function activity_log($module_id,$page_id,$page_name,$tr_from,$tr_no,$tr_id,$tr_type,$execution_time) { $ipaddress = get_client_ip(); $link = explode('/',$_SERVER['REQUEST_URI']); $c = count($link); $page_link = $link[$c-4].'/'.$link[$c-3].'/'.$link[$c-2].'/'.$link[$c-1]; $sql = "INSERT INTO `user_action_log` ( `access_id`,`user_id`,`user_fname`, `user_level`, `mod_id`, `page_id`, `page_name`, `page_link`, `session_id`, `ip_address`, `tr_from`, `tr_no`, `tr_id`, `tr_type`,`execution_time`) VALUES ('".$_SESSION['user']['access_id']."','".$_SESSION['user']['id']."', '".$_SESSION['user']['fname']."','".$_SESSION['user']['level']."', '".(int)$module_id."', '".(int)$page_id."', '".$page_name."', '".$page_link."', '".session_id()."', '".$ipaddress."', '".$tr_from."' , '".(int)$tr_no."' ,'".(int)$tr_id."' ,'".$tr_type."', '".$execution_time."')"; db_query($sql); return db_insert_id(); } function get_client_ip() { $ipaddress = ''; if (getenv('HTTP_CLIENT_IP')) {$ipaddress = getenv('HTTP_CLIENT_IP');} else if(getenv('HTTP_X_FORWARDED_FOR')) {$ipaddress = getenv('HTTP_X_FORWARDED_FOR');} else if(getenv('HTTP_X_FORWARDED')) {$ipaddress = getenv('HTTP_X_FORWARDED');} else if(getenv('HTTP_FORWARDED_FOR')) {$ipaddress = getenv('HTTP_FORWARDED_FOR');} else if(getenv('HTTP_FORWARDED')) {$ipaddress = getenv('HTTP_FORWARDED');} else if(getenv('REMOTE_ADDR')) {$ipaddress = getenv('REMOTE_ADDR');} else{ $ipaddress = 'UNKNOWN';} return $ipaddress; } function insert_invalid_access_record($company_id,$username,$password,$mod_id) { $c_name = "ERPCOMBD"; $access_date = date('Y-m-d'); $session_id = session_id(); $ip_address = $_SERVER['REMOTE_ADDR']; $cookie_log = $_COOKIE[$c_name]; $sql = "INSERT INTO `user_access_login_fail` (`username`, `password`, `company_id`, `session_id`, `ip_address`, `mod_id`, `access_date`,`cookie_log`) VALUES ( '".$username."', '".$password."', '".$company_id."', '".$session_id."', '".$ip_address."', '".$mod_id."', '".$access_date."', '".$cookie_log."')"; db_query($sql); if (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on') { $c_value = "Fail Log at:".time()." CI:".$company_id." UN:".$username." SI:".session_id(); setcookie($c_name, $c_value, time() + (86400 * 1000), "/", "", true,true); } } function insert_valid_access_record($company_id,$username,$mod_id) { $c_name = $company_id; $access_date = date('Y-m-d'); $session_id = session_id(); $ip_address = $_SERVER['REMOTE_ADDR']; $_SESSION['access']['ip'] = $ip_address; $_SESSION['access']['mod'] = $mod_id; $_SESSION['access']['si'] = $session_id; $cookie_log = $_COOKIE[$c_name]; $sql = "INSERT INTO `user_access_login_success` (`username`, `company_id`, `session_id`, `ip_address`, `mod_id`, `access_date`,`cookie_log`) VALUES ( '".$username."', '".$company_id."', '".$session_id."', '".$ip_address."', '".$mod_id."', '".$access_date."', '".$cookie_log."')"; db_query($sql); $_SESSION['mhafuz'] = 'Active'; $depot = find_all_field('warehouse','','warehouse_id='.$_SESSION['user']['depot']); $proj_sql="select * from project_info limit 1"; $proj=@mysqli_fetch_object(db_query($proj_sql)); $_SESSION['user']['acc_depot'] = $depot->acc_code; $_SESSION['user']['group_name'] = $depot->warehouse_name; $_SESSION['company_name']=$_SESSION['proj_name']=$proj->proj_name; $_SESSION['company_address']=$proj->proj_address; $_SESSION['company_logo']='../images/'.$_SESSION['proj_id'].'.jpg'; if (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on') { $c_value = "Success Log at:".time()." CI:".$company_id." UN:".$username." SI:".session_id(); setcookie($c_name, $c_value, time() + (86400 * 1000), "/", "", true,true); } } function load_menu($mod_id,$mod_name,$user_id){ ?>
} ?>