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 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 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 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 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 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 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 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 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 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 delFromApiInfoByApiId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
apiId = requset.GET.get('apiId')
if apiId:
apiInfoDao.delFromApiInfoByApiId(apiId)
code, message = 200, '更新完成'
else:
raise Exception('参数报错: apiId 不能为空！')
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())
def delFromReleaseOrderByOrderId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
orderId = requset.GET.get('orderId')
if orderId:
releaseOrderDao.delFromReleaseOrderByOrderId(orderId)
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 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 getAllFromValnById(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
id = requset.GET.get('id')
if id and id.isdigit():
vlanInfo = vlanDao.getAllFromValnById(id)
code, data = 200, {'vlan': OrmConversion(vlanInfo)}
else:
raise Exception('参数报错： id不能为空！')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromTaskLogListByTaskId(request):
data = {}
taskId = request.GET.get('taskId')
try:
checkUserSession(request)
if taskId is None:
data['message'] = '参数报错: taskId不能为空!'
else:
taskLogList = taskLogListDao.getAllFromTaskLogListByTaskId(taskId)
for taskLog in taskLogList:
data[taskLog.log_id] = model_to_dict(taskLog)
except Exception as e:
data['message'] = str(e)
finally:
return HttpResponse(json.dumps(data, cls=DateEncoder, ensure_ascii=False).encode('utf-8'))
def delFromVlanById(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
id = requset.GET.get('id')
if id and id.isdigit():
vlanDao.delFromVlanById(id)
code, message = 200, '删除成功'
else:
raise Exception('参数报错： id不能为空！')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def getNewSaltId(request):
code, data, message = None, None, None
try:
checkUserSession(request)
newHost = hostInfoDao.getNewSaltId()
if newHost:
data = newHost
else:
raise Exception("暂无新主机")
code = 200
except Exception as e:
code, message = 300, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def updStatusFromReleaseOrderByOrderId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
orderId = requset.GET.get('orderId')
status = requset.GET.get('status')
if orderId and status:
releaseOrderDao.updStatusFromReleaseOrderByOrderId(orderId, status)
code, message = 200, '工单状态更新完成'
else:
raise Exception('参数报错: orderId, status 都不能为空')
except Exception as e:
code, data, message = 300, None, str(e)
finally:
return HttpResponse(
JsonResponse(code=code, message=message, data=data).getJson())
def setFromRoleInfo(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
roleName = requset.GET.get('roleName')
remarks = requset.GET.get('remarks')
if roleName:
roleInfoDao.setFromRoleInfo(roleName, remarks)
code, message = 200, '添加完成'
else:
raise Exception('参数报错: roleName 不能为空！')
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 getAllFromRoleInfoByRoleId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
apiId = requset.GET.get('roleId')
if apiId:
roleInfo = roleInfoDao.getAllFromRoleInfoByRoleId(apiId)
code = 200
data = {'roleInfo': OrmConversion(roleInfo)}
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 delFromRoleInfoByRoleId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
roleId = requset.GET.get('roleId')
if roleId:
userGroupDao.updRoleIdIsNoneFromUserGroupByRoleId(roleId)
roleInfoDao.delFromRoleInfoByRoleId(roleId)
code, message = 200, '更新完成'
else:
raise Exception('参数报错: apiId 不能为空！')
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 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 delFromUserGroupByGroupId(requset):
code, data, message = None, None, None
try:
checkUserSession(requset)
groupId = requset.GET.get('groupId')
if groupId:
userInfoDao.updGroupIdFromUserInfoByGroupId(groupId)
userGroupDao.delFromUserGroupByGroupId(groupId)
code, message = 200, '删除完成'
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 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())
