package com.panzhihua.common.listen; import java.util.ArrayList; import java.util.List; import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import com.alibaba.fastjson.JSONObject; import com.panzhihua.common.exceptions.ServiceException; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.ComSwRotaExcelVO; import com.panzhihua.common.service.community.CommunityService; import lombok.extern.slf4j.Slf4j; /** * @description: 值班表监听 * @author: Null * @date: 2021/7/31 13:26 */ @Slf4j public class ComSwRotaExcelListen extends AnalysisEventListener { private static final int BATCH_COUNT = 100; private CommunityService communityService; private Long communityId; private List list = new ArrayList<>(); public ComSwRotaExcelListen(CommunityService communityService, Long communityId) { this.communityService = communityService; this.communityId = communityId; } @Override public void invoke(ComSwRotaExcelVO comSwRotaExcelVO, AnalysisContext analysisContext) { list.add(comSwRotaExcelVO); if (list.size() == 0) { throw new ServiceException("500", "导入数据为空!"); } // 达到BATCH_COUNT了,需要去存储一次数据库,防止数据几万条数据在内存,容易OOM if (list.size() >= BATCH_COUNT) { log.info("excel导入数据【{}】", JSONObject.toJSONString(list)); R r = this.communityService.listSaveSwRotaExcelVO(list, this.communityId); if (!R.isOk(r)) { throw new ServiceException(r.getMsg()); } list.clear(); // 清空list } } @Override public void doAfterAllAnalysed(AnalysisContext analysisContext) { log.info("excel导入数据【{}】", JSONObject.toJSONString(list)); if (list.size() == 0) { throw new ServiceException("500", "导入数据为空!"); } R r = this.communityService.listSaveSwRotaExcelVO(list, this.communityId);// 确保最后遗留的数据保存在数据库中 if (!R.isOk(r)) { throw new ServiceException(r.getMsg()); } } }