liquid_feedback_frontend: a4f4e783c67c model/issue.lua

liquid_feedback_frontend

view model/issue.lua @ 754:a4f4e783c67c

Updated german translations

author	bsw
date	Thu Jun 28 22:44:54 2012 +0200 (2012-06-28)
parents	c4b878748205
children	3c91b7678cab

line source

1 Issue = mondelefant.new_class()

2 Issue.table = 'issue'

4 local new_selector = Issue.new_selector

6 function Issue:new_selector()

7 local selector = new_selector(self)

8 selector:add_field("coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now()", "state_time_left")

9 return selector

10 end

12 Issue:add_reference{

13 mode = 'm1',

14 to = "Area",

15 this_key = 'area_id',

16 that_key = 'id',

17 ref = 'area',

18 }

20 Issue:add_reference{

21 mode = 'm1',

22 to = "Policy",

23 this_key = 'policy_id',

24 that_key = 'id',

25 ref = 'policy',

26 }

28 Issue:add_reference{

29 mode = '1m',

30 to = "Initiative",

31 this_key = 'id',

32 that_key = 'issue_id',

33 ref = 'initiatives',

34 back_ref = 'issue',

35 default_order = 'initiative.rank, initiative.supporter_count DESC, id'

36 }

38 Issue:add_reference{

39 mode = '1m',

40 to = "Interest",

41 this_key = 'id',

42 that_key = 'issue_id',

43 ref = 'interests',

44 back_ref = 'issue',

45 default_order = '"id"'

46 }

48 Issue:add_reference{

49 mode = '1m',

50 to = "Supporter",

51 this_key = 'id',

52 that_key = 'issue_id',

53 ref = 'supporters',

54 back_ref = 'issue',

55 default_order = '"id"'

56 }

58 Issue:add_reference{

59 mode = '1m',

60 to = "DirectVoter",

61 this_key = 'id',

62 that_key = 'issue_id',

63 ref = 'direct_voters',

64 back_ref = 'issue',

65 default_order = '"member_id"'

66 }

68 Issue:add_reference{

69 mode = '1m',

70 to = "Vote",

71 this_key = 'id',

72 that_key = 'issue_id',

73 ref = 'votes',

74 back_ref = 'issue',

75 default_order = '"member_id", "initiative_id"'

76 }

78 Issue:add_reference{

79 mode = '1m',

80 to = "Delegation",

81 this_key = 'id',

82 that_key = 'issue_id',

83 ref = 'delegations',

84 back_ref = 'issue'

85 }

87 Issue:add_reference{

88 mode = 'mm',

89 to = "Member",

90 this_key = 'id',

91 that_key = 'id',

92 connected_by_table = 'interest',

93 connected_by_this_key = 'issue_id',

94 connected_by_that_key = 'member_id',

95 ref = 'members'

96 }

98 Issue:add_reference{

99 mode = 'mm',

100 to = "Member",

101 this_key = 'id',

102 that_key = 'id',

103 connected_by_table = 'direct_interest_snapshot',

104 connected_by_this_key = 'issue_id',

105 connected_by_that_key = 'member_id',

106 ref = 'interested_members_snapshot'

107 }

108

109 Issue:add_reference{

110 mode = 'mm',

111 to = "Member",

112 this_key = 'id',

113 that_key = 'id',

114 connected_by_table = 'direct_voter',

115 connected_by_this_key = 'issue_id',

116 connected_by_that_key = 'member_id',

117 ref = 'direct_voters'

118 }

119

120 Issue:add_reference{

121 mode = "11",

122 to = mondelefant.class_prototype,

123 this_key = "id",

124 that_key = "issue_id",

125 ref = "member_info",

126 back_ref = "issue",

127 selector_generator = function(list, options)

128 assert(options.member_id, "member_id mandatory for member_info")

129 local ids = { sep = ", " }

130 for i, object in ipairs(list) do

131 local id = object.id

132 if id ~= nil then

133 ids[#ids+1] = {"?", id}

134 end

135 end

136 local sub_selector = Issue:get_db_conn():new_selector()

137 if #ids == 0 then

138 return sub_selector:empty_list_mode()

139 end

140 sub_selector:from("issue")

141 sub_selector:add_field("issue.id", "issue_id")

142 sub_selector:add_field{ '(delegation_info(?, null, null, issue.id, ?)).*', options.member_id, options.trustee_id }

143 sub_selector:add_where{ 'issue.id IN ($)', ids }

144

145 local selector = Issue:get_db_conn():new_selector()

146 selector:add_from("issue")

147 selector:join(sub_selector, "delegation_info", "delegation_info.issue_id = issue.id")

148 selector:left_join("member", "first_trustee", "first_trustee.id = delegation_info.first_trustee_id")

149 selector:left_join("member", "other_trustee", "other_trustee.id = delegation_info.other_trustee_id")

150 selector:add_field("delegation_info.*")

151 selector:add_field("first_trustee.name", "first_trustee_name")

152 selector:add_field("other_trustee.name", "other_trustee_name")

153 selector:left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", options.member_id })

154 selector:add_field("direct_voter.member_id NOTNULL", "direct_voted")

155 return selector

156 end

157 }

158

159 function Issue.list:load_everything_for_member_id(member_id)

160 local areas = self:load("area")

161 areas:load("unit")

162 self:load("policy")

163 if member_id then

164 self:load("member_info", { member_id = member_id })

165 end

166 local initiatives = self:load("initiatives")

167 initiatives:load_everything_for_member_id(member_id)

168 end

169

170 function Issue.object:load_everything_for_member_id(member_id)

171 local areas = self:load("area")

172 areas:load("unit")

173 self:load("policy")

174 if member_id then

175 self:load("member_info", { member_id = member_id })

176 end

177 local initiatives = self:load("initiatives")

178 initiatives:load_everything_for_member_id(member_id)

179 end

180

181 function Issue:get_state_name_for_state(value)

182 local state_name_table = {

183 new = _"New",

184 accepted = _"Discussion",

185 frozen = _"Frozen",

186 voting = _"Voting",

187 finished = _"Finished",

188 cancelled = _"Cancelled"

189 }

190 return state_name_table[value] or value or ''

191 end

192

193 function Issue:get_search_selector(search_string)

194 return self:new_selector()

195 :join('"initiative"', nil, '"initiative"."issue_id" = "issue"."id"')

196 :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"')

197 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string }

198 :add_group_by('"issue"."id"')

199 :add_group_by('"issue"."state"')

200 :add_group_by('"issue"."area_id"')

201 :add_group_by('"issue"."policy_id"')

202 :add_group_by('"issue"."created"')

203 :add_group_by('"issue"."accepted"')

204 :add_group_by('"issue"."half_frozen"')

205 :add_group_by('"issue"."fully_frozen"')

206 :add_group_by('"issue"."closed"')

207 :add_group_by('"issue"."ranks_available"')

208 :add_group_by('"issue"."status_quo_schulze_rank"')

209 :add_group_by('"issue"."cleaned"')

210 :add_group_by('"issue"."snapshot"')

211 :add_group_by('"issue"."latest_snapshot_event"')

212 :add_group_by('"issue"."population"')

213 :add_group_by('"issue"."voter_count"')

214 :add_group_by('"issue"."admission_time"')

215 :add_group_by('"issue"."discussion_time"')

216 :add_group_by('"issue"."verification_time"')

217 :add_group_by('"issue"."voting_time"')

218 --:set_distinct()

219 end

220

221 function Issue:modify_selector_for_state(initiatives_selector, state)

222 if state == "new" then

223 initiatives_selector:add_where("issue.accepted ISNULL AND issue.closed ISNULL")

224 elseif state == "accepted" then

225 initiatives_selector:add_where("issue.accepted NOTNULL AND issue.half_frozen ISNULL AND issue.closed ISNULL")

226 elseif state == "frozen" then

227 initiatives_selector:add_where("issue.half_frozen NOTNULL AND issue.fully_frozen ISNULL AND issue.closed ISNULL")

228 elseif state == "voting" then

229 initiatives_selector:add_where("issue.fully_frozen NOTNULL AND issue.closed ISNULL")

230 elseif state == "finished" then

231 initiatives_selector:add_where("issue.fully_frozen NOTNULL AND issue.closed NOTNULL")

232 elseif state == "cancelled" then

233 initiatives_selector:add_where("issue.fully_frozen ISNULL AND issue.closed NOTNULL")

234 else

235 error("Invalid state")

236 end

237 end

238

239 function Issue.object_get:state()

240 if self.closed then

241 if self.fully_frozen then

242 return "finished"

243 else

244 return "cancelled"

245 end

246 elseif self.fully_frozen then

247 return "voting"

248 elseif self.half_frozen then

249 return "frozen"

250 elseif self.accepted then

251 return "accepted"

252 else

253 return "new"

254 end

255

256 end

257

258 function Issue.object_get:state_name()

259 return Issue:get_state_name_for_state(self.state)

260 end

261

262 function Issue.object_get:next_states()

263 local state = self.state

264 local next_states

265 if state == "new" then

266 next_states = { "accepted", "cancelled" }

267 elseif state == "accepted" then

268 next_states = { "frozen" }

269 elseif state == "frozen" then

270 next_states = { "voting" }

271 elseif state == "voting" then

272 next_states = { "finished" }

273 end

274 return next_states

275 end

276

277 function Issue.object_get:next_states_names()

278 local next_states = self.next_states

279 if not next_states then

280 return

281 end

282 local state_names = {}

283 for i, state in ipairs(self.next_states) do

284 state_names[#state_names+1] = Issue:get_state_name_for_state(state)

285 end

286 return table.concat(state_names, ", ")

287 end

288

289 function Issue.object_get:etherpad_url()

290 return config.etherpad.base_url .. "p/" .. config.etherpad.group_id .. "$Issue" .. self.id

291 end