src/Repository/VehicleModelRepository.php line 87

  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\BlogKind;
  6. use App\Entity\Dealer;
  7. use App\Entity\VehicleCategory;
  8. use App\Entity\VehicleKind;
  9. use App\Entity\VehicleManufacturer;
  10. use App\Entity\VehicleModel;
  11. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  12. use Doctrine\Persistence\ManagerRegistry;
  14. /**
  15.  * @extends ServiceEntityRepository<VehicleModel>
  16.  *
  17.  * @method VehicleModel|null find($id, $lockMode = null, $lockVersion = null)
  18.  * @method VehicleModel|null findOneBy(array $criteria, array $orderBy = null)
  19.  * @method VehicleModel[]    findAll()
  20.  * @method VehicleModel[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  21.  */
  22. class VehicleModelRepository extends ServiceEntityRepository
  23. {
  24.     public function __construct(ManagerRegistry $registry)
  25.     {
  26.         parent::__construct($registry, VehicleModel::class);
  27.     }
  29.     public function save(VehicleModel $entity, bool $flush = false): void
  30.     {
  31.         $this->getEntityManager()->persist($entity);
  33.         if ($flush) {
  34.             $this->getEntityManager()->flush();
  35.         }
  36.     }
  38.     public function remove(VehicleModel $entity, bool $flush = false): void
  39.     {
  40.         $this->getEntityManager()->remove($entity);
  42.         if ($flush) {
  43.             $this->getEntityManager()->flush();
  44.         }
  45.     }
  47.     /**
  48.      * @return VehicleModel[]  Returns an array of VehicleCategory objects
  49.      */
  50.     public function findActive( VehicleManufacturer $manufacturer =  null,
  51.                                 VehicleCategory $vehicleCategory = null, VehicleKind  $vehicleKind = null): array
  52.     {
  53.        $return =  $this->createQueryBuilder('vm')
  54.             ->leftJoin('vm.vehicles', 'vehicles')
  55.             ->andWhere('vehicles.visible = true')
  56.             ->leftJoin('vehicles.dealer', 'dealer')
  57.             ->andWhere('dealer.visible = true');
  59.         if( $manufacturer ) {
  60.             $return
  61.                 ->andWhere('vehicles.manufacturer = :manufacturer')
  62.                 ->setParameter('manufacturer', $manufacturer);
  63.         }
  65.         if( $vehicleCategory ) {
  66.             $return
  67.                 ->andWhere('vehicles.category = :vehicleCategory')
  68.                 ->setParameter('vehicleCategory', $vehicleCategory);
  69.         }
  71.         if( $vehicleKind ) {
  72.             $return
  73.                 ->andWhere('vehicles.kind = :vehicleKind')
  74.                 ->setParameter('vehicleKind', $vehicleKind);
  75.         }
  77.         return   $return
  78.             ->orderBy('vm.name', 'ASC')
  79.             ->getQuery()
  80.             ->getResult();
  81.     }
  84.     /**
  85.      * @return VehicleModel[] Returns an array of VehicleManufacturer objects
  86.      */
  87.     public function findByDealerActive(Dealer $dealer, int $manufacturerId =  null): array
  88.     {
  89.         $return =  $this->createQueryBuilder('vm')
  90.             ->leftJoin('vm.vehicles', 'v')
  91.             ->andWhere('v.dealer = :dealer')
  92.             ->andWhere('v.visible = true')
  93.             ->setParameter('dealer', $dealer);
  95.         if(isset($manufacturerId)) {
  96.             $return->andWhere('vm.vehicleManufacturer = :manufacturer')
  97.                 ->setParameter('manufacturer', $manufacturerId);
  98.         }
  100.       return  $return ->orderBy('vm.name', 'ASC')
  101.             ->getQuery()
  102.             ->getResult();
  103.     }
  106.     public function findName(string $name): ?VehicleModel
  107.     {
  108.         return $this->createQueryBuilder('v')
  109.             ->andWhere('v.name LIKE :name')
  110.             ->setParameter('name', '%'.$name.'%')
  111.             ->setMaxResults(1)
  112.             ->getQuery()
  113.             ->getOneOrNullResult();
  114.     }
  116.     /**
  117.      * @return VehicleModel[]
  118.      */
  119.     public function findByManufacturerAndBlogKind(VehicleManufacturer $manufacturer, BlogKind $blogKind): array
  120.     {
  121.         return $this->createQueryBuilder('vm')
  122.             ->leftJoin('vm.blogs', 'b')
  123.             ->leftJoin('b.kinds', 'bk')
  124.             ->andWhere('bk = :blogKind')
  125.             ->andWhere('vm.vehicleManufacturer = :manufacturer')
  126.             ->andWhere('b.visible = true')
  127.             ->setParameter('blogKind', $blogKind)
  128.             ->setParameter('manufacturer', $manufacturer)
  129.             ->orderBy('vm.name', 'ASC')
  130.             ->getQuery()
  131.             ->getResult();
  132.     }
  133. }