Viewing file: printRepFollowDocAllDept.php (7.5 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?
set_time_limit(0);
include_once "template.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";
include_once "../class/clsDocReceiveSend.php";
include_once "../class/clsPerson.php";
include_once "../class/clsProposeType.php";
include_once "../link/keyThai.php";
include_once "getPrefix.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);
$oPp= new ProposeType($oC);
$MaxDocGroup=$oDP->SearchMaxDocGroup();
?>
<html>
<head>
<script language="javascript" src="../source/calendarDateInput.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" align="center">
<tr><td >
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="?mm=1">รายงาน</a>
</font>
<img src="../picture/ico3.gif" width="10" border="0" align="absmiddle">รายงานการค้นหาหนังสือราชการทุกชนิด</font>
</legend>
<form name="ff" method="post" action="printRepFollowDocAllDeptex.php" >
<table width="99%" align="center">
<tr>
<td height="22"><font face="MS Sans Serif, Tahoma, sans-serif"><strong>รายงานการค้นหาหนังสือราชการทุกชนิด
<? $oDP1->SearchByKey($deptId); $oDP1->GetRecord(); echo "หน่วยงาน :: ".$oDP1->deptName; ?>
</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="93%" height="22"><font face="MS Sans Serif, Tahoma, sans-serif"><strong><? echo $GLOBALS["COLLEGENAME"]; ?>
<? if(th2a($yearDoc) == 0){
echo "วันที่ดำเนินการส่งหนังสือตั้งแต่วันที่ "; list($day1,$month1,$year1) = split('/',$start); $s=($year1+543)."-".$month1."-".$day1; echo abbreDate2($s,'/');
echo " ถึง ";list($day2,$month2,$year2) = split('/',$end); $e=($year2+543)."-".$month2."-".$day2; echo abbreDate2($e,'/');
}else{
echo "วันที่ดำเนินการส่งหนังสือประจำปี ".a2th($yearDoc);
}
?>
</strong></font></td>
<td width="7%" align="right">
<a href='#' onClick='return showDocex2()'><img src="../picture/print.gif" alt="พิมพ์หน้านี้" border="0" style="cursor:pointer;"></a>
<a href='#' onClick='return showDocex()'><img src="../picture/ico_excel.gif" alt="พิมพ์ excel" border="0" style="cursor:pointer;"></a></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="6%" align="center"><strong>ที่</strong></td><td width="15%" align="center"><strong>ที่หนังสือ</strong></td><td width="22%" align="center"><strong>เรื่อง</strong></td><td width="10%" align="center"><strong>ว/ด/ป ที่<br>ลงทะเบียน</strong></td><td width="17%" align="center"><strong>หน่วยงานย่อย/<br>ผู้รับผิดชอบหลัก</strong></td><td width="10%" align="center"><strong>หมายเหตุ</strong></td></tr>
<?
if(th2a($yearDoc) == 0){
list($dd, $mm, $yy) = split('[/]',$start);
$startT=($yy+543)."-".$mm."-".$dd;
list($dd, $mm, $yy) = split('[/]',$end);
$endT=($yy+543)."-".$mm."-".$dd;
}else{
$yy = th2a($yearDoc);
$startT = $yy."-01-01";
$endT = $yy."-12-31";
}
$oDoc->SearchByDrsSendDateDocTypeNoDocSubjectDocNoDeptIdfDeleteDocGroupDsID322($startT,$endT,th2a($DocTypeNoStart),th2a($DocTypeNoEnd),th2a($DocSubject),th2a($DocNo),$deptId,$MaxDocGroup,$PtID);
while($oDoc->GetRecord()){
if($proposeid=='' || $proposeid!=$oDoc->PtID){ $proposeid=$oDoc->PtID;
$oPp->SearchByKey($proposeid); $oPp->GetRecord();
?>
<tr><td colspan="6" height="22"> <strong><? echo $oPp->PtName; ?></strong></td></tr>
<?
}
$nomainps='0';
if(($i%2) == 0)
echo "<tr bgcolor=\"#FFFFFF\" height=22 >";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_17"]."\">";
$oRs->SearchByDrsFromDrsIDDrsMainPs($oDoc->DrsID);
if($oRs->GetRecord()==1){
$oPS->SearchByKey($oRs->personId); $oPS->GetRecord();
$showname=GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName;
}else{
$showname="<div align=\"center\">-</div>";
$nomainps=1;
}
?>
<td width="6%" align="center"><? echo a2th($oDoc->DocTypeNo); ?></td>
<td width="15%"> <? echo $oDoc->DocNo; ?></td>
<td width="23%"> <a href="#" onClick="printDetailFollowDocDept('<? echo $oDoc->DocID; ?>','<? echo $oDoc->DrsID; ?>')"><? echo $oDoc->DocSubject; ?></a></td>
<td width="11%" align="center"><? if($oDoc->DocDateCreate!="0000-00-00 00:00:00"){ list($DocD,$DocT) = split(' ',$oDoc->DocDateCreate); echo abbreDate2($DocD,'/')."<br>".a2th($DocT);} ?></td>
<td width="16%"><? echo $showname; ?></td>
<td width="8%"> </td></tr>
<? $i++; } ?>
</table>
</td></tr>
<tr><td align="center" colspan="2"><input type="button" name="cancel" value="กลับหน้าหลัก" onClick="location.href = 'searchRepFollowDoc.php'"></td></tr>
</table>
<input type="hidden" name="DocSubject" value="<? echo $DocSubject; ?>" >
<input type="hidden" name="DocNo" value="<? echo $DocNo; ?>" >
<input type="hidden" name="start" value="<? echo $start; ?>" >
<input type="hidden" name="PtID" value="<? echo $PtID; ?>" >
<input type="hidden" name="end" value="<? echo $end; ?>" >
<input type="hidden" name="yearDoc" value="<? echo $yearDoc; ?>" >
<input type="hidden" name="DocTypeNoStart" value="<? echo $DocTypeNoStart; ?>" >
<input type="hidden" name="DocTypeNoEnd" value="<? echo $DocTypeNoEnd; ?>" >
<input type="hidden" name="seeAll" value="<? echo $seeAll; ?>" >
<input type="hidden" name="deptId" value="<? echo $deptId; ?>" >
<input type="hidden" name="dlcid" value="<? echo $dlcid; ?>" >
<input type="hidden" name="print" value="พิมพ์" >
</form>
</fieldset>
</td>
</tr>
</table>
</body>
</html>
<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>
|