bsw/jbe@5: local tmp = db:query({ "SELECT text_entries_left FROM member_contingent_left WHERE member_id = ?", app.session.member.id }, "opt_object")
bsw/jbe@5: if tmp and tmp.text_entries_left and tmp.text_entries_left < 1 then
bsw/jbe@5:   slot.put_into("error", _"Sorry, you have reached your personal flood limit. Please be slower...")
bsw/jbe@5:   return false
bsw/jbe@5: end
bsw/jbe@0: 
bsw/jbe@6: local name = param.get("name")
bsw/jbe@6: local name = util.trim(name)
bsw/jbe@6: 
bsw/jbe@6: if #name < 3 then
bsw/jbe@6:   slot.put_into("error", _"This title is really too short!")
bsw/jbe@6:   return false
bsw/jbe@6: end
bsw/jbe@6: 
bsw/jbe@0: local suggestion = Suggestion:new()
bsw/jbe@0: 
bsw/jbe@0: suggestion.author_id = app.session.member.id
bsw/jbe@6: suggestion.name = name
bsw/jbe@6: param.update(suggestion, "description", "initiative_id")
bsw/jbe@0: suggestion:save()
bsw/jbe@0: 
bsw/jbe@5: -- TODO important m1 selectors returning result _SET_!
bsw/jbe@5: local issue = suggestion.initiative:get_reference_selector("issue"):for_share():single_object_mode():exec()
bsw/jbe@5: 
bsw/jbe@5: if issue.closed then
bsw/jbe@5:   slot.put_into("error", _"This issue is already closed.")
bsw/jbe@5:   return false
bsw/jbe@5: elseif issue.fully_frozen then 
bsw/jbe@5:   slot.put_into("error", _"Voting for this issue has already begun.")
bsw/jbe@5:   return false
bsw/jbe@5: end
bsw/jbe@5: 
bsw/jbe@0: local opinion = Opinion:new()
bsw/jbe@0: 
bsw/jbe@0: opinion.suggestion_id = suggestion.id
bsw/jbe@0: opinion.member_id     = app.session.member.id
bsw/jbe@0: opinion.degree        = param.get("degree", atom.integer)
bsw/jbe@0: opinion.fulfilled     = false
bsw/jbe@0: 
bsw/jbe@0: opinion:save()
bsw/jbe@0: 
bsw/jbe@0: slot.put_into("notice", _"Your suggestion has been added")