Class: Lesli::UserService

Inherits:
ApplicationLesliService show all
Defined in:
app/services/lesli/user_service.rb

Instance Method Summary collapse

Methods inherited from ApplicationLesliService

#cache_key_for_account, #cache_key_for_user, #create, #delete, #error, #errors, #errors_as_sentence, #found?, #initialize, #result, #successful?

Constructor Details

This class inherits a constructor from Lesli::ApplicationLesliService

Instance Method Details

#find(id) ⇒ Object 



36
37
38
 
# File 'app/services/lesli/user_service.rb', line 36

def find id
    super(current_user..users.find_by(id: id))
end

#index(params) ⇒ Array

TODO: Implement pg_search

Returns:

  • (Array) —

    Paginated index of users.



89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
 
# File 'app/services/lesli/user_service.rb', line 89

def index params

    # Build user full name
    fullname_sql = "TRIM(CONCAT(lesli_users.first_name, ' ', lesli_users.last_name))"

    # Build user status
    status_sql = "case when lesli_users.active is true then 'active' else 'inactive' end"

    # Get all the roles assigned to the user
    roles_subquery = <<-SQL
        LEFT JOIN (
            SELECT ur.user_id, string_agg(r.name, ', ' ORDER BY r.name) as rolenames
            FROM lesli_shield_user_roles ur
            JOIN lesli_roles r ON r.id = ur.role_id
            WHERE ur.deleted_at IS NULL
            GROUP BY ur.user_id
        ) roles ON roles.user_id = lesli_users.id
    SQL

    current_user..users
    .joins(roles_subquery)
    .select(
        :id,
        :email,
        :active,
        "#{status_sql} AS status",
        "#{fullname_sql} AS fullname",
        "COALESCE(roles.rolenames, '') AS rolenames",
        Date2.new.date_time.db_column("current_sign_in_at")
    )
    .page(query.dig(:pagination, :page))
    .per(query.dig(:pagination, :perPage))
end

#list(params = nil) ⇒ Object

Return a list of users that belongs to the account of the current_user this list is meant to be used in selectors, autocomplets, etc



43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
 
# File 'app/services/lesli/user_service.rb', line 43

def list params=nil
    users = current_user..users

    if params[:role].present?
        # add simple quotes to the roles so the sql can manage the query
        roles = params[:role].split(",").map { |role| "'#{role}'" }.join(", ")
        # users = users.joins("
        #     inner join (
        #         select
        #             ur.users_id, string_agg(r.\"name\", ', ') role_names
        #         from user_roles ur
        #         join roles r
        #             on r.id = ur.role_id 
        #             and r.name in ( #{ roles } )
        #         where ur.deleted_at is null
        #         group by ur.users_id
        #     ) roles on roles.users_id = users.id
        # ")

        users = users.joins("
            inner join (
                select
                    ur.users_id, string_agg(r.\"name\", ', ') role_names
                from user_roles ur
                join roles r
                    on r.id = ur.role_id 
                    and r.name in (:roles)
                where ur.deleted_at is null
                group by ur.users_id
            ) roles on roles.users_id = users.id
        ")
        .where('r.name IN (:roles)', roles: roles)

    end

    users.order(name: :asc).select(
        :id,
        :email,
        "CONCAT_WS(' ', first_name, last_name) as name",
        "COALESCE(NULLIF(alias,''), email) as alias"
    ).as_json
end

#show ⇒ Object

Creates a query that selects all user information from several tables if CloudLock is present



124
125
126
 
# File 'app/services/lesli/user_service.rb', line 124

def show
    resource
end

#update(params) ⇒ Object 



128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
 
# File 'app/services/lesli/user_service.rb', line 128

def update params

    # old_attributes = resource.detail.attributes.merge({
    #     active: resource.active
    # })

    if resource.update(params)

        # Set the user alias based on the full_name.
        if resource.alias.empty?
            resource.update(alias: resource.full_name_initials())
        end

        # new_attributes = resource.detail.attributes.merge({
        #     active: resource.active
        # })
        #resource.log_activity_update(current_user, resource, old_attributes, new_attributes)
    else
        self.error(resource.errors.full_messages.to_sentence)
    end
    
    self
end