| @@ 199-204 (lines=6) @@ | ||
| 196 | } |
|
| 197 | ||
| 198 | // oreder_date |
|
| 199 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
| 200 | $date = $searchData['order_date_start']; |
|
| 201 | $qb |
|
| 202 | ->andWhere('o.order_date >= :order_date_start') |
|
| 203 | ->setParameter('order_date_start', $date); |
|
| 204 | } |
|
| 205 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
| 206 | $date = clone $searchData['order_date_end']; |
|
| 207 | $date = $date |
|
| @@ 205-212 (lines=8) @@ | ||
| 202 | ->andWhere('o.order_date >= :order_date_start') |
|
| 203 | ->setParameter('order_date_start', $date); |
|
| 204 | } |
|
| 205 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
| 206 | $date = clone $searchData['order_date_end']; |
|
| 207 | $date = $date |
|
| 208 | ->modify('+1 days'); |
|
| 209 | $qb |
|
| 210 | ->andWhere('o.order_date < :order_date_end') |
|
| 211 | ->setParameter('order_date_end', $date); |
|
| 212 | } |
|
| 213 | ||
| 214 | // payment_date |
|
| 215 | if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) { |
|
| @@ 215-220 (lines=6) @@ | ||
| 212 | } |
|
| 213 | ||
| 214 | // payment_date |
|
| 215 | if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) { |
|
| 216 | $date = $searchData['payment_date_start']; |
|
| 217 | $qb |
|
| 218 | ->andWhere('o.payment_date >= :payment_date_start') |
|
| 219 | ->setParameter('payment_date_start', $date); |
|
| 220 | } |
|
| 221 | if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) { |
|
| 222 | $date = clone $searchData['payment_date_end']; |
|
| 223 | $date = $date |
|
| @@ 221-228 (lines=8) @@ | ||
| 218 | ->andWhere('o.payment_date >= :payment_date_start') |
|
| 219 | ->setParameter('payment_date_start', $date); |
|
| 220 | } |
|
| 221 | if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) { |
|
| 222 | $date = clone $searchData['payment_date_end']; |
|
| 223 | $date = $date |
|
| 224 | ->modify('+1 days'); |
|
| 225 | $qb |
|
| 226 | ->andWhere('o.payment_date < :payment_date_end') |
|
| 227 | ->setParameter('payment_date_end', $date); |
|
| 228 | } |
|
| 229 | ||
| 230 | // update_date |
|
| 231 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| @@ 231-236 (lines=6) @@ | ||
| 228 | } |
|
| 229 | ||
| 230 | // update_date |
|
| 231 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| 232 | $date = $searchData['update_date_start']; |
|
| 233 | $qb |
|
| 234 | ->andWhere('o.update_date >= :update_date_start') |
|
| 235 | ->setParameter('update_date_start', $date); |
|
| 236 | } |
|
| 237 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 238 | $date = clone $searchData['update_date_end']; |
|
| 239 | $date = $date |
|
| @@ 237-244 (lines=8) @@ | ||
| 234 | ->andWhere('o.update_date >= :update_date_start') |
|
| 235 | ->setParameter('update_date_start', $date); |
|
| 236 | } |
|
| 237 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 238 | $date = clone $searchData['update_date_end']; |
|
| 239 | $date = $date |
|
| 240 | ->modify('+1 days'); |
|
| 241 | $qb |
|
| 242 | ->andWhere('o.update_date < :update_date_end') |
|
| 243 | ->setParameter('update_date_end', $date); |
|
| 244 | } |
|
| 245 | ||
| 246 | // payment_total |
|
| 247 | if (isset($searchData['payment_total_start']) && StringUtil::isNotBlank($searchData['payment_total_start'])) { |
|
| @@ 290-295 (lines=6) @@ | ||
| 287 | } |
|
| 288 | ||
| 289 | // お届け予定日(Shipping.delivery_date) |
|
| 290 | if (!empty($searchData['shipping_delivery_date_start']) && $searchData['shipping_delivery_date_start']) { |
|
| 291 | $date = $searchData['shipping_delivery_date_start']; |
|
| 292 | $qb |
|
| 293 | ->andWhere('s.shipping_delivery_date >= :shipping_delivery_date_start') |
|
| 294 | ->setParameter('shipping_delivery_date_start', $date); |
|
| 295 | } |
|
| 296 | if (!empty($searchData['shipping_delivery_date_end']) && $searchData['shipping_delivery_date_end']) { |
|
| 297 | $date = clone $searchData['shipping_delivery_date_end']; |
|
| 298 | $date = $date |
|
| @@ 296-303 (lines=8) @@ | ||
| 293 | ->andWhere('s.shipping_delivery_date >= :shipping_delivery_date_start') |
|
| 294 | ->setParameter('shipping_delivery_date_start', $date); |
|
| 295 | } |
|
| 296 | if (!empty($searchData['shipping_delivery_date_end']) && $searchData['shipping_delivery_date_end']) { |
|
| 297 | $date = clone $searchData['shipping_delivery_date_end']; |
|
| 298 | $date = $date |
|
| 299 | ->modify('+1 days'); |
|
| 300 | $qb |
|
| 301 | ->andWhere('s.shipping_delivery_date < :shipping_delivery_date_end') |
|
| 302 | ->setParameter('shipping_delivery_date_end', $date); |
|
| 303 | } |
|
| 304 | ||
| 305 | // Order By |
|
| 306 | $qb->orderBy('o.update_date', 'DESC'); |
|
| @@ 147-152 (lines=6) @@ | ||
| 144 | } |
|
| 145 | ||
| 146 | // oreder_date |
|
| 147 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
| 148 | $date = $searchData['order_date_start']; |
|
| 149 | $qb |
|
| 150 | ->andWhere('o.order_date >= :order_date_start') |
|
| 151 | ->setParameter('order_date_start', $date); |
|
| 152 | } |
|
| 153 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
| 154 | $date = clone $searchData['order_date_end']; |
|
| 155 | $date = $date |
|
| @@ 153-160 (lines=8) @@ | ||
| 150 | ->andWhere('o.order_date >= :order_date_start') |
|
| 151 | ->setParameter('order_date_start', $date); |
|
| 152 | } |
|
| 153 | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
|
| 154 | $date = clone $searchData['order_date_end']; |
|
| 155 | $date = $date |
|
| 156 | ->modify('+1 days'); |
|
| 157 | $qb |
|
| 158 | ->andWhere('o.order_date < :order_date_end') |
|
| 159 | ->setParameter('order_date_end', $date); |
|
| 160 | } |
|
| 161 | ||
| 162 | // shipping_delivery_date |
|
| 163 | if (!empty($searchData['shipping_delivery_date_start']) && $searchData['shipping_delivery_date_start']) { |
|
| @@ 163-168 (lines=6) @@ | ||
| 160 | } |
|
| 161 | ||
| 162 | // shipping_delivery_date |
|
| 163 | if (!empty($searchData['shipping_delivery_date_start']) && $searchData['shipping_delivery_date_start']) { |
|
| 164 | $date = $searchData['shipping_delivery_date_start']; |
|
| 165 | $qb |
|
| 166 | ->andWhere('s.shipping_delivery_date >= :shipping_delivery_date_start') |
|
| 167 | ->setParameter('shipping_delivery_date_start', $date); |
|
| 168 | } |
|
| 169 | if (!empty($searchData['shipping_delivery_date_end']) && $searchData['shipping_delivery_date_end']) { |
|
| 170 | $date = clone $searchData['shipping_delivery_date_end']; |
|
| 171 | $date = $date |
|
| @@ 169-176 (lines=8) @@ | ||
| 166 | ->andWhere('s.shipping_delivery_date >= :shipping_delivery_date_start') |
|
| 167 | ->setParameter('shipping_delivery_date_start', $date); |
|
| 168 | } |
|
| 169 | if (!empty($searchData['shipping_delivery_date_end']) && $searchData['shipping_delivery_date_end']) { |
|
| 170 | $date = clone $searchData['shipping_delivery_date_end']; |
|
| 171 | $date = $date |
|
| 172 | ->modify('+1 days'); |
|
| 173 | $qb |
|
| 174 | ->andWhere('s.shipping_delivery_date < :shipping_delivery_date_end') |
|
| 175 | ->setParameter('shipping_delivery_date_end', $date); |
|
| 176 | } |
|
| 177 | ||
| 178 | // shipping_date |
|
| 179 | if (!empty($searchData['shipping_date_start']) && $searchData['shipping_date_start']) { |
|
| @@ 179-184 (lines=6) @@ | ||
| 176 | } |
|
| 177 | ||
| 178 | // shipping_date |
|
| 179 | if (!empty($searchData['shipping_date_start']) && $searchData['shipping_date_start']) { |
|
| 180 | $date = $searchData['shipping_date_start']; |
|
| 181 | $qb |
|
| 182 | ->andWhere('s.shipping_date >= :shipping_date_start') |
|
| 183 | ->setParameter('shipping_date_start', $date); |
|
| 184 | } |
|
| 185 | if (!empty($searchData['shipping_date_end']) && $searchData['shipping_date_end']) { |
|
| 186 | $date = clone $searchData['shipping_date_end']; |
|
| 187 | $date = $date |
|
| @@ 185-192 (lines=8) @@ | ||
| 182 | ->andWhere('s.shipping_date >= :shipping_date_start') |
|
| 183 | ->setParameter('shipping_date_start', $date); |
|
| 184 | } |
|
| 185 | if (!empty($searchData['shipping_date_end']) && $searchData['shipping_date_end']) { |
|
| 186 | $date = clone $searchData['shipping_date_end']; |
|
| 187 | $date = $date |
|
| 188 | ->modify('+1 days'); |
|
| 189 | $qb |
|
| 190 | ->andWhere('s.shipping_date < :shipping_date_end') |
|
| 191 | ->setParameter('shipping_date_end', $date); |
|
| 192 | } |
|
| 193 | ||
| 194 | // update_date |
|
| 195 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| @@ 195-200 (lines=6) @@ | ||
| 192 | } |
|
| 193 | ||
| 194 | // update_date |
|
| 195 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| 196 | $date = $searchData['update_date_start']; |
|
| 197 | $qb |
|
| 198 | ->andWhere('s.update_date >= :update_date_start') |
|
| 199 | ->setParameter('update_date_start', $date); |
|
| 200 | } |
|
| 201 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 202 | $date = clone $searchData['update_date_end']; |
|
| 203 | $date = $date |
|
| @@ 201-208 (lines=8) @@ | ||
| 198 | ->andWhere('s.update_date >= :update_date_start') |
|
| 199 | ->setParameter('update_date_start', $date); |
|
| 200 | } |
|
| 201 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 202 | $date = clone $searchData['update_date_end']; |
|
| 203 | $date = $date |
|
| 204 | ->modify('+1 days'); |
|
| 205 | $qb |
|
| 206 | ->andWhere('s.update_date < :update_date_end') |
|
| 207 | ->setParameter('update_date_end', $date); |
|
| 208 | } |
|
| 209 | ||
| 210 | // payment_total |
|
| 211 | if (isset($searchData['payment_total_start']) && StringUtil::isNotBlank($searchData['payment_total_start'])) { |
|
| @@ 145-151 (lines=7) @@ | ||
| 142 | ->andWhere('c.birth >= :birth_start') |
|
| 143 | ->setParameter('birth_start', $searchData['birth_start']); |
|
| 144 | } |
|
| 145 | if (!empty($searchData['birth_end']) && $searchData['birth_end']) { |
|
| 146 | $date = clone $searchData['birth_end']; |
|
| 147 | $date->modify('+1 days'); |
|
| 148 | $qb |
|
| 149 | ->andWhere('c.birth < :birth_end') |
|
| 150 | ->setParameter('birth_end', $date); |
|
| 151 | } |
|
| 152 | ||
| 153 | // tel |
|
| 154 | if (isset($searchData['phone_number']) && StringUtil::isNotBlank($searchData['phone_number'])) { |
|
| @@ 191-197 (lines=7) @@ | ||
| 188 | ->andWhere('c.create_date >= :create_date_start') |
|
| 189 | ->setParameter('create_date_start', $searchData['create_date_start']); |
|
| 190 | } |
|
| 191 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
| 192 | $date = clone $searchData['create_date_end']; |
|
| 193 | $date->modify('+1 days'); |
|
| 194 | $qb |
|
| 195 | ->andWhere('c.create_date < :create_date_end') |
|
| 196 | ->setParameter('create_date_end', $date); |
|
| 197 | } |
|
| 198 | ||
| 199 | // update_date |
|
| 200 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| @@ 205-211 (lines=7) @@ | ||
| 202 | ->andWhere('c.update_date >= :update_date_start') |
|
| 203 | ->setParameter('update_date_start', $searchData['update_date_start']); |
|
| 204 | } |
|
| 205 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 206 | $date = clone $searchData['update_date_end']; |
|
| 207 | $date->modify('+1 days'); |
|
| 208 | $qb |
|
| 209 | ->andWhere('c.update_date < :update_date_end') |
|
| 210 | ->setParameter('update_date_end', $date); |
|
| 211 | } |
|
| 212 | ||
| 213 | // last_buy |
|
| 214 | if (!empty($searchData['last_buy_start']) && $searchData['last_buy_start']) { |
|
| @@ 219-225 (lines=7) @@ | ||
| 216 | ->andWhere('c.last_buy_date >= :last_buy_start') |
|
| 217 | ->setParameter('last_buy_start', $searchData['last_buy_start']); |
|
| 218 | } |
|
| 219 | if (!empty($searchData['last_buy_end']) && $searchData['last_buy_end']) { |
|
| 220 | $date = clone $searchData['last_buy_end']; |
|
| 221 | $date->modify('+1 days'); |
|
| 222 | $qb |
|
| 223 | ->andWhere('c.last_buy_date < :last_buy_end') |
|
| 224 | ->setParameter('last_buy_end', $date); |
|
| 225 | } |
|
| 226 | ||
| 227 | // status |
|
| 228 | if (!empty($searchData['customer_status']) && count($searchData['customer_status']) > 0) { |
|
| @@ 301-306 (lines=6) @@ | ||
| 298 | } |
|
| 299 | ||
| 300 | // crate_date |
|
| 301 | if (!empty($searchData['create_date_start']) && $searchData['create_date_start']) { |
|
| 302 | $date = $searchData['create_date_start']; |
|
| 303 | $qb |
|
| 304 | ->andWhere('p.create_date >= :create_date_start') |
|
| 305 | ->setParameter('create_date_start', $date); |
|
| 306 | } |
|
| 307 | ||
| 308 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
| 309 | $date = clone $searchData['create_date_end']; |
|
| @@ 308-315 (lines=8) @@ | ||
| 305 | ->setParameter('create_date_start', $date); |
|
| 306 | } |
|
| 307 | ||
| 308 | if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
|
| 309 | $date = clone $searchData['create_date_end']; |
|
| 310 | $date = $date |
|
| 311 | ->modify('+1 days'); |
|
| 312 | $qb |
|
| 313 | ->andWhere('p.create_date < :create_date_end') |
|
| 314 | ->setParameter('create_date_end', $date); |
|
| 315 | } |
|
| 316 | ||
| 317 | // update_date |
|
| 318 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| @@ 318-323 (lines=6) @@ | ||
| 315 | } |
|
| 316 | ||
| 317 | // update_date |
|
| 318 | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
|
| 319 | $date = $searchData['update_date_start']; |
|
| 320 | $qb |
|
| 321 | ->andWhere('p.update_date >= :update_date_start') |
|
| 322 | ->setParameter('update_date_start', $date); |
|
| 323 | } |
|
| 324 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 325 | $date = clone $searchData['update_date_end']; |
|
| 326 | $date = $date |
|
| @@ 324-331 (lines=8) @@ | ||
| 321 | ->andWhere('p.update_date >= :update_date_start') |
|
| 322 | ->setParameter('update_date_start', $date); |
|
| 323 | } |
|
| 324 | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
|
| 325 | $date = clone $searchData['update_date_end']; |
|
| 326 | $date = $date |
|
| 327 | ->modify('+1 days'); |
|
| 328 | $qb |
|
| 329 | ->andWhere('p.update_date < :update_date_end') |
|
| 330 | ->setParameter('update_date_end', $date); |
|
| 331 | } |
|
| 332 | ||
| 333 | // Order By |
|
| 334 | $qb |
|