File manager

File manager - Edit - /home/autoph/public_html/voc/home/search_load_found_ro.php

Back
<?php include 'core/init.php'; $userID=$user_data['u_id']; $dealID= $user_data['dealer']; $compID= $user_data['company']; $toDate = date_create() ->format("Y/m/d"); $toTime =Explode(":", date('H:i:s')); $currentTime = date("H:i:s"); $query = mysql_query("SELECT * FROM vts_service_status_logs WHERE ro_number='".$_POST['value']."'"); $viewRODetails=$_POST['value']; $vPlate = mysql_result(mysql_query("SELECT `s_v_plate` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); ?> <?php if(mysql_num_rows($query) > 0){ echo '<div style="width:100%;border:0px solid red;text-align:left;float:left:font-family:Verdana;font-size:14px;font-weight:normal;padding:1px;color:blue;min-width:250px;height:100%">'; //========================================================= echo '<div style="margin:1px; width:34%;float:left;position:relative;border:0px solid gray;border-right:1px dashed gray;height:100%;min-height:200px">'; 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'> R.O 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=1' class='hideClick hidden' style='font-weight:bold'> ✕ </a> </div> </div>"; ?> <?php //VEHICLE INFORMATION DATA GOES HERE... echo '<div style="padding:5px;margin:1px; width:100%;float:left;position:relative;border:0px solid red;height:93%;min-height:200px">'; $getData = mysql_query("SELECT * FROM `vts_vehicle_lists` WHERE `v_plate`='$vPlate'"); echo "<table style='width:100%'>"; while($row=mysql_fetch_array($getData)){ //$openAppt $sellerDealer = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['sold_by_dealer']."'"),0); $vLocation = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['v_location_id']."'"),0); $ROPlate = mysql_result(mysql_query("SELECT `s_v_plate` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $JobType = mysql_result(mysql_query("SELECT `s_appt_type` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $ROMake = mysql_result(mysql_query("SELECT `v_make` FROM `vts_vehicle_lists` WHERE `v_plate`='$ROPlate'"),0); $ROColor = mysql_result(mysql_query("SELECT `v_color` FROM `vts_vehicle_lists` WHERE `v_plate`='$ROPlate'"),0); $vAction = mysql_result(mysql_query("SELECT `out_description` FROM `vts_check_out_reasons` WHERE `out_id`='".$row['action_id']."'"),0); //$serviceUpdate = mysql_result(mysql_query("SELECT `status` FROM `vts_service_logs` WHERE `v_plate`='".$row['v_plate']."' AND `date` "),0); $QSssp = mysql_result(mysql_query("SELECT `s_qs_ssp` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $QScust = mysql_result(mysql_query("SELECT `s_qs_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $QSComp = mysql_result(mysql_query("SELECT `s_qs_comp_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $GJcust = mysql_result(mysql_query("SELECT `s_gj_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $GJcomp = mysql_result(mysql_query("SELECT `s_gj_comp_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $GJwar = mysql_result(mysql_query("SELECT `s_gj_warranty` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $GJwarSub = mysql_result(mysql_query("SELECT `s_gj_warranty_sub` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $BPcust = mysql_result(mysql_query("SELECT `s_bp_cust_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $BPcopm = mysql_result(mysql_query("SELECT `s_bp_warranty_type` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $BPins = mysql_result(mysql_query("SELECT `s_bp_insurance_paid` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $transID = mysql_result(mysql_query("SELECT `transferred_to` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $dateTransTo = mysql_result(mysql_query("SELECT `transfer_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $dateReturned = mysql_result(mysql_query("SELECT `transfer_return_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $apptDate = mysql_result(mysql_query("SELECT `appt_date` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $closedDate = mysql_result(mysql_query("SELECT `date_closed` FROM `vts_service_transaction` WHERE `s_ro_no`='$viewRODetails'"),0); $isOutSourced = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$transID."'"),0); $isOutSourcedCode = mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='".$transID."'"),0); echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Data Owned By:</td>"; echo "<td style='width:50%;border:0px solid white'>".$sellerDealer."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Vehicle Brand:</td>"; echo "<td style='width:50%;border:0px solid white'>".$row['v_brand']."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Vehicle Plate:</td>"; echo "<td style='width:50%;border:0px solid white'>".$ROPlate."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'> Varriant:</td>"; echo "<td style='width:50%;border:0px solid white'>".$row['v_model']."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'> Make:</td>"; echo "<td style='width:50%;border:0px solid white'>".$ROMake."</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Color:</td>"; echo "<td style='width:50%;border:0px solid white'>".$ROColor."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' style=' border:0px solid white;border-bottom:0px solid gray'>- - - - - - - - - - - - - - - - - - - - - - - -</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Job Type:</td>"; echo "<td style='width:50%;border:0px solid white'>$JobType</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Appointment Date:</td>"; echo "<td style='width:50%;border:0px solid white'>".$apptDate."</td>"; echo "</tr>"; switch($JobType){ case 'QS': echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Paid By Customer:</td>"; echo "<td style='width:50%;border:0px solid white'>$QScust</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Company P.O:</td>"; echo "<td style='width:50%;border:0px solid white'>$QScust</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>S.S.P:</td>"; echo "<td style='width:50%;border:0px solid white'>$QSssp</td>"; echo "</tr>"; break; case 'GJ': echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Paid By Customer:</td>"; echo "<td style='width:50%;border:0px solid white'>$GJcust</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Company P.O:</td>"; echo "<td style='width:50%;border:0px solid white'>$GJcomp</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Warranty</td>"; echo "<td style='width:50%;border:0px solid white'>$GJwar</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Warranty Claim Type</td>"; echo "<td style='width:50%;border:0px solid white'>$GJwarSub</td>"; echo "</tr>"; break; case 'BP': echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Paid By Customer:</td>"; echo "<td style='width:50%;border:0px solid white'>$BPcust</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Company P.O:</td>"; echo "<td style='width:50%;border:0px solid white'>$BPcomp</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Warranty</td>"; echo "<td style='width:50%;border:0px solid white'>$BPins</td>"; echo "</tr>"; break; } echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Job Out-Sourced To:</td>"; echo "<td style='width:50%;border:0px solid white'>$isOutSourced</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Date Transferred To $isOutSourcedCode:</td>"; echo "<td style='width:50%;border:0px solid white'>$dateTransTo</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>$isOutSourcedCode Competion Date:</td>"; echo "<td style='width:50%;border:0px solid white'>$dateReturned</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:40%;border:0px solid white'>Closed Date:</td>"; echo "<td style='width:50%;border:0px solid white'>".$closedDate."</td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; echo "</div>"; //========================================================= echo '<div style="margin:1px; width:65%;float:right;position:relative;border:0px solid gray;border-right:1px dashed gray;height:100%;min-height:200px">'; 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'> Time & Motion Analysis: <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>"; //VEHICLE SERVICE INFORMATION DATA GOES HERE... $getINOUT = mysql_query("SELECT * FROM `vts_service_status_logs` WHERE `ro_number`='$viewRODetails' ORDER BY `log_id` ASC"); echo "<table style='width:100%'>"; echo "<tr>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Datex</td>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Time</td>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Interval</td>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Update</td>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Remarks</td>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Update SMS</td>"; echo "<td style='border:0px solid white;border-bottom:1px solid gray;font-size:10px'>Update Email</td>"; echo "</tr>"; $dateOne=''; while($sRow=mysql_fetch_array($getINOUT)){ if($dateOne == ''){ $dateOne = $sRow['date']." ". $sRow['time']; $mvInterval=0; }else{ $dateTwo = $sRow['date']." ". $sRow['time']; $date_a = new DateTime($dateOne ); $date_b = new DateTime($dateTwo); $interval = date_diff($date_a, $date_b); $mvInterval = $interval->format('%m:%d:%h:%i:%s'); } $status = mysql_result(mysql_query("SELECT `service_desc` FROM `vts_service_status` WHERE `serv_id`='".$sRow['status']."'"),0); $tSlot = mysql_result(mysql_query("SELECT `time_slot` FROM `vts_service_slots` WHERE `slot_id`='".$sRow['time_slot_code']."'"),0); echo "<tr>"; echo "<td style='border:0px solid white;font-size:10px'>".$sRow['date']."</a></td>"; echo "<td style='border:0px solid white;font-size:10px'>".$sRow['time']."</a></td>"; echo "<td style='border:0px solid white;font-size:10px'>".$mvInterval."</a></td>"; echo "<td style='border:0px solid white;font-size:10px'>".$dateOne."</a></td>"; echo "<td style='border:0px solid white;font-size:10px'>".$sRow['notes']."</a></td>"; echo "<td style='border:0px solid white;font-size:10px'>".$sRow['update_sms']."</a></td>"; echo "<td style='border:0px solid white;font-size:10px'>".$sRow['update_email']."</a></td>"; echo "</tr>"; $dateOne = $sRow['date']." ". $sRow['time']; $dateTwo=''; } echo "</table>"; echo "</div>"; ?> <?php }else{ echo "No Record Fountd."; } ?>

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