File manager - Edit - /home/autoph/public_html/api/aha/SA_updateURs.bak
Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; //UPDATE Alert Status to 1 if($mykey =="TOKEN6e59e008b5348b452b615a3033729daae383CheckIn"){ $userID = $_GET['userID']; $serviceID = $_GET['serviceID']; $NewStatusCode = $_GET['statusCode']; $oldStatusCode = $_GET['oldStatusID']; $carPlate = $_GET['carPlate']; switch($NewStatusCode){ case 1: $statusName ="For Confirmation of Booking"; break; case 2: $statusName ="Waiting for Arrival"; break; case 3: $statusName ="Unit Arrived"; break; case 4: $statusName ="Vehicle Checklist"; break; case 5: $statusName ="Job Started"; break; case 6: $statusName ="For Test Drive"; break; case 7: $statusName ="For Carwash"; break; case 8: $statusName ="For Quality Check"; break; case 9: $statusName ="Billing Preparation"; break; case 10: $statusName ="Waiting Parts"; break; case 11: $statusName ="Parts Arrived"; break; case 12: $statusName ="Installing Parts"; break; case 13: $statusName ="For Payment"; break; case 14: $statusName ="Ready to Release"; break; case 15: $statusName ="Completed"; break; } $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', '$userID', '$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"; $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) { } } }else{ $stat="Update failed"; } echo json_encode(["status" => "$stat"]); } $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings