水库编辑，向新表中添加标签数据

guoshilong

2024-02-01 91a17daf8bcda53729e56ecdf1109b22cf022c73

水库编辑，向新表中添加标签数据

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/RelResLabel.java

New file
@@ -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;


}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.java

New file
@@ -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> {


}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/RelResLabelMapper.xml

New file
@@ -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>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IRelResLabelService.java

New file
@@ -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);
}

 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);
    }


 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/RelResLabelServiceImpl.java

New file
@@ -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;
    }
}