From cc3d237b380bc30be21f7cb5d8c6fb9b3d617fe3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 03 三月 2023 09:20:14 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/service/data/MetaService.java |   97 ++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 80 insertions(+), 17 deletions(-)

diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java
index 6f052a5..25b734b 100644
--- a/src/main/java/com/lf/server/service/data/MetaService.java
+++ b/src/main/java/com/lf/server/service/data/MetaService.java
@@ -6,6 +6,7 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
+import java.util.ArrayList;
 import java.util.List;
 
 /**
@@ -18,31 +19,37 @@
     MetaMapper metaMapper;
 
     @Override
-    public Integer selectCount(Integer depid, Integer dirid, String name) {
+    public Integer selectCount(String depcode, String dircode, Integer verid, String name) {
+        depcode = StringHelper.getRightLike(depcode);
+        dircode = StringHelper.getRightLike(dircode);
         name = StringHelper.getLikeStr(name);
 
-        return metaMapper.selectCount(depid, dirid, name);
+        return metaMapper.selectCount(depcode, dircode, verid, name);
     }
 
     @Override
-    public List<MetaEntity> selectByPage(Integer depid, Integer dirid, String name, Integer limit, Integer offset) {
+    public List<MetaEntity> selectByPage(String depcode, String dircode, Integer verid, String name, Integer limit, Integer offset) {
+        depcode = StringHelper.getRightLike(depcode);
+        dircode = StringHelper.getRightLike(dircode);
         name = StringHelper.getLikeStr(name);
 
-        return metaMapper.selectByPage(depid, dirid, name, limit, offset);
+        return metaMapper.selectByPage(depcode, dircode, verid, name, limit, offset);
     }
 
     @Override
-    public Integer selectMetasForCount(Integer depid, String dirs, String name) {
+    public Integer selectMetasForCount(String depcode, String dirs, String name) {
+        depcode = StringHelper.getRightLike(depcode);
         name = StringHelper.getLikeStr(name);
 
-        return metaMapper.selectMetasForCount(depid, dirs, name);
+        return metaMapper.selectMetasForCount(depcode, dirs, name);
     }
 
     @Override
-    public List<MetaEntity> selectMetasForPage(Integer depid, String dirs, String name, Integer limit, Integer offset) {
+    public List<MetaEntity> selectMetasForPage(String depcode, String dirs, String name, Integer limit, Integer offset) {
+        depcode = StringHelper.getRightLike(depcode);
         name = StringHelper.getLikeStr(name);
 
-        return metaMapper.selectMetasForPage(depid, dirs, name, limit, offset);
+        return metaMapper.selectMetasForPage(depcode, dirs, name, limit, offset);
     }
 
     @Override
@@ -60,8 +67,17 @@
     }
 
     @Override
-    public List<MetaEntity> selectAll() {
-        return metaMapper.selectAll();
+    public Integer selectCountByPid(Integer metaid, String name) {
+        name = StringHelper.getLikeStr(name);
+
+        return metaMapper.selectCountByPid(metaid, name);
+    }
+
+    @Override
+    public List<MetaEntity> selectPageByPid(Integer metaid, String name, Integer limit, Integer offset) {
+        name = StringHelper.getLikeStr(name);
+
+        return metaMapper.selectPageByPid(metaid, name, limit, offset);
     }
 
     @Override
@@ -75,8 +91,18 @@
     }
 
     @Override
+    public List<MetaEntity> selectByIdsForTab(String ids) {
+        return metaMapper.selectByIdsForTab(ids);
+    }
+
+    @Override
     public List<MetaEntity> selectMetaFiles(List<Integer> ids) {
         return metaMapper.selectMetaFiles(ids);
+    }
+
+    @Override
+    public List<MetaEntity> selectXlsAnnex(Integer[] ids, String tabs) {
+        return metaMapper.selectXlsAnnex(ids, tabs);
     }
 
     @Override
@@ -90,13 +116,8 @@
     }
 
     @Override
-    public Integer delete(int id) {
-        return metaMapper.delete(id);
-    }
-
-    @Override
-    public Integer deletes(List<Integer> ids) {
-        return metaMapper.deletes(ids);
+    public Integer deletes(String sql, String ids) {
+        return metaMapper.deletes(sql, ids);
     }
 
     @Override
@@ -108,4 +129,46 @@
     public Integer updates(List<MetaEntity> list) {
         return metaMapper.updates(list);
     }
+
+    /**
+     * 鍒犻櫎鍏冩暟鎹�
+     */
+    public Integer deletes(List<Integer> list) {
+        String ids = StringHelper.join(list, ",");
+
+        String sql = null;
+        List<MetaEntity> metas = selectByIdsForTab(ids);
+        if (null != metas && metas.size() > 0) {
+            sql = getDelTabsSql(metas);
+        }
+
+        return deletes(sql, ids);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎琛ㄨ褰昐QL
+     */
+    public String getDelTabsSql(List<MetaEntity> metas) {
+        List<String> list = new ArrayList<>();
+        String tab = metas.get(0).getTab();
+
+        List<String> pids = new ArrayList<>();
+        for (MetaEntity me : metas) {
+            if (tab.equals(me.getTab())) {
+                pids.add("'" + me.getEventid() + "'");
+            } else {
+                list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ",")));
+
+                pids.clear();
+                tab = me.getTab();
+                pids.add("'" + me.getEventid() + "'");
+            }
+        }
+
+        if (pids.size() > 0) {
+            list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ",")));
+        }
+
+        return StringHelper.join(list, ";");
+    }
 }

--
Gitblit v1.9.3