Viewing file:  printAllDocLineConfigex.php (4.2 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
header('Content-type: application/xls');
header('Content-Disposition: attachment; filename="printAllDocLineConfigex.xls"');
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "functforRptEx.php";
include_once "../class/clsDocLinePosition.php";
include_once "../class/clsDocLineConfig.php";
include_once "../link/keyThai.php";
include_once "getPrefix.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oDP3 = new Department($oC);
$oPS = new person($oC);
$oDlc = new DocLineConfig($oC);
$oDlc1 = new DocLineConfig($oC);
$oDlp = new docLinePosition($oC);
$MaxDocGroup=$oDP->SearchMaxDocGroup();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
</head>
<title>ГТВ§Т№Л№йТ·Хи§Т№КТГєГГіўН§єШ¤¤Е·ШЎЛ№иЗВ§Т№</title>
<body>
<br>
<table border="0" align="center" width="95%">
<tr>
<td align="center"><font size="2" ><strong>ГТВ§Т№Л№йТ·Хи§Т№КТГєГГіўН§єШ¤¤Е·ШЎЛ№иЗВ§Т№ КГШ» і ЗС№·Хи <?php echo abbreDate2((date('Y')+543).'-'.date('m').'-'.date('d')); ?></strong></font></td>
</tr>
<tr><td align="center"> <br>
<? $oDP->SearchBydeptDateDocGroup($MaxDocGroup);
while($oDP->GetRecord()){
?>
<table width="100%" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td colspan="8" height="25" align="left"><font size="2" ><strong>Л№иЗВ§Т№ :: </strong><? echo $oDP->deptName; ?></font></td></tr>
<tr><td colspan="8" height="25" align="left"><font size="2" ><strong>К¶Т№РЎТГгЄй§Т№ :: </strong>
<? if($oDlc1->SearchDeptconfirm($oDP->deptId)=="Y"){ echo "ВЧ№ВС№ЎТГгЄй§Т№бЕйЗ"; }else{ echo "ВС§дБиВЧ№ВС№ЎТГгЄй§Т№"; } ?>
</font></td></tr>
</table>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" style="border-collapse:collapse">
<tr >
<td width="6%" align="center"><strong>ЕУґСє</strong></td>
<td width="21%" align="center"><strong>µУбЛ№и§</strong></td>
<td align="center" ><strong>єШ¤ЕТЎГ</strong><strong></strong></td>
<td width="10%" align="center"><strong>аК№Н<br>Е§№ТБ</strong></td>
<td width="8%" align="center"><strong>Е§№ТБ</strong></td>
<td width="8%" align="center"><strong>Ки§јиТ№</strong></td>
<td width="8%" align="center"><strong>Ки§</strong></td>
<td width="10%" align="center"><strong>ґЩ<br>
Л№С§КЧН</strong></td>
<td width="8%" align="center"><strong>Active</strong></td>
</tr>
<?
$oDlc->SearchByDeptMaxDocGroup($oDP->deptId,$MaxDocGroup);
$i=0;
while($oDlc->GetRecord()){
?>
<tr >
<td align="center" height="22"><? echo a2th($oDlc->DlcSeq); ?><? //echo "DlcID=".$oDlc->DlcID; ?></td>
<td align="left" ><? $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); echo " ".$oDlp->DlpName; ?></td>
<? $oPS->SearchByKey($oDlc->personId); $oPS->GetRecord();?>
<td width="21%" align="left"><? echo " ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName; ?></td>
<td align="center"><? if($oDlc->DlcPropose=="Y"){ echo "/"; }?></td>
<td align="center"><? if($oDlc->DlcSign=="Y"){ echo "/"; }?></td>
<td align="center"><? if($oDlc->DlcByPass=="Y"){ echo "/"; }?></td>
<td align="center"><? if($oDlc->DlcSend=="Y"){ echo "/"; }?></td>
<td align="center"><? if($oDlc->DlcView=="Y"){ echo "/"; }?></td>
<td align="center"><? if($oDlc->DlcActive=="Y"){ echo "/"; }?></td>
</tr>
<? $i++; } //end loop lineconfig
if($i=="0"){ ?>
<tr><td align="center" colspan="9" height="25"><font size="2">ВС§дБиБХЎТГЎУЛ№ґЛ№йТ·Хи§Т№КТГєГГіўН§єШ¤¤Е</font></td></tr>
<? } // if no lineconfig ?>
</table><br>
<? } //loop show each dept?>
</td></tr>
</tr>
<tr>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">ЗС№·ХиѕФБѕм : <?php echo abbreDate2((date('Y')+543).'-'.date('m').'-'.date('d')).' '.a2th(date('H:i:s'));?></font></td>
</tr>
</table>
|