";
$selPlate=$_GET['view'];
$dealOwner = mysql_result(mysql_query("SELECT `t_deal_id` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$dealOwnerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealOwner'"),0);
$carBrand = mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0);
$carModel = mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0);
$carModel = mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0);
$serviceOwnedBy = mysql_result(mysql_query("SELECT `t_deal_id` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$serviceTransDate = mysql_result(mysql_query("SELECT `t_trans_date` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$serviceTransTime = mysql_result(mysql_query("SELECT `t_trans_time` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$tServiceNotes= mysql_result(mysql_query("SELECT `t_service_notes` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$serviceOwnedByName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$serviceOwnedBy'"),0);
$tServiceStatus =mysql_result(mysql_query("SELECT `t_service_status` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$tServiceStatusName =mysql_result(mysql_query("SELECT `service_desc` FROM `vts_service_status` WHERE `serv_id`='$tServiceStatus'"),0);
$transDate =mysql_result(mysql_query("SELECT `t_arrived_date` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$transTime =mysql_result(mysql_query("SELECT `t_arrived_time` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$tNotes =mysql_result(mysql_query("SELECT `t_notes` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
if($transDate===''){
$transDateR='IN-TRANSIT';
}else{
$transDateR=$transDate;
}
if($transTime===''){
$transTimeR='IN-TRANSIT';
}else{
$transTimeR=$transTime;
}
$currentLocation = mysql_result(mysql_query("SELECT `t_trans_to_dealer_id` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$currentLocationName=mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$currentLocation'"),0);
$lastMove = mysql_result(mysql_query("SELECT `action_id` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0);
$lastMoveLocation = mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='$lastMove'"),0);
$transBy=mysql_result(mysql_query("SELECT `t_trans_by` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0);
$transByName = mysql_result(mysql_query("SELECT `u_name` FROM `vts_users` WHERE `u_id`='$transBy'"),0);
echo "
Plate No.".$selPlate."
V. Model.".$carModel."
V. Brand".$carBrand."
Service Owned By:".$serviceOwnedByName."
Last Action:".$lastMoveLocation."
";
echo "
Transferred To.".$currentLocationName."
Transferred By:".strtoupper($transByName)."
Transferred Date:".$serviceTransDate ." | ".$serviceTransTime."
Received Date:".$transDateR."
Received Time:".$transTimeR."
";
echo "
Reason for Transfer:
".$tNotes."
";
echo "
Service Remarks:
".$tServiceNotes.
"
Service Status:".$tServiceStatusName."
";
echo "