X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/98544db2e8f7e804efce8efabffc7e62b4c09b02..42d2646c377a92fd92d37e09ef6b733fa9b50946:/Repository/SnippetRepository.php

diff --git a/Repository/SnippetRepository.php b/Repository/SnippetRepository.php
new file mode 100644
index 0000000..a1d696b
--- /dev/null
+++ b/Repository/SnippetRepository.php
@@ -0,0 +1,30 @@
+<?php
+
+namespace Rapsys\AirBundle\Repository;
+
+use Symfony\Component\Translation\TranslatorInterface;
+use Doctrine\ORM\Query\ResultSetMapping;
+
+/**
+ * SnippetRepository
+ */
+class SnippetRepository extends \Doctrine\ORM\EntityRepository {
+	/**
+	 * Find snippets by locale and user id
+	 *
+	 * @param string $locale The locale
+	 * @param User|int $user The user
+	 * @return array The snippets or empty array
+	 */
+	public function findByLocaleUserId($locale, $user) {
+		//Fetch snippets
+		$ret = $this->getEntityManager()
+			->createQuery('SELECT s FROM RapsysAirBundle:Snippet s WHERE s.locale = :locale and s.user = :user')
+			->setParameter('locale', $locale)
+			->setParameter('user', $user)
+			->getResult();
+
+		//Send result
+		return $ret;
+	}
+}