zend-blog-3-backend

1
<?php
2

3
namespace App\Repository;
4

5
use App\Entity\PygmentsCode;
6
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
7
use Doctrine\ORM\Query;
8
use Doctrine\Persistence\ManagerRegistry;
9

10
/**
11
 * @method PygmentsCode|null find($id, $lockMode = null, $lockVersion = null)
12
 */
13
class PygmentsCodeRepository extends ServiceEntityRepository
14
{
15
    /**
16
     * @param ManagerRegistry $registry
17
     */
18
    public function __construct(ManagerRegistry $registry)
19
    {
20
        parent::__construct($registry, PygmentsCode::class);
21
    }
22

23
    public function getListQuery(): Query
24
    {
25
        $qb = $this->createQueryBuilder('e');
26
        $qb
27
            ->select('e', 'l')
28
            ->leftJoin('e.language', 'l')
29
            ->orderBy('e.id', 'DESC')
30
        ;
31

32
        return $qb->getQuery();
33
    }
34
}
35