def addSubSection(id_survey, id_section):
parentSection = Section.query.get(id_section)
form = SectionForm()
if form.validate_on_submit():
section = Section(title = form.title.data,
description = form.description.data,
sequence = form.sequence.data,
percent = form.percent.data,
parent = parentSection)
db.session.add(section)
db.session.commit()
flash('Adding subsection.')
return redirect(url_for('researcher.editSection',id_survey = id_survey, id_section = id_section))
# heuristics of the next sequence
section = Section.query.filter(Section.parent_id==id_section).order_by(Section.sequence.desc())
if section.count()>=2 and section[0].sequence==section[1].sequence:
# see the last and penultimate
form.sequence.data= section[0].sequence
elif section.count()>=1:
form.sequence.data= section[0].sequence + 1
else:
form.sequence.data =1
path=tips_path(parentSection)
return render_template('/researcher/addEditSection.html',
title = "Section",
form = form,
survey = Survey.query.get(id_survey),
sections = Survey.query.get(id_survey).sections.all(),
addSubSection = True,
path = path)
def addSection(id_survey):
survey = Survey.query.get(id_survey)
form = SectionForm()
if form.validate_on_submit():
section = Section(title = form.title.data,
description = form.description.data,
sequence = form.sequence.data,
percent = form.percent.data,
survey = survey
)
db.session.add(section)
db.session.commit()
flash('Adding section.')
return redirect(url_for('researcher.editSurvey',id_survey = survey.id))
# heuristics of the next sequence
section = Section.query.filter(Section.survey_id==id_survey).order_by(Section.sequence.desc())
if section.count()>=2 and section[0].sequence==section[1].sequence:
# see the last and penultimate
form.sequence.data= section[0].sequence
elif section.count()>=1:
form.sequence.data= section[0].sequence + 1
else:
form.sequence.data =1
return render_template('/researcher/addEditSection.html',
title = "Section",
form = form,
survey = survey,
sections = survey.sections.all(),
#add = true, you is adding a new section
addSection = True)