投票人员查询优化

linwei

2024-02-22 7bcd0d2d7510cb2ba67099cd768e1b2b6d047dc2

 src/main/java/org/springblade/modules/article/service/impl/ArticleServiceImpl.java

@@ -1,14 +1,26 @@
package org.springblade.modules.article.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.common.cache.SysCache;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.SpringUtil;
import org.springblade.modules.article.entity.Article;
import org.springblade.modules.article.mapper.ArticleMapper;
import org.springblade.modules.article.service.ArticleService;
import org.springblade.modules.article.vo.ArticleVO;
import org.springblade.modules.property.entity.PropertyCompanyDistrictEntity;
import org.springblade.modules.property.entity.PropertyCompanyEntity;
import org.springblade.modules.property.service.IPropertyCompanyDistrictService;
import org.springblade.modules.property.service.IPropertyCompanyService;
import org.springblade.modules.property.service.IPropertyDistrictUserService;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;
import java.util.stream.Collectors;

/**
 * @author zhongrj
@@ -21,17 +33,58 @@

   /**
    * 查询资讯分页信息
    *
    * @param page
    * @param article 资讯对象
    * @return
    */
   @Override
   public IPage<Article> selectArticlePage(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.selectArticlePage(page,article));
      String userRole = AuthUtil.getUserRole();
      // 物业身份，只查询该物业公司下的公告
      // if (userRole.contains("wygly") || userRole.contains("wyxmjl")) {
      //    // 物业公司 有哪些小区
      //    IPropertyCompanyDistrictService bean = SpringUtils.getBean(IPropertyCompanyDistrictService.class);
      //    List<PropertyCompanyDistrictEntity> list = bean.list(Wrappers.<PropertyCompanyDistrictEntity>lambdaQuery()
      //       .eq(PropertyCompanyDistrictEntity::getUserId, AuthUtil.getUserId()));
      //    List<String> collect = list.stream().map(PropertyCompanyDistrictEntity::getDistrictId).collect(Collectors.toList());
      //    article.setDistrictIdList(collect);
      // }
      if (userRole.contains("wygly") || userRole.contains("wyxmjl")) {
         // 查询小区id
         IPropertyDistrictUserService propertyDistrictUserService = SpringUtils.getBean(IPropertyDistrictUserService.class);
         List<String> districtIds = propertyDistrictUserService.selectPropertyDistrictByUserId(AuthUtil.getUserId());
         // 通过用户机构查询用户的物业公司
         IPropertyCompanyService bean = SpringUtil.getBean(IPropertyCompanyService.class);
         PropertyCompanyEntity one = bean.getOne(Wrappers.<PropertyCompanyEntity>lambdaQuery().eq(PropertyCompanyEntity::getDeptId, AuthUtil.getDeptId()));
         if (one != null) {
            IPropertyCompanyDistrictService bean2 = SpringUtils.getBean(IPropertyCompanyDistrictService.class);
            // 通过物业公司，查询小区
            List<PropertyCompanyDistrictEntity> list = bean2.list(Wrappers.<PropertyCompanyDistrictEntity>lambdaQuery()
               .eq(PropertyCompanyDistrictEntity::getPropertyCompanyId, one.getId()));
            if (list.size() > 0) {
               List<String> collect = list.stream().map(i -> i.getDistrictId()).collect(Collectors.toList());
               districtIds.addAll(collect);
            }
         }
         article.setDistrictIdList(districtIds);
         if (districtIds.size() == 0) {
            return page.setRecords(new ArrayList<>());
         }
         article.setPropertyFlag(1);
      }
      if (userRole.contains("jdgly")) {
         List<String> regionChildCodesList = SysCache.getRegionChildCodesByDeptId(AuthUtil.getDeptId());
         if (regionChildCodesList.size() > 0) {
            article.setDistrictIdList(regionChildCodesList);
         }
      }
      return page.setRecords(baseMapper.selectArticlePage(page, article));
   }

   /**
    * 查询资讯分页信息
    *
    * @param page
    * @param article 资讯对象
    * @return
@@ -41,56 +94,60 @@
      // 查询用户小区的id
      String districId = baseMapper.getDistrictId(article.getHouseCode());
      article.setDistrictId(districId);
      article.setUserId(AuthUtil.getUserId());
      List<ArticleVO> articleVOS = baseMapper.selectArticlePageByApp(page, article);
      return page.setRecords(articleVOS);
   }

   @Override
   public IPage<Article> selectArticleG(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.selectArticleG(page,article));
      return page.setRecords(baseMapper.selectArticleG(page, article));
   }

   /**
    * 查询资讯分页信息(角色权限)
    *
    * @param page
    * @param article 资讯对象
    * @return
    */
   @Override
   public IPage<Article> pageDate(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.pageDate(page,article));
      return page.setRecords(baseMapper.pageDate(page, article));
   }

   /**
    * 查询资讯分页信息(敏感词预警)
    *
    * @param page
    * @param article 资讯对象
    * @return
    */
   @Override
   public IPage<Article> pageWords(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.pageWords(page,article));
      return page.setRecords(baseMapper.pageWords(page, article));
   }

   @Override
   public IPage<Article> pageCollectList(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.pageCollectList(page,article));
      return page.setRecords(baseMapper.pageCollectList(page, article));
   }

   /**
    * 查询资讯分页信息(角色权限)附带评论点赞数
    *
    * @param page
    * @param article 资讯对象
    * @return
    */
   @Override
   public IPage<Article> pageLikes(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.pageLikes(page,article));
      return page.setRecords(baseMapper.pageLikes(page, article));
   }

   @Override
   public IPage<Article> pageCollect(IPage<Article> page, ArticleVO article) {
      return page.setRecords(baseMapper.pageCollect(page,article));
      return page.setRecords(baseMapper.pageCollect(page, article));
   }

   /**
@@ -105,6 +162,11 @@

   @Override
   public ArticleVO getArticleOne(ArticleVO article) {
      if (article.getType() != null && article.getType().equals(4)) {
         article.setParentId("1740566650527752194");
      } else {
         article.setParentId("1722966265111248897");
      }
      ArticleVO articleVO = baseMapper.getArticleOne(article);
      return articleVO;
   }