From 8366535c15151e7def2ba8398be4dba3e3121727 Mon Sep 17 00:00:00 2001
From: whycq <10027870+whycq@user.noreply.gitee.com>
Date: 星期一, 08 七月 2024 08:07:00 +0800
Subject: [PATCH] # 换板绑定
---
src/main/java/com/zy/asrs/controller/MobileController.java | 312 +++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 311 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/MobileController.java b/src/main/java/com/zy/asrs/controller/MobileController.java
index 8eadac7..11b25f7 100644
--- a/src/main/java/com/zy/asrs/controller/MobileController.java
+++ b/src/main/java/com/zy/asrs/controller/MobileController.java
@@ -1,14 +1,33 @@
package com.zy.asrs.controller;
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.mapper.EntityWrapper;
+import com.baomidou.mybatisplus.mapper.Wrapper;
import com.core.annotations.ManagerAuth;
+import com.core.common.BaseRes;
+import com.core.common.Cools;
import com.core.common.R;
+import com.core.exception.CoolException;
+import com.zy.asrs.entity.*;
import com.zy.asrs.entity.param.CombParam;
-import com.zy.asrs.service.MobileService;
+import com.zy.asrs.service.*;
+import com.zy.common.model.MobileLocDetlVo;
import com.zy.common.web.BaseController;
+import com.zy.ints.entity.WaitMatchk;
+import com.zy.ints.entity.WaitMatin;
+import com.zy.ints.service.WaitMatchkService;
+import com.zy.ints.service.WaitMatinService;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
+
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.List;
/**
* 绉诲姩绔帴鍙ｆ帶鍒跺櫒
@@ -20,6 +39,20 @@
@Autowired
private MobileService mobileService;
+ @Autowired
+ private LocMastService locMastService;
+ @Autowired
+ private LocDetlService locDetlService;
+ @Autowired
+ private WrkDetlService wrkDetlService;
+ @Autowired
+ private WaitMatinService waitMatinService;
+ @Autowired
+ private WaitMatchkService waitMatchkService;
+ @Autowired
+ private MatCodeService matCodeService;
+ @Autowired
+ private WrkMastService wrkMastService;
/**
* 缁勬墭
@@ -27,8 +60,285 @@
@RequestMapping("/comb/auth")
@ManagerAuth(memo = "缁勬墭")
public R comb(@RequestBody CombParam combParam){
+ System.out.println("combParam = " + combParam);
mobileService.comb(combParam, getUserId());
return R.ok();
}
+ /**
+ * 缁勬墭
+ */
+ @RequestMapping("/comb/form")
+ @ManagerAuth(memo = "缁勬墭")
+ public R combForm(@RequestParam CombParam combParam){
+ mobileService.comb(combParam, getUserId());
+ return R.ok();
+ }
+
+ /**
+ * 搴撳瓨鏌ヨ(鏍规嵁鐗╂枡缂栫爜鍜屽簱浣嶆煡璇㈠簱瀛樻暟閲忓拰鎹℃枡鏁伴噺)
+ * @param locNo
+ * @param matNo
+ * @return
+ */
+ @RequestMapping("/locDetl/stockQuery")
+ @ManagerAuth
+ public R stockQuery(@RequestParam(required = false)String locNo,
+ @RequestParam(required = false)String matNo){
+ if (!Cools.isEmpty(locNo)) {
+ LocMast locMast = locMastService.selectById(locNo);
+ if (null == locMast || !"F".equals(locMast.getLocSts())) {
+ return R.parse(BaseRes.EMPTY);
+ }
+ List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>()
+ .eq("loc_no", locNo).orderBy("appe_time", false));
+ List<MobileLocDetlVo> res = new ArrayList<>();
+ locDetls.forEach(locDetl -> {
+ MobileLocDetlVo vo = new MobileLocDetlVo();
+ List<WrkDetl> wrkDetlsList = wrkDetlService.queryWrkDetl(locDetl.getMatNo(), locDetl.getLocNo());
+ final Double[] pickNum = {0.0};
+ wrkDetlsList.forEach(item -> {
+ pickNum[0] = pickNum[0] + item.getQty();
+ });
+ vo.setPickNum(pickNum[0]);
+ vo.setLocNo(locDetl.getLocNo());
+ vo.setMatNo(locDetl.getMatNo());
+ vo.setMatName(locDetl.getMatName());
+ vo.setCount(locDetl.getQty());
+ res.add(vo);
+ });
+ return R.ok().add(res);
+ }
+ if (!Cools.isEmpty(matNo)) {
+ List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>()
+ .eq("mat_no", matNo).orderBy("appe_time", false));
+ List<MobileLocDetlVo> res = new ArrayList<>();
+ locDetls.forEach(locDetl -> {
+ MobileLocDetlVo vo = new MobileLocDetlVo();
+ List<WrkDetl> wrkDetlsList = wrkDetlService.queryWrkDetl(locDetl.getMatNo(), locDetl.getLocNo());
+ final Double[] pickNum = {0.0};
+ wrkDetlsList.forEach(item -> {
+ pickNum[0] = pickNum[0] + item.getQty();
+ });
+ vo.setPickNum(pickNum[0]);
+ vo.setLocNo(locDetl.getLocNo());
+ vo.setMatNo(locDetl.getMatNo());
+ vo.setMatName(locDetl.getMatName());
+ vo.setCount(locDetl.getQty());
+ res.add(vo);
+ });
+ return R.ok().add(res);
+ }
+ return R.parse(BaseRes.PARAM);
+ }
+
+ // 鎷ｆ枡妫�绱㈡墭鐩樹俊鎭�
+ @RequestMapping("/piking/auth")
+ @ManagerAuth
+ public R pikingAuth(String barcode) {
+ WrkMast wrkMast = wrkMastService.selectByBarcode(barcode);
+ if (Cools.isEmpty(wrkMast)) {
+ throw new CoolException(barcode + "鏆傛棤宸ヤ綔妗�");
+ }
+ if (wrkMast.getIoType() != 103 && wrkMast.getIoType() != 107){
+ throw new CoolException(barcode + "涓嶄负鎷ｆ枡/鐩樼偣鍑哄簱");
+ }
+ List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo());
+ return R.ok().add(wrkDetls);
+ }
+ /**
+ * 鏍规嵁搴撲綅鍙锋煡鎵惧簱瀛樻槑缁�
+ */
+ @RequestMapping("/locDetl")
+ @ManagerAuth
+ public R getLocDetl(@RequestParam(required = false)String locNo,
+ @RequestParam(required = false)String matNo){
+ if (!Cools.isEmpty(locNo)) {
+ LocMast locMast = locMastService.selectById(locNo);
+ if (null == locMast || !"F".equals(locMast.getLocSts())) {
+ return R.parse(BaseRes.EMPTY);
+ }
+ List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>()
+ .eq("loc_no", locNo).orderBy("appe_time", false));
+ List<MobileLocDetlVo> res = new ArrayList<>();
+ locDetls.forEach(locDetl -> {
+ MobileLocDetlVo vo = new MobileLocDetlVo();
+ vo.setLocNo(locDetl.getLocNo());
+ vo.setMatNo(locDetl.getMatNo());
+ vo.setMatName(locDetl.getMatName());
+ vo.setCount(locDetl.getQty());
+ res.add(vo);
+ });
+ return R.ok().add(res);
+ }
+ if (!Cools.isEmpty(matNo)) {
+ List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>()
+ .eq("mat_no", matNo).orderBy("appe_time", false));
+ List<MobileLocDetlVo> res = new ArrayList<>();
+ locDetls.forEach(locDetl -> {
+ MobileLocDetlVo vo = new MobileLocDetlVo();
+ vo.setLocNo(locDetl.getLocNo());
+ vo.setMatNo(locDetl.getMatNo());
+ vo.setMatName(locDetl.getMatName());
+ vo.setCount(locDetl.getQty());
+ res.add(vo);
+ });
+ return R.ok().add(res);
+ }
+ return R.parse(BaseRes.PARAM);
+ }
+
+ /**
+ * 鏍规嵁閫氱煡鍗曟煡璇㈡槑缁�
+ */
+ @RequestMapping("/bill/query/auth")
+ @ManagerAuth(memo = "鏍规嵁閫氱煡鍗曟煡璇㈡槑缁�")
+ public R billQuery(@RequestParam String billNo){
+ List<WaitMatin> waitMatins = waitMatinService.selectList(new EntityWrapper<WaitMatin>().eq("bill_no", billNo).last("and qty > in_qty"));
+ List<CombBillQueryVo> vos = new ArrayList<>();
+ if (!Cools.isEmpty(waitMatins)) {
+ for (WaitMatin waitMatin : waitMatins) {
+ CombBillQueryVo vo = new CombBillQueryVo();
+ vo.setMatNo(waitMatin.getMatNo());
+ vo.setMatName(waitMatin.getMatName());
+ vo.setCount(waitMatin.getQty()-waitMatin.getInQty());
+ vo.setBillNo(waitMatin.getBillNo());
+ vo.setSeqNo(waitMatin.getSeqNo());
+ vo.setUnit(waitMatin.getUnit());
+ vo.setSpecs(waitMatin.getSpecs());
+ vo.setSize(waitMatin.getSize());
+ vo.setColor(waitMatin.getColor());
+ vos.add(vo);
+ }
+ }
+ return R.ok().add(vos);
+ }
+
+ /**
+ * PDA鐩樼偣鏍规嵁鍑哄簱鍙ｆ煡璇㈠搴旂墿鏂欎俊鎭�
+ */
+ @RequestMapping("/check/queryMatFromDevNo")
+ public R queryMatFromDevNo(Integer devNo) {
+ List<WrkDetl> list = wrkDetlService.queryMatFromDevNo(devNo);
+ return R.ok().add(list);
+ }
+
+ /**
+ * 鏍规嵁PDA鐩樼偣鏁伴噺锛屾洿鏂扮洏鐐归�氱煡妗�
+ * @param param
+ * @return
+ */
+ @RequestMapping("/stock/check")
+ @Transactional
+ @ManagerAuth
+ public R erpStockCheck(@RequestBody String param) {
+ Boolean flag = false;
+ JSONObject jsonObject = JSONObject.parseObject(param);
+ String checkListStr = jsonObject.getString("checkList");
+ List<WaitMatchk> checkList = JSONArray.parseArray(checkListStr, WaitMatchk.class);
+ Long userId = 9527L; //getUserId();//9527L;
+ int seq = 0;
+ Date now = new Date();
+ for (Integer i = 0; i < checkList.size(); i++) {
+ String locNo = checkList.get(i).getLocNo();
+ String matNo = checkList.get(i).getMatNo();
+ Double checkQty = checkList.get(i).getCheckQty();
+
+ Wrapper<WaitMatchk> wrapper = new EntityWrapper<WaitMatchk>().eq("loc_no",locNo).eq("mat_no",matNo);
+ WaitMatchk waitMatchk0 = waitMatchkService.selectOne(wrapper);
+ if(null != waitMatchk0){
+ waitMatchk0.setCheckQty(checkQty);
+ flag = waitMatchkService.update(waitMatchk0,wrapper);
+ if(!flag){
+ throw new CoolException("鏇存柊鐩樼偣閫氱煡妗ｅけ璐�");
+ }
+ } else {
+ MatCode matCode = matCodeService.selectOne(new EntityWrapper<MatCode>().eq("mat_no",matNo));
+ WaitMatchk waitMatchk1 = waitMatchkService.selectOne(new EntityWrapper<WaitMatchk>().eq("loc_no",locNo).orderBy("seq_no",false));
+ if(null != matCode) {
+ WaitMatchk waitMatchk = new WaitMatchk();
+ waitMatchk.setLocNo(locNo);
+ waitMatchk.setMatNo(matNo);
+ if(null != waitMatchk1){
+ waitMatchk.setBillNo(waitMatchk1.getBillNo());
+ waitMatchk.setSeqNo(waitMatchk1.getSeqNo()+1);
+ waitMatchk.setZpallet(waitMatchk1.getZpallet());
+ waitMatchk.setLinkErp(waitMatchk1.getLinkErp());
+ waitMatchk.setIoStatus(waitMatchk1.getIoStatus());
+ } else {
+ waitMatchk.setBillNo("0");
+ waitMatchk.setSeqNo(seq++);
+ waitMatchk.setLinkErp(0);
+ waitMatchk.setIoStatus(1);
+ }
+ waitMatchk.setBillType(1);//鎶界洏
+ waitMatchk.setMatName(matCode.getMatName());
+ waitMatchk.setStockQty(0D);
+ waitMatchk.setCheckQty(checkQty);
+ waitMatchk.setModiTime(now);
+ waitMatchk.setModiUser(getUserId());
+ waitMatchk.setAppeTime(now);
+ waitMatchk.setAppeUser(getUserId());
+ flag = waitMatchkService.insert(waitMatchk);
+ if(!flag){
+ throw new CoolException("鏂板鐩樼偣閫氱煡妗ｆ暟鎹け璐�");
+ }
+ }
+
+ }
+ }
+ return R.ok().add(flag);
+ }
+
+ // 鎷ｆ枡杞叏鏉�
+ // sBarcode 鍘熸墭鐩樼爜 tBarcode 杞崲鎵樼洏鐮�
+ @RequestMapping("/piking/to/full")
+ @ManagerAuth
+ @Transactional
+ public R pikingToFull(String sBarcode,String tBarcode) {
+ // 妫�鏌ヨ浆鎹㈡墭鐩樼爜鏄惁鍦ㄥ簱
+ List<LocDetl> locDetls = locDetlService.selectByZpallet(tBarcode);
+ if (!Cools.isEmpty(locDetls)) {
+ throw new CoolException("闇�瑕佽浆鎹㈢殑鎵樼洏宸茶浣跨敤,璇锋洿鎹㈡墭鐩橈紒");
+ }
+ WrkMast twrkMast = wrkMastService.selectByBarcode(tBarcode);
+ if (!Cools.isEmpty(twrkMast)) {
+ throw new CoolException("闇�瑕佽浆鎹㈢殑鎵樼洏宸茶浣跨敤,璇锋洿鎹㈡墭鐩橈紒");
+ }
+ LocMast tlocMast = locMastService.selectByBarcode(tBarcode);
+ if (!Cools.isEmpty(tlocMast)) {
+ throw new CoolException("闇�瑕佽浆鎹㈢殑鎵樼洏宸茶浣跨敤,璇锋洿鎹㈡墭鐩橈紒");
+ }
+ WrkDetl twrkDetl = wrkDetlService.selectByZpallet0(tBarcode);
+ if (!Cools.isEmpty(twrkDetl)) {
+ throw new CoolException("闇�瑕佽浆鎹㈢殑鎵樼洏宸茶浣跨敤,璇锋洿鎹㈡墭鐩橈紒");
+ }
+// 淇敼宸ヤ綔妗ｆ墭鐩樼爜
+ WrkMast wrkMast = wrkMastService.selectByBarcode(sBarcode);
+ if (wrkMast.getWrkSts() != 14) {
+ throw new CoolException("鍑哄簱鏈畬鎴愶紒");
+ }
+ List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo());
+ for (WrkDetl wrkDetl : wrkDetls) {
+ //++++
+ wrkDetlService.updateBarcode(sBarcode,tBarcode,wrkDetl.getSupplier());
+ }
+
+ if (Cools.isEmpty(wrkMast)) {
+ throw new CoolException("璇风‘璁ゆ墭鐩樼爜锛�");
+ }
+// 淇敼搴撳瓨鏄庣粏妗ｆ墭鐩樼爜
+ List<LocDetl> locDetls1 = locDetlService.selectByZpallet(sBarcode);
+ for (LocDetl locDetl : locDetls1) {
+ //++++
+ locDetlService.updateZpallet(sBarcode,tBarcode,locDetl.getSupplier());
+ }
+// 淇敼宸ヤ綔涓绘。鏉＄爜
+ wrkMast.setBarcode(tBarcode);
+ wrkMastService.updateById(wrkMast);
+ LocMast locMast = locMastService.selectByBarcode(sBarcode);
+ locMast.setBarcode(tBarcode);
+ locMastService.updateById(locMast);
+ return R.ok("杞崲鎴愬姛");
+ }
}
--
Gitblit v1.9.1