From f25bd904560faada2a00e93fbd8abab6be238f9c Mon Sep 17 00:00:00 2001
From: lsh <lsh@163.com>
Date: 星期二, 15 四月 2025 15:44:31 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/controller/StaDescController.java |   84 +++++++++++++++++++++++++++++++++++++++---
 1 files changed, 78 insertions(+), 6 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/StaDescController.java b/src/main/java/com/zy/asrs/controller/StaDescController.java
index 98a8050..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
@@ -44,14 +107,15 @@
         return R.ok(staDescService.selectPage(new Page<>(curr, limit), wrapper));
     }
 
-    private void convert(Map<String, Object> map, EntityWrapper wrapper){
+    private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){
         for (Map.Entry<String, Object> entry : map.entrySet()){
-            if (entry.getKey().endsWith(">")) {
-                wrapper.ge(Cools.deleteChar(entry.getKey()), DateUtils.convert(String.valueOf(entry.getValue())));
-            } else if (entry.getKey().endsWith("<")) {
-                wrapper.le(Cools.deleteChar(entry.getKey()), DateUtils.convert(String.valueOf(entry.getValue())));
+            String val = String.valueOf(entry.getValue());
+            if (val.contains(RANGE_TIME_LINK)){
+                String[] dates = val.split(RANGE_TIME_LINK);
+                wrapper.ge(entry.getKey(), DateUtils.convert(dates[0]));
+                wrapper.le(entry.getKey(), DateUtils.convert(dates[1]));
             } else {
-                wrapper.eq(entry.getKey(), String.valueOf(entry.getValue()));
+                wrapper.like(entry.getKey(), val);
             }
         }
     }
@@ -59,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