File manager

File manager - Edit - /home/autoph/public_html/voc/home/trans_load_checedin_vehicle.php

Back
<?php include 'core/init.php'; $userID=$user_data['u_id']; $dealID= $user_data['dealer']; $compID= $user_data['company']; $toDate = date_create() ->format("Y/m/d"); $toTime =Explode(":", date('H:i:s')); $currentTime = date("H:i:s"); $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); $svRO=$_POST['value']; $query = mysql_query("SELECT * FROM vts_service_transaction WHERE s_ro_no='".$_POST['value']."'"); $checkIfWIthOpenTransfer = mysql_result(mysql_query("SELECT `transferred_to` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0); if(mysql_num_rows($query) > 0){ ?><div style='border:1px solid gray;width:100%;height:100%;float:left;margin:0px;min-width:400px;background:white'> <div class='bgColor' style='vertical-align:top;height:25px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;color:#043062'> Vehicle Information: <div style='float:right;font-family:Verdana;font-size:15px'> <a href='mainindex.php?id=9&d=1' style='font-weight:bold'> ✕ </a> </div> </div><?php echo '<center>'; while ($data = mysql_fetch_array($query)) { $fPlate=$data["s_v_plate"]; $fBrand=$data["brand_id"]; $fModel=$data["model_id"]; } echo "<div style='float:left;width:49.5%;border:1px solid gray;height:100%;min-height:361px;margin:2px;padding:5px;text-align:left;background: #f2efeb '>"; echo "<form id='UpdateInOut' style='height:100%'>"; echo "<div style='border:0px solid red;height:80px;padding:2px'>"; echo "<b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal'>Select Destination:</b> <select id='Destination' style='text-align:left;width:100%;min-width:150px;float:left;font-size:12px;border:1px solid black'> <option value='0'></option>"; $optionSQL=mysql_query("SELECT * FROM `vts_dealerships` WHERE `deal_status`='1' ORDER BY `deal_name` ASC"); while($out=mysql_fetch_array($optionSQL)){ echo "<option value='".$out['deal_id']."'>".$out['deal_name']."</option>"; } echo "</select>"; echo "</div>"; //$apptDate = mysql_escape_string($_POST['apptDate']); //$newApptDate = date_format(date_create_from_format('Y-m-d', $apptDate), 'Y/m/d'); //transDate echo "<div style='border:0px solid red;height:70px;padding:2px'>"; echo "<b style=' background: #f2efeb ;font-size:12px;color:black;font-weight:normal'>Transfer Date:</b> <br>"; echo "<input type='date' id='transDate' style='padding:5px;text-align:left;width:20%;min-width:150px;float:left;font-size:14px;border:1px solid black'> "; echo "</div>"; echo "<div style='border:0px solid red;height:70px;padding:2px'>"; echo "<b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal'>Service Request/Instruction:</b><br>"; echo "<textarea rows='2' id='serviceRequestInfo' style='width:100%;padding:5px;border:1px solid black;min-width:500px;'></textarea>"; echo "<input type='hidden' id='vRONumber' value='".$svRO."'> <input type='hidden' id='companyCode' value=".$compID."> <input type='hidden' id='fPlate' value=".$fPlate."> <input type='hidden' id='myUserID' value=".$userID."> <input type='hidden' id='addDate' value=".$toDate."> <input type='hidden' id='myCurrentTime' value=".$currentTime."> <input type='hidden' id='dealerID' value=".$dealID.">"; if($checkIfWIthOpenTransfer !='NA'){ $transToDealID = mysql_result(mysql_query("SELECT `transferred_to` FROM `vts_service_transaction` WHERE `s_ro_no`='$svRO' AND `service_status`='0'"),0); $transToDealName=mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$transToDealID'"),0); echo "<br> <center><input type='submit' id='xxxx' disabled value='Confirm' style='background:lightgray;font-size:20px;font-weight:bold;font-family:Verdana;height:60px;width:50%;margin-right:10px;'></center>"; echo "<br> <i style='font-family:Verdana;color:red;padding:3px;font-size:12px;background:yellow'>Error! Duplicate Entry Detected. Unit currently assigned/transferred to ".$transToDealName."</i></b>"; }else{ echo "<br><br><center><input type='submit' id='sendRequest' value='Confirm' style='font-size:22px;font-weight:bold;font-family:Verdana;height:60px;width:50%;margin-right:0px;'></center>"; } echo "</div>"; echo "</form>"; echo "</div>"; echo "<div style='float:right;width:49.5%;border:1px solid gray;height:100%;min-height:361px;margin:2px;padding:5px;text-align:left;background:#f2efeb '>"; echo "<div class='bgColor' style='vertical-align:top;height:25px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;color:#043062'> Service Information: <div style='float:right;font-family:Verdana;font-size:15px'> <a href='mainindex.php?id=9&d=1' style='font-weight:bold'> ✕ </a> </div> </div>"; $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 "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;margin-right:20px'>RO Number:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$svRO."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Plate Number:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$plateN."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Vehicle Brand:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$brandName."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Vehicle Model:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$modelName."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Job Type:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$jobType."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Appointment Date:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$apptDateS."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Appoitment Time:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$timeSlName."</b>"; switch($jobType){ case 'QS': echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>SSP Paid:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$qsSSP."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Company P.O:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$qsComp."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Customer Paid:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$qsCust."</b>"; break; case 'BP': echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Customer Paid:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$bpCust."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Warranty Claim:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$bpWar."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Paid by Insurance:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$bpIns."</b>"; break; case 'GJ': echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Customer Paid:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$gjCust."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Company P.O:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$gjComp."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Warranty Claim:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$gjWar."</b>"; echo "<br><b style='padding:3px;background: #f2efeb ;font-size:12px;color:black;font-weight:normal;color:#535251;line-height:200%;margin-right:20px'>Warranty Type:</b>"; echo "<b style='font-family:Verdana;color:black;font-weight:normal;font-size:14px'>".$gjWarSub."</b>"; break; } echo "</div>"; }else{ echo "No Record Fountd."; } echo "</div>"; // IDS plate checkIn checkOut kmReading location ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:69px;height:89px;border:0px solid red;position:absolute;top:50%;left:50%;padding:2px;"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Loading..</div> <!-- add jquery --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //loading gif animator during query or page load $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //alert("Its working"); FOR CHECKING IN VEHICLE $("#sendRequest").click(function(){ var vRONumber = $("#vRONumber").val(); var serviceRequestInfo = $("#serviceRequestInfo").val(); var Destination = $("#Destination").val(); var addBy = $("#myUserID").val(); var addDate = $("#addDate").val(); var addTime = $("#myCurrentTime").val(); var companyCode= $("#companyCode").val(); var transDate= $("#transDate").val(); var dealerID= $("#dealerID").val(); var fPlate= $("#fPlate").val(); if (vRONumber == "") { alert("Invalid Entry. Missing vRONumber or Plate not exist."); return false; } if (transDate == "") { alert("Invalid Entry. Please input transfer date."); return false; } if (serviceRequestInfo == "") { alert("Invalid Entry. Service Request information is required."); return false; } if (Destination == "") { alert("Invalid Entry. Please select Destination."); return false; } $.ajax({ url: "sub_transfer_request_save.php", type: "POST", async: false, data: { "done": 1, "vRONumber" : vRONumber, "companyCode" : companyCode, "dealerID" : dealerID, "transDate" : transDate, "serviceRequestInfo" : serviceRequestInfo, "Destination" : Destination, "addDate" : addDate, "fPlate" : fPlate, "addTime" : addTime, "addBy" : addBy }, success: function(data){ alert("Transfer Request has been saved..."); $('#serviceRequestInfo').val('')=""; $('#Destination').val('')=""; } }) }); }); </script>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings