"; echo " R.O Number V. Plate V. Brand V. Model Type Date Time "; $result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_ro_no`='$SelRONumberA'"); // echo "My RO: ". $SelRONumberA; while($row=mysql_fetch_array($result)){ $cBrand = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='".$row['brand_id']."'"),0); $cModel = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='".$row['brand_id']."'"),0); $appTime = mysql_result(mysql_query("SELECT `time_slot` FROM `vts_service_slots` WHERE `slot_id`='".$row['time_slot_code']."'"),0); $appDate = $row['appt_date']; $sPlate = $row['s_v_plate']; $arrivedDate = $row['s_arrived_date']; $sRoNumber = $row['s_ro_no']; $arrivedTime = $row['s_arrived_time']; $chkIfTransferred= $row['transferred_to']; $chkIfReturned= $row['transfer_return_date']; echo ""; echo "".$sRoNumber.""; echo "".$row['s_v_plate'].""; echo "".$cBrand.""; echo "".$cModel.""; echo "".$row['s_appt_type'].""; echo "".$row['appt_date'].""; echo "".$appTime.""; // echo""; echo ""; } echo ""; echo ""; ?>
☶ Service Update:
✕

Select Update: "; ?>
"; echo "
Update Client Via SMS"; echo "Update Client Via E-mail"; echo "
"; if($chkStatus==1){ //CLOSED echo " "; ?>
"; ?> "; ?> "; ?> "; echo ""; ?>
"; echo " LAST UPDATE DATE TIME NOTES "; while($lrow=mysql_fetch_array($loadInfoA)){ //$no = $no + 1; $statID = $lrow['status']; $paintStage = $lrow['paint_stage']; if($paintStage!='NA'){ $subStage="/".$paintStage; }else{ $subStage=""; } $lstMove = mysql_result(mysql_query("SELECT `service_desc` FROM `vts_service_status` WHERE `serv_id`='$statID' "),0); echo ""; // echo "".$no.""; echo "".$lstMove." ".$subStage.""; echo "".$lrow['date'].""; echo "".$lrow['time'].""; echo "".$lrow['notes'].""; echo""; echo ""; } echo ""; ?>
= '$appDate' AND `deleted`='0' ORDER BY `chk_id` DESC"); echo ""; echo ""; while($lrow=mysql_fetch_array($loadInfoB)){ $no = $no + 1; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo""; echo ""; } echo "
Mileage IN / OUT DATE TIME LOCATION NOTES
".$lrow['chk_km'].""; if($lrow['chk_transaction']==='IN'){ echo 'CHECKED-IN'; }else{ echo 'CHECKED-OUT'; } ;"".$lrow['date']."".$lrow['time'].""; // $getCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='".$lrow['comp_code']."'"),0); // echo $getCompName; //echo""; $getDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$lrow['dealer_code']."'"),0); echo $getDealName; echo""; $getLocName = mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='".$lrow['location_code']."'"),0); echo $getLocName; echo"
"; ?>
"; echo ""; echo ""; exit(); } ?>