app/Plugin/EccubePaymentLite42/Service/GetProductClassesRegularCycles.php line 31

Open in your IDE?
  1. <?php
  3. namespace Plugin\EccubePaymentLite42\Service;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Eccube\Entity\Order;
  7. use Eccube\Entity\ProductClass;
  8. use Eccube\Repository\ProductClassRepository;
  9. use Plugin\EccubePaymentLite42\Entity\ProductClassRegularCycle;
  10. use Plugin\EccubePaymentLite42\Entity\RegularCycle;
  12. class GetProductClassesRegularCycles
  13. {
  14.     /**
  15.      * @var ProductClassRepository
  16.      */
  17.     private $productClassRepository;
  18.     /**
  19.      * @var EntityManagerInterface
  20.      */
  21.     private $entityManager;
  23.     public function __construct(
  24.         ProductClassRepository $productClassRepository,
  25.         EntityManagerInterface $entityManager
  26.     ) {
  27.         $this->productClassRepository = $productClassRepository;
  28.         $this->entityManager = $entityManager;
  29.     }
  31.     public function handle(Order $Order)
  32.     {
  33.         $productClassIds = $this->getProductClassIds($Order);
  34.         $regularCycleIds = $this->getRegularCycleIds($Order);
  35.         $qb = $this
  36.             ->entityManager
  37.             ->createQueryBuilder();
  38.         $qb
  39.             ->select('rc')
  40.             ->from(ProductClass::class, 'pc')
  41.             ->innerJoin(ProductClassRegularCycle::class, 'pcrc')
  42.             ->innerJoin(RegularCycle::class, 'rc')
  43.             ->where(
  44.                 $qb->expr()->in('pc.id', ':productClassIds')
  45.             )
  46.             ->andWhere(
  47.                 $qb->expr()->in('rc.id', ':regularCycleIds')
  48.             )
  49.             ->setParameter('productClassIds', $productClassIds)
  50.             ->setParameter('regularCycleIds', $regularCycleIds)
  51.             ->orderBy('rc.sort_no', 'DESC')
  52.         ;
  54.         return $qb
  55.             ->getQuery()
  56.             ->getResult();
  57.     }
  59.     private function getProductClassIds(Order $Order)
  60.     {
  61.         $productClassIds = [];
  62.         foreach ($Order->getProductOrderItems() as $key => $OrderItem) {
  63.             $productClassId = $OrderItem->getProductClass()->getId();
  64.             $productClassIds[$productClassId] = $productClassId;
  65.         }
  67.         return $productClassIds;
  68.     }
  70.     private function getRegularCycleIds(Order $Order)
  71.     {
  72.         $regularCycleIds = [];
  73.         foreach ($Order->getProductOrderItems() as $key => $OrderItem) {
  74.             $tempRegularCycleIds = [];
  75.             foreach ($OrderItem->getProductClass()->getRegularCycle() as $regularCycle) {
  76.                 /** @var RegularCycle $regularCycle */
  77.                 $regularCycleId = $regularCycle->getId();
  78.                 $tempRegularCycleIds[] = $regularCycleId;
  79.             }
  80.             if ($key === 0) {
  81.                 $regularCycleIds = $tempRegularCycleIds;
  82.                 continue;
  83.             }
  84.             $regularCycleIds = array_intersect($regularCycleIds, $tempRegularCycleIds);
  85.         }
  87.         return $regularCycleIds;
  88.     }
  89. }