app/Plugin/CustomerReview42/Repository/CustomerReviewListRepository.php line 85

Open in your IDE?
  1. <?php
  3. namespace Plugin\CustomerReview42\Repository;
  5. use Eccube\Util\StringUtil;
  6. use Eccube\Repository\AbstractRepository;
  7. use Plugin\CustomerReview42\Entity\CustomerReviewList;
  8. use Plugin\CustomerReview42\Entity\CustomerReviewStatus;
  9. use Doctrine\Persistence\ManagerRegistry;
  11. class CustomerReviewListRepository extends AbstractRepository
  12. {
  13.     /**
  14.      * CustomerReviewListRepository constructor.
  15.      *
  16.      * @param ManagerRegistry $registry
  17.      */
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, CustomerReviewList::class);
  21.     }
  23.     /**
  24.      * @param int $id
  25.      * @return null|CustomerReviewList
  26.      */
  27.     public function get($id)
  28.     {
  29.         return $this->find($id);
  30.     }
  32.     /**
  33.      * get query builder.
  34.      *
  35.      * @param  array $searchData
  36.      *
  37.      * @return \Doctrine\ORM\QueryBuilder
  38.      */
  39.     public function getQueryBuilderBySearchData($searchData)
  40.     {
  41.         $qb = $this->createQueryBuilder('r')
  42.                 ->andWhere('r.Status = :status' )
  43.                 ->setParameter('status', CustomerReviewStatus::SHOW);
  45.         // 商品
  46.         if (!empty($searchData['product_id']) && $searchData['product_id']) {
  47.             $qb
  48.                 ->andWhere('r.Product = :product_id' )
  49.                 ->setParameter('product_id', $searchData['product_id']);
  50.         }
  52.         // 評価
  53.         $search_recommend_level = false;
  54.         if (!empty($searchData['star']) && $searchData['star']) {
  55.             $qb->andWhere('r.recommend_level = :recommend_level' )
  56.                 ->setParameter('recommend_level', $searchData['star']);
  57.             $search_recommend_level = true;
  58.         }
  60.         // Order By
  61.         if (!empty($searchData['orderby']) && $searchData['orderby'] == CustomerReviewList::POST_OLDER ) {
  62.         // 投稿日が古い順
  63.             $qb->OrderBy('r.create_date', 'ASC');
  64.         } else if (!$search_recommend_level && !empty($searchData['orderby']) && $searchData['orderby'] == CustomerReviewList::RECOMMEND_HIGHER ) {
  65.         // 評価が高い順
  66.             $qb->OrderBy('r.recommend_level', 'DESC');
  67.             $qb->addOrderBy('r.create_date', 'DESC');
  68.         } else if (!$search_recommend_level && !empty($searchData['orderby']) && $searchData['orderby'] == CustomerReviewList::RECOMMEND_LOWER ) {
  69.         // 評価が低い順
  70.             $qb->OrderBy('r.recommend_level', 'ASC');
  71.             $qb->addOrderBy('r.create_date', 'DESC');
  72.         } else {
  73.         // 投稿日が新しい順
  74.             $qb->OrderBy('r.create_date', 'DESC');
  75.         }
  77.         return $qb;
  78.     }
  80.     /**
  81.      * @param int $product_id
  82.      * @param int $limit
  83.      * @return null|CustomerReviewList
  84.      */
  85.     public function getReviewList($product_id, $limit = 0)
  86.     {
  87.         $searchData['product_id'] = $product_id;
  88.         $qb = $this->getQueryBuilderBySearchData($searchData);
  89.         if ( is_numeric($limit) && $limit != 0 )
  90.         {
  91.             $qb->setMaxResults($limit);
  92.         }
  93.         return $qb->getQuery()->getResult();
  94.     }
  96.     /**
  97.      * get query builder.
  98.      *
  99.      * @param  array $searchData
  100.      *
  101.      * @return \Doctrine\ORM\QueryBuilder
  102.      */
  103.     public function getQueryBuilderBySearchDataForAdmin($searchData)
  104.     {
  105.         $qb = $this->createQueryBuilder('r')
  106.             ->addSelect('p')
  107.             ->innerJoin('r.Product', 'p');
  109.         // 商品
  110.         if (!empty($searchData['product_id']) && $searchData['product_id']) {
  111.             $qb
  112.                 ->andWhere('r.Product = :product_id' )
  113.                 ->setParameter('product_id', $searchData['product_id']);
  114.         }
  116.         // 投稿ユーザ
  117.         if (!empty($searchData['customer_id']) && $searchData['customer_id']) {
  118.             $qb
  119.                 ->andWhere('r.Customer = :customer_id' )
  120.                 ->setParameter('customer_id', $searchData['customer_id']);
  121.         }
  123.         // ステータス
  124.         if (!empty($searchData['status']) && count($searchData['status']) > 0) {
  125.             $qb
  126.                 ->andWhere($qb->expr()->in('r.Status', ':Status'))
  127.                 ->setParameter('Status', $searchData['status']);
  128.         }
  130.         // crate_date
  131.         if (isset($searchData['create_date_start']) && !is_null($searchData['create_date_start'])) {
  132.             $date = $searchData['create_date_start'];
  133.             $qb
  134.                 ->andWhere('r.create_date >= :create_date_start')
  135.                 ->setParameter('create_date_start', $date);
  136.         }
  138.         if (isset($searchData['create_date_end']) && !is_null($searchData['create_date_end'])) {
  139.             $date = clone $searchData['create_date_end'];
  140.             $date = $date
  141.                 ->modify('+1 days');
  142.             $qb
  143.                 ->andWhere('r.create_date < :create_date_end')
  144.                 ->setParameter('create_date_end', $date);
  145.         }
  147.         // Order By
  148.         $qb->orderBy('r.create_date', 'DESC');
  150.         return $qb;
  151.     }
  152. }