#pda料箱组托和换码

lty

3 天以前 8e943b7104561c3b14cf223016698709c5ade4b5

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

@@ -42,7 +42,7 @@
    @RequestMapping(value = "/locDetl/update")
    public R update1() {
        if (!locDetlService.updateLocNo("0402805", "0402804")) {
            return R.error();
            return R.error("response.operation_failed");
        }
        return R.ok();
    }
@@ -64,7 +64,9 @@
                    res.addAll(locDetls);
                }
            }
            return R.ok().add(res);
            R r = R.ok();
            r.put("data",res);
            return r;
        }
        return R.parse(BaseRes.EMPTY);
    }
@@ -83,7 +85,11 @@
                param.remove("modi_time");
            }
        }
        return R.ok(locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class)));
        Page<LocDetl> stockOut = locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class));
        if (stockOut.getRecords().size()==0){
            stockOut = locDetlService.getStockOut(toPage(1, limit, param, LocDetl.class));
        }
        return R.ok(stockOut);
    }

    @RequestMapping(value = "/locDetl/list/auth")// /locDetl/list/auth 接口问题
@@ -136,43 +142,43 @@
    }

    @RequestMapping(value = "/locDetl/add/auth")
    @ManagerAuth(memo = "库位明细添加")
    @ManagerAuth(memo = "response.loc_detl_add")
    public R add(LocDetl locDetl) {
        locDetl.setModiUser(getUserId());
        locDetl.setModiTime(new Date());
        locDetl.setAppeUser(getUserId());
        locDetl.setAppeTime(new Date());
        locDetlService.insert(locDetl);
        return R.ok();
        return R.ok("response.save_success");
    }

   @RequestMapping(value = "/locDetl/update/auth")
   @ManagerAuth(memo = "库位明细修改")
    @ManagerAuth(memo = "response.loc_detl_update")
    public R update(LocDetl locDetl){
        if (Cools.isEmpty(locDetl) || null==locDetl.getMatnr()){
            return R.error();
            return R.error("response.param_error");
        }
        locDetl.setModiUser(getUserId());
        locDetl.setModiTime(new Date());
        locDetlService.updateById(locDetl);
        return R.ok();
        return R.ok("response.update_success");
    }

    @RequestMapping(value = "/locDetl/delete/auth")
    @ManagerAuth(memo = "库位明细删除")
    @ManagerAuth(memo = "response.loc_detl_delete")
    public R delete(@RequestParam String param){
        List<LocDetl> list = JSONArray.parseArray(param, LocDetl.class);
        if (Cools.isEmpty(list)){
            return R.error();
            return R.error("response.parameter_error");
        }
        for (LocDetl entity : list){
            locDetlService.delete(new EntityWrapper<>(entity));
        }
        return R.ok();
        return R.ok("response.delete_success");
    }

    @RequestMapping(value = "/locDetl/export/auth")
    @ManagerAuth(memo = "库位明细导出")
    @ManagerAuth(memo = "response.loc_detl_export")
    public R export(@RequestBody JSONObject param){
        List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
        EntityWrapper<LocDetl> wrapper = new EntityWrapper<>();
@@ -218,7 +224,9 @@
    public R query(@RequestBody JSONObject param) {
        Wrapper<LocDetl> wrapper = new EntityWrapper<LocDetl>().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val"));
        if (null != locDetlService.selectOne(wrapper)){
            return R.parse(BaseRes.REPEAT).add(getComment(LocDetl.class, String.valueOf(param.get("key"))));
            R r = R.parse(BaseRes.REPEAT);
            r.put("data", getComment(LocDetl.class, String.valueOf(param.get("key"))));
            return r;
        }
        return R.ok();
    }
@@ -235,7 +243,9 @@
                locDetl.sync(mat);
            }
        }
        return R.ok().add(stockStatis);
        R r = R.ok();
        r.put("data",stockStatis);
        return r;
    }

    @Autowired
@@ -243,7 +253,7 @@

    @RequestMapping(value = "/locDetl/statis/export")
//    @ManagerAuth
    public void statisExport(HttpServletResponse response) throws IOException {
    public void statisExport(HttpServletResponse response, @RequestParam(required = false, defaultValue = "zh-cn") String lang) throws IOException {
        List<LocDetl> excel = LocDetlMapper.getStockStatisExcel();
        for (LocDetl locDetl : excel) {
            Mat mat = matService.selectByMatnr(locDetl.getMatnr());
@@ -253,12 +263,30 @@
        }
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        String fileName = URLEncoder.encode("库存明细统计报表", "UTF-8");
        boolean isEn = "en".equalsIgnoreCase(lang);
        String fileNameStr = isEn ? "Inventory Detail Statistical Report" : "response.inventory_detail_statistical_report";
        String fileName = URLEncoder.encode(fileNameStr, "UTF-8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), LocDetl.class)
                .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
                .sheet("表1")
                .doWrite(excel);
        
        com.alibaba.excel.write.builder.ExcelWriterBuilder writerBuilder = EasyExcel.write(response.getOutputStream(), LocDetl.class);
        writerBuilder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy());

        if (isEn) {
            writerBuilder.head(getEnglishHead());
        }
        
        writerBuilder.sheet("Sheet1").doWrite(excel);
    }

    private List<List<String>> getEnglishHead() {
        List<List<String>> list = new ArrayList<>();
        list.add(Collections.singletonList("Quantity"));
        list.add(Collections.singletonList("Item No."));
        list.add(Collections.singletonList("Item Name"));
        list.add(Collections.singletonList("Spec"));
        list.add(Collections.singletonList("Batch No."));
        list.add(Collections.singletonList("Order No."));
        return list;
    }

    /**