AppBundle\Entity\InventoryRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getInventory()	0	7	1
A	getLastInventory()	0	8	1
A	findActive()	0	8	1

<?php

namespace AppBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * InventoryRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class InventoryRepository extends EntityRepository
{
    /**
     * Affiche les inventaires actifs.
     *
     * @return QueryBuilder Requête DQL
     */
    public function getInventory()
    {
        $query = $this->findActive()
            ->getQuery();
        
        return $query->getResult();
    }

    /**
     * Renvoi les derniers inventaires.
     *
     * @param integer $count Nombre d'élément à afficher
     * @return array Query result
     */
    public function getLastInventory($count)
    {
        $query = $this->findActive()
            ->setMaxResults($count)
            ->getQuery();

        return $query->getResult();
    }

    private function findActive()
    {
        $query = $this->createQueryBuilder('i')
            ->where('i.status > 0')
            ->orderBy('i.id', 'DESC');

        return $query;
    }
}