File manager

File manager - Edit - /home/autoph/public_html/api/aha/load_service_status.php

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

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings