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