app/Customize/Repository/ReserveRepository.php line 52

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of EC-CUBE
  5.  *
  6.  * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  7.  *
  8.  * http://www.ec-cube.co.jp/
  9.  *
  10.  * For the full copyright and license information, please view the LICENSE
  11.  * file that was distributed with this source code.
  12.  */
  14. namespace Customize\Repository;
  16. use Customize\Entity\Reserve;
  17. use Eccube\Repository\AbstractRepository;
  18. use Doctrine\Persistence\ManagerRegistry as RegistryInterface;
  20. /**
  21.  * Reserve
  22.  *
  23.  * This class was generated by the Doctrine ORM. Add your own custom
  24.  * repository methods below.
  25.  */
  26. class ReserveRepository extends AbstractRepository
  27. {
  28.     public function __construct(RegistryInterface $registry)
  29.     {
  30.         parent::__construct($registry, Reserve::class);
  31.     }
  33.     /**
  34.      * 一覧を取得する.
  35.      *
  36.      * @return \Customize\Entity\Reserve[] 一覧の配列
  37.      */
  38.     public function findReserveByDay($date=null, \Customize\Entity\ReserveSetting $ReserveSetting)
  39.     {
  40.         $qb = $this->createQueryBuilder('r')
  41.             ->where('r.ReserveSetting = :ReserveSetting')
  42.             ->andwhere('r.reserve_day = :date')
  43.             ->addOrderBy('r.ReserveTime', 'DESC')
  44.             ->setParameter('ReserveSetting', $ReserveSetting)
  45.             ->setParameter('date', $date);
  47.         $Reserves = $qb->getQuery()->getResult();
  49.         return $Reserves;
  50.     }
  52.     public function findReserveByReasonDay($date=null, $ReserveReason=null, \Customize\Entity\ReserveSetting $ReserveSetting, $Customer)
  53.     {
  54.         $qb = $this->createQueryBuilder('r')
  55.             ->where('r.ReserveSetting = :ReserveSetting')
  56.             ->andwhere('r.Customer IS NOT NULL')
  57.             ->andWhere('r.ReserveReason = :ReserveReason')
  58.             ->andwhere('r.reserve_day > :date')
  59.             ->andwhere('r.Customer = :Customer')
  60.             ->addOrderBy('r.ReserveTime', 'DESC')
  61.             ->setParameter('ReserveSetting', $ReserveSetting)
  62.             ->setParameter('ReserveReason', $ReserveReason)
  63.             ->setParameter('date', (new \DateTime())->format('Y-m-d'))
  64.             ->setParameter('Customer', $Customer);
  66.         $Reserves = $qb->getQuery()->getResult();
  68.         return $Reserves;
  69.     }
  71.     public function getTimeCount($date=null, \Customize\Entity\ReserveSetting $ReserveSetting, \Customize\Entity\Master\ReserveTime $ReserveTime,\Eccube\Entity\Master\Sex $Sex=null)
  72.     {
  73.         $qb = $this->createQueryBuilder('r')
  74.             ->select('COUNT(r.id) as cnt')
  75.             ->leftJoin('r.Customer', 'c')
  76.             ->where('r.ReserveSetting = :ReserveSetting')
  77.             ->andwhere('r.reserve_day = :date')
  78.             ->andwhere('r.Customer IS NOT NULL')
  79.             ->andwhere('r.ReserveTime = :ReserveTime');
  80.         if($Sex)
  81.             $qb = $qb->andwhere('c.Sex = :Sex');
  83.         $qb = $qb->setParameter('ReserveSetting', $ReserveSetting)
  84.             ->setParameter('ReserveTime', $ReserveTime)
  85.             ->setParameter('date', $date);
  86.         if($Sex)
  87.             $qb = $qb->setParameter('Sex', $Sex);
  89.         $TimeCount = $qb->getQuery()->getSingleResult();
  90.         return $TimeCount;
  91.     }
  93.     public function getReserveByMonth($month, \Customize\Entity\ReserveSetting $ReserveSetting)
  94.     {
  95.         $qb = $this->createQueryBuilder('r')
  96.             ->select('r as reserve,COUNT(r.id) as cnt')
  97.             ->innerJoin('r.Customer', 'c')
  98.             ->where('r.ReserveSetting = :ReserveSetting')
  99.             ->andwhere('r.reserve_day LIKE :month')
  100.             ->groupBy('r.reserve_day')
  101.             ->addGroupBy('c.Sex')
  102.             ->setParameter('ReserveSetting', $ReserveSetting)
  103.             ->setParameter('month', '%'.$month.'%');
  104.         $MonthReserve = $qb->getQuery()->getResult();
  105.         return $MonthReserve;
  106.     }
  108.     public function getReserveByCustomer(\Eccube\Entity\Customer $Customer)
  109.     {
  110.         $qb = $this->createQueryBuilder('r')
  111.             ->select('r.id','r.reserve_day','rs.kubun_place_id','rs.place_id','s.store_name','s.addr01','s.addr02','p.name as pref_name','rt.name as reserve_time')
  112.             ->leftJoin('r.ReserveSetting', 'rs')
  113.             ->leftJoin('Customize\Entity\Store', 's', 'WITH', 'rs.place_id = s.store_id')
  114.             ->leftJoin('s.Pref', 'p')
  115.             ->leftJoin('r.ReserveTime', 'rt')
  116.             ->where('r.Customer = :Customer')
  117.             ->orderBy('r.reserve_day','desc')
  118.             ->setParameter('Customer', $Customer);
  120.         return $qb;
  121.     }
  123.     public function getQueryBuilderForCSVExport($date=null, \Customize\Entity\ReserveSetting $ReserveSetting){
  124.         $qb = $this->createQueryBuilder('r')
  125.             ->where('r.ReserveSetting = :ReserveSetting')
  126.             ->andwhere('r.reserve_day = :date')
  127.             ->andwhere('r.Customer IS NOT NULL')
  128.             ->addOrderBy('r.ReserveTime', 'DESC')
  129.             ->setParameter('ReserveSetting', $ReserveSetting)
  130.             ->setParameter('date', $date);
  132.         return $qb;
  133.     }
  134. }