def getPageListLogin():
myRes = MyResponse()
currentPage = MyRequest.get("currentPage", type=int)
pageSize = MyRequest.get("pageSize", type=int)
searchName = MyRequest.get("searchName", type=str).strip()
startDate = MyRequest.get_verify_date("startDate")
endDate = MyRequest.get_verify_date("endDate")
try:
columns = [
LogLogin.LOGL_KEY, LogLogin.TIME_CREATE, LogLogin.DESCRIPT,
LogLogin.IP_ADDRESS, UserInfo.LOGIN_NAME, UserInfo.USER_NAME
]
outerjoins = [(UserInfo, UserInfo.USER_KEY == LogLogin.USER_KEY)]
filters = [LogLogin.TIME_CREATE.between(startDate, endDate)]
if searchName != '':
filters.append(UserInfo.FloginName.like("%" + searchName + "%"))
myRes.data = MySqlalchemy.get_page_list(
currentPage,
pageSize,
LogLogin.LOGL_KEY,
columns,
outerjoins=outerjoins,
filters=filters,
orders=[LogLogin.TIME_CREATE.desc()])
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()
def getList():
myRes = MyResponse()
try:
query_data = db_session.query(UserInfo).all()
myRes.data = MySqlalchemy.convertToList(query_data)
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:
query_data = db_session.query(RoleInfo).order_by(
RoleInfo.TIME_MODIFY.desc())
myRes.data = MySqlalchemy.convertToList(query_data)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getDetail():
myRes = MyResponse()
DPT_KEY = MyRequest.get_verify_empty("DPT_KEY", errmsg="部门ID不能为空")
try:
query_data=db_session.query(DptInfo).filter(DptInfo.DPT_KEY==DPT_KEY).one()
dict_menu=MySqlalchemy.convertToDict(query_data)
myRes.data = dict_menu
myRes.code = ResState.HTTP_SUCCESS
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg=str(ex)
return myRes.to_json()
def getDetail():
myRes = MyResponse()
ROLE_KEY = MyRequest.get("ROLE_KEY", type=int)
try:
query_data = db_session.query(RoleInfo).filter(
RoleInfo.ROLE_KEY == ROLE_KEY).one()
dict_data = MySqlalchemy.convertToDict(query_data)
myRes.code = ResState.HTTP_SUCCESS
myRes.data = dict_data
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getList():
myRes = MyResponse()
try:
query_menuButton = db_session.query(OperInfo).order_by(
OperInfo.OPER_SOFT.asc()).all()
myRes.data = MySqlalchemy.convertToList(query_menuButton)
print(myRes.data)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getDetail():
myRes = MyResponse()
Fid = MyRequest.get_verify_empty("Fid", errmsg="Fid不能为空")
try:
query_menu = db_session.query(MenuInfo).filter(
MenuInfo.Fid == Fid).one()
dict_menu = MySqlalchemy.convertToDict(query_menu)
myRes.data = dict_menu
myRes.code = ResState.HTTP_SUCCESS
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getList():
myRes = MyResponse()
try:
query_menu = db_session.query(
MenuInfo.MENU_KEY, MenuInfo.MENU_PKEY, MenuInfo.MENU_NAME,
MenuInfo.MENU_URL, MenuInfo.MENU_ICON,
MenuInfo.MENU_SOFT).order_by(MenuInfo.MENU_SOFT.asc()).all()
myRes.data = MySqlalchemy.convertToList(query_menu)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getRoleMenuAndOperList():
myRes = MyResponse()
ROLE_KEY = MyRequest.get("ROLE_KEY", type=int)
try:
query_data = db_session.query(RolePermission.ROLE_KEY,
RolePermission.RESOURCE_KEY,
RolePermission.RESOURCE_TYPE).filter(
RolePermission.ROLE_KEY == ROLE_KEY)
myRes.data = MySqlalchemy.convertToList(query_data)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getRoleListByUserKey():
myRes = MyResponse()
USER_KEY = MyRequest.get("USER_KEY", type=int)
try:
clomns = [UserRole.USER_KEY, RoleInfo.ROLE_NAME, UserRole.ROLE_KEY]
query_data = db_session.query(*clomns).outerjoin(
RoleInfo, RoleInfo.ROLE_KEY == UserRole.ROLE_KEY).filter(
UserRole.USER_KEY == USER_KEY)
myRes.data = MySqlalchemy.convertToList(query_data)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getPageList():
myRes = MyResponse()
currentPage = MyRequest.get("currentPage", type=int)
pageSize = MyRequest.get("pageSize", type=int)
searchDptKey = MyRequest.get("searchDptKey", type=str)
searchName = MyRequest.get("searchName", type=str).strip()
columns = [
UserInfo.USER_KEY, UserInfo.USER_NAME, UserInfo.LOGIN_NAME,
UserInfo.USER_SEX, UserInfo.USER_POSITION, UserInfo.DPT_KEY,
DptInfo.DPT_NAME, UserInfo.TIME_MODIFY, UserInfo.PHONE
]
filters = []
outerjoins = [(DptInfo, DptInfo.DPT_KEY == UserInfo.DPT_KEY)]
try:
USER_KEY = g.USER_KEY
if USER_KEY != 1:
filters.append(UserInfo.USER_KEY != 1)
if searchDptKey != 0:
filters.append(UserInfo.DPT_KEY.like(searchDptKey + "%"))
if searchName is not None:
filters.append(UserInfo.USER_NAME.like("%" + searchName + "%"))
user_page_info = MySqlalchemy.get_page_list(
currentPage,
pageSize,
UserInfo.USER_KEY,
columns,
outerjoins=outerjoins,
filters=filters,
orders=[UserInfo.TIME_MODIFY.desc()])
###拼接用户角色
query_data_role = db_session.query(
UserRole.USER_KEY, RoleInfo.ROLE_NAME,
UserRole.ROLE_KEY).outerjoin(
RoleInfo, RoleInfo.ROLE_KEY == UserRole.ROLE_KEY)
list_role = MySqlalchemy.convertToList(query_data_role)
for xuser in user_page_info["data"]:
list_roleName = []
for xrole in list_role:
if xuser["USER_KEY"] == xrole["USER_KEY"]:
list_roleName.append(xrole["ROLE_NAME"])
xuser["ROLE_NAMES"] = ",".join(list_roleName)
myRes.data = user_page_info
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def getDptAndUserList():
myRes = MyResponse()
try:
query_data_dpt = db_session.query(DptInfo.DPT_KEY, DptInfo.DPT_PKEY,
DptInfo.DPT_NAME)
query_data_user = db_session.query(
UserInfo.USER_KEY, UserInfo.DPT_KEY,
UserInfo.USER_NAME).filter(UserInfo.USER_KEY != 1)
query_data = query_data_dpt.union_all(query_data_user)
myRes.data = MySqlalchemy.convertToList(query_data)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
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 getDetail():
myRes = MyResponse()
USER_KEY = MyRequest.get("USER_KEY", type=int)
try:
columns = [
UserInfo.USER_KEY, UserInfo.DPT_KEY, UserInfo.USER_NAME,
UserInfo.LOGIN_NAME, UserInfo.USER_SEX, UserInfo.USER_POSITION,
UserInfo.PHONE, UserInfo.TIME_CREATE, UserRole.ROLE_KEY
]
dict_user = MySqlalchemy.get_detail(
columns,
outerjoins=[UserRole, UserRole.USER_KEY == UserInfo.USER_KEY],
filters=[UserInfo.USER_KEY == USER_KEY])
myRes.code = ResState.HTTP_SUCCESS
myRes.data = dict_user
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def login():
myRes = MyResponse()
try:
FloginName = MyRequest.get_verify_empty("FloginName", errmsg="用户名不能为空")
Fpwd = MyRequest.get_verify_empty("Fpwd", errmsg="密码不能为空")
from app.apis.utils.auth_helper import Auth
dict_user, token = Auth.authenticate(FloginName, Fpwd)
userInfo = {
"USER_NAME": dict_user["USER_NAME"],
"LOGIN_NAME": dict_user["LOGIN_NAME"],
"PHONE": dict_user["PHONE"]
}
g.FuserId = dict_user["USER_KEY"]
myRes.data = {"userInfo": userInfo, "token": token}
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "登录成功"
login_logger("用户登录")
except SQLAlchemyError as ex:
mylog.error(ex)
return myRes.to_json_msg(ResState.ERROR_DB)
return myRes.to_json()
def exportLogLogin():
myRes = MyResponse()
searchName = MyRequest.get("searchName", type=str).strip()
startDate = MyRequest.get_verify_date("startDate")
endDate = MyRequest.get_verify_date("endDate")
downLoadFile = DownLoadFile()
xlsxwriterWriter = XlsxwriterWriter()
try:
db_query = db_session.query(UserInfo.Fid, UserInfo.FloginName,
UserInfo.Fname, LogLogin.FcreateTime,
LogLogin.Fremark, LogLogin.FipAddress)
db_query = db_query.outerjoin(UserInfo,
UserInfo.Fid == LogLogin.FuserId)
db_query = db_query.filter(
LogLogin.FcreateTime.between(startDate, endDate))
if searchName != '':
db_query = db_query.filter(
UserInfo.FloginName.like("%" + searchName + "%"))
query_data = db_query.order_by(LogLogin.FcreateTime.desc())
dataArray = MySqlalchemy.convertToDict(query_data)
df = pandas.DataFrame(dataArray)
xlsxwriterWriter.open()
xlsxwriterWriter.writeSheetbyList(df, titles=None, sheetname="ttt")
downLoadFile.filepath = xlsxwriterWriter.filepath
downLoadFile.filename = xlsxwriterWriter.filename
downLoadFile.newfilename = "操作日志" + getSysDateTimeStr() + ".xlsx"
myRes.data = []
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except ExcelError as ex:
mylog.error(ex)
abort(404, "写入excel错误")
except SQLAlchemyError as ex:
mylog.error(ex)
abort(404, sys.exc_info()[1])
finally:
xlsxwriterWriter.close()
return downLoadFile.download()
