From 7331f7ad8a9f4511fc740238dbafc4e4d53b9730 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期二, 31 十二月 2024 16:24:12 +0800
Subject: [PATCH] 盘点单
---
src/main/java/com/zy/asrs/controller/StaDescController.java | 71 +++++++++++++++++++++++++++++++++++
1 files changed, 71 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/StaDescController.java b/src/main/java/com/zy/asrs/controller/StaDescController.java
index 5c32944..3a6ac32 100644
--- a/src/main/java/com/zy/asrs/controller/StaDescController.java
+++ b/src/main/java/com/zy/asrs/controller/StaDescController.java
@@ -6,6 +6,8 @@
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.zy.asrs.entity.StaDesc;
+import com.zy.asrs.entity.param.StaDescInitParam;
+import com.zy.asrs.mapper.StaDescMapper;
import com.zy.asrs.service.StaDescService;
import com.zy.common.web.BaseController;
import com.core.annotations.ManagerAuth;
@@ -13,6 +15,11 @@
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
+import org.apache.ibatis.session.ExecutorType;
+import org.apache.ibatis.session.SqlSession;
+import org.apache.ibatis.session.SqlSessionFactory;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@@ -21,8 +28,64 @@
@RestController
public class StaDescController extends BaseController {
+ private static final Logger log = LoggerFactory.getLogger(StaDescController.class);
@Autowired
private StaDescService staDescService;
+ @Autowired
+ private SqlSessionFactory sqlSessionFactory;
+
+ @RequestMapping(value = "/staDesc/init/auth")
+ @ManagerAuth(memo = "鍒濆鍖栫珯鐐硅矾寰�")
+ public R init(StaDescInitParam param) {
+ try{
+ if (param.getTypeDesc()==1){
+ staDescService.delete(new EntityWrapper<>());
+ }
+ String[] startStaList = param.getStartStaList().split(";");
+ String[] endStaList = param.getEndStaList().split(";");
+ List<StaDesc> staDescList = new ArrayList<>();
+ SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
+ StaDescMapper sqlSessionMapper = sqlSession.getMapper(StaDescMapper.class);
+ for (String startSta : startStaList){
+ for (String endSta : endStaList){
+ for (Integer type:param.getType()){
+ int sameRes = staDescService.selectCount(new EntityWrapper<StaDesc>()
+ .eq("type_no", type)
+ .eq("stn_no", Integer.parseInt(startSta))
+ .eq("crn_no", param.getCrnNo())
+ .eq("crn_stn", Integer.parseInt(endSta)));
+ if (sameRes > 0) {
+ continue;
+ }
+ StaDesc staDesc = new StaDesc();
+ staDesc.setCrnNo(param.getCrnNo());
+ staDesc.setTypeNo(type);
+ staDesc.setStnNo(Integer.parseInt(startSta));
+ staDesc.setCrnStn(Integer.parseInt(endSta));
+ staDesc.setModiUser(getUserId());
+ staDesc.setModiTime(new Date());
+ staDesc.setAppeUser(getUserId());
+ staDesc.setAppeTime(new Date());
+// staDescList.add(staDesc);
+ sqlSessionMapper.insert(staDesc);
+
+ }
+ }
+ }
+ try{
+ sqlSession.commit();
+ sqlSession.close();
+ }catch (Exception e){
+ log.error("鍒濆鍖栫珯鐐硅矾寰勫紓甯�===>sql寮傚父锛歿}",e.getMessage());
+ }
+// staDescService.insertBatch(staDescList);
+ }catch (Exception e){
+ log.error("鍒濆鍖栫珯鐐硅矾寰勫紓甯革細{}",e.getMessage());
+ return R.error("鍒濆鍖栫珯鐐硅矾寰勫紓甯革細"+e.getMessage());
+ }
+
+ return R.ok("ok1").add("ok2");
+ }
@RequestMapping(value = "/staDesc/{id}/auth")
@ManagerAuth
@@ -60,6 +123,14 @@
@RequestMapping(value = "/staDesc/add/auth")
@ManagerAuth(memo = "绔欑偣璺緞娣诲姞")
public R add(StaDesc staDesc) {
+ int sameRes = staDescService.selectCount(new EntityWrapper<StaDesc>()
+ .eq("type_no", staDesc.getTypeNo())
+ .eq("stn_no", staDesc.getStnNo())
+ .eq("crn_no", staDesc.getCrnNo())
+ .eq("crn_stn", staDesc.getCrnStn()));
+ if (sameRes > 0) {
+ return R.error("璺緞宸插瓨鍦�");
+ }
staDesc.setModiUser(getUserId());
staDesc.setModiTime(new Date());
staDesc.setAppeUser(getUserId());
--
Gitblit v1.9.1