def search_teacher_db(args,params_dict):
if params_dict["search_teacher"]=="":
result = Teachers.query.all()
pagination, user = paginate_html_db(Teachers)
return pagination, result
if Teachers.query.filter_by(teacher_name=args.get("search_teacher")).all()==[]:
return None
return paginate_html_db(Teachers)[0],Teachers.query.filter_by(teacher_name=args.get("search_teacher")).all()
def add_Subject():
if request.method == "POST":
result = judge_add_subject_form(request.form)
if result[0] == False:
print(result[1].errors)
return render_template("school_tem/error.html",
errors=result[1].errors)
add_subject_db(request.form.to_dict().items())
return redirect("/Subject_info")
pagination, subjects_modellistAll = paginate_html_db(Students, 6)
return render_template("school_tem/add_subjects.html",
pagination=pagination)
def Teacher_info():
params_dict = request.args.to_dict()
if "search_teacher" in request.args.to_dict():
result = search_teacher_db(request.args, params_dict)
if result == None:
return redirect(url_for("Teacher_info") + "?page=1")
return render_template('school_tem/teachers.html',
teachers_modellist=result[1],
pagination=result[0])
elif "delete_teacher" in params_dict and params_dict[
"delete_teacher"] != "":
delete_teacher_db(request.args)
return redirect("/Teacher_info")
elif "page" in params_dict and params_dict["page"] != "":
pagination, teachers_modellistAll = paginate_html_db(Teachers, 14)
return render_template("school_tem/teachers.html",
teachers_modellist=teachers_modellistAll,
pagination=pagination)
return redirect(request.url + "?page=1")
def Student_info():
params_dict = request.args.to_dict()
if "search_student" in request.args.to_dict():
result = search_student_db(request.args, params_dict)
if result == None:
return redirect(url_for("Student_info") + "?page=1")
return render_template('school_tem/students.html',
students_modellist=result[1],
pagination=result[0])
elif "delete_student" in params_dict and params_dict[
"delete_student"] != "":
delete_student_db(request.args)
return redirect("/Student_info")
elif "page" in params_dict and params_dict["page"] != "":
pagination, students_modellistAll = paginate_html_db(Students, 14)
return render_template("school_tem/students.html",
students_modellist=students_modellistAll,
pagination=pagination)
return redirect(request.url + "?page=1")
def paginate_subeject():
pagination, users = paginate_html_db(Students, 6)
student_list = []
for user in users:
student_list.append(user.student_name)
return jsonify(student_list)