File manager - Edit - /home/autoph/public_html/api/aha/load_service_questionairs.php
Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; //echo "Arnel " . $mykey; if($mykey =="6e59e008b5348b452b615a3033729daae383"){ $serviceID = $_GET['serviceID']; $sql = "SELECT * FROM `aha_service_ratings_questions` WHERE `enabled` = 1 AND `type`='service' ORDER BY `id` ASC"; $result = $conn->query($sql); if ($result->num_rows > 0) { $rows = array(); while($row = $result->fetch_assoc()) { $seq = $row['sequence']; switch ($seq) { case 1: $qa =$row['question']; break; case 2: $qb =$row['question']; break; case 3: $qc =$row['question']; break; } } } $srv="SELECT t1.id AS serviceID,t1.car_plate,t1.dealer_id,t1.date,t1.assigned_service_advisor,t2.name AS DealName, t2.id AS dealID,t3.id AS hrUserID,t3.first_name,t3.last_name FROM autoph_ahg_crm.service_bookings t1 LEFT JOIN autoph_ahg_crm.dealerships t2 ON t1.dealer_id = t2.id LEFT JOIN autoph_ahg_hr.users t3 ON t1.assigned_service_advisor = t3.employee_id WHERE t1.id = $serviceID LIMIT 1"; $resultS = $conn->query($srv); if ($resultS->num_rows > 0) { while($rowV = $resultS->fetch_assoc()) { $carPlate =$rowV['car_plate']; $dealName =$rowV['DealName']; $saName =$rowV['last_name'].", ". $rowV['first_name']; $date =$rowV['date']; } } // Output the result in JSON format header('Content-Type: application/json'); $openText = "Users comment in open text format"; echo json_encode([ "QuestionA" => "$qa", "QuestionB" => "$qb", "QuestionC" => "$qc", "openText" => "$openText", "carPlate" => "$carPlate", "dealName" => "$dealName", "saName" => "$saName", "date" => "$date", ]); } // Close connection $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings