1 slot.set_layout("lf2")

2

3 slot.put_into("leftright_pre", '<div class="sidebar_right">')

4 slot.put_into("leftright_post", '</div>')

5

6 local initiative = Initiative:by_id(param.get_id())

7

8 local issue = initiative.issue

9 issue:load("interest_for_member", { member_id = app.session.member_id }, "interest")

10

11 local supporting_members_selector = Member:new_selector()

12 :join("direct_supporter_snapshot", "dss", { "dss.issue_id = ? AND dss.initiative_id = ? AND dss.member_id = member.id and dss.event = (select latest_snapshot_event from issue where id = ?)", issue.id, initiative.id, issue.id })

13 :join("direct_interest_snapshot", "dis", { "dis.issue_id = ? AND dis.member_id = member.id and dis.event = (select latest_snapshot_event from issue where id = ?)", issue.id, issue.id })

14 :add_field("dis.weight", "weight")

15 :add_order_by("dis.weight DESC")

16 local supporting_members = supporting_members_selector:exec()

17

18 local voting_members_selector = Member:new_selector()

19 :join("direct_voter", nil, { "direct_voter.issue_id = ? AND direct_voter.member_id = member.id", issue.id })

20 :add_field("direct_voter.weight", "weight")

21 :add_order_by("direct_voter.weight DESC")

22 local voting_members = voting_members_selector:exec()

23

24 local alternative_initiatives = initiative.issue.initiatives

25 alternative_initiatives:load("initiating_members", nil, "initiating_members")

26

27

28 slot.select("sidebar", function()

29

30 execute.view{ module = "lf2", view = "_sidebar_issue", params = { issue = issue, initiative_id = initiative.id } }

31

32 execute.view{ module = "lf2", view = "_sidebar_initiatives", params = {

33 initiatives = alternative_initiatives,

34 head_content = function() ui.tag{ content = _"Alternative initiatives" } end

35 } }

36

37 execute.view{ module = "lf2", view = "_sidebar_drafts", params = {

38 initiative = initiative

39 } }

40

41 end)

42

43 local draft = initiative.current_draft

44

45 ui.box{

46 content = function()

47

48 ui.box_row{ class = "initiative head", content = function() ui.box_col { content = function()

49 execute.view{ module = "lf2", view = "_initiative", params = { initiative = initiative } }

50 end } end }

51

52 ui.box_row{ class = "head2", content = function() ui.box_col{ content = function()

53 if initiative.issue.fully_frozen and initiative.issue.closed then

54 ui.link{ external = "#votes", text = _("#{vote_count} votes", { vote_count = #voting_members }) }

55 slot.put(" &middot; ")

56 end

57 ui.link{ external = "#suggestions", text = _("#{suggestion_count} suggestions", { suggestion_count = 23 }) }

58 slot.put(" &middot; ")

59 ui.link{ external = "#supporters", text = _("#{supporter_count} supporters", { supporter_count = #supporting_members }) }

60 end } end }

61

62 ui.box_row{ content = function() ui.box_col{ content = function()

63 execute.view{ module = "lf2", view = "_draft", params = { draft = draft } }

64 end } end }

65 end

66 }

67

68 if initiative.issue.fully_frozen and initiative.issue.closed then

69 ui.boxhead{ name = "votes", content = _"Votes" }

70 ui.box{

71 content = function()

72 ui.box_row{ content = function() ui.box_col{ content = function()

73 execute.view{ module = "lf2", view = "_avatars", params = { members = voting_members } }

74 end } end }

75 end

76 }

77 end

78

79 ui.boxhead{ name = "suggestions", content = _"Suggestions" }

80 ui.box{

81 content = function()

82 ui.box_row{ content = function() ui.box_col{ content = function()

83 slot.put("suggestions")

84 end } end }

85 end

86 }

87

88 ui.boxhead{ name = "supporters", content = _"Supporters" }

89 ui.box{

90 content = function()

91 ui.box_row{ content = function() ui.box_col{ content = function()

92 execute.view{ module = "lf2", view = "_avatars", params = { members = supporting_members } }

93 end } end }

94 end

95 }

96