liquid_feedback_frontend: 6c88b4bfb56c app/main/member/show

liquid_feedback_frontend

view app/main/member/show_tab.lua @ 285:6c88b4bfb56c

Apply interest/support filter for member at member page

author	bsw
date	Fri Feb 17 15:16:02 2012 +0100 (2012-02-17)
parents	b77e6a17ca77
children	44f9a09ea51c

line source

1 local show_as_homepage = param.get("show_as_homepage", atom.boolean)

3 local member

5 if request.get_json_request_slots() then

6 member = Member:by_id(param.get("member_id"))

7 else

8 member = param.get("member", "table")

9 end

11 local tabs = {

12 module = "member",

13 view = "show_tab",

14 static_params = {

15 member_id = member.id,

16 show_as_homepage = show_as_homepage

17 }

18 }

20 if show_as_homepage and app.session.member_id == member.id then

22 if app.session.member.notify_email_unconfirmed then

23 tabs[#tabs+1] = {

24 class = "yellow",

25 name = "email_unconfirmed",

26 label = _"Email unconfirmed",

27 icon = { static = "icons/16/bell.png" },

28 module = "member",

29 view = "_email_unconfirmed",

30 params = {}

31 }

32 end

34 if config.motd_intern then

35 tabs[#tabs+1] = {

36 class = "yellow",

37 name = "motd",

38 label = _"Message of the day",

39 icon = { static = "icons/16/bell.png" },

40 module = "index",

41 view = "_motd",

42 params = {}

43 }

44 end

46 local broken_delegations = Delegation:new_selector()

47 :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")

48 :join("member", nil, "delegation.trustee_id = member.id")

49 :add_where{"delegation.truster_id = ?", member.id}

50 :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }

52 if broken_delegations:count() > 0 then

53 tabs[#tabs+1] = {

54 class = "red",

55 name = "broken_delegations",

56 label = _"Delegation problems" .. " (" .. tostring(broken_delegations:count()) .. ")",

57 icon = { static = "icons/16/table_go.png" },

58 module = "delegation",

59 view = "_list",

60 params = { delegations_selector = broken_delegations, outgoing = true },

61 }

62 end

64 local selector = Area:new_selector()

65 :reset_fields()

66 :join("privilege", nil, { "privilege.unit_id = area.unit_id AND privilege.member_id = ? AND privilege.voting_right", app.session.member_id })

67 :add_field("area.id", nil, { "grouped" })

68 :add_field("area.name", nil, { "grouped" })

69 :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })

70 :add_field("count(issue.id)", "issues_to_vote_count")

71 :add_field("count(interest.member_id)", "interested_issues_to_vote_count")

72 :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")

73 :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")

74 :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })

75 :add_where{ "direct_voter.member_id ISNULL" }

76 :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })

77 :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })

79 local not_voted_areas = {}

80 local issues_to_vote_count = 0

81 for i, area in ipairs(selector:exec()) do

82 if area.is_member or area.interested_issues_to_vote_count > 0 then

83 not_voted_areas[#not_voted_areas+1] = area

84 end

85 if area.is_member then

86 issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum

87 end

88 end

90 if issues_to_vote_count > 0 then

91 tabs[#tabs+1] = {

92 class = "yellow",

93 name = "not_voted_issues",

94 label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",

95 icon = { static = "icons/16/email_open.png" },

96 module = "index",

97 view = "_not_voted_issues",

98 params = {

99 areas = not_voted_areas

100 }

101 }

102 end

103

104 local initiator_invites_selector = Initiative:new_selector()

105 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")

106 :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })

107 :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")

108

109 if initiator_invites_selector:count() > 0 then

110 tabs[#tabs+1] = {

111 class = "yellow",

112 name = "initiator_invites",

113 label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",

114 icon = { static = "icons/16/user_add.png" },

115 module = "index",

116 view = "_initiator_invites",

117 params = {

118 initiatives_selector = initiator_invites_selector

119 }

120 }

121 end

122

123 local updated_drafts_selector = Initiative:new_selector()

124 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")

125 :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")

126 :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })

127 :add_where("initiative.revoked ISNULL")

128

129 if updated_drafts_selector:count() > 0 then

130 tabs[#tabs+1] = {

131 class = "yellow",

132 name = "updated_drafts",

133 label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",

134 icon = { static = "icons/16/script.png" },

135 module = "index",

136 view = "_updated_drafts",

137 params = {

138 initiatives_selector = updated_drafts_selector