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