File manager

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

Back
<?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); //echo "Connected"; $userID=$user_data['u_id']; $myCurTime=$currentTime; $dealID= $user_data['dealer']; $compID= $user_data['company']; $toDate = date_create() ->format("Y/m/d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $myPlate = mysql_escape_string($_POST['updateApptPlate']); $vPlateA = str_replace(' ', '', $myPlate); $plate = str_replace('-', '', $vPlateA); $kmReading = mysql_escape_string($_POST['Mileage']); $location = mysql_escape_string($_POST['para']); $addBy = mysql_escape_string($_POST['addBy']); $addDate = mysql_escape_string($_POST['addDate']); $dealerID = mysql_escape_string($_POST['MydealID']); $companyCode = mysql_escape_string($_POST['MycompID']); $addTime = mysql_escape_string($_POST['addTime']); $checkInOutSelect = mysql_escape_string($_POST['checkInOutSelect']); $chkIfPlateExist = mysql_result(mysql_query("SELECT COUNT('v_id') FROM `vts_vehicle_lists` WHERE `v_plate`='$plate' \|\| `v_conduction`='$plate'"),0); if($chkIfPlateExist == 0){ //PLATE NOT FOUND mysql_query("INSERT INTO vts_in_out_history (chk_plate, chk_km, chk_transaction, comp_code,dealer_code,location_code, time, date, user_id) VALUES('{$plate}','{$kmReading}','{$checkInOutSelect}','{$companyCode}','{$dealerID}','{$location}','{$addTime}','{$addDate}','{$addBy}')"); if($checkInOutSelect==='IN'){ //CHECKIN BUT NO RECORDS FOUND //============================================================ if($location== 3 \|\| $location == 6){ // CHECK IF APPT OR WALKIN mysql_query("INSERT INTO vts_service_transaction (s_arrived_date, s_arrived_time, s_v_plate, s_comp_code, s_deal_code, s_appt_type,s_date,s_time,appt_date,time_slot_code) VALUES('{$addDate}','{$addTime}','{$plate}','{$companyCode}','{$dealerID}','XX','{$addDate}','{$addTime}','{$addDate}','1')"); //ADD RECCORDS TO VEHICLE LIST WITH LIMITED INFORMATION ONLY }else{ //INSERT VEHICLE RECORD FOR MONITORING ONLY` mysql_query("INSERT INTO vts_vehicle_lists (v_plate, v_conduction, v_in_out, v_location_id, action_id) VALUES('{$plate}','{$plate}','1','{$dealerID}','{$location}')"); } //============================================================ } }else{ mysql_query("INSERT INTO vts_in_out_history (chk_plate, chk_km, chk_transaction, comp_code,dealer_code,location_code, time, date, user_id) VALUES('{$plate}','{$kmReading}','{$checkInOutSelect}','{$companyCode}','{$dealerID}','{$location}','{$addTime}','{$addDate}','{$addBy}')"); $chkIfPlateExist = mysql_result(mysql_query("SELECT COUNT('S_id') FROM `vts_service_transaction` WHERE `s_v_plate`='$plate' \|\| `s_conduction`='$plate'"),0); if($chkIfPlateExist == 0){ //PLATE NOT FOUND IN SERVICE APPOINTMENT RECORDS BUT IN THE VEHICLE LIST DATABASE mysql_query("INSERT INTO vts_service_transaction (s_arrived_date, s_arrived_time, s_v_plate, s_comp_code, s_deal_code, s_appt_type,s_date,s_time,appt_date,time_slot_code) VALUES('{$addDate}','{$addTime}','{$plate}','{$companyCode}','{$dealerID}','XX','{$addDate}','{$addTime}','{$addDate}','1')"); }else{ mysql_query("UPDATE `vts_service_transaction` SET `s_arrived_date`='$addDate',`s_arrived_time`='$addTime' WHERE `s_arrived_time`='' AND `s_v_plate`='$plate' AND `s_comp_code`='$companyCode' AND `s_deal_code`='$dealerID' AND `service_status`='0' \|\| `s_arrived_time`='' AND `s_v_plate`='$plate' AND `transferred_to`='$dealerID' AND `service_status`='0'"); } if($checkInOutSelect==='IN'){ mysql_query("UPDATE `vts_vehicle_lists` SET `v_in_out`='1',`v_location_id`='$dealerID',`action_id`='$location' WHERE `v_plate`='$plate'"); }else{ mysql_query("UPDATE `vts_vehicle_lists` SET `v_in_out`='0',`v_location_id`='0',`action_id`='$location' WHERE `v_plate`='$plate'"); mysql_query("UPDATE `vts_in_out_history` SET `tag_as_out`='OUT' WHERE `chk_plate`='$plate' AND `tag_as_out`=''"); } } exit(); } if(isset($_POST['display'])){ $addDate = mysql_escape_string($_POST['addDate']); $getApptSum = mysql_query("SELECT * FROM `vts_service_transaction` WHERE `appt_date` = '$toDate' ORDER BY `time_slot_code` ASC"); echo "<table id='apptSummary' style='width:100%'>"; echo "<thead>"; echo "<tr class='tablehead'> <th class='bgBlue;font-color:black;width:15%'>REC.NO</th> <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%'>Appt. Date </th> <th class='bgBlue;font-color:black;width:10%'>Arrived Time </th> <th class='bgBlue;font-color:black;width:10%'>Current Status </th> </tr> </thead>"; while($row=mysql_fetch_array($getApptSum)){ if($row['s_ro_no']===''){ $tColor="red"; }else{ $tColor="black"; } if($row['s_arrived_time']==''){ $status="Waiting"; }else{ $status="Arrived"; } $brandName=mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0); $modelName=mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0); echo "<tr>"; echo "<td style='font-size:12px;color:$tColor'>".$row['s_id']."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$row['s_v_plate']."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$row['s_ro_no']."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$brandName."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$modelName."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$row['s_appt_type']."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$row['appt_date']."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$row['s_arrived_time']."</td>"; echo "<td style='font-size:12px;color:$tColor'>".$status."</td>"; echo "</tr>"; } echo "</table>"; } ?>

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