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

?>