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='')