<?php
include '../../../cfg/ahaconn.php';
$mykey =$_GET['keyID'];
 
if($mykey == "6e59e008b5348b452b615a3033729daae383Cancelled"){
    $userID = $_GET['userID'];
    $serviceID = $_GET['serviceID'];
    $reasonX = $_GET['reason'];
    
   // SQL query
    $sql = "UPDATE `service_bookings` SET `service_status_id`='99', `cancelled_at`='$myTimeStamp',`cancelled_by` = '$userID',`cancellation_initiated_by`='Customer',`cancel_reason`='$reasonX' WHERE `id`='$serviceID' AND `aha_user_id`='$userID'";
    
    if ($conn->query($sql) === TRUE) {
          	$stat="Your Service Booking has been cancelled.";
          	$title="Cancelled Appointment";
          	$msg ="Your service appointment has been cancelled.";
              	$sqlNot = "INSERT INTO aha_general_notifications (`aha_user_id`,`date_time_created`,`alert_title`,`alert_message`,`notification_type`,`read_by_user`)
                VALUES ('$userID','$myTimeStamp','$title','$msg','Service','0')";
         
                if ($conn->query($sqlNot) === TRUE) {
                   
                }
            
    	}else{
    	    $stat="Unable to cancel your service appointment.  Please call our hotline number for assistance.  Thank you!";
    	}
  
}
 echo json_encode(["status" => "$stat"]);
$conn->close();

?>