File manager

File manager - Edit - /home/autoph/public_html/connect/home/search_vehicle_history.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:400px; overflow:auto; border:1px solid gray; } #submit_name{ width:30%; min-width:150px; margin:20px; padding:20px; } #name, textarea{ width:100%; } </style> </head> <body> <?php if(isset($_GET['view'])){ echo "<div style='min-width:600px;min-height:300px;width:50%;height:60%;border:0px solid red;margin:20px;position:absolute;z-index:99999;top:10px;left:10px;background:white;'>"; 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'> TRANSFER INFORMATION: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=9&ex=refresh' class='hideClick hidden' > ♲ </a><!--REFRESH/RELOAD WINDOW--> <a href='mainindex.php?id=9&ex=true' class='hideClick hidden' > ✉ </a> <!--EXTRACT LIST OF COMPANY AND EXPORT TO EXCEL--> <a href='mainindex.php?id=9' class='hideClick hidden' style='font-weight:bold'> ✕ </a> </div> </div>"; echo "<div style='border:0px solid red; padding:10px;margin:10px;height:90%;background: #ebe6e8 '>"; $selPlate=$_GET['view']; $dealOwner = mysql_result(mysql_query("SELECT `t_deal_id` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $dealOwnerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealOwner'"),0); $carBrand = mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0); $carModel = mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0); $carModel = mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0); $serviceOwnedBy = mysql_result(mysql_query("SELECT `t_deal_id` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $serviceTransDate = mysql_result(mysql_query("SELECT `t_trans_date` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $serviceTransTime = mysql_result(mysql_query("SELECT `t_trans_time` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $tServiceNotes= mysql_result(mysql_query("SELECT `t_service_notes` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $serviceOwnedByName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$serviceOwnedBy'"),0); $tServiceStatus =mysql_result(mysql_query("SELECT `t_service_status` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $tServiceStatusName =mysql_result(mysql_query("SELECT `service_desc` FROM `vts_service_status` WHERE `serv_id`='$tServiceStatus'"),0); $transDate =mysql_result(mysql_query("SELECT `t_arrived_date` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $transTime =mysql_result(mysql_query("SELECT `t_arrived_time` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $tNotes =mysql_result(mysql_query("SELECT `t_notes` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); if($transDate===''){ $transDateR='IN-TRANSIT'; }else{ $transDateR=$transDate; } if($transTime===''){ $transTimeR='IN-TRANSIT'; }else{ $transTimeR=$transTime; } $currentLocation = mysql_result(mysql_query("SELECT `t_trans_to_dealer_id` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $currentLocationName=mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$currentLocation'"),0); $lastMove = mysql_result(mysql_query("SELECT `action_id` FROM `vts_vehicle_lists` WHERE `v_plate`='$selPlate'"),0); $lastMoveLocation = mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='$lastMove'"),0); $transBy=mysql_result(mysql_query("SELECT `t_trans_by` FROM `vts_vehicle_transfer_for_service` WHERE `t_plate`='$selPlate'"),0); $transByName = mysql_result(mysql_query("SELECT `u_name` FROM `vts_users` WHERE `u_id`='$transBy'"),0); echo "<div style='width:49%;margin:3px;float:left;font-size:14px;font-family:Verdana;font-weight:normal;color:black;border:1px solid gray;padding:5px;position:relative'> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Plate No.</b>".$selPlate."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>V. Model.</b>".$carModel."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>V. Brand</b>".$carBrand."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Service Owned By:</b>".$serviceOwnedByName."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Last Action:</b>".$lastMoveLocation."<br> </div>"; echo "<div style='width:49%;margin:3px;float:left;font-size:14px;font-family:Verdana;font-weight:normal;color:black;border:1px solid gray;padding:5px;position:relative'> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Transferred To.</b>".$currentLocationName."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Transferred By:</b>".strtoupper($transByName)."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Transferred Date:</b>".$serviceTransDate ." \| ".$serviceTransTime."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Received Date:</b>".$transDateR."<br> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Received Time:</b>".$transTimeR."<br> </div>"; echo "<div style='width:99%;margin:3px;float:left;font-size:14px;font-family:Verdana;font-weight:normal;color:black;border:1px solid gray;padding:5px;position:relative'> <b style=' font-family:Verdana;font-size:12px;color: #605b5d ;font-weight:normal;'>Reason for Transfer:</b> <p style='padding-left:10px;font-family:Verdana;font-size:14px;color:black;border:1px solid lightgray ;font-weight:normal;padding:5px;background:#f3f0f1'>".$tNotes."</p><br> </div>"; echo "<div style='width:99%;margin:3px;float:left;font-size:14px;font-family:Verdana;font-weight:normal;color:black;border:1px solid gray;padding:5px;position:relative'> <b style=' font-family:Verdana;font-size:12px;color: #605b5d ;font-weight:normal;'>Service Remarks:</b> <p style='padding-left:10px;font-family:Verdana;font-size:14px;color:black;border:1px solid lightgray ;font-weight:normal;padding:5px;background:#f3f0f1;min-height:30px'>".$tServiceNotes. "</p> <b style='padding:10px;font-family:Verdana;font-size:11px;color: #605b5d ;font-weight:normal;line-height:25px;'>Service Status:</b>".$tServiceStatusName."<br> <br> </div>"; echo "</div>"; echo "</div>"; } ?> <div style='border:1px solid gray;width:99%;height:95%;min-height:540px;float:left;margin:0px;min-width:600px;background:white'> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:18px;color:#043062'> Vehicle Search: <div style='float:right;font-family:Verdana;font-size:15px;'> <a href='mainindex.php?id=9&ex=refresh' class='hideClick hidden' > ♲ </a><!--REFRESH/RELOAD WINDOW--> <a href='mainindex.php?id=9&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 id="comment_input_from" style='border-bottom:1px solid gray'> <form class='bgColor' id="lets_search" action="" style="float:left;padding:5px;width:45%;margin:0px auto;text-align:left;background:transparent"> <input type="text" name="searchV" id="searchV" style='margin-right:5px;float:left;width:50%;min-width:100px;height:50px;border:1px solid red;font-family:Verdana;font-weight:normal;font-size:20px;text-align:center;padding:5px' onkeyup="this.value = this.value.toUpperCase();"> <input type="submit" id="sendSearch" value="Search Plate" style='margin-right:5px;float:left;border:1px solid gray;min-width:50px;width:35%;font-size:16px;font-weight:normal;font-family:Verdana;height:50px;padding:5px'> </form> <form class='bgColor' id="search_ro" action="" style="float:right;padding:5px;width:45%;margin:0px auto;text-align:left;background:transparent"> <input type="text" id="viewRODetails" style='float:right;width:50%;min-width:100px;height:50px;border:1px solid red;font-family:Verdana;font-weight:normal;font-size:20px;text-align:center;padding:5px' onkeyup="this.value = this.value.toUpperCase();"> <input type="submit" id="searchRODetails" value="Search RO#" style='margin-right:5px;float:right;border:1px solid gray;min-width:50px;width:35%;font-size:16px;font-weight:normal;font-family:Verdana;height:50px;padding:5px'> </form> <div id="display_area" style='overflow:auto;border:1px solid gray;padding:5px;background:#f5f4f6;height:475px'> </div> </div> </div> </body> </html> <!-- JQUERY FROM GOOGLE API --> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script> <script type="text/javascript"> $(function() { $("#lets_search").bind('submit',function() { var value = $('#searchV').val(); if (value == "") { alert("Invalid Entry. Model Name is required."); return false; } $.post('search_load_found_unit.php',{value:value}, function(data){ $("#display_area").html(data); }); return false; }); }); $(function() { $("#search_ro").bind('submit',function() { var value = $('#viewRODetails').val(); if (value == "") { alert("Invalid Entry. Model Name is required."); return false; } $.post('search_load_found_ro.php',{value:value}, function(data){ $("#display_area").html(data); }); return false; }); }); </script>

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