File manager - Edit - /home/autoph/public_html/voc/home/active_service_pending_ur.php
Back
<html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> .loader { border: 16px solid #f3f3f3; border-radius: 50%; border-top: 16px solid blue; border-bottom: 16px solid blue; width: 120px; height: 120px; -webkit-animation: spin 2s linear infinite; animation: spin 2s linear infinite; } @-webkit-keyframes spin { 0% { -webkit-transform: rotate(0deg); } 100% { -webkit-transform: rotate(360deg); } } @keyframes spin { 0% { transform: rotate(0deg); } 100% { transform: rotate(360deg); } } </style> <title></title> <style type="text/css"> body{ background:#fafcfc; } a{ text-decoration:none; } } #wrapper{ width:50%; height:auto; margin:10px auto; border:1px solid #cbcbcb; background:white; } #comment_input_from li{ list-style-type:none; margin:5px auto; } #comment_input_from{ width:100%; margin:0px; background: #dde2e4 ; padding:10px; } #display_area{ width:100%; margin:00px auto; background:#fafcfc; padding:2px; height:200px; overflow:auto; border:0px solid gray; } #submit_name{ width:30%; min-width:150px; margin:20px; padding:20px; } #name, textarea{ width:100%; } </style> </head> <script language="javascript" type="text/javascript"> function showRow(row) { var x=row.cells; document.getElementById("SelRONumberA").value = x[1].innerHTML; document.getElementById("searchPlate").value = x[0].innerHTML; } </script> <body> <div id="showActiveService" style='display:block;border:1px solid gray;width:100%;height:100%;float:left;margin:0px;padding:2px;min-width:400px;background:white'> <div style='border:0px 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:2px;font-family:Verdana;font-weight:normal;color:#043062;padding-right:5px'> ☶ Active Service Repair <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=14&ex=refresh' class='hideClick hidden' > ♲ </a><!--REFRESH/RELOAD WINDOW--> <a href='mainindex.php?id=14&ex=true' class='hideClick hidden' > ✉ </a> <!--EXTRACT LIST OF COMPANY AND EXPORT TO EXCEL--> <a href='mainindex.php?id=1' class='hideClick hidden' style='font-weight:bold'> ✕ </a> </div> </div> <div class="bgColor" style='padding:8px;width:100%;height:65px'> <b style='margin-left:20px;padding-right:5px;font-family:Verdana;color:black;font-weight:normal'>⚲ Search Plate:</b> <input type="hidden" id="addBy" value="<?php echo $userID;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="addDate" value="<?php echo $toDate;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="addTime" value="<?php echo $myCurTime;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="sCompID" value="<?php echo $compID;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="hidden" id="sDealID" value="<?php echo $dealID;?>" style="width:200px;padding:5px;font-family:Verdana;font-size:14px"> <input type="text" id="searchPlate" disabled style="text-align:center;min=width:100px;width:20%;padding:5px;font-family:Verdana;font-size:14px" onkeyup="this.value = this.value.toUpperCase();"> <input type="text" id="SelRONumberA" style="width:100px;padding:5px;font-family:Verdana;font-size:14px"> <input type="submit" id="submit_search" value="Search..." style='margin-left:2px;padding:5px;width:100px;font-family:Verdana;font-size:14px;height:30px'> </div> <div id="display_area" style='border:1px solid lightgray;height:500px'> <?php echo "<table style='width:100%;'>"; echo "<thead> <tr> <th class='bgBlue;font-color:black;width:15%'>V. Plate</th> <th class='bgBlue;font-color:black;width:15%'>RO #</th> <th class='bgBlue;font-color:black;width:40%'>V. Brand</th> <th class='bgBlue;font-color:black;width:40%'>V. Model</th> <th class='bgBlue;font-color:black;width:15%'>Type </th> <th class='bgBlue;font-color:black;width:10%'>Date </th> <th class='bgBlue;font-color:black;width:10%'>Out-Sourced By:</th> <th class='bgBlue;font-color:black;width:10%'>Current Status </th> </tr> </thead>"; $result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_comp_code`='$compID' AND `s_deal_code`='$dealID' AND `service_status`='0' AND `s_ro_no`!='' || `transferred_to`='$dealID' AND `service_status`='0' AND `s_ro_no`!='' AND `transfer_return_date`='' ORDER BY `appt_date`, `time_slot_code` ASC"); while($row=mysql_fetch_array($result)){ $chkIfTransferred= $row['transferred_to']; $cBrand=mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0); $cModel=mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0); $getTransferID = $row['transferred_to']; if($getTransferID!='NA'){ $transferredToDealer=mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$getTransferID'"),0); }else{ $transferredToDealer=$getTransferID; } if($chkIfTransferred!='NA'){ $fColor='red'; }else{ $fColor=''; } ?><tr onclick="javascript:showRow(this);"><?php echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$row['s_v_plate']."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$row['s_ro_no']."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$cBrand."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$cModel."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$row['s_appt_type']."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$row['appt_date']."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>".$transferredToDealer."</td>"; echo "<td style='padding:5px;font-size:12px;color:$fColor'>"; $getStatLog = mysql_result(mysql_query("SELECT `paint_stage` FROM `vts_service_status_logs` WHERE `paint_stage`!='NA' AND `ro_number` = '".$row['s_ro_no']."' ORDER BY `log_id` DESC LIMIT 1"),0); if($getStatLog!='NA'){ $seperator='➤'; }else{ $seperator=''; } $genStatus = mysql_result(mysql_query("SELECT `status` FROM `vts_service_status_logs` WHERE `ro_number` = '".$row['s_ro_no']."' ORDER BY `log_id` DESC LIMIT 1"),0); $getGeneralStatus =mysql_result(mysql_query("SELECT `service_desc` FROM `vts_service_status` WHERE `serv_id` = '$genStatus' "),0); echo $getGeneralStatus." ".$seperator." ". $getStatLog; echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> </div> </div> </body> </html> <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"); $("#submit_search").click(function(){ var sDealID = $("#sDealID").val(); var sCompID = $("#sCompID").val(); var addBy = $("#addBy").val(); var addDate = $("#addDate").val(); var addTime = $("#addTime").val(); var SelRONumberA = $("#SelRONumberA").val(); var searchPlate = $("#searchPlate").val(); if (SelRONumberA == "") { alert("Invalid Input. Please input the correct plate number format."); return false; } $.ajax({ url: "sub_update_ongoing_service.php", type: "POST", async: false, data: { "done": 1, "sDealID": sDealID, "searchPlate" : searchPlate, "SelRONumberA" : SelRONumberA, "sCompID": sCompID, "addDate" : addDate, "addTime" : addTime, "addBy" : addBy }, success: function(data){ //alert("New Record Saved."); //showHide(); displayFromDatabase(); //$('#searchPlate').val(''); } }) }); }); //retrieve and display function displayFromDatabase(){ var sDealID = $("#sDealID").val(); var sCompID = $("#sCompID").val(); var addBy = $("#addBy").val(); var addDate = $("#addDate").val(); var addTime = $("#addTime").val(); var SelRONumberA = $("#SelRONumberA").val(); var searchPlate = $("#searchPlate").val(); $.ajax({ url: "sub_update_ongoing_service.php", type: "POST", async: false, data: { "display": 1, "sDealID": sDealID, "searchPlate" : searchPlate, "SelRONumberA" : SelRONumberA, "sCompID": sCompID, "addDate" : addDate, "addTime" : addTime, "addBy" : addBy }, success: function(d){ $("#display_area").html(d); } }); } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings