liquid_feedback_frontend
view app/main/event/_list.lua @ 509:d97be0729c53
Fixed order of initiatives in event listing
| author | bsw |
|---|---|
| date | Sun Mar 25 23:23:20 2012 +0200 (2012-03-25) |
| parents | 1b147b265547 |
| children | 63d6549cc00b |
line source
1 local global = param.get("global", atom.boolean)
2 local for_member = param.get("for_member", "table")
3 local for_unit = param.get("for_unit", "table")
4 local for_area = param.get("for_area", "table")
5 local event_max_id = param.get_all_cgi()["event_max_id"]
6 local event_selector = Event:new_selector()
7 :add_order_by("event.id DESC")
8 :limit(25)
9 :join("issue", nil, "issue.id = event.issue_id")
10 :add_field("now()::date - event.occurrence::date", "time_ago")
12 if event_max_id then
13 event_selector:add_where{ "event.id < ?", event_max_id }
14 end
16 if for_member then
17 event_selector:add_where{ "event.member_id = ?", for_member.id }
18 elseif for_unit then
19 event_selector:join("area", nil, "area.id = issue.area_id")
20 event_selector:add_where{ "area.unit_id = ?", for_unit.id }
21 elseif for_area then
22 event_selector:add_where{ "issue.area_id = ?", for_area.id }
23 elseif not global then
24 event_selector:join("event_seen_by_member", nil, { "event_seen_by_member.id = event.id AND event_seen_by_member.seen_by_member_id = ?", app.session.member_id })
25 end
27 if app.session.member_id then
28 event_selector
29 :left_join("interest", "_interest", { "_interest.issue_id = issue.id AND _interest.member_id = ?", app.session.member.id } )
30 :add_field("(_interest.member_id NOTNULL)", "is_interested")
31 :left_join("delegating_interest_snapshot", "_delegating_interest", { "_delegating_interest.issue_id = issue.id AND _delegating_interest.member_id = ? AND _delegating_interest.event = issue.latest_snapshot_event", app.session.member.id } )
32 :add_field("_delegating_interest.delegate_member_ids[1]", "is_interested_by_delegation_to_member_id")
33 :add_field("_delegating_interest.delegate_member_ids[array_upper(_delegating_interest.delegate_member_ids, 1)]", "is_interested_via_member_id")
34 :add_field("array_length(_delegating_interest.delegate_member_ids, 1)", "delegation_chain_length")
35 end
37 local last_event_id
39 ui.container{ attr = { class = "issues events" }, content = function()
41 local last_event_date
42 for i, event in ipairs(event_selector:exec()) do
43 last_event_id = event.id
45 if event.occurrence.date ~= last_event_date then
46 local days_ago_text
47 if event.time_ago == 0 then
48 days_ago_text = _"Today"
49 elseif event.time_ago == 1 then
50 days_ago_text = _"Yesterday"
51 else
52 days_ago_text = _("#{count} days ago", { count = event.time_ago })
53 end
54 ui.container{ attr = { class = "date" }, content = function()
55 ui.tag{ content = format.date(event.occurrence.date) }
56 slot.put(" · ")
57 ui.tag{ content = days_ago_text }
58 end }
60 last_event_date = event.occurrence.date
61 end
62 local class = "issue"
63 if event.is_interested then
64 class = class .. " interested"
65 elseif event.is_interested_by_delegation_to_member_id then
66 class = class .. " interested_by_delegation"
67 end
68 ui.container{ attr = { class = class }, content = function()
70 ui.container { attr = { class = "issue_info" }, content = function()
72 if event.is_interested then
73 ui.tag{
74 tag = "div", attr = { class = "interest_by_delegation"},
75 content = function()
76 local text = "You are interested in this issue"
77 ui.image{ attr = { alt = text, title = text }, static = "icons/16/eye.png" }
78 end
79 }
81 elseif event.is_interested_by_delegation_to_member_id then
82 ui.tag{
83 tag = "div", attr = { class = "interest_by_delegation"},
84 content = function()
85 local member = Member:by_id(event.is_interested_by_delegation_to_member_id)
86 local text = _"delegated to"
87 ui.image{
88 attr = { class = "delegation_arrow", alt = text, title = text },
89 static = "delegation_arrow_24_horizontal.png"
90 }
91 execute.view{
92 module = "member_image",
93 view = "_show",
94 params = {
95 member = member,
96 image_type = "avatar",
97 show_dummy = true,
98 class = "micro_avatar",
99 popup_text = member.name
100 }
101 }
102 if event.is_interested_by_delegation_to_member_id ~= event.is_interested_via_member_id then
103 if event.delegation_chain_length > 2 then
104 local text = _"delegated to"
105 ui.image{
106 attr = { class = "delegation_arrow", alt = text, title = text },
107 static = "delegation_arrow_24_horizontal.png"
108 }
109 ui.tag{ content = "..." }
110 end
111 local text = _"delegated to"
112 ui.image{
113 attr = { class = "delegation_arrow", alt = text, title = text },
114 static = "delegation_arrow_24_horizontal.png"
115 }
116 local member = Member:by_id(event.is_interested_via_member_id)
117 execute.view{
118 module = "member_image",
119 view = "_show",
120 params = {
121 member = member,
122 image_type = "avatar",
123 show_dummy = true,
124 class = "micro_avatar",
125 popup_text = member.name
126 }
127 }
128 end
129 end
130 }
131 end
133 ui.container{ content = function()
134 ui.link{
135 attr = { class = "issue_id" },
136 text = _("Issue ##{id}", { id = tostring(event.issue_id) }),
137 module = "issue",
138 view = "show",
139 id = event.issue_id
140 }
142 slot.put(" · ")
143 ui.tag{ content = event.issue.policy.name }
144 slot.put(" · ")
145 ui.tag{ content = event.issue.area.name }
146 slot.put(" · ")
147 ui.tag{ content = event.issue.area.unit.name }
148 end }
150 ui.container{ attr = { class = "issue_policy_info" }, content = function()
151 if (app.session.member_id or config.public_access == "pseudonym") and event.member_id then
152 if app.session.member_id then
153 ui.link{
154 content = function()
155 execute.view{
156 module = "member_image",
157 view = "_show",
158 params = {
159 member = event.member,
160 image_type = "avatar",
161 show_dummy = true,
162 class = "micro_avatar",
163 popup_text = text
164 }
165 }
166 end,
167 module = "member", view = "show", id = event.member_id
168 }
169 slot.put(" ")
170 end
171 ui.link{
172 text = event.member.name,
173 module = "member", view = "show", id = event.member_id
174 }
175 slot.put(" · ")
176 end
177 local event_name = event.event_name
178 local event_image
179 if event.event == "issue_state_changed" then
180 if event.state == "discussion" then
181 event_name = _"Discussion started"
182 event_image = "comments.png"
183 elseif event.state == "verification" then
184 event_name = _"Verification started"
185 event_image = "lock.png"
186 elseif event.state == "voting" then
187 event_name = _"Voting started"
188 event_image = "email_open.png"
189 else
190 event_name = event.state_name
191 end
192 if event_image then
193 ui.image{ static = "icons/16/" .. event_image }
194 slot.put(" ")
195 end
196 end
197 ui.tag{ attr = { class = "event_name" }, content = event_name }
198 slot.put(" · ")
199 ui.tag{ attr = { class = "time" }, content = format.time(event.occurrence) }
200 end }
202 end }
204 if event.suggestion_id then
205 ui.container{ attr = { class = "suggestion" }, content = function()
206 ui.link{
207 text = event.suggestion.name,
208 module = "suggestion", view = "show", id = event.suggestion_id
209 }
210 end }
211 end
213 ui.container{ attr = { class = "initiative_list" }, content = function()
214 if not event.initiative_id then
215 local initiatives_selector = Initiative:new_selector()
216 :add_where{ "initiative.issue_id = ?", event.issue_id }
217 :add_order_by("initiative.rank, initiative.supporter_count DESC")
218 execute.view{ module = "initiative", view = "_list", params = {
219 issue = event.issue,
220 initiatives_selector = initiatives_selector,
221 no_sort = true,
222 limit = 3
223 } }
224 else
225 local initiatives_selector = Initiative:new_selector()
226 :add_where{ "initiative.id = ?", event.initiative_id }
227 execute.view{ module = "initiative", view = "_list", params = {
228 issue = event.issue,
229 initiatives_selector = initiatives_selector,
230 no_sort = true,
231 limit = 1
232 } }
233 end
234 end }
236 --[[
237 if event.initiative_id then
238 ui.container{ attr = { class = "initiative_id" }, content = event.initiative_id }
239 end
240 if event.draft_id then
241 ui.container{ attr = { class = "draft_id" }, content = event.draft_id }
242 end
243 if event.suggestion_id then
244 ui.container{ attr = { class = "suggestion_id" }, content = event.suggestion_id }
245 end
246 --]]
248 end }
249 end
251 end }
253 ui.link{
254 text = _"Show older events",
255 module = request.get_module(),
256 view = request.get_view(),
257 id = param.get_id(),
258 params = {
259 tab = param.get_all_cgi()["tab"],
260 events = param.get_all_cgi()["events"],
261 event_max_id = last_event_id
262 }
263 }
266 slot.put("<br />")
267 slot.put("<br />")