public getFavoriteProductQueryBuilderByCustomer ( $Customer ) : Doctrine\ORM\QueryBuilder | ||
$Customer | ||
return | Doctrine\ORM\QueryBuilder |
public function getFavoriteProductQueryBuilderByCustomer($Customer)
{
$qb = $this->createQueryBuilder('p')->innerJoin('p.CustomerFavoriteProducts', 'cfp')->where('cfp.Customer = :Customer AND p.Status = 1')->setParameter('Customer', $Customer);
// Order By
// XXX Paginater を使用した場合に PostgreSQL で正しくソートできない
$qb->addOrderBy('cfp.create_date', 'DESC');
return $qb;
}