From a34dafbbfa35432f9dc262779d9e6b6318ff2128 Mon Sep 17 00:00:00 2001
From: wang..123 <brook_w@163.com>
Date: 星期二, 01 三月 2022 15:55:01 +0800
Subject: [PATCH] #导出导入功能改善
---
src/main/java/com/zy/asrs/controller/StatisController.java | 82 +++++++++++++++++++++++++++++++++++++----
1 files changed, 74 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/StatisController.java b/src/main/java/com/zy/asrs/controller/StatisController.java
index 80b6f6d..b7241c3 100644
--- a/src/main/java/com/zy/asrs/controller/StatisController.java
+++ b/src/main/java/com/zy/asrs/controller/StatisController.java
@@ -6,13 +6,17 @@
import com.baomidou.mybatisplus.plugins.Page;
import com.core.annotations.ManagerAuth;
import com.core.common.R;
+import com.core.exception.CoolException;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.MatCode;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.MatCodeService;
import com.zy.asrs.utils.VersionUtils;
import com.zy.common.web.BaseController;
+import com.zy.ints.entity.StockSync;
+import com.zy.ints.service.StockSyncService;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@@ -20,6 +24,7 @@
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
+import java.util.Date;
import java.util.List;
import java.util.Map;
@@ -33,6 +38,8 @@
private MatCodeService matCodeService;
@Autowired
private LocDetlService locDetlService;
+ @Autowired
+ StockSyncService stockSyncService;
// 搴撳瓨缁熻 ------------------------------------------------------------------------------------------
@@ -42,10 +49,9 @@
@RequestParam(defaultValue = "14")Integer limit,
// @RequestParam(required = false)String condition,
@RequestParam Map<String, Object> param) {
- System.out.println(param);
Page<LocDetl> stockStatis = locDetlService.getStockStatis(toPage(curr, limit, param, LocDetl.class));
for (LocDetl locDetl : stockStatis.getRecords()) {
- MatCode mat = matCodeService.selectOne(new EntityWrapper<MatCode>().eq("mat_no",locDetl.getMatNo()).eq("str8",locDetl.getColor()));
+ MatCode mat = matCodeService.selectOne(new EntityWrapper<MatCode>().eq("mat_no",locDetl.getMatNo()));
// MatCode mat = matCodeService.selectById(locDetl.getMatnr());
if (mat != null) {
VersionUtils.setLocDetl(locDetl, mat);
@@ -74,11 +80,71 @@
.doWrite(excel);
}
-// @RequestMapping(value = "/stock/statis/queryLocByMatNoAndMatName")
-// public R queryLocByMatNoAndMatName(@RequestParam LocDetl locDetl){
-// List<LocDetl> locDetls=locDetlService.getlocDetlByMatNoAndMatName(locDetl);
-//// locDetl.
-// return R.ok().add(locDetls);
-// }
+ /**
+ * 鑾峰彇搴撳瓨鍚屾琛ㄦ暟鎹�
+ * @return
+ */
+ @RequestMapping(value = "/stock/stockSyncCount")
+ @ManagerAuth(memo = "鑾峰彇搴撳瓨鍚屾涓婁紶娓呭崟鏁伴噺")
+ public R getStockSyncCount() {
+ return R.ok(stockSyncService.getStockSyncCount());
+ }
+ /**
+ * 鎻掑叆鏁版嵁鍒板簱瀛樺悓姝ヨ〃
+ * @return
+ */
+ @RequestMapping(value = "/stock/insertStockSync")
+ @ManagerAuth(memo = "鍚屾涓婁紶娓呭崟鏁版嵁鎻掑叆")
+ @Transactional
+ public R insertStockSync() {
+ Date now = new Date();
+ Long userId = getUserId();
+ List<LocDetl> locDetls = locDetlService.getStockSum();
+ for(LocDetl locdetl : locDetls){
+ StockSync stockSync = new StockSync();
+ stockSync.setMatNo(locdetl.getMatNo());
+ stockSync.setMatName(locdetl.getMatName());
+ stockSync.setQty(locdetl.getQty());
+ stockSync.setModiUser(userId);
+ stockSync.setModiTime(now);
+ stockSync.setAppeUser(userId);
+ stockSync.setAppeTime(now);
+ if(!stockSyncService.insert(stockSync)){
+ throw new CoolException("鎻掑叆鍚屾搴撳瓨鏁版嵁澶辫触");
+ }
+ }
+ return R.ok(locDetls.size());
+ }
+
+ /**
+ * 鏇存柊鏁版嵁鍒板簱瀛樺悓姝ヨ〃锛屽厛娓呯┖鍐嶆彃鍏�
+ * @return
+ */
+ @RequestMapping(value = "/stock/updateStockSync")
+ @ManagerAuth(memo = "娓呯┖鍚屾涓婁紶鏁版嵁骞舵彃鍏�")
+ @Transactional
+ public R updateStockSync() {
+ if(!stockSyncService.clearStockSync()){
+ throw new CoolException("鍚屾涓婁紶鏁版嵁娓呯┖澶辫触锛岃鑱旂郴绠＄悊鍛�");
+ }
+
+ Date now = new Date();
+ Long userId = getUserId();
+ List<LocDetl> locDetls = locDetlService.getStockSum();
+ for(LocDetl locdetl : locDetls){
+ StockSync stockSync = new StockSync();
+ stockSync.setMatNo(locdetl.getMatNo());
+ stockSync.setMatName(locdetl.getMatName());
+ stockSync.setQty(locdetl.getQty());
+ stockSync.setModiUser(userId);
+ stockSync.setModiTime(now);
+ stockSync.setAppeUser(userId);
+ stockSync.setAppeTime(now);
+ if(!stockSyncService.insert(stockSync)){
+ throw new CoolException("鏇存柊鍚屾搴撳瓨鏁版嵁澶辫触");
+ }
+ }
+ return R.ok(locDetls.size());
+ }
}
--
Gitblit v1.9.1