File manager

File manager - Edit - /home/autoph/public_html/voc/home/service_transfer_request.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:1px 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:1px 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); $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:12px;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:12px;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:12px;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:12px;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:12px;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:12px;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:100%;min-height:300px;float:left;margin:5px;min-width:400px;background:white'> <div class='bgColor' style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-size:18px;font-family:Verdana;font-weight:normal;color:#043062'> Service Repair Transfer Module: <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:0px solid red;height:100%'> <form class='bgColor' id="lets_search" action="" style="padding:5px;width:100%;margin:0px auto;text-align:left"> <b style='font-family:Verdana;font-weight:normal;color:#043062'>Search RO Number:</b><br> <input type="text" name="searchV" id="searchV" style='width:30%;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..." style='border:1px solid red;min-width:50px;width:15%;font-size:20px;font-weight:bold;font-family:Verdana;height:50px;padding:5px'> </form> <div id="display_area" style='border:1px solid gray;height:450px'> <?php //$dealID= $user_data['dealer']; //$compID= $user_data['company']; //echo "Dealer: ". $dealID; //echo "company: ". $compID; $result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_comp_code`='$compID' AND `s_deal_code`='$dealID' AND `service_status`='0' ORDER BY `s_v_plate` ASC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th style='width:10%'>RO NUMBER.</th> <th style='width:10%'>PLATE NO.</th> <th style='width:14%'>V. BRAND</th> <th style='width:15%'>V. MODEL</th> <th style='width:15%'>JOB. TYPE</th> <th style='width:10%'>APPT. DATE</th> <th style='width:20%'>STATUS</th> <th style='width:5%'></th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='".$row['brand_id']."'"),0); $modelName = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='".$row['model_id']."'"),0); ?><tr onclick="javascript:showApptInfo(this);"><?php echo "<td>".$row['s_ro_no']."</td>"; echo "<td>".$row['s_v_plate']."</td>"; echo "<td>".$brandName."</td>"; echo "<td>".$modelName."</td>"; echo "<td>".$row['s_appt_type']."</td>"; echo "<td>".$row['appt_date']."</td>"; echo "<td>"; if($row['service_status']=='0'){ echo "Open"; }else{ echo "Closed"; } echo "</td>"; echo "<td style='text-align:center'><a href='mainindex.php?id=9&view=".$row['s_v_plate']."'><button> » </button></a></td>"; echo "</tr>"; } echo "</table>"; ?> </div> </div> </div> </body> </html> <script language="javascript" type="text/javascript"> function showApptInfo(row) { var x=row.cells; document.getElementById("searchV").value = x[0].innerHTML; } </script> <!-- JQUERY FROM src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"> GOOGLE API --> <script type="text/javascript" src="js/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('trans_load_checedin_vehicle.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