CODEWITHSUNDEEP
symfonydoctrinetwig
Patrick Rey
Patrick Rey

Reputation: 129

Show multiple data from an Entity

I want to show the best 5 scores from each different Game I have. So I made this function :

public function records (){
    $em = $this->getDoctrine()->getManager();
    $games = $em->getRepository(Game::class)->findAll();

    foreach($games as $g){
        $records = new ArrayCollection;
        $records = $em->getRepository(Game::class)->findAllRecords($g->getId());
    }


    return $this->render('game/records.html.twig', [            
        'games' => $games,
        'records' => $records,
    ]);
}

Here is the repository function :

public function findAllRecords($id){
    $qb = $this->createQueryBuilder('g');

    $qb->select('g.name')
        ->innerJoin('g.Parties', 'p')
        ->innerJoin('p.playeds', 'y')
        ->innerJoin('y.joueur', 'j')
        ->addSelect('y.score')        
        ->addSelect('j.nom, j.prenom')
        ->where('g.id = :id')
        ->setParameter('id', $id)            
        ->orderBy('y.score', 'DESC')
        ->setMaxResults('5');
    var_dump($qb->getDQL());
    $query = $qb->getQuery();
    return $query->getResult();
}

And finally the view :

{% for g in games %}
{{ g.name }}
<table class="table">
    <tbody>
        <tr>                
            <th>score</th>
        </tr>
            {% for r in records %}
       <tr>
            <td>{{ r.score }}</td>
        </tr>
            {% endfor %}
    </tbody>
</table>
{% endfor %}

It doesn't completely works as I just get the data from the last game ID. How can I show the data for each game ?

Upvotes: 0

Views: 132

Answers (1)

Andy
Andy

Reputation: 727

foreach($games as $g){ $records = new ArrayCollection; $records = $em->getRepository(Game::class)->findAllRecords($g->getId()); }

Here's your issue. This is always overwriting. You want to do something like:

$records = new ArrayCollection;
foreach($games as $g) {
  $records[] = $em->......;
}

That should solve your issue

Upvotes: 2

Related Questions