liquid_feedback_frontend

annotate app/main/event/_list.lua @ 712:0daedb7c1c11

find changesets by author, revision, files, or words in the commit message
Improved preloading of data for event list
author bsw
date Wed Jun 27 00:24:32 2012 +0200 (2012-06-27)
parents fe76cc06e6cf
children 344e5fdce8c9
rev   line source
bsw@414 1 local global = param.get("global", atom.boolean)
bsw@414 2 local for_member = param.get("for_member", "table")
bsw@414 3 local for_unit = param.get("for_unit", "table")
bsw@414 4 local for_area = param.get("for_area", "table")
bsw@422 5 local event_max_id = param.get_all_cgi()["event_max_id"]
bsw@414 6 local event_selector = Event:new_selector()
bsw@414 7 :add_order_by("event.id DESC")
bsw@414 8 :limit(25)
bsw@414 9 :join("issue", nil, "issue.id = event.issue_id")
bsw@437 10 :add_field("now()::date - event.occurrence::date", "time_ago")
bsw@437 11
bsw@422 12 if event_max_id then
bsw@422 13 event_selector:add_where{ "event.id < ?", event_max_id }
bsw@422 14 end
bsw@422 15
bsw@414 16 if for_member then
bsw@414 17 event_selector:add_where{ "event.member_id = ?", for_member.id }
bsw@414 18 elseif for_unit then
bsw@414 19 event_selector:join("area", nil, "area.id = issue.area_id")
bsw@414 20 event_selector:add_where{ "area.unit_id = ?", for_unit.id }
bsw@414 21 elseif for_area then
bsw@414 22 event_selector:add_where{ "issue.area_id = ?", for_area.id }
bsw@414 23 elseif not global then
bsw@414 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 })
bsw@414 25 end
bsw@414 26
bsw@414 27 if app.session.member_id then
bsw@414 28 event_selector
bsw@414 29 :left_join("interest", "_interest", { "_interest.issue_id = issue.id AND _interest.member_id = ?", app.session.member.id } )
bsw@414 30 :add_field("(_interest.member_id NOTNULL)", "is_interested")
bsw@414 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 } )
bsw@414 32 :add_field("_delegating_interest.delegate_member_ids[1]", "is_interested_by_delegation_to_member_id")
bsw@414 33 :add_field("_delegating_interest.delegate_member_ids[array_upper(_delegating_interest.delegate_member_ids, 1)]", "is_interested_via_member_id")
bsw@414 34 :add_field("array_length(_delegating_interest.delegate_member_ids, 1)", "delegation_chain_length")
bsw@414 35 end
bsw@414 36
bsw@422 37 local last_event_id
bsw@414 38
bsw@596 39 local events = event_selector:exec()
bsw@596 40
bsw@712 41 local issues = events:load("issue")
bsw@712 42 issues:load_everything_for_member_id(app.session.member_id)
bsw@712 43
bsw@712 44 events:load("initiative")
bsw@712 45 events:load("suggestion")
bsw@712 46 events:load("member")
bsw@712 47
bsw@712 48
bsw@422 49 ui.container{ attr = { class = "issues events" }, content = function()
bsw@414 50
bsw@422 51 local last_event_date
bsw@596 52 for i, event in ipairs(events) do
bsw@422 53 last_event_id = event.id
bsw@414 54
bsw@676 55 ui.container{ attr = { class = "event_info" }, content = function()
bsw@619 56 local event_name = event.event_name
bsw@619 57 local event_image
bsw@619 58 if event.event == "issue_state_changed" then
bsw@619 59 if event.state == "discussion" then
bsw@619 60 event_name = _"Discussion started"
bsw@619 61 event_image = "comments.png"
bsw@619 62 elseif event.state == "verification" then
bsw@619 63 event_name = _"Verification started"
bsw@619 64 event_image = "lock.png"
bsw@619 65 elseif event.state == "voting" then
bsw@619 66 event_name = _"Voting started"
bsw@619 67 event_image = "email_open.png"
bsw@696 68 elseif event.state == "finished_with_winner" then
bsw@696 69 event_name = event.state_name
bsw@696 70 event_image = "award_star_gold_2.png"
bsw@696 71 elseif event.state == "finished_without_winner" then
bsw@696 72 event_name = event.state_name
bsw@696 73 event_image = "cross.png"
bsw@619 74 else
bsw@619 75 event_name = event.state_name
bsw@619 76 end
bsw@619 77 if event_image then
bsw@619 78 ui.image{ static = "icons/16/" .. event_image }
bsw@619 79 slot.put(" ")
bsw@619 80 end
bsw@619 81 end
bsw@619 82 local days_ago_text
bsw@619 83 if event.time_ago == 0 then
bsw@619 84 days_ago_text = _("Today at #{time}", { time = format.time(event.occurrence) })
bsw@619 85 elseif event.time_ago == 1 then
bsw@619 86 days_ago_text = _("Yesterday at #{time}", { time = format.time(event.occurrence) })
bsw@619 87 else
bsw@619 88 days_ago_text = _("#{date} at #{time}", { date = format.date(event.occurrence.date), time = format.time(event.occurrence) })
bsw@619 89 end
bsw@619 90 ui.tag{ attr = { class = "event_name" }, content = event_name }
bsw@686 91 slot.put("<br />")
bsw@619 92 ui.tag{ content = days_ago_text }
bsw@688 93 --[[ if event.time_ago > 1 then
bsw@686 94 slot.put("<br />(")
bsw@619 95 ui.tag{ content = _("#{count} days ago", { count = event.time_ago }) }
bsw@619 96 slot.put(")")
bsw@619 97 end
bsw@688 98 --]]
bsw@688 99 if (app.session.member_id or config.public_access == "pseudonym") and event.member_id then
bsw@688 100 slot.put("<br />")
bsw@688 101 slot.put("<br />")
bsw@688 102 if app.session.member_id then
bsw@688 103 ui.link{
bsw@688 104 content = function()
bsw@688 105 execute.view{
bsw@688 106 module = "member_image",
bsw@688 107 view = "_show",
bsw@688 108 params = {
bsw@688 109 member = event.member,
bsw@688 110 image_type = "avatar",
bsw@688 111 show_dummy = true,
bsw@688 112 class = "micro_avatar",
bsw@688 113 popup_text = text
bsw@688 114 }
bsw@688 115 }
bsw@688 116 end,
bsw@688 117 module = "member", view = "show", id = event.member_id
bsw@688 118 }
bsw@688 119 slot.put(" ")
bsw@688 120 end
bsw@688 121 ui.link{
bsw@688 122 text = event.member.name,
bsw@688 123 module = "member", view = "show", id = event.member_id
bsw@688 124 }
bsw@688 125 end
bsw@619 126 end }
bsw@525 127
bsw@635 128 ui.container{ attr = { class = "issue" }, content = function()
bsw@635 129
bsw@635 130 execute.view{ module = "delegation", view = "_info", params = { issue = event.issue } }
bsw@414 131
bsw@635 132 ui.container{ attr = { class = "content" }, content = function()
bsw@678 133 ui.link{
bsw@678 134 module = "unit", view = "show", id = event.issue.area.unit_id,
bsw@678 135 attr = { class = "unit_link" }, text = event.issue.area.unit.name
bsw@678 136 }
bsw@678 137 slot.put(" ")
bsw@678 138 ui.link{
bsw@678 139 module = "area", view = "show", id = event.issue.area_id,
bsw@678 140 attr = { class = "area_link" }, text = event.issue.area.name
bsw@678 141 }
bsw@422 142 end }
bsw@422 143
bsw@635 144 ui.container{ attr = { class = "title" }, content = function()
bsw@635 145 ui.link{
bsw@635 146 attr = { class = "issue_id" },
bsw@635 147 text = _("#{policy} ##{id}", { policy = event.issue.policy.name, id = event.issue_id }),
bsw@635 148 module = "issue",
bsw@635 149 view = "show",
bsw@635 150 id = event.issue_id
bsw@635 151 }
bsw@635 152 end }
bsw@635 153
bsw@422 154 if event.suggestion_id then
bsw@422 155 ui.container{ attr = { class = "suggestion" }, content = function()
bsw@422 156 ui.link{
bsw@422 157 text = event.suggestion.name,
bsw@422 158 module = "suggestion", view = "show", id = event.suggestion_id
bsw@422 159 }
bsw@422 160 end }
bsw@422 161 end
bsw@422 162
bsw@422 163 ui.container{ attr = { class = "initiative_list" }, content = function()
bsw@422 164 if not event.initiative_id then
bsw@422 165 local initiatives_selector = Initiative:new_selector()
bsw@422 166 :add_where{ "initiative.issue_id = ?", event.issue_id }
bsw@509 167 :add_order_by("initiative.rank, initiative.supporter_count DESC")
bsw@422 168 execute.view{ module = "initiative", view = "_list", params = {
bsw@422 169 issue = event.issue,
bsw@422 170 initiatives_selector = initiatives_selector,
bsw@422 171 no_sort = true,
bsw@422 172 limit = 3
bsw@422 173 } }
bsw@422 174 else
bsw@422 175 local initiatives_selector = Initiative:new_selector()
bsw@422 176 :add_where{ "initiative.id = ?", event.initiative_id }
bsw@422 177 execute.view{ module = "initiative", view = "_list", params = {
bsw@422 178 issue = event.issue,
bsw@422 179 initiatives_selector = initiatives_selector,
bsw@422 180 no_sort = true,
bsw@422 181 limit = 1
bsw@422 182 } }
bsw@414 183 end
bsw@414 184 end }
bsw@414 185
bsw@422 186 --[[
bsw@422 187 if event.initiative_id then
bsw@422 188 ui.container{ attr = { class = "initiative_id" }, content = event.initiative_id }
bsw@422 189 end
bsw@422 190 if event.draft_id then
bsw@422 191 ui.container{ attr = { class = "draft_id" }, content = event.draft_id }
bsw@422 192 end
bsw@422 193 if event.suggestion_id then
bsw@422 194 ui.container{ attr = { class = "suggestion_id" }, content = event.suggestion_id }
bsw@422 195 end
bsw@422 196 --]]
bsw@422 197
bsw@422 198 end }
bsw@422 199 end
bsw@414 200
bsw@422 201 end }
bsw@422 202
bsw@596 203 slot.put("<br />")
bsw@596 204
bsw@596 205 if #events > 0 then
bsw@596 206 ui.link{
bsw@596 207 text = _"Show older events",
bsw@596 208 module = request.get_module(),
bsw@596 209 view = request.get_view(),
bsw@596 210 id = param.get_id(),
bsw@596 211 params = {
bsw@596 212 tab = param.get_all_cgi()["tab"],
bsw@596 213 events = param.get_all_cgi()["events"],
bsw@596 214 event_max_id = last_event_id
bsw@596 215 }
bsw@422 216 }
bsw@596 217 else
bsw@596 218 ui.tag{ content = _"No more events available" }
bsw@596 219 end
bsw@456 220
bsw@456 221 slot.put("<br />")
bsw@456 222 slot.put("<br />")

Impressum / About Us