# 出库作业，和库存明细管理 排序

whycq

2023-07-24 b7e08df5a07b3fa832a46ecc31983e16f2bccc8c

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

@@ -12,16 +12,21 @@
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.MatCode;
import com.zy.asrs.entity.MatCodePrint;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.MatCodeService;
import com.zy.asrs.utils.VersionUtils;
import com.zy.common.CodeRes;
import com.zy.common.config.AdminInterceptor;
import com.zy.common.utils.BarcodeUtils;
import com.zy.common.utils.QrCode;
import com.zy.common.utils.excel.matcode.MatCodeExcel;
import com.zy.common.utils.excel.matcode.MatCodeExcelListener;
import com.zy.common.web.BaseController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

@@ -37,6 +42,8 @@

    @Autowired
    private MatCodeService matCodeService;
    @Autowired
    private LocDetlService locDetlService;

    @RequestMapping(value = "/matCode/{id}/auth")
    @ManagerAuth
@@ -89,6 +96,7 @@
        matCode.setModiTime(new Date());
        matCode.setAppeUser(getUserId());
        matCode.setAppeTime(new Date());
       // matCode.setMatNo(UUID.randomUUID().toString().replaceAll("-", ""));
        matCodeService.insert(matCode);
        return R.ok();
    }
@@ -113,6 +121,10 @@
            return R.error();
        }
        for (MatCode entity : list){
            Integer count = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("mat_no",entity.getMatNo()));
            if(count>0){
                return R.error("产品编码" + entity.getMatNo() + "在库存中已存在，禁止删除");
            }
            matCodeService.delete(new EntityWrapper<>(entity));
        }
        return R.ok();
@@ -120,18 +132,21 @@

    // 导出
    @RequestMapping(value = "/matCode/export/auth")
    @ManagerAuth(value = ManagerAuth.Auth.NONE, memo = "物料编码数据导出")
    @ManagerAuth(value = ManagerAuth.Auth.NONE, memo = "产品代号数据导出")
    public void export(@RequestParam(required = false) String fileName,
                       @RequestParam(required = false) Integer rowCount,
                       @RequestParam(required = false) String ids,
                       HttpServletResponse response) throws Exception {
        List<MatCode> list = matCodeService.selectList(new EntityWrapper<>());
        List<MatCode> list = null;
        if(!Cools.isEmpty(ids)){
            list = matCodeService.selectList(new EntityWrapper<MatCode>().last("where mat_no in (" + ids + ")"));
        }else{
            list = matCodeService.selectList(new EntityWrapper<>());
        }
//        List<MatCode> list = matCodeService.selectList(new EntityWrapper<>());
        List<MatCodeExcel> excels = new ArrayList<>();
        for (MatCode matCode : list) {
            MatCodeExcel excel = new MatCodeExcel();
            excel.setMatNo(matCode.getMatNo());
            excel.setBarcode(matCode.getBarcode());
            excel.setMatName(matCode.getMatName());
            excel.setStr1(matCode.getStr1());
            MatCodeExcel excel = VersionUtils.getExcel(matCode);
            excels.add(excel);
            if (rowCount != null && excels.size() >= rowCount){
                break;
@@ -139,7 +154,7 @@
        }
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        fileName = URLEncoder.encode(Cools.isEmpty(fileName)?"物料编码":fileName, "UTF-8");
        fileName = URLEncoder.encode(Cools.isEmpty(fileName)?"产品代号":fileName, "UTF-8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), MatCodeExcel.class)
                .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
@@ -149,16 +164,17 @@

    // 导入
    @RequestMapping(value = "/matCode/import/auth")
    @ManagerAuth(memo = "物料编码数据导入")
    @ManagerAuth(memo = "产品代号数据导入")
    @Transactional
    public R matCodeImport(MultipartFile file) throws IOException, InterruptedException {
        MatCodeExcelListener listener = new MatCodeExcelListener(getUserId());
        EasyExcel.read(file.getInputStream(), MatCodeExcel.class, listener).sheet().doRead();
        return R.ok("成功导入"+listener.getTotal()+"条物料信息");
        return R.ok("成功导入"+listener.getTotal()+"条产品信息");
    }

    // 打印
    @RequestMapping(value = "/macCode/print/auth")
    @ManagerAuth(memo = "物料编码打印")
    @RequestMapping(value = "/matCode/print/auth")
    @ManagerAuth(memo = "产品代号打印")
    public R matCodePrint(@RequestParam(value = "param[]") String[] param) {
        if(Cools.isEmpty(param)) {
            return R.parse(CodeRes.EMPTY);
@@ -179,10 +195,11 @@
    }

    @RequestMapping(value = "/macCode/code/auth")
//    @ManagerAuth(memo = "物料编码条形码获取(type:1(条形码);2(二维码)")
//    @ManagerAuth(memo = "产品代号条形码获取(type:1(条形码);2(二维码)")
    public R matCodeBarcode(@RequestParam(defaultValue = "1") Integer type
                        , @RequestParam String param
                        , HttpServletResponse response) throws Exception {
        AdminInterceptor.cors(response);
        if (Cools.isEmpty(param)){
            return R.parse(BaseRes.EMPTY);
        }
@@ -226,4 +243,24 @@
        return R.ok();
    }

    @RequestMapping("/matType/auth")
    public R type(){
        List<Map<String, Object>> result = new ArrayList<>();
        for (int i = 1; i < 4; i++) {
            Map<String, Object> item = new HashMap<>();
            item.put("id",i+"");
            if (i == 1){
                item.put("value","原材料");
            }
            if (i == 2){
                item.put("value","成品");
            }
            if (i == 3){
                item.put("value","半成品");
            }
            result.add(item);
        }

        return R.ok(result);
    }
}