From: Raphaël Gertz Date: Tue, 4 Oct 2022 07:07:23 +0000 (+0200) Subject: Rename function findByLocaleUserId to findByUserIdLocaleIndexByLocationId X-Git-Tag: 0.3.0~222 X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/7a0be510744f8f8abec3b9eb6e4d389e86949602 Rename function findByLocaleUserId to findByUserIdLocaleIndexByLocationId Php strict Cleanup --- diff --git a/Repository/SnippetRepository.php b/Repository/SnippetRepository.php index a1d696b..2da863e 100644 --- a/Repository/SnippetRepository.php +++ b/Repository/SnippetRepository.php @@ -1,27 +1,33 @@ - + * + * 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 { /** - * 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 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 - $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('user', $user) ->getResult(); //Send result