def getAllFromTaskListByPage(request):
code, data, message = None, None, None
try:
userInfo = checkUserSession(request)
page = request.GET.get('page')
taskState = request.GET.get('taskState')
type = request.GET.get('type')
taskName = request.GET.get('taskName')
userId = None
if type == 'user' and userInfo['user_name'] != 'admin':
userId = userInfo['user_id']
if page:
taskList, num_pages = taskListDao.getAllFromTaskListByPage(page, taskName=taskName, taskState=taskState, userId=userId)
data = {
'taskList': list(taskList),
'num_pages': num_pages,
'page': int(page)
}
code = 200
else:
raise Exception('参数报错: page不能为空')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def updPassWordFromUserInfo(request):
code, data, message = None, None, None
try:
userInfo = checkUserSession(request)
oldPassWrod = request.GET.get('oldPassWrod')
newPassWord = request.GET.get('newPassWord')
if oldPassWrod and newPassWord:
#: 密旧码验证
h = hashlib.sha256()
h.update(bytes(oldPassWrod, encoding='utf-8'))
oldPassWrod = h.hexdigest()
dbPassWord = userInfoDao.getPassWordFromUserInfoByUserId(
userInfo['user_id'])
if oldPassWrod != dbPassWord:
raise Exception('参数报错: 老密码错误，请重新输入谢谢！')
#: 新密码更新
p = hashlib.sha256()
p.update(bytes(newPassWord, encoding='utf-8'))
newPassWord = p.hexdigest()
userInfoDao.updAllFromUserInfoByUserId(userInfo['user_id'],
password=newPassWord)
code, message = 200, '密码修改成功'
else:
raise Exception("参数报错: 新旧密码不能为空！")
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=None).getJson())
def delApiListFromRoleIdByRoleId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
roleId = requset.GET.get('roleId')
apiList = requset.GET.get('apiList')
if roleId and apiList:
roleInfo = roleInfoDao.getAllFromRoleInfoByRoleId(roleId)
if roleInfo.api_list == '*':
raise Exception("权限报错: 不能修改admin权限！")
apiList = json.loads(apiList)
if roleInfo.api_list:
dbApiList = json.loads(roleInfo.api_list)
dbApiList = list(set(dbApiList).difference(set(apiList)))
roleInfoDao.updAllFromRoleInfoByRoleId(
roleId, apiList=json.dumps(dbApiList))
code, message = 200, '删除权限完成'
else:
raise Exception('权限报错: 该角色没有需要删除的权限！')
else:
raise Exception('参数报错: roleId, apiList 都不能为空！')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def updInfoFromUserInfo(request):
code, data, message = None, None, None
try:
userInfo = checkUserSession(request)
userName = request.GET.get('userName')
phone = request.GET.get('phone')
email = request.GET.get('email')
if userName:
if phone:
checkUserInfo = userInfoDao.getFromUserInfoByLogin(phone)
if checkUserInfo and checkUserInfo.user_id != userInfo[
'user_id']:
raise Exception("参数报错: 手机号码已存在")
if email:
checkUserInfo = userInfoDao.getFromUserInfoByLogin(phone)
if checkUserInfo and checkUserInfo.user_id != userInfo[
'user_id']:
raise Exception("参数报错: 邮箱已存在")
userInfoDao.updAllFromUserInfoByUserId(userInfo['user_id'],
userName=userName,
phone=phone,
email=email)
code, message = 200, '信息更新成功'
else:
raise Exception('参数报错: 用户名不能修改为空！')
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=None).getJson())
def updFromProjectSettingByProjectId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
settingId = requset.GET.get('settingId')
projectId = requset.GET.get('projectId')
ambientId = requset.GET.get('ambientId')
fileName = requset.GET.get('fileName')
remotePath = requset.GET.get('remotePath')
remarks = requset.GET.get('remarks')
if settingId and projectId and ambientId and fileName and remotePath:
projectSettingDao.updFromProjectSettingByProjectId(settingId,
projectId,
ambientId,
fileName,
remotePath,
remarks=remarks)
code, message = 200, '配置文件信息，更新完成'
else:
raise Exception(
'参数报错: settingId, projectId, ambientId, fileName, remotePath 都不能为空！'
)
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def updContentFromReleaseOrdeByOrderId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
orderId = requset.GET.get('orderId')
orderTitle = requset.GET.get('orderTitle')
orderContent = requset.GET.get('orderContent')
ambientId = requset.GET.get('ambientId')
releaseTime = requset.GET.get('releaseTime')
executorId = requset.GET.get('executorId')
artisanId = requset.GET.get('artisanId')
productId = requset.GET.get('productId')
ftpPath = requset.GET.get('ftpPath')
remarks = requset.GET.get('remarks')
if orderId:
releaseOrderDao.updContentFromReleaseOrdeByOrderId(orderId,
orderTitle,
orderContent,
ambientId,
releaseTime,
executorId,
artisanId,
productId,
ftpPath=ftpPath,
remarks=remarks)
code, message = 200, '更新工单内容成功'
else:
raise Exception('参数报错: orderId 不能为空')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def setFromReleaseOrder(requset):
code, data, message = None, None, None
try:
userInfo = checkUserSession(requset)
orderTitle = requset.GET.get('orderTitle')
orderContent = requset.GET.get('orderContent')
releaseTime = requset.GET.get('releaseTime')
executorId = requset.GET.get('executorId')
ambientId = requset.GET.get('ambientId')
artisanId = requset.GET.get('artisanId')
authorId = userInfo['user_id']
productId = requset.GET.get('productId')
remarks = requset.GET.get('remarks')
ftpPath = requset.GET.get('ftpPath')
if orderTitle and orderContent and releaseTime and ambientId and artisanId and authorId and productId and executorId:
releaseOrder = releaseOrderDao.setFromReleaseOrder(orderTitle,
orderContent,
releaseTime,
ambientId,
executorId,
artisanId,
authorId,
productId,
remarks=remarks,
ftpPath=ftpPath)
code, message = 200, '添加工单完成'
else:
raise Exception(
'参数报错: orderTitle, orderContent, releaseTime, ambientId, executorId, artisanId, authorId, productId 都不能为空'
)
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromRoleInfoAndApiInfoByRoleId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
apiId = requset.GET.get('roleId')
if apiId:
roleInfo = roleInfoDao.getAllFromRoleInfoByRoleId(apiId)
if roleInfo.api_list == '*':
apiInfoList = apiInfoDao.getAllFromApiInfo()
elif roleInfo.api_list:
apiIdList = json.loads(roleInfo.api_list)
apiInfoList = apiInfoDao.getAllFromApiInfoByApiIdList(
apiIdList)
else:
apiInfoList = []
code = 200
data = {
'roleInfo': OrmConversion(roleInfo),
'apiInfoList': OrmConversion(list(apiInfoList))
}
else:
raise Exception('参数报错: roleId 不能为空！')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def updPassWordFromUserInfo(request):
code, data, message = None, None, None
try:
userInfo = checkUserSession(request)
oldPassWrod = request.GET.get('oldPassWrod')
newPassWord = request.GET.get('newPassWord')
if oldPassWrod and newPassWord:
#: 密旧码验证
oldPassWrod = hash(oldPassWrod)
dbPassWord = userInfoDao.getPassWordFromUserInfoByUserId(
userInfo['user_id'])
if oldPassWrod != dbPassWord:
raise Exception('参数报错: 老密码错误，请重新输入谢谢！')
#: 新密码更新
newPassWord = hash(newPassWord)
userInfoDao.updAllFromUserInfoByUserId(userInfo['user_id'],
password=newPassWord)
code, message = 200, '密码修改成功'
else:
raise Exception("参数报错: 新旧密码不能为空！")
except Exception as e:
code, message = 300, str(e)
finally:
NATS_publish("updPassWordFromUserInfo")
kafka_saveLog("updPassWordFromUserInfo", code)
return HttpResponse(
JsonResponse(code=code, message=message, data=None).getJson())
def getFromUserInfoByLogin(request):
code, data, message = None, None, None
try:
account = request.GET.get('account')
password = request.GET.get('password')
if account and password:
userInfo = userInfoDao.getFromUserInfoByLogin(account)
if userInfo:
if userInfo.state == 2:
raise Exception('登录报错: 对不起，您已离职，账号无法再次使用！')
if userInfo.password == hash(password):
request.session['userId'] = userInfo.user_id
code, data, message = 200, {
'userName': userInfo.user_name
}, "登录完成"
else:
raise Exception('密码输入错误')
else:
raise Exception("用户不存在")
else:
raise Exception('参数报错: 登录名与密码不能为空')
except Exception as e:
code, message = 300, str(e)
finally:
NATS_publish("getFromUserInfoByLogin")
kafka_saveLog("getFromUserInfoByLogin", code)
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def updAllFromTaskListByTaskId(request):
code, data, message = None, None, None
try:
userInfo = checkUserSession(request)
taskId = request.GET.get('taskId')
taskInfo = request.GET.get('taskInfo')
executeId = request.GET.get('executeId')
authorizerId = request.GET.get('authorizerId')
modifyDate = request.GET.get('modifyDate')
if taskId is None:
raise Exception('taskId不能为空')
taskList = taskListDao.getAllFromTaskListByTaskId(taskId)
if userInfo['user_name'] == 'admin':
taskListDao.updAllFromTaskListByTaskId(taskId, taskInfo=taskInfo, executeId=executeId,
authorizerId=authorizerId, modifyDate=modifyDate)
code, data, message = 200, None, '修改完成'
return
if taskList['task_state'] == 2 or taskList['task_state'] == 4 or taskList['task_state'] == 3:
raise Exception("修改失败：任务已经授权或完成操作，不能再修改任务内容！")
else:
taskListDao.updAllFromTaskListByTaskId(taskId, taskInfo=taskInfo, executeId=executeId, authorizerId=authorizerId, modifyDate=modifyDate)
code, data, message = 200, None, '修改完成'
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getFromUserInfoByLogin(request):
code, data, message = None, None, None
try:
account = request.GET.get('account')
password = request.GET.get('password')
if account and password:
userInfo = userInfoDao.getFromUserInfoByLogin(account)
if userInfo:
if userInfo.state == 2:
raise Exception('登录报错: 对不起，您已离职，账号无法再次使用！')
h = hashlib.sha256()
h.update(bytes(password, encoding='utf-8'))
if userInfo.password == h.hexdigest():
request.session['userId'] = userInfo.user_id
code, data, message = 200, {
'userName': userInfo.user_name
}, "登录完成"
else:
raise Exception('密码输入错误')
else:
raise Exception("用户不存在")
else:
raise Exception('参数报错: 登录名与密码不能为空')
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def setFromUserInfo(request):
code, data, message = None, None, None
try:
email = request.GET.get('email')
phone = request.GET.get('phone')
userName = request.GET.get('userName')
password = request.GET.get('passWord')
if email and phone and userName and password:
if userName == 'admin':
raise Exception('参数报错: 不能注册管理员账号！')
userInfo = userInfoDao.getFromUserInfoByLogin(phone)
if userInfo:
raise Exception("注册失败,手机号码已存在")
userInfo = userInfoDao.getFromUserInfoByLogin(email)
if userInfo:
raise Exception("注册失败,邮箱已存在")
h = hashlib.sha256()
h.update(bytes(password, encoding='utf-8'))
password = h.hexdigest()
userGroup = userGroupDao.getAllFromUserGroupByGroupName('员工部')
userInfoDao.setFromUserInfo(email, phone, userName, password,
userGroup.group_id)
code, message = 200, '账号注册成功'
else:
raise Exception('参数报错: 邮箱, 手机号码, 用户名, 密码 都不能为空!')
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=None).getJson())
def getAllHostInfoByPage(requset):
code, data, message = None, None, None
try:
#checkUserSession(requset)
zabbix_hostip = []
page = requset.GET.get('page')
if page:
hostInfoList, numPages = monitorInfoDao.getAllHostInfoByPage(
page=page)
for hostInfo in hostInfoList:
networkList = networkDao.getAllFromNetworkByHostId(
hostInfo['host_id'], state=0)
host_ip = ''
for network in networkList:
if 'eth0' in network.network_name or 'en' in network.network_name or 'em' in network.network_name:
host_ip = network.ip_address
break
hostInfo['ip'] = host_ip
zabbix_hostip.append(host_ip)
ip_id_D = monitorInfoDao.getAllHostID(zabbix_hostip)
if ip_id_D:
host_monitor_D = monitorInfoDao.getAllItem(ip_id_D)
for k in hostInfoList:
for key, item in host_monitor_D.items():
if key in k['ip']:
k['cpu_use'] = item[0]
k['mem_use'] = item[1]
k['load5_use'] = item[2]
break
else:
k['cpu_use'] = ''
k['mem_use'] = ''
k['load5_use'] = ''
data = {
'hostInfoList': list(hostInfoList),
'numPages': numPages,
'page': int(page)
}
code = 200
else:
for k in hostInfoList:
k['cpu_use'] = ''
k['mem_use'] = ''
k['load5_use'] = ''
data = {
'hostInfoList': list(hostInfoList),
'numPages': numPages,
'page': int(page)
}
code = 200
else:
raise Exception('参数报错: page不能为空')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getGitNameFromGitInfo(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
gitInfoList = gitInfoDao.getGitNameFromGitInfo()
code, data = 200, {'gitInfoList': list(gitInfoList)}
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getCookies(request):
code, data, message = None, None, None
try:
cookie = request.COOKIES
code, data = 200, {'cookie': cookie}
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def delFromSessionByKey(request):
code, data, message = None, None, None
try:
del request.session["userId"]
code, message = 200, '注销完成'
except Exception as e:
code, message = 300, '用户没有登录，无需注销'
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getIdAndVlanNameFromVlan(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
vlanList = vlanDao.getIdAndVlanNameFromVlan()
code, data = 200, {'vlanList': list(vlanList)}
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getGroupIdAndGroupNameFromUserGroup(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
userGroupList = userGroupDao.getGroupIdAndGroupNameFromUserGroup()
code, data = 200, {'userGroupList': list(userGroupList)}
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromUsreInfoByMyself(request):
code, data, message = None, None, None
try:
userInfo = checkUserSession(request)
userInfo = userInfoDao.getAllFromUsreInfoByUserId(userInfo['user_id'])
code, data = 200, {'userInfo': userInfo}
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromAmbient(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
ambientList = ambientDao.getAllFromAmbient()
code, data = 200, {'ambientList': OrmConversion(list(ambientList))}
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllUserInfo(request):
code, data, message = None, None, None
try:
checkUserSession(request)
groupId = request.GET.get("groupId")
userInfoList = userInfoDao.getAllUserInfo(groupId=groupId)
code, data = 200, list(userInfoList)
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getIp(request):
code, data, message = None, None, None
try:
if 'HTTP_X_FORWARDED_FOR' in request.META:
ipaddress = request.META['HTTP_X_FORWARDED_FOR']
else:
ipaddress = request.META['REMOTE_ADDR']
code, data = 200, {'ipaddress': ipaddress}
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromTaskListByTaskId(request):
code, data, message = None, None, None
try:
checkUserSession(request)
taskId = request.GET.get('taskId')
if taskId is None:
raise Exception('taskId不能为空')
else:
taskList = taskListDao.getAllFromTaskListByTaskId(taskId)
code, data = 200, {'taskList': taskList}
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromUsreInfoByMyself(request):
code, data, message = None, None, None
try:
userId = request.session["userId"]
userInfo = userInfoDao.getAllFromUsreInfoByUserId(userId=userId)
userInfo = userInfoDao.getAllFromUsreInfoByUserId(userInfo['user_id'])
code, data = 200, {'userInfo': userInfo}
except Exception as e:
code, message = 300, str(e)
finally:
NATS_publish("getAllFromUsreInfoByMyself")
kafka_saveLog("getAllFromUsreInfoByMyself", code)
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getBranchsFromGitByProjectId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
projectId = requset.GET.get('projectId')
if projectId:
branchs = gitInfoDao.getBranchsFromGitByProjectId(projectId)
code, data = 200, {'branchs': branchs}
else:
raise Exception('参数报错: projectId 不能为空')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromGitInfoByGitId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
gitId = requset.GET.get('gitId')
if gitId:
gitInfo = gitInfoDao.getAllFromGitInfoByGitId(gitId)
code, data = 200, {'gitInfo': OrmConversion(gitInfo)}
else:
raise Exception('参数报错: gitId 不能为空')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromUsreInfoByUserId(request):
code, data, message = None, None, None
try:
checkUserSession(request)
userId = request.GET.get('userId')
if userId is None:
raise Exception('参数报错: userId不能为空！')
userInfo = userInfoDao.getAllFromUsreInfoByUserId(userId)
code, data = 200, {'userInfo': userInfo}
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromUserGroupByGroupId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
groupId = requset.GET.get('groupId')
if groupId:
userGroup = userGroupDao.getAllFromUserGroupByGroupId(groupId)
code, data = 200, {'userGroup': OrmConversion(userGroup)}
else:
raise Exception('参数报错: groupId 不能为空！')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def delFromProjectSettingByProjectId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
settingId = requset.GET.get('settingId')
if settingId:
projectSettingDao.delFromProjectSettingByProjectId(settingId)
code, message = 200, '删除配置文件完成'
else:
raise Exception('参数报错: settingId 不能为空！')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
