1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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
|
class WorkbenchesController < ChouetteController
before_action :query_params, only: [:show]
include RansackDateFilter
before_action only: [:show] { set_date_time_params("validity_period", Date) }
defaults resource_class: Workbench
include PolicyChecker
respond_to :html, except: :destroy
def index
redirect_to dashboard_path
end
def show
scope = resource.all_referentials
scope = ransack_associated_lines(scope)
scope = self.ransack_period_range(scope: scope, error_message: t('referentials.errors.validity_period'), query: :in_periode)
scope = ransack_status(scope)
@q_for_form = scope.ransack(params[:q])
@q_for_result = scope.ransack(ransack_params)
@wbench_refs = sort_result(@q_for_result.result).paginate(page: params[:page], per_page: 30)
@wbench_refs = ReferentialDecorator.decorate(
@wbench_refs,
context: {
current_workbench_id: params[:id]
}
)
end
def delete_referentials
referentials = resource.referentials.where(id: params[:referentials])
referentials.each do |referential|
ReferentialDestroyWorker.perform_async(referential.id)
referential.update_attribute(:ready, false)
end
flash[:notice] = t('notice.referentials.deleted')
redirect_to resource
end
private
def workbench_params
params.require(:workbench).permit(compliance_control_set_ids: @workbench.workgroup.compliance_control_sets_by_workbench.keys)
end
def resource
@workbench = current_organisation.workbenches.find params[:id]
end
def sort_result collection
col = (Referential.column_names + %w{lines validity_period}).include?(params[:sort]) ? params[:sort] : 'name'
dir = %w[asc desc].include?(params[:direction]) ? params[:direction] : 'asc'
if ['lines', 'validity_period'].include?(col)
collection.send("order_by_#{col}", dir)
else
collection.order("#{col} #{dir}")
end
end
def query_params
params[:q] ||= {}
params[:q].delete_if { |query, value| value.blank? }
end
# Fake ransack filter
def ransack_associated_lines scope
if params[:q]['associated_lines_id_eq']
scope = scope.include_metadatas_lines([params[:q]['associated_lines_id_eq']])
end
scope
end
# Fake ransack filter
def ransack_status scope
sql = scope.to_sql
filters = []
(params[:q] && params[:q][:state] || {}).each do |k, v|
if v == "1"
# We get the specific part of the SQL QUERY
# It looks a bit weird, bu this way we don't have to duplicate the
# logic of the scopes
filter_sql = scope.send(k).to_sql
j = 0
while filter_sql[j] == sql[j]
j += 1
end
i = j
while filter_sql[j] != sql[i]
j += 1
end
filter_sql = filter_sql[i..j]
filter_sql = filter_sql.strip
filter_sql = filter_sql.gsub /^AND\s*/i, ''
filters << filter_sql
end
end
# archived = !params[:q]['archived_at_not_null'].to_i.zero?
# unarchived = !params[:q]['archived_at_null'].to_i.zero?
#
# # Both status checked, means no filter
# return scope unless archived || unarchived
# return scope if archived && unarchived
#
# scope = scope.where(archived_at: nil) if unarchived
# scope = scope.where("archived_at is not null") if archived
scope.where filters.map{|f| "(#{f})"}.join('OR')
end
# Ignore archived_at_not_null/archived_at_null managed by ransack_status scope
# We clone params[:q] so we can delete fake ransack filter arguments before calling search method,
# which will allow us to preserve params[:q] for sorting
def ransack_params
copy_params = params[:q].clone
copy_params.delete('associated_lines_id_eq')
copy_params.delete('archived_at_not_null')
copy_params.delete('archived_at_null')
copy_params
end
end
|
