商品档案全量导出修改

pang.jiabao

2024-04-18 f746571f6d16529b8e2593e1d25681dde592d56c

商品档案全量导出修改

 src/main/java/com/zy/asrs/controller/MatController.java

@@ -12,11 +12,9 @@
import com.core.annotations.ManagerAuth;
import com.core.common.*;
import com.core.exception.CoolException;
import com.zy.asrs.entity.ManPakOut;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.entity.MatPrint;
import com.zy.asrs.entity.OrderDetl;
import com.zy.asrs.entity.*;
import com.zy.asrs.entity.result.KeyValueVo;
import com.zy.asrs.mapper.TagMapper;
import com.zy.asrs.service.ManPakOutService;
import com.zy.asrs.service.MatService;
import com.zy.asrs.service.OrderDetlService;
@@ -33,6 +31,7 @@
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import javax.imageio.ImageIO;
import javax.servlet.http.HttpServletResponse;
import java.awt.image.BufferedImage;
@@ -40,6 +39,7 @@
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.*;
import java.util.stream.Collectors;

@RestController
@Slf4j
@@ -181,6 +181,8 @@
        }
        return R.ok();
    }
    @Resource
    private TagMapper tagMapper;

    @RequestMapping(value = "/mat/export/auth")
    @ManagerAuth
@@ -217,7 +219,11 @@
                    Page page1 = new Page(j + 1 + oneSheetWriteCount * i, writeDataRows);
                    //查询分页列表---按照自己的业务查列表，分页这个一定要使用这个：page1.getPageNum(),page1.getPageSize()！！！
                    List<Mat> list = matService.selectPage(new Page<>(page1.getCurrent(), page1.getLimit())).getRecords();
//                    List<AltitudeMonExportExcelVO > SurfDayList = new ArrayList<>();
                    List<Tag> tags = tagMapper.selectList(null);
                    // 所有类别
                    Map<Long, String> tagMaps = tags.stream().collect(Collectors.toMap(Tag::getId,Tag::getName,(v1,v2) -> v1));
                    // 归类id寻找归类名称
                    list = list.stream().peek(mat -> mat.setUuid(tagMaps.get(mat.getTagId()))).collect(Collectors.toList());
                    //写入到excel:
                    /**************z只需要选择一种方式即可*****************/
                    //这里可以通过设置includeColumnFiledNames、excludeColumnFiledNames导出什么字段，可以动态配置，前端传过来那些列，就导出那些列

 src/main/java/com/zy/asrs/entity/Mat.java

@@ -49,7 +49,8 @@
    /**
     * 编号
     */
    @ExcelIgnore
    // 导出借用该字段存所属归类中文描述
    @ExcelProperty(value = "归类名称")
    @ApiModelProperty(value= "编号")
    private String uuid;