def Grouplist(request, ID):
host_list = Asset.objects.all()
lists = Authorize.objects.get(user=ID).asset_group.all()
lst = SelfPaginator(request, lists, 20)
kwvars = {'request': request, 'lPage': lst, 'host_list': host_list}
return render_to_response('Asset/asset_group_list.html', kwvars,
RequestContext(request))
def Glist(request):
lists = AssetGroup.objects.all()
host_list = Asset.objects.all()
lst = SelfPaginator(request, lists, 20)
kwvars = {'lPage': lst, 'host_list': host_list, 'request': request}
return render_to_response('Asset/asset_group_list.html', kwvars,
RequestContext(request))
def getCommuteExplainList(request):
if request.method == "GET":
try:
pagesize = request.GET["pagesize"]
except:
pagesize = 25
mList = CommuteExplain.objects.filter(
id_user=request.user).order_by('-commex_create_time')
lst = SelfPaginator(request, mList, pagesize)
result = {}
result["total"] = len(mList)
result["rows"] = []
for lid, item in enumerate(lst.object_list):
t_result = {}
t_result["id"] = lid + 1
t_result["commex_apply_date"] = str(item.commex_date)
t_result["commex_status"] = item.commex_status
t_result["commex_result"] = item.commex_result
t_result["commute_date"] = str(item.commute_commex.all())
t_result["commute_worktime"] = str(item.commute_commex.all())
t_result["commute_offtime"] = str(item.commex_date)
t_result["commute_status"] = item.commex_result
result["rows"].append(t_result)
else:
result = {"total": 0, "rows": []}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
def stockGetList(request):
stock_st_dic = {0: '坏件', 1: '好件', 2: '其他', 3: '其他', 4: '其他'}
if request.method == "GET":
try:
pagesize = request.GET["pagesize"]
except:
pagesize = 25
mList = StockList.objects.all()
lst = SelfPaginator(request, mList, pagesize)
result = {}
result["total"] = len(mList)
result["rows"] = []
for lid, item in enumerate(lst.object_list):
t_result = {}
t_result["id"] = lid + 1
t_result["stock_area"] = area_dic[item.stock_area]
t_result["brand"] = item.id_spare.id_brand.brand_cn
t_result["spare"] = item.id_spare.spare_cn
t_result["stock_sn"] = item.stock_sn
t_result["stock_st"] = stock_st_dic[item.stock_st]
t_result["from_to"] = "{stock_from} ~ {stock_to}".format(
stock_from=item.stock_from,
stock_to=item.stock_to) if item.stock_from else '-'
result["rows"].append(t_result)
else:
result = {"total": 0, "rows": []}
return HttpResponse(json.dumps(result, ensure_ascii=False))
def engineerList(request):
mList = EngineerList.objects.all()
lst = SelfPaginator(request,mList,15)
kwvars = {
'lPage': lst,
'request': request,
'title': '工单系统-基础信息-厂商工程师列表',
}
return render_to_response('workorder/engineerList.html', kwvars, RequestContext(request))
def User_history(request):
search = request.GET.get('keyword','')
if search:
lists = Userlog.objects.filter(username__contains=search)
else:
lists = Userlog.objects.all().order_by('-date_added')
lst = SelfPaginator(request,lists,20)
kwvars = {'request':request,'lPage':lst}
return render_to_response('Audit/user_history.html',kwvars,RequestContext(request))
def assetModelList(request):
mList = AssetModelList.objects.all()
lst = SelfPaginator(request,mList,15)
kwvars = {
'lPage': lst,
'request': request,
'title': '工单系统-基础信息-资产型号列表',
}
return render_to_response('workorder/assetModelList.html', kwvars, RequestContext(request))
def faultList(request):
mList = FaultList.objects.all()
lst = SelfPaginator(request,mList, 15)
kwvars = {
'lPage':lst,
'request':request,
'title':'工单系统-基础信息-故障类型',
}
return render_to_response('workorder/faultList.html',kwvars,RequestContext(request))
def spareList(request):
mList = SpareList.objects.all()
#分页功能
lst = SelfPaginator(request,mList, 15)
kwvars = {
'lPage':lst,
'request':request,
'title':'工单系统-基础信息-备件型号列表',
}
return render_to_response('workorder/spareList.html',kwvars,RequestContext(request))
def Hostlist(request, ID):
search = request.GET.get('keyword', '')
if (len(search) != 0):
lists = Authorize.objects.get(user=ID).asset.filter(
hostname__contains=search)
else:
lists = Authorize.objects.get(user=ID).asset.all()
lst = SelfPaginator(request, lists, 20)
kwvars = {'request': request, 'lPage': lst, 'asset_type': HOST_TYPE}
return render_to_response('Asset/asset_list.html', kwvars,
RequestContext(request))
def ListPermission(request):
mList = PermissionList.objects.all()
#分页功能
lst = SelfPaginator(request,mList, 20)
kwvars = {
'lPage':lst,
'request':request,
}
return render_to_response('UserManage/permission.list.html',kwvars,RequestContext(request))
def ListRole(request):
mList = RoleList.objects.all()
print request.path
#分页功能
lst = SelfPaginator(request,mList, 20)
kwvars = {
'lPage':lst,
'request':request,
}
return render_to_response('UserManage/role.list.html',kwvars,RequestContext(request))
def ListUser(request):
mList = get_user_model().objects.all()
#分页功能
lst = SelfPaginator(request,mList, 30)
kwvars = {
'lPage':lst,
'request':request,
}
return render_to_response('admin/usermanage/userlist.html',kwvars,RequestContext(request))
def commuteList(request):
form = {}
mList = Commute.objects.all().order_by('-comm_date')
logger.info("all user's commute")
lst = SelfPaginator(request,mList, 15)
kwvars = {
'form':form,
'lPage':lst,
'request':request,
'title':'工单系统-上班记录-我的打卡',
'title_content':'我的打卡',
}
return render_to_response('workorder/commuteList.html',kwvars,RequestContext(request))
def ListRoom(request):
mList = Room.objects.all()
#分页功能
lst = SelfPaginator(request, mList, 20)
kwvars = {
'lPage': lst,
'request': request,
}
return render_to_response('RoomManage/room.list.html', kwvars,
RequestContext(request))
def ListVisitor(request):
mList = Visitor.objects.all()
#分页功能
lst = SelfPaginator(request, mList, 20)
kwvars = {
'lPage': lst,
'request': request,
}
return render_to_response('VisitorManage/visitor.list.html', kwvars,
RequestContext(request))
def idcList(request):
mList = IDCList.objects.all()
#mList = IDCList.objects.raw('select * from usermanage_user right join workorder_idclist on workorder_idclist.id_idc = usermanage_user.id_idc;')
#分页功能
lst = SelfPaginator(request,mList, 15)
#lst = SelfPaginator(request,list(mList), 15)
kwvars = {
'lPage':lst,
'request':request,
'title':'工单系统-基础信息-机房信息列表',
#'postUrl':'/workorder/idc/list/',
}
return render_to_response('workorder/idcList.html',kwvars,RequestContext(request))
def ListStrategy(request):
mList = StrategyList.objects.all()
#分页功能
lst = SelfPaginator(request, mList, 20)
kwvars = {
'lPage': lst,
'request': request,
}
return render_to_response('StrategyManage/strategy.list.html', kwvars,
RequestContext(request))
def adminArticleList(request):
'''管理后台 文章列表'''
logger.info('show article list ...')
articles = Article.objects.all()
#分页功能
lst = SelfPaginator(request, articles, 10)
kwvars = {
'lPage': lst,
'request': request,
}
return render_to_response('Article/admin.article.list.html', kwvars,
RequestContext(request))
def ListRoomStatus(request, SN):
print SN
room = Room.objects.get(roomsn=SN)
mList = RoomStatus.objects.filter(room_id=room.id).order_by('-id')
#分页功能
lst = SelfPaginator(request, mList, 20)
kwvars = {
'lPage': lst,
'request': request,
'SN': SN,
}
return render_to_response('MonitorManage/monitor.list.html', kwvars,
RequestContext(request))
def ListPermission(request):
mList = PermissionList.objects.all()
for item in mList:
try:
tItem = PermissionList.objects.get(id_perm=item.per_pid)
item.per_pid = "%s(%s)" % (tItem.per_cn, tItem.per_url)
#item.per_pid = tItem["per_cn"]
except:
item.per_pid = "------"
#分页功能
lst = SelfPaginator(request, mList, 30)
kwvars = {
'lPage': lst,
'request': request,
}
return render_to_response('admin/usermanage/permissionlist.html', kwvars,
RequestContext(request))
def operList(request):
mList = OperList.objects.all()
for item in mList:
try:
tItem = OperList.objects.get(id_op = item.op_pid)
item.op_pid = tItem.op_cn
except:
item.op_pid = "------"
lst = SelfPaginator(request,mList, 15)
kwvars = {
'lPage':lst,
'request':request,
'title':'工单系统-基础信息-操作类型列表',
#'postUrl':'/workorder/oper/list/',
}
return render_to_response('workorder/operList.html',kwvars,RequestContext(request))
export = request.GET.get('export', '')
kwvars = {'request': request, 'URL': 'listuserurl'}
if (len(search) != 0):
mList = get_user_model().objects.filter(username__contains=search)
else:
mList = get_user_model().objects.all()
if export:
try:
rev = write_excel(mList, user=request.user.username, T="user")
return rev
except Exception, e:
kwvars["err"] = "导出列表错误!%s" % (str(e))
return render_to_response('status.html', kwvars,
RequestContext(request))
lst = SelfPaginator(request, mList, 20)
kwvars['lPage'] = lst
return render_to_response('UserManage/user.list.html', kwvars,
RequestContext(request))
@login_required
@PermissionVerify()
def AddUser(request):
if request.method == 'POST':
form = AddUserForm(request.POST)
if form.is_valid():
user = form.save(commit=False)
user.set_password(form.cleaned_data['password'])
form.save()
return HttpResponseRedirect(reverse('listuserurl'))
export = request.GET.get('export', '')
kwvars = {'request': request, 'asset_type': HOST_TYPE, 'URL': 'alist'}
if (len(search) != 0):
lists = Asset.objects.filter(hostname__contains=search)
else:
lists = Asset.objects.all()
if export:
try:
rev = write_excel(lists, user=request.user.username)
return rev
except Exception, e:
kwvars["err"] = "导出列表错误!%s" % (str(e))
return render_to_response('status.html', kwvars,
RequestContext(request))
lst = SelfPaginator(request, lists, 20)
kwvars['lPage'] = lst
return render_to_response('Asset/asset_list.html', kwvars,
RequestContext(request))
@login_required
@PermissionVerify()
def Hostlist(request, ID):
search = request.GET.get('keyword', '')
if (len(search) != 0):
lists = Authorize.objects.get(user=ID).asset.filter(
hostname__contains=search)
else:
lists = Authorize.objects.get(user=ID).asset.all()
lst = SelfPaginator(request, lists, 20)
def Authorize_list(request):
lists = Authorize.objects.all()
lst = SelfPaginator(request, lists, 20)
kwvars = {'request': request, 'lPage': lst}
return render_to_response('Authorize/authorize_list.html', kwvars,
RequestContext(request))
mList = []
# search_opertype
try:
search_opertype = request.GET["search_opertype"]
if search_opertype and mList:
mList = mList.filter(stio_type__icontains=search_opertype)
except Exception, ex:
print ex
try:
pagesize = request.GET["pagesize"]
except:
pagesize = 25
print mList
lst = SelfPaginator(request, mList, pagesize)
result = {}
result["total"] = len(mList)
result["rows"] = []
for lid, item in enumerate(lst.object_list):
t_result = {}
t_result["id"] = item.id_stinout
t_result["stio_create_time"] = str(item.stio_create_time)
t_result["stio_type"] = item.stio_type
t_result["spare_en"] = item.id_spare.spare_en
t_result["stio_num"] = item.stio_num
try:
t_result["reinfo_code"] = item.id_reinfo.reinfo_code
except Exception, ex:
t_result["reinfo_code"] = "-"
t_result["descript"] = item.stio_descript
