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

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

3 local for_unit = param.get("for_unit", "table")

4 local for_area = param.get("for_area", "table")

5 local event_max_id = param.get_all_cgi()["event_max_id"]

6 local event_selector = Event:new_selector()

7 :add_order_by("event.id DESC")

8 :limit(25)

9 :join("issue", nil, "issue.id = event.issue_id")

10 :add_field("now()::date - event.occurrence::date", "time_ago")

11

12 if event_max_id then

13 event_selector:add_where{ "event.id < ?", event_max_id }

14 end

15

16 if for_member then

17 event_selector:add_where{ "event.member_id = ?", for_member.id }

18 elseif for_unit then

19 event_selector:join("area", nil, "area.id = issue.area_id")

20 event_selector:add_where{ "area.unit_id = ?", for_unit.id }

21 elseif for_area then

22 event_selector:add_where{ "issue.area_id = ?", for_area.id }

23 elseif not global then

24 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 })

25 end

26

27 if app.session.member_id then

28 event_selector

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

30 :add_field("(_interest.member_id NOTNULL)", "is_interested")

31 :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 } )

32 :add_field("_delegating_interest.delegate_member_ids[1]", "is_interested_by_delegation_to_member_id")

33 :add_field("_delegating_interest.delegate_member_ids[array_upper(_delegating_interest.delegate_member_ids, 1)]", "is_interested_via_member_id")

34 :add_field("array_length(_delegating_interest.delegate_member_ids, 1)", "delegation_chain_length")

35 end

36

37 local last_event_id

38

39 local events = event_selector:exec()

40

41 ui.container{ attr = { class = "issues events" }, content = function()

42

43 local last_event_date

44 for i, event in ipairs(events) do

45 last_event_id = event.id

46 event.issue:load_everything_for_member_id(app.session.member_id)

47

48 ui.container{ attr = { class = "event_info" }, content = function()

49 if (app.session.member_id or config.public_access == "pseudonym") and event.member_id then

50 if app.session.member_id then

51 ui.link{

52 content = function()

53 execute.view{

54 module = "member_image",

55 view = "_show",

56 params = {

57 member = event.member,

58 image_type = "avatar",

59 show_dummy = true,

60 class = "micro_avatar",

61 popup_text = text

62 }

63 }

64 end,

65 module = "member", view = "show", id = event.member_id

66 }

67 slot.put(" ")

68 end

69 ui.link{

70 text = event.member.name,

71 module = "member", view = "show", id = event.member_id

72 }

73 slot.put(" &middot; ")

74 end

75 local event_name = event.event_name

76 local event_image

77 if event.event == "issue_state_changed" then

78 if event.state == "discussion" then

79 event_name = _"Discussion started"

80 event_image = "comments.png"

81 elseif event.state == "verification" then

82 event_name = _"Verification started"

83 event_image = "lock.png"

84 elseif event.state == "voting" then

85 event_name = _"Voting started"

86 event_image = "email_open.png"

87 else

88 event_name = event.state_name

89 end

90 if event_image then

91 ui.image{ static = "icons/16/" .. event_image }

92 slot.put(" ")

93 end

94 end

95 local days_ago_text

96 if event.time_ago == 0 then

97 days_ago_text = _("Today at #{time}", { time = format.time(event.occurrence) })

98 elseif event.time_ago == 1 then

99 days_ago_text = _("Yesterday at #{time}", { time = format.time(event.occurrence) })

100 else

101 days_ago_text = _("#{date} at #{time}", { date = format.date(event.occurrence.date), time = format.time(event.occurrence) })

102 end

103 ui.tag{ attr = { class = "event_name" }, content = event_name }

104 slot.put(" &middot; ")

105 ui.tag{ content = days_ago_text }

106 if event.time_ago > 1 then

107 slot.put(" (")

108 ui.tag{ content = _("#{count} days ago", { count = event.time_ago }) }

109 slot.put(")")

110 end

111 end }

112

113 ui.container{ attr = { class = "issue" }, content = function()

114

115 execute.view{ module = "delegation", view = "_info", params = { issue = event.issue } }

116

117 ui.container{ attr = { class = "content" }, content = function()

118 ui.link{

119 module = "unit", view = "show", id = event.issue.area.unit_id,

120 attr = { class = "unit_link" }, text = event.issue.area.unit.name

121 }

122 slot.put(" ")

123 ui.link{

124 module = "area", view = "show", id = event.issue.area_id,

125 attr = { class = "area_link" }, text = event.issue.area.name

126 }

127 end }

128

129 ui.container{ attr = { class = "title" }, content = function()

130 ui.link{

131 attr = { class = "issue_id" },

132 text = _("#{policy} ##{id}", { policy = event.issue.policy.name, id = event.issue_id }),

133 module = "issue",

134 view = "show",

135 id = event.issue_id

136 }

137 end }

138

139 if event.suggestion_id then

140 ui.container{ attr = { class = "suggestion" }, content = function()

141 ui.link{

142 text = event.suggestion.name,

143 module = "suggestion", view = "show", id = event.suggestion_id

144 }

145 end }

146 end

147

148 ui.container{ attr = { class = "initiative_list" }, content = function()

149 if not event.initiative_id then

150 local initiatives_selector = Initiative:new_selector()

151 :add_where{ "initiative.issue_id = ?", event.issue_id }

152 :add_order_by("initiative.rank, initiative.supporter_count DESC")

153 execute.view{ module = "initiative", view = "_list", params = {

154 issue = event.issue,

155 initiatives_selector = initiatives_selector,

156 no_sort = true,

157 limit = 3

158 } }

159 else

160 local initiatives_selector = Initiative:new_selector()

161 :add_where{ "initiative.id = ?", event.initiative_id }

162 execute.view{ module = "initiative", view = "_list", params = {

163 issue = event.issue,

164 initiatives_selector = initiatives_selector,

165 no_sort = true,

166 limit = 1

167 } }

168 end

169 end }

170

171 --[[

172 if event.initiative_id then

173 ui.container{ attr = { class = "initiative_id" }, content = event.initiative_id }

174 end

175 if event.draft_id then

176 ui.container{ attr = { class = "draft_id" }, content = event.draft_id }

177 end

178 if event.suggestion_id then

179 ui.container{ attr = { class = "suggestion_id" }, content = event.suggestion_id }

180 end

181 --]]

182

183 end }

184 end

185

186 end }

187

188 slot.put("<br />")

189

190 if #events > 0 then

191 ui.link{

192 text = _"Show older events",

193 module = request.get_module(),

194 view = request.get_view(),

195 id = param.get_id(),

196 params = {

197 tab = param.get_all_cgi()["tab"],

198 events = param.get_all_cgi()["events"],

199 event_max_id = last_event_id

200 }

201 }

202 else

203 ui.tag{ content = _"No more events available" }

204 end

205

206 slot.put("<br />")

207 slot.put("<br />")