ヤミRoot VoidGate

Viewing: LineStandingRepository.php

<?php

namespace AppBundle\Repository;

use AppBundle\Entity\Line;
use AppBundle\Entity\Standing;
/**
 * LineStandingRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class LineStandingRepository extends \Doctrine\ORM\EntityRepository
{
    public function findOneByLineAndStanding(Line $line, Standing $standing){
        $qb = $this
        ->createQueryBuilder('ls')
        ->innerJoin('ls.line','l', 'WITH' , 'l.lineId = :line_id')
            ->addSelect( 'l')
        ->innerJoin('ls.standing', 's', 'WITH' , 's.standingId = :standing_id')
            ->addSelect('s')
        ->setParameter('line_id', $line->getLineId())
        ->setParameter('standing_id', $standing->getStandingId());

        $lineStanding = $qb
            ->getQuery()
            ->getOneOrNullResult();

        return $lineStanding;
    }
}

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