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@712: local issues = events:load("issue")
bsw@712: issues:load_everything_for_member_id(app.session.member_id)
bsw@712: 
bsw@712: events:load("initiative")
bsw@712: events:load("suggestion")
bsw@712: events:load("member")
bsw@712: 
bsw@712: 
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@414: 
bsw@676:     ui.container{ attr = { class = "event_info" }, content = function()
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@696:         elseif event.state == "finished_with_winner" then
bsw@696:           event_name = event.state_name
bsw@696:           event_image = "award_star_gold_2.png"
bsw@696:         elseif event.state == "finished_without_winner" then
bsw@696:           event_name = event.state_name
bsw@696:           event_image = "cross.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@686:       slot.put("<br />") 
bsw@619:       ui.tag{ content = days_ago_text }
bsw@688: --[[      if event.time_ago > 1 then
bsw@686:         slot.put("<br />(")
bsw@619:         ui.tag{ content = _("#{count} days ago", { count = event.time_ago }) }
bsw@619:         slot.put(")")
bsw@619:       end
bsw@688:       --]]
bsw@813:       if app.session:has_access("authors_pseudonymous") and event.member_id then
bsw@688:         slot.put("<br />") 
bsw@688:         slot.put("<br />") 
bsw@688:         if app.session.member_id then
bsw@688:           ui.link{
bsw@688:             content = function()
bsw@688:               execute.view{
bsw@688:                 module = "member_image",
bsw@688:                 view = "_show",
bsw@688:                 params = {
bsw@688:                   member = event.member,
bsw@688:                   image_type = "avatar",
bsw@688:                   show_dummy = true,
bsw@688:                   class = "micro_avatar",
bsw@688:                   popup_text = text
bsw@688:                 }
bsw@688:               }
bsw@688:             end,
bsw@688:             module = "member", view = "show", id = event.member_id
bsw@688:           }
bsw@688:           slot.put(" ")
bsw@688:         end
bsw@688:         ui.link{
bsw@688:           text = event.member.name,
bsw@688:           module = "member", view = "show", id = event.member_id
bsw@688:         }
bsw@688:       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@678:         ui.link{
bsw@678:           module = "unit", view = "show", id = event.issue.area.unit_id,
bsw@678:           attr = { class = "unit_link" }, text = event.issue.area.unit.name
bsw@678:         }
bsw@678:         slot.put(" ")
bsw@678:         ui.link{
bsw@678:           module = "area", view = "show", id = event.issue.area_id,
bsw@678:           attr = { class = "area_link" }, text = event.issue.area.name
bsw@678:         }
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:       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@725:             limit = 5
bsw@422:           } }
bsw@422:         else
bsw@819:           local initiatives_selector = Initiative:new_selector()
bsw@819:             :add_where{ "initiative.id = ?", event.initiative_id }
bsw@422:           execute.view{ module = "initiative", view = "_list", params = { 
bsw@422:             initiatives_selector = initiatives_selector,
bsw@422:             no_sort = true,
bsw@725:             hide_more_initiatives = true
bsw@422:           } }
bsw@414:         end
bsw@414:       end }
bsw@414: 
bsw@725:       ui.container{ attr = { class = "content suggestion" }, content = function()
bsw@725:         if event.suggestion_id then
bsw@725:           ui.link{
bsw@725:             text = event.suggestion.name,
bsw@725:             module = "suggestion", view = "show", id = event.suggestion_id
bsw@725:           }
bsw@725:         end
bsw@725:       end }
bsw@422:     end }
bsw@422:   end
bsw@414: 
bsw@422: end }
bsw@422: 
bsw@596: slot.put("<br />")
bsw@596: 
bsw@596: if #events > 0 then
bsw@596:   ui.link{
bsw@770:     attr = { class = "more_events_links" },
bsw@596:     text = _"Show older events",
bsw@596:     module = request.get_module(),
bsw@596:     view = request.get_view(),
bsw@772:     id = for_unit and for_unit.id or for_area and for_area.id,
bsw@771:     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("<br />")
bsw@456: slot.put("<br />")