def fetch_assets(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = repository_models.Mission.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = repository_models.Mission.objects.filter(conditions).extra(select=self.extra_select).values( *self.values_list).order_by("-id")[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'mission_type_list': self.mission_type_list } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_assets(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = models.Asset.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = models.Asset.objects.filter(conditions).extra( select=self.extra_select).values(*self.values_list).order_by( '-id')[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'device_status_list': self.device_status_list, 'device_type_list': self.device_type_list, 'idc_list': self.idc_list, 'business_unit_list': self.business_unit_list, 'status_map': self.status_map, 'tag_list': self.tag_list } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_users(self, request): response = BaseResponse() try: ret = {} conditions = self.users_condition(request) users_count = models.UserProfile.objects.filter(conditions).count() peritems = int(request.GET.get('peritems', None)) page_info = PageInfo(request.GET.get('pager', None), users_count, peritems) users_list = models.UserProfile.objects.filter(conditions).extra( select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(users_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'role_list': self.role_list, 'user_status_list': self.user_status_list, } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) print(response) return response
def fetch_assets(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = models.Asset.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = models.Asset.objects.filter(conditions).extra(select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'device_status_list': self.device_status_list, 'device_type_list': self.device_type_list, 'idc_list': self.idc_list, 'business_unit_list': self.business_unit_list, 'status_map': self.status_map } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def news(request): username = request.get_signed_cookie('username', default=0, salt='123') if username: # newsRet = models.get_news()[::-1] dataRet = models.get_data() page_info = PageInfo( request.GET.get('page'), len(newsRet), 5, '/news', ) news_list = newsRet[page_info.start():page_info.end()] return render( request, 'news.html', { 'username': username, 'page_info': page_info, 'news_list': news_list, }, ) else: return redirect('/login/')
def fetch_queryset(self, request): response = BaseResponse() try: ret = {} conditions = self.queryset_condition(request) queryset_count = self.queryset.filter(conditions).count() page_info = PageInfo(request.GET.get( 'pager', None), queryset_count) queryset_list = self.queryset.filter(conditions).extra(select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(queryset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = self.global_dict response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_user(self, request): """ 获取用户信息 :param request: :return: """ response = BaseResponse() try: ret = {} conditions = self.select_condition(request) user_count = models.UserProfile.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), user_count) user_list = models.UserProfile.objects.filter(conditions).extra( select=self.extra_select).values(*self.values_list).order_by( 'id')[page_info.start:page_info.end] # 加入查询条件 ret['condition_config'] = self.condition_config # 加入配置文件 ret['table_config'] = self.table_config # 加入查询到的数据 ret['data_list'] = list(user_list) # 加入页面信息 ret['page_info'] = { 'page_str': page_info.pager(), 'page_start': page_info.start, } # 加入全局变量 ret['global_dict'] = {} response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_tags(self, request): response = BaseResponse() try: ret = {} conditions = self.tag_condition(request) # 根据搜索条件构造 q 对象 asset_count = models.Tag.objects.filter( conditions).count() # 根据搜索条件统计搜索总数量 page_info = PageInfo(request.GET.get('pager', None), asset_count) # 使用 PageInfo 构造 分页 asset_list = models.Tag.objects.filter(conditions).extra( select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = {} response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_assets(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) # 根据搜索条件构造 q 对象 asset_count = models.Asset.objects.filter(conditions).count() # 根据搜索条件统计搜索总数量 page_info = PageInfo(request.GET.get('pager', None), asset_count) # 使用 PageInfo 构造 分页 asset_list = models.Asset.objects.filter(conditions).extra(select=self.extra_select).values(*self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'device_status_list': self.device_status_list, 'device_type_list': self.device_type_list, 'idc_list': self.idc_list, 'business_unit_list': self.business_unit_list, 'tagName_list': self.tagName_list(ret['data_list']), # 用作资产表中 对应的标签名称 'tag_name_list': self.tag_name_list, # 用作搜索条件处显示标签名称搜索条件 } response.data = ret response.status = True response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_business(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) # print(conditions) asset_count = models.BusinessUnit.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = models.BusinessUnit.objects.filter(conditions).extra(select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] # print(asset_list, type(asset_list)) ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'contact_id_list': self.contact_id_list, 'manager_id_list': self.manager_id_list, } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_data(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = USER_CENTER_MODELS.Permission.objects.filter( conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = USER_CENTER_MODELS.Permission.objects.filter( conditions).extra(select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'url_method_list': self.url_method_list, } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_services(self,request): response = BaseResponse() try: ret = {} conditions = self.Server_condition(request) asset_count = models.Base.objects.filter(conditions).count() print(asset_count,'count',request.GET.get('pager') ) page_info = PageInfo(request.GET.get('pager',None),asset_count) asset_list = models.Base.objects.filter(conditions).extra(select=self.extra_select).values(\ *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'device_status_list':self.device_status_list } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_assets(cls, request): response = BaseResponse() try: ret = {} conditions = cls.assets_condition(request) asset_count = models.Asset.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = models.Asset.objects.filter(conditions).values(*cls.asset_values())[ page_info.start:page_info.end] ret['table_config'] = cls.table_config() ret['condition_config'] = cls.condition_config() ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'device_status_list': cls.device_status_list(), 'device_type_list': cls.device_type_list(), 'idc_list': cls.idc_list(), 'business_unit_list': cls.business_unit_list() } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_data(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = OMTOOLS_MODELS.MongodbMission.objects.filter( conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = OMTOOLS_MODELS.MongodbMission.objects.filter( conditions).order_by('-id').extra( select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'op_type_list': self.op_type_list, 'option_status': self.option_status, 'status_map': self.status_map, } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_user(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) user_count = user_models.UserProfile.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), user_count) user_list = user_models.UserProfile.objects.filter(conditions).extra(select=self.extra_select).values( *self.values_list).order_by("-id")[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(user_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { "group_list": self.group_list } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_group(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) group_count = user_models.UserGroup.objects.filter( conditions).count() page_info = PageInfo(request.GET.get('pager', None), group_count) group_list = user_models.UserGroup.objects.filter( conditions).extra(select=self.extra_select).values( *self.values_list).order_by( "-id")[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(group_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } # ret['global_dict'] = { # "group_list": self.group_list # } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_users(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = models.UserProfile.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = models.UserProfile.objects.filter(conditions).extra(select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] print('asset_list', list(asset_list)) ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } # ret['global_dict'] = {'usergroup_list': self.usergroup_list} ret['global_dict'] = {'usergroup_list': self.usergroup_list, 'users_list': self.users_list} print('ret', ret['global_dict']) response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def fetch_data(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) asset_count = USER_CENTER_MODELS.Roles.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), asset_count) asset_list = USER_CENTER_MODELS.Roles.objects.filter(conditions).extra( select=self.extra_select).values( *self.values_list)[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(asset_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } ret['global_dict'] = { 'url_method_list': self.url_method_list, } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response
def linux_operate_index(request): user_id1 = request.session.get('user_id') user_obj = User.objects.filter(id=user_id1).values('avatar') user = request.session.get('user_name') all_count = models.CmdbInfo.objects.all().count() page_info = PageInfo(request.GET.get('page'), all_count, 10, 'linux_operate.html', 11) ip_list = models.CmdbInfo.objects.all()[page_info.start():page_info.end()] return render(request,'linux_operate.html',{'ip_list':ip_list,'page_info':page_info,'user':user,'user_obj':user_obj[0]['avatar']})
def Promotion_list(request): user_id1 = request.session.get('user_id') user_obj = models.User.objects.filter(id=user_id1).values('avatar') all_count = models.Promotion.objects.all().count() page_info = PageInfo(request.GET.get('page'), all_count, 10, 'api_promotion.html', 11) promotion_list = models.Promotion.objects.all()[page_info.start():page_info.end()] user = request.session.get('user_name') return render(request, 'api_promotion.html', {'promotion_list': promotion_list, 'page_info': page_info,'user':user,'user_obj':user_obj[0]['avatar']})
def index(request): username = request.session.get('username', '') if not username: return redirect('/login/') all_count = Hosts.objects.all().count() page_info = PageInfo(request.GET.get('p'), 10, all_count, request.path_info, page_range=11) user_list = Hosts.objects.all().order_by('-id')[page_info.start():page_info.end()] return render(request, 'index.html', locals())
def get(self, request, **kwargs): site = kwargs.get("site") blog = models.Blog.objects.filter(site=site).first() if blog: sort = kwargs.get("sort") sort_val = kwargs.get("sort_val") if sort == "tag": # 按标签 article_list = models.Article.objects.filter( blog=blog, tags__nid=sort_val) elif sort == "category": # 按分类 article_list = models.Article.objects.filter( blog=blog, category__nid=sort_val) elif sort == "date": article_list = models.Article.objects.filter(blog=blog).extra( select={ "Year_month": 'strftime("%%Y-%%m",create_time)' }).extra(where=["Year_month=%s"], params=[sort_val]) else: # 所有文章 article_list = models.Article.objects.filter(blog=blog) """ 缺 year_month """ # fans_objs = models.UserFans.objects.filter(user=blog.user) # myfollow_objs = models.UserFans.objects.filter(follower=blog.user) # tag_list = models.Article.objects.filter(blog=blog).values("tags__title","tags__nid").annotate(ct=Count("nid")) # category_list = models.Article.objects.filter(blog=blog).values("category__title","category__nid").annotate(ct=Count("nid")) # date_list = models.Article.objects.filter(blog=blog).extra(select={"Year_month":'strftime("%%Y-%%m",create_time)'}).values("Year_month").annotate(ct=Count("nid")) pageinfo = getlayout(blog) page_info = PageInfo( request.GET.get("page"), len(article_list), settings.HOMEPAGE_ITEMS_PER_PAGE, "", ) # pageinfo["article_list"] = article_list.order_by("-create_time") pageinfo["article_list"] = article_list.order_by( "-create_time")[page_info.start():page_info.end()] pageinfo["page_info"] = page_info # pageinfo = { # "blog": blog, # "article_list": article_list.order_by("-create_time"), # "fans_objs":fans_objs, # "myfollow_objs":myfollow_objs, # "tag_list":tag_list, # "category_list":category_list, # "date_list": date_list, # } return render(request, "blog/homepage.html", pageinfo) else: return redirect("/")
def custom(request): all_count = models.UserInfo.objects.count() page_info = PageInfo(request.GET.get('page'), all_count, 10, show_page=5) user_list = models.UserInfo.objects.all()[page_info.start():page_info.stop( )] return render(request, 'custom.html', { 'user_list': user_list, 'page_info': page_info })
def test2(request): all_count = UserInfo.objects.all().count() page_info = PageInfo(request.GET.get('p'), 10, all_count, request.path_info, page_range=7) user_list = UserInfo.objects.all().order_by( '-id')[page_info.start():page_info.end()] return render(request, 'test2.html', locals())
def index(request): count = Article.objects.all().count() page_info = PageInfo(request.GET.get('page'), count, 8, '/userinfo/index/', 11) article_list = Article.objects.all()[page_info.start():page_info.end()] blogcategory = Category.objects.all() return render( request, "index.html", { "article_list": article_list, 'page_info': page_info, "blogcategory": blogcategory })
def index(request): # 表示用户想要访问的页 # 每页显示数据 all_count = Article.objects.all().count() page_info = PageInfo(request.GET.get("page"), all_count, 5, '/index.html') article_list = Article.objects.all().order_by("-create_date").values( "article_id", "title", "article_content", "uid__username", "create_date", "uid")[page_info.start():page_info.end()] return render(request, "index.html", { "article_list": article_list, "page_info": page_info })
def classes(request, page): # class_list = mysql_result('select id,class_name from class') # page = request.GET.get('page') page_info = PageInfo(page, models.Classes.objects.all().count(), 10, '/classes/', 11) class_list = models.Classes.objects.all()[page_info.start():page_info.end( )] return render(request, 'classes.html', { "classes_list": class_list, 'page_info': page_info })
def custom(request): # 表示用户想要访问的页码 all_count = models.UserInfo.objects.all().count() current_page = request.GET.get('page') # 每页显示的数据个数 pageinfo = PageInfo(current_page, all_count, 10, 5, 'custom') start = pageinfo.start() end = pageinfo.end() user_list = models.UserInfo.objects.all()[start:end] # django中也有安全标签 xss攻击慎用 safe和mark_safe # from django.utils.safestring import mark_safe # user_list = mark_safe(user_list) return render(request, 'custom.html', { 'user_list': user_list, 'pageinfo': pageinfo })
def custom(request): #表示用户当前想要访问的页码 8 current_page = int(request.GET.get('page')) #每页显示数据的个数 per_page = 10 #总个数 num_userinfo = models.UserInfo.objects.all().count() # num_userinfo =models.UserInfo.objects.filter(id__lt=22).count() page_info = PageInfo(current_page, per_page, num_userinfo, 11, '/custom.html') userlist = models.UserInfo.objects.all()[page_info.start():page_info.end()] return render(request, 'custom.html', { 'userlist': userlist, 'page_info': page_info })
def student(request, page): page_info = PageInfo(page, models.Student.objects.all().count(), 10, '/student/', 11) student_list = models.Student.objects.all()[page_info.start():page_info. end()] class_list = models.Classes.objects.all()[page_info.start():page_info.end( )] print(models.Student.objects.all().count()) print(class_list) return render( request, 'student.html', { 'student_list': student_list, 'class_list': class_list, 'page_info': page_info })
def get(self, request, *args, **kwargs): # blog_id = request.session['user_info']['blog_nid'] # article_type_list = models.Article.type_choices result = {} type_list = map(lambda item: { 'nid': item[0], 'title': item[1] }, models.Article.type_choices) ##map 对象,用list可以获取,可以迭代 categroy_list = models.Category.objects.all() result['type_list'] = type_list result['categroy_list'] = categroy_list if kwargs: print(request.path_info) condition = {} for k, v in kwargs.items(): kwargs[k] = int(v) if v == '0': result[k] = 0 else: condition[k] = int(v) result[k] = int(v) content_count = models.Article.objects.filter(**condition).count() page_info = PageInfo(request.GET.get('p', None), content_count) result['page_info'] = { "page_str": page_info.pager(), # "page_start":page_info.start, "p": request.GET.get('p', 1), "content_count": content_count, } print(result['page_info'], 333) blog_content_list = models.Article.objects.filter( **condition).values('nid', 'title', 'summary')[page_info.start:page_info.end] result['content'] = blog_content_list # print(page_info) # result['content'] = page_info # print(result) # exit(1) return render(request, 'backend/article.html', result) else: print(result) return render(request, 'backend/article.html', result)
def ordermanage(request): store_info = request.session.get("store_info") store_id = store_info["store_id"] order_list = Orders.objects.filter(order_store_id=store_id, order_status__gte=1).values( "order_id", "total_price", "create_date", "finish_time", "order_status") all_count = Orders.objects.filter(order_store_id=store_id, order_status__gte=1).count() print(all_count) page_info = PageInfo(request.GET.get("page"), all_count, 10, '/store/ordermanage', "") order_list = order_list[page_info.start():page_info.end()] return render(request, "Store/OrderManage.html", { "order_list": order_list, "page_info": page_info })
def custom(request): # # 表示用户当前想要访问的页码 8 # current_page = request.GET.get('page') # current_page = int(current_page) # # 每页显示的数据的个数 # per_page = 10 # start = (current_page-1)*per_page # end = current_page*per_page # user_list = models.UserInfo.objects.all()[start: end] all_count = models.UserInfo.objects.all().count() page_info = PageInfo(request.GET.get('page'), all_count, 10, '/custom.html',) user_list = models.UserInfo.objects.all()[page_info.start():page_info.end()] return render(request, 'custom.html', {'user_list': user_list, 'page_info':page_info,})
def fetch_idc(self, request): response = BaseResponse() try: ret = {} conditions = self.assets_condition(request) idc_count = CMDB_MODELS.IDC.objects.filter(conditions).count() page_info = PageInfo(request.GET.get('pager', None), idc_count) idc_list = CMDB_MODELS.IDC.objects.filter(conditions).extra(select=self.extra_select).values( *self.values_list).order_by("-id")[page_info.start:page_info.end] ret['table_config'] = self.table_config ret['condition_config'] = self.condition_config ret['data_list'] = list(idc_list) ret['page_info'] = { "page_str": page_info.pager(), "page_start": page_info.start, } response.data = ret response.message = '获取成功' except Exception as e: response.status = False response.message = str(e) return response