From 7e10622ead5bd8b3ce0c9fda39d22ae0e938e030 Mon Sep 17 00:00:00 2001
From: zwl <1051256694@qq.com>
Date: 星期五, 12 九月 2025 13:44:10 +0800
Subject: [PATCH] 完善订单组托可用数据显示功能
---
zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/AdjDetlController.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/AdjDetlController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/AdjDetlController.java
index 82aa100..d101eca 100644
--- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/AdjDetlController.java
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/AdjDetlController.java
@@ -2,7 +2,10 @@
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.core.conditions.AbstractWrapper;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zy.asrs.common.wms.entity.AdjDetl;
import com.zy.asrs.common.wms.service.AdjDetlService;
@@ -45,6 +48,13 @@
wrapper.ge(AdjDetl::getAppeTime, DateUtils.convert(range[0]));
wrapper.le(AdjDetl::getAppeTime, DateUtils.convert(range[1]));
}
+ if (!Cools.isEmpty(param.get("loc_no"))) {
+ wrapper.like(AdjDetl::getLocNo, param.get("loc_no"));
+ }
+ if (!Cools.isEmpty(param.get("matnr"))) {
+ wrapper.like(AdjDetl::getMatnr, param.get("matnr"));
+ }
+ wrapper.orderByDesc(AdjDetl::getModiTime);
return R.ok(adjDetlService.page(new Page<>(curr, limit), wrapper));
}
@@ -103,4 +113,25 @@
return R.ok().add(vos);
}
+ @RequestMapping(value = "/adjDetl/export/auth")
+ @ManagerAuth
+ public R export(@RequestBody JSONObject param){
+ List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
+ LambdaQueryWrapper<AdjDetl> wrapper = new LambdaQueryWrapper<>();
+ Map<String, Object> map = excludeTrash(param.getJSONObject("adjDetl"));
+ if (!Cools.isEmpty(map.get("loc_no"))) {
+ wrapper.like(AdjDetl::getLocNo, map.get("loc_no"));
+ }
+ if (!Cools.isEmpty(map.get("matnr"))) {
+ wrapper.like(AdjDetl::getMatnr, map.get("matnr"));
+ }
+ if (!Cools.isEmpty(map.get("modi_time"))) {
+ String[] range = map.get("modi_time").toString().split(RANGE_TIME_LINK);
+ wrapper.ge(AdjDetl::getAppeTime, DateUtils.convert(range[0]));
+ wrapper.le(AdjDetl::getAppeTime, DateUtils.convert(range[1]));
+ }
+ List<AdjDetl> list = adjDetlService.list(wrapper);
+ return R.ok(exportSupport(list, fields));
+ }
+
}
--
Gitblit v1.9.1