public function scopeRankable($query) { return $query->qualified()->where('approved_date', '>', DB::raw('date_sub(now(), interval 30 day)'))->get(); }