From 01c9667cfb06970564e837dc343d5cee0eb3aed7 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期三, 24 四月 2024 17:53:42 +0800
Subject: [PATCH] 代码提交

---
 smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetoptionService.java         |    2 
 smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml                      |   20 +-
 smartor/src/main/java/com/smartor/domain/IvrTaskSingle.java                              |    2 
 pom.xml                                                                                  |    8 
 ruoyi-common/src/main/java/com/ruoyi/common/utils/HttpUtil.java                          |    4 
 smartor/src/main/java/com/smartor/domain/IvrLibaScript.java                              |   10 +
 smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java                            |   10 +
 smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java             |    3 
 smartor/src/main/java/com/smartor/domain/IvrLibaTargetVO.java                            |    7 
 smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java             |    4 
 smartor/src/main/java/com/smartor/domain/PatArchive.java                                 |    8 +
 smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetoptionMapper.java            |    2 
 ruoyi-admin/src/main/java/com/ruoyi/web/task/PhoneTask.java                              |   59 ++++----
 smartor/src/main/resources/mapper/smartor/IvrLibaTemplateScriptMapper.xml                |    8 +
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrTaskController.java        |    3 
 smartor/src/main/resources/mapper/smartor/SvyLibTopicMapper.xml                          |   14 +
 smartor/src/main/java/com/smartor/domain/IvrLibaScriptVO.java                            |   12 +
 smartor/src/main/java/com/smartor/service/impl/IvrTaskSingleServiceImpl.java             |    7 
 smartor/src/main/java/com/smartor/domain/IvrTask.java                                    |   12 +
 smartor/src/main/java/com/smartor/service/impl/HeTaskServiceImpl.java                    |    9 
 smartor/src/main/java/com/smartor/config/PhoneUtils.java                                 |   33 +++-
 smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScript.java                      |    7 +
 smartor/src/main/resources/mapper/smartor/IvrTaskSingleMapper.xml                        |    1 
 smartor/src/main/java/com/smartor/domain/PatTaskRelevance.java                           |    7 +
 smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptTargetoptionServiceImpl.java |    4 
 smartor/src/main/resources/mapper/smartor/SvyLibTitleMapper.xml                          |   17 ++
 smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java                              |    8 
 smartor/src/main/java/com/smartor/domain/IvrTaskSingleVO.java                            |    4 
 smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml                        |   22 ++
 smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScriptVO.java                    |    7 +
 smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml                           |   15 -
 ruoyi-admin/src/main/resources/application-druid.yml                                     |    4 
 smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml                        |   29 ++-
 ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java                                 |    2 
 smartor/src/main/java/com/smartor/domain/SvyLibTopic.java                                |   11 +
 smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml            |    3 
 smartor/src/main/java/com/smartor/domain/IvrLibaTemplateVO.java                          |    8 
 smartor/src/main/java/com/smartor/domain/SvyLibTitle.java                                |   11 +
 38 files changed, 281 insertions(+), 116 deletions(-)

diff --git a/pom.xml b/pom.xml
index 1b7abf7..45150fe 100644
--- a/pom.xml
+++ b/pom.xml
@@ -3,7 +3,7 @@
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
 	<modelVersion>4.0.0</modelVersion>
-	
+
     <groupId>com.ruoyi</groupId>
     <artifactId>ruoyi</artifactId>
     <version>3.8.5</version>
@@ -11,7 +11,7 @@
     <name>ruoyi</name>
     <url>http://www.ruoyi.vip</url>
     <description>鑻ヤ緷绠$悊绯荤粺</description>
-    
+
     <properties>
         <ruoyi.version>3.8.5</ruoyi.version>
         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
@@ -32,7 +32,7 @@
         <velocity.version>2.3</velocity.version>
         <jwt.version>0.9.1</jwt.version>
     </properties>
-	
+
     <!-- 渚濊禆澹版槑 -->
     <dependencyManagement>
         <dependencies>
@@ -244,4 +244,4 @@
         </pluginRepository>
     </pluginRepositories>
 
-</project>
\ No newline at end of file
+</project>
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrTaskController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrTaskController.java
index 0d5e09b..82885bf 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrTaskController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/IvrTaskController.java
@@ -6,6 +6,7 @@
 import com.ruoyi.common.core.page.TableDataInfo;
 import com.ruoyi.common.enums.BusinessType;
 import com.ruoyi.common.utils.DtoConversionUtils;
+import com.ruoyi.common.utils.PageUtils;
 import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.smartor.domain.IvrTask;
 import com.smartor.domain.IvrTaskVO;
@@ -46,7 +47,7 @@
     @PreAuthorize("@ss.hasPermi('smartor:ivrtask:list')")
     @PostMapping("/list")
     public TableDataInfo list(@RequestBody IvrTask ivrTask) {
-        startPage();
+        PageUtils.startPageByPost(ivrTask.getPageNum(), ivrTask.getPageSize());
         List<IvrTask> list = ivrTaskService.selectIvrTaskList(ivrTask);
         List<IvrTaskVO> ivrTaskVOS = DtoConversionUtils.sourceToTarget(list, IvrTaskVO.class);
         if (CollectionUtils.isNotEmpty(ivrTaskVOS)) {
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/task/PhoneTask.java b/ruoyi-admin/src/main/java/com/ruoyi/web/task/PhoneTask.java
index b228061..7f8fbdb 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/task/PhoneTask.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/task/PhoneTask.java
@@ -35,38 +35,41 @@
 
     @Override
     public void run() {
-        try {
-            //鑾峰彇鐢佃瘽缁勶紝鏌ョ湅鍝簺鐢佃瘽鍙互浣跨敤
-            PhoneUtils phoneUtils = new PhoneUtils();
-            String uuid = IdUtils.randomUUID();
-            Map<String, Object> objectMap = new HashMap<>();
-            objectMap.put("ivrTaskcall", ivrTaskcall);
-            objectMap.put("ivrLibaTemplateScriptVO", ivrLibaTemplateScriptVO);
-            //灏嗘暟鎹斁鍒皉edis涓紝鏂逛究鍦ㄥ洖璋冩柟娉曢噷鑾峰彇
-            redisCache.setCacheObject(uuid, objectMap, 120, TimeUnit.MINUTES);
+        synchronized (PhoneTask.class) {
+            try {
+                //鑾峰彇鐢佃瘽缁勶紝鏌ョ湅鍝簺鐢佃瘽鍙互浣跨敤
+                PhoneUtils phoneUtils = new PhoneUtils();
+                String uuid = IdUtils.randomUUID();
+                Map<String, Object> objectMap = new HashMap<>();
+                objectMap.put("ivrTaskcall", ivrTaskcall);
+                objectMap.put("ivrLibaTemplateScriptVO", ivrLibaTemplateScriptVO);
+                //灏嗘暟鎹斁鍒皉edis涓紝鏂逛究鍦ㄥ洖璋冩柟娉曢噷鑾峰彇
+                redisCache.setCacheObject(uuid, objectMap, 120, TimeUnit.MINUTES);
 
-            //璁板綍棣栨闂
-            QuestionMessage returnQues = new QuestionMessage();
-            returnQues.setKcb(ivrLibaTemplateVO.getRevisitBefore());
-            for (IvrLibaTemplateScriptVO ivrLibaTemplateScriptVO : ivrLibaTemplateScriptVO) {
-                if (ivrLibaTemplateScriptVO.getTargetid() == ivrLibaTemplateVO.getFirstQuestionNum().intValue()) {
-                    returnQues.setNowQuestion(ivrLibaTemplateScriptVO);
+                //璁板綍棣栨闂
+                QuestionMessage returnQues = new QuestionMessage();
+                returnQues.setKcb(ivrLibaTemplateVO.getRevisitBefore());
+                for (IvrLibaTemplateScriptVO ivrLibaTemplateScriptVO : ivrLibaTemplateScriptVO) {
+                    if (ivrLibaTemplateScriptVO.getTargetid() == ivrLibaTemplateVO.getFirstQuestionNum().intValue()) {
+                        returnQues.setNowQuestion(ivrLibaTemplateScriptVO);
+                    }
                 }
+                returnQues.setQuestionList(ivrLibaTemplateScriptVO);
+                //灏嗛棶棰橈紝鍜屾ā鏉夸俊鎭斁鍒皉edis涓�
+                redisCache.setCacheObject(uuid + "returnQues", returnQues, 120, TimeUnit.MINUTES);
+                redisCache.setCacheObject(uuid + "ivrLibaTemplateVO", ivrLibaTemplateVO, 120, TimeUnit.MINUTES);
+
+                //璋冪敤鏈哄櫒浜虹數璇濓紝寮�濮嬬數璇濓紙闇�瑕佸皢鍥炶皟鏂规硶浼犲叆锛岃繖涓瓑鈥濈數璇濇柟鈥滃憡璇夋�庝箞浼狅紝鐜板湪鍏堢┖鐫�,杩樻湁绗竴鍙ラ棶棰樿瘽鏈級
+//            phoneUtils.ob(uuid, null, ivrTaskcall.getPhone(), null, null, null, null, null, null, null, null);
+                String ob = phoneUtils.ob("", "", "", "", "", "", "", "3001", "", true);
+                System.out.println("OB鐨勫�间负锛�" + ob);
+                //閫氱煡 MQ 娑堟伅宸茶鎺ユ敹,鍙互ACK(浠庨槦鍒椾腑鍒犻櫎)浜�   锛堣繖涓渶瑕佹牴鎹笟鍔″啀鍘诲鐞咥CK锛�
+
+                channel.basicAck(message.getMessageProperties().getDeliveryTag(), false);
+            } catch (IOException e) {
+                e.printStackTrace();
             }
-            returnQues.setQuestionList(ivrLibaTemplateScriptVO);
-            //灏嗛棶棰橈紝鍜屾ā鏉夸俊鎭斁鍒皉edis涓�
-            redisCache.setCacheObject(uuid + "returnQues", returnQues, 120, TimeUnit.MINUTES);
-            redisCache.setCacheObject(uuid + "ivrLibaTemplateVO", ivrLibaTemplateVO, 120, TimeUnit.MINUTES);
-
-            //璋冪敤鏈哄櫒浜虹數璇濓紝寮�濮嬬數璇濓紙闇�瑕佸皢鍥炶皟鏂规硶浼犲叆锛岃繖涓瓑鈥濈數璇濇柟鈥滃憡璇夋�庝箞浼狅紝鐜板湪鍏堢┖鐫�,杩樻湁绗竴鍙ラ棶棰樿瘽鏈級
-            phoneUtils.ob(uuid, null, ivrTaskcall.getPhone(), null, null, null, null, null, null, null, null);
-            //閫氱煡 MQ 娑堟伅宸茶鎺ユ敹,鍙互ACK(浠庨槦鍒椾腑鍒犻櫎)浜�   锛堣繖涓渶瑕佹牴鎹笟鍔″啀鍘诲鐞咥CK锛�
-
-            channel.basicAck(message.getMessageProperties().getDeliveryTag(), false);
-        } catch (IOException e) {
-            e.printStackTrace();
         }
-
 
     }
 }
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java b/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java
index 9374f8f..75f14db 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java
@@ -4,6 +4,7 @@
 import org.junit.Test;
 import org.springframework.amqp.rabbit.core.RabbitTemplate;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.core.SpringVersion;
 
 //@SpringBootTest
 //@RunWith(SpringRunner.class)
@@ -13,6 +14,7 @@
 
     @Test
     public void testSend() {
+        System.out.println("Spring Framework鐗堟湰锛�" + SpringVersion.getVersion());
 //        rabbitTemplate.convertAndSend(RabbitMqConfig.EXCHANGE_NAME, "phone.001", "娴嬭瘯鏁版嵁001");
 //        rabbitTemplate.convertAndSend(RabbitMqConfig.EXCHANGE_NAME, "phone.002", "娴嬭瘯鏁版嵁002");
 //        rabbitTemplate.convertAndSend(RabbitMqConfig.EXCHANGE_NAME, "phone.003", "娴嬭瘯鏁版嵁003");
diff --git a/ruoyi-admin/src/main/resources/application-druid.yml b/ruoyi-admin/src/main/resources/application-druid.yml
index 5484465..45c90ae 100644
--- a/ruoyi-admin/src/main/resources/application-druid.yml
+++ b/ruoyi-admin/src/main/resources/application-druid.yml
@@ -2,6 +2,7 @@
 spring:
   rabbitmq:
     host: 116.62.18.175
+#    host: 127.0.0.1
     password: guest
     port: 5672
     username: guest
@@ -119,4 +120,5 @@
 signName: 鏉窞鍒╂箹绉戞妧
 
 #鏅鸿兘鍛煎彨
-phoneIP: http://124.220.50.51:8001
+phoneIP: http://124.220.50.51
+phonePort: 8001
diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/utils/HttpUtil.java b/ruoyi-common/src/main/java/com/ruoyi/common/utils/HttpUtil.java
index dfed36d..3f990a0 100644
--- a/ruoyi-common/src/main/java/com/ruoyi/common/utils/HttpUtil.java
+++ b/ruoyi-common/src/main/java/com/ruoyi/common/utils/HttpUtil.java
@@ -180,7 +180,7 @@
                 HttpEntity<RESPBODY> rep = null;
                 if (isNullOrEmpty(respStr) || null == respBodyClass) {
                     rep = new HttpEntity<RESPBODY>(respHeaders, null);
-                    ;// 鏃犲搷搴�
+                    // 鏃犲搷搴�
                 } else {
                     if (respBodyClass != String.class) {
                         RESPBODY respBody = JSON.parseObject(respStr, respBodyClass);
@@ -355,4 +355,4 @@
         }
         return false;
     }
-}
\ No newline at end of file
+}
diff --git a/smartor/src/main/java/com/smartor/config/PhoneUtils.java b/smartor/src/main/java/com/smartor/config/PhoneUtils.java
index a1ca8d3..df4a3dc 100644
--- a/smartor/src/main/java/com/smartor/config/PhoneUtils.java
+++ b/smartor/src/main/java/com/smartor/config/PhoneUtils.java
@@ -1,12 +1,18 @@
 package com.smartor.config;
 
+import com.fasterxml.jackson.annotation.JsonFormat;
 import com.ruoyi.common.utils.HttpUtil;
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.common.utils.http.HttpEntity;
+import org.apache.commons.httpclient.methods.PostMethod;
+import org.apache.commons.httpclient.params.HttpMethodParams;
+import org.apache.http.util.EntityUtils;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Component;
+import sun.net.www.http.HttpClient;
 
 import javax.mail.Multipart;
+import java.nio.charset.StandardCharsets;
 import java.util.HashMap;
 import java.util.Map;
 
@@ -15,6 +21,9 @@
 
     @Value("${phoneIP}")
     private String phoneIP;
+
+    @Value("${phonePort}")
+    private String phonePort;
 
     /**
      * 娣诲姞鍒嗘満add_user
@@ -165,7 +174,7 @@
     public String getAgentState(String name) {
         Map<String, Object> map = new HashMap<>();
         map.put("name", name);
-        return sendReq(map, "/tel/ai_api/set_agent_state");
+        return sendReq(map, "/tel/ai_api/get_agent_state");
     }
 
     /**
@@ -186,7 +195,7 @@
         map.put("dnis", dnis);
         map.put("force_call", force_call);
         if (force_call == null) map.put("force_call", true);
-        return sendReq(map, "/tel/ai_api/set_agent_state");
+        return sendReq(map, "/tel/ai_api/manual_outbound");
     }
 
     /**
@@ -201,7 +210,7 @@
         map.put("text", fileText);
         map.put("uuid", uuid);
 
-        return sendReq(map, "/tel/ai_api/set_agent_state");
+        return sendReq(map, "/tel/ai_api/tts_playback");
     }
 
     /**
@@ -216,7 +225,7 @@
         map.put("wav_file", wav_file);
         map.put("uuid", uuid);
 
-        return sendReq(map, "/tel/ai_api/set_agent_state");
+        return sendReq(map, "/tel/ai_api/playback");
     }
 
     /**
@@ -224,7 +233,7 @@
      *
      * @return
      */
-    public String ob(String kg_uuid, String kg_file, String data, String app_id, String ani, String special_ch, String sign, String extension, String dnis, Boolean call_uuid, Boolean force_call) {
+    public String ob(String kg_uuid, String kg_file, String data, String app_id, String ani, String special_ch, String sign, String dnis, String call_uuid, Boolean force_call) {
         Map<String, Object> map = new HashMap<>();
         map.put("kg_uuid", kg_uuid);
         map.put("kg_file", kg_file);
@@ -233,14 +242,12 @@
         map.put("ani", ani);
         map.put("special_ch", special_ch);
         map.put("sign", sign);
-        map.put("extension", extension);
         map.put("dnis", dnis);
         map.put("call_uuid", call_uuid);
         map.put("force_call", force_call);
         if (force_call == null) map.put("force_call", true);
-        return sendReq(map, "/tel/ai_api/set_agent_state");
+        return sendReq(map, "/tel/ai_api/outbound");
     }
-
 
     /**
      * 鎸傛柇閫氳瘽
@@ -257,13 +264,17 @@
         map.put("sign", sign);
         map.put("dnis", dnis);
         map.put("call_uuid", call_uuid);
-        return sendReq(map, "/tel/ai_api/set_agent_state");
+        return sendReq(map, "/tel/ai_api/hangup");
     }
 
     private String sendReq(Map<String, Object> map, String path) {
         HttpEntity<Map<String, Object>> req = new HttpEntity<>(getHead(), map);
-        HttpEntity<String> stringHttpEntity = HttpUtil.postJsonRequestV2(phoneIP + path, req, String.class);
-        return stringHttpEntity.getBody();
+        if (StringUtils.isEmpty(phoneIP)) {
+            phoneIP = "http://124.220.50.51";
+            phonePort = "8001";
+        }
+        HttpEntity<String> stringHttpEntity = HttpUtil.postJsonRequestV2(phoneIP + ":" + phonePort + path, req, String.class);
+        return new String(stringHttpEntity.getBody().getBytes(StandardCharsets.UTF_8));
     }
 
     private Map<String, String> getHead() {
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java b/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java
index a2d44ae..b05ddad 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaScript.java
@@ -215,8 +215,14 @@
      * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
      */
     @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
-    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=,閫�=椤�,2=,鏂�=鏈�,3=,鏁�=鍊�")
-    private Long isenable;
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2=鏂囨湰,3=鏁板��")
+    private Long valueType;
+
+    /**
+     * 鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�
+     */
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
 
     /**
      * 涓婁紶鏃堕棿
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaScriptVO.java b/smartor/src/main/java/com/smartor/domain/IvrLibaScriptVO.java
index bc12bbd..525cb73 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaScriptVO.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaScriptVO.java
@@ -32,8 +32,16 @@
     /**
      * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
      */
-    @ApiModelProperty("鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
-    private Long isenable;
+    @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2=鏂囨湰,3=鏁板��")
+    private Long valueType;
+
+    /**
+     * 鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�
+     */
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
+
 
     /**
      * 闂璇濇湳鏍囬
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java
index de2106a..d9b1c39 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTarget.java
@@ -74,8 +74,8 @@
      * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
      */
     @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
-    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=,閫�=椤�,2=,鏂�=鏈�,3=,鏁�=鍊�")
-    private Long isenable;
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2鏂囨湰,3鏁板��")
+    private Long valueType;
 
     /**
      * 鏄惁寮傚父鏍囪瘑
@@ -177,6 +177,9 @@
     @Excel(name = "鍙傛暟鍙橀噺")
     private String parameter;
 
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
+
     /**
      * pageNum
      */
@@ -190,7 +193,6 @@
     @ApiModelProperty(value = "pageSize")
     @Excel(name = "pageSize")
     private Integer pageSize;
-
 
 
 }
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTargetVO.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTargetVO.java
index d69147d..d1468e4 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTargetVO.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTargetVO.java
@@ -76,8 +76,8 @@
      * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
      */
     @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
-    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=,閫�=椤�,2=,鏂�=鏈�,3=,鏁�=鍊�")
-    private Long isenable;
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2鏂囨湰,3鏁板��")
+    private Long valueType;
 
     /**
      * 鏄惁寮傚父鏍囪瘑
@@ -200,4 +200,7 @@
     @ApiModelProperty(value = "鏍囩闆嗗悎")
     private List<BaseTag> baseTagList = new ArrayList<>();
 
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
+
 }
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java
index bf0404d..30c13bc 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplate.java
@@ -103,9 +103,15 @@
     /**
      * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
      */
-    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=,閫�=椤�,2=,鏂�=鏈�,3=,鏁�=鍊�")
     @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
-    private Long isEnable;
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2=鏂囨湰,3=鏁板��")
+    private Long valueType;
+
+    /**
+     * 鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�
+     */
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
 
     /**
      * 鏂板鐢ㄦ埛ID
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScript.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScript.java
index c083778..472bc6c 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScript.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScript.java
@@ -246,4 +246,11 @@
     @Excel(name = "鍏跺畠鏁版嵁锛堝瓨鍌ㄥ彉閲忥級")
     @ApiModelProperty(value = "鍏跺畠鏁版嵁锛堝瓨鍌ㄥ彉閲忥級")
     private String otherdata;
+
+    /**
+     * 鏄惁蹇呭~锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�
+     */
+    @Excel(name = "鏄惁蹇呭~锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�")
+    @ApiModelProperty(value = "鏄惁蹇呭~锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�")
+    private String isMust;
 }
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScriptVO.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScriptVO.java
index abcc5cf..7eb27f1 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScriptVO.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateScriptVO.java
@@ -248,6 +248,13 @@
     private String otherdata;
 
     /**
+     * 鏄惁蹇呭~锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�
+     */
+    @Excel(name = "鏄惁蹇呭~锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�")
+    @ApiModelProperty(value = "鏄惁蹇呭~锛堢粰浜哄伐鐢ㄧ殑锛孉I涓嶇敤閬靛畧锛�")
+    private String isMust;
+
+    /**
      * 璇濇湳閫夐」
      */
     @ApiModelProperty(value = "璇濇湳閫夐」")
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateVO.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateVO.java
index f72fa81..fca400f 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateVO.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTemplateVO.java
@@ -102,9 +102,13 @@
     /**
      * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
      */
-    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=,閫�=椤�,2=,鏂�=鏈�,3=,鏁�=鍊�")
     @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
-    private Long isEnable;
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2=鏂囨湰,3=鏁板��")
+    private Long valueType;
+
+
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
 
     /**
      * 鏂板鐢ㄦ埛ID
diff --git a/smartor/src/main/java/com/smartor/domain/IvrTask.java b/smartor/src/main/java/com/smartor/domain/IvrTask.java
index 9ef8b76..adb7726 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrTask.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrTask.java
@@ -245,4 +245,16 @@
     @ApiModelProperty(value = "鏂囨湰鍙橀噺鍙傛暟 ")
     private String param;
 
+    /**
+     * pageNum
+     */
+    @ApiModelProperty("pageNum")
+    private Integer pageNum;
+
+    /**
+     * pageSize
+     */
+    @ApiModelProperty("pageSize")
+    private Integer pageSize;
+
 }
diff --git a/smartor/src/main/java/com/smartor/domain/IvrTaskSingle.java b/smartor/src/main/java/com/smartor/domain/IvrTaskSingle.java
index c1512f7..3ef97f7 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrTaskSingle.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrTaskSingle.java
@@ -412,7 +412,7 @@
      * 灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌锛�
      */
     @Excel(name = "  灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌锛�")
-    @ApiModelProperty(value = "灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌锛�")
+    @ApiModelProperty(value = "灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌 3.涓撶梾锛�")
     private String hospType;
 
 
diff --git a/smartor/src/main/java/com/smartor/domain/IvrTaskSingleVO.java b/smartor/src/main/java/com/smartor/domain/IvrTaskSingleVO.java
index 318c139..b8cd039 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrTaskSingleVO.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrTaskSingleVO.java
@@ -413,8 +413,8 @@
     /**
      * 灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌锛�
      */
-    @Excel(name = "  灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌锛�")
-    @ApiModelProperty(value = "灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌锛�")
+    @Excel(name = "  灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌   3.涓撶梾锛�")
+    @ApiModelProperty(value = "灏辫瘖绫诲瀷锛�1闂ㄨ瘖  2鍑洪櫌   3.涓撶梾锛�")
     private String hospType;
 
     /**
diff --git a/smartor/src/main/java/com/smartor/domain/PatArchive.java b/smartor/src/main/java/com/smartor/domain/PatArchive.java
index 53cfd03..e4b514e 100644
--- a/smartor/src/main/java/com/smartor/domain/PatArchive.java
+++ b/smartor/src/main/java/com/smartor/domain/PatArchive.java
@@ -92,6 +92,14 @@
     private Date birthdate;
 
     /**
+     * 鍏ラ櫌鏃堕棿
+     */
+    @ApiModelProperty("鍏ラ櫌鏃堕棿")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = " 鐢熸棩 ", width = 30, dateFormat = "yyyy-MM-dd")
+    private Date inhosptime;
+
+    /**
      * 骞撮緞
      */
     @ApiModelProperty("骞撮緞")
diff --git a/smartor/src/main/java/com/smartor/domain/PatTaskRelevance.java b/smartor/src/main/java/com/smartor/domain/PatTaskRelevance.java
index a77e9e1..40a3c2e 100644
--- a/smartor/src/main/java/com/smartor/domain/PatTaskRelevance.java
+++ b/smartor/src/main/java/com/smartor/domain/PatTaskRelevance.java
@@ -134,6 +134,13 @@
     private Date sendTime;
 
     /**
+     * 鍏ラ櫌鏃堕棿
+     */
+    @Excel(name = "鍏ラ櫌鏃堕棿")
+    @ApiModelProperty("鍏ラ櫌鏃堕棿")
+    private Date inhosptime;
+
+    /**
      * 鍙戦�佹椂闂�
      */
     @Excel(name = "灏辫瘖鏃堕棿")
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibTitle.java b/smartor/src/main/java/com/smartor/domain/SvyLibTitle.java
index ba49ad5..d2170c9 100644
--- a/smartor/src/main/java/com/smartor/domain/SvyLibTitle.java
+++ b/smartor/src/main/java/com/smartor/domain/SvyLibTitle.java
@@ -207,6 +207,17 @@
     @ApiModelProperty("鍏跺畠鏁版嵁锛堝瓨鍌ㄥ彉閲忥級")
     private String otherdata = "";
 
+    /**
+     * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
+     */
+    @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2=鏂囨湰,3=鏁板��")
+    private Long valueType;
+
+
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
+
 
     public SvyLibTitle() {
     }
diff --git a/smartor/src/main/java/com/smartor/domain/SvyLibTopic.java b/smartor/src/main/java/com/smartor/domain/SvyLibTopic.java
index 487966a..24fb1c9 100644
--- a/smartor/src/main/java/com/smartor/domain/SvyLibTopic.java
+++ b/smartor/src/main/java/com/smartor/domain/SvyLibTopic.java
@@ -167,6 +167,17 @@
     private List<SvyLibTopicoption> svyLibTopicoptions = new ArrayList<>();
 
     /**
+     * 鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級
+     */
+    @ApiModelProperty(value = "鍊肩被鍨嬶紙1 閫夐」  2 鏂囨湰  3 鏁板�硷級")
+    @Excel(name = "鍊肩被鍨�", readConverterExp = "1=閫夐」,2=鏂囨湰,3=鏁板��")
+    private Long valueType;
+
+
+    @ApiModelProperty(value = "鍥炲锛堟寚闂鐨勫洖澶嶏紝缁欓棶绛旈鐢ㄧ殑锛�")
+    private String reply;
+
+    /**
      * pageNum
      */
     @ApiModelProperty(value = "pageNum")
diff --git a/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetoptionMapper.java b/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetoptionMapper.java
index e884594..9a72ba3 100644
--- a/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetoptionMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/IvrLibaScriptTargetoptionMapper.java
@@ -51,6 +51,6 @@
      * @param id 闂璇濇湳鎸囨爣閫夐」搴撲富閿�
      * @return 缁撴灉
      */
-    public int deleteIvrLibaScriptTargetoptionByTargetoptionid(Long id);
+    public Boolean deleteIvrLibaScriptTargetoptionByTargetoptionid(Long id);
 
 }
diff --git a/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetoptionService.java b/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetoptionService.java
index f5d8bf1..a13fd0d 100644
--- a/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetoptionService.java
+++ b/smartor/src/main/java/com/smartor/service/IIvrLibaScriptTargetoptionService.java
@@ -49,6 +49,6 @@
      * @param targetoptionids 闇�瑕佸垹闄ょ殑闂璇濇湳鎸囨爣閫夐」搴撲富閿泦鍚�
      * @return 缁撴灉
      */
-    public int deleteIvrLibaScriptTargetoptionByTargetoptionids(String[] targetoptionids);
+    public Boolean deleteIvrLibaScriptTargetoptionByTargetoptionids(String[] targetoptionids);
 
 }
diff --git a/smartor/src/main/java/com/smartor/service/impl/HeTaskServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/HeTaskServiceImpl.java
index bf9143d..efddf63 100644
--- a/smartor/src/main/java/com/smartor/service/impl/HeTaskServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/HeTaskServiceImpl.java
@@ -322,10 +322,11 @@
             }
         }
         for (PatArchive patArchive : patArchiveList) {
-            PatTaskRelevance PatTaskRelevance = DtoConversionUtils.sourceToTarget(patArchive, PatTaskRelevance.class);
-            PatTaskRelevance.setCreateTime(patArchive.getCreateTime());
-            PatTaskRelevance.setCreateBy(patArchive.getCreateBy());
-            PatTaskRelevances.add(PatTaskRelevance);
+            PatTaskRelevance patTaskRelevance = DtoConversionUtils.sourceToTarget(patArchive, PatTaskRelevance.class);
+            patTaskRelevance.setCreateTime(patArchive.getCreateTime());
+            patTaskRelevance.setCreateBy(patArchive.getCreateBy());
+            patTaskRelevance.setDeptName(patArchive.getDept());
+            PatTaskRelevances.add(patTaskRelevance);
         }
 
         return PatTaskRelevances;
diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java
index 2568b25..0dce115 100644
--- a/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptServiceImpl.java
@@ -162,7 +162,8 @@
                     if (ivrLibaScriptTargetoption.getId() == null) {
                         log.info("鍒犻櫎澶辫触,闂鎸囨爣閫夐」id涓虹┖");
                     } else {
-                        ivrLibaScriptTargetoptionMapper.deleteIvrLibaScriptTargetoptionByTargetoptionid(ivrLibaScriptTargetoption.getId());
+                        Boolean aBoolean = ivrLibaScriptTargetoptionMapper.deleteIvrLibaScriptTargetoptionByTargetoptionid(ivrLibaScriptTargetoption.getId());
+                        log.info("aBoolean鐨勫�间负:{}", aBoolean);
                     }
                 }
             }
diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptTargetoptionServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptTargetoptionServiceImpl.java
index 637cf89..6f46ce7 100644
--- a/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptTargetoptionServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaScriptTargetoptionServiceImpl.java
@@ -73,8 +73,8 @@
      * @return 缁撴灉
      */
     @Override
-    public int deleteIvrLibaScriptTargetoptionByTargetoptionids(String[] targetoptionids) {
-        Integer i = null;
+    public Boolean deleteIvrLibaScriptTargetoptionByTargetoptionids(String[] targetoptionids) {
+        Boolean i = null;
         for (String id : targetoptionids) {
             i = ivrLibaScriptTargetoptionMapper.deleteIvrLibaScriptTargetoptionByTargetoptionid(Long.valueOf(id));
         }
diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java
index 50b52cf..45dd461 100644
--- a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java
@@ -165,7 +165,8 @@
                 }
             }
         }
-        if (CollectionUtils.isNotEmpty(ivrLibaTargetVO.getTargetoptionList())) {
+        if (CollectionUtils.isNotEmpty(ivrLibaTargetVO.getTargetoptionList()) && ivrLibaTargetVO.getValueType() == 1) {
+            //閫夐」澶勭悊
             for (IvrLibaTargetoption ivrLibaTargetoption : ivrLibaTargetVO.getTargetoptionList()) {
                 if (CollectionUtils.isNotEmpty(ivrLibaTargetoption.getNodynamiccruxs())) {
                     ivrLibaTargetoption.setNodynamiccruxsJson(new Gson().toJson(ivrLibaTargetoption.getNodynamiccruxs()));
@@ -187,6 +188,7 @@
                 }
 
             }
+        } else if (ivrLibaTargetVO.getValueType() == 2 || ivrLibaTargetVO.getValueType() == 3) {
         }
 
         return ivrLibaTarget.getId().intValue();
diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrTaskSingleServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrTaskSingleServiceImpl.java
index f31568c..fff13e3 100644
--- a/smartor/src/main/java/com/smartor/service/impl/IvrTaskSingleServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/IvrTaskSingleServiceImpl.java
@@ -92,6 +92,9 @@
         //瀹氫箟鎮h�呬笌鍗曚竴浠诲姟鍏宠仈琛ㄩ泦鍚�
         List<PatTaskRelevance> patTaskRelevances = new ArrayList<>();
         List<IvrTaskSingle> list = selectIvrTaskcallList(ivrTaskcall);
+        if (CollectionUtils.isEmpty(list)) {
+            new BaseException("璇ヤ换鍔′笉瀛樺湪");
+        }
         //灏嗘煡鍑烘潵鐨勬暟鎹�掑叆IvrTaskcallVO涓�
         IvrTaskSingleVO ivrTaskcallVO2 = DtoConversionUtils.sourceToTarget(list.get(0), IvrTaskSingleVO.class);
         String sendTimeSlot = list.get(0).getSendTimeSlot();
@@ -205,7 +208,7 @@
             IvrTask ivrTask = DtoConversionUtils.sourceToTarget(ivrTaskcallVO, IvrTask.class);
             Integer taskId = ivrTaskService.insertIvrTask(ivrTask);
 
-            ivrTaskcallVO.setTaskid(taskId.longValue());
+            ivrTaskcallVO.setTaskid(ivrTask.getTaskid().longValue());
             //鏂板
             if (CollectionUtils.isNotEmpty(ivrTaskcallVO.getPatTaskRelevances())) {
                 for (PatTaskRelevance patTaskRelevance : ivrTaskcallVO.getPatTaskRelevances()) {
@@ -378,7 +381,7 @@
                 } else if (integer != null && integer < ivrTaskcall.getRecallcount().intValue()) {
                     //杩涜閲嶆嫧
                     PhoneUtils phoneUtils = new PhoneUtils();
-                    phoneUtils.ob(phoneCallBackVO.getUuid(), null, ivrTaskcall.getPhone(), null, null, null, null, null, null, null, null);
+                    phoneUtils.ob(null, null, null, null, null, null, null, ivrTaskcall.getPhone(), phoneCallBackVO.getUuid(), true);
                 }
             }
 
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml
index ef4f226..e844931 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptMapper.xml
@@ -47,6 +47,8 @@
         <result property="deptNames" column="deptNames"/>
         <result property="deptIds" column="deptIds"/>
         <result property="tag" column="tag"/>
+        <result property="valueType" column="value_type"/>
+        <result property="reply" column="reply"/>
     </resultMap>
 
     <sql id="selectIvrLibaScriptVo">
@@ -56,7 +58,8 @@
                deptNames,
                deptIds,
                questiontitle,
-               isenable,
+               value_type,
+               reply,
                isAvailable,
                questionText,
                questionvoice,
@@ -88,7 +91,7 @@
             <if test="tag != null  and tag != ''">and tag = #{tag}</if>
             <if test="suitway != null  and suitway != ''">and suitway = #{suitway}</if>
             <if test="isAvailable != null  and isAvailable != ''">and isAvailable = #{isAvailable}</if>
-            <if test="isenable != null ">and isenable = #{isenable}</if>
+            <if test="valueType != null ">and value_type = #{valueType}</if>
             <if test="questionText != null  and questionText != ''">and questionText = #{questionText}</if>
             <if test="questionvoice != null  and questionvoice != ''">and questionvoice = #{questionvoice}</if>
             <if test="nomatchtext != null  and nomatchtext != ''">and nomatchtext = #{nomatchtext}</if>
@@ -136,7 +139,7 @@
             <if test="deptNames != null">deptNames,</if>
             <if test="tag != null">tag,</if>
             <if test="isAvailable != null">isAvailable,</if>
-            <if test="isenable != null">isenable,</if>
+            <if test="reply != null">reply,</if>
             <if test="questionText != null">questionText,</if>
             <if test="questionvoice != null">questionvoice,</if>
             <if test="nomatchtext != null">nomatchtext,</if>
@@ -171,6 +174,8 @@
             <if test="pid != null">pid,</if>
             <if test="guid != null">guid,</if>
             <if test="otherdata != null">otherdata,</if>
+            <if test="valueType != null">value_type,</if>
+            <if test="reply != null">reply,</if>
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="questiontitle != null">#{questiontitle},</if>
@@ -180,7 +185,7 @@
             <if test="deptNames != null">#{deptNames},</if>
             <if test="tag != null">#{tag},</if>
             <if test="isAvailable != null">#{isAvailable},</if>
-            <if test="isenable != null">#{isenable},</if>
+            <if test="reply != null">#{reply},</if>
             <if test="questionText != null">#{questionText},</if>
             <if test="questionvoice != null">#{questionvoice},</if>
             <if test="nomatchtext != null">#{nomatchtext},</if>
@@ -215,6 +220,8 @@
             <if test="pid != null">#{pid},</if>
             <if test="guid != null">#{guid},</if>
             <if test="otherdata != null">#{otherdata},</if>
+            <if test="valueType != null">#{valueType},</if>
+            <if test="reply != null">#{reply},</if>
         </trim>
     </insert>
 
@@ -224,7 +231,8 @@
             <if test="questiontitle != null">questiontitle = #{questiontitle},</if>
             <if test="suitway != null">suitway = #{suitway},</if>
             <if test="isAvailable != null">isAvailable = #{isAvailable},</if>
-            <if test="isenable != null">isenable = #{isenable},</if>
+            <if test="valueType != null">value_type = #{valueType},</if>
+            <if test="reply != null">reply = #{reply},</if>
             <if test="questionText != null">questionText = #{questionText},</if>
             <if test="questionvoice != null">questionvoice = #{questionvoice},</if>
             <if test="nomatchtext != null">nomatchtext = #{nomatchtext},</if>
@@ -263,6 +271,8 @@
             <if test="deptIds != null">deptIds = #{deptIds},</if>
             <if test="campus != null">campus = #{campus},</if>
             <if test="tag != null">tag = #{tag},</if>
+            <if test="valueType != null">value_type = #{valueType},</if>
+            <if test="reply != null">reply = #{reply},</if>
         </trim>
         where id = #{id}
     </update>
@@ -275,4 +285,4 @@
         where id = #{id}
     </update>
 
-</mapper>
\ No newline at end of file
+</mapper>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml
index e67684d..fa08924 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaScriptTargetoptionMapper.xml
@@ -55,6 +55,7 @@
             resultMap="IvrLibaScriptTargetoptionResult">
         <include refid="selectIvrLibaScriptTargetoptionVo"/>
         <where>
+            del_flag=0
             <if test="targetid != null  and targetid != ''">and targetid = #{targetid}</if>
             <if test="targetname != null  and targetname != ''">and targetname = #{targetname}</if>
             <if test="scriptid != null ">and scriptid = #{scriptid}</if>
@@ -194,4 +195,4 @@
         where id = #{id}
     </delete>
 
-</mapper>
\ No newline at end of file
+</mapper>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml
index f1e0ccf..5cccc91 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetMapper.xml
@@ -12,7 +12,7 @@
         <result property="targetdesc" column="targetdesc"/>
         <result property="language" column="language"/>
         <result property="version" column="version"/>
-        <result property="isenable" column="isenable"/>
+        <result property="valueType" column="value_type"/>
         <result property="isabnormal" column="isabnormal"/>
         <result property="warnup" column="warnup"/>
         <result property="warndown" column="warndown"/>
@@ -31,6 +31,7 @@
         <result property="suitDisease" column="suitDisease"/>
         <result property="suitWay" column="suitWay"/>
         <result property="parameter" column="parameter"/>
+        <result property="reply" column="reply"/>
     </resultMap>
 
     <resultMap type="com.smartor.domain.IvrLibaTargetVO" id="IvrLibaTargetVOResult">
@@ -41,7 +42,7 @@
         <result property="targetdesc" column="targetdesc"/>
         <result property="language" column="language"/>
         <result property="version" column="version"/>
-        <result property="isenable" column="isenable"/>
+        <result property="valueType" column="value_type"/>
         <result property="isabnormal" column="isabnormal"/>
         <result property="warnup" column="warnup"/>
         <result property="warndown" column="warndown"/>
@@ -56,6 +57,7 @@
         <result property="suitDisease" column="suitDisease"/>
         <result property="suitWay" column="suitWay"/>
         <result property="parameter" column="parameter"/>
+        <result property="reply" column="reply"/>
         <collection property="targetoptionList" javaType="java.util.List" resultMap="IvrLibaTargetoptionResult"/>
     </resultMap>
 
@@ -90,7 +92,8 @@
                groupid,
                targettype,
                targetname,
-               targetdesc, language, version, isenable, isabnormal, warnup, warndown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, assortid,
+               reply,
+               targetdesc, language, version, value_type, isabnormal, warnup, warndown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, assortid,
             isAvailable, suitDisease, suitWay, parameter
         from ivr_liba_target
     </sql>
@@ -107,7 +110,7 @@
             <if test="targetdesc != null  and targetdesc != ''">and targetdesc = #{targetdesc}</if>
             <if test="language != null  and language != ''">and language = #{language}</if>
             <if test="version != null ">and version = #{version}</if>
-            <if test="isenable != null ">and isenable = #{isenable}</if>
+            <if test="valueType != null ">and value_type = #{valueType}</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>
@@ -133,13 +136,14 @@
         a.targetdesc,
         a.language,
         a.version,
-        a.isenable,
+        a.value_type,
         a.isabnormal,
         a.warnup,
         a.warndown,
         a.orgid,
         a.pid,
         a.guid,
+        a.reply,
         a.assortid,
         a.isAvailable,
         a.suitDisease,
@@ -163,7 +167,7 @@
             <if test="targetdesc != null  and targetdesc != ''">and a.targetdesc = #{targetdesc}</if>
             <if test="language != null  and language != ''">and a.language = #{language}</if>
             <if test="version != null ">and a.version = #{version}</if>
-            <if test="isenable != null ">and a.isenable = #{isenable}</if>
+            <if test="valueType != null ">and a.valueType = #{value_type}</if>
             <if test="isabnormal != null ">and a.isabnormal = #{isabnormal}</if>
             <if test="warnup != null ">and a.warnup = #{warnup}</if>
             <if test="warndown != null ">and a.warndown = #{warndown}</if>
@@ -196,7 +200,7 @@
             <if test="targetdesc != null">targetdesc,</if>
             <if test="language != null and language != ''">language,</if>
             <if test="version != null">version,</if>
-            <if test="isenable != null">isenable,</if>
+            <if test="valueType != null">value_type,</if>
             <if test="isabnormal != null">isabnormal,</if>
             <if test="warnup != null">warnup,</if>
             <if test="warndown != null">warndown,</if>
@@ -215,6 +219,7 @@
             <if test="suitDisease != null and suitDisease != ''">suitDisease,</if>
             <if test="suitWay != null and suitWay != ''">suitWay,</if>
             <if test="parameter != null and parameter != ''">parameter,</if>
+            <if test="reply != null and reply != ''">reply,</if>
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="groupid != null">#{groupid},</if>
@@ -223,10 +228,12 @@
             <if test="targetdesc != null">#{targetdesc},</if>
             <if test="language != null and language != ''">#{language},</if>
             <if test="version != null">#{version},</if>
-            <if test="isenable != null">#{isenable},</if>
+            <if test="valueType != null">#{valueType},</if>
             <if test="isabnormal != null">#{isabnormal},</if>
             <if test="warnup != null">#{warnup},</if>
             <if test="warndown != null">#{warndown},</if>
+            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
+            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
             <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
             <if test="updateBy != null">#{updateBy},</if>
             <if test="updateTime != null">#{updateTime},</if>
@@ -242,6 +249,7 @@
             <if test="suitDisease != null and suitDisease != ''">#{suitDisease},</if>
             <if test="suitWay != null and suitWay != ''">#{suitWay},</if>
             <if test="parameter != null and parameter != ''">#{parameter},</if>
+            <if test="reply != null and reply != ''">#{reply},</if>
         </trim>
     </insert>
 
@@ -254,7 +262,7 @@
             <if test="targetdesc != null">targetdesc = #{targetdesc},</if>
             <if test="language != null and language != ''">language = #{language},</if>
             <if test="version != null">version = #{version},</if>
-            <if test="isenable != null">isenable = #{isenable},</if>
+            <if test="valueType != null">value_type = #{valueType},</if>
             <if test="isabnormal != null">isabnormal = #{isabnormal},</if>
             <if test="warnup != null">warnup = #{warnup},</if>
             <if test="warndown != null">warndown = #{warndown},</if>
@@ -273,6 +281,7 @@
             <if test="suitWay != null and suitWay != ''">suitWay = #{suitWay},</if>
             <if test="isAvailable != null and isAvailable != ''">isAvailable = #{isAvailable},</if>
             <if test="parameter != null and parameter != ''">parameter = #{parameter},</if>
+            <if test="reply != null and reply != ''">reply = #{reply},</if>
         </trim>
         where id = #{id}
     </update>
@@ -289,4 +298,4 @@
             #{id}
         </foreach>
     </delete>
-</mapper>
\ No newline at end of file
+</mapper>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml
index 1aea316..41c167d 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml
@@ -16,7 +16,8 @@
         <result property="submodule" column="submodule"/>
         <result property="language" column="language"/>
         <result property="note" column="note"/>
-        <result property="isEnable" column="isEnable"/>
+        <result property="valueType" column="value_type"/>
+        <result property="reply" column="reply"/>
         <result property="addUserID" column="addUserID"/>
         <result property="addTime" column="addTime"/>
         <result property="modifyUserID" column="modifyUserID"/>
@@ -58,6 +59,8 @@
     <sql id="selectIvrLibaTemplateVo">
         select ID,
                targetid,
+               value_type,
+               reply,
                revisit_before,
                revisit_after,
                targetname,
@@ -74,7 +77,7 @@
                suitway,
                mate_num,
                no_voice_num,
-               submodule, language, note, isEnable, addUserID, addTime, modifyUserID, modifyTime, groupID, label_info, submoduleID, playType, icd10code, icd10codename, atuoTaskDayOffset, deptIds, dept_names, F_KSDM, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, assortid, parameter
+               submodule, language, note, addUserID, addTime, modifyUserID, modifyTime, groupID, label_info, submoduleID, playType, icd10code, icd10codename, atuoTaskDayOffset, deptIds, dept_names, F_KSDM, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, assortid, parameter
         from ivr_liba_template
     </sql>
 
@@ -102,7 +105,6 @@
             <if test="submodule != null  and submodule != ''">and submodule = #{submodule}</if>
             <if test="language != null  and language != ''">and language = #{language}</if>
             <if test="note != null  and note != ''">and note = #{note}</if>
-            <if test="isEnable != null ">and isEnable = #{isEnable}</if>
             <if test="addUserID != null  and addUserID != ''">and addUserID = #{addUserID}</if>
             <if test="addTime != null ">and addTime = #{addTime}</if>
             <if test="modifyUserID != null  and modifyUserID != ''">and modifyUserID = #{modifyUserID}</if>
@@ -156,7 +158,8 @@
             <if test="submodule != null">submodule,</if>
             <if test="language != null and language != ''">language,</if>
             <if test="note != null">note,</if>
-            <if test="isEnable != null">isEnable,</if>
+            <if test="valueType != null">value_type,</if>
+            <if test="reply != null">reply,</if>
             <if test="addUserID != null">addUserID,</if>
             <if test="addTime != null">addTime,</if>
             <if test="modifyUserID != null">modifyUserID,</if>
@@ -205,7 +208,8 @@
             <if test="submodule != null">#{submodule},</if>
             <if test="language != null and language != ''">#{language},</if>
             <if test="note != null">#{note},</if>
-            <if test="isEnable != null">#{isEnable},</if>
+            <if test="valueType != null">#{valueType},</if>
+            <if test="reply != null">#{reply},</if>
             <if test="addUserID != null">#{addUserID},</if>
             <if test="addTime != null">#{addTime},</if>
             <if test="modifyUserID != null">#{modifyUserID},</if>
@@ -239,6 +243,7 @@
             <if test="revisitAfter != null ">#{revisitAfter}</if>
             <if test="revisitBefore != null ">#{revisitBefore}</if>
             <if test="noVoiceNum != null and noVoiceNum > 0">#{noVoiceNum}</if>
+
         </trim>
     </insert>
 
@@ -258,7 +263,8 @@
             <if test="submodule != null">submodule = #{submodule},</if>
             <if test="language != null and language != ''">language = #{language},</if>
             <if test="note != null">note = #{note},</if>
-            <if test="isEnable != null">isEnable = #{isEnable},</if>
+            <if test="valueType != null">value_type = #{valueType},</if>
+            <if test="reply != null">reply = #{reply},</if>
             <if test="addUserID != null">addUserID = #{addUserID},</if>
             <if test="addTime != null">addTime = #{addTime},</if>
             <if test="modifyUserID != null">modifyUserID = #{modifyUserID},</if>
@@ -310,4 +316,4 @@
             #{ID}
         </foreach>
     </delete>
-</mapper>
\ No newline at end of file
+</mapper>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateScriptMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateScriptMapper.xml
index e8f426b..5dde368 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateScriptMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTemplateScriptMapper.xml
@@ -41,6 +41,7 @@
         <result property="questiontitle" column="questiontitle"/>
         <result property="nextQuestion" column="next_question"/>
         <result property="otherdata" column="otherdata"/>
+        <result property="isMust" column="is_must"/>
     </resultMap>
 
     <sql id="selectIvrLibaTemplateScriptVo">
@@ -66,6 +67,7 @@
                questiontitle,
                next_question,
                otherdata,
+               is_must,
                targetOptions, language, playWavOnly, isEnable, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid
         from ivr_liba_template_script
     </sql>
@@ -105,6 +107,7 @@
             <if test="targetid != null ">and targetid = #{targetid}</if>
             <if test="targettype != null  and targettype != ''">and targettype = #{targettype}</if>
             <if test="targetvalue != null  and targetvalue != ''">and targetvalue = #{targetvalue}</if>
+            <if test="isMust != null  and isMust != ''">and is_must = #{isMust}</if>
         </where>
     </select>
 
@@ -153,6 +156,7 @@
             <if test="questiontitle != null">questiontitle,</if>
             <if test="nextQuestion != null">next_question,</if>
             <if test="otherdata != null">otherdata,</if>
+            <if test="isMust != null  and isMust != ''">is_must,</if>
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="templateQuestionNum != null">#{templateQuestionNum},</if>
@@ -190,6 +194,7 @@
             <if test="questiontitle != null">#{questiontitle},</if>
             <if test="nextQuestion != null">#{nextQuestion},</if>
             <if test="otherdata != null">#{otherdata},</if>
+            <if test="isMust != null  and isMust != ''">#{isMust},</if>
         </trim>
     </insert>
 
@@ -231,6 +236,7 @@
             <if test="questiontitle != null">questiontitle = #{questiontitle},</if>
             <if test="nextQuestion != null">next_question = #{nextQuestion},</if>
             <if test="otherdata != null">otherdata = #{otherdata},</if>
+            <if test="isMust != null  and isMust != ''">is_must = #{isMust}</if>
         </trim>
         where ID = #{ID}
     </update>
@@ -249,4 +255,4 @@
             #{ID}
         </foreach>
     </delete>
-</mapper>
\ No newline at end of file
+</mapper>
diff --git a/smartor/src/main/resources/mapper/smartor/IvrTaskSingleMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrTaskSingleMapper.xml
index 96aaa82..9667cc4 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrTaskSingleMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrTaskSingleMapper.xml
@@ -191,6 +191,7 @@
             <if test="operator != null  and operator != ''">and operator = #{operator}</if>
             <if test="operatorNo != null  and operatorNo != ''">and operator_no = #{operatorNo}</if>
             <if test="wechat != null  and wechat != ''">and wechat = #{wechat}</if>
+            <if test="hospType != null  and hospType != ''">and hosp_type = #{hospType}</if>
         </where>
         order by update_time desc,id desc
     </select>
diff --git a/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml b/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml
index d3b775d..9d4ca36 100644
--- a/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml
@@ -34,6 +34,7 @@
         <result property="tag" column="tag"/>
         <result property="pattype" column="pattype"/>
         <result property="bedNo" column="bedno"/>
+        <result property="inhosptime" column="inhosptime"/>
     </resultMap>
 
     <sql id="selectPatArchiveVo">
@@ -269,8 +270,6 @@
             resultMap="PatArchiveResult">
 
         select
-        -- c.tagname as tag,
-        -- b.tagid as tagid,
         a.patid,
         a.name,
         d.deptname,
@@ -298,21 +297,15 @@
         a.isupload,
         a.upload_time,
         a.pattype,
-        d.bed_no
-        -- from pat_archive a,pat_archivetag b ,base_tag c,pat_med_inhosp d
+        d.bed_no,
+        d.starttime as inhosptime
         from pat_archive a,pat_med_inhosp d
         <where>
-            -- a.patid = b.patid and b.tagid = c.tagid and a.patid = d.patid
             a.patid = d.patid
             <if test="name != null  and name != ''">and a.name like concat('%', #{name}, '%')</if>
             <if test="idcardno != null  and idcardno != ''">and a.idcardno = #{idcardno}</if>
             <if test="pid != null  and pid != ''">and a.patid = #{pid}</if>
             <if test="telcode != null  and telcode != ''">and a.telcode = #{telcode}</if>
-            <!--            <if test="tagIds != null  and tagIds != ''">and c.tagid in-->
-            <!--                <foreach collection="tagIds" item="tagId" open="(" separator="," close=")">-->
-            <!--                    #{tagId}-->
-            <!--                </foreach>-->
-            <!--            </if>-->
 
             <if test="hospitalname != null and hospitalname != ''">
                 AND d.hospitalname = #{hospitalname}
@@ -343,8 +336,6 @@
             </if>
 
             AND d.del_flag != 1
-            -- AND b.del_flag != 1
-            -- AND c.del_flag != 1
             AND a.del_flag != 1
         </where>
     </select>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibTitleMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibTitleMapper.xml
index 9894aa5..ce11791 100644
--- a/smartor/src/main/resources/mapper/smartor/SvyLibTitleMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/SvyLibTitleMapper.xml
@@ -31,11 +31,15 @@
         <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"/>
     </resultMap>
 
     <sql id="selectSvyLibTitleVo">
         select svyid,
                categoryid,
+               value_type,
+               reply,
                svycode,
                svyname,
                description,
@@ -66,7 +70,8 @@
     <select id="selectSvyLibTitleList" parameterType="com.smartor.domain.SvyLibTitleReq" resultMap="SvyLibTitleResult">
         select a.svyid, a.categoryid, a.svycode, a.svyname, a.description, a.introduce,a.submitprompt, a.templateid,
         a.version,a.centerlibrarycode, a.centerlibraryid, a.islocal, a.isenable, a.orgid, a.del_flag, a.create_by,
-        a.create_time, a.update_by, a.update_time, a.isupload, a.upload_time,a.dept_names,a.label_info,
+        a.create_time, a.update_by, a.update_time, a.isupload,
+        a.upload_time,a.dept_names,a.value_type,a.label_info,a.reply,
         a.campus,a.suitway,a.otherdata
         ,c.icdname from svy_lib_title
         a,icd10_association b,icd10 c
@@ -115,6 +120,10 @@
             <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>
+            value_type,
+            reply,
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="categoryid != null">#{categoryid},</if>
@@ -142,6 +151,8 @@
             <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>
         </trim>
     </insert>
 
@@ -173,6 +184,8 @@
             <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>
         </trim>
         where svyid = #{svyid}
     </update>
@@ -189,4 +202,4 @@
             #{svyid}
         </foreach>
     </delete>
-</mapper>
\ No newline at end of file
+</mapper>
diff --git a/smartor/src/main/resources/mapper/smartor/SvyLibTopicMapper.xml b/smartor/src/main/resources/mapper/smartor/SvyLibTopicMapper.xml
index bfce5aa..2f4bf1e 100644
--- a/smartor/src/main/resources/mapper/smartor/SvyLibTopicMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/SvyLibTopicMapper.xml
@@ -29,11 +29,15 @@
         <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"/>
     </resultMap>
 
     <sql id="selectSvyLibTopicVo">
         select topicid,
                oldid,
+               value_type,
+               reply,
                svyid,
                topictype,
                topiccode,
@@ -55,7 +59,7 @@
                suitway,
                isavailable,
                otherdata,
-               language,
+            language,
             svy_topicid as svyTopicId
         from svy_lib_topic
     </sql>
@@ -112,6 +116,8 @@
             <if test="isavailable != null and isavailable != ''">isavailable,</if>
             <if test="language != null and language!=''">language,</if>
             <if test="otherdata != null and otherdata!=''">otherdata,</if>
+            <if test="valueType != null and valueType!=''">value_type,</if>
+            <if test="reply != null and reply!=''">otherdata,</if>
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="oldid != null">#{oldid},</if>
@@ -138,6 +144,8 @@
             <if test="isavailable != null and isavailable != ''">#{isavailable},</if>
             <if test="language != null  and language!=''">#{language},</if>
             <if test="otherdata != null and otherdata!=''">#{otherdata},</if>
+            <if test="valueType != null and valueType!=''">#{valueType},</if>
+            <if test="reply != null and reply!=''">#{therdata},</if>
         </trim>
     </insert>
 
@@ -167,6 +175,8 @@
             <if test="tag != null">tag = #{tag},</if>
             <if test="language != null and language!=''">language = #{language},</if>
             <if test="otherdata != null and otherdata!=''">otherdata = #{otherdata},</if>
+            <if test="valueType != null and valueType!=''">value_type = #{valueType},</if>
+            <if test="reply != null and reply!=''">therdata =#{therdata},</if>
         </trim>
         where topicid = #{topicid}
     </update>
@@ -187,4 +197,4 @@
     </delete>
 
 
-</mapper>
\ No newline at end of file
+</mapper>

--
Gitblit v1.9.3