From 91a17daf8bcda53729e56ecdf1109b22cf022c73 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Thu, 01 Feb 2024 14:53:47 +0800
Subject: [PATCH] 水库编辑，向新表中添加标签数据
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java | 14 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/RelResLabel.java | 39 +++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.xml | 7 ++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/RelResLabelServiceImpl.java | 49 ++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.java | 12 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IRelResLabelService.java | 8 ++
6 files changed, 129 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/RelResLabel.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/RelResLabel.java
new file mode 100644
index 0000000..fe0597f
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/RelResLabel.java
@@ -0,0 +1,39 @@
+package cn.gistack.sm.sjztmd.entity;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.databind.annotation.JsonSerialize;
+import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.io.Serializable;
+
+/**
+ * 水库标签表
+ *
+ * @author Chill
+ */
+@Data
+@TableName("\"rel_res_label\"")
+@ApiModel(value = "标签", description = "标签")
+public class RelResLabel implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 主键
+ */
+ @TableField("\"guid\"")
+ private String guid;
+
+ /**
+ *标签
+ */
+ @TableField("\"label\"")
+ private String label;
+
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.java
new file mode 100644
index 0000000..c4b69ce
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.java
@@ -0,0 +1,12 @@
+package cn.gistack.sm.sjztmd.mapper;
+
+import cn.gistack.sm.sjztmd.entity.RelResLabel;
+import cn.gistack.sm.sjztmd.entity.YwTermitesTask;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+
+
+public interface RelResLabelMapper extends BaseMapper<RelResLabel> {
+
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.xml
new file mode 100644
index 0000000..f5eccf6
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.xml
@@ -0,0 +1,7 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
+<mapper namespace="cn.gistack.sm.sjztmd.mapper.RelResLabelMapper">
+ <!--namespace根据自己需要创建的的mapper的路径和名称填写-->
+
+
+</mapper>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IRelResLabelService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IRelResLabelService.java
new file mode 100644
index 0000000..33ed473
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IRelResLabelService.java
@@ -0,0 +1,8 @@
+package cn.gistack.sm.sjztmd.service;
+
+import cn.gistack.sm.sjztmd.entity.RelResLabel;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+public interface IRelResLabelService extends IService<RelResLabel> {
+ Boolean updateEntity(String guid, String label);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
index 41924bb..73d6b39 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
@@ -3,8 +3,10 @@
import cn.gistack.sm.intelligentCall.mapper.CallTaskMapper;
import cn.gistack.sm.sjztmd.dto.AttResBaseUserDTO;
import cn.gistack.sm.sjztmd.entity.AttResBase;
+import cn.gistack.sm.sjztmd.entity.RelResLabel;
import cn.gistack.sm.sjztmd.mapper.AttResBaseMapper;
import cn.gistack.sm.sjztmd.service.IAttResBaseService;
+import cn.gistack.sm.sjztmd.service.IRelResLabelService;
import cn.gistack.sm.sjztmd.vo.AttResAdVO;
import cn.gistack.sm.sjztmd.vo.AttResBaseGeneralInvestigationVO;
import cn.gistack.sm.sjztmd.vo.AttResBaseVO;
@@ -15,6 +17,7 @@
import org.springblade.core.tool.utils.DateUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestParam;
import java.util.ArrayList;
@@ -34,6 +37,10 @@
@Autowired
private CallTaskMapper callTaskMapper;
+
+ @Autowired
+ private IRelResLabelService relResLabelService;
+
@Override
public IPage<AttResBase> selectAttResBasePage(IPage<AttResBase> page, AttResBase attResBase) {
@@ -75,8 +82,15 @@
}
@Override
+ @Transactional(rollbackFor = Exception.class)
public Boolean updateResBaseByGuid(AttResBase attResBase) {
attResBase.setUpdateTime(DateUtil.now());
+
+
+ //向水库标签表中更新数据
+ relResLabelService.updateEntity(attResBase.getGuid(),attResBase.getLabel());
+
+
return baseMapper.updateResBaseByGuid(attResBase);
}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/RelResLabelServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/RelResLabelServiceImpl.java
new file mode 100644
index 0000000..8b81cba
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/RelResLabelServiceImpl.java
@@ -0,0 +1,49 @@
+package cn.gistack.sm.sjztmd.service.impl;
+
+import cn.gistack.sm.sjztmd.entity.RelResLabel;
+import cn.gistack.sm.sjztmd.mapper.RelResLabelMapper;
+import cn.gistack.sm.sjztmd.service.IRelResLabelService;
+import com.baomidou.dynamic.datasource.annotation.DS;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.core.tool.utils.StringUtil;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.List;
+
+@Service
+@DS("zt")
+public class RelResLabelServiceImpl extends ServiceImpl<RelResLabelMapper, RelResLabel> implements IRelResLabelService {
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public Boolean updateEntity(String guid, String label) {
+
+ //删除表中原来的标签
+ QueryWrapper queryWrapper = new QueryWrapper();
+ queryWrapper.eq("\"guid\"",guid);
+
+ boolean remove = remove(queryWrapper);
+ //添加新标签数据
+ if (StringUtil.isNotBlank(label)){
+ List<RelResLabel> list = new ArrayList<>();
+
+ List<String> labelList = Arrays.asList(label.split(","));
+
+ labelList.forEach(e->{
+ RelResLabel relResLabel = new RelResLabel();
+
+ relResLabel.setGuid(guid);
+ relResLabel.setLabel(e);
+
+ list.add(relResLabel);
+ });
+
+ boolean saveBatch = saveBatch(list);
+ return saveBatch;
+ }
+ return remove;
+ }
+}
--
Gitblit v1.9.3