AppBundle\Repository\Stocks\InventoryRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getAllItems()	0	7	1
A	getItems()	0	7	1
A	getLastInventory()	0	8	1

<?php

/**
 * Entité Inventory.
 *
 * PHP Version 5
 *
 * @author    Quétier Laurent <lq@dev-int.net>
 * @copyright 2014 Dev-Int GLSR
 * @license   http://opensource.org/licenses/gpl-license.php GNU Public License
 *
 * @version GIT: <git_id>
 *
 * @link https://github.com/Dev-Int/glsr
 */
namespace AppBundle\Repository\Stocks;

use Doctrine\ORM\EntityRepository;

/**
 * InventoryRepository
 *
 * @category Entity
 */
class InventoryRepository extends EntityRepository
{
    /**
     * Affiche tous les inventaires.
     *
     * @return QueryBuilder Requête DQL
     */
    public function getAllItems()
    {
        $query = $this->createQueryBuilder('i')
            ->orderBy('i.id', 'DESC');
        
        return $query;
    }

    /**
     * Affiche les inventaires actifs.
     *
     * @return QueryBuilder Requête DQL
     */
    public function getItems()
    {
        $query = $this->getAllItems()
            ->where('i.status > 0');

        return $query;
    }

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

        return $query->getResult();
    }
}