app/Plugin/ApexOrderItemOption/Repository/OptionRepository.php line 15

Open in your IDE?
  1. <?php
  3. namespace Plugin\ApexOrderItemOption\Repository;
  5. use Eccube\Repository\AbstractRepository;
  6. use Plugin\ApexOrderItemOption\Entity\Option;
  7. use Plugin\ApexOrderItemOption\Repository\ProductOptionRepository;
  8. use Doctrine\Persistence\ManagerRegistry as RegistryInterface;
  10. class OptionRepository extends AbstractRepository
  11. {
  13.     public function __construct(RegistryInterface $registry, $entityClass = Option::class)
  14.     {
  15.         parent::__construct($registry, $entityClass);
  16.     }
  18.     public function getList()
  19.     {
  20.         $qb = $this->createQueryBuilder('o')
  21.                 ->orderBy('o.sort_no', 'DESC');
  22.         $Options = $qb->getQuery()
  23.                 ->getResult();
  25.         return $Options;
  26.     }
  28.     public function getIds()
  29.     {
  30.         $qb = $this->createQueryBuilder('o')
  31.                 ->select('o.id')
  32.                 ->orderBy('o.sort_no', 'DESC');
  33.         $results = $qb->getQuery()
  34.                 ->getResult();
  36.         $Ids = [];
  37.         foreach($results as $result){
  38.             $Ids[] = $result['id'];
  39.         }
  40.         return $Ids;
  41.     }
  43.     public function saveOption($Option)
  44.     {
  45.         $em = $this->getEntityManager();
  46.         try {
  47.             if (!$Option->getId()) {
  48.                 $sort_no = $this->createQueryBuilder('o')
  49.                         ->select('MAX(o.sort_no)')
  50.                         ->getQuery()
  51.                         ->getSingleScalarResult();
  52.                 if (!$sort_no) {
  53.                     $sort_no = 0;
  54.                 }
  55.                 $Option->setSortNo($sort_no + 1);
  56.             }
  58.             if($Option->getType() == Option::CHECKBOX_TYPE){
  59.                 $Option->setIsRequired(false);
  60.             }elseif($Option->getType() == Option::NUMBER_TYPE || $Option->getType() == Option::TEXT_TYPE || $Option->getType() == Option::TEXTAREA_TYPE){
  61.             }else{
  62.                 $Option->setRequireMin(null);
  63.                 $Option->setRequireMax(null);
  64.             }
  66.             $em->persist($Option);
  67.             $em->flush();
  69.         } catch (\Exception $e) {
  70.             return false;
  71.         }
  73.         return true;
  74.     }
  76.     public function deleteOption($Option)
  77.     {
  78.         $em = $this->getEntityManager();
  79.         try {
  80.             $ProductOptions = $em->createQueryBuilder()
  81.                                  ->from('Plugin\ApexOrderItemOption\Entity\ProductOption','po')
  82.                                  ->select('po')
  83.                                  ->where('po.Option = :Option')
  84.                                  ->setParameter('Option',$Option)
  85.                                  ->getQuery()
  86.                                  ->getResult();
  88.             if (count($ProductOptions) > 0) {
  89.                 foreach($ProductOptions as $ProductOption){
  90.                     $productOptionRepository = $em->getRepository('Plugin\ApexOrderItemOption\Entity\ProductOption');
  91.                     /** @var ProductOptionRepository $productOptionRepository **/
  92.                     $productOptionRepository
  93.                                 ->deleteProductOption($ProductOption);
  94.                 }
  95.             }
  97.             $sort_no = $Option->getSortNo();
  98.             $em->createQueryBuilder()
  99.                     ->update('Plugin\ApexOrderItemOption\Entity\Option', 'o')
  100.                     ->set('o.sort_no', 'o.sort_no - 1')
  101.                     ->where('o.sort_no > :sort_no')->setParameter('sort_no', $sort_no)
  102.                     ->getQuery()
  103.                     ->execute();
  105.             $em->remove($Option);
  106.             $em->flush();
  107.         } catch (\Exception $e) {
  108.             return false;
  109.         }
  111.         return true;
  112.     }
  114. }