bsw@414: local global = param.get("global", atom.boolean) bsw@414: local for_member = param.get("for_member", "table") bsw@414: local for_unit = param.get("for_unit", "table") bsw@414: local for_area = param.get("for_area", "table") bsw@422: local event_max_id = param.get_all_cgi()["event_max_id"] bsw@414: local event_selector = Event:new_selector() bsw@414: :add_order_by("event.id DESC") bsw@414: :limit(25) bsw@414: :join("issue", nil, "issue.id = event.issue_id") bsw@437: :add_field("now()::date - event.occurrence::date", "time_ago") bsw@437: bsw@422: if event_max_id then bsw@422: event_selector:add_where{ "event.id < ?", event_max_id } bsw@422: end bsw@422: bsw@414: if for_member then bsw@414: event_selector:add_where{ "event.member_id = ?", for_member.id } bsw@414: elseif for_unit then bsw@414: event_selector:join("area", nil, "area.id = issue.area_id") bsw@414: event_selector:add_where{ "area.unit_id = ?", for_unit.id } bsw@414: elseif for_area then bsw@414: event_selector:add_where{ "issue.area_id = ?", for_area.id } bsw@414: elseif not global then bsw@414: 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: end bsw@414: bsw@414: if app.session.member_id then bsw@414: event_selector bsw@414: :left_join("interest", "_interest", { "_interest.issue_id = issue.id AND _interest.member_id = ?", app.session.member.id } ) bsw@414: :add_field("(_interest.member_id NOTNULL)", "is_interested") bsw@414: :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: :add_field("_delegating_interest.delegate_member_ids[1]", "is_interested_by_delegation_to_member_id") bsw@414: :add_field("_delegating_interest.delegate_member_ids[array_upper(_delegating_interest.delegate_member_ids, 1)]", "is_interested_via_member_id") bsw@414: :add_field("array_length(_delegating_interest.delegate_member_ids, 1)", "delegation_chain_length") bsw@414: end bsw@414: bsw@422: local last_event_id bsw@414: bsw@596: local events = event_selector:exec() bsw@596: bsw@422: ui.container{ attr = { class = "issues events" }, content = function() bsw@414: bsw@422: local last_event_date bsw@596: for i, event in ipairs(events) do bsw@422: last_event_id = event.id bsw@553: event.issue:load_everything_for_member_id(app.session.member_id) bsw@414: bsw@676: ui.container{ attr = { class = "event_info" }, content = function() bsw@619: if (app.session.member_id or config.public_access == "pseudonym") and event.member_id then bsw@619: if app.session.member_id then bsw@619: ui.link{ bsw@619: content = function() bsw@619: execute.view{ bsw@619: module = "member_image", bsw@619: view = "_show", bsw@619: params = { bsw@619: member = event.member, bsw@619: image_type = "avatar", bsw@619: show_dummy = true, bsw@619: class = "micro_avatar", bsw@619: popup_text = text bsw@619: } bsw@525: } bsw@619: end, bsw@619: module = "member", view = "show", id = event.member_id bsw@619: } bsw@619: slot.put(" ") bsw@619: end bsw@619: ui.link{ bsw@619: text = event.member.name, bsw@619: module = "member", view = "show", id = event.member_id bsw@619: } bsw@619: slot.put(" · ") bsw@619: end bsw@619: local event_name = event.event_name bsw@619: local event_image bsw@619: if event.event == "issue_state_changed" then bsw@619: if event.state == "discussion" then bsw@619: event_name = _"Discussion started" bsw@619: event_image = "comments.png" bsw@619: elseif event.state == "verification" then bsw@619: event_name = _"Verification started" bsw@619: event_image = "lock.png" bsw@619: elseif event.state == "voting" then bsw@619: event_name = _"Voting started" bsw@619: event_image = "email_open.png" bsw@619: else bsw@619: event_name = event.state_name bsw@619: end bsw@619: if event_image then bsw@619: ui.image{ static = "icons/16/" .. event_image } bsw@619: slot.put(" ") bsw@619: end bsw@619: end bsw@619: local days_ago_text bsw@619: if event.time_ago == 0 then bsw@619: days_ago_text = _("Today at #{time}", { time = format.time(event.occurrence) }) bsw@619: elseif event.time_ago == 1 then bsw@619: days_ago_text = _("Yesterday at #{time}", { time = format.time(event.occurrence) }) bsw@619: else bsw@619: days_ago_text = _("#{date} at #{time}", { date = format.date(event.occurrence.date), time = format.time(event.occurrence) }) bsw@619: end bsw@619: ui.tag{ attr = { class = "event_name" }, content = event_name } bsw@619: slot.put(" · ") bsw@619: ui.tag{ content = days_ago_text } bsw@619: if event.time_ago > 1 then bsw@619: slot.put(" (") bsw@619: ui.tag{ content = _("#{count} days ago", { count = event.time_ago }) } bsw@619: slot.put(")") bsw@619: end bsw@619: end } bsw@525: bsw@635: ui.container{ attr = { class = "issue" }, content = function() bsw@635: bsw@635: execute.view{ module = "delegation", view = "_info", params = { issue = event.issue } } bsw@414: bsw@635: ui.container{ attr = { class = "content" }, content = function() bsw@635: ui.tag{ content = event.issue.area.name } bsw@635: slot.put(" · ") bsw@635: ui.tag{ content = event.issue.area.unit.name } bsw@422: end } bsw@422: bsw@635: ui.container{ attr = { class = "title" }, content = function() bsw@635: ui.link{ bsw@635: attr = { class = "issue_id" }, bsw@635: text = _("#{policy} ##{id}", { policy = event.issue.policy.name, id = event.issue_id }), bsw@635: module = "issue", bsw@635: view = "show", bsw@635: id = event.issue_id bsw@635: } bsw@635: end } bsw@635: bsw@422: if event.suggestion_id then bsw@422: ui.container{ attr = { class = "suggestion" }, content = function() bsw@422: ui.link{ bsw@422: text = event.suggestion.name, bsw@422: module = "suggestion", view = "show", id = event.suggestion_id bsw@422: } bsw@422: end } bsw@422: end bsw@422: bsw@422: ui.container{ attr = { class = "initiative_list" }, content = function() bsw@422: if not event.initiative_id then bsw@422: local initiatives_selector = Initiative:new_selector() bsw@422: :add_where{ "initiative.issue_id = ?", event.issue_id } bsw@509: :add_order_by("initiative.rank, initiative.supporter_count DESC") bsw@422: execute.view{ module = "initiative", view = "_list", params = { bsw@422: issue = event.issue, bsw@422: initiatives_selector = initiatives_selector, bsw@422: no_sort = true, bsw@422: limit = 3 bsw@422: } } bsw@422: else bsw@422: local initiatives_selector = Initiative:new_selector() bsw@422: :add_where{ "initiative.id = ?", event.initiative_id } bsw@422: execute.view{ module = "initiative", view = "_list", params = { bsw@422: issue = event.issue, bsw@422: initiatives_selector = initiatives_selector, bsw@422: no_sort = true, bsw@422: limit = 1 bsw@422: } } bsw@414: end bsw@414: end } bsw@414: bsw@422: --[[ bsw@422: if event.initiative_id then bsw@422: ui.container{ attr = { class = "initiative_id" }, content = event.initiative_id } bsw@422: end bsw@422: if event.draft_id then bsw@422: ui.container{ attr = { class = "draft_id" }, content = event.draft_id } bsw@422: end bsw@422: if event.suggestion_id then bsw@422: ui.container{ attr = { class = "suggestion_id" }, content = event.suggestion_id } bsw@422: end bsw@422: --]] bsw@422: bsw@422: end } bsw@422: end bsw@414: bsw@422: end } bsw@422: bsw@596: slot.put("
") bsw@596: bsw@596: if #events > 0 then bsw@596: ui.link{ bsw@596: text = _"Show older events", bsw@596: module = request.get_module(), bsw@596: view = request.get_view(), bsw@596: id = param.get_id(), bsw@596: params = { bsw@596: tab = param.get_all_cgi()["tab"], bsw@596: events = param.get_all_cgi()["events"], bsw@596: event_max_id = last_event_id bsw@596: } bsw@422: } bsw@596: else bsw@596: ui.tag{ content = _"No more events available" } bsw@596: end bsw@456: bsw@456: slot.put("
") bsw@456: slot.put("
")