Laravel范围的模型自定义场值

Question

我的模型如下

class WorkingTime extends Model
{
    protected $table = 'working_times';
    protected $fillable = ['day', 'start_time', 'finish_time', 'user_id'];
    public function scopeAfterStart($query, $start)
    {
        return $query->where('start_time', '<=', $start);
    }

    public function scopeBeforeFinish($query, $finish)
    {
        return $query->where('finish_time', '>=', $finish);
    }
}

，可以使用以下查询，

WorkingTime::afterStart(1200)->beforeFinish(1800)->get();

我需要做的是，在work_times表中start_time_time＆gt; finish_time值，我必须检查finish_time + 2400＆gt; = $ teright。更具体地说，必须发生以下查询之类的事情，

with new_working_times as (
    select       
        start_time,
        case when start_time > finish_time then
            finish_time + 2400 
        else
            finish_time
        end as finish_time   
)
select * from new_working_times
where finish_time > {finishTime} and start_time < {start_time}

我该如何通过雄辩和范围进行操作？