";
echo "
";
echo "
| REC.NO |
Cust. Name |
V. Plate |
C. Sticker |
RO # |
V. Brand |
V. Model |
Type |
Appt. Date |
E-mail |
Mobile |
Current Status |
Released Date/Time |
";
while($row=mysql_fetch_array($getApptSum)){
if($row['s_ro_no']==='' && $row['s_arrived_time']!=''){
$tColor="red";
}else{
$tColor="black";
}
$brandID=$row['brand_id'];
$modelID=$row['model_id'];
$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);
$vPlate=$row['s_v_plate'];
$ConductionSticker = mysql_result(mysql_query("SELECT `v_conduction` FROM `vts_vehicle_lists` WHERE `v_plate`='$vPlate'"),0);
$cID= mysql_result(mysql_query("SELECT `cust_id` FROM `vts_vehicle_lists` WHERE `v_plate`='$vPlate'"),0);
$custFName = mysql_result(mysql_query("SELECT `cust_fname` FROM `vts_customers` WHERE `c_id`='$cID'"),0);
$custLName = mysql_result(mysql_query("SELECT `cust_lname` FROM `vts_customers` WHERE `c_id`='$cID'"),0);
$vEmail = mysql_result(mysql_query("SELECT `cust_email` FROM `vts_customers` WHERE `c_id`='$cID'"),0);
$vMobile = mysql_result(mysql_query("SELECT `cust_mobile` FROM `vts_customers` WHERE `c_id`='$cID'"),0);
?>
".$row['s_id']."";
echo "| ".$custFName." ".$custLName ." | ";
echo "".$row['s_v_plate']." | ";
echo "".$ConductionSticker." | ";
echo "".$row['s_ro_no']." | ";
echo "".$brandName." | ";
echo "".$modelName." | ";
echo "".$row['s_appt_type']." | ";
echo "".$row['appt_date']." | ";
echo "".$vEmail." | ";
echo "".$vMobile." | ";
echo "";
if($row['s_arrived_time']==''){
echo 'Waiting to Arrive';
}else{
echo 'Arrived at '.$row['s_arrived_time'];
}
echo " | ";
echo "".$row['date_closed']." | ".$row['time_closed']." | ";
echo "
";
}
echo "";
?>
