for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
/* For licensing terms, see /license.txt */
namespace Chamilo\FaqBundle\Repository;
use Chamilo\FaqBundle\Entity\Question;
use Doctrine\ORM\EntityRepository;
/**
* Class QuestionRepository.
*
* @package Genj\FaqBundle\Entity
*/
class QuestionRepository extends EntityRepository
{
* @param string $categorySlug
* @return Question|null
public function retrieveFirstByCategorySlug($categorySlug)
$query = $this->createQueryBuilder('q')
->join('q.category', 'c')
->join('c.translations', 't')
->where('t.slug = :categorySlug')
->orderBy('q.rank', 'ASC')
->setMaxResults(1)
->getQuery();
$query->setParameter('categorySlug', $categorySlug);
return $query->getOneOrNullResult();
}
* @param string $slug
public function getQuestionBySlug($slug)
->join('q.translations', 't')
->where('t.slug = :slug')
$query->setParameter('slug', $slug);
chamilo /
chamilo-lms
