1 local issue = param.get("issue", "table")

2 local initiative = param.get("initiative", "table")

3

4 if app.session:has_access("all_pseudonymous") then

5 ui.sidebar ( "tab-members", function ()

6

7 local text = _"Interested members"

8 if issue.state == "finished_with_winner" or issue.state == "finished_without_winner" then

9 text = _"Voters"

10 end

11

12 ui.sidebarHead( function()

13 ui.heading{

14 level = 2, content = text

15 }

16 end )

17

18 local interested_members_selector

19

20 if issue.state == "finished_with_winner" or issue.state == "finished_without_winner" then

21 if initiative then

22 interested_members_selector = Member:new_selector()

23 :join("issue", nil, { "issue.id = ?", issue.id })

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

25 :join("vote", nil, { "vote.member_id = member.id AND vote.initiative_id = ?", initiative.id })

26 :add_field("direct_voter.weight", "voter_weight")

27 :add_field("vote.grade")

28 :add_field("direct_voter.comment", "voter_comment")

29 else

30 interested_members_selector = Member:new_selector()

31 :join("issue", nil, { "issue.id = ?", issue.id })

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

33 :add_field("direct_voter.weight", "voter_weight")

34 :add_field("direct_voter.comment", "voter_comment")

35 end

36 else

37 interested_members_selector= issue:get_reference_selector("interested_members_snapshot")

38 :join("issue", nil, "issue.id = direct_interest_snapshot.issue_id")

39 :add_field("direct_interest_snapshot.weight")

40 :add_where("direct_interest_snapshot.event = issue.latest_snapshot_event")

41

42 if initiative then

43 interested_members_selector:left_join("direct_supporter_snapshot", nil, { "direct_supporter_snapshot.initiative_id = ? AND direct_interest_snapshot.issue_id = direct_supporter_snapshot.issue_id AND direct_supporter_snapshot.member_id = direct_interest_snapshot.member_id AND direct_supporter_snapshot.event = issue.latest_snapshot_event", initiative.id })

44 interested_members_selector:add_field("direct_supporter_snapshot.member_id NOTNULL", "supporter")

45 interested_members_selector:add_field("satisfied", "supporter_satisfied")

46 end

47 end

48

49 execute.view{

50 module = "member",

51 view = "_list",

52 params = {

53 issue = issue,

54 initiative = initiative,

55 members_selector = interested_members_selector,

56 no_filter = true,

57 member_class = "sidebarRow sidebarRowNarrow",

58 for_votes = issue.state == "finished_with_winner" or issue.state == "finished_without_winner"

59 }

60 }

61

62 end )

63

64 end