是否可以在Laravel中拆分查询构建器？

Question

Is it possible to split queries somehow like this?

public function getStatuses($dates)
{
    $query = DB::table('tickets');

    if ($dates['from'])
        $query = $query->where('from', $dates['from']);

    if ($dates['to'])
        $query = $query->where('to', $dates['to']);

    $query = $query->select('Active');

    return $query->get()->toArray();
}

Answer 1

Yes, it's possibile. But don't reassign to the same variable or you risk messing it up:

public function getStatuses($dates)
{
    $query = DB::table('tickets');
    if ($dates['from'])
        $query->where('from', $dates['from']);
    if ($dates['to'])
        $query->where('to', $dates['to']);
    $query->select('Active');
    return $query->get()->toArray();
}