bsw/jbe@0: local issue
bsw/jbe@0: local area
bsw/jbe@0: 
bsw/jbe@0: db:query("BEGIN")
bsw/jbe@0: 
bsw/jbe@0: local issue_id = param.get("issue_id", atom.integer)
bsw/jbe@0: if issue_id then
bsw/jbe@0:   issue = Issue:new_selector():add_where{"id=?",issue_id}:single_object_mode():exec()
bsw/jbe@0:   area = issue.area
bsw/jbe@0: 
bsw/jbe@0: else
bsw/jbe@0:   local area_id = param.get("area_id", atom.integer)
bsw/jbe@0:   area = Area:new_selector():add_where{"id=?",area_id}:single_object_mode():exec()
bsw/jbe@0: end
bsw/jbe@0: 
bsw/jbe@0: local initiative = Initiative:new()
bsw/jbe@0: 
bsw/jbe@0: if not issue then
bsw/jbe@0:   issue = Issue:new()
bsw/jbe@0:   issue.area_id = area.id
bsw/jbe@0:   issue.policy_id = param.get("policy_id", atom.integer)
bsw/jbe@0:   issue:save()
bsw/jbe@0: end
bsw/jbe@0: 
bsw/jbe@0: initiative.issue_id = issue.id
bsw@3: 
bsw@3: param.update(initiative, "name", "discussion_url")
bsw/jbe@0: initiative:save()
bsw/jbe@0: 
bsw/jbe@0: local draft = Draft:new()
bsw/jbe@0: draft.initiative_id = initiative.id
bsw/jbe@0: draft.content = param.get("draft")
bsw/jbe@0: draft.author_id = app.session.member.id
bsw/jbe@0: draft:save()
bsw/jbe@0: 
bsw/jbe@0: local initiator = Initiator:new()
bsw/jbe@0: initiator.initiative_id = initiative.id
bsw/jbe@0: initiator.member_id = app.session.member.id
bsw/jbe@0: initiator:save()
bsw/jbe@0: 
bsw/jbe@0: local supporter = Supporter:new()
bsw/jbe@0: supporter.initiative_id = initiative.id
bsw/jbe@0: supporter.member_id = app.session.member.id
bsw/jbe@0: supporter.draft_id = draft.id
bsw/jbe@0: supporter:save()
bsw/jbe@0: 
bsw/jbe@0: db:query("COMMIT")
bsw/jbe@0: 
bsw/jbe@0: slot.put_into("notice", _"Initiative successfully created")
bsw/jbe@0: 
bsw/jbe@0: request.redirect{
bsw/jbe@0:   module = "initiative",
bsw/jbe@0:   view = "show",
bsw/jbe@0:   id = initiative.id
bsw/jbe@0: }