HasPeriodColumns

HasPeriodColumns.php

<?php

namespace App\Support\Traits;

use Carbon\CarbonInterface;
use Illuminate\Contracts\Database\Eloquent\Builder;

trait HasPeriodColumns
{
    public function scopeOverlapping(Builder $query, CarbonInterface $start, CarbonInterface $end, string $startColumn, string $endColumn): Builder
    {
        return $query->where(static function (Builder $query) use ($start, $end, $startColumn, $endColumn) {
            return $query
                ->whereBetween($startColumn, [$start, $end])
                ->orWhereBetween($endColumn, [$start, $end])
                ->orWhere($startColumn, '>', $start)->where($endColumn, '<', $end);
        });
    }
}