| Server IP : 104.21.21.239 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/hotel-dev/public_html/mod/ |
Upload File : |
<?php include('_mod_security.php'); ?>
<?php
$venue = db_quote($_GET['venue']);
$event_id = nz(db_quote($_GET['event_id']), '0');
$sql = "SELECT SUM(IF(rsvp_".$venue." = 1,nbr_of_guests,0)) AS rsvp_count ".
", SUM(IF(cancel_".$venue." = 1,nbr_of_guests,0)) AS cancel_count ".
", SUM(IF(attended_".$venue." = 1,nbr_of_guests,0)) AS attended_count ".
", SUM(IF(wait_".$venue." = 1,nbr_of_guests,0)) AS wait_count ".
"FROM events_concierges WHERE event_id = ".$event_id;
$result_concierges = $db->query($sql);
$row_concierges = $result_concierges->fetch(PDO::FETCH_OBJ);
$sql = "SELECT SUM(IF(rsvp_".$venue." = 1,nbr_of_guests,0)) AS rsvp_count ".
", SUM(IF(cancel_".$venue." = 1,nbr_of_guests,0)) AS cancel_count ".
", SUM(IF(attended_".$venue." = 1,nbr_of_guests,0)) AS attended_count ".
", SUM(IF(wait_".$venue." = 1,nbr_of_guests,0)) AS wait_count ".
"FROM events_guests WHERE event_id = ".$event_id;
$result_guests = $db->query($sql);
$row_guests = $result_guests->fetch(PDO::FETCH_OBJ);
echo json_encode(array(
'nbr_rsvp' => $row_concierges->rsvp_count + $row_guests->rsvp_count,
'nbr_cancelirmed' => $row_concierges->cancel_count + $row_guests->cancel_count,
'nbr_attended' => $row_concierges->attended_count + $row_guests->attended_count,
'nbr_waitlisted' => $row_concierges->wait_count + $row_guests->wait_count,
));
?>