def show_oper_menu(operation):
if operation == 'add':
crole_str = session['role_str']
role_id = request.args.get('role_id')
role_name = request.args.get('role_name')
role_dict = dict()
role_dict['id'] = role_id
role_dict['name'] = role_name
sql_oper = SqlOperate()
# 中菜单列表
menus_list = sql_oper.get_menus_list_by_role_str(crole_str)
selected_menu = sql_oper.get_menus_list_by_role_str(role_id)
selected_id_list = list()
for menu_dict in selected_menu:
for menu in menu_dict['menu_list']:
selected_id_list.append(menu['id'])
return render_template('add_menu.html',
menus_list=menus_list,
role=role_dict,
selected_id=selected_id_list)
elif operation == 'edit':
crole_str = session['role_str']
result = is_sys(crole_str)
menu_id = request.args.get('menu_id')
role_str = request.args.get('role_str')
role_list = [int(i) for i in role_str.split('/')]
menu_select_sql = """SELECT name,view_name FROM menu WHERE id=%s;""" % menu_id
sql_oper = SqlOperate()
# 查询出菜单名元组
menu_tup = sql_oper.select(menu_select_sql)
roles_list = sql_oper.get_roles_list_by_role_str(crole_str)
menu_dict = dict()
menu_dict['id'] = menu_id
menu_dict['name'] = menu_tup[0][0]
menu_dict['view_name'] = menu_tup[0][1]
if result == -1:
menu_dict['name_is_edit'] = False
else:
menu_dict['name_is_edit'] = True
return render_template('edit_menu.html',
menu=menu_dict,
roles=roles_list,
select_roles=role_list)
def show_left():
user_id = g.user_id
role_sql = """SELECT role_str FROM user WHERE id=%s""" % user_id
sql_oper = SqlOperate()
crole_str = sql_oper.select(role_sql)[0][0]
menus_list = sql_oper.get_menus_list_by_role_str(crole_str)
return render_template('left.html', menus_list=menus_list)
def get_menu():
crole_str = session['role_str']
sql_oper = SqlOperate()
role_list = sql_oper.get_roles_list_by_role_str(crole_str)
result = is_sys(crole_str)
# 中菜单列表
menus_list = sql_oper.get_menus_list_by_role_str(crole_str)
return render_template('index_menu.html',
menus_list=menus_list,
roles=role_list,
result=result)
def show_base():
name = session['name']
role_str = session['role_str']
sql_oper = SqlOperate()
try:
role_text = sql_oper.get_role_text(role_str)
except Exception as e:
print e
# 前端需求，加上menus_list
user_id = g.user_id
role_sql = """SELECT role_str FROM user WHERE id=%s""" % user_id
sql_oper = SqlOperate()
crole_str = sql_oper.select(role_sql)[0][0]
menus_list = sql_oper.get_menus_list_by_role_str(crole_str)
return render_template('base.html', menus_list=menus_list, username=name, role_text=role_text)
