session_start();
ob_start();
$pagelevel1 = "lrsb1";
$pagelevel2 = "lrsb2";
$pagelevel3 = "jkr1";
$pagelevel4 = "jkr2";
$pagelevel5 = "kkr1";
$pagelevel6 = "kkr2";
//$_SESSION['last_reload'] = time();
//include "../../road/user/timeout.php";
include "../../../database/member.php";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$rowsPerPage = 10;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum -1)*$rowsPerPage;
?>
CRMIS
//determine level
if (($_SESSION['mylevel'] == $pagelevel1)
||
($_SESSION['mylevel'] == $pagelevel2)
)
{
?>
|
|
}//end of determine level
?>
//determine level
if (($_SESSION['mylevel'] == $pagelevel1)
||
($_SESSION['mylevel'] == $pagelevel2)
)
{
?>
| |
}//end of determine level
?>
| No |
RouteNo |
Road Name |
Remarks |
//determine level
if (($_SESSION['mylevel'] == $pagelevel1)
||
($_SESSION['mylevel'] == $pagelevel2)
)
{
?>
Option |
}//end of determine level
?>
$sql = "SELECT * From route WHERE zone='SPB' ORDER by routeID DESC LIMIT $offset, $rowsPerPage";
//$sql = "Select id, DateRequested, RequestedBy, ApprovedBy, centre From overtime";
//$sql = "Select count(prRef) as countPrRef, prRef, count(prOrderDate) as countprOrderDate, prProcessStatus, prOrderDate, prPRFNo, prPreUserID, prReqUserID, prReqDate, prVerUserID, prVerDate, prAppUserID, prAppUserID2 From pr Group By prRef Order By prOrderDate DESC, prPRFNo, prPreDate DESC ";
//$sql = "Select * From pr";
$No = $offset + 1;
$rs = mysql_query($sql) or die(mysql_error());
if ($rs)
{
while ($rw = mysql_fetch_object($rs))
{
$routeID=$rw->routeID;
$routeNo=$rw->routeNo;
$district=$rw->district;
$roadname=$rw->roadname;
$roadFrom=$rw->roadFrom;
$roadTo=$rw->roadTo;
$remarks=$rw->remarks;
$class=$rw->class;
$category=$rw->category;
$type=$rw->type;
$length=$rw->length;
$ComnNo=$rw->ComnNo;
$ComnDate=$rw-ComnDate;
$zone=$rw->zone;
$concession=$rw->concession;
$inventory_code=$rw->inventory_code;
$quantity=$rw->quantity;
?>
| echo $No; ?> |
echo $routeNo; ?> |
|
echo $remarks; ?> |
//determine level
if (($_SESSION['mylevel'] == $pagelevel1)
||
($_SESSION['mylevel'] == $pagelevel2)
)
{
?>
|
}//end of determine level
?>
$No++;
}
}
else
{
?>
| RECORD |
Empty |
}
?>
|
$query = "select count(routeID) as numrows from route WHERE zone='SPB'";
$result = mysql_query($query) or die("Error, query failed");
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
if($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " [Prev] ";
$first = " [First Page] ";
}
else
{
$prev = ' ';
$first = ' ';
}
if($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " [Next] ";
$last = " [Last Page] ";
}
else
{
$next = ' ';
$last = ' ';
}
//echo $first . $prev . $nav . $next . $last;
echo $first . $prev .
" Showing page $pageNum of $maxPage pages " . $next . $last;
?>
|