EC-CUBE /
ec-cube
| @@ 138-149 (lines=12) @@ | ||
| 135 | } |
|
| 136 | ||
| 137 | // birth |
|
| 138 | if (!empty($searchData['birth_start']) && $searchData['birth_start']) { |
|
| 139 | if (!$joinedCustomer) { |
|
| 140 | $qb->leftJoin('o.Customer', 'c'); |
|
| 141 | $joinedCustomer = true; |
|
| 142 | } |
|
| 143 | ||
| 144 | $date = $searchData['birth_start'] |
|
| 145 | ->format('Y-m-d H:i:s'); |
|
| 146 | $qb |
|
| 147 | ->andWhere('c.birth >= :birth_start') |
|
| 148 | ->setParameter('birth_start', $date); |
|
| 149 | } |
|
| 150 | if (!empty($searchData['birth_end']) && $searchData['birth_end']) { |
|
| 151 | if (!$joinedCustomer) { |
|
| 152 | $qb->leftJoin('o.Customer', 'c'); |
|
| @@ 150-163 (lines=14) @@ | ||
| 147 | ->andWhere('c.birth >= :birth_start') |
|
| 148 | ->setParameter('birth_start', $date); |
|
| 149 | } |
|
| 150 | if (!empty($searchData['birth_end']) && $searchData['birth_end']) { |
|
| 151 | if (!$joinedCustomer) { |
|
| 152 | $qb->leftJoin('o.Customer', 'c'); |
|
| 153 | $joinedCustomer = true; |
|
| 154 | } |
|
| 155 | ||
| 156 | $date = clone $searchData['birth_end']; |
|
| 157 | $date = $date |
|
| 158 | ->modify('+1 days') |
|
| 159 | ->format('Y-m-d H:i:s'); |
|
| 160 | $qb |
|
| 161 | ->andWhere('c.birth < :birth_end') |
|
| 162 | ->setParameter('birth_end', $date); |
|
| 163 | } |
|
| 164 | ||
| 165 | // sex |
|
| 166 | if (!empty($searchData['sex']) && count($searchData['sex']) > 0) { |
|
