#

DELL

2022-05-06 b43d307ac60607bcc556ca52c54cee0176b66273

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

@@ -12,8 +12,10 @@
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;
@@ -24,6 +26,7 @@
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;

@@ -39,6 +42,8 @@

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

    @RequestMapping(value = "/matCode/{id}/auth")
    @ManagerAuth
@@ -91,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();
    }
@@ -115,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();
@@ -122,11 +132,18 @@

    // 导出
    @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 = VersionUtils.getExcel(matCode);
@@ -137,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())
@@ -147,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 = "/matCode/print/auth")
    @ManagerAuth(memo = "物料编码打印")
    @ManagerAuth(memo = "产品代号打印")
    public R matCodePrint(@RequestParam(value = "param[]") String[] param) {
        if(Cools.isEmpty(param)) {
            return R.parse(CodeRes.EMPTY);
@@ -177,7 +195,7 @@
    }

    @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 {
@@ -225,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);
    }
}