def pbossMakeRecordSearch(request): starttime = request.GET.get('starttime') endtime = request.GET.get('endtime') recordresult = request.GET.get('recordresult') #全部则将参数置空,不查询此参数 if recordresult == "全部": recordresult = "" #判断参数是否为空,若均不为空,all([])返回True if all([starttime, endtime, recordresult]): record_list = PbossOrderRecord.objects.filter( record_starttime__gte=starttime, record_endtime__lte=endtime, record_result=recordresult) elif all([starttime, recordresult]): record_list = PbossOrderRecord.objects.filter( record_starttime__gte=starttime, record_result=recordresult) elif all([endtime, recordresult]): record_list = PbossOrderRecord.objects.filter( record_endtime__lte=endtime, record_result=recordresult) elif all([starttime, endtime]): record_list = PbossOrderRecord.objects.filter( record_starttime__gte=starttime, record_endtime__lte=endtime) elif all([starttime]): record_list = PbossOrderRecord.objects.filter( record_starttime__gte=starttime) elif all([endtime]): record_list = PbossOrderRecord.objects.filter( record_endtime__lte=endtime) elif all([recordresult]): record_list = PbossOrderRecord.objects.filter( record_result=recordresult) else: record_list = PbossOrderRecord.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( record_list, request) return render(request, "order/pbossMakeRecord.html", locals())
def cFinanceMgnt(request): finance_list = OprFinance.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( finance_list, request) area_list = config.get('Finance', 'finance_area').split(', ') checkresult_list = config.get('Finance', 'finance_checkresult').split(', ') return render(request, "operation/cmiotFinanceManagement.html", locals())
def pbossMakeRecord(request): record_list = PbossOrderRecord.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( record_list, request) return render(request, "order/pbossMakeRecord.html", locals())
def hostManagement(request): host_list = [] keyword = request.GET.get("keyword", "") if keyword: host_list = models.CmdbHost.objects.filter( Q(cmdb_host_name__icontains=keyword) | Q(cmdb_host_type__icontains=keyword) | Q(cmdb_host_pod__icontains=keyword) | Q(cmdb_host_busip__icontains=keyword) | Q(cmdb_host_manip__icontains=keyword) | Q(cmdb_host_status__icontains=keyword)) else: host_list = models.CmdbHost.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( host_list, request) return render(request, "cmdb/host_management.html", locals())
def appManagement(request): app_list = [] keyword = request.GET.get("keyword", "") if keyword: app_list = models.CmdbAppCluster.objects.filter( Q(app_name__icontains=keyword) | Q(app_status__icontains=keyword)) else: cluster_list = models.CmdbAppCluster.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( cluster_list, request) return render(request, "cmdb/app_management.html", locals())
def userManagement(request): user_List = models.User.objects.all() user_info_list = [] for i in user_List: acc_user_name = i.acc_user_name acc_user_id = i.acc_user_id acc_user_CNname = i.acc_user_CNname acc_role_name = i.roles.all()[0].title acc_user_status = i.acc_user_status acc_user_createtime = i.acc_user_createtime acc_last_log_time = i.acc_last_log_time user_info = { "acc_user_id": acc_user_id, "acc_user_name": acc_user_name, "acc_user_CNname": acc_user_CNname, "acc_role_name": acc_role_name, "acc_user_status": acc_user_status, "acc_user_createtime": acc_user_createtime, "acc_last_log_time": acc_last_log_time } user_info_list.append(user_info) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( user_info_list, request) return render(request, "account/user_management.html", locals())
def hostPwdOprLog(request): host_pwd_opr_log_list = [] keyword = request.GET.get("keyword", "") starttime = request.GET.get('starttime') endtime = request.GET.get('endtime') host_pwd_opr_log_list = models.HostPwdOprLog.objects.all() if keyword: host_pwd_opr_log_list = host_pwd_opr_log_list.filter( Q(opr_user_name__icontains=keyword)) if starttime: host_pwd_opr_log_list = host_pwd_opr_log_list.filter( opr_time__gte=starttime) if endtime: host_pwd_opr_log_list = host_pwd_opr_log_list.filter( opr_time__lte=endtime) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( host_pwd_opr_log_list, request) return render(request, "cmdb/host_pwd_opr_log.html", locals())
def taskManagement(request): # 获取所有后台对象 # page_len = request.GET.get('page_len', '') task_list = [] keyword = request.GET.get("keyword", "") if keyword: task_list = models.BgTaskManagement.objects.filter( Q(bg_module__icontains=keyword) | Q(bg_domain__icontains=keyword) | Q(bg_status__icontains=keyword) | Q(bg_lastopr_user__icontains=keyword) | Q(bg_lastopr_type__icontains=keyword) | Q(bg_lastopr_result__icontains=keyword)) else: task_list = models.BgTaskManagement.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( task_list, request) return render(request, "background/task_management.html", locals())
def clusterAppDetail(request): clusterId = request.GET.get("clusterId") cluster_app_detail_list = models.CmdbApp.objects.filter( cluster_id=clusterId) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( cluster_app_detail_list, request) return render(request, "cmdb/cluster_app_detail.html", locals())
def appDetailByMoDo(request): bg_module = request.GET.get("bg_module") bg_domain = request.GET.get("bg_domain") cmdbAppCluster_list = CmdbAppCluster.objects.filter( bgTaskManagement__bg_module=bg_module, bgTaskManagement__bg_domain=bg_domain) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( cmdbAppCluster_list, request) return render(request, "cmdb/app_management.html", locals())
def taskLogSearch(request): log_list = [] starttime = request.GET.get('starttime') endtime = request.GET.get('endtime') bg_module = request.GET.get('bg_module') bg_domain = request.GET.get('bg_domain') bg_id_list = [] # bg_operation = request.GET.get('bg_operation') #bg_opr_user = request.GET.get('bg_opr_user') if bg_domain and bg_module: tm = models.BgTaskManagement.objects.get(bg_domain=bg_domain, bg_module=bg_module) bg_id = tm.bg_id bg_id_list.append(bg_id) elif bg_domain: tm = models.BgTaskManagement.objects.filter(bg_domain=bg_domain) for i in tm: bg_id = i.bg_id bg_id_list.append(bg_id) elif bg_module: tm = models.BgTaskManagement.objects.filter(bg_module=bg_module) for i in tm: bg_id = i.bg_id bg_id_list.append(bg_id) for id in bg_id_list: if starttime and endtime: taskLog_list = BgTaskLog.objects.filter( bg_operation_time__gte=starttime, bg_operation_time__lte=endtime, bg_id=bg_id) else: taskLog_list = BgTaskLog.objects.filter(bg_id=id) for i in taskLog_list: bg_id = i.bg_id bg_log_id = i.bg_log_id taskManagement_i = models.BgTaskManagement.objects.get(bg_id=bg_id) bg_module = taskManagement_i.bg_module bg_domain = taskManagement_i.bg_domain bg_operation_user = i.bg_operation_user bg_operation = i.bg_operation bg_opr_result = i.bg_opr_result bg_operation_time = i.bg_operation_time log_dict = { "bg_log_id": bg_log_id, "bg_module": bg_module, "bg_domain": bg_domain, "bg_operation_user": bg_operation_user, "bg_operation": bg_operation, "bg_opr_result": bg_opr_result, "bg_operation_time": bg_operation_time } log_list.append(log_dict) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( log_list, request) return render(request, "background/task_log.html", locals())
def taskLog(request): # 获取所有后台对象 # page_len = request.GET.get('page_len', '') taskLog_list = models.BgTaskLog.objects.all().order_by('-bg_log_id') log_list = [] for i in taskLog_list: bg_id = i.bg_id taskManagement = models.BgTaskManagement.objects.get(bg_id=bg_id) bg_log_id = i.bg_log_id bg_module = taskManagement.bg_module bg_domain = taskManagement.bg_domain bg_operation_user = i.bg_operation_user bg_operation = i.bg_operation bg_opr_result = i.bg_opr_result bg_operation_time = i.bg_operation_time bg_operation_finish_time = i.bg_operation_finish_time log_dict = { "bg_log_id": bg_log_id, "bg_module": bg_module, "bg_domain": bg_domain, "bg_operation_user": bg_operation_user, "bg_operation": bg_operation, "bg_opr_result": bg_opr_result, "bg_operation_time": bg_operation_time, "bg_operation_finish_time": bg_operation_finish_time } log_list.append(log_dict) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( log_list, request) return render(request, "background/task_log.html", locals())
def cFinanceMgntSearch(request): #定义查询条件字典 search_dict = dict() monthpicker = request.POST.get('monthpicker') if monthpicker: search_dict['opr_cycle'] = monthpicker area_list = request.POST.getlist('area_list') if area_list: search_dict['opr_area__in'] = area_list result_list = request.POST.getlist('result_list') if result_list: search_dict['opr_check_result__in'] = result_list #将3个查询条件进行或查询 finance_list = OprFinance.objects.filter(**search_dict) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( finance_list, request) #获取模板内容 content_html = render_to_string('operation/finance_list.html', {'page_objects': page_objects, 'page_len': page_len, 'p':p, 'show_first': show_first, 'show_end':show_end, 'end_page':end_page, 'page_range':page_range, 'current_page':current_page}) #组装返回结果 result = {'flag': "success", 'msg': '', 'html': content_html} return JsonResponse(result)
def cFinanceReco(request): financereco_list = OprFinanceReco.objects.all().order_by('-opr_finance_reco_id') p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( financereco_list, request) area_list = config.get('Finance', 'finance_area').split(', ') recoresult_list = config.get('Finance', 'finance_recoresult').split(', ') return render(request, "operation/cmiotFinanceReco.html", locals())
def pbossOrderRollback(request): order_list = PbossOrderRollback.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( order_list, request) return render(request, "order/pbossOrderRollback.html", locals())
def hostPwdOprLogPage(request): host_pwd_opr_log_list = models.HostPwdOprLog.objects.all() p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( host_pwd_opr_log_list, request) return render(request, "cmdb/host_pwd_opr_log.html", locals())
def pbossOrderRollbackSearch(request): starttime = request.GET.get('starttime') endtime = request.GET.get('endtime') order_list = PbossOrderRollback.objects.filter( order_starttime__gte=starttime, order_endtime__lte=endtime) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( order_list, request) return render(request, "order/pbossOrderRollback.html", locals())
def userSearch(request): acc_user_name = request.GET.get('acc_user_name') if acc_user_name == '': user_list = models.User.objects.all() else: user_list = models.User.objects.filter(acc_user_name=acc_user_name) p, page_objects, page_range, current_page, show_first, show_end, end_page, page_len = pages( user_list, request) return render(request, "account/user_management.html", locals())