| rev |
line source |
|
bsw/jbe@5
|
1 local tmp = db:query({ "SELECT text_entries_left, initiatives_left FROM member_contingent_left WHERE member_id = ?", app.session.member.id }, "opt_object")
|
|
bsw/jbe@5
|
2 if tmp then
|
|
bsw/jbe@5
|
3 if tmp.initiatives_left and tmp.initiatives_left < 1 then
|
|
bsw/jbe@5
|
4 slot.put_into("error", _"Sorry, your contingent for creating initiatives has been used up. Please try again later.")
|
|
bsw/jbe@5
|
5 return false
|
|
bsw/jbe@5
|
6 end
|
|
bsw/jbe@5
|
7 if tmp.text_entries_left and tmp.text_entries_left < 1 then
|
|
bsw/jbe@5
|
8 slot.put_into("error", _"Sorry, you have reached your personal flood limit. Please be slower...")
|
|
bsw/jbe@5
|
9 return false
|
|
bsw/jbe@5
|
10 end
|
|
bsw/jbe@5
|
11 end
|
|
bsw/jbe@5
|
12
|
|
bsw/jbe@0
|
13 local issue
|
|
bsw/jbe@0
|
14 local area
|
|
bsw/jbe@0
|
15
|
|
bsw/jbe@0
|
16 local issue_id = param.get("issue_id", atom.integer)
|
|
bsw/jbe@0
|
17 if issue_id then
|
|
bsw/jbe@0
|
18 issue = Issue:new_selector():add_where{"id=?",issue_id}:single_object_mode():exec()
|
|
bsw/jbe@5
|
19 if issue.closed then
|
|
bsw/jbe@5
|
20 slot.put_into("error", _"This issue is already closed.")
|
|
bsw/jbe@5
|
21 return false
|
|
bsw/jbe@5
|
22 elseif issue.fully_frozen then
|
|
bsw/jbe@5
|
23 slot.put_into("error", _"Voting for this issue has already begun.")
|
|
bsw/jbe@5
|
24 return false
|
|
bsw/jbe@5
|
25 end
|
|
bsw/jbe@0
|
26 area = issue.area
|
|
bsw/jbe@0
|
27 else
|
|
bsw/jbe@0
|
28 local area_id = param.get("area_id", atom.integer)
|
|
bsw/jbe@0
|
29 area = Area:new_selector():add_where{"id=?",area_id}:single_object_mode():exec()
|
|
bsw/jbe@52
|
30 if not area.active then
|
|
bsw/jbe@52
|
31 slot.put_into("error", "Invalid area.")
|
|
bsw/jbe@52
|
32 return false
|
|
bsw/jbe@52
|
33 end
|
|
bsw/jbe@0
|
34 end
|
|
bsw/jbe@0
|
35
|
|
bsw@10
|
36 local policy_id = param.get("policy_id", atom.integer)
|
|
bsw@10
|
37
|
|
bsw@10
|
38 if policy_id == -1 then
|
|
bsw@10
|
39 slot.put_into("error", _"Please choose a policy")
|
|
bsw@10
|
40 return false
|
|
bsw@10
|
41 end
|
|
bsw@10
|
42
|
|
bsw/jbe@52
|
43 local policy = Policy:by_id(policy_id)
|
|
bsw/jbe@52
|
44
|
|
bsw/jbe@52
|
45 if not policy.active then
|
|
bsw/jbe@52
|
46 slot.put_into("error", "Invalid policy.")
|
|
bsw/jbe@52
|
47 return false
|
|
bsw/jbe@52
|
48 end
|
|
bsw/jbe@52
|
49
|
|
bsw/jbe@6
|
50 local name = param.get("name")
|
|
bsw/jbe@6
|
51
|
|
bsw/jbe@6
|
52 local name = util.trim(name)
|
|
bsw/jbe@6
|
53
|
|
bsw/jbe@6
|
54 if #name < 3 then
|
|
bsw/jbe@6
|
55 slot.put_into("error", _"This name is really too short!")
|
|
bsw/jbe@6
|
56 return false
|
|
bsw/jbe@6
|
57 end
|
|
bsw/jbe@6
|
58
|
|
bsw/jbe@0
|
59 local initiative = Initiative:new()
|
|
bsw/jbe@0
|
60
|
|
bsw/jbe@0
|
61 if not issue then
|
|
bsw@7
|
62 if not area:get_reference_selector("allowed_policies")
|
|
bsw@7
|
63 :add_where{ "policy.id = ?", policy_id }
|
|
bsw@7
|
64 :optional_object_mode()
|
|
bsw@7
|
65 :exec()
|
|
bsw@7
|
66 then
|
|
bsw@7
|
67 error("policy not allowed")
|
|
bsw@7
|
68 end
|
|
bsw/jbe@0
|
69 issue = Issue:new()
|
|
bsw/jbe@0
|
70 issue.area_id = area.id
|
|
bsw@7
|
71 issue.policy_id = policy_id
|
|
bsw/jbe@0
|
72 issue:save()
|
|
bsw/jbe@0
|
73 end
|
|
bsw/jbe@0
|
74
|
|
bsw/jbe@0
|
75 initiative.issue_id = issue.id
|
|
bsw/jbe@6
|
76 initiative.name = name
|
|
bsw/jbe@6
|
77 param.update(initiative, "discussion_url")
|
|
bsw/jbe@0
|
78 initiative:save()
|
|
bsw/jbe@0
|
79
|
|
bsw/jbe@0
|
80 local draft = Draft:new()
|
|
bsw/jbe@0
|
81 draft.initiative_id = initiative.id
|
|
bsw/jbe@4
|
82 local formatting_engine = param.get("formatting_engine")
|
|
bsw/jbe@4
|
83 local formatting_engine_valid = false
|
|
bsw/jbe@4
|
84 for fe, dummy in pairs(config.formatting_engine_executeables) do
|
|
bsw/jbe@4
|
85 if formatting_engine == fe then
|
|
bsw/jbe@4
|
86 formatting_engine_valid = true
|
|
bsw/jbe@4
|
87 end
|
|
bsw/jbe@4
|
88 end
|
|
bsw/jbe@4
|
89 if not formatting_engine_valid then
|
|
bsw/jbe@4
|
90 error("invalid formatting engine!")
|
|
bsw/jbe@4
|
91 end
|
|
bsw/jbe@4
|
92 draft.formatting_engine = formatting_engine
|
|
bsw/jbe@0
|
93 draft.content = param.get("draft")
|
|
bsw/jbe@0
|
94 draft.author_id = app.session.member.id
|
|
bsw/jbe@0
|
95 draft:save()
|
|
bsw/jbe@0
|
96
|
|
bsw/jbe@0
|
97 local initiator = Initiator:new()
|
|
bsw/jbe@0
|
98 initiator.initiative_id = initiative.id
|
|
bsw/jbe@0
|
99 initiator.member_id = app.session.member.id
|
|
bsw@10
|
100 initiator.accepted = true
|
|
bsw/jbe@0
|
101 initiator:save()
|
|
bsw/jbe@0
|
102
|
|
bsw/jbe@0
|
103 local supporter = Supporter:new()
|
|
bsw/jbe@0
|
104 supporter.initiative_id = initiative.id
|
|
bsw/jbe@0
|
105 supporter.member_id = app.session.member.id
|
|
bsw/jbe@0
|
106 supporter.draft_id = draft.id
|
|
bsw/jbe@0
|
107 supporter:save()
|
|
bsw/jbe@0
|
108
|
|
bsw/jbe@0
|
109 slot.put_into("notice", _"Initiative successfully created")
|
|
bsw/jbe@0
|
110
|
|
bsw/jbe@0
|
111 request.redirect{
|
|
bsw/jbe@0
|
112 module = "initiative",
|
|
bsw/jbe@0
|
113 view = "show",
|
|
bsw/jbe@0
|
114 id = initiative.id
|
|
bsw/jbe@0
|
115 } |