AppBundle\Entity\SupplierRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	41
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	3
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getSuppliers()	0	8	1
A	getSupplierForReassign()	0	16	1

<?php

/**
 * Entité Supplier.
 *
 * 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    since 1.0.0
 *
 * @link       https://github.com/Dev-Int/glsr
 */
namespace AppBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * SupplierRepository Entité Supplier.
 *
 * @category   Entity
 */
class SupplierRepository extends EntityRepository
{
    /**
     * Affiche les fournisseurs actifs.
     *
     * @return QueryBuilder Requête DQL
     */
    public function getSuppliers()
    {
        $query = $this->createQueryBuilder('s')
            ->where('s.active = 1')
            ->orderBy('s.name', 'ASC');
        
        return $query;
    }

    /**
     * Renvoie les fournisseurs actifs correspondant à la famille logistique
     * de l'article en paramètre.
     *
     * @param AppBundle\Entity\Article $article Article sélectionné
     *
     * @return QueryBuilder Requête DQL
     */
    public function getSupplierForReassign($article)
    {
        $query = $this->createQueryBuilder('s')
            ->where('s.name != :idname')
            ->andWhere('s.family_log = :flname')
            ->andWhere('s.active = 1')
            ->setParameters(
                array(
                    'idname' => $article->getSupplier()->getName(),
                    'flname' => $article->getFamilyLog(),
                )
            )
            ->orderBy('s.name', 'ASC');

        return $query;
    }
}