timegridio /
concierge
| @@ 517-520 (lines=4) @@ | ||
| 514 | return $query |
|
| 515 | ->where(function ($query) use ($startAt, $finishAt) { |
|
| 516 | ||
| 517 | $query->where(function ($query) use ($startAt, $finishAt) { |
|
| 518 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 519 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 520 | }) |
|
| 521 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 522 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 523 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| @@ 521-524 (lines=4) @@ | ||
| 518 | $query->where('finish_at', '>=', $finishAt->timezone('UTC')) |
|
| 519 | ->where('start_at', '<=', $startAt->timezone('UTC')); |
|
| 520 | }) |
|
| 521 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 522 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 523 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 524 | }) |
|
| 525 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 526 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 527 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 525-528 (lines=4) @@ | ||
| 522 | $query->where('finish_at', '<', $finishAt->timezone('UTC')) |
|
| 523 | ->where('finish_at', '>', $startAt->timezone('UTC')); |
|
| 524 | }) |
|
| 525 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 526 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 527 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 528 | }) |
|
| 529 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 530 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 531 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| @@ 529-532 (lines=4) @@ | ||
| 526 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 527 | ->where('start_at', '<', $finishAt->timezone('UTC')); |
|
| 528 | }) |
|
| 529 | ->orWhere(function ($query) use ($startAt, $finishAt) { |
|
| 530 | $query->where('start_at', '>', $startAt->timezone('UTC')) |
|
| 531 | ->where('finish_at', '<', $finishAt->timezone('UTC')); |
|
| 532 | }); |
|
| 533 | ||
| 534 | }); |
|
| 535 | } |
|
