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 filters = execute.load_chunk{module="issue", chunk="_filters.lua", params = {

38 for_events = true,

39 member = app.session.member, for_member = for_member, state = for_state, for_unit = for_unit and true or false, for_area = for_area and true or false

40 }}

41

42 filters.opened = true

43 filters.selector = event_selector

44

45 filters.content = function()

46

47

48 local last_event_id

49

50 local events = event_selector:exec()

51

52 local issues = events:load("issue")

53 issues:load_everything_for_member_id(app.session.member_id)

54

55 events:load("initiative")

56 events:load("suggestion")

57 events:load("member")

58

59

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

61

62 local last_event_date

63 for i, event in ipairs(events) do

64 last_event_id = event.id

65

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

67 local event_name = event.event_name

68 local event_image

69 if event.event == "issue_state_changed" then

70 if event.state == "discussion" then

71 event_name = _"Discussion started"

72 event_image = "comments.png"

73 elseif event.state == "verification" then

74 event_name = _"Verification started"

75 event_image = "lock.png"

76 elseif event.state == "voting" then

77 event_name = _"Voting started"

78 event_image = "email_open.png"

79 elseif event.state == "finished_with_winner" then

80 event_name = event.state_name

81 event_image = "award_star_gold_2.png"

82 elseif event.state == "finished_without_winner" then

83 event_name = event.state_name

84 event_image = "cross.png"

85 else

86 event_name = event.state_name

87 end

88 if event_image then

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

90 slot.put(" ")

91 end

92 end

93 local days_ago_text

94 if event.time_ago == 0 then

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

96 elseif event.time_ago == 1 then

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

98 else

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

100 end

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

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

103 ui.tag{ content = days_ago_text }

104 --[[ if event.time_ago > 1 then

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

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

107 slot.put(")")

108 end

109 --]]

110 if app.session:has_access("authors_pseudonymous") and event.member_id then

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

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

113 if app.session.member_id then

114 ui.link{

115 content = function()

116 execute.view{

117 module = "member_image",

118 view = "_show",

119 params = {

120 member = event.member,

121 image_type = "avatar",

122 show_dummy = true,

123 class = "micro_avatar",

124 popup_text = text

125 }

126 }

127 end,

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

129 }

130 slot.put(" ")

131 end

132 ui.link{

133 text = event.member.name,

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

135 }

136 end

137 end }

138

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

140

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

142

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

144 ui.link{

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

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

147 }

148 slot.put(" ")

149 ui.link{

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

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

152 }

153 end }

154

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

156 ui.link{

157 attr = { class = "issue_id" },

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

159 module = "issue",

160 view = "show",

161 id = event.issue_id

162 }

163 end }

164

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

166 if not event.initiative_id then

167 local initiatives_selector = Initiative:new_selector()

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

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

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

171 issue = event.issue,

172 initiatives_selector = initiatives_selector,

173 no_sort = true,

174 limit = 5

175 } }

176 else

177 local initiatives_selector = Initiative:new_selector()

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

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

180 initiatives_selector = initiatives_selector,

181 no_sort = true,

182 hide_more_initiatives = true

183 } }

184 end

185 end }

186

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

188 if event.suggestion_id then

189 ui.link{

190 text = event.suggestion.name,

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

192 }

193 end

194 end }

195 end }

196 end

197

198 end }

199

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

201

202 if #events > 0 then

203 ui.link{

204 attr = { class = "more_events_links" },

205 text = _"Show older events",

206 module = request.get_module(),

207 view = request.get_view(),

208 id = for_unit and for_unit.id or for_area and for_area.id,

209 params = {

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

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

212 event_max_id = last_event_id

213 }

214 }

215 else

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

217 end

218

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

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

221

222 end

223

224

225 ui.filters(filters)