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 ui.container{ attr = { class = "issues events" }, content = function()

40

41 local last_event_date

42 for i, event in ipairs(event_selector:exec()) do

43 last_event_id = event.id

44

45 if event.occurrence.date ~= last_event_date then

46 local days_ago_text

47 if event.time_ago == 0 then

48 days_ago_text = _"Today"

49 elseif event.time_ago == 1 then

50 days_ago_text = _"Yesterday"

51 else

52 days_ago_text = _("#{count} days ago", { count = event.time_ago })

53 end

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

55 ui.tag{ content = format.date(event.occurrence.date) }

56 slot.put(" &middot; ")

57 ui.tag{ content = days_ago_text }

58 end }

59

60 last_event_date = event.occurrence.date

61 end

62 local class = "issue"

63 if event.is_interested then

64 class = class .. " interested"

65 elseif event.is_interested_by_delegation_to_member_id then

66 class = class .. " interested_by_delegation"

67 end

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

69

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

71

72 ui.container{ content = function()

73 ui.link{

74 attr = { class = "issue_id" },

75 text = _("Issue ##{id}", { id = tostring(event.issue_id) }),

76 module = "issue",

77 view = "show",

78 id = event.issue_id

79 }

80

81 slot.put(" &middot; ")

82 ui.tag{ content = event.issue.policy.name }

83 slot.put(" &middot; ")

84 ui.tag{ content = event.issue.area.name }

85 slot.put(" &middot; ")

86 ui.tag{ content = event.issue.area.unit.name }

87 end }

88

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

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

91 if app.session.member_id then

92 ui.link{

93 content = function()

94 execute.view{

95 module = "member_image",

96 view = "_show",

97 params = {

98 member = event.member,

99 image_type = "avatar",

100 show_dummy = true,

101 class = "micro_avatar",

102 popup_text = text

103 }

104 }

105 end,

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

107 }

108 slot.put(" ")

109 end

110 ui.link{

111 text = event.member.name,

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

113 }

114 slot.put(" &middot; ")

115 end

116 local event_name = event.event_name

117 local event_image

118 if event.event == "issue_state_changed" then

119 if event.state == "discussion" then

120 event_name = _"Discussion started"

121 event_image = "comments.png"

122 elseif event.state == "verification" then

123 event_name = _"Verification started"

124 event_image = "lock.png"

125 elseif event.state == "voting" then

126 event_name = _"Voting started"

127 event_image = "email_open.png"

128 else

129 event_name = event.state_name

130 end

131 if event_image then

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

133 slot.put(" ")

134 end

135 end

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

137 slot.put(" &middot; ")

138 ui.tag{ attr = { class = "time" }, content = format.time(event.occurrence) }

139 end }

140

141 end }

142

143 if event.suggestion_id then

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

145 ui.link{

146 text = event.suggestion.name,

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

148 }

149 end }

150 end

151

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

153 if not event.initiative_id then

154 local initiatives_selector = Initiative:new_selector()

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

156 :add_order_by("initiative.rank, initiative.supporter_count")

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

158 issue = event.issue,

159 initiatives_selector = initiatives_selector,

160 no_sort = true,

161 limit = 3

162 } }

163 else

164 local initiatives_selector = Initiative:new_selector()

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

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

167 issue = event.issue,

168 initiatives_selector = initiatives_selector,

169 no_sort = true,

170 limit = 1

171 } }

172 end

173 end }

174

175 --[[

176 if event.initiative_id then

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

178 end

179 if event.draft_id then

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

181 end

182 if event.suggestion_id then

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

184 end

185 --]]

186

187 end }

188 end

189

190 end }

191

192 ui.link{

193 text = _"Show older events",

194 module = request.get_module(),

195 view = request.get_view(),

196 id = param.get_id(),

197 params = {

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

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

200 event_max_id = last_event_id

201 }

202 }

203

204

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

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