From 9c8c9675325a22c69ac113ab26f9285b60582ae1 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 09 七月 2024 10:10:26 +0800
Subject: [PATCH] 代码提交
---
smartor/src/main/java/com/smartor/domain/IvrLibaTemplateTargetoption.java | 8
smartor/src/main/resources/mapper/smartor/SvyLibScriptOptionMapper.xml | 12
smartor/src/main/java/com/smartor/domain/SvyLibTemplateWjx.java | 204 ++++
smartor/src/main/java/com/smartor/domain/SvyLibTemplateScriptWjx.java | 208 ++++
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateScriptWjxController.java | 98 ++
smartor/src/main/java/com/smartor/service/impl/PersonVoiceServiceImpl.java | 54
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateTargetoptionWjxController.java | 98 ++
smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoptionWjx.java | 149 +++
smartor/src/main/resources/mapper/smartor/SvyLibTemplateScriptWjxMapper.xml | 211 ++++
smartor/src/main/java/com/smartor/service/ISvyLibTemplateTargetoptionWjxService.java | 62 +
smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml | 13
smartor/src/main/java/com/smartor/service/ISvyLibTemplateScriptWjxService.java | 62 +
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateWjxController.java | 98 ++
smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScriptVO.java | 63 -
smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScript.java | 66 -
smartor/src/main/java/com/smartor/service/ISvyLibTemplateWjxService.java | 62 +
smartor/src/main/java/com/smartor/domain/IvrLibaScriptTargetoption.java | 223 ----
smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateWjxServiceImpl.java | 97 +
smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionWjxMapper.xml | 243 ++++
smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoption.java | 6
smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateScriptWjxServiceImpl.java | 90 +
smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateTargetoptionWjxServiceImpl.java | 97 +
smartor/src/main/java/com/smartor/domain/SvyLibScriptOption.java | 7
smartor/src/main/java/com/smartor/mapper/SvyLibTemplateScriptWjxMapper.java | 64 +
smartor/src/main/resources/mapper/smartor/IvrLibaTemplateTargetoptionMapper.xml | 14
smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionMapper.xml | 12
smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java | 6
smartor/src/main/java/com/smartor/mapper/SvyLibTemplateWjxMapper.java | 63 +
smartor/src/main/resources/mapper/smartor/SvyTaskTemplateScriptMapper.xml | 195 +--
smartor/src/main/resources/mapper/smartor/SvyLibTemplateWjxMapper.xml | 251 +++++
smartor/src/main/java/com/smartor/mapper/SvyLibTemplateTargetoptionWjxMapper.java | 64 +
smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml | 12
32 files changed, 2,423 insertions(+), 489 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateScriptWjxController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateScriptWjxController.java
new file mode 100644
index 0000000..05c539f
--- /dev/null
+++ b/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));
+ }
+}
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateTargetoptionWjxController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateTargetoptionWjxController.java
new file mode 100644
index 0000000..a9f4cfc
--- /dev/null
+++ b/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;
+
+/**
+ * 闂嵎闂鎸囨爣閫夐」搴揅ontroller
+ *
+ * @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));
+ }
+}
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateWjxController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/SvyLibTemplateWjxController.java
new file mode 100644
index 0000000..2b38fc0
--- /dev/null
+++ b/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));
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaScriptTargetoption.java b/smartor/src/main/java/com/smartor/domain/IvrLibaScriptTargetoption.java
index b122d5a..f039c02 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaScriptTargetoption.java
+++ b/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;
- }
}
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java
index e96ff36..25f793e 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java
+++ b/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
*/
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateTargetoption.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateTargetoption.java
index 2658d6a..717b571 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateTargetoption.java
+++ b/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;
+
+
}
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibScriptOption.java b/smartor/src/main/java/com/smartor/domain/SvyLibScriptOption.java
index 2f53ff0..3d83a2d 100644
--- a/smartor/src/main/java/com/smartor/domain/SvyLibScriptOption.java
+++ b/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;
+
}
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibTemplateScriptWjx.java b/smartor/src/main/java/com/smartor/domain/SvyLibTemplateScriptWjx.java
new file mode 100644
index 0000000..4f69ffb
--- /dev/null
+++ b/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;
+
+ /**
+ * 鑰佺増鏈琁D
+ */
+ @ApiModelProperty(value = "鑰佺増鏈琁D")
+ 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;
+
+ /**
+ * 鐖禝D
+ */
+ @ApiModelProperty(value = "鐖禝D")
+ 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銆丅锛孋锛孌绛夛紱
+ */
+ @ApiModelProperty(value = "棰樼洰鍒嗗�硷細鏁板瓧1,2绛夛紱瀛楁瘝A銆丅锛孋锛孌绛夛紱")
+ private String score;
+
+ /**
+ * 闂鎻忚堪
+ */
+ @ApiModelProperty(value = "闂鎻忚堪")
+ private String scriptDesc;
+
+ public void setId(Long id) {
+ this.id = id;
+ }
+
+
+}
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoption.java b/smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoption.java
index b21fd9f..1910bd6 100644
--- a/smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoption.java
+++ b/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;
+
}
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoptionWjx.java b/smartor/src/main/java/com/smartor/domain/SvyLibTemplateTargetoptionWjx.java
new file mode 100644
index 0000000..f5e8f24
--- /dev/null
+++ b/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;
+
+ /** 鐖禝D */
+ @ApiModelProperty(value = "鐖禝D")
+ 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;
+
+}
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibTemplateWjx.java b/smartor/src/main/java/com/smartor/domain/SvyLibTemplateWjx.java
new file mode 100644
index 0000000..2bac124
--- /dev/null
+++ b/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;
+
+ /**
+ * 涓績搴揑D
+ */
+ @ApiModelProperty(value = "涓績搴揑D")
+ 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;
+
+ /**
+ * 鐖禝D
+ */
+ @ApiModelProperty(value = "鐖禝D")
+ 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;
+
+}
diff --git a/smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScript.java b/smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScript.java
index da718ae..2a1635f 100644
--- a/smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScript.java
+++ b/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锛氬彲浠ヤ笉濉� 锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�
@@ -144,12 +84,6 @@
*/
@ApiModelProperty(value = "鏄惁瀛樺湪鎿嶄綔锛�1 鏂板 2淇敼 3鍒犻櫎")
private Integer isoperation;
-
- /**
- * 鍙兘鎾斁WAV绫诲瀷
- */
- @ApiModelProperty(value = "鍙兘鎾斁WAV绫诲瀷")
- private Long playWavOnly;
/**
* 鎺掑簭
diff --git a/smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScriptVO.java b/smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScriptVO.java
index f883c9c..d470d0b 100644
--- a/smartor/src/main/java/com/smartor/domain/SvyTaskTemplateScriptVO.java
+++ b/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锛氬彲浠ヤ笉濉� 锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�
@@ -148,11 +90,6 @@
@ApiModelProperty(value = "鏄惁蹇呭～,1:蹇呭～ 2锛氬彲浠ヤ笉濉� ")
private String isMust;
- /**
- * 鍙兘鎾斁WAV绫诲瀷
- */
- @ApiModelProperty(value = "鍙兘鎾斁WAV绫诲瀷")
- private Long playWavOnly;
/**
* 鍒犻櫎鏍囪
diff --git a/smartor/src/main/java/com/smartor/mapper/SvyLibTemplateScriptWjxMapper.java b/smartor/src/main/java/com/smartor/mapper/SvyLibTemplateScriptWjxMapper.java
new file mode 100644
index 0000000..1acbe30
--- /dev/null
+++ b/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);
+}
diff --git a/smartor/src/main/java/com/smartor/mapper/SvyLibTemplateTargetoptionWjxMapper.java b/smartor/src/main/java/com/smartor/mapper/SvyLibTemplateTargetoptionWjxMapper.java
new file mode 100644
index 0000000..9978bd1
--- /dev/null
+++ b/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;
+
+/**
+ * 闂嵎闂鎸囨爣閫夐」搴揗apper鎺ュ彛
+ *
+ * @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);
+}
diff --git a/smartor/src/main/java/com/smartor/mapper/SvyLibTemplateWjxMapper.java b/smartor/src/main/java/com/smartor/mapper/SvyLibTemplateWjxMapper.java
new file mode 100644
index 0000000..ed1c3c1
--- /dev/null
+++ b/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);
+}
diff --git a/smartor/src/main/java/com/smartor/service/ISvyLibTemplateScriptWjxService.java b/smartor/src/main/java/com/smartor/service/ISvyLibTemplateScriptWjxService.java
new file mode 100644
index 0000000..fed3b0e
--- /dev/null
+++ b/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);
+}
diff --git a/smartor/src/main/java/com/smartor/service/ISvyLibTemplateTargetoptionWjxService.java b/smartor/src/main/java/com/smartor/service/ISvyLibTemplateTargetoptionWjxService.java
new file mode 100644
index 0000000..08cb9ee
--- /dev/null
+++ b/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;
+
+/**
+ * 闂嵎闂鎸囨爣閫夐」搴揝ervice鎺ュ彛
+ *
+ * @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);
+}
diff --git a/smartor/src/main/java/com/smartor/service/ISvyLibTemplateWjxService.java b/smartor/src/main/java/com/smartor/service/ISvyLibTemplateWjxService.java
new file mode 100644
index 0000000..34ca47e
--- /dev/null
+++ b/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);
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/PersonVoiceServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/PersonVoiceServiceImpl.java
index 415ad1c..0afd776 100644
--- a/smartor/src/main/java/com/smartor/service/impl/PersonVoiceServiceImpl.java
+++ b/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;
diff --git a/smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateScriptWjxServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateScriptWjxServiceImpl.java
new file mode 100644
index 0000000..8c3ba42
--- /dev/null
+++ b/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);
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateTargetoptionWjxServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateTargetoptionWjxServiceImpl.java
new file mode 100644
index 0000000..b8ada46
--- /dev/null
+++ b/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;
+
+/**
+ * 闂嵎闂鎸囨爣閫夐」搴揝ervice涓氬姟灞傚鐞�
+ *
+ * @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);
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateWjxServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/SvyLibTemplateWjxServiceImpl.java
new file mode 100644
index 0000000..c41282a
--- /dev/null
+++ b/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);
+ }
+}
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml
index fa08924..f6e578a 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml
index 0a61fd1..8824810 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateTargetoptionMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateTargetoptionMapper.xml
index c70050d..8f8c705 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateTargetoptionMapper.xml
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibScriptOptionMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibScriptOptionMapper.xml
index a10842f..00aaa5c 100644
--- a/smartor/src/main/resources/mapper/smartor/SvyLibScriptOptionMapper.xml
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibTemplateScriptWjxMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibTemplateScriptWjxMapper.xml
new file mode 100644
index 0000000..c29d7f2
--- /dev/null
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionMapper.xml
index 220ac30..ef5b727 100644
--- a/smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionMapper.xml
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionWjxMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibTemplateTargetoptionWjxMapper.xml
new file mode 100644
index 0000000..718353e
--- /dev/null
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibTemplateWjxMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibTemplateWjxMapper.xml
new file mode 100644
index 0000000..d96f6ed
--- /dev/null
+++ b/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>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyTaskTemplateScriptMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyTaskTemplateScriptMapper.xml
index e2b3f9f..b209d3b 100644
--- a/smartor/src/main/resources/mapper/smartor/SvyTaskTemplateScriptMapper.xml
+++ b/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">
--
Gitblit v1.9.3