Add functions findOneByIdAsArray and findAllByPeriodAsArray

[airbundle] / Repository / SnippetRepository.php

diff --git a/Repository/SnippetRepository.php b/Repository/SnippetRepository.php
index a1d696b720f9856987ad7f3f684c0706e63cd2df..2da863e1ff66af6f5dacfa79d7fdbd639deffa8f 100644 (file)
--- a/Repository/SnippetRepository.php
+++ b/Repository/SnippetRepository.php
@@ -1,27 +1,33 @@
-<?php
+<?php declare(strict_types=1);

 
 

-namespace Rapsys\AirBundle\Repository;
+/*
+ * This file is part of the Rapsys AirBundle package.
+ *
+ * (c) Raphaël Gertz <symfony@rapsys.eu>
+ *
+ * For the full copyright and license information, please view the LICENSE
+ * file that was distributed with this source code.
+ */

 
 

-use Symfony\Component\Translation\TranslatorInterface;
-use Doctrine\ORM\Query\ResultSetMapping;
+namespace Rapsys\AirBundle\Repository;

 
 /**
  * SnippetRepository
  */
 class SnippetRepository extends \Doctrine\ORM\EntityRepository {
        /**
 
 /**
  * SnippetRepository
  */
 class SnippetRepository extends \Doctrine\ORM\EntityRepository {
        /**

-        * Find snippets by locale and user id
+        * Find snippets by user id, locale and index by location id

         *
         *

+        * @param int $user The user

         * @param string $locale The locale
         * @param string $locale The locale

-        * @param User|int $user The user
-        * @return array The snippets or empty array
+        * @return array The snippets array

         */
         */

-       public function findByLocaleUserId($locale, $user) {
+       public function findByUserIdLocaleIndexByLocationId(int $userId, string $locale): array {

                //Fetch snippets
                //Fetch snippets

-               $ret = $this->getEntityManager()
-                       ->createQuery('SELECT s FROM RapsysAirBundle:Snippet s WHERE s.locale = :locale and s.user = :user')
+               $ret = $this->_em
+                       ->createQuery('SELECT s FROM RapsysAirBundle:Snippet s INDEX BY s.location WHERE s.locale = :locale and s.user = :user')
+                       ->setParameter('user', $userId)

                        ->setParameter('locale', $locale)
                        ->setParameter('locale', $locale)

-                       ->setParameter('user', $user)

                        ->getResult();
 
                //Send result
                        ->getResult();
 
                //Send result