File manager - Edit - /home/autoph/public_html/connect/home/unit_reservation.php
Back
<!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <?php include 'core/database/connect.php'; error_reporting(0); $toDate = date_create() ->format("Y/m/d"); if(isset($_POST['Display'])){ $brandName = mysql_real_escape_string($_POST['brandName']); $UserCompanyName = mysql_real_escape_string($_POST['UserCompanyName']); $UserCompanyID = mysql_real_escape_string($_POST['UserCompanyID']); $MyUserID = mysql_real_escape_string($_POST['MyUserID']); } echo "<input type='hidden' id='ActiveCompanyCode' value='$UserCompanyName'>"; echo "<input type='hidden' id='bBrand' value='$brandName'>"; echo "<input type='hidden' id='myCompID' value='$UserCompanyID'>"; ?> <!--================================================ =====================================--> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:400px;height:100px;border:0px solid red;position:absolute;top:50%;left:45%;padding:2px;z-index:999999999999999999"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Scanning. Please wait....</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(){ $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); $("#goSearch").click(function(){ //alert("test"); //return false; var ActiveCompanyCode = $("#ActiveCompanyCode").val(); var bBrand = $("#bBrand").val(); var searchText = $("#searchText").val(); if (searchText == "") { $('#searchText').focus(); $('#searchText').css({'border-bottom':'1px solid red'}); $('#searchText').css({'color':'red'}); $('#searchText').attr("placeholder","Type something here (Cs No# / Unit Descriptoin"); return false; } //alert(bBrand); $.ajax({ url: "searchReservationResult.php", type: "POST", async: false, data: { "searchText":searchText, "ActiveCompanyCode":ActiveCompanyCode, "bBrand":bBrand, "searchDisplay": 1 }, success: function(d){ //invShowAssignMsg(); $("#viewInventoryPerModel").html(d); //invHideAssignMsg(); $('#searchText').val(''); } }) }); $("#deleteRecord").click(function(){ var resID = $("#resID").val(); var SelBrand = $("#SelBrand").val(); var myCompID = $("#myCompID").val(); if (resID == "") { alert('No record is selected...'); return false; } //alert(bBrand); $.ajax({ url: "DELETE_RESERVATION.php", type: "POST", async: false, data: { "resID":resID, "SelBrand":SelBrand, "myCompID":myCompID, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#viewInventory").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); }); function showClearanceInfo(row) { var x=row.cells; document.getElementById("resID").value = x[0].innerHTML; document.getElementById("SelBrand").value = x[4].innerHTML; } function hideDeleteForm(){ $("#deleteForm").fadeOut(300); }; function showDeleteForm(){ $("#deleteForm").fadeIn(300); }; </script> <!-- =======================IMPORT FORM===================================================== --> <div id="deleteForm" style="float:left;position:absolute;top:10px;left:10px;width:400px;height:200px;border:1px solid gray;background:white;display:none;z-index:999999999"> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#043062;text-align:left;'> ❑ DELETE RECORD: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='#' onclick='hideDeleteForm()' style='font-weight:bold'> ✕ </a> </div> </div> <p style='font-family:Calibri;font-size:20px;color:red;text-align:center'>ARE YOU SURE YOU WANT TO DELETE THIS RECORD? </p> <button id="deleteRecord" style='padding:10px;border:1px solid red;font-family:Calibri;font-size:18px;font-weight:bold;width:50%;margin-left:25%;text-align:center;'>YES</button> </div> </div> <!-- =======================IMPORT FORM===================================================== --> <div class='bodyTitle'>LIST OF RESERVED VEHICLES - <?php echo $brandName;?></div> <div class='bodyMenu'> <input type='text' id='searchText' placeholder="Search CS Number / Unit Description / Color" style='margin:0px;height:35px; float:left;;width:45%'> <button id="goSearch" style='height:35px; float:left;;width:15%;min-width:100px'>Search...</button> <button style='display:none;height:35px; float:left;width:10%;min-width:100px' onclick="showAddNewForm()" >✚ New </button> <button style='height:35px; float:left;width:10%;min-width:50px;font-family:AriL;font-size:24px;color:green;font-weight:bold' onclick="location.reload()" >↺</button> <button style='display:none;height:35px; float:left;width:10%;min-width:50px;font-family:AriL;font-size:24px;color:green;font-weight:bold' > </button> <input type="hidden" id="resID"> <input type="hidden" id="SelBrand"> <input type="hidden" id="bBrand"> </div> </div> <div id="viewInventory" style="padding:0px;width:100%;margin:0px;background:white;min-height:400px;max-height:500px;overflow:auto;float:left;border:0px solid gray"> <?php $brd = $brandName; $getBrand=mysql_query("SELECT * FROM `db_sc_request` WHERE `brand_name`= '$brd' AND `status`!='Cancelled' ORDER BY saved_date DESC"); //VALIDATE ACCESS //echo "COmpany ID:".$UserCompanyID; echo "<table id='mainModel' style='width:100%;margin:00px'>"; echo "<thead>"; echo "<th style='width:5%'>UNIT ID</th>"; echo "<th style='width:10%'>DATE</th>"; echo "<th style='width:20%'>SALES PERSON</th>"; echo "<th style='width:10%'>CS NUMBER</th>"; echo "<th style='width:10%'>BRAND</th>"; echo "<th style='width:20%'>VARIANT</th>"; echo "<th style='width:30%'>NOTES</th>"; echo "</thead>"; while($row=mysql_fetch_array($getBrand)){ $fName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$row['sc_id']."'"),0); $lName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$row['sc_id']."'"),0); $vID = $row['unit_id']; $company = mysql_result(mysql_query("SELECT `company` FROM `db_vehicle_inventory` WHERE `id`='$vID'"),0); $cs = mysql_result(mysql_query("SELECT `cs_number` FROM `db_vehicle_inventory` WHERE `id`='$vID'"),0); $unitCompID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_code`='$company'"),0); if($unitCompID == $UserCompanyID){ ?><tr onclick="javascript:showClearanceInfo(this);" ondblclick="showDeleteForm()"><?php echo "<td style='text-align:left;padding:5px'>".$row['req_id']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['saved_date']."</td>"; echo "<td style='text-align:left;padding:5px'>".$lName.", ".$fName."</td>"; echo "<td style='text-align:left;padding:5px'>".$cs."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['brand_name']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['variant_dest']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['notes']."</td>"; echo "</tr>"; } } echo "</table>"; //OF VALIDATION ?> </div> <div id="viewInventoryPerModel" style="padding:15px;width:100%;margin:0px;background: white;height:520px;overflow:auto;float:left;border:0px solid gray;border-top:1px solid gray"> <p style="font-family:Calibri;font-size:14px;color:gray;font-weight:normal;float:center;margin:40px">Search Result (0).</p> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings