liquid_feedback_frontend: abcac05b1091 app/main/issue/

124 selector:add_where({ "EXISTS (SELECT 1 FROM initiative JOIN supporter ON supporter.initiative_id = initiative.id AND supporter.member_id = ? LEFT JOIN opinion ON opinion.initiative_id = initiative.id AND opinion.member_id = ? AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled)) WHERE initiative.issue_id = issue.id AND opinion.member_id ISNULL LIMIT 1)", app.session.member.id, app.session.member.id })

125 end

126 },

127 {

128 name = "potentially_supported",

129 label = _"Potential supported",

130 selector_modifier = function(selector)

131 selector:add_where({ "EXISTS (SELECT 1 FROM initiative JOIN supporter ON supporter.initiative_id = initiative.id AND supporter.member_id = ? JOIN opinion ON opinion.initiative_id = initiative.id AND opinion.member_id = ? AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled)) WHERE initiative.issue_id = issue.id LIMIT 1)", app.session.member.id, app.session.member.id })

132 end

133 },

134 {

135 name = "initiated",

136 label = _"Initiated",

137 selector_modifier = function(selector)

138 selector:add_where({ "EXISTS (SELECT 1 FROM initiative JOIN initiator ON initiator.initiative_id = initiative.id AND initiator.member_id = ? WHERE initiative.issue_id = issue.id)", app.session.member.id })

139 end

140 },

141 }

142

143 if not param.get("no_sort", atom.boolean) then

144 filters[#filters+1] = {

145 label = _"Order by",

146 name = "issue_list",

147 {

148 name = "max_potential_support",

149 label = _"Max potential support",

150 selector_modifier = function(selector)

151 selector:add_order_by("(SELECT max(supporter_count) FROM initiative WHERE initiative.issue_id = issue.id) DESC")

152 end

153 },

154 {

155 name = "max_support",

156 label = _"Max support",

157 selector_modifier = function(selector)

158 selector:add_order_by("(SELECT max(satisfied_supporter_count) FROM initiative WHERE initiative.issue_id = issue.id) DESC")

159 end

160 },

161 {

162 name = "population",

163 label = _"Population",

164 selector_modifier = function(selector)

165 selector:add_order_by("issue.population DESC")

166 end

167 },

168 {

169 name = "newest",

170 label = _"Newest",

171 selector_modifier = function(selector)

172 selector:add_order_by("issue.created DESC")

173 end

174 },

175 {

176 name = "oldest",

177 label = _"Oldest",

178 selector_modifier = function(selector)

179 selector:add_order_by("issue.created")

180 end

181 }

182 }

183 end

184

185 filters.content = function()

186 local ui_paginate = ui.paginate

187 if param.get("per_page") == "all" then

188 ui_paginate = function(args) args.content() end

189 end

190 ui_paginate{

191 per_page = tonumber(param.get("per_page")),

192 selector = issues_selector,

193 content = function()

194 local highlight_string = param.get("highlight_string", "string")

195 local issues = issues or issues_selector:exec()

196 -- issues:load(initiatives)

197 ui.list{

198 attr = { class = "issues" },

199 records = issues,

200 columns = {

201 {

202 label = _"Issue",

203 content = function(record)

204 if not param.get("for_area_list", atom.boolean) then

205 ui.field.text{

206 value = record.area.name

207 }

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

209 end

210 if record.is_interested then

211 local label = _"You are interested in this issue",

212 ui.image{

213 attr = { alt = label, title = label },

214 static = "icons/16/eye.png"

215 }

216 slot.put(" ")

217 end

218 ui.link{

219 text = _("Issue ##{id}", { id = tostring(record.id) }),

220 module = "issue",

221 view = "show",

222 id = record.id

223 }

224 if record.state == "new" then

225 ui.image{

226 static = "icons/16/new.png"

227 }

228 end

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

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

231 if record.old_state then

232 ui.field.text{ value = format.time(record.sort) }

233 ui.field.text{ value = Issue:get_state_name_for_state(record.old_state) .. " > " .. Issue:get_state_name_for_state(record.new_state) }

234 else

235 end

236 end

237 },

238 {

239 label = _"State",

240 content = function(record)

241 if record.state == "voting" then

242 ui.link{

243 content = _"Voting",

244 module = "vote",

245 view = "list",

246 params = { issue_id = record.id }

247 }

248 else

249 ui.field.issue_state{ value = record.state }

250 end

251 end

252 },

253 {

254 label = _"Initiatives",

255 content = function(record)

256 local initiatives_selector = record:get_reference_selector("initiatives")

257 local highlight_string = param.get("highlight_string")

258 if highlight_string then

259 initiatives_selector:add_field( {'"highlight"("initiative"."name", ?)', highlight_string }, "name_highlighted")

260 end

261 execute.view{

262 module = "initiative",

263 view = "_list",

264 params = {

265 issue = record,

266 initiatives_selector = initiatives_selector,

267 highlight_string = highlight_string,

268 per_page = tonumber(app.session.member:get_setting_value("initiatives_preview_limit") or 3),

269 no_sort = true,

270 limit = tonumber(app.session.member:get_setting_value("initiatives_preview_limit") or 3)

271 }

272 }

273 end

274 },

275 }

276 }

277 end

278 }

279 end

280

281 filters.selector = issues_selector

282 filters.label = _"Change filters and order"

283

284 if param.get("no_filter", atom.boolean) then

285 filters.content()

286 else

287 ui.filters(filters)

288 end

289

290 if param.get("legend", atom.boolean) ~= false then

291 local filter = param.get_all_cgi().filter

292 if not filter or filter == "any" or filter ~= "finished" then

293 ui.bargraph_legend{

294 width = 25,

295 bars = {

296 { color = "#0a0", label = _"Supporter" },

297 { color = "#777", label = _"Potential supporter" },

298 { color = "#ddd", label = _"No support at all" },

299 }

300 }

301 end

302 if not filter or filter == "any" or filter == "finished" then

303 ui.bargraph_legend{

304 width = 25,

305 bars = {

306 { color = "#0a0", label = _"Yes" },

307 { color = "#aaa", label = _"Abstention" },

308 { color = "#a00", label = _"No" },

309 }

310 }

311 end

312 end

313