def admin_add_sudy():
if request.method == 'POST':
new_c_id = str(uuid.uuid4())
get_db()
db = Database(g._database)
adding_dict = request.form.to_dict(flat=False)
list_to_Courts = []
for margin in tables_sets(table_name='Sud', mode='fields'):
if margin == 'c_id':
list_to_Courts.append(new_c_id)
elif margin == 'u_id':
list_to_Courts.append(request.cookies.get('user_id'))
else:
list_to_Courts.append(adding_dict[margin][0])
db.insert_tables('Sud', tuple(list_to_Courts))
return redirect('/admin/render/sudy')
if request.method == 'GET':
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:])
urists = db.get_urists()
ur_up = [' '.join(i) for i in urists]
clients = db.get_clients()
return render_template('admin/add/add_sudy.html',
clients=clients,
role=role,
name=name,
urists=ur_up)
def render(template_name):
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:])
href_acsess = request.url.split('/')[3]
if acssec_translate(role) == href_acsess:
real_acsess = href_acsess
else:
real_acsess = acssec_translate(role)
return redirect(f'/{real_acsess}/render/{template_name}')
table_name = settings_by_template(template_name, 'table_name')
if request.method == 'GET':
if real_acsess == 'admin':
d_table = db.get_join_table(table_name)
else:
d_table = db.get_join_table_u_id(table_name, user)
else:
dict_ = request.form.to_dict(flat=False)
print(dict_)
practice = dict_['practice']
lawyers = dict_['lawyers']
client = request.form.get('client')
print(client)
if practice == [''] and client == '' and lawyers == ['']:
if real_acsess == 'admin':
d_table = db.get_join_table(table_name)
else:
d_table = db.get_join_table_u_id(table_name, user)
elif practice != [''] or client != '' or lawyers != ['']:
if real_acsess == 'admin':
d_table = db.get_join_table_search(table_name,
practice=practice,
client=client,
lawyers=lawyers)
else:
d_table = db.get_join_table_search_u_id(table_name,
user,
practice=practice,
client=client,
lawyers=lawyers)
else:
return redirect(f'/{real_acsess}/render/{template_name}')
if d_table != []:
start_from = settings_by_template(template_name, 'start_from')
colors = []
delite_hrs = []
for i in d_table:
colors.append(i.pop(-1))
for item in d_table:
item.append(item.pop(1))
item[2] = ' ;\n'.join(json.loads(item[2])) + ' .'
item[4] = ' ;\n'.join(json.loads(item[4])) + ' .'
if item[start_from] == 'Нет файла':
item[start_from] == 'Нет файла'
else:
item[start_from] = '/download_files/' + '/'.join(
item[start_from].split('\\')[-3:])
if item[start_from + 1] == 'Нет файла':
item[start_from] == 'Нет файла'
else:
item[start_from + 1] = '/download_files/' + '/'.join(
item[start_from + 1].split('\\')[-3:])
x_lst = [
item[start_from + 3].split(' ')[i:i + 3]
for i in range(0, len(item[start_from + 3].split(' ')), 3)
]
item[start_from + 3] = '\n'.join([' '.join(i) for i in x_lst])
serch_clients = db.get_clients()
lawyers = [' '.join(i) for i in db.get_urists()]
return render_template(f'/{real_acsess}/{template_name}' + '.html',
data=d_table,
role=role,
name=name,
colors=colors,
serch_clients=serch_clients,
lawyers=lawyers)
else:
return render_template(f'/{real_acsess}/{template_name}' + '.html',
data=[],
role=role,
name=name,
colors=[],
delite_href='')