Conditions | 1 |
Paths | 1 |
Total Lines | 9 |
Code Lines | 7 |
Lines | 0 |
Ratio | 0 % |
Changes | 0 |
1 | <?php |
||
31 | public function findByProvinceName(string $provinceName): array |
||
32 | { |
||
33 | return $this->createQueryBuilder('o') |
||
34 | ->leftJoin(Province::class, 'p', 'WITH', 'p.code = o.provinceCode') |
||
35 | ->where('o.provinceName LIKE :province') |
||
36 | ->orWhere('p.name LIKE :province') |
||
37 | ->setParameter('province', '%' . $provinceName . '%') |
||
38 | ->getQuery() |
||
39 | ->getResult() |
||
40 | ; |
||
56 |