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) # 根据搜索条件构造 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_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_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_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_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_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 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_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 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_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_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_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_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)
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 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 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,
}
business_1_lists = self.business_1_list(request)
business_2_lists = self.business_2_list(request)
business_3_lists = self.business_3_list(request)
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,
'business_1_list': business_1_lists,
'business_2_list': business_2_lists,
'business_3_list': business_3_lists
}
# ret['menu'] = '''<a id="menu_create" class="menu-item" href="/_project.html"><i class="fa fa-gitlab"
# aria-hidden="true" style="width: 14px; margin-left: 1px"></i><span>项目创建</span></a>
# '''
ret['menu'] = menu(request)
print('-----', ret['menu'])
response.data = ret
response.message = '获取成功'
except Exception as e:
response.status = False
response.message = str(e)
return response
def fetch_asset(self,request):
response = BaseResponse()
try:
ret = {}
# print(request)
conditions = self.Server_condition(request)
print(conditions)
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]
# print(list(asset_list))
ret['table_config'] = self.table_config
ret['condition_config'] = self.condition_config
ret['data_list'] = list(asset_list)
##对前端适应，提供id字段
for i in list(asset_list):
i['id'] = i['ni']
ret['page_info'] = {
"page_str": page_info.pager(),
"page_start": page_info.start,
}
ret['global_dict'] = {
'device_status_list':self.device_status_list,
'username_list': self.username_list,
'computer_list': self.computer_list,
'asset_model_list': self.asset_model_list,
'type_list':self.type_list,
}
response.data = ret
response.message = '获取成功'
except Exception as e:
response.status = False
response.message = str(e)
return response
def fetch_asset(self, request):
"""
获取资产
:param request:
:return:
"""
response = BaseResponse()
try:
ret = {}
conditions = self.select_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]
"""
<QuerySet [{'id': 1, 'business_unit_id': None, 'asset_status': 'online', 'asset_type': 'server', 'idc_id': 1, 'server_title': 'ytd13'}, {'id': 2, 'business_unit_id': None, 'asset_sta
tus': 'online', 'asset_type': 'server', 'idc_id': None, 'server_title': 'CentOS-01'}]>
"""
# 加入查询条件
ret['condition_config'] = self.condition_config
# 加入配置文件
ret['table_config'] = self.table_config
# 加入查询到的数据
ret['data_list'] = list(asset_list)
# 加入页面信息
ret['page_info'] = {
'page_str': page_info.pager(),
'page_start': page_info.start,
}
# 加入全局变量
ret['global_dict'] = {
'asset_type_list': self.asset_type_list,
'business_unit_list': self.business_unit_list,
'idc_list': self.idc_list,
'asset_status_list': self.asset_status_list
}
response.data = ret
response.message = '获取成功'
except Exception as e:
response.status = False
response.message = str(e)
return response
def show_download_log_list(request):
"""
显示要下载的日志列表视图
:param request:
:return:
"""
response = BaseResponse()
try:
ret = {}
choice_value = request.GET.get('choiceValue')
project_name = choice_value.split('-')[0]
application_name = choice_value.split('-')[1]
project_path = models.Project.objects.filter(
name=project_name).first().path_name
application_path = models.Application.objects.filter(
name=application_name).first().path_name
abs_path = os.path.join(settings.RSYNC_LOG_DIR, project_path,
application_path)
ret_list = post_file(abs_path)
file_count = len(cut_file_list(application_path, ret_list))
page_info = PageInfo(request.GET.get('pager', None), file_count)
ret['data_list'] = cut_file_list(
application_path, ret_list)[page_info.start:page_info.end]
ret['page_info'] = {
'page_str': page_info.pager(),
'page_start': page_info.start
}
response.data = ret
Logger().log(message='[%s]显示要下载的日志列表成功,路径为[%s]' %
(request.user.name, abs_path),
mode=True)
except Exception as e:
response.status = False
response.message = '查询失败'
response.error = str(e)
Logger().log(message='[%s]显示要下载的日志列表失败,%s' %
(request.user.name, str(e)),
mode=False)
return JsonResponse(response.__dict__)
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
def fetch_assets(self, request):
response = BaseResponse()
username = request.GET.get('username')
try:
ret = {}
# conditions = self.assets_condition(request)
asset_count = models.AuthInfo.objects.filter(
username=username).count()
page_info = PageInfo(request.GET.get('pager', None), asset_count)
asset_list = models.AuthInfo.objects.filter(
username=username).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,
'rank_list': self.rank_list,
'idc_list': self.idc_list,
'business_unit_list': self.business_unit_list,
'business_1_list': self.business_1_list,
'business_2_list': self.business_2_list,
'business_3_list': self.business_3_list
}
ret['menu'] = menu(request)
response.data = ret
response.message = '获取成功'
except Exception as e:
response.status = False
response.message = str(e)
return response
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
