AppBundle\Entity\CategoryRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	countAll()	0	9	1
A	findOrderedByPosition()	0	12	1

<?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()
    {
        return $this
            ->createQueryBuilder('c')
            ->select('COUNT(c.id)')
            ->getQuery()
            ->getSingleScalarResult()
        ;
    }
}