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