src/Repository/CarriersSubscriptionsRepository.php line 21

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\CarriersSubscriptions;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\ORM\Exception\ORMException;
  8. use Doctrine\ORM\OptimisticLockException;
  9. use Doctrine\Persistence\ManagerRegistry;
  11. /**
  12.  * @extends ServiceEntityRepository<CarriersSubscriptions>
  13.  *
  14.  * @method CarriersSubscriptions|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method CarriersSubscriptions|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method CarriersSubscriptions[]    findAll()
  17.  * @method CarriersSubscriptions[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class CarriersSubscriptionsRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, CarriersSubscriptions::class);
  24.     }
  26.     /**
  27.      * @throws ORMException
  28.      * @throws OptimisticLockException
  29.      */
  30.     public function add(CarriersSubscriptions $entity, bool $flush = false): void
  31.     {
  32.         $this->_em->persist($entity);
  33.         if ($flush) {
  34.             $this->_em->flush();
  35.         }
  36.     }
  38.     /**
  39.      * @throws ORMException
  40.      * @throws OptimisticLockException
  41.      */
  42.     public function remove(CarriersSubscriptions $entity, bool $flush = false): void
  43.     {
  44.         $this->_em->remove($entity);
  45.         if ($flush) {
  46.             $this->_em->flush();
  47.         }
  48.     }
  50. //    /**
  51. //     * @return CarriersSubscriptions[] Returns an array of CarriersSubscriptions objects
  52. //     */
  53. //    public function findByExampleField($value): array
  54. //    {
  55. //        return $this->createQueryBuilder('c')
  56. //            ->andWhere('c.exampleField = :val')
  57. //            ->setParameter('val', $value)
  58. //            ->orderBy('c.id', 'ASC')
  59. //            ->setMaxResults(10)
  60. //            ->getQuery()
  61. //            ->getResult()
  62. //        ;
  63. //    }
  65. //    public function findOneBySomeField($value): ?CarriersSubscriptions
  66. //    {
  67. //        return $this->createQueryBuilder('c')
  68. //            ->andWhere('c.exampleField = :val')
  69. //            ->setParameter('val', $value)
  70. //            ->getQuery()
  71. //            ->getOneOrNullResult()
  72. //        ;
  73. //    }
  74.     public function findCarrierSubscriptionsByCarrier($carrier_id){
  75.         return $this->createQueryBuilder('c')
  76.             ->select('c.id, c.unsubscribed_at, c.nbDesiredVehicles, c.subscribed_at, c.start_at, c.trial_end_date, p.trial_duration_days')
  77.             ->leftJoin('c.carriers', 'ca')
  78.             ->leftJoin('c.package', 'p')
  79.             ->where('ca.id = :carrier_id')
  80.             ->setParameter('carrier_id', $carrier_id)
  81.             ->getQuery()
  82.             ->getResult();
  83.     }
  84.     public function findCarrierSubscriptionsEndsBefore2Months(){
  85.         return $this->createQueryBuilder('c')
  86.             ->select('ca.id AS carrier_id, c.id, c.unsubscribed_at,c.end_at')
  87.             ->leftJoin('c.carriers', 'ca')
  88.             ->getQuery()
  89.             ->getResult();
  90.     }
  91.     public function getExpirationAccountDate($carrier_id){
  92.         return $this->createQueryBuilder('cs')
  93.             ->select('cs.subscribed_at, p.nbr_month_of_validity')
  94.             ->leftJoin('cs.package', 'p')
  95.             ->leftJoin('cs.carriers', 'ca')
  96.             ->where('ca.id = :carrier_id')
  97.             ->setParameter('carrier_id', $carrier_id)
  98.             ->getQuery()
  99.             ->getResult();
  100.     }
  101.     public function getLastSubscription($carrier_id,$status){
  102.         return $this->createQueryBuilder('cs')
  103.             ->select('cs.id, cs.subscribed_at,cs.start_at,cs.end_at,cs.nbDesiredVehicles,pa.trial_duration_days')
  104.             ->leftJoin('cs.carriers', 'ca')
  105.             ->leftJoin('cs.payment', 'p')
  106.             ->leftJoin('cs.package', 'pa')
  107.             ->where('ca.id = :carrier_id')
  108.             ->setParameter('carrier_id', $carrier_id)
  109.             ->andWhere('p.status = :status')
  110.             ->setParameter('status', $status)
  111.             ->orderBy('cs.id', 'DESC')
  112.             ->setMaxResults(1)
  113.             ->getQuery()
  114.             ->getResult();
  115.     }
  116. }