Viewing file: printRepSumDocDept.php (13.64 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" alt="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>
|