| | |
|---|
| | | import com.ruoyi.inspect.service.InsOrderService; |
|---|
| | | import com.ruoyi.inspect.service.InsReportService; |
|---|
| | | import com.ruoyi.inspect.service.RawMaterialOrderService; |
|---|
| | | import com.ruoyi.inspect.vo.ProductVo; |
|---|
| | | import com.ruoyi.performance.mapper.AuxiliaryOutputWorkingHoursMapper; |
|---|
| | | import com.ruoyi.performance.pojo.AuxiliaryOutputWorkingHours; |
|---|
| | | import com.ruoyi.system.mapper.UserMapper; |
|---|
| | |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //查询检验项记录 |
|---|
| | | List<Long> ifsIds = ifsByOverList.stream().map(IfsInventoryQuantitySupplierDto::getId).collect(Collectors.toList()); |
|---|
| | | List<ProductVo> inspectList = insProductMapper.selectInspectListByIfsIfs(ifsIds); |
|---|
| | | |
|---|
| | | |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | |
|---|
| | | //新建ExcelWriter |
|---|
| | | ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build(); |
|---|
| | | //获取sheet0对象 |
|---|
| | | WriteSheet mainSheet = EasyExcel.writerSheet(0, "原材料检测信息导出").head(IfsInventoryQuantitySupplierDto.class).build(); |
|---|
| | | WriteSheet mainSheet = EasyExcel.writerSheet(0, "原材料检测信息总览").head(IfsInventoryQuantitySupplierDto.class).build(); |
|---|
| | | WriteSheet inspectSheet = EasyExcel.writerSheet(1, "原材料检测数据详情").head(ProductVo.class).build(); |
|---|
| | | |
|---|
| | | //向sheet0写入数据 传入空list这样只导出表头 |
|---|
| | | excelWriter.write(ifsByOverList, mainSheet); |
|---|
| | | excelWriter.write(inspectList, inspectSheet); |
|---|
| | | //关闭流 |
|---|
| | | excelWriter.finish(); |
|---|
| | | } catch (IOException e) { |
|---|
