|
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/application/document/ |
Upload File : |
<? $time_start = getmicrotime(); ?>
<form action="" method="post" enctype="multipart/form-data" name="post" id="post">
<link href="../../common/style.css" rel="stylesheet" type="text/css" />
<?
// print_r($_SESSION);
$_SESSION[session_type]=$_GET[type];
if(!$type){$type=$_SESSION[session_type];}
if(!$type){$type="all";}
?>
<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>
<div id="div_search_all" style="display:none;">
<table width="96%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#E6E6E6" class="login_fill3" style="border:1px solid #5595CC;">
<tr>
<td align="left"><img src="../../images/ico_srch.gif" width="16" height="16" />
ระบุคำค้นหา
<INPUT type="text" name="keyword" class="input" style="width:200px; height:20px; background-color:#ffffff;">
<SELECT name="topic" class="input" style="width:200px; height:20px;">
<option value="">- เลือกประเภทค้นหา -</option>
<option value="title">เรื่อง</option>
<option value="docid">เลขหนังสือ </option>
<option value="refid">เอกสารเลขที่ </option>
<option value="sending">จาก</option>
<option value="getting">ถึง</option>
</SELECT>
<input type="hidden" name="page2" value="1" />
<input name="search" type="hidden" id="search" value="now" />
<INPUT type="hidden" name="type" value="get">
<INPUT type="submit" name="submit" value="Go" style="width:50;" class="input">
<br />
<? if ($session_permit[200]) {?>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4"><hr></td>
</tr>
<tr>
<td colspan="4"><strong>ระบุวันที่</strong></td>
</tr>
<tr>
<td width="99" align="right">ลงวันที่ :</td>
<td width="200">
<input name="pdate_a" type="text" id="pdate_a" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly />
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.pdate_a, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
<td width="50">ถึง</td>
<td width="567">
<input name="pdate_b" type="text" id="pdate_b" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.pdate_b, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
</tr>
<!-- <tr>
<td align="right">ระบุวันบันทึก : </td>
<td>
<input name="rdate_a" type="text" id="rdate_a" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.rdate_a, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
<td>ถึง</td>
<td>
<input name="rdate_b" type="text" id="rdate_b" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.rdate_b, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </tr>
<tr>-->
<td colspan="4" align="left"><strong>ระบุการค้นหาในกลุ่มจดหมายเวียน
<input name="receive_search" type="hidden" id="receive_search" value="on" />
</strong></td>
</tr>
<tr>
<td align="right">วันส่งต่อเอกสาร : </td>
<td><input name="sdate_a" type="text" id="sdate_a" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.sdate_a, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
<td>ถึง</td>
<td><input name="sdate_b" type="text" id="sdate_b" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.sdate_b, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
</tr>
<tr>
<td align="right">วันรับทราบ : </td>
<td><input name="kdate_a" type="text" id="kdate_a" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.kdate_a, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
<td>ถึง</td>
<td><input name="kdate_b" type="text" id="kdate_b" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.kdate_b, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
</tr>
<tr>
<td align="right">วันรับต้นฉบับ : </td>
<td><input name="tdate_a" type="text" id="tdate_a" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.tdate_a, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
<td>ถึง</td>
<td><input name="tdate_b" type="text" id="tdate_b" onkeypress="chk_key_in(this.value, this.id);" size="20" maxlength="10" readonly/>
<img src="../..//images/calendar.png" alt="วัน/เดือน/ปี" width="24" height="24" border="0" align="absmiddle" onclick="popUpCalendar(this, post.tdate_b, 'dd/mm/yyyy')" onmouseover="this.style.cursor='hand'"value="วัน เดือน ปี" /> </td>
</tr>
<tr>
<td align="right">ผู้รับ : </td>
<td><input type="text" name="staff_search" /></td>
<td>หน่วยงาน</td>
<td><input name="group_search" type="text" id="group_search" /></td>
</tr>
<tr>
<td width="99"> </td>
<td width="200"> </td>
<td> </td>
<td> </td>
</tr>
</table>
<?}?>
</td>
</tr>
</table>
</div>
<?
if($search){
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{
// $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="left">
<?// 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 = "หนังสือเวียน";}?>
<TR>
<TD colspan="2" align="left"><? if(trim($session_keyword)) { ?>"<?=$session_keyword?>" <? } ?></TD>
</TR>
<TR>
<TD colspan="2" align="left">
<? if(trim($session_topic)) { ?>
<strong>ในหมวด:</strong> "<?=$topic_name?>"
<? } ?>
<? if(trim($session_type_doc)){ ?>
<strong>ประเภทเอกสาร:</strong> "<? echo "$type_doc_name"?>" <? }?> </TD>
</TR>
<? } ?>
<? if((trim($session_pdate_a)) || (trim($session_pdate_b)) ) { ?>
<TR>
<TD width="10%" align="left">ลงวันที</TD>
<TD width="90%" align="left"><? if(trim($session_pdate_a)){ ?>"<?=$session_pdate_a?>" <?} if(trim($session_pdate_b)){?> ถึง "<?=$session_pdate_b?>" <?}?></TD>
</TR>
<? } ?>
<? if((trim($session_rdate_a)) || (trim($session_rdate_b)) ) { ?>
<TR>
<TD align="left">วันบันทึก</TD>
<TD align="left"><? if(trim($session_rdate_a)){ ?>"<?=$session_rdate_a?>" <?} if(trim($session_rdate_b)){?> ถึง "<?=$session_rdate_b?>" <?}?></TD>
</TR>
<? } ?>
<? if((trim($session_sdate_a)) || (trim($session_sdate_b)) ) { ?>
<TR>
<TD align="left">วันส่งต่อเอกสาร</TD>
<TD align="left"><? if(trim($session_sdate_a)){ ?>"<?=$session_sdate_a?>" <?} if(trim($session_sdate_b)){?> ถึง "<?=$session_sdate_b?>" <?}?></TD>
</TR>
<? } ?>
<? if((trim($session_kdate_a)) || (trim($session_kdate_b)) ) { ?>
<TR>
<TD align="left">วันรับทราบ</TD>
<TD align="left"><? if(trim($session_kdate_a)){ ?>"<?=$session_kdate_a?>" <?} if(trim($session_kdate_b)){?> ถึง "<?=$session_kdate_b?>" <?}?></TD>
</TR>
<? } ?>
<? if((trim($session_tdate_a)) || (trim($session_tdate_b)) ) { ?>
<TR>
<TD align="left">วันรับต้นฉบับ</TD>
<TD align="left"><? if(trim($session_tdate_a)){ ?>"<?=$session_tdate_a?>" <?} if(trim($session_tdate_b)){?> ถึง "<?=$session_tdate_b?>" <?}?></TD>
</TR>
<? } ?>
<? if((trim($session_staff_search)) ) { ?>
<TR>
<TD align="left">ระบผู้รับ</TD>
<TD align="left">"<?=$session_staff_search?>"</TD>
</TR>
<? }?>
<? if((trim($session_group_search)) ) { ?>
<TR>
<TD align="left">ระบุกลุ่ม </TD>
<TD align="left">"<?=$session_group_search?>"</TD>
</TR>
<? }?>
</TABLE>
</td>
</tr>
</table>
<?
if((trim($session_keyword)) && (!trim($session_topic))) {
$keyword_search=explode(" ",$session_keyword);
$search_tag="";
$sql_tb_col = "SHOW COLUMNS FROM document";
$result_col =mysql_query($sql_tb_col)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$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_p=" 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_r=" 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=" DISTINCT ";
$search_code_s=" 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=" DISTINCT ";
$search_code_k=" 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=" DISTINCT ";
$search_code_t=" 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_ss=" 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_gs=" 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";
}
}
# ส่วนเรียงลำดับ
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 ((!$session_permit[100])&&(!$session_permit[200])) {
if($mode=="private"){
$order_code.="doc_receive.timeknow asc ,";
$paidcheck ="AND doc_receive.paidstaffid is null";
$order_inner="Left Join doc_receive ON document.id = doc_receive.docid";
}
$distinct_mode=" DISTINCT ";
if(($type=="all") || (!$type)){
$order_code.="document.time_rec desc , document.docid desc ";
}else{
$order_code.="document.docid desc , document.pdate desc ";
}
}
$time_end = getmicrotime(); writetime2db($time_start,$time_end,'ทดสอบ ส่วนการค้นหา query');
########################################################33
$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
GROUP BY
doc_attach.docid
order by doc_attach.docid
";
$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];
}
# Check ผู้รับหนังสอส่งต่อ
$sql_p="
SELECT
distinct
docid,
count(staff_id) as num_letter
FROM
doc_receive
group by docid
";
// doc_receive.staff_id
$result_p = mysql_query($sql_p)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($ersp = mysql_fetch_assoc($result_p)){
$prd[$ersp[docid]]=$ersp[num_letter];
}
//echo "<pre>";
//print_r($pr);
//echo "<pre>";
######################################READ STATUS
# 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'
";
$result_permit_status = mysql_query($sql_permit_status)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($rs_permit_status = mysql_fetch_assoc($result_permit_status )){
$permit_status[$rs_permit_status[docid]]='view';
}
# Check ทะเบียนที่เป็นหนังสือถึง owner User
if( (!$session_permit[100]) || (!$session_permit[200]) || (!$session_permit[300])){
$sql_permit="
SELECT
docid,
status
FROM
doc_receive
where
staff_id=$session_staffid
group by docid
";
}else{
$sql_permit="
SELECT
document.id as docid
FROM
document
";
}
$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]='';}
// if($rs_permit[status]){
$read_status[$rs_permit[docid]]=$rs_permit[status];
// }
}
###################################### END READ STATUS
//print_r($read_status);
# เรียก สถานะการหนังสือ
$sql_st="
SELECT
doc_status.id,
doc_status.detail
FROM
doc_status
";
$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];
}$st[0]="-";
# Check ประวัติการแก้ไข้เอกสาร
$sql_edit_list="
select id,count(*) as edittime from doc_edit group by id
";
$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];
}
# Check ตั้งค่าแสดงผลประจำปี
$sql_setting_list="
select * from doc_setting where staffid = '$_SESSION[session_staffid]' AND colump != 'year_setting'
";
$result = mysql_query($sql_setting_list)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
if($result){$rs_row=mysql_num_rows($result);}
# Check ตั้งค่าแสดงผล Columb
$sql_setting_list="
select * from doc_setting where staffid = '$_SESSION[session_staffid]';
";
$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]";
}
if (!$session_permit[100]){
$mode="private";
}
# Check การแสดงผลตามกลุ่มงาน
if($mode=="group"){
$distinct_mode=" DISTINCT ";
$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.=" ) ";}
}
}
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="";
$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.=" epm_groupmember.staffid like '".$rs_gid[staffid]."' ";
$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."' ";
}
$sql_member_owner="
select doc_receive.docid from doc_receive where $code_gid group by doc_receive.docid
";
// echo "<br><br>";
$code_mem="";$i=0;
$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++;
$code_mem.="( document.id= '$rs_mem[docid]' )";
}
}
}
if($i>0){ $code_mem.=" "; }
// echo $code_gid;
// $distinct_mode=" DISTINCT ";
// $inner_select =" Inner Join doc_receive ON doc_receive.docid = document.id ";
$where_code.="or ( (document.owner = '$session_staffid') $code_mem )";
// $sql_union="
// UNION
// select * from document where document.owner = '".$rs_gid[staffid]."'
// ";
}
if($type=="all"){$type="%%";}
if($c_select[year_setting]){
$year_select_code=" AND YEAR(document.pdate) LIKE '$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) LIKE '$year_now'";
}
$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 '$type'
and ((doc_receive.staff_id = '$session_staffid')or(doc_receive.owner = '$session_staffid'))
";
//and document.docid is not null
$result_owner = mysql_query($sql_owner_doc)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
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;
}
}
$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
";
$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];
}
$time_end = getmicrotime(); writetime2db($time_start,$time_end,'การอ่านสถานะและประวัติทะเบียน');
if($type=="all"){$type="%%";}
$sql="
SELECT
$distinct_mode
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`
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_p
$search_code_r
$search_code_s
$search_code_k
$search_code_t
$search_code_ss
$search_code_gs
$order_code
";
$result_row1 = mysql_query($sql)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
if($result_row1){
$row_all= mysql_num_rows($result_row1);
};
/*
$row_c= mysql_fetch_assoc($result_row)
$row_all=$row_c[all_num];
$result = mysql_query($sql)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$row_all= mysql_num_rows($result);
*/
$nump=0;
$numid=0;
if($stype=="%%"){$type="all";}
/////////////////////////// PAGE CODE
if(!$page){$page="1";}
if(!$perpage){$perpage="20";}
//if($_GET['type']!="get"){$page="1";}
$lastpage=intval($row_all/$perpage)+1;
$limit_start=($page-1)*$perpage;
$limit_code=" limit $limit_start , $perpage ";
$time_start = getmicrotime();
$sql.=" $limit_code";
$result3 = mysql_query($sql)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$time_end = getmicrotime(); writetime2db($time_start,$time_end,'การเรียกรายงานแสดงหน้าเวบ');
?>
<? if($type=="%%"){$type="all";}?>
<? echo "<b>ทะเบียนหนังสือประจำปี ".($year_select+543)."</b>" ;?>
<? if($arrange=="D"){$arrange_now="A";}else{$arrange_now="D";} ?>
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<? if(($session_order)||($order)){?>
<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?>&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?>&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;"/>-->
<?=$page?>
/
<?=$lastpage?>
<? if($page<$lastpage){?>
<a href="<?=$PHP_SELF?>?type=<?=$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?>&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>
<? if(!$arrange){$arrange="A";} ?>
<table width="99%" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td align="right" >
<table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr>
<? // if($type=="all"){?>
<td width="2%" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg"> </td>
<td width="2%" 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></td>
<? //}?>
<?// if($order){ if($arrange=="D"){$arrange_code="asc";$arrange="A";}else{$arrange_code="desc";$arrange="D";} } ?>
<? if(($c_select[c1])){ ?>
<td width="2%" 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="8%" 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"){?><img src="../../images/sort_<?=$arrange_code?>.gif" border=0><?}?></a></strong></td>
<? }?>
<? if(($c_select[c3]) || (!$rs_row)){ ?>
<td width="10%" 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"){?><img src="../../images/sort_<?=$arrange_code?>.gif" border=0><?}?></a></strong></td>
<? } ?>
<? if(($c_select[c4]) || (!$rs_row)){ ?>
<td width="9%" 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"){?><img src="../../images/sort_<?=$arrange_code?>.gif" border=0><?}?></a></strong></td>
<? }?>
<? if(($c_select[c5]) || (!$rs_row)){ ?>
<td width="16%" 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"){?><img src="../../images/sort_<?=$arrange_code?>.gif" border=0><?}?></a></strong></td>
<? }?>
<? if(($c_select[c6]) || (!$rs_row)){ ?>
<td width="16%" 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"){?><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="<?=$w?>" 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"){?><img src="../../images/sort_<?=$arrange_code?>.gif" border=0><?}?></a></strong></td>
<? }?>
<!--<? if(($c_select[c8]) || (!$rs_row)){ ?>
<td width="12" 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></td>
<? }?>-->
<? if(($c_select[c9]) || (!$rs_row)){ ?>
<td width="2%" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg" style="width:80px;"> </td>
<td width="2%" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg" > </td>
<td width="2%" 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]){?>
<td width="2%" align="center" valign="top" background="../../images/bg_tr_blue.gif" class="executive_bg" > </td>
<?}?>
<? } ?>
-->
</tr>
<?
while($ers = mysql_fetch_assoc($result3)){$numid++;
$nump++;
if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
if($owner_deadline[$ers[id]]){
$alert_code="#FFE8E8";
$alert_code_h="#FC7465";
$late_code="#FFF8F4";
$bgtemp=$bgcolor;
//if( ($owner_remain[$ers[id]]>$owner_alert[$ers[id]]) && ($owner_remain[$ers[id]]>=0) ){
//echo"if( (".$owner_remain[$ers[id]]."<=".$owner_alert[$ers[id]].") && (".$owner_remain[$ers[id]]."<=0) ){";
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";
}
}
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++;}
}
?>
<tr bgcolor="<?=$bgcolor?>" <? if(($session_permit[200]) || ($owner_doc[$ers[id]])){?>onmouseover='mOvr(this,"dbf2ae");' onmouseout='mOut(this,"<?=$bgcolor?>");' onClick="window.location.replace('<?=$PHP_SELF?>?action=view&id=<?=$ers[id]?>&type=<?=$ers[type]?>')"<? }else{?>style="cursor:defualt"<? }?> height="48:pixel">
<?
if($owner_deadline[$ers[id]]){
$bgcolor=$bgtemp;
}
?>
<?// if($type=="all"){?>
<td align="center" valign="top" >
<? if($ers[type]=="get"){?>
<img src="../../images/email_fwd2.gif" width="15" height="12" />
<? }elseif($ers[type]=="send"){?>
<img src="../../images/email_reply2.gif" width="15" height="12" />
<? }elseif($ers[type]=="circular"){?>
<img src="../../images/email_circular.gif" width="15" height="12" />
<? }?> </td>
<td align="center" valign="top" class="index" ><? // if($session_staffid==$ers[owner]){ || ($read_status[$ers[id]]) ?>
<!--<img src="../../images/user1_add.png" width="16" height="16" border="0" title="ผู้บันทึก"/>-->
<? if(($read_status[$ers[id]]=="0") || (!$read_status[$ers[id]])){?>
<img src="../../images/email_close.gif" width="15" height="12" border="0" title="ใหม่"/>
<? }else if($read_status[$ers[id]]=="100"){?>
<img src="../../images/email_open.gif" width="15" height="12" border="0" title="รับทราบ"/>
<? }else if($read_status[$ers[id]]=="200"){?>
<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]?>">
<?=$ers[docid]?>
<? if($ers[speed]=="100") { ?><br><font color="#FF0000">ด่วน</font><? } ?>
<? if($ers[speed]=="200") { ?><br><STRONG><font color="#FF0000">ด่วนมาก</font></STRONG><? } ?>
<? if($ers[speed]=="300") { ?><br><STRONG><font color="#CC0000">ด่วนที่สุด*** </font></STRONG><? } ?>
<? if($ers[secret]=="100") { ?><br><STRONG>(ลับ)</STRONG><? } ?>
<? if($ers[secret]=="200") { ?><br><STRONG>(ลับมาก)</STRONG><? } ?>
<? if($ers[secret]=="300") { ?><br><STRONG>(ลับที่สุด)</STRONG><? } ?></td>
<? }?>
<? if($ers['doc_status']!="w"){ ?>
<? if(($c_select[c3]) || (!$rs_row)){ ?>
<td align="left" valign="top" class="index" title="<?=$ers[refid]?>">
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){?><B><?}?>
<? if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){?><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="left" valign="top" class="index" title="<?=$ndate?>" >
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){?><B><?}?>
<? if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){?><b><? }?>
<?=$ndate?>
</td>
<? }?>
<? if(($c_select[c5]) || (!$rs_row)){ ?>
<td align="left" valign="top" class="index" title="<?=$ers[sending]?>">
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){?><B><?}?>
<? if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){?><b><? }?>
<?=$ers[sending]?>
</td>
<? }?>
<? if(($c_select[c6]) || (!$rs_row)){ ?>
<td align="left" valign="top" class="index" title="<?=$ers[getting]?>" >
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){?><B><?}?>
<? if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){?><b><? }?>
<?=$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="left" 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="วันดำเนินการ <?=daythai($owner_deadline[$ers[id]])?>
<? if($owner_remain[$ers[id]]>="0"){?> เหลือเวลา <?=$owner_remain[$ers[id]]?> วัน<? }?>" />
<? } ?><? }?>
<? if( ($owner_doc[$ers[id]] ) && (!$read_status[$ers[id]]) ){?><B><?}?>
<? if( (($session_permit[100]) ||($session_permit[200]) ||($session_permit[300]) ) && (!$read_status[$ers[id]]) ){?><b><? }?>
<? if($max_to<128){$max_to=128;} ?>
<?=trimtxt($ers[title],intval($max_to*1.4))?>
<? if($edittime[$ers[id]]){echo "<i><u>(แก้ไขครั้งที่ ".$edittime[$ers[id]].")</u></i>";} ?>
</td>
<? }?>
<? }else{?>
<td align="center" valign="middle" class="index" colspan="<?=$col_rows?>" > <strong> เลขทะเบียนนี้ ถูกยกเลิกโดย ผู้ใช้ระบบ "<?=$del_label[$ers[id]]?>" </strong></td>
<? }?>
<? if(($c_select[c9]) || (!$rs_row)){ ?>
<td align="left" valign="top" class="index">
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr style="cursor:default" >
<?
if($owner_deadline[$ers[id]]){
$bgcolor=$bgtemp;
}
?>
<? if(($c_select[c9]) || (!$rs_row)){ ?>
<td align="left" valign="top" class="index">
<? if(($prd[$ers[id]]) && ($session_permit[300])) {?>
<img src="../../images/ico_prisoner.gif" width="12" height="16" border="0" title="มีกิจกรรมสำหรับ ทะเบียนหนังสือนี้"/>
<? } ?> </td>
<? if(($prd[$ers[id]]>1) && ($session_permit[300])) {?>
<td align="left" valign="top" class="index"><? if( $prd[$ers[id]] >1) { echo "(".intval($prd[$ers[id]]).")"; } ?></td>
<? } ?>
<? }?>
<? if(($c_select[c10]) || (!$rs_row)){ ?>
<? }?>
</tr>
</table></td>
<td align="left" valign="top" class="index"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" class="index"><? if($attachment[$ers[id]]){ ?>
<? if($attachment[$ers[id]]=="1") {?>
<a href="download_file.php?reading=<?=$attach_link[$ers[id]]?>" target="_blank" >
<? }?>
<img src='../../images/file_attach.gif' border="0" alt="เอกสารแนบ : <?=$attach_name[$ers[id]]?>"/>
<? if($attachment[$ers[id]]=="1") {?>
</a>
<?}?>
<?}?></td>
<td align="left" valign="top" class="index"><?
if($attachment[$ers[id]]){
if($attachment[$ers[id]]>"1")
{echo "(".$attachment[$ers[id]].")";}
}?></td>
</tr>
</table></td>
<td align="left" valign="top" class="index"><? if($ers[comment]){ ?>
<img src='../../images/ico_warning.gif' width="16" height="15" title="<?=$ers[comment]?>"/>
<? }?></td>
<? }?>
</tr>
<? } ?>
<? if($nump=="0") {?>
<tr bgcolor="#F2F2F2">
<td colspan="14" align="center">-- ยังไม่มีข้อมูล --</td>
</tr>
<? } ?>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>