zend-blog-3-backend

1
<?php
2

3
namespace App\Repository;
4

5
use App\Entity\PygmentsLanguage;
6
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
7
use Doctrine\Persistence\ManagerRegistry;
8

9
class PygmentsLanguageRepository extends ServiceEntityRepository
10
{
11
    use ListQueryTrait;
12

13
    /**
14
     * @param ManagerRegistry $registry
15
     */
16
    public function __construct(ManagerRegistry $registry)
17
    {
18
        parent::__construct($registry, PygmentsLanguage::class);
19
    }
20

21
    /**
22
     * @return array
23
     */
24
    public function getNamesArray(): array
25
    {
26
        $qb = $this->createQueryBuilder('lang')
27
            ->select('lang.id', 'lang.name')
28
            ->orderBy('lang.name', 'ASC');
29

30
        return $qb->getQuery()->getArrayResult();
31
    }
32
}
33