From 160beba2bb2044f52956552e9cd8716ef4e0093b Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 03 三月 2023 15:08:05 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/data/MetaService.java | 82 +++++++++++++++++++++++++++++++++-------
1 files changed, 67 insertions(+), 15 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 e73e42b..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;
/**
@@ -19,8 +20,8 @@
@Override
public Integer selectCount(String depcode, String dircode, Integer verid, String name) {
- depcode = StringHelper.getLeftLike(depcode);
- dircode = StringHelper.getLeftLike(dircode);
+ depcode = StringHelper.getRightLike(depcode);
+ dircode = StringHelper.getRightLike(dircode);
name = StringHelper.getLikeStr(name);
return metaMapper.selectCount(depcode, dircode, verid, name);
@@ -28,8 +29,8 @@
@Override
public List<MetaEntity> selectByPage(String depcode, String dircode, Integer verid, String name, Integer limit, Integer offset) {
- depcode = StringHelper.getLeftLike(depcode);
- dircode = StringHelper.getLeftLike(dircode);
+ depcode = StringHelper.getRightLike(depcode);
+ dircode = StringHelper.getRightLike(dircode);
name = StringHelper.getLikeStr(name);
return metaMapper.selectByPage(depcode, dircode, verid, name, limit, offset);
@@ -37,7 +38,7 @@
@Override
public Integer selectMetasForCount(String depcode, String dirs, String name) {
- depcode = StringHelper.getLeftLike(depcode);
+ depcode = StringHelper.getRightLike(depcode);
name = StringHelper.getLikeStr(name);
return metaMapper.selectMetasForCount(depcode, dirs, name);
@@ -45,7 +46,7 @@
@Override
public List<MetaEntity> selectMetasForPage(String depcode, String dirs, String name, Integer limit, Integer offset) {
- depcode = StringHelper.getLeftLike(depcode);
+ depcode = StringHelper.getRightLike(depcode);
name = StringHelper.getLikeStr(name);
return metaMapper.selectMetasForPage(depcode, dirs, name, limit, offset);
@@ -66,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
@@ -78,6 +88,11 @@
@Override
public MetaEntity selectByGuid(String guid, String tab) {
return metaMapper.selectByGuid(guid, tab);
+ }
+
+ @Override
+ public List<MetaEntity> selectByIdsForTab(String ids) {
+ return metaMapper.selectByIdsForTab(ids);
}
@Override
@@ -101,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
@@ -119,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