/** * Query builder scope for RTD assets * * @param Illuminate\Database\Query\Builder $query Query builder instance * * @return Illuminate\Database\Query\Builder Modified query builder */ public function scopeRTD($query) { return $query->whereNULL('assigned_to')->whereHas('assetstatus', function ($query) { $query->where('deployable', '=', 1)->where('pending', '=', 0)->where('archived', '=', 0); }); }