Viewing file:  printRepSumRegisDocforDeptex.php (15.98 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
set_time_limit(0);
header('Content-type: application/xls');
header('Content-Disposition: attachment; filename="printRepSumRegisDocex.xls"');
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.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";
include_once "../class/clsDocReceiveSend.php";
include_once "../class/clsPerson.php";
include_once "../link/keyThai.php";
include_once "getPrefix.php";
include_once "functforRptEx.php";
include_once "../class/clsDocSpeedLevel.php";
include_once "../class/clsDocSecreLevel.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);
$oDlc = new DocLineConfig($oC);
$oDlc1 = new DocLineConfig($oC);
$oDlc2 = new DocLineConfig($oC);
$oDlc3 = new DocLineConfig($oC);
$oDlc4 = new DocLineConfig($oC);
$oDlp = new docLinePosition($oC);
$oDlp1 = new docLinePosition($oC);
$oRs = new DocReceiveSend($oC);
$oRs1 = new DocReceiveSend($oC);
$oPS = new person($oC);
$oDsl = new DocSpeedLevel($oC);
$oDsl2 = new DocSpeedLevel($oC);
$oDsl3 = new DocSpeedLevel($oC);
$oDsl4 = new DocSpeedLevel($oC);
$oDsl5 = new DocSpeedLevel($oC);
$oDcl = new DocSecretLevel($oC);
$oDcl2 = new DocSecretLevel($oC);
$oDcl3 = new DocSecretLevel($oC);
$oDcl4 = new DocSecretLevel($oC);
$oDcl5 = new DocSecretLevel($oC);
$MaxDocGroup=$oDP->SearchMaxDocGroup();
$colspanSecret=$oDcl->SearchNumRowDocSecretLevel();
$colspanSpeed=$oDsl->SearchNumRowDocSpeedLevel();
?>
<title>รายงานทะเบียนหนังสือภาพรวมของทั้งหน่วยงาน</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<body>
<div id="tabmargin">
<form name="ff" method="post" action="printRepSumRegisDocforDeptex.php" ><br>
<table width="99%" align="center">
<tr><td> </td></tr>
<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="92%" 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="8%" align="right"> </td>
</tr>
<tr>
<td height="24" colspan="2"><hr></td>
</tr>
<tr align="center">
<td align="center" colspan="2">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DADADA" style="border-collapse:collapse">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_1"]; ?>">
<td width="18%" rowspan="3" align="center"><strong>หน่วยงาน</strong></td>
<td width="12%" align="center" colspan=<? echo $colspanSecret+$colspanSpeed+4; ?>><strong>หนังสือภายนอก</strong></td>
<td width="10%" align="center" colspan=<? echo $colspanSecret+$colspanSpeed+3; ?>><strong>หนังสือภายใน</strong></td>
<td width="10%" align="center" colspan=<? echo $colspanSecret+$colspanSpeed+3; ?>><strong>หนังสือ<br>เสนอเพื่อลงนาม</strong></td>
<td width="10%" align="center" colspan=<? echo $colspanSecret+$colspanSpeed+4; ?>><strong>หนังสือ<br>
ประทับตรา</strong></td>
<td width="12%" align="center" colspan=3><strong>หนังสือสั่งการ</strong></td>
<td width="10%" align="center" colspan=3><strong>หนังสือประชาสัมพันธ์</strong></td>
<td width="8%" align="center" ><strong>หนังสือที่ทำขึ้น<br>
ไว้เป็นหลักฐาน</strong></td>
<td width="10%" align="center" colspan=<? echo $colspanSecret+$colspanSpeed+3; ?>><strong>บันทึกข้อความส่งภายนอก</strong></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_1"]; ?>">
<td width="3%" align="center" rowspan="2"><strong>รับ-<br>
ภาย<br>
นอก</strong></td>
<td width="3%" align="center" rowspan="2"><strong>รับ-<br>
ภาย<br>
ใน</strong></td>
<td width="3%" align="center" rowspan="2"><strong>ส่ง</strong></td>
<td width="4%" align="center" rowspan="2"><strong>รวม</strong></td>
<td align="center" colspan=<? echo $colspanSecret;?>><strong>ชั้นความลับ</strong></td>
<td align="center" colspan=<? echo $colspanSpeed;?>><strong>ชั้นความเร็ว</strong></td>
<td width="3%" align="center" rowspan="2"><strong>รับ</strong></td>
<td width="3%" align="center" rowspan="2"><strong>ส่ง</strong></td>
<td width="4%" align="center" rowspan="2"><strong>รวม</strong></td>
<td align="center" colspan=<? echo $colspanSecret;?>><strong>ชั้นความลับ</strong></td>
<td align="center" colspan=<? echo $colspanSpeed;?>><strong>ชั้นความเร็ว</strong></td>
<td width="3%" align="center" rowspan="2"><strong>รับ</strong></td>
<td width="3%" align="center" rowspan="2"><strong>ส่ง</strong></td>
<td width="4%" align="center" rowspan="2"><strong>รวม</strong></td>
<td align="center" colspan=<? echo $colspanSecret;?>><strong>ชั้นความลับ</strong></td>
<td align="center" colspan=<? echo $colspanSpeed;?>><strong>ชั้นความเร็ว</strong></td>
<td width="3%" align="center" rowspan="2"><strong>รับ-<br>
ภาย<br>
นอก</strong></td>
<td width="3%" align="center" rowspan="2"><strong>รับ-<br>
ภาย<br>
ใน</strong></td>
<td width="3%" align="center" rowspan="2"><strong>ส่ง</strong></td>
<td width="4%" align="center" rowspan="2"><strong>รวม</strong></td>
<td align="center" colspan=<? echo $colspanSecret;?>><strong>ชั้นความลับ</strong></td>
<td align="center" colspan=<? echo $colspanSpeed;?>><strong>ชั้นความเร็ว</strong></td>
<td width="5%" align="center" rowspan="2"><strong>คำสั่ง</strong></td>
<td width="5%" align="center" rowspan="2"><strong>ระเบียบ</strong></td>
<td width="5%" align="center" rowspan="2"><strong>ข้อบังคับ</strong></td>
<td width="5%" align="center" rowspan="2"><strong>ประกาศ</strong></td>
<td width="5%" align="center" rowspan="2"><strong>แถลงการณ์</strong></td>
<td width="5%" align="center" rowspan="2"><strong>ข่าว</strong></td>
<td width="8%" align="center" rowspan="2"><strong>หนังสือรับรอง</strong></td>
<td width="3%" align="center" rowspan="2"><strong>รับ</strong></td>
<td width="3%" align="center" rowspan="2"><strong>ส่ง</strong></td>
<td width="4%" align="center" rowspan="2"><strong>รวม</strong></td>
<td align="center" colspan=<? echo $colspanSecret;?>><strong>ชั้นความลับ</strong></td>
<td align="center" colspan=<? echo $colspanSpeed;?>><strong>ชั้นความเร็ว</strong></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_1"]; ?>">
<?
$oDcl->RSDocSecretLevel();
while($oDcl->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDcl->DclName;?></strong></td>
<?
}
$oDsl->RSDocSpeedLevel();
while($oDsl->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDsl->DslName;?></strong></td>
<?
}
$oDcl2->RSDocSecretLevel();
while($oDcl2->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDcl2->DclName;?></strong></td>
<?
}
$oDsl2->RSDocSpeedLevel();
while($oDsl2->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDsl2->DslName;?></strong></td>
<?
}
$oDcl3->RSDocSecretLevel();
while($oDcl3->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDcl3->DclName;?></strong></td>
<?
}
$oDsl3->RSDocSpeedLevel();
while($oDsl3->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDsl3->DslName;?></strong></td>
<?
}
$oDcl4->RSDocSecretLevel();
while($oDcl4->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDcl4->DclName;?></strong></td>
<?
}
$oDsl4->RSDocSpeedLevel();
while($oDsl4->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDsl4->DslName;?></strong></td>
<?
}
$oDcl5->RSDocSecretLevel();
while($oDcl5->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDcl5->DclName;?></strong></td>
<?
}
$oDsl5->RSDocSpeedLevel();
while($oDsl5->GetRecord()){
?>
<td width="4%" align="center"><strong><? echo $oDsl5->DslName;?></strong></td>
<?
}
?>
</tr>
<?
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";
}
$i=0;
$oDP->SearchByKey($deptId);
$oDP->GetRecord();
$sumreceiveOut1=0;
$sumreceiveIn1=0;
$sumsend1=0;
$sum1=0;
$sumreceive2=0;
$sumsend2=0;
$sum2=0;
$sumreceive2sign=0;
$sumsend2sign=0;
$sum2sign=0;
$sumreceiveOut3=0;
$sumreceiveIn3=0;
$sumsend3=0;
$sum3=0;
$sum4=0;
$sum5=0;
$sum6=0;
$sum7=0;
$sum8=0;
$sum9=0;
$sum10=0;
$sum11=0;
$sumreceive12=0;
$sumsend12=0;
$sum12=0;
?><tr>
<td align="left" height="22"><b><? echo $oDP->deptName; ?></b></td>
<td align="center"><? echo $sumreceiveOut1=$oDoc->SearchRepSumRegisDoc('1','1',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumreceiveIn1=$oDoc->SearchRepSumRegisDoc('3','1',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumsend1=$oDoc->SearchRepSumRegisDoc('2','1',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum1=$sumreceiveOut1+$sumreceiveIn1+$sumsend1;?></td>
<?
$oDcl->RSDocSecretLevel();
while($oDcl->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('1',$startT,$endT,$oDP->deptId,'DclID',$oDcl->DclID); ?></td>
<?
}
$oDsl->RSDocSpeedLevel();
while($oDsl->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('1',$startT,$endT,$oDP->deptId,'DslID',$oDsl->DslID); ?></td>
<?
}
?>
<td align="center"><? echo $sumreceive2=$oDoc->SearchRepSumRegisDoc('3','3',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumsend2=$oDoc->SearchRepSumRegisDoc('4','3',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum2=$sumreceive2+$sumsend2;?></td>
<?
$oDcl2->RSDocSecretLevel();
while($oDcl2->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('3',$startT,$endT,$oDP->deptId,'DclID',$oDcl2->DclID); ?></td>
<?
}
$oDsl2->RSDocSpeedLevel();
while($oDsl2->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('3',$startT,$endT,$oDP->deptId,'DslID',$oDsl2->DslID); ?></td>
<?
}
?>
<td align="center"><? echo $sumreceive2sign=$oDoc->SearchRepSumRegisDoc('3','15',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumsend2sign=$oDoc->SearchRepSumRegisDoc('4','15',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum2sign=$sumreceive2sign+$sumsend2sign;?></td>
<?
$oDcl3->RSDocSecretLevel();
while($oDcl3->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('15',$startT,$endT,$oDP->deptId,'DclID',$oDcl3->DclID); ?></td>
<?
}
$oDsl3->RSDocSpeedLevel();
while($oDsl3->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('15',$startT,$endT,$oDP->deptId,'DslID',$oDsl3->DslID); ?></td>
<?
}
?>
<td align="center"><? echo $sumreceiveOut3=$oDoc->SearchRepSumRegisDoc('1','2',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumreceiveIn3=$oDoc->SearchRepSumRegisDoc('3','2',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumsend3=$oDoc->SearchRepSumRegisDoc('2','2',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum3=$sumreceiveOut3+$sumreceiveIn3+$sumsend3;?></td>
<?
$oDcl4->RSDocSecretLevel();
while($oDcl4->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('2',$startT,$endT,$oDP->deptId,'DclID',$oDcl4->DclID); ?></td>
<?
}
$oDsl4->RSDocSpeedLevel();
while($oDsl4->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('2',$startT,$endT,$oDP->deptId,'DslID',$oDsl4->DslID); ?></td>
<?
}
?>
<td align="center"><? echo $sum4=$oDoc->SearchRepSumRegisDoc('5','5',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum5=$oDoc->SearchRepSumRegisDoc('5','6',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum6=$oDoc->SearchRepSumRegisDoc('5','7',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum7=$oDoc->SearchRepSumRegisDoc('5','9',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum8=$oDoc->SearchRepSumRegisDoc('5','10',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum9=$oDoc->SearchRepSumRegisDoc('5','11',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum10=$oDoc->SearchRepSumRegisDoc('5','13',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumreceive12=$oDoc->SearchRepSumRegisDoc('1','14',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sumsend12=$oDoc->SearchRepSumRegisDoc('2','14',$startT,$endT,$oDP->deptId); ?></td>
<td align="center"><? echo $sum12=$sumreceive12+$sumsend12;?></td>
<?
$oDcl5->RSDocSecretLevel();
while($oDcl5->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('14',$startT,$endT,$oDP->deptId,'DclID',$oDcl5->DclID); ?></td>
<?
}
$oDsl5->RSDocSpeedLevel();
while($oDsl5->GetRecord()){
?>
<td align="center"><? echo $oDoc->SearchRepSumRegisDocSecretLevel('14',$startT,$endT,$oDP->deptId,'DslID',$oDsl5->DslID); ?></td>
<?
}
?>
</tr>
</table>
</table>
</td>
</tr>
</table>
<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="deptId" id="deptId" value="<? echo $deptId;?>">
<input type="hidden" name="print" id="print" value="พิมพ์" >
</form>
</div>
</body>
<script>
function printDetailFollowDocDept(p,q){
FileName = "printRepFollowDocDeptDetail.php?DocID="+p+"&DrsID="+q;
var w=600;
var h=600;
strOption = "scrollbars=yes,left=300,top=100,width=" + w + ",height=" + h;
window.open(FileName,"",strOption);
}function showDocex(){
document.ff.submit();
}
function showDocex2(){
window.print();
}
</script>
|