src/Repository/SupplierCustomerRepository.php line 14

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Supplier;
  6. use App\Entity\SupplierCustomer;
  7. use DateTime;
  8. use Doctrine\ORM\EntityManagerInterface;
  10. class SupplierCustomerRepository extends GeneralRepository
  11. {
  12.     public function __construct(EntityManagerInterface $em)
  13.     {
  14.         parent::__construct($em, $em->getClassMetadata(SupplierCustomer::class));
  16.         $this->setLetter('sc');
  18.         $this->setDefaultSort([
  19.             'field' => 'createdAt',
  20.             'order' => 'DESC'
  21.         ]);
  22.         $this->setDefaultLimit(10);
  25.     }
  28.     public function setSearchParams($params)
  29.     {
  30.         parent::setSearchParams($params);
  33.         //        $isPartner = ( isset( $params['partner'] ) ) ? $params['partner'] : false;
  34.         //        $this->partner( $isPartner );
  36.         if (isset($params['supplierStatus'])) {
  37.             $this->supplierStatus($params['supplierStatus']);
  38.         }
  40.         if (isset($params['partnerOnly'])) {
  41.             if ($params['partnerOnly']) {
  42.                 $this->partnerOnly();
  43.             }
  44.         }
  46.         if (isset($params['guestOnly'])) {
  47.             if ($params['guestOnly']) {
  48.                 $this->guestOnly();
  49.             }
  50.         }
  53.         if (isset($params['customer'])) {
  55.             $this->qb
  56.                 ->andWhere($this->letter . '.customer = :customer')
  57.                 ->setParameter(':customer', $params['customer']);
  58.         }
  60.         if (isset($params['customers'])) {
  61.             $this->qb
  62.                 ->andWhere($this->letter . '.customer IN (:customers)')
  63.                 ->setParameter(':customers', $params['customers']);
  64.         }
  66.         if (isset($params['supplier'])) {
  68.             $this->qb
  69.                 ->andWhere($this->letter . '.supplier = :supplier')
  70.                 ->setParameter(':supplier', $params['supplier']);
  71.         }
  73.         if (isset($params['suppliers'])) {
  74.             $this->qb
  75.                 ->andWhere($this->letter . '.supplier IN (:suppliers)')
  76.                 ->setParameter(':suppliers', $params['suppliers']);
  77.         }
  79.         if (isset($params['adherentNumber'])) {
  80.             $this->qb
  81.                 ->andWhere($this->letter . '.adherentNumber = :adherentNumber')
  82.                 ->setParameter(':adherentNumber', $params['adherentNumber']);
  83.         }
  85.         if (isset($params['deliveryModel'])) {
  87.             $this->qb
  88.                 ->andWhere($this->letter . '.deliveryModel = :deliveryModel')
  89.                 ->setParameter(':deliveryModel', $params['deliveryModel']);
  91.         }
  93.         if (isset($params['createdBefore'])) {
  94.             $this->createdBefore($params['createdBefore']);
  95.         }
  97.         if (isset($params['adherentNumber' ])) {
  98.             $this->adherentNumber($params['adherentNumber']);
  99.         }
  100.     }
  102.     private function adherentNumber($adherentNumber)
  103.     {
  104.         $this->qb
  105.             ->andWhere($this->letter . '.adherentNumber = :adherentNumber')
  106.             ->setParameter('adherentNumber', $adherentNumber);
  107.     }
  109.     private function createdBefore(DateTime $date)
  110.     {
  111.         $day = clone $date;
  112.         $day->setTime(23, 59, 59);
  114.         $this->qb
  115.             ->andWhere($this->letter . '.createdAt <= :date')
  116.             ->setParameter('date', $day);
  117.     }
  120.     /**
  121.      * @param $id
  122.      *
  123.      * @return array
  124.      */
  125.     public function findOneEnabledById($id)
  126.     {
  127.         $query = $this->createQueryBuilder('sc')
  128.                       ->join('sc.supplier', 's')
  129.                       ->where('s.enabled = :enabled')
  130.                       ->andWhere('sc.id = :id')
  131.                       ->setParameter('id', $id)
  132.                       ->setParameter('enabled', true);
  134.         return $query->getQuery()->getResult();
  135.     }
  137.     private function supplierStatus($supplierStatus)
  138.     {
  139.         $this->qb
  140.             ->join($this->letter . '.supplier', 's')
  141.             ->andWhere('s.status = :supplierStatus')
  142.             ->setParameter(':supplierStatus', $supplierStatus);
  143.     }
  145.     private function partnerOnly()
  146.     {
  147.         $this->qb
  148.             ->join($this->letter . '.supplier', 's')
  149.             ->andWhere("s.status = '" . Supplier::STATUS_PARTNER . "'");
  150.     }
  152.     private function guestOnly()
  153.     {
  154.         $this->qb
  155.             ->join($this->letter . '.supplier', 's');
  157.         $this->qb
  158.             ->andWhere("s.status IN ('" . Supplier::STATUS_UNTRUSTED . "', '" . Supplier::STATUS_TRUSTED . "')");
  159.     }
  161. }