zend-blog-3-backend

1
<?php
2

3
namespace App\Repository;
4

5
use Doctrine\ORM\Query;
6
use Doctrine\ORM\QueryBuilder;
7

8
trait ListQueryTrait
9
{
10
    /**
11
     * @param bool $nameBased
12
     *
13
     * @return Query
14
     */
15
    public function getListQuery(bool $nameBased = false): Query
16
    {
17
        /* @var QueryBuilder $qb */
18
        $qb = $this->createQueryBuilder('e');
19

20
        if ($nameBased) {
21
            $qb->orderBy('e.name', 'ASC');
22
        } else {
23
            $qb->orderBy('e.id', 'DESC');
24
        }
25

26
        return $qb->getQuery();
27
    }
28
}
29