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