Viewing file:  signDoc2.php (19.11 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "template.php";
include_once "../class/clsTable.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 "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);
$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();
$DLCID="27";
include_once "selectposition.php";
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
</head>
<style>
/*
<!--
A:link {text-decoration: none; color: #000000}
A:visited {text-decoration: none; color: #000000}
A:hover {text-decoration: none; font-weight: bold; color: #000066}
-->
*/
</style>
<body>
<table width="100%" align="center">
<tr><td >
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="signDoc.php">ลงนาม</a>
</font></legend>
<form name="ff" METHOD="POST" action="signDoc2.php">
<table align="center" width="98%" >
<tr>
<td width="68%" height="25"><img src="../picture/official_letter.gif" border="0" >
<font color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>" size="3"><strong>
ลงนามหนังสือ</strong></font> </td>
<td width="23%" align="right"> </td>
<td width="9%" align="right" > </td>
</tr>
<tr>
<td colspan="3"><hr color="#000099"></hr>
</td>
</tr>
</table><br>
<font color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>" size="2"><strong>
รายการหนังสือที่ยังไม่ได้ลงนาม</strong></font>
<table width="99%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DADADA" style="border-collapse:collapse" background="<? if($DtID=="6" || $DtID=="7" || $DtID=="9"){ echo "../picture/table_header_bg2.gif"; }else{ echo "../picture/table_header_bg.gif"; }?>">
<tr height=22>
<td width="13%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>ที่/ฉบับที่/ครั้งที่/เลขที่</strong></font></td>
<td width="15%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>จาก/ที่มา (ต้นเรื่อง)</strong></font></td>
<td width="29%" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_1"]; ?>" size="2"><strong>เรื่อง/ว่าด้วย (ชนิดหนังสือ)</strong></font></td>
<td width="2%" align="center"><img src="../picture/rapid0.jpg" border="0" ></td>
<td width="2%" align="center"><img src="../picture/secret0.jpg" border="0" ></td>
</tr>
<? //-------------------------other doc------------------------------------------------------------------------------------
$oDlc->SearchByKey($DLCID); $oDlc->GetRecord();
$oDlp1->SearchByKey($oDlc->DlpID); $oDlp1->GetRecord();
if($oDlp1->DlpPID!="0"){
$DlcPS2=$DLCID;
}else{
$DlcPS2=$oDlc2->SearchDlc2($oDlc->DlcSeq,$oDlp1->DlpPID,$oDlc->deptId);
}
$oDoc->SearchByDocGroupDsID2DocIDDlcIDDrsReceiveDlcID2Status2($MaxDocGroup,$DLCID,$DlcPS2);
$i=0;
while($oDoc->GetRecord()){
if(($i%2) == 0)
echo "<tr bgcolor=\"#FFFFFF\" height=22 >";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_16"]."\" height=22 align=\"left\">";
?>
<td> <? echo $oDoc->DocNo; ?></td>
<td align="left">
<?
if($oDoc->DtID=="1" || $oDoc->DtID=="2" || $oDoc->DtID=="14"){
echo " ".$oDoc->DocFrom."<br>";
}else{
if($oDoc->DocPID=="0"){
$oDlc2->SearchByKey($oDoc->DlcID); $oDlc2->GetRecord();
$oDlp->SearchByKey($oDlc2->DlpID); $oDlp->GetRecord();
$oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord();
echo " ".$oDP->deptName."<br>";
echo " (".$oDlp->DlpName.")";
}else{
$oRs6->SearchByDocIDDocGroupStatus($oDoc->DocID,$oDoc->DocGroup,0); $oRs6->GetRecord();
$oRs7->SearchByKey($oRs6->DrsFromDrsID); $oRs7->GetRecord();
$oDoc2->SearchByKey($oRs7->DocID); $oDoc2->GetRecord();
$oDlc2->SearchByKey($oDoc2->DlcID); $oDlc2->GetRecord();
$oDlp->SearchByKey($oDlc2->DlpID); $oDlp->GetRecord();
$oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord();
echo " ".$oDP->deptName."<br>";
echo " (".$oDlp->DlpName.")";
}
}
?>
</td>
<td align="left"> <a href="showSignDoc.php?DocID=<?php echo $oDoc->DocID;?>&DrsID=<? echo $oDoc->DrsID; ?>"><? echo $oDoc->DocSubject; ?><? //if($DtID=="13"){ echo "ชื่อผู้ได้รับการรับรอง<br>".$oDoc->CertificatePs; }else{ echo $oDoc->DocSubject; } ?></a>
<font color="<?php echo $GLOBALS["COLOR_FONT_5"]; ?>" size="2"><? $oDt->SearchByKey($oDoc->DtID); $oDt->GetRecord(); echo "(".$oDt->DtName.")"; ?></font>
<? if($oDlp->DlpPID!="0"){ if($DLCID==$oDoc->DlcID){ echo " <font color=\"#029b0a\"><storng>[รักษาการ]</strong></font>"; }} ?>
<? if($oDlp->DlpPID=="0"){ if($DlcPS2==$oDoc->DlcID){ echo " <font color=\"#029b0a\"><storng>[รักษาการ]</strong></font>"; }} ?>
</td>
<? if($oDoc->DslID=="0"){ $rapid="../picture/rapid0.jpg"; $rapidname=$oDsl2->SearchName(0); }else if($oDoc->DslID=="1"){ $rapid="../picture/rapid1.jpg"; $rapidname=$oDsl2->SearchName(1); }else if($oDoc->DslID=="2"){ $rapid="../picture/rapid2.jpg"; $rapidname=$oDsl2->SearchName(2); }else if($oDoc->DslID=="3"){ $rapid="../picture/rapid3.jpg"; $rapidname=$oDsl2->SearchName(3); }else{ $rapid="../picture/blank.gif"; $rapidname=""; }?>
<td align="center"><img src="<? echo $rapid; ?>" title="<? echo $rapidname; ?>" border="0" ></td>
<? if($oDoc->DclID=="0"){ $secret="../picture/secret0.jpg"; $secretname=$oDcl2->SearchName(0); }else if($oDoc->DclID=="1"){ $secret="../picture/secret1.jpg"; $secretname=$oDcl2->SearchName(1); }else if($oDoc->DclID=="2"){ $secret="../picture/secret2.jpg"; $secretname=$oDcl2->SearchName(2); }else if($oDoc->DclID=="3"){ $secret="../picture/secret3.jpg"; $secretname=$oDcl2->SearchName(3); }else if($oDoc->DclID=="4"){ $secret="../picture/secret4.jpg"; $secretname=$oDcl2->SearchName(4); }else{ $secret="../picture/blank.gif"; $secretname=""; }?>
<td align="center"><img src="<? echo $secret; ?>" title="<? echo $secretname; ?>" border="0" ></td>
</tr>
<? $i++; } ?>
</table>
<table width="99%" align="center" border=0 cellpadding="0" cellspacing="0" bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_13'];?>" height="22">
<? if($i=="0"){?>
<tr height=22><td align="center" bgcolor="#FFFFFF"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีรายการหนังสือที่ลงนาม **</font></td></tr>
<? } ?>
<tr height=22><td align="right"> </td></tr>
<tr height=22 bgcolor="#FFFFFF">
<td colspan="4" valign="bottom"><br>
<hr color="#000099"></hr></td>
</tr>
</table>
<br><? if($monthe==""){ $monthe=Date('m'); } if($searchYear==""){ $searchYear=Date('Y')+543; } //echo "month=".$monthe." "."Year=".$searchYear;?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#DADADA" style="border-collapse:collapse">
<tr height=27 bgcolor="#FFFFFF" ><td align="left" >
<font color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>" size="2"><strong>
<a id="openshow" <? if($flagshow=="1"){ ?>style="display:none; cursor:pointer" <? }else{ ?> style="display:''; cursor:pointer" <? }?> onclick="up_downList('<? if($flagshow=="1"){ echo "up"; }else{ echo "up"; }?>')"><img src="../picture/downshow.gif" title="แสดง" border="0" > <U>แสดงรายการหนังสือที่ลงนามแล้วทั้งหมด</U></a>
<a id="closeshow" <? if($flagshow=="1"){ ?>style="display:''; cursor:pointer" <? }else{ ?>style="display:none; cursor:pointer" <? }?> title="ซ่อน" onclick="up_downList('<? if($flagshow=="1"){ echo "down"; }else{ echo "down"; }?>')"><img src="../picture/downshow.gif" title="ซ่อน" border="0" > <U>ซ่อนรายการหนังสือที่ลงนามแล้วทั้งหมด</U></a>
</strong></font>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" id="showtable2" <? if($flagshow=="1"){ ?>style="display:''; border-collapse:collapse" <? }else{ ?>style="display:none; border-collapse:collapse" <? }?>>
<tr><td align="right"><font color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>" size="2">
ค้นหาหนังสือ (เรื่อง/ว่าด้วย)</font> <input name="searchName" type="text" size="25" value="<? echo a2th($searchName); ?>"> <input name="searchNamesub" type="submit" value="ค้นหา" onClick="changeS2()">
ประจำเดือน</font>
<select name="monthe" onChange="On_Month()">
<option value="01" <? if($monthe=="01"){ echo "selected"; }?>>ม.ค.</option>
<option value="02" <? if($monthe=="02"){ echo "selected"; }?>>ก.พ.</option>
<option value="03" <? if($monthe=="03"){ echo "selected"; }?>>มี.ค.</option>
<option value="04" <? if($monthe=="04"){ echo "selected"; }?>>เม.ย.</option>
<option value="05" <? if($monthe=="05"){ echo "selected"; }?>>พ.ค.</option>
<option value="06" <? if($monthe=="06"){ echo "selected"; }?>>มิ.ย.</option>
<option value="07" <? if($monthe=="07"){ echo "selected"; }?>>ก.ค.</option>
<option value="08" <? if($monthe=="08"){ echo "selected"; }?>>ส.ค.</option>
<option value="09" <? if($monthe=="09"){ echo "selected"; }?>>ก.ย.</option>
<option value="10" <? if($monthe=="10"){ echo "selected"; }?>>ต.ค.</option>
<option value="11" <? if($monthe=="11"){ echo "selected"; }?>>พ.ย.</option>
<option value="12" <? if($monthe=="12"){ echo "selected"; }?>>ธ.ค.</option>
</select>
<input name="searchYear" type="text" size="5" maxlength="5" value=<? if($searchYear!=""){ echo a2th($searchYear); }else{ echo a2th(Date('Y')+543); } ?> onKeyUp="On_Year()" onKeyPress="event.keyCode=CheckInput(event.keyCode,'<? echo $InputThai; ?>'); return event.keyCode;"></td></tr>
</table>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DADADA" id="showtable" <? if($flagshow=="1"){ ?>style="display:''; border-collapse:collapse" <? }else{ ?>style="display:none; border-collapse:collapse" <? }?> background="<? 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"; }?>">
<? $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>
<?
//--------------------------------find count
$numrow=0;
$oRs4->SearchByDocGroupDlcIDDrsReceiveDlcID2Status2DrsSendDate($MaxDocGroup,$DLCID,$DlcPS2,$monthe,th2a($searchYear),th2a($searchName));
while($oRs4->GetRecord()){
$numrow++;
}
$numRow = $numrow;
//echo "===========".$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;
//-------------------------------
$oRs5->SearchByDocGroupDlcIDDrsReceiveDlcID2Status2LimitDrsSendDate($MaxDocGroup,$DLCID,$DlcPS2, $start, $page_size,$monthe,th2a($searchYear),th2a($searchName));
$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%"> <? echo $oDoc3->DocNo; ?></td>
<td width="18%" >
<?
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();
$oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord();
echo " ".$oDP->deptName."<br>";
echo " (".$oDlp->DlpName.")";
}else{
$oRs6->SearchByDocIDDocGroupStatus($oRs5->DocID,$oRs5->DocGroup,0); $oRs6->GetRecord();
$oRs7->SearchByKey($oRs6->DrsFromDrsID); $oRs7->GetRecord();
$oDoc2->SearchByKey($oRs7->DocID); $oDoc2->GetRecord();
$oDlc2->SearchByKey($oDoc2->DlcID); $oDlc2->GetRecord();
$oDlp->SearchByKey($oDlc2->DlpID); $oDlp->GetRecord();
$oDP->SearchByKey($oDlc2->deptId); $oDP->GetRecord();
echo " ".$oDP->deptName."<br>";
echo " (".$oDlp->DlpName.")";
}
}
?>
</td>
<td width="30%">
<a href="showDetailSignDoc.php?DocID=<?php echo $oDoc3->DocID;?>&DrsID=<? echo $oRs5->DrsID; ?>&flagshow=<? echo $flagshow; ?>&monthe=<? echo $monthe;?>&searchYear=<? echo $searchYear; ?>&searchName=<? echo $searchName; ?>"><? echo $oDoc3->DocSubject; ?></a>
<font color="<?php echo $GLOBALS["COLOR_FONT_5"]; ?>" size="2"><? $oDt->SearchByKey($oDoc3->DtID); $oDt->GetRecord(); echo "(".$oDt->DtName.")"; ?></font>
<? if($oDlp->DlpPID!="0"){ if($DLCID==$oRs5->DlcID){ echo " <font color=\"#029b0a\"><storng>[รักษาการ]</strong></font>"; }} ?>
<? if($oDlp->DlpPID=="0"){ if($DlcPS2==$oRs5->DlcID){ echo " <font color=\"#029b0a\"><storng>[รักษาการ]</strong></font>"; }} ?>
</td>
<td align="center">
<?
if($oRs5->DrsSendDate!="0000-00-00 00:00:00"){
list($DocD,$DocT) = split(' ',$oRs5->DrsSendDate);
echo abbreDate2($DocD,'/')."<br>".a2th($DocT);
}
?>
</td>
</tr>
<?
$z++; } ?>
<? 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>
<? } ?>
<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=<? echo $flagshow; ?>&monthe=<? echo $monthe;?>&searchYear=<? echo $searchYear; ?>&searchName=<? echo $searchName; ?>"><?php echo '[ '.a2th($num).' ]'; if($num==14){echo "<br>";}?></a>
<?php
}
}
?> </td></tr>
</table>
</td></tr>
</table><input type="hidden" name="flagshow" value="<? echo $flagshow; ?>">
</form>
</fieldset>
<table width="99%" border="0" align="center">
<tr>
<td width="134" align="left"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2"> <strong>หมายเหตุ
: </strong> </font></td>
<td width="1070" align="left"> <font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">คลิกที่เรื่องหนังสือเพื่อลงนาม</font></td>
</tr>
<tr>
<td width="134" align="left"> </td>
<td colspan="2" align="left">
<font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">ชั้นความเร็ว
<? $oDsl->RSDocSpeedLevel(); $r=0; while($oDsl->GetRecord()){
if($oDsl->DslID=="0"){ $picsp="../picture/rapid0.jpg"; }else if($oDsl->DslID=="1"){ $picsp="../picture/rapid1.jpg"; }else if($oDsl->DslID=="2"){ $picsp="../picture/rapid2.jpg"; }else if($oDsl->DslID=="3"){ $picsp="../picture/rapid3.jpg"; } else if($oDsl->DslID=="4"){ $picsp="../picture/rapid4.jpg"; }
?> <img src="<? echo $picsp; ?>" border="0" > <? echo " ".$oDsl->DslName." "; $r++; }?>
</font></td>
</tr>
<tr>
<td width="134"> </td>
<td colspan="2" align="left">
<font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">ชั้นความลับ
<? $oDcl->RSDocSecretLevel(); $r=0; while($oDcl->GetRecord()){
if($oDcl->DclID=="0"){ $piccl="../picture/secret0.jpg"; }else if($oDcl->DclID=="1"){ $piccl="../picture/secret1.jpg"; }else if($oDcl->DclID=="2"){ $piccl="../picture/secret2.jpg"; }else if($oDcl->DclID=="3"){ $piccl="../picture/secret3.jpg"; } else if($oDcl->DclID=="4"){ $piccl="../picture/secret4.jpg"; }
?><img src="<? echo $piccl; ?>" border="0" > <? echo " ".$oDcl->DclName." "; $r++; }?>
</font></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<? ?>
<script language="javascript">
function showDoc(){
document.ff.submit();
}
function up_downList(status){
if(status=='up'){
closeshow.style.display='';
openshow.style.display='none';
showtable.style.display='';
showtable2.style.display='';
}else{
openshow.style.display='';
closeshow.style.display='none';
showtable.style.display='none';
showtable2.style.display='none';
}
}
function On_Month(){
searchYear=document.ff.searchYear.value;
if (searchYear=="") {
alert('กรุณากรอกปี');
document.ff.searchYear.focus();
return false ;
}
document.ff.flagshow.value=1;
document.ff.submit();
}
function On_Year(){
searchYear=document.ff.searchYear.value;
if (searchYear.length == 4) {
document.ff.flagshow.value=1;
document.ff.submit();
}
}
function changeS2(){
if(document.ff.searchName.value==""){
document.ff.searchName.value="";
}
document.ff.submit();
}
</script>
|