public static function getSignupsForEvent($id, $currentUserSignupStatus = null)
{
global $db;
// Get the signup info.
$sql = sprintf('SELECT s.id, sum(s2.status = "CANCELLED") as countCancelled, sum(s2.status = "STAFF" OR s2.status = "ATTENDED") as countAttended, sp.seat AS selectedSeat, s.comments, s.status, s.user, u.username, u.real_name AS userRealName, s.event, s.ticketCost, g.css AS userGroupCss FROM signups s LEFT JOIN signups s2 ON s.user = s2.user LEFT JOIN users u ON s.user = u.id LEFT JOIN `groups` g ON u.group = g.id LEFT JOIN seatingplan_seat_selections sp ON s.event = sp.event AND sp.user = u.id WHERE s.event = :eventId GROUP BY u.id ORDER BY status ASC, u.username ASC');
$stmt = $db->prepare($sql);
$stmt->bindValue(':eventId', $id, Database::PARAM_INT);
$stmt->execute();
$signups = $stmt->fetchAll();
foreach ($signups as $index => $signup) {
if (!empty($currentUserSignupStatus)) {
$signups[$index]['actions'] = signupLinks($id, $currentUserSignupStatus, $signup['id'], $signup['status'], $signup['user']);
}
if (!Session::hasPriv('VIEW_SIGNUP_MONNIES')) {
unset($signups[$index]['ticketCost']);
}
}
return $signups;
}
$formForceSignup->process();
}
}
require_once 'includes/widgets/header.php';
if (!Session::hasPriv('VIEW_SIGNUP_COMMENTS')) {
require_once 'includes/widgets/sidebar.php';
}
if (Session::isLoggedIn()) {
$notifications = array();
checkNotificationNotGuarenteedSeats($notifications);
$tpl->assign('notifications', $notifications);
}
$signups = Events::getSignupsForEvent($id, $event['signups']);
$tpl->assign('event', $event);
$tpl->assign('signups', $signups);
$tpl->assign('signupLinks', signupLinks($event['id'], $event['signups'], null));
$tpl->assign('signupStatistics', getSignupStatistics($signups));
$tpl->display('eventOverview.tpl');
if (Session::hasPriv('FORCE_SIGNUP')) {
$tpl->assignForm($formForceSignup);
}
if (Session::hasPriv('EVENT_FINANCE_OVERVIEW')) {
$tpl->assign('eventFinanceOverview', Events::getSignupFinances($event['id']));
}
$tpl->assign('privViewAttendance', Session::hasPriv('VIEW_ATTENDANCE_COUNTS'));
$tpl->assign('privViewSignupComments', Session::hasPriv('VIEW_SIGNUP_COMMENTS'));
$tpl->display('signupsList.tpl');
if (Session::hasPriv('VIEW_SIGNUP_COMMENTS')) {
require_once 'includes/widgets/sidebar.php';
}
$tpl->assign('venue', array('id' => $event['venueId'], 'name' => $event['venueName']));
