From 6353a0d97a272b683663ecb4d46ecdff250ba525 Mon Sep 17 00:00:00 2001
From: 18516761980 <56479841@qq.com>
Date: 星期三, 20 七月 2022 16:57:52 +0800
Subject: [PATCH] #
---
src/main/java/com/slcf/dao/WorkFileDao.java | 7 +++
src/main/java/com/slcf/service/WorkFileService.java | 2 +
src/main/java/com/slcf/service/impl/WorkFileServiceImpl.java | 13 ++++++
src/main/java/com/slcf/controller/AsrsController.java | 75 ++++++++++++++++++++++++++++++++++---
4 files changed, 91 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/slcf/controller/AsrsController.java b/src/main/java/com/slcf/controller/AsrsController.java
index 1878239..c983a97 100644
--- a/src/main/java/com/slcf/controller/AsrsController.java
+++ b/src/main/java/com/slcf/controller/AsrsController.java
@@ -17,6 +17,7 @@
import javax.servlet.http.HttpServletRequest;
import com.slcf.pojo.*;
+import com.slcf.service.*;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
@@ -27,11 +28,6 @@
import org.springframework.web.bind.annotation.ResponseBody;
import com.slcf.erp.ErpBean;
-import com.slcf.service.LocDetailService;
-import com.slcf.service.LocationService;
-import com.slcf.service.WaitCheckService;
-import com.slcf.service.WaitPakInService;
-import com.slcf.service.WaitPakOutService;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
@@ -51,6 +47,10 @@
LocationService locationService;
@Autowired
LocDetailService locDetailService;
+ @Autowired
+ MatCodeService matCodeService;
+ @Autowired
+ WorkFileService workFileService;
Logger logger=Logger.getLogger(AsrsController.class);
@@ -791,7 +791,70 @@
}
return map;
}
-
+
+ /**
+ * 搴撲綅淇℃伅杩斿洖鎺ュ彛
+ * @param requestBody
+ * @param request
+ * @return
+ */
+ @ResponseBody
+ @RequestMapping(value="/queryWrkDetl.action",method={ RequestMethod.GET, RequestMethod.POST })
+ public JSONObject queryWrkDetl(@RequestBody String requestBody,HttpServletRequest request){
+
+ JSONObject map = new JSONObject();
+ logger.info("宸ヤ綔鏄庣粏杩斿洖鎺ュ彛璋冪敤锛�" + requestBody);
+ try {
+ JSONArray result = new JSONArray();
+ JSONObject json = JSONObject.fromObject(requestBody);
+ String zpallet = json.get("zpallet").toString();
+
+ List<WorkDetailBean> detls = workFileService.getWorkDetlList(zpallet);
+ for (WorkDetailBean detl : detls) {
+ WaitPakOutBean wrapper = new WaitPakOutBean();
+ wrapper.setLgnum(detl.getLgnum());
+ wrapper.setTanum(detl.getTbnum());
+ wrapper.setTapos(detl.getTbpos());
+ WaitPakOutBean waitPakout = waitPakOutService.queryWaitPakOutByNum(wrapper);
+
+ JSONObject detlJSON = new JSONObject();
+ detlJSON.put("LGNUM", detl.getLgnum());
+ detlJSON.put("TANUM", detl.getTbnum());
+ detlJSON.put("BDATU", detl.getModi_time());
+ detlJSON.put("BZEIT", detl.getModi_time());
+ detlJSON.put("TRART", "");
+ detlJSON.put("TAPOS", detl.getTbpos());
+ detlJSON.put("MATNR", detl.getMatnr());
+ detlJSON.put("MAKTX", detl.getMaktx());
+ detlJSON.put("WERKS", detl.getWerks());
+ detlJSON.put("LGORT", "");
+ detlJSON.put("MEINS", detl.getAltme());
+ detlJSON.put("VLTYP", waitPakout == null ? "" : waitPakout.getVltyp().toString());
+ detlJSON.put("NLTYP", waitPakout == null ? "" : waitPakout.getNltyp());
+ detlJSON.put("NLBER", "");
+ detlJSON.put("NLPLA", waitPakout == null ? "" : waitPakout.getNlpla());
+ detlJSON.put("VSOLM", detl.getAnfme());
+ detlJSON.put("BNAME", detl.getBname().toString());
+ result.add(detlJSON);
+ }
+ if (result.size() == 0){
+ map.put("item", result);
+ map.put("zstatus", "E");
+ map.put("message", "鏌ヨ涓嶅埌璇ユ墭鐩樼爜鐨勫伐浣滄槑缁�");
+ }else {
+ map.put("item", result);
+ map.put("zstatus", "S");
+ map.put("message", "杩斿洖鏄庣粏淇℃伅鎴愬姛");
+ }
+
+ }catch (Exception e){
+ map.put("item", "");
+ map.put("zstatus", "E");
+ map.put("message", "杩斿洖鏄庣粏淇℃伅澶辫触" + e.getMessage());
+ }
+ return map;
+ }
+
/**
* 鍏ュ簱瀹屾垚锛岃皟鐢╯ap鎺ュ彛涓婁紶瀹屾垚淇℃伅
*/
diff --git a/src/main/java/com/slcf/dao/WorkFileDao.java b/src/main/java/com/slcf/dao/WorkFileDao.java
index 1d030d6..f4a6f9f 100644
--- a/src/main/java/com/slcf/dao/WorkFileDao.java
+++ b/src/main/java/com/slcf/dao/WorkFileDao.java
@@ -148,4 +148,11 @@
@Update("update asr_wrk_detl set nista=#{nista} "
+ " where wrk_no=#{wrk_no} and lgnum=#{lgnum} and tbnum=#{tbnum} and tbpos=#{tbpos} and matnr=#{matnr}")
public int upWorkDetl(WorkDetailBean workDetl);
+
+ /**
+ * 鏍规嵁鎵樼洏鐮佹煡璇㈠伐浣滄槑缁哃ist
+ * @return
+ */
+ @Select("select * from asr_wrk_detl where zpallet=#{} order by wrk_no asc")
+ public List<WorkDetailBean> getWorkDetlList(String zpallet);
}
diff --git a/src/main/java/com/slcf/service/WorkFileService.java b/src/main/java/com/slcf/service/WorkFileService.java
index cc3f5d6..7a00ce2 100644
--- a/src/main/java/com/slcf/service/WorkFileService.java
+++ b/src/main/java/com/slcf/service/WorkFileService.java
@@ -72,4 +72,6 @@
* @return
*/
public int upWorkDetl(WorkDetailBean workDetl);
+
+ public List<WorkDetailBean> getWorkDetlList(String zpallet);
}
diff --git a/src/main/java/com/slcf/service/impl/WorkFileServiceImpl.java b/src/main/java/com/slcf/service/impl/WorkFileServiceImpl.java
index 4476bd3..a7237e3 100644
--- a/src/main/java/com/slcf/service/impl/WorkFileServiceImpl.java
+++ b/src/main/java/com/slcf/service/impl/WorkFileServiceImpl.java
@@ -347,4 +347,17 @@
}
return result;
}
+
+ /**
+ * 鏍规嵁鎵樼洏鐮佹煡璇㈠伐浣滄槑缁哃ist
+ * @return
+ */
+ public List<WorkDetailBean> getWorkDetlList(String zpallet) {
+ try {
+ return workFileDao.getWorkDetlList(zpallet);
+ }catch(Exception e) {
+ System.out.println(e.getMessage());
+ return null;
+ }
+ }
}
--
Gitblit v1.9.1