ヤミRoot VoidGate

Viewing: BuildingRepository.php

<?php

namespace App\Repository;

use App\Entity\Building;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;

/**
 * @method Building|null find($id, $lockMode = null, $lockVersion = null)
 * @method Building|null findOneBy(array $criteria, array $orderBy = null)
 * @method Building[]    findAll()
 * @method Building[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
class BuildingRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, Building::class);
    }

    // /**
    //  * @return Building[] Returns an array of Building objects
    //  */
    /*
    public function findByExampleField($value)
    {
        return $this->createQueryBuilder('b')
            ->andWhere('b.exampleField = :val')
            ->setParameter('val', $value)
            ->orderBy('b.id', 'ASC')
            ->setMaxResults(10)
            ->getQuery()
            ->getResult()
        ;
    }
    */

    /*
    public function findOneBySomeField($value): ?Building
    {
        return $this->createQueryBuilder('b')
            ->andWhere('b.exampleField = :val')
            ->setParameter('val', $value)
            ->getQuery()
            ->getOneOrNullResult()
        ;
    }
    */



    public function findByTown($townId): array
    {

        return $this->createQueryBuilder('b')
            ->leftJoin('b.address', 'a')
            ->leftJoin('a.town', 't')
            ->Where('b.address_id = a.id')
            ->Where('t.town_id = :town_id')
            ->setParameter('town_id', $townId)
            ->orderBy('b.id', 'DESC')
         // ->setMaxResults(10)
            ->getQuery()
            ->getResult();
    }

    public function findAllDetailByTown($townId, $buildId): array
    {

        if($buildId=="all"){
            return $this->createQueryBuilder('b')
                ->leftJoin('b.company', 'cmp' ,'b.company_id = cmp.id')
                ->leftJoin('b.options', 'op', 'b.options_id = op.id')
                ->leftJoin('b.address', 'a','b.address_id = a.id')
                ->leftJoin('b.type', 'tp','b.type_id = tp.id')
                ->leftJoin('a.town', 't', 'a.town_id = t.id')
                ->leftJoin('b.picture1', 'pt', 'b.picture1_id = pt.id')

                ->where('t.id = :town_id')

                ->andWhere('b.active = :active')
                ->setParameter('town_id', $townId)
                ->setParameter('active', true)



                ->orderBy('op.notiriety', 'DESC')
                // ->setMaxResults(10)
                ->getQuery()
                ->getResult();
        }else{
            return $this->createQueryBuilder('b')
                ->leftJoin('b.company', 'cmp' ,'b.company_id = cmp.id')
                ->leftJoin('b.options', 'op', 'b.options_id = op.id')
                ->leftJoin('b.address', 'a','b.address_id = a.id')
                ->leftJoin('b.type', 'tp','b.type_id = tp.id')
                ->leftJoin('a.town', 't', 'a.town_id = t.id')
                ->leftJoin('b.picture1', 'pt', 'b.picture1_id = pt.id')

                ->where('t.id = :town_id')
                ->andWhere('tp.id = :type_id')
                ->andWhere('b.active = :active')
                ->setParameter('town_id', $townId)
                ->setParameter('active', true)
                ->setParameter('type_id', $buildId)


                ->orderBy('op.notiriety', 'DESC')
                // ->setMaxResults(10)
                ->getQuery()
                ->getResult();
        }


    }

}
User / IP	: 216.73.216.81
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