';
while ($data = mysql_fetch_array($query)) {
$fPlate=$data["s_v_plate"];
$fBrand=$data["brand_id"];
$fModel=$data["model_id"];
}
echo "
";
echo "
";
$plateN = mysql_result(mysql_query("SELECT `s_v_plate` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$brandName=mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='$plateN'"),0);
$modelName=mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='$plateN'"),0);
$jobType = mysql_result(mysql_query("SELECT `s_appt_type` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$apptDateS = mysql_result(mysql_query("SELECT `appt_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$timeSl = mysql_result(mysql_query("SELECT `time_slot_code` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$qsSSP = mysql_result(mysql_query("SELECT `s_qs_ssp` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$qsComp = mysql_result(mysql_query("SELECT `s_qs_comp_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$qsCust = mysql_result(mysql_query("SELECT `s_qs_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$gjComp = mysql_result(mysql_query("SELECT `s_gj_comp_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$gjCust = mysql_result(mysql_query("SELECT `s_gj_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$gjWar = mysql_result(mysql_query("SELECT `s_gj_warranty` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$gjWarSub = mysql_result(mysql_query("SELECT `s_gj_warranty_sub` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$bpCust = mysql_result(mysql_query("SELECT `s_bp_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$bpWar = mysql_result(mysql_query("SELECT `s_bp_warranty_type` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$bpIns = mysql_result(mysql_query("SELECT `s_bp_insurance_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0);
$timeSlName = mysql_result(mysql_query("SELECT `time_slot` FROM `vts_service_slots` WHERE `slot_id`='$timeSl'"),0);
echo "
RO Number:";
echo "
".$svRO."";
echo "
Plate Number:";
echo "
".$plateN."";
echo "
Vehicle Brand:";
echo "
".$brandName."";
echo "
Vehicle Model:";
echo "
".$modelName."";
echo "
Job Type:";
echo "
".$jobType."";
echo "
Appointment Date:";
echo "
".$apptDateS."";
echo "
Appoitment Time:";
echo "
".$timeSlName."";
switch($jobType){
case 'QS':
echo "
SSP Paid:";
echo "
".$qsSSP."";
echo "
Company P.O:";
echo "
".$qsComp."";
echo "
Customer Paid:";
echo "
".$qsCust."";
break;
case 'BP':
echo "
Customer Paid:";
echo "
".$bpCust."";
echo "
Warranty Claim:";
echo "
".$bpWar."";
echo "
Paid by Insurance:";
echo "
".$bpIns."";
break;
case 'GJ':
echo "
Customer Paid:";
echo "
".$gjCust."";
echo "
Company P.O:";
echo "
".$gjComp."";
echo "
Warranty Claim:";
echo "
".$gjWar."";
echo "
Warranty Type:";
echo "
".$gjWarSub."";
break;
}
echo "
