File manager - Edit - /home/autoph/public_html/api/aha/SA_updateURPayment.php
Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; //UPDATE Alert Status to 1 if($mykey =="TOKEN6e59e008b5348b452b615a3033729daae383Payment"){ $userID = $_GET['userID']; $employeeID = $_GET['employeeID']; $serviceID = $_GET['serviceID']; $NewStatusCode = $_GET['statusCode']; $OldStatusCode = $_GET['OldStatusCode']; $amount = $_GET['amount']; $carPlate = $_GET['carPlate']; $mileage = $_GET['mileage']; $nextPMSDate = $_GET['nextPMSDate']; $statusName ="For Payment"; $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',amount = '$amount', mileage='$mileage' WHERE `id`='$serviceID'"; $sqlV = "UPDATE `vehicles` SET `mileage`='$mileage', `updated_at`='$myTimeStamp',last_date_service = '$myTimeStamp', next_pms_date='$nextPMSDate' WHERE `plate_no`='$carPlate'"; if ($conn->query($sqlV) === TRUE) { } 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", "URStatus"=>"$statusName"]); } $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings