|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/eoffice/config/ |
Upload File : |
<?
$host = "localhost" ;
$username = "sapphire" ;
$password = "sprd!@#$%" ;
$db_mainobec = "obec";
$connect_status = "On line" ;
$mainwebsite = "";
$admin_email = " vcsystem@sapphire ";
$servergraph = "202.69.143.77";
$show_title = "ระบบทะเบียนหนนังสือ รับ-ส่ง";
$dbname ="eoffice_lampang"; # ฐานข้อมูลที่ใช้งาน
$db_epm="epm"; # ฐานข้อมูลที่เชื่อมกับ epm
$perpage="30"; # Dart ต่อ หน้า
$db_mode="self"; //epm //self โหมดรายการ staff
$logon_mode="self"; //epm //self โหมดเรียก logon
$provincename="ลำปาง";
// $arr_gidstaff[68]="1"; # ระบุกลุ่ม สารบัญ
if($db_mode=="self"){
$table_staff=$dbname.".epm_staff";
}
if($db_mode=="epm"){
$table_staff=$db_epm.".epm_staff";
}
$table_mainmenu = $dbname.".main_menu";
$table_staffgroup = $dbname.".epm_staffgroup";
$table_groupmember = $dbname.".epm_groupmember";
$profile_staffgroup = $dbname.".profile_staffgroup";
$profile_groupmember = $dbname.".profile_groupmember";
$myconnect = mysql_connect($host, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db($dbname) or die("cannot select database $dbname");
$iresult = mysql_query("SET character_set_results=tis-620");
$iresult = mysql_query("SET NAMES TIS620");
if ($_SESSION[session_depusername] == "infoadmin") $isAdmin = true; else $isAdmin = false;
if ($_SESSION[session_depusername] == "infoadmin") $isFinance = true; else $isFinance = false;
function addlog($action){
global $session_staffid;
$ip= getenv(REMOTE_ADDR);
$sql_log="INSERT INTO `doc_log` (`logtime`,`staffid`,`action`,`ip`) VALUES (NOW() ,'$session_staffid' , '$action','$ip')";
$result_log = mysql_query($sql_log)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
}
$result_time=mysql_query("select now( ) as sql_time")or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$rs_t = mysql_fetch_assoc($result_time);
$sql_time=$rs_t[sql_time];
$wordingset = array("0"=>"ผู้ว่าราชการจังหวัด$provincename","1"=>array("รักษาราชการแทน","รักษาการแทน "));
$wordingposition="show";
function doclog($docid,$doc_reciveid,$staffid,$staff_label,$doc_owner,$owner_label,$doc_status,$doc_history ,$action ){
global $sql_time,$session_staffid , $session_fullname ,$session_fullname_title ;
$ip= getenv(REMOTE_ADDR);
switch ($action) {
####################### case "del" : $action_id_number = 10 ; break;
case "activity" :
$action_id_number = 500 ;
break;
case "add" :
$action_id_number = 100 ;
break;
case "edit":
$action_id_number = 150 ;
break;
case "view":
$action_id_number = 400 ;
break;
} ####### END switch ($action_id) {
#10 ลบ
#100 หนังสือเข้า
#500 หนังสือถูกส่งต่อไปยัง
#200 หนังสือออก
#300 หนังสือเวียน
#900 ลงทะเบียนรับหนังสือไปแล้ว
$staff_label = str_replace("()" ,"",$staff_label);
$owner_label = str_replace("()" ,"",$owner_label);
$sql_log="
INSERT INTO `doc_history`
( docid , doc_reciveid , staffid , doc_owner , doc_status , timerec , doc_history , staff_label , owner_label , doc_action , action_id )
VALUES
( '$docid', '$doc_reciveid', '$staffid', '$doc_owner', '$doc_status', '$sql_time', '$doc_history', '$staff_label', '$owner_label', '$action' , '$action_id_number' )
";
#echo " <hr> $sql_log <hr> ";
$result_log = mysql_query($sql_log)or die("Query line " . __LINE__ . " error<hr>". mysql_error());
// echo $sql_log ;
} ######## END function doclog($docid,
?>