include_once("pagebody.php"); pageHeader(); $pageTitle="การเข้าใช้ระบบงาน"; echo "
$pageTitle |
if ($pg<>"" or $submit=="Search"){ include_once("functions.php"); include_once("clsUmLog.php"); include_once("clsUmUser.php"); include_once("clsUmMenu.php"); include_once("clsUmSystem.php"); $oC = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB'], $GLOBALS['USER'], $GLOBALS['PASSWORD']); $oL = new umlog($oC); $oUs = new umuser($oC); $oMn = new ummenu($oC); $oSt = new umsystem($oC); $frDt=dmyE2ymdO($frDate); $toDt=dmyE2ymdO($toDate); $cond="and left(UlDt,10) between '$frDt' and '$toDt' "; $login = trim($login); if ($login<>""){ $cond.="and UsLogin='$login' "; } $oL->RSumlogCond($cond); $numRow=$oL->GetRowSelected(); //set num row per page, must change object name as well if($submit=="Search") $pg=1; if($nrpp=="") $oL->rowPerPage=$GLOBALS['rowsPerPage']; else $oL->rowPerPage=$nrpp; $oL->gotoPage($pg); // paging ?>
# | วันที่ | เวลา | รหัสผู้ใช้ | ระบบงาน : เมนู | IP | SQL | |
---|---|---|---|---|---|---|---|
$i | "; echo "" . ymd2dmy(substr($oL->UlDt,0,10)) . " | "; echo "" . substr($oL->UlDt,-8) . " | "; $oUs->SearchByKey($oL->UlUsID); $oUs->GetRecord(); echo "" . $oL->UlUsID . ":" . $oUs->UsLogin . " | "; $oMn->SearchByKey($oL->UlMnID); $oMn->GetRecord(); $oSt->SearchByKey($oMn->MnStID); $oSt->GetRecord(); echo "" . $oSt->StNameT . " : " . $oMn->MnNameT . " | "; // echo "" . $oL->UlFrTime . " | "; echo "" . $oL->UlIP . " | "; echo "" . $oL->UlCmd . " | "; echo "
";
//Show page number
// paging
$s="";
$mxPage=$oL->numPages();
for ($i=1; $i<=$mxPage; $i++){
$s.="";
if ($i==$pg)
$s.=" $i ";
else
$s.=" $i ";
$s.=" ";
if ($i % $GLOBALS['rowsPerPage'] ==0) $s.=" "; } echo $s; // paging echo " |