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 local issues = events:load("issue")

42 issues:load_everything_for_member_id(app.session.member_id)

43

44 events:load("initiative")

45 events:load("suggestion")

46 events:load("member")

47

48

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

50

51 local last_event_date

52 for i, event in ipairs(events) do

53 last_event_id = event.id

54

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

56 local event_name = event.event_name

57 local event_image

58 if event.event == "issue_state_changed" then

59 if event.state == "discussion" then

60 event_name = _"Discussion started"

61 event_image = "comments.png"

62 elseif event.state == "verification" then

63 event_name = _"Verification started"

64 event_image = "lock.png"

65 elseif event.state == "voting" then

66 event_name = _"Voting started"

67 event_image = "email_open.png"

68 elseif event.state == "finished_with_winner" then

69 event_name = event.state_name

70 event_image = "award_star_gold_2.png"

71 elseif event.state == "finished_without_winner" then

72 event_name = event.state_name

73 event_image = "cross.png"

74 else

75 event_name = event.state_name

76 end

77 if event_image then

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

79 slot.put(" ")

80 end

81 end

82 local days_ago_text

83 if event.time_ago == 0 then

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

85 elseif event.time_ago == 1 then

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

87 else

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

89 end

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

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

92 ui.tag{ content = days_ago_text }

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

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

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

96 slot.put(")")

97 end

98 --]]

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

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

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

102 if app.session.member_id then

103 ui.link{

104 content = function()

105 execute.view{

106 module = "member_image",

107 view = "_show",

108 params = {

109 member = event.member,

110 image_type = "avatar",

111 show_dummy = true,

112 class = "micro_avatar",

113 popup_text = text

114 }

115 }

116 end,

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

118 }

119 slot.put(" ")

120 end

121 ui.link{

122 text = event.member.name,

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

124 }

125 end

126 end }

127

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

129

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

131

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

133 ui.link{

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

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

136 }

137 slot.put(" ")

138 ui.link{

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

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

141 }

142 end }

143

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

145 ui.link{

146 attr = { class = "issue_id" },

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

148 module = "issue",

149 view = "show",

150 id = event.issue_id

151 }

152 end }

153

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

155 if not event.initiative_id then

156 local initiatives_selector = Initiative:new_selector()

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

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

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

160 issue = event.issue,

161 initiatives_selector = initiatives_selector,

162 no_sort = true,

163 limit = 5

164 } }

165 else

166 local initiatives_selector = Initiative:new_selector()

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

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

169 issue = event.issue,

170 initiatives_selector = initiatives_selector,

171 no_sort = true,

172 limit = 1,

173 hide_more_initiatives = true

174 } }

175 end

176 end }

177

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

179 if event.suggestion_id then

180 ui.link{

181 text = event.suggestion.name,

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

183 }

184 end

185 end }

186 end }

187 end

188

189 end }

190

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

192

193 if #events > 0 then

194 ui.link{

195 text = _"Show older events",

196 module = request.get_module(),

197 view = request.get_view(),

198 id = param.get_id(),

199 params = {

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

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

202 event_max_id = last_event_id

203 }

204 }

205 else

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

207 end

208

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

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