Completed
Push — sf2.7 ( 0eab0c...d4139d )
by Laurent
03:30
created

ArticleRepository::getArticles()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 10
Code Lines 7

Duplication

Lines 0
Ratio 0 %

Importance

Changes 2
Bugs 0 Features 0
Metric Value
c 2
b 0
f 0
dl 0
loc 10
rs 9.4285
cc 1
eloc 7
nc 1
nop 0
1
<?php
2
3
/**
4
 * Entité Article.
5
 *
6
 * PHP Version 5
7
 *
8
 * @author     Quétier Laurent <[email protected]>
9
 * @copyright  2014 Dev-Int GLSR
10
 * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
11
 *
12
 * @version    since 1.0.0
13
 *
14
 * @link       https://github.com/Dev-Int/glsr
15
 */
16
namespace AppBundle\Entity;
17
18
use Doctrine\ORM\EntityRepository;
19
use Doctrine\ORM\Tools\Pagination\Paginator;
20
21
/**
22
 * ArticleRepository.
23
 *
24
 * @category   Entity
25
 */
26
class ArticleRepository extends EntityRepository
27
{
28
    /**
29
     * Affiche les articles actifs.
30
     *
31
     * @return QueryBuilder Requête DQL
32
     */
33
    public function getArticles()
34
    {
35
        $query = $this->createQueryBuilder('a')
36
            ->leftjoin('a.supplier', 's')
37
            ->addSelect('s')
38
            ->where('a.active = 1')
39
            ->orderBy('a.name', 'ASC');
40
        
41
        return $query;
42
    }
43
44
    /**
45
     * Renvoi les article du fournisseur en paramètre.
46
     *
47
     * @param int $supplier Supplier_id
48
     *
49
     * @return array Query result
50
     */
51
    public function getArticleFromSupplier($supplier)
52
    {
53
        $query = $this->createQueryBuilder('a')
54
            ->where('a.active = 1')
55
            ->where('a.supplier = :id')
56
            ->setParameter('id', $supplier)
57
            ->orderBy('a.name', 'ASC')
58
            ->getQuery();
59
60
        return $query->getResult();
61
    }
62
}
63