报事报修物业人员查询优化

linwei

2024-02-21 876ce063e5026dc934667dedfb0b658a22b9c43d

 src/main/java/org/springblade/modules/task/service/impl/TaskReportForRepairsServiceImpl.java

@@ -16,14 +16,40 @@
 */
package org.springblade.modules.task.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import org.springblade.common.cache.SysCache;
import org.springblade.common.param.CommonParamSet;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.mp.base.BaseServiceImpl;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.SpringUtil;
import org.springblade.modules.district.entity.DistrictEntity;
import org.springblade.modules.district.service.IDistrictService;
import org.springblade.modules.grid.entity.GridmanEntity;
import org.springblade.modules.grid.service.IGridService;
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.springblade.modules.sse.server.SSEServer;
import org.springblade.modules.system.service.IDeptService;
import org.springblade.modules.task.entity.TaskEntity;
import org.springblade.modules.task.entity.TaskReportForRepairsEntity;
import org.springblade.modules.task.vo.TaskReportForRepairsVO;
import org.springblade.modules.task.mapper.TaskReportForRepairsMapper;
import org.springblade.modules.task.service.ITaskReportForRepairsService;
import org.springblade.core.mp.base.BaseServiceImpl;
import org.springblade.modules.task.service.ITaskService;
import org.springblade.modules.task.vo.TaskReportForRepairsVO;
import org.springblade.modules.task.vo.TaskReportStatistics;
import org.springblade.modules.taskPlaceSelfCheck.vo.TaskPlaceSelfCheckVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;

/**
 * 报事报修任务表 服务实现类
@@ -34,15 +60,195 @@
@Service
public class TaskReportForRepairsServiceImpl extends BaseServiceImpl<TaskReportForRepairsMapper, TaskReportForRepairsEntity> implements ITaskReportForRepairsService {

   @Autowired
   private ITaskService taskService;

   @Autowired
   private IGridService gridService;

   @Autowired
   private IDeptService deptService;

   /**
    * 自定义分页
    *
    * @param page
    * @param taskReportForRepairs
    * @return
    */
   @Override
   public IPage<TaskReportForRepairsVO> selectTaskReportForRepairsPage(IPage<TaskReportForRepairsVO> page, TaskReportForRepairsVO taskReportForRepairs) {
      return page.setRecords(baseMapper.selectTaskReportForRepairsPage(page, taskReportForRepairs));
      // 公共参数设置
      CommonParamSet commonParamSet = new CommonParamSet().invoke(TaskReportForRepairsVO.class,taskReportForRepairs);
      taskReportForRepairs.setConfirmUserId(AuthUtil.getUserId());
      List<String> addressCodeList = new ArrayList<>();
      if (null != taskReportForRepairs.getRoleName() && !taskReportForRepairs.getRoleName().equals("")) {
          if (taskReportForRepairs.getRoleName().equals("居民")) {
            taskReportForRepairs.setCreateUser(AuthUtil.getUserId());
            taskReportForRepairs.setConfirmUserId(null);
            //
            taskReportForRepairs.setRoleType("inhabitant");
         }
      }
      String userRole = AuthUtil.getUserRole();
      List<String> aoiCodeList = new ArrayList<>();
      if (userRole.contains("wygly") || userRole.contains("wyxmjl")|| userRole.contains("wyfwry")) {
         taskReportForRepairs.setRoleType("wy");
         // 查询小区id
         IPropertyDistrictUserService propertyDistrictUserService = SpringUtils.getBean(IPropertyDistrictUserService.class);
         List<String> districtIds = propertyDistrictUserService.selectPropertyDistrictByUserId(AuthUtil.getUserId());
         // 通过用户机构查询用户的物业公司
         IPropertyCompanyService bean = SpringUtil.getBean(IPropertyCompanyService.class);
         PropertyCompanyEntity companyEntity = bean.getOne(Wrappers.<PropertyCompanyEntity>lambdaQuery().eq(PropertyCompanyEntity::getDeptId, AuthUtil.getDeptId()));
         if (companyEntity != null) {
            IPropertyCompanyDistrictService bean2 = SpringUtils.getBean(IPropertyCompanyDistrictService.class);
            // 通过物业公司，查询小区
            List<PropertyCompanyDistrictEntity> companyDistrictEntities = bean2.list(Wrappers.<PropertyCompanyDistrictEntity>lambdaQuery()
               .eq(PropertyCompanyDistrictEntity::getPropertyCompanyId, companyEntity.getId()));
            if (companyDistrictEntities.size() > 0) {
               List<String> collect = companyDistrictEntities.stream().map(i -> i.getDistrictId()).collect(Collectors.toList());
               districtIds.addAll(collect);
            }
         }
         if (districtIds.size() == 0) {
            return page.setRecords(new ArrayList<>());
         }
         IDistrictService districtService = SpringUtil.getBean(IDistrictService.class);
         List<DistrictEntity> districtEntityList = districtService.list(Wrappers.<DistrictEntity>lambdaQuery().in(DistrictEntity::getId, districtIds));
         aoiCodeList = districtEntityList.stream().map(i -> i.getAoiCode()).collect(Collectors.toList());
      }

      return page.setRecords(baseMapper.selectTaskReportForRepairsPage(page, taskReportForRepairs, addressCodeList,
         commonParamSet.getRegionChildCodesList(), commonParamSet.getIsAdministrator(), aoiCodeList,commonParamSet.getGridCodeList()));
   }

   /**
    * 查询报事报修统计
    *
    * @return
    */
   @Override
   public TaskReportStatistics getStatisticsCount(String houseCode) {
      List<String> regionChildCodesList = SysCache.getRegionChildCodesByDeptId(AuthUtil.getDeptId());
      Integer isAdministrator = AuthUtil.isAdministrator() == true ? 1 : 2;
      return baseMapper.getStatisticsCount(AuthUtil.getUserId(), houseCode, regionChildCodesList, isAdministrator);
   }

   /**
    * 报事报修任务表 新增
    *
    * @param taskReportForRepairs
    * @return
    */
   @Override
   public boolean saveTaskReportForRepairs(TaskReportForRepairsEntity taskReportForRepairs) {
      boolean flag = false;
      // 任务新增
      TaskEntity taskEntity = new TaskEntity();
      taskEntity.setName(taskReportForRepairs.getRealName() + "报修");
      taskEntity.setStatus(1);
      taskEntity.setType(1);
      taskEntity.setFrequency(3);
      if (null != taskReportForRepairs.getAddressCode() && !taskReportForRepairs.getAddressCode().equals("")) {
         taskEntity.setHouseCode(taskReportForRepairs.getAddressCode());
      }
      // 新增
      boolean save = taskService.save(taskEntity);
      if (save) {
         taskReportForRepairs.setTaskId(taskEntity.getId());
         taskReportForRepairs.setConfirmFlag(1);
         flag = save(taskReportForRepairs);
         // 同时向web 端推送消息
         SSEServer.sendMessage("web:1", "1");
      }
      return flag;
   }

   /**
    * 报事报修任务表 自定义修改
    *
    * @param taskReportForRepairs
    * @return
    */
   @Override
   public boolean updateTaskReportForRepairs(TaskReportForRepairsEntity taskReportForRepairs) {
      // 设置参数
      taskReportForRepairs.setUpdateTime(new Date());
      taskReportForRepairs.setUpdateUser(AuthUtil.getUserId());
      // 更新
      return updateById(taskReportForRepairs);
   }

   /**
    * 报事报修任务表 审核
    *
    * @param taskReportForRepairs
    * @return
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public boolean checkReportForRepairs(TaskReportForRepairsEntity taskReportForRepairs) {
      boolean flag = false;
      // 设置更新时间
      taskReportForRepairs.setConfirmTime(new Date());
      taskReportForRepairs.setConfirmUserId(AuthUtil.getUserId());
      // 更新数据
      boolean b = updateById(taskReportForRepairs);
      if (b) {
         TaskReportForRepairsEntity entity = getById(taskReportForRepairs.getId());
         // 更新任务表状态
         TaskEntity taskEntity = new TaskEntity();
         taskEntity.setId(entity.getTaskId());
         taskEntity.setStatus(taskReportForRepairs.getConfirmFlag());
         flag = taskService.updateById(taskEntity);
      }
      // 返回
      return flag;
   }

   @Override
   public TaskReportStatistics getStatisticsCount() {
      return baseMapper.getStatisticsCount();
   public Integer getStatistics(Long userId, String neiCode) {
      return baseMapper.getStatistics(userId, neiCode);
   }

   /**
    * 更新状态--临时接口
    *
    * @param gridman
    * @return
    */
   @Override
   public boolean updateView(GridmanEntity gridman) {
      baseMapper.updateView(gridman);
      return true;
   }

   @Override
   public Object getReportForStatistics(String code, String roleType) {
      Map<String, Object> objectObjectHashMap = new HashMap<>();
      if (roleType.equals("2")) {
         Integer result1 = baseMapper.getReportForStatistics(code, null, null, null, roleType);
         Integer result = baseMapper.getReportForStatistics(code, null, 3, null, roleType);
         objectObjectHashMap.put("result", result1);
         objectObjectHashMap.put("result1", result);
         objectObjectHashMap.put("result2", result1.equals(0) ? 0 : BigDecimal.valueOf(result).divide(BigDecimal.valueOf(result1), 4, BigDecimal.ROUND_HALF_UP));
         objectObjectHashMap.put("result3", baseMapper.getReportForStatistics(code, null, null, 1, roleType));
         objectObjectHashMap.put("result4", baseMapper.getReportForStatistics(code, null, null, 2, roleType));
         objectObjectHashMap.put("result5", baseMapper.getReportForStatistics(code, null, null, 3, roleType));
         objectObjectHashMap.put("result6", baseMapper.getReportForStatistics(code, null, null, 4, roleType));
      } else {
         Integer result1 = baseMapper.getReportForStatistics(code, AuthUtil.getUserId(), null, null, roleType);
         Integer result = baseMapper.getReportForStatistics(code, AuthUtil.getUserId(), 3, null, roleType);
         // result 总数  result1 已处理  result2 处理率  result3 公共维修  result4 居家维修  result5 矛盾纠纷  result6 投诉举报
         objectObjectHashMap.put("result", result1);
         objectObjectHashMap.put("result1", result);
         objectObjectHashMap.put("result2", result1.equals(0) ? 0 : BigDecimal.valueOf(result).divide(BigDecimal.valueOf(result1), 4, BigDecimal.ROUND_HALF_UP));
         objectObjectHashMap.put("result3", baseMapper.getReportForStatistics(code, AuthUtil.getUserId(), null, 1, roleType));
         objectObjectHashMap.put("result4", baseMapper.getReportForStatistics(code, AuthUtil.getUserId(), null, 2, roleType));
         objectObjectHashMap.put("result5", baseMapper.getReportForStatistics(code, AuthUtil.getUserId(), null, 3, roleType));
         objectObjectHashMap.put("result6", baseMapper.getReportForStatistics(code, AuthUtil.getUserId(), null, 4, roleType));
      }
      return objectObjectHashMap;
   }

}