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
|
# File 'app/services/lesli_help/ticket_service.rb', line 40
def index
return current_user.account.help.tickets.left_joins(
:user, :creator
).select(
:id,
:subject,
:deadline,
:creator_id,
:user_id,
"CONCAT_WS(' ', lesli_users.first_name, lesli_users.last_name) as user_name",
"CONCAT_WS(' ', creators_lesli_help_tickets.first_name, creators_lesli_help_tickets.last_name) as creator_name",
"lesli_help_tickets.updated_at",
"lesli_help_tickets.created_at"
).order(id: :desc)
.page(query[:pagination][:page])
.per(query[:pagination][:perPage])
current_user.account.help.tickets.left_joins(
:priority,
:type,
:workspace,
:category,
:status,
:assignments,
:assigned,
:user
).select(
:id,
:subject,
:deadline,
:assigned_id,
:user_id,
"CONCAT_WS(' ', users.first_name, users.last_name) as assigned_name",
"CONCAT_WS(' ', users_cloud_help_tickets.first_name, users_cloud_help_tickets.last_name) as user_name",
"cloud_help_tickets.updated_at",
"cloud_help_tickets.created_at"
)
end
|