代码提交

liusheng

2024-07-09 9c8c9675325a22c69ac113ab26f9285b60582ae1

代码提交

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateScriptWjxController.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.SvyLibTemplateScriptWjx;
import com.smartor.service.ISvyLibTemplateScriptWjxService;
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-08
 */
@RestController
@RequestMapping("/smartor/srcriptwjx")
public class SvyLibTemplateScriptWjxController extends BaseController
{
    @Autowired
    private ISvyLibTemplateScriptWjxService svyLibTemplateScriptWjxService;

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx)
    {
        startPage();
        List<SvyLibTemplateScriptWjx> list = svyLibTemplateScriptWjxService.selectSvyLibTemplateScriptWjxList(svyLibTemplateScriptWjx);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ¨¡æ¿é—®å·é¢˜ç›®åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:export')")
    @Log(title = "模板问卷题目", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyLibTemplateScriptWjx svyLibTemplateScriptWjx)
    {
        List<SvyLibTemplateScriptWjx> list = svyLibTemplateScriptWjxService.selectSvyLibTemplateScriptWjxList(svyLibTemplateScriptWjx);
        ExcelUtil<SvyLibTemplateScriptWjx> util = new ExcelUtil<SvyLibTemplateScriptWjx>(SvyLibTemplateScriptWjx.class);
        util.exportExcel(response, list, "模板问卷题目数据");
    }

    /**
     * èŽ·å–模板问卷题目详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(svyLibTemplateScriptWjxService.selectSvyLibTemplateScriptWjxById(id));
    }

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·é¢˜ç›®
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:add')")
    @Log(title = "模板问卷题目", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyLibTemplateScriptWjx svyLibTemplateScriptWjx)
    {
        return toAjax(svyLibTemplateScriptWjxService.insertSvyLibTemplateScriptWjx(svyLibTemplateScriptWjx));
    }

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·é¢˜ç›®
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:edit')")
    @Log(title = "模板问卷题目", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyLibTemplateScriptWjx svyLibTemplateScriptWjx)
    {
        return toAjax(svyLibTemplateScriptWjxService.updateSvyLibTemplateScriptWjx(svyLibTemplateScriptWjx));
    }

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·é¢˜ç›®
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:remove')")
    @Log(title = "模板问卷题目", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(svyLibTemplateScriptWjxService.deleteSvyLibTemplateScriptWjxByIds(ids));
    }
}

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateTargetoptionWjxController.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.SvyLibTemplateTargetoptionWjx;
import com.smartor.service.ISvyLibTemplateTargetoptionWjxService;
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-08
 */
@RestController
@RequestMapping("/smartor/optionwjx")
public class SvyLibTemplateTargetoptionWjxController extends BaseController
{
    @Autowired
    private ISvyLibTemplateTargetoptionWjxService svyLibTemplateTargetoptionWjxService;

    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        startPage();
        List<SvyLibTemplateTargetoptionWjx> list = svyLibTemplateTargetoptionWjxService.selectSvyLibTemplateTargetoptionWjxList(svyLibTemplateTargetoptionWjx);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“列表
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:export')")
    @Log(title = "问卷问题指标选项库", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        List<SvyLibTemplateTargetoptionWjx> list = svyLibTemplateTargetoptionWjxService.selectSvyLibTemplateTargetoptionWjxList(svyLibTemplateTargetoptionWjx);
        ExcelUtil<SvyLibTemplateTargetoptionWjx> util = new ExcelUtil<SvyLibTemplateTargetoptionWjx>(SvyLibTemplateTargetoptionWjx.class);
        util.exportExcel(response, list, "问卷问题指标选项库数据");
    }

    /**
     * èŽ·å–问卷问题指标选项库详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(svyLibTemplateTargetoptionWjxService.selectSvyLibTemplateTargetoptionWjxById(id));
    }

    /**
     * æ–°å¢žé—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:add')")
    @Log(title = "问卷问题指标选项库", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        return toAjax(svyLibTemplateTargetoptionWjxService.insertSvyLibTemplateTargetoptionWjx(svyLibTemplateTargetoptionWjx));
    }

    /**
     * ä¿®æ”¹é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:edit')")
    @Log(title = "问卷问题指标选项库", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        return toAjax(svyLibTemplateTargetoptionWjxService.updateSvyLibTemplateTargetoptionWjx(svyLibTemplateTargetoptionWjx));
    }

    /**
     * åˆ é™¤é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:remove')")
    @Log(title = "问卷问题指标选项库", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(svyLibTemplateTargetoptionWjxService.deleteSvyLibTemplateTargetoptionWjxByIds(ids));
    }
}

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateWjxController.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.SvyLibTemplateWjx;
import com.smartor.service.ISvyLibTemplateWjxService;
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-08
 */
@RestController
@RequestMapping("/smartor/templatewjx")
public class SvyLibTemplateWjxController extends BaseController
{
    @Autowired
    private ISvyLibTemplateWjxService svyLibTemplateWjxService;

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:list')")
    @GetMapping("/list")
    public TableDataInfo list(SvyLibTemplateWjx svyLibTemplateWjx)
    {
        startPage();
        List<SvyLibTemplateWjx> list = svyLibTemplateWjxService.selectSvyLibTemplateWjxList(svyLibTemplateWjx);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ¨¡æ¿é—®å·åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:export')")
    @Log(title = "模板问卷", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, SvyLibTemplateWjx svyLibTemplateWjx)
    {
        List<SvyLibTemplateWjx> list = svyLibTemplateWjxService.selectSvyLibTemplateWjxList(svyLibTemplateWjx);
        ExcelUtil<SvyLibTemplateWjx> util = new ExcelUtil<SvyLibTemplateWjx>(SvyLibTemplateWjx.class);
        util.exportExcel(response, list, "模板问卷数据");
    }

    /**
     * èŽ·å–模板问卷详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:query')")
    @GetMapping(value = "/{svyid}")
    public AjaxResult getInfo(@PathVariable("svyid") Long svyid)
    {
        return success(svyLibTemplateWjxService.selectSvyLibTemplateWjxBySvyid(svyid));
    }

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:add')")
    @Log(title = "模板问卷", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody SvyLibTemplateWjx svyLibTemplateWjx)
    {
        return toAjax(svyLibTemplateWjxService.insertSvyLibTemplateWjx(svyLibTemplateWjx));
    }

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:edit')")
    @Log(title = "模板问卷", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody SvyLibTemplateWjx svyLibTemplateWjx)
    {
        return toAjax(svyLibTemplateWjxService.updateSvyLibTemplateWjx(svyLibTemplateWjx));
    }

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·
     */
    @PreAuthorize("@ss.hasPermi('system:wjx:remove')")
    @Log(title = "模板问卷", businessType = BusinessType.DELETE)
    @DeleteMapping("/{svyids}")
    public AjaxResult remove(@PathVariable Long[] svyids)
    {
        return toAjax(svyLibTemplateWjxService.deleteSvyLibTemplateWjxBySvyids(svyids));
    }
}

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

@@ -20,6 +20,8 @@
 * @author ruoyi
 * @date 2023-12-21
 */

@Data
@ApiModel(value = "IvrLibaScriptTargetoption", description = "问题话术指标选项库对象")
public class IvrLibaScriptTargetoption extends BaseEntity {
    private static final long serialVersionUID = 1L;
@@ -194,225 +196,16 @@
    @Excel(name = "GUID")
    private String guid;

    @ApiModelProperty(value = "选项附加标识")
    private String appendflag;

    @ApiModelProperty(value = "附件信息")
    private String appenddesc;

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

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Long getTargetid() {
        return targetid;
    }

    public void setTargetid(Long targetid) {
        this.targetid = targetid;
    }

    public String getTargetname() {
        return targetname;
    }

    public void setTargetname(String targetname) {
        this.targetname = targetname;
    }

    public Long getScriptid() {
        return scriptid;
    }

    public void setScriptid(Long scriptid) {
        this.scriptid = scriptid;
    }

    public String getTargettype() {
        return targettype;
    }

    public void setTargettype(String targettype) {
        this.targettype = targettype;
    }

    public String getCategoryName() {
        return categoryName;
    }

    public void setCategoryName(String categoryName) {
        this.categoryName = categoryName;
    }

    public String getTargetvalue() {
        return targetvalue;
    }

    public void setTargetvalue(String targetvalue) {
        this.targetvalue = targetvalue;
    }

    public String getTargetregex() {
        return targetregex;
    }

    public void setTargetregex(String targetregex) {
        this.targetregex = targetregex;
    }

    public String getTargetregex2() {
        return targetregex2;
    }

    public void setTargetregex2(String targetregex2) {
        this.targetregex2 = targetregex2;
    }

    public String getNodynamiccruxsJson() {
        return nodynamiccruxsJson;
    }

    public void setNodynamiccruxsJson(String nodynamiccruxsJson) {
        this.nodynamiccruxsJson = nodynamiccruxsJson;
    }

    public String getDynamiccruxsJson() {
        return dynamiccruxsJson;
    }

    public void setDynamiccruxsJson(String dynamiccruxsJson) {
        this.dynamiccruxsJson = dynamiccruxsJson;
    }

    public List<String> getNodynamiccruxs() {
        return nodynamiccruxs;
    }

    public void setNodynamiccruxs(List<String> nodynamiccruxs) {
        this.nodynamiccruxs = nodynamiccruxs;
    }

    public List<String> getDynamiccruxs() {
        return dynamiccruxs;
    }

    public void setDynamiccruxs(List<String> dynamiccruxs) {
        this.dynamiccruxs = dynamiccruxs;
    }

    public String getOptiondesc() {
        return optiondesc;
    }

    public void setOptiondesc(String optiondesc) {
        this.optiondesc = optiondesc;
    }

    public String getLanguage() {
        return language;
    }

    public void setLanguage(String language) {
        this.language = language;
    }

    public Long getVersion() {
        return version;
    }

    public void setVersion(Long version) {
        this.version = version;
    }

    public String getGroupid() {
        return groupid;
    }

    public void setGroupid(String groupid) {
        this.groupid = groupid;
    }

    public Long getIsabnormal() {
        return isabnormal;
    }

    public void setIsabnormal(Long isabnormal) {
        this.isabnormal = isabnormal;
    }

    public Long getWarnup() {
        return warnup;
    }

    public void setWarnup(Long warnup) {
        this.warnup = warnup;
    }

    public Long getWarndown() {
        return warndown;
    }

    public void setWarndown(Long warndown) {
        this.warndown = warndown;
    }

    public String getDelFlag() {
        return delFlag;
    }

    public void setDelFlag(String delFlag) {
        this.delFlag = delFlag;
    }

    public Long getIsupload() {
        return isupload;
    }

    public void setIsupload(Long isupload) {
        this.isupload = isupload;
    }

    public Date getUploadTime() {
        return uploadTime;
    }

    public void setUploadTime(Date uploadTime) {
        this.uploadTime = uploadTime;
    }

    public String getOrgid() {
        return orgid;
    }

    public void setOrgid(String orgid) {
        this.orgid = orgid;
    }

    public Long getPid() {
        return pid;
    }

    public void setPid(Long pid) {
        this.pid = pid;
    }

    public String getGuid() {
        return guid;
    }

    public void setGuid(String guid) {
        this.guid = guid;
    }

    public Integer getIsoperation() {
        return isoperation;
    }

    public void setIsoperation(Integer isoperation) {
        this.isoperation = isoperation;
    }
}

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

@@ -168,6 +168,12 @@

    @ApiModelProperty(value = "总条数")
    private Integer allitems;

    @ApiModelProperty(value = "选项附加标识")
    private String appendflag;

    @ApiModelProperty(value = "附件信息")
    private String appenddesc;
    /**
     * pageNum
     */

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

@@ -208,11 +208,17 @@
    @ApiModelProperty(value = "是否是用户选择的选项")
    private Boolean isUserOperation = false;


    /**
     * ä¸‹ä¸€é¢˜
     */
    @ApiModelProperty(value = "下一题")
    private Integer nextQuestion;

    @ApiModelProperty(value = "选项附加标识")
    private String appendflag;

    @ApiModelProperty(value = "附件信息")
    private String appenddesc;


}

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

@@ -188,5 +188,12 @@
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;

    @ApiModelProperty(value = "选项附加标识")
    private String appendflag;

    @ApiModelProperty(value = "附件信息")
    private String appenddesc;

}


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

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

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
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_script_wjx
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Data
public class SvyLibTemplateScriptWjx extends BaseEntity {
    private static final long serialVersionUID = 1L;

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

    /**
     * è€ç‰ˆæœ¬ID
     */
    @ApiModelProperty(value = "老版本ID")
    private Long oldid;

    /**
     * é—®å·æ¨¡æ¿ID
     */
    @ApiModelProperty(value = "问卷模板ID")
    private Long svyid;

    /**
     * é¢˜ç›®ç±»åž‹;枚举 1.单选 2多选 3填空 4其它
     */
    @ApiModelProperty(value = "题目类型;枚举 1.单选 2多选 3填空 4其它")
    private String scriptType;

    /**
     * é¢˜ç›®æ ‡é¢˜
     */
    @ApiModelProperty(value = "题目标题")
    private String scriptTopic;

    /**
     * é¢˜ç›®è¯æœ¯å†…容
     */
    @ApiModelProperty(value = "题目话术内容")
    private String script;

    /**
     * é¢˜ç›®å†…容
     */
    @ApiModelProperty(value = "题目内容")
    private String scriptContent;

    /**
     * é¢˜ç›®ç¼–号
     */
    @ApiModelProperty(value = "题目编号")
    private String seqno;

    /**
     * é—®é¢˜å›¾ç‰‡
     */
    @ApiModelProperty(value = "问题图片")
    private String scriptPicture;

    /**
     * é¢˜ç›®æ ‡ç­¾
     */
    @ApiModelProperty(value = "题目标签")
    private String tag;

    /**
     * æŽ’序
     */
    @ApiModelProperty(value = "排序")
    private Long sort;

    /**
     * æ˜¯å¦å¿…å¡«   0必填   1不必填
     */
    @ApiModelProperty(value = "是否必填   0必填   1不必填")
    private String ismandatory;

    /**
     * æ˜¯å¦éšè—
     */
    @ApiModelProperty(value = "是否隐藏")
    private Long ishide;

    /**
     * åˆ é™¤æ ‡å¿—（0：未删除 1：已删除）
     */
    private String delFlag;

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

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

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

    /**
     * svy_topic表的topicid
     */
    @ApiModelProperty(value = "svy_topic表的topicid")
    private Long svyTopicid;

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

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

    /**
     * åˆ†ç±»id
     */
    @ApiModelProperty(value = "分类id")
    private Long categoryid;

    /**
     * é€‚用方式：调查表1，智能语音2、人工3
     */
    @ApiModelProperty(value = "适用方式：调查表1，智能语音2、人工3")
    private String suitway;

    /**
     * æ˜¯å¦å¯ç”¨ 0可用  1不可用
     */
    @ApiModelProperty(value = "是否可用 0可用  1不可用")
    private String isavailable;

    /**
     * è¯­è¨€
     */
    @ApiModelProperty(value = "语言")
    private String language;

    /**
     * å…¶å®ƒæ•°æ®ï¼ˆå­˜å‚¨å˜é‡ï¼‰
     */
    @ApiModelProperty(value = "其它数据")
    private String otherdata;

    /**
     * å€¼ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @ApiModelProperty(value = "值类型")
    private String valueType;

    /**
     * å›žå¤ï¼ˆæŒ‡é—®é¢˜çš„回复，给问答题用的）
     */
    @ApiModelProperty(value = "回复")
    private String reply;

    /**
     * åˆ†å€¼ç±»åž‹ï¼š1：数字，2：等级
     */
    @ApiModelProperty(value = "分值类型：1：数字，2：等级")
    private String scoretype;

    /**
     * é¢˜ç›®åˆ†å€¼ï¼šæ•°å­—1,2等；字母A、B，C，D等；
     */
    @ApiModelProperty(value = "题目分值：数字1,2等；字母A、B，C，D等；")
    private String score;

    /**
     * é—®é¢˜æè¿°
     */
    @ApiModelProperty(value = "问题描述")
    private String scriptDesc;

    public void setId(Long id) {
        this.id = id;
    }


}

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

@@ -242,4 +242,10 @@
    @ApiModelProperty(value = "选项图片路径")
    private String picturePath;

    @ApiModelProperty(value = "选项附加标识")
    private String appendflag;

    @ApiModelProperty(value = "附件信息")
    private String appenddesc;

}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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_targetoption_wjx
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Data
public class SvyLibTemplateTargetoptionWjx extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”® */
    @ApiModelProperty(value = "主键")
    private Long id;

    /** åˆ†ç»„ID */
    @ApiModelProperty(value = "分组ID")
    private String groupid;

    /**
     * æŽ’序
     */
    @ApiModelProperty(value = "排序")
    private Long sort;

    /** ç±»åˆ«åç§° */
    @ApiModelProperty(value = "类别名称")
    private String categoryName;

    /** é—®é¢˜id */
    @ApiModelProperty(value = "问题id")
    private Long scriptid;

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

    /** æ¨¡æ¿æŒ‡æ ‡ç±»åž‹ */
    @ApiModelProperty(value = "模板指标类型")
    private String targettype;

    /** æŒ‡æ ‡ID */
    @ApiModelProperty(value = "指标ID")
    private Long targetid;

    /** æŒ‡æ ‡åç§° */
    @ApiModelProperty(value = "指标名称")
    private String targetname;

    /** æ¨¡æ¿æŒ‡æ ‡å€¼ */
    @ApiModelProperty(value = "模板指标值")
    private String targetvalue;

    /** é¢„警标识（0：不用预警，1：需要预警） */
    @ApiModelProperty(value = "预警标识")
    private Long isabnormal;

    /** é¢„警阀值上限* */
    @ApiModelProperty(value = "预警阀值上限*")
    private Long warnup;

    /** é¢„警阀值下限* */
    @ApiModelProperty(value = "预警阀值下限*")
    private Long warndown;

    /** æ¨¡æ¿æŒ‡æ ‡æ­£åˆ™ */
    @ApiModelProperty(value = "模板指标正则")
    private String targetregex;

    /** æ¨¡æ¿æŒ‡æ ‡æ­£åˆ™2 */
    @ApiModelProperty(value = "模板指标正则2")
    private String targetregex2;

    /** æ­£åˆ™å…³é”®å­—(不含) */
    @ApiModelProperty(value = "正则关键字(不含)")
    private String dynamiccruxs;

    /** æ­£åˆ™å…³é”®å­—(含) */
    @ApiModelProperty(value = "正则关键字(含)")
    private String nodynamiccruxs;

    /** é€‰é¡¹æè¿° */
    @ApiModelProperty(value = "选项描述")
    private String optioncontent;

    /** ä¸‹ä¸€ä¸ªè¯æœ¯ç¼–号 */
    @ApiModelProperty(value = "下一个话术编号")
    private Long nextQuestion;

    /** è¯­è¨€ */
    @ApiModelProperty(value = "语言")
    private String language;

    /** ç‰ˆæœ¬ */
    @ApiModelProperty(value = "版本")
    private String version;

    /** åˆ é™¤æ ‡å¿—（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 String orgid;

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

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

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

    /** åˆ†æ•° */
    @ApiModelProperty(value = "分数")
    private String score;

    /** é€‰é¡¹é™„加标识：0-无附加，1-有附件； */
    @ApiModelProperty(value = "选项附加标识：0-无附加，1-有附件；")
    private String appendflag;

    /** é™„件信息 */
    @ApiModelProperty(value = "附件信息")
    private String appenddesc;

}

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

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

import java.math.BigDecimal;
import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
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_wjx
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Data
public class SvyLibTemplateWjx extends BaseEntity {
    private static final long serialVersionUID = 1L;

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

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

    /**
     * é—®å·åˆ†ç±»ID
     */
    @ApiModelProperty(value = "问卷分类ID")
    private Long categoryid;

    /**
     * é—®å·ä»£ç 
     */
    @ApiModelProperty(value = "问卷代码")
    private String svycode;

    /**
     * é—®å·åç§°
     */
    @ApiModelProperty(value = "问卷名称")
    private String svyname;

    /**
     * é—®å·æè¿°
     */
    @ApiModelProperty(value = "问卷描述")
    private String description;

    /**
     * é—®å·ä»‹ç»
     */
    @ApiModelProperty(value = "问卷介绍")
    private String introduce;

    /**
     * é—®å·æç¤º
     */
    @ApiModelProperty(value = "问卷提示")
    private String submitprompt;

    /**
     * æ ‡ç­¾
     */
    @ApiModelProperty(value = "标签")
    private String tag;

    /**
     * ç‰ˆæœ¬
     */
    @ApiModelProperty(value = "版本")
    private BigDecimal version;

    /**
     * ä¸­å¿ƒåº“代码
     */
    @ApiModelProperty(value = "中心库代码")
    private String centerlibrarycode;

    /**
     * ä¸­å¿ƒåº“ID
     */
    @ApiModelProperty(value = "中心库ID")
    private Long centerlibraryid;

    /**
     * æ˜¯å¦æœ¬åœ°
     */
    @ApiModelProperty(value = "是否本地")
    private Long islocal;

    /**
     * æ˜¯å¦å¯ç”¨
     */
    @ApiModelProperty(value = "是否启用")
    private String isenable;

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

    /**
     * åˆ é™¤æ ‡å¿—（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 String topicid;

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

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

    /**
     * ç§‘室名称
     */
    @ApiModelProperty(value = "科室名称")
    private String deptNames;

    /**
     * æ ‡ç­¾ä¿¡æ¯
     */
    @ApiModelProperty(value = "标签信息")
    private String labelInfo;

    /**
     * é™¢åŒº
     */
    @ApiModelProperty(value = "院区")
    private String campus;

    /**
     * é€‚用方式：调查表1，智能语音2、人工3
     */
    @ApiModelProperty(value = "适用方式：调查表1，智能语音2、人工3")
    private String suitway;

    /**
     * å…¶å®ƒæ•°æ®ï¼ˆå­˜å‚¨å˜é‡ï¼‰
     */
    @ApiModelProperty(value = "其它数据")
    private String otherdata;

    /**
     * å€¼ç±»åž‹ï¼ˆ1 é€‰é¡¹  2 æ–‡æœ¬  3 æ•°å€¼ï¼‰
     */
    @ApiModelProperty(value = "值类型")
    private String valueType;

    /**
     * å›žå¤ï¼ˆæŒ‡é—®é¢˜çš„回复，给问答题用的）
     */
    @ApiModelProperty(value = "回复")
    private String reply;

    /**
     * é—®é¢˜æ€»åˆ†å€¼
     */
    @ApiModelProperty(value = "问题总分值")
    private String scriptScore;

    /**
     * åˆ†æ•°ç±»åž‹
     */
    @ApiModelProperty(value = "分数类型")
    private String scoreType;

}

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

@@ -68,70 +68,10 @@
    private String categoryName;

    /**
     * é—®é¢˜ç‚¹
     */
    @ApiModelProperty(value = "问题点")
    private String scriptPoint;

    /**
     * è¯æœ¯å†…容
     */
    @ApiModelProperty(value = "话术内容")
    private String scriptContent;

    /**
     * è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "话术语音")
    private String scriptVoice;

    /**
     * æ— åŒ¹é…è¯æœ¯
     */
    @ApiModelProperty(value = "无匹配话术")
    private String noMatchText;

    /**
     * æ— åŒ¹é…è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "无匹配话术语音")
    private String noMatchVoice;

    /**
     * é™é»˜è¯æœ¯
     */
    @ApiModelProperty(value = "静默话术")
    private String slienceText;

    /**
     * é™é»˜è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "静默话术语音")
    private String slienceVoice;

    /**
     * é€šç”¨åº“匹配后话术
     */
    @ApiModelProperty(value = "通用库匹配后话术")
    private String submoduleText;

    /**
     * é€šç”¨åº“匹配后话术语音
     */
    @ApiModelProperty(value = "通用库匹配后话术语音")
    private String submoduleVoice;

    /**
     * å¬ä¸æ¸…话术
     */
    @ApiModelProperty(value = "听不清话术")
    private String noClearlyText;

    /**
     * å¬ä¸æ¸…话术语音
     */
    @ApiModelProperty(value = "听不清话术语音")
    private String noClearlyVoice;

    /**
     * æ˜¯å¦å¿…å¡«,1:必填    2：可以不填    ï¼ˆç»™äººå·¥ç”¨çš„，AI不用遵守）
@@ -144,12 +84,6 @@
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;

    /**
     * åªèƒ½æ’­æ”¾WAV类型
     */
    @ApiModelProperty(value = "只能播放WAV类型")
    private Long playWavOnly;

    /**
     * æŽ’序

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

@@ -76,11 +76,6 @@
    @ApiModelProperty(value = "类别名")
    private String categoryName;

    /**
     * é—®é¢˜ç‚¹
     */
    @ApiModelProperty(value = "问题点")
    private String scriptPoint;

    /**
     * è¯æœ¯å†…容
@@ -88,59 +83,6 @@
    @ApiModelProperty(value = "话术内容")
    private String scriptContent;

    /**
     * è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "话术语音")
    private String scriptVoice;

    /**
     * æ— åŒ¹é…è¯æœ¯
     */
    @ApiModelProperty(value = "无匹配话术")
    private String noMatchText;

    /**
     * æ— åŒ¹é…è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "无匹配话术语音")
    private String noMatchVoice;

    /**
     * é™é»˜è¯æœ¯
     */
    @ApiModelProperty(value = "静默话术")
    private String slienceText;

    /**
     * é™é»˜è¯æœ¯è¯­éŸ³
     */
    @ApiModelProperty(value = "静默话术语音")
    private String slienceVoice;

    /**
     * é€šç”¨åº“匹配后话术
     */
    @ApiModelProperty(value = "通用库匹配后话术")
    private String submoduleText;

    /**
     * é€šç”¨åº“匹配后话术语音
     */
    @ApiModelProperty(value = "通用库匹配后话术语音")
    private String submoduleVoice;

    /**
     * å¬ä¸æ¸…话术
     */
    @ApiModelProperty(value = "听不清话术")
    private String noClearlyText;

    /**
     * å¬ä¸æ¸…话术语音
     */
    @ApiModelProperty(value = "听不清话术语音")
    private String noClearlyVoice;

    /**
     * æ˜¯å¦å¿…å¡«,1:必填    2：可以不填    ï¼ˆç»™äººå·¥ç”¨çš„，AI不用遵守）
@@ -148,11 +90,6 @@
    @ApiModelProperty(value = "是否必填,1:必填    2：可以不填 ")
    private String isMust;

    /**
     * åªèƒ½æ’­æ”¾WAV类型
     */
    @ApiModelProperty(value = "只能播放WAV类型")
    private Long playWavOnly;

    /**
     * åˆ é™¤æ ‡è®°

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

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

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

import java.util.List;

/**
 * æ¨¡æ¿é—®å·é¢˜ç›®Mapper接口
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Mapper
public interface SvyLibTemplateScriptWjxMapper
{
    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param id æ¨¡æ¿é—®å·é¢˜ç›®ä¸»é”®
     * @return æ¨¡æ¿é—®å·é¢˜ç›®
     */
    public SvyLibTemplateScriptWjx selectSvyLibTemplateScriptWjxById(Long id);

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®åˆ—表
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return æ¨¡æ¿é—®å·é¢˜ç›®é›†åˆ
     */
    public List<SvyLibTemplateScriptWjx> selectSvyLibTemplateScriptWjxList(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx);

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateScriptWjx(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx);

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateScriptWjx(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx);

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param id æ¨¡æ¿é—®å·é¢˜ç›®ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateScriptWjxById(Long id);

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

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

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

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

import java.util.List;

/**
 * é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“Mapper接口
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Mapper
public interface SvyLibTemplateTargetoptionWjxMapper
{
    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    public SvyLibTemplateTargetoptionWjx selectSvyLibTemplateTargetoptionWjxById(Long id);

    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“列表
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“集合
     */
    public List<SvyLibTemplateTargetoptionWjx> selectSvyLibTemplateTargetoptionWjxList(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx);

    /**
     * æ–°å¢žé—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateTargetoptionWjx(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx);

    /**
     * ä¿®æ”¹é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateTargetoptionWjx(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx);

    /**
     * åˆ é™¤é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTargetoptionWjxById(Long id);

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

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

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

import java.util.List;

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

/**
 * æ¨¡æ¿é—®å·Mapper接口
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Mapper
public interface SvyLibTemplateWjxMapper {
    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·
     *
     * @param svyid æ¨¡æ¿é—®å·ä¸»é”®
     * @return æ¨¡æ¿é—®å·
     */
    public SvyLibTemplateWjx selectSvyLibTemplateWjxBySvyid(Long svyid);

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·åˆ—表
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return æ¨¡æ¿é—®å·é›†åˆ
     */
    public List<SvyLibTemplateWjx> selectSvyLibTemplateWjxList(SvyLibTemplateWjx svyLibTemplateWjx);

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateWjx(SvyLibTemplateWjx svyLibTemplateWjx);

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateWjx(SvyLibTemplateWjx svyLibTemplateWjx);

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·
     *
     * @param svyid æ¨¡æ¿é—®å·ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateWjxBySvyid(Long svyid);

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

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

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

import com.smartor.domain.SvyLibTemplateScriptWjx;

import java.util.List;

/**
 * æ¨¡æ¿é—®å·é¢˜ç›®Service接口
 *
 * @author ruoyi
 * @date 2024-07-08
 */
public interface ISvyLibTemplateScriptWjxService
{
    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param id æ¨¡æ¿é—®å·é¢˜ç›®ä¸»é”®
     * @return æ¨¡æ¿é—®å·é¢˜ç›®
     */
    public SvyLibTemplateScriptWjx selectSvyLibTemplateScriptWjxById(Long id);

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®åˆ—表
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return æ¨¡æ¿é—®å·é¢˜ç›®é›†åˆ
     */
    public List<SvyLibTemplateScriptWjx> selectSvyLibTemplateScriptWjxList(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx);

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateScriptWjx(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx);

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateScriptWjx(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx);

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param ids éœ€è¦åˆ é™¤çš„模板问卷题目主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateScriptWjxByIds(Long[] ids);

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·é¢˜ç›®ä¿¡æ¯
     *
     * @param id æ¨¡æ¿é—®å·é¢˜ç›®ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateScriptWjxById(Long id);
}

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

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

import com.smartor.domain.SvyLibTemplateTargetoptionWjx;

import java.util.List;

/**
 * é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“Service接口
 *
 * @author ruoyi
 * @date 2024-07-08
 */
public interface ISvyLibTemplateTargetoptionWjxService
{
    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    public SvyLibTemplateTargetoptionWjx selectSvyLibTemplateTargetoptionWjxById(Long id);

    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“列表
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“集合
     */
    public List<SvyLibTemplateTargetoptionWjx> selectSvyLibTemplateTargetoptionWjxList(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx);

    /**
     * æ–°å¢žé—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateTargetoptionWjx(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx);

    /**
     * ä¿®æ”¹é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateTargetoptionWjx(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx);

    /**
     * æ‰¹é‡åˆ é™¤é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„问卷问题指标选项库主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTargetoptionWjxByIds(Long[] ids);

    /**
     * åˆ é™¤é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“信息
     *
     * @param id é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateTargetoptionWjxById(Long id);
}

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

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

import com.smartor.domain.SvyLibTemplateWjx;

import java.util.List;

/**
 * æ¨¡æ¿é—®å·Service接口
 *
 * @author ruoyi
 * @date 2024-07-08
 */
public interface ISvyLibTemplateWjxService
{
    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·
     *
     * @param svyid æ¨¡æ¿é—®å·ä¸»é”®
     * @return æ¨¡æ¿é—®å·
     */
    public SvyLibTemplateWjx selectSvyLibTemplateWjxBySvyid(Long svyid);

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·åˆ—表
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return æ¨¡æ¿é—®å·é›†åˆ
     */
    public List<SvyLibTemplateWjx> selectSvyLibTemplateWjxList(SvyLibTemplateWjx svyLibTemplateWjx);

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return ç»“æžœ
     */
    public int insertSvyLibTemplateWjx(SvyLibTemplateWjx svyLibTemplateWjx);

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return ç»“æžœ
     */
    public int updateSvyLibTemplateWjx(SvyLibTemplateWjx svyLibTemplateWjx);

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿é—®å·
     *
     * @param svyids éœ€è¦åˆ é™¤çš„模板问卷主键集合
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateWjxBySvyids(Long[] svyids);

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·ä¿¡æ¯
     *
     * @param svyid æ¨¡æ¿é—®å·ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteSvyLibTemplateWjxBySvyid(Long svyid);
}

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

@@ -45,16 +45,16 @@
    private String accessKeySecret;

    @Autowired
    private SvyLibTemplateMapper svyLibTitleMapper;
    private SvyLibTemplateWjxMapper svyLibTitleMapper;

    @Autowired
    private SvyLibScriptMapper svyLibTopicMapper;
    private SvyLibTemplateScriptWjxMapper svyLibTopicMapper;

    @Autowired
    private SvyLibTopicdirectionMapper svyLibTopicdirectionMapper;

    @Autowired
    private SvyLibScriptOptionMapper svyLibTopicoptionMapper;
    private SvyLibTemplateTargetoptionWjxMapper svyLibTopicoptionMapper;
//
//    @Autowired
//    private ISvyLibTitleService svyLibTitleService;
@@ -95,6 +95,7 @@
    }

    public String explainHTML2() throws IOException {

        String folderPath = "E:\\pc2";
        // èŽ·å–文件夹下的所有文件
        File[] files = new File(folderPath).listFiles();
@@ -108,17 +109,22 @@
            String fileContent = new String(Files.readAllBytes(file.toPath()));

            Document parse = Jsoup.parse(fileContent);
            Element body = parse.body();
            Elements elementsByClass3 = body.getElementsByClass("topic__type-des");
            String desc = elementsByClass3.text();

            //保存title
            String title = parse.title();
            SvyLibTemplate svyLibTitle = new SvyLibTemplate();
            SvyLibTemplateWjx svyLibTitle = new SvyLibTemplateWjx();
//            svyLibTitle.setCategoryid(System.currentTimeMillis());
            svyLibTitle.setSvyname(title);
            svyLibTitle.setDescription(desc);
            svyLibTitle.setDelFlag("0");
            svyLibTitle.setIsupload(0L);
            svyLibTitleMapper.insertSvyLibTemplate(svyLibTitle);

            Element body = parse.body();
            svyLibTitleMapper.insertSvyLibTemplateWjx(svyLibTitle);


            Elements elementsByClass = body.getElementsByClass("topic__type-body");
            Elements children = elementsByClass.get(0).children();
            for (Element element : children) {
@@ -140,7 +146,7 @@
                String legend = element.getElementsByTag("legend").text();
                System.out.println("题目： " + legend);
                //将题目保存到表中
                SvyLibScript svyLibTopic = new SvyLibScript();
                SvyLibTemplateScriptWjx svyLibTopic = new SvyLibTemplateScriptWjx();
                svyLibTopic.setSvyid(svyLibTitle.getSvyid());

                //判断该题目下是否有选项
@@ -150,22 +156,22 @@
                    if (spans.size() != 0) {
                        Elements radio__type = spans.get(0).getElementsByClass("radio__type");
                        if (radio__type.size() != 0) {
                            svyLibTopic.setScripttype("1");
                            svyLibTopic.setScriptType("1");
                        } else {
                            Elements checkbox__type = spans.get(0).getElementsByClass("checkbox__type");
                            if (checkbox__type.size() != 0) {
                                svyLibTopic.setScripttype("2");
                                svyLibTopic.setScriptType("2");
                            }
                        }

                    }
                    svyLibTopic.setScriptcode(IdUtils.simpleUUID());
                    svyLibTopic.setSeqno(IdUtils.simpleUUID());
                    svyLibTopic.setScriptContent(legend);
                    svyLibTopic.setDelFlag("0");
                    svyLibTopic.setIsupload(0L);
                    svyLibTopic.setOrgid(fileName);
                    try {
                        svyLibTopicMapper.insertSvyLibScript(svyLibTopic);
                        svyLibTopicMapper.insertSvyLibTemplateScriptWjx(svyLibTopic);
                    } catch (Exception e) {
                        noExpiain(fileName.substring(0, fileName.length() - 5) + "出异常了1", fileContent);
                        continue a;
@@ -180,16 +186,16 @@
                            String text = label.text();
                            //将题目存库
//                            item = item + "------" + text;
                            SvyLibScriptOption svyLibTopicoption = new SvyLibScriptOption();
                            svyLibTopicoption.setTopicid(svyLibTopic.getId());
                            svyLibTopicoption.setSvyid(svyLibTitle.getSvyid());
                            SvyLibTemplateTargetoptionWjx svyLibTopicoption = new SvyLibTemplateTargetoptionWjx();
                            svyLibTopicoption.setScriptid(svyLibTopic.getId());
                            svyLibTopicoption.setTemplateID(svyLibTitle.getSvyid());
                            svyLibTopicoption.setSort(i);
                            svyLibTopicoption.setOptioncode(IdUtils.simpleUUID());
                            svyLibTopicoption.setGuid(IdUtils.simpleUUID());
                            svyLibTopicoption.setOptioncontent(text);
                            svyLibTopicoption.setDelFlag("0");
                            svyLibTopicoption.setIsupload(0L);
                            try {
                                svyLibTopicoptionMapper.insertSvyLibScriptOption(svyLibTopicoption);
                                svyLibTopicoptionMapper.insertSvyLibTemplateTargetoptionWjx(svyLibTopicoption);
                            } catch (Exception e) {
                                noExpiain(fileName.substring(0, fileName.length() - 5) + "出异常了2", fileContent);
                                continue a;
@@ -203,16 +209,16 @@
                    //将题目保存到表中
                    Elements elementsByClass2 = element.getElementsByClass("ui-control-group ui-matrix");
                    if (elementsByClass2.size() > 0) {
                        SvyLibScript svyLibTopic2 = new SvyLibScript();
                        SvyLibTemplateScriptWjx svyLibTopic2 = new SvyLibTemplateScriptWjx();
                        svyLibTopic2.setSvyid(svyLibTitle.getSvyid());
                        svyLibTopic2.setScriptcode(IdUtils.simpleUUID());
                        svyLibTopic2.setSeqno(IdUtils.simpleUUID());
                        svyLibTopic2.setScriptContent(legend);
                        svyLibTopic2.setDelFlag("0");
                        svyLibTopic.setIsupload(0L);
                        svyLibTopic2.setScripttype("4");
                        svyLibTopic2.setScriptType("4");
                        svyLibTopic2.setOrgid(fileName);
                        try {
                            svyLibTopicMapper.insertSvyLibScript(svyLibTopic2);
                            svyLibTopicMapper.insertSvyLibTemplateScriptWjx(svyLibTopic2);
                        } catch (Exception e) {
                            noExpiain(fileName.substring(0, fileName.length() - 5) + "出异常了22", fileContent);
                            continue a;
@@ -238,16 +244,16 @@


                        //将题目保存到表中
                        SvyLibScript svyLibTopic3 = new SvyLibScript();
                        SvyLibTemplateScriptWjx svyLibTopic3 = new SvyLibTemplateScriptWjx();
                        svyLibTopic3.setSvyid(svyLibTitle.getSvyid());
                        svyLibTopic3.setScriptcode(IdUtils.simpleUUID());
                        svyLibTopic3.setSeqno(IdUtils.simpleUUID());
                        svyLibTopic3.setScriptContent(legend);
                        svyLibTopic3.setDelFlag("0");
                        svyLibTopic3.setIsupload(0L);
                        svyLibTopic3.setScripttype("3");
                        svyLibTopic3.setScriptType("3");
                        svyLibTopic3.setOrgid(fileName);
                        try {
                            svyLibTopicMapper.insertSvyLibScript(svyLibTopic3);
                            svyLibTopicMapper.insertSvyLibTemplateScriptWjx(svyLibTopic3);
                        } catch (Exception e) {
                            noExpiain(fileName.substring(0, fileName.length() - 5) + "出异常了33", fileContent);
                            continue a;

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

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

import java.util.List;

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyLibTemplateScriptWjx;
import com.smartor.mapper.SvyLibTemplateScriptWjxMapper;
import com.smartor.service.ISvyLibTemplateScriptWjxService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * æ¨¡æ¿é—®å·é¢˜ç›®Service业务层处理
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Service
public class SvyLibTemplateScriptWjxServiceImpl implements ISvyLibTemplateScriptWjxService {
    @Autowired
    private SvyLibTemplateScriptWjxMapper svyLibTemplateScriptWjxMapper;

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param id æ¨¡æ¿é—®å·é¢˜ç›®ä¸»é”®
     * @return æ¨¡æ¿é—®å·é¢˜ç›®
     */
    @Override
    public SvyLibTemplateScriptWjx selectSvyLibTemplateScriptWjxById(Long id) {
        return svyLibTemplateScriptWjxMapper.selectSvyLibTemplateScriptWjxById(id);
    }

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·é¢˜ç›®åˆ—表
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return æ¨¡æ¿é—®å·é¢˜ç›®
     */
    @Override
    public List<SvyLibTemplateScriptWjx> selectSvyLibTemplateScriptWjxList(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx) {
        return svyLibTemplateScriptWjxMapper.selectSvyLibTemplateScriptWjxList(svyLibTemplateScriptWjx);
    }

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyLibTemplateScriptWjx(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx) {
        svyLibTemplateScriptWjx.setCreateTime(DateUtils.getNowDate());
        return svyLibTemplateScriptWjxMapper.insertSvyLibTemplateScriptWjx(svyLibTemplateScriptWjx);
    }

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param svyLibTemplateScriptWjx æ¨¡æ¿é—®å·é¢˜ç›®
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyLibTemplateScriptWjx(SvyLibTemplateScriptWjx svyLibTemplateScriptWjx) {
        svyLibTemplateScriptWjx.setUpdateTime(DateUtils.getNowDate());
        return svyLibTemplateScriptWjxMapper.updateSvyLibTemplateScriptWjx(svyLibTemplateScriptWjx);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿é—®å·é¢˜ç›®
     *
     * @param ids éœ€è¦åˆ é™¤çš„模板问卷题目主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateScriptWjxByIds(Long[] ids) {
        return svyLibTemplateScriptWjxMapper.deleteSvyLibTemplateScriptWjxByIds(ids);
    }

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·é¢˜ç›®ä¿¡æ¯
     *
     * @param id æ¨¡æ¿é—®å·é¢˜ç›®ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateScriptWjxById(Long id) {
        return svyLibTemplateScriptWjxMapper.deleteSvyLibTemplateScriptWjxById(id);
    }
}

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

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

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyLibTemplateTargetoptionWjx;
import com.smartor.mapper.SvyLibTemplateTargetoptionWjxMapper;
import com.smartor.service.ISvyLibTemplateTargetoptionWjxService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“Service业务层处理
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Service
public class SvyLibTemplateTargetoptionWjxServiceImpl implements ISvyLibTemplateTargetoptionWjxService
{
    @Autowired
    private SvyLibTemplateTargetoptionWjxMapper svyLibTemplateTargetoptionWjxMapper;

    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param id é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    @Override
    public SvyLibTemplateTargetoptionWjx selectSvyLibTemplateTargetoptionWjxById(Long id)
    {
        return svyLibTemplateTargetoptionWjxMapper.selectSvyLibTemplateTargetoptionWjxById(id);
    }

    /**
     * æŸ¥è¯¢é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“列表
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     */
    @Override
    public List<SvyLibTemplateTargetoptionWjx> selectSvyLibTemplateTargetoptionWjxList(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        return svyLibTemplateTargetoptionWjxMapper.selectSvyLibTemplateTargetoptionWjxList(svyLibTemplateTargetoptionWjx);
    }

    /**
     * æ–°å¢žé—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyLibTemplateTargetoptionWjx(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        svyLibTemplateTargetoptionWjx.setCreateTime(DateUtils.getNowDate());
        return svyLibTemplateTargetoptionWjxMapper.insertSvyLibTemplateTargetoptionWjx(svyLibTemplateTargetoptionWjx);
    }

    /**
     * ä¿®æ”¹é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param svyLibTemplateTargetoptionWjx é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyLibTemplateTargetoptionWjx(SvyLibTemplateTargetoptionWjx svyLibTemplateTargetoptionWjx)
    {
        svyLibTemplateTargetoptionWjx.setUpdateTime(DateUtils.getNowDate());
        return svyLibTemplateTargetoptionWjxMapper.updateSvyLibTemplateTargetoptionWjx(svyLibTemplateTargetoptionWjx);
    }

    /**
     * æ‰¹é‡åˆ é™¤é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“
     *
     * @param ids éœ€è¦åˆ é™¤çš„问卷问题指标选项库主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateTargetoptionWjxByIds(Long[] ids)
    {
        return svyLibTemplateTargetoptionWjxMapper.deleteSvyLibTemplateTargetoptionWjxByIds(ids);
    }

    /**
     * åˆ é™¤é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“信息
     *
     * @param id é—®å·é—®é¢˜æŒ‡æ ‡é€‰é¡¹åº“主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateTargetoptionWjxById(Long id)
    {
        return svyLibTemplateTargetoptionWjxMapper.deleteSvyLibTemplateTargetoptionWjxById(id);
    }
}

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

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

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.SvyLibTemplateWjx;
import com.smartor.mapper.SvyLibTemplateWjxMapper;
import com.smartor.service.ISvyLibTemplateWjxService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * æ¨¡æ¿é—®å·Service业务层处理
 *
 * @author ruoyi
 * @date 2024-07-08
 */
@Service
public class SvyLibTemplateWjxServiceImpl implements ISvyLibTemplateWjxService
{
    @Autowired
    private SvyLibTemplateWjxMapper svyLibTemplateWjxMapper;

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·
     *
     * @param svyid æ¨¡æ¿é—®å·ä¸»é”®
     * @return æ¨¡æ¿é—®å·
     */
    @Override
    public SvyLibTemplateWjx selectSvyLibTemplateWjxBySvyid(Long svyid)
    {
        return svyLibTemplateWjxMapper.selectSvyLibTemplateWjxBySvyid(svyid);
    }

    /**
     * æŸ¥è¯¢æ¨¡æ¿é—®å·åˆ—表
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return æ¨¡æ¿é—®å·
     */
    @Override
    public List<SvyLibTemplateWjx> selectSvyLibTemplateWjxList(SvyLibTemplateWjx svyLibTemplateWjx)
    {
        return svyLibTemplateWjxMapper.selectSvyLibTemplateWjxList(svyLibTemplateWjx);
    }

    /**
     * æ–°å¢žæ¨¡æ¿é—®å·
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return ç»“æžœ
     */
    @Override
    public int insertSvyLibTemplateWjx(SvyLibTemplateWjx svyLibTemplateWjx)
    {
        svyLibTemplateWjx.setCreateTime(DateUtils.getNowDate());
        return svyLibTemplateWjxMapper.insertSvyLibTemplateWjx(svyLibTemplateWjx);
    }

    /**
     * ä¿®æ”¹æ¨¡æ¿é—®å·
     *
     * @param svyLibTemplateWjx æ¨¡æ¿é—®å·
     * @return ç»“æžœ
     */
    @Override
    public int updateSvyLibTemplateWjx(SvyLibTemplateWjx svyLibTemplateWjx)
    {
        svyLibTemplateWjx.setUpdateTime(DateUtils.getNowDate());
        return svyLibTemplateWjxMapper.updateSvyLibTemplateWjx(svyLibTemplateWjx);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ¨¡æ¿é—®å·
     *
     * @param svyids éœ€è¦åˆ é™¤çš„模板问卷主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateWjxBySvyids(Long[] svyids)
    {
        return svyLibTemplateWjxMapper.deleteSvyLibTemplateWjxBySvyids(svyids);
    }

    /**
     * åˆ é™¤æ¨¡æ¿é—®å·ä¿¡æ¯
     *
     * @param svyid æ¨¡æ¿é—®å·ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteSvyLibTemplateWjxBySvyid(Long svyid)
    {
        return svyLibTemplateWjxMapper.deleteSvyLibTemplateWjxBySvyid(svyid);
    }
}

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

@@ -33,12 +33,16 @@
        <result property="guid" column="guid"/>
        <result property="nodynamiccruxsJson" column="nodynamiccruxs"/>
        <result property="dynamiccruxsJson" column="dynamiccruxs"/>
        <result property="appendflag" column="appendflag"/>
        <result property="appenddesc" column="appenddesc"/>
    </resultMap>

    <sql id="selectIvrLibaScriptTargetoptionVo">
        select id,
               targetid,
               targetname,
               appendflag,
               appenddesc,
               scriptid,
               targettype,
               categoryName,
@@ -80,6 +84,8 @@
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="nodynamiccruxsJson != null ">and nodynamiccruxs = #{nodynamiccruxsJson}</if>
            <if test="dynamiccruxsJson != null ">and dynamiccruxs = #{dynamiccruxsJson}</if>
            <if test="appendflag != null">and appendflag = #{appendflag}</if>
            <if test="appenddesc != null">and appenddesc = #{appenddesc}</if>
        </where>
    </select>

@@ -120,6 +126,8 @@
            <if test="guid != null">guid,</if>
            <if test="nodynamiccruxsJson != null ">nodynamiccruxs,</if>
            <if test="dynamiccruxsJson != null ">dynamiccruxs,</if>
            <if test="appendflag != null">appendflag,</if>
            <if test="appenddesc != null">appenddesc,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
@@ -150,6 +158,8 @@
            <if test="guid != null">#{guid},</if>
            <if test="nodynamiccruxsJson != null ">#{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null ">#{dynamiccruxsJson},</if>
            <if test="appendflag != null">#{appendflag},</if>
            <if test="appenddesc != null">#{appenddesc},</if>
        </trim>
    </insert>

@@ -183,6 +193,8 @@
            <if test="guid != null">guid = #{guid},</if>
            <if test="nodynamiccruxsJson != null ">nodynamiccruxs = #{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null ">dynamiccruxs = #{dynamiccruxsJson},</if>
            <if test="appendflag != null">appendflag = #{appendflag},</if>
            <if test="appenddesc != null">appenddesc = #{appenddesc},</if>
        </trim>
        where id = #{id}
    </update>

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

@@ -32,11 +32,15 @@
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
        <result property="orderno" column="orderno"/>
        <result property="appendflag" column="appendflag"/>
        <result property="appenddesc" column="appenddesc"/>
    </resultMap>

    <sql id="selectIvrLibaTargetoptionVo">
        select targetoptionid,
               targetid,
               appendflag,
               appenddesc,
               targettype,
               categoryName,
               targetvalue,
@@ -77,7 +81,8 @@
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="nodynamiccruxsJson != null">and nodynamiccruxs = #{nodynamiccruxsJson}</if>
            <if test="dynamiccruxsJson != null">and dynamiccruxs = #{dynamiccruxsJson}</if>

            <if test="appendflag != null">and appendflag = #{appendflag}</if>
            <if test="appenddesc != null">and appenddesc = #{appenddesc}</if>
        </where>
        order by guid asc
    </select>
@@ -117,6 +122,8 @@
            <if test="nodynamiccruxsJson != null">nodynamiccruxs,</if>
            <if test="dynamiccruxsJson != null">dynamiccruxs,</if>
            <if test="orderno != null">orderno,</if>
            <if test="appendflag != null">appendflag,</if>
            <if test="appenddesc != null">appenddesc,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="targetid != null">#{targetid},</if>
@@ -145,6 +152,8 @@
            <if test="nodynamiccruxsJson != null">#{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null">#{dynamiccruxsJson},</if>
            <if test="orderno != null">#{orderno},</if>
            <if test="appendflag != null">#{appendflag},</if>
            <if test="appenddesc != null">#{appenddesc},</if>
        </trim>
    </insert>

@@ -177,6 +186,8 @@
            <if test="nodynamiccruxsJson != null">nodynamiccruxs = #{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null">dynamiccruxs = #{dynamiccruxsJson},</if>
            <if test="orderno != null">orderno = #{orderno},</if>
            <if test="appendflag != null">appendflag = #{appendflag},</if>
            <if test="appenddesc != null">appenddesc = #{appenddesc},</if>
        </trim>
        where targetoptionid = #{targetoptionid}
    </update>

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

@@ -33,11 +33,15 @@
        <result property="guid" column="guid"/>
        <result property="scriptid" column="scriptid"/>
        <result property="nextQuestion" column="next_question"/>
        <result property="appendflag" column="appendflag"/>
        <result property="appenddesc" column="appenddesc"/>
    </resultMap>

    <sql id="selectIvrLibaTemplateTargetoptionVo">
        select id,
               targetid,
               appendflag,
               appenddesc,
               scriptid,
               targetname,
               templateID,
@@ -50,7 +54,7 @@
               dynamiccruxs,
               targetid,
               next_question,
               optiondesc, language, version, groupid, isabnormal,  del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid
               optiondesc, language, version, groupid, isabnormal, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid
        from ivr_liba_template_targetoption
    </sql>

@@ -82,6 +86,8 @@
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="nodynamiccruxsJson != null ">and nodynamiccruxs = #{nodynamiccruxsJson}</if>
            <if test="dynamiccruxsJson != null ">and dynamiccruxs = #{dynamiccruxsJson}</if>
            <if test="appendflag != null">and appendflag = #{appendflag}</if>
            <if test="appenddesc != null">and appenddesc = #{appenddesc}</if>
        </where>
    </select>

@@ -122,6 +128,8 @@
            <if test="nextQuestion != null">next_question,</if>
            <if test="nodynamiccruxsJson != null ">nodynamiccruxs,</if>
            <if test="dynamiccruxsJson != null ">dynamiccruxs,</if>
            <if test="appendflag != null">appendflag,</if>
            <if test="appenddesc != null">appenddesc,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="targetid != null">#{targetid},</if>
@@ -151,6 +159,8 @@
            <if test="nextQuestion != null">#{nextQuestion},</if>
            <if test="nodynamiccruxsJson != null ">#{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null ">#{dynamiccruxsJson},</if>
            <if test="appendflag != null">#{appendflag},</if>
            <if test="appenddesc != null">#{appenddesc},</if>
        </trim>
    </insert>

@@ -184,6 +194,8 @@
            <if test="nextQuestion != null">next_question = #{nextQuestion},</if>
            <if test="nodynamiccruxsJson != null ">nodynamiccruxs = #{nodynamiccruxsJson},</if>
            <if test="dynamiccruxsJson != null ">dynamiccruxs = #{dynamiccruxsJson},</if>
            <if test="appendflag != null">appendflag = #{appendflag},</if>
            <if test="appenddesc != null">appenddesc = #{appenddesc},</if>
        </trim>
        where id = #{id}
    </update>

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

@@ -36,12 +36,16 @@
        <result property="updateTime" column="update_time"/>
        <result property="isupload" column="isupload"/>
        <result property="uploadTime" column="upload_time"/>
        <result property="appendflag" column="appendflag"/>
        <result property="appenddesc" column="appenddesc"/>
    </resultMap>

    <sql id="selectSvyLibScriptOptionVo">
        select id,
               topicid,
               svyid,
               appendflag,
               appenddesc,
               topictype,
               optioncode,
               optioncontent,
@@ -103,6 +107,8 @@
            <if test="oldid != null ">and oldid = #{oldid}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="appendflag != null">and appendflag = #{appendflag}</if>
            <if test="appenddesc != null">and appenddesc = #{appenddesc}</if>
        </where>
    </select>

@@ -145,6 +151,8 @@
            <if test="updateTime != null">update_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="appendflag != null">appendflag,</if>
            <if test="appenddesc != null">appenddesc,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="topicid != null">#{topicid},</if>
@@ -177,6 +185,8 @@
            <if test="updateTime != null">#{updateTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="appendflag != null">#{appendflag},</if>
            <if test="appenddesc != null">#{appenddesc},</if>
        </trim>
    </insert>

@@ -213,6 +223,8 @@
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="appendflag != null">appendflag = #{appendflag},</if>
            <if test="appenddesc != null">appenddesc = #{appenddesc},</if>
        </trim>
        where id = #{id}
    </update>

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,211 @@
<?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.SvyLibTemplateScriptWjxMapper">

    <resultMap type="com.smartor.domain.SvyLibTemplateScriptWjx" id="SvyLibTemplateScriptWjxResult">
        <result property="id"    column="id"    />
        <result property="oldid"    column="oldid"    />
        <result property="svyid"    column="svyid"    />
        <result property="scriptType"    column="script_type"    />
        <result property="scriptTopic"    column="script_topic"    />
        <result property="script"    column="script"    />
        <result property="scriptContent"    column="script_content"    />
        <result property="seqno"    column="seqno"    />
        <result property="scriptPicture"    column="script_picture"    />
        <result property="tag"    column="tag"    />
        <result property="sort"    column="sort"    />
        <result property="ismandatory"    column="ismandatory"    />
        <result property="ishide"    column="ishide"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="orgid"    column="orgid"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="isupload"    column="isupload"    />
        <result property="uploadTime"    column="upload_time"    />
        <result property="svyTopicid"    column="svy_topicid"    />
        <result property="pid"    column="pid"    />
        <result property="guid"    column="guid"    />
        <result property="categoryid"    column="categoryid"    />
        <result property="suitway"    column="suitway"    />
        <result property="isavailable"    column="isavailable"    />
        <result property="language"    column="language"    />
        <result property="otherdata"    column="otherdata"    />
        <result property="valueType"    column="value_type"    />
        <result property="reply"    column="reply"    />
        <result property="scoretype"    column="scoretype"    />
        <result property="score"    column="score"    />
        <result property="scriptDesc"    column="script_desc"    />
    </resultMap>

    <sql id="selectSvyLibTemplateScriptWjxVo">
        select id, oldid, svyid, script_type, script_topic, script, script_content, seqno, script_picture, tag, sort, ismandatory, ishide, del_flag, orgid, create_by, create_time, update_by, update_time, isupload, upload_time, svy_topicid, pid, guid, categoryid, suitway, isavailable, language, otherdata, value_type, reply, scoretype, score, script_desc from svy_lib_template_script_wjx
    </sql>

    <select id="selectSvyLibTemplateScriptWjxList" parameterType="com.smartor.domain.SvyLibTemplateScriptWjx" resultMap="SvyLibTemplateScriptWjxResult">
        <include refid="selectSvyLibTemplateScriptWjxVo"/>
        <where>
            <if test="oldid != null "> and oldid = #{oldid}</if>
            <if test="svyid != null "> and svyid = #{svyid}</if>
            <if test="scriptType != null  and scriptType != ''"> and script_type = #{scriptType}</if>
            <if test="scriptTopic != null  and scriptTopic != ''"> and script_topic = #{scriptTopic}</if>
            <if test="script != null  and script != ''"> and script = #{script}</if>
            <if test="scriptContent != null  and scriptContent != ''"> and script_content = #{scriptContent}</if>
            <if test="seqno != null  and seqno != ''"> and seqno = #{seqno}</if>
            <if test="scriptPicture != null  and scriptPicture != ''"> and script_picture = #{scriptPicture}</if>
            <if test="tag != null  and tag != ''"> and tag = #{tag}</if>
            <if test="sort != null "> and sort = #{sort}</if>
            <if test="ismandatory != null  and ismandatory != ''"> and ismandatory = #{ismandatory}</if>
            <if test="ishide != null "> and ishide = #{ishide}</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="svyTopicid != null "> and svy_topicid = #{svyTopicid}</if>
            <if test="pid != null "> and pid = #{pid}</if>
            <if test="guid != null  and guid != ''"> and guid = #{guid}</if>
            <if test="categoryid != null "> and categoryid = #{categoryid}</if>
            <if test="suitway != null  and suitway != ''"> and suitway = #{suitway}</if>
            <if test="isavailable != null  and isavailable != ''"> and isavailable = #{isavailable}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="otherdata != null  and otherdata != ''"> and otherdata = #{otherdata}</if>
            <if test="valueType != null  and valueType != ''"> and value_type = #{valueType}</if>
            <if test="reply != null  and reply != ''"> and reply = #{reply}</if>
            <if test="scoretype != null  and scoretype != ''"> and scoretype = #{scoretype}</if>
            <if test="score != null  and score != ''"> and score = #{score}</if>
            <if test="scriptDesc != null  and scriptDesc != ''"> and script_desc = #{scriptDesc}</if>
        </where>
    </select>

    <select id="selectSvyLibTemplateScriptWjxById" parameterType="Long" resultMap="SvyLibTemplateScriptWjxResult">
        <include refid="selectSvyLibTemplateScriptWjxVo"/>
        where id = #{id}
    </select>

    <insert id="insertSvyLibTemplateScriptWjx" parameterType="com.smartor.domain.SvyLibTemplateScriptWjx" useGeneratedKeys="true" keyProperty="id">
        insert into svy_lib_template_script_wjx
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="oldid != null">oldid,</if>
            <if test="svyid != null">svyid,</if>
            <if test="scriptType != null">script_type,</if>
            <if test="scriptTopic != null">script_topic,</if>
            <if test="script != null">script,</if>
            <if test="scriptContent != null">script_content,</if>
            <if test="seqno != null">seqno,</if>
            <if test="scriptPicture != null">script_picture,</if>
            <if test="tag != null">tag,</if>
            <if test="sort != null">sort,</if>
            <if test="ismandatory != null">ismandatory,</if>
            <if test="ishide != null">ishide,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="orgid != null">orgid,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="svyTopicid != null">svy_topicid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="categoryid != null">categoryid,</if>
            <if test="suitway != null">suitway,</if>
            <if test="isavailable != null">isavailable,</if>
            <if test="language != null">language,</if>
            <if test="otherdata != null">otherdata,</if>
            <if test="valueType != null">value_type,</if>
            <if test="reply != null">reply,</if>
            <if test="scoretype != null">scoretype,</if>
            <if test="score != null">score,</if>
            <if test="scriptDesc != null">script_desc,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="oldid != null">#{oldid},</if>
            <if test="svyid != null">#{svyid},</if>
            <if test="scriptType != null">#{scriptType},</if>
            <if test="scriptTopic != null">#{scriptTopic},</if>
            <if test="script != null">#{script},</if>
            <if test="scriptContent != null">#{scriptContent},</if>
            <if test="seqno != null">#{seqno},</if>
            <if test="scriptPicture != null">#{scriptPicture},</if>
            <if test="tag != null">#{tag},</if>
            <if test="sort != null">#{sort},</if>
            <if test="ismandatory != null">#{ismandatory},</if>
            <if test="ishide != null">#{ishide},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="svyTopicid != null">#{svyTopicid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="categoryid != null">#{categoryid},</if>
            <if test="suitway != null">#{suitway},</if>
            <if test="isavailable != null">#{isavailable},</if>
            <if test="language != null">#{language},</if>
            <if test="otherdata != null">#{otherdata},</if>
            <if test="valueType != null">#{valueType},</if>
            <if test="reply != null">#{reply},</if>
            <if test="scoretype != null">#{scoretype},</if>
            <if test="score != null">#{score},</if>
            <if test="scriptDesc != null">#{scriptDesc},</if>
         </trim>
    </insert>

    <update id="updateSvyLibTemplateScriptWjx" parameterType="com.smartor.domain.SvyLibTemplateScriptWjx">
        update svy_lib_template_script_wjx
        <trim prefix="SET" suffixOverrides=",">
            <if test="oldid != null">oldid = #{oldid},</if>
            <if test="svyid != null">svyid = #{svyid},</if>
            <if test="scriptType != null">script_type = #{scriptType},</if>
            <if test="scriptTopic != null">script_topic = #{scriptTopic},</if>
            <if test="script != null">script = #{script},</if>
            <if test="scriptContent != null">script_content = #{scriptContent},</if>
            <if test="seqno != null">seqno = #{seqno},</if>
            <if test="scriptPicture != null">script_picture = #{scriptPicture},</if>
            <if test="tag != null">tag = #{tag},</if>
            <if test="sort != null">sort = #{sort},</if>
            <if test="ismandatory != null">ismandatory = #{ismandatory},</if>
            <if test="ishide != null">ishide = #{ishide},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="svyTopicid != null">svy_topicid = #{svyTopicid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="categoryid != null">categoryid = #{categoryid},</if>
            <if test="suitway != null">suitway = #{suitway},</if>
            <if test="isavailable != null">isavailable = #{isavailable},</if>
            <if test="language != null">language = #{language},</if>
            <if test="otherdata != null">otherdata = #{otherdata},</if>
            <if test="valueType != null">value_type = #{valueType},</if>
            <if test="reply != null">reply = #{reply},</if>
            <if test="scoretype != null">scoretype = #{scoretype},</if>
            <if test="score != null">score = #{score},</if>
            <if test="scriptDesc != null">script_desc = #{scriptDesc},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteSvyLibTemplateScriptWjxById" parameterType="Long">
        delete from svy_lib_template_script_wjx where id = #{id}
    </delete>

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

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

@@ -37,12 +37,16 @@
        <result property="guid" column="guid"/>
        <result property="picturePath" column="picture_path"/>
        <result property="score" column="score"/>
        <result property="appendflag" column="appendflag"/>
        <result property="appenddesc" column="appenddesc"/>
    </resultMap>

    <sql id="selectSvyLibTemplateTargetoptionVo">
        select id,
               groupid,
               score,
               appendflag,
               appenddesc,
               categoryName,
               scriptid,
               templateID,
@@ -97,6 +101,8 @@
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="score != null  and score != ''">and score = #{score}</if>
            <if test="picturePath != null  and picturePath != ''">and picture_path = #{picturePath}</if>
            <if test="appendflag != null">and appendflag = #{appendflag}</if>
            <if test="appenddesc != null">and appenddesc = #{appenddesc}</if>
        </where>
    </select>

@@ -140,6 +146,8 @@
            <if test="guid != null">guid,</if>
            <if test="picturePath != null">picture_path,</if>
            <if test="score != null">score,</if>
            <if test="appendflag != null">appendflag,</if>
            <if test="appenddesc != null">appenddesc,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="groupid != null">#{groupid},</if>
@@ -173,6 +181,8 @@
            <if test="guid != null">#{guid},</if>
            <if test="picturePath != null">#{picturePath},</if>
            <if test="score != null">#{score},</if>
            <if test="appendflag != null">#{appendflag},</if>
            <if test="appenddesc != null">#{appenddesc},</if>
        </trim>
    </insert>

@@ -210,6 +220,8 @@
            <if test="guid != null">guid = #{guid},</if>
            <if test="picturePath != null">picture_path = #{picturePath},</if>
            <if test="score != null">score = #{score},</if>
            <if test="appendflag != null">appendflag = #{appendflag},</if>
            <if test="appenddesc != null">appenddesc = #{appenddesc},</if>
        </trim>
        where id = #{id}
    </update>

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,243 @@
<?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.SvyLibTemplateTargetoptionWjxMapper">

    <resultMap type="com.smartor.domain.SvyLibTemplateTargetoptionWjx" id="SvyLibTemplateTargetoptionWjxResult">
        <result property="id" column="id"/>
        <result property="groupid" column="groupid"/>
        <result property="categoryName" column="categoryName"/>
        <result property="scriptid" column="scriptid"/>
        <result property="templateID" column="templateID"/>
        <result property="targettype" column="targettype"/>
        <result property="targetid" column="targetid"/>
        <result property="targetname" column="targetname"/>
        <result property="targetvalue" column="targetvalue"/>
        <result property="isabnormal" column="isabnormal"/>
        <result property="warnup" column="warnup"/>
        <result property="warndown" column="warndown"/>
        <result property="targetregex" column="targetregex"/>
        <result property="targetregex2" column="targetregex2"/>
        <result property="dynamiccruxs" column="dynamiccruxs"/>
        <result property="nodynamiccruxs" column="nodynamiccruxs"/>
        <result property="optioncontent" column="optioncontent"/>
        <result property="nextQuestion" column="next_question"/>
        <result property="language" column="language"/>
        <result property="version" column="version"/>
        <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="orgid" column="orgid"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
        <result property="picturePath" column="picture_path"/>
        <result property="score" column="score"/>
        <result property="appendflag" column="appendflag"/>
        <result property="appenddesc" column="appenddesc"/>
        <result property="sort" column="sort"/>
    </resultMap>

    <sql id="selectSvyLibTemplateTargetoptionWjxVo">
        select id,
               groupid,
               sort,
               categoryName,
               scriptid,
               templateID,
               targettype,
               targetid,
               targetname,
               targetvalue,
               isabnormal,
               warnup,
               warndown,
               targetregex,
               targetregex2,
               dynamiccruxs,
               nodynamiccruxs,
               optioncontent,
               next_question, language, version, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, picture_path, score, appendflag, appenddesc
        from svy_lib_template_targetoption_wjx
    </sql>

    <select id="selectSvyLibTemplateTargetoptionWjxList"
            parameterType="com.smartor.domain.SvyLibTemplateTargetoptionWjx"
            resultMap="SvyLibTemplateTargetoptionWjxResult">
        <include refid="selectSvyLibTemplateTargetoptionWjxVo"/>
        <where>
            <if test="groupid != null  and groupid != ''">and groupid = #{groupid}</if>
            <if test="categoryName != null  and categoryName != ''">and categoryName like concat('%', #{categoryName},
                '%')
            </if>
            <if test="scriptid != null ">and scriptid = #{scriptid}</if>
            <if test="templateID != null ">and templateID = #{templateID}</if>
            <if test="targettype != null  and targettype != ''">and targettype = #{targettype}</if>
            <if test="targetid != null ">and targetid = #{targetid}</if>
            <if test="targetname != null  and targetname != ''">and targetname like concat('%', #{targetname}, '%')</if>
            <if test="targetvalue != null  and targetvalue != ''">and targetvalue = #{targetvalue}</if>
            <if test="isabnormal != null ">and isabnormal = #{isabnormal}</if>
            <if test="warnup != null ">and warnup = #{warnup}</if>
            <if test="warndown != null ">and warndown = #{warndown}</if>
            <if test="targetregex != null  and targetregex != ''">and targetregex = #{targetregex}</if>
            <if test="targetregex2 != null  and targetregex2 != ''">and targetregex2 = #{targetregex2}</if>
            <if test="dynamiccruxs != null  and dynamiccruxs != ''">and dynamiccruxs = #{dynamiccruxs}</if>
            <if test="nodynamiccruxs != null  and nodynamiccruxs != ''">and nodynamiccruxs = #{nodynamiccruxs}</if>
            <if test="optioncontent != null  and optioncontent != ''">and optioncontent = #{optioncontent}</if>
            <if test="nextQuestion != null ">and next_question = #{nextQuestion}</if>
            <if test="language != null  and language != ''">and language = #{language}</if>
            <if test="version != null  and version != ''">and version = #{version}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="picturePath != null  and picturePath != ''">and picture_path = #{picturePath}</if>
            <if test="score != null  and score != ''">and score = #{score}</if>
            <if test="appendflag != null  and appendflag != ''">and appendflag = #{appendflag}</if>
            <if test="appenddesc != null  and appenddesc != ''">and appenddesc = #{appenddesc}</if>
            <if test="sort != null">and sort = #{sort}</if>
        </where>
    </select>

    <select id="selectSvyLibTemplateTargetoptionWjxById" parameterType="Long"
            resultMap="SvyLibTemplateTargetoptionWjxResult">
        <include refid="selectSvyLibTemplateTargetoptionWjxVo"/>
        where id = #{id}
    </select>

    <insert id="insertSvyLibTemplateTargetoptionWjx" parameterType="com.smartor.domain.SvyLibTemplateTargetoptionWjx"
            useGeneratedKeys="true" keyProperty="id">
        insert into svy_lib_template_targetoption_wjx
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="groupid != null">groupid,</if>
            <if test="categoryName != null">categoryName,</if>
            <if test="scriptid != null">scriptid,</if>
            <if test="templateID != null">templateID,</if>
            <if test="targettype != null">targettype,</if>
            <if test="targetid != null">targetid,</if>
            <if test="targetname != null">targetname,</if>
            <if test="targetvalue != null">targetvalue,</if>
            <if test="isabnormal != null">isabnormal,</if>
            <if test="warnup != null">warnup,</if>
            <if test="warndown != null">warndown,</if>
            <if test="targetregex != null">targetregex,</if>
            <if test="targetregex2 != null">targetregex2,</if>
            <if test="dynamiccruxs != null">dynamiccruxs,</if>
            <if test="nodynamiccruxs != null">nodynamiccruxs,</if>
            <if test="optioncontent != null">optioncontent,</if>
            <if test="nextQuestion != null">next_question,</if>
            <if test="language != null">language,</if>
            <if test="version != null">version,</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="orgid != null">orgid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="picturePath != null">picture_path,</if>
            <if test="score != null">score,</if>
            <if test="appendflag != null">appendflag,</if>
            <if test="appenddesc != null">appenddesc,</if>
            <if test="sort != null">sort,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="groupid != null">#{groupid},</if>
            <if test="categoryName != null">#{categoryName},</if>
            <if test="scriptid != null">#{scriptid},</if>
            <if test="templateID != null">#{templateID},</if>
            <if test="targettype != null">#{targettype},</if>
            <if test="targetid != null">#{targetid},</if>
            <if test="targetname != null">#{targetname},</if>
            <if test="targetvalue != null">#{targetvalue},</if>
            <if test="isabnormal != null">#{isabnormal},</if>
            <if test="warnup != null">#{warnup},</if>
            <if test="warndown != null">#{warndown},</if>
            <if test="targetregex != null">#{targetregex},</if>
            <if test="targetregex2 != null">#{targetregex2},</if>
            <if test="dynamiccruxs != null">#{dynamiccruxs},</if>
            <if test="nodynamiccruxs != null">#{nodynamiccruxs},</if>
            <if test="optioncontent != null">#{optioncontent},</if>
            <if test="nextQuestion != null">#{nextQuestion},</if>
            <if test="language != null">#{language},</if>
            <if test="version != null">#{version},</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="orgid != null">#{orgid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="picturePath != null">#{picturePath},</if>
            <if test="score != null">#{score},</if>
            <if test="appendflag != null">#{appendflag},</if>
            <if test="appenddesc != null">#{appenddesc},</if>
            <if test="sort != null">#{sort},</if>
        </trim>
    </insert>

    <update id="updateSvyLibTemplateTargetoptionWjx" parameterType="com.smartor.domain.SvyLibTemplateTargetoptionWjx">
        update svy_lib_template_targetoption_wjx
        <trim prefix="SET" suffixOverrides=",">
            <if test="groupid != null">groupid = #{groupid},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <if test="scriptid != null">scriptid = #{scriptid},</if>
            <if test="templateID != null">templateID = #{templateID},</if>
            <if test="targettype != null">targettype = #{targettype},</if>
            <if test="targetid != null">targetid = #{targetid},</if>
            <if test="targetname != null">targetname = #{targetname},</if>
            <if test="targetvalue != null">targetvalue = #{targetvalue},</if>
            <if test="isabnormal != null">isabnormal = #{isabnormal},</if>
            <if test="warnup != null">warnup = #{warnup},</if>
            <if test="warndown != null">warndown = #{warndown},</if>
            <if test="targetregex != null">targetregex = #{targetregex},</if>
            <if test="targetregex2 != null">targetregex2 = #{targetregex2},</if>
            <if test="dynamiccruxs != null">dynamiccruxs = #{dynamiccruxs},</if>
            <if test="nodynamiccruxs != null">nodynamiccruxs = #{nodynamiccruxs},</if>
            <if test="optioncontent != null">optioncontent = #{optioncontent},</if>
            <if test="nextQuestion != null">next_question = #{nextQuestion},</if>
            <if test="language != null">language = #{language},</if>
            <if test="version != null">version = #{version},</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="orgid != null">orgid = #{orgid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="picturePath != null">picture_path = #{picturePath},</if>
            <if test="score != null">score = #{score},</if>
            <if test="appendflag != null">appendflag = #{appendflag},</if>
            <if test="appenddesc != null">appenddesc = #{appenddesc},</if>
            <if test="sort != null">sort = #{sort},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteSvyLibTemplateTargetoptionWjxById" parameterType="Long">
        delete
        from svy_lib_template_targetoption_wjx
        where id = #{id}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,251 @@
<?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.SvyLibTemplateWjxMapper">

    <resultMap type="com.smartor.domain.SvyLibTemplateWjx" id="SvyLibTemplateWjxResult">
        <result property="svyid" column="svyid"/>
        <result property="templateid" column="templateid"/>
        <result property="categoryid" column="categoryid"/>
        <result property="svycode" column="svycode"/>
        <result property="svyname" column="svyname"/>
        <result property="description" column="description"/>
        <result property="introduce" column="introduce"/>
        <result property="submitprompt" column="submitprompt"/>
        <result property="tag" column="tag"/>
        <result property="version" column="version"/>
        <result property="centerlibrarycode" column="centerlibrarycode"/>
        <result property="centerlibraryid" column="centerlibraryid"/>
        <result property="islocal" column="islocal"/>
        <result property="isenable" column="isenable"/>
        <result property="orgid" column="orgid"/>
        <result property="delFlag" column="del_flag"/>
        <result property="createBy" column="create_by"/>
        <result property="createTime" column="create_time"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
        <result property="isupload" column="isupload"/>
        <result property="uploadTime" column="upload_time"/>
        <result property="topicid" column="topicid"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
        <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"/>
        <result property="valueType" column="value_type"/>
        <result property="reply" column="reply"/>
        <result property="scriptScore" column="script_score"/>
        <result property="scoreType" column="score_type"/>
    </resultMap>

    <sql id="selectSvyLibTemplateWjxVo">
        select svyid,
               templateid,
               categoryid,
               svycode,
               svyname,
               description,
               introduce,
               submitprompt,
               tag,
               version,
               centerlibrarycode,
               centerlibraryid,
               islocal,
               isenable,
               orgid,
               del_flag,
               create_by,
               create_time,
               update_by,
               update_time,
               isupload,
               upload_time,
               topicid,
               pid,
               guid,
               dept_names,
               label_info,
               campus,
               suitway,
               otherdata,
               value_type,
               reply,
               script_score,
               score_type
        from svy_lib_template_wjx
    </sql>

    <select id="selectSvyLibTemplateWjxList" parameterType="com.smartor.domain.SvyLibTemplateWjx"
            resultMap="SvyLibTemplateWjxResult">
        <include refid="selectSvyLibTemplateWjxVo"/>
        <where>
            <if test="templateid != null ">and templateid = #{templateid}</if>
            <if test="categoryid != null ">and categoryid = #{categoryid}</if>
            <if test="svycode != null  and svycode != ''">and svycode = #{svycode}</if>
            <if test="svyname != null  and svyname != ''">and svyname like concat('%', #{svyname}, '%')</if>
            <if test="description != null  and description != ''">and description = #{description}</if>
            <if test="introduce != null  and introduce != ''">and introduce = #{introduce}</if>
            <if test="submitprompt != null  and submitprompt != ''">and submitprompt = #{submitprompt}</if>
            <if test="tag != null  and tag != ''">and tag = #{tag}</if>
            <if test="version != null ">and version = #{version}</if>
            <if test="centerlibrarycode != null  and centerlibrarycode != ''">and centerlibrarycode =
                #{centerlibrarycode}
            </if>
            <if test="centerlibraryid != null ">and centerlibraryid = #{centerlibraryid}</if>
            <if test="islocal != null ">and islocal = #{islocal}</if>
            <if test="isenable != null  and isenable != ''">and isenable = #{isenable}</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="topicid != null  and topicid != ''">and topicid = #{topicid}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="deptNames != null  and deptNames != ''">and dept_names = #{deptNames}</if>
            <if test="labelInfo != null  and labelInfo != ''">and label_info = #{labelInfo}</if>
            <if test="campus != null  and campus != ''">and campus = #{campus}</if>
            <if test="suitway != null  and suitway != ''">and suitway = #{suitway}</if>
            <if test="otherdata != null  and otherdata != ''">and otherdata = #{otherdata}</if>
            <if test="valueType != null  and valueType != ''">and value_type = #{valueType}</if>
            <if test="reply != null  and reply != ''">and reply = #{reply}</if>
            <if test="scriptScore != null  and scriptScore != ''">and script_score = #{scriptScore}</if>
            <if test="scoreType != null  and scoreType != ''">and score_type = #{scoreType}</if>
        </where>
    </select>

    <select id="selectSvyLibTemplateWjxBySvyid" parameterType="Long" resultMap="SvyLibTemplateWjxResult">
        <include refid="selectSvyLibTemplateWjxVo"/>
        where svyid = #{svyid}
    </select>

    <insert id="insertSvyLibTemplateWjx" parameterType="com.smartor.domain.SvyLibTemplateWjx" useGeneratedKeys="true"
            keyProperty="svyid">
        insert into svy_lib_template_wjx
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateid != null">templateid,</if>
            <if test="categoryid != null">categoryid,</if>
            <if test="svycode != null">svycode,</if>
            <if test="svyname != null">svyname,</if>
            <if test="description != null">description,</if>
            <if test="introduce != null">introduce,</if>
            <if test="submitprompt != null">submitprompt,</if>
            <if test="tag != null">tag,</if>
            <if test="version != null">version,</if>
            <if test="centerlibrarycode != null">centerlibrarycode,</if>
            <if test="centerlibraryid != null">centerlibraryid,</if>
            <if test="islocal != null">islocal,</if>
            <if test="isenable != null">isenable,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="topicid != null">topicid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</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>
            <if test="valueType != null">value_type,</if>
            <if test="reply != null">reply,</if>
            <if test="scriptScore != null">script_score,</if>
            <if test="scoreType != null">score_type,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="templateid != null">#{templateid},</if>
            <if test="categoryid != null">#{categoryid},</if>
            <if test="svycode != null">#{svycode},</if>
            <if test="svyname != null">#{svyname},</if>
            <if test="description != null">#{description},</if>
            <if test="introduce != null">#{introduce},</if>
            <if test="submitprompt != null">#{submitprompt},</if>
            <if test="tag != null">#{tag},</if>
            <if test="version != null">#{version},</if>
            <if test="centerlibrarycode != null">#{centerlibrarycode},</if>
            <if test="centerlibraryid != null">#{centerlibraryid},</if>
            <if test="islocal != null">#{islocal},</if>
            <if test="isenable != null">#{isenable},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="topicid != null">#{topicid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</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>
            <if test="valueType != null">#{valueType},</if>
            <if test="reply != null">#{reply},</if>
            <if test="scriptScore != null">#{scriptScore},</if>
            <if test="scoreType != null">#{scoreType},</if>
        </trim>
    </insert>

    <update id="updateSvyLibTemplateWjx" parameterType="com.smartor.domain.SvyLibTemplateWjx">
        update svy_lib_template_wjx
        <trim prefix="SET" suffixOverrides=",">
            <if test="templateid != null">templateid = #{templateid},</if>
            <if test="categoryid != null">categoryid = #{categoryid},</if>
            <if test="svycode != null">svycode = #{svycode},</if>
            <if test="svyname != null">svyname = #{svyname},</if>
            <if test="description != null">description = #{description},</if>
            <if test="introduce != null">introduce = #{introduce},</if>
            <if test="submitprompt != null">submitprompt = #{submitprompt},</if>
            <if test="tag != null">tag = #{tag},</if>
            <if test="version != null">version = #{version},</if>
            <if test="centerlibrarycode != null">centerlibrarycode = #{centerlibrarycode},</if>
            <if test="centerlibraryid != null">centerlibraryid = #{centerlibraryid},</if>
            <if test="islocal != null">islocal = #{islocal},</if>
            <if test="isenable != null">isenable = #{isenable},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="topicid != null">topicid = #{topicid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</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>
            <if test="valueType != null">value_type = #{valueType},</if>
            <if test="reply != null">reply = #{reply},</if>
            <if test="scriptScore != null">script_score = #{scriptScore},</if>
            <if test="scoreType != null">score_type = #{scoreType},</if>
        </trim>
        where svyid = #{svyid}
    </update>

    <delete id="deleteSvyLibTemplateWjxBySvyid" parameterType="Long">
        delete
        from svy_lib_template_wjx
        where svyid = #{svyid}
    </delete>

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

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

@@ -1,96 +1,85 @@
<?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">
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.smartor.mapper.SvyTaskTemplateScriptMapper">

    <resultMap type="com.smartor.domain.SvyTaskTemplateScript" id="SvyTaskTemplateScriptResult">
        <result property="ID"    column="ID"    />
        <result property="taskid"    column="taskid"    />
        <result property="scriptno"    column="scriptno"    />
        <result property="templateID"    column="templateID"    />
        <result property="scriptid"    column="scriptid"    />
        <result property="scriptDesc"    column="script_desc"    />
        <result property="language"    column="language"    />
        <result property="categoryName"    column="categoryName"    />
        <result property="scriptPoint"    column="script_point"    />
        <result property="scriptContent"    column="script_content"    />
        <result property="scriptVoice"    column="script_voice"    />
        <result property="noMatchText"    column="noMatchText"    />
        <result property="noMatchVoice"    column="noMatchVoice"    />
        <result property="slienceText"    column="slienceText"    />
        <result property="slienceVoice"    column="slienceVoice"    />
        <result property="submoduleText"    column="submoduleText"    />
        <result property="submoduleVoice"    column="submoduleVoice"    />
        <result property="noClearlyText"    column="noClearlyText"    />
        <result property="noClearlyVoice"    column="noClearlyVoice"    />
        <result property="isMust"    column="is_must"    />
        <result property="playWavOnly"    column="playWavOnly"    />
        <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="orgid"    column="orgid"    />
        <result property="pid"    column="pid"    />
        <result property="guid"    column="guid"    />
        <result property="valueType"    column="value_type"    />
        <result property="targetOptions"    column="targetOptions"    />
        <result property="targettype"    column="targettype"    />
        <result property="targetid"    column="targetid"    />
        <result property="targetvalue"    column="targetvalue"    />
        <result property="nextScriptno"    column="next_scriptno"    />
        <result property="scriptResult"    column="script_result"    />
        <result property="otherdata"    column="otherdata"    />
        <result property="picturePath"    column="picture_path"    />
        <result property="sort"    column="sort"    />
        <result property="scriptTopic"    column="script_topic"    />
        <result property="ID" column="ID"/>
        <result property="taskid" column="taskid"/>
        <result property="scriptno" column="scriptno"/>
        <result property="templateID" column="templateID"/>
        <result property="scriptid" column="scriptid"/>
        <result property="scriptDesc" column="script_desc"/>
        <result property="language" column="language"/>
        <result property="categoryName" column="categoryName"/>
        <result property="scriptContent" column="script_content"/>
        <result property="isMust" column="is_must"/>
        <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="orgid" column="orgid"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
        <result property="valueType" column="value_type"/>
        <result property="targetOptions" column="targetOptions"/>
        <result property="targettype" column="targettype"/>
        <result property="targetid" column="targetid"/>
        <result property="targetvalue" column="targetvalue"/>
        <result property="nextScriptno" column="next_scriptno"/>
        <result property="scriptResult" column="script_result"/>
        <result property="otherdata" column="otherdata"/>
        <result property="picturePath" column="picture_path"/>
        <result property="sort" column="sort"/>
        <result property="scriptTopic" column="script_topic"/>
    </resultMap>

    <sql id="selectSvyTaskTemplateScriptVo">
        select ID,sort,script_desc, taskid, scriptno, templateID, scriptid, script_topic, language, categoryName, script_point, script_content, script_voice, noMatchText, noMatchVoice, slienceText, slienceVoice, submoduleText, submoduleVoice, noClearlyText, noClearlyVoice, is_must, playWavOnly, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, value_type, targetOptions, targettype, targetid, targetvalue, next_scriptno, script_result, otherdata, picture_path from svy_task_template_script
        select ID,
               sort,
               script_desc,
               taskid,
               scriptno,
               templateID,
               scriptid,
               script_topic, language, categoryName, script_content, is_must, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, value_type, targetOptions, targettype, targetid, targetvalue, next_scriptno, script_result, otherdata, picture_path
        from svy_task_template_script
    </sql>

    <select id="selectSvyTaskTemplateScriptList" parameterType="com.smartor.domain.SvyTaskTemplateScript" resultMap="SvyTaskTemplateScriptResult">
    <select id="selectSvyTaskTemplateScriptList" parameterType="com.smartor.domain.SvyTaskTemplateScript"
            resultMap="SvyTaskTemplateScriptResult">
        <include refid="selectSvyTaskTemplateScriptVo"/>
        <where>
            <if test="taskid != null "> and taskid = #{taskid}</if>
            <if test="scriptno != null "> and scriptno = #{scriptno}</if>
            <if test="templateID != null "> and templateID = #{templateID}</if>
            <if test="scriptid != null "> and scriptid = #{scriptid}</if>
            <if test="scriptDesc != null  and scriptDesc != ''"> and script_desc = #{scriptDesc}</if>
            <if test="language != null  and language != ''"> and language = #{language}</if>
            <if test="categoryName != null  and categoryName != ''"> and categoryName like concat('%', #{categoryName}, '%')</if>
            <if test="scriptPoint != null  and scriptPoint != ''"> and script_point = #{scriptPoint}</if>
            <if test="scriptContent != null  and scriptContent != ''"> and script_content = #{scriptContent}</if>
            <if test="scriptVoice != null  and scriptVoice != ''"> and script_voice = #{scriptVoice}</if>
            <if test="noMatchText != null  and noMatchText != ''"> and noMatchText = #{noMatchText}</if>
            <if test="noMatchVoice != null  and noMatchVoice != ''"> and noMatchVoice = #{noMatchVoice}</if>
            <if test="slienceText != null  and slienceText != ''"> and slienceText = #{slienceText}</if>
            <if test="slienceVoice != null  and slienceVoice != ''"> and slienceVoice = #{slienceVoice}</if>
            <if test="submoduleText != null  and submoduleText != ''"> and submoduleText = #{submoduleText}</if>
            <if test="submoduleVoice != null  and submoduleVoice != ''"> and submoduleVoice = #{submoduleVoice}</if>
            <if test="noClearlyText != null  and noClearlyText != ''"> and noClearlyText = #{noClearlyText}</if>
            <if test="noClearlyVoice != null  and noClearlyVoice != ''"> and noClearlyVoice = #{noClearlyVoice}</if>
            <if test="isMust != null  and isMust != ''"> and is_must = #{isMust}</if>
            <if test="playWavOnly != null "> and playWavOnly = #{playWavOnly}</if>
            <if test="isupload != null "> and isupload = #{isupload}</if>
            <if test="uploadTime != null "> and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''"> and orgid = #{orgid}</if>
            <if test="pid != null "> and pid = #{pid}</if>
            <if test="guid != null  and guid != ''"> and guid = #{guid}</if>
            <if test="valueType != null "> and value_type = #{valueType}</if>
            <if test="targetOptions != null  and targetOptions != ''"> and targetOptions = #{targetOptions}</if>
            <if test="targettype != null  and targettype != ''"> and targettype = #{targettype}</if>
            <if test="targetid != null "> and targetid = #{targetid}</if>
            <if test="targetvalue != null  and targetvalue != ''"> and targetvalue = #{targetvalue}</if>
            <if test="nextScriptno != null "> and next_scriptno = #{nextScriptno}</if>
            <if test="scriptResult != null  and scriptResult != ''"> and script_result = #{scriptResult}</if>
            <if test="otherdata != null  and otherdata != ''"> and otherdata = #{otherdata}</if>
            <if test="picturePath != null  and picturePath != ''"> and picture_path = #{picturePath}</if>
            <if test="scriptTopic != null  and scriptTopic != ''"> and script_topic = #{scriptTopic}</if>
            <if test="taskid != null ">and taskid = #{taskid}</if>
            <if test="scriptno != null ">and scriptno = #{scriptno}</if>
            <if test="templateID != null ">and templateID = #{templateID}</if>
            <if test="scriptid != null ">and scriptid = #{scriptid}</if>
            <if test="scriptDesc != null  and scriptDesc != ''">and script_desc = #{scriptDesc}</if>
            <if test="language != null  and language != ''">and language = #{language}</if>
            <if test="categoryName != null  and categoryName != ''">and categoryName like concat('%', #{categoryName},
                '%')
            </if>
            <if test="scriptContent != null  and scriptContent != ''">and script_content = #{scriptContent}</if>
            <if test="isMust != null  and isMust != ''">and is_must = #{isMust}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="valueType != null ">and value_type = #{valueType}</if>
            <if test="targetOptions != null  and targetOptions != ''">and targetOptions = #{targetOptions}</if>
            <if test="targettype != null  and targettype != ''">and targettype = #{targettype}</if>
            <if test="targetid != null ">and targetid = #{targetid}</if>
            <if test="targetvalue != null  and targetvalue != ''">and targetvalue = #{targetvalue}</if>
            <if test="nextScriptno != null ">and next_scriptno = #{nextScriptno}</if>
            <if test="scriptResult != null  and scriptResult != ''">and script_result = #{scriptResult}</if>
            <if test="otherdata != null  and otherdata != ''">and otherdata = #{otherdata}</if>
            <if test="picturePath != null  and picturePath != ''">and picture_path = #{picturePath}</if>
            <if test="scriptTopic != null  and scriptTopic != ''">and script_topic = #{scriptTopic}</if>
        </where>
    </select>

@@ -99,7 +88,8 @@
        where ID = #{ID}
    </select>

    <insert id="insertSvyTaskTemplateScript" parameterType="com.smartor.domain.SvyTaskTemplateScript" useGeneratedKeys="true" keyProperty="ID">
    <insert id="insertSvyTaskTemplateScript" parameterType="com.smartor.domain.SvyTaskTemplateScript"
            useGeneratedKeys="true" keyProperty="ID">
        insert into svy_task_template_script
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="taskid != null">taskid,</if>
@@ -109,19 +99,8 @@
            <if test="scriptDesc != null">script_desc,</if>
            <if test="language != null">language,</if>
            <if test="categoryName != null">categoryName,</if>
            <if test="scriptPoint != null">script_point,</if>
            <if test="scriptContent != null">script_content,</if>
            <if test="scriptVoice != null">script_voice,</if>
            <if test="noMatchText != null">noMatchText,</if>
            <if test="noMatchVoice != null">noMatchVoice,</if>
            <if test="slienceText != null">slienceText,</if>
            <if test="slienceVoice != null">slienceVoice,</if>
            <if test="submoduleText != null">submoduleText,</if>
            <if test="submoduleVoice != null">submoduleVoice,</if>
            <if test="noClearlyText != null">noClearlyText,</if>
            <if test="noClearlyVoice != null">noClearlyVoice,</if>
            <if test="isMust != null">is_must,</if>
            <if test="playWavOnly != null">playWavOnly,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
@@ -143,7 +122,7 @@
            <if test="picturePath != null">picture_path,</if>
            <if test="sort != null">sort,</if>
            <if test="scriptTopic != null">script_topic,</if>
         </trim>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="taskid != null">#{taskid},</if>
            <if test="scriptno != null">#{scriptno},</if>
@@ -152,19 +131,8 @@
            <if test="scriptDesc != null">#{scriptDesc},</if>
            <if test="language != null">#{language},</if>
            <if test="categoryName != null">#{categoryName},</if>
            <if test="scriptPoint != null">#{scriptPoint},</if>
            <if test="scriptContent != null">#{scriptContent},</if>
            <if test="scriptVoice != null">#{scriptVoice},</if>
            <if test="noMatchText != null">#{noMatchText},</if>
            <if test="noMatchVoice != null">#{noMatchVoice},</if>
            <if test="slienceText != null">#{slienceText},</if>
            <if test="slienceVoice != null">#{slienceVoice},</if>
            <if test="submoduleText != null">#{submoduleText},</if>
            <if test="submoduleVoice != null">#{submoduleVoice},</if>
            <if test="noClearlyText != null">#{noClearlyText},</if>
            <if test="noClearlyVoice != null">#{noClearlyVoice},</if>
            <if test="isMust != null">#{isMust},</if>
            <if test="playWavOnly != null">#{playWavOnly},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
@@ -186,7 +154,7 @@
            <if test="picturePath != null">#{picturePath},</if>
            <if test="sort != null">#{sort},</if>
            <if test="scriptTopic != null">#{scriptTopic},</if>
         </trim>
        </trim>
    </insert>

    <update id="updateSvyTaskTemplateScript" parameterType="com.smartor.domain.SvyTaskTemplateScript">
@@ -199,19 +167,8 @@
            <if test="scriptDesc != null">script_desc = #{scriptDesc},</if>
            <if test="language != null">language = #{language},</if>
            <if test="categoryName != null">categoryName = #{categoryName},</if>
            <if test="scriptPoint != null">script_point = #{scriptPoint},</if>
            <if test="scriptContent != null">script_content = #{scriptContent},</if>
            <if test="scriptVoice != null">script_voice = #{scriptVoice},</if>
            <if test="noMatchText != null">noMatchText = #{noMatchText},</if>
            <if test="noMatchVoice != null">noMatchVoice = #{noMatchVoice},</if>
            <if test="slienceText != null">slienceText = #{slienceText},</if>
            <if test="slienceVoice != null">slienceVoice = #{slienceVoice},</if>
            <if test="submoduleText != null">submoduleText = #{submoduleText},</if>
            <if test="submoduleVoice != null">submoduleVoice = #{submoduleVoice},</if>
            <if test="noClearlyText != null">noClearlyText = #{noClearlyText},</if>
            <if test="noClearlyVoice != null">noClearlyVoice = #{noClearlyVoice},</if>
            <if test="isMust != null">is_must = #{isMust},</if>
            <if test="playWavOnly != null">playWavOnly = #{playWavOnly},</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>
@@ -238,7 +195,9 @@
    </update>

    <delete id="deleteSvyTaskTemplateScriptByID" parameterType="Long">
        delete from svy_task_template_script where ID = #{ID}
        delete
        from svy_task_template_script
        where ID = #{ID}
    </delete>

    <delete id="deleteSvyTaskTemplateScriptByIDs" parameterType="String">