| rev |
line source |
|
bsw/jbe@0
|
1 local issue
|
|
bsw/jbe@0
|
2 local area
|
|
bsw/jbe@0
|
3
|
|
bsw/jbe@0
|
4 local issue_id = param.get("issue_id", atom.integer)
|
|
bsw/jbe@0
|
5 if issue_id then
|
|
bsw@969
|
6 issue = Issue:new_selector():add_where{"id=?",issue_id}:for_share():single_object_mode():exec()
|
|
bsw/jbe@5
|
7 if issue.closed then
|
|
bsw/jbe@5
|
8 slot.put_into("error", _"This issue is already closed.")
|
|
bsw/jbe@5
|
9 return false
|
|
bsw/jbe@5
|
10 elseif issue.fully_frozen then
|
|
bsw/jbe@5
|
11 slot.put_into("error", _"Voting for this issue has already begun.")
|
|
bsw/jbe@5
|
12 return false
|
|
bsw@967
|
13 elseif issue.phase_finished then
|
|
bsw@967
|
14 slot.put_into("error", _"Current phase is already closed.")
|
|
bsw@967
|
15 return false
|
|
bsw/jbe@5
|
16 end
|
|
bsw/jbe@0
|
17 area = issue.area
|
|
bsw/jbe@0
|
18 else
|
|
bsw/jbe@0
|
19 local area_id = param.get("area_id", atom.integer)
|
|
bsw/jbe@0
|
20 area = Area:new_selector():add_where{"id=?",area_id}:single_object_mode():exec()
|
|
bsw/jbe@52
|
21 if not area.active then
|
|
bsw/jbe@52
|
22 slot.put_into("error", "Invalid area.")
|
|
bsw/jbe@52
|
23 return false
|
|
bsw/jbe@52
|
24 end
|
|
bsw/jbe@0
|
25 end
|
|
bsw/jbe@0
|
26
|
|
bsw@281
|
27 if not app.session.member:has_voting_right_for_unit_id(area.unit_id) then
|
|
bsw@281
|
28 error("access denied")
|
|
bsw@281
|
29 end
|
|
bsw@281
|
30
|
|
bsw@904
|
31 local policy_id = param.get("policy_id", atom.integer)
|
|
bsw@904
|
32 local policy
|
|
bsw@904
|
33 if policy_id then
|
|
bsw@904
|
34 policy = Policy:by_id(policy_id)
|
|
bsw@904
|
35 end
|
|
bsw@904
|
36
|
|
bsw@904
|
37 if not issue then
|
|
bsw@904
|
38 if policy_id == -1 then
|
|
bsw@904
|
39 slot.put_into("error", _"Please choose a policy")
|
|
bsw@904
|
40 return false
|
|
bsw@904
|
41 end
|
|
bsw@904
|
42 if not policy.active then
|
|
bsw@904
|
43 slot.put_into("error", "Invalid policy.")
|
|
bsw@904
|
44 return false
|
|
bsw@904
|
45 end
|
|
bsw@904
|
46 if policy.polling and not app.session.member:has_polling_right_for_unit_id(area.unit_id) then
|
|
bsw@904
|
47 error("no polling right for this unit")
|
|
bsw@904
|
48 end
|
|
bsw@904
|
49
|
|
bsw@904
|
50 if not area:get_reference_selector("allowed_policies")
|
|
bsw@904
|
51 :add_where{ "policy.id = ?", policy_id }
|
|
bsw@904
|
52 :optional_object_mode()
|
|
bsw@904
|
53 :exec()
|
|
bsw@904
|
54 then
|
|
bsw@904
|
55 error("policy not allowed")
|
|
bsw@904
|
56 end
|
|
bsw@904
|
57 end
|
|
bsw@904
|
58
|
|
bsw@904
|
59 local is_polling = (issue and param.get("polling", atom.boolean)) or (policy and policy.polling) or false
|
|
bsw@904
|
60
|
|
bsw@904
|
61 local tmp = db:query({ "SELECT text_entries_left, initiatives_left FROM member_contingent_left WHERE member_id = ? AND polling = ?", app.session.member.id, is_polling }, "opt_object")
|
|
bsw@904
|
62 if not tmp or tmp.initiatives_left < 1 then
|
|
bsw@904
|
63 slot.put_into("error", _"Sorry, your contingent for creating initiatives has been used up. Please try again later.")
|
|
bsw@904
|
64 return false
|
|
bsw@904
|
65 end
|
|
bsw@904
|
66 if tmp and tmp.text_entries_left < 1 then
|
|
bsw@904
|
67 slot.put_into("error", _"Sorry, you have reached your personal flood limit. Please be slower...")
|
|
bsw@904
|
68 return false
|
|
bsw@904
|
69 end
|
|
bsw@904
|
70
|
|
bsw/jbe@6
|
71 local name = param.get("name")
|
|
bsw/jbe@6
|
72
|
|
bsw/jbe@6
|
73 local name = util.trim(name)
|
|
bsw/jbe@6
|
74
|
|
bsw/jbe@6
|
75 if #name < 3 then
|
|
bsw@1045
|
76 slot.put_into("error", _"Please enter a meaningful title for your initiative!")
|
|
bsw@1045
|
77 return false
|
|
bsw@1045
|
78 end
|
|
bsw@1045
|
79
|
|
bsw@1045
|
80 if #name > 140 then
|
|
bsw@1045
|
81 slot.put_into("error", _"This title is too long!")
|
|
bsw/jbe@6
|
82 return false
|
|
bsw/jbe@6
|
83 end
|
|
bsw/jbe@6
|
84
|
|
bsw@1045
|
85 local formatting_engine
|
|
bsw@1045
|
86 if config.enforce_formatting_engine then
|
|
bsw@1045
|
87 formatting_engine = config.enforce_formatting_engine
|
|
bsw@1045
|
88 else
|
|
bsw@1045
|
89 formatting_engine = param.get("formatting_engine")
|
|
bsw@1045
|
90 local formatting_engine_valid = false
|
|
bsw@1045
|
91 for i, fe in ipairs(config.formatting_engines) do
|
|
bsw@1045
|
92 if formatting_engine == fe.id then
|
|
bsw@1045
|
93 formatting_engine_valid = true
|
|
bsw@1045
|
94 end
|
|
bsw@1045
|
95 end
|
|
bsw@1045
|
96 if not formatting_engine_valid then
|
|
bsw@1045
|
97 error("invalid formatting engine!")
|
|
bsw@81
|
98 end
|
|
bsw@81
|
99 end
|
|
bsw@81
|
100
|
|
bsw@1092
|
101 local timing
|
|
bsw@1096
|
102 if not issue and policy.free_timeable then
|
|
bsw@1092
|
103 local free_timing_string = util.trim(param.get("free_timing"))
|
|
bsw@1092
|
104 if not free_timing_string or #free_timing_string < 1 then
|
|
bsw@1092
|
105 slot.put_into("error", _"Choose timing")
|
|
bsw@1092
|
106 return false
|
|
bsw@1092
|
107 end
|
|
bsw@1092
|
108 local available_timings
|
|
bsw@1092
|
109 if config.free_timing and config.free_timing.available_func then
|
|
bsw@1092
|
110 available_timings = config.free_timing.available_func(policy)
|
|
bsw@1092
|
111 if available_timings == false then
|
|
bsw@1092
|
112 error("error in free timing config")
|
|
bsw@1092
|
113 end
|
|
bsw@1092
|
114 end
|
|
bsw@1092
|
115 if available_timings then
|
|
bsw@1092
|
116 local timing_available = false
|
|
bsw@1092
|
117 for i, available_timing in ipairs(available_timings) do
|
|
bsw@1092
|
118 if available_timing.id == free_timing_string then
|
|
bsw@1092
|
119 timing_available = true
|
|
bsw@1092
|
120 end
|
|
bsw@1092
|
121 end
|
|
bsw@1092
|
122 if not timing_available then
|
|
bsw@1092
|
123 slot.put_into("error", _"Invalid timing")
|
|
bsw@1092
|
124 return false
|
|
bsw@1092
|
125 end
|
|
bsw@1092
|
126 end
|
|
bsw@1092
|
127 timing = config.free_timing.calculate_func(policy, free_timing_string)
|
|
bsw@1092
|
128 if not timing then
|
|
bsw@1092
|
129 error("error in free timing config")
|
|
bsw@1092
|
130 end
|
|
bsw@1092
|
131 end
|
|
bsw@1092
|
132
|
|
bsw@1045
|
133 if param.get("preview") or param.get("edit") then
|
|
bsw@95
|
134 return
|
|
bsw@95
|
135 end
|
|
bsw@81
|
136
|
|
bsw/jbe@0
|
137 local initiative = Initiative:new()
|
|
bsw/jbe@0
|
138
|
|
bsw/jbe@0
|
139 if not issue then
|
|
bsw/jbe@0
|
140 issue = Issue:new()
|
|
bsw/jbe@0
|
141 issue.area_id = area.id
|
|
bsw@7
|
142 issue.policy_id = policy_id
|
|
bsw@898
|
143
|
|
bsw@898
|
144 if policy.polling then
|
|
bsw@898
|
145 issue.accepted = 'now'
|
|
bsw@898
|
146 issue.state = 'discussion'
|
|
bsw@898
|
147 initiative.polling = true
|
|
bsw@901
|
148
|
|
bsw@901
|
149 if policy.free_timeable then
|
|
bsw@901
|
150 issue.discussion_time = timing.discussion
|
|
bsw@901
|
151 issue.verification_time = timing.verification
|
|
bsw@901
|
152 issue.voting_time = timing.voting
|
|
bsw@901
|
153 end
|
|
bsw@901
|
154
|
|
bsw@898
|
155 end
|
|
bsw@898
|
156
|
|
bsw/jbe@0
|
157 issue:save()
|
|
bsw@286
|
158
|
|
bsw@286
|
159 if config.etherpad then
|
|
bsw@286
|
160 local result = net.curl(
|
|
bsw@286
|
161 config.etherpad.api_base
|
|
bsw@286
|
162 .. "api/1/createGroupPad?apikey=" .. config.etherpad.api_key
|
|
bsw@286
|
163 .. "&groupID=" .. config.etherpad.group_id
|
|
bsw@286
|
164 .. "&padName=Issue" .. tostring(issue.id)
|
|
jbe@326
|
165 .. "&text=" .. request.get_absolute_baseurl() .. "issue/show/" .. tostring(issue.id) .. ".html"
|
|
bsw@286
|
166 )
|
|
bsw@286
|
167 end
|
|
bsw/jbe@0
|
168 end
|
|
bsw/jbe@0
|
169
|
|
bsw@898
|
170 if param.get("polling", atom.boolean) and app.session.member:has_polling_right_for_unit_id(area.unit_id) then
|
|
bsw@898
|
171 initiative.polling = true
|
|
bsw@898
|
172 end
|
|
bsw/jbe@0
|
173 initiative.issue_id = issue.id
|
|
bsw/jbe@6
|
174 initiative.name = name
|
|
bsw/jbe@0
|
175 initiative:save()
|
|
bsw/jbe@0
|
176
|
|
bsw/jbe@0
|
177 local draft = Draft:new()
|
|
bsw/jbe@0
|
178 draft.initiative_id = initiative.id
|
|
bsw/jbe@4
|
179 draft.formatting_engine = formatting_engine
|
|
bsw/jbe@0
|
180 draft.content = param.get("draft")
|
|
bsw/jbe@0
|
181 draft.author_id = app.session.member.id
|
|
bsw/jbe@0
|
182 draft:save()
|
|
bsw/jbe@0
|
183
|
|
bsw/jbe@0
|
184 local initiator = Initiator:new()
|
|
bsw/jbe@0
|
185 initiator.initiative_id = initiative.id
|
|
bsw/jbe@0
|
186 initiator.member_id = app.session.member.id
|
|
bsw@10
|
187 initiator.accepted = true
|
|
bsw/jbe@0
|
188 initiator:save()
|
|
bsw/jbe@0
|
189
|
|
bsw@944
|
190 if not is_polling then
|
|
bsw@944
|
191 local supporter = Supporter:new()
|
|
bsw@944
|
192 supporter.initiative_id = initiative.id
|
|
bsw@944
|
193 supporter.member_id = app.session.member.id
|
|
bsw@944
|
194 supporter.draft_id = draft.id
|
|
bsw@944
|
195 supporter:save()
|
|
bsw@944
|
196 end
|
|
bsw/jbe@0
|
197
|
|
bsw/jbe@0
|
198 slot.put_into("notice", _"Initiative successfully created")
|
|
bsw/jbe@0
|
199
|
|
bsw/jbe@0
|
200 request.redirect{
|
|
bsw/jbe@0
|
201 module = "initiative",
|
|
bsw/jbe@0
|
202 view = "show",
|
|
bsw/jbe@0
|
203 id = initiative.id
|
|
jbe@326
|
204 }
|