afup/sources/AppBundle/Controller/StaticController.php

<?php


namespace AppBundle\Controller;

use AppBundle\Offices\OfficesCollection;
use Symfony\Component\HttpFoundation\Request;

class StaticController extends SiteBaseController
{
    public function officesAction()
    {
        $officesCollection = new OfficesCollection();
        return $this->render(
        ':site:offices.html.twig',
            [
                'offices' => $officesCollection->getAllSortedByLabels()
            ]
        );
    }

    protected function getAperos($url)
    {
        $fp = fopen($url, 'rb');
        if (!$fp) {
            throw new \RuntimeException("Error opening spreadsheet");
        }

        $aperos = [];

        while (false !== ($row = fgetcsv($fp))) {
            if (0 === strlen(trim($row[0]))) {
                continue;
            }

            list($code, $meeetupId, $content) = $row;

            $apero = [
                'code' => $code,
                'content' => $content,
            ];

            if (strlen(trim($meeetupId))) {
                $apero['meetup_id'] = $meeetupId;
            }

            $aperos[] = $apero;
        }

        return $aperos;
    }

    public function superAperoAction()
    {
        $aperos = $this->getAperos($this->container->getParameter('super_apero_csv_url'));
        return $this->render(':site:superapero.html.twig', ['aperos' => $aperos]);
    }

    public function voidAction(Request $request)
    {
        $params = [];
        if ($request->attributes->has('legacyContent')) {
            $params = $request->attributes->get('legacyContent');
        }

        return $this->render('site/base.html.twig', $params);
    }
}