<?php
include '../../../cfg/ahaconn.php';
$mykey = $_GET['keyID'];
//echo "Arnel " . $mykey;
if($mykey =="6e59e008b5348b452b615a3033729daae383"){
   $userID = $_GET['userID'];
 
   // SQL query
   // $sql = "SELECT t1.*,t1.id AS serviceID,t2.*, t3.firstname,t3.lastname,t3.email,t3.mobile FROM autoph_ahg_crm.service_bookings t1 LEFT JOIN autoph_ahg_crm.service_status t2 ON t1.service_status_id =  t2.id LEFT JOIN autoph_ahg_hr_staging.users t3 WHERE aha_user_id='$userID' AND service_status_id < 10 ";
   $sql = "SELECT t1.*,t1.id AS serviceID,t2.*, t3.firstname,t3.lastname,t3.email,t3.mobile,t3.asa_user_id,t4.employee_id,t4.deviceID,t4.deviceToken
    FROM autoph_ahg_crm.service_bookings t1
    LEFT JOIN autoph_ahg_crm.service_status t2
    ON t1.service_status_id =  t2.id
    LEFT JOIN autoph_ahg_hr_staging.employees t3
    ON t1.assigned_service_advisor = t3.employee_id
    LEFT JOIN autoph_ahg_hr_staging.users t4
    ON t1.assigned_service_advisor = t4.employee_id
    WHERE t1.aha_user_id='$userID' AND service_status_id < 15 GROUP BY car_plate";
   
    $result = $conn->query($sql);
    $count=0;
    if ($result->num_rows > 0) {
        // Array to hold the results
        $rows = array();
    $cancelBooking = '';
       while($row = $result->fetch_assoc()) {
           $servID = $row['service_status_id'];
           if($servID > 2){
               $cancelBooking = '';
           }else{
               $cancelBooking = 'visible';
           }
            $serviceMsgCount="";
            $bookingID = $row['serviceID'];
            
            $countMsg = "SELECT * FROM aha_sa_client_messages WHERE service_booking_id='$bookingID' AND `asa_aha_sender_id`!='$userID' AND `read_by_user`=0";
            
            $msgCount = $conn->query($countMsg);
             while($cnt = $msgCount->fetch_assoc()){
                $serviceMsgCount=  $serviceMsgCount + 1;
             }
             
           $saID = $row['service_advisor_id'];
           $saName = $row['firstname'] . " ". $row['lastname'];
           $saEmail = $row['email'];
           $saMobile = $row['mobile'];
           $deviceID = $row['deviceID'];
           $deviceToken = $row['deviceToken'];
           switch ($servID){
            case 0:
                $step1 ="";
                $step2 ="";
                $step3 ="";
                $step4 ="";
                $step5 ="";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 1:
                $step1 ="Visible";
                $step2 ="";
                $step3 ="";
                $step4 ="";
                $step5 ="";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 2:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="";
                $step4 ="";
                $step5 ="";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 3:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="";
                $step5 ="";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 4:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 5:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 6:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="Visible";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 7:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="Visible";
                $step7 ="Visible";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 8:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="Visible";
                $step7 ="Visible";
                $step8 ="Visible";
                $step9 ="";
                $step10 ="";
                break;
            case 9:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="Visible";
                $step7 ="Visible";
                $step8 ="Visible";
                $step9 ="Visible";
                $step10 ="";
                break;
            case 10:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 11:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 12:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="";
                $step7 ="";
                $step8 ="";
                $step9 ="";
                $step10 ="";
                break;
            case 13:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="Visible";
                $step7 ="Visible";
                $step8 ="Visible";
                $step9 ="";
                $step10 ="";
                break;
            case 14:
                $step1 ="Visible";
                $step2 ="Visible";
                $step3 ="Visible";
                $step4 ="Visible";
                $step5 ="Visible";
                $step6 ="Visible";
                $step7 ="Visible";
                $step8 ="Visible";
                $step9 ="Visible";
                $step10 ="";
                break;
        }
        $selectedFields = [
            'id' => $row['serviceID'],
             'serviceID' => $row['serviceID'],
            'userID' => $row['aha_user_id'],
            'asaUserID' => $row['asa_user_id'],
            'carPlate' => $row['car_plate'],
            'statName' => $row['name'],
            'stepA' => $step1,
            'stepB' => $step2,
            'stepC' => $step3,
            'stepD' => $step4,
            'stepE' => $step5,
            'stepF' => $step6,
            'stepG' => $step7,
            'stepH' => $step8,
            'stepI' => $step9,
            'stepJ' => $step10,
            'saName'=> $saName,
            'saNumber'=> $saMobile,
            'saEmail'=> $saEmail,
            'deviceID'=>"$deviceID",
            'deviceToken'=>"$deviceToken",
            'bgColor' => $row['bgcolor'],
            'CancelOption' =>$cancelBooking,
            "serviceMsgCount"=>$serviceMsgCount,
            'amountToPay' =>$row['amount']
            // Add more fields as needed
        ];
        $rows[] = $selectedFields;
        $count = $count + 1;
    }
    if($count > 0){
        $cardNotes = "";
    }else{
        $cardNotes = "No Active Bookings.";
    }
      
        
        // Output the result in JSON format
        header('Content-Type: application/json');
       echo json_encode([$rows,"Count" => "$count"]);
    } else {
        $viewCard = "";
        $cardNotes = "No Active Bookings.";
        echo json_encode([$rows,"Count" => "$count"]);
    }
}
// Close connection
$conn->close();

?>