异步加载列表根据屏蔽时间和当前时间来更新有效状态

晓庆的故事簿

已于 2024-02-23 10:42:09 修改

阅读量387

点赞数 7

文章标签： mybatis spring boot

于 2024-02-23 10:41:31 首次发布

本文链接：https://blog.csdn.net/qq_40660283/article/details/136249818

版权

异步加载列表更新有效时间的状态

controller

/**
     * 查询数据列表
     */
@RequiresPermissions("policy:blackHouseData:list")
@GetMapping("/pageList")
public TableDataInfo pageList(BlackHouseDataQueryParam blackHouseConfig) {
    CompletableFuture<List<BlackHouseData>> listCompletableFuture = blackHouseDataService.selectAsyncBlackHouseDataListByQueryParam(blackHouseConfig);
    List<BlackHouseData> blackHouseDataList = listCompletableFuture.join();
    return getDataTable(blackHouseDataList);
}

service

/**
     * 查询数据列表
     */
@RequiresPermissions("policy:blackHouseData:list")
@GetMapping("/pageList")
public TableDataInfo pageList(BlackHouseDataQueryParam blackHouseConfig) {
    CompletableFuture<List<BlackHouseData>> listCompletableFuture = blackHouseDataService.selectAsyncBlackHouseDataListByQueryParam(blackHouseConfig);
    List<BlackHouseData> blackHouseDataList = listCompletableFuture.join();
    return getDataTable(blackHouseDataList);
}

serviceImpl

 /**
     * 查询数据列表
     * @param blackHouseConfig 
     * @return 
     */
    @Override
    public CompletableFuture<List<BlackHouseData>> selectAsyncBlackHouseDataListByQueryParam(BlackHouseDataQueryParam blackHouseConfig) {
        // 在主线程中获取分页参数
        PageDomain pageDomain = TableSupport.buildPageRequest();
        Integer pageNum = pageDomain.getPageNum();
        Integer pageSize = pageDomain.getPageSize();
        String orderBy = SqlUtil.escapeOrderBySql(pageDomain.getOrderBy());
        Boolean reasonable = pageDomain.getReasonable();
        return CompletableFuture.supplyAsync(() -> {
            // 在异步线程中设置分页参数
            PageMethod.startPage(pageNum, pageSize, orderBy).setReasonable(reasonable);
            return blackHouseConfigMapper.selectBlackHouseDataListByQueryParam(blackHouseConfig);
        }).thenCompose(blackHouseDataList -> toUpdateStatus(blackHouseDataList)
                .thenApply(v -> {
                    // 在更新状态完成后，再进行一次数据库查询
                    PageMethod.startPage(pageNum, pageSize, orderBy).setReasonable(reasonable);
                    return blackHouseConfigMapper.selectBlackHouseDataListByQueryParam(blackHouseConfig);
                }));
    }
    @Resource
    SqlSessionFactory sqlSessionFactory;

    private CompletableFuture<Void> toUpdateStatus(List<BlackHouseData> blackHouseDataList) {
        return CompletableFuture.runAsync(() -> {
            LocalDateTime nowDate = LocalDateTime.now();
            try (SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH)) {
                BlackHouseDataMapper mapper = session.getMapper(BlackHouseDataMapper.class);
                for (BlackHouseData bData : blackHouseDataList) {
                    Date shieldEndTime = bData.getShieldEndTime();
                    Instant instant = shieldEndTime.toInstant();
                    ZoneId zone = ZoneId.systemDefault();
                    LocalDateTime shieldEndDate = LocalDateTime.ofInstant(instant, zone);
                    // 屏蔽时间过了当前时间,失效
                    if (shieldEndDate.isBefore(nowDate)) {
                        bData.setStatus(GdsYesNoEnum.NO.getCode());
                        mapper.updateBlackHouseData(bData);
                    }
                }
                session.commit();
                session.clearCache();
            } catch (Exception e) {
                e.printStackTrace();
            }
        });
    }

mapper

    /**
     * 根据条件查询
     * @param blackHouseConfig
     * @return
     */
	List<BlackHouseData> selectBlackHouseDataListByQueryParam(BlackHouseDataQueryParam blackHouseConfig);

mapper.xml

<select id="selectBlackHouseDataListByQueryParam" parameterType="BlackHouseDataQueryParam" resultMap="BlackHouseDataResult">
        <include refid="selectBlackHouseDataVo"/>
        <where>
        	<if test="keyId!= null "> and t.key_id= #{keyId}</if>
        	<if test="status != null "> and t.status = #{status}</if>
        </where>
        order by t.key_id desc
    </select>