]> Raphaël G. Git Repositories - airbundle/blob - Repository/SlotRepository.php
Add google token entity
[airbundle] / Repository / SlotRepository.php
1 <?php declare(strict_types=1);
2
3 /*
4 * This file is part of the Rapsys AirBundle package.
5 *
6 * (c) Raphaël Gertz <symfony@rapsys.eu>
7 *
8 * For the full copyright and license information, please view the LICENSE
9 * file that was distributed with this source code.
10 */
11
12 namespace Rapsys\AirBundle\Repository;
13
14 use Doctrine\ORM\Query\ResultSetMapping;
15
16 /**
17 * SlotRepository
18 */
19 class SlotRepository extends Repository {
20 /**
21 * Find slots with translated title
22 *
23 * @return array The slots id keyed by translated title
24 */
25 public function findAllWithTranslatedTitle(): array {
26 //Set the request from quoted table name
27 //XXX: this allow to make this code table name independent
28 $req = 'SELECT s.id, s.title FROM RapsysAirBundle:Slot AS s';
29
30 //Replace bundle entity name by table name
31 $req = str_replace($this->tableKeys, $this->tableValues, $req);
32
33 //Get result set mapping instance
34 //XXX: DEBUG: see ../blog.orig/src/Rapsys/BlogBundle/Repository/ArticleRepository.php
35 $rsm = new ResultSetMapping();
36
37 //Declare all fields
38 //XXX: see vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/Types.php
39 //addScalarResult($sqlColName, $resColName, $type = 'string');
40 $rsm->addScalarResult('id', 'id', 'integer')
41 ->addScalarResult('title', 'title', 'string')
42 ->addIndexByScalar('id');
43
44 //Fetch result
45 $res = $this->_em
46 ->createNativeQuery($req, $rsm)
47 ->getResult();
48
49 //Init return
50 $ret = [];
51
52 //Process result
53 foreach($res as $data) {
54 //Get translated slot
55 $slot = $this->translator->trans($data['title']);
56 //Set data
57 //XXX: ChoiceType use display string as key
58 $ret[$slot] = $data['id'];
59 }
60
61 //Send result
62 return $ret;
63 }
64 }