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 html_error_replacer(file_name, error):
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]
soup = BeautifulSoup(
render_template(file_name.replace('\\', '/'),
role=role,
name=name,
urists=ur_up), "lxml")
err_tag = soup.find(id='error')
err_tag.string = error
return render_template_string(soup.prettify())
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='')
def add(template_name):
print(template_name)
if request.cookies.get('user_id') == None:
return redirect('/login')
if request.method == 'POST':
new_t_id = str(uuid.uuid4())
get_db()
db = Database(g._database)
file_agree = request.files["Agreement"]
file_invoice = request.files["Invoice"]
if file_agree or file_invoice or (file_agree and file_invoice):
saving_status = file_saving(new_t_id, file_agree, file_invoice)
if saving_status == False:
return html_error_replacer(
os.path.join('admin', 'add', f'{template_name}.html'),
'Ошибка файлов, попробуйте ещё раз')
else:
file_saving(new_t_id, file_agree=None, file_invoice=None)
adding_dict = request.form.to_dict(flat=False)
print(adding_dict)
list_to_Affairs = []
for margin in tables_sets(table_name='Affairs', mode='fields'):
if margin == 't_id':
list_to_Affairs.append(new_t_id)
elif margin == 'u_id':
list_to_Affairs.append(request.cookies.get('user_id'))
elif margin == 'Agreement':
if file_agree:
list_to_Affairs.append(
os.path.join(application.config['UPLOAD_FOLDER'],
new_t_id, 'Agreement',
secure_filename(file_agree.filename)))
else:
list_to_Affairs.append('Нет файла')
elif margin == 'Invoice':
if file_invoice:
list_to_Affairs.append(
os.path.join(application.config['UPLOAD_FOLDER'],
new_t_id, 'Invoice',
secure_filename(file_invoice.filename)))
else:
list_to_Affairs.append('Нет файла')
elif margin == 'Type':
list_to_Affairs.append('None')
elif margin == 'Practice':
list_to_Affairs.append(json.dumps(adding_dict[margin]))
elif margin == 'Lawyers':
list_to_Affairs.append(json.dumps(adding_dict[margin]))
else:
list_to_Affairs.append(adding_dict[margin][0])
db.insert_tables('Affairs', tuple(list_to_Affairs))
table_name = settings_by_template(template_name.lstrip('add_'),
'table_name')
list_to_table = []
for margin in tables_sets(table_name=table_name, mode='fields'):
if margin == 't_id':
list_to_table.append(new_t_id)
else:
list_to_table.append(adding_dict[margin][0])
db.insert_tables(table_name, tuple(list_to_table))
user = request.cookies.get('user_id')
user_info = db.find_user_by_id(user)
role = user_info[0]
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}/add/{template_name}')
t_name = template_name.lstrip('add_')
return redirect(f'/{real_acsess}/render/{t_name}')
if request.method == 'GET':
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()
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}/add/{template_name}')
ur_up = [' '.join(i) for i in urists]
return render_template(f'{real_acsess}/add/{template_name}.html',
role=role,
name=name,
urists=ur_up)