"; // 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; ?> <?=$webpage_title?>
send_cmd($cmd); $data = $db_dpis->get_array(); if($SESS_USERID != '1' && $SESS_USERID != $data[USER_ID]) { ?>
  ® Welcome ....     send_cmd($cmd); echo "$cnt  online"; // echo "$cnt  online"; ?>   
= '".$today."'"; } elseif($filter_1 == 'new') { $filter_1_str = "SUBSTR(trim(MSG_START_DATE),1,10) >= '".$today."'"; } if($DPISDB=="odbc"){ $filter_1_str = str_replace("SUBSTR", "MID", $filter_1_str); $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M left join PER_MESSAGE_USER U on (M.MSG_ID = U.MSG_ID) where $filter_1_str AND MSG_TYPE=0 and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; }elseif($DPISDB=="oci8"){ $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M ,PER_MESSAGE_USER U where $filter_1_str AND MSG_TYPE=0 and M.MSG_ID = U.MSG_ID(+) and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; }elseif($DPISDB=="mysql"){ $filter_1_str = str_replace("SUBSTR", "MID", $filter_1_str); $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M left join PER_MESSAGE_USER U on (M.MSG_ID = U.MSG_ID) where $filter_1_str AND MSG_TYPE=0 and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; } $countdata = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); //echo "$cmd
"; if($countdata){ while($data = $db_dpis->get_array()){ $temp_MSG_ID = trim($data[MSG_ID]); if(in_array($temp_MSG_ID,$EXIST_MSG_ID)==false){ //ไม่แสดง MSG_ID ซ้ำกันหลายแถว $EXIST_MSG_ID[] = $temp_MSG_ID; $POSTUSRNAME=""; $MSG_POST_DATE=""; $MSG_POST_DATE = show_date_format($data[MSG_POST_DATE], 1); //ดึงชื่อผู้โพสต์จาก ตาราง user_detail ของ mysql $cmd1 ="select fullname from user_detail where id=$data[POST_USER_ID]"; $db->send_cmd($cmd1); $datausr = $db->get_array(); $datausr = array_change_key_case($datausr, CASE_LOWER); $POSTUSRNAME = $datausr[fullname]; //$SESS_USERID; $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($MSG_ID==$temp_MSG_ID ){ $class = "table_body_over"; $onmouse_event = ""; } // end if $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); ?> >".$SESS_USERID."--".$cmdshow; $db_dpis->send_cmd($cmdshow); //$db_dpis->show_error(); while($data = $db_dpis->get_array()){ $temp_MSG_ID = trim($data[MSG_ID]); $POSTUSRNAME=""; $MSG_POST_DATE=""; $MSG_POST_DATE = show_date_format($data[MSG_POST_DATE], 1); //ดึงชื่อผู้โพสต์จาก ตาราง user_detail ของ mysql $cmd1 ="select fullname from user_detail where id=$data[POST_USER_ID]"; $db->send_cmd($cmd1); $datausr = $db->get_array(); $datausr = array_change_key_case($datausr, CASE_LOWER); $POSTUSRNAME = $datausr[fullname]; //$SESS_USERID; $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($MSG_ID==$temp_MSG_ID ){ $class = "table_body_over"; $onmouse_event = ""; } // end if $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); include("main_msg.html"); } //end while } //end in_array } //end is_array } //end if($SESS_USERID != '1') ***************************************/ }else{ //end countdata ?>
  " class="table_head">วิธีการใช้งานระบบ (คลิกเพื่อเพิ่มข้อมูล) checked> รอการแสดงผล checked> ปัจจุบัน checked> เก่า
       0){ ?> ดูไฟล์เอกสาร
ยังไม่มีข้อมูล  
1) : ?>
 
= '".$today."'"; } elseif($filter_2 == 'new') { $filter_2_str = "SUBSTR(trim(MSG_START_DATE),1,10) >= '".$today."'"; } if($DPISDB=="odbc"){ $filter_2_str = str_replace("SUBSTR", "MID", $filter_2_str); $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M left join PER_MESSAGE_USER U on (M.MSG_ID = U.MSG_ID) where $filter_2_str AND MSG_TYPE=1 and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; }elseif($DPISDB=="oci8"){ $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M ,PER_MESSAGE_USER U where $filter_2_str AND MSG_TYPE=1 and M.MSG_ID = U.MSG_ID(+) and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; }elseif($DPISDB=="mysql"){ $filter_2_str = str_replace("SUBSTR", "MID", $filter_2_str); $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M left join PER_MESSAGE_USER U on (M.MSG_ID = U.MSG_ID) where $filter_2_str AND MSG_TYPE=1 and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; } $countdata = $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); // echo "$countdata :: $cmd
"; if($countdata > 0){ while($data = $db_dpis->get_array()){ $temp_MSG_ID = trim($data[MSG_ID]); if(in_array($temp_MSG_ID,$EXIST_MSG_ID)==false){ //ไม่แสดง MSG_ID ซ้ำกันหลายแถว $EXIST_MSG_ID[] = $temp_MSG_ID; $POSTUSRNAME=""; $MSG_POST_DATE=""; $MSG_POST_DATE = show_date_format($data[MSG_POST_DATE], 1); //ดึงชื่อผู้โพสต์จาก ตาราง user_detail ของ mysql $cmd1 ="select fullname from user_detail where id=$data[POST_USER_ID]"; $db->send_cmd($cmd1); // $db->show_error(); $datausr = $db->get_array(); $datausr = array_change_key_case($datausr, CASE_LOWER); $POSTUSRNAME = $datausr[fullname]; //$SESS_USERID ?>
  ข่าวสารและประชาสัมพันธ์ (คลิกเพื่อเพิ่มข้อมูล) checked> รอการแสดงผล checked> ปัจจุบัน checked> เก่า
       0){ ?> ดูไฟล์เอกสาร
ยังไม่มีข้อมูล  

= '".$today."'"; } elseif($filter_3 == 'new') { $filter_3_str = "SUBSTR(trim(MSG_START_DATE),1,10) >= '".$today."'"; } if($DPISDB=="odbc"){ $filter_3_str = str_replace("SUBSTR", "MID", $filter_3_str); $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M left join PER_MESSAGE_USER U on (M.MSG_ID = U.MSG_ID) where $filter_3_str AND MSG_TYPE=2 and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; }elseif($DPISDB=="oci8"){ $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M ,PER_MESSAGE_USER U where $filter_3_str AND MSG_TYPE=2 and M.MSG_ID = U.MSG_ID(+) and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; }elseif($DPISDB=="mysql"){ $filter_3_str = str_replace("SUBSTR", "MID", $filter_3_str); $cmd = "select M.MSG_ID,MSG_POST_DATE,M.USER_ID as POST_USER_ID,U.USER_ID as USER_ID,M.MSG_SHOW,U.MSG_STATUS,MSG_HEADER,MSG_SOURCE,MSG_DOCUMENT from PER_MESSAGE M left join PER_MESSAGE_USER U on (M.MSG_ID = U.MSG_ID) where $filter_3_str AND MSG_TYPE=2 and U.USER_ID=$SESS_USERID order by MSG_POST_DATE desc"; } $countdata = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); //echo "$cmd
"; if($countdata > 0){ while($data = $db_dpis->get_array()){ $temp_MSG_ID = trim($data[MSG_ID]); if(in_array($temp_MSG_ID,$EXIST_MSG_ID)==false){ //ไม่แสดง MSG_ID ซ้ำกันหลายแถว $EXIST_MSG_ID[] = $temp_MSG_ID; $POSTUSRNAME=""; $MSG_POST_DATE=""; $MSG_POST_DATE = show_date_format($data[MSG_POST_DATE], 1); //ดึงชื่อผู้โพสต์จาก ตาราง user_detail ของ mysql $cmd1 ="select fullname from user_detail where id=$data[POST_USER_ID]"; $db->send_cmd($cmd1); // $db->show_error(); $datausr = $db->get_array(); $datausr = array_change_key_case($datausr, CASE_LOWER); $POSTUSRNAME = $datausr[fullname]; //$SESS_USERID; ?>
  หนังสือเวียนอิเล็กทรอนิกส์-หนังสือคำสั่งอิเล็กทรอนิกส์ (คลิกเพื่อเพิ่มข้อมูล) checked> รอการแสดงผล checked> ปัจจุบัน checked> เก่า
       0){ ?> ดูไฟล์เอกสาร
ยังไม่มีข้อมูล  
 
 
 
 
send_cmd($cmd); // $db_dpis->show_error(); //echo " - - ".$count.":".$cmd."
"; if($count>0){ $UPDATE_DATE = date("Y-m-d H:i:s"); while($data = $db_dpis->get_array()){ //echo "
".$data[MSG_ID]."--".$data[USER_ID]; //---Insert $cmd1 = " insert into PER_MESSAGE_USER(MSG_ID,USER_ID,MSG_STATUS,UPDATE_USER,UPDATE_DATE) VALUES ($data[MSG_ID],$data[USER_ID],0,$data[UPDATE_USER],'$UPDATE_DATE') "; //$count1 = $db_dpis->send_cmd($cmd1); //$db_dpis->show_error(); //echo "
--> ".$cmd1."
"; $count1++; } //echo " - - ".$count1."
"; } //-------------- ############################## ?>