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