Viewing file: printRepSumDocDept.php (13.46 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<? include_once("../../class/clsConnection.php"); include_once("../../class/clsDB.php"); include_once "../global.php"; include_once "../link/function.php"; include_once "../link/functionshow.php"; include_once "../class/clsDocType.php"; include_once "../class/clsDocuments.php"; include_once "funct.php"; include_once "../class/clsDepartment.php"; include_once "../class/clsDocLineConfig.php"; include_once "../class/clsDocLinePosition.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); $oDP1 = new Department($oC); $oDP1 = new Department($oC); $oDlc1 = new DocLineConfig($oC); $oDlc2 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC);
$yy = $yearDoc; $trimester_S1 = $yy."-01-01 00:00:00"; $trimester_E1 = $yy."-03-31 23:59:59"; $trimester_S2 = $yy."-04-01 00:00:00"; $trimester_E2 = $yy."-06-30 23:59:59"; $trimester_S3 = $yy."-07-01 00:00:00"; $trimester_E3 = $yy."-09-30 23:59:59"; $trimester_S4 = $yy."-10-01 00:00:00"; $trimester_E4 = $yy."-12-31 23:59:59"; $trimester_SAll = $yy."-01-01 00:00:00"; $trimester_EAll= $yy."-12-31 23:59:59"; ?> <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="ps" method="post" action="RPOIS_103_104_ex.php" target="_self"> <div align="center"> </div><br> <table width="978" 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> รายงานสรุปจำนวนหนังสือรายการประเภทต่างๆแยกตามหน่วยงานย่อยรายไตรมาส </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> <? $oDP1->SearchByKey($deptId); $oDP1->GetRecord(); echo "หน่วยงาน :: ".$oDP1->deptName; ?> <? echo $GLOBALS["COLLEGENAME"]; ?> <? echo "ประจำปี ".$yearDoc; ?> </strong></font></td> <td width="27%" align="right"><!--a href='#' onClick='return checkFormat()'--><img src="../picture/print.gif" title="print" border="0" style="cursor:pointer;"><!--/a--></td> </tr> <tr> <td height="24" colspan="2"><hr></td> </tr> <tr><td> </td></tr> </table> <table width="100%" border="1" cellpadding="0" cellspacing="0" align="center" style="border-collapse:collapse" bordercolor="#000000"> <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="3%" rowspan="2" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ที่</strong></font></td> <td width="17%" rowspan="2" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ประเภทหนังสือ</strong></font></td> <td colspan="4" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ไตรมาส 1</strong></font></td> <td colspan="4" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ไตรมาส 2</strong></font></td> <td colspan="4" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ไตรมาส 3</strong></font></td> <td colspan="4" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ไตรมาส 4</strong></font></td> <td colspan="4" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รวมทั้งหมด</strong></font></td> </tr> <tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>"> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รับ</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ส่ง</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>คุม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รวม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รับ</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ส่ง</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>คุม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รวม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รับ</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ส่ง</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>คุม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รวม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รับ</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ส่ง</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>คุม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รวม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รับ</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>ส่ง</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>คุม</strong></font></td> <td width="4%"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><strong>รวม</strong></font></td> </tr> <? $oDt->RSdoctypeDtP(); $i=0; while($oDt->GetRecord()){ $i++; ?> <tr> <td height="22" align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><? echo $i; ?></font></td> <td><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <strong><? echo $oDt->DtName; ?></strong></font></td> <? //-------------ไตรมาส 1------------------------------?> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=1; }else{ $RsID=3;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri1 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S1,$trimester_E1,$deptId,$RsID,$oDt->DtID); if($tri1!=""){ echo $tri1; }else{ echo "0"; } } ?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=2; }else{ $RsID=4;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri1 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S1,$trimester_E1,$deptId,$RsID,$oDt->DtID); if($tri1!=""){ echo $tri1; }else{ echo "0"; }} ?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->forRegis=="Y"){ $tri1 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S1,$trimester_E1,$deptId,5,$oDt->DtID); if($tri1!=""){ echo $tri1; }else{ echo "0"; }; }else{ echo "-";}?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? $tri1_total = $oDoc->CountDocSumTrimesterDocDateCreateDeptIDTypeDoc($trimester_S1,$trimester_E1,$deptId,$oDt->DtID); if($tri1_total!=""){ echo $tri1_total; }else{ echo "0"; } ?> </font></td> <? //-------------ไตรมาส 2------------------------------?> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=1; }else{ $RsID=3;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri2 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S2,$trimester_E2,$deptId,$RsID,$oDt->DtID); if($tri2!=""){ echo $tri2; }else{ echo "0"; }; ?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=2; }else{ $RsID=4;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri2 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S2,$trimester_E2,$deptId,$RsID,$oDt->DtID); if($tri2!=""){ echo $tri2; }else{ echo "0"; }} ?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->forRegis=="Y"){ $tri2 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S2,$trimester_E2,$deptId,5,$oDt->DtID); if($tri2!=""){ echo $tri2; }else{ echo "0"; }; }else{ echo "-";}}?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? $tri2_total = $oDoc->CountDocSumTrimesterDocDateCreateDeptIDTypeDoc($trimester_S2,$trimester_E2,$deptId,$oDt->DtID); if($tri2_total!=""){ echo $tri2_total; }else{ echo "0"; } ?> </font></td> <? //-------------ไตรมาส 3------------------------------?> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=1; }else{ $RsID=3;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri3 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S3,$trimester_E3,$deptId,$RsID,$oDt->DtID); if($tri3!=""){ echo $tri3; }else{ echo "0"; }} ?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=2; }else{ $RsID=4;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri3 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S3,$trimester_E3,$deptId,$RsID,$oDt->DtID); if($tri3!=""){ echo $tri3; }else{ echo "0"; }} ?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->forRegis=="Y"){ $tri3 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S3,$trimester_E3,$deptId,5,$oDt->DtID); if($tri3!=""){ echo $tri3; }else{ echo "0"; }; }else{ echo "-";}?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? $tri3_total = $oDoc->CountDocSumTrimesterDocDateCreateDeptIDTypeDoc($trimester_S3,$trimester_E3,$deptId,$oDt->DtID); if($tri3_total!=""){ echo $tri3_total; }else{ echo "0"; } ?> </font></td> <? //-------------ไตรมาส 4------------------------------?> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=1; }else{ $RsID=3;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri4 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S4,$trimester_E4,$deptId,$RsID,$oDt->DtID); if($tri4!=""){ echo $tri4; }else{ echo "0"; }} ?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->DtRunAll=="Y"){ $RsID=2; }else{ $RsID=4;} if($oDt->forRegis=="Y"){ echo "-"; }else{ $tri4 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S4,$trimester_E4,$deptId,$RsID,$oDt->DtID); if($tri4!=""){ echo $tri4; }else{ echo "0"; }} ?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->forRegis=="Y"){ $tri4 = $oDoc->CountDocDocDateCreateDeptRsIDDtID($trimester_S4,$trimester_E4,$deptId,5,$oDt->DtID); if($tri4!=""){ echo $tri4; }else{ echo "0"; }; }else{ echo "-";}?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? $tri4_total = $oDoc->CountDocSumTrimesterDocDateCreateDeptIDTypeDoc($trimester_S4,$trimester_E4,$deptId,$oDt->DtID); if($tri4_total!=""){ echo $tri4_total; }else{ echo "0"; } ?> </font></td> <? //-------------ไตรมาส sum------------------------------?> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? //$triAll = $oDout->CountByDTrimesterStarEnd_DPID_Direction_SGID($trimester_SAll,$trimester_EAll,$depId,0,4); echo $triAll; ?> </font></td> <td align="center"> <font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? //$triAll = $oDout->CountByDTrimesterStarEnd_DPID_Direction_SGID($trimester_SAll,$trimester_EAll,$depId,1,4); echo $triAll; ?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? if($oDt->forRegis=="Y"){ }else{ echo "-";}?> </font></td> <td align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> <? //$tri_totalAll = $oDout->CountByDTrimesterStarEnd_DPID_SGID($trimester_SAll,$trimester_EAll,$depId,4); echo $tri_totalAll;?> </font></td> </tr> <? } ?> </table> </td> </tr> </table></td> </tr> </table> </form><br> </div> </body>
|