File manager

File manager - Edit - /home/autoph/public_html/connect/home/search_load_found_vehicles.php

Back
<?php include 'core/init.php'; //$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); //error_reporting(1); ?> <script language="javascript" type="text/javascript"> function showCustDetails(row) { var x=row.cells; document.getElementById("loadCustData").value = x[0].innerHTML; //document.getElementById("customerID").value = x[0].innerHTML; document.getElementById("loadCDFName").value = x[1].innerHTML; document.getElementById("loadCDLName").value = x[2].innerHTML; document.getElementById("loadCDMName").value = x[3].innerHTML; document.getElementById("loadCDGender").value = x[4].innerHTML; document.getElementById("loadCDBirthDate").value = x[5].innerHTML; document.getElementById("loadCDMobile").value = x[6].innerHTML; document.getElementById("loadCDEmail").value = x[7].innerHTML; document.getElementById("loadCDFBAccnt").value = x[8].innerHTML; document.getElementById("loadCDTWAccnt").value = x[9].innerHTML; document.getElementById("loadCDIGAccnt").value = x[10].innerHTML; document.getElementById("loadViberAccnt").value = x[11].innerHTML; document.getElementById("loadCDHomeAddress").value = x[12].innerHTML; document.getElementById("svEditRegion").value = x[13].innerHTML; document.getElementById("svEditMunicipality").value = x[14].innerHTML; document.getElementById("svEditCity").value = x[15].innerHTML; document.getElementById("svEditBrgy").value = x[16].innerHTML; document.getElementById("svEditBusinessName").value = x[17].innerHTML; document.getElementById("svEditSector").value = x[18].innerHTML; //document.getElementById("svEditBusinessName").value = x[13].innerHTML; //document.getElementById("svEditSector").value = x[14].innerHTML; } function viewCustTable() { var div = document.getElementById("custMoreInfo"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = ''; } } function viewCustTableHide() { var div = document.getElementById("custMoreInfo"); if (div.style.display == 'none') { div.style.display = 'none'; } else { div.style.display = 'none'; } } function viewPicLoader() { var div = document.getElementById("picLoader"); if (div.style.display == '') { div.style.display = 'none'; } else { div.style.display = ''; } } </script> <!--SHOW MUNICIPATILITES BASED ON SELECTED REGION--> <script> //show municipalities based onselected region_code` function showMunicipalityList(str) { if (str == "") { document.getElementById("svEditMunicipality").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("svEditMunicipality").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","add_new_load_municipality_based_on_selected_region.php?q="+str,true); xmlhttp.send(); } } //show municipalities based onselected region_code` function showCityList(str) { if (str == "") { document.getElementById("svEditCity").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("svEditCity").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","add_new_load_city_based_on_selected_municipality_editMode.php?q="+str,true); xmlhttp.send(); } } //show Brangays function showBrgyLists(str) { if (str == "") { document.getElementById("svEditBrgy").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("svEditBrgy").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","add_new_load_barangays_based_on_selected_city_editMode.php?q="+str,true); xmlhttp.send(); } } </script> <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"); }); //UPDATING Record $("#updateCustInfo").click(function(){ var loadCustData= $("#loadCustData").val(); var loadCDFName= $("#loadCDFName").val(); var loadCDLName= $("#loadCDLName").val(); var loadCDMName= $("#loadCDMName").val(); var loadCDGender= $("#loadCDGender").val(); var loadCDBirthDate= $("#loadCDBirthDate").val(); var loadCDMobile= $("#loadCDMobile").val(); var loadCDEmail= $("#loadCDEmail").val(); var loadCDHomeAddress= $("#loadCDHomeAddress").val(); var svSalesAgent= $("#svSalesAgent").val(); var loadCDFBAccnt= $("#loadCDFBAccnt").val(); var loadCDIGAccnt= $("#loadCDIGAccnt").val(); var loadCDTWAccnt= $("#loadCDTWAccnt").val(); var svEditBrgy= $("#svEditBrgy").val(); var svEditCity= $("#svEditCity").val(); var svEditMunicipality= $("#svEditMunicipality").val(); var svEditRegion= $("#svEditRegion").val(); var svEditBusinessName= $("#svEditBusinessName").val(); var svEditSector= $("#svEditSector").val(); if (loadCDLName == "") { alert("Error: Please input Lastname"); return false; } if (loadCDFName == "") { alert("Error: Please input Firsname"); return false; } if (loadCDMobile == "") { alert("Error: Please input Mobile Number"); return false; } if (loadCDEmail == "") { alert("Error: Please input E-mail Address"); return false; } $.ajax({ url: "sub_save_edited_customer_data.php", type: "POST", async: false, data: { "done": 1, "loadCustData" : loadCustData, "svEditBusinessName" : svEditBusinessName, "svEditCity" : svEditCity, "svEditBrgy" : svEditBrgy, "svEditSector" : svEditSector, "svEditMunicipality" : svEditMunicipality, "svEditRegion" : svEditRegion, "loadCDFName" : loadCDFName, "loadCDLName" : loadCDLName, "loadCDMName" : loadCDMName, "loadCDGender" : loadCDGender, "loadCDBirthDate" : loadCDBirthDate, "loadCDMobile" : loadCDMobile, "loadCDEmail" : loadCDEmail, "loadCDHomeAddress" : loadCDHomeAddress, "loadCDFBAccnt" : loadCDFBAccnt, "svSalesAgent" : svSalesAgent, "loadCDIGAccnt" : loadCDIGAccnt, "loadCDTWAccnt" : loadCDTWAccnt }, success: function(data){ alert("Update complete..."); } }) }); }); </script> <SCRIPT LANGUAGE="JavaScript"> <!-- myPopup = ''; function openPopup(url) { myPopup = window.open('upload_profile_pic.php?cid=','popupWindow','width=550,height=320','menubar=no, toolbar=no, location=no, directories=no, status=no, scrollbars=no, resizable=no, dependent, width=550, height=320, left=0, top=0'); if (!myPopup.opener) myPopup.opener = self; } //--></SCRIPT> <?php if(isset($_POST['done'])){ $searchString = mysql_escape_string($_POST['searchString']); $result = mysql_query("SELECT * FROM `vts_vehicle_lists` WHERE `v_plate` LIKE '%$searchString%' \|\| `v_conduction` LIKE '%$searchString%' ORDER BY `v_plate` ASC"); if(mysql_num_rows($result) > 1){ $textMsg = "Search Results"; }else{ $textMsg = "Search Result"; } echo "<div class='bgColor' style='background:lightgray;vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:14px;color:#043062'> ✛ ".$textMsg." (".mysql_num_rows($result).") </div>"; echo "<div style='width:100%;height:550px;border:0px solid red;overflow:auto'>"; echo "<div style='width:2000px;height:440px;border:0px solid red'>"; echo "<table style='width:100%;'>"; echo "<thead> <tr> <th>PLATE</th> <th>CONDUCTION</th> <th>BRAND</th> <th>MODEL</th> <th>TYPE</th> <th>MAKE</th> <th>COLOR</th> <th>CUSTOMER NAME</th> <th>COMPANY</th> <th>LAST PMS DATE</th> <th>SOURCE DEALER</th> <th>TRANS. TYPE</th> <th>GAS TYPE</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ ?><tr onclick="javascript:showCustDetails(this);" ondblclick="viewCustTable()"><?php echo "<td>".$row['v_plate']."</td>"; echo "<td>".$row['v_conduction']."</td>"; echo "<td>".$row['v_brand']."</td>"; echo "<td>".$row['v_model']."</td>"; echo "<td>".$row['v_type']."</td>"; echo "<td>".$row['v_make']."</td>"; echo "<td>".$row['v_color']."</td>"; echo "<td>"; $getFName = mysql_result(mysql_query("SELECT `cust_lname` FROM `vts_customers` WHERE `c_id`='".$row['cust_id']."'"),0); $getLName = mysql_result(mysql_query("SELECT `cust_fname` FROM `vts_customers` WHERE `c_id`='".$row['cust_id']."'"),0); echo $getLName .", " . $getFName; echo "</td>"; echo "<td>"; $getCName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='".$row['v_owner_fleet_id']."'"),0); echo $getCName; echo "</td>"; echo "<td>".$row['v_last_pms_date']."</td>"; echo "<td>".$row['sold_by_dealer']."</td>"; echo "<td>".$row['v_gear']."</td>"; echo "<td>".$row['gas']."</td>"; echo "</tr>"; } echo "</table>"; echo"</div>"; echo"</div>"; exit(); } ?>

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