private function getIssuesList() { global $db; $sql = 'SELECT e.id, e.title, o.title AS organizerTitle, e.* FROM events e LEFT JOIN organizers o ON e.organizer = o.id WHERE e.dateFinish > now() '; $result = $db->query($sql); $events = $result->fetchAll(); $checker = new EventsChecker($events); $checker->checkAllEvents(); $events = $checker->getEventsList(); return $events; }
<?php require_once 'includes/common.php'; define('TITLE', 'Site Checks'); require_once 'includes/widgets/header.php'; require_once 'includes/classes/EventsChecker.php'; if (!Session::getUser()->hasPriv('SITE_CHECKS')) { throw new PermissionException(); } $checker = new EventsChecker(); $checker->checkAllEvents(); $events = $checker->getEventsList(); $tpl->assign('listEventsWithIssues', $events); $tpl->display('eventsWithIssues.tpl'); $sql = 'SELECT o.id, o.title, o.websiteUrl, o.lastChecked, count(u.id) assUserCount, o.assumedStale FROM organizers o LEFT JOIN users u ON u.organization = o.id AND u.email IS NOT NULL LEFT JOIN events e ON o.id = e.organizer AND e.dateFinish > now() WHERE e.id IS null GROUP BY o.id ORDER BY o.title'; $result = $db->query($sql); $orgies = $result->fetchAll(); $tpl->assign('listOrganizers', $orgies); $tpl->display('organizersWithNoEvents.tpl'); startSidebar(); require_once 'includes/widgets/adminBox.php'; require_once 'includes/widgets/footer.php';