timegridio /
concierge
| @@ 510-513 (lines=4) @@ | ||
| 507 | return $query |
|
| 508 | ->where(function ($query) use ($startAt, $finishAt) { |
|
| 509 | ||
| 510 | $query->where(function ($query) use ($startAt, $finishAt) { |
|
| 511 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 512 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 513 | }) |
|
| 514 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 515 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 516 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| @@ 514-517 (lines=4) @@ | ||
| 511 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 512 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 513 | }) |
|
| 514 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 515 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 516 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 517 | }) |
|
| 518 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 519 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 520 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 518-521 (lines=4) @@ | ||
| 515 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 516 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 517 | }) |
|
| 518 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 519 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 520 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 521 | }) |
|
| 522 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 523 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 524 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 522-525 (lines=4) @@ | ||
| 519 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 520 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 521 | }) |
|
| 522 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 523 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 524 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| 525 | }); |
|
| 526 | ||
| 527 | }); |
|
| 528 | } |
|
