Viewing file:  RptSysGrp.php (2.38 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include_once("pagebody.php");
pageHeader();
$pageTitle="รายงานสรุป ระบบงาน - กลุ่มผู้ใช้งาน";
echo "<table width=100% class=\"pageTitleBgColor\" align=\"center\">\n";
echo "<tr><td align=center>$pageTitle</td></tr>\n";
echo "</table>";
?>
<!--your code here-------------------------------------------------------------------------->
<br>
<p align=center>
<form name=form1 method=post>
<table bgcolor=#eeeeee align="center">
<tr align=left>
<td>เลือกระบบงาน</td>
<td>
<?
include_once("clsUmSystemR.php");
$oC = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB'], $GLOBALS['USER'], $GLOBALS['PASSWORD']);
$oSt = new umsystemr($oC);
echo $oSt->selectHTML("ID", $ID);
$oSt->Close();
$oC->Disconnect();
?>
</td>
</tr>
<tr align=left>
<td></td>
<td ><input type="checkbox" name="viewall" value="T">แสดงทุกระบบงาน</td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submit" value="Search"></td>
</tr>
</table>
</form>
</p>
<?
if ($pg<>"" or $submit=="Search"){
include_once("functions.php");
include_once("clsUmSystemR.php");
$oC = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB'], $GLOBALS['USER'], $GLOBALS['PASSWORD']);
$oSt = new umsystemr($oC);
if ($viewall=='T'){
$oSt->RsSystemGroup();
}else{
$oSt->RsSystemGroup($ID);
}
$numRow=$oSt->GetRowSelected();
?>
<table border="0" align="center" cellspacing="1" class="TableBodyBgColor" cellpadding="2" width="70%">
<!-- caption align="right" >พบ <?=$numRow?> รายการ</caption -->
<tr class="TableHeaderBgColor">
<th>#</th>
<th>ระบบงาน-กลุ่มผู้ใช้งาน</th>
<th>หมายเหตุ</th>
</tr>
<?
$sv="";
while ($oSt->GetRecord()){
if ($sv<>$oSt->StID){
$i++;
$sv=$oSt->StID;
//print group header
echo "<tr bgcolor=#ffffff valign=top>";
echo "<td align=center>$i</td>";
echo "<td>$oSt->StNameT</td>";
echo "<td> </td>";
echo "</tr>\n";
}
//print detail
if ($sv==$oSt->StID){
echo "<tr bgcolor=#ffffff valign=top>";
echo "<td align=center></td>";
echo "<td>" . str_repeat(" ", 10) . $oSt->GpNameT . "</td>";
echo "<td> </td>";
echo "</tr>\n";
}
}
$oSt->Close();
?>
</table>
<br>
<?
} //if ($pg<>""....
?>
<!--------------------------------------------------------------------->
<? pageFooter(); ?>
<!--------------------------------------------------------------------->
<!--put javascript here-->
<script language="javascript">
</script>
|