代码提交

liusheng

2024-07-25 7ef571e23124892654b480c7120fa69a4ae9eb36

代码提交

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibScriptTagController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,98 @@
package com.ruoyi.web.controller.smartor;

import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.SvyLibScriptTag;
import com.smartor.service.ISvyLibScriptTagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * é—®é¢˜è¯æœ¯æ ‡ç­¾åº“Controller
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@RestController
@RequestMapping("/smartor/svyLibScriptTag")
public class SvyLibScriptTagController extends BaseController
{
    @Autowired
    private ISvyLibScriptTagService svyLibScriptTagService;

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:tag:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyLibScriptTag svyLibScriptTag)
    {
        startPage();
        List<SvyLibScriptTag> list = svyLibScriptTagService.selectSvyLibScriptTagList(svyLibScriptTag);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé—®é¢˜è¯æœ¯æ ‡ç­¾åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:tag:export')")
    @Log(title = "问题话术标签库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyLibScriptTag svyLibScriptTag)
    {
        List<SvyLibScriptTag> list = svyLibScriptTagService.selectSvyLibScriptTagList(svyLibScriptTag);
        ExcelUtil<SvyLibScriptTag> util = new ExcelUtil<SvyLibScriptTag>(SvyLibScriptTag.class);
        util.exportExcel(response, list, "问题话术标签库数据");
    }

    /**
     * èŽ·å–问题话术标签库详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:tag:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(svyLibScriptTagService.selectSvyLibScriptTagById(id));
    }

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    @PreAuthorize("@ss.hasPermi('system:tag:add')")
    @Log(title = "问题话术标签库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyLibScriptTag svyLibScriptTag)
    {
        return toAjax(svyLibScriptTagService.insertSvyLibScriptTag(svyLibScriptTag));
    }

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    @PreAuthorize("@ss.hasPermi('system:tag:edit')")
    @Log(title = "问题话术标签库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyLibScriptTag svyLibScriptTag)
    {
        return toAjax(svyLibScriptTagService.updateSvyLibScriptTag(svyLibScriptTag));
    }

    /**
     * åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    @PreAuthorize("@ss.hasPermi('system:tag:remove')")
    @Log(title = "问题话术标签库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(svyLibScriptTagService.deleteSvyLibScriptTagByIds(ids));
    }
}

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateTagController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,98 @@
package com.ruoyi.web.controller.smartor;

import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.SvyLibTemplateTag;
import com.smartor.service.ISvyLibTemplateTagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * æ¨¡æ¿æ ‡ç­¾Controller
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@RestController
@RequestMapping("/smartor/svyLibTemplateTag")
public class SvyLibTemplateTagController extends BaseController
{
    @Autowired
    private ISvyLibTemplateTagService svyLibTemplateTagService;

    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:tag:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyLibTemplateTag svyLibTemplateTag)
    {
        startPage();
        List<SvyLibTemplateTag> list = svyLibTemplateTagService.selectSvyLibTemplateTagList(svyLibTemplateTag);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ¨¡æ¿æ ‡ç­¾åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:tag:export')")
    @Log(title = "模板标签", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyLibTemplateTag svyLibTemplateTag)
    {
        List<SvyLibTemplateTag> list = svyLibTemplateTagService.selectSvyLibTemplateTagList(svyLibTemplateTag);
        ExcelUtil<SvyLibTemplateTag> util = new ExcelUtil<SvyLibTemplateTag>(SvyLibTemplateTag.class);
        util.exportExcel(response, list, "模板标签数据");
    }

    /**
     * èŽ·å–模板标签详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:tag:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(svyLibTemplateTagService.selectSvyLibTemplateTagById(id));
    }

    /**
     * æ–°å¢žæ¨¡æ¿æ ‡ç­¾
     */
    @PreAuthorize("@ss.hasPermi('system:tag:add')")
    @Log(title = "模板标签", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyLibTemplateTag svyLibTemplateTag)
    {
        return toAjax(svyLibTemplateTagService.insertSvyLibTemplateTag(svyLibTemplateTag));
    }

    /**
     * ä¿®æ”¹æ¨¡æ¿æ ‡ç­¾
     */
    @PreAuthorize("@ss.hasPermi('system:tag:edit')")
    @Log(title = "模板标签", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyLibTemplateTag svyLibTemplateTag)
    {
        return toAjax(svyLibTemplateTagService.updateSvyLibTemplateTag(svyLibTemplateTag));
    }

    /**
     * åˆ é™¤æ¨¡æ¿æ ‡ç­¾
     */
    @PreAuthorize("@ss.hasPermi('system:tag:remove')")
    @Log(title = "模板标签", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(svyLibTemplateTagService.deleteSvyLibTemplateTagByIds(ids));
    }
}

 ruoyi-admin/src/main/resources/application.yml

@@ -111,7 +111,7 @@
  # ä»¤ç‰Œå¯†é’¥
  secret: abcdefghijklmnopqrstuvwxyz
  # ä»¤ç‰Œæœ‰æ•ˆæœŸï¼ˆé»˜è®¤30分钟）
  expireTime: 30
  expireTime: 120

# MyBatis配置
mybatis:

 smartor/src/main/java/com/smartor/domain/SvyLibScript.java

@@ -98,11 +98,9 @@
    @ApiModelProperty("上传标记")
    private Long isupload;

    /**
     * ä¸Šä¼ æ ‡è®°
     */

    @ApiModelProperty("标签")
    private String tag = "";
    private List<SvyLibScriptTag> svyLibScriptTagList;

    /**
     * ä¸Šä¼ æ—¶é—´

 smartor/src/main/java/com/smartor/domain/SvyLibScriptTag.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,98 @@
package com.smartor.domain;

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * é—®é¢˜è¯æœ¯æ ‡ç­¾åº“对象 svy_lib_script_tag
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Data
@ApiModel(value = "SvyLibScriptTag", description = "问题话术标签库对象")
public class SvyLibScriptTag extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "自增ID")
    private Long id;

    /**
     * æ ‡ç­¾åˆ†ç±»ID
     */
    @ApiModelProperty(value = "标签分类ID")
    private Long tagcategoryid;

    /**
     * ivr_liba_script çš„主键
     */
    @ApiModelProperty(value = "ivr_liba_script çš„主键")
    private Long scriptid;

    /**
     * æ ‡ç­¾ID
     */
    @ApiModelProperty(value = "标签ID")
    private Long tagid;

    /**
     * æ ‡ç­¾å
     */
    @ApiModelProperty(value = "标签名")
    private String tagname;

    /**
     * æœºæž„ID
     */
    @ApiModelProperty(value = "机构ID")
    private String orgid;

    /**
     * åˆ é™¤æ ‡å¿—（0：未删除 1：已删除）
     */
    @ApiModelProperty(value = "删除标志（0：未删除 1：已删除）")
    private String delFlag;

    /**
     * ä¸Šä¼ æ ‡å¿—（0：未上传 1：已上传）
     */
    @ApiModelProperty(value = "上传标志")
    private Long isupload;

    /**
     * ä¸Šä¼ æ—¶é—´
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @ApiModelProperty(value = "上传时间")
    private Date uploadTime;

    /**
     * çˆ¶ID
     */
    @ApiModelProperty(value = "父ID")
    private Long pid;

    /**
     * GUID
     */
    @ApiModelProperty(value = "GUID")
    private String guid;

    /**
     * æ˜¯å¦å­˜åœ¨æ“ä½œï¼š1 æ–°å¢ž 2修改 3删除
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;

}

 smartor/src/main/java/com/smartor/domain/SvyLibTemplate.java

@@ -170,6 +170,7 @@
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;
    
    /**
     * ç§‘室名称
     */
@@ -182,7 +183,7 @@
     */
    @Excel(name = "标签信息")
    @ApiModelProperty("标签信息")
    private String labelInfo = "";
    private List<SvyLibTemplateTag> svyLibTemplateTagList;

    /**
     * é™¢åŒº

 smartor/src/main/java/com/smartor/domain/SvyLibTemplateTag.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,92 @@
package com.smartor.domain;

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * æ¨¡æ¿æ ‡ç­¾å¯¹è±¡ svy_lib_template_tag
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Data
@ApiModel(value = "SvyLibTemplateTag", description = "模板标签对象")
public class SvyLibTemplateTag extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty(value = "主键")
    private Long id;

    /**
     * æ ‡ç­¾åˆ†ç±»ID
     */
    @ApiModelProperty(value = "标签分类ID")
    private Long tagcategoryid;

    /**
     * æ¨¡æ¿ID
     */
    @ApiModelProperty(value = "模板ID")
    private Long templateid;

    /**
     * æ ‡ç­¾ID
     */
    @ApiModelProperty(value = "标签ID")
    private Long tagid;

    /**
     * æ ‡ç­¾å
     */
    @ApiModelProperty(value = "标签名")
    private String tagname;

    /**
     * æœºæž„ID
     */
    @ApiModelProperty(value = "机构ID")
    private String orgid;

    /**
     * åˆ é™¤æ ‡å¿—（0：未删除 1：已删除）
     */
    @ApiModelProperty(value = "删除标志（0：未删除 1：已删除）")
    private String delFlag;

    /**
     * ä¸Šä¼ æ ‡å¿—（0：未上传 1：已上传）
     */
    @ApiModelProperty(value = "上传标志")
    private Long isupload;

    /**
     * ä¸Šä¼ æ—¶é—´
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @ApiModelProperty(value = "上传时间")
    private Date uploadTime;

    /**
     * çˆ¶ID
     */
    @ApiModelProperty(value = "父ID")
    private Long pid;

    /**
     * GUID
     */
    @ApiModelProperty(value = "GUID")
    private String guid;

}

 smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoption.java

@@ -244,6 +244,12 @@
    private Integer nextQuestion;

    /**
     * ä¸‹ä¸€é¢˜
     */
    @ApiModelProperty(value = "选项编号")
    private Long optionNo;

    /**
     * é€‰é¡¹å›¾ç‰‡è·¯å¾„
     */
    @ApiModelProperty(value = "选项图片路径")

 smartor/src/main/java/com/smartor/mapper/SvyLibScriptTagMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,64 @@
package com.smartor.mapper;

import com.smartor.domain.SvyLibScriptTag;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * é—®é¢˜è¯æœ¯æ ‡ç­¾åº“Mapper接口
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Mapper
public interface SvyLibScriptTagMapper
{
    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param id é—®é¢˜è¯æœ¯æ ‡ç­¾åº“主键
     * @return é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    public SvyLibScriptTag selectSvyLibScriptTagById(Long id);

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“列表
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return é—®é¢˜è¯æœ¯æ ‡ç­¾åº“集合
     */
    public List<SvyLibScriptTag> selectSvyLibScriptTagList(SvyLibScriptTag svyLibScriptTag);

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return ç»“æžœ
     */
    public int insertSvyLibScriptTag(SvyLibScriptTag svyLibScriptTag);

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return ç»“æžœ
     */
    public int updateSvyLibScriptTag(SvyLibScriptTag svyLibScriptTag);

    /**
     * åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param id é—®é¢˜è¯æœ¯æ ‡ç­¾åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyLibScriptTagById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibScriptTagByIds(Long[] ids);
}

 smartor/src/main/java/com/smartor/mapper/SvyLibTemplateTagMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,64 @@
package com.smartor.mapper;

import com.smartor.domain.SvyLibTemplateTag;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * æ¨¡æ¿æ ‡ç­¾Mapper接口
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Mapper
public interface SvyLibTemplateTagMapper
{
    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾
     *
     * @param id æ¨¡æ¿æ ‡ç­¾ä¸»é”®
     * @return æ¨¡æ¿æ ‡ç­¾
     */
    public SvyLibTemplateTag selectSvyLibTemplateTagById(Long id);

    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾åˆ—表
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return æ¨¡æ¿æ ‡ç­¾é›†åˆ
     */
    public List<SvyLibTemplateTag> selectSvyLibTemplateTagList(SvyLibTemplateTag svyLibTemplateTag);

    /**
     * æ–°å¢žæ¨¡æ¿æ ‡ç­¾
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateTag(SvyLibTemplateTag svyLibTemplateTag);

    /**
     * ä¿®æ”¹æ¨¡æ¿æ ‡ç­¾
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateTag(SvyLibTemplateTag svyLibTemplateTag);

    /**
     * åˆ é™¤æ¨¡æ¿æ ‡ç­¾
     *
     * @param id æ¨¡æ¿æ ‡ç­¾ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTagById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿æ ‡ç­¾
     *
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTagByIds(Long[] ids);
}

 smartor/src/main/java/com/smartor/service/ISvyLibScriptTagService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.smartor.service;

import com.smartor.domain.SvyLibScriptTag;

import java.util.List;

/**
 * é—®é¢˜è¯æœ¯æ ‡ç­¾åº“Service接口
 *
 * @author ruoyi
 * @date 2024-07-24
 */
public interface ISvyLibScriptTagService {
    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param id é—®é¢˜è¯æœ¯æ ‡ç­¾åº“主键
     * @return é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    public SvyLibScriptTag selectSvyLibScriptTagById(Long id);

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“列表
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return é—®é¢˜è¯æœ¯æ ‡ç­¾åº“集合
     */
    public List<SvyLibScriptTag> selectSvyLibScriptTagList(SvyLibScriptTag svyLibScriptTag);

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return ç»“æžœ
     */
    public int insertSvyLibScriptTag(SvyLibScriptTag svyLibScriptTag);

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return ç»“æžœ
     */
    public int updateSvyLibScriptTag(SvyLibScriptTag svyLibScriptTag);

    /**
     * æ‰¹é‡åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„问题话术标签库主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibScriptTagByIds(Long[] ids);

    /**
     * åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“信息
     *
     * @param id é—®é¢˜è¯æœ¯æ ‡ç­¾åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyLibScriptTagById(Long id);
}

 smartor/src/main/java/com/smartor/service/ISvyLibTemplateTagService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.smartor.service;

import com.smartor.domain.SvyLibTemplateTag;

import java.util.List;

/**
 * æ¨¡æ¿æ ‡ç­¾Service接口
 *
 * @author ruoyi
 * @date 2024-07-24
 */
public interface ISvyLibTemplateTagService
{
    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾
     *
     * @param id æ¨¡æ¿æ ‡ç­¾ä¸»é”®
     * @return æ¨¡æ¿æ ‡ç­¾
     */
    public SvyLibTemplateTag selectSvyLibTemplateTagById(Long id);

    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾åˆ—表
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return æ¨¡æ¿æ ‡ç­¾é›†åˆ
     */
    public List<SvyLibTemplateTag> selectSvyLibTemplateTagList(SvyLibTemplateTag svyLibTemplateTag);

    /**
     * æ–°å¢žæ¨¡æ¿æ ‡ç­¾
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateTag(SvyLibTemplateTag svyLibTemplateTag);

    /**
     * ä¿®æ”¹æ¨¡æ¿æ ‡ç­¾
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateTag(SvyLibTemplateTag svyLibTemplateTag);

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿æ ‡ç­¾
     *
     * @param ids éœ€è¦åˆ é™¤çš„模板标签主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTagByIds(Long[] ids);

    /**
     * åˆ é™¤æ¨¡æ¿æ ‡ç­¾ä¿¡æ¯
     *
     * @param id æ¨¡æ¿æ ‡ç­¾ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTagById(Long id);
}

 smartor/src/main/java/com/smartor/service/impl/SvyLibScriptServiceImpl.java

@@ -6,8 +6,10 @@
import com.ruoyi.common.utils.StringUtils;
import com.smartor.domain.SvyLibScript;
import com.smartor.domain.SvyLibScriptOption;
import com.smartor.domain.SvyLibScriptTag;
import com.smartor.mapper.SvyLibScriptMapper;
import com.smartor.mapper.SvyLibScriptOptionMapper;
import com.smartor.mapper.SvyLibScriptTagMapper;
import com.smartor.service.ISvyLibScriptService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections4.CollectionUtils;
@@ -34,6 +36,9 @@
    @Autowired
    private SvyLibScriptOptionMapper svyLibScriptOptionMapper;

    @Autowired
    private SvyLibScriptTagMapper svyLibScriptTagMapper;

    /**
     * æŸ¥è¯¢é—®å·é¢˜ç›®
     *
@@ -55,7 +60,6 @@
    public List<SvyLibScript> selectSvyLibScriptList(SvyLibScript svyLibTopic) {
        List<SvyLibScript> svyLibScripts = svyLibTopicMapper.selectSvyLibScriptList(svyLibTopic);
        //获取题目选项

        for (int j = 0; j < svyLibScripts.size(); j++) {
            log.info("问题id为：{}", svyLibScripts.get(j).getId());
            if (StringUtils.isNotEmpty(svyLibScripts.get(j).getIcd10Name()))
@@ -71,6 +75,11 @@
                //将查询出的选项目放到题目中
                svyLibScripts.get(j).setSvyLibScriptOptions(svyLibTopicoptions);
            }
            //获取tag
            SvyLibScriptTag svyLibScriptTag = new SvyLibScriptTag();
            svyLibScriptTag.setScriptid(svyLibScripts.get(j).getId());
            List<SvyLibScriptTag> svyLibScriptTags = svyLibScriptTagMapper.selectSvyLibScriptTagList(svyLibScriptTag);
            svyLibScripts.get(j).setSvyLibScriptTagList(svyLibScriptTags);
        }
        return svyLibScripts;
    }
@@ -124,6 +133,25 @@
                }
            }
        }
        //标签处理
        if (CollectionUtils.isNotEmpty(svyLibTopic.getSvyLibScriptTagList())) {
            for (SvyLibScriptTag svyLibScriptTag : svyLibTopic.getSvyLibScriptTagList()) {
                if (svyLibScriptTag.getIsoperation() != null && svyLibScriptTag.getIsoperation() == 1) {
                    //新增
                    svyLibScriptTag.setScriptid(svyLibTopic.getId());
                    svyLibScriptTag.setCreateTime(new Date());
                    svyLibScriptTagMapper.insertSvyLibScriptTag(svyLibScriptTag);
                } else if (svyLibScriptTag.getIsoperation() != null && svyLibScriptTag.getIsoperation() == 2) {
                    //修改
                    svyLibScriptTag.setScriptid(svyLibTopic.getId());
                    svyLibScriptTag.setUpdateTime(new Date());
                    svyLibScriptTagMapper.updateSvyLibScriptTag(svyLibScriptTag);
                } else if (svyLibScriptTag.getIsoperation() != null && svyLibScriptTag.getIsoperation() == 3) {
                    //删除
                    svyLibScriptTagMapper.deleteSvyLibScriptTagById(svyLibScriptTag.getId());
                }
            }
        }
        return i;
    }


 smartor/src/main/java/com/smartor/service/impl/SvyLibScriptTagServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.smartor.service.impl;

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyLibScriptTag;
import com.smartor.mapper.SvyLibScriptTagMapper;
import com.smartor.service.ISvyLibScriptTagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * é—®é¢˜è¯æœ¯æ ‡ç­¾åº“Service业务层处理
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Service
public class SvyLibScriptTagServiceImpl implements ISvyLibScriptTagService
{
    @Autowired
    private SvyLibScriptTagMapper svyLibScriptTagMapper;

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param id é—®é¢˜è¯æœ¯æ ‡ç­¾åº“主键
     * @return é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    @Override
    public SvyLibScriptTag selectSvyLibScriptTagById(Long id)
    {
        return svyLibScriptTagMapper.selectSvyLibScriptTagById(id);
    }

    /**
     * æŸ¥è¯¢é—®é¢˜è¯æœ¯æ ‡ç­¾åº“列表
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     */
    @Override
    public List<SvyLibScriptTag> selectSvyLibScriptTagList(SvyLibScriptTag svyLibScriptTag)
    {
        return svyLibScriptTagMapper.selectSvyLibScriptTagList(svyLibScriptTag);
    }

    /**
     * æ–°å¢žé—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyLibScriptTag(SvyLibScriptTag svyLibScriptTag)
    {
        svyLibScriptTag.setCreateTime(DateUtils.getNowDate());
        return svyLibScriptTagMapper.insertSvyLibScriptTag(svyLibScriptTag);
    }

    /**
     * ä¿®æ”¹é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param svyLibScriptTag é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyLibScriptTag(SvyLibScriptTag svyLibScriptTag)
    {
        svyLibScriptTag.setUpdateTime(DateUtils.getNowDate());
        return svyLibScriptTagMapper.updateSvyLibScriptTag(svyLibScriptTag);
    }

    /**
     * æ‰¹é‡åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„问题话术标签库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibScriptTagByIds(Long[] ids)
    {
        return svyLibScriptTagMapper.deleteSvyLibScriptTagByIds(ids);
    }

    /**
     * åˆ é™¤é—®é¢˜è¯æœ¯æ ‡ç­¾åº“信息
     *
     * @param id é—®é¢˜è¯æœ¯æ ‡ç­¾åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibScriptTagById(Long id)
    {
        return svyLibScriptTagMapper.deleteSvyLibScriptTagById(id);
    }
}

 smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateServiceImpl.java

@@ -35,6 +35,8 @@
    private SvyLibTemplateTargetoptionMapper svyLibTemplateTargetoptionMapper;
    @Autowired
    private TempDetpRelevanceMapper tempDetpRelevanceMapper;
    @Autowired
    private SvyLibTemplateTagMapper svyLibTemplateTagMapper;

    /**
     * æŸ¥è¯¢é—®å·
@@ -84,6 +86,12 @@
            tempDetpRelevance.setTempid(svyLibTemplates.get(i).getSvyid());
            List<TempDetpRelevance> tempDetpRelevances = tempDetpRelevanceMapper.selectTempDetpRelevanceList(tempDetpRelevance);
            svyLibTemplates.get(i).setTempDetpRelevances(CollectionUtils.isNotEmpty(tempDetpRelevances) ? tempDetpRelevances : new ArrayList<>());

            //获取标签
            SvyLibTemplateTag svyLibTemplateTag = new SvyLibTemplateTag();
            svyLibTemplateTag.setTemplateid(svyLibTemplates.get(i).getSvyid());
            List<SvyLibTemplateTag> svyLibTemplateTags = svyLibTemplateTagMapper.selectSvyLibTemplateTagList(svyLibTemplateTag);
            svyLibTemplates.get(i).setSvyLibTemplateTagList(svyLibTemplateTags);
        }

        //先将相同的id的icdname,整理到一块
@@ -170,6 +178,21 @@
            }

        }

        //标签处理
        if (CollectionUtils.isNotEmpty(svyLibTemplate.getSvyLibTemplateTagList())) {
            for (SvyLibTemplateTag svyLibTemplateTag : svyLibTemplate.getSvyLibTemplateTagList()) {
                if (svyLibTemplateTag.getId() == null) {
                    //新增
                    svyLibTemplateTag.setTemplateid(svyLibTemplate.getSvyid());
                    svyLibTemplateTagMapper.insertSvyLibTemplateTag(svyLibTemplateTag);
                } else {
                    svyLibTemplateTag.setTemplateid(svyLibTemplate.getSvyid());
                    svyLibTemplateTagMapper.updateSvyLibTemplateTag(svyLibTemplateTag);
                }
            }

        }
        return i;
    }


 smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateTagServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.smartor.service.impl;

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyLibTemplateTag;
import com.smartor.mapper.SvyLibTemplateTagMapper;
import com.smartor.service.ISvyLibTemplateTagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * æ¨¡æ¿æ ‡ç­¾Service业务层处理
 *
 * @author ruoyi
 * @date 2024-07-24
 */
@Service
public class SvyLibTemplateTagServiceImpl implements ISvyLibTemplateTagService
{
    @Autowired
    private SvyLibTemplateTagMapper svyLibTemplateTagMapper;

    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾
     *
     * @param id æ¨¡æ¿æ ‡ç­¾ä¸»é”®
     * @return æ¨¡æ¿æ ‡ç­¾
     */
    @Override
    public SvyLibTemplateTag selectSvyLibTemplateTagById(Long id)
    {
        return svyLibTemplateTagMapper.selectSvyLibTemplateTagById(id);
    }

    /**
     * æŸ¥è¯¢æ¨¡æ¿æ ‡ç­¾åˆ—表
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return æ¨¡æ¿æ ‡ç­¾
     */
    @Override
    public List<SvyLibTemplateTag> selectSvyLibTemplateTagList(SvyLibTemplateTag svyLibTemplateTag)
    {
        return svyLibTemplateTagMapper.selectSvyLibTemplateTagList(svyLibTemplateTag);
    }

    /**
     * æ–°å¢žæ¨¡æ¿æ ‡ç­¾
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyLibTemplateTag(SvyLibTemplateTag svyLibTemplateTag)
    {
        svyLibTemplateTag.setCreateTime(DateUtils.getNowDate());
        return svyLibTemplateTagMapper.insertSvyLibTemplateTag(svyLibTemplateTag);
    }

    /**
     * ä¿®æ”¹æ¨¡æ¿æ ‡ç­¾
     *
     * @param svyLibTemplateTag æ¨¡æ¿æ ‡ç­¾
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyLibTemplateTag(SvyLibTemplateTag svyLibTemplateTag)
    {
        svyLibTemplateTag.setUpdateTime(DateUtils.getNowDate());
        return svyLibTemplateTagMapper.updateSvyLibTemplateTag(svyLibTemplateTag);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿æ ‡ç­¾
     *
     * @param ids éœ€è¦åˆ é™¤çš„模板标签主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateTagByIds(Long[] ids)
    {
        return svyLibTemplateTagMapper.deleteSvyLibTemplateTagByIds(ids);
    }

    /**
     * åˆ é™¤æ¨¡æ¿æ ‡ç­¾ä¿¡æ¯
     *
     * @param id æ¨¡æ¿æ ‡ç­¾ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateTagById(Long id)
    {
        return svyLibTemplateTagMapper.deleteSvyLibTemplateTagById(id);
    }
}

 smartor/src/main/resources/mapper/smartor/BaseTagcategoryMapper.xml

@@ -120,16 +120,6 @@
    <select id="baseTagCategoryByName" parameterType="java.lang.String"
            resultType="com.smartor.domain.BaseTagcategory">
        select a.tagcategoryid,
        a.orgid,
        a.update_by,
        a.update_time,
        a.pym,
        a.wbm,
        a.del_flag,
        a.create_by,
        a.create_time,
        a.isupload,
        a.upload_time,
        a.categoryname,
        count(b.tagid) as tagNum
        from base_tagcategory a left join base_tag b
@@ -139,6 +129,6 @@
                '%')
            </if>
        </where>
        GROUP BY a.categoryname
        GROUP BY a.tagcategoryid,a.categoryname
    </select>
</mapper>
</mapper>

 smartor/src/main/resources/mapper/smartor/SvyLibScriptTagMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,136 @@
<?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="com.smartor.mapper.SvyLibScriptTagMapper">

    <resultMap type="com.smartor.domain.SvyLibScriptTag" id="SvyLibScriptTagResult">
        <result property="id" column="id"/>
        <result property="tagcategoryid" column="tagcategoryid"/>
        <result property="scriptid" column="scriptid"/>
        <result property="tagid" column="tagid"/>
        <result property="tagname" column="tagname"/>
        <result property="orgid" column="orgid"/>
        <result property="delFlag" column="del_flag"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
        <result property="createBy" column="create_by"/>
        <result property="createTime" column="create_time"/>
        <result property="isupload" column="isupload"/>
        <result property="uploadTime" column="upload_time"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
    </resultMap>

    <sql id="selectSvyLibScriptTagVo">
        select id,
               tagcategoryid,
               scriptid,
               tagid,
               tagname,
               orgid,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               pid,
               guid
        from svy_lib_script_tag
    </sql>

    <select id="selectSvyLibScriptTagList" parameterType="com.smartor.domain.SvyLibScriptTag"
            resultMap="SvyLibScriptTagResult">
        <include refid="selectSvyLibScriptTagVo"/>
        <where>
            <if test="tagcategoryid != null ">and tagcategoryid = #{tagcategoryid}</if>
            <if test="scriptid != null ">and scriptid = #{scriptid}</if>
            <if test="tagid != null ">and tagid = #{tagid}</if>
            <if test="tagname != null  and tagname != ''">and tagname like concat('%', #{tagname}, '%')</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
        </where>
    </select>

    <select id="selectSvyLibScriptTagById" parameterType="Long" resultMap="SvyLibScriptTagResult">
        <include refid="selectSvyLibScriptTagVo"/>
        where id = #{id}
    </select>

    <insert id="insertSvyLibScriptTag" parameterType="com.smartor.domain.SvyLibScriptTag">
        insert into svy_lib_script_tag
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="tagcategoryid != null">tagcategoryid,</if>
            <if test="scriptid != null">scriptid,</if>
            <if test="tagid != null">tagid,</if>
            <if test="tagname != null">tagname,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="tagcategoryid != null">#{tagcategoryid},</if>
            <if test="scriptid != null">#{scriptid},</if>
            <if test="tagid != null">#{tagid},</if>
            <if test="tagname != null">#{tagname},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
        </trim>
    </insert>

    <update id="updateSvyLibScriptTag" parameterType="com.smartor.domain.SvyLibScriptTag">
        update svy_lib_script_tag
        <trim prefix="SET" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid = #{tagcategoryid},</if>
            <if test="scriptid != null">scriptid = #{scriptid},</if>
            <if test="tagid != null">tagid = #{tagid},</if>
            <if test="tagname != null">tagname = #{tagname},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteSvyLibScriptTagById" parameterType="Long">
        delete
        from svy_lib_script_tag
        where id = #{id}
    </delete>

    <delete id="deleteSvyLibScriptTagByIds" parameterType="String">
        delete from svy_lib_script_tag where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 smartor/src/main/resources/mapper/smartor/SvyLibTemplateMapper.xml

@@ -27,7 +27,6 @@
        <result property="isupload" column="isupload"/>
        <result property="uploadTime" column="upload_time"/>
        <result property="deptNames" column="dept_names"/>
        <result property="labelInfo" column="label_info"/>
        <result property="campus" column="campus"/>
        <result property="suitway" column="suitway"/>
        <result property="otherdata" column="otherdata"/>
@@ -63,7 +62,6 @@
               isupload,
               upload_time,
               dept_names,
               label_info,
               campus,
               suitway,
               script_score,
@@ -97,7 +95,6 @@
        a.upload_time,
        a.dept_names,
        a.value_type,
        a.label_info,
        a.reply,
        a.campus,
        a.suitway,
@@ -151,7 +148,6 @@
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="deptNames != null">dept_names,</if>
            <if test="labelInfo != null">label_info,</if>
            <if test="campus != null">campus,</if>
            <if test="suitway != null">suitway,</if>
            <if test="otherdata != null">otherdata,</if>
@@ -182,7 +178,6 @@
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="deptNames != null">#{deptNames},</if>
            <if test="labelInfo != null">#{labelInfo},</if>
            <if test="campus != null">#{campus},</if>
            <if test="suitway != null">#{suitway},</if>
            <if test="otherdata != null">#{otherdata},</if>
@@ -217,7 +212,6 @@
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="deptNames != null">dept_names=#{deptNames},</if>
            <if test="labelInfo != null">label_info=#{labelInfo},</if>
            <if test="campus != null">campus=#{campus},</if>
            <if test="suitway != null">suitway=#{suitway},</if>
            <if test="otherdata != null">otherdata=#{otherdata},</if>

 smartor/src/main/resources/mapper/smartor/SvyLibTemplateTagMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,135 @@
<?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="com.smartor.mapper.SvyLibTemplateTagMapper">

    <resultMap type="com.smartor.domain.SvyLibTemplateTag" id="SvyLibTemplateTagResult">
        <result property="id" column="id"/>
        <result property="tagcategoryid" column="tagcategoryid"/>
        <result property="templateid" column="templateid"/>
        <result property="tagid" column="tagid"/>
        <result property="tagname" column="tagname"/>
        <result property="orgid" column="orgid"/>
        <result property="delFlag" column="del_flag"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
        <result property="createBy" column="create_by"/>
        <result property="createTime" column="create_time"/>
        <result property="isupload" column="isupload"/>
        <result property="uploadTime" column="upload_time"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
    </resultMap>

    <sql id="selectSvyLibTemplateTagVo">
        select id,
               tagcategoryid,
               templateid,
               tagid,
               tagname,
               orgid,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               pid,
               guid
        from svy_lib_template_tag
    </sql>

    <select id="selectSvyLibTemplateTagList" parameterType="com.smartor.domain.SvyLibTemplateTag"
            resultMap="SvyLibTemplateTagResult">
        <include refid="selectSvyLibTemplateTagVo"/>
        <where>
            <if test="tagcategoryid != null ">and tagcategoryid = #{tagcategoryid}</if>
            <if test="templateid != null ">and templateid = #{templateid}</if>
            <if test="tagid != null ">and tagid = #{tagid}</if>
            <if test="tagname != null  and tagname != ''">and tagname like concat('%', #{tagname}, '%')</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
        </where>
    </select>

    <select id="selectSvyLibTemplateTagById" parameterType="Long" resultMap="SvyLibTemplateTagResult">
        <include refid="selectSvyLibTemplateTagVo"/>
        where id = #{id}
    </select>

    <insert id="insertSvyLibTemplateTag" parameterType="com.smartor.domain.SvyLibTemplateTag" useGeneratedKeys="true"
            keyProperty="id">
        insert into svy_lib_template_tag
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid,</if>
            <if test="templateid != null">templateid,</if>
            <if test="tagid != null">tagid,</if>
            <if test="tagname != null">tagname,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">#{tagcategoryid},</if>
            <if test="templateid != null">#{templateid},</if>
            <if test="tagid != null">#{tagid},</if>
            <if test="tagname != null">#{tagname},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
        </trim>
    </insert>

    <update id="updateSvyLibTemplateTag" parameterType="com.smartor.domain.SvyLibTemplateTag">
        update svy_lib_template_tag
        <trim prefix="SET" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid = #{tagcategoryid},</if>
            <if test="templateid != null">templateid = #{templateid},</if>
            <if test="tagid != null">tagid = #{tagid},</if>
            <if test="tagname != null">tagname = #{tagname},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteSvyLibTemplateTagById" parameterType="Long">
        delete
        from svy_lib_template_tag
        where id = #{id}
    </delete>

    <delete id="deleteSvyLibTemplateTagByIds" parameterType="String">
        delete from svy_lib_template_tag where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>