| | |
| | | @RequestParam(defaultValue = "10")Integer limit, |
| | | @RequestParam(required = false)String orderByField, |
| | | @RequestParam(required = false)String orderByType, |
| | | @RequestParam(required = false)String condition, |
| | | @RequestParam Map<String, Object> param){ |
| | | excludeTrash(param); |
| | | EntityWrapper<MatCode> wrapper = new EntityWrapper<>(); |
| | | convert(param, wrapper); |
| | | allLike(MatCode.class, param.keySet(), wrapper, condition); |
| | | if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} |
| | | else { |
| | | wrapper.orderBy("modi_time", false); |
| | | } |
| | | return R.ok(matCodeService.selectPage(new Page<>(curr, limit), wrapper)); |
| | | } |
| | | |
| | |
| | | excel.setBarcode(matCode.getBarcode()); |
| | | excel.setMatName(matCode.getMatName()); |
| | | excel.setStr1(matCode.getStr1()); |
| | | excel.setStr2(matCode.getStr2()); |
| | | excels.add(excel); |
| | | if (rowCount != null && excels.size() >= rowCount){ |
| | | break; |
| | |
| | | @RequestMapping(value = "/matCode/import/auth") |
| | | @ManagerAuth(memo = "物料编码数据导入") |
| | | public R matCodeImport(MultipartFile file) throws IOException, InterruptedException { |
| | | Thread.sleep(2000); |
| | | EasyExcel.read(file.getInputStream(), MatCodeExcel.class, new MatCodeExcelListener()).sheet().doRead(); |
| | | return R.ok(); |
| | | MatCodeExcelListener listener = new MatCodeExcelListener(getUserId()); |
| | | EasyExcel.read(file.getInputStream(), MatCodeExcel.class, listener).sheet().doRead(); |
| | | return R.ok("成功导入"+listener.getTotal()+"条物料信息"); |
| | | } |
| | | |
| | | // 打印 |