def server_updatemore(request):
mydict = {
"mynotice":"", # 状态提示条
'status':Server.STATUS,
}
if request.method == 'POST':
moreid = request.GET.get('moreid', '')
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
servicetype = request.POST.get('servicetype', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status','')
comment = request.POST.get('comment', '')
if company == '' or department == '' or principal == '' or servicetype == '' or guarantee == '' or buydate == '' :
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'server/server_updatemore.html',mydict)
moreid = commons.str_to_list(moreid) #将传过来的字符串转换为list
Server.objects.filter(id__in = moreid).update(company=company,department=department,principal=principal,servicetype=servicetype,guarantee=guarantee,buydate=buydate,user=user,status=status,comment=comment)
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/server/list/")
return render(request,'server/server_updatemore.html',mydict)
def idcroom_add(request):
mydict = {
"mynotice": "", # 状态提示条
}
if request.method == 'POST':
name = request.POST.get('name', '')
user = request.user.username
comment = request.POST.get('comment', '')
if name == '' and comment == '':
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，带星号（*）表单不能为空！")
return render(request, 'idcroom/idcroom_add.html', mydict)
if Idcroom.objects.filter(name=name):
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，此名称已存在！")
return render(request, 'idcroom/idcroom_add.html', mydict)
idcroom = Idcroom(
name=name,
user=user,
comment=comment,
)
idcroom.save()
commons.mynotice(request, "add", "success")
return HttpResponseRedirect("/idcroom/list/")
return render(request, 'idcroom/idcroom_add.html', mydict)
def group_add(request):
mynotice = "" # 状态提示条
mydict = {"mynotice": mynotice, "permissions_all": PERMISSIONS}
if request.method == 'POST':
name = request.POST.get('name', '')
permissions = request.POST.getlist('permissions[]', '')
comment = request.POST.get('comment', '')
if name == '' or commons == '':
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，带星号（*）表单不能为空！")
return render(request, 'myauth/group_add.html', mydict)
if Group.objects.filter(name=name):
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，此分组已存在！")
return render(request, 'myauth/group_add.html', mydict)
group = Group(
name=name,
permissions=commons.list_to_str(permissions),
comment=comment,
)
group.save()
commons.mynotice(request, "add", "success")
return HttpResponseRedirect("/myauth/group/list?action=add")
return render(request, 'myauth/group_add.html', mydict)
def group_add(request):
mynotice = "" # 状态提示条
mydict = {"mynotice": mynotice,
"permissions_all":PERMISSIONS
}
if request.method == 'POST':
name = request.POST.get('name', '')
permissions = request.POST.getlist('permissions[]', '')
comment = request.POST.get('comment', '')
if name == '' or commons == '':
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'myauth/group_add.html',mydict)
if Group.objects.filter(name=name):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此分组已存在！")
return render(request,'myauth/group_add.html',mydict)
group = Group(
name = name,
permissions = commons.list_to_str(permissions),
comment = comment,
)
group.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/myauth/group/list?action=add")
return render(request,'myauth/group_add.html',mydict)
def idcroom_add(request):
mydict = {"mynotice": "", # 状态提示条
}
if request.method == 'POST':
name = request.POST.get('name', '')
user = request.user.username
comment = request.POST.get('comment', '')
if name == '' and comment == '':
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'idcroom/idcroom_add.html',mydict)
if Idcroom.objects.filter(name=name):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此名称已存在！")
return render(request,'idcroom/idcroom_add.html',mydict)
idcroom = Idcroom(
name = name,
user = user,
comment = comment,
)
idcroom.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/idcroom/list/")
return render(request,'idcroom/idcroom_add.html',mydict)
def diskbk_update(request,id):
#id = request.REQUEST.get('id')
sqldata = Diskbk.objects.get(id=id)
idcroom = Idcroom.objects.all() # 获取机房列表
# 状态，OrderedDict保持字典原来顺序
STATUS = OrderedDict([
('backup','备件'),
('fault','故障'),
('scrap','报废'),
])
mydict = {"sqldata":sqldata,
"mynotice":"", # 状态提示条
"idcroom":idcroom,
"status":STATUS
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
brand = request.POST.get('brand', '')
type = request.POST.get('type', '')
capacity = request.POST.get('capacity', '')
status = request.POST.get('status', '')
idcroom_id = request.POST.get('idcroom_id', '')
user = request.user.username
comment = request.POST.get('comment', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
if sn == '' or brand == '' or type == '' or capacity == '' or guarantee == '' or buydate == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'backup/diskbk_update.html',mydict)
if sqldata.sn != sn and len(Idcroom.objects.filter(sn=sn)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此序列号已存在！")
return render(request,'backup/diskbk_update.html',mydict)
diskbk = Diskbk.objects.get(id = id)
diskbk.sn = sn
diskbk.brand = brand
diskbk.type = type
diskbk.capacity = capacity
diskbk.status = status
diskbk.idcroom_id = idcroom_id
diskbk.user = user
diskbk.comment = comment
diskbk.guarantee = guarantee
diskbk.buydate = buydate
diskbk.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/backup/diskbk/list/")
return render(request,'backup/diskbk_update.html',mydict)
def memorybk_add(request):
idcroom = Idcroom.objects.all() # 获取机房列表
# 状态，OrderedDict保持字典原来顺序
STATUS = OrderedDict([
('backup','备件'),
('fault','故障'),
('scrap','报废'),
])
mydict = {"mynotice": "", # 状态提示条
"idcroom":idcroom,
"status":STATUS
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
brand = request.POST.get('brand', '')
type = request.POST.get('type', '')
capacity = request.POST.get('capacity', '')
status = request.POST.get('status', '')
idcroom_id = request.POST.get('idcroom_id', '')
user = request.user.username
comment = request.POST.get('comment', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
if sn == '' or brand == '' or type == '' or capacity == '' or guarantee == '' or buydate == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'backup/memorybk_add.html',mydict)
if Memorybk.objects.filter(sn=sn):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此序列号已存在！")
return render(request,'backup/memorybk_add.html',mydict)
memorybk = Memorybk(
sn = sn,
brand = brand,
type = type,
capacity = capacity,
status = status,
idcroom_id = idcroom_id,
user = user,
comment = comment,
guarantee = guarantee,
buydate = buydate,
)
memorybk.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/backup/memorybk/list/")
return render(request,'backup/memorybk_add.html',mydict)
def serverbk_update(request,id):
#id = request.REQUEST.get('id')
sqldata = Serverbk.objects.get(id=id)
idcroom = Idcroom.objects.all() # 获取机房列表
mydict = {"sqldata":sqldata,
"mynotice":"", # 状态提示条
"idcroom":idcroom
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
brand = request.POST.get('brand', '')
model = request.POST.get('model', '')
cpu = request.POST.get('cpu', '')
memory = request.POST.get('memory', '')
disk = request.POST.get('disk', '')
idcroom_id = request.POST.get('idcroom_id', '')
user = request.user.username
comment = request.POST.get('comment', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
if sn == '' or brand == '' or model == '' or cpu == '' or memory == '' or disk == '' or guarantee == '' or buydate == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'backup/serverbk_update.html',mydict)
if sqldata.sn != sn and len(Idcroom.objects.filter(sn=sn)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此序列号已存在！")
return render(request,'backup/serverbk_update.html',mydict)
serverbk = Serverbk.objects.get(id = id)
serverbk.sn = sn
serverbk.brand = brand
serverbk.model = model
serverbk.cpu = cpu
serverbk.memory = memory
serverbk.disk = disk
serverbk.idcroom_id = idcroom_id
serverbk.user = user
serverbk.comment = comment
serverbk.guarantee = guarantee
serverbk.buydate = buydate
serverbk.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/backup/serverbk/list/")
return render(request,'backup/serverbk_update.html',mydict)
def serverbk_add(request):
idcroom = Idcroom.objects.all() # 获取机房列表
mydict = {"mynotice": "", # 状态提示条
"idcroom":idcroom,
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
brand = request.POST.get('brand', '')
model = request.POST.get('model', '')
cpu = request.POST.get('cpu', '')
memory = request.POST.get('memory', '')
disk = request.POST.get('disk', '')
idcroom_id = request.POST.get('idcroom_id', '')
user = request.user.username
comment = request.POST.get('comment', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
if sn == '' or brand == '' or model == '' or cpu == '' or memory == '' or disk == '' or guarantee == '' or buydate == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'backup/serverbk_add.html',mydict)
if Serverbk.objects.filter(sn=sn):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此序列号已存在！")
return render(request,'backup/serverbk_add.html',mydict)
serverbk = Serverbk(
sn = sn,
brand = brand,
model = model,
cpu = cpu,
memory = memory,
disk = disk,
idcroom_id = idcroom_id,
user = user,
comment = comment,
guarantee = guarantee,
buydate = buydate,
)
serverbk.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/backup/serverbk/list/")
return render(request,'backup/serverbk_add.html',mydict)
def user_update(request, id):
groups = Group.objects.all() # 获取分组列表
sqldata = User.objects.get(id=id)
mynotice = "" # 状态提示条
mydict = {
"mynotice": mynotice,
"groups": groups,
"sqldata": sqldata,
}
if request.method == 'POST':
username = request.POST.get('username')
password = request.POST.get('password')
name = request.POST.get('name')
email = request.POST.get('email', '')
group_id = request.POST.get('group_id', '')
is_active = request.POST.get('is_active', '')
if username == '' or name == '' or password == '':
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，带星号（*）表单不能为空！")
return render(request, 'myauth/user_update.html', mydict)
if sqldata.username != username and len(
User.objects.filter(username=username)) >= 1:
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，此用户名已存在！")
return render(request, 'myauth/user_update.html', mydict)
try:
if sqldata.password != password:
password = make_password(password, "pwd", 'pbkdf2_sha256')
user = User.objects.get(id=id)
#user.username = username #禁止用户修改username
user.password = password
user.name = name
user.email = email
user.group_id = group_id
user.is_active = is_active
user.save()
commons.mynotice(request, "update", "success")
return HttpResponseRedirect("/myauth/user/list/")
except Exception:
pass
return render(request, 'myauth/user_update.html', mydict)
def column_list(request):
sqldata = Column.objects.all()
mynotice = ""
if request.method == 'GET':
action = request.GET.get('action')
if action == "add":
mynotice = commons.mynotice("success","恭喜您，添加成功！")
elif action == "update":
mynotice = commons.mynotice("success","恭喜您，更新成功！")
elif action == "del":
mynotice = commons.mynotice("success","恭喜您，删除成功！")
return render(request,'news/column_list.html',{'sqldata':sqldata,'mynotice':mynotice,'nav_news_column_list':"true"})
def memorybk_list(request):
sqldata = Memorybk.objects.all()
idcroom = Idcroom.objects.all() # 获取机房列表
# 状态，OrderedDict保持字典原来顺序
STATUS = OrderedDict([
('backup','备件'),
('fault','故障'),
('scrap','报废'),
])
idcroom_dict = {}
for idc in idcroom:
idcroom_dict[idc.id] = idc.name
mydict = {'sqldata':sqldata,
'mynotice':'',
'idcroom_dict':idcroom_dict,
'status':STATUS,
'nav_backup_memorybk_list':"true"
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'backup/memorybk_list.html',mydict)
def user_update(request,id):
groups = Group.objects.all() # 获取分组列表
sqldata = User.objects.get(id=id)
mynotice = "" # 状态提示条
mydict = {"mynotice": mynotice,
"groups": groups,
"sqldata":sqldata,
}
if request.method == 'POST':
username = request.POST.get('username')
password = request.POST.get('password')
name = request.POST.get('name')
email = request.POST.get('email', '')
group_id = request.POST.get('group_id', '')
is_active = request.POST.get('is_active','')
if username == '' or name == '' or password == '':
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'myauth/user_update.html',mydict)
if sqldata.username != username and len(User.objects.filter(username=username)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此用户名已存在！")
return render(request,'myauth/user_update.html',mydict)
try:
if sqldata.password != password:
password = make_password(password, "pwd", 'pbkdf2_sha256')
user = User.objects.get(id = id)
#user.username = username #禁止用户修改username
user.password = password
user.name = name
user.email = email
user.group_id = group_id
user.is_active = is_active
user.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/myauth/user/list/")
except Exception:
pass
return render(request, 'myauth/user_update.html',mydict)
def group_update(request, id):
#id = request.REQUEST.get('id')
sqldata = Group.objects.get(id=id)
permissions_list = commons.str_to_list(sqldata.permissions)
# 根据键值和权限列表把列表格式化成字典
permissions_sqldata = {}
for value in permissions_list:
if value in PERMISSIONS:
permissions_sqldata[value] = PERMISSIONS[value]
mynotice = "" # 状态提示条
permissions = ""
mydict = {
"sqldata": sqldata,
"mynotice": mynotice,
"permissions_sqldata": permissions_sqldata,
"permissions_all": PERMISSIONS,
}
if request.method == 'POST':
name = request.POST.get('name', '')
permissions = request.POST.getlist('permissions[]', '')
comment = request.POST.get('comment', '')
if name == '' or comment == '':
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，带星号（*）表单不能为空！")
return render(request, 'myauth/group_update.html', mydict)
if sqldata.name != name and len(Group.objects.filter(name=name)) >= 1:
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，此分组已存在！")
return render(request, 'myauth/group_update.html', mydict)
mydict["permissions"] = permissions
group = Group.objects.get(id=id)
group.name = name
group.permissions = commons.list_to_str(permissions)
group.comment = comment
group.save()
commons.mynotice(request, "update", "success")
return HttpResponseRedirect("/myauth/group/list?action=update")
return render(request, 'myauth/group_update.html', mydict)
def column_update(request,id):
#id = request.REQUEST.get('id')
sqldata = Column.objects.get(id=id)
class TestUEditorForm(forms.Form):
intro=UEditorField("",initial=sqldata.intro,width=782,height=400,imagePath="uploads/images/",toolbars='full', filePath='uploads/files/')
form = TestUEditorForm()
mynotice = "" # 状态提示条
mydict = {"form": form,
"sqldata":sqldata,
"mynotice":mynotice,
}
if request.method == 'POST':
name = request.POST.get('name', '')
slug = request.POST.get('slug', '')
intro = request.POST.get('intro', '')
nav_display = request.POST.get('nav_display', '')
home_display = request.POST.get('home_display', '')
if name == ''or slug == '' or intro == '':
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'news/column_update.html',mydict)
if sqldata.name != name and len(Column.objects.filter(name=name)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此分类已存在！")
return render(request,'news/column_update.html',mydict)
if sqldata.slug != slug and len(Column.objects.filter(slug=slug)) > 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此网址已存在！")
return render(request,'news/column_update.html',mydict)
column = Column.objects.get(id = id)
column.name = name
column.slug = slug
column.intro = intro
column.nav_display = nav_display
column.home_display = home_display
column.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/news/column/list/")
return render(request,'news/column_update.html',mydict)
def article_update(request,id):
#id = request.REQUEST.get('id')
sqldata = Article.objects.get(id=id)
class TestUEditorForm(forms.Form):
# initial 指定Ueditor内容
content=UEditorField("",initial=sqldata.content,width=782,height=400,imagePath="uploads/images/",toolbars='full', filePath='uploads/files/')
form = TestUEditorForm()
mynotice = "" # 状态提示条
columns = Column.objects.all() # 获取分类列表
mydict = {"form": form,
"sqldata":sqldata,
"mynotice":mynotice,
"columns":columns,
}
if request.method == 'POST':
title = request.POST.get('title', '')
column_id = request.POST.get('column_id', '')
content = request.POST.get('content', '')
published = request.POST.get('published', '')
if title == '' or content == '':
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'news/article_update.html',mydict)
if sqldata.title != title and len(Article.objects.filter(title=title)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此文章已存在！")
return render(request,'news/article_update.html',mydict)
article = Article.objects.get(id = id)
article.title = title
article.column_id = column_id
article.content = content
article.published = published
article.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/news/article/list/")
return render(request,'news/article_update.html',mydict)
def group_update(request,id):
#id = request.REQUEST.get('id')
sqldata = Group.objects.get(id=id)
permissions_list=commons.str_to_list(sqldata.permissions)
# 根据键值和权限列表把列表格式化成字典
permissions_sqldata = {}
for value in permissions_list:
if value in PERMISSIONS:
permissions_sqldata[value] = PERMISSIONS[value]
mynotice = "" # 状态提示条
permissions = ""
mydict = {"sqldata":sqldata,
"mynotice":mynotice,
"permissions_sqldata":permissions_sqldata,
"permissions_all":PERMISSIONS,
}
if request.method == 'POST':
name = request.POST.get('name', '')
permissions = request.POST.getlist('permissions[]', '')
comment = request.POST.get('comment', '')
if name == '' or comment == '':
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'myauth/group_update.html',mydict)
if sqldata.name != name and len(Group.objects.filter(name=name)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此分组已存在！")
return render(request,'myauth/group_update.html',mydict)
mydict["permissions"] = permissions
group = Group.objects.get(id = id)
group.name = name
group.permissions = commons.list_to_str(permissions)
group.comment = comment
group.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/myauth/group/list?action=update")
return render(request,'myauth/group_update.html',mydict)
def user_add(request):
mynotice = "" # 状态提示条
groups = Group.objects.all() # 获取分组列表
mydict = {
"mynotice": mynotice,
"groups": groups,
}
if request.method == 'POST':
username = request.POST.get('username')
password = request.POST.get('password')
name = request.POST.get('name')
email = request.POST.get('email', '')
group_id = request.POST.get('group_id', '')
is_active = request.POST.get('is_active', '')
if username == '' or name == '' or password == '':
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，带星号（*）表单不能为空！")
return render(request, 'myauth/user_add.html', mydict)
if User.objects.filter(username=username):
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，此用户名已存在！")
return render(request, 'myauth/user_add.html', mydict)
try:
user = User(
username=username,
name=name,
password=make_password(password, "pwd", 'pbkdf2_sha256'),
email=email,
group_id=group_id,
is_active=is_active,
)
user.save()
commons.mynotice(request, "add", "success")
return HttpResponseRedirect("/myauth/user/list/")
except Exception:
pass
return render(request, 'myauth/user_add.html', {'groups': groups})
def group_list(request):
sqldata = Group.objects.all()
mydict = {'sqldata':sqldata,
'mynotice':'',
'nav_myauth_group_list':"true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'myauth/group_list.html',mydict)
def group_list(request):
sqldata = Group.objects.all()
mydict = {'sqldata':sqldata,
'mynotice':'',
'nav_myauth_group_list':"true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'myauth/group_list.html',mydict)
def idcroom_list(request):
sqldata = Idcroom.objects.all()
mydict = {
'sqldata': sqldata,
'mynotice': '',
'nav_idcroom_list': 'true',
}
mydict['mynotice'] = commons.mynotice(request)
return render(request, 'idcroom/idcroom_list.html', mydict)
def idcroom_list(request):
sqldata = Idcroom.objects.all()
mydict = {
'sqldata':sqldata,
'mynotice':'',
'nav_idcroom_list':'true',
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'idcroom/idcroom_list.html',mydict)
def column_add(request):
class TestUEditorForm(forms.Form):
intro=UEditorField("",initial="",width=782,height=400,imagePath="uploads/images/",toolbars='full', filePath='uploads/files/')
form = TestUEditorForm()
mynotice = "" # 状态提示条
mydict = {"form": form,
"mynotice": mynotice,
}
if request.method == 'POST':
name = request.POST.get('name', '')
slug = request.POST.get('slug', '')
intro = request.POST.get('intro', '')
nav_display = request.POST.get('nav_display', '')
home_display = request.POST.get('home_display', '')
if name == '' or slug == '' or intro == '':
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'news/column_add.html',mydict)
if Column.objects.filter(name=name):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此分类已存在！")
return render(request,'news/column_add.html',mydict)
if Column.objects.filter(slug=slug):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此网址已存在！")
return render(request,'news/column_add.html',mydict)
column = Column(
name = name,
slug = slug,
intro = intro,
nav_display = nav_display,
home_display = home_display,
)
column.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/news/column/list/")
return render(request,'news/column_add.html',mydict)
def server_update(request,id):
sqldata = Server.objects.get(id=id)
mydict = {"sqldata":sqldata,
"mynotice":"", # 状态提示条
'status':Server.STATUS,
}
if request.method == 'POST':
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
servicetype = request.POST.get('servicetype', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status','')
comment = request.POST.get('comment', '')
if company == '' or department == '' or principal == '' or servicetype == '' or guarantee == '' or buydate == '' :
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'server/server_update.html',mydict)
server = Server.objects.get(id = id)
server.company = company
server.department = department
server.principal = principal
server.servicetype = servicetype
server.guarantee = guarantee
server.buydate = buydate
server.user = user
server.status = status
server.comment = comment
server.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/server/list/")
return render(request,'server/server_update.html',mydict)
def server_update(request, id):
sqldata = Server.objects.get(id=id)
mydict = {
"sqldata": sqldata,
"mynotice": "", # 状态提示条
'status': Server.STATUS,
}
if request.method == 'POST':
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
servicetype = request.POST.get('servicetype', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status', '')
comment = request.POST.get('comment', '')
if company == '' or department == '' or principal == '' or servicetype == '' or guarantee == '' or buydate == '':
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，带星号（*）表单不能为空！")
return render(request, 'server/server_update.html', mydict)
server = Server.objects.get(id=id)
server.company = company
server.department = department
server.principal = principal
server.servicetype = servicetype
server.guarantee = guarantee
server.buydate = buydate
server.user = user
server.status = status
server.comment = comment
server.save()
commons.mynotice(request, "update", "success")
return HttpResponseRedirect("/server/list/")
return render(request, 'server/server_update.html', mydict)
def user_add(request):
mynotice = "" # 状态提示条
groups = Group.objects.all() # 获取分组列表
mydict = {"mynotice": mynotice,
"groups": groups,
}
if request.method == 'POST':
username = request.POST.get('username')
password = request.POST.get('password')
name = request.POST.get('name')
email = request.POST.get('email', '')
group_id = request.POST.get('group_id', '')
is_active = request.POST.get('is_active','')
if username == '' or name == '' or password == '':
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'myauth/user_add.html',mydict)
if User.objects.filter(username=username):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此用户名已存在！")
return render(request,'myauth/user_add.html',mydict)
try:
user = User(
username = username,
name = name,
password = make_password(password, "pwd", 'pbkdf2_sha256'),
email = email,
group_id = group_id,
is_active = is_active,
)
user.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/myauth/user/list/")
except Exception:
pass
return render(request, 'myauth/user_add.html', {'groups':groups})
def article_add(request):
class TestUEditorForm(forms.Form):
content=UEditorField("",initial="",width=782,height=400,imagePath="uploads/images/",toolbars='full', filePath='uploads/files/')
form = TestUEditorForm()
mynotice = "" # 状态提示条
columns = Column.objects.all() # 获取分类列表
mydict = {"form": form,
"mynotice": mynotice,
"columns": columns,
}
if request.method == 'POST':
title = request.POST.get('title', '')
column_id = request.POST.get('column_id', '')
author = request.user.username # 添加文章时，作者字段获取系统登录用户
content = request.POST.get('content', '')
published = request.POST.get('published', '')
if title == '' or content == ''or column_id == '':
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'news/article_add.html',mydict)
if Article.objects.filter(title=title):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此文章已存在！")
return render(request,'news/article_add.html',mydict)
article = Article(
title = title,
column_id = int(column_id),
author = author,
content = content,
published = published,
)
article.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/news/article/list/")
return render(request,'news/article_add.html',mydict)
def idcroom_update(request,id):
#id = request.REQUEST.get('id')
sqldata = Idcroom.objects.get(id=id)
mydict = {"sqldata":sqldata,
"mynotice":"", # 状态提示条
}
if request.method == 'POST':
name = request.POST.get('name', '')
user = request.POST.get('user', '')
comment = request.POST.get('comment', '')
if name == '' and comment == '':
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'idcroom/idcroom_update.html',mydict)
if sqldata.name != name and len(Idcroom.objects.filter(name=name)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此名称已存在！")
return render(request,'idcroom/idcroom_update.html',mydict)
idcroom = Idcroom.objects.get(id = id)
idcroom.name = name
# idcroom.user = user 不更新操作员
idcroom.comment = comment
idcroom.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/idcroom/list/")
return render(request,'idcroom/idcroom_update.html',mydict)
def server_list(request):
sqldata = Server.objects.all()
# 把内存字段json格式转换为列表
for data in sqldata:
data.memory = json.loads(data.memory)
mydict = {'sqldata':sqldata,
'mynotice':'',
'nav_server_list':"true",
'status':Server.STATUS,
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'server/server_list.html',mydict)
def idcroom_update(request, id):
#id = request.REQUEST.get('id')
sqldata = Idcroom.objects.get(id=id)
mydict = {
"sqldata": sqldata,
"mynotice": "", # 状态提示条
}
if request.method == 'POST':
name = request.POST.get('name', '')
user = request.POST.get('user', '')
comment = request.POST.get('comment', '')
if name == '' and comment == '':
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，带星号（*）表单不能为空！")
return render(request, 'idcroom/idcroom_update.html', mydict)
if sqldata.name != name and len(
Idcroom.objects.filter(name=name)) >= 1:
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，此名称已存在！")
return render(request, 'idcroom/idcroom_update.html', mydict)
idcroom = Idcroom.objects.get(id=id)
idcroom.name = name
# idcroom.user = user 不更新操作员
idcroom.comment = comment
idcroom.save()
commons.mynotice(request, "update", "success")
return HttpResponseRedirect("/idcroom/list/")
return render(request, 'idcroom/idcroom_update.html', mydict)
def article_list(request):
sqldata = Article.objects.all()
columns = Column.objects.all() # 获取分类列表
columns_dict = {}
for column in columns:
columns_dict[column.id] = column.name
mydict = {'sqldata':sqldata,
'mynotice':'',
'columns_dict':columns_dict,
'nav_news_article_list':"true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'news/article_list.html',mydict)
def user_list(request):
sqldata = User.objects.all()
groups = Group.objects.all() # 获取分组列表
groups_dict = {}
for group in groups:
groups_dict[group.id] = group.name
mydict = {'sqldata':sqldata,
'mynotice':'',
'groups_dict':groups_dict,
'nav_myauth_user_list':"true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'myauth/user_list.html',mydict)
def user_list(request):
sqldata = User.objects.all()
groups = Group.objects.all() # 获取分组列表
groups_dict = {}
for group in groups:
groups_dict[group.id] = group.name
mydict = {
'sqldata': sqldata,
'mynotice': '',
'groups_dict': groups_dict,
'nav_myauth_user_list': "true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request, 'myauth/user_list.html', mydict)
def switch_list(request):
sqldata = Switch.objects.all()
idcroom = Idcroom.objects.all() # 获取机房列表
idcroom_dict = {}
for idc in idcroom:
idcroom_dict[idc.id] = idc.name
mydict = {'sqldata':sqldata,
'mynotice':'',
'nav_switch_list':"true",
'status':Switch.STATUS,
"idcroom_dict":idcroom_dict,
'nav_network_switch_list':"true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'network/switch_list.html',mydict)
def switch_list(request):
sqldata = Switch.objects.all()
idcroom = Idcroom.objects.all() # 获取机房列表
idcroom_dict = {}
for idc in idcroom:
idcroom_dict[idc.id] = idc.name
mydict = {
'sqldata': sqldata,
'mynotice': '',
'nav_switch_list': "true",
'status': Switch.STATUS,
"idcroom_dict": idcroom_dict,
'nav_network_switch_list': "true",
}
mydict['mynotice'] = commons.mynotice(request)
return render(request, 'network/switch_list.html', mydict)
def serverbk_list(request):
sqldata = Serverbk.objects.all()
idcroom = Idcroom.objects.all() # 获取机房列表
idcroom_dict = {}
for idc in idcroom:
idcroom_dict[idc.id] = idc.name
if request.method == 'POST':
if request.FILES['file']:
filepath = commons.handle_upload_file(request.FILES['file'])
return HttpResponseRedirect('backup/serverbk/list')
mydict = {'sqldata':sqldata,
'mynotice':'',
'idcroom_dict':idcroom_dict,
'nav_backup_serverbk_list':"true"
}
mydict['mynotice'] = commons.mynotice(request)
return render(request,'backup/serverbk_list.html',mydict)
def switch_add(request):
idcroom = Idcroom.objects.all() # 获取机房列表
mydict = {
"mynotice":"", # 状态提示条
"status":Switch.STATUS,
"idcroom":idcroom,
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
ip = request.POST.get('ip', '')
other_ip = request.POST.get('other_ip', '')
snmpcommunity = request.POST.get('snmpcommunity', '')
brand = request.POST.get('brand', '')
model = request.POST.get('model', '')
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
idcroom_id = request.POST.get('idcroom_id', '')
cabinet = request.POST.get('cabinet', '')
position = request.POST.get('position', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status','')
comment = request.POST.get('comment', '')
if sn == '' or ip == '' or snmpcommunity == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，带星号（*）表单不能为空！")
return render(request,'network/switch_add.html',mydict)
if Switch.objects.filter(sn=sn):
mydict['mynotice'] = commons.mynotice(request,"add","error","添加失败，此序列号已存在！")
return render(request,'network/switch_add.html',mydict)
switch = Switch(
sn = sn,
ip = ip,
other_ip = other_ip,
snmpcommunity = snmpcommunity,
brand = brand,
model = model,
company = company,
department = department,
principal = principal,
idcroom_id = idcroom_id,
cabinet = cabinet,
position = position,
guarantee = guarantee,
buydate = buydate,
user = user,
status = status,
comment = comment,
)
switch.save()
commons.mynotice(request,"add","success")
return HttpResponseRedirect("/network/switch/list/")
return render(request,'network/switch_add.html',mydict)
def switch_update(request,id):
sqldata = Switch.objects.get(id=id)
idcroom = Idcroom.objects.all() # 获取机房列表
mydict = {"sqldata":sqldata,
"mynotice":"", # 状态提示条
'status':Switch.STATUS,
"idcroom":idcroom,
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
ip = request.POST.get('ip', '')
other_ip = request.POST.get('other_ip', '')
snmpcommunity = request.POST.get('snmpcommunity', '')
brand = request.POST.get('brand', '')
model = request.POST.get('model', '')
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
idcroom_id = request.POST.get('idcroom_id', '')
cabinet = request.POST.get('cabinet', '')
position = request.POST.get('position', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status','')
comment = request.POST.get('comment', '')
if sn == '' or ip == '' or snmpcommunity == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，带星号（*）表单不能为空！")
return render(request,'network/switch_update.html',mydict)
if sqldata.sn != sn and len(Switch.objects.filter(sn=sn)) >= 1:
mydict['mynotice'] = commons.mynotice(request,"update","error","更新失败，此序列号已存在！")
return render(request,'network/switch_update.html',mydict)
switch = Switch.objects.get(id = id)
switch.sn = sn
switch.ip = ip
switch.other_ip = other_ip
switch.snmpcommunity = snmpcommunity
switch.brand = brand
switch.model = model
switch.company = company
switch.department = department
switch.principal = principal
switch.idcroom_id = idcroom_id
switch.cabinet = cabinet
switch.position = position
switch.guarantee = guarantee
switch.buydate = buydate
switch.user = user
switch.status = status
switch.comment = comment
switch.save()
commons.mynotice(request,"update","success")
return HttpResponseRedirect("/network/switch/list/")
return render(request,'network/switch_update.html',mydict)
def switch_add(request):
idcroom = Idcroom.objects.all() # 获取机房列表
mydict = {
"mynotice": "", # 状态提示条
"status": Switch.STATUS,
"idcroom": idcroom,
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
ip = request.POST.get('ip', '')
other_ip = request.POST.get('other_ip', '')
snmpcommunity = request.POST.get('snmpcommunity', '')
brand = request.POST.get('brand', '')
model = request.POST.get('model', '')
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
idcroom_id = request.POST.get('idcroom_id', '')
cabinet = request.POST.get('cabinet', '')
position = request.POST.get('position', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status', '')
comment = request.POST.get('comment', '')
if sn == '' or ip == '' or snmpcommunity == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，带星号（*）表单不能为空！")
return render(request, 'network/switch_add.html', mydict)
if Switch.objects.filter(sn=sn):
mydict['mynotice'] = commons.mynotice(request, "add", "error",
"添加失败，此序列号已存在！")
return render(request, 'network/switch_add.html', mydict)
switch = Switch(
sn=sn,
ip=ip,
other_ip=other_ip,
snmpcommunity=snmpcommunity,
brand=brand,
model=model,
company=company,
department=department,
principal=principal,
idcroom_id=idcroom_id,
cabinet=cabinet,
position=position,
guarantee=guarantee,
buydate=buydate,
user=user,
status=status,
comment=comment,
)
switch.save()
commons.mynotice(request, "add", "success")
return HttpResponseRedirect("/network/switch/list/")
return render(request, 'network/switch_add.html', mydict)
def switch_update(request, id):
sqldata = Switch.objects.get(id=id)
idcroom = Idcroom.objects.all() # 获取机房列表
mydict = {
"sqldata": sqldata,
"mynotice": "", # 状态提示条
'status': Switch.STATUS,
"idcroom": idcroom,
}
if request.method == 'POST':
sn = request.POST.get('sn', '')
ip = request.POST.get('ip', '')
other_ip = request.POST.get('other_ip', '')
snmpcommunity = request.POST.get('snmpcommunity', '')
brand = request.POST.get('brand', '')
model = request.POST.get('model', '')
company = request.POST.get('company', '')
department = request.POST.get('department', '')
principal = request.POST.get('principal', '')
idcroom_id = request.POST.get('idcroom_id', '')
cabinet = request.POST.get('cabinet', '')
position = request.POST.get('position', '')
guarantee = request.POST.get('guarantee', '')
buydate = request.POST.get('buydate', '')
user = request.user.username # 操作员为当前登录用户，系统自动获取不允许手动修改
status = request.POST.get('status', '')
comment = request.POST.get('comment', '')
if sn == '' or ip == '' or snmpcommunity == '' or idcroom_id:
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，带星号（*）表单不能为空！")
return render(request, 'network/switch_update.html', mydict)
if sqldata.sn != sn and len(Switch.objects.filter(sn=sn)) >= 1:
mydict['mynotice'] = commons.mynotice(request, "update", "error",
"更新失败，此序列号已存在！")
return render(request, 'network/switch_update.html', mydict)
switch = Switch.objects.get(id=id)
switch.sn = sn
switch.ip = ip
switch.other_ip = other_ip
switch.snmpcommunity = snmpcommunity
switch.brand = brand
switch.model = model
switch.company = company
switch.department = department
switch.principal = principal
switch.idcroom_id = idcroom_id
switch.cabinet = cabinet
switch.position = position
switch.guarantee = guarantee
switch.buydate = buydate
switch.user = user
switch.status = status
switch.comment = comment
switch.save()
commons.mynotice(request, "update", "success")
return HttpResponseRedirect("/network/switch/list/")
return render(request, 'network/switch_update.html', mydict)
