From e630f90300fe49872a8935a978f09424ff7441cb Mon Sep 17 00:00:00 2001
From: gt-fuwuqi <3272660260@qq.com>
Date: 星期五, 08 十一月 2024 14:53:36 +0800
Subject: [PATCH] 按堆垛机号查看物料明细
---
src/main/java/com/zy/asrs/controller/LocDetlController.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/LocDetlController.java b/src/main/java/com/zy/asrs/controller/LocDetlController.java
index c180e32..5cb0385 100644
--- a/src/main/java/com/zy/asrs/controller/LocDetlController.java
+++ b/src/main/java/com/zy/asrs/controller/LocDetlController.java
@@ -85,6 +85,30 @@
param.remove("curr");
param.remove("limit");
EntityWrapper<LocDetl> wrapper = new EntityWrapper<>();
+ if (!Cools.isEmpty(param.get("crnNo"))) {
+ switch ((String) param.get("crnNo")) {
+ case "1": wrapper.le("SUBSTRING(loc_no, 1, 2)",4);
+ break;
+ case "2":wrapper.ge("SUBSTRING(loc_no, 1, 2)",5).le("SUBSTRING(loc_no, 1, 2)",8);
+ break;
+ case "3":wrapper.ge("SUBSTRING(loc_no, 1, 2)",9).le("SUBSTRING(loc_no, 1, 2)",12);
+ break;
+ case "4":wrapper.ge("SUBSTRING(loc_no, 1, 2)",13).le("SUBSTRING(loc_no, 1, 2)",16);
+ break;
+ case "5":
+ break;
+ case "6":
+ break;
+ case "7":wrapper.ge("SUBSTRING(loc_no, 1, 2)",17).le("SUBSTRING(loc_no, 1, 2)",37);
+ break;
+ case "8":wrapper.ge("SUBSTRING(loc_no, 1, 2)",38).le("SUBSTRING(loc_no, 1, 2)",45);
+ break;
+ case "9":wrapper.ge("SUBSTRING(loc_no, 1, 2)",46).le("SUBSTRING(loc_no, 1, 2)",53);
+ break;
+ default:
+ }
+ param.remove("crnNo");
+ }
convert(param, wrapper);
// 涓嶅悓缁ф壙瑙掕壊鏄剧ず涓嶅悓搴撲俊鎭�
RoleUtils.addRoleWrapperByLocNo(getUserId(),wrapper);
--
Gitblit v1.9.1