From 7299282e6d9bfb7cf008477c2af888b3930bd716 Mon Sep 17 00:00:00 2001 From: zhangc <zc@123> Date: 星期四, 20 二月 2025 10:46:49 +0800 Subject: [PATCH] 兼容四期 --- src/main/java/com/zy/asrs/controller/OrderController.java | 30 +++++++++++++++++++----------- 1 files changed, 19 insertions(+), 11 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java index 000fe9f..50a5d9c 100644 --- a/src/main/java/com/zy/asrs/controller/OrderController.java +++ b/src/main/java/com/zy/asrs/controller/OrderController.java @@ -1,6 +1,7 @@ package com.zy.asrs.controller; import com.alibaba.fastjson.JSONObject; +import com.baomidou.mybatisplus.enums.SqlLike; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.baomidou.mybatisplus.plugins.Page; @@ -220,16 +221,20 @@ @RequestMapping(value = "/order/detls/pakin/page/auth/v2") @ManagerAuth public R orderDetlsV2(@RequestParam(defaultValue = "1") Integer curr, - @RequestParam(defaultValue = "100") Integer limit, - @RequestParam(required = false) String orderByField, - @RequestParam(required = false) String orderByType, - @RequestParam Map<String, Object> param) { + @RequestParam(defaultValue = "100") Integer limit, + @RequestParam(required = false) String orderByField, + @RequestParam(required = false) String orderByType, + @RequestParam Map<String, Object> param) { EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); excludeTrash(param); Object o = param.get("orderType"); if (o != null) { String[] split = o.toString().split(","); - wrapper.in("source", split); + if (split[0].equals("39")) { + wrapper.in("source", split).andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT); + } else { + wrapper.in("source", split); + } param.remove("orderType"); } convert(param, wrapper); @@ -299,10 +304,11 @@ List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1)); List<Long> docIds = new ArrayList<>(); for (DocType pakin : pakins) { - if (pakin.getDocId() == 36||pakin.getDocId() == 39) { + if (pakin.getDocId() == 36 || pakin.getDocId() == 39) { docIds.add(pakin.getDocId()); } } + wrapper.like("matnr", "50", SqlLike.RIGHT); wrapper.in("source", docIds); return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper)); } @@ -348,6 +354,7 @@ docIds.add(pakin.getDocId()); } } + wrapper.notLike("matnr", "401", SqlLike.RIGHT).notLike("matnr", "402", SqlLike.RIGHT); wrapper.in("source", docIds); Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); for (OrderDetl record : page.getRecords()) { @@ -361,10 +368,10 @@ @RequestMapping(value = "/order/bcpDb/detls/pakin/page/auth/v2") @ManagerAuth public R bcpDbOrderDetlsV2(@RequestParam(defaultValue = "1") Integer curr, - @RequestParam(defaultValue = "100") Integer limit, - @RequestParam(required = false) String orderByField, - @RequestParam(required = false) String orderByType, - @RequestParam Map<String, Object> param) { + @RequestParam(defaultValue = "100") Integer limit, + @RequestParam(required = false) String orderByField, + @RequestParam(required = false) String orderByType, + @RequestParam Map<String, Object> param) { EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); excludeTrash(param); Object o = param.get("orderType"); @@ -382,7 +389,8 @@ // docIds.add(pakin.getDocId()); // } // } - //wrapper.in("source", docIds); + wrapper.like("order_no", "DC", SqlLike.RIGHT); + // wrapper.in("source", docIds); Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfmeDb(record.getMatnr(), record.getThreeCode(), 1); -- Gitblit v1.9.1