File manager

File manager - Edit - /home/autoph/public_html/api/aha/SA_updateURs.php

Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; //UPDATE Alert Status to 1 if($mykey =="TOKEN6e59e008b5348b452b615a3033729daae383CheckIn"){ $userID = $_GET['userID']; $employeeID = $_GET['employeeID']; $serviceID = $_GET['serviceID']; $NewStatusCode = $_GET['statusCode']; $oldStatusCode = $_GET['oldStatusID']; $carPlate = $_GET['carPlate']; switch($NewStatusCode){ case 1: $statusName ="For Confirmation of Booking"; $cstatusName ="Your Booking has been confirmed and SA has been assigned"; break; case 2: $statusName ="Waiting for Arrival"; $cstatusName ="Waiting for unit to arrive at site"; break; case 3: $statusName ="Unit Arrived"; $cstatusName ="Your unit has arrived"; break; case 4: $statusName ="Vehicle Checklist"; $cstatusName ="Our Service Advisor is now doing the vehicle checklist prior to start of service"; break; case 5: $statusName ="Job Started"; $cstatusName ="Our technicians is now servicing your car."; break; case 6: $statusName ="For Test Drive"; $ctatusName ="We are conducting test drive after completing the service"; break; case 7: $statusName ="For Carwash"; $cstatusName ="Your unit is now being cleansed and sanitized"; break; case 8: $statusName ="For Quality Check"; $cstatusName ="Your unit is now subject for quality checked after completing the required service"; break; case 9: $statusName ="Billing Preparation"; $cstatusName ="We are now finalizing all documents for billing."; break; case 10: $statusName ="Waiting Parts"; $cstatusName ="We are still waiting for parts to arrived. We'll inform you once parts becomes available."; case '10.1': $statusName ="Parts For Client Approval"; $cstatusName ="Waiting for clients approval for requested parts."; break; case 11: $statusName ="Parts Arrived"; $cstatusName ="We are happy to inform you that the ordered parts has arrived"; break; case 12: $statusName ="Installing Parts"; $cstatusName ="We are installing parts to your vehicle"; break; case 13: $statusName ="For Payment"; $cstatusName ="You can now proceed to cashier for payment"; break; case 14: $statusName ="Ready to Release"; $cstatusName ="Your unit is now ready for release"; break; case 15: $statusName ="Completed"; $cstatusName ="Your vehicle service has been completed."; break; } $gStatDes = "SELECT * FROM service_status WHERE id='$NewStatusCode'"; $qStat = $conn->query($gStatDes); while($row = $qStat->fetch_assoc()) { $statDes = $row['description']; } $insertD = "INSERT INTO service_booking_logs( service_booking_id, aha_user_id, car_plate, update_description, update_by, status_id, time_started, created_at) VALUES( '$serviceID', '$userID', '$carPlate', '$statusName', '$employeeID', '$NewStatusCode', '$myTimeStamp', '$myTimeStamp')"; // SQL query $sql = "UPDATE `service_bookings` SET `service_status_id`=$NewStatusCode, `updated_at`='$myTimeStamp' WHERE `id`='$serviceID'"; if ($conn->query($sql) === TRUE) { } if ($conn->query($insertD) === TRUE) { $stat="Update complete Code: A"; } //Update service booking record to close and put time stamp $uUR = "UPDATE `service_booking_logs` SET `time_ended`='$myTimeStamp', `updated_at`='$myTimeStamp' WHERE `service_booking_id`='$serviceID' AND `status_id`='$oldStatusCode'"; if ($conn->query($uUR) === TRUE) { $stat="Update complete Code: B"; } //insert general notification $notify ="INSERT INTO `aha_general_notifications` (`aha_user_id`,`date_time_created`,`alert_title`,`alert_message`,`notification_type`) VALUES('$userID','$myTimeStamp','$statusName','$statDes','Service')"; if ($conn->query($notify) === TRUE) { $stat="Update complete Code: C"; } echo json_encode(["status" => "$stat", "URStatus"=>"$statusName", "cstatusName"=>"$cstatusName"]); } $conn->close(); ?>

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