liquid_feedback_frontend
annotate model/issue.lua @ 5:afd9f769c7ae
Version beta1
Final voting with Schulze-Method is now possible
Many bug fixes and code cleanup
Registration with invite codes
More sort and filter options
Seperated display of "supporters" and "potential supporters"
Optical changes
Flood limit / initiative contigent is now checked by frontend
Neccessary changes to access core beta11
Final voting with Schulze-Method is now possible
Many bug fixes and code cleanup
Registration with invite codes
More sort and filter options
Seperated display of "supporters" and "potential supporters"
Optical changes
Flood limit / initiative contigent is now checked by frontend
Neccessary changes to access core beta11
| author | bsw/jbe |
|---|---|
| date | Fri Dec 25 12:00:00 2009 +0100 (2009-12-25) |
| parents | 768faea1096d |
| children | 8d91bccab0bf |
| rev | line source |
|---|---|
| bsw/jbe@0 | 1 Issue = mondelefant.new_class() |
| bsw/jbe@0 | 2 Issue.table = 'issue' |
| bsw/jbe@0 | 3 |
| bsw/jbe@0 | 4 Issue:add_reference{ |
| bsw/jbe@0 | 5 mode = 'm1', |
| bsw/jbe@0 | 6 to = "Area", |
| bsw/jbe@0 | 7 this_key = 'area_id', |
| bsw/jbe@0 | 8 that_key = 'id', |
| bsw/jbe@0 | 9 ref = 'area', |
| bsw/jbe@0 | 10 } |
| bsw/jbe@0 | 11 |
| bsw/jbe@0 | 12 Issue:add_reference{ |
| bsw/jbe@0 | 13 mode = 'm1', |
| bsw/jbe@0 | 14 to = "Policy", |
| bsw/jbe@0 | 15 this_key = 'policy_id', |
| bsw/jbe@0 | 16 that_key = 'id', |
| bsw/jbe@0 | 17 ref = 'policy', |
| bsw/jbe@0 | 18 } |
| bsw/jbe@0 | 19 |
| bsw/jbe@0 | 20 Issue:add_reference{ |
| bsw/jbe@0 | 21 mode = '1m', |
| bsw/jbe@0 | 22 to = "Initiative", |
| bsw/jbe@0 | 23 this_key = 'id', |
| bsw/jbe@0 | 24 that_key = 'issue_id', |
| bsw/jbe@0 | 25 ref = 'initiatives', |
| bsw/jbe@0 | 26 back_ref = 'issue' |
| bsw/jbe@0 | 27 } |
| bsw/jbe@0 | 28 |
| bsw/jbe@0 | 29 Issue:add_reference{ |
| bsw/jbe@0 | 30 mode = '1m', |
| bsw/jbe@0 | 31 to = "Interest", |
| bsw/jbe@0 | 32 this_key = 'id', |
| bsw/jbe@0 | 33 that_key = 'issue_id', |
| bsw/jbe@0 | 34 ref = 'interests', |
| bsw/jbe@0 | 35 back_ref = 'issue', |
| bsw/jbe@0 | 36 default_order = '"id"' |
| bsw/jbe@0 | 37 } |
| bsw/jbe@0 | 38 |
| bsw/jbe@0 | 39 Issue:add_reference{ |
| bsw/jbe@0 | 40 mode = '1m', |
| bsw/jbe@0 | 41 to = "Supporter", |
| bsw/jbe@0 | 42 this_key = 'id', |
| bsw/jbe@0 | 43 that_key = 'issue_id', |
| bsw/jbe@0 | 44 ref = 'supporters', |
| bsw/jbe@0 | 45 back_ref = 'issue', |
| bsw/jbe@0 | 46 default_order = '"id"' |
| bsw/jbe@0 | 47 } |
| bsw/jbe@0 | 48 |
| bsw/jbe@0 | 49 Issue:add_reference{ |
| bsw/jbe@0 | 50 mode = '1m', |
| bsw/jbe@0 | 51 to = "DirectVoter", |
| bsw/jbe@0 | 52 this_key = 'id', |
| bsw/jbe@0 | 53 that_key = 'issue_id', |
| bsw/jbe@0 | 54 ref = 'direct_voters', |
| bsw/jbe@0 | 55 back_ref = 'issue', |
| bsw/jbe@0 | 56 default_order = '"member_id"' |
| bsw/jbe@0 | 57 } |
| bsw/jbe@0 | 58 |
| bsw/jbe@0 | 59 Issue:add_reference{ |
| bsw/jbe@0 | 60 mode = '1m', |
| bsw/jbe@0 | 61 to = "Vote", |
| bsw/jbe@0 | 62 this_key = 'id', |
| bsw/jbe@0 | 63 that_key = 'issue_id', |
| bsw/jbe@0 | 64 ref = 'votes', |
| bsw/jbe@0 | 65 back_ref = 'issue', |
| bsw/jbe@0 | 66 default_order = '"member_id", "initiative_id"' |
| bsw/jbe@0 | 67 } |
| bsw/jbe@0 | 68 |
| bsw/jbe@0 | 69 Issue:add_reference{ |
| bsw@2 | 70 mode = '1m', |
| bsw@2 | 71 to = "Delegation", |
| bsw@2 | 72 this_key = 'id', |
| bsw@2 | 73 that_key = 'issue_id', |
| bsw@2 | 74 ref = 'delegations', |
| bsw@2 | 75 back_ref = 'issue' |
| bsw@2 | 76 } |
| bsw@2 | 77 |
| bsw@2 | 78 Issue:add_reference{ |
| bsw/jbe@0 | 79 mode = 'mm', |
| bsw/jbe@0 | 80 to = "Member", |
| bsw/jbe@0 | 81 this_key = 'id', |
| bsw/jbe@0 | 82 that_key = 'id', |
| bsw/jbe@0 | 83 connected_by_table = 'interest', |
| bsw/jbe@0 | 84 connected_by_this_key = 'issue_id', |
| bsw/jbe@0 | 85 connected_by_that_key = 'member_id', |
| bsw/jbe@0 | 86 ref = 'members' |
| bsw/jbe@0 | 87 } |
| bsw/jbe@0 | 88 |
| bsw@3 | 89 Issue:add_reference{ |
| bsw@3 | 90 mode = 'mm', |
| bsw@3 | 91 to = "Member", |
| bsw@3 | 92 this_key = 'id', |
| bsw@3 | 93 that_key = 'id', |
| bsw@3 | 94 connected_by_table = 'direct_interest_snapshot', |
| bsw@3 | 95 connected_by_this_key = 'issue_id', |
| bsw@3 | 96 connected_by_that_key = 'member_id', |
| bsw@3 | 97 ref = 'interested_members_snapshot' |
| bsw@3 | 98 } |
| bsw@3 | 99 |
| bsw/jbe@0 | 100 function Issue:get_state_name_for_state(value) |
| bsw@2 | 101 local state_name_table = { |
| bsw@2 | 102 new = _"New", |
| bsw@3 | 103 accepted = _"Discussion", |
| bsw@2 | 104 frozen = _"Frozen", |
| bsw@2 | 105 voting = _"Voting", |
| bsw@2 | 106 finished = _"Finished", |
| bsw@2 | 107 cancelled = _"Cancelled" |
| bsw@2 | 108 } |
| bsw/jbe@0 | 109 return state_name_table[value] or value |
| bsw/jbe@0 | 110 end |
| bsw/jbe@0 | 111 |
| bsw@2 | 112 function Issue:get_search_selector(search_string) |
| bsw/jbe@0 | 113 return self:new_selector() |
| bsw/jbe@0 | 114 :join('"initiative"', nil, '"initiative"."issue_id" = "issue"."id"') |
| bsw@2 | 115 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?)', search_string } |
| bsw/jbe@0 | 116 :set_distinct() |
| bsw/jbe@0 | 117 end |
| bsw/jbe@0 | 118 |
| bsw/jbe@0 | 119 function Issue.object_get:state() |
| bsw/jbe@0 | 120 if self.accepted then |
| bsw@3 | 121 if self.closed then |
| bsw/jbe@5 | 122 return "finished" |
| bsw@3 | 123 elseif self.fully_frozen then |
| bsw@3 | 124 return "voting" |
| bsw@3 | 125 elseif self.half_frozen then |
| bsw@3 | 126 return "frozen" |
| bsw/jbe@0 | 127 else |
| bsw/jbe@0 | 128 return "accepted" |
| bsw/jbe@0 | 129 end |
| bsw/jbe@0 | 130 else |
| bsw/jbe@0 | 131 if self.closed then |
| bsw@2 | 132 return "cancelled" |
| bsw/jbe@0 | 133 else |
| bsw/jbe@0 | 134 return "new" |
| bsw/jbe@0 | 135 end |
| bsw/jbe@0 | 136 end |
| bsw@2 | 137 end |
| bsw@2 | 138 |
| bsw@2 | 139 function Issue.object_get:state_name() |
| bsw@2 | 140 return Issue:get_state_name_for_state(self.state) |
| bsw@2 | 141 end |
| bsw@2 | 142 |
| bsw@2 | 143 function Issue.object_get:state_time_left() |
| bsw@2 | 144 local state = self.state |
| bsw@2 | 145 local last_event_time |
| bsw@2 | 146 local duration |
| bsw@2 | 147 if state == "new" then |
| bsw@2 | 148 last_event_time = self.created |
| bsw@2 | 149 duration = self.policy.admission_time |
| bsw@2 | 150 elseif state == "accepted" then |
| bsw@2 | 151 last_event_time = self.accepted |
| bsw@2 | 152 duration = self.policy.discussion_time |
| bsw@2 | 153 elseif state == "frozen" then |
| bsw@2 | 154 last_event_time = self.half_frozen |
| bsw@2 | 155 duration = self.policy.verification_time |
| bsw@2 | 156 elseif state == "voting" then |
| bsw@2 | 157 last_event_time = self.fully_frozen |
| bsw@2 | 158 duration = self.policy.voting_time |
| bsw@2 | 159 end |
| bsw@2 | 160 return db:query{ "SELECT ?::timestamp + ?::interval - now() as time_left", last_event_time, duration }[1].time_left |
| bsw@2 | 161 end |
| bsw@2 | 162 |
| bsw@2 | 163 function Issue.object_get:next_states() |
| bsw@2 | 164 local state = self.state |
| bsw@2 | 165 local next_states |
| bsw@2 | 166 if state == "new" then |
| bsw@2 | 167 next_states = { "accepted", "cancelled" } |
| bsw@2 | 168 elseif state == "accepted" then |
| bsw@2 | 169 next_states = { "frozen" } |
| bsw@2 | 170 elseif state == "frozen" then |
| bsw@2 | 171 next_states = { "voting" } |
| bsw@2 | 172 elseif state == "voting" then |
| bsw@2 | 173 next_states = { "finished" } |
| bsw@2 | 174 end |
| bsw@2 | 175 return next_states |
| bsw@2 | 176 end |
| bsw@2 | 177 |
| bsw@2 | 178 function Issue.object_get:next_states_names() |
| bsw@2 | 179 local next_states = self.next_states |
| bsw@2 | 180 if not next_states then |
| bsw@2 | 181 return |
| bsw@2 | 182 end |
| bsw@2 | 183 local state_names = {} |
| bsw@2 | 184 for i, state in ipairs(self.next_states) do |
| bsw@2 | 185 state_names[#state_names+1] = Issue:get_state_name_for_state(state) |
| bsw@2 | 186 end |
| bsw@2 | 187 return table.concat(state_names, ", ") |
| bsw/jbe@0 | 188 end |