for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace AppBundle\Entity;
use Doctrine\ORM\EntityRepository;
class CategoryRepository extends EntityRepository
{
public function findOrderedByPosition()
return $this
->createQueryBuilder('c')
->select('c, m')
->leftJoin('c.meals', 'm')
->orderBy('c.position', 'ASC')
->addOrderBy('m.position', 'ASC')
->getQuery()
->getResult()
;
}
public function countAll()
->select('COUNT(c.id)')
->getSingleScalarResult()