public function getQueryBuilderByCustomer(\Eccube\Entity\Customer $Customer)
{
$qb = $this->createQueryBuilder('cfp')->select('cfp, p')->innerJoin('cfp.Product', 'p')->where('cfp.Customer = :Customer AND p.Status = 1')->setParameter('Customer', $Customer);
// Order By
$qb->addOrderBy('cfp.create_date', 'DESC');
return $qb;
}