<?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();

?>