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