48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# File 'app/models/lesli/role/action.rb', line 48
def self.index current_user, query, role
Descriptor
.joins(:privileges)
.left_joins(:role_descriptors)
.joins(%(
inner join system_controller_actions
on system_controller_actions.id = descriptor_privileges.system_controller_action_id
)).joins(%(
inner join system_controllers
on system_controllers.id = system_controller_actions.system_controller_id
))
.select(
"coalesce(role_descriptors.descriptor_id, descriptors.id) as id",
"descriptors.name as name",
"system_controllers.reference as reference",
"system_controllers.route as controller",
"system_controller_actions.name as action",
"system_controllers.engine as engine",
"case when role_descriptors.descriptor_id is null then false else true end as active"
)
end
|