timegridio /
concierge
| @@ 493-496 (lines=4) @@ | ||
| 490 | return $query |
|
| 491 | ->where(function ($query) use ($startAt, $finishAt) { |
|
| 492 | ||
| 493 | $query->where(function ($query) use ($startAt, $finishAt) { |
|
| 494 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 495 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 496 | }) |
|
| 497 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 498 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 499 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| @@ 497-500 (lines=4) @@ | ||
| 494 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 495 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 496 | }) |
|
| 497 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 498 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 499 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 500 | }) |
|
| 501 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 502 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 503 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 501-504 (lines=4) @@ | ||
| 498 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 499 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 500 | }) |
|
| 501 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 502 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 503 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 504 | }) |
|
| 505 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 506 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 507 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 505-508 (lines=4) @@ | ||
| 502 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 503 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 504 | }) |
|
| 505 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 506 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 507 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| 508 | }); |
|
| 509 | ||
| 510 | }); |
|
| 511 | } |
|
