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>
|