/** * Query builder scope for pending assets * * @param Illuminate\Database\Query\Builder $query Query builder instance * * @return Illuminate\Database\Query\Builder Modified query builder */ public function scopeAssetsByLocation($query, $location) { return $query->where(function ($query) use($location) { $query->whereHas('assigneduser', function ($query) use($location) { $query->where('users.location_id', '=', $location->id); })->orWhere(function ($query) use($location) { $query->where('assets.rtd_location_id', '=', $location->id); $query->whereNull('assets.assigned_to'); }); }); }
/** * Querie all not completed projects * * @param Illuminate\Database\Query\Builder $query * * @return Illuminate\Database\Query\Builder */ public function scopeOpen($query) { return $query->whereNull('completed_at'); }