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