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
