| | |
|---|
| | | package com.ruoyi.inspect.service.impl; |
|---|
| | | |
|---|
| | | import cn.hutool.core.collection.CollUtil; |
|---|
| | | import cn.hutool.core.date.DateTime; |
|---|
| | | import cn.hutool.core.date.DateUtil; |
|---|
| | | import cn.hutool.core.util.ObjectUtil; |
|---|
| | | import cn.hutool.core.util.StrUtil; |
|---|
| | | import cn.hutool.json.JSONUtil; |
|---|
| | |
|---|
| | | import com.alibaba.excel.ExcelWriter; |
|---|
| | | import com.alibaba.excel.write.metadata.WriteSheet; |
|---|
| | | import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; |
|---|
| | | import com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
|---|
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
|---|
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
|---|
| | | import com.ruoyi.basic.mapper.IfsInventoryQuantityMapper; |
|---|
| | | import com.ruoyi.basic.mapper.StandardProductListMapper; |
|---|
| | |
|---|
| | | import com.ruoyi.common.core.domain.entity.User; |
|---|
| | | import com.ruoyi.common.numgen.NumberGenerator; |
|---|
| | | import com.ruoyi.common.utils.*; |
|---|
| | | import com.ruoyi.common.utils.api.IfsApiUtils; |
|---|
| | | import com.ruoyi.framework.exception.ErrorException; |
|---|
| | | import com.ruoyi.inspect.dto.*; |
|---|
| | | import com.ruoyi.inspect.mapper.*; |
|---|
| | | import com.ruoyi.inspect.pojo.*; |
|---|
| | | import com.ruoyi.inspect.service.InsOrderService; |
|---|
| | | import com.ruoyi.inspect.service.InsOrderStateService; |
|---|
| | | import com.ruoyi.inspect.service.InsProductService; |
|---|
| | | import com.ruoyi.inspect.service.InsSampleService; |
|---|
| | | import com.ruoyi.inspect.vo.InsOrderPrintingVo; |
|---|
| | | import com.ruoyi.inspect.vo.SampleDefectsFatherVo; |
|---|
| | | import com.ruoyi.system.mapper.CustomMapper; |
|---|
| | | import com.ruoyi.performance.pojo.AuxiliaryOutputWorkingHoursTemporary; |
|---|
| | | import com.ruoyi.performance.service.AuxiliaryOutputWorkingHoursTemporaryService; |
|---|
| | | import com.ruoyi.system.mapper.UserMapper; |
|---|
| | | import lombok.AllArgsConstructor; |
|---|
| | | import org.apache.commons.lang3.StringUtils; |
|---|
| | |
|---|
| | | import java.io.IOException; |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.net.URLEncoder; |
|---|
| | | import java.text.SimpleDateFormat; |
|---|
| | | import java.time.LocalDate; |
|---|
| | | import java.time.LocalDateTime; |
|---|
| | | import java.time.Month; |
|---|
| | |
|---|
| | | private InsSampleMapper insSampleMapper; |
|---|
| | | private InsProductService insProductService; |
|---|
| | | private InsProductMapper insProductMapper; |
|---|
| | | private InsProductUserMapper insProductUserMapper; |
|---|
| | | private InsSampleUserMapper insSampleUserMapper; |
|---|
| | | private InsOrderStateMapper insOrderStateMapper; |
|---|
| | | private InsOrderStateService insOrderStateService; |
|---|
| | | private UserMapper userMapper; |
|---|
| | | private IfsInventoryQuantityMapper ifsInventoryQuantityMapper; |
|---|
| | | private CustomMapper customMapper; |
|---|
| | | private final NumberGenerator<InsOrder> numberGenerator; |
|---|
| | | private InsReportMapper insReportMapper; |
|---|
| | | private InsUnqualifiedRetestProductMapper insUnqualifiedRetestProductMapper; |
|---|
| | | private IfsApiUtils ifsApiUtils; |
|---|
| | | private SpotCheckQuarterItemMapper spotCheckQuarterItemMapper; |
|---|
| | | private StandardProductListMapper standardProductListMapper; |
|---|
| | | private AuxiliaryOutputWorkingHoursTemporaryService auxiliaryOutputWorkingHoursTemporaryService; |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | isOrderAll = "1"; |
|---|
| | | sampleOrderDto.setState(null); |
|---|
| | | } |
|---|
| | | IPage<SampleOrderDto> sampleOrderDtoIPage = insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll); |
|---|
| | | return insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 分配检验人 |
|---|
| | | * |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | @Transactional(rollbackFor = Exception.class) |
|---|
| | | public int upInsOrder(Integer orderId, Integer sampleId, String appointed, Integer userId, String sonLaboratory) { |
|---|
| | |
|---|
| | | insOrder.setAppointed(StringUtils.isNotEmpty(appointed) ? LocalDate.parse(appointed) : null); |
|---|
| | | insOrder.setSendTime(LocalDateTime.now()); |
|---|
| | | insOrderMapper.updateById(insOrder); |
|---|
| | | List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId)); |
|---|
| | | List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList()); |
|---|
| | | List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId)); |
|---|
| | | List<Integer> ids = insSamples.stream().map(InsSample::getId).collect(Collectors.toList()); |
|---|
| | | List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery() |
|---|
| | | .in(InsProduct::getInsSampleId, ids) |
|---|
| | | .eq(InsProduct::getState, 1) |
|---|
| | | .select(InsProduct::getSonLaboratory).groupBy(InsProduct::getSonLaboratory)); |
|---|
| | | for (InsProduct insProduct : insProducts) { |
|---|
| | | |
|---|
| | | // 批量添加检验任务状态表 |
|---|
| | | List<InsOrderState> insOrderStateList = insProducts.stream().map(insProduct -> { |
|---|
| | | InsOrderState insOrderState = new InsOrderState(); |
|---|
| | | insOrderState.setInsOrderId(orderId); |
|---|
| | | try { |
|---|
| | |
|---|
| | | throw new ErrorException("该检验单有未维护实验室的检验项目"); |
|---|
| | | } |
|---|
| | | insOrderState.setInsState(0); |
|---|
| | | insOrderStateMapper.insert(insOrderState); |
|---|
| | | } |
|---|
| | | return insOrderState; |
|---|
| | | }).collect(Collectors.toList()); |
|---|
| | | insOrderStateService.saveBatch(insOrderStateList); |
|---|
| | | |
|---|
| | | if (userId != null) { |
|---|
| | | InsSampleUser insSampleUser = new InsSampleUser(); |
|---|
| | | insSampleUser.setState(0); |
|---|
| | |
|---|
| | | spotCheckQuarterItem.setSamplingUser(user.getName()); |
|---|
| | | spotCheckQuarterItemMapper.updateById(spotCheckQuarterItem); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | // 创建工时暂存 |
|---|
| | | // 缓存样品id, 编号map |
|---|
| | | Map<Integer, String> sampleMap = insSamples.stream().collect(Collectors.toMap(InsSample::getId, InsSample::getSampleCode)); |
|---|
| | | List<InsProduct> insProductList = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery() |
|---|
| | | .in(InsProduct::getInsSampleId, ids) |
|---|
| | | .eq(InsProduct::getState, 1)); |
|---|
| | | List<AuxiliaryOutputWorkingHoursTemporary> outputWorkingHours = insProductList.stream().map(insProduct -> { |
|---|
| | | AuxiliaryOutputWorkingHoursTemporary auxiliaryOutputWorkingHours = new AuxiliaryOutputWorkingHoursTemporary(); |
|---|
| | | auxiliaryOutputWorkingHours.setInspectionItemClass(insProduct.getInspectionItemClass());//检测项分类 |
|---|
| | | auxiliaryOutputWorkingHours.setInspectionItem(insProduct.getInspectionItem());//检测父项 |
|---|
| | | auxiliaryOutputWorkingHours.setInspectionItemSubclass(insProduct.getInspectionItemSubclass());//检测子项 |
|---|
| | | auxiliaryOutputWorkingHours.setSample(sampleMap.get(insProduct.getInsSampleId()));//样品编号 |
|---|
| | | auxiliaryOutputWorkingHours.setOrderId(order.getId());//订单id |
|---|
| | | auxiliaryOutputWorkingHours.setOrderNo(order.getEntrustCode());//非加班委托单号 |
|---|
| | | auxiliaryOutputWorkingHours.setWorkTime(insProduct.getManHour());//非加班工时 |
|---|
| | | auxiliaryOutputWorkingHours.setAmount(1);//非加班数量 |
|---|
| | | auxiliaryOutputWorkingHours.setOutputWorkTime((ObjectUtils.isNotEmpty(auxiliaryOutputWorkingHours.getOvertimeWorkTime()) ? auxiliaryOutputWorkingHours.getOvertimeWorkTime() : BigDecimal.ZERO).add(ObjectUtils.isNotEmpty(auxiliaryOutputWorkingHours.getWorkTime()) ? auxiliaryOutputWorkingHours.getWorkTime() : BigDecimal.ZERO));//产量工时 |
|---|
| | | auxiliaryOutputWorkingHours.setManHourGroup(insProduct.getManHourGroup());//工时分组 |
|---|
| | | DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
|---|
| | | DateTimeFormatter formatters = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); |
|---|
| | | auxiliaryOutputWorkingHours.setDateTime(LocalDateTime.now().toLocalDate().atStartOfDay().format(formatters));//日期 |
|---|
| | | LocalDateTime localDateTime = LocalDateTime.now(); |
|---|
| | | DateTime parse = DateUtil.parse(localDateTime.format(formatter)); |
|---|
| | | auxiliaryOutputWorkingHours.setWeekDay(getWeek(localDateTime.format(formatters)));//星期 |
|---|
| | | auxiliaryOutputWorkingHours.setWeek(String.valueOf(DateUtil.weekOfYear(DateUtil.offsetDay(parse, 1))));//周次 |
|---|
| | | auxiliaryOutputWorkingHours.setCheck(userId);//检测人 |
|---|
| | | auxiliaryOutputWorkingHours.setPrice(insProduct.getPrice());//单价 |
|---|
| | | auxiliaryOutputWorkingHours.setSampleId(insProduct.getInsSampleId());//样品id |
|---|
| | | auxiliaryOutputWorkingHours.setInsProductId(insProduct.getId());//检验项id |
|---|
| | | |
|---|
| | | return auxiliaryOutputWorkingHours; |
|---|
| | | }).collect(Collectors.toList()); |
|---|
| | | auxiliaryOutputWorkingHoursTemporaryService.saveBatch(outputWorkingHours); |
|---|
| | | |
|---|
| | | return 1; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public static String getWeek(String dayStr) { |
|---|
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
|---|
| | | try { |
|---|
| | | Date date = sdf.parse(dayStr); |
|---|
| | | Calendar calendar = Calendar.getInstance(); |
|---|
| | | calendar.setTime(date); |
|---|
| | | int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK); |
|---|
| | | int day = calendar.get(Calendar.DAY_OF_MONTH); |
|---|
| | | return getWeekDay(dayOfWeek); |
|---|
| | | } catch (Exception e) { |
|---|
| | | e.printStackTrace(); |
|---|
| | | } |
|---|
| | | return null; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public static String getWeekDay(int dayOfWeek) { |
|---|
| | | switch (dayOfWeek) { |
|---|
| | | case Calendar.MONDAY: |
|---|
| | | return "周一"; |
|---|
| | | case Calendar.TUESDAY: |
|---|
| | | return "周二"; |
|---|
| | | case Calendar.WEDNESDAY: |
|---|
| | | return "周三"; |
|---|
| | | case Calendar.THURSDAY: |
|---|
| | | return "周四"; |
|---|
| | | case Calendar.FRIDAY: |
|---|
| | | return "周五"; |
|---|
| | | case Calendar.SATURDAY: |
|---|
| | | return "周六"; |
|---|
| | | case Calendar.SUNDAY: |
|---|
| | | return "周日"; |
|---|
| | | default: |
|---|
| | | return "未知"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | @Transactional(rollbackFor = Exception.class) |
|---|
| | | public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing) { |
|---|
| | | public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder) { |
|---|
| | | // todo: 下单判断抽样计划的唯一性 |
|---|
| | | if (insOrder.getQuarterItemId() != null) { |
|---|
| | | Long quarterItemCount = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
|---|
| | |
|---|
| | | throw new ErrorException("该抽样计划已被绑定过"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | insOrder.setState(0); |
|---|
| | | |
|---|
| | | LocalDate appointed = insOrder.getAppointed(); |
|---|
| | |
|---|
| | | .set(IfsInventoryQuantity::getInspectStatus, 0)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 审核检验单 |
|---|
| | | upInsOrderOfState(insOrder); |
|---|
| | | upInsOrder(insOrder.getId(), null, appointed != null ? appointed.toString() : null, SecurityUtils.getUserId().intValue(), "原材料"); |
|---|
| | | |
|---|
| | | // 分配检验人 |
|---|
| | | upInsOrder(insOrder.getId(), null, appointed != null ? appointed.toString() : null, SecurityUtils.getUserId().intValue(), "原材料"); |
|---|
| | | |
|---|
| | | // 根据零件号判断是否是辅材 |
|---|
| | | boolean isRaw = false; |
|---|
| | |
|---|
| | | if (StringUtils.isBlank(product.getAsk()) || StringUtils.isBlank(product.getTell())) { |
|---|
| | | throw new ErrorException("有检验项的要求值或要求描述为空, 请先去标准库配置要求值或要求描述"); |
|---|
| | | } |
|---|
| | | if (StringUtils.isBlank(product.getSonLaboratory())) { |
|---|
| | | throw new ErrorException("有检验项的的子实验室为绑定, 请先绑定子实验室"); |
|---|
| | | } |
|---|
| | | insProductMapper.insert(product); |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 审核检验单 |
|---|
| | | * @param insOrder |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public int upInsOrderOfState(InsOrder insOrder) { |
|---|
| | | insOrder.setExamineTime(LocalDateTime.now()); |
|---|
| | |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | InsOrder insOrder = insOrderMapper.selectById(id); |
|---|
| | | List<SampleProductDto> list = insSampleMapper.getInsOrderAndSample(id, laboratory); |
|---|
| | | for (SampleProductDto sampleProductDto : list) { |
|---|
| | | List<Integer> ids = sampleProductDto.getInsProduct().stream().map(InsProduct::getId).collect(Collectors.toList()); |
|---|
| | | List<InsProductUser> insProductUsers = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery() |
|---|
| | | .in(InsProductUser::getInsProductId, ids)); |
|---|
| | | if (CollectionUtils.isNotEmpty(insProductUsers)) { |
|---|
| | | List<Integer> userIds = insProductUsers.stream().map(InsProductUser::getCreateUser).distinct().collect(Collectors.toList()); |
|---|
| | | String collect = userMapper.selectBatchIds(userIds).stream().map(User::getName).collect(Collectors.joining(",")); |
|---|
| | | sampleProductDto.setCheckName(collect); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | map.put("insOrder", insOrder); |
|---|
| | | map.put("sampleProduct", list); |
|---|
| | | //查询所有记录模版去重 |
|---|
| | |
|---|
| | | return productDto2IPage; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public IPage<CostStatisticsDto> costStatistics(IPage<CostStatisticsDto> page, CostStatisticsDto costStatisticsDto) { |
|---|
| | | String dates = costStatisticsDto.getDates(); |
|---|
| | | String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(","); |
|---|
| | | costStatisticsDto.setDates(null); |
|---|
| | | |
|---|
| | | //todo:仅看自己 |
|---|
| | | |
|---|
| | | IPage<CostStatisticsDto> dtoIPage = insOrderMapper.selectCostStatistics(page, QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59")); |
|---|
| | | List<CostStatisticsDto> collect = dtoIPage.getRecords().stream().map(dto -> { |
|---|
| | | Set<String> uniqueTags = new HashSet<>(); |
|---|
| | | if (dto.getInspectionItem().contains(",")) { |
|---|
| | | for (String s : dto.getInspectionItem().split(",")) { |
|---|
| | | uniqueTags.add(s.split("@")[0]); |
|---|
| | | } |
|---|
| | | } else { |
|---|
| | | uniqueTags.add(dto.getInspectionItem().split("@")[0]); |
|---|
| | | } |
|---|
| | | dto.setInspectionItem(uniqueTags.toString()); |
|---|
| | | return dto; |
|---|
| | | }).collect(Collectors.toList()); |
|---|
| | | dtoIPage.setRecords(collect); |
|---|
| | | return dtoIPage; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public Map<String, Object> costStatistics2(CostStatisticsDto costStatisticsDto) { |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | String dates = costStatisticsDto.getDates(); |
|---|
| | | String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(","); |
|---|
| | | costStatisticsDto.setDates(null); |
|---|
| | | List<CostStatisticsDto> costStatisticsDtos = insOrderMapper.selectCostStatistics2(QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59")); |
|---|
| | | double totalPrice = costStatisticsDtos.stream() |
|---|
| | | .filter(dto -> dto.getPrice() != null) // 过滤掉价格为 null 的对象 |
|---|
| | | .mapToDouble(value -> value.getPrice().doubleValue() * value.getNum()) |
|---|
| | | .sum(); |
|---|
| | | map.put("total", totalPrice); |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public Map<String, Object> selectSampleDefects(Page page, String inspectionItems, String orderNumber) { |
|---|
| | | List<SampleDefectsFatherVo> sampleDefectsFatherVos = insOrderMapper.selectSampleDefects(page, inspectionItems, orderNumber); |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | map.put("records", sampleDefectsFatherVos); |
|---|
| | | Long aLong = insOrderMapper.getCount(inspectionItems, orderNumber); |
|---|
| | | map.put("total", aLong); |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public int updateStatus(Integer id) { |
|---|
| | | return insOrderMapper.updateStatus(id); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public void export(CostStatisticsDto costStatisticsDto, HttpServletResponse response) throws IOException { |
|---|
| | | //查询导出的费用统计数据 |
|---|
| | | String dates = costStatisticsDto.getDates(); |
|---|
| | | String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(","); |
|---|
| | | costStatisticsDto.setDates(null); |
|---|
| | | List<CostStatisticsDto> costStatisticsDtos = insOrderMapper.selectCostStatistics2(QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59")); |
|---|
| | | costStatisticsDtos = costStatisticsDtos.stream().map(dto -> { |
|---|
| | | Set<String> uniqueTags = new HashSet<>(); |
|---|
| | | if (dto.getInspectionItem().contains(",")) { |
|---|
| | | for (String s : dto.getInspectionItem().split(",")) { |
|---|
| | | uniqueTags.add(s.split("@")[0]); |
|---|
| | | } |
|---|
| | | } else { |
|---|
| | | uniqueTags.add(dto.getInspectionItem().split("@")[0]); |
|---|
| | | } |
|---|
| | | dto.setInspectionItem(uniqueTags.toString()); |
|---|
| | | return dto; |
|---|
| | | }).collect(Collectors.toList()); |
|---|
| | | |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setCharacterEncoding("UTF-8"); |
|---|
| | | // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系 |
|---|
| | | String fileName = URLEncoder.encode("样品费用统计导出", "UTF-8"); |
|---|
| | | response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); |
|---|
| | | Map<String, List<CostStatisticsDto>> groupByCompany = |
|---|
| | | costStatisticsDtos.stream().filter(e -> StrUtil.isNotEmpty(e.getCompany())) |
|---|
| | | .collect(Collectors.groupingBy(CostStatisticsDto::getCompany)); |
|---|
| | | try { |
|---|
| | | // 新建ExcelWriter |
|---|
| | | // 新建ExcelWriter |
|---|
| | | ExcelWriter excelWriter = |
|---|
| | | EasyExcel.write(response.getOutputStream()) |
|---|
| | | .registerWriteHandler(new SimpleColumnWidthStyleStrategy(25)) |
|---|
| | | .build(); |
|---|
| | | for (Map.Entry<String, List<CostStatisticsDto>> companyDataEntry : groupByCompany.entrySet()) { |
|---|
| | | String sheetName = companyDataEntry.getKey(); |
|---|
| | | List<CostStatisticsDto> dataList = companyDataEntry.getValue(); |
|---|
| | | WriteSheet mainSheet = EasyExcel.writerSheet(sheetName) |
|---|
| | | .head(CostStatisticsDto.class) |
|---|
| | | .registerWriteHandler(new SimpleColumnWidthStyleStrategy(25)) |
|---|
| | | .build(); |
|---|
| | | excelWriter.write(dataList, mainSheet); |
|---|
| | | } |
|---|
| | | // 关闭流 |
|---|
| | | excelWriter.finish(); |
|---|
| | | } catch (IOException e) { |
|---|
| | | throw new RuntimeException("导出失败"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 获取ifs库存信息 |
|---|
