";
$result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_comp_code`='$compID' AND `s_deal_code`='$dealID' AND `service_status`='0' AND `s_ro_no`!='' || `transferred_to`='$dealID' AND `service_status`='0' AND `s_ro_no`!='' AND `transfer_return_date`='' ORDER BY `appt_date`, `time_slot_code` ASC");
while($row=mysql_fetch_array($result)){
$chkIfTransferred= $row['transferred_to'];
$cBrand=mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0);
$cModel=mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0);
$getTransferID = $row['transferred_to'];
if($getTransferID!='NA'){
$transferredToDealer=mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$getTransferID'"),0);
}else{
$transferredToDealer=$getTransferID;
}
if($chkIfTransferred!='NA'){
$fColor='red';
}else{
$fColor='';
}
?>
".$row['s_v_plate']."";
echo "
".$row['s_ro_no']."
";
echo "
".$cBrand."
";
echo "
".$cModel."
";
echo "
".$row['s_appt_type']."
";
echo "
".$row['appt_date']."
";
echo "
".$transferredToDealer."
";
echo "
";
$getStatLog = mysql_result(mysql_query("SELECT `paint_stage` FROM `vts_service_status_logs` WHERE `paint_stage`!='NA' AND `ro_number` = '".$row['s_ro_no']."' ORDER BY `log_id` DESC LIMIT 1"),0);
if($getStatLog!='NA'){
$seperator='➤';
}else{
$seperator='';
}
$genStatus = mysql_result(mysql_query("SELECT `status` FROM `vts_service_status_logs` WHERE `ro_number` = '".$row['s_ro_no']."' ORDER BY `log_id` DESC LIMIT 1"),0);
$getGeneralStatus =mysql_result(mysql_query("SELECT `service_desc` FROM `vts_service_status` WHERE `serv_id` = '$genStatus' "),0);
echo $getGeneralStatus." ".$seperator." ". $getStatLog;
echo "