bsw@851: --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@851: --elseif not global then
bsw@851: --  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@851: local filters = execute.load_chunk{module="issue", chunk="_filters.lua", params = {
bsw@851:   for_events = true,
bsw@851:   member = app.session.member, for_member = for_member, state = for_state, for_unit = for_unit and true or false, for_area = for_area and true or false
bsw@851: }}
bsw@414: 
bsw@851: filters.opened = true
bsw@851: filters.selector = event_selector
bsw@851: 
bsw@851: filters.content = function()
bsw@851: 
bsw@596: 
bsw@851:   local last_event_id
bsw@851: 
bsw@851:   local events = event_selector:exec()
bsw@712: 
bsw@851:   local issues = events:load("issue")
bsw@851:   issues:load_everything_for_member_id(app.session.member_id)
bsw@851: 
bsw@851:   events:load("initiative")
bsw@851:   events:load("suggestion")
bsw@851:   events:load("member")
bsw@712: 
bsw@712: 
bsw@851:   ui.container{ attr = { class = "issues events" }, content = function()
bsw@414: 
bsw@851:     local last_event_date
bsw@851:     for i, event in ipairs(events) do
bsw@851:       last_event_id = event.id
bsw@414: 
bsw@851:       ui.container{ attr = { class = "event_info" }, content = function()
bsw@851:         local event_name = event.event_name
bsw@851:         local event_image
bsw@851:         if event.event == "issue_state_changed" then
bsw@851:           if event.state == "discussion" then
bsw@851:             event_name = _"Discussion started"
bsw@851:             event_image = "comments.png"
bsw@851:           elseif event.state == "verification" then
bsw@851:             event_name = _"Verification started"
bsw@851:             event_image = "lock.png"
bsw@851:           elseif event.state == "voting" then
bsw@851:             event_name = _"Voting started"
bsw@851:             event_image = "email_open.png"
bsw@851:           elseif event.state == "finished_with_winner" then
bsw@851:             event_name = event.state_name
bsw@851:             event_image = "award_star_gold_2.png"
bsw@851:           elseif event.state == "finished_without_winner" then
bsw@851:             event_name = event.state_name
bsw@851:             event_image = "cross.png"
bsw@851:           else
bsw@851:             event_name = event.state_name
bsw@851:           end
bsw@851:           if event_image then
bsw@851:             ui.image{ static = "icons/16/" .. event_image }
bsw@851:             slot.put(" ")
bsw@851:           end
bsw@619:         end
bsw@851:         local days_ago_text
bsw@851:         if event.time_ago == 0 then
bsw@851:           days_ago_text = _("Today at #{time}", { time = format.time(event.occurrence) })
bsw@851:         elseif event.time_ago == 1 then
bsw@851:           days_ago_text = _("Yesterday at #{time}", { time = format.time(event.occurrence) })
bsw@851:         else
bsw@851:           days_ago_text = _("#{date} at #{time}", { date = format.date(event.occurrence.date), time = format.time(event.occurrence) })
bsw@851:         end
bsw@851:         ui.tag{ attr = { class = "event_name" }, content = event_name }
bsw@688:         slot.put("<br />") 
bsw@851:         ui.tag{ content = days_ago_text }
bsw@851:   --[[      if event.time_ago > 1 then
bsw@851:           slot.put("<br />(")
bsw@851:           ui.tag{ content = _("#{count} days ago", { count = event.time_ago }) }
bsw@851:           slot.put(")")
bsw@851:         end
bsw@851:         --]]
bsw@851:         if app.session:has_access("authors_pseudonymous") and event.member_id then
bsw@851:           slot.put("<br />") 
bsw@851:           slot.put("<br />") 
bsw@851:           if app.session.member_id then
bsw@851:             ui.link{
bsw@851:               content = function()
bsw@851:                 execute.view{
bsw@851:                   module = "member_image",
bsw@851:                   view = "_show",
bsw@851:                   params = {
bsw@851:                     member = event.member,
bsw@851:                     image_type = "avatar",
bsw@851:                     show_dummy = true,
bsw@851:                     class = "micro_avatar",
bsw@851:                     popup_text = text
bsw@851:                   }
bsw@851:                 }
bsw@851:               end,
bsw@851:               module = "member", view = "show", id = event.member_id
bsw@851:             }
bsw@851:             slot.put(" ")
bsw@851:           end
bsw@688:           ui.link{
bsw@851:             text = event.member.name,
bsw@688:             module = "member", view = "show", id = event.member_id
bsw@688:           }
bsw@414:         end
bsw@414:       end }
bsw@414: 
bsw@851:       ui.container{ attr = { class = "issue" }, content = function()
bsw@851: 
bsw@862:         execute.view{ module = "delegation", view = "_info", params = { issue = event.issue, member = for_member } }
bsw@851: 
bsw@851:         ui.container{ attr = { class = "content" }, content = function()
bsw@851:           ui.link{
bsw@851:             module = "unit", view = "show", id = event.issue.area.unit_id,
bsw@851:             attr = { class = "unit_link" }, text = event.issue.area.unit.name
bsw@851:           }
bsw@851:           slot.put(" ")
bsw@851:           ui.link{
bsw@851:             module = "area", view = "show", id = event.issue.area_id,
bsw@851:             attr = { class = "area_link" }, text = event.issue.area.name
bsw@851:           }
bsw@851:         end }
bsw@851:         
bsw@851:         ui.container{ attr = { class = "title" }, content = function()
bsw@725:           ui.link{
bsw@851:             attr = { class = "issue_id" },
bsw@851:             text = _("#{policy} ##{id}", { policy = event.issue.policy.name, id = event.issue_id }),
bsw@851:             module = "issue",
bsw@851:             view = "show",
bsw@851:             id = event.issue_id
bsw@725:           }
bsw@851:         end }
bsw@851: 
bsw@851:         ui.container{ attr = { class = "initiative_list" }, content = function()
bsw@851:           if not event.initiative_id then
bsw@851:             local initiatives_selector = Initiative:new_selector()
bsw@851:               :add_where{ "initiative.issue_id = ?", event.issue_id }
bsw@851:               :add_order_by("initiative.rank, initiative.supporter_count DESC")
bsw@851:             execute.view{ module = "initiative", view = "_list", params = { 
bsw@851:               issue = event.issue,
bsw@851:               initiatives_selector = initiatives_selector,
bsw@851:               no_sort = true,
bsw@862:               limit = 5,
bsw@862:               for_member = for_member
bsw@851:             } }
bsw@851:           else
bsw@851:             local initiatives_selector = Initiative:new_selector()
bsw@851:               :add_where{ "initiative.id = ?", event.initiative_id }
bsw@851:             execute.view{ module = "initiative", view = "_list", params = { 
bsw@851:               initiatives_selector = initiatives_selector,
bsw@851:               no_sort = true,
bsw@862:               hide_more_initiatives = true,
bsw@862:               for_member = for_member
bsw@851:             } }
bsw@851:           end
bsw@851:         end }
bsw@851: 
bsw@851:         ui.container{ attr = { class = "content suggestion" }, content = function()
bsw@851:           if event.suggestion_id then
bsw@851:             ui.link{
bsw@851:               text = event.suggestion.name,
bsw@851:               module = "suggestion", view = "show", id = event.suggestion_id
bsw@851:             }
bsw@851:           end
bsw@851:         end }
bsw@725:       end }
bsw@851:     end
bsw@851: 
bsw@851:   end }
bsw@851: 
bsw@851:   slot.put("<br />")
bsw@851: 
bsw@851:   if #events > 0 then
bsw@851:     ui.link{
bsw@851:       attr = { class = "more_events_links" },
bsw@851:       text = _"Show older events",
bsw@851:       module = request.get_module(),
bsw@851:       view = request.get_view(),
bsw@851:       id = for_unit and for_unit.id or for_area and for_area.id,
bsw@851:       params = {
bsw@851:         tab = param.get_all_cgi()["tab"],
bsw@851:         events = param.get_all_cgi()["events"],
bsw@851:         event_max_id = last_event_id
bsw@851:       }
bsw@851:     }
bsw@851:   else
bsw@851:     ui.tag{ content = _"No more events available" }
bsw@422:   end
bsw@414: 
bsw@851:   slot.put("<br />")
bsw@851:   slot.put("<br />")
bsw@596: 
bsw@596: end
bsw@456: 
bsw@851: 
bsw@851: ui.filters(filters)