def secretary_sudy(): if request.cookies.get('user_id') == None: return redirect('/login') else: user = request.cookies.get('user_id') get_db() db = Database(g._database) user_info = db.find_user_by_id(user) role = user_info[0] name = ' '.join(user_info[1:]) d_table = db.get_courts() for item in d_table: item.insert(0, d_table.index(item) + 1) item.append(item.pop(1)) item.pop(1) if d_table != []: return render_template("secretary/sudy.html", data=d_table, role=role, name=name) else: return render_template("secretary/sudy.html", data=[], role=role, name=name, delite_href='')
def admin_sudy(): if request.cookies.get('user_id') == None: return redirect('/login') else: user = request.cookies.get('user_id') get_db() db = Database(g._database) user_info = db.find_user_by_id(user) role = user_info[0] name = ' '.join(user_info[1:]) if request.method == 'GET': d_table = db.get_courts() else: client = request.form.get('client') date = request.form.get('date') if client == '' and date == '': d_table = db.get_courts() elif client == '' and date != '': d_table = db.get_courts_search(date=date) elif client != '' and date == '': d_table = db.get_courts_search(client=client) elif client != '' and date != '': d_table = db.get_courts_search(client=client, date=date) else: redirect('/admin/render/sudy') if d_table == []: return render_template("/admin/sudy.html", data=[], role=role, name=name, delite_href='') else: for item in d_table: item.insert(0, d_table.index(item) + 1) item.append(item.pop(1)) item.pop(1) serch_clients = [] if db.get_courts_clients() == []: serch_clients = [] else: for cl in db.get_courts_clients(): serch_clients.append(cl[0]) return render_template("/admin/sudy.html", data=d_table, role=role, serch_clients=serch_clients, name=name)