报事报修查询优化

lin

2024-04-15 5b33d886cb6da7a8b0f66f0c0bb0a3d0b2b19d6a

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

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

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import org.springblade.core.mp.base.BaseServiceImpl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.itextpdf.text.log.Logger;
import com.itextpdf.text.log.LoggerFactory;
import org.apache.commons.lang3.StringUtils;
import org.springblade.common.constant.CommonConstant;
import org.springblade.common.constant.DictConstant;
import org.springblade.common.param.CommonParamSet;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.task.entity.TaskEntity;
import org.springblade.modules.category.entity.CategoryEntity;
import org.springblade.modules.category.service.ICategoryService;
import org.springblade.modules.grid.entity.GridEntity;
import org.springblade.modules.grid.entity.GridWorkLogEntity;
import org.springblade.modules.grid.service.IGridService;
import org.springblade.modules.grid.service.IGridWorkLogService;
import org.springblade.modules.house.service.IHouseRentalService;
import org.springblade.modules.house.service.IHouseholdService;
import org.springblade.modules.house.vo.HouseRentalTenantVO;
import org.springblade.modules.house.vo.HouseholdVO;
import org.springblade.modules.place.service.IPlaceExtService;
import org.springblade.modules.place.service.IPlaceService;
import org.springblade.modules.place.vo.PlaceVO;
import org.springblade.modules.sms.service.ISmsSendService;
import org.springblade.modules.task.entity.*;
import org.springblade.modules.task.mapper.TaskMapper;
import org.springblade.modules.task.service.ITaskService;
import org.springblade.modules.task.service.*;
import org.springblade.modules.task.vo.TaskVO;
import org.springblade.modules.task.service.ITaskPlaceRectificationService;
import org.springblade.modules.task.entity.TaskPlaceSelfCheckEntity;
import org.springblade.modules.task.service.ITaskPlaceSelfCheckService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.time.LocalDate;
import java.time.temporal.ChronoUnit;
import java.util.*;
import java.util.stream.Collectors;

/**
 * 任务表 服务实现类
@@ -37,12 +68,107 @@
 * @since 2023-11-06
 */
@Service
public class TaskServiceImpl extends BaseServiceImpl<TaskMapper, TaskEntity> implements ITaskService {
public class TaskServiceImpl extends ServiceImpl<TaskMapper, TaskEntity> implements ITaskService {

   private Logger logger = LoggerFactory.getLogger(TaskServiceImpl.class);

   @Autowired
   private IPlaceService placeService;

   @Autowired
   private IHouseholdService iHouseholdService;

   @Autowired
   private IHouseRentalService iHouseRentalService;

   @Autowired
   private ICategoryService categoryService;

   @Autowired
   private ITaskCampusReportingEventService taskCampusReportingEventService;

   @Autowired
   private ITaskLabelReportingEventService taskLabelReportingEventService;

   @Autowired
   private ITaskHotelReportingService taskHotelReportingService;

   @Autowired
   private IGridWorkLogService gridWorkLogService;

   @Autowired
   private ITaskResidencePermitApplyService residencePermitApplyService;

   @Autowired
   private ISmsSendService smsSendService;

   // 确保该常量值正确地从配置文件中读取或以更合适的方式定义
   private static final long SMS_TEMPLATE_ID = 1775429789463142401L;

   @Override
   public IPage<TaskVO> selectTaskPage(IPage<TaskVO> page, TaskVO task) {
      return page.setRecords(baseMapper.selectTaskPage(page, task));
//      String roleName = SpringUtils.getRequestParam("roleName");
//      String communityCode = SpringUtils.getRequestParam("communityCode");
//      if (!Strings.isBlank(communityCode)) {
//         // 校验社区编号是否合规
//         if (null != SpringUtils.getBean(IRegionService.class).getById(communityCode)) {
//            task.setCommunityCode(communityCode);
//         }
//      }
//      List<String> regionChildCodesList = SysCache.getRegionChildCodesByDeptId(AuthUtil.getDeptId());
//      Integer isAdministrator = AuthUtil.isAdministrator() == true ? 1 : 2;
      // 网格编号集合
//      List<String> gridCodeList = new ArrayList<>();
      // 民警角色
//      if (!Strings.isBlank(roleName)) {
//         task.setRoleName(roleName);
//         if (roleName.equals("mj")) {
//            regionChildCodesList = SpringUtil.getBean(IPoliceAffairsGridService.class).getCommunityCodeListByUserId(AuthUtil.getUserId());
//         }
//         if (roleName.equals("wgy")) {
//            gridCodeList = SpringUtil.getBean(IGridService.class).getGridListByUserId(AuthUtil.getUserId());
//         }
//      }
//      if (AuthUtil.getUserAccount().equals("18879306957")) {
//         task.setCommunityCode("361102003027");
//      }
      CommonParamSet commonParamSet = new CommonParamSet().invoke(TaskVO.class, task);
      if (null != task.getReportType() && task.getReportType() == 1) {
         // 查询取保候审任务列表(人房相关)
         return page.setRecords(baseMapper.selectTaskPageByPerson(page, task, commonParamSet.getRegionChildCodesList(),
            commonParamSet.getIsAdministrator(), commonParamSet.getGridCodeList()));
      }
      // 查询非取保候审任务列表(场所相关)
      return page.setRecords(baseMapper.selectTaskPage(page, task, commonParamSet.getRegionChildCodesList(),
         commonParamSet.getIsAdministrator(), commonParamSet.getGridCodeList()));
   }

   @Override
   public IPage<TaskVO> getBailReportingPage(IPage<TaskVO> page, TaskVO task) {
      CommonParamSet commonParamSet = new CommonParamSet().invoke(TaskVO.class, task);
      // 民警角色
      if (AuthUtil.getUserRole().equals("mj")) {
         task.setUserId(AuthUtil.getUserId());
         return page.setRecords(baseMapper.selectTaskPageBy(page, task,
            commonParamSet.getRegionChildCodesList(),
            commonParamSet.getIsAdministrator()));
      } else {
         if (AuthUtil.getUserAccount().equals("18879306957")) {
            task.setCommunityCode("361102003027");
            task.setUserId(null);
         }
         if (AuthUtil.getUserRole().equals("wgy")) {
            task.setUserId(AuthUtil.getUserId());
         }
         // 非民警角色
         List<TaskVO> taskVOS = baseMapper.getBailReportingPage(page,
            task,
            commonParamSet.getRegionChildCodesList(),
            commonParamSet.getGridCodeList(),
            commonParamSet.getIsAdministrator());
         // 返回
         return page.setRecords(taskVOS);
      }
   }

   /**
@@ -56,7 +182,8 @@
    * @return
    */
   @Override
   public Long saveTask(Integer type, String name, Integer frequency, String remark, Long createUser, String houseCode) {
   public Long saveTask(Integer type, String name, Integer frequency, String remark, Long createUser,
                   String houseCode, Integer reportType, Integer status) {
      TaskEntity taskEntity = new TaskEntity();
      taskEntity.setType(type);
      taskEntity.setName(name);
@@ -65,6 +192,8 @@
      taskEntity.setCreateTime(new Date());
      taskEntity.setCreateUser(createUser);
      taskEntity.setHouseCode(houseCode);
      taskEntity.setReportType(reportType);
      taskEntity.setStatus(status);
      return baseMapper.insert(taskEntity) > 0 ? taskEntity.getId() : 0;
   }

@@ -87,12 +216,532 @@
   public Object countNumber(String houseCode, Integer status) {
      Map<String, Object> objectObjectHashMap = new HashMap<>();
      // 总数
      Long all = baseMapper.selectCount(Wrappers.<TaskEntity>lambdaQuery().eq(TaskEntity::getCreateUser, AuthUtil.getUserId() ));
      LambdaQueryWrapper<TaskEntity> objectQueryWrapper = new LambdaQueryWrapper<>();
      objectQueryWrapper.eq(TaskEntity::getCreateUser, AuthUtil.getUserId());
      objectQueryWrapper.isNotNull(TaskEntity::getHouseCode);
      objectQueryWrapper.eq(TaskEntity::getIsDeleted, 0);
      objectQueryWrapper.in(TaskEntity::getReportType, 2, 3, 4, 5, 6);
      if (StringUtils.isNotBlank(houseCode)) {
         objectQueryWrapper.eq(TaskEntity::getHouseCode, houseCode);
      }
      Long all = baseMapper.selectCount(objectQueryWrapper);
      objectQueryWrapper.eq(TaskEntity::getStatus, 2);
      // 已处理
      Long processed = baseMapper.selectCount(Wrappers.<TaskEntity>lambdaQuery().eq(TaskEntity::getCreateUser, AuthUtil.getUserId())
         .eq(TaskEntity::getStatus, 2));
      Long processed = baseMapper.selectCount(objectQueryWrapper);
      objectObjectHashMap.put("all", all);
      objectObjectHashMap.put("processed", processed);
      return objectObjectHashMap;
   }

   @Override
   public Object countTypeNumber(Integer roleType, String neiCode) {
      TaskVO taskVO = new TaskVO();
      Map<String, Object> objectObjectHashMap = new HashMap<>();
      taskVO.setStatus(1);
      taskVO.setUserId(roleType > 0 ? AuthUtil.getUserId() : null);
      taskVO.setNeiCode(neiCode);
      taskVO.setReportType(5);
      taskVO.setIsDeleted(0);
      CommonParamSet commonParamSet = new CommonParamSet().invoke(TaskVO.class, taskVO);

      // 标签报事-二手交易
      Integer bqsj = baseMapper.selectTaskCount(taskVO, commonParamSet.getRegionChildCodesList(),
         commonParamSet.getIsAdministrator(), commonParamSet.getGridCodeList());
      taskVO.setReportType(1);
      // 取保候审
      Integer qbhs = baseMapper.selectTaskCount(taskVO, commonParamSet.getRegionChildCodesList(),
         commonParamSet.getIsAdministrator(), commonParamSet.getGridCodeList());
      // 报事报修
      Integer bsbx = SpringUtils.getBean(ITaskReportForRepairsService.class).getStatistics(roleType > 0 ? AuthUtil.getUserId() : null, neiCode,commonParamSet.getRegionChildCodesList(),
         commonParamSet.getIsAdministrator(), commonParamSet.getGridCodeList());
      // 住户审核
      Integer zhsh = iHouseholdService.statistics(roleType > 0 ? AuthUtil.getUserId() : null, neiCode, 0);
      // 出租审核
      HouseRentalTenantVO houseRentalTenantVO = new HouseRentalTenantVO();
      houseRentalTenantVO.setCommunityCode(neiCode);
      houseRentalTenantVO.setAuditStatus(2);
      Integer czsh = iHouseRentalService.getStatisticsCount(houseRentalTenantVO);
      // 场所审核
      Integer cssh = SpringUtils.getBean(IPlaceExtService.class).selectCount(roleType > 0 ? AuthUtil.getUserId() : null, neiCode, 1);
      // 走访日志
      // 查询网格员对应的网格id
      String gridCode = getGridCode();
      Integer zfrw = SpringUtils.getBean(IGridWorkLogService.class).getGridWorkCountHandleCount(gridCode, 1);
      // 消防自查
      Integer xfzc = SpringUtils.getBean(ITaskPlaceSelfCheckService.class).getCount(neiCode, 1);
      // 消防隐患整改
      Integer xfyhzg = SpringUtils.getBean(ITaskPlaceRectificationService.class).getCount(neiCode, 1);
      // 居住证申请
      Integer jzzsq = residencePermitApplyService.getCount(neiCode, 1);
      // 无诈统计
      taskVO.setReportType(6);
      Integer wztj = baseMapper.selectTaskCount(taskVO, commonParamSet.getRegionChildCodesList(),
         commonParamSet.getIsAdministrator(), commonParamSet.getGridCodeList());
      // 设置
      objectObjectHashMap.put("qbhs", qbhs);// 取保候审
      objectObjectHashMap.put("bqsj", bqsj);// 标签报事-二手交易
      objectObjectHashMap.put("bsbx", bsbx);// 报事报修
      objectObjectHashMap.put("zhsh", zhsh);// 住户审核
      objectObjectHashMap.put("czsh", czsh);// 出租审核
      objectObjectHashMap.put("cssh", cssh);// 场所审核
      objectObjectHashMap.put("zfrw", zfrw);// 走访日志
      objectObjectHashMap.put("xfzc", xfzc);// 消防自查
      objectObjectHashMap.put("xfyhzg", xfyhzg);// 消防隐患整改
      objectObjectHashMap.put("jzzsq", jzzsq);// 居住证申请
      objectObjectHashMap.put("wztj", wztj);// 无诈
      return objectObjectHashMap;
   }

   /**
    * 获取网格员id
    *
    * @return
    */
   private String getGridCode() {
      GridEntity grid = SpringUtils.getBean(IGridService.class).getGridByUserId(AuthUtil.getUserId());
      if (null != grid) {
         return grid.getGridCode();
      }
      return null;
   }

   @Override
   public Object countFrequencyNumber() {
      Map<String, Object> objectObjectHashMap = new HashMap<>();
      TaskVO taskVO = new TaskVO();
      taskVO.setUserId(AuthUtil.getUserId());
      taskVO.setFrequency(1);
      taskVO.setStatus(1);
      Integer disposable = baseMapper.selectTaskCount(taskVO, null, null, null);
      taskVO.setFrequency(2);
      Integer periodicity = baseMapper.selectTaskCount(taskVO, null, null, null);
      objectObjectHashMap.put("disposable", disposable);
      objectObjectHashMap.put("periodicity", periodicity);
      return objectObjectHashMap;
   }

   @Override
   public Boolean removeTask(TaskEntity task) {

      boolean update1 = update(Wrappers.<TaskEntity>lambdaUpdate()
         .set(TaskEntity::getIsDeleted, 1)
         .eq(TaskEntity::getId, task.getId()));
      if (update1) {
         if (task.getReportType().equals(1)) {
            ITaskBailReportingEventService bean = SpringUtils.getBean(ITaskBailReportingEventService.class);
            boolean update = bean.update(Wrappers.<TaskBailReportingEventEntity>lambdaUpdate()
               .set(TaskBailReportingEventEntity::getIsDeleted, 1)
               .eq(TaskBailReportingEventEntity::getTaskId, task.getId()));
            return update;
         } else if (task.getReportType().equals(2)) {
            ITaskHotelReportingService bean = SpringUtils.getBean(ITaskHotelReportingService.class);
            boolean update = bean.update(Wrappers.<TaskHotelReportingEntity>lambdaUpdate()
               .set(TaskHotelReportingEntity::getIsDeleted, 1)
               .eq(TaskHotelReportingEntity::getTaskId, task.getId()));
            return update;
         } else if (task.getReportType().equals(3)) {
            ITaskLabelReportingEventService bean = SpringUtils.getBean(ITaskLabelReportingEventService.class);
            boolean update = bean.update(Wrappers.<TaskLabelReportingEventEntity>lambdaUpdate()
               .set(TaskLabelReportingEventEntity::getIsDeleted, 1)
               .eq(TaskLabelReportingEventEntity::getTaskId, task.getId()));
            return update;
         } else if (task.getReportType().equals(4)) {
            ITaskLabelReportingEventService bean = SpringUtils.getBean(ITaskLabelReportingEventService.class);
            boolean update = bean.update(Wrappers.<TaskLabelReportingEventEntity>lambdaUpdate()
               .set(TaskLabelReportingEventEntity::getIsDeleted, 1)
               .eq(TaskLabelReportingEventEntity::getTaskId, task.getId()));
            return update;
         } else if (task.getReportType().equals(5)) {
            ITaskLabelReportingEventService bean = SpringUtils.getBean(ITaskLabelReportingEventService.class);
            boolean update = bean.update(Wrappers.<TaskLabelReportingEventEntity>lambdaUpdate()
               .set(TaskLabelReportingEventEntity::getIsDeleted, 1)
               .eq(TaskLabelReportingEventEntity::getTaskId, task.getId()));
            return update;
         } else if (task.getReportType().equals(6)) {
            ITaskCampusReportingEventService bean = SpringUtils.getBean(ITaskCampusReportingEventService.class);
            boolean update = bean.update(Wrappers.<TaskCampusReportingEventEntity>lambdaUpdate()
               .set(TaskCampusReportingEventEntity::getIsDeleted, 1)
               .eq(TaskCampusReportingEventEntity::getTaskId, task.getId()));
            return update;
         }
      }

      return update1;
   }

   /**
    * 根据类型创建任务
    *
    * @param param 参数
    * @return
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public boolean createTaskJob(String param) {
      // 解析参数
      JSONObject jsonParam = JSON.parseObject(param);
//      String params = jsonParam.getString("params");
      boolean flag = false;
      // 校园安全自查任务生成
      createCampusReportingTask();
      // 打金店/二手车/二手手机任务生成
      createLabelReportingTask();
      // 旅馆安全自查任务生成
      createHotelReportingTask();
      // 人员类-肇事肇祸精神障碍患者走访任务生成
      createGridWordTask();
      // 返回
      return flag;
   }


   /**
    * 人员类-肇事肇祸精神障碍患者走访任务生成
    */
   public void createGridWordTask() {
      // 肇事肇祸精神障碍患者走访任务生成，查询标签为：1006
      List<Integer> list = new ArrayList<Integer>() {{
         add(1006);
      }};
      // 根据人员标签编号集合查询对应的住户（按颜色区分近多少天没有发过任务的住户）
      List<HouseholdVO> householdVOList = iHouseholdService.getHouseholdListByParam(list);
      // 生成任务
      for (HouseholdVO household : householdVOList) {
         // 新增走访任务
         saveGridWordTask(household);
      }
   }

   /**
    * 新增走访任务
    *
    * @param household
    */
   public void saveGridWordTask(HouseholdVO household) {
      GridWorkLogEntity gridWorkLogEntity = new GridWorkLogEntity();
      gridWorkLogEntity.setHouseholdId(household.getId());
      gridWorkLogEntity.setType(2);
      gridWorkLogEntity.setPersonType(1006);
      // 系统下发
      gridWorkLogEntity.setSource(2);
      // 待处理
      gridWorkLogEntity.setStatus(1);
      // 新增
      gridWorkLogService.save(gridWorkLogEntity);
   }

   /**
    * 打金店/二手车/二手手机任务生成
    */
   public void createLabelReportingTask() {
      // 打金店/二手车/二手手机任务生成，标签:130808/140304/130604
      List<String> stringList = new ArrayList<String>() {{
         add("130808");
         add("140304");
         add("130604");
      }};
      String tableName = "jczz_task_label_reporting_event";
      // 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）
      List<PlaceVO> placeVOList = placeService.getPlaceListByParam(stringList, tableName);
      // 生成任务
      for (PlaceVO placeVO : placeVOList) {
         String taskName = "";
         Integer reportType = 3;
         if (placeVO.getLabel().equals("130808")) {
            taskName = DictConstant.SECOND_HAND_TRANSACTION;
            reportType = 3;
         }
         if (placeVO.getLabel().equals("130604")) {
            taskName = DictConstant.USED_MOBILE_PHONES;
            reportType = 4;
         }
         if (placeVO.getLabel().equals("140304")) {
            taskName = DictConstant.USED_CAR;
            reportType = 5;
         }
         // 新增任务
         TaskEntity taskEntity = saveTaskEntity(placeVO.getHouseCode(), 1, taskName, 2, reportType);
         // 同时新增打金店/二手车/二手手机任务
         saveGoldShop(placeVO, taskEntity, taskName, reportType);
      }
   }

   /**
    * 旅馆安全自查任务生成
    */
   public void createHotelReportingTask() {
      // 旅馆标签为
      List<String> stringList = new ArrayList<String>() {{
         add("120101");
         add("120102");
         add("120103");
         add("120104");
      }};
      String tableName = "jczz_task_hotel_reporting";
      // 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）
      List<PlaceVO> placeVOList = placeService.getPlaceListByParam(stringList, tableName);
      // 生成任务
      for (PlaceVO placeVO : placeVOList) {
         // 新增任务
         TaskEntity taskEntity = saveTaskEntity(placeVO.getHouseCode(), 1, DictConstant.HOTEL_SECURITY, 2, 2);
         // 同时新增校园安全检查任务
         saveHotel(placeVO, taskEntity);
      }
   }

   /**
    * 校园安全自查任务生成
    */
   public void createCampusReportingTask() {
      // 校园安全自查，查询标签为教育的场所 parentNo = 1601
      String parentNo = "1601";
      QueryWrapper<CategoryEntity> wrapper = new QueryWrapper<>();
      wrapper.eq("is_deleted", 0).eq("parent_no", parentNo);
      List<CategoryEntity> categoryEntityList = categoryService.list(wrapper);
      // 取出编号集合
      List<String> stringList = categoryEntityList.stream().map(categoryEntity -> categoryEntity.getCategoryNo()).collect(Collectors.toList());
      // 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）
      String tableName = "jczz_task_campus_reporting_event";
      List<PlaceVO> placeVOList = placeService.getPlaceListByParam(stringList, tableName);
      // 生成任务
      for (PlaceVO placeVO : placeVOList) {
         // 新增任务
         TaskEntity taskEntity = saveTaskEntity(placeVO.getHouseCode(), 1, DictConstant.CAMPUS_SECURITY_INSPECTION, 2, 6);
         // 同时新增校园安全检查任务
         saveCampus(placeVO, taskEntity);
      }
   }

   /**
    * 新增校园安全检查任务
    *
    * @param placeVO
    * @param taskEntity
    */
   private void saveCampus(PlaceVO placeVO, TaskEntity taskEntity) {
      TaskCampusReportingEventEntity campusReportingEventEntity = new TaskCampusReportingEventEntity();
      campusReportingEventEntity.setTaskId(taskEntity.getId());
      campusReportingEventEntity.setPlaceId(placeVO.getId());
      campusReportingEventEntity.setCampusName(placeVO.getPlaceName());
      campusReportingEventEntity.setCheckUserId(placeVO.getPrincipalUserId());
      campusReportingEventEntity.setCheckUserName(placeVO.getPrincipal());
      campusReportingEventEntity.setCheckTelephone(placeVO.getPrincipalPhone());
      // 系统下发
      campusReportingEventEntity.setSource(2);
      // 待完善
      campusReportingEventEntity.setConfirmFlag("4");
      // 新增
      taskCampusReportingEventService.save(campusReportingEventEntity);
   }

   /**
    * 新增旅馆安全检查任务
    *
    * @param placeVO
    * @param taskEntity
    */
   private void saveHotel(PlaceVO placeVO, TaskEntity taskEntity) {
      TaskHotelReportingEntity taskHotelReportingEntity = new TaskHotelReportingEntity();
      taskHotelReportingEntity.setTaskId(taskEntity.getId());
      taskHotelReportingEntity.setPlaceId(placeVO.getId());
      taskHotelReportingEntity.setHotelName(placeVO.getPlaceName());
      taskHotelReportingEntity.setCheckUserId(placeVO.getPrincipalUserId());
      taskHotelReportingEntity.setCheckUserName(placeVO.getPrincipal());
      taskHotelReportingEntity.setCheckTelephone(placeVO.getPrincipalPhone());
      // 系统下发
      taskHotelReportingEntity.setSource(2);
      // 待完善
      taskHotelReportingEntity.setConfirmFlag("4");
      // 新增
      taskHotelReportingService.save(taskHotelReportingEntity);
   }


   /**
    * 新增打金店/二手车/二手手机任务
    *
    * @param placeVO
    * @param taskEntity
    * @param taskName
    * @param reportType
    */
   private void saveGoldShop(PlaceVO placeVO, TaskEntity taskEntity, String taskName, Integer reportType) {
      TaskLabelReportingEventEntity taskLabelReportingEventEntity = new TaskLabelReportingEventEntity();
      taskLabelReportingEventEntity.setTaskId(taskEntity.getId());
      taskLabelReportingEventEntity.setPlaceId(placeVO.getId());
      taskLabelReportingEventEntity.setDistrictName(placeVO.getPlaceName());
      taskLabelReportingEventEntity.setUserId(placeVO.getPrincipalUserId());
      taskLabelReportingEventEntity.setOwner(placeVO.getPrincipal());
      taskLabelReportingEventEntity.setPhoneNumber(placeVO.getPrincipalPhone());
      taskLabelReportingEventEntity.setLabelName(taskName);
      // 打金店
      if (reportType == 3) {
         taskLabelReportingEventEntity.setEventType("1");
      }
      // 二手车
      if (reportType == 4) {
         taskLabelReportingEventEntity.setEventType("3");
      }
      // 二手手机
      if (reportType == 5) {
         taskLabelReportingEventEntity.setEventType("2");
      }
      // 系统下发
      taskLabelReportingEventEntity.setSource(2);
      // 待完善
      taskLabelReportingEventEntity.setConfirmFlag("4");
      // 新增
      taskLabelReportingEventService.save(taskLabelReportingEventEntity);
   }

   /**
    * 插入任务信息
    *
    * @param houseCode
    * @param type
    * @param taskName
    * @param frequency
    * @param reportType
    * @return
    */
   private TaskEntity saveTaskEntity(String houseCode,
                             Integer type,
                             String taskName,
                             Integer frequency,
                             Integer reportType) {
      TaskEntity taskEntity = new TaskEntity();
      taskEntity.setType(type);
      taskEntity.setName(taskName);
      taskEntity.setFrequency(frequency);
      taskEntity.setCreateTime(new Date());
      taskEntity.setHouseCode(houseCode);
      taskEntity.setReportType(reportType);
      // 系统下发
      taskEntity.setSource(2);
      // 待场所负责人上报完善处理
      taskEntity.setStatus(4);
      // 新增
      save(taskEntity);
      // 返回
      return taskEntity;
   }

   /**
    * 审核任务。
    * 根据任务的报告类型，更新相应的任务状态，并触发相应的事件更新。
    *
    * @param task 任务实体，包含任务信息和报告类型。
    * @return 返回审核结果，成功为true，失败为false。
    */
   @Override
   public Boolean examine(TaskEntity task) {
      if (task == null || task.getReportType() == null) {
         // 检查任务和报告类型是否为空，若为空则直接返回false
         return false;
      }
      // 根据任务报告类型，更新任务状态并触发相应的事件更新
      boolean result = updateById(task);
      if (!result) {
         return false;
      }
      if (task.getReportType().equals(CommonConstant.REPORT_TYPE_SECONDHAND_TRADE)) {
         // 如果报告类型匹配，尝试更新任务标签报告事件状态
         ITaskLabelReportingEventService bean = SpringUtils.getBean(ITaskLabelReportingEventService.class);
         return bean.update(Wrappers.<TaskLabelReportingEventEntity>lambdaUpdate()
            .set(TaskLabelReportingEventEntity::getConfirmFlag, task.getStatus())
            .eq(TaskLabelReportingEventEntity::getTaskId, task.getId()));
      } else if (task.getReportType().
         equals(CommonConstant.REPORT_TYPE_FIRE_INSPECTION)) {
         // 如果报告类型为消防自查，尝试更新消防自查状态
         ITaskPlaceSelfCheckService bean = SpringUtils.getBean(ITaskPlaceSelfCheckService.class);
         return bean.update(Wrappers.<TaskPlaceSelfCheckEntity>lambdaUpdate()
            .set(TaskPlaceSelfCheckEntity::getStatus, task.getStatus())
            .eq(TaskPlaceSelfCheckEntity::getTaskId, task.getId()));

      } else if (task.getReportType().equals(CommonConstant.REPORT_TYPE_NO_FRAUD)) {
         // 如果报告类型为无诈，尝试更新无诈报告状态
         ITaskNoFraudReportingService bean = SpringUtils.getBean(ITaskNoFraudReportingService.class);
         return bean.update(Wrappers.<TaskNoFraudReportingEntity>lambdaUpdate()
            .set(TaskNoFraudReportingEntity::getStatus, task.getStatus())
            .eq(TaskNoFraudReportingEntity::getTaskId, task.getId()));
      }
      // 如果没有匹配的报告类型，返回false
      return false;
   }

   /**
    * 创建居住证发送短信任务。
    * 该方法首先计算六个月前的日期，然后查询在该日期之后申请的居住证任务实体列表，
    * 并对这些实体发送短信通知。
    *
    * @param param 传递给发送短信任务的参数，具体用途根据实现而定。
    * @return 返回一个布尔值，通常用于指示任务是否创建成功。
    *         根据实际逻辑需要调整返回值，当前示例中返回值始终为false。
    */
   @Override
   public boolean createResidenceSendSms(String param) {
      try {
         // 计算六个月前的日期
         LocalDate sixMonthsAgo = getSixMonthsAgo();
         // 查询需要发送短信的居住证申请实体列表
         List<TaskResidencePermitApplyEntity> entitiesToSms = queryEntitiesToSms(sixMonthsAgo);
         // 发送短信并更新相关实体状态
         sendSmsAndUpdateEntities(entitiesToSms);
      } catch (Exception e) {
         // 处理发送短信过程中可能出现的异常，如记录日志
         logger.error("Error occurred while sending SMS: " + e.getMessage(), e);
         return false; // 根据异常处理逻辑决定是否返回false或其他值
      }
      return false; // 根据实际逻辑调整返回值
   }


   /**
    * 获取六个月前的日期。
    * 该方法不接受任何参数，仅返回当前日期减去六个月的结果。
    *
    * @return 返回一个LocalDate对象，表示六个月前的日期。
    */
   private LocalDate getSixMonthsAgo() {
       // 获取当前日期并减去6个月
       return LocalDate.now().minus(6, ChronoUnit.MONTHS);
   }

   /**
    * 查询需要发送短信的居住证申请实体列表。
    *
    * @param sixMonthsAgo 六个月前的日期，用于筛选确认时间在六个月之前的申请记录。
    * @return 返回一个包含所有符合条件的居住证申请实体的列表。
    */
      private List<TaskResidencePermitApplyEntity> queryEntitiesToSms(LocalDate sixMonthsAgo) {
         // 使用LambdaQueryWrapper构建查询条件，筛选出确认状态为2（即确认），且未发送过短信（发送短信标志为1），确认时间在指定日期（sixMonthsAgo）之前的所有申请记录。
         return residencePermitApplyService.list(new LambdaQueryWrapper<TaskResidencePermitApplyEntity>()
            .eq(TaskResidencePermitApplyEntity::getConfirmFlag, 2)
            .eq(TaskResidencePermitApplyEntity::getSendSmsFlag, 1)
            .le(TaskResidencePermitApplyEntity::getConfirmTime, sixMonthsAgo));
      }

   /**
    * 发送短信并更新实体状态
    *
    * @param entitiesToSms 需要发送短信并更新状态的实体列表，每个实体代表一个居住证申请任务。
    *                       实体列表中每个元素应包含至少一个ID属性，用于标识申请任务。
    */
      private void sendSmsAndUpdateEntities(List<TaskResidencePermitApplyEntity> entitiesToSms) {
         List<TaskResidencePermitApplyEntity> updatedEntities = new ArrayList<>(); // 用于收集成功发送短信并需更新状态的实体列表

         for (TaskResidencePermitApplyEntity entity : entitiesToSms) {
            // 尝试发送短信，发送成功则更新实体状态
            Boolean smsSent = smsSendService.sendNotice(SMS_TEMPLATE_ID, entity.getId());
            if (smsSent) {
               entity.setSendSmsFlag(2); // 标记为已发送短信
               updatedEntities.add(entity); // 加入到需更新的实体列表中
            }
         }

         // 若存在需更新的实体，则批量更新这些实体的状态
         if (!updatedEntities.isEmpty()) {
            residencePermitApplyService.updateBatchById(updatedEntities);
         }
      }
}