search_software.html

{% extends 'base.html' %}

{% block title %}

软件名字 <input type="text" id="mname" name="mname" value="{

{ mname }}" class="ui_input_txt02" />

</div>

软件名字 <input type="text" id="softwarename" name="softwarename" class="ui_input_txt02" />

授权数 <input type="text" id="softwarelicense_num" name="softwarelicense_num" class="ui_input_txt02" />

版本号 <input type="text" id="softwareversion" name="softwareversion" class="ui_input_txt02" />

</div>

{% if softwarelist.has_previous %}

<a href="javascript:void(0)" οnclick="search_software({

{ softwarelist.previous_page_number }});">上一页</a>

{% endif %}

        Page {
    { softwarelist.number }} of {
    { softwarelist.paginator.num_pages }}.        {% if softwarelist.has_next %}        下一页    {% endif %}

</div>

<input type="button" value="编辑" class="ui_input_btn01" οnclick="edit_software({

{ softwarelist.number }});" />

</div>

</form>

</div>

{% endblock %}

{% block content %}

<tr>

</th>

</tr>

{% for mr in softwarelist.object_list %}

<tr>

<td><input type="checkbox" name="idcheck" value={

{ mr.id }} class="acb" /></td>

<td>{

{ mr.name }}</td>

<td>{

{ mr.license_num }}</td>

<td>{

{ mr.version }}</td>

<td>

<a href="javascript:void(0)" οnclick="edit_mr('{

{ mr.id }}','{

{ mr.name }}','{

{ mr.license_num }}','{

{ mr.version }}')" class="edit">编辑</a>

<a href="javascript:void(0)" οnclick="del_software({

{ mr.id }},{

{ softwarelist.number }});">删除</a>

</td>

</tr>

{% endfor %}

</table>

</div>

function search_software(page){

var text1 = document.getElementById("mname").value;

var myurl="search_software.html"+"?"+"mname="+text1+"&&page="+page;

window.location.assign(encodeURI(myurl))

}

function edit_mr(id,name,license_num,version){

document.getElementById("softwareid").value=id;

document.getElementById("softwarename").value=name;

document.getElementById("softwarelicense_num").value=license_num;

document.getElementById("softwareversion").value=version;

}

function edit_software(page){

var text1 = document.getElementById("mname").value;

id=document.getElementById("softwareid").value;

name=document.getElementById("softwarename").value;

license_num=document.getElementById("softwarelicense_num").value;

version=document.getElementById("softwareversion").value;

var myurl="edit_software.html"+"?"+"id="+id+"&&name="+name+"&&license_num="+license_num+"&&version="+version+"&&mname="+text1+"&&page="+page;

window.location.assign(encodeURI(myurl))

}

function del_software(id,page){

if(window.confirm('确定要删除该记录吗？')){

var text1= document.getElementById("mname").value;

var myurl="del_software.html"+"?"+"id="+id+"&&mname="+text1+"&&page="+page;

window.location.assign(encodeURI(myurl))

return true;

}else{

//alert("取消");

return false;

}

function batdel_software(){

if(window.confirm('确定要删除记录吗？')){

obj = document.getElementsByName("idcheck");

var text1= document.getElementById("mname").value;

check_val = [];

for(k in obj){

if(obj[k].checked)

check_val.push(obj[k].value);

}

var myurl="batdel_software.html"+"?"+"ids="+check_val+"&&mname="+text1;

window.location.assign(encodeURI(myurl))

return true;

}else{

return false;

}

function excel_software(){

var text1 = document.getElementById("mname").value;

var myurl="excel_software.html"+"?"+"mname="+text1;

window.location.assign(encodeURI(myurl))

}

</script>

{% endblock %}

search_manufactory.html

{% extends 'base.html' %}

{% block title %}

厂商名字 <input type="text" id="mname" name="mname" value="{

{ mname }}" class="ui_input_txt02" />

</div>

厂商名字 <input type="text" id="manufactorymanufactory" name="manufactorymanufactory" class="ui_input_txt02" />

厂商电话 <input type="text" id="manufactorysupport_num" name="manufactorysupport_num" class="ui_input_txt02" />

备注 <input type="text" id="manufactorymemo" name="manufactorymemo" class="ui_input_txt02" />

</div>

{% if manufactorylist.has_previous %}

<a href="javascript:void(0)" οnclick="search_manufactory({

{ manufactorylist.previous_page_number }});">上一页</a>

{% endif %}

        Page {
    { manufactorylist.number }} of {
    { manufactorylist.paginator.num_pages }}.        {% if manufactorylist.has_next %}        下一页    {% endif %}

</div>

<input type="button" value="编辑" class="ui_input_btn01" οnclick="edit_manufactory({

{ manufactorylist.number }});" />

</div>

</form>

</div>

{% endblock %}

{% block content %}

<tr>

</th>

</tr>

{% for mr in manufactorylist.object_list %}

<tr>

<td><input type="checkbox" name="idcheck" value={

{ mr.id }} class="acb" /></td>

<td>{

{ mr.manufactory }}</td>

<td>{

{ mr.support_num }}</td>

<td>{

{ mr.memo }}</td>

<td>

<a href="javascript:void(0)" οnclick="edit_mr('{

{ mr.id }}','{

{ mr.manufactory }}','{

{ mr.support_num }}','{

{ mr.memo }}')" class="edit">编辑</a>

<a href="javascript:void(0)" οnclick="del_manufactory({

{ mr.id }},{

{ manufactorylist.number }});">删除</a>

</td>

</tr>

{% endfor %}

</table>

</div>

function search_manufactory(page){

var text1 = document.getElementById("mname").value;

var myurl="search_manufactory.html"+"?"+"mname="+text1+"&&page="+page;

window.location.assign(encodeURI(myurl))

}

function edit_mr(id,name,license_num,version){

document.getElementById("manufactoryid").value=id;

document.getElementById("manufactorymanufactory").value=name;

document.getElementById("manufactorysupport_num").value=license_num;

document.getElementById("manufactorymemo").value=version;

}

function edit_manufactory(page){

var text1 = document.getElementById("mname").value;

id=document.getElementById("manufactoryid").value;

name=document.getElementById("manufactorymanufactory").value;

license_num=document.getElementById("manufactorysupport_num").value;

version=document.getElementById("manufactorymemo").value;

var myurl="edit_manufactory.html"+"?"+"id="+id+"&&manufactory="+name+"&&support_num="+license_num+"&&memo="+version+"&&mname="+text1+"&&page="+page;

window.location.assign(encodeURI(myurl))

}

function del_manufactory(id,page){

if(window.confirm('确定要删除该记录吗？')){

var text1= document.getElementById("mname").value;

var myurl="del_manufactory.html"+"?"+"id="+id+"&&mname="+text1+"&&page="+page;

window.location.assign(encodeURI(myurl))

return true;

}else{

//alert("取消");

return false;

}

function batdel_manufactory(){

if(window.confirm('确定要删除记录吗？')){

obj = document.getElementsByName("idcheck");

var text1= document.getElementById("mname").value;

check_val = [];

for(k in obj){

if(obj[k].checked)

check_val.push(obj[k].value);

}

var myurl="batdel_manufactory.html"+"?"+"ids="+check_val+"&&mname="+text1;

window.location.assign(encodeURI(myurl))

return true;

}else{

return false;

}

function excel_manufactory(){

var text1 = document.getElementById("mname").value;

var myurl="excel_manufactory.html"+"?"+"mname="+text1;

window.location.assign(encodeURI(myurl))

}

</script>

{% endblock %}

cmdbapp/softwareviews.py

-- coding: utf-8 --

from future import unicode_literals

from django.shortcuts import render,render_to_response

from django.core.paginator import Paginator,InvalidPage,EmptyPage

from cmdbapp.models import *

from django.http import HttpResponse

from django.http import HttpResponseRedirect

from xlwt import *

import StringIO

def search_software(request):

error = False

each_page = 5

mname=request.GET.get('mname','0')

if mname=='0' or mname.strip()=='':

record_list = Software.objects.all()

mname=''

paginator = Paginator(record_list,each_page)

try:

page = int(request.GET.get('page', '1'))

except ValueError:

page = 1

try:

contacts = paginator.page(page)

except (EmptyPage, InvalidPage):

contacts = paginator.page(paginator.num_pages)

return render_to_response('search_software.html',{'softwarelist':contacts,"mname":mname})

else:

record_list = Software.objects.filter(name=mname)        paginator = Paginator(record_list,each_page)        try:            page = int(request.GET.get('page', '1'))        except ValueError:            page = 1        try:            contacts = paginator.page(page)        except (EmptyPage, InvalidPage):            contacts = paginator.page(paginator.num_pages)        return render_to_response('search_software.html',{'softwarelist':contacts,"mname":mname})

def add_software(request):

n = request.POST.get('softwarename')

v = request.POST.get('softwareversion')

l = request.POST.get('softwarelicense_num')

Software.objects.create(name=n,license_num=l,version=v)

return HttpResponseRedirect('search_software.html')

def edit_software(request):

id=request.GET.get('id')

iid=int(id)

name=request.GET.get('name')

l=request.GET.get('license_num')

v=request.GET.get('version')

Software.objects.filter(id=iid).update(name=name,license_num=l,version=v)

page=request.GET.get('page')

mname=request.GET.get('mname')

return HttpResponseRedirect('search_software.html?mname='+mname+"&&page="+page)

def del_software(request):

id=request.GET.get('id')

iid=int(id)

Software.objects.filter(id=iid).delete()

page=request.GET.get('page')

mname=request.GET.get('mname')

return HttpResponseRedirect('search_software.html?mname='+mname+"&&page="+page)

def batdel_software(request):

ids=request.GET.get('ids')

b=ids.split(',')

arr = map(int,b)

for aaa in arr:

Software.objects.filter(id=aaa).delete()

mname=request.GET.get('mname')

return HttpResponseRedirect('search_software.html?mname='+mname)

def excel_software(request):

mname=request.GET.get('mname','0')

if mname=='0' or mname.strip()=='':

list_obj = Software.objects.all()

mname=''

else:

list_obj = Software.objects.filter(name=mname)

if list_obj:

# 创建工作薄

ws = Workbook(encoding='utf-8')

w = ws.add_sheet(u"软件清单")

w.write(0, 0, "id")

w.write(0, 1, u"软件名字")

w.write(0, 2, u"授权数")

w.write(0, 3, u"版本号")

# 写入数据

excel_row = 1

for obj in list_obj:

data_id = obj.id

data_name = obj.name

data_license_num = obj.license_num

data_version = obj.version

w.write(excel_row, 0, data_id)

w.write(excel_row, 1, data_name)

w.write(excel_row, 2, data_license_num)

w.write(excel_row, 3, data_version)

excel_row += 1

sio = StringIO.StringIO()

ws.save(sio)

sio.seek(0)

response = HttpResponse(sio.getvalue(), content_type='application/vnd.ms-excel')

response['Content-Disposition'] = 'attachment; filename=机房清单-'+mname+'.xls'

response.write(sio.getvalue())

return response

cmdbapp/manufactoryviews.py

-- coding: utf-8 --

from future import unicode_literals

from django.shortcuts import render,render_to_response

from django.core.paginator import Paginator,InvalidPage,EmptyPage

from cmdbapp.models import *

from django.http import HttpResponse

from django.http import HttpResponseRedirect

from xlwt import *

import StringIO

def search_manufactory(request):

error = False

each_page = 5

mname=request.GET.get('mname','0')

if mname=='0' or mname.strip()=='':

record_list = Manufactory.objects.all()

mname=''

paginator = Paginator(record_list,each_page)

try:

page = int(request.GET.get('page', '1'))

except ValueError:

page = 1

try:

contacts = paginator.page(page)

except (EmptyPage, InvalidPage):

contacts = paginator.page(paginator.num_pages)

return render_to_response('search_manufactory.html',{'manufactorylist':contacts,"mname":mname})

else:

record_list = Manufactory.objects.filter(name=mname)        paginator = Paginator(record_list,each_page)        try:            page = int(request.GET.get('page', '1'))        except ValueError:            page = 1        try:            contacts = paginator.page(page)        except (EmptyPage, InvalidPage):            contacts = paginator.page(paginator.num_pages)        return render_to_response('search_manufactory.html',{'manufactorylist':contacts,"mname":mname})

def add_manufactory(request):

n = request.POST.get('manufactorymanufactory')

v = request.POST.get('manufactorysupport_num')

l = request.POST.get('manufactorymemo')

Manufactory.objects.create(manufactory=n,support_num=v,memo=l)

return HttpResponseRedirect('search_manufactory.html')

def edit_manufactory(request):

id=request.GET.get('id')

iid=int(id)

name=request.GET.get('manufactory')

l=request.GET.get('support_num')

v=request.GET.get('memo')

Manufactory.objects.filter(id=iid).update(manufactory=name,support_num=l,memo=v)

page=request.GET.get('page')

mname=request.GET.get('mname')

return HttpResponseRedirect('search_manufactory.html?mname='+mname+"&&page="+page)

def del_manufactory(request):

id=request.GET.get('id')

iid=int(id)

Manufactory.objects.filter(id=iid).delete()

page=request.GET.get('page')

mname=request.GET.get('mname')

return HttpResponseRedirect('search_manufactory.html?mname='+mname+"&&page="+page)

def batdel_manufactory(request):

ids=request.GET.get('ids')

b=ids.split(',')

arr = map(int,b)

for aaa in arr:

Manufactory.objects.filter(id=aaa).delete()

mname=request.GET.get('mname')

return HttpResponseRedirect('search_manufactory.html?mname='+mname)

def excel_manufactory(request):

mname=request.GET.get('mname','0')

if mname=='0' or mname.strip()=='':

list_obj = Manufactory.objects.all()

mname=''

else:

list_obj = Manufactory.objects.filter(name=mname)

if list_obj:

# 创建工作薄

ws = Workbook(encoding='utf-8')

w = ws.add_sheet(u"厂商清单")

w.write(0, 0, "id")

w.write(0, 1, u"厂商名字")

w.write(0, 2, u"电话")

w.write(0, 3, u"备注")

# 写入数据

excel_row = 1

for obj in list_obj:

data_id = obj.id

data_name = obj.manufactory

data_license_num = obj.support_num

data_version = obj.memo

w.write(excel_row, 0, data_id)

w.write(excel_row, 1, data_name)

w.write(excel_row, 2, data_license_num)

w.write(excel_row, 3, data_version)

excel_row += 1

sio = StringIO.StringIO()

ws.save(sio)

sio.seek(0)

response = HttpResponse(sio.getvalue(), content_type='application/vnd.ms-excel')

response['Content-Disposition'] = 'attachment; filename=机房清单-'+mname+'.xls'

response.write(sio.getvalue())

return response

cmdb/urls.py

"""cmdb URL Configuration

The urlpatterns list routes URLs to views. For more information please see:

Examples:

Function views

1. Add an import: from my_app import views

2. Add a URL to urlpatterns: url(r'^

', views.home, name='home') Class-based views 1. Add an import: from other_app.views import Home 2. Add a URL to urlpatterns: url(r'^

', Home.as_view(), name='home')

Including another URLconf

1. Import the include() function: from django.conf.urls import url, include

2. Add a URL to urlpatterns: url(r'^blog/', include('blog.urls'))

"""

from django.conf.urls import url

from django.contrib import admin

from cmdbapp import machinaroomviews,serverviews,networkdeviceviews,securitydeviceviews,softwareviews,storagedeviceviews,manufactoryviews

from django.contrib.auth.views import *

from django.contrib.staticfiles.urls import staticfiles_urlpatterns

from django.contrib import staticfiles

from django.views.static import serve

urlpatterns = [

url(r'^static/(?P<path>.*)

',serve,{'document_root': settings.STATIC_ROOT}), url(r'^

',machinaroomviews.main_page,name='main_page'),

url(r'^base',machinaroomviews.base,name='base'),

url(r'^search_machinaroom.html

',machinaroomviews.search_machinaroom,name='search_machinaroom'), url(r'^add_machinaroom.html

',machinaroomviews.add_machinaroom,name='add_machinaroom'),

url(r'^edit_machinaroom.html',machinaroomviews.edit_machinaroom,name='edit_machinaroom'),

url(r'^del_machinaroom.html',machinaroomviews.del_machinaroom,name='del_machinaroom'),

url(r'^batdel_machinaroom.html',machinaroomviews.batdel_machinaroom,name='batdel_machinaroom'),

url(r'^excel_machinaroom.html',machinaroomviews.excel_machinaroom,name='excel_machinaroom'),

url(r'^login/

', login), url(r'^search_server.html

',serverviews.search_server,name='search_server'),

url(r'^add_server.html

',serverviews.add_server,name="add_server"), url(r'^edit_server.html

',serverviews.edit_server,name="edit_server"),

url(r'^del_server.html',serverviews.del_server,name='del_server'),

url(r'^batdel_server.html',serverviews.batdel_server,name='batdel_server'),

url(r'^excel_server.html',serverviews.excel_server,name='excel_server'),

url(r'^search_networkdevice.html

',networkdeviceviews.search_networkdevice,name='search_networkdevice'), url(r'^add_networkdevice.html

',networkdeviceviews.add_networkdevice,name="add_networkdevice"),

url(r'^edit_networkdevice.html

',networkdeviceviews.edit_networkdevice,name="edit_networkdevice"), url(r'^del_networkdevice.html',networkdeviceviews.del_networkdevice,name='del_networkdevice'), url(r'^batdel_networkdevice.html',networkdeviceviews.batdel_networkdevice,name='batdel_networkdevice'), url(r'^excel_networkdevice.html',networkdeviceviews.excel_networkdevice,name='excel_networkdevice'), url(r'^search_securitydevice.html

',securitydeviceviews.search_securitydevice,name='search_securitydevice'),

url(r'^add_securitydevice.html

',securitydeviceviews.add_securitydevice,name="add_securitydevice"), url(r'^edit_securitydevice.html

',securitydeviceviews.edit_securitydevice,name="edit_securitydevice"),

url(r'^del_securitydevice.html',securitydeviceviews.del_securitydevice,name='del_securitydevice'),

url(r'^batdel_securitydevice.html',securitydeviceviews.batdel_securitydevice,name='batdel_securitydevice'),

url(r'^excel_securitydevice.html',securitydeviceviews.excel_securitydevice,name='excel_securitydevice'),

url(r'^search_storagedevice.html

',storagedeviceviews.search_storagedevice,name='search_storagedevice'), url(r'^add_storagedevice.html

',storagedeviceviews.add_storagedevice,name="add_storagedevice"),

url(r'^edit_storagedevice.html

',storagedeviceviews.edit_storagedevice,name="edit_storagedevice"), url(r'^del_storagedevice.html',storagedeviceviews.del_storagedevice,name='del_storagedevice'), url(r'^batdel_storagedevice.html',storagedeviceviews.batdel_storagedevice,name='batdel_storagedevice'), url(r'^excel_storagedevice.html',storagedeviceviews.excel_storagedevice,name='excel_storagedevice'), url(r'^search_software.html

',softwareviews.search_software,name='search_software'),

url(r'^add_software.html

',softwareviews.add_software,name='add_software'), url(r'^edit_software.html',softwareviews.edit_software,name='edit_software'), url(r'^del_software.html',softwareviews.del_software,name='del_software'), url(r'^batdel_software.html',softwareviews.batdel_software,name='batdel_software'), url(r'^excel_software.html',softwareviews.excel_software,name='excel_software'), url(r'^search_manufactory.html

',manufactoryviews.search_manufactory,name='search_manufactory'),

url(r'^add_manufactory.html$',manufactoryviews.add_manufactory,name='add_manufactory'),

url(r'^edit_manufactory.html',manufactoryviews.edit_manufactory,name='edit_manufactory'),

url(r'^del_manufactory.html',manufactoryviews.del_manufactory,name='del_manufactory'),

url(r'^batdel_manufactory.html',manufactoryviews.batdel_manufactory,name='batdel_manufactory'),

url(r'^excel_manufactory.html',manufactoryviews.excel_manufactory,name='excel_manufactory'),

]