File manager

File manager - Edit - /home/autoph/public_html/voc/home/check_save_in_out.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); $vPlate=$_POST['value']; $query = mysql_query("SELECT * FROM vts_vehicle_lists WHERE v_plate='".$vPlate."'"); //echo $vPlate; if(mysql_num_rows($query) > 0){ //echo "<p style='padding:5px'>".mysql_num_rows($query). " Record Found.</p>"; echo '<div style="width:100%;border:0px solid red;text-align:left;float:left:font-family:Verdana;font-size:14px;font-weight:normal;padding:10px;">Vehicle Information:</div> <table style="width:99%">'; while ($data = mysql_fetch_array($query)) { echo '<tr style=""> <td style="font-size:12px;border:0px solid red;padding:5px;background:#faf3a5;padding:10px;">Plate: <b style="padding:3px;font-family:Verdana;font-size:16px;font-weight:normal;color:red">'.$data["v_plate"].'</b></td> <td style="font-size:12px;border:0px solid red;padding:5px;background:#faf3a5;padding:10px;">Brand: <b style="padding:3px;font-family:Verdana;font-size:16px;font-weight:normal;color:red">'.$data["v_brand"].'</b></td> <td style="font-size:12px;border:0px solid red;padding:5px;background:#faf3a5;padding:10px;">Model: <b style="padding:3px;font-family:Verdana;font-size:16px;font-weight:normal;color:red">'.$data["v_model"].'</b></td> <td style="font-size:12px;border:0px solid red;padding:5px;background:#faf3a5;padding:10px;">Color: <b style="padding:3px;font-family:Verdana;font-size:16px;font-weight:normal;color:red">'.$data["v_color"].'</b></td> </tr>'; $vStat=$data['v_in_out']; } echo "<form id='UpdateInOut' action='' style='width:100%;margin:0 text-align:center;padding:10px;bo'>"; echo "<tr> <td colspan='3' style='width:80%;text-align:left;background:white;border:0px solid red;font-size:14px;height:110px'>"; echo "Select Reason:<br><select id='location' style='width:90%;min-width:150px;float:left;'> <option value='0'></option>"; $optionSQL=mysql_query("SELECT * FROM `vts_check_out_reasons` WHERE `out_status`='1' ORDER BY `out_description` ASC"); while($out=mysql_fetch_array($optionSQL)){ echo "<option value='".$out['out_id']."'>".$out['out_description']."</option>"; } echo "</select>"; echo "</td>"; echo "<td style='width:20%;text-align:left;background:white;border:0px solid red;font-size:14px;'>Kilometer Reading:<br> <input type='text' id='kmReading'> </td>"; echo "</tr>"; echo "<tr> <td colspan='4' style='text-align:center;background:white;border:0px solid blue;border-top:10px solid white;text-align:center;font-size:40px;height:120px'>"; echo "<input type='hidden' id='plate' value='".$vPlate."'> <input type='hidden' id='companyCode' value=".$compID."> <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.">"; echo "<input type='submit' id='checkIn' value='CHECK-IN' style='float:left;font-size:24px;font-weight:bold;font-family:Verdana;height:80px;width:30%; '>"; echo "<input type='submit' id='checkOut' value='CHECK-OUT' style='float:right;font-size:24px;font-weight:bold;font-family:Verdana;height:80px;width:30%;margin-right:20px;'>"; echo "</form>"; echo "</td> </tr>"; echo '</table>'; }else{ echo "No Record Fountd."; } // 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 $("#checkIn").click(function(){ var plate = $("#plate").val(); var kmReading = $("#kmReading").val(); var location = $("#location").val(); var addBy = $("#myUserID").val(); var addDate = $("#addDate").val(); var addTime = $("#myCurrentTime").val(); var companyCode= $("#companyCode").val(); var dealerID= $("#dealerID").val(); var trans= 'IN'; if (plate == "") { alert("Invalid Entry. Missing Plate or Plate not exist."); return false; } if (kmReading == "") { alert("Invalid Entry. Please input Kilometer Reading."); return false; } if (location == "") { alert("Invalid Entry. Please select Check-in Reason."); return false; } $.ajax({ url: "sub_check_in_vehicle.php", type: "POST", async: false, data: { "done": 1, "plate" : plate, "companyCode" : companyCode, "dealerID" : dealerID, "kmReading" : kmReading, "location" : location, "addDate" : addDate, "addTime" : addTime, "trans": trans, "addBy" : addBy }, success: function(data){ alert("Vehicle has been Checked-In"); //displayFromDatabase(); $('#kmReading').val(''); $('#location').val(''); } }) }); //alert("Its working"); FOR CHECKING OUT VEHICLE $("#checkOut").click(function(){ var plate = $("#plate").val(); var kmReading = $("#kmReading").val(); var location = $("#location").val(); var addBy = $("#myUserID").val(); var addDate = $("#addDate").val(); var addTime = $("#myCurrentTime").val(); var companyCode= $("#companyCode").val(); var dealerID= $("#dealerID").val(); var trans= 'OUT'; if (plate == "") { alert("Invalid Entry. Missing Plate or Plate not exist."); return false; } if (kmReading == "") { alert("Invalid Entry. Please input Kilometer Reading."); return false; } if (location == "") { alert("Invalid Entry. Please select Check-in Reason."); return false; } $.ajax({ url: "sub_check_in_vehicle.php", type: "POST", async: false, data: { "done": 1, "trans": trans, "plate" : plate, "companyCode" : companyCode, "dealerID" : dealerID, "kmReading" : kmReading, "location" : location, "addDate" : addDate, "addTime" : addTime, "addBy" : addBy }, success: function(data){ alert("Vehicle has been Checked-Out"); displayFromDatabase(); $('#kmReading').val(''); $('#location').val(''); } }) }); });

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