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