format("Y/m/d");
$toTime =Explode(":", date('H:i:s'));
$currentTime = date("H:i:s");
$query = mysql_query("SELECT * FROM vts_vehicle_lists WHERE v_plate='".$_POST['value']."'");
$vPlate=$_POST['value'];
$checkIfWIthOpenTransfer = mysql_result(mysql_query("SELECT COUNT(`t_id`) FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$vPlate' AND `t_deal_id`='$dealID' AND `closed`='0'"),0);
?>
0){
echo ''; //=========================================================
echo '
';
echo "
";
?>
';
$getData = mysql_query("SELECT * FROM `vts_vehicle_lists` WHERE `v_plate`='$vPlate'");
echo "
";
while($row=mysql_fetch_array($getData)){
$custID = $row['cust_id'];
$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);
$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);
echo "";
echo "| Sold By: | ";
echo "".$sellerDealer." | ";
echo "
";
echo "";
echo "| Vehicle Brand: | ";
echo "".$row['v_brand']." | ";
echo "
";
echo "";
echo "| Vehicle Plate: | ";
echo "".$row['v_plate']." | ";
echo "
";
echo "";
echo "| Varriant: | ";
echo "".$row['v_model']." | ";
echo "
";
echo "";
echo "| Make: | ";
echo "".$row['v_make']." | ";
echo "
";
echo "";
echo "| Color: | ";
echo "".$row['v_color']." | ";
echo "
";
echo "";
echo "| Dealer Location: | ";
echo "".$vLocation." | ";
echo "
";
echo "";
echo "| Last Action Taken: | ";
echo "".$vAction." | ";
echo "
";
echo "";
echo " | ";
echo "
";
echo "";
echo "| CUSTOMER INFORMATION: | ";
echo " | ";
echo "
";
echo "";
$custFName = mysql_result(mysql_query("SELECT `cust_fname` FROM `vts_customers` WHERE `c_id`='$custID'"),0);
$custLName = mysql_result(mysql_query("SELECT `cust_lname` FROM `vts_customers` WHERE `c_id`='$custID'"),0);
$vEmail = mysql_result(mysql_query("SELECT `cust_email` FROM `vts_customers` WHERE `c_id`='$custID'"),0);
$vMobile = mysql_result(mysql_query("SELECT `cust_mobile` FROM `vts_customers` WHERE `c_id`='$custID'"),0);
$gender = mysql_result(mysql_query("SELECT `cust_mobile` FROM `vts_customers` WHERE `c_id`='$custID'"),0);
$fb = mysql_result(mysql_query("SELECT `cust_fb` FROM `vts_customers` WHERE `c_id`='$custID'"),0);
echo "| Full Name: | ";
echo "".$custFName." ".$custLName." | ";
echo "
";
echo "";
echo "| Contact Information: | ";
echo "".$vMobile." | ";
echo "
";
echo "";
echo "| E-mail Address: | ";
echo "".$vEmail ." | ";
echo "
";
echo "";
echo "| Gender: | ";
echo " ".$gender." | ";
echo "
";
echo "";
echo "| FB Account: | ";
echo "".$fb." | ";
echo "
";
}
echo "
";
echo "
";
echo "
';
echo "
";
//VEHICLE SERVICE INFORMATION DATA GOES HERE...
$getINOUT = mysql_query("SELECT * FROM `vts_service_transaction` WHERE `s_v_plate`='$vPlate' ORDER BY `s_date`, `s_time` DESC");
echo "
";
echo "";
echo "| RO# | ";
echo "Type | ";
echo "date In | ";
echo "Date Closed | ";
echo "Reason | ";
echo "
";
while($sRow=mysql_fetch_array($getINOUT)){
$viewRO = $sRow['s_ro_no'];
$dealCHKID = $sRow['s_deal_code'];
$dealActionID = $sRow['location_code'];
$dealCHKName = mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$dealCHKID'"),0);
$sByID = $sRow['add_by'];
$addByName= mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `add_by`='$sByID'"),0);
$sType= $sRow['s_appt_type'];
$sTypeName= mysql_result(mysql_query("SELECT `code` FROM `vts_service_type` WHERE `serv_id`='$sType'"),0);
$tSlot = mysql_result(mysql_query("SELECT `time_slot` FROM `vts_service_slots` WHERE `slot_id`='".$sRow['time_slot_code']."'"),0);
?>".$sRow['s_ro_no']."";
echo "| ".$sRow['s_appt_type']." | ";
echo "".$sRow['appt_date']." | ";
echo "".$sRow['date_closed']." | ";
echo "".$sRow['closed_reason']." | ";
echo "
";
}
echo "
";
echo "
Check-In / Check-Out History:
";
echo "";
echo "| Date | ";
echo "Time | ";
echo "TR | ";
echo "K.M | ";
echo "LOC | ";
echo "Tran | ";
echo "
";
while($cRow=mysql_fetch_array($getINOUT)){
$dealCHKID = $cRow['dealer_code'];
$dealActionID = $cRow['location_code'];
$dealCHKName = mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$dealCHKID'"),0);
$dealActionID = $cRow['location_code'];
$dealActionName = mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='$dealActionID'"),0);
$outByID = $cRow['user_id'];
$outByName= mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='$dealActionID'"),0);
echo "";
echo "| ".$cRow['date']." | ";
echo "".$cRow['time']." | ";
echo "".$cRow['chk_transaction']." | ";
echo "".$cRow['chk_km']." | ";
echo "".$dealCHKName." | ";
echo "".$dealActionName." | ";
echo "
";
}
echo "
";
echo "";
//=========================================================
echo "";
}else{
echo "No Record Fountd.";
}
?>