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