def app_info(request):
app = App_info.objects.all()
#调用分页函数
list_page = common.page_info(request, v_keys=app, limit=100)
v_list = {}
i = 1
for k in list_page:
v_list.update({i: {}})
v_list[i]["id"] = k.id
v_list[i]["owner"] = k.owner
v_list[i]["appname"] = k.appname
v_list[i]["domain"] = k.domain
v_list[i]["project"] = k.project
v_list[i]["env_types"] = k.env_types
v_list[i]["amount"] = k.amount
v_list[i]["port"] = k.port
v_list[i]["app_status_id"] = k.app_status_id
i = i + 1
context = {
'v_list': v_list,
'list_page': list_page,
}
return render(request, 'itresource/app_info.html', context)
def itres_info(request):
itres = Itres_info.objects.all()
#调用分页函数
list_page = common.page_info(request, v_keys=itres, limit=100)
v_list = {}
i = 1
for k in list_page:
v_list.update({i: {}})
v_list[i]["id"] = k.id
v_list[i]["res_applicant"] = k.res_applicant #申请人
v_list[i]["res_types"] = k.res_types #资源类型
v_list[i]["res_department"] = k.res_department #申请部门
v_list[i]["project"] = k.project #归属项目
v_list[i]["res_approver"] = k.res_approver #审批人
v_list[i]["res_creation"] = k.res_creation #申请时间
v_list[i]["res_resid"] = k.res_resid #资源ID
v_list[i]["res_status"] = k.res_status #状态
i = i + 1
context = {
'v_list': v_list,
'list_page': list_page,
}
return render(request, 'itresource/itres_info.html', context)
def ali_slb_info(request):
rds_count = len(ali_rds)
ecs_count = len(ali_ecs)
slb_count = len(ali_slb)
#调用分页函数
list_page = common.page_info(request, v_keys=ali_slb, limit=100)
v_list = {}
i = 1
for k in list_page:
#开始遍历实例
v_list.update({i: {}})
vid = k['LoadBalancerId']
v_list[i]['id'] = k['LoadBalancerId']
v_list[i]['name'] = k['LoadBalancerName']
v_list[i]['add'] = k['Address']
select_itres_info(i=i, res_resid=vid, v_list=v_list)
i = i + 1
context = {
'v_list': v_list,
'rds_count': rds_count,
'ecs_count': ecs_count,
'slb_count': slb_count,
'list_page': list_page,
}
return render(request, 'itmessage/itmes_info_slb.html', context)
def ali_ecs_info(request):
rds_count = len(ali_rds)
ecs_count = len(ali_ecs)
slb_count = len(ali_slb)
#调用分页函数
list_page = common.page_info(request, v_keys=ali_ecs, limit=100)
v_list = {}
i = 1
for k in list_page:
#开始遍历实例
v_list.update({i: {}})
vid = k['InstanceId']
v_list[i]['id'] = k['InstanceId']
v_list[i]['name'] = k['InstanceName']
v_list[i]['pubadd'] = k['PublicIpAddress']
v_list[i]['lanadd'] = k['InnerIpAddress']
#调用公共函数查询数据库
select_itres_info(i=i, res_resid=vid, v_list=v_list)
i = i + 1
context = {
'v_list': v_list,
'rds_count': rds_count,
'ecs_count': ecs_count,
'slb_count': slb_count,
'list_page': list_page,
}
return render(request, 'itmessage/itmes_info_ecs.html', context)
def supp_info(request):
server = request.META['HTTP_HOST']
#查询状态不包含sp_status=1 的数据
supp_info = supplier_info.objects.exclude(sp_status=1)
#实现分页 调用分页函数
list_page = common.page_info(request=request, v_keys=supp_info, limit=200)
##定义空值导入数据库数值 ilt = "itres list"
v_list = {}
i = 1
for k in list_page:
v_list.update({i: {}})
v_list[i]["id"] = k.id
v_list[i]["applicant"] = k.sp_applicant #申请人
v_list[i]["project"] = k.sp_project #归属项目
v_list[i]["creation"] = k.sp_creation #申请时间
v_list[i]["sp_id"] = k.sp_id #供应商ID
v_list[i]["addr"] = k.sp_addr #地址
v_list[i]["zone"] = k.sp_zone #区域
v_list[i]["user"] = k.sp_user #用户名
v_list[i]["status"] = k.sp_status #状态
v_list[i]["status_id"] = k.sp_status_id
i = i + 1
context = {
'v_list': v_list,
'list_page': list_page,
}
return render(request, 'supplier/supplier_info.html', context)