|
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/pathumthani_eoffice/application/bin/document_failed/ |
Upload File : |
<?
//include("chk_permission.php");
session_start();
include("../../config/config.inc.php");
include("../../common/function.php");
include("../../common/eoffice.inc.php");
include("../../common/common_system.inc.php");
$time_start_main = getmicrotime();
if($debug_session=="on"){echo "<pre>"; print_r($_SESSION); echo"<pre>";}
# HARD FIX
$user=$_SESSION[session_staffid];
$type=$_GET[type];
if($type){$_SESSION[tab]=$type;}
if(!$type){$type=$_SESSION[type];}
// if($action){include "docreg_action.php"; }
?>
<html>
<head><title>ระบบทะเบียนหนังสือ</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="../../common/style.css" rel="stylesheet" type="text/css">
<link href="../../common/tab_style.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="../../common/popcalendar.js"></script>
<script language="javascript" src="../../common/xmlhttp.js"></script>
</head>
<body topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="350" align="left"><img src="../control/head/samutsakhon/h-header.jpg" width="394" height="79"></td>
<td align="right" background="../../images/header/h-rayong_02.jpg"> </td>
<td width="359" align="right" valign="bottom"><img src="../../images/h-lampang/h-lampang_03.jpg" width="387" height="79"></td>
</tr>
</table>
<span id="menubar">
<? include "menubar.php"; ?>
</span>
<? if($_SESSION[session_username]=="root"){ exit; }?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left">
<?
if(($session_permit[100]) || ($session_permit[200]) || ($session_permit[300])){
### อ่านจากทั้งหมด
# นับ docid ที่ไม่ว่าง
$sql_ac=" SELECT Count(document.id) as num FROM document WHERE document.docid is not null ";
$time_start = getmicrotime();
$result_ac = mysql_query($sql_ac)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
writetime2db($time_start, getmicrotime() ,' นับ docid ทั้งหมด สำหรับสารบรรณ ');
$rs_ac = mysql_fetch_assoc($result_ac);
# นับ docid ตามประเภท จากทั้งหมด
$sql_res="
SELECT
document.type,
Count(document.id) as num
FROM
document
WHERE
document.docid is not null
GROUP by document.type
";
$time_start = getmicrotime();
$result_res = mysql_query($sql_res)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($rs_res = mysql_fetch_assoc($result_res)){
$doc_num[$rs_res[type]]=$rs_res[num];
}
writetime2db($time_start, getmicrotime() ,' นับ docid ตามประเภท จากทั้งหมด สำหรับสารบรรณ ');
$sql_allread="
SELECT COUNT(doc_history.doc_action) as ALLNUMREAD
FROM document Inner Join doc_history ON document.id = doc_history.docid
WHERE doc_history.doc_action = 'view' AND doc_history.doc_owner = '$session_staffid'
GROUP by doc_history.doc_owner
";
// $result_allread = mysql_query($sql_allread)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
// $rs_allread = mysql_fetch_assoc($result_allread);
}
if( ($session_username!="root") && ((!$session_permit[100]) && (!$session_permit[200]) ) ){
if($_SESSION[session_staffid]){
$sql_group=" SELECT org_groupmember.gid FROM org_groupmember WHERE org_groupmember.staffid = '$session_staffid' ";
$code_gid="";
$time_start = getmicrotime();
$result_gid_list=mysql_query($sql_group);
if(@mysql_num_rows($result_gid_list)>0){$i=0;
while($rs_gid=mysql_fetch_assoc($result_gid_list)){
if($i>0){ $code_gid.="or"; }else{$code_gid=" WHERE ";} $i++;
$code_gid.=" org_groupmember.gid like '".$rs_gid[gid]."' ";
}
writetime2db($time_start, getmicrotime() ,' หา GROUP MEMBER ของ user ');
$sql_group_mem=" SELECT org_groupmember.staffid FROM org_groupmember $code_gid ";
$code_gid="";
$result_gid_list2=mysql_query($sql_group_mem);
$i=0;
}
if($result_gid_list2){
while($rs_gid=mysql_fetch_assoc($result_gid_list2)){
if($i>0){ $code_gid.="or"; }else{ $code_gid=" "; } $i++;
$code_gid.=" (doc_receive.staff_id = '".$rs_gid[staffid]."' )or(doc_receive.owner = '".$rs_gid[staffid]."' ) ";
}
}
if($i>0){ $code_gid.="or doc_receive.staff_id = '".$session_staffid."' "; }else{ $code_gid.="doc_receive.staff_id = '".$session_staffid."' "; }
if($session_org){$code_gid.=" or(doc_receive.group_id = '".$session_org."') "; };
$sql_member_owner=" select doc_receive.docid from doc_receive where $code_gid group by doc_receive.docid ";
$code_mem="";$i=0;
$time_start = getmicrotime();
$result_mem_list2=mysql_query($sql_member_owner);
if($result_mem_list2){
while($rs_mem=mysql_fetch_assoc($result_mem_list2)){
if($i>0){ $code_mem.="or"; }else{ $code_mem=" OR "; } $i++;
$tag_d.="$rs_mem[docid],";
}
$code_mem="or document.id in (".$tag_d."0)";
}
writetime2db($time_start, getmicrotime() ,' หาเอกสารของตัวเอง ');
}
if($i>0){ $code_mem.=" "; }
$where_code.="and ( (document.owner = '$session_staffid') ) $code_mem";
$sql_all="
SELECT
document.type,count(*) as num
FROM
document
WHERE
document.type LIKE '%%'
$paidcheck
$year_select_code
$where_code
GROUP by document.type
";
$time_start = getmicrotime();
$result=mysql_query($sql_all);
while($rs_all=mysql_fetch_assoc($result)){ $doc_num[$rs_all[type]]=$rs_all[num]; }
$rs_num=$doc_num[get]+$doc_num[send]+$doc_num[circular];
writetime2db($time_start, getmicrotime() ,' จำนวนเอกสารแต่ละประเภท ');
$sql_read="
SELECT
Count(doc_receive.id) as num
FROM
doc_receive
WHERE
doc_receive.`status` = '0' AND
doc_receive.staff_id = '$session_staffid'
GROUP by doc_receive.id
";
$time_start = getmicrotime();
$result_read = mysql_query($sql_read)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$rs_read = mysql_fetch_assoc($result_read);
writetime2db($time_start, getmicrotime() ,' จำนวนเอกสารแต่ละประเภท ');
}
if($type != "personal"){ // ปิดการแสดงผลในกรณีเลือกข้อมูลส่วนบุคคล
if(($session_username!="root") && ((!$session_permit[100]) && (!$session_permit[200]) && (!$session_permit[300])) ){
echo "จำนวนหนังสือทั้งหมด ".array_sum($doc_num)." ฉบับ";
//echo "จำนวนหนังสือทั้งหมด ".$rs_num." ฉบับ";
//if($rs_read[num]) { echo "ยังไม่ได้อ่าน ".$rs_read[num]." ฉบับ";}
}else{
echo "หนังสือในระบบ ".array_sum($doc_num)." ฉบับ";
}
// echo "หนังสือในระบบ ".$rs_ac[num]." ฉบับ";
// if($rs_allread[ALLNUMREAD]) { echo "ยังไม่ได้อ่าน".." ฉบับ"; }
if($doc_num[get]||$doc_num[send]||$doc_num[circular]){ echo"["; }
if($doc_num[get]){ echo "รับ :$doc_num[get] "; }
if($doc_num[send]){ echo "ส่ง : $doc_num[send] "; }
if($doc_num[circular]){ echo "เวียน : $doc_num[circular] "; }
if($doc_num[command]){ echo "คำสั่ง : $doc_num[command] "; }
if($doc_num[secret]){ echo "ลับ : $doc_num[secret] "; }
if($doc_num[get]||$doc_num[send]||$doc_num[circular]){ echo"]"; }
} ?>
</td>
<td align="right" valign="top">
<? if($session_apppermit[1][10]=="on" || $session_apppermit[16][10]=="on"){ ?>
<A href="docreg_autonumber.php?type=system&action=autonumber" target="mainFrame">
<IMG src="../../images/icon_blacklist_list.gif" width="16" height="16" border="0"></A>
<A href="../manage_application/privilage.php?app_id=<?=($session_apppermit[1][10])?'1':'16';?>" target="_blank">
<IMG src="../../images/icon_user.gif" border="0"> </A>
<? } ?>
<a href="user_properties.php" target="mainFrame" >ผู้ใช้ระบบ :
<?
if($_SESSION[session_title]){echo "(".$_SESSION[session_title].")";}
echo $_SESSION[session_fullname];
if($session_permit[300]){echo "<img src='../../images/users_into.jpg' border=0>";}
?>
</a> </td>
</tr>
</table>
<iframe id="fdownload" name="fdownload" width="10" height="10" scrolling="no" frameborder="0"></iframe>
</body>
</html>
<? $time_end_main = getmicrotime(); writetime2db($time_start_main,$time_end_main,'เมนูบาร์ '); ?>
<? if($debug_session=="on"){echo "<pre>"; print_r($_SESSION);}?>