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())