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';
