File manager

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

Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; //echo "Arnel " . $mykey; if($mykey =="6e59e008b5348b452b615a3033729daae383"){ $userID = $_GET['userID']; // SQL query $sql = "SELECT t1.id AS serviceID,t1.,t2. FROM service_bookings t1 LEFT JOIN service_status t2 ON t1.service_status_id = t2.progress_count WHERE aha_user_id='$userID' AND service_status_id < 10 AND `checked_out_at` IS NULL GROUP BY t2.progress_count"; $result = $conn->query($sql); $count=0; if ($result->num_rows > 0) { // Array to hold the results $rows = array(); while($row = $result->fetch_assoc()) { $servID = $row['service_status_id']; 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 ="Visuble"; $step4 =""; $step5 =""; $step6 =""; $step7 =""; $step8 =""; $step9 =""; $step10 =""; break; case 4: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 =""; $step6 =""; $step7 =""; $step8 =""; $step9 =""; $step10 =""; break; case 5: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 ="Visible"; $step6 =""; $step7 =""; $step8 =""; $step9 =""; $step10 =""; break; case 6: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 ="Visible"; $step6 ="Visible"; $step7 =""; $step8 =""; $step9 =""; $step10 =""; break; case 7: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 ="Visible"; $step6 ="Visible"; $step7 ="Visible"; $step8 =""; $step9 =""; $step10 =""; break; case 8: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 ="Visible"; $step6 ="Visible"; $step7 ="Visible"; $step8 ="Visible"; $step9 =""; $step10 =""; break; case 9: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 ="Visible"; $step6 ="Visible"; $step7 ="Visible"; $step8 ="Visible"; $step9 ="Visible"; $step10 =""; break; case 10: $step1 ="Visible"; $step2 ="Visible"; $step3 ="Visuble"; $step4 ="Visuble"; $step5 ="Visible"; $step6 ="Visible"; $step7 ="Visible"; $step8 ="Visible"; $step9 ="Visible"; $step10 ="Visible"; break; } $selectedFields = [ 'id' => $row['serviceID'], 'serviceID' => $row['serviceID'], 'userID' => $row['aha_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, // 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