Class: LesliAudit::UserService

Inherits:
Lesli::ApplicationLesliService
  • Object
show all
Defined in:
app/services/lesli_audit/user_service.rb

Instance Method Summary collapse

Instance Method Details

#registrations ⇒ Object 



173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
 
# File 'app/services/lesli_audit/user_service.rb', line 173

def registrations

    #Get filters from the request     
    group = query[:group]
    group = "month"

    #Get period only if the request have filters
    period = group unless group.blank?

    group_by = "DATE_TRUNC('month', created_at)" if group == 'month'
    group_by = "DATE_TRUNC('week', created_at)" if group == 'week'
    group_by = "DATE_TRUNC('day', created_at)" if group == 'day'

    # compatibility for SQLite
    if ActiveRecord::Base.connection.adapter_name == "SQLite"
        group_by = "strftime('%Y-%m', created_at)"
    end

    registrations = []

    if ["day", "week", "month", "year"].include?(period)

        registrations = current_user..users
        .group(group_by)
        .count.map do |request|
            {
                :xaxiskey => request[0],
                :yaxiskey => request[1]
            }
        end
    end

    registrations
end

#users ⇒ Object 



36
37
38
39
40
41
42
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
85
86
87
88
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
122
123
124
125
126
127
128
129
130
131
132
133
134
 
# File 'app/services/lesli_audit/user_service.rb', line 36

def users
    users = current_user..users

    now = Time.current
    last_30_days = 30.days.ago

    stats = users.pick(
        # total users 
        Arel.sql("COUNT(*)"),

        # total deactivated users 
        Arel.sql("SUM(CASE WHEN active = 0 AND deleted_at IS NULL THEN 1 ELSE 0 END)"),

        # total locked users 
        Arel.sql(
            "SUM(CASE WHEN (
                locked_at IS NOT NULL
                OR locked_until > #{ActiveRecord::Base.connection.quote(Time.current)}
            ) AND deleted_at IS NULL THEN 1 ELSE 0 END)"
        ),

        # total not confirmed users
        Arel.sql("SUM(CASE WHEN confirmed_at IS NULL AND deleted_at IS NULL THEN 1 ELSE 0 END)"),

        # total deleted users 
        Arel.sql("SUM(CASE WHEN deleted_at IS NOT NULL THEN 1 ELSE 0 END)"),

        # users that never signed in 
        Arel.sql("SUM(CASE WHEN last_sign_in_at IS NULL AND deleted_at IS NULL THEN 1 ELSE 0 END)"),

        # total active users for the last 30 days 
        Arel.sql("SUM(CASE WHEN last_sign_in_at >= #{ActiveRecord::Base.connection.quote(last_30_days)} AND deleted_at IS NULL THEN 1 ELSE 0 END)"),

        # users with failed logins
        Arel.sql("SUM(CASE WHEN failed_attempts > 0 AND deleted_at IS NULL THEN 1 ELSE 0 END)"),
    )

    summary = { 
        total_users: stats[0].to_i, 
        total_users_deactivated: stats[1].to_i, 
        total_users_locked: stats[2].to_i, 
        total_users_unconfirmed: stats[3].to_i, 
        total_users_deleted: stats[4].to_i,

        total_users_never_signed_in: stats[5].to_i, 
        total_users_active_last_30_days: stats[6].to_i, 
        total_users_with_failed_attempts: stats[7].to_i
    }

    {
        overview: [{
            label: "Total users",
            value: summary[:total_users],
            percentage: 100,
            color: "info"
        }, {
            label: "Deactivated users",
            value: summary[:total_users_deactivated],
            percentage: percentage(summary[:total_users_deactivated], summary[:total_users]),
            color: "warning"
        }, {
            label: "Locked users",
            value: summary[:total_users_locked],
            percentage: percentage(summary[:total_users_locked], summary[:total_users]),
            color: "danger"
        }, {
            label: "Unconfirmed users",
            value: summary[:total_users_unconfirmed],
            percentage: percentage(summary[:total_users_unconfirmed], summary[:total_users]),
            color: "warning",
        }, {
            label: "Deleted users",
            value: summary[:total_users_deleted],
            percentage: percentage(summary[:total_users_deleted], summary[:total_users]),
            color: "danger"
        }],
        attention_needed: [{
            label: "Unconfirmed users",
            value: summary[:total_users_unconfirmed],
            color: "info",
            icon: "user-add-line"
        }, {
            label: "Never signed in",
            value: summary[:total_users_never_signed_in],
            color: "warning",
            icon: "time-line"
        }, {
            label: "Failed login attempts",
            value: summary[:total_users_with_failed_attempts],
            color: "danger",
            icon: "shield-keyhole-line"
        }, {
            label: "Locked users",
            value: summary[:total_users_locked],
            color: "danger",
            icon: "lock-line"
        }]
    }
end

#working_hours ⇒ Object 



136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
 
# File 'app/services/lesli_audit/user_service.rb', line 136

def working_hours

    group = 'day' 

    group_by = "DATE_TRUNC('month', lesli_audit_user_requests.date)" if group == 'month'
    group_by = "DATE_TRUNC('week', lesli_audit_user_requests.date)" if group == 'week'
    group_by = "DATE_TRUNC('day', lesli_audit_user_requests.date)" if group == 'day'

    # compatibility for SQLite
    if ActiveRecord::Base.connection.adapter_name == "SQLite"
        group_by = "strftime('%Y-%m-%d', lesli_audit_user_requests.date)"
    end

    user_requests = current_user..users.joins(:requests)

    user_requests = user_requests.select(
        :id,
        "lesli_users.id as user_id",
        "lesli_users.email as user_email",
        "#{group_by} date",
        "min(lesli_audit_user_requests.created_at) as first_activity", 
        "max(lesli_audit_user_requests.updated_at) as last_activity",
        "count(lesli_audit_user_requests.id) resources", 
        "sum(lesli_audit_user_requests.request_count) requests"
    )
   
    user_requests = user_requests.group(:user_id, group_by)

    user_requests.map do |request|
        request[:first_activity] = Date2.new(request[:first_activity]).time
        request[:last_activity] = Date2.new(request[:last_activity]).time
        request
    end
    
    user_requests.reverse
end