|
public getCustomerCount ( |
||
| $Customer | ||
| $OrderStatuses | array | |
| return | Doctrine\ORM\QueryBuilder | |
public function getCustomerCount(\Eccube\Entity\Customer $Customer, array $OrderStatuses)
{
$result = $this->createQueryBuilder('o')->select('COUNT(o.id) AS buy_times, SUM(o.total) AS buy_total')->where('o.Customer = :Customer')->andWhere('o.OrderStatus in (:OrderStatuses)')->setParameter('Customer', $Customer)->setParameter('OrderStatuses', $OrderStatuses)->groupBy('o.id')->orderBy('o.id', 'ASC')->getQuery()->getResult();
return $result;
}