Skip to content

Instantly share code, notes, and snippets.

@donovan-duplessis
Created August 29, 2012 08:10
Show Gist options
  • Save donovan-duplessis/3508355 to your computer and use it in GitHub Desktop.
Save donovan-duplessis/3508355 to your computer and use it in GitHub Desktop.
Consultant Reports query within model
def self.reports(current_user)
select_fields = %w[
consultant_reports.id consultant_reports.week
teams.id teams.name admin_users.id admin_users.name
]
group_fields = %w[ teams.name admin_users.name consultant_reports.week ]
data = joins(:team, :admin_user).select(select_fields).group(group_fields)
current_user.has_role?(:consultant) ?
data.where('teams.admin_user_id = ?', current_user.id) : data
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment