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)