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