def job_detail(request, ids):
proj_base_dir = get_dir("pro_path")
obj = {}
obj_job = get_object(job, id=ids)
obj_playbook = obj_job.playbook
obj_project = get_object(project, name=obj_job.project)
obj_pro_path = obj_project.path
pkfile = proj_base_dir + obj_pro_path + "/" + obj_playbook
obj["name"] = obj_playbook
with open(pkfile, 'r') as f:
obj["content"] = f.read()
return render_to_response('sktask/job_detail.html', locals(),
RequestContext(request))
def url_del(request):
url_id = request.GET.get('id', '')
if url_id:
Url.objects.filter(id=url_id).delete()
if request.method == 'POST':
url_id_all = str(request.POST.get('url_id_all', ''))
if url_id_all:
for url_id in url_id_all.split(','):
url = get_object(Url, id=url_id)
url.delete()
return HttpResponse(u'删除成功')
def asset_edit(request, ids):
status = 0
obj = get_object(Host, id=ids)
if request.method == 'POST':
af = AssetForm(request.POST, instance=obj)
if af.is_valid():
af.save()
status = 1
else:
status = 2
else:
af = AssetForm(instance=obj)
return render_to_response('skcmdb/asset_edit.html', locals(),
RequestContext(request))
def app_del(request):
app_id = request.GET.get('id', '')
if app_id:
App.objects.filter(id=app_id).delete()
if request.method == 'POST':
app_batch = request.GET.get('arg', '')
app_id_all = str(request.POST.get('app_id_all', ''))
if app_batch:
for app_id in app_id_all.split(','):
app = get_object(App, id=app_id)
app.delete()
return HttpResponse(u'删除成功')
def asset_del(request):
asset_id = request.GET.get('id', '')
if asset_id:
Host.objects.filter(id=asset_id).delete()
if request.method == 'POST':
asset_batch = request.GET.get('arg', '')
asset_id_all = str(request.POST.get('asset_id_all', ''))
if asset_batch:
for asset_id in asset_id_all.split(','):
asset = get_object(Host, id=asset_id)
asset.delete()
return HttpResponse(u'删除成功')
def job_edit(request, ids):
status = 0
# asset_types = online_status
obj = get_object(job, id=ids)
# obj = job.objects.get(id=ids)
if request.method == 'POST':
obj_f = Job_form(request.POST, instance=obj)
if obj_f.is_valid():
obj_f.save()
status = 1
else:
status = 2
else:
obj_f = Job_form(instance=obj)
return render_to_response("sktask/job_edit.html", locals(),
RequestContext(request))
def UserGroup_edit(request, ids):
temp_name = "skaccounts/accounts-header.html"
status = 0
obj = get_object(UserGroup, id=ids)
if request.method == 'POST':
tpl_UserGroup_form = UserGroup_form(request.POST, instance=obj)
if tpl_UserGroup_form.is_valid():
tpl_UserGroup_form.save()
status = 1
return HttpResponseRedirect(reverse('UserGroup_index'))
else:
status = 3
else:
tpl_UserGroup_form = UserGroup_form(instance=obj)
return render_to_response("skaccounts/UserGroup_edit.html", locals(),
RequestContext(request))
def asset(request):
temp_name = "skcmdb/cmdb-header.html"
idc_info = Idc.objects.all()
sa_info = UserInfo.objects.filter(type=1)
env_info = Env.objects.all()
ywgroup_info = YwGroup.objects.all()
hosttype_info = HostGroup.objects.all()
middletype_info = MiddleType.objects.all()
host_list = Host.objects.all()
group_info = HostGroup.objects.all()
asset_status = ASSET_STATUS
idc_name = request.GET.get('idc', '')
sa_name = request.GET.get('sa', '')
env_name = request.GET.get('env', '')
ywgroup_name = request.GET.get('ywgroup', '')
hostgroup_name = request.GET.get('hostgroup', '')
middletype_name = request.GET.get('middletype', '')
status = request.GET.get('status', '')
keyword = request.GET.get('keyword', '')
export = request.GET.get("export", '')
group_id = request.GET.get("group_id", '')
idc_id = request.GET.get("idc_id", '')
asset_id_all = request.GET.getlist("id", '')
if group_id:
group = get_object(HostGroup, id=group_id)
if group:
asset_find = Host.objects.filter(group=group)
elif idc_id:
idc = get_object(Idc, id=idc_id)
if idc:
asset_find = Host.objects.filter(idc=idc)
else:
asset_find = Host.objects.all()
if idc_name:
asset_find = asset_find.filter(idc__name__contains=idc_name)
if sa_name:
asset_find = asset_find.filter(sa__nickname__contains=sa_name)
if env_name:
asset_find = asset_find.filter(env__name__contains=env_name)
if ywgroup_name:
asset_find = asset_find.filter(ywgroup__name__contains=ywgroup_name)
if hostgroup_name:
asset_find = asset_find.filter(group__name__contains=hostgroup_name)
if middletype_name:
asset_find = asset_find.filter(
middletype__name__contains=middletype_name)
if status:
asset_find = asset_find.filter(status__contains=status)
if keyword:
asset_find = asset_find.filter(
Q(hostname__contains=keyword) | Q(ip__contains=keyword)
| Q(other_ip__contains=keyword) | Q(os__contains=keyword)
| Q(vendor__contains=keyword) | Q(cpu_model__contains=keyword)
| Q(cpu_num__contains=keyword) | Q(memory__contains=keyword)
| Q(disk__contains=keyword) | Q(sn__contains=keyword)
| Q(position__contains=keyword) | Q(memo__contains=keyword))
if export == "true":
if asset_id_all:
asset_find = []
for asset_id in asset_id_all:
asset = get_object(Host, id=asset_id)
if asset:
asset_find.append(asset)
response = HttpResponse(content_type='text/csv')
now = datetime.datetime.now().strftime('%Y_%m_%d_%H_%M')
file_name = 'hostsesset_cmdb_' + now + '.csv'
response[
'Content-Disposition'] = "attachment; filename=" + file_name
writer = csv.writer(response)
writer.writerow([
str2gb('主机名'),
str2gb('IP地址'),
str2gb('其它IP'),
str2gb('主机分组'),
str2gb('负责人'),
str2gb('运行环境'),
str2gb('业务分组'),
str2gb('主机类型'),
str2gb('资产编号'),
str2gb('设备状态'),
str2gb('操作系统'),
str2gb('设备厂商'),
str2gb('CPU型号'),
str2gb('CPU核数'),
str2gb('内存大小'),
str2gb('硬盘信息'),
str2gb('SN号码'),
str2gb('所在机房'),
str2gb('所在位置'),
str2gb('备注信息')
])
for h in asset_find:
if h.status:
at_as = int(h.status)
a_status = ASSET_STATUS[at_as - 1][1]
else:
a_status = ""
if h.sa:
a_sa = h.sa.nickname
else:
a_sa = ""
writer.writerow([
str2gb(h.hostname), h.ip, h.other_ip,
str2gb(h.group),
str2gb(a_sa),
str2gb(h.env),
str2gb(h.ywgroup),
str2gb(h.middletype),
str2gb(h.asset_no),
str2gb(a_status),
str2gb(h.os),
str2gb(h.vendor),
str2gb(h.cpu_model),
str2gb(h.cpu_num),
str2gb(h.memory),
str2gb(h.disk),
str2gb(h.sn),
str2gb(h.idc),
str2gb(h.position),
str2gb(h.memo)
])
return response
if export == "all":
host = Host.objects.all()
response = HttpResponse(content_type='text/csv')
now = datetime.datetime.now().strftime('%Y_%m_%d_%H_%M')
file_name = 'hostsesset_cmdb_' + now + '.csv'
response['Content-Disposition'] = "attachment; filename=" + file_name
writer = csv.writer(response)
writer.writerow([
str2gb('主机名'),
str2gb('IP地址'),
str2gb('其它IP'),
str2gb('主机分组'),
str2gb('负责人'),
str2gb('运行环境'),
str2gb('业务分组'),
str2gb('主机类型'),
str2gb('资产编号'),
str2gb('设备状态'),
str2gb('操作系统'),
str2gb('设备厂商'),
str2gb('CPU型号'),
str2gb('CPU核数'),
str2gb('内存大小'),
str2gb('硬盘信息'),
str2gb('SN号码'),
str2gb('所在机房'),
str2gb('所在位置'),
str2gb('备注信息')
])
for h in host:
if h.status:
at_as = int(h.status)
a_status = ASSET_STATUS[at_as - 1][1]
else:
a_status = ""
if h.sa:
a_sa = h.sa.nickname
else:
a_sa = ""
writer.writerow([
str2gb(h.hostname), h.ip, h.other_ip,
str2gb(h.group),
str2gb(a_sa),
str2gb(h.env),
str2gb(h.ywgroup),
str2gb(h.middletype),
str2gb(h.asset_no),
str2gb(a_status),
str2gb(h.os),
str2gb(h.vendor),
str2gb(h.cpu_model),
str2gb(h.cpu_num),
str2gb(h.memory),
str2gb(h.disk),
str2gb(h.sn),
str2gb(h.idc),
str2gb(h.position),
str2gb(h.memo)
])
return response
assets_list, p, assets, page_range, current_page, show_first, show_end = pages(
asset_find, request)
return render_to_response('skcmdb/index.html', locals(),
RequestContext(request))