def query_menu(login_name):
session = database.sess()
permission = session.query(AdminPermission.permission)\
.filter(AdminUsers.login_name==login_name,AdminUsers.id==AdminPermission.user_id)\
.first()
fun_groups = session.query(FunctionGroups).filter(
FunctionGroups.id.in_((permission[0]))).all()
print(fun_groups)
p = []
for fun_group in fun_groups:
menu = dict()
menu["id"] = fun_group.id
menu["label"] = fun_group.name
#暂无用到
menu['path'] = "/"
print(fun_group.children)
if fun_group.children:
children_menu_list = []
fun_points = session.query(FunctionPoint).filter(
FunctionPoint.id.in_((fun_group.children))).all()
print(fun_points)
for fun_point in fun_points:
children_menu = dict()
children_menu["id"] = fun_point.id
children_menu["label"] = fun_point.name
children_menu["path"] = fun_point.path
children_menu_list.append(children_menu)
menu["children"] = children_menu_list
p.append(menu)
print(p)
return p
def add_fun():
session = database.sess()
group_id = request.form["group_id"]
fun_id = request.form["fun_id"]
fun_groups = session.query(FunctionGroups).filter(
FunctionGroups.id == group_id).first()
children = fun_groups.children
if fun_id not in children:
fun_groups.children = children + "," + fun_id
session.commit()
return jsonify({"result": 'is ok', "code": "200"})
def point_all():
session = database.sess()
results = session.query(FunctionPointAll).all()
function_arr = []
for result in results:
function_obj = dict()
function_obj['id'] = result.id
function_obj['label'] = result.name
function_obj['path'] = result.path
function_arr.append(function_obj)
return jsonify({"point_all": json.dumps(function_arr), "code": "200"})
def delete_point():
session = database.sess()
group_id = request.form["group_id"]
fun_id = request.form["fun_id"]
fun_groups = session.query(FunctionGroups).filter(
FunctionGroups.id == group_id).first()
children = fun_groups.children
children = children.split(",")
if fun_id in children:
children.remove(fun_id)
fun_groups.children = ','.join(children)
session.commit()
return jsonify({"result": 'is ok', "code": "200"})
else:
return jsonify({"result": 'is error', "code": "404"})
def login():
session = database.sess()
login_name = request.form["login_name"]
password = request.form["password"]
user_info = session.query(AdminUsers.login_name,AdminPermission.permission)\
.filter(AdminUsers.login_name==login_name,AdminUsers.password==password,AdminUsers.id==AdminPermission.user_id)\
.all()
if len(user_info) == 0:
abort(404)
userObj = user_info[0]
power = query_menu(login_name)
return jsonify({
"name": userObj.login_name,
"token": "1111111",
"power": power,
"code": "200"
})
def user_info(user_id):
session = database.sess()
user_mes = session.query(AdminUsers).filter(AdminUsers.id == user_id).all()
if len(user_mes) == 0:
abort(404)
return user_id