'; //=========================================================
echo '
';
echo "
";
?>
';
$getData = mysql_query("SELECT * FROM `vts_vehicle_lists` WHERE `v_plate`='$vPlate'");
echo "
";
while($row=mysql_fetch_array($getData)){
//$openAppt
$sellerDealer = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['sold_by_dealer']."'"),0);
$vLocation = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['v_location_id']."'"),0);
$ROPlate = mysql_result(mysql_query("SELECT `s_v_plate` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$JobType = mysql_result(mysql_query("SELECT `s_appt_type` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$ROMake = mysql_result(mysql_query("SELECT `v_make` FROM `vts_vehicle_lists` WHERE `v_plate`='$ROPlate'"),0);
$ROColor = mysql_result(mysql_query("SELECT `v_color` FROM `vts_vehicle_lists` WHERE `v_plate`='$ROPlate'"),0);
$vAction = mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='".$row['action_id']."'"),0);
//$serviceUpdate = mysql_result(mysql_query("SELECT `status` FROM `vts_service_logs` WHERE `v_plate`='".$row['v_plate']."' AND `date` "),0);
$QSssp = mysql_result(mysql_query("SELECT `s_qs_ssp` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$QScust = mysql_result(mysql_query("SELECT `s_qs_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$QSComp = mysql_result(mysql_query("SELECT `s_qs_comp_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$GJcust = mysql_result(mysql_query("SELECT `s_gj_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$GJcomp = mysql_result(mysql_query("SELECT `s_gj_comp_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$GJwar = mysql_result(mysql_query("SELECT `s_gj_warranty` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$GJwarSub = mysql_result(mysql_query("SELECT `s_gj_warranty_sub` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$BPcust = mysql_result(mysql_query("SELECT `s_bp_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$BPcopm = mysql_result(mysql_query("SELECT `s_bp_warranty_type` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$BPins = mysql_result(mysql_query("SELECT `s_bp_insurance_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$transID = mysql_result(mysql_query("SELECT `transferred_to` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$dateTransTo = mysql_result(mysql_query("SELECT `transfer_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$dateReturned = mysql_result(mysql_query("SELECT `transfer_return_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$apptDate = mysql_result(mysql_query("SELECT `appt_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$closedDate = mysql_result(mysql_query("SELECT `date_closed` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0);
$isOutSourced = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$transID."'"),0);
$isOutSourcedCode = mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='".$transID."'"),0);
echo "";
echo "| Data Owned By: | ";
echo "".$sellerDealer." | ";
echo "
";
echo "";
echo "| Vehicle Brand: | ";
echo "".$row['v_brand']." | ";
echo "
";
echo "";
echo "| Vehicle Plate: | ";
echo "".$ROPlate." | ";
echo "
";
echo "";
echo "| Varriant: | ";
echo "".$row['v_model']." | ";
echo "
";
echo "";
echo "| Make: | ";
echo "".$ROMake." | ";
echo "
";
echo "";
echo "| Color: | ";
echo "".$ROColor." | ";
echo "
";
echo "";
echo "| - - - - - - - - - - - - - - - - - - - - - - - - | ";
echo "
";
echo "";
echo "| Job Type: | ";
echo "$JobType | ";
echo "
";
echo "";
echo "| Appointment Date: | ";
echo "".$apptDate." | ";
echo "
";
switch($JobType){
case 'QS':
echo "";
echo "| Paid By Customer: | ";
echo "$QScust | ";
echo "
";
echo "";
echo "| Company P.O: | ";
echo "$QScust | ";
echo "
";
echo "";
echo "| S.S.P: | ";
echo "$QSssp | ";
echo "
";
break;
case 'GJ':
echo "";
echo "| Paid By Customer: | ";
echo "$GJcust | ";
echo "
";
echo "";
echo "| Company P.O: | ";
echo "$GJcomp | ";
echo "
";
echo "";
echo "| Warranty | ";
echo "$GJwar | ";
echo "
";
echo "";
echo "| Warranty Claim Type | ";
echo "$GJwarSub | ";
echo "
";
break;
case 'BP':
echo "";
echo "| Paid By Customer: | ";
echo "$BPcust | ";
echo "
";
echo "";
echo "| Company P.O: | ";
echo "$BPcomp | ";
echo "
";
echo "";
echo "| Warranty | ";
echo "$BPins | ";
echo "
";
break;
}
echo "";
echo "| Job Out-Sourced To: | ";
echo "$isOutSourced | ";
echo "
";
echo "";
echo "| Date Transferred To $isOutSourcedCode: | ";
echo "$dateTransTo | ";
echo "
";
echo "";
echo "| $isOutSourcedCode Competion Date: | ";
echo "$dateReturned | ";
echo "
";
echo "";
echo "| Closed Date: | ";
echo "".$closedDate." | ";
echo "
";
}
echo "
";
echo "
";
echo "