@@ 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']) { |