| @@ 162-166 (lines=5) @@ | ||
| 159 | } |
|
| 160 | ||
| 161 | // Pref |
|
| 162 | if (!empty($searchData['pref']) && $searchData['pref']) { |
|
| 163 | $qb |
|
| 164 | ->andWhere('c.Pref = :pref') |
|
| 165 | ->setParameter('pref', $searchData['pref']->getId()); |
|
| 166 | } |
|
| 167 | ||
| 168 | // sex |
|
| 169 | if (!empty($searchData['sex']) && count($searchData['sex']) > 0) { |
|
| @@ 180-184 (lines=5) @@ | ||
| 177 | ->setParameter('sexs', $sexs); |
|
| 178 | } |
|
| 179 | ||
| 180 | if (!empty($searchData['birth_month']) && $searchData['birth_month']) { |
|
| 181 | $qb |
|
| 182 | ->andWhere('EXTRACT(MONTH FROM c.birth) = :birth_month') |
|
| 183 | ->setParameter('birth_month', $searchData['birth_month']); |
|
| 184 | } |
|
| 185 | ||
| 186 | // birth |
|
| 187 | if (!empty($searchData['birth_start']) && $searchData['birth_start']) { |
|