* * @method Court|null find($id, $lockMode = null, $lockVersion = null) * @method Court|null findOneBy(array $criteria, array $orderBy = null) * @method Court[] findAll() * @method Court[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null) */ class CourtRepository extends ServiceEntityRepository { public function __construct(ManagerRegistry $registry) { parent::__construct($registry, Court::class); } public function findCourt(int $id): ?Court { return $this->createQueryBuilder('court') ->andWhere('court.id = :val') ->setParameter('val', $id) ->getQuery() ->getOneOrNullResult() ; } public function findOneByCourtName(string $court_name): ?Court { return $this->createQueryBuilder('court') ->andWhere('court.court_name = :val') ->setParameter('val', $court_name) ->getQuery() ->getOneOrNullResult() ; } public function findOneByCourtPostcode(string $court_postcode): ?Court { return $this->createQueryBuilder('court') ->andWhere('court.court_postcode = :val') ->setParameter('val', $court_postcode) ->getQuery() ->getOneOrNullResult() ; } // /** // * @return Court[] Returns an array of Court objects // */ // public function findByExampleField($value): array // { // return $this->createQueryBuilder('u') // ->andWhere('u.exampleField = :val') // ->setParameter('val', $value) // ->orderBy('u.id', 'ASC') // ->setMaxResults(10) // ->getQuery() // ->getResult() // ; // } // public function findOneBySomeField($value): ?Court // { // return $this->createQueryBuilder('u') // ->andWhere('u.exampleField = :val') // ->setParameter('val', $value) // ->getQuery() // ->getOneOrNullResult() // ; // } }