ヤミRoot VoidGate

Viewing: CabRepository.php

<?php

namespace AppBundle\Repository;

/**
 * CabRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class CabRepository extends \Doctrine\ORM\EntityRepository
{
    public function search($companyId = null, $minCostPerHour = null, $maxCostPerHour = null, $minCostPerDay = null, $maxCostPerDay = null , $onlyActiveCabs = 'true', $deletedCabs =  'false')
    {
        // TODO:
        $qb =$this
        	->createQueryBuilder('cab');

        if($companyId)	
        	$qb
        	->innerJoin('cab.company', 'company', 'WITH', 'company.companyId = :companyId' )
        	->setParameter('companyId', $companyId);

        if($maxCostPerHour)
        	$qb
        	->andWhere('cab.maxCostPerHour <= :maxCostPerHour')
        	->setParameter('maxCostPerHour', $maxCostPerHour);

        if($maxCostPerDay)
        	$qb
        	->andWhere('cab.maxCostPerDay <= :maxCostPerDay')
        	->setParameter('maxCostPerDay', $maxCostPerDay);

        if($onlyActiveCabs == 'true') 
        	$qb->andWhere('cab.isActive = true');

        if($deletedCabs == 'false') 
        	$qb->andWhere('cab.isDeleted = false');
        
        $cabs_array = $qb
          ->getQuery()
          ->getResult();

        return $cabs_array;
    }
}

User / IP	: 216.73.216.33
Host / Server	: 146.88.233.70 / dev.loger.cm
System	: Linux hybrid1120.fr.ns.planethoster.net 3.10.0-957.21.2.el7.x86_64 #1 SMP Wed Jun 5 14:26:44 UTC 2019 x86_64