Viewing file: showSelectSignDoc.php (10.67 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
header("content-type: application/x-javascript; charset=TIS-620");
?>
<script src="getinfo.js"></script>
<script>
function On_Year(DLCID,MaxDocGroup,DlcPS2,y){
searchYear=y;
if (searchYear.length == 4) {
ShowInfoSendDoc(DLCID,MaxDocGroup,DlcPS2);
}
}
</script>
<?php
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../class/clsDocLinePosition.php";
include_once "../class/clsDocLineConfig.php";
include_once "../class/clsReceiveSendType.php";
include_once "../class/clsDocType.php";
include_once "../link/functionshow.php";
include_once "../class/clsDocattatchesTmp.php";
include_once "../class/clsDocuments.php";
include_once "../class/clsDocSpeedLevel.php";
include_once "../class/clsDocSecreLevel.php";
include_once "../class/clsDocReceiveSend.php";
include_once "../class/clsDocWSign.php";
include_once "funct.php";
include_once "../link/keyThai.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oDP3 = new Department($oC);
$oPS = new person($oC);
$oDlc = new DocLineConfig($oC);
$oDlc2 = new DocLineConfig($oC);
$oDlp = new docLinePosition($oC);
$oDlp1 = new docLinePosition($oC);
$oRSt = new receiveSendType($oC);
$oDt = new doctype($oC);
$oDtmp = new DocattatchesTmp($oC);
$oDoc = new Documents($oC);
$oDoc1 = new Documents($oC);
$oDoc2 = new Documents($oC);
$oDoc3 = new Documents($oC);
$oDoc4 = new Documents($oC);
$oDoc5 = new Documents($oC);
$oDsl = new DocSpeedLevel($oC);
$oDcl = new DocSecretLevel($oC);
$oDsl2 = new DocSpeedLevel($oC);
$oDcl2 = new DocSecretLevel($oC);
$oRs = new DocReceiveSend($oC);
$oRs1 = new DocReceiveSend($oC);
$oRs4 = new DocReceiveSend($oC);
$oRs5 = new DocReceiveSend($oC);
$oRs6 = new DocReceiveSend($oC);
$oRs7 = new DocReceiveSend($oC);
$MaxDocGroup=$oDP->SearchMaxDocGroup();
$InputThai=$oSys->SearchByInputThai();
$oDws = new docwsign($oC);
$oDlc->SearchByKey($DLCID); $oDlc->GetRecord();
$oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord();
?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
<tr><td align="right"><font color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>" size="2">
<?php if($oDlp1->DlpPID!="0"){ ?>รายการหนังสือ
<select name="s" onChange="ShowInfoSign('<?php echo $DLCID; ?>','<?php echo $MaxDocGroup; ?>','<?php echo $DlcPS2; ?>')" id="s">
<option value="1" <?php if($s=="" || $s=="1"){ echo "selected"; }?>>ที่ลงนามแล้ว</option>
<option value="2" <?php if($s=="2"){ echo "selected"; }?>>ที่รอเสนอผอก./หน.</option>
</select>
<br>
<?php }else{ ?><input type="hidden" name="s" value="<? echo $s; ?>"> <? } ?>
ค้นหาหนังสือ (เรื่อง/ว่าด้วย)</font> <input name="searchName" type="text" size="25" value="<?php echo a2th($searchName); ?>"> <font color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>" size="2"> (ที่/ฉบับที่/ครั้งที่/เลขที่)</font> <input name="searchNo" type="text" size="20" value="<?php echo a2th($searchNo); ?>"> <br>
ประจำเดือน</font>
<select name="monthe" onChange="ShowInfoSign('<?php echo $DLCID; ?>','<?php echo $MaxDocGroup; ?>','<?php echo $DlcPS2; ?>')">
<option value="01" <?php if($monthe=="01"){ echo "selected"; }?>>ม.ค.</option>
<option value="02" <?php if($monthe=="02"){ echo "selected"; }?>>ก.พ.</option>
<option value="03" <?php if($monthe=="03"){ echo "selected"; }?>>มี.ค.</option>
<option value="04" <?php if($monthe=="04"){ echo "selected"; }?>>เม.ย.</option>
<option value="05" <?php if($monthe=="05"){ echo "selected"; }?>>พ.ค.</option>
<option value="06" <?php if($monthe=="06"){ echo "selected"; }?>>มิ.ย.</option>
<option value="07" <?php if($monthe=="07"){ echo "selected"; }?>>ก.ค.</option>
<option value="08" <?php if($monthe=="08"){ echo "selected"; }?>>ส.ค.</option>
<option value="09" <?php if($monthe=="09"){ echo "selected"; }?>>ก.ย.</option>
<option value="10" <?php if($monthe=="10"){ echo "selected"; }?>>ต.ค.</option>
<option value="11" <?php if($monthe=="11"){ echo "selected"; }?>>พ.ย.</option>
<option value="12" <?php if($monthe=="12"){ echo "selected"; }?>>ธ.ค.</option>
</select>
<input name="searchYear" type="text" size="5" maxlength="5" value=<?php if($searchYear!=""){ echo a2th($searchYear); }else{ echo a2th(Date('Y')+543); } ?> onKeyUp="On_Year('<?php echo $DLCID; ?>','<?php echo $MaxDocGroup; ?>','<?php echo $DlcPS2; ?>')" onKeyPress="event.keyCode=CheckInput(event.keyCode,'<?php echo $InputThai; ?>'); return event.keyCode;">
<input name="searchNamesub" type="button" value="ค้นหา" onClick="ShowInfoSign('<?php echo $DLCID; ?>','<?php echo $MaxDocGroup; ?>','<?php echo $DlcPS2; ?>')">
</td></tr>
</table>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DADADA" style="border-collapse:collapse" background="<?php if($DtID=="5" || $DtID=="6" || $DtID=="7" || $DtID=="9" || $DtID=="10" || $DtID=="11" || $DtID=="12" || $DtID=="13"){ echo "../picture/table_header_bg6.gif"; }else{ echo "../picture/table_header_bg5.gif"; }?>">
<?php $flagshow=1;?>
<tr height=22>
<td width="15%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>ที่/ฉบับที่/ครั้งที่/เลขที่</strong></font></td>
<td width="10%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>จาก/ที่มา (ต้นเรื่อง)</strong></font></td>
<td width="26%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>เรื่อง/ว่าด้วย (ชนิดหนังสือ)</strong></font></td>
<td width="10%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>วันที่ลงนาม</strong></font></td>
</tr>
<?php
//--------------------------------find count
$numrow=0;
if($s=="2"){
$oRs4->SearchByDocGroupDlcIDDrsReceiveDlcID2Status2DrsSendDatesearchNoforWSign($MaxDocGroup,$DLCID,$DlcPS2,$monthe,th2a($searchYear),th2a($searchName),th2a($searchNo));
}else{
$oRs4->SearchByDocGroupDlcIDDrsReceiveDlcID2Status2DrsSendDatesearchNo($MaxDocGroup,$DLCID,$DlcPS2,$monthe,th2a($searchYear),th2a($searchName),th2a($searchNo));
}
$numRow = $oRs4->NumRow();
$page_size = 10;
$total_page = (int)($numRow/$page_size);
if(($numRow%$page_size) != 0)
$total_page++;
if(isset($page_id))
$start = $page_size*($page_id-1);
else {
$page_id = 1;
$start = 0;
}
//echo "numrow=".$numrow;
//-------------------------------
if($s=="2"){
$oRs5->SearchByDocGroupDlcIDDrsReceiveDlcID2Status2LimitDrsSendDatesearchNoforWSign($MaxDocGroup,$DLCID,$DlcPS2, $start, $page_size,$monthe,th2a($searchYear),th2a($searchName),th2a($searchNo));
}else{
$oRs5->SearchByDocGroupDlcIDDrsReceiveDlcID2Status2LimitDrsSendDatesearchNo($MaxDocGroup,$DLCID,$DlcPS2, $start, $page_size,$monthe,th2a($searchYear),th2a($searchName),th2a($searchNo));
}
$z=0;
while($oRs5->GetRecord()){
$oDoc3->SearchByKey($oRs5->DocID);
$oDoc3->GetRecord();
if(($z%2) == 0)
echo "<tr bgcolor=\"#FFFFFF\" height=22 >";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_16"]."\" height=22>";
?>
<td width="13%"> <?php echo $oDoc3->DocNo; ?></td>
<td width="18%" >
<?php
if($oDoc3->DtID=="1" || $oDoc3->DtID=="2" || $oDoc3->DtID=="14"){
echo " ".$oDoc3->DocFrom."<br>";
}else{
if($oDoc3->DocPID=="0"){
$oDlc2->SearchByKey($oDoc3->DlcID); $oDlc2->GetRecord();
$oDlp->SearchByKey($oDlc2->DlpID); $oDlp->GetRecord();
echo " ".$oDoc3->DocFrom."<br>";
echo " (".$oDlp->DlpName.")";
}else{
$oDoc5->SearchByKey($oDoc3->DocPID); $oDoc5->GetRecord();
$oDlc2->SearchByKey($oDoc5->DlcID); $oDlc2->GetRecord();
$oDlp->SearchByKey($oDlc2->DlpID); $oDlp->GetRecord();
echo " ".$oDoc3->DocFrom."<br>";
echo " (".$oDlp->DlpName.")";
}
}
?>
</td>
<td width="30%">
<a href="showDetailSignDoc.php?DocID=<?php echo $oDoc3->DocID;?>&DrsID=<?php echo $oRs5->DrsID; ?>&flagshow=<?php echo $flagshow; ?>&monthe=<?php echo $monthe;?>&searchYear=<?php echo $searchYear; ?>&searchName=<?php echo $searchName; ?>&searchNo=<?php echo $searchNo; ?>&s=<?php echo $s; ?>"><?php echo $oDoc3->DocSubject; ?></a>
<font color="<?php echo $GLOBALS["COLOR_FONT_5"]; ?>" size="2"><?php $oDt->SearchByKey($oDoc3->DtID); $oDt->GetRecord(); echo "(".$oDt->DtName.")"; ?></font>
<?php if($oDlp1->DlpPID!="0"){ if($DLCID==$oRs5->DlcID){ echo " <font color=\"#029b0a\"><storng>[รักษาการ]</strong></font>"; }} ?>
<?php if($oDlp1->DlpPID=="0"){ if($DlcPS2==$oRs5->DlcID){ echo " <font color=\"#029b0a\"><storng>[รักษาการ]</strong></font>"; }} ?>
<?php if($oRs5->DrsWSign=='Y'){ echo " (หนังสือรอเสนอผอก./หน.)"; } ?>
</td>
<td align="center">
<?php
if($s==2){
if($oRs5->signDateTime!="0000-00-00 00:00:00"){
list($DocD,$DocT) = split(' ',$oRs5->signDateTime);
}
}else{
if($oRs5->DrsSendDate!="0000-00-00 00:00:00"){
list($DocD,$DocT) = split(' ',$oRs5->DrsSendDate);
}
}
echo abbreDate2($DocD,'/')."<br>".a2th($DocT);
?>
</td>
</tr>
<?php
$z++; } ?>
<?php if($z=="0"){?>
<tr height=22><td align="center" bgcolor="#FFFFFF" colspan="4"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีรายการหนังสือที่ลงนามแล้ว **</font></td></tr>
<?php } ?>
<tr height=22 bgcolor="#DADADA"><td align="right" colspan="7"><strong>หน้า-></strong>
<?php
for ($num=1; $num<=$total_page; $num++) {
if($num == $page_id)
echo a2th($num)." ";
else {
?>
<a href="signDoc.php?page_id=<?php echo $num;?>&flagshow=<?php echo $flagshow; ?>&monthe=<?php echo $monthe;?>&searchYear=<?php echo $searchYear; ?>&searchName=<?php echo $searchName; ?>&searchNo=<?php echo $searchNo; ?>"><?php echo '[ '.a2th($num).' ]'; if($num==14){echo "<br>";}?></a>
<?php
}
}
?> </td></tr>
</table>
|