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@422: ui.container{ attr = { class = "issues events" }, content = function()
bsw@414: 
bsw@422:   local last_event_date
bsw@422:   for i, event in ipairs(event_selector:exec()) do
bsw@422:     last_event_id = event.id
bsw@414: 
bsw@422:     if event.occurrence.date ~= last_event_date then
bsw@437:       local days_ago_text
bsw@437:       if event.time_ago == 0 then
bsw@437:         days_ago_text = _"Today"
bsw@437:       elseif event.time_ago == 1 then
bsw@437:         days_ago_text = _"Yesterday"
bsw@437:       else
bsw@437:         days_ago_text = _("#{count} days ago", { count = event.time_ago })
bsw@437:       end
bsw@437:       ui.container{ attr = { class = "date" }, content = function()
bsw@437:         ui.tag{ content = format.date(event.occurrence.date) }
bsw@437:         slot.put(" &middot; ")
bsw@437:         ui.tag{ content = days_ago_text }
bsw@437:       end }
bsw@437:       
bsw@422:       last_event_date = event.occurrence.date
bsw@422:     end
bsw@422:     local class = "issue"
bsw@422:     if event.is_interested then
bsw@422:       class = class .. " interested"
bsw@422:     elseif event.is_interested_by_delegation_to_member_id then
bsw@422:       class = class .. " interested_by_delegation"
bsw@422:     end
bsw@525: 
bsw@525:             ui.container{ attr = { class = "issue_policy_info" }, content = function()
bsw@525:           if (app.session.member_id or config.public_access == "pseudonym") and event.member_id then
bsw@525:             if app.session.member_id then
bsw@525:               ui.link{
bsw@525:                 content = function()
bsw@525:                   execute.view{
bsw@525:                     module = "member_image",
bsw@525:                     view = "_show",
bsw@525:                     params = {
bsw@525:                       member = event.member,
bsw@525:                       image_type = "avatar",
bsw@525:                       show_dummy = true,
bsw@525:                       class = "micro_avatar",
bsw@525:                       popup_text = text
bsw@525:                     }
bsw@525:                   }
bsw@525:                 end,
bsw@525:                 module = "member", view = "show", id = event.member_id
bsw@525:               }
bsw@525:               slot.put(" ")
bsw@525:             end
bsw@525:             ui.link{
bsw@525:               text = event.member.name,
bsw@525:               module = "member", view = "show", id = event.member_id
bsw@525:             }
bsw@525:             slot.put(" &middot; ") 
bsw@525:           end
bsw@525:           local event_name = event.event_name
bsw@525:           local event_image
bsw@525:           if event.event == "issue_state_changed" then
bsw@525:             if event.state == "discussion" then
bsw@525:               event_name = _"Discussion started"
bsw@525:               event_image = "comments.png"
bsw@525:             elseif event.state == "verification" then
bsw@525:               event_name = _"Verification started"
bsw@525:               event_image = "lock.png"
bsw@525:             elseif event.state == "voting" then
bsw@525:               event_name = _"Voting started"
bsw@525:               event_image = "email_open.png"
bsw@525:             else
bsw@525:               event_name = event.state_name
bsw@525:             end
bsw@525:             if event_image then
bsw@525:               ui.image{ static = "icons/16/" .. event_image }
bsw@525:               slot.put(" ")
bsw@525:             end
bsw@525:           end
bsw@525:           ui.tag{ attr = { class = "event_name" }, content = event_name }
bsw@525:           slot.put(" &middot; ") 
bsw@525:           ui.tag{ attr = { class = "time" }, content = format.time(event.occurrence) }
bsw@525:         end }
bsw@525: 
bsw@422:     ui.container{ attr = { class = class }, content = function()
bsw@414: 
bsw@422:       ui.container { attr = { class = "issue_info" }, content = function()
bsw@422:       
bsw@498:         if event.is_interested then
bsw@498:           ui.tag{
bsw@498:             tag = "div", attr = { class = "interest_by_delegation"},
bsw@498:             content = function()
bsw@498:               local text = "You are interested in this issue"
bsw@498:               ui.image{ attr = { alt = text, title = text }, static = "icons/16/eye.png" }
bsw@498:             end
bsw@498:           }
bsw@498:           
bsw@498:         elseif event.is_interested_by_delegation_to_member_id then
bsw@498:           ui.tag{
bsw@498:             tag = "div", attr = { class = "interest_by_delegation"},
bsw@498:             content = function()
bsw@498:               local member = Member:by_id(event.is_interested_by_delegation_to_member_id)
bsw@498:               local text = _"delegated to"
bsw@498:               ui.image{
bsw@498:                 attr = { class = "delegation_arrow", alt = text, title = text },
bsw@498:                 static = "delegation_arrow_24_horizontal.png"
bsw@498:               }
bsw@498:               execute.view{
bsw@498:                 module = "member_image",
bsw@498:                 view = "_show",
bsw@498:                 params = {
bsw@498:                   member = member,
bsw@498:                   image_type = "avatar",
bsw@498:                   show_dummy = true,
bsw@498:                   class = "micro_avatar",
bsw@498:                   popup_text = member.name
bsw@498:                 }
bsw@498:               }
bsw@498:               if event.is_interested_by_delegation_to_member_id ~= event.is_interested_via_member_id then
bsw@498:                 if event.delegation_chain_length > 2 then
bsw@498:                   local text = _"delegated to"
bsw@498:                   ui.image{
bsw@498:                     attr = { class = "delegation_arrow", alt = text, title = text },
bsw@498:                     static = "delegation_arrow_24_horizontal.png"
bsw@498:                   }
bsw@498:                   ui.tag{ content = "..." }
bsw@498:                 end
bsw@498:               local text = _"delegated to"
bsw@498:                 ui.image{
bsw@498:                   attr = { class = "delegation_arrow", alt = text, title = text },
bsw@498:                   static = "delegation_arrow_24_horizontal.png"
bsw@498:                 }
bsw@498:                 local member = Member:by_id(event.is_interested_via_member_id)
bsw@498:                 execute.view{
bsw@498:                   module = "member_image",
bsw@498:                   view = "_show",
bsw@498:                   params = {
bsw@498:                     member = member,
bsw@498:                     image_type = "avatar",
bsw@498:                     show_dummy = true,
bsw@498:                     class = "micro_avatar",
bsw@498:                     popup_text = member.name
bsw@498:                   }
bsw@498:                 }
bsw@498:               end
bsw@498:             end
bsw@498:           }
bsw@498:         end
bsw@498: 
bsw@422:         ui.container{ content = function()
bsw@422:           ui.link{
bsw@422:             attr = { class = "issue_id" },
bsw@422:             text = _("Issue ##{id}", { id = tostring(event.issue_id) }),
bsw@422:             module = "issue",
bsw@422:             view = "show",
bsw@422:             id = event.issue_id
bsw@422:           }
bsw@414: 
bsw@422:           slot.put(" &middot; ")
bsw@471:           ui.tag{ content = event.issue.policy.name }
bsw@471:           slot.put(" &middot; ")
bsw@422:           ui.tag{ content = event.issue.area.name }
bsw@422:           slot.put(" &middot; ")
bsw@422:           ui.tag{ content = event.issue.area.unit.name }
bsw@414:         end }
bsw@414: 
bsw@422: 
bsw@422:       end }
bsw@422:       
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@422: ui.link{
bsw@423:   text = _"Show older events",
bsw@422:   module = request.get_module(),
bsw@422:   view = request.get_view(),
bsw@422:   id = param.get_id(),
bsw@422:   params = { 
bsw@422:     tab = param.get_all_cgi()["tab"],
bsw@422:     events = param.get_all_cgi()["events"],
bsw@422:     event_max_id = last_event_id
bsw@422:   }
bsw@422: }
bsw@456: 
bsw@456: 
bsw@456: slot.put("<br />")
bsw@456: slot.put("<br />")