| rev |
line source |
|
bsw/jbe@0
|
1 Issue = mondelefant.new_class()
|
|
bsw/jbe@0
|
2 Issue.table = 'issue'
|
|
bsw/jbe@0
|
3
|
|
bsw@549
|
4 local new_selector = Issue.new_selector
|
|
bsw@549
|
5
|
|
bsw@549
|
6 function Issue:new_selector()
|
|
bsw@549
|
7 local selector = new_selector(self)
|
|
bsw@549
|
8 selector:add_field("coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now()", "state_time_left")
|
|
bsw@549
|
9 return selector
|
|
bsw@549
|
10 end
|
|
bsw@549
|
11
|
|
bsw/jbe@0
|
12 Issue:add_reference{
|
|
bsw/jbe@0
|
13 mode = 'm1',
|
|
bsw/jbe@0
|
14 to = "Area",
|
|
bsw/jbe@0
|
15 this_key = 'area_id',
|
|
bsw/jbe@0
|
16 that_key = 'id',
|
|
bsw/jbe@0
|
17 ref = 'area',
|
|
bsw/jbe@0
|
18 }
|
|
bsw/jbe@0
|
19
|
|
bsw/jbe@0
|
20 Issue:add_reference{
|
|
bsw/jbe@0
|
21 mode = 'm1',
|
|
bsw/jbe@0
|
22 to = "Policy",
|
|
bsw/jbe@0
|
23 this_key = 'policy_id',
|
|
bsw/jbe@0
|
24 that_key = 'id',
|
|
bsw/jbe@0
|
25 ref = 'policy',
|
|
bsw/jbe@0
|
26 }
|
|
bsw/jbe@0
|
27
|
|
bsw/jbe@0
|
28 Issue:add_reference{
|
|
bsw/jbe@0
|
29 mode = '1m',
|
|
bsw/jbe@0
|
30 to = "Initiative",
|
|
bsw/jbe@0
|
31 this_key = 'id',
|
|
bsw/jbe@0
|
32 that_key = 'issue_id',
|
|
bsw/jbe@0
|
33 ref = 'initiatives',
|
|
bsw/jbe@0
|
34 back_ref = 'issue'
|
|
bsw/jbe@0
|
35 }
|
|
bsw/jbe@0
|
36
|
|
bsw/jbe@0
|
37 Issue:add_reference{
|
|
bsw/jbe@0
|
38 mode = '1m',
|
|
bsw/jbe@0
|
39 to = "Interest",
|
|
bsw/jbe@0
|
40 this_key = 'id',
|
|
bsw/jbe@0
|
41 that_key = 'issue_id',
|
|
bsw/jbe@0
|
42 ref = 'interests',
|
|
bsw/jbe@0
|
43 back_ref = 'issue',
|
|
bsw/jbe@0
|
44 default_order = '"id"'
|
|
bsw/jbe@0
|
45 }
|
|
bsw/jbe@0
|
46
|
|
bsw/jbe@0
|
47 Issue:add_reference{
|
|
bsw/jbe@0
|
48 mode = '1m',
|
|
bsw/jbe@0
|
49 to = "Supporter",
|
|
bsw/jbe@0
|
50 this_key = 'id',
|
|
bsw/jbe@0
|
51 that_key = 'issue_id',
|
|
bsw/jbe@0
|
52 ref = 'supporters',
|
|
bsw/jbe@0
|
53 back_ref = 'issue',
|
|
bsw/jbe@0
|
54 default_order = '"id"'
|
|
bsw/jbe@0
|
55 }
|
|
bsw/jbe@0
|
56
|
|
bsw/jbe@0
|
57 Issue:add_reference{
|
|
bsw/jbe@0
|
58 mode = '1m',
|
|
bsw/jbe@0
|
59 to = "DirectVoter",
|
|
bsw/jbe@0
|
60 this_key = 'id',
|
|
bsw/jbe@0
|
61 that_key = 'issue_id',
|
|
bsw/jbe@0
|
62 ref = 'direct_voters',
|
|
bsw/jbe@0
|
63 back_ref = 'issue',
|
|
bsw/jbe@0
|
64 default_order = '"member_id"'
|
|
bsw/jbe@0
|
65 }
|
|
bsw/jbe@0
|
66
|
|
bsw/jbe@0
|
67 Issue:add_reference{
|
|
bsw/jbe@0
|
68 mode = '1m',
|
|
bsw/jbe@0
|
69 to = "Vote",
|
|
bsw/jbe@0
|
70 this_key = 'id',
|
|
bsw/jbe@0
|
71 that_key = 'issue_id',
|
|
bsw/jbe@0
|
72 ref = 'votes',
|
|
bsw/jbe@0
|
73 back_ref = 'issue',
|
|
bsw/jbe@0
|
74 default_order = '"member_id", "initiative_id"'
|
|
bsw/jbe@0
|
75 }
|
|
bsw/jbe@0
|
76
|
|
bsw/jbe@0
|
77 Issue:add_reference{
|
|
bsw@2
|
78 mode = '1m',
|
|
bsw@2
|
79 to = "Delegation",
|
|
bsw@2
|
80 this_key = 'id',
|
|
bsw@2
|
81 that_key = 'issue_id',
|
|
bsw@2
|
82 ref = 'delegations',
|
|
bsw@2
|
83 back_ref = 'issue'
|
|
bsw@2
|
84 }
|
|
bsw@2
|
85
|
|
bsw@2
|
86 Issue:add_reference{
|
|
bsw/jbe@0
|
87 mode = 'mm',
|
|
bsw/jbe@0
|
88 to = "Member",
|
|
bsw/jbe@0
|
89 this_key = 'id',
|
|
bsw/jbe@0
|
90 that_key = 'id',
|
|
bsw/jbe@0
|
91 connected_by_table = 'interest',
|
|
bsw/jbe@0
|
92 connected_by_this_key = 'issue_id',
|
|
bsw/jbe@0
|
93 connected_by_that_key = 'member_id',
|
|
bsw/jbe@0
|
94 ref = 'members'
|
|
bsw/jbe@0
|
95 }
|
|
bsw/jbe@0
|
96
|
|
bsw@3
|
97 Issue:add_reference{
|
|
bsw@3
|
98 mode = 'mm',
|
|
bsw@3
|
99 to = "Member",
|
|
bsw@3
|
100 this_key = 'id',
|
|
bsw@3
|
101 that_key = 'id',
|
|
bsw@3
|
102 connected_by_table = 'direct_interest_snapshot',
|
|
bsw@3
|
103 connected_by_this_key = 'issue_id',
|
|
bsw@3
|
104 connected_by_that_key = 'member_id',
|
|
bsw@3
|
105 ref = 'interested_members_snapshot'
|
|
bsw@3
|
106 }
|
|
bsw@3
|
107
|
|
bsw/jbe@6
|
108 Issue:add_reference{
|
|
bsw/jbe@6
|
109 mode = 'mm',
|
|
bsw/jbe@6
|
110 to = "Member",
|
|
bsw/jbe@6
|
111 this_key = 'id',
|
|
bsw/jbe@6
|
112 that_key = 'id',
|
|
bsw/jbe@6
|
113 connected_by_table = 'direct_voter',
|
|
bsw/jbe@6
|
114 connected_by_this_key = 'issue_id',
|
|
bsw/jbe@6
|
115 connected_by_that_key = 'member_id',
|
|
bsw/jbe@6
|
116 ref = 'direct_voters'
|
|
bsw/jbe@6
|
117 }
|
|
bsw/jbe@6
|
118
|
|
bsw@525
|
119 Issue:add_reference{
|
|
bsw@525
|
120 mode = "11",
|
|
bsw@525
|
121 to = mondelefant.class_prototype,
|
|
bsw@525
|
122 this_key = "id",
|
|
bsw@525
|
123 that_key = "issue_id",
|
|
bsw@547
|
124 ref = "member_info",
|
|
bsw@525
|
125 back_ref = "issue",
|
|
bsw@525
|
126 selector_generator = function(list, options)
|
|
bsw@547
|
127 assert(options.member_id, "member_id mandatory for member_info")
|
|
bsw@525
|
128 local ids = { sep = ", " }
|
|
bsw@525
|
129 for i, object in ipairs(list) do
|
|
bsw@525
|
130 local id = object.id
|
|
bsw@525
|
131 if id ~= nil then
|
|
bsw@525
|
132 ids[#ids+1] = {"?", id}
|
|
bsw@525
|
133 end
|
|
bsw@525
|
134 end
|
|
bsw@525
|
135 local sub_selector = Issue:get_db_conn():new_selector()
|
|
bsw@525
|
136 if #ids == 0 then
|
|
bsw@525
|
137 return sub_selector:empty_list_mode()
|
|
bsw@525
|
138 end
|
|
bsw@525
|
139 sub_selector:from("issue")
|
|
bsw@525
|
140 sub_selector:add_field("issue.id", "issue_id")
|
|
bsw@529
|
141 sub_selector:add_field{ '(delegation_info(?, null, null, issue.id, ?)).*', options.member_id, options.trustee_id }
|
|
bsw@525
|
142 sub_selector:add_where{ 'issue.id IN ($)', ids }
|
|
bsw@525
|
143
|
|
bsw@525
|
144 local selector = Issue:get_db_conn():new_selector()
|
|
bsw@547
|
145 selector:add_from("issue")
|
|
bsw@547
|
146 selector:join(sub_selector, "delegation_info", "delegation_info.issue_id = issue.id")
|
|
bsw@525
|
147 selector:left_join("member", "first_trustee", "first_trustee.id = delegation_info.first_trustee_id")
|
|
bsw@525
|
148 selector:left_join("member", "other_trustee", "other_trustee.id = delegation_info.other_trustee_id")
|
|
bsw@525
|
149 selector:add_field("delegation_info.*")
|
|
bsw@525
|
150 selector:add_field("first_trustee.name", "first_trustee_name")
|
|
bsw@525
|
151 selector:add_field("other_trustee.name", "other_trustee_name")
|
|
bsw@547
|
152 selector:left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", options.member_id })
|
|
bsw@547
|
153 selector:add_field("direct_voter.member_id NOTNULL", "direct_voted")
|
|
bsw@525
|
154 return selector
|
|
bsw@525
|
155 end
|
|
bsw@525
|
156 }
|
|
bsw@525
|
157
|
|
bsw@547
|
158 function Issue.list:load_everything_for_member_id(member_id)
|
|
bsw@547
|
159 local areas = self:load("area")
|
|
bsw@547
|
160 areas:load("unit")
|
|
bsw@547
|
161 self:load("policy")
|
|
bsw@547
|
162 self:load("member_info", { member_id = member_id })
|
|
bsw@525
|
163 end
|
|
bsw@525
|
164
|
|
bsw@548
|
165 function Issue.object:load_everything_for_member_id(member_id)
|
|
bsw@548
|
166 local areas = self:load("area")
|
|
bsw@548
|
167 areas:load("unit")
|
|
bsw@548
|
168 self:load("policy")
|
|
bsw@548
|
169 self:load("member_info", { member_id = member_id })
|
|
bsw@548
|
170 end
|
|
bsw@548
|
171
|
|
bsw/jbe@0
|
172 function Issue:get_state_name_for_state(value)
|
|
bsw@2
|
173 local state_name_table = {
|
|
bsw@2
|
174 new = _"New",
|
|
bsw@3
|
175 accepted = _"Discussion",
|
|
bsw@2
|
176 frozen = _"Frozen",
|
|
bsw@2
|
177 voting = _"Voting",
|
|
bsw@2
|
178 finished = _"Finished",
|
|
bsw@2
|
179 cancelled = _"Cancelled"
|
|
bsw@2
|
180 }
|
|
bsw@10
|
181 return state_name_table[value] or value or ''
|
|
bsw/jbe@0
|
182 end
|
|
bsw/jbe@0
|
183
|
|
bsw@2
|
184 function Issue:get_search_selector(search_string)
|
|
bsw/jbe@0
|
185 return self:new_selector()
|
|
bsw/jbe@0
|
186 :join('"initiative"', nil, '"initiative"."issue_id" = "issue"."id"')
|
|
bsw/jbe@6
|
187 :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"')
|
|
bsw/jbe@6
|
188 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string }
|
|
bsw/jbe@6
|
189 :add_group_by('"issue"."id"')
|
|
bsw@481
|
190 :add_group_by('"issue"."state"')
|
|
bsw/jbe@6
|
191 :add_group_by('"issue"."area_id"')
|
|
bsw/jbe@6
|
192 :add_group_by('"issue"."policy_id"')
|
|
bsw/jbe@6
|
193 :add_group_by('"issue"."created"')
|
|
bsw/jbe@6
|
194 :add_group_by('"issue"."accepted"')
|
|
bsw/jbe@6
|
195 :add_group_by('"issue"."half_frozen"')
|
|
bsw/jbe@6
|
196 :add_group_by('"issue"."fully_frozen"')
|
|
bsw/jbe@6
|
197 :add_group_by('"issue"."closed"')
|
|
bsw/jbe@6
|
198 :add_group_by('"issue"."ranks_available"')
|
|
bsw@483
|
199 :add_group_by('"issue"."status_quo_schulze_rank"')
|
|
poelzi@140
|
200 :add_group_by('"issue"."cleaned"')
|
|
bsw/jbe@6
|
201 :add_group_by('"issue"."snapshot"')
|
|
bsw/jbe@6
|
202 :add_group_by('"issue"."latest_snapshot_event"')
|
|
bsw/jbe@6
|
203 :add_group_by('"issue"."population"')
|
|
bsw/jbe@6
|
204 :add_group_by('"issue"."voter_count"')
|
|
bsw@75
|
205 :add_group_by('"issue"."admission_time"')
|
|
bsw@75
|
206 :add_group_by('"issue"."discussion_time"')
|
|
bsw@75
|
207 :add_group_by('"issue"."verification_time"')
|
|
bsw@75
|
208 :add_group_by('"issue"."voting_time"')
|
|
bsw/jbe@19
|
209 :add_group_by('"_interest"."member_id"')
|
|
bsw@480
|
210 :add_group_by("_delegating_interest.delegate_member_ids")
|
|
bsw/jbe@6
|
211 --:set_distinct()
|
|
bsw/jbe@0
|
212 end
|
|
bsw/jbe@0
|
213
|
|
bsw@75
|
214 function Issue:modify_selector_for_state(initiatives_selector, state)
|
|
bsw@51
|
215 if state == "new" then
|
|
bsw@75
|
216 initiatives_selector:add_where("issue.accepted ISNULL AND issue.closed ISNULL")
|
|
bsw@51
|
217 elseif state == "accepted" then
|
|
bsw@75
|
218 initiatives_selector:add_where("issue.accepted NOTNULL AND issue.half_frozen ISNULL AND issue.closed ISNULL")
|
|
bsw@51
|
219 elseif state == "frozen" then
|
|
bsw@75
|
220 initiatives_selector:add_where("issue.half_frozen NOTNULL AND issue.fully_frozen ISNULL AND issue.closed ISNULL")
|
|
bsw@51
|
221 elseif state == "voting" then
|
|
bsw@75
|
222 initiatives_selector:add_where("issue.fully_frozen NOTNULL AND issue.closed ISNULL")
|
|
bsw@51
|
223 elseif state == "finished" then
|
|
bsw@75
|
224 initiatives_selector:add_where("issue.fully_frozen NOTNULL AND issue.closed NOTNULL")
|
|
bsw@51
|
225 elseif state == "cancelled" then
|
|
bsw@75
|
226 initiatives_selector:add_where("issue.fully_frozen ISNULL AND issue.closed NOTNULL")
|
|
bsw@75
|
227 else
|
|
bsw@75
|
228 error("Invalid state")
|
|
bsw@51
|
229 end
|
|
bsw@51
|
230 end
|
|
bsw@51
|
231
|
|
bsw/jbe@0
|
232 function Issue.object_get:state()
|
|
bsw/jbe@52
|
233 if self.closed then
|
|
bsw/jbe@52
|
234 if self.fully_frozen then
|
|
bsw/jbe@5
|
235 return "finished"
|
|
bsw/jbe@0
|
236 else
|
|
bsw/jbe@52
|
237 return "cancelled"
|
|
bsw/jbe@0
|
238 end
|
|
bsw/jbe@52
|
239 elseif self.fully_frozen then
|
|
bsw/jbe@52
|
240 return "voting"
|
|
bsw/jbe@52
|
241 elseif self.half_frozen then
|
|
bsw/jbe@52
|
242 return "frozen"
|
|
bsw/jbe@52
|
243 elseif self.accepted then
|
|
bsw/jbe@52
|
244 return "accepted"
|
|
bsw/jbe@0
|
245 else
|
|
bsw/jbe@52
|
246 return "new"
|
|
bsw/jbe@0
|
247 end
|
|
bsw/jbe@52
|
248
|
|
bsw@2
|
249 end
|
|
bsw@2
|
250
|
|
bsw@2
|
251 function Issue.object_get:state_name()
|
|
bsw@2
|
252 return Issue:get_state_name_for_state(self.state)
|
|
bsw@2
|
253 end
|
|
bsw@2
|
254
|
|
bsw@2
|
255 function Issue.object_get:next_states()
|
|
bsw@2
|
256 local state = self.state
|
|
bsw@2
|
257 local next_states
|
|
bsw@2
|
258 if state == "new" then
|
|
bsw@2
|
259 next_states = { "accepted", "cancelled" }
|
|
bsw@2
|
260 elseif state == "accepted" then
|
|
bsw@2
|
261 next_states = { "frozen" }
|
|
bsw@2
|
262 elseif state == "frozen" then
|
|
bsw@2
|
263 next_states = { "voting" }
|
|
bsw@2
|
264 elseif state == "voting" then
|
|
bsw@2
|
265 next_states = { "finished" }
|
|
bsw@2
|
266 end
|
|
bsw@2
|
267 return next_states
|
|
bsw@2
|
268 end
|
|
bsw@2
|
269
|
|
bsw@2
|
270 function Issue.object_get:next_states_names()
|
|
bsw@2
|
271 local next_states = self.next_states
|
|
bsw@2
|
272 if not next_states then
|
|
bsw@2
|
273 return
|
|
bsw@2
|
274 end
|
|
bsw@2
|
275 local state_names = {}
|
|
bsw@2
|
276 for i, state in ipairs(self.next_states) do
|
|
bsw@2
|
277 state_names[#state_names+1] = Issue:get_state_name_for_state(state)
|
|
bsw@2
|
278 end
|
|
bsw@2
|
279 return table.concat(state_names, ", ")
|
|
bsw@525
|
280 end
|
|
bsw@525
|
281
|
|
bsw@525
|
282 function Issue.object_get:etherpad_url()
|
|
bsw@525
|
283 return config.etherpad.base_url .. "p/" .. config.etherpad.group_id .. "$Issue" .. self.id
|
|
bsw/jbe@0
|
284 end |