<?php
include '../../../cfg/ahaconn.php';
$mykey = $_GET['keyID'];
if($mykey =="6e59e008b5348b452b615a3033729daae383rateus"){
$userID = $_GET['userID'];
 
    $sql = "SELECT * FROM `service_bookings` WHERE `aha_user_id`='$userID' AND `score`=0 AND `cancelled_by` is NULL AND `survey_completed`='No'";
     
    $result = $connhr->query($sql);
    if ($result->num_rows > 0) {
        
        $rows = array();
        $count=0;
 
        while($row = $result->fetch_assoc ()){
            $count = $count + 1;
            $selectedFields = [
                'id' => $row['id'],
                'car_plate' => $row['car_plate'],
                'serviceDate' => $row['date']
        ];
        $rows[] = $selectedFields;
  
        }
    
    } 
    header('Content-Type: application/json');
    echo json_encode([$rows,"count"=>"$count"]);
}
$connhr->close();

?>