Viewing file: printRepRegisDocforDeptSendOutYN.php (20.25 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<? set_time_limit(0); include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../class/clsTable.php"; include_once "../link/function.php"; include_once "../link/functionshow.php"; include_once "../class/clsDocType.php"; include_once "../class/clsDocuments.php"; include_once "../class/clsDepartment.php"; include_once "funct.php"; include_once "../class/clsDocLineConfig.php"; include_once "../link/keyThai.php"; $oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDt = new doctype($oC); $oDoc = new Documents($oC); $oDoc2 = new Documents($oC); $oDP = new Department($oC); $oDlc1 = new DocLineConfig($oC); $MaxDocGroup=$oDP->SearchMaxDocGroup();
$oDlc1->SearchByKey($dlcid); $oDlc1->GetRecord();
?> <title>รายงานทะเบียนหนังสือภาพรวมของทั้งหน่วยงาน</title> <meta http-equiv="Content-Type" content="text/html; charset=tis-620"> <link href="../source/style.css" rel="stylesheet" type="text/css"> <body> <div id="tabmargin"> <form name="ff" method="post" action="printRepRegisDocforDeptSendOutYNex.php" ><br> <table width="100%" align="center"> <tr bgcolor="#FFFFFF"> <td width="99%"><table width="100%" cellpadding="1" cellspacing="1"> <tr> <td height="22"><font face="MS Sans Serif, Tahoma, sans-serif"><strong> <? //------receive $oDt->SearchRepReceiveDocName(); while($oDt->GetRecord()){ $dt1N=$oDt->DtID."1N"; $dt1Y=$oDt->DtID."1Y"; if($typeshow==$dt1N){ echo "รายงานทะเบียนรับ".$oDt->DtName; $DtID=$oDt->DtID; $RsID=1; $docsend="N"; } if($typeshow==$dt1Y){ echo "รายงานทะเบียนรับ".$oDt->DtName." (รับจากหน่วยงานภายนอก)"; $DtID=$oDt->DtID; $RsID=1; $docsend="Y"; } $dt2N=$oDt->DtID."2N"; $dt2Y=$oDt->DtID."2Y"; if($typeshow==$dt2N){ echo "รายงานทะเบียนส่ง".$oDt->DtName." (ยุติหนังสือ)"; $DtID=$oDt->DtID; $RsID=2; $docsend="N"; } if($typeshow==$dt2Y){ echo "รายงานทะเบียนส่ง".$oDt->DtName." (ไม่ยุติหนังสือ / ส่งให้หน่วยงานภายนอก)"; $DtID=$oDt->DtID; $RsID=2; $docsend="Y"; } } ?> </strong></font></td> <td height="22" align="right"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>OIS...</strong></font></td> </tr> <tr> <td width="73%" height="22"><font face="MS Sans Serif, Tahoma, sans-serif"><strong><? echo $GLOBALS["COLLEGENAME"]; ?> <? if(th2a($yearDoc) == 0){ echo "ตั้งแต่วันที่ "; list($day1,$month1,$year1) = preg_split('[/]',$start); $s=($year1+543)."-".$month1."-".$day1; echo abbreDate2($s,'/'); echo " ถึง "; list($day2,$month2,$year2) = preg_split('[/]',$end); $e=($year2+543)."-".$month2."-".$day2; echo abbreDate2($e,'/'); }else{ echo "ประจำปี ".a2th($yearDoc); } ?> </strong></font></td> <td width="27%" align="right"> <a href='#' onClick='return showDocex2()'><img src="../picture/print.gif" title="พิมพ์หน้านี้" border="0" style="cursor:pointer;"></a> <a href='#' onClick='return showDocex()'><img src="../picture/ico_excel.gif" title="พิมพ์ excel" border="0" style="cursor:pointer;"></a></td> </tr> <? if($seeDept=="1"){ $oDP->SearchByKey($deptId); $oDP->GetRecord(); ?> <tr><td>หน่วยงาน :: <? echo $oDP->deptName; ?></td><td> </td></tr> <? } ?> <tr> <td height="24" colspan="2"><hr></td> </tr> </table>
<? $flag = 0; if(th2a($yearDoc) == 0){ list($dd, $mm, $yy) = preg_split('[/]',$start); $startT=($yy+543)."-".$mm."-".$dd; list($dd, $mm, $yy) = preg_split('[/]',$end); $endT=($yy+543)."-".$mm."-".$dd; }else{ $yy = th2a($yearDoc); $startT = $yy."-01-01"; $endT = $yy."-12-31"; } $oDoc2->SearchRsIDDtIDfDeleteDocNoSubject_deptId_Date_sendOutDocYN($RsID,$DtID,$startT,$endT,th2a($DocTypeNoStart),th2a($DocTypeNoEnd),th2a($DocSubject),$deptId,$MaxDocGroup,$docsend); while($oDoc2->GetRecord()){ $oDlc1->SearchByKey($oDoc2->DlcID); $oDlc1->GetRecord(); list($DocD,$DocT) = preg_split('[ ]',$oDoc2->DocDateCreate); $a=$DocD; if($d!=$DocD){ $d=$a; ?> <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" style="border-collapse:collapse"> <tr><td> </td></tr> <tr><td align="right" colspan="8"> <font size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong> วันที่ลงทะเบียน<? echo ShowNameRSDoc2($RsID); ?>หนังสือ <? echo abbreDate2($DocD,'/');?></strong></font> </td></tr></table> <? } //show date and column?> <table width="100%" border="1" cellpadding="0" cellspacing="0" align="center" style="border-collapse:collapse" bordercolor="#000000"> <? //------------------header if($RsID==1 || $RsID==2){ ?> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="5%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>เลข<br>ทะเบียน<br><? echo ShowNameRSDoc2($RsID); ?></strong></font></td> <td width="11%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ที่</strong></font></td> <td width="8%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ลงวันที่</strong></font></td> <? if($RsID == 1){ $sizef="17%"; $sizet="8%"; }else if($RsID == 2){ $sizef="8%"; $sizet="17%"; }?> <td width="<? echo $sizef; ?>"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>จาก</strong></font></td> <td width="<? echo $sizet; ?>"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ถึง</strong></font></td> <td width="18%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>เรื่อง</strong></font></td> <td width="15%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>การปฏิบัติ</strong></font></td> <td width="9%" ><font face="MS Sans Serif, Tahoma, sans-serif"><strong>หมายเหตุ</strong></font></td> </tr> <? }else if($DtID==5){ ?> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="10%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ที่</strong></font></td> <td width="11%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>สั่ง ณ วันที่</strong></font></td> <td width="33%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>เรื่อง</strong></font></td> <td width="16%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ที่คำสั่งเดิมยกเลิก</strong></font></td> <td width="15%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>การปฏิบัติ</strong></font></td> <td width="9%" ><font face="MS Sans Serif, Tahoma, sans-serif"><strong>หมายเหตุ</strong></font></td> </tr> <? }else if($DtID==6 || $DtID==7){ ?> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="8%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ฉบับที่</strong></font></td> <td width="11%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ณ วันที่</strong></font></td> <td width="38%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ว่าด้วย/เรื่อง</strong></font></td> <td width="23%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>การปฏิบัติ</strong></font></td> <td width="9%" ><font face="MS Sans Serif, Tahoma, sans-serif"><strong>หมายเหตุ</strong></font></td> </tr> <? }else if($DtID==9){ ?> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="8%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ครั้งที่</strong></font></td> <td width="11%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ประกาศ ณ วันที่</strong></font></td> <td width="38%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>เรื่อง</strong></font></td> <td width="23%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>การปฏิบัติ</strong></font></td> <td width="9%" ><font face="MS Sans Serif, Tahoma, sans-serif"><strong>หมายเหตุ</strong></font></td> </tr> <? }else if($DtID==10 || $DtID==11){ ?> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="8%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ครั้งที่</strong></font></td> <td width="11%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>วัน/เดือน/ปี</strong></font></td> <td width="38%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>เรื่อง</strong></font></td> <td width="23%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>การปฏิบัติ</strong></font></td> <td width="9%" ><font face="MS Sans Serif, Tahoma, sans-serif"><strong>หมายเหตุ</strong></font></td> </tr> <? }else if($DtID==13){ ?> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="8%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ที่</strong></font></td> <td width="11%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>วดป ที่ออกใบรับรอง</strong></font></td> <td width="15%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>บุคคลที่รับรอง</strong></font></td> <td width="21%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>เรื่อง</strong></font></td> <td width="15%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>ผู้รับเอกสาร</strong></font></td> <td width="15%"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>การปฏิบัติ</strong></font></td> <td width="9%" ><font face="MS Sans Serif, Tahoma, sans-serif"><strong>หมายเหตุ</strong></font></td> </tr> <? } $oDoc->SearchRsIDDtIDfDeleteDocNoSubject_deptId_sendOutDocYN($RsID,$DtID,$oDoc2->DocDateCreate,th2a($DocTypeNoStart),th2a($DocTypeNoEnd),th2a($DocSubject),$deptId,$MaxDocGroup,$printorder,$docsend); while($oDoc->GetRecord()){ //------------------data if($oDoc->DocPID=="0" || $oDoc->DocPID==""){ $searchDoc=$oDoc->DocID; }else{ $searchDoc=$oDoc->DocPID; } if($RsID==1 || $RsID==2){ ?> <tr valign="top"> <td align="center" valign="top"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo a2th($oDoc->DocTypeNo); ?></font></td> <td align="center" valign="top"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo $oDoc->DocNo; ?></font></td> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo abbreDate2($oDoc->DocDate,'/');?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocFrom; ?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocTo; ?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> <a onClick = "newPage('printDetailRepRegisDocforDept.php?DocID=<? echo $oDoc->DocID; ?>&typeshow=<? echo $typeshow; ?>&dlcid=<? echo $dlcid; ?>&DocSubject=<? echo $DocSubject; ?>&start=<? echo $start;?>&end=<? echo $end; ?>&yearDoc=<? echo $yearDoc; ?>&DocTypeNoStart=<? echo $DocTypeNoStart; ?>&DocTypeNoEnd=<? echo $DocTypeNoEnd; ?>&seeDept=<? echo $seeDept; ?>&deptId=<? echo $deptId; ?>&printorder=<? echo $printorder; ?>')" style="cursor:pointer;"> <? echo " ".$oDoc->DocSubject; ?></a> </font></td> <td ><font face="MS Sans Serif, Tahoma, sans-serif"><? echo searchPsAct($oDoc->DocID,$RsID); ?><? if($oDoc->PtID!=="1"){ searchDocSendToPs($oDoc->DocID,$RsID); }?></font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocShortDesc; ?><? //echo wordwrap($oDoc->DocShortDesc, 14, "\n", true); ?> </font></td> </tr> <? }else if($DtID==5){ ?> <tr valign="top"> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo $oDoc->DocNo; ?></font></td> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo abbreDate2($oDoc->DocDate,'/');?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> <a onClick = "newPage('printDetailRepRegisDocforDept.php?DocID=<? echo $oDoc->DocID; ?>&typeshow=<? echo $typeshow; ?>&dlcid=<? echo $dlcid; ?>&DocSubject=<? echo $DocSubject; ?>&start=<? echo $start;?>&end=<? echo $end; ?>&yearDoc=<? echo $yearDoc; ?>&DocTypeNoStart=<? echo $DocTypeNoStart; ?>&DocTypeNoEnd=<? echo $DocTypeNoEnd; ?>&seeDept=<? echo $seeDept; ?>&deptId=<? echo $deptId; ?>&printorder=<? echo $printorder; ?>')" style="cursor:pointer;"> <? echo " ".$oDoc->DocSubject; ?></a> </font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> </font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo searchPsAct($oDoc->DocID,$RsID); ?><? if($oDoc->PtID!=="1"){ searchDocSendToPs($oDoc->DocID,$RsID); }?></font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocShortDesc; ?> </font></td> </tr> <? }else if($DtID==6 || $DtID==7){ ?> <tr valign="top"> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo $oDoc->DocNo; ?></font></td> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo abbreDate2($oDoc->DocDate,'/');?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> <a onClick = "newPage('printDetailRepRegisDocforDept.php?DocID=<? echo $oDoc->DocID; ?>&typeshow=<? echo $typeshow; ?>&dlcid=<? echo $dlcid; ?>&DocSubject=<? echo $DocSubject; ?>&start=<? echo $start;?>&end=<? echo $end; ?>&yearDoc=<? echo $yearDoc; ?>&DocTypeNoStart=<? echo $DocTypeNoStart; ?>&DocTypeNoEnd=<? echo $DocTypeNoEnd; ?>&seeDept=<? echo $seeDept; ?>&deptId=<? echo $deptId; ?>&printorder=<? echo $printorder; ?>')" style="cursor:pointer;"> <? echo " ".$oDoc->DocSubject; ?></a> </font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo searchPsAct($oDoc->DocID,$RsID); ?><? if($oDoc->PtID!=="1"){ searchDocSendToPs($oDoc->DocID,$RsID); }?></font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocShortDesc; ?> </font></td> </tr> <? }else if($DtID==9){ ?> <tr valign="top"> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo $oDoc->DocNo; ?></font></td> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo abbreDate2($oDoc->DocDate,'/');?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> <a onClick = "newPage('printDetailRepRegisDocforDept.php?DocID=<? echo $oDoc->DocID; ?>&typeshow=<? echo $typeshow; ?>&dlcid=<? echo $dlcid; ?>&DocSubject=<? echo $DocSubject; ?>&start=<? echo $start;?>&end=<? echo $end; ?>&yearDoc=<? echo $yearDoc; ?>&DocTypeNoStart=<? echo $DocTypeNoStart; ?>&DocTypeNoEnd=<? echo $DocTypeNoEnd; ?>&seeDept=<? echo $seeDept; ?>&deptId=<? echo $deptId; ?>&printorder=<? echo $printorder; ?>')" style="cursor:pointer;"> <? echo " ".$oDoc->DocSubject; ?></a> </font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo searchPsAct($oDoc->DocID,$RsID); ?><? if($oDoc->PtID!=="1"){ searchDocSendToPs($oDoc->DocID,$RsID); }?></font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocShortDesc; ?> </font></td> </tr> <? }else if($DtID==10 || $DtID==11){ ?> <tr valign="top"> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo $oDoc->DocNo; ?></font></td> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo abbreDate2($oDoc->DocDate,'/');?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> <a onClick = "newPage('printDetailRepRegisDocforDept.php?DocID=<? echo $oDoc->DocID; ?>&typeshow=<? echo $typeshow; ?>&dlcid=<? echo $dlcid; ?>&DocSubject=<? echo $DocSubject; ?>&start=<? echo $start;?>&end=<? echo $end; ?>&yearDoc=<? echo $yearDoc; ?>&DocTypeNoStart=<? echo $DocTypeNoStart; ?>&DocTypeNoEnd=<? echo $DocTypeNoEnd; ?>&seeDept=<? echo $seeDept; ?>&deptId=<? echo $deptId; ?>&printorder=<? echo $printorder; ?>')" style="cursor:pointer;"> <? echo " ".$oDoc->DocSubject; ?></a> </font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo searchPsAct($oDoc->DocID,$RsID); ?><? if($oDoc->PtID!=="1"){ searchDocSendToPs($oDoc->DocID,$RsID); }?></font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocShortDesc; ?> </font></td> </tr> <? }else if($DtID==13){ ?> <tr valign="top"> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo $oDoc->DocNo; ?></font></td> <td align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><? echo abbreDate2($oDoc->DocDate,'/');?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->CertificatePs; ?></font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> <a onClick = "newPage('printDetailRepRegisDocforDept.php?DocID=<? echo $oDoc->DocID; ?>&typeshow=<? echo $typeshow; ?>&dlcid=<? echo $dlcid; ?>&DocSubject=<? echo $DocSubject; ?>&start=<? echo $start;?>&end=<? echo $end; ?>&yearDoc=<? echo $yearDoc; ?>&DocTypeNoStart=<? echo $DocTypeNoStart; ?>&DocTypeNoEnd=<? echo $DocTypeNoEnd; ?>&seeDept=<? echo $seeDept; ?>&deptId=<? echo $deptId; ?>&printorder=<? echo $printorder; ?>')" style="cursor:pointer;"> <? echo " ".$oDoc->DocSubject; ?></a> </font></td> <td><font face="MS Sans Serif, Tahoma, sans-serif"> </font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo searchPsAct($oDoc->DocID,$RsID); ?><? if($oDoc->PtID!=="1"){ searchDocSendToPs($oDoc->DocID,$RsID); }?></font> </td> <td><font face="MS Sans Serif, Tahoma, sans-serif"><? echo " ".$oDoc->DocShortDesc; ?> </font></td> </tr> <? } } //while data ?> <? $flag = 1; } // end while oDoc if($flag == 0){ ?> <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_5"];?>"> <td colspan="10" align="center"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" >** ไม่พบรายการ **</font></td> </tr> <? } ?> </table> </td> </tr> </table></td> </tr> </table> <input type="hidden" name="typeshow" id="typeshow" value="<? echo $typeshow; ?>" > <input type="hidden" name="dlcid" id="dlcid" value="<? echo $dlcid; ?>" > <input type="hidden" name="DocSubject" id="DocSubject" value="<? echo $DocSubject; ?>" > <input type="hidden" name="start" id="start" value="<? echo $start; ?>" > <input type="hidden" name="end" id="end" value="<? echo $end; ?>" > <input type="hidden" name="yearDoc" id="yearDoc" value="<? echo $yearDoc; ?>" > <input type="hidden" name="DocTypeNoStart" id="DocTypeNoStart" value="<? echo $DocTypeNoStart; ?>" > <input type="hidden" name="DocTypeNoEnd" id="DocTypeNoEnd" value="<? echo $DocTypeNoEnd; ?>" > <input type="hidden" name="seeDept" id="seeDept" value="<? echo $seeDept; ?>" > <input type="hidden" name="deptId" id="deptId" value="<? echo $deptId; ?>" > <input type="hidden" name="printorder" id="printorder" value="<? echo $printorder; ?>" > <input type="hidden" name="print" id="print" value="พิมพ์" > </form><br> </div> </body> <script> function newPage(linkurl){ FileName = linkurl; var w=700; strOption = "scrollbars=yes,left=370,top=100,menubar=1,width="+w; window.open(FileName,"",strOption); } function showline(p){ FileName = "showlinedocTable.php?searchDoc="+p; var w=900; var h=500; strOption = "scrollbars=yes,left=370,top=100,menubar=1,width=" + w + ",height=" + h; window.open(FileName,"",strOption); } function showDocex(){ document.ff.submit(); } function showDocex2(){ window.print(); } </script>
|