timegridio /
concierge
| @@ 529-532 (lines=4) @@ | ||
| 526 | return $query |
|
| 527 | ->where(function ($query) use ($startAt, $finishAt) { |
|
| 528 | ||
| 529 | $query->where(function ($query) use ($startAt, $finishAt) { |
|
| 530 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 531 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 532 | }) |
|
| 533 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 534 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 535 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| @@ 533-536 (lines=4) @@ | ||
| 530 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 531 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 532 | }) |
|
| 533 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 534 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 535 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 536 | }) |
|
| 537 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 538 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 539 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 537-540 (lines=4) @@ | ||
| 534 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 535 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 536 | }) |
|
| 537 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 538 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 539 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 540 | }) |
|
| 541 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 542 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 543 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 541-544 (lines=4) @@ | ||
| 538 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 539 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 540 | }) |
|
| 541 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 542 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 543 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| 544 | }); |
|
| 545 | ||
| 546 | }); |
|
| 547 | } |
|
