.idea/workspace.xml
@@ -4,13 +4,25 @@ <option name="autoReloadType" value="SELECTIVE" /> </component> <component name="ChangeListManager"> <list default="true" id="d7325e97-ef1a-4946-a53e-fea72f2992f8" name="Changes" comment="ä»£ç æäº¤"> <list default="true" id="d7325e97-ef1a-4946-a53e-fea72f2992f8" name="Changes" comment=""> <change afterPath="$PROJECT_DIR$/ruoyi-common/src/main/java/com/ruoyi/common/enums/HospTypeEnum.java" afterDir="false" /> <change afterPath="$PROJECT_DIR$/ruoyi-common/src/main/java/com/ruoyi/common/enums/ServiceTaskTypeEnum.java" afterDir="false" /> <change afterPath="$PROJECT_DIR$/ruoyi-common/src/main/java/com/ruoyi/common/enums/TaskTypeEnum.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/.idea/workspace.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/workspace.xml" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/component/RedisMqReceiver.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/component/RedisMqReceiver.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-common/src/main/java/com/ruoyi/common/core/redis/RedisCache.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-common/src/main/java/com/ruoyi/common/core/redis/RedisCache.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceExternalController.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceExternalController.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskController.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskController.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-admin/src/main/resources/application-druid.yml" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-admin/src/main/resources/application-druid.yml" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-admin/src/main/resources/application.yml" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-admin/src/main/resources/application.yml" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java" beforeDir="false" afterPath="$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/domain/ServiceSubtask.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/domain/ServiceSubtask.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/domain/ServiceSubtaskVO.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/domain/ServiceSubtaskVO.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/domain/ServiceTaskInfo.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/domain/ServiceTaskInfo.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/SvyTaskSingleServiceImpl.java" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/SvyTaskSingleServiceImpl.java" afterDir="false" /> <change beforePath="$PROJECT_DIR$/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml" beforeDir="false" afterPath="$PROJECT_DIR$/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml" afterDir="false" /> </list> <option name="SHOW_DIALOG" value="false" /> <option name="HIGHLIGHT_CONFLICTS" value="true" /> @@ -93,11 +105,11 @@ <recent name="D:\daima\smartor\smartor-lisui\smartor\src\main\java\com\smartor\mapper" /> </key> <key name="CopyClassDialog.RECENTS_KEY"> <recent name="com.ruoyi.common.enums" /> <recent name="com.smartor.domain" /> <recent name="com.ruoyi.web.controller.smartor" /> <recent name="com.smartor.service" /> <recent name="com.smartor.service.impl" /> <recent name="com.smartor.mapper" /> </key> </component> <component name="RedisHelper"> @@ -228,9 +240,9 @@ </configuration> <recent_temporary> <list> <item itemvalue="JUnit.MQTest.bb" /> <item itemvalue="JUnit.FtpService.aa" /> <item itemvalue="JUnit.FtpService" /> <item itemvalue="JUnit.MQTest.bb" /> <item itemvalue="JUnit.MQTest" /> </list> </recent_temporary> @@ -332,7 +344,7 @@ <workItem from="1739411538383" duration="21710000" /> <workItem from="1739501318573" duration="2373000" /> <workItem from="1739507523684" duration="15221000" /> <workItem from="1739766088739" duration="469000" /> <workItem from="1739766088739" duration="19190000" /> </task> <task id="LOCAL-00001" summary="ä»£ç æäº¤"> <created>1730948127775</created> @@ -383,7 +395,14 @@ <option name="project" value="LOCAL" /> <updated>1734406665810</updated> </task> <option name="localTasksCounter" value="8" /> <task id="LOCAL-00008" summary="å¾é忰墿¯ï¼å¤ææ¯å¾å¤´é¨æ°å¢è¿æ¯å¾å°¾é¨æ°å¢"> <created>1739766619501</created> <option name="number" value="00008" /> <option name="presentableId" value="LOCAL-00008" /> <option name="project" value="LOCAL" /> <updated>1739766619501</updated> </task> <option name="localTasksCounter" value="9" /> <servers /> </component> <component name="TypeScriptGeneratedFilesManager"> @@ -403,7 +422,8 @@ <component name="VcsManagerConfiguration"> <MESSAGE value="ä»£ç æäº¤(é¿æä»»å¡çµè¯å®æ)" /> <MESSAGE value="ä»£ç æäº¤" /> <option name="LAST_COMMIT_MESSAGE" value="ä»£ç æäº¤" /> <MESSAGE value="å¾é忰墿¯ï¼å¤ææ¯å¾å¤´é¨æ°å¢è¿æ¯å¾å°¾é¨æ°å¢" /> <option name="LAST_COMMIT_MESSAGE" value="å¾é忰墿¯ï¼å¤ææ¯å¾å¤´é¨æ°å¢è¿æ¯å¾å°¾é¨æ°å¢" /> </component> <component name="XDebuggerManager"> <breakpoint-manager> @@ -425,12 +445,12 @@ </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceExternalController.java</url> <line>116</line> <line>115</line> <option name="timeStamp" value="281" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceExternalController.java</url> <line>133</line> <line>132</line> <option name="timeStamp" value="285" /> </line-breakpoint> <line-breakpoint type="java-line"> @@ -525,7 +545,7 @@ </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/SvyTaskSingleServiceImpl.java</url> <line>206</line> <line>209</line> <option name="timeStamp" value="349" /> </line-breakpoint> <line-breakpoint type="java-line"> @@ -535,7 +555,7 @@ </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/SvyTaskSingleServiceImpl.java</url> <line>311</line> <line>266</line> <option name="timeStamp" value="352" /> </line-breakpoint> <line-breakpoint type="java-line"> @@ -640,27 +660,27 @@ </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java</url> <line>523</line> <line>530</line> <option name="timeStamp" value="383" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java</url> <line>662</line> <line>669</line> <option name="timeStamp" value="384" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java</url> <line>634</line> <line>641</line> <option name="timeStamp" value="385" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>1983</line> <line>1991</line> <option name="timeStamp" value="386" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>1979</line> <line>1987</line> <option name="timeStamp" value="387" /> </line-breakpoint> <line-breakpoint type="java-line"> @@ -680,33 +700,68 @@ </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java</url> <line>298</line> <option name="timeStamp" value="404" /> <line>320</line> <option name="timeStamp" value="405" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java</url> <line>313</line> <option name="timeStamp" value="405" /> </line-breakpoint> <line-breakpoint enabled="true" type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java</url> <line>255</line> <line>256</line> <option name="timeStamp" value="412" /> </line-breakpoint> <line-breakpoint enabled="true" type="java-line"> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskController.java</url> <line>205</line> <option name="timeStamp" value="415" /> </line-breakpoint> <line-breakpoint enabled="true" type="java-line"> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>1440</line> <line>1442</line> <option name="timeStamp" value="416" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>1493</line> <option name="timeStamp" value="417" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java</url> <line>339</line> <option name="timeStamp" value="420" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java</url> <line>206</line> <option name="timeStamp" value="421" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java</url> <line>51</line> <option name="timeStamp" value="425" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>2093</line> <option name="timeStamp" value="426" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskController.java</url> <line>204</line> <option name="timeStamp" value="427" /> </line-breakpoint> <line-breakpoint type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>2102</line> <option name="timeStamp" value="428" /> </line-breakpoint> <line-breakpoint enabled="true" type="java-line"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java</url> <line>1489</line> <option name="timeStamp" value="417" /> <line>1510</line> <option name="timeStamp" value="429" /> </line-breakpoint> <line-breakpoint enabled="true" type="java-line"> <url>file://$PROJECT_DIR$/ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/SysMenuController.java</url> <line>107</line> <option name="timeStamp" value="431" /> </line-breakpoint> <line-breakpoint enabled="true" type="java-method"> <url>file://$PROJECT_DIR$/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java</url> ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceExternalController.java
@@ -61,12 +61,11 @@ */ @ApiOperation("æ°å¢ä»»å¡") @PostMapping("/generalInterfaceAddTask") public AjaxResult generalInterfaceAddTask(@RequestBody ServiceTaskInfo serviceSubtask) { ServiceTaskInfo serviceTaskVO = null; public AjaxResult generalInterfaceAddTask(@RequestBody ServiceTaskInfo serviceTaskInfo) { log.error("------serviceTaskInfoçå¼ä¸ºï¼{}", serviceTaskInfo); Integer res = 0; try { serviceTaskVO = DtoConversionUtils.sourceToTarget(serviceSubtask, ServiceTaskInfo.class); res = svyTaskSingleService.insertTaskInfo(serviceTaskVO); res = svyTaskSingleService.insertTaskInfo(serviceTaskInfo); } catch (Exception e) { e.printStackTrace(); log.error("serviceExternal---generalInterfaceAddTaskåºå¼å¸¸äºï¼{}", e.getMessage()); ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskController.java
@@ -204,6 +204,8 @@ public List<PullTaskVO> taskPull() { log.error("çµè¯ä»»å¡æå(é¨ç»®)"); List<PullTaskVO> pullTaskVOList = serviceSubtaskService.taskPull(); // List<PullTaskVO> pullTaskVOList = new ArrayList<>(); log.error("çµè¯ä»»å¡æå(é¨ç»®):{}", pullTaskVOList); return pullTaskVOList; } ruoyi-admin/src/main/java/com/ruoyi/web/test/MQTest.java
@@ -48,7 +48,8 @@ @Test public void bb() { int i = 61 /60; System.out.println(i); } public void aa(MultipartFile file) throws IOException { ruoyi-admin/src/main/resources/application-druid.yml
@@ -18,13 +18,13 @@ password: Smartor.2023 driverClassName: com.mysql.cj.jdbc.Driver # æ°å # url: jdbc:mysql://192.168.191.181:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 # username: smartor # password: Smartor.2023 # driverClassName: com.mysql.cj.jdbc.Driver # url: jdbc:mysql://192.168.191.181:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 # username: smartor # password: Smartor.2023 # driverClassName: com.mysql.cj.jdbc.Driver # å ¬å¸äº # url: jdbc:mysql://116.62.18.175:6002/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 # url: jdbc:mysql://116.62.18.175:6002/smartor_lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 # username: hxsoft # password: Hxerp2000 # driverClassName: com.mysql.cj.jdbc.Driver @@ -151,12 +151,12 @@ qrpath: D:\qrcode #å ¬å¸å å¤é¾è¯·æ±IPå端å£å· req_path: 8095 localIP: 192.168.2.13 #req_path: 8095 #localIP: 192.168.2.13 #æ°åå»é¢å¤é¾è¯·æ±IPå端å£å· #req_path: 8093 #localIP: https://wx.lihusmart.com req_path: 8093 localIP: https://wx.lihusmart.com #è·åæ£è ä¿¡æ¯URL(ååæä¾) hosp_info_url: http://esb-core-rest.wowjoy.cn/esb/exchange @@ -165,23 +165,23 @@ uploadSwitch: 1 ## æå®asråè°çurlè·¯å¾(æ¬å°) ASRCallBackPath: http://192.168.2.13:8095/smartor/serviceSubtask/phoneCallBackYQ #ASRCallBackPath: http://192.168.2.13:8095/smartor/serviceSubtask/phoneCallBackYQ ##ææIP(æ¬å°) hangup: http://192.168.2.13:8091/hangup #hangup: http://192.168.2.13:8091/hangup ##fsæä½¿ç¨çé¿éçapp_key(æ¬å°) #app_key_yq: ZurNHpaQLq6P55YS # æå®asråè°çurlè·¯å¾(æ°å) #ASRCallBackPath: http://192.168.101.135:8095/smartor/serviceSubtask/phoneCallBackYQ ASRCallBackPath: http://192.168.101.135:8095/smartor/serviceSubtask/phoneCallBackYQ #ææIP(æ°å) #hangup: http://192.16.4.220:8091/hangup hangup: http://192.16.4.220:8091/hangup #fsæä½¿ç¨çé¿éçapp_key(æ°å) app_key_yq: ZurNHpaQLq6P55YS #æ¬ å° ç信请æ±å°å(è¿ä¸ªæå¡æ¯æä»¬èªå·±åç) xhsmsPath: http://192.168.2.13:8092/sendSms #xhsmsPath: http://192.168.2.13:8092/sendSms #æ°åç信请æ±å°å(è¿ä¸ªæå¡æ¯æä»¬èªå·±åç) #xhsmsPath: http://192.16.4.220:8092/sendSms xhsmsPath: http://192.16.4.220:8092/sendSms #å¸å· xhsmsAccount: 911124 #æ¥å£å¯ç @@ -200,12 +200,14 @@ FTP_PASSWORD: xh@2023 #è¯é³å°å访é®åç¼(æ°å) #voicePathPrefix: http://192.168.191.181:8095/profile/upload/vadio/ voicePathPrefix: http://192.168.191.181:8095/profile/upload/vadio/ #è¯é³å°å访é®åç¼(å ¬å¸) voicePathPrefix: http://192.168.2.13:8095/profile/upload/vadio/ #voicePathPrefix: http://192.168.2.13:8095/profile/upload/vadio/ #å 许èªå¨çæä»»å¡ createTaskServiceType: 2 #ç¬¬ä¸ªå°æ¶çµè¯æ¨æçä¸é phoneUpEveryHour: 10 phoneUpEveryHour: 12 #çµè¯æ¯å¤©ç»ææ¶é´ phoneEndHour: 20 ruoyi-admin/src/main/resources/application.yml
@@ -72,7 +72,7 @@ # redis é ç½® redis: # # å°åï¼ä¸½æ°´ï¼ # host: 127.0.0.1 # host: 127.0.0.1 # å°åï¼å ¬å¸ï¼ host: 116.62.18.175 port: 6020 ruoyi-common/src/main/java/com/ruoyi/common/enums/HospTypeEnum.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ package com.ruoyi.common.enums; /** * åéç±»åæä¸¾ */ public enum HospTypeEnum { é¨è¯("1", "é¨è¯"), åºé¢("2", "ãåºé¢"), ä¸ç ("3", "ä¸ç "), å¤é¨å¯¼å ¥("4", "å¤é¨å¯¼å ¥"), æ¥è¯("5", "ãæ¥è¯"), ä½é¢("6", "ä½é¢"), 使£("7", "使£"); private String code; private String desc; HospTypeEnum(String code, String desc) { this.code = code; this.desc = desc; } public static String getDescByCode(String desc) { HospTypeEnum[] organEnums = values(); for (int i = 0; i < organEnums.length; i++) { HospTypeEnum organEnum = organEnums[i]; if (organEnum.getDesc().equals(desc)) { return organEnum.getCode(); } } return "0"; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public String getDesc() { return desc; } public void setDesc(String desc) { this.desc = desc; } } ruoyi-common/src/main/java/com/ruoyi/common/enums/ServiceTaskTypeEnum.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ package com.ruoyi.common.enums; /** * åéç±»åæä¸¾ */ public enum ServiceTaskTypeEnum { 使£é访("9", "使£é访 "), 廿é访("10", "廿é访"); private String code; private String desc; ServiceTaskTypeEnum(String code, String desc) { this.code = code; this.desc = desc; } public static String getDescByCode(String desc) { ServiceTaskTypeEnum[] organEnums = values(); for (int i = 0; i < organEnums.length; i++) { ServiceTaskTypeEnum organEnum = organEnums[i]; if (organEnum.getDesc().equals(desc)) { return organEnum.getCode(); } } return "0"; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public String getDesc() { return desc; } public void setDesc(String desc) { this.desc = desc; } } ruoyi-common/src/main/java/com/ruoyi/common/enums/TaskTypeEnum.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ package com.ruoyi.common.enums; /** * åéç±»åæä¸¾ */ public enum TaskTypeEnum { 使£é访("8", "使£é访"), å¿çµä¸ç§é访("9", "ãå¿çµä¸ç§é访"), å½±åä¸ç§é访("10", "å½±åä¸ç§é访"); private String code; private String desc; TaskTypeEnum(String code, String desc) { this.code = code; this.desc = desc; } public static String getDescByCode(String desc) { TaskTypeEnum[] organEnums = values(); for (int i = 0; i < organEnums.length; i++) { TaskTypeEnum organEnum = organEnums[i]; if (organEnum.getDesc().equals(desc)) { return organEnum.getCode(); } } return "0"; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public String getDesc() { return desc; } public void setDesc(String desc) { this.desc = desc; } } ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java
@@ -72,7 +72,7 @@ * @return ä¿®æ¹åç SQL */ private String modifySqlWithorgidId(String originalSql, String orgid) { if (originalSql.contains("insert into") || originalSql.contains("INSERT INTO") || originalSql.contains("from sys_menu")) if (originalSql.contains("insert into") || originalSql.contains("INSERT INTO") || originalSql.contains("from sys_menu") || originalSql.contains("update sys_menu")) return originalSql; // æå orgid ç WHERE åå¥ String whereClause = " orgid = '" + orgid + "'"; ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java
@@ -48,6 +48,7 @@ import java.time.ZoneId; import java.time.format.DateTimeFormatter; import java.util.*; import java.util.stream.Collectors; /** * 宿¶ä»»å¡è°åº¦æµè¯ @@ -308,7 +309,13 @@ ServiceSubtaskVO ivrTaskcall = new ServiceSubtaskVO(); ivrTaskcall.setTaskid(commonTaskcallMQ.getTaskid()); ivrTaskcall.setSendstate(2L); List<ServiceSubtask> selectServiceSubtaskList = iServiceSubtaskService.selectServiceSubtaskList(ivrTaskcall); List<ServiceSubtask> subtaskList = iServiceSubtaskService.selectServiceSubtaskList(ivrTaskcall); // æç § endtime 离å½åæ¶é´æè¿çæåº List<ServiceSubtask> selectServiceSubtaskList = subtaskList.stream() .sorted(Comparator.comparing(subtask -> Math.abs(subtask.getEndtime().getTime() - new Date().getTime()))) .collect(Collectors.toList()); if (descByCode.equals("çµè¯")) { String value = ""; List<String> list = new ArrayList<>(); smartor/src/main/java/com/smartor/domain/ServiceSubtask.java
@@ -35,6 +35,12 @@ private Long taskid; /** * ç¬¬ä¸æ¹ä»»å¡ID */ @ApiModelProperty(value = "ç¬¬ä¸æ¹ä»»å¡ID") private String taskGuid; /** * åºé¢ç 人记å½ID */ @ApiModelProperty(value = "åºé¢ç 人记å½ID") @@ -144,14 +150,14 @@ * ä»»å¡ç±»å(é¨è¯ï¼ä½é¢ï¼å¤è¯â¦) */ @Excel(name = "ä»»å¡ç±»å(0éç¥ã1宣æã2é¨è¯ã3åºé¢ã4å¤è¯ã5使£ã6é®å·ã7廿â¦â¦)") @ApiModelProperty(value = "ä»»å¡ç±»å(0éç¥ã1宣æã2é¨è¯ã3åºé¢ã4å¤è¯ã5使£ã6é®å·ã7廿â¦â¦)") @ApiModelProperty(value = "ä»»å¡ç±»å(0éç¥ã1宣æã2é¨è¯ã3åºé¢ã4å¤è¯ã5使£ã6é®å·ã7廿ã8使£é访ã9å½±åä¸ç§é访ã10å¿çµä¸ç§é访â¦â¦)") private String type; /** * æå¡ç±»å(1ãçæµè¯ä¼°ï¼2ãåºé¢é访ï¼3ãé¨è¯é访ï¼4ã宣æå ³æï¼5ãå¤è¯éç¥ï¼6ãæ»¡æåº¦è°æ¥ï¼7ãæ£è æ¥åï¼ 8ãå ¶ä»éç¥) */ @Excel(name = "æå¡ç±»å(1ãçæµè¯ä¼°ï¼2ãåºé¢é访ï¼3ãé¨è¯é访ï¼4ã宣æå ³æï¼5ãå¤è¯éç¥ï¼6ãæ»¡æåº¦è°æ¥ï¼7ãæ£è æ¥åï¼ 8ãå ¶ä»éç¥)") @ApiModelProperty(value = "æå¡ç±»å(1ãçæµè¯ä¼°ï¼2ãåºé¢é访ï¼3ãé¨è¯é访ï¼4ã宣æå ³æï¼5ãå¤è¯éç¥ï¼6ãæ»¡æåº¦è°æ¥ï¼7ãæ£è æ¥åï¼ 8ãå ¶ä»éç¥)") @ApiModelProperty(value = "æå¡ç±»å(1ãçæµè¯ä¼°ï¼2ãåºé¢é访ï¼3ãé¨è¯é访ï¼4ã宣æå ³æï¼5ãå¤è¯éç¥ï¼6ãæ»¡æåº¦è°æ¥ï¼7ãæ£è æ¥åï¼ 8ãå ¶ä»éç¥ 9使£é访 10廿é访") private String serviceType; /** @@ -420,7 +426,7 @@ * å°±è¯ç±»åï¼1é¨è¯ 2åºé¢ï¼ */ @Excel(name = " å°±è¯ç±»åï¼1é¨è¯ 2åºé¢ï¼") @ApiModelProperty(value = "å°±è¯ç±»åï¼1é¨è¯ 2åºé¢ 3.ä¸ç 4.å¤é¨å¯¼å ¥ï¼") @ApiModelProperty(value = "å°±è¯ç±»åï¼1é¨è¯ 2åºé¢ 3.ä¸ç 4.å¤é¨å¯¼å ¥ 5æ¥è¯ã5ä½é¢ã7使£ï¼") private String hospType; smartor/src/main/java/com/smartor/domain/ServiceSubtaskVO.java
@@ -28,6 +28,13 @@ @ApiModelProperty(value = "主é®id") private Long subId; /** * ç¬¬ä¸æ¹ä»»å¡ID */ @ApiModelProperty(value = "ç¬¬ä¸æ¹ä»»å¡ID") private String taskGuid; /** * åé人 */ smartor/src/main/java/com/smartor/domain/ServiceTaskInfo.java
@@ -33,7 +33,7 @@ private long taskstate; @ApiModelProperty(value = "ä»»å¡ID") private long taskguid; private String taskguid; @ApiModelProperty(value = "ä»»å¡åç§°") private String taskname; smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
@@ -51,6 +51,8 @@ public Boolean updateServiceSubtaskByPatId(ServiceSubtask ServiceSubtask); public Boolean updateServiceSubtaskByCondition(ServiceSubtask ServiceSubtask); public Boolean updateServiceSubtaskByTaskGuid(ServiceSubtask ServiceSubtask); /** * å é¤åä¸ä»»å¡ï¼éè®¿ï¼ smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
@@ -124,6 +124,8 @@ @Value("${phoneUpEveryHour}") private Integer phoneUpEveryHour; @Value("${phoneEndHour}") private Integer phoneEndHour; /** * æ¥è¯¢åä¸ä»»å¡ï¼éè®¿ï¼ @@ -1452,7 +1454,9 @@ //phoneCount() éè¿ç»åºçæ¯ä¸ªå°æ¶éè¦æåºççµè¯éï¼ç®åºå°æä¸8ç¹ä¸ç¹è½æåºå¤å°ä¸ªçµè¯ï¼è·åå°æ»é //妿éè¦ç«å³æ§è¡çæ°æ®é大äºä¸å¤©è¦æ§è¡çä¸éï¼ååªåä¸éçæ°éï¼å ¶å®çåæ¾åredisä¸ count = Math.min(phoneCount(), (int) size); cacheList = listOps.range("cache-0", 0, count - 1); if (count != 0) { cacheList = listOps.range("cache-0", 0, count - 1); } } log.error("任塿åcache-0ç弿¯å¤å°ï¼{}", cacheList); @@ -1507,6 +1511,10 @@ PullTaskVO pullTaskVO = new PullTaskVO(); String subId = subIds.get(i).trim(); ServiceSubtask serviceSubtask = serviceSubtaskMapper.selectServiceSubtaskById(Long.valueOf(subId)); if (ObjectUtils.isEmpty(serviceSubtask)) { log.error("该subIdæé®é¢ï¼å¨è¡¨ä¸æ¥è¯¢ä¸å°ï¼{}", subId); continue; } ServiceTask serviceTask = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid()); IvrTaskTemplate ivrTaskTemplate = ivrTaskTemplateService.selectIvrTaskTemplateByID(serviceSubtask.getTemplateid()); if (ObjectUtils.isEmpty(ivrTaskTemplate)) continue; @@ -2079,13 +2087,17 @@ // å½åæ¶é´ LocalTime currentTime = LocalTime.now(); // ç®æ æ¶é´ï¼æä¸ 8 ç¹ï¼ LocalTime targetTime = LocalTime.of(20, 0); LocalTime targetTime = LocalTime.of(phoneEndHour, 0); // 计ç®å½åæ¶é´å°ç®æ æ¶é´çæ¶é¿ Duration duration = Duration.between(currentTime, targetTime); // è·åå©ä½æ¶é´çå°æ¶æ° long remainingHours = duration.toHours(); long remainingHours = 0; long remainingMinutes = duration.toMinutes(); //å¦æè¶ è¿8ç¹,就设置为0 if (remainingHours < 0) remainingHours = 0; //è·ç¦»ç»ææ¶é´å°äº20åéï¼å°±ä¸æåäº if (remainingMinutes < 20) remainingHours = 0; else if (remainingMinutes < 60 && remainingMinutes > 20) remainingHours = 1; else if (remainingMinutes > 60) remainingHours = remainingMinutes / 60; // 计ç®å©ä½å¯ä»¥æççµè¯æ° int remainingCalls = (int) (remainingHours * phoneUpEveryHour); return remainingCalls; smartor/src/main/java/com/smartor/service/impl/SvyTaskSingleServiceImpl.java
@@ -6,6 +6,9 @@ import com.fasterxml.jackson.core.JsonProcessingException; import com.fasterxml.jackson.databind.ObjectMapper; import com.google.gson.Gson; import com.ruoyi.common.enums.HospTypeEnum; import com.ruoyi.common.enums.ServiceTaskTypeEnum; import com.ruoyi.common.enums.TaskTypeEnum; import com.ruoyi.common.exception.base.BaseException; import com.ruoyi.common.utils.*; import com.ruoyi.common.utils.http.HttpEntity; @@ -16,6 +19,7 @@ import com.smartor.mapper.ServiceSubtaskMapper; import com.smartor.service.IServiceTaskService; import com.smartor.service.ISvyTaskSingleService; import com.sun.org.apache.bcel.internal.generic.NEW; import lombok.extern.slf4j.Slf4j; import okhttp3.OkHttpClient; import okhttp3.Request; @@ -201,69 +205,27 @@ else if (isoperation == 3) serviceSubtaskMapper.deleteServiceSubtaskByCondition(taskId, patid); } @Override public int insertTaskInfo(ServiceTaskInfo serviceTaskVO) { if (ObjectUtils.isEmpty(serviceTaskVO)) { log.info("æ°å¢ä»»å¡å ¥å为空ï¼è¯·æ£æ¥å ¥å"); throw new BaseException("æ°å¢ä»»å¡å ¥å为空ï¼è¯·æ£æ¥å ¥å"); } Integer integer = 1; //ServiceSubtask serviceTask = DtoConversionUtils.sourceToTarget(serviceTaskVO, ServiceSubtask.class); //serviceTask.setTextParam(JSON.toJSONString(serviceTaskVO.getTextParam())); //å°ä»»å¡ä¿¡æ¯æ¾å°æå¡è¡¨ä¸ ServiceSubtask serviceSubtask = DtoConversionUtils.sourceToTarget(serviceTaskVO, ServiceSubtask.class); serviceSubtask.setTaskid(serviceTaskVO.getTaskguid()); ServiceSubtask serviceSubtask = new ServiceSubtask(); serviceSubtask.setTaskGuid(serviceTaskVO.getTaskguid()); String type = "0"; if (serviceTaskVO.getServicetype().equals("çæµè¯ä¼°")) { type = "1"; } else if (serviceTaskVO.getServicetype().equals("åºé¢é访")) { type = "2"; } else if (serviceTaskVO.getServicetype().equals("é¨è¯é访")) { type = "3"; } else if (serviceTaskVO.getServicetype().equals("宣æå ³æ")) { type = "4"; } else if (serviceTaskVO.getServicetype().equals("å¤è¯éç¥")) { type = "5"; } else if (serviceTaskVO.getServicetype().equals("满æåº¦è°æ¥")) { type = "6"; } else if (serviceTaskVO.getServicetype().equals("æ£è æ¥å")) { type = "7"; } else if (serviceTaskVO.getServicetype().equals("å ¶ä»éç¥")) { type = "8"; } if (type.equals("0")) { type = serviceTaskVO.getServicetype(); } if (StringUtils.isNotEmpty(serviceTaskVO.getServicetype())) type = ServiceTaskTypeEnum.getDescByCode(serviceTaskVO.getServicetype()); serviceSubtask.setServiceType(type); //0ã1宣æã2é¨è¯ã3åºé¢ã4å¤è¯ã5使£ã6é®å·ã7廿 String tasktype = "-1"; if (serviceTaskVO.getTasktype().equals("éç¥")) { tasktype = "0"; } else if (serviceTaskVO.getTasktype().equals("宣æ")) { tasktype = "1"; } else if (serviceTaskVO.getTasktype().equals("é¨è¯")) { tasktype = "2"; } else if (serviceTaskVO.getTasktype().equals("åºé¢")) { tasktype = "3"; } else if (serviceTaskVO.getTasktype().equals("å¤è¯")) { tasktype = "4"; } else if (serviceTaskVO.getTasktype().equals("使£")) { tasktype = "5"; } else if (serviceTaskVO.getTasktype().equals("é®å·")) { tasktype = "6"; } else if (serviceTaskVO.getTasktype().equals("廿")) { tasktype = "7"; } if (tasktype.equals("-1")) { tasktype = serviceTaskVO.getTasktype(); } if (StringUtils.isNotEmpty(serviceTaskVO.getTasktype())) tasktype = TaskTypeEnum.getDescByCode(serviceTaskVO.getTasktype()); serviceSubtask.setType(tasktype); serviceSubtask.setLabelstatus(serviceTaskVO.getTaskstate()); serviceSubtask.setTaskName(serviceTaskVO.getTaskname()); serviceSubtask.setTaskDesc(serviceTaskVO.getTaskdesc()); serviceSubtask.setPreachform(serviceTaskVO.getExemode()); //serviceSubtask.setUploadTime(serviceTaskVO.setUploadTime()); serviceSubtask.setCreateBy(serviceTaskVO.getCreateBy()); serviceSubtask.setCreateTime(serviceTaskVO.getCreateTime()); serviceSubtask.setOperatorNo(serviceTaskVO.getOperatorno()); @@ -286,31 +248,25 @@ serviceSubtask.setWechat(serviceTaskVO.getPatopenid()); serviceSubtask.setInhospno(serviceTaskVO.getInhosno()); String hosptype = "-1"; if (serviceTaskVO.getVisittype().equals("é¨è¯")) { hosptype = "1"; } else if (serviceTaskVO.getVisittype().equals("åºé¢")) { hosptype = "2"; } else if (serviceTaskVO.getVisittype().equals("ä¸ç ")) { hosptype = "3"; } else if (serviceTaskVO.getVisittype().equals("å¤é¨å¯¼å ¥")) { hosptype = "4"; } if (hosptype.equals("-1")) { hosptype = serviceTaskVO.getVisittype(); } hosptype = HospTypeEnum.getDescByCode(serviceTaskVO.getVisittype()); serviceSubtask.setHospType(hosptype); serviceSubtask.setHospno(serviceTaskVO.getVisitno()); serviceSubtask.setAdmindate(serviceTaskVO.getVisittime()); serviceSubtask.setRoomno(serviceTaskVO.getRoomno()); serviceSubtask.setBedNo(serviceTaskVO.getBedno()); serviceSubtask.setDeptname(serviceTaskVO.getDeptname()); //serviceSubtask.setSendname(serviceTaskVO.gets()); //serviceSubtask.setPatid(serviceTaskVO.getPid()); serviceSubtask.setSendstate(1L); //serviceSubtask.setHospType(serviceTask.getHospType()); serviceSubtask.setCreateTime(new Date()); serviceSubtaskMapper.insertServiceSubtask(serviceSubtask); integer = serviceSubtask.getId().intValue(); //å æ¥è¯¢ä¸éï¼è¯¥taskGuidæ¯å¦åå¨ ServiceSubtaskVO serviceSubtaskVO = new ServiceSubtaskVO(); serviceSubtaskVO.setTaskGuid(serviceTaskVO.getGuid()); List<ServiceSubtask> serviceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(serviceSubtaskVO); if (CollectionUtils.isNotEmpty(serviceSubtaskList)) { serviceSubtaskMapper.updateServiceSubtaskByTaskGuid(serviceSubtask); } else { serviceSubtaskMapper.insertServiceSubtask(serviceSubtask); } Integer integer = serviceSubtask.getId().intValue(); log.error("æå ¥çIDæ¯ï¼{}", integer); return integer; } smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
@@ -38,6 +38,7 @@ <result property="orgid" column="orgid"/> <result property="pid" column="pid"/> <result property="guid" column="guid"/> <result property="taskGuid" column="task_guid"/> <result property="textParam" column="text_param"/> <result property="preachform" column="preachform"/> <result property="bedNo" column="bed_no"/> @@ -85,6 +86,7 @@ <sql id="selectServiceSubtaskVo"> select id, hosp_type, task_guid, patfrom, inhospid, suggest, @@ -248,6 +250,7 @@ <if test="remark != null">and remark = #{remark}</if> <if test="suggest != null">and suggest = #{suggest}</if> <if test="createBy != null">and create_by = #{createBy}</if> <if test="taskGuid != null">and task_guid = #{taskGuid}</if> </where> <if test="serviceType != null and serviceType != ''and serviceType != '2'and serviceType != '3'">order by long_send_time desc @@ -336,6 +339,7 @@ <if test="sendstate != null ">sendstate,</if> <if test="inhospid != null ">inhospid,</if> <if test="patfrom != null ">patfrom,</if> <if test="taskGuid != null ">task_guid,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="sendname != null">#{sendname},</if> @@ -408,6 +412,7 @@ <if test="sendstate != null ">#{sendstate},</if> <if test="inhospid != null ">#{inhospid},</if> <if test="patfrom != null ">#{patfrom},</if> <if test="taskGuid != null ">#{taskGuid},</if> </trim> </insert> @@ -484,6 +489,7 @@ <if test="suggest != null ">suggest=#{suggest},</if> <if test="inhospid != null ">inhospid=#{inhospid},</if> <if test="patfrom != null ">patfrom=#{patfrom},</if> <if test="taskGuid != null ">task_guid=#{taskGuid},</if> </trim> where id = #{id} </update> @@ -561,6 +567,7 @@ <if test="suggest != null ">suggest=#{suggest},</if> <if test="inhospid != null ">inhospid=#{inhospid},</if> <if test="patfrom != null ">patfrom=#{patfrom},</if> <if test="taskGuid != null ">taskGuid=#{taskGuid},</if> </trim> where patid = #{patid} and taskid = #{taskid} </update> @@ -638,9 +645,90 @@ <if test="suggest != null ">suggest=#{suggest},</if> <if test="inhospid != null ">inhospid=#{inhospid},</if> <if test="patfrom != null ">patfrom=#{patfrom},</if> <if test="taskGuid != null ">task_guid=#{taskGuid},</if> </trim> where patid = #{patid} and taskid = #{taskid} </update> <update id="updateServiceSubtaskByTaskGuid" parameterType="com.smartor.domain.ServiceSubtask"> update service_subtask <trim prefix="SET" suffixOverrides=","> <if test="sendname != null">sendname = #{sendname},</if> <if test="phone != null">phone = #{phone},</if> <if test="sex != null">sex = #{sex},</if> <if test="sendstate != null ">sendstate = #{sendstate},</if> <if test="age != null">age = #{age},</if> <if test="sfzh != null">sfzh = #{sfzh},</if> <if test="addr != null">addr = #{addr},</if> <if test="senderdetail != null">senderdetail = #{senderdetail},</if> <if test="type != null">type = #{type},</if> <if test="taskid != null">taskid = #{taskid},</if> <if test="templateid != null">templateid = #{templateid},</if> <if test="templatename != null">templatename = #{templatename},</if> <if test="senddate != null">senddate = #{senddate},</if> <if test="senduuid != null">senduuid = #{senduuid},</if> <if test="result != null">result = #{result},</if> <if test="finishtime != null">finishtime = #{finishtime},</if> <if test="recordid != null">recordid = #{recordid},</if> <if test="exrecallcount != null">exrecallcount = #{exrecallcount},</if> <if test="pulltime != null">pulltime = #{pulltime},</if> <if test="deptcode != null">deptcode = #{deptcode},</if> <if test="labelstatus != null">labelstatus = #{labelstatus},</if> <if test="updateBy != null">update_by = #{updateBy},</if> <if test="updateTime != null">update_time = #{updateTime},</if> <if test="createBy != null">create_by = #{createBy},</if> <if test="createTime != null">create_time = #{createTime},</if> <if test="isupload != null">isupload = #{isupload},</if> <if test="uploadTime != null">upload_time = #{uploadTime},</if> <if test="orgid != null">orgid = #{orgid},</if> <if test="pid != null">pid = #{pid},</if> <if test="guid != null">guid = #{guid},</if> <if test="textParam != null">text_param = #{textParam},</if> <if test="preachform != null">preachform = #{preachform},</if> <if test="bedNo != null">bed_no = #{bedNo},</if> <if test="sendType != null and sendType != ''">send_type = #{sendType},</if> <if test="taskName != null and taskName != ''">task_name = #{taskName},</if> <if test="taskDesc != null and taskDesc != ''">task_desc = #{taskDesc},</if> <if test="operatorNo != null and operatorNo != ''">operator_no = #{operatorNo},</if> <if test="operator != null and operator != ''">operator = #{operator},</if> <if test="hospType != null and hospType != ''">hosp_type = #{hospType},</if> <if test="hospno != null and hospno != ''">hospno = #{hospno},</if> <if test="wechat != null and wechat != ''">wechat = #{wechat},</if> <if test="roomno != null and roomno != ''">roomno = #{roomno},</if> <if test="admindate != null and admindate != ''">admindate = #{admindate},</if> <if test="deptname != null and deptname != ''">deptname = #{deptname},</if> <if test="diagname != null and diagname != ''">diagname = #{diagname},</if> <if test="libtemplateid != null ">libtemplateid = #{libtemplateid},</if> <if test="libtemplatename != null ">libtemplatename = #{libtemplatename},</if> <if test="patid != null ">patid = #{patid},</if> <if test="openid != null ">openid = #{openid},</if> <if test="longSendTime != null ">long_send_time = #{longSendTime},</if> <if test="serviceType != null ">service_type = #{serviceType},</if> <if test="score != null ">score = #{score},</if> <if test="submit != null ">submit = #{submit},</if> <if test="leavehospitaldistrictcode != null and leavehospitaldistrictcode != ''">leavehospitaldistrictcode = #{leavehospitaldistrictcode}, </if> <if test="leavehospitaldistrictname != null and leavehospitaldistrictname != ''">leavehospitaldistrictname = #{leavehospitaldistrictname}, </if> <if test="drname != null ">drname = #{drname},</if> <if test="drcode != null ">drcode = #{drcode},</if> <if test="endtime != null ">endtime = #{endtime},</if> <if test="starttime != null ">starttime = #{starttime},</if> <if test="excep != null ">excep = #{excep},</if> <if test="nurseName != null ">nurse_name=#{nurseName},</if> <if test="nurseId != null ">nurse_id=#{nurseId},</if> <if test="remark != null ">remark=#{remark},</if> <if test="suggest != null ">suggest=#{suggest},</if> <if test="inhospid != null ">inhospid=#{inhospid},</if> <if test="patfrom != null ">patfrom=#{patfrom},</if> <if test="taskGuid != null ">task_guid=#{taskGuid},</if> </trim> where task_guid = #{taskGuid} </update> <update id="deleteServiceSubtaskById" parameterType="Long"> update service_subtask @@ -749,6 +837,7 @@ remark, inhospid, patfrom, task_guid, diagname FROM service_subtask, JSON_TABLE(send_time_slot, '$[*]' COLUMNS (