iLOG Summary Screen
Stats
23 jobs this month
215 jobs this year
Job No. |
Reg No. |
Date/Time |
Customer |
Agent |
Status |
if($_SESSION['access_level'] == "1") {
$sql = "SELECT * FROM jobs ORDER BY id DESC";
}
if($_SESSION['access_level'] == "2") {
$sql = "SELECT * FROM jobs where agent='$_SESSION[loggedin_as]' ORDER BY id DESC";
}
if($_SESSION['access_level'] == "3") {
$sql = "SELECT * FROM jobs where customer = '$_SESSION[loggedin_as]' ORDER BY id DESC";
}
include "inc/dbc.inc.php";
$query = mysql_query($sql);
while ($r = mysql_fetch_array($query)) {
$registration = $r['registration'];
$chassisno = $r['chassisno'];
$created = $r['created'];
$agent = $r['agent'];
$sdcstatus = $r['sdcstatus'];
$customer = $r['customer'];
$id = $r['id'];
echo "
$id |
$registration |
$created |
$customer |
$agent |
$sdcstatus |
";
} ?>
include "inc/footer.inc.php";
?>