Rails 5 helpers to fetch tasks with different filters

Question

I moved a lot of the loading/logic from my view to my controller, and it's working great but after I did this I now have several very similar helper methods in my controller.

What is a more efficient way of doing this? Is there? I assume get_last_task_owed and get_first_task_owed I would be able to do in the view by finding the .first and .last of the record respectively.

 def get_projects_owed
 current_user.projects.where('end_date > ?', Date.today).order(:start_date).pluck(:name, :start_date, :end_date)
 end
 def get_all_projects
 current_user.projects.order(:start_date).pluck(:name, :start_date, :end_date)
 end
 def get_all_tasks
 @project.tasks.order(:product, :task_start_date).pluck(:product, :task_name, :task_start_date, :task_end_date).to_json
 end
 def get_last_task_owed
 tasks = @project.tasks
 tasks.where('task_end_date >= ?', Date.today).order('task_end_date DESC').first.task_end_date.strftime("%B %d, %Y")
 end
 def get_first_task_owed
 tasks = @project.tasks
 tasks.where('task_end_date >= ?', Date.today).order('task_end_date ASC').first.task_end_date.strftime("%B %d, %Y")
 end
 helper_method :get_projects_owed
 helper_method :get_all_projects
 helper_method :get_clients_with_projects
 helper_method :get_all_tasks
 helper_method :get_last_task_owed
 helper_method :get_first_task_owed

Answer 1

One possible improvement is using scopes:

def get_projects_owed
 current_user.projects.owed.recent_first.pluck(:name, :start_date, :end_date)
end
def get_all_projects
 current_user.projects.recent_first.pluck(:name, :start_date, :end_date)
end
def get_last_task_owed
 get_owed_tasks.last.task_end_date.strftime("%B %d, %Y")
end
def get_first_task_owed
 get_owed_tasks.first.task_end_date.strftime("%B %d, %Y")
end
def get_owed_tasks
 tasks = @project.tasks
 tasks.owed.order('task_end_date DESC')
end
helper_method :get_owed_tasks
class Project
 scope :owed, -> { where('end_date > ?', Date.today) }
 scope :recent_first, -> { order(:start_date) }
end
class Task
 scope :owed, -> { where('task_end_date >= ?', Date.today) }
end