EC-CUBE / ec-cube

     * @param  \Eccube\Entity\Customer $Customer

     * @return QueryBuilder

     */

    public function getQueryBuilderByCustomer(\Eccube\Entity\Customer $Customer)

    {

        $qb = $this->createQueryBuilder('o')

            ->where('o.Customer = :Customer')

            ->setParameter('Customer', $Customer);

        // Order By

        $qb->addOrderBy('o.id', 'DESC');

        return $this->queries->customize(QueryKey::ORDER_SEARCH_BY_CUSTOMER, $qb, ['customer' => $Customer]);

    }

    /**

     * 会員の合計購入金額を取得、回数を取得

     * @see CustomerFavoriteProductRepository::getQueryBuilderByCustomer()

     * @deprecated since 3.0.0, to be removed in 3.1

     */

    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 $this->queries->customize(QueryKey::PRODUCT_GET_FAVORITE, $qb, ['customer' => $Customer]);

    }

}