public function indexAction() { $urls = $this->em->createQuery('SELECT su, s FROM Entity\\ShortUrl su LEFT JOIN su.station s ORDER BY su.station_id, su.short_url ASC')->getArrayResult(); $global_custom_urls = array(); $station_custom_urls = array(); foreach ($urls as $url) { if ($url['station']) { $station_custom_urls[] = $url; } else { $global_custom_urls[] = $url; } } $this->view->station_custom_urls = $station_custom_urls; $this->view->global_custom_urls = $global_custom_urls; // Auto-Generated Station URLs. $station_details = Station::getShortNameLookup(); $station_categories = Station::getCategories(); $station_urls = array(); foreach ($station_details as $short_name => $station) { $station['url'] = ShortUrl::getFullUrl($short_name); $station['icon'] = $station_categories[$station['category']]['icon']; $station_urls[$short_name] = $station; } $this->view->station_urls = $station_urls; // Auto-Generated Convention Archive URLs $convention_details = Convention::getShortNameLookup(); $convention_urls = array(); foreach ($convention_details as $short_name => $convention) { $convention['url'] = ShortUrl::getFullUrl($short_name); $convention_urls[$short_name] = $convention; } $this->view->convention_urls = $convention_urls; }
public function indexAction() { $urls = $this->em->createQuery('SELECT su FROM Entity\\ShortUrl su WHERE su.station_id = :station_id ORDER BY su.timestamp ASC')->setParameter('station_id', $this->station->id)->execute(); $this->view->urls = $urls; // Auto-Generated Station URLs. $station_details = Station::getShortNameLookup(); $station_categories = Station::getCategories(); $station_urls = array(); foreach ($station_details as $short_name => $station) { $station['url'] = ShortUrl::getFullUrl($short_name); $station['icon'] = $station_categories[$station['category']]['icon']; $station_urls[$short_name] = $station; } $this->view->station_urls = $station_urls; // Auto-Generated Convention Archive URLs $convention_details = Convention::getShortNameLookup(); $convention_urls = array(); foreach ($convention_details as $short_name => $convention) { $convention['url'] = ShortUrl::getFullUrl($short_name); $convention_urls[$short_name] = $convention; } $this->view->convention_urls = $convention_urls; }