bsw@1045: local initiative = Initiative:by_id(param.get("initiative_id"))
bsw@1045: 
bsw@1045: local issue
bsw@1045: 
bsw@1045: if initiative then
bsw@1045:   issue = initiative.issue
bsw@1045: else
bsw@1045:   issue = Issue:by_id(param.get("issue_id"))
bsw@1045: end
bsw@1045: 
bsw@1045: if app.session.member_id then
bsw@1045:   if initiative then
bsw@1045:     initiative:load_everything_for_member_id(app.session.member.id)
bsw@1045:   end
bsw@1045:   issue:load_everything_for_member_id(app.session.member.id)
bsw@1045: end
bsw@1045: 
bsw/jbe@6: local member = Member:by_id(param.get("member_id", atom.integer))
bsw/jbe@6: 
bsw/jbe@6: local members_selector = Member:new_selector()
bsw/jbe@6:   :join("delegating_voter", nil, "delegating_voter.member_id = member.id")
bsw/jbe@6:   :add_where{ "delegating_voter.issue_id = ?", issue.id }
bsw/jbe@6:   :add_where{ "delegating_voter.delegate_member_ids[1] = ?", member.id }
bsw@11:   :add_field("delegating_voter.weight", "voter_weight")
bsw@190:   :join("issue", nil, "issue.id = delegating_voter.issue_id")
bsw/jbe@6: 
bsw@1045: 
bsw/jbe@6: execute.view{
bsw@1045:   module = "issue", view = "_head", params = {
bsw@1045:     issue = issue, initiative = initiative
bsw@1045:   }
bsw@1045: }
bsw@1045: 
bsw@1045: execute.view{ module = "issue", view = "_sidebar_state", params = {
bsw@1045:   issue = issue,
bsw@1045: } }
bsw@1045: 
bsw@1045: execute.view { 
bsw@1045:   module = "issue", view = "_sidebar_issue", params = {
bsw@1045:     issue = issue,
bsw@1045:     highlight_initiative_id = initiative and initiative.id or nil,
bsw@1045:   }
bsw@1045: }
bsw@1045: 
bsw@1045: execute.view { 
bsw@1045:   module = "issue", view = "_sidebar_whatcanido", params = {
bsw@1045:     issue = issue
bsw/jbe@6:   }
bsw@1045: }
bsw@1045: 
bsw@1045: execute.view { 
bsw@1045:   module = "issue", view = "_sidebar_members", params = {
bsw@1045:     issue = issue,
bsw@1045:     initiative = initiative
bsw@1045:   }
bsw@1045: }
bsw@1045: 
bsw@1045: 
bsw@1045: ui.section( function()
bsw@1045:     
bsw@1045:   ui.sectionHead( function()
bsw@1045:     ui.heading{ level = 1, content = _("Incoming delegations for '#{member}'", { member = member.name }) }
bsw@1045:   end)
bsw@1045: 
bsw@1045:   execute.view{
bsw@1045:     module = "member",
bsw@1045:     view = "_list",
bsw@1045:     params = {
bsw@1045:       members_selector = members_selector,
bsw@1045:       trustee = member,
bsw@1045:       issue = issue,
bsw@1045:       initiative = initiative,
bsw@1045:       for_votes = true, no_filter = true,
bsw@1045:       
bsw@1045:     }
bsw@1045:   }
bsw@1045:   
bsw@1045: end )