From 7f9e11864762e6a1f9231a7657e736d81b2abeb4 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期五, 22 十二月 2023 18:16:17 +0800
Subject: [PATCH] 代码提交
---
smartor/src/main/java/com/smartor/domain/IvrLibaScriptTarget.java | 161 ++++++++++++++++
smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetMapper.java | 56 +++++
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptTargetController.java | 91 +++++++++
smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetService.java | 54 +++++
smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetMapper.xml | 181 ++++++++++++++++++
5 files changed, 543 insertions(+), 0 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptTargetController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptTargetController.java
new file mode 100644
index 0000000..f53bf3e
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrLibaScriptTargetController.java
@@ -0,0 +1,91 @@
+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.IvrLibaScriptTarget;
+import com.smartor.service.IIvrLibaScriptTargetService;
+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;
+
+/**
+ * 闂璇濇湳鎸囨爣搴揅ontroller
+ *
+ * @author ruoyi
+ * @date 2023-12-21
+ */
+@RestController
+@RequestMapping("/smartor/scripttarget")
+public class IvrLibaScriptTargetController extends BaseController {
+ @Autowired
+ private IIvrLibaScriptTargetService ivrLibaScriptTargetService;
+
+ /**
+ * 鏌ヨ闂璇濇湳鎸囨爣搴撳垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('system:target:list')")
+ @PostMapping("/list")
+ public TableDataInfo list(@RequestBody IvrLibaScriptTarget ivrLibaScriptTarget) {
+ startPage();
+ List<IvrLibaScriptTarget> list = ivrLibaScriptTargetService.selectIvrLibaScriptTargetList(ivrLibaScriptTarget);
+ return getDataTable(list);
+ }
+
+ /**
+ * 瀵煎嚭闂璇濇湳鎸囨爣搴撳垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('system:target:export')")
+ @Log(title = "闂璇濇湳鎸囨爣搴�", businessType = BusinessType.EXPORT)
+ @PostMapping("/export")
+ public void export(HttpServletResponse response, IvrLibaScriptTarget ivrLibaScriptTarget) {
+ List<IvrLibaScriptTarget> list = ivrLibaScriptTargetService.selectIvrLibaScriptTargetList(ivrLibaScriptTarget);
+ ExcelUtil<IvrLibaScriptTarget> util = new ExcelUtil<IvrLibaScriptTarget>(IvrLibaScriptTarget.class);
+ util.exportExcel(response, list, "闂璇濇湳鎸囨爣搴撴暟鎹�");
+ }
+
+ /**
+ * 鑾峰彇闂璇濇湳鎸囨爣搴撹缁嗕俊鎭�
+ */
+ @PreAuthorize("@ss.hasPermi('system:target:query')")
+ @GetMapping(value = "/getInfo/{questionTargetID}")
+ public AjaxResult getInfo(@PathVariable("questionTargetID") String questionTargetID) {
+ return success(ivrLibaScriptTargetService.selectIvrLibaScriptTargetByQuestionTargetID(questionTargetID));
+ }
+
+ /**
+ * 鏂板闂璇濇湳鎸囨爣搴�
+ */
+ @PreAuthorize("@ss.hasPermi('system:target:add')")
+ @Log(title = "闂璇濇湳鎸囨爣搴�", businessType = BusinessType.INSERT)
+ @PostMapping("/add")
+ public AjaxResult add(@RequestBody IvrLibaScriptTarget ivrLibaScriptTarget) {
+ return toAjax(ivrLibaScriptTargetService.insertIvrLibaScriptTarget(ivrLibaScriptTarget));
+ }
+
+ /**
+ * 淇敼闂璇濇湳鎸囨爣搴�
+ */
+ @PreAuthorize("@ss.hasPermi('system:target:edit')")
+ @Log(title = "闂璇濇湳鎸囨爣搴�", businessType = BusinessType.UPDATE)
+ @PostMapping("/edit")
+ public AjaxResult edit(@RequestBody IvrLibaScriptTarget ivrLibaScriptTarget) {
+ return toAjax(ivrLibaScriptTargetService.updateIvrLibaScriptTarget(ivrLibaScriptTarget));
+ }
+
+ /**
+ * 鍒犻櫎闂璇濇湳鎸囨爣搴�
+ */
+ @PreAuthorize("@ss.hasPermi('system:target:remove')")
+ @Log(title = "闂璇濇湳鎸囨爣搴�", businessType = BusinessType.DELETE)
+ @GetMapping("/remove/{questionTargetIDs}")
+ public AjaxResult remove(@PathVariable Integer[] ids) {
+ return toAjax(ivrLibaScriptTargetService.deleteIvrLibaScriptTargetByQuestionTargetIDs(ids));
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaScriptTarget.java b/smartor/src/main/java/com/smartor/domain/IvrLibaScriptTarget.java
new file mode 100644
index 0000000..21c719f
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaScriptTarget.java
@@ -0,0 +1,161 @@
+package com.smartor.domain;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.common.core.domain.BaseEntity;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.Date;
+
+/**
+ * 闂璇濇湳鎸囨爣搴撳璞� ivr_liba_script_target
+ *
+ * @author ruoyi
+ * @date 2023-12-21
+ */
+@Data
+@ApiModel(value = "IvrLibaScriptTarget", description = "闂璇濇湳鎸囨爣搴撳璞�")
+public class IvrLibaScriptTarget extends BaseEntity {
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("涓婚敭")
+ private Long id;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("闂id")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private Long scriptid;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鎸囨爣ID")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private Long targetID;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鎸囨爣绫诲瀷")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private String targetType;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("绫诲埆鍚�")
+ @Excel(name = "${绫诲埆鍚峿", readConverterExp = "$column.readConverterExp()")
+ private String categoryName;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鎸囨爣鍊�")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private String targetValue;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鍩虹鐨勬鍒�")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private String basicRegex;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鏈韩鐨勬鍒�")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private String selfRegex;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("姝ｅ垯浣跨敤绫诲瀷")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private String regexUsedType;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鍒嗛〉")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private Long sort;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鐗堟湰")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private Long version;
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("鏄惁鍙敤")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private Long isEnable;
+
+
+ /**
+ * $column.columnComment
+ */
+ @ApiModelProperty("椤剁珯json")
+ @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
+ private String tipsJson;
+
+ /**
+ * 鍒犻櫎鏍囪
+ */
+ @ApiModelProperty("鍒犻櫎鏍囪")
+ private String delFlag;
+
+ /**
+ * 涓婁紶鏍囪
+ */
+ @ApiModelProperty("涓婁紶鏍囪")
+ @Excel(name = " 涓婁紶鏍囪 ")
+ private Long isupload;
+
+ /**
+ * 涓婁紶鏃堕棿
+ */
+ @ApiModelProperty("涓婁紶鏃堕棿")
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date uploadTime;
+
+ /**
+ * 鏈烘瀯ID
+ */
+ @ApiModelProperty("鏈烘瀯ID")
+ @Excel(name = " 鏈烘瀯ID ")
+ private String orgid;
+
+ /**
+ * 鐖禝D
+ */
+ @ApiModelProperty("鐖禝D")
+ @Excel(name = "鐖禝D")
+ private Long pid;
+
+ /**
+ * GUID
+ */
+ @ApiModelProperty("GUID")
+ @Excel(name = "GUID")
+ private String guid;
+
+ /**
+ * 鏄惁瀛樺湪鎿嶄綔锛�1 鏂板 2淇敼 3鍒犻櫎
+ */
+ @ApiModelProperty(value = "鏄惁瀛樺湪鎿嶄綔锛�1 鏂板 2淇敼 3鍒犻櫎")
+ private Integer isoperation;
+}
diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetMapper.java
new file mode 100644
index 0000000..3413d50
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetMapper.java
@@ -0,0 +1,56 @@
+package com.smartor.mapper;
+
+import com.smartor.domain.IvrLibaScriptTarget;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.List;
+
+/**
+ * 闂璇濇湳鎸囨爣搴揗apper鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2023-12-21
+ */
+@Mapper
+public interface IvrLibaScriptTargetMapper {
+ /**
+ * 鏌ヨ闂璇濇湳鎸囨爣搴�
+ *
+ * @param questionTargetID 闂璇濇湳鎸囨爣搴撲富閿�
+ * @return 闂璇濇湳鎸囨爣搴�
+ */
+ public IvrLibaScriptTarget selectIvrLibaScriptTargetByQuestionTargetID(String questionTargetID);
+
+ /**
+ * 鏌ヨ闂璇濇湳鎸囨爣搴撳垪琛�
+ *
+ * @param ivrLibaScriptTarget 闂璇濇湳鎸囨爣搴�
+ * @return 闂璇濇湳鎸囨爣搴撻泦鍚�
+ */
+ public List<IvrLibaScriptTarget> selectIvrLibaScriptTargetList(IvrLibaScriptTarget ivrLibaScriptTarget);
+
+ /**
+ * 鏂板闂璇濇湳鎸囨爣搴�
+ *
+ * @param ivrLibaScriptTarget 闂璇濇湳鎸囨爣搴�
+ * @return 缁撴灉
+ */
+ public int insertIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);
+
+ /**
+ * 淇敼闂璇濇湳鎸囨爣搴�
+ *
+ * @param ivrLibaScriptTarget 闂璇濇湳鎸囨爣搴�
+ * @return 缁撴灉
+ */
+ public int updateIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);
+
+ /**
+ * 鍒犻櫎闂璇濇湳鎸囨爣搴�
+ *
+ * @param questionTargetID 闂璇濇湳鎸囨爣搴撲富閿�
+ * @return 缁撴灉
+ */
+ public int deleteIvrLibaScriptTargetByQuestionTargetID(Long id);
+
+}
diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetService.java
new file mode 100644
index 0000000..10125b8
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetService.java
@@ -0,0 +1,54 @@
+package com.smartor.service;
+
+import com.smartor.domain.IvrLibaScriptTarget;
+
+import java.util.List;
+
+/**
+ * 闂璇濇湳鎸囨爣搴揝ervice鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2023-12-21
+ */
+public interface IIvrLibaScriptTargetService {
+ /**
+ * 鏌ヨ闂璇濇湳鎸囨爣搴�
+ *
+ * @param questionTargetID 闂璇濇湳鎸囨爣搴撲富閿�
+ * @return 闂璇濇湳鎸囨爣搴�
+ */
+ public IvrLibaScriptTarget selectIvrLibaScriptTargetByQuestionTargetID(String questionTargetID);
+
+ /**
+ * 鏌ヨ闂璇濇湳鎸囨爣搴撳垪琛�
+ *
+ * @param ivrLibaScriptTarget 闂璇濇湳鎸囨爣搴�
+ * @return 闂璇濇湳鎸囨爣搴撻泦鍚�
+ */
+ public List<IvrLibaScriptTarget> selectIvrLibaScriptTargetList(IvrLibaScriptTarget ivrLibaScriptTarget);
+
+ /**
+ * 鏂板闂璇濇湳鎸囨爣搴�
+ *
+ * @param ivrLibaScriptTarget 闂璇濇湳鎸囨爣搴�
+ * @return 缁撴灉
+ */
+ public int insertIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);
+
+ /**
+ * 淇敼闂璇濇湳鎸囨爣搴�
+ *
+ * @param ivrLibaScriptTarget 闂璇濇湳鎸囨爣搴�
+ * @return 缁撴灉
+ */
+ public int updateIvrLibaScriptTarget(IvrLibaScriptTarget ivrLibaScriptTarget);
+
+ /**
+ * 鎵归噺鍒犻櫎闂璇濇湳鎸囨爣搴�
+ *
+ * @param questionTargetIDs 闇�瑕佸垹闄ょ殑闂璇濇湳鎸囨爣搴撲富閿泦鍚�
+ * @return 缁撴灉
+ */
+ public int deleteIvrLibaScriptTargetByQuestionTargetIDs(Integer[] ids);
+
+}
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetMapper.xml
new file mode 100644
index 0000000..652855c
--- /dev/null
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetMapper.xml
@@ -0,0 +1,181 @@
+<?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.IvrLibaScriptTargetMapper">
+
+ <resultMap type="com.smartor.domain.IvrLibaScriptTarget" id="IvrLibaScriptTargetResult">
+ <result property="id" column="id"/>
+ <result property="scriptid" column="scriptid"/>
+ <result property="targetID" column="targetID"/>
+ <result property="targetType" column="targetType"/>
+ <result property="categoryName" column="categoryName"/>
+ <result property="targetValue" column="targetValue"/>
+ <result property="basicRegex" column="basicRegex"/>
+ <result property="selfRegex" column="selfRegex"/>
+ <result property="regexUsedType" column="regexUsedType"/>
+ <result property="sort" column="sort"/>
+ <result property="version" column="version"/>
+ <result property="isEnable" column="isEnable"/>
+ <result property="tipsJson" column="tipsJson"/>
+ <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"/>
+ </resultMap>
+
+ <sql id="selectIvrLibaScriptTargetVo">
+ select id,
+ scriptid,
+ targetID,
+ targetType,
+ categoryName,
+ targetValue,
+ basicRegex,
+ selfRegex,
+ regexUsedType,
+ sort,
+ version,
+ isEnable,
+ tipsJson,
+ del_flag,
+ update_by,
+ update_time,
+ create_by,
+ create_time,
+ isupload,
+ upload_time,
+ orgid,
+ pid,
+ guid
+ from ivr_liba_script_target
+ </sql>
+
+ <select id="selectIvrLibaScriptTargetList" parameterType="com.smartor.domain.IvrLibaScriptTarget"
+ resultMap="IvrLibaScriptTargetResult">
+ <include refid="selectIvrLibaScriptTargetVo"/>
+ <where>
+ <if test="scriptid != null ">and scriptid = #{scriptid}</if>
+ <if test="targetID != null ">and targetID = #{targetID}</if>
+ <if test="targetType != null and targetType != ''">and targetType = #{targetType}</if>
+ <if test="categoryName != null and categoryName != ''">and categoryName like concat('%', #{categoryName},
+ '%')
+ </if>
+ <if test="targetValue != null and targetValue != ''">and targetValue = #{targetValue}</if>
+ <if test="basicRegex != null and basicRegex != ''">and basicRegex = #{basicRegex}</if>
+ <if test="selfRegex != null and selfRegex != ''">and selfRegex = #{selfRegex}</if>
+ <if test="regexUsedType != null and regexUsedType != ''">and regexUsedType = #{regexUsedType}</if>
+ <if test="sort != null ">and sort = #{sort}</if>
+ <if test="version != null ">and version = #{version}</if>
+ <if test="isEnable != null ">and isEnable = #{isEnable}</if>
+ <if test="tipsJson != null and tipsJson != ''">and tipsJson = #{tipsJson}</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>
+ </where>
+ </select>
+
+ <select id="selectIvrLibaScriptTargetByQuestionTargetID" parameterType="String"
+ resultMap="IvrLibaScriptTargetResult">
+ <include refid="selectIvrLibaScriptTargetVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertIvrLibaScriptTarget" parameterType="com.smartor.domain.IvrLibaScriptTarget">
+ insert into ivr_liba_script_target
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="scriptid != null">scriptid,</if>
+ <if test="targetID != null">targetID,</if>
+ <if test="targetType != null">targetType,</if>
+ <if test="categoryName != null">categoryName,</if>
+ <if test="targetValue != null">targetValue,</if>
+ <if test="basicRegex != null">basicRegex,</if>
+ <if test="selfRegex != null">selfRegex,</if>
+ <if test="regexUsedType != null">regexUsedType,</if>
+ <if test="sort != null">sort,</if>
+ <if test="version != null">version,</if>
+ <if test="isEnable != null">isEnable,</if>
+ <if test="tipsJson != null">tipsJson,</if>
+ <if test="delFlag != null and delFlag != ''">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>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="scriptid != null ">#{scriptid},</if>
+ <if test="targetID != null">#{targetID},</if>
+ <if test="targetType != null">#{targetType},</if>
+ <if test="categoryName != null">#{categoryName},</if>
+ <if test="targetValue != null">#{targetValue},</if>
+ <if test="basicRegex != null">#{basicRegex},</if>
+ <if test="selfRegex != null">#{selfRegex},</if>
+ <if test="regexUsedType != null">#{regexUsedType},</if>
+ <if test="sort != null">#{sort},</if>
+ <if test="version != null">#{version},</if>
+ <if test="isEnable != null">#{isEnable},</if>
+ <if test="tipsJson != null">#{tipsJson},</if>
+ <if test="delFlag != null and delFlag != ''">#{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>
+ </trim>
+ </insert>
+
+ <update id="updateIvrLibaScriptTarget" parameterType="com.smartor.domain.IvrLibaScriptTarget">
+ update ivr_liba_script_target
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="scriptid != null">scriptid = #{scriptid},</if>
+ <if test="targetID != null">targetID = #{targetID},</if>
+ <if test="targetType != null">targetType = #{targetType},</if>
+ <if test="categoryName != null">categoryName = #{categoryName},</if>
+ <if test="targetValue != null">targetValue = #{targetValue},</if>
+ <if test="basicRegex != null">basicRegex = #{basicRegex},</if>
+ <if test="selfRegex != null">selfRegex = #{selfRegex},</if>
+ <if test="regexUsedType != null">regexUsedType = #{regexUsedType},</if>
+ <if test="sort != null">sort = #{sort},</if>
+ <if test="version != null">version = #{version},</if>
+ <if test="isEnable != null">isEnable = #{isEnable},</if>
+ <if test="tipsJson != null">tipsJson = #{tipsJson},</if>
+ <if test="delFlag != null and delFlag != ''">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>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteIvrLibaScriptTargetByQuestionTargetID" parameterType="Long">
+ update ivr_liba_script_target
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="delFlag != null and delFlag != ''">del_flag = 1</if>
+ </trim>
+ where id = #{id}
+ </delete>
+
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3