function indexNoEventsSeat(Request $request, Application $app)
{
$arb = new \com\meetyournextmp\repositories\builders\AreaRepositoryBuilder();
$arb->setIsMapItAreaOnly(true);
$arb->setIncludeDeleted(false);
$arb->setIncludeAreasWithNoEventsOnly(true);
$arb->setLimit(800);
$this->parameters['areas'] = $arb->fetchAll();
return $app['twig']->render('site/help/noevents.seats.html.twig', $this->parameters);
}
protected function run()
{
$siteRepo = new \repositories\SiteRepository();
$site = $siteRepo->loadById($this->app['config']->singleSiteID);
// TODO assumes single site!
$out = array();
$erb = new EventRepositoryBuilder();
$erb->setIncludeDeleted(false);
$erb->setIncludeCancelled(false);
$erb->setSite($site);
$out['countEventsTotal'] = count($erb->fetchAll());
$erb = new EventRepositoryBuilder();
$erb->setIncludeDeleted(false);
$erb->setIncludeCancelled(false);
$erb->setSite($site);
$erb->setBefore($this->app['timesource']->getDateTime());
$out['countEventsBeforeNow'] = count($erb->fetchAll());
$erb = new EventRepositoryBuilder();
$erb->setIncludeDeleted(false);
$erb->setIncludeCancelled(false);
$erb->setSite($site);
$erb->setAfterNow();
$out['countEventsAfterNow'] = count($erb->fetchAll());
$arb = new \com\meetyournextmp\repositories\builders\AreaRepositoryBuilder();
$arb->setIsMapItAreaOnly(true);
$arb->setIncludeDeleted(false);
$arb->setIncludeAreasWithNoEventsOnly(true);
$arb->setLimit(800);
$out['countSeatsWithNoEvents'] = count($arb->fetchAll());
$areaRepo = new AreaRepository();
foreach (array(3 => 'countEventsInScotland', 1 => 'countEventsInEngland', 2 => 'countEventsInWales', 4 => 'countEventsInNIreland', 712 => 'countEventsInGreaterLondon') as $areaSlug => $key) {
$erb = new EventRepositoryBuilder();
$erb->setIncludeDeleted(false);
$erb->setIncludeCancelled(false);
$erb->setSite($site);
$erb->setArea($areaRepo->loadBySlug($site, $areaSlug));
$out[$key] = count($erb->fetchAll());
}
// =================================== Events by day
$report = $this->getValueReport('com.meetyournextmp', 'NonDeletedNonCancelledEventsStartAtReport', $this->app);
$startAt = \TimeSource::getDateTime();
$startAt->setTime(0, 0, 0);
$endAt = new \DateTime('2015-05-07 10:00:00');
$period = "P1D";
$report->setFilterSiteId($this->app['config']->singleSiteID);
$reportByTime = new SeriesOfValueByTimeReport($report, $startAt, $endAt, $period);
$reportByTime->run();
$out['countEventsByDay'] = array();
foreach ($reportByTime->getData() as $data) {
$out['countEventsByDay'][] = array('count' => $data->getData(), 'date' => $data->getLabelStart()->format('D d F Y'));
}
// =================================== Users with edits
$report = $this->getSeriesReport("org.openacalendar", "UsersWithEventsEdited", $this->app);
$report->run();
$out['userEventsEdited'] = array();
foreach ($report->getData() as $data) {
$out['userEventsEdited'][] = array('count' => $data->getData(), 'userID' => $data->getLabelID(), 'userUserName' => $data->getLabelText());
}
//var_dump($out);
file_put_contents(APP_ROOT_DIR . DIRECTORY_SEPARATOR . 'cache' . DIRECTORY_SEPARATOR . 'numbers.json', json_encode($out));
return array('result' => 'ok');
}
$arb->setNoParentArea(true);
$arb->setIncludeDeleted(false);
$arb->fetchAll();
foreach ($arb->fetchAll() as $area) {
foreach ($parentAreas as $key => $value) {
if ($area->getTitle() == $key) {
$parentAreas[$key] = $area;
}
}
}
$workToDo = array('England' => null, 'Scotland' => null, 'Wales' => null, 'Northern Ireland' => null);
foreach ($parentAreas as $parentArea) {
print "Parent Area " . $parentArea->getTitle() . "\n";
$arb = new \com\meetyournextmp\repositories\builders\AreaRepositoryBuilder();
$arb->setParentArea($parentArea);
$arb->setLimit(10000);
foreach ($arb->fetchAll() as $area) {
if ($area->getParentAreaId() == $parentArea->getId()) {
print " - " . $area->getTitle() . "\n";
if (considerArea($area, $modeCurrent, $magicWords, $ignoreWords)) {
print " - - Consider\n";
$newParentTitle = stripCompassEndOfArea($area, $modeCurrent, $magicWords);
if (!isset($workToDo[$parentArea->getTitle()][$newParentTitle])) {
$workToDo[$parentArea->getTitle()][$newParentTitle] = array();
}
$workToDo[$parentArea->getTitle()][$newParentTitle][] = $area;
}
}
}
}
print "\n\n\n\n\n";