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