AppBundle\Repository\CustomerOrderRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	23
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	findLastOpenOrder()	0	14	1

<?php

namespace AppBundle\Repository;

use AppBundle\Entity\Customer;
use AppBundle\Entity\CustomerOrder;

class CustomerOrderRepository extends AbstractRepository
{
    /**
     * Method returns opened customer order
     *
     * @param Customer $param
     * @return CustomerOrder|null
     */
    public function findLastOpenOrder(Customer $param)
    {
        return $this->createQueryBuilder('o')
            ->join('o.customer', 'c')
            ->where('o.status = :opened')
            ->andWhere('c.id = :param')
            ->setParameter(':param', $param->getId())
            ->setParameter(':opened', CustomerOrder::STATUS_OPENED)
            ->orderBy('o.id', 'DESC')
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult()
            ;
    }
}