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