def getLoginUserPermissionList():
myRes = MyResponse()
try:
USER_KEY = g.USER_KEY
outerjoins_menu = []
outerjoins_oper = []
filters = []
columns_menu = [
MenuInfo.MENU_SOFT, MenuInfo.MENU_KEY, MenuInfo.MENU_ICON,
MenuInfo.MENU_URL, MenuInfo.MENU_PKEY, MenuInfo.MENU_NAME
]
columns_oper = [OperInfo.OPER_NAME, OperInfo.OPER_URL]
if USER_KEY != 12:
outerjoins_menu = [
(RolePermission,
and_(MenuInfo.MENU_KEY == RolePermission.RESOURCE_KEY,
RolePermission.RESOURCE_TYPE == 0)),
(UserRole, UserRole.ROLE_KEY == RolePermission.ROLE_KEY)
]
outerjoins_oper = [
(RolePermission,
and_(OperInfo.OPER_KEY == RolePermission.RESOURCE_KEY,
RolePermission.RESOURCE_TYPE == 1)),
(UserRole, UserRole.ROLE_KEY == RolePermission.ROLE_KEY)
]
filters = [(UserRole.USER_KEY == USER_KEY)]
query_data_menu = MySqlalchemy.get_all(columns_menu,
outerjoins=outerjoins_menu,
filters=filters,
orders=[
(MenuInfo.MENU_SOFT.asc())
])
query_data_oper = MySqlalchemy.get_all(columns_oper,
outerjoins=outerjoins_oper,
filters=filters,
orders=[
(OperInfo.OPER_SOFT.asc())
])
myRes.data = {"menuList": query_data_menu, "operList": query_data_oper}
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getList():
myRes = MyResponse()
try:
myRes.data=MySqlalchemy.get_all(DptInfo,orders=DptInfo.DPT_SOFT.asc())
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = ResState.ERROR_DB
return myRes.to_json()