timegridio /
concierge
| @@ 376-379 (lines=4) @@ | ||
| 373 | return $query |
|
| 374 | ->where(function ($query) use ($startAt, $finishAt) { |
|
| 375 | ||
| 376 | $query->where(function ($query) use ($startAt, $finishAt) { |
|
| 377 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 378 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 379 | }) |
|
| 380 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 381 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 382 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| @@ 380-383 (lines=4) @@ | ||
| 377 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 378 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 379 | }) |
|
| 380 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 381 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 382 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 383 | }) |
|
| 384 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 385 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 386 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 384-387 (lines=4) @@ | ||
| 381 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 382 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 383 | }) |
|
| 384 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 385 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 386 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 387 | }) |
|
| 388 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 389 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 390 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 388-391 (lines=4) @@ | ||
| 385 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 386 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 387 | }) |
|
| 388 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 389 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 390 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| 391 | }); |
|
| 392 | ||
| 393 | }); |
|
| 394 | } |
|
