";
echo "
";
echo "
| REC.NOX |
V. Plate |
RO # |
V. Brand |
V. Model |
Type |
Appt. Date |
Arrived Time |
Current Status |
";
while($row=mysql_fetch_array($getApptSum)){
if($row['s_ro_no']===''){
$tColor="red";
}else{
$tColor="black";
}
if($row['s_arrived_time']==''){
if($row['transferred_to']=='NA'){
$status="Waiting";
}else{
$status="Transferred: Waiting";
}
}else{
if($row['transferred_to']!='NA'){
$status="Transferred: Arrived";
}else{
$status="Arrived";
}
}
$brandName=mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0);
$modelName=mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0);
//$brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='$brandID'"),0);
//$modelName = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='$brandID'"),0);
if($status==='Arrived' || $status='Transferred: Arrived'){
?>
|
".$row['s_id']."";
echo "| ".$row['s_v_plate']." | ";
echo "".$row['s_ro_no']." | ";
echo "".$brandName." | ";
echo "".$modelName." | ";
echo "".$row['s_appt_type']." | ";
echo "".$row['appt_date']." | ";
echo "".$row['s_arrived_time']." | ";
echo "".$status." | ";
echo "
";
}
echo "";
?>
