Twig foreach group by date

Question

I have a table with football matches called 'matches'. In that table there is a field 'kickoff', which is a datetime-column of the time when the match starts. With the following code I get all the matches out of the table.

$matches = $em->createQueryBuilder()

        ->select('m')

        ->from('FootballWcBundle:Matches', 'm')

        ->addOrderBy('m.kickoff', 'ASC')

        ->getQuery()

        ->getResult();



return $this->render('FootballWcBundle:Page:matches.html.twig', array(

        'matches' => $matches

));

Now I want to show the matches on the screen grouped by the date.
Like this:

12-12-2014

match1

match2

14-12-2014

match3

match4

match5

Is there a way to let Twig know to group by the kickoff column or is there another way to do this?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

You could do that as below:

    {% set date = null %}
    {% for match in matches %}
        {% if date != match.kickoff %}
            {% set date = match.kickoff %}
            <h3>{{ date }}</h3>
        {% endif %}

        <p>{{ match.name }}</p>
    {% endfor %}

In this way, you set the first date as null, and you iterate all matches and write a 'p' tag with the name (I supposed the match had a name to do the example), and when the date of the matches changes, you write a 'h3' tag with the date of the match. As date is set to null in the first iteration, the first date will be write.

Twig foreach group by date

Sign up