def add_group():
if current_user.admin:
form = SelectForm()
form.class_list.choices = DB.class_list_form()
form.class_list2.choices = DB.class_list_form()
if form.submit.data:
DB.add_group(form.class_list.data, form.name.data)
return redirect(url_for("add_group"))
if form.submit2.data:
return redirect(
url_for("dell_group", class_id=form.class_list2.data))
return render_template("add_groupp.html",
form=form,
rows=DB.group_list())
else:
return redirect(url_for("index"))
def add_student():
if current_user.admin:
form = SelectForm()
form.student_list.choices = DB.student_list_form()
form.class_list.choices = DB.class_list_form()
form.school_list.choices = DB.list_school_form()
form.student_list2.choices = DB.student_list_form()
form.class_list2.choices = DB.class_list_form()
if form.submit.data:
DB.add_student(form.school_list.data, form.class_list.data,
form.name.data, form.surname.data,
form.patronymic.data, form.sex.data,
form.password.data)
return "Данные для " + str(form.name.data) + " " + str(
form.surname.data
) + " " + str(form.patronymic.data) + " Логин:пароль " + str(
DB.get_last_added_userid()
) + " : " + form.password.data + """ <a href="/add_student" font-size="16">ок</a>"""
if form.submit3.data:
DB.update_student(id=form.student_list2.data,
class_id=form.class_list2.data,
sex=form.sex2.data,
name=form.name2.data,
surname=form.surname2.data,
patronymic=form.patronymic2.data,
password=form.password2.data)
return redirect(url_for("add_student"))
if form.submit2.data:
student = db.session.query(Students).filter_by(
id=form.student_list.data)
student = student.all()
user_id = student[0].id_user
db.session.query(User).filter_by(id=user_id).delete()
db.session.query(Students).filter_by(
id=form.student_list.data).delete()
db.session.commit()
return redirect(url_for("add_student"))
return render_template("add_student2.html",
form=form,
rows=DB.student_list())
else:
return redirect(url_for("index"))
def add_schedule():
if current_user.admin:
form = SelectForm()
form.class_list.choices = DB.class_list_form()
if form.submit2.data:
DB.add_schedule(form.class_list.data)
return redirect(
url_for("add_schedule2", class_id=form.class_list.data))
return render_template("add_schedule1.html", form=form)
else:
return redirect(url_for("index"))
def add_class():
if current_user.admin:
form = SelectForm()
form.school_list.choices = DB.list_school_form()
form.class_list.choices = DB.class_list_form()
if form.submit.data:
DB.add_class(form.school_list.data, form.name.data)
return redirect(url_for("add_class"))
if form.submit2.data:
DB.delete_class(form.class_list.data)
return redirect(url_for("add_class"))
return render_template("add_class.html",
form=form,
rows=DB.class_list())
else:
return redirect(url_for("index"))
def add_studentgroup():
if current_user.admin:
form = SelectForm()
form.class_list.choices = DB.class_list_form()
form.group_list.choices = DB.studentgroup_list_form()
if form.submit2.data:
return redirect(
url_for("add_studentgroup2", class_id=form.class_list.data))
if form.submit.data:
a = form.group_list.data
a = a.split(" ")
DB.delete_student_from_group(a[1], a[0])
return redirect(url_for("add_studentgroup"))
return render_template("add_studentgroup.html",
form=form,
rows=DB.studentgroup_list_form())
else:
return redirect(url_for("index"))
