// echo "main-REMOTE_ADDR-$REMOTE_ADDR
";
// echo "
main_before_inc_connect_db > ".$SESS_PER_ID."/".$SESS_FIRSTNAME."<".$USER_ID.">".$SESS_USERID." (( $username && $password ))";
include("../php_scripts/connect_database.php");
// echo "
main_after_inc_connect_db > ".$SESS_PER_ID."/".$SESS_FIRSTNAME."<".$USER_ID.">".$SESS_USERID." (( $username && $password ))";
// Get Right Value from connect_database.php
$SESS_USERGROUP_CONDB=trim($SESS_USERGROUP);
$SESS_PER_ID_CONDB=trim($SESS_PER_ID);
$SESS_FIRSTNAME_CONDB=trim($SESS_FIRSTNAME);
$SESS_USERID_CONDB=trim($SESS_USERID);
$cmd = " select code, name_th, group_level, pv_code, org_id from user_group where id=$SESS_USERGROUP_CONDB ";
$db->send_cmd($cmd);
// $db->show_error();
$data = $db->get_array();
$data = array_change_key_case($data, CASE_LOWER);
$SESS_GROUPCODE = $data[code];
$SESS_GROUPCODE_MAIN=$SESS_GROUPCODE;
function manage_login($upd) {
global $db, $db_type, $session_id, $SESS_USERID, $SESS_USERNAME, $SESS_FIRSTNAME, $REMOTE_ADDR;
if($db_type=="mysql") $log_date = "NOW()";
elseif($db_type=="mssql") $log_date = "GETDATE()";
elseif($db_type=="oci8" || $db_type=="odbc") { $log_date = date("Y-m-d H:i:s"); $log_date = "'$log_date'"; }
if ($upd != "1") {
// หา log_id ใหม่
$cmd = " select max(log_id) as max_id from user_last_access ";
$db->send_cmd($cmd);
$data = $db->get_array();
$data = array_change_key_case($data, CASE_LOWER);
$log_id = $data[max_id] + 1;
// สร้าง login record ใหม่
$cmd = " insert into user_last_access (log_id, user_id, username, fullname, last_login, from_ip, session_id) values ($log_id, $SESS_USERID, '$SESS_USERNAME', '$SESS_FIRSTNAME', $log_date, '$REMOTE_ADDR', '$session_id') ";
$db->send_cmd($cmd);
// $db->show_error();
// echo "create new $cmd
";
} else {
// เมื่อมีการ logout
$cmd = " update user_last_access set last_logout=$log_date, f_logout='1' where session_id='$session_id' ";
$db->send_cmd($cmd);
// $db->show_error();
}
}
// echo "main--1
";
include("php_scripts/session_start.php"); //redirect page
// echo "main--2
";
include("../php_scripts/calendar_data.php");
// echo "main--3
";
include("php_scripts/function_share.php");
// echo "main--4
";
include("php_scripts/load_per_control.php");
// New Set to Right Value from connect_database.php
if($SESS_USERGROUP_CONDB) $SESS_USERGROUP = trim($SESS_USERGROUP_CONDB);
if($SESS_PER_ID_CONDB) $SESS_PER_ID=trim($SESS_PER_ID_CONDB);
if($SESS_FIRSTNAME_CONDB) $SESS_FIRSTNAME=trim($SESS_FIRSTNAME_CONDB);
if($SESS_USERID_CONDB) $SESS_USERID=trim($SESS_USERID_CONDB);
if($SESS_GROUPCODE_MAIN) $SESS_GROUPCODE=trim($SESS_GROUPCODE_MAIN);
/*echo $PAGE_AUTH["add"]."+".$PAGE_AUTH["edit"];
print_r($PAGE_AUTH);
>> สำหรับเมนูหลักหน้าแรกมันไม่มีตัว AUTH ไม่สามารถกำหนดสิทธิ์ได้
>> group1 --> MENU_ID_LV0=0&MENU_ID_LV1=0&MENU_ID_LV2=0&MENU_ID_LV3=0
if($db_type=="mysql"){
}else if(db_type=="oci8"){
} */
// echo "test--".$SESS_MINISTRY_ID."=".md5("PKG1".$SESS_MINISTRY_ID)." [ $SPKG1 ] ~ ".$SESS_DEPARTMENT_ID."+".$SESS_USERGROUP."($SESS_GROUPCODE) == $LOGON_GROUP - $CTRL_TYPE - $SESS_USERGROUP_LEVEL ";
// echo " [ $SESS_USERGROUP_LEVEL] $BKK_FLAG // $SESS_PER_ID | $SESS_USERID :: $SESS_MINISTRY_NAME :: $SESS_DEPARTMENT_NAME :: $SESS_ORG_NAME :: $SESS_ORG_NAME_1 :: $SESS_PROVINCE_NAME :: $SESS_ORG_SETLEVEL :: $SESS_COMPETENCY_METHOD :: $SESS_PER_TYPE :: $SESS_ORG_SETLEVEL
";
if (!$filter_1) $filter_1 = "current";
if (!$filter_2) $filter_2 = "current";
if (!$filter_3) $filter_3 = "current";
//echo "
main ----------- Group_CODE : ".$SESS_GROUPCODE."//User_Group : ".$SESS_USERGROUP;
?>