|
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_bk v 1test/ |
Upload File : |
<?
###################################################################
## E-OFFICE : DASHBOARD of E-Document
###################################################################
## Version : 200905??.001 (Created/Modified; Date.RunNumber)
## Created Date : 2009-03-?? hh:mm
## Created By : Mr.PUDIS PROMSRI (PAAK)
## E-mail : pudis@sapphire.co.th
## Tel. : 086-1860538
## Company : Sappire Research and Development Co.,Ltd. (C)All Right Reserved
###################################################################
## Version : 20090725.002
## Modified Detail:ปรับปรุง DASHฺBOARD ใหม่
## Modified Date : 2009-07-04 10:00
## Modified By : Mr.PUDIS PROMSRI (PAAK)
##
###################################################################
//include("chk_permission.php");
$owner_show="off"; // พี่อิม ลำปาง ได้ REQUEST ให้เอาส่วนนี้ออก
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();
$time_start_dashboard=getmicrotime();
# HARD FIX
$user=$_SESSION[session_staffid];
$type=$_GET[type];
if($type){$_SESSION[tab]=$type;}
if(!$type){$type=$_SESSION[type];}
//echo "<pre>";print_r($_SESSION);
?>
<style type="text/css">
<!--
body {
margin-: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<form action="" method="post" enctype="multipart/form-data" name="post" id="post">
<span id="loading"></span>
<link href="../../common/style.css" rel="stylesheet" type="text/css" />
<?
if($debug_session=="on"){echo "<pre>"; print_r($_SESSION);}
$_SESSION[session_type]=$_GET[type];
if(!$type){$type=$_SESSION[session_type];}
if(!$type){$type="all";}
if(!$_SESSION[session_permit][100]&&!$_SESSION[session_permit][200]){$mode="private";}
?>
<script language="javascript">
function showEle(divname){
if(document.getElementById(divname).style.display == 'none'){
document.getElementById(divname).style.display = 'block';
} else {
document.getElementById(divname).style.display = 'none';
}
}
</script>
<?
### สร้าง SESSION SEARCH และเริ่มต้น การแสดง KEYWORD ESARCH
if($search){
$type=($type_doc)?$type_doc:$type;
## ถ้ามี METHOD POST ให้ บันทึก session keyword
if (($_SERVER[REQUEST_METHOD] == "POST")){
$page="1";
$_SESSION[session_keyword]=$keyword;
$_SESSION[session_topic]=$topic;
$_SESSION[session_type_doc]=$type_doc;
if((!$pdate_a)&&($pdate_b)){$pdate_a=$pdate_b;}
if((!$pdate_b)&&($pdate_a)){$pdate_b=$pdate_a;}
$_SESSION[session_pdate_a]=$pdate_a;
$_SESSION[session_pdate_b]=$pdate_b;
if((!$rdate_a)&&($rdate_b)){$rdate_a=$rdate_b;}
if((!$rdate_b)&&($rdate_a)){$rdate_b=$rdate_a;}
$_SESSION[session_rdate_a]=$rdate_a;
$_SESSION[session_rdate_b]=$rdate_b;
if((!$sdate_a)&&($sdate_b)){$sdate_a=$sdate_b;}
if((!$sdate_b)&&($sdate_a)){$sdate_b=$sdate_a;}
$_SESSION[session_sdate_a]=$sdate_a;
$_SESSION[session_sdate_b]=$sdate_b;
if((!$kdate_a)&&($kdate_b)){$kdate_a=$kdate_b;}
if((!$kdate_b)&&($kdate_a)){$kdate_b=$kdate_a;}
$_SESSION[session_kdate_a]=$kdate_a;
$_SESSION[session_kdate_b]=$kdate_b;
if((!$tdate_a)&&($tdate_b)){$tdate_a=$tdate_b;}
if((!$tdate_b)&&($tdate_a)){$tdate_b=$tdate_a;}
$_SESSION[session_tdate_a]=$tdate_a;
$_SESSION[session_tdate_b]=$tdate_b;
$_SESSION[session_staff_search]=$staff_search;
$_SESSION[session_group_search]=$group_search;
}else{
//ถ้าไม้่ใช่ให้ หาอ่าน keyword จาก session mี่เคยเก็บไว้
// $page="1";
$keyword=$_SESSION[session_keyword];
$topic=$_SESSION[session_topic];
$type_doc = $_SESSION[session_type_doc];
$pdate_a=$_SESSION[session_pdate_a];
$pdate_b=$_SESSION[session_pdate_b];
if((!$pdate_a)&&($pdate_b)){$pdate_b=$session_pdate_a;}
if((!$pdate_b)&&($pdate_a)){$pdate_a=$session_pdate_b;}
$rdate_a=$_SESSION[session_rdate_a];
$rdate_a=$_SESSION[session_rdate_b];
if(!$rdate_a){$rdate_b=$session_rdate_a;}
if(!$rdate_b){$rdate_a=$session_rdate_b;}
$sdate_a=$_SESSION[session_sdate_a];
$sdate_b=$_SESSION[session_sdate_b];
if(!$sdate_a){$sdate_b=$session_sdate_a;}
if(!$sdate_b){$sdate_a=$session_sdate_b;}
$kdate_a=$_SESSION[session_kdate_a];
$kdate_b=$_SESSION[session_kdate_b];
if(!$kdate_a){$kdate_b=$session_kdate_a;}
if(!$kdate_b){$kdate_a=$session_kdate_b;}
$tdate_a=$_SESSION[session_tdate_a];
$tdate_b=$_SESSION[session_tdate_b];
if(!$tdate_a){$tdate_b=$session_tdate_a;}
if(!$tdate_b){$tdate_a=$session_tdate_b;}
$staff_search=$_SESSION[session_staff_search];
$group_search=$_SESSION[session_group_search];
}
}
if ($search){
?>
<table width="96%" border="1" align="center" cellpadding="0" cellspacing="0" class="login_fill3" style="border:1px">
<tr>
<td align="">
<? // print_r($POST);?>
<b>ผลการค้นหา : </b><br>
<table width="100%">
<? if((trim($session_keyword)) || (trim($session_topic)) ) {
if($session_topic=="title"){$topic_name="ชื่อเรื่อง";}
if($session_topic=="docid"){$topic_name="เลขทะเบียนลง";}
if($session_topic=="refid"){$topic_name="ลงวันที่";}
if($session_topic=="sending"){$topic_name="จาก";}
if($session_topic=="getting"){$topic_name="ถึง";}
if($session_topic=="comment"){$topic_name="หมายเหตุ";}
if($session_type_doc == "get"){ $type_doc_name = "หนังสือรับ";}
if($session_type_doc == "sent"){ $type_doc_name = "หนังสือส่ง";}
if($session_type_doc == "circular"){ $type_doc_name = "หนังสือเวียน";}
if($session_type_doc == "command"){ $type_doc_name = "หนังสือคำสั่ง";}
?>
<tr>
<td colspan="2" align=""><? if(trim($session_keyword)) { echo "$session_keyword"; } ?></td>
</tr>
<tr>
<td colspan="2" align="">
<? if(trim($session_topic)) { echo "<strong>ในหมวด:</strong> $topic_name"; }
if(trim($session_type_doc)){ echo "<strong>ประเภทเอกสาร:</strong> $type_doc_name"; }
?>
</td>
</tr>
<?
}
if((trim($session_pdate_a)) || (trim($session_pdate_b)) ) {
?>
<tr>
<td width="10%" align="">ลงวันที</td>
<td width="90%" align="">
<?
if(trim($session_pdate_a)){ echo "$session_pdate_a"; }
if(trim($session_pdate_b)){echo "ถึง $session_pdate_b "; }
?>
</td>
</tr>
<? }
if((trim($session_rdate_a)) || (trim($session_rdate_b)) ) {
?>
<tr>
<td align="">วันบันทึก</td>
<td align=""><?
if(trim($session_rdate_a)){ echo "$session_rdate_a"; }
if(trim($session_rdate_b)){ echo "ถึง $session_rdate_b"; }?>
</td>
</tr>
<? }
if((trim($session_sdate_a)) || (trim($session_sdate_b)) ) {
?>
<tr>
<td align="">วันส่งต่อเอกสาร</td>
<td align="">
<?
if(trim($session_sdate_a)){ echo "$session_sdate_a"; }
if(trim($session_sdate_b)){ echo "ถึง $session_sdate_b"; }?>
</td>
</tr>
<? } ?>
<? if((trim($session_kdate_a)) || (trim($session_kdate_b)) ) {
?>
<tr>
<td align="">วันรับทราบ</td>
<td align="">
<?
if(trim($session_kdate_a)){ echo "<?=$session_kdate_a?>"; }
if(trim($session_kdate_b)){ echo "ถึง $session_kdate_b"; }
?>
</td>
</tr>
<? }
if((trim($session_tdate_a)) || (trim($session_tdate_b)) ) { ?>
<tr>
<td align="">วันรับต้นฉบับ</td>
<td align="">
<?
if(trim($session_tdate_a)){ echo "$session_tdate_a"; }
if(trim($session_tdate_b)){ echo "ถึง $session_tdate_b"; }
?>
</td>
</tr>
<? }
if((trim($session_staff_search)) ) { ?>
<tr>
<td align="">ระบผู้รับ</td>
<td align="">"<?=$session_staff_search?>"</td>
</tr>
<? }
if((trim($session_group_search)) ) { ?>
<tr>
<td align="">ระบุกลุ่ม </td>
<td align="">"<?=$session_group_search?>"</td>
</tr>
<? }?>
</table>
</td>
</tr>
</table>
<?
### ค้นหา KEYWORD
if((trim($session_keyword)) && (!trim($session_topic))) {
$keyword_search=explode(" ",$session_keyword);
$search_tag="";
$sql_tb_col = "SHOW COLUMNS FROM document ";
$time_start_dash = getmicrotime();
$result_col =mysql_query($sql_tb_col)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
writetime2db($time_start_dash, getmicrotime() ,'SHOW COLUMN เรียกคอลัมร์ทั้งหมดของ tbl document ');
$search_tag.="AND ( ";
while($rs_col = mysql_fetch_assoc($result_col)){
foreach($keyword_search as $tag_1 => $tag_val ){
if($i!=0){$search_tag.=" OR ";}$i++;
$search_tag.=" document.$rs_col[Field] LIKE '%$tag_val%' ";
}
if($i!=0){$search_tag.=" OR ";}$i++;
$search_tag.=" document.$rs_col[Field] LIKE '%$session_keyword%' ";
}
$search_tag.=") ";
}elseif(trim($session_topic)) {
$search_tag .=" AND ( document.$session_topic LIKE '%$session_keyword%') ";
}else if(trim($session_type_doc)){
$search_tag .= " AND (document.type LIKE '%$session_type_doc%')";
}
if((trim($pdate_a)) || (trim($pdate_b)) ) {
$d = explode("/", $pdate_a);$key_pdate_a = ($d[2] - 543)."-".$d[1]."-".$d[0];
$d = explode("/", $pdate_b);$key_pdate_b = ($d[2] - 543)."-".$d[1]."-".$d[0];
$search_code.=" AND ( document.pdate between '$key_pdate_a' and '$key_pdate_b' ) ";
}
if((trim($rdate_a)) || (trim($rdate_b)) ) {
$d = explode("/", $rdate_a); $key_rdate_a = ($d[2] - 543)."-".$d[1]."-".$d[0];
$d = explode("/", $rdate_b); $key_rdate_b = ($d[2] - 543)."-".$d[1]."-".$d[0];
$search_code.=" AND ( document.time_rec between '$key_rdate_a' and '$key_rdate_b' )";
}
if((trim($sdate_a)) || (trim($sdate_b)) ){
$d = explode("/", $sdate_a); $key_sdate_a = ($d[2] - 543)."-".$d[1]."-".$d[0];
$d = explode("/", $sdate_b); $key_sdate_b = ($d[2] - 543)."-".$d[1]."-".$d[0];
$distinct_mode="";
$search_code.=" AND ( doc_receive.timerec between '$key_sdate_a' and '$key_sdate_b' )";
}
if((trim($kdate_a)) || (trim($kdate_b)) ){
$d = explode("/", $kdate_a); $key_kdate_a = ($d[2] - 543)."-".$d[1]."-".$d[0];
$d = explode("/", $kdate_b); $key_kdate_b = ($d[2] - 543)."-".$d[1]."-".$d[0];
$distinct_mode="";
$search_code.=" AND ( doc_receive.timeknow between '$key_kdate_a' and '$key_kdate_b' )";
}
if((trim($tdate_a)) || (trim($tdate_b)) ){
$d = explode("/", $tdate_a); $key_tdate_a = ($d[2] - 543)."-".$d[1]."-".$d[0];
$d = explode("/", $tdate_b); $key_tdate_b = ($d[2] - 543)."-".$d[1]."-".$d[0];
$distinct_mode="";
$search_code.=" AND ( doc_receive.timepaid between '$key_tdate_a' and '$key_tdate_b' )";
}
if(trim($staff_search)){
$inner_person_code="Inner Join $table_staff ON $table_staff.staffid = doc_receive.staff_id";
$search_code.=" AND ( $table_staff.staffname LIKE '%$staff_search%' OR $table_staff.staffsurname LIKE '%$staff_search%' )";
}
if(trim($group_search)){
$inner_group_code="Inner Join profile_staffgroup ON doc_receive.group_id = profile_staffgroup.gid";
$search_code.=" AND ( profile_staffgroup.groupname LIKE '%$group_search%' )";
}
if(($search_code_s)||($search_code_k)||($search_code_t)||($search_code_ss)||($search_code_gs)){
$inner_search="Inner Join doc_receive ON doc_receive.docid = document.id";
}
}
### END สร้าง SESSION SEARCH และเริ่มต้น การแสดง KEYWORD ESARCH
# ส่วนเรียงลำดับ
if($arrange){
$_SESSION[session_order]=$order;
$_SESSION[session_arrange]=$arrange;
}
if((!$order) || (!$arrange)){
$order=$_SESSION[session_order];
$arrange=$_SESSION[session_arrange];
}
if($param=="new"){
$_SESSION[session_order] = "";
$_SESSION[session_arrange] = "";
$order="";
$arrange="";
}
if($order){
if($arrange=="D"){$arrange_code="desc";$arrange="A";}else{$arrange_code="asc";$arrange="D";}
$order_code="order by $order $arrange_code";
}else{
$order_code="ORDER by ";
if($mode=="private"){
// $order_code.="doc_receive.timeknow asc ,";
// $paidcheck ="AND doc_receive.paidstaffid is null";
// $order_inner="INNER Join doc_receive ON document.id = doc_receive.docid";
// $group_doc="group by document.id";
}
//$distinct_mode="";
if(($type=="all") || (!$type)){ $order_code.="document.time_rec desc , document.docid desc "; }
else{ $order_code.="document.docid desc , document.pdate desc "; }
}
################################# USER VIEW
if($mode=="private"){
$r="0";
if($_SESSION[session_staffid]){
$sql_group=" SELECT org_groupmember.gid FROM org_groupmember WHERE org_groupmember.staffid = '$session_staffid' ";
$code_gid="";
$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]."' ";
}
$sql_group_mem="SELECT org_groupmember.staffid FROM org_groupmember $code_gid ";
$code_gid="";
$time_start_dash = getmicrotime();
$result_gid_list2=mysql_query($sql_group_mem);
//writetime2db($time_start_dash, getmicrotime() ,' เรียกกลุ่มที่ ผู้ใช้สังกัดอยู่ ทั้งหมด ');
$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++;
//echo $session_org;
$code_gid.=" (doc_receive.staff_id = '".$rs_gid[staffid]."' )or(doc_receive.owner = '".$rs_gid[staffid]."' ) ";
$code_gid.=" or(doc_receive.group_id = '".$session_org."') ";
}
}
if($i>0){ $code_gid.="or doc_receive.staff_id = '".$session_staffid."' "; }
else{ $code_gid.="doc_receive.staff_id = '".$session_staffid."' "; }
$type=($type=='all')?'%%':$type;
$sql_member_owner=" select doc_receive.docid from doc_receive Inner Join document ON doc_receive.docid = document.id where ($code_gid) and type LIKE '$type' group by doc_receive.docid ";
$type=($type=='%%')?'all':$type;
########## วน loop หาว่า หน่วยงานของ User นี้มี หนังสืออะไรส่งมาถึงบ้าง และส่งหนังสืออะไรไปบ้าง
$code_mem="";$i=0;
$time_start_dash = getmicrotime();
$result_mem_list2=mysql_query($sql_member_owner);
//writetime2db($time_start_dash, getmicrotime() ,'หาว่า หน่วยงานของ User นี้มี หนังสืออะไรส่งมาถึงบ้าง ');
if($result_mem_list2){
while($rs_mem=mysql_fetch_assoc($result_mem_list2)){
$tag_d.="$rs_mem[docid],";
}
$code_mem="or (document.id in (".$tag_d."0))";
// ####### END while($rs_mem=mysql_fetch_assoc($result_mem_list2))
} //####### END if($result_mem_list2)
}
if($i>0){ $code_mem.=" "; }
$where_code.=" AND ( (document.owner = '$session_staffid') ) $code_mem";
}
################################## END USER VIEW xxxxxx
if($type=="all"){$type="%%";}
if($c_select[year_setting]){
$year_select_code=" AND YEAR(document.pdate) = '$c_select_val[year_setting]'";
$year_select=$c_select_val[year_setting];
}else{
$year_now=DATE(Y);
$year_select=$year_now;
$year_select_code=" AND YEAR(document.pdate) = '$year_now'";
}
# Check ตั้งค่าแสดงผลประจำปี
$text_beeb.="482 search<br>";
$sql_setting_list=" select staffid from doc_setting where staffid = '$_SESSION[session_staffid]' AND colump != 'year_setting' ";
$time_start_dash = getmicrotime();
$result = mysql_query($sql_setting_list)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
//writetime2db($time_start_dash, getmicrotime() ,' Check ตั้งค่าแสดงผลประจำปี');
if($result){$rs_row=mysql_num_rows($result);}
# Check ตั้งค่าแสดงผล Columb
$text_beeb.="488 search<br>";
$sql_setting_list=" select * from doc_setting where staffid = '$_SESSION[session_staffid]'; ";
$time_start_dash = getmicrotime();
$result = mysql_query($sql_setting_list)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($srs = mysql_fetch_assoc($result)){
$c_select[$srs [colump]]="on";
$c_select_val[$srs[colump]]="$srs[colump_val]";
}
writetime2db($time_start_dash, getmicrotime() ,'Check ตั้งค่าแสดงผล Column ');
# Check การแสดงผลตามกลุ่มงาน
if($mode=="group"){
$inner_select ="
Inner Join doc_receive ON doc_receive.docid = document.id
Inner Join $table_groupmember ON doc_receive.staff_id = $table_groupmember.staffid
";
$r="0";
if($_SESSION[session_gid][$session_staffid]){
foreach ($_SESSION[session_gid][$session_staffid] as $num => $val) {
if($r>"0"){$where_code.=" or ";}else{ $where_code.="and ("; }$r++;
$where_code.="$table_groupmember.gid = '$val'";
}
if($r>"0"){$where_code.=" ) ";}
}
}
# เรียก สถานะหนังสือ
$sql_st="SELECT doc_status.id, doc_status.detail FROM doc_status ";
$time_start_dash = getmicrotime();
$result_st = mysql_query($sql_st)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($ersst = mysql_fetch_assoc($result_st)){
$st[$ersst[id]]=$ersst[detail];
}
writetime2db($time_start_dash, getmicrotime() ,' เรียก สถานะหนังสือ ');
$st[0]="-";
// $sql_del_label="
// SELECT
// doc_history.doc_action,
// doc_history.timerec,
// doc_history.owner_label,
// doc_history.docid,
// document.`type`
// FROM
// doc_history
// Inner Join document ON document.id = doc_history.docid
// WHERE
// doc_history.doc_action = 'del'
// $year_select_code
// GROUP BY
// doc_history.docid
// ORDER BY
// doc_history.timerec DESC
// ";
// $time_start_dash = getmicrotime();
// $result_owner = mysql_query($sql_del_label)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
// while($rs_del_label=mysql_fetch_assoc($result_owner)){
// $del_label[$rs_del_label[docid]]=$rs_del_label[owner_label];
// }
// writetime2db($time_start_dash, getmicrotime() ,' จำนวนการประวัติต่อ ทะเบียนหนังสือนั้นๆ ');
################################################START แบ่งหน้า
if($type=="all"){$type="%%";}
$sql_scape_01=" SELECT ";
#ชุด 2 เลือก ฟิลด์ที่ต้องการ
$sql_scape_02_1="
document.id, document.docid, document.number, document.pdate,document.`type`,document.refid,document.sending,
document.getting,document.title, document.`comment`,document.`owner`,document.`status`,document.`speed`,
document.`secret`,document.`doc_status`
";
$sql_scape_02_2="
count(document.id) as num
";
#ชุด 3 เงื่อนไข
$sql_scape_03="
FROM
document
$inner_person_code
$inner_group_code
$order_inner
$inner_select
$inner_search
WHERE
document.type LIKE '$type'
$paidcheck
$search_tag
$year_select_code
$where_code
$search_code
";
#ชุด 4 ORDER AND GROUP
$sql_scape_04_1=" $order_code ";
// GROUP by document.id
$sql_scape_04_2=" $order_code ";
$sql=$sql_scape_01.$sql_scape_02_2.$sql_scape_03.$sql_scape_04_1;
#
$time_start_dash = getmicrotime();
$result_row1 = mysql_query($sql)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
writetime2db($time_start_dash, getmicrotime() ,'จำนวนทะเบียนหนังสือทั้งหมดที่ผู้ใช้สามารถเรียกดูได้');
##################################### # START แบ่งหน้า
$time_start_dash = getmicrotime();
if($result_row1){ /*$row_all= mysql_num_rows($result_row1);*/ $row_a=mysql_fetch_assoc($result_row1); $row_all=$row_a[num]; };
$nump=0;
$numid=0;
if($stype=="%%"){$type="all";}
/////////////////////////// PAGE CODE
if(!$page){$page="1";}
if(!$perpage){$perpage="20";}
$lastpage=intval($row_all/$perpage)+1;
$limit_start=($page-1)*$perpage;
$limit_code=" limit $limit_start , $perpage ";
$sql=$sql_scape_01.$sql_scape_02_1.$sql_scape_03.$sql_scape_04_2;
$sql.=" $limit_code";
//echo "<pre>".$sql."</pre>";
if($debug_sql=="on"){echo "<pre>".$sql."</pre>";}
$result3 = mysql_query($sql);
if(@mysql_num_rows($result3)>0){
$xi=0;
while($rsn =mysql_fetch_assoc($result3)){
$tag_id.="'".$rsn[id]."',";
}
//$tag_id=substr($tag_id,0,-1);<br />
}
$tag_id.="'0'";
//echo "$tag_id <hr>";
writetime2db($time_start_dash, getmicrotime() ,'แบ่งหน้า เพื่อแสดงทะเบียนออก หน้าเวบเพจ');
if($type=="%%"){$type="all";}
if($arrange=="D"){$arrange_now="A";}else{$arrange_now="D";}
echo "<b>ทะเบียนหนังสือประจำปี ".($year_select+543)."</b>" ;
echo "<b>" ;
if($type=="get"){echo " (หนังสือรับ)";}
else if($type=="send"){echo " (หนังสือส่ง)"; }
else if($type=="circular"){echo " (หนังสือเวียน)"; }
else if($type=="command"){echo " (หนังสือคำสั่ง)"; }
//else{echo " หนังสือทุกประเภท";}
echo "</b>" ;
######################################################
//echo "<pre>";print_r($session_permit);echo "<hr>";
# Check ทะเบียนที่เป็นหนังสือถึง owner User
$sql_permit="SELECT docid,Max(doc_receive.`status`) as status FROM doc_receive where docid in ($tag_id) group by docid";
$time_start_dash = getmicrotime();
$result_permit = mysql_query($sql_permit)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($rs_permit = mysql_fetch_assoc($result_permit)){
$pr[$session_staffid]=$rs_permit[docid];
//if($permit_status[$rs_permit[docid]]){$rs_permit[status]="100";}else{$rs_permit[status]='';}
$read_status[$rs_permit[docid]]=$rs_permit[status];
}
writetime2db($time_start_dash, getmicrotime() ,'Check ทะเบียนที่เป็นหนังสือถึง owner User');
//echo "<pre>";print_r($read_status);echo"</pre>";
$time_start_dash = getmicrotime();
$search_type=($type=="all")?"%%":$type;
$sql_owner_doc="
SELECT
document.id,
document.`owner`,
document.`status`,
doc_receive.`deadline`,
doc_receive.`deadline_alert`
FROM
document
Inner Join doc_receive ON doc_receive.docid = document.id
WHERE
document.type LIKE '$search_type'
and ((doc_receive.staff_id = '$session_staffid')or(doc_receive.owner = '$session_staffid'))
and document.id in ($tag_id)
";
$time_start_dash=getmicrotime();
$result_owner = mysql_query($sql_owner_doc)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
writetime2db($time_start_dash, getmicrotime() ,'หา สถานะเอกสารที่เกี่ยวข้องลง');
if($type=="all"){$type="%%";}
while($rs_owner = mysql_fetch_assoc($result_owner)){
$owner_doc[$rs_owner[id]]="on";
if($rs_owner[deadline]){
$owner_deadline[$rs_owner[id]]=$rs_owner[deadline];
$owner_alert[$rs_owner[id]]=$rs_owner[deadline_alert];
$d=explode("-",$rs_owner[deadline]);
$mkremain=( (mktime(12, 0, 0, $d[1], $d[2], $d[0]))-( mktime(12, 0, 0, date("m"), date("d"), date("Y"))) )/(24*60*60);
$owner_remain[$rs_owner[id]]=$mkremain;
} ##### END if($rs_owner[deadline]){
} ########## END while($rs_owner = mysql_fetch_assoc($result_owner)){
writetime2db($time_start_dash, getmicrotime() ,'หาเอกสารที่เกี่ยวข้องลง Array');
######################################################## ปิดการแสดงผล จำนวนไฟล์แนบ
// $type="$type";
// $time_start = getmicrotime();
// ## Chack ไฟล์แนบ
// $sql_attach_check = " SELECT doc_attach.docid,doc_attach.id, Count(doc_attach.id) as file_nums FROM doc_attach where 1=1 $tag_doc GROUP BY
// doc_attach.docid order by doc_attach.docid ";
// $time_start_dash = getmicrotime();
// $result_check = mysql_query($sql_attach_check)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
// while($crs = mysql_fetch_assoc($result_check)){
// $attachment[$crs[docid]]=$crs[file_nums];
// $attach_link[$crs[docid]]=$crs[id];
// }
########################################################
//writetime2db($time_start_dash, getmicrotime() ,' Chack ไฟล์แนบ ');
/* # Check ประวัติการเปิดอ่านทะเบียนหนังสืิอ
$sql_permit_status="SELECT doc_history.docid as docid FROM doc_history WHERE doc_history.doc_owner='$session_staffid'
AND doc_history.doc_action='view' $tag_doc group by docid
";
$time_start_dash = getmicrotime();
$result_permit_status = mysql_query($sql_permit_status)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
//writetime2db($time_start_dash, getmicrotime() ,' Check ประวัติการเปิดอ่านทะเบียนหนังสืิอ ');
echo "<script language='javascript'>document.getElementById('loading').innerHTML=' <img src='../../images/indicator.gif'>: Check ประวัติการเปิดอ่านทะเบียนหนังสืิอ'</script>"
while($rs_permit_status = mysql_fetch_assoc($result_permit_status )){
$permit_status[$rs_permit_status[docid]]='view';
}*/
######################################################## ปิดการแสดงผล Check ประวัติการแก้ไข้เอกสาร
// echo $sql_edit_list=" select id,count(*) as edittime from doc_edit where 1=1 AND id in ($tag_id) group by id ";
// $time_start_dash = getmicrotime();
// $result = mysql_query($sql_edit_list)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
// while($rs_edit = mysql_fetch_assoc($result)){
// $edittime[$rs_edit[id]]=$rs_edit[edittime];
// }
// writetime2db($time_start_dash, getmicrotime() ,' Check ประวัติการแก้ไข้เอกสาร ');
######################################################## END ปิดการแสดงผล Check ประวัติการแก้ไข้เอกสาร
?>
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<? if(($session_order)||($order)){
$text_beeb.="571 search<br>";
?>
<tr>
<td colspan="3" align="right"><!--<a href="<?=$PHP_SELF?>?type=<?=$type?>&page=1&search=<?=$search?>&order=<?=$order?>&arrange=<?=$arrange_now?>¶m=new">ล้างการเรียงลำดับ</a>--></td>
</tr>
<? } ?>
<tr>
<td width="20%" align="right"> </td>
<td align="center"><? if($page>"1"){?>
<a href="<?=$PHP_SELF?>?type=<?=($type=='%%')?'all':$type?>&page=1&search=<?=$search?>&order=<?=$order?>&arrange=<?=$arrange_now?>"> <img src="../../images/page_div_icon/First.gif" border="0" /></a>
<? }else{?>
<img src="../../images/page_div_icon/xFirst.gif" border="0" />
<? }?>
<? if($page>"1"){?>
<a href="<?=$PHP_SELF?>?type=<?=($type=='%%')?'all':$type?>&page=<?=($page-1)?>&search=<?=$search?>&order=<?=$order?>&arrange=<?=$arrange_now?>"> <img src="../../images/page_div_icon/Previous.gif" border="0"></a>
<? }else{?>
<img src="../../images/page_div_icon/xPrevious.gif" border="0" />
<? }?>
<!--<INPUT name="page" type="text" value="<?=$page?>" style="width:30px;"/>-->
<? echo "$page/$lastpage"; ?>
<? if($page<$lastpage){?>
<a href="<?=$PHP_SELF?>?type=<?=($type=='%%')?'all':$type?>&page=<?=($page+1)?>&search=<?=$search?>&order=<?=$order?>&arrange=<?=$arrange_now?>"><img src="../../images/page_div_icon/Next.gif" border="0" /></a>
<? }else{?>
<img src="../../images/page_div_icon/xNext.gif" border="0" />
<? }?>
<? if($page<$lastpage){?>
<a href="<?=$PHP_SELF?>?type=<?=($type=='%%')?'all':$type?>&page=<?=$lastpage?>&search=<?=$search?>&order=<?=$order?>&arrange=<?=$arrange_now?>"> <img src="../../images/page_div_icon/Last.gif" border="0" /></a>
<? }else{?>
<img src="../../images/page_div_icon/xLast.gif" border="0">
<? }?>
</td>
<td width="20%" align="right">
<!--
<? // if($session_permit[400]){?>
<label onclick="showEle('div_search_all');" style="cursor:hand" title="เลือกค้นหาแบบละเอียด"><u>ค้นหา<img src="../../images/ico_search.gif" width="16" height="16" border="0" /></u></label>
<?// }?>
<? // if( ($session_permit[300])&&($type!="all") ){?>
<a href="<?=$PHP_SELF?>?type=<?=$type?>&action=add">เพิ่มข้อมูล<img src="../../images/ico_add_pic.gif" width="16" height="16" border="0" /></a>
<? //}?>
--> </td>
</tr>
</table>
</div>
<table width="95%" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td align="center" >
<table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr>
<td width="17" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg"><? if(!$arrange){$arrange="A";} ?></td>
<td width="17" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg"><strong><a href="<?=$PHP_SELF?>?type=<?=$type?>&order=status&arrange=<?=$arrange?>"></a></strong>
<? if($order){ ?>
<a href="?param=new"><img src="../../images/drilldown.png" alt="ล้างค่าการ sort" border="0" /></a>
<? }?>
</td>
<? if(($c_select[c1])){ ?>
<td width="29" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<? if(($session_order)||($order)){?>
<a href="<?=$PHP_SELF?>?type=<?=$type?>&page=1&search=<?=$search?>&order=<?=$order?>&arrange=<?=$arrange_now?>¶m=new">ลำดับ</a>
<? }else{echo "ลำดับ";}?> </td>
<? } ?>
<? if(($c_select[c2]) || (!$rs_row)){ ?>
<td width="68" height="20" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<strong><a href="<?=$PHP_SELF?>?type=<?=$type?>&order=docid&arrange=<?=$arrange?>">เลข<br />
หนังสือ
<? if($order=="docid"){ echo "<img src='../../images/sort_".$arrange_code.".gif' border=0>"; }?></a></strong></td>
<? }?>
<? if(($c_select[c3]) || (!$rs_row)){ ?>
<td width="66" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<a href="<?=$PHP_SELF?>?type=<?=$type?>&order=refid&arrange=<?=$arrange?>">เอกสาร<br />
เลขที่
<? if($order=="refid"){echo "<img src='../../images/sort_".$arrange_code.".gif' border=0>"; }?></a></strong></td>
<? } ?>
<? if(($c_select[c4]) || (!$rs_row)){ ?>
<td width="67" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<strong><a href="<?=$PHP_SELF?>?type=<?=$type?>&order=pdate&arrange=<?=$arrange?>">ลงวันที่
<? if($order=="pdate"){echo "<img src='../../images/sort_".$arrange_code.".gif' border=0>"; }?></a></strong></td>
<? }?>
<? if(($c_select[c5]) || (!$rs_row)){ ?>
<td width="67" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<strong><a href="<?=$PHP_SELF?>?type=<?=$type?>&order=sending&arrange=<?=$arrange?>">จาก
<? if($order=="sending"){echo "<img src='../../images/sort_".$arrange_code.".gif' border=0>"; }?></a></strong></td>
<? }?>
<? if(($c_select[c6]) || (!$rs_row)){ ?>
<td width="108" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<strong><a href="<?=$PHP_SELF?>?type=<?=$type?>&order=getting&arrange=<?=$arrange?>">ถึง
<? if($order=="getting"){echo "<img src='../../images/sort_".$arrange_code.".gif' border=0>"; }?></a></strong></td>
<? }?>
<? if(($c_select[c7]) || (!$rs_row)){ ?>
<? if($session_permit[300]){$w="100%";}else{$w="100%";} ?>
<td width="100" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg">
<strong><a href="<?=$PHP_SELF?>?type=<?=$type?>&order=title&arrange=<?=$arrange?>">เรื่อง
<? if($order=="title"){echo "<img src='../../images/sort_".$arrange_code.".gif' border=0>"; }?></a></strong></td>
<? }?>
<? if(($c_select[c9]) || (!$rs_row)){ ?>
<td align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg" > </td>
<? }
if($type=="all"){$type="%%";}
if(($c_select[c10]) || (!$rs_row)){
if($session_permit[300]){
//echo '<td width="2%" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg" > </td>';
}
} ?>
</tr>
<?
if(mysql_num_rows($result3)>0){mysql_data_seek($result3,0);}
while($ers = mysql_fetch_assoc($result3)){$numid++;
$nump++;
if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
if($owner_deadline[$ers[id]]){
$alert_code="#F8D549";
$alert_code_h="#FC7465";
$late_code="#FFF8F4";
$late_code_pass="#DFFFBF";
$bgtemp=$bgcolor;
// if( ($owner_remain[$ers[id]]<=$owner_alert[$ers[id]]) && $owner_remain[$ers[id]]>="0"){
// $bgcolor="$alert_code_h";
// }elseif($owner_remain[$ers[id]]>="0"){
// $bgcolor="$alert_code";
// }elseif($owner_remain[$ers[id]]<"0"){
// $bgcolor="$late_code";
// }
// echo $owner_remain[$ers[id]]." - ".$owner_alert[$ers[id]];
if( ($owner_remain[$ers[id]]<=$owner_alert[$ers[id]]) && $owner_remain[$ers[id]]>="0"){
$bgcolor="$alert_code_h";
}elseif($owner_remain[$ers[id]]>="0"){
$bgcolor="$alert_code";
}elseif($owner_remain[$ers[id]]<"0"){
$bgcolor="$late_code_pass";
}
}
if($ers[pdate]){
$d = explode("-", $ers[pdate]);
$ndate = $d[2]."/".$d[1]."/".($d[0] + 543);
$ndate =daythai($ers[pdate]);
}
if($ers[group_id]){$receive=$gr[$ers[group_id]];}
elseif($ers[staff_id]){$receive=$pr[$ers[staff_id]];}
else{$receive="-";}
if($ers['doc_status']=="w"){
$bgcolor="EAEAFA";
$ers[refid]="";
$ers[sending]="";
$ers[getting]="";
$ers[title]="";
$ndate="";
$col_rows=2;
if(!$c_select[c3]){$col_rows++;}
if(!$c_select[c4]){$col_rows++;}
if(!$c_select[c5]){$col_rows++;}
if(!$c_select[c6]){$col_rows++;}
if(!$c_select[c7]){$col_rows++;}
}
#1. รายการที่หน่วยงานตนเองส่ง คลิกได้อยู่แล้ว
#2. สำหรับ user ที่ permit == 100 ต้องได้ permit 200 ถึงจะคลิกได้ (รายการนอกเหนือข้อ 1)
#owner_docv2
?>
<? if(($session_permit[200]) || ($owner_docv2[$ers[id]])){ echo""; }else{ /* echo " style='cursor:defualt' "; */}?>
<tr bgcolor="<?=$bgcolor?>" onmouseover='mOvr(this,"dbf2ae");' onmouseout='mOut(this,"<?=$bgcolor?>");' onClick="window.location.replace('document_view.php?action=view&id=<?=$ers[id]?>&type=<?=$ers[type]?>')" height="48:pixel">
<?
if($owner_deadline[$ers[id]]){
$bgcolor=$bgtemp;
}
?>
<?// if($type=="all"){?>
<td align="center" valign="top" >
<?
if($ers[type]=="get"){ echo '<img src="../../images/email_fwd2.gif" width="15" height="12" />'; } // หนังสือรับ
elseif($ers[type]=="send"){ echo '<img src="../../images/email_reply2.gif" width="15" height="12" />'; } // หนังสือส่ง
elseif($ers[type]=="circular"){echo '<img src="../../images/email_circular.gif" width="15" height="12" />';} // หนังสือเวียน
elseif($ers[type]=="command"){echo '<img src="../../images/email_new.gif" width="14" height="10" />';} // หนังสือคำสั่ง
elseif($ers[type]=="secret"){ echo '<img src="../../images/email.gif" width="15" height="12" />';} // หนังสือลับ
?>
</td>
<td align="center" valign="top" class="index" >
<?
if(($read_status[$ers[id]]=="0") || (!$read_status[$ers[id]])){
echo '<img src="../../images/email_close.gif" width="15" height="12" border="0" title="ใหม่"/>';
}else if($read_status[$ers[id]]=="100"){
echo ' <img src="../../images/email_open.gif" width="15" height="12" border="0" title="รับทราบ"/>';
}else if($read_status[$ers[id]]=="200"){
echo '<img src="../../images/menu_logout.gif" width="14" height="14" border="0" title="รับต้นฉบับแล้ว"/>';
}?> </td>
<? if(($c_select[c1])){ ?>
<td align="center" valign="top" class="index" title="<?=$ers[docid]?>"><?=$numid?></td>
<? }?>
<!--<td align="center">
$nump
</td>-->
<? if(($c_select[c2]) || (!$rs_row)){ ?>
<td height="20" align="center" valign="top" class="index" title="<?=$ers[docid]?>">
<? echo $ers[docid];
if($ers[speed]=="100") { echo "<br><font color=#FF0000>ด่วน</font>"; }
if($ers[speed]=="200") { echo "<br><STRONG><font color=#FF0000>ด่วนมาก</font></STRONG>"; }
if($ers[speed]=="300") { echo "<br><STRONG><font color=#CC0000>ด่วนที่สุด*** </font></STRONG>"; }
if($ers[secret]=="100") { echo "<br><STRONG>(ลับ)</STRONG>"; }
if($ers[secret]=="200") { echo "<br><STRONG>(ลับมาก)</STRONG>"; }
if($ers[secret]=="300") { echo "<br><STRONG>(ลับที่สุด)</STRONG>"; }
?> </td>
<? }?>
<? if($ers['doc_status']!="w"){ ?>
<? if(($c_select[c3]) || (!$rs_row)){ ?>
<td align="" valign="top" class="index" title="<?=$ers[refid]?>">
<? if( (!$read_status[$ers[id]]) ){ echo "<B>"; }
if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){ echo "<b>"; }
if(trimtxt($ers[refid],20)){echo trimtxt($ers[refid],20);}else{ echo $ers[docid]; }
// if($ers[type]=="send") {echo "/".$ers[number];}
// if($ers[type]=="circular") {echo "/ว".$ers[number];}?> </td>
<? }
if(($c_select[c4]) || (!$rs_row)){
?>
<td align="" valign="top" class="index" title="<?=$ndate?>" >
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){ echo "<B>"; }
if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){ echo "<B>"; }
echo $ndate;
?> </td>
<? }?>
<? if(($c_select[c5]) || (!$rs_row)){ ?>
<td align="" valign="top" class="index" title="<?=$ers[sending]?>">
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){ echo "<B>";}
if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){ echo "<B>"; }
echo trim($ers[sending]); ?> </td>
<? }?>
<? if(($c_select[c6]) || (!$rs_row)){ ?>
<td align="" valign="top" class="index" title="<?=$ers[getting]?>">
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){ echo "<B>";}
if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){ echo "<B>"; }
echo trim($ers[getting]); ?> </td>
<? }?>
<? if(($c_select[c7]) || (!$rs_row)){ ?>
<? if( (strlen($ers[sending])) > (strlen($ers[getting]))) { $max_to=strlen($ers[sending]);}else{$max_to=strlen($ers[getting]);}?>
<td align="" valign="top" class="index" title="<?=$ers[title]?>">
<? if($owner_doc[$ers[id]]){
if($owner_deadline[$ers[id]]){ ?>
<img src="../../images/calendar.gif" width="16" height="16" border="0" title="วันดำเนินการ <? echo daythai($owner_deadline[$ers[id]]);
if($owner_remain[$ers[id]]>="0"){ echo "เหลือเวลา ".$owner_remain[$ers[id]]." วัน "; }?>" />
<? } }
if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){ echo "<B>"; }
if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){ echo "<b>"; }
if($max_to<128){$max_to=128;}
echo trimtxt($ers[title],intval($max_to*1.4));
if($edittime[$ers[id]]){echo "<i><u>(แก้ไขครั้งที่ ".$edittime[$ers[id]].")</u></i>";} ?> </td>
<? }
}else{
echo '<td align="center" valign="middle" class="index" colspan=5 > <strong> เลขทะเบียนนี้ ถูกยกเลิกโดย ผู้ใช้ระบบ '.$del_label[$ers[id]].' </strong></td>';
}?>
<? if(($c_select[c9]) || (!$rs_row)){ ?>
<td width="26" align="center" valign="top" class="index">
<?php /*?> <?
if($ers[owner]){
$sql="
SELECT
org_staffgroup.groupname
FROM
document
Inner Join epm_staff ON document.owner = epm_staff.staffid
Inner Join org_groupmember ON epm_staff.staffid = org_groupmember.staffid
Inner Join org_staffgroup ON org_groupmember.gid = org_staffgroup.gid
WHERE
org_staffgroup.groupname != 'Administrator' AND document.id=".$ers[id]."
LIMIT 1
";
$result_owner=@mysql_query($sql);
$owner_name=mysql_fetch_assoc($result_owner);
?>
<img src='../../images/man.gif' width="16" height="15" title="<?="ผู้สร้างหนังสือ :".$owner_name[groupname]?>"/>
<? }else{echo" ";} ?><?php */?>
<?php /*?> <? เปิด นึกว่าทำให้ user สับสน ในการใช้งาน และ หนังสือไม่ตรงกับความเป็นจริง
if($owner_deadline[$ers[id]]){
$bgcolor=$bgtemp;
}
if(($c_select[c9]) || (!$rs_row)){
if(($prd[$ers[id]]) && ($session_permit[300])) {?>
<img src="../../images/ico_prisoner.gif" width="12" height="16" border="0" title="มีกิจกรรมสำหรับ ทะเบียนหนังสือนี้"/><br>
<?
echo "(".intval($prd[$ers[id]]).")";
}else{echo" ";}
}?><?php */
## Chack ไฟล์แนบ
$sql_attach_check = "
SELECT doc_attach.docid,doc_attach.id, Count(doc_attach.id) as file_nums
FROM doc_attach
where 1=1 $tag_doc and doc_attach.docid = '$ers[id]' GROUP BY
doc_attach.docid order by doc_attach.docid LIMIT 1 ";
$result_check = mysql_query($sql_attach_check)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$crs = @mysql_fetch_assoc($result_check);
$attachment[$crs[docid]]=$crs[file_nums];
$attach_link[$crs[docid]]=$crs[id];
if($attachment[$ers[id]]){ if($attachment[$ers[id]]>"0") {?><img src='../../images/file_attach.gif' border="0" /><? }}
if($ers[comment]){ ?><img src='../../images/ico_warning.gif' width="16" height="15" title="<?=$ers[comment]?>"/><? }else{echo" ";} ?></td>
<? }?>
</tr>
<? }
if($nump=="0") {?>
<tr bgcolor="#F2F2F2">
<td colspan="14" align="center">-- ยังไม่มีข้อมูล --</td>
</tr>
<? } ?>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<? // echo $text_beeb;
writetime2db($time_start_dashboard, getmicrotime() ,' หน้า DASHBOARD ทั้งหมด ');
?>