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"))