代码提交

liusheng

2024-01-30 7ae67ba965ea680407ae21fedbd035d43ce8c313

代码提交

 ruoyi-admin/pom.xml

@@ -48,6 +48,13 @@
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!-- SQL_SERVER驱动包 -->
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <version>9.2.1.jre8</version>
        </dependency>

        <!-- æ ¸å¿ƒæ¨¡å—-->
        <dependency>
            <groupId>com.ruoyi</groupId>
@@ -95,6 +102,7 @@
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web-services</artifactId>
        </dependency>

        <dependency>
            <groupId>org.apache.cxf</groupId>
            <artifactId>cxf-rt-frontend-jaxws</artifactId>
@@ -109,19 +117,6 @@
            <groupId>org.codehaus.woodstox</groupId>
            <artifactId>stax2-api</artifactId>
            <version>3.1.1</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/ca.uhn.hapi/hapi-base -->
        <dependency>
            <groupId>ca.uhn.hapi</groupId>
            <artifactId>hapi-base</artifactId>
            <version>2.3</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/ca.uhn.hapi/hapi-structures-v24 -->
        <dependency>
            <groupId>ca.uhn.hapi</groupId>
            <artifactId>hapi-structures-v24</artifactId>
            <version>2.3</version>
        </dependency>

        <dependency>

 ruoyi-admin/src/main/java/com/ruoyi/RuoYiApplication.java

@@ -30,6 +30,6 @@
                " |  |  \\    /  \\      /           \n" +
                " ''-'   `'-'    `-..-'              ");
        //开启SOCKET
//        new SocketCommunication().socketCommunication();
        new SocketCommunication().socketCommunication();
    }
}

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeTaskController.java

@@ -5,7 +5,7 @@
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.utils.PageUtils;
import com.smartor.domain.HeTask;
import com.smartor.domain.HeTaskVO;
import com.smartor.domain.PatArchiveReq;
@@ -17,7 +17,6 @@
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
@@ -68,14 +67,14 @@
    }

    /**
     * æ–°å¢žå®£æ•™ä»»åŠ¡
     * æ–°å¢žæˆ–修改删除宣教任务
     */
    @ApiOperation("新增宣教任务(发送任务)")
    @ApiOperation("新增或修改删除宣教任务")
    @PreAuthorize("@ss.hasPermi('system:task:add')")
    @Log(title = "宣教任务", businessType = BusinessType.INSERT)
    @PostMapping("/add")
    public AjaxResult add(@RequestBody HeTaskVO heTaskVO) {
        return toAjax(heTaskService.insertHeTask(heTaskVO));
    @PostMapping("/insertOrUpdateHeTask")
    public AjaxResult insertOrUpdateHeTask(@RequestBody HeTaskVO heTaskVO) {
        return toAjax(heTaskService.insertOrUpdateHeTask(heTaskVO));
    }

    /**
@@ -106,6 +105,7 @@
    @ApiOperation("获取患者信息")
    @PostMapping("/getPatientInfo")
    public TableDataInfo getPatientInfo(@RequestBody PatArchiveReq patArchiveReq) {
        PageUtils.startPageByPost(patArchiveReq.getPageNum(), patArchiveReq.getPageSize());
        return getDataTable(heTaskService.getPatientInfo(patArchiveReq));
    }


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/TestLsController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,49 @@
package com.ruoyi.web.controller.smartor;

import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.ServiceThirdData;
import com.smartor.domain.SvyLibTopicRes;
import com.smartor.domain.SvyTopic;
import com.smartor.domain.SvyTopicReq;
import com.smartor.service.IServiceThirdDataService;
import com.smartor.service.ISvyTopicService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * é¢˜ç›®Controller
 *
 * @author ruoyi
 * @date 2023-06-26
 */
@Api(description = "testController")
@RestController
@RequestMapping("/tc")
public class TestLsController extends BaseController {
    @Autowired
    private IServiceThirdDataService iServiceThirdDataService;

    /**
     * æŸ¥è¯¢é¢˜ç›®åˆ—表
     */
    @PostMapping("/list")
    public TableDataInfo list(@RequestBody ServiceThirdData serviceThirdData) {
        List<ServiceThirdData> list = iServiceThirdDataService.queryList(serviceThirdData);
        return getDataTable(list);
    }

}

 ruoyi-admin/src/main/java/com/ruoyi/web/test/pctest.java

@@ -15,72 +15,96 @@
import java.nio.file.Paths;
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class pctest {

    public static void main(String[] args) {
        String str = null;
//        for (int i = 51; i <= 189; i++) {
//        System.out.print(i + " ");
        try {
        // å¾…匹配的字符串
        String sentence = "135465465好46546";

//                long l = System.currentTimeMillis();
////                str = "2263œ189œœ232105105§胸部肿瘤科日间病房患者<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§11¤232334680§胸部肿瘤科患者出院<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§19¤232313714§胸部肿瘤科食管癌患者出院<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§20¤232294126§胸部肿瘤科肺癌患者出院<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§22¤232231895§TKA术后<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§16¤232349695§<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>1月§29¤232303115§高糖<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>工作培训试题§16¤232295017§肿瘤<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>登记培训测试题§15¤232233427§老年健康监测队列<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>培训测试§10¤232215217§24病区IBD患者<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>问卷（8.22-8.28）§20¤232169849§2023.8.25小金人俱乐部MDT门诊<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§9¤232173705§<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>信息反馈表§6¤";
////                str = HttpUtils.sendGet("https://www.wjx.cn/handler/Search.ashx?input=%E9%9A%8F%E8%AE%BF&qc=&cp=" + i + "&nw=1&qt=1&accurate=0&t=" + l);
//                while (true) {
//                    if (str.contains("<font")) {
//                        str = str.substring(0, str.indexOf("<font")) + str.substring(str.indexOf("</font>") + 7);
//                    } else {
////                        System.out.println(str);
        // å®šä¹‰æ­£åˆ™è¡¨è¾¾å¼
//        String regex = ".*吃了.*早上好.*";
//        String regex = ".*吃了.*|.*早上好.*";
//        String regex = "^(?!.*很好，吃了吗).*|.*没吃.*早上好.*医院.*";
        String regex = "^(?!.别|不可|不可靠)(.(好|幸福)+.*)$";

            List<String> list = new ArrayList<>();
            String folderPath = "E:/pc";
            try {
                Files.walk(Paths.get(folderPath)).filter(Files::isRegularFile).forEach(path -> list.add(path.getFileName().toString()));
            } catch (IOException e) {
                System.out.println("An error occurred while traversing the folder.");
                e.printStackTrace();
        // ç¼–译正则表达式
        Pattern pattern = Pattern.compile(regex);

        // åˆ›å»º Matcher å¯¹è±¡
        Matcher matcher = pattern.matcher(sentence);

        // è¿›è¡ŒåŒ¹é…
        if (matcher.matches()) {
            System.out.println("句子中包含\"吃了，早上好\"。");
        } else {
            System.out.println("句子中不包含\"吃了，早上好\"。");
            }

            for (String name : list) {
                name = name.substring(0, name.indexOf(".html"));
//                String sd = "https://www.wjx.cn/xz/" + name + ".aspx";
//                String content = HttpUtils.sendGet(sd, "review=1&u_atoken=31d3a0e6-e00e-483c-b956-b6177972e734&u_asession=01691hXKO9p1D59fHgd0NAIGdr-8HrPakCUS6X_v_Z43ohuMPPQJnwrrPl3mly-UFXYrO71Pz35K7wOrV6v8t3g9sq8AL43dpOnCClYrgFm6o&u_asig=052KZ_HPijdQddSitCTcvhNlwy7cGO2t46JgQGTyclFPT7xwZjoK0YBNED-DbuN5gugFYO36lFqDfxMpnRFufeLFk7BSuILL02zWW0QNCM-NWgLElQ9wTw7yMg4BFlXpIhOVzkXl1W45ZWoBPny57uZ3WVmTrcdvNBGM1L1rWev0UwpA9oQuqX4mfRyWspmK8gksmHjM0JOodanL5-M1Qs1Srh04GpT7zItRH0TxDThMR15LDAE7pTBPfvFUyoAgUl5gGKGQH-vEmN2Ae1t4GLLQkS6fjps_twKYxR-u2135jY94r_LXIIil3Y3aVPRGAe&u_aref=gk2k7DQa4vfdgaFwA4iVd7KUI4Q%3D", Constants.UTF8);
//                String sd = "https://www.wjx.cn/xz/214877887.aspx?review=1&u_atoken=7ea94b7e-ff2c-4f9f-a16a-2377e7b932f7&u_asession=01mUmaPv86XmI35R93EFzW4vAn-_bjd_hg8O3aV3Qj_hY4LTkzoq3vcQyaBAt_bXG0L3UvT1OC8yhlQ_Vrlj1nD9sq8AL43dpOnCClYrgFm6o&u_asig=05qqfmDpV5jnzQ3zaOR-kKvhCvox19kVoC-lC8wI68PnJ7lkckawOfhM2Sz6TSlLyxhPCLiM-UkS5JtWfnNrZeTMme2Xl4_nh34yljc8iiZeJybY6mcSFGRriqnFvQfUeuCvV5odDJuWRnGyKMRbx_RypafWqYj328He90miD2j6an7QQBtuwLgtjfNI6ktmk7ksmHjM0JOodanL5-M1Qs1cOGKb4pT6nOz7TsF50O_Y5mwcLzFTlOSTrqpuPzNwho1AC5ZokKrUg3JS1GlbH-sRHfAvD91UjmwUK--AQbESDY94r_LXIIil3Y3aVPRGAe&u_aref=muWANYNZeB7WW%2B%2F7kLKv3uRT8ws%3D";
//                String content = HttpUtils.sendGet(sd);
                HttpRequest get = HttpUtil.createGet("https://www.wjx.cn/xz/215122141.aspx?review=1&u_atoken=ae7fe80c-bf23-4e45-bcda-e1a79738fa28&u_asession=014vQCkRvW7c3i2ofZKQ4cwL_Kbllht28bP58Yv5WaOmib7bTm0yOu3E9ghHeDwRromXsXiqHPUHP-r4N4zkLsNdsq8AL43dpOnCClYrgFm6o&u_asig=05cv8a98zgMB5Y5sCj2tshR0ymwhcsf5o0ZnRdzw_MWEqjWv9qUXA2y-W56hqxwwu62XCEZ1EDfpROWbv7u5K0esMlHJrRxH3x6MobynAbRVK73TZbz-pPzJrSvkDKmiOfptL_k4wm25Oa44SC2LnI-f_gUMOBxNBqpVgCnR54boOBWxWY3t65iSXiQbR5_szmksmHjM0JOodanL5-M1Qs1XAPImYHnI2tMZUJbFSrHeeZf56fnMo9lJFDBHsYIUFUSQYCfCQCLXjf34sWIadxtsAb6Kn2CIzT3kClvRmyaM_Y94r_LXIIil3Y3aVPRGAe&u_aref=OUtfes0VUTyTV7SKqEByRa9VGaU%3D");
                String content = get.execute().body();
                //创建文件夹
                Path folder = Paths.get("E:/pc2/" + name + ".html");
                Files.createFile(folder);
                Files.write(Paths.get("E:/pc2/" + name + ".html"), content.getBytes());
            }


//            int index = 0;
//            while (true) {
//                int dd = str.indexOf("¤", index) + 1;
//                String newStr = str.substring(dd, str.indexOf("§", dd));
//                index = dd;
//                String sd = "https://www.wjx.cn/xz/" + newStr + ".aspx";
//                String content = HttpUtils.sendGet(sd, "review=1");
//        String str = null;
////        for (int i = 51; i <= 189; i++) {
////        System.out.print(i + " ");
//        try {
//
////                long l = System.currentTimeMillis();
//////                str = "2263œ189œœ232105105§胸部肿瘤科日间病房患者<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§11¤232334680§胸部肿瘤科患者出院<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§19¤232313714§胸部肿瘤科食管癌患者出院<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§20¤232294126§胸部肿瘤科肺癌患者出院<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§22¤232231895§TKA术后<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§16¤232349695§<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>1月§29¤232303115§高糖<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>工作培训试题§16¤232295017§肿瘤<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>登记培训测试题§15¤232233427§老年健康监测队列<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>培训测试§10¤232215217§24病区IBD患者<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>问卷（8.22-8.28）§20¤232169849§2023.8.25小金人俱乐部MDT门诊<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>§9¤232173705§<font color='#30a6f5'>随</font><font color='#30a6f5'>访</font>信息反馈表§6¤";
//////                str = HttpUtils.sendGet("https://www.wjx.cn/handler/Search.ashx?input=%E9%9A%8F%E8%AE%BF&qc=&cp=" + i + "&nw=1&qt=1&accurate=0&t=" + l);
////                while (true) {
////                    if (str.contains("<font")) {
////                        str = str.substring(0, str.indexOf("<font")) + str.substring(str.indexOf("</font>") + 7);
////                    } else {
//////                        System.out.println(str);
//
//            List<String> list = new ArrayList<>();
//            String folderPath = "E:/pc";
//            try {
//                Files.walk(Paths.get(folderPath)).filter(Files::isRegularFile).forEach(path -> list.add(path.getFileName().toString()));
//            } catch (IOException e) {
//                System.out.println("An error occurred while traversing the folder.");
//                e.printStackTrace();
//            }
//
//            for (String name : list) {
//                name = name.substring(0, name.indexOf(".html"));
////                String sd = "https://www.wjx.cn/xz/" + name + ".aspx";
////                String content = HttpUtils.sendGet(sd, "review=1&u_atoken=31d3a0e6-e00e-483c-b956-b6177972e734&u_asession=01691hXKO9p1D59fHgd0NAIGdr-8HrPakCUS6X_v_Z43ohuMPPQJnwrrPl3mly-UFXYrO71Pz35K7wOrV6v8t3g9sq8AL43dpOnCClYrgFm6o&u_asig=052KZ_HPijdQddSitCTcvhNlwy7cGO2t46JgQGTyclFPT7xwZjoK0YBNED-DbuN5gugFYO36lFqDfxMpnRFufeLFk7BSuILL02zWW0QNCM-NWgLElQ9wTw7yMg4BFlXpIhOVzkXl1W45ZWoBPny57uZ3WVmTrcdvNBGM1L1rWev0UwpA9oQuqX4mfRyWspmK8gksmHjM0JOodanL5-M1Qs1Srh04GpT7zItRH0TxDThMR15LDAE7pTBPfvFUyoAgUl5gGKGQH-vEmN2Ae1t4GLLQkS6fjps_twKYxR-u2135jY94r_LXIIil3Y3aVPRGAe&u_aref=gk2k7DQa4vfdgaFwA4iVd7KUI4Q%3D", Constants.UTF8);
////                String sd = "https://www.wjx.cn/xz/214877887.aspx?review=1&u_atoken=7ea94b7e-ff2c-4f9f-a16a-2377e7b932f7&u_asession=01mUmaPv86XmI35R93EFzW4vAn-_bjd_hg8O3aV3Qj_hY4LTkzoq3vcQyaBAt_bXG0L3UvT1OC8yhlQ_Vrlj1nD9sq8AL43dpOnCClYrgFm6o&u_asig=05qqfmDpV5jnzQ3zaOR-kKvhCvox19kVoC-lC8wI68PnJ7lkckawOfhM2Sz6TSlLyxhPCLiM-UkS5JtWfnNrZeTMme2Xl4_nh34yljc8iiZeJybY6mcSFGRriqnFvQfUeuCvV5odDJuWRnGyKMRbx_RypafWqYj328He90miD2j6an7QQBtuwLgtjfNI6ktmk7ksmHjM0JOodanL5-M1Qs1cOGKb4pT6nOz7TsF50O_Y5mwcLzFTlOSTrqpuPzNwho1AC5ZokKrUg3JS1GlbH-sRHfAvD91UjmwUK--AQbESDY94r_LXIIil3Y3aVPRGAe&u_aref=muWANYNZeB7WW%2B%2F7kLKv3uRT8ws%3D";
////                String content = HttpUtils.sendGet(sd);
//                HttpRequest get = HttpUtil.createGet("https://www.wjx.cn/xz/215122141.aspx?review=1&u_atoken=ae7fe80c-bf23-4e45-bcda-e1a79738fa28&u_asession=014vQCkRvW7c3i2ofZKQ4cwL_Kbllht28bP58Yv5WaOmib7bTm0yOu3E9ghHeDwRromXsXiqHPUHP-r4N4zkLsNdsq8AL43dpOnCClYrgFm6o&u_asig=05cv8a98zgMB5Y5sCj2tshR0ymwhcsf5o0ZnRdzw_MWEqjWv9qUXA2y-W56hqxwwu62XCEZ1EDfpROWbv7u5K0esMlHJrRxH3x6MobynAbRVK73TZbz-pPzJrSvkDKmiOfptL_k4wm25Oa44SC2LnI-f_gUMOBxNBqpVgCnR54boOBWxWY3t65iSXiQbR5_szmksmHjM0JOodanL5-M1Qs1XAPImYHnI2tMZUJbFSrHeeZf56fnMo9lJFDBHsYIUFUSQYCfCQCLXjf34sWIadxtsAb6Kn2CIzT3kClvRmyaM_Y94r_LXIIil3Y3aVPRGAe&u_aref=OUtfes0VUTyTV7SKqEByRa9VGaU%3D");
//                String content = get.execute().body();
//                //创建文件夹
//                Path folder = Paths.get("E:/pc/" + newStr + ".html");
//                Path folder = Paths.get("E:/pc2/" + name + ".html");
//                Files.createFile(folder);
//                Files.write(Paths.get("E:/pc/" + newStr + ".html"), content.getBytes());
//                Files.write(Paths.get("E:/pc2/" + name + ".html"), content.getBytes());
//            }
//
//                if (index == -1) {
//                    break;
//
////            int index = 0;
////            while (true) {
////                int dd = str.indexOf("¤", index) + 1;
////                String newStr = str.substring(dd, str.indexOf("§", dd));
////                index = dd;
////                String sd = "https://www.wjx.cn/xz/" + newStr + ".aspx";
////                String content = HttpUtils.sendGet(sd, "review=1");
////
////                //创建文件夹
////                Path folder = Paths.get("E:/pc/" + newStr + ".html");
////                Files.createFile(folder);
////                Files.write(Paths.get("E:/pc/" + newStr + ".html"), content.getBytes());
////
////                if (index == -1) {
////                    break;
////                }
////            }
////            break;
////                    }
//
////                }
//
//        } catch (Exception e) {
//                }
//            }
//            break;
    }
}
//                    }

//                }

        } catch (Exception e) {
        }
    }
}
//}

 ruoyi-admin/src/main/resources/application-druid.yml

@@ -2,7 +2,7 @@
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    #    driverClassName: com.mysql.cj.jdbc.Driver
    druid:
      # ä¸»åº“数据源
      master:
@@ -12,13 +12,15 @@
        url: jdbc:mysql://116.62.18.175:6002/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: hxsoft
        password: Hxerp2000
        driverClassName: com.mysql.cj.jdbc.Driver
      # ä»Žåº“数据源
      slave:
        # ä»Žæ•°æ®æºå¼€å…³/默认关闭
        enabled: false
        url:
        username:
        password:
        enabled: true
        url: jdbc:sqlserver://116.62.18.175:6001;DatabaseName=iv-ywey;encrypt=false;SelectMethod=cursor
        username: sa
        password: Hxerp2000
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
      # åˆå§‹è¿žæŽ¥æ•°
      initialSize: 5
      # æœ€å°è¿žæŽ¥æ± æ•°é‡
@@ -34,20 +36,21 @@
      # é…ç½®ä¸€ä¸ªè¿žæŽ¥åœ¨æ± ä¸­æœ€å¤§ç”Ÿå­˜çš„时间，单位是毫秒
      maxEvictableIdleTimeMillis: 900000
      # é…ç½®æ£€æµ‹è¿žæŽ¥æ˜¯å¦æœ‰æ•ˆ
      validationQuery: SELECT 1 FROM DUAL
      #      validationQuery: SELECT 1 FROM DUAL
      validationQuery: SELECT 1
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      webStatFilter:
        enabled: true
      statViewServlet:
        enabled: true
        enabled: false
        # è®¾ç½®ç™½åå•ï¼Œä¸å¡«åˆ™å…è®¸æ‰€æœ‰è®¿é—®
        allow:
        url-pattern: /druid/*
        # æŽ§åˆ¶å°ç®¡ç†ç”¨æˆ·åå’Œå¯†ç 
        login-username: ruoyi
        login-password: 123456
        login-username: lihu
        login-password: Lihu@1363419#$
      filter:
        stat:
          enabled: true

 ruoyi-admin/src/main/resources/application.yml

@@ -1,7 +1,7 @@
# é¡¹ç›®ç›¸å…³é…ç½®
ruoyi:
  # åç§°
  name: RuoYi
  name: lihu
  # ç‰ˆæœ¬
  version: 3.8.5
  # ç‰ˆæƒå¹´ä»½

 ruoyi-admin/src/main/resources/logback.xml

@@ -81,7 +81,7 @@
    </root>
    
    <!--系统操作日志-->
    <root level="info">
    <root level="debug">
        <appender-ref ref="file_info" />
        <appender-ref ref="file_error" />
    </root>

 ruoyi-common/src/main/java/com/ruoyi/common/enums/AdmTypeEnum.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,43 @@
package com.ruoyi.common.enums;

public enum AdmTypeEnum {

    JZ("E", "急诊"), ZY("I", "住院"), MZ("O", "门诊"), TJ("T", "体检");


    private String code;
    private String desc;

    AdmTypeEnum(String code, String desc) {
        this.code = code;
        this.desc = desc;
    }

    public static String getDescByCode(String code) {
        AdmTypeEnum[] organEnums = values();
        for (int i = 0; i < organEnums.length; i++) {
            AdmTypeEnum organEnum = organEnums[i];
            if (organEnum.getCode().equals(code)) {
                return organEnum.getDesc();
            }
        }
        return null;
    }


    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/FollowUpEnum.java

@@ -3,6 +3,7 @@
public enum FollowUpEnum {

    HZGH("ADT^A04", "患者挂号"),
    YZZXJH("RGV^O15", "医嘱执行计划"),
    WCJZ("REF^I12", "完成接诊"),
    CFSQ("OMP^O09[NW~PH~IP]", "处方申请"),
    CFSFQR("OMP^O09[OK^SC]", "处方收费确认"),
@@ -20,6 +21,8 @@
    HZJBXXXG("ADT^A31", "患者基本信息修改"),

    HZRY("ADT^A01", "患者入院"),
    HZCY("ADT^A03", "患者出院"),
    HZJD("ADT^A28", "患者建档"),
    HZQXRY("ADT^A11", "患者取消入院"),
    HZRK("ADT^A10", "患者入科"),
    HZQXRK("ADT^A32", "患者取消入科"),

 ruoyi-common/src/main/java/com/ruoyi/common/enums/LevelHospEnum.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,45 @@
package com.ruoyi.common.enums;

public enum LevelHospEnum {

    QY("01", "痊愈"), HZ("02", "好转"), WY("03", "未愈"), SW("04", "死亡"), WZ("05", "未治"), LY("06", "离院"), LYY("07", "留院"),

    QT("09", "其化");


    private String code;
    private String desc;

    LevelHospEnum(String code, String desc) {
        this.code = code;
        this.desc = desc;
    }

    public static String getDescByCode(String code) {
        LevelHospEnum[] organEnums = values();
        for (int i = 0; i < organEnums.length; i++) {
            LevelHospEnum organEnum = organEnums[i];
            if (organEnum.getCode().equals(code)) {
                return organEnum.getDesc();
            }
        }
        return null;
    }


    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-quartz/pom.xml

@@ -34,6 +34,11 @@
            <groupId>com.ruoyi</groupId>
            <artifactId>ruoyi-common</artifactId>
        </dependency>
        <dependency>
            <groupId>com.ruoyi</groupId>
            <artifactId>smartor</artifactId>
            <version>3.8.5</version>
        </dependency>

    </dependencies>


 ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java

@@ -1,7 +1,12 @@
package com.ruoyi.quartz.task;

import com.smartor.domain.ServiceThirdData;
import com.smartor.service.IServiceThirdDataService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.ruoyi.common.utils.StringUtils;

import java.util.Date;

/**
 * å®šæ—¶ä»»åŠ¡è°ƒåº¦æµ‹è¯•
@@ -9,20 +14,30 @@
 * @author ruoyi
 */
@Component("ryTask")
public class RyTask
{
    public void ryMultipleParams(String s, Boolean b, Long l, Double d, Integer i)
    {
public class RyTask {
    @Autowired
    private IServiceThirdDataService iServiceThirdDataService;

    public void ryMultipleParams(String s, Boolean b, Long l, Double d, Integer i) {
        System.out.println(StringUtils.format("执行多参方法： å­—符串类型{}，布尔类型{}，长整型{}，浮点型{}，整形{}", s, b, l, d, i));
    }

    public void ryParams(String params)
    {
    public void ryParams(String params) {
        System.out.println("执行有参方法：" + params);
    }

    public void ryNoParams()
    {
    public void ryNoParams() {
        System.out.println("执行无参方法");
    }

    public void analysisData() {
        System.out.println("---------------------------");
        //数据解析
        ServiceThirdData serviceThirdData = new ServiceThirdData();
        serviceThirdData.setDataType("ADT^A03");
        serviceThirdData.setIsDeal(0);
        serviceThirdData.setCreateTime(new Date());
        iServiceThirdDataService.queryList(serviceThirdData);

    }
}

 ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/ScheduleUtils.java

@@ -85,7 +85,7 @@
        {
            // æ‰§è¡Œè°ƒåº¦ä»»åŠ¡
            scheduler.scheduleJob(jobDetail, trigger);
            scheduler.deleteJob(jobDetail.getKey());
//            scheduler.deleteJob(jobDetail.getKey());
        }

        // æš‚停任务

 smartor/pom.xml

@@ -95,6 +95,25 @@
            <artifactId>nls-sdk-tts</artifactId>
            <version>2.2.1</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/ca.uhn.hapi/hapi-base -->
        <dependency>
            <groupId>ca.uhn.hapi</groupId>
            <artifactId>hapi-base</artifactId>
            <version>2.3</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/ca.uhn.hapi/hapi-structures-v24 -->
        <dependency>
            <groupId>ca.uhn.hapi</groupId>
            <artifactId>hapi-structures-v24</artifactId>
            <version>2.3</version>
        </dependency>

        <dependency>
            <groupId>com.googlecode.json-simple</groupId>
            <artifactId>json-simple</artifactId>
            <version>1.1.1</version>
        </dependency>
    </dependencies>



 smartor/src/main/java/com/smartor/domain/HeLibrary.java

@@ -53,7 +53,7 @@
     */
    @Excel(name = " ç‰ˆæœ¬ ")
    @ApiModelProperty("版本")
    private BigDecimal version;
    private String version;

    /**
     * å®£æ•™å½¢å¼ :文本、图片、语音、视频、混合
@@ -186,7 +186,7 @@
     */
    @Excel(name = "适用方式：调查表1，智能语音2、人工3")
    @ApiModelProperty("适用方式：调查表1，智能语音2、人工3")
    private String suitway;
    private String suitway = "";

    /**
     * ç§‘室名称

 smartor/src/main/java/com/smartor/domain/HeLibraryVO.java

@@ -55,7 +55,7 @@
     */
    @Excel(name = " ç‰ˆæœ¬ ")
    @ApiModelProperty("版本")
    private BigDecimal version;
    private String version;

    /**
     * å®£æ•™å½¢å¼ :文本、图片、语音、视频、混合
@@ -209,7 +209,7 @@
     */
    @Excel(name = "适用方式：调查表1，智能语音2、人工3")
    @ApiModelProperty("适用方式：调查表1，智能语音2、人工3")
    private String suitway;
    private String suitway = "";

    @ApiModelProperty("指标标签对象集合")
    private List<HeLibraryTag> heLibraryTagList = new ArrayList<>();

 smartor/src/main/java/com/smartor/domain/HeTaskVO.java

@@ -214,4 +214,11 @@
     */
    private HeLibraryVO heLibraryVOs;

    /**
     * æ˜¯å¦å­˜åœ¨æ“ä½œï¼š1 æ–°å¢ž 2修改 3删除
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;


}

 smartor/src/main/java/com/smartor/domain/HospitalRecord.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,366 @@
package com.smartor.domain;

import io.swagger.annotations.ApiModel;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

import java.util.Date;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘对象 hospital_record
 *
 * @author ruoyi
 * @date 2024-01-26
 */
@Data
@ApiModel(value = "HospitalRecord", description = "医院患者记录")
public class HospitalRecord extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long ID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String sourceSystem;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String messageID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String methodName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String reqIimRules;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String patientID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Date opreationTime;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String episodeID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String outMedNO;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String inMedNO;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String visitNum;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String admTypeCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String admTypeDesc;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String admStatus;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String admDate;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encPatName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encPatGender;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encPatBirthDate;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String transferstart;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String transferend;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encPatMaritalStatus;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String originalText;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encDocList;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encAdmLocList;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encounterPeriodStart;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encounterPeriodEnd;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encounterBooktime;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encAdmSource;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encInhostype;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encDietName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encOuthostype;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encVisitnum;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encChargeType;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encChargeTypeName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encChargeCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encChargeName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encReglevelcode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encCareLevel;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String specialday;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String primaryday;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String secondaryday;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String tertiaryday;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String enroomno;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String enBedno;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encSeeno;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encAgeUnit;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encAgeValue;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String enIsbaby;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encHavebaby;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encDiagList;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String directorCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String directorName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encDiagnosisCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encDiagnosisDesc;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encAdmLocCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String encAdmLocName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private Long taskStatus;


}

 smartor/src/main/java/com/smartor/domain/HospitalUserinfo.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,518 @@
package com.smartor.domain;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

import java.util.Date;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘对象 hospital_userinfo
 *
 * @author ruoyi
 * @date 2024-01-29
 */
@Data
public class HospitalUserinfo{
    private static final long serialVersionUID = 1L;

    /**
     * $column.columnComment
     */
    private Long ID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String SourceSystem;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String MessageID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String MethodName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ReqIimRules;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String PatientID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String VisitNum;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String RegDate;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String IdentityID;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String PatName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Phone;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String PatSex;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthDate;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Address;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String AddProvince;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String AddCity;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String AddCounty;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String AddTown;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String AddVillage;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String AddHouseNo;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddress;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddProvince;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddCity;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddCounty;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddTown;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddVillage;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseAddHouseNo;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddress;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddProvince;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddCity;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddCounty;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddTown;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddVillage;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String BirthAddHouseNo;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddress;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddProvince;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddCity;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddCounty;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddTown;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddVillage;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ContactsAddHouseNo;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddress;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddProvince;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddCity;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddCounty;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddTown;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddVillage;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NativeAddHouseNo;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String PostalCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HouseCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String WorkCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String MaritalStatus;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Country;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Nation;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String NationCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String OccupType;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String OccupTypeCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String WorkUnit;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String WorkPhone;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HCardNo;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HCIssuersCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String HUrbanCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String MedOrgCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String paycode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String payname;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ConRelShip;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ConPerPhone;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String ConPerName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String RegOrgCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String RegOrgDesc;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String InsureOrgName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String InsureOrgCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String RegEmpCode;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String RegEmpName;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String INEnroomno;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String OUTEnroomno;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String EncAdmSource;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Directordoc;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Attenddoc;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Beddoc;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Bednur;

    /**
     * $column.columnComment
     */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String Regdoc;

    /**
     * åˆ›å»ºæ—¶é—´
     */
    private String CreateTime;

}

 smartor/src/main/java/com/smartor/domain/IvrLibaTemplateTag.java

@@ -99,6 +99,13 @@
    private String guid;

    /**
     * GUID
     */
    @Excel(name = "GUID")
    @ApiModelProperty(value = "GUID")
    private String tagname;

    /**
     * æ˜¯å¦å­˜åœ¨æ“ä½œï¼š1 æ–°å¢ž 2修改 3删除
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")

 smartor/src/main/java/com/smartor/domain/PatArchive.java

@@ -211,6 +211,13 @@
    @Excel(name = " ç§‘室 ")
    private String dept;

    /**
     * é’‰é’‰å·
     */
    @ApiModelProperty("科室")
    @Excel(name = " ç§‘室 ")
    private String bedNo;

    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE).append("patid", getPatid()).append("name", getName()).append("sex", getSex()).append("idcardno", getIdcardno()).append("birthdate", getBirthdate()).append("age", getAge()).append("source", getSource()).append("archivetime", getArchivetime()).append("archiveby", getArchiveby()).append("telcode", getTelcode()).append("relativetelcode", getRelativetelcode()).append("idcardtype", getIdcardtype()).append("orgid", getOrgid()).append("openid", getOpenid()).append("delFlag", getDelFlag()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("isupload", getIsupload()).append("uploadTime", getUploadTime()).toString();

 smartor/src/main/java/com/smartor/domain/PatArchivetag.java

@@ -84,8 +84,5 @@
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;

    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE).append("tagname", getTagname()).append("id", getId()).append("tagcategoryid", getTagcategoryid()).append("tagid", getTagid()).append("orgid", getOrgid()).append("delFlag", getDelFlag()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("isupload", getIsupload()).append("uploadTime", getUploadTime()).append("patid", getPatid()).toString();
    }

}

 smartor/src/main/java/com/smartor/domain/PatHetaskRelevance.java

@@ -8,6 +8,8 @@
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

import java.util.Date;

/**
 * æ‚£è€…与宣教任务关联对象 pat_hetask_relevance
 *
@@ -31,7 +33,7 @@
     */
    @Excel(name = "患者ID")
    @ApiModelProperty("患者ID")
    private Long patId;
    private Long patid;

    /**
     * å®£æ•™ä»»åŠ¡ID
@@ -41,10 +43,10 @@
    private Long heTaskId;

    /**
     * åˆ é™¤ï¼š0不删除  1删除
     * åˆ é™¤æ ‡è®°
     */
    @ApiModelProperty("删除：0不删除  1删除")
    private Long delFlag;
    @ApiModelProperty(value = "删除标记")
    private String delFlag;

    /**
     * å§“名
@@ -72,7 +74,7 @@
     */
    @Excel(name = "床号")
    @ApiModelProperty("床号")
    private Long badNo;
    private Long bedno;

    /**
     * ç§‘室
@@ -102,4 +104,41 @@
    @ApiModelProperty("病历号")
    private String medicalRecordNo;

    /**
     * ç—…历号
     */
    @Excel(name = "发送状态")
    @ApiModelProperty("发送状态")
    private Integer sendStatus;


    /**
     * å‘送时间
     */
    @Excel(name = "发送时间")
    @ApiModelProperty("发送时间")
    private Date sendTime;


    /**
     * æ“ä½œäºº
     */
    @Excel(name = "操作人")
    @ApiModelProperty("操作人")
    private String operatePerson;


    /**
     * æŽ¥æ”¶æ—¶é—´
     */
    @Excel(name = "接收时间")
    @ApiModelProperty("接收时间")
    private String receiveTime;

    /**
     * æ˜¯å¦å­˜åœ¨æ“ä½œï¼š1 æ–°å¢ž 2修改 3删除
     */
    @ApiModelProperty(value = "是否存在操作：1 æ–°å¢ž 2修改 3删除")
    private Integer isoperation;

}

 smartor/src/main/java/com/smartor/domain/SvyLibTopic.java

@@ -39,7 +39,7 @@
    /**
     * é—®åˆ¸é¢˜ç›®åˆ†ç±»ID
     */
    @ApiModelProperty("老版本ID")
    @ApiModelProperty("分类ID")
    private Long categoryid;

    /**

 smartor/src/main/java/com/smartor/mapper/HospitalRecordMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,66 @@
package com.smartor.mapper;

import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.smartor.domain.HospitalRecord;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘Mapper接口
 *
 * @author ruoyi
 * @date 2024-01-26
 */
@DataSource(value = DataSourceType.SLAVE)
@Mapper
public interface HospitalRecordMapper {
    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    public HospitalRecord selectHospitalRecordByID(String ID);

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘列表
     *
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘集合
     */
    public List<HospitalRecord> selectHospitalRecordList(HospitalRecord hospitalRecord);

    /**
     * æ–°å¢žã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int insertHospitalRecord(HospitalRecord hospitalRecord);

    /**
     * ä¿®æ”¹ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int updateHospitalRecord(HospitalRecord hospitalRecord);

    /**
     * åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ç»“æžœ
     */
    public int deleteHospitalRecordByID(String ID);

    /**
     * æ‰¹é‡åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param IDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteHospitalRecordByIDs(String[] IDs);
}

 smartor/src/main/java/com/smartor/mapper/HospitalUserinfoMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,66 @@
package com.smartor.mapper;

import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.smartor.domain.HospitalUserinfo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘Mapper接口
 *
 * @author ruoyi
 * @date 2024-01-29
 */
@DataSource(value = DataSourceType.SLAVE)
@Mapper
public interface HospitalUserinfoMapper {
    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    public HospitalUserinfo selectHospitalUserinfoByID(Long ID);

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘列表
     *
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘集合
     */
    public List<HospitalUserinfo> selectHospitalUserinfoList(HospitalUserinfo hospitalUserinfo);

    /**
     * æ–°å¢žã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int insertHospitalUserinfo(HospitalUserinfo hospitalUserinfo);

    /**
     * ä¿®æ”¹ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int updateHospitalUserinfo(HospitalUserinfo hospitalUserinfo);

    /**
     * åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ç»“æžœ
     */
    public int deleteHospitalUserinfoByID(Long ID);

    /**
     * æ‰¹é‡åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param IDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteHospitalUserinfoByIDs(Long[] IDs);
}

 smartor/src/main/java/com/smartor/mapper/ServiceThirdDataMapper.java

@@ -29,4 +29,10 @@
     * @return ç»“æžœ
     */
    public int insertThirdData(ServiceThirdData serviceThirdData);

    public int insertThirdDataZxyzjh(ServiceThirdData serviceThirdData);

    public int insertThirdDataCfxzsq(ServiceThirdData serviceThirdData);

    public int updateIsDeal(Long id);
}

 smartor/src/main/java/com/smartor/service/IHeTaskService.java

@@ -33,7 +33,7 @@
     * @param heTaskVO å®£æ•™ä»»åŠ¡
     * @return ç»“æžœ
     */
    public int insertHeTask(HeTaskVO heTaskVO);
    public int insertOrUpdateHeTask(HeTaskVO heTaskVO);

    /**
     * ä¿®æ”¹å®£æ•™ä»»åŠ¡

 smartor/src/main/java/com/smartor/service/IHospitalRecordService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.smartor.service;

import com.smartor.domain.HospitalRecord;

import java.util.List;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘Service接口
 * 
 * @author ruoyi
 * @date 2024-01-26
 */
public interface IHospitalRecordService 
{
    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    public HospitalRecord selectHospitalRecordByID(String ID);

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘列表
     * 
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘集合
     */
    public List<HospitalRecord> selectHospitalRecordList(HospitalRecord hospitalRecord);

    /**
     * æ–°å¢žã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int insertHospitalRecord(HospitalRecord hospitalRecord);

    /**
     * ä¿®æ”¹ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int updateHospitalRecord(HospitalRecord hospitalRecord);

    /**
     * æ‰¹é‡åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param IDs éœ€è¦åˆ é™¤çš„【请填写功能名称】主键集合
     * @return ç»“æžœ
     */
    public int deleteHospitalRecordByIDs(String[] IDs);

    /**
     * åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘信息
     * 
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ç»“æžœ
     */
    public int deleteHospitalRecordByID(String ID);
}

 smartor/src/main/java/com/smartor/service/IHospitalUserinfoService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.smartor.service;

import com.smartor.domain.HospitalUserinfo;

import java.util.List;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘Service接口
 * 
 * @author ruoyi
 * @date 2024-01-29
 */
public interface IHospitalUserinfoService 
{
    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    public HospitalUserinfo selectHospitalUserinfoByID(Long ID);

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘列表
     * 
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘集合
     */
    public List<HospitalUserinfo> selectHospitalUserinfoList(HospitalUserinfo hospitalUserinfo);

    /**
     * æ–°å¢žã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int insertHospitalUserinfo(HospitalUserinfo hospitalUserinfo);

    /**
     * ä¿®æ”¹ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    public int updateHospitalUserinfo(HospitalUserinfo hospitalUserinfo);

    /**
     * æ‰¹é‡åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param IDs éœ€è¦åˆ é™¤çš„【请填写功能名称】主键集合
     * @return ç»“æžœ
     */
    public int deleteHospitalUserinfoByIDs(Long[] IDs);

    /**
     * åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘信息
     * 
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ç»“æžœ
     */
    public int deleteHospitalUserinfoByID(Long ID);
}

 smartor/src/main/java/com/smartor/service/impl/HeTaskServiceImpl.java

@@ -1,6 +1,7 @@
package com.smartor.service.impl;

import com.ruoyi.common.enums.SendTypeEnum;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.DtoConversionUtils;
import com.smartor.common.SendService;
@@ -9,6 +10,7 @@
import com.smartor.mapper.PatArchiveMapper;
import com.smartor.mapper.PatHetaskRelevanceMapper;
import com.smartor.service.IHeTaskService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.lang3.ObjectUtils;
import org.springframework.beans.factory.annotation.Autowired;
@@ -26,6 +28,7 @@
 * @author ruoyi
 * @date 2024-01-07
 */
@Slf4j
@Service
public class HeTaskServiceImpl implements IHeTaskService {
    @Autowired
@@ -103,91 +106,149 @@
     * @param heTaskVO å®£æ•™ä»»åŠ¡
     * @return ç»“æžœ
     */
//    @Transactional(rollbackFor = Exception.class)
//    @Override
//    public int insertHeTask(HeTaskVO heTaskVO) {
//
//        Integer integer = 0;
//        //判断发送状态  0 æš‚停发送  1 å®šæ—¶å‘送  2 ç«‹å³å‘送
//        if (heTaskVO.getIsSend() == 2) {
//            //发送方式
//            String sendtype = SendTypeEnum.getDescByCode(heTaskVO.getPreachform().intValue());
//            for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
//                //开始发送
//                SendMagParam sendMagParam = new SendMagParam();
//                sendMagParam.setType(sendtype);
//                sendMagParam.setPhone(patHetaskRelevance.getPhone());
//                //这里的模板ID不确定，先这样写
//                sendMagParam.setTmpCode("SMS_461860582");
//                sendMagParam.setContent("Test发送数据");
//                Boolean success = sendService.sendMsg(sendMagParam);
//                if (success) {
//                    integer = integer + 1;
//                }
//
//                //必须全部成功，才能修改发送状态
//                if (heTaskVO.getPatHetaskRelevances().size() == integer) {
//                    //如果发送成功
//                    heTaskVO.setSendState(1L);
//                }
//            }
//            //将任务信息新增到宣教任务表中
//            HeTask heTask = DtoConversionUtils.sourceToTarget(heTaskVO, HeTask.class);
//            heTask.setCreateTime(DateUtils.getNowDate());
//            heTaskMapper.insertHeTask(heTask);
//
//            //将任务与患者关联
//            Integer i = null;
//            if (ObjectUtils.isNotEmpty(heTaskVO.getPatHetaskRelevances())) {
//                for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
//                    patHetaskRelevance.setHeTaskId(heTask.getId());
//                    i = patHetaskRelevanceMapper.insertPatHetaskRelevance(patHetaskRelevance);
//                }
//
//            }
//
//        } else if (heTaskVO.getIsSend() == 1) {
//            //定时发送(异步)
//            Timer timer = new Timer();
//            timer.schedule(new TimerTask() {
//                @Override
//                public void run() {
//                    Integer integer = 0;
//                    for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
//                        String sendtype = SendTypeEnum.getDescByCode(heTaskVO.getPreachform().intValue());
//                        SendMagParam sendMagParam = new SendMagParam();
//                        sendMagParam.setType(sendtype);
//                        sendMagParam.setPhone(patHetaskRelevance.getPhone());
//                        //这里的模板ID不确定，先这样写
//                        sendMagParam.setTmpCode("SMS_461860582");
//                        sendMagParam.setContent("Test发送数据");
//                        Boolean success = sendService.sendMsg(sendMagParam);
//                        if (success) {
//                            integer = integer + 1;
//                        }
//                    }
//                    //必须全部成功，才能修改发送状态
//                    if (heTaskVO.getPatHetaskRelevances().size() == integer) {
//                        //如果发送成功
//                        heTaskVO.setSendState(1L);
//                    }
//                    HeTask heTask = DtoConversionUtils.sourceToTarget(heTaskVO, HeTask.class);
//                    heTask.setCreateTime(DateUtils.getNowDate());
//                    heTaskMapper.insertHeTask(heTask);
//
//                    if (ObjectUtils.isNotEmpty(heTaskVO.getPatHetaskRelevances())) {
//                        for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
//                            patHetaskRelevance.setHeTaskId(heTask.getId());
//                            patHetaskRelevanceMapper.insertPatHetaskRelevance(patHetaskRelevance);
//                        }
//
//                    }
//                }
//            }, heTaskVO.getSendTime());
//
//        }
//        return 1;
//    }

    /**
     * æ–°å¢žå®£æ•™ä»»åŠ¡
     *
     * @param heTaskVO å®£æ•™ä»»åŠ¡
     * @return ç»“æžœ
     */
    @Transactional(rollbackFor = Exception.class)
    @Override
    public int insertHeTask(HeTaskVO heTaskVO) {

    public int insertOrUpdateHeTask(HeTaskVO heTaskVO) {
        if (ObjectUtils.isEmpty(heTaskVO)) {
            log.info("宣教任务入参为空，请检查入参");
            throw new BaseException("宣教任务入参为空，请检查入参");
        }
        Integer integer = 0;
        //判断发送状态  0 æš‚停发送  1 å®šæ—¶å‘送  2 ç«‹å³å‘送
        if (heTaskVO.getIsSend() == 2) {
            //发送方式
            String sendtype = SendTypeEnum.getDescByCode(heTaskVO.getPreachform().intValue());
            for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
                //开始发送
                SendMagParam sendMagParam = new SendMagParam();
                sendMagParam.setType(sendtype);
                sendMagParam.setPhone(patHetaskRelevance.getPhone());
                //这里的模板ID不确定，先这样写
                sendMagParam.setTmpCode("SMS_461860582");
                sendMagParam.setContent("Test发送数据");
                Boolean success = sendService.sendMsg(sendMagParam);
                if (success) {
                    integer = integer + 1;
                }
        if (heTaskVO.getIsoperation() != null && heTaskVO.getIsoperation() == 1) {

                //必须全部成功，才能修改发送状态
                if (heTaskVO.getPatHetaskRelevances().size() == integer) {
                    //如果发送成功
                    heTaskVO.setSendState(1L);
                }
            }
            //将任务信息新增到宣教任务表中
            HeTask heTask = DtoConversionUtils.sourceToTarget(heTaskVO, HeTask.class);
            heTask.setCreateTime(DateUtils.getNowDate());
            heTaskMapper.insertHeTask(heTask);

            //将任务与患者关联
            Integer i = null;
            if (ObjectUtils.isNotEmpty(heTaskVO.getPatHetaskRelevances())) {
                for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
                    patHetaskRelevance.setHeTaskId(heTask.getId());
                    i = patHetaskRelevanceMapper.insertPatHetaskRelevance(patHetaskRelevance);
                }

            }

        } else if (heTaskVO.getIsSend() == 1) {
            //定时发送(异步)
            Timer timer = new Timer();
            timer.schedule(new TimerTask() {
                @Override
                public void run() {
                    Integer integer = 0;
                    for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
                        String sendtype = SendTypeEnum.getDescByCode(heTaskVO.getPreachform().intValue());
                        SendMagParam sendMagParam = new SendMagParam();
                        sendMagParam.setType(sendtype);
                        sendMagParam.setPhone(patHetaskRelevance.getPhone());
                        //这里的模板ID不确定，先这样写
                        sendMagParam.setTmpCode("SMS_461860582");
                        sendMagParam.setContent("Test发送数据");
                        Boolean success = sendService.sendMsg(sendMagParam);
                        if (success) {
                            integer = integer + 1;
                        }
                    }
                    //必须全部成功，才能修改发送状态
                    if (heTaskVO.getPatHetaskRelevances().size() == integer) {
                        //如果发送成功
                        heTaskVO.setSendState(1L);
                    }
                    HeTask heTask = DtoConversionUtils.sourceToTarget(heTaskVO, HeTask.class);
                    heTask.setCreateTime(DateUtils.getNowDate());
                    heTaskMapper.insertHeTask(heTask);

                    if (ObjectUtils.isNotEmpty(heTaskVO.getPatHetaskRelevances())) {
            integer = heTask.getId().intValue();
            //新增
                        for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
                            patHetaskRelevance.setHeTaskId(heTask.getId());
                            patHetaskRelevanceMapper.insertPatHetaskRelevance(patHetaskRelevance);
                        }

        } else if (heTaskVO.getIsoperation() != null && heTaskVO.getIsoperation() == 2) {
            HeTask heTask = DtoConversionUtils.sourceToTarget(heTaskVO, HeTask.class);
            heTask.setUpdateTime(DateUtils.getNowDate());
            heTaskMapper.updateHeTask(heTask);
            //新增、删除、修改患者信息
            for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
                if (patHetaskRelevance.getIsoperation() != null && patHetaskRelevance.getIsoperation() == 1) {
                    patHetaskRelevanceMapper.insertPatHetaskRelevance(patHetaskRelevance);
                } else if (patHetaskRelevance.getIsoperation() != null && patHetaskRelevance.getIsoperation() == 2) {
                    patHetaskRelevance.setHeTaskId(heTask.getId());
                    patHetaskRelevanceMapper.updatePatHetaskRelevance(patHetaskRelevance);
                } else if (patHetaskRelevance.getIsoperation() != null && patHetaskRelevance.getIsoperation() == 3) {
                    patHetaskRelevanceMapper.deletePatHetaskRelevanceById(patHetaskRelevance.getId());
                    }
                }
            }, heTaskVO.getSendTime());
            integer = heTask.getId().intValue();
        } else if (heTaskVO.getIsoperation() != null && heTaskVO.getIsoperation() == 3) {
            heTaskMapper.deleteHeTaskById(heTaskVO.getId());

            //删除患者信息
            for (PatHetaskRelevance patHetaskRelevance : heTaskVO.getPatHetaskRelevances()) {
                if (patHetaskRelevance.getIsoperation() != null && patHetaskRelevance.getIsoperation() == 3) {
                    patHetaskRelevanceMapper.deletePatHetaskRelevanceById(patHetaskRelevance.getId());
        }
        return 1;
    }
            integer = heTaskVO.getId().intValue();
        }
        return integer;
    }


    /**
     * ä¿®æ”¹å®£æ•™ä»»åŠ¡
@@ -259,7 +320,6 @@
        }
        for (PatArchive patArchive : patArchiveList) {
            PatHetaskRelevance patHetaskRelevance = DtoConversionUtils.sourceToTarget(patArchive, PatHetaskRelevance.class);
            patHetaskRelevance.setDept(patArchive.getArchiveby());
            patHetaskRelevance.setCreateTime(patArchive.getCreateTime());
            patHetaskRelevance.setCreateBy(patArchive.getCreateBy());
            patHetaskRelevances.add(patHetaskRelevance);

 smartor/src/main/java/com/smartor/service/impl/HospitalRecordServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,94 @@
package com.smartor.service.impl;

import com.smartor.domain.HospitalRecord;
import com.smartor.mapper.HospitalRecordMapper;
import com.smartor.service.IHospitalRecordService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘Service业务层处理
 * 
 * @author ruoyi
 * @date 2024-01-26
 */
@Service
public class HospitalRecordServiceImpl implements IHospitalRecordService
{
    @Autowired
    private HospitalRecordMapper hospitalRecordMapper;

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    @Override
    public HospitalRecord selectHospitalRecordByID(String ID)
    {
        return hospitalRecordMapper.selectHospitalRecordByID(ID);
    }

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘列表
     * 
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    @Override
    public List<HospitalRecord> selectHospitalRecordList(HospitalRecord hospitalRecord)
    {
        return hospitalRecordMapper.selectHospitalRecordList(hospitalRecord);
    }

    /**
     * æ–°å¢žã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    @Override
    public int insertHospitalRecord(HospitalRecord hospitalRecord)
    {
        return hospitalRecordMapper.insertHospitalRecord(hospitalRecord);
    }

    /**
     * ä¿®æ”¹ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param hospitalRecord ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    @Override
    public int updateHospitalRecord(HospitalRecord hospitalRecord)
    {
        return hospitalRecordMapper.updateHospitalRecord(hospitalRecord);
    }

    /**
     * æ‰¹é‡åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * 
     * @param IDs éœ€è¦åˆ é™¤çš„【请填写功能名称】主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteHospitalRecordByIDs(String[] IDs)
    {
        return hospitalRecordMapper.deleteHospitalRecordByIDs(IDs);
    }

    /**
     * åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘信息
     * 
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteHospitalRecordByID(String ID)
    {
        return hospitalRecordMapper.deleteHospitalRecordByID(ID);
    }
}

 smartor/src/main/java/com/smartor/service/impl/HospitalUserinfoServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,87 @@
package com.smartor.service.impl;

import com.smartor.domain.HospitalUserinfo;
import com.smartor.mapper.HospitalUserinfoMapper;
import com.smartor.service.IHospitalUserinfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘Service业务层处理
 *
 * @author ruoyi
 * @date 2024-01-29
 */
@Service
public class HospitalUserinfoServiceImpl implements IHospitalUserinfoService {
    @Autowired
    private HospitalUserinfoMapper hospitalUserinfoMapper;

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    @Override
    public HospitalUserinfo selectHospitalUserinfoByID(Long ID) {
        return hospitalUserinfoMapper.selectHospitalUserinfoByID(ID);
    }

    /**
     * æŸ¥è¯¢ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘列表
     *
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     */
    @Override
    public List<HospitalUserinfo> selectHospitalUserinfoList(HospitalUserinfo hospitalUserinfo) {
        return hospitalUserinfoMapper.selectHospitalUserinfoList(hospitalUserinfo);
    }

    /**
     * æ–°å¢žã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    @Override
    public int insertHospitalUserinfo(HospitalUserinfo hospitalUserinfo) {
        return hospitalUserinfoMapper.insertHospitalUserinfo(hospitalUserinfo);
    }

    /**
     * ä¿®æ”¹ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param hospitalUserinfo ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     * @return ç»“æžœ
     */
    @Override
    public int updateHospitalUserinfo(HospitalUserinfo hospitalUserinfo) {
        return hospitalUserinfoMapper.updateHospitalUserinfo(hospitalUserinfo);
    }

    /**
     * æ‰¹é‡åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘
     *
     * @param IDs éœ€è¦åˆ é™¤çš„【请填写功能名称】主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteHospitalUserinfoByIDs(Long[] IDs) {
        return hospitalUserinfoMapper.deleteHospitalUserinfoByIDs(IDs);
    }

    /**
     * åˆ é™¤ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘信息
     *
     * @param ID ã€è¯·å¡«å†™åŠŸèƒ½åç§°ã€‘主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteHospitalUserinfoByID(Long ID) {
        return hospitalUserinfoMapper.deleteHospitalUserinfoByID(ID);
    }
}

 smartor/src/main/java/com/smartor/service/impl/IvrLibaTemplateServiceImpl.java

@@ -11,6 +11,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;

/**
@@ -124,10 +125,14 @@
        IvrLibaTemplate ivrLibaTemplate = DtoConversionUtils.sourceToTarget(ivrLibaTemplateVO, IvrLibaTemplate.class);
        if (ivrLibaTemplateVO.getIsoperation() != null && ivrLibaTemplateVO.getIsoperation() == 1) {
            //新增
            i = ivrLibaTemplateMapper.insertIvrLibaTemplate(ivrLibaTemplate);
            ivrLibaTemplate.setCreateTime(new Date());
            ivrLibaTemplateMapper.insertIvrLibaTemplate(ivrLibaTemplate);
            i = ivrLibaTemplate.getID().intValue();
        } else if (ivrLibaTemplateVO.getIsoperation() != null && ivrLibaTemplateVO.getIsoperation() == 2) {
            //修改
            i = ivrLibaTemplateMapper.updateIvrLibaTemplate(ivrLibaTemplate);
            ivrLibaTemplate.setUpdateTime(new Date());
            ivrLibaTemplateMapper.updateIvrLibaTemplate(ivrLibaTemplate);
            i = ivrLibaTemplate.getID().intValue();
        }
        log.info("新增或修改模板详情的id为：{}", ivrLibaTemplate.getID());

@@ -137,16 +142,19 @@
                if (ivrLibaTemplateTag.getIsoperation() != null && ivrLibaTemplateTag.getIsoperation() == 1) {
                    //新增
                    ivrLibaTemplateTag.setTemplateid(ivrLibaTemplate.getID());
                    ivrLibaTemplateTag.setCreateTime(new Date());
                    ivrLibaTemplateTagMapper.insertIvrLibaTemplateTag(ivrLibaTemplateTag);
                } else if (ivrLibaTemplateTag.getIsoperation() != null && ivrLibaTemplateTag.getIsoperation() == 2) {
                    //修改
                    ivrLibaTemplateTag.setTemplateid(ivrLibaTemplate.getID());
                    ivrLibaTemplateTag.setUploadTime(new Date());
                    ivrLibaTemplateTagMapper.updateIvrLibaTemplateTag(ivrLibaTemplateTag);
                } else if (ivrLibaTemplateTag.getIsoperation() != null && ivrLibaTemplateTag.getIsoperation() == 3) {
                    //删除
                    if (ivrLibaTemplateTag.getId() == null) {
                        log.info("删除失败,模板指标id为空");
                    } else {
                        ivrLibaTemplateTag.setUploadTime(new Date());
                        ivrLibaTemplateTagMapper.deleteIvrLibaTemplateTagById(ivrLibaTemplateTag.getId());
                    }
                }
@@ -160,6 +168,7 @@
                    //新增
                    IvrLibaTemplateScript ivrLibaTemplateScript = DtoConversionUtils.sourceToTarget(ivrLibaTemplateScriptVO, IvrLibaTemplateScript.class);
                    ivrLibaTemplateScript.setTemplateID(ivrLibaTemplate.getID());
                    ivrLibaTemplateScript.setCreateTime(new Date());
                    ivrLibaTemplateScriptMapper.insertIvrLibaTemplateScript(ivrLibaTemplateScript);
                    //对选项目进行处理
                    dealOption(ivrLibaTemplateScriptVO.getIvrLibaTemplateTargetoptionList(), ivrLibaTemplateScript, ivrLibaTemplate.getID());
@@ -168,6 +177,7 @@
                    //修改
                    IvrLibaTemplateScript ivrLibaTemplateScript = DtoConversionUtils.sourceToTarget(ivrLibaTemplateScriptVO, IvrLibaTemplateScript.class);
                    ivrLibaTemplateScript.setTemplateID(ivrLibaTemplate.getID());
                    ivrLibaTemplateScript.setUpdateTime(new Date());
                    ivrLibaTemplateScriptMapper.updateIvrLibaTemplateScript(ivrLibaTemplateScript);
                    //对选项目进行处理
                    dealOption(ivrLibaTemplateScriptVO.getIvrLibaTemplateTargetoptionList(), ivrLibaTemplateScript, ivrLibaTemplate.getID());
@@ -177,6 +187,7 @@
                    if (ivrLibaTemplateScriptVO.getID() == null) {
                        log.info("删除失败,模板话术id为空");
                    } else {
                        ivrLibaTemplateScriptVO.setUpdateTime(new Date());
                        ivrLibaTemplateTagMapper.deleteIvrLibaTemplateTagById(ivrLibaTemplateScriptVO.getID());
                    }
                }
@@ -189,8 +200,10 @@
                //新增
                tempDetpRelevance.setTempid(ivrLibaTemplate.getID());
                tempDetpRelevance.setType(2L);
                tempDetpRelevance.setCreateTime(new Date());
                tempDetpRelevanceMapper.insertTempDetpRelevance(tempDetpRelevance);
            } else {
                tempDetpRelevance.setUpdateTime(new Date());
                tempDetpRelevanceMapper.updateTempDetpRelevance(tempDetpRelevance);
            }
        }

 smartor/src/main/java/com/smartor/service/impl/RemoteDataSaveServiceImpl.java

@@ -54,7 +54,15 @@
        //此处引不到sping中的mapper,只能通过上下文，去获取mapper对象
        ServiceThirdDataMapper serviceThirdDataMapper = SpringUtils.getBean(ServiceThirdDataMapper.class);
        try {
            int i = serviceThirdDataMapper.insertThirdData(serviceThirdData);
            if (dataType.equals("RGV^O15")) {
                //直接插到"执行医嘱计划表"
                int i1 = serviceThirdDataMapper.insertThirdDataZxyzjh(serviceThirdData);
            } else if (dataType.equals("OMP^O09")) {
                //处方新增申请
                int i2 = serviceThirdDataMapper.insertThirdDataCfxzsq(serviceThirdData);
            } else {
                int i3 = serviceThirdDataMapper.insertThirdData(serviceThirdData);
            }
        } catch (Exception e) {
            SimpleDateFormat simpleDateFormat1 = new SimpleDateFormat("YYYY-MM-dd HH:mm:ss");
            String date = simpleDateFormat1.format(new Date());
@@ -62,21 +70,6 @@
            e.getMessage();
        }


//        //根据数据类型，去调用相应的方法进行数据保存(这一块先不做了，后面再做)
//        switch (dataType) {
//            case "ADT^A31":
//                //患者基本信息
//                patientInfo(map);
//                break;
//            case "ADT^A08":
//                //患者诊断信息修改/
//                patientInfoEdit(map);
//            case "ADT^A01":
//                //患者入院
//                patientHospitalized(map);
//                break;
//        }
    }

    /**

 smartor/src/main/java/com/smartor/service/impl/ServiceThirdDataServiceImpl.java

@@ -1,10 +1,22 @@
package com.smartor.service.impl;

import java.util.List;

import ca.uhn.hl7v2.HL7Exception;
import ca.uhn.hl7v2.model.Message;
import ca.uhn.hl7v2.parser.PipeParser;
import com.smartor.domain.HospitalRecord;
import com.smartor.domain.HospitalUserinfo;
import com.smartor.domain.ServiceThirdData;
import com.smartor.mapper.ServiceThirdDataMapper;
import com.smartor.service.IHospitalRecordService;
import com.smartor.service.IHospitalUserinfoService;
import com.smartor.service.IServiceThirdDataService;
import com.smartor.yiwudataanalysis.ADT_A03;
import lombok.extern.log4j.Log4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;


/**
@@ -13,12 +25,49 @@
 * @author ruoyi
 * @date 2023-10-10
 */
@Log4j
@Service
public class ServiceThirdDataServiceImpl implements IServiceThirdDataService {

    @Autowired
    private ServiceThirdDataMapper serviceThirdDataMapper;

    @Autowired
    private IHospitalRecordService iHospitalRecordService;
    @Autowired
    private IHospitalUserinfoService iHospitalUserinfoService;

    @Override
    public List<ServiceThirdData> queryList(ServiceThirdData serviceThirdData) {
        return null;

        List<ServiceThirdData> serviceThirdDataList = serviceThirdDataMapper.selectServiceThirdDataList(serviceThirdData);
        for (ServiceThirdData std : serviceThirdDataList) {
            PipeParser parser = new PipeParser();
            Message message = null;
            try {
                String dataInfo = std.getDataInfo().substring(1);
                dataInfo = dataInfo.replaceAll("\n", "");
                dataInfo = dataInfo.substring(0, dataInfo.length() - 1);
                message = parser.parse(dataInfo);
                ADT_A03 adt_a03 = new ADT_A03();

                List<Object> objectList = adt_a03.explainPID(message, dataInfo);
                HospitalRecord hospitalRecord = (HospitalRecord) objectList.get(0);
                iHospitalRecordService.insertHospitalRecord(hospitalRecord);

                HospitalUserinfo hospitalUserinfo = (HospitalUserinfo) objectList.get(1);
                iHospitalUserinfoService.insertHospitalUserinfo(hospitalUserinfo);

                int ii = serviceThirdDataMapper.updateIsDeal(std.getId());
                System.out.println("是否修改成功：" + ii);
            } catch (HL7Exception e) {
                e.printStackTrace();
    }

        }

        return new ArrayList<>();
    }


}

 smartor/src/main/java/com/smartor/yiwudataanalysis/ADT_A03.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,484 @@
package com.smartor.yiwudataanalysis;

import ca.uhn.hl7v2.HL7Exception;
import ca.uhn.hl7v2.model.Message;
import ca.uhn.hl7v2.model.Structure;
import ca.uhn.hl7v2.model.v24.datatype.*;
import ca.uhn.hl7v2.model.v24.segment.DG1;
import ca.uhn.hl7v2.model.v24.segment.PID;
import ca.uhn.hl7v2.model.v24.segment.PV1;
import ca.uhn.hl7v2.model.v24.segment.PV2;
import com.ruoyi.common.enums.AdmTypeEnum;
import com.ruoyi.common.enums.LevelHospEnum;
import com.ruoyi.common.utils.StringUtils;
import com.smartor.domain.HospitalRecord;
import com.smartor.domain.HospitalUserinfo;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.Year;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

//出院数据
public class ADT_A03 {
    //解析PID
    public List<Object> explainPID(Message message, String dataInfo) throws HL7Exception {
        //解析PID（患者基本信息）
        PID pid = (PID) message.get("PID");

        //患者主索引信息
        CX pid2_patientID = pid.getPid2_PatientID();
        //患者全院唯一标识（患者主索引/ID）
        String patientID = pid2_patientID.getID().encode();
        //VIP-先诊疗后付费标志（0/1）
        String cd = pid2_patientID.getCheckDigit().encode();

        //患者相关 ID^^^授权机构
        CX[] pid3_patientIdentifierList = pid.getPid3_PatientIdentifierList();
        if (pid3_patientIdentifierList != null || pid3_patientIdentifierList.length > 0) {
            for (CX cx : pid3_patientIdentifierList) {
                //患者相关ID
                String hzxgID = cx.getID().encode();
                //分配患者 ID æœºæž„
                String patiendOrgan = cx.getAssigningAuthority().encode();
            }
        }

        //门诊不填，住院必填
        CX[] pid4_alternatePatientIDPID = pid.getPid4_AlternatePatientIDPID();
        if (pid4_alternatePatientIDPID != null || pid4_alternatePatientIDPID.length > 0) {
            for (CX cx : pid4_alternatePatientIDPID) {
                //非婴儿 0 å©´å„¿ 1
                String s = cx.getID().encode();
                //  0/空-不需要保密； 1-保密
                String s1 = cx.getIdentifierTypeCode().encode();
            }
        }

        //患者姓名
        XPN[] pid5_patientName = pid.getPid5_PatientName();
        String patientName = "";
        for (XPN xpn : pid5_patientName) {
            //拼音
            String pinyin = xpn.getFamilyName().encode();
            //患者姓名
            patientName = xpn.getGivenName().encode();
        }


        //出生日期
        String birthday = pid.getPid7_DateTimeOfBirth().encode();
        SimpleDateFormat inputFormatt = new SimpleDateFormat("yyyyMMddHHmmss"); // è¾“入日期格式
        Date date = null; // è§£æžä¸ºDate对象
        try {
            date = inputFormatt.parse(birthday);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        SimpleDateFormat outputFormatt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // è¾“出日期格式
        String birthdatTime = outputFormatt.format(date);


        //性别 1男  2女
        String xb = pid.getPid8_AdministrativeSex().encode();

        //血型信息
        CE[] pid10_race = pid.getPid10_Race();
        for (CE ce : pid10_race) {
            //血型代码
            String xxdm = ce.getCe1_Identifier().encode();
            //血型名称
            String xxmc = ce.getCe2_Text().encode();
            //rh血型代码
            String rhxxdm = ce.getCe4_AlternateIdentifier().encode();
            //rh血型名称
            String rhxxmc = ce.getCe5_AlternateText().encode();
        }

        //地址信息
        XAD[] pid11_patientAddress = pid.getPid11_PatientAddress();
        String xxdzxx = null;
        String streetName = null;
        String dwellingNumber = null;
        String otherDesignation = null;
        String city = null;
        String province = null;
        for (XAD xad : pid11_patientAddress) {
            //详细地址信息
            xxdzxx = xad.getXad1_StreetAddress().getSad1_StreetOrMailingAddress().encode();
            //街道信息（村/街/道）
            streetName = xad.getXad1_StreetAddress().getStreetName().encode();
            //门牌号码
            dwellingNumber = xad.getXad1_StreetAddress().getDwellingNumber().encode();
            //县地区（县)
            otherDesignation = xad.getXad2_OtherDesignation().encode();
            //城市（市）
            city = xad.getXad3_City().encode();
            //省
            province = xad.getXad4_StateOrProvince().encode();
            //地址类型（参考字典）
            String addressType = xad.getXad7_AddressType().encode();
            //乡镇信息
            String designation = xad.getXad8_OtherGeographicDesignation().encode();
            //县地区编码
            String parishCode = xad.getXad9_CountyParishCode().encode();
            //街道标准编码（保留）
            String censusTract = xad.getXad10_CensusTract().encode();
        }

        //个人电话
        XTN[] pid13_phoneNumberHome = pid.getPid13_PhoneNumberHome();
        String phone = null;
        for (XTN xtn : pid13_phoneNumberHome) {
            //电话类型代码（参考字典）
            String lxdm = xtn.getTelecommunicationEquipmentType().encode();
            //电话号码
            phone = xtn.getPhoneNumber().encode();
        }

        //工作电话
        XTN[] pid14_phoneNumberBusiness = pid.getPid14_PhoneNumberBusiness();
        for (XTN xtn : pid14_phoneNumberBusiness) {
            //工作电话
            String phoneNumberWork = xtn.getPhoneNumber().encode();
        }

        //婚姻状况代码
        String identifier = pid.getPid16_MaritalStatus().getIdentifier().encode();
        //婚姻状况名称
        String text = pid.getPid16_MaritalStatus().getText().encode();

        //证件号码
        String id = pid.getPid18_PatientAccountNumber().getID().encode();
        //证件类型（参考字典）
        String assigningAuthority = pid.getPid18_PatientAccountNumber().getAssigningAuthority().encode();
        //证件不详原因
        HD assigningFacility = pid.getPid18_PatientAccountNumber().getAssigningFacility();
        //原因代码
        String namespaceID = assigningFacility.getNamespaceID().encode();
        //原因名称
        String universalID = assigningFacility.getUniversalID().encode();

        //身份证号
        String SSNNumberPatient = pid.getPid19_SSNNumberPatient().encode();

        CX[] pid21_motherSIdentifier = pid.getPid21_MotherSIdentifier();
        for (CX cx : pid21_motherSIdentifier) {
            //母亲住院 ID(门诊不填，住院必填)
            String mqid = cx.getID().encode();
        }

        //民族
        CE[] pid22_ethnicGroup = pid.getPid22_EthnicGroup();
        String mztext = null;
        for (CE ce : pid22_ethnicGroup) {
            //民族 ID
            String Identifier = ce.getIdentifier().encode();
            //民族名称
            mztext = ce.getText().encode();
        }

        //出生地
        String encode = pid.getPid23_BirthPlace().encode();

        //职业
        CE[] citizenship = pid.getPid26_Citizenship();
        for (CE ce : citizenship) {
            //职业代码
            String Identifier = ce.getIdentifier().encode();
            //职业名称
            String zytext = ce.getText().encode();
        }

        //国籍代码
        String Identifier = pid.getPid28_Nationality().getIdentifier().encode();
        //国籍名称
        String gjtext = pid.getPid28_Nationality().getText().encode();

        //死胎标志 é»˜è®¤æ˜¯ 0/空，1-死胎
        String patientDeathIndicator = pid.getPid30_PatientDeathIndicator().encode();

        //黑名单病人
        IS[] pid32_identityReliabilityCode = pid.getPid32_IdentityReliabilityCode();

        //患者属性 (参考字典)
        //格式如：0101000
        //说明：由多位组成，第一
        //位表示属性 1 çš„值，
        // ç¬¬äºŒä½è¡¨ç¤ºå±žæ€§ 2 çš„值。
        String hzIdentifier = pid.getPid38_ProductionClassCode().getIdentifier().encode();

        //--------------------------------------------------------------
        //解析 PV1（患者访问信息）
        PV1 pv1 = (PV1) message.get("PV1");

        //挂号序号或住院次数
        String xh = pv1.getPv11_SetIDPV1().encode();

        //患者分类   E：急诊； I：住院；    O：门诊；T：体检
        String patientClass = pv1.getPv12_PatientClass().encode();

        //患者位置信息
        PL pv13_assignedPatientLocation = pv1.getPv13_AssignedPatientLocation();
        //当前病区
        String bq = pv13_assignedPatientLocation.getPointOfCare().encode();
        //当前病房
        String room = pv13_assignedPatientLocation.getRoom().encode();
        //当前病床
        String bad = pv13_assignedPatientLocation.getBed().encode();
        //当前科室 ID
        String namespaceID1 = pv13_assignedPatientLocation.getFacility().getNamespaceID().encode();
        //当前科室名称
        String ksuniversalID = pv13_assignedPatientLocation.getFacility().getUniversalID().encode();
        //当前床位名称
        String locationStatus = pv13_assignedPatientLocation.getLocationStatus().encode();
        //当前病区名称
        String personLocationType = pv13_assignedPatientLocation.getPersonLocationType().encode();

        //入院类型  R:常规  E:紧急  W:留观  å…¶ä½™è§ HL7 çº¦å®š
        String admissionType = pv1.getPv14_AdmissionType().encode();

        //转前位置信息
        //转前病区
        String pointOfCare = pv1.getPv16_PriorPatientLocation().getPointOfCare().encode();
        //转前病房
        String room1 = pv1.getPv16_PriorPatientLocation().getRoom().encode();
        //转前病床
        String bed = pv1.getPv16_PriorPatientLocation().getBed().encode();
        //转前科室
        HD facility = pv1.getPv16_PriorPatientLocation().getFacility();
        //转前科室 ID
        String namespaceID2 = facility.getNamespaceID().encode();
        //转前科室名称
        String universalID1 = facility.getUniversalID().encode();
        //转前床位名称
        String locationStatus1 = pv1.getPv16_PriorPatientLocation().getLocationStatus().encode();
        //转前病区名称
        String personLocationType1 = pv1.getPv16_PriorPatientLocation().getPersonLocationType().encode();

        //门诊为就诊医生
        XCN[] pv17_attendingDoctor = pv1.getPv17_AttendingDoctor();
        String IDNumber = null;
        String givenName = null;
        for (XCN xcn : pv17_attendingDoctor) {
            //主治医生 ID
            IDNumber = xcn.getIDNumber().encode();
            //主治医生姓名
            givenName = xcn.getGivenName().encode();
            //医疗组信息
            HD xcn14_assigningFacility = xcn.getXcn14_AssigningFacility();
            //医疗组名称
            String universalID2 = xcn14_assigningFacility.getNamespaceID().encode();
            //收治医生 ID
            String universalID3 = xcn14_assigningFacility.getUniversalID().encode();
        }

        //挂号类别  1-普通；2-急诊  4-专家；6-老教授
        String pv110_hospitalService = pv1.getPv110_HospitalService().encode();

        //预收入院检验标识  é»˜è®¤ä¸ºç©º 0-否；1-是
        String pv112_preadmitTestIndicator = pv1.getPv112_PreadmitTestIndicator().encode();

        //再次入院标志 é»˜è®¤ä¸ºç©ºï¼Œ â€œR”表示再入院
        String pv113_reAdmissionIndicator = pv1.getPv113_ReAdmissionIndicator().encode();

        //入院途径
        String pv114_admitSource = pv1.getPv114_AdmitSource().encode();

        //入院医生
        XCN[] pv117_admittingDoctor = pv1.getPv117_AdmittingDoctor();
        for (XCN xcn : pv117_admittingDoctor) {
            //员工号
            String idNumber = xcn.getIDNumber().encode();
            //姓名
            String givenName2 = xcn.getGivenName().encode();
        }

        //费用类别
        String pv118_patientType = pv1.getPv118_PatientType().encode();

        //就诊 ID æˆ–者患者住院 ID
        String id1 = pv1.getPv119_VisitNumber().getID().encode();

        //优惠类别
        FC[] pv120_financialClass = pv1.getPv120_FinancialClass();
        for (FC fc : pv120_financialClass) {
            String financialClass = fc.getFinancialClass().encode();
        }

        //费用性质
        String pv121_chargePriceIndicator = pv1.getPv121_ChargePriceIndicator().encode();

        //入科日期
        DT[] pv125_contractEffectiveDate = pv1.getPv125_ContractEffectiveDate();
        DT dt = pv125_contractEffectiveDate[0];

        SimpleDateFormat inputFormattt = new SimpleDateFormat("yyyyMMdd"); // è¾“入日期格式
        Date date22 = null; // è§£æžä¸ºDate对象
        try {
            date22 = inputFormattt.parse(dt.encode());
        } catch (ParseException e) {
            e.printStackTrace();
        }
        SimpleDateFormat outputFormat2 = new SimpleDateFormat("yyyy-MM-dd"); // è¾“出日期格式
        String rkdate = outputFormat2.format(date22);


        //账户冻结建议
        String pv128_interestCode = pv1.getPv128_InterestCode().encode();

        //欠费冻结标识  é»˜è®¤æ˜¯ 0/空  1：冻结；2：永不冻结
        String pv129_transferToBadDebtCode = pv1.getPv129_TransferToBadDebtCode().encode();

        //冻结日期
        String pv130_transferToBadDebtDate = pv1.getPv130_TransferToBadDebtDate().encode();

        //解冻日期
        String pv135_deleteAccountDate = pv1.getPv135_DeleteAccountDate().encode();

        //离院去向/转归
        String pv136_dischargeDisposition = pv1.getPv136_DischargeDisposition().encode();

        //离院去往位置
        String pv137_dischargedToLocation = pv1.getPv137_DischargedToLocation().getDischargeLocation().encode();

        //饮食类型ID
        String identifier1 = pv1.getPv138_DietType().getIdentifier().encode();
        //饮食类型名称
        String text1 = pv1.getPv138_DietType().getText().encode();

        //挂号的上下午标志   0-上午；1-下午；2-晚上
        String pv139_servicingFacility = pv1.getPv139_ServicingFacility().encode();

        //科室 ID^^^院区 ID
        PL pv142_pendingLocation = pv1.getPv142_PendingLocation();
        //门诊就诊科室 ID
        String mzpointOfCare = pv142_pendingLocation.getPointOfCare().encode();
        //住院院区 ID
        String namespaceID3 = pv142_pendingLocation.getFacility().getNamespaceID().encode();
        //应用 ID
        String universalIDType = pv142_pendingLocation.getFacility().getUniversalIDType().encode();
        //医疗机构代码
        String personLocationType2 = pv142_pendingLocation.getPersonLocationType().encode();
        //医疗机构名称
        String building = pv142_pendingLocation.getBuilding().encode();

        //就诊/住院时间
        String pv144_admitDateTime = pv1.getPv144_AdmitDateTime().encode();

        //出院时间  A03 æ¶ˆæ¯å¿…å¡«
        TS[] pv145_dischargeDateTime = pv1.getPv145_DischargeDateTime();
        TS ts = pv145_dischargeDateTime[0];
//        Date date2 = new Date(Long.valueOf(ts.encode()));
//        SimpleDateFormat sdff = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//        String dischargeDateTime = sdff.format(date2);

        SimpleDateFormat inputFormat = new SimpleDateFormat("yyyyMMddHHmmss"); // è¾“入日期格式
        Date date2 = null; // è§£æžä¸ºDate对象
        try {
            date2 = inputFormat.parse(ts.encode());
        } catch (ParseException e) {
            e.printStackTrace();
        }
        SimpleDateFormat outputFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // è¾“出日期格式
        String dischargeDateTime = outputFormat.format(date2);

        //访问标示
        String visitIndicator = pv1.getPv151_VisitIndicator().encode();

        //操作人信息
        XCN[] pv152_otherHealthcareProvider = pv1.getPv152_OtherHealthcareProvider();
        for (XCN xcn : pv152_otherHealthcareProvider) {
            //员工号
            String IDNumber2 = xcn.getIDNumber().encode();
            //姓名
            String givenName3 = xcn.getGivenName().encode();
        }
        //-----------------------------
        PV2 pv2 = (PV2) message.get("PV2");
        //实际住院天数
        String pv211_actualLengthOfInpatientStay = pv2.getPv211_ActualLengthOfInpatientStay().encode();

        //------------------------------------------
        Structure[] dg1s = message.getAll("DG1");
        String dg12_diagnosisCodingMethod = null;
        String dg14_diagnosisDescription = null;
        for (Structure structure : dg1s) {
            DG1 dg11 = (DG1) structure;
            //序号
            String dg1xh = dg11.getDg11_SetIDDG1().encode();
            //诊断代码
            dg12_diagnosisCodingMethod = dg11.getDg12_DiagnosisCodingMethod().encode();
            //诊断名称
            dg14_diagnosisDescription = dg11.getDg14_DiagnosisDescription().encode();
            //诊断类型
            String dg16_diagnosisType = dg11.getDg16_DiagnosisType().encode();
            System.out.println(dg11);

        }

        //数据入库
        HospitalRecord hospitalRecord = new HospitalRecord();
        hospitalRecord.setCreateTime(new Date());
        hospitalRecord.setPatientID(patientID);
        hospitalRecord.setOpreationTime(new Date());
        //就诊号
        hospitalRecord.setOutMedNO(id1);
        //就诊类型描述（门诊、住院...）
        hospitalRecord.setAdmTypeDesc(AdmTypeEnum.getDescByCode(patientClass));
        //入院状态（就诊中、结束就诊...）
        hospitalRecord.setAdmStatus(LevelHospEnum.getDescByCode(pv136_dischargeDisposition));
        hospitalRecord.setAdmDate(dischargeDateTime);
        hospitalRecord.setEncPatName(patientName);
        if (StringUtils.isNotEmpty(xb)) {
            hospitalRecord.setEncPatGender(xb.equals(1) ? "男" : "女");
        }
        hospitalRecord.setEncPatBirthDate(birthdatTime);
        //获取年龄
        int currentYear = Year.now().getValue();
        Integer integer = Integer.valueOf(birthdatTime.substring(0, 4));
        Integer age = currentYear - integer;
        hospitalRecord.setEncAgeValue(age.toString());

        //主治医生编号
        hospitalRecord.setDirectorCode(IDNumber);
        //主治医生姓名
        hospitalRecord.setDirectorName(givenName);
        hospitalRecord.setEncAdmLocCode(namespaceID1);
        hospitalRecord.setEncAdmLocName(ksuniversalID);
        hospitalRecord.setEncDiagnosisCode(dg12_diagnosisCodingMethod);
        hospitalRecord.setEncDiagnosisDesc(dg14_diagnosisDescription);

        List<Object> objectList = new ArrayList<>();
//        objectList.add(hospitalRecord);

        HospitalUserinfo hospitalUserinfo = new HospitalUserinfo();
//        hospitalUserinfo.setCreateTime(null);
        hospitalUserinfo.setPatientID(patientID);
        hospitalUserinfo.setRegDate(rkdate);
        hospitalUserinfo.setIdentityID(SSNNumberPatient);
        hospitalUserinfo.setPatName(patientName);
        hospitalUserinfo.setPhone(phone);
        if (StringUtils.isNotEmpty(xb)) {
            hospitalUserinfo.setPatSex(xb.equals(1) ? "男" : "女");
        }
        hospitalUserinfo.setBirthDate(birthdatTime);
        hospitalUserinfo.setAddress(xxdzxx);
        hospitalUserinfo.setAddProvince(province);
        hospitalUserinfo.setAddCity(city);
        hospitalUserinfo.setAddCounty(otherDesignation);
        hospitalUserinfo.setAddTown(streetName);
        hospitalUserinfo.setCountry(gjtext);
        hospitalUserinfo.setNation(mztext);
        hospitalUserinfo.setConPerPhone(phone);
        hospitalUserinfo.setRegOrgDesc("义乌市第二人民医院");
        hospitalUserinfo.setEncAdmSource(AdmTypeEnum.getDescByCode(patientClass));
        objectList.add(hospitalRecord);
        objectList.add(hospitalUserinfo);

        return objectList;

    }
}

 smartor/src/main/resources/mapper/smartor/HeLibraryAssortMapper.xml

@@ -41,6 +41,7 @@
            resultMap="HeLibraryAssortResult">
        <include refid="selectHeLibraryAssortVo"/>
        <where>
            del_flag != 1
            <if test="assortname != null  and assortname != ''">and assortname like concat('%', #{assortname}, '%')</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>
            <if test="isupload != null ">and isupload = #{isupload}</if>
@@ -48,7 +49,7 @@
            <if test="pid != null ">and pid = #{pid}</if>
            <if test="guid != null  and guid != ''">and guid = #{guid}</if>
            <if test="seqno != null  ">and seqno = #{seqno}</if>
            and del_flag != 1

        </where>
        order by seqno asc
    </select>

 smartor/src/main/resources/mapper/smartor/HeLibraryTagMapper.xml

@@ -44,6 +44,7 @@
    <select id="selectHeLibraryTagList" parameterType="com.smartor.domain.HeLibraryTag" resultMap="HeLibraryTagResult">
        <include refid="selectHeLibraryTagVo"/>
        <where>
            del_flag=0
            <if test="tagcategoryid != null ">and tagcategoryid = #{tagcategoryid}</if>
            <if test="tagid != null ">and tagid = #{tagid}</if>
            <if test="orgid != null  and orgid != ''">and orgid = #{orgid}</if>

 smartor/src/main/resources/mapper/smartor/HospitalRecordMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,420 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.smartor.mapper.HospitalRecordMapper">

    <resultMap type="com.smartor.domain.HospitalRecord" id="HospitalRecordResult">
        <result property="ID" column="ID"/>
        <result property="sourceSystem" column="SourceSystem"/>
        <result property="messageID" column="MessageID"/>
        <result property="createTime" column="CreateTime"/>
        <result property="methodName" column="MethodName"/>
        <result property="reqIimRules" column="ReqIimRules"/>
        <result property="patientID" column="PatientID"/>
        <result property="opreationTime" column="OpreationTime"/>
        <result property="episodeID" column="EpisodeID"/>
        <result property="outMedNO" column="OutMedNO"/>
        <result property="inMedNO" column="InMedNO"/>
        <result property="visitNum" column="VisitNum"/>
        <result property="admTypeCode" column="AdmTypeCode"/>
        <result property="admTypeDesc" column="AdmTypeDesc"/>
        <result property="admStatus" column="AdmStatus"/>
        <result property="admDate" column="AdmDate"/>
        <result property="encPatName" column="EncPatName"/>
        <result property="encPatGender" column="EncPatGender"/>
        <result property="encPatBirthDate" column="EncPatBirthDate"/>
        <result property="transferstart" column="Transferstart"/>
        <result property="transferend" column="Transferend"/>
        <result property="encPatMaritalStatus" column="EncPatMaritalStatus"/>
        <result property="originalText" column="OriginalText"/>
        <result property="encDocList" column="EncDocList"/>
        <result property="encAdmLocList" column="EncAdmLocList"/>
        <result property="encounterPeriodStart" column="Encounter_period_start"/>
        <result property="encounterPeriodEnd" column="Encounter_period_end"/>
        <result property="encounterBooktime" column="Encounter_booktime"/>
        <result property="encAdmSource" column="EncAdmSource"/>
        <result property="encInhostype" column="EncInhostype"/>
        <result property="encDietName" column="EncDietName"/>
        <result property="encOuthostype" column="EncOuthostype"/>
        <result property="encVisitnum" column="EncVisitnum"/>
        <result property="encChargeType" column="EncChargeType"/>
        <result property="encChargeTypeName" column="EncChargeTypeName"/>
        <result property="encChargeCode" column="EncChargeCode"/>
        <result property="encChargeName" column="EncChargeName"/>
        <result property="encReglevelcode" column="EncReglevelcode"/>
        <result property="encCareLevel" column="EncCareLevel"/>
        <result property="specialday" column="Specialday"/>
        <result property="primaryday" column="Primaryday"/>
        <result property="secondaryday" column="Secondaryday"/>
        <result property="tertiaryday" column="Tertiaryday"/>
        <result property="enroomno" column="Enroomno"/>
        <result property="enBedno" column="EnBedno"/>
        <result property="encSeeno" column="EncSeeno"/>
        <result property="encAgeUnit" column="EncAgeUnit"/>
        <result property="encAgeValue" column="EncAgeValue"/>
        <result property="enIsbaby" column="EnIsbaby"/>
        <result property="encHavebaby" column="EncHavebaby"/>
        <result property="encDiagList" column="EncDiagList"/>
        <result property="directorCode" column="DirectorCode"/>
        <result property="directorName" column="DirectorName"/>
        <result property="encDiagnosisCode" column="EncDiagnosisCode"/>
        <result property="encDiagnosisDesc" column="EncDiagnosisDesc"/>
        <result property="encAdmLocCode" column="EncAdmLocCode"/>
        <result property="encAdmLocName" column="EncAdmLocName"/>
        <result property="taskStatus" column="taskStatus"/>
    </resultMap>

    <sql id="selectHospitalRecordVo">
        select ID,
               SourceSystem,
               MessageID,
               CreateTime,
               MethodName,
               ReqIimRules,
               PatientID,
               OpreationTime,
               EpisodeID,
               OutMedNO,
               InMedNO,
               VisitNum,
               AdmTypeCode,
               AdmTypeDesc,
               AdmStatus,
               AdmDate,
               EncPatName,
               EncPatGender,
               EncPatBirthDate,
               Transferstart,
               Transferend,
               EncPatMaritalStatus,
               OriginalText,
               EncDocList,
               EncAdmLocList,
               Encounter_period_start,
               Encounter_period_end,
               Encounter_booktime,
               EncAdmSource,
               EncInhostype,
               EncDietName,
               EncOuthostype,
               EncVisitnum,
               EncChargeType,
               EncChargeTypeName,
               EncChargeCode,
               EncChargeName,
               EncReglevelcode,
               EncCareLevel,
               Specialday,
               Primaryday,
               Secondaryday,
               Tertiaryday,
               Enroomno,
               EnBedno,
               EncSeeno,
               EncAgeUnit,
               EncAgeValue,
               EnIsbaby,
               EncHavebaby,
               EncDiagList,
               DirectorCode,
               DirectorName,
               EncDiagnosisCode,
               EncDiagnosisDesc,
               EncAdmLocCode,
               EncAdmLocName,
               taskStatus
        from hospital_record
    </sql>

    <select id="selectHospitalRecordList" parameterType="com.smartor.domain.HospitalRecord"
            resultMap="HospitalRecordResult">
        <include refid="selectHospitalRecordVo"/>
        <where>
            <if test="ID != null  and ID != ''">and ID = #{ID}</if>
            <if test="sourceSystem != null  and sourceSystem != ''">and SourceSystem = #{sourceSystem}</if>
            <if test="messageID != null  and messageID != ''">and MessageID = #{messageID}</if>
            <if test="createTime != null  and createTime != ''">and CreateTime = #{createTime}</if>
            <if test="methodName != null  and methodName != ''">and MethodName like concat('%', #{methodName}, '%')</if>
            <if test="reqIimRules != null  and reqIimRules != ''">and ReqIimRules = #{reqIimRules}</if>
            <if test="patientID != null  and patientID != ''">and PatientID = #{patientID}</if>
            <if test="opreationTime != null  and opreationTime != ''">and OpreationTime = #{opreationTime}</if>
            <if test="episodeID != null  and episodeID != ''">and EpisodeID = #{episodeID}</if>
            <if test="outMedNO != null  and outMedNO != ''">and OutMedNO = #{outMedNO}</if>
            <if test="inMedNO != null  and inMedNO != ''">and InMedNO = #{inMedNO}</if>
            <if test="visitNum != null  and visitNum != ''">and VisitNum = #{visitNum}</if>
            <if test="admTypeCode != null  and admTypeCode != ''">and AdmTypeCode = #{admTypeCode}</if>
            <if test="admTypeDesc != null  and admTypeDesc != ''">and AdmTypeDesc = #{admTypeDesc}</if>
            <if test="admStatus != null  and admStatus != ''">and AdmStatus = #{admStatus}</if>
            <if test="admDate != null  and admDate != ''">and AdmDate = #{admDate}</if>
            <if test="encPatName != null  and encPatName != ''">and EncPatName like concat('%', #{encPatName}, '%')</if>
            <if test="encPatGender != null  and encPatGender != ''">and EncPatGender = #{encPatGender}</if>
            <if test="encPatBirthDate != null  and encPatBirthDate != ''">and EncPatBirthDate = #{encPatBirthDate}</if>
            <if test="transferstart != null  and transferstart != ''">and Transferstart = #{transferstart}</if>
            <if test="transferend != null  and transferend != ''">and Transferend = #{transferend}</if>
            <if test="encPatMaritalStatus != null  and encPatMaritalStatus != ''">and EncPatMaritalStatus =
                #{encPatMaritalStatus}
            </if>
            <if test="originalText != null  and originalText != ''">and OriginalText = #{originalText}</if>
            <if test="encDocList != null  and encDocList != ''">and EncDocList = #{encDocList}</if>
            <if test="encAdmLocList != null  and encAdmLocList != ''">and EncAdmLocList = #{encAdmLocList}</if>
            <if test="encounterPeriodStart != null  and encounterPeriodStart != ''">and Encounter_period_start =
                #{encounterPeriodStart}
            </if>
            <if test="encounterPeriodEnd != null  and encounterPeriodEnd != ''">and Encounter_period_end =
                #{encounterPeriodEnd}
            </if>
            <if test="encounterBooktime != null  and encounterBooktime != ''">and Encounter_booktime =
                #{encounterBooktime}
            </if>
            <if test="encAdmSource != null  and encAdmSource != ''">and EncAdmSource = #{encAdmSource}</if>
            <if test="encInhostype != null  and encInhostype != ''">and EncInhostype = #{encInhostype}</if>
            <if test="encDietName != null  and encDietName != ''">and EncDietName like concat('%', #{encDietName},
                '%')
            </if>
            <if test="encOuthostype != null  and encOuthostype != ''">and EncOuthostype = #{encOuthostype}</if>
            <if test="encVisitnum != null  and encVisitnum != ''">and EncVisitnum = #{encVisitnum}</if>
            <if test="encChargeType != null  and encChargeType != ''">and EncChargeType = #{encChargeType}</if>
            <if test="encChargeTypeName != null  and encChargeTypeName != ''">and EncChargeTypeName like concat('%',
                #{encChargeTypeName}, '%')
            </if>
            <if test="encChargeCode != null  and encChargeCode != ''">and EncChargeCode = #{encChargeCode}</if>
            <if test="encChargeName != null  and encChargeName != ''">and EncChargeName like concat('%',
                #{encChargeName}, '%')
            </if>
            <if test="encReglevelcode != null  and encReglevelcode != ''">and EncReglevelcode = #{encReglevelcode}</if>
            <if test="encCareLevel != null  and encCareLevel != ''">and EncCareLevel = #{encCareLevel}</if>
            <if test="specialday != null  and specialday != ''">and Specialday = #{specialday}</if>
            <if test="primaryday != null  and primaryday != ''">and Primaryday = #{primaryday}</if>
            <if test="secondaryday != null  and secondaryday != ''">and Secondaryday = #{secondaryday}</if>
            <if test="tertiaryday != null  and tertiaryday != ''">and Tertiaryday = #{tertiaryday}</if>
            <if test="enroomno != null  and enroomno != ''">and Enroomno = #{enroomno}</if>
            <if test="enBedno != null  and enBedno != ''">and EnBedno = #{enBedno}</if>
            <if test="encSeeno != null  and encSeeno != ''">and EncSeeno = #{encSeeno}</if>
            <if test="encAgeUnit != null  and encAgeUnit != ''">and EncAgeUnit = #{encAgeUnit}</if>
            <if test="encAgeValue != null  and encAgeValue != ''">and EncAgeValue = #{encAgeValue}</if>
            <if test="enIsbaby != null  and enIsbaby != ''">and EnIsbaby = #{enIsbaby}</if>
            <if test="encHavebaby != null  and encHavebaby != ''">and EncHavebaby = #{encHavebaby}</if>
            <if test="encDiagList != null  and encDiagList != ''">and EncDiagList = #{encDiagList}</if>
            <if test="directorCode != null  and directorCode != ''">and DirectorCode = #{directorCode}</if>
            <if test="directorName != null  and directorName != ''">and DirectorName like concat('%', #{directorName},
                '%')
            </if>
            <if test="dncDiagnosisCode != null  and dncDiagnosisCode != ''">and EncDiagnosisCode = #{dncDiagnosisCode}
            </if>
            <if test="encDiagnosisDesc != null  and encDiagnosisDesc != ''">and EncDiagnosisDesc = #{encDiagnosisDesc}
            </if>
            <if test="encAdmLocCode != null  and encAdmLocCode != ''">and EncAdmLocCode = #{encAdmLocCode}</if>
            <if test="encAdmLocName != null  and encAdmLocName != ''">and EncAdmLocName like concat('%',
                #{encAdmLocName}, '%')
            </if>
            <if test="taskStatus != null  and taskStatus != ''">and taskStatus = #{taskStatus}</if>
        </where>
    </select>

    <select id="selectHospitalRecordByID" parameterType="String" resultMap="HospitalRecordResult">
        <include refid="selectHospitalRecordVo"/>
        where ID = #{ID}
    </select>

    <insert id="insertHospitalRecord" parameterType="com.smartor.domain.HospitalRecord">
        insert into hospital_record
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="ID != null">ID,</if>
            <if test="sourceSystem != null">SourceSystem,</if>
            <if test="messageID != null">MessageID,</if>
            <if test="createTime != null">CreateTime,</if>
            <if test="methodName != null">MethodName,</if>
            <if test="reqIimRules != null">ReqIimRules,</if>
            <if test="patientID != null">PatientID,</if>
            <if test="opreationTime != null">OpreationTime,</if>
            <if test="episodeID != null">EpisodeID,</if>
            <if test="outMedNO != null">OutMedNO,</if>
            <if test="inMedNO != null">InMedNO,</if>
            <if test="visitNum != null">VisitNum,</if>
            <if test="admTypeCode != null">AdmTypeCode,</if>
            <if test="admTypeDesc != null">AdmTypeDesc,</if>
            <if test="admStatus != null">AdmStatus,</if>
            <if test="admDate != null">AdmDate,</if>
            <if test="encPatName != null">EncPatName,</if>
            <if test="encPatGender != null">EncPatGender,</if>
            <if test="encPatBirthDate != null">EncPatBirthDate,</if>
            <if test="transferstart != null">Transferstart,</if>
            <if test="transferend != null">Transferend,</if>
            <if test="encPatMaritalStatus != null">EncPatMaritalStatus,</if>
            <if test="originalText != null">OriginalText,</if>
            <if test="encDocList != null">EncDocList,</if>
            <if test="encAdmLocList != null">EncAdmLocList,</if>
            <if test="encounterPeriodStart != null">Encounter_period_start,</if>
            <if test="encounterPeriodEnd != null">Encounter_period_end,</if>
            <if test="encounterBooktime != null">Encounter_booktime,</if>
            <if test="encAdmSource != null">EncAdmSource,</if>
            <if test="encInhostype != null">EncInhostype,</if>
            <if test="encDietName != null">EncDietName,</if>
            <if test="encOuthostype != null">EncOuthostype,</if>
            <if test="encVisitnum != null">EncVisitnum,</if>
            <if test="encChargeType != null">EncChargeType,</if>
            <if test="encChargeTypeName != null">EncChargeTypeName,</if>
            <if test="encChargeCode != null">EncChargeCode,</if>
            <if test="encChargeName != null">EncChargeName,</if>
            <if test="encReglevelcode != null">EncReglevelcode,</if>
            <if test="encCareLevel != null">EncCareLevel,</if>
            <if test="specialday != null">Specialday,</if>
            <if test="primaryday != null">Primaryday,</if>
            <if test="secondaryday != null">Secondaryday,</if>
            <if test="tertiaryday != null">Tertiaryday,</if>
            <if test="enroomno != null">Enroomno,</if>
            <if test="enBedno != null">EnBedno,</if>
            <if test="encSeeno != null">EncSeeno,</if>
            <if test="encAgeUnit != null">EncAgeUnit,</if>
            <if test="encAgeValue != null">EncAgeValue,</if>
            <if test="enIsbaby != null">EnIsbaby,</if>
            <if test="encHavebaby != null">EncHavebaby,</if>
            <if test="encDiagList != null">EncDiagList,</if>
            <if test="directorCode != null">DirectorCode,</if>
            <if test="directorName != null">DirectorName,</if>
            <if test="encDiagnosisCode != null">EncDiagnosisCode,</if>
            <if test="encDiagnosisDesc != null">EncDiagnosisDesc,</if>
            <if test="encAdmLocCode != null">EncAdmLocCode,</if>
            <if test="encAdmLocName != null">EncAdmLocName,</if>
            <if test="taskStatus != null">taskStatus,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="ID != null">#{ID},</if>
            <if test="sourceSystem != null">#{sourceSystem},</if>
            <if test="messageID != null">#{messageID},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="methodName != null">#{methodName},</if>
            <if test="reqIimRules != null">#{reqIimRules},</if>
            <if test="patientID != null">#{patientID},</if>
            <if test="opreationTime != null">#{opreationTime},</if>
            <if test="episodeID != null">#{episodeID},</if>
            <if test="outMedNO != null">#{outMedNO},</if>
            <if test="inMedNO != null">#{inMedNO},</if>
            <if test="visitNum != null">#{visitNum},</if>
            <if test="admTypeCode != null">#{admTypeCode},</if>
            <if test="admTypeDesc != null">#{admTypeDesc},</if>
            <if test="admStatus != null">#{admStatus},</if>
            <if test="admDate != null">#{admDate},</if>
            <if test="encPatName != null">#{encPatName},</if>
            <if test="encPatGender != null">#{encPatGender},</if>
            <if test="encPatBirthDate != null">#{encPatBirthDate},</if>
            <if test="transferstart != null">#{transferstart},</if>
            <if test="transferend != null">#{transferend},</if>
            <if test="encPatMaritalStatus != null">#{encPatMaritalStatus},</if>
            <if test="originalText != null">#{originalText},</if>
            <if test="encDocList != null">#{encDocList},</if>
            <if test="encAdmLocList != null">#{encAdmLocList},</if>
            <if test="encounterPeriodStart != null">#{encounterPeriodStart},</if>
            <if test="encounterPeriodEnd != null">#{encounterPeriodEnd},</if>
            <if test="encounterBooktime != null">#{encounterBooktime},</if>
            <if test="encAdmSource != null">#{encAdmSource},</if>
            <if test="encInhostype != null">#{encInhostype},</if>
            <if test="encDietName != null">#{encDietName},</if>
            <if test="encOuthostype != null">#{encOuthostype},</if>
            <if test="encVisitnum != null">#{encVisitnum},</if>
            <if test="encChargeType != null">#{encChargeType},</if>
            <if test="encChargeTypeName != null">#{encChargeTypeName},</if>
            <if test="encChargeCode != null">#{encChargeCode},</if>
            <if test="encChargeName != null">#{encChargeName},</if>
            <if test="encReglevelcode != null">#{encReglevelcode},</if>
            <if test="encCareLevel != null">#{encCareLevel},</if>
            <if test="specialday != null">#{specialday},</if>
            <if test="primaryday != null">#{primaryday},</if>
            <if test="secondaryday != null">#{secondaryday},</if>
            <if test="tertiaryday != null">#{tertiaryday},</if>
            <if test="enroomno != null">#{enroomno},</if>
            <if test="enBedno != null">#{enBedno},</if>
            <if test="encSeeno != null">#{encSeeno},</if>
            <if test="encAgeUnit != null">#{encAgeUnit},</if>
            <if test="encAgeValue != null">#{encAgeValue},</if>
            <if test="enIsbaby != null">#{enIsbaby},</if>
            <if test="encHavebaby != null">#{encHavebaby},</if>
            <if test="encDiagList != null">#{encDiagList},</if>
            <if test="directorCode != null">#{directorCode},</if>
            <if test="directorName != null">#{directorName},</if>
            <if test="encDiagnosisCode != null">#{encDiagnosisCode},</if>
            <if test="encDiagnosisDesc != null">#{encDiagnosisDesc},</if>
            <if test="encAdmLocCode != null">#{encAdmLocCode},</if>
            <if test="encAdmLocName != null">#{encAdmLocName},</if>
            <if test="taskStatus != null">#{taskStatus},</if>
        </trim>
    </insert>

    <update id="updateHospitalRecord" parameterType="com.smartor.domain.HospitalRecord">
        update hospital_record
        <trim prefix="SET" suffixOverrides=",">
            <if test="SourceSystem != null">SourceSystem = #{SourceSystem},</if>
            <if test="MessageID != null">MessageID = #{MessageID},</if>
            <if test="CreateTime != null">CreateTime = #{CreateTime},</if>
            <if test="MethodName != null">MethodName = #{MethodName},</if>
            <if test="ReqIimRules != null">ReqIimRules = #{ReqIimRules},</if>
            <if test="PatientID != null">PatientID = #{PatientID},</if>
            <if test="OpreationTime != null">OpreationTime = #{OpreationTime},</if>
            <if test="EpisodeID != null">EpisodeID = #{EpisodeID},</if>
            <if test="OutMedNO != null">OutMedNO = #{OutMedNO},</if>
            <if test="InMedNO != null">InMedNO = #{InMedNO},</if>
            <if test="VisitNum != null">VisitNum = #{VisitNum},</if>
            <if test="AdmTypeCode != null">AdmTypeCode = #{AdmTypeCode},</if>
            <if test="AdmTypeDesc != null">AdmTypeDesc = #{AdmTypeDesc},</if>
            <if test="AdmStatus != null">AdmStatus = #{AdmStatus},</if>
            <if test="AdmDate != null">AdmDate = #{AdmDate},</if>
            <if test="EncPatName != null">EncPatName = #{EncPatName},</if>
            <if test="EncPatGender != null">EncPatGender = #{EncPatGender},</if>
            <if test="EncPatBirthDate != null">EncPatBirthDate = #{EncPatBirthDate},</if>
            <if test="Transferstart != null">Transferstart = #{Transferstart},</if>
            <if test="Transferend != null">Transferend = #{Transferend},</if>
            <if test="EncPatMaritalStatus != null">EncPatMaritalStatus = #{EncPatMaritalStatus},</if>
            <if test="OriginalText != null">OriginalText = #{OriginalText},</if>
            <if test="EncDocList != null">EncDocList = #{EncDocList},</if>
            <if test="EncAdmLocList != null">EncAdmLocList = #{EncAdmLocList},</if>
            <if test="encounterPeriodStart != null">Encounter_period_start = #{encounterPeriodStart},</if>
            <if test="encounterPeriodEnd != null">Encounter_period_end = #{encounterPeriodEnd},</if>
            <if test="encounterBooktime != null">Encounter_booktime = #{encounterBooktime},</if>
            <if test="EncAdmSource != null">EncAdmSource = #{EncAdmSource},</if>
            <if test="EncInhostype != null">EncInhostype = #{EncInhostype},</if>
            <if test="EncDietName != null">EncDietName = #{EncDietName},</if>
            <if test="EncOuthostype != null">EncOuthostype = #{EncOuthostype},</if>
            <if test="EncVisitnum != null">EncVisitnum = #{EncVisitnum},</if>
            <if test="EncChargeType != null">EncChargeType = #{EncChargeType},</if>
            <if test="EncChargeTypeName != null">EncChargeTypeName = #{EncChargeTypeName},</if>
            <if test="EncChargeCode != null">EncChargeCode = #{EncChargeCode},</if>
            <if test="EncChargeName != null">EncChargeName = #{EncChargeName},</if>
            <if test="EncReglevelcode != null">EncReglevelcode = #{EncReglevelcode},</if>
            <if test="EncCareLevel != null">EncCareLevel = #{EncCareLevel},</if>
            <if test="Specialday != null">Specialday = #{Specialday},</if>
            <if test="Primaryday != null">Primaryday = #{Primaryday},</if>
            <if test="Secondaryday != null">Secondaryday = #{Secondaryday},</if>
            <if test="Tertiaryday != null">Tertiaryday = #{Tertiaryday},</if>
            <if test="Enroomno != null">Enroomno = #{Enroomno},</if>
            <if test="EnBedno != null">EnBedno = #{EnBedno},</if>
            <if test="EncSeeno != null">EncSeeno = #{EncSeeno},</if>
            <if test="EncAgeUnit != null">EncAgeUnit = #{EncAgeUnit},</if>
            <if test="EncAgeValue != null">EncAgeValue = #{EncAgeValue},</if>
            <if test="EnIsbaby != null">EnIsbaby = #{EnIsbaby},</if>
            <if test="EncHavebaby != null">EncHavebaby = #{EncHavebaby},</if>
            <if test="EncDiagList != null">EncDiagList = #{EncDiagList},</if>
            <if test="DirectorCode != null">DirectorCode = #{DirectorCode},</if>
            <if test="DirectorName != null">DirectorName = #{DirectorName},</if>
            <if test="EncDiagnosisCode != null">EncDiagnosisCode = #{EncDiagnosisCode},</if>
            <if test="EncDiagnosisDesc != null">EncDiagnosisDesc = #{EncDiagnosisDesc},</if>
            <if test="EncAdmLocCode != null">EncAdmLocCode = #{EncAdmLocCode},</if>
            <if test="EncAdmLocName != null">EncAdmLocName = #{EncAdmLocName},</if>
            <if test="taskStatus != null">taskStatus = #{taskStatus},</if>
        </trim>
        where ID = #{ID}
    </update>

    <delete id="deleteHospitalRecordByID" parameterType="String">
        delete
        from hospital_record
        where ID = #{ID}
    </delete>

    <delete id="deleteHospitalRecordByIDs" parameterType="String">
        delete from hospital_record where ID in
        <foreach item="ID" collection="array" open="(" separator="," close=")">
            #{ID}
        </foreach>
    </delete>
</mapper>

 smartor/src/main/resources/mapper/smartor/HospitalUserinfoMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,562 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.smartor.mapper.HospitalUserinfoMapper">

    <resultMap type="com.smartor.domain.HospitalUserinfo" id="HospitalUserinfoResult">
        <result property="ID" column="ID"/>
        <result property="SourceSystem" column="SourceSystem"/>
        <result property="MessageID" column="MessageID"/>
        <result property="CreateTime" column="CreateTime"/>
        <result property="MethodName" column="MethodName"/>
        <result property="ReqIimRules" column="ReqIimRules"/>
        <result property="PatientID" column="PatientID"/>
        <result property="VisitNum" column="VisitNum"/>
        <result property="RegDate" column="RegDate"/>
        <result property="IdentityID" column="IdentityID"/>
        <result property="PatName" column="PatName"/>
        <result property="Phone" column="Phone"/>
        <result property="PatSex" column="PatSex"/>
        <result property="BirthDate" column="BirthDate"/>
        <result property="Address" column="Address"/>
        <result property="AddProvince" column="AddProvince"/>
        <result property="AddCity" column="AddCity"/>
        <result property="AddCounty" column="AddCounty"/>
        <result property="AddTown" column="AddTown"/>
        <result property="AddVillage" column="AddVillage"/>
        <result property="AddHouseNo" column="AddHouseNo"/>
        <result property="HouseAddress" column="HouseAddress"/>
        <result property="HouseAddProvince" column="HouseAddProvince"/>
        <result property="HouseAddCity" column="HouseAddCity"/>
        <result property="HouseAddCounty" column="HouseAddCounty"/>
        <result property="HouseAddTown" column="HouseAddTown"/>
        <result property="HouseAddVillage" column="HouseAddVillage"/>
        <result property="HouseAddHouseNo" column="HouseAddHouseNo"/>
        <result property="BirthAddress" column="BirthAddress"/>
        <result property="BirthAddProvince" column="BirthAddProvince"/>
        <result property="BirthAddCity" column="BirthAddCity"/>
        <result property="BirthAddCounty" column="BirthAddCounty"/>
        <result property="BirthAddTown" column="BirthAddTown"/>
        <result property="BirthAddVillage" column="BirthAddVillage"/>
        <result property="BirthAddHouseNo" column="BirthAddHouseNo"/>
        <result property="ContactsAddress" column="ContactsAddress"/>
        <result property="ContactsAddProvince" column="ContactsAddProvince"/>
        <result property="ContactsAddCity" column="ContactsAddCity"/>
        <result property="ContactsAddCounty" column="ContactsAddCounty"/>
        <result property="ContactsAddTown" column="ContactsAddTown"/>
        <result property="ContactsAddVillage" column="ContactsAddVillage"/>
        <result property="ContactsAddHouseNo" column="ContactsAddHouseNo"/>
        <result property="NativeAddress" column="NativeAddress"/>
        <result property="NativeAddProvince" column="NativeAddProvince"/>
        <result property="NativeAddCity" column="NativeAddCity"/>
        <result property="NativeAddCounty" column="NativeAddCounty"/>
        <result property="NativeAddTown" column="NativeAddTown"/>
        <result property="NativeAddVillage" column="NativeAddVillage"/>
        <result property="NativeAddHouseNo" column="NativeAddHouseNo"/>
        <result property="PostalCode" column="PostalCode"/>
        <result property="HouseCode" column="HouseCode"/>
        <result property="WorkCode" column="WorkCode"/>
        <result property="MaritalStatus" column="MaritalStatus"/>
        <result property="Country" column="Country"/>
        <result property="Nation" column="Nation"/>
        <result property="NationCode" column="NationCode"/>
        <result property="OccupType" column="OccupType"/>
        <result property="OccupTypeCode" column="OccupTypeCode"/>
        <result property="WorkUnit" column="WorkUnit"/>
        <result property="WorkPhone" column="WorkPhone"/>
        <result property="HCardNo" column="HCardNo"/>
        <result property="HCIssuersCode" column="HCIssuersCode"/>
        <result property="HUrbanCode" column="HUrbanCode"/>
        <result property="MedOrgCode" column="MedOrgCode"/>
        <result property="paycode" column="paycode"/>
        <result property="payname" column="payname"/>
        <result property="ConRelShip" column="ConRelShip"/>
        <result property="ConPerPhone" column="ConPerPhone"/>
        <result property="ConPerName" column="ConPerName"/>
        <result property="RegOrgCode" column="RegOrgCode"/>
        <result property="RegOrgDesc" column="RegOrgDesc"/>
        <result property="InsureOrgName" column="InsureOrgName"/>
        <result property="InsureOrgCode" column="InsureOrgCode"/>
        <result property="RegEmpCode" column="RegEmpCode"/>
        <result property="RegEmpName" column="RegEmpName"/>
        <result property="INEnroomno" column="INEnroomno"/>
        <result property="OUTEnroomno" column="OUTEnroomno"/>
        <result property="EncAdmSource" column="EncAdmSource"/>
        <result property="Directordoc" column="Directordoc"/>
        <result property="Attenddoc" column="Attenddoc"/>
        <result property="Beddoc" column="Beddoc"/>
        <result property="Bednur" column="Bednur"/>
        <result property="Regdoc" column="Regdoc"/>
    </resultMap>

    <sql id="selectHospitalUserinfoVo">
        select ID,
               SourceSystem,
               MessageID,
               CreateTime,
               MethodName,
               ReqIimRules,
               PatientID,
               VisitNum,
               RegDate,
               IdentityID,
               PatName,
               Phone,
               PatSex,
               BirthDate,
               Address,
               AddProvince,
               AddCity,
               AddCounty,
               AddTown,
               AddVillage,
               AddHouseNo,
               HouseAddress,
               HouseAddProvince,
               HouseAddCity,
               HouseAddCounty,
               HouseAddTown,
               HouseAddVillage,
               HouseAddHouseNo,
               BirthAddress,
               BirthAddProvince,
               BirthAddCity,
               BirthAddCounty,
               BirthAddTown,
               BirthAddVillage,
               BirthAddHouseNo,
               ContactsAddress,
               ContactsAddProvince,
               ContactsAddCity,
               ContactsAddCounty,
               ContactsAddTown,
               ContactsAddVillage,
               ContactsAddHouseNo,
               NativeAddress,
               NativeAddProvince,
               NativeAddCity,
               NativeAddCounty,
               NativeAddTown,
               NativeAddVillage,
               NativeAddHouseNo,
               PostalCode,
               HouseCode,
               WorkCode,
               MaritalStatus,
               Country,
               Nation,
               NationCode,
               OccupType,
               OccupTypeCode,
               WorkUnit,
               WorkPhone,
               HCardNo,
               HCIssuersCode,
               HUrbanCode,
               MedOrgCode,
               paycode,
               payname,
               ConRelShip,
               ConPerPhone,
               ConPerName,
               RegOrgCode,
               RegOrgDesc,
               InsureOrgName,
               InsureOrgCode,
               RegEmpCode,
               RegEmpName,
               INEnroomno,
               OUTEnroomno,
               EncAdmSource,
               Directordoc,
               Attenddoc,
               Beddoc,
               Bednur,
               Regdoc
        from hospital_userinfo
    </sql>

    <select id="selectHospitalUserinfoList" parameterType="HospitalUserinfo" resultMap="HospitalUserinfoResult">
        <include refid="selectHospitalUserinfoVo"/>
        <where>
            <if test="SourceSystem != null  and SourceSystem != ''">and SourceSystem = #{SourceSystem}</if>
            <if test="MessageID != null  and MessageID != ''">and MessageID = #{MessageID}</if>
            <if test="CreateTime != null  and CreateTime != ''">and CreateTime = #{CreateTime}</if>
            <if test="MethodName != null  and MethodName != ''">and MethodName like concat('%', #{MethodName}, '%')</if>
            <if test="ReqIimRules != null  and ReqIimRules != ''">and ReqIimRules = #{ReqIimRules}</if>
            <if test="PatientID != null  and PatientID != ''">and PatientID = #{PatientID}</if>
            <if test="VisitNum != null  and VisitNum != ''">and VisitNum = #{VisitNum}</if>
            <if test="RegDate != null  and RegDate != ''">and RegDate = #{RegDate}</if>
            <if test="IdentityID != null  and IdentityID != ''">and IdentityID = #{IdentityID}</if>
            <if test="PatName != null  and PatName != ''">and PatName like concat('%', #{PatName}, '%')</if>
            <if test="Phone != null  and Phone != ''">and Phone = #{Phone}</if>
            <if test="PatSex != null  and PatSex != ''">and PatSex = #{PatSex}</if>
            <if test="BirthDate != null  and BirthDate != ''">and BirthDate = #{BirthDate}</if>
            <if test="Address != null  and Address != ''">and Address = #{Address}</if>
            <if test="AddProvince != null  and AddProvince != ''">and AddProvince = #{AddProvince}</if>
            <if test="AddCity != null  and AddCity != ''">and AddCity = #{AddCity}</if>
            <if test="AddCounty != null  and AddCounty != ''">and AddCounty = #{AddCounty}</if>
            <if test="AddTown != null  and AddTown != ''">and AddTown = #{AddTown}</if>
            <if test="AddVillage != null  and AddVillage != ''">and AddVillage = #{AddVillage}</if>
            <if test="AddHouseNo != null  and AddHouseNo != ''">and AddHouseNo = #{AddHouseNo}</if>
            <if test="HouseAddress != null  and HouseAddress != ''">and HouseAddress = #{HouseAddress}</if>
            <if test="HouseAddProvince != null  and HouseAddProvince != ''">and HouseAddProvince = #{HouseAddProvince}
            </if>
            <if test="HouseAddCity != null  and HouseAddCity != ''">and HouseAddCity = #{HouseAddCity}</if>
            <if test="HouseAddCounty != null  and HouseAddCounty != ''">and HouseAddCounty = #{HouseAddCounty}</if>
            <if test="HouseAddTown != null  and HouseAddTown != ''">and HouseAddTown = #{HouseAddTown}</if>
            <if test="HouseAddVillage != null  and HouseAddVillage != ''">and HouseAddVillage = #{HouseAddVillage}</if>
            <if test="HouseAddHouseNo != null  and HouseAddHouseNo != ''">and HouseAddHouseNo = #{HouseAddHouseNo}</if>
            <if test="BirthAddress != null  and BirthAddress != ''">and BirthAddress = #{BirthAddress}</if>
            <if test="BirthAddProvince != null  and BirthAddProvince != ''">and BirthAddProvince = #{BirthAddProvince}
            </if>
            <if test="BirthAddCity != null  and BirthAddCity != ''">and BirthAddCity = #{BirthAddCity}</if>
            <if test="BirthAddCounty != null  and BirthAddCounty != ''">and BirthAddCounty = #{BirthAddCounty}</if>
            <if test="BirthAddTown != null  and BirthAddTown != ''">and BirthAddTown = #{BirthAddTown}</if>
            <if test="BirthAddVillage != null  and BirthAddVillage != ''">and BirthAddVillage = #{BirthAddVillage}</if>
            <if test="BirthAddHouseNo != null  and BirthAddHouseNo != ''">and BirthAddHouseNo = #{BirthAddHouseNo}</if>
            <if test="ContactsAddress != null  and ContactsAddress != ''">and ContactsAddress = #{ContactsAddress}</if>
            <if test="ContactsAddProvince != null  and ContactsAddProvince != ''">and ContactsAddProvince =
                #{ContactsAddProvince}
            </if>
            <if test="ContactsAddCity != null  and ContactsAddCity != ''">and ContactsAddCity = #{ContactsAddCity}</if>
            <if test="ContactsAddCounty != null  and ContactsAddCounty != ''">and ContactsAddCounty =
                #{ContactsAddCounty}
            </if>
            <if test="ContactsAddTown != null  and ContactsAddTown != ''">and ContactsAddTown = #{ContactsAddTown}</if>
            <if test="ContactsAddVillage != null  and ContactsAddVillage != ''">and ContactsAddVillage =
                #{ContactsAddVillage}
            </if>
            <if test="ContactsAddHouseNo != null  and ContactsAddHouseNo != ''">and ContactsAddHouseNo =
                #{ContactsAddHouseNo}
            </if>
            <if test="NativeAddress != null  and NativeAddress != ''">and NativeAddress = #{NativeAddress}</if>
            <if test="NativeAddProvince != null  and NativeAddProvince != ''">and NativeAddProvince =
                #{NativeAddProvince}
            </if>
            <if test="NativeAddCity != null  and NativeAddCity != ''">and NativeAddCity = #{NativeAddCity}</if>
            <if test="NativeAddCounty != null  and NativeAddCounty != ''">and NativeAddCounty = #{NativeAddCounty}</if>
            <if test="NativeAddTown != null  and NativeAddTown != ''">and NativeAddTown = #{NativeAddTown}</if>
            <if test="NativeAddVillage != null  and NativeAddVillage != ''">and NativeAddVillage = #{NativeAddVillage}
            </if>
            <if test="NativeAddHouseNo != null  and NativeAddHouseNo != ''">and NativeAddHouseNo = #{NativeAddHouseNo}
            </if>
            <if test="PostalCode != null  and PostalCode != ''">and PostalCode = #{PostalCode}</if>
            <if test="HouseCode != null  and HouseCode != ''">and HouseCode = #{HouseCode}</if>
            <if test="WorkCode != null  and WorkCode != ''">and WorkCode = #{WorkCode}</if>
            <if test="MaritalStatus != null  and MaritalStatus != ''">and MaritalStatus = #{MaritalStatus}</if>
            <if test="Country != null  and Country != ''">and Country = #{Country}</if>
            <if test="Nation != null  and Nation != ''">and Nation = #{Nation}</if>
            <if test="NationCode != null  and NationCode != ''">and NationCode = #{NationCode}</if>
            <if test="OccupType != null  and OccupType != ''">and OccupType = #{OccupType}</if>
            <if test="OccupTypeCode != null  and OccupTypeCode != ''">and OccupTypeCode = #{OccupTypeCode}</if>
            <if test="WorkUnit != null  and WorkUnit != ''">and WorkUnit = #{WorkUnit}</if>
            <if test="WorkPhone != null  and WorkPhone != ''">and WorkPhone = #{WorkPhone}</if>
            <if test="HCardNo != null  and HCardNo != ''">and HCardNo = #{HCardNo}</if>
            <if test="HCIssuersCode != null  and HCIssuersCode != ''">and HCIssuersCode = #{HCIssuersCode}</if>
            <if test="HUrbanCode != null  and HUrbanCode != ''">and HUrbanCode = #{HUrbanCode}</if>
            <if test="MedOrgCode != null  and MedOrgCode != ''">and MedOrgCode = #{MedOrgCode}</if>
            <if test="paycode != null  and paycode != ''">and paycode = #{paycode}</if>
            <if test="payname != null  and payname != ''">and payname like concat('%', #{payname}, '%')</if>
            <if test="ConRelShip != null  and ConRelShip != ''">and ConRelShip = #{ConRelShip}</if>
            <if test="ConPerPhone != null  and ConPerPhone != ''">and ConPerPhone = #{ConPerPhone}</if>
            <if test="ConPerName != null  and ConPerName != ''">and ConPerName like concat('%', #{ConPerName}, '%')</if>
            <if test="RegOrgCode != null  and RegOrgCode != ''">and RegOrgCode = #{RegOrgCode}</if>
            <if test="RegOrgDesc != null  and RegOrgDesc != ''">and RegOrgDesc = #{RegOrgDesc}</if>
            <if test="InsureOrgName != null  and InsureOrgName != ''">and InsureOrgName like concat('%',
                #{InsureOrgName}, '%')
            </if>
            <if test="InsureOrgCode != null  and InsureOrgCode != ''">and InsureOrgCode = #{InsureOrgCode}</if>
            <if test="RegEmpCode != null  and RegEmpCode != ''">and RegEmpCode = #{RegEmpCode}</if>
            <if test="RegEmpName != null  and RegEmpName != ''">and RegEmpName like concat('%', #{RegEmpName}, '%')</if>
            <if test="INEnroomno != null  and INEnroomno != ''">and INEnroomno = #{INEnroomno}</if>
            <if test="OUTEnroomno != null  and OUTEnroomno != ''">and OUTEnroomno = #{OUTEnroomno}</if>
            <if test="EncAdmSource != null  and EncAdmSource != ''">and EncAdmSource = #{EncAdmSource}</if>
            <if test="Directordoc != null  and Directordoc != ''">and Directordoc = #{Directordoc}</if>
            <if test="Attenddoc != null  and Attenddoc != ''">and Attenddoc = #{Attenddoc}</if>
            <if test="Beddoc != null  and Beddoc != ''">and Beddoc = #{Beddoc}</if>
            <if test="Bednur != null  and Bednur != ''">and Bednur = #{Bednur}</if>
            <if test="Regdoc != null  and Regdoc != ''">and Regdoc = #{Regdoc}</if>
        </where>
    </select>

    <select id="selectHospitalUserinfoByID" parameterType="Long" resultMap="HospitalUserinfoResult">
        <include refid="selectHospitalUserinfoVo"/>
        where ID = #{ID}
    </select>

    <insert id="insertHospitalUserinfo" parameterType="com.smartor.domain.HospitalUserinfo" useGeneratedKeys="true" keyProperty="ID">
        insert into hospital_userinfo
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="SourceSystem != null">SourceSystem,</if>
            <if test="MessageID != null">MessageID,</if>
            <if test="CreateTime != null  and CreateTime != ''">CreateTime,</if>
            <if test="MethodName != null">MethodName,</if>
            <if test="ReqIimRules != null">ReqIimRules,</if>
            <if test="PatientID != null">PatientID,</if>
            <if test="VisitNum != null">VisitNum,</if>
            <if test="RegDate != null">RegDate,</if>
            <if test="IdentityID != null">IdentityID,</if>
            <if test="PatName != null">PatName,</if>
            <if test="Phone != null">Phone,</if>
            <if test="PatSex != null">PatSex,</if>
            <if test="BirthDate != null">BirthDate,</if>
            <if test="Address != null">Address,</if>
            <if test="AddProvince != null">AddProvince,</if>
            <if test="AddCity != null">AddCity,</if>
            <if test="AddCounty != null">AddCounty,</if>
            <if test="AddTown != null">AddTown,</if>
            <if test="AddVillage != null">AddVillage,</if>
            <if test="AddHouseNo != null">AddHouseNo,</if>
            <if test="HouseAddress != null">HouseAddress,</if>
            <if test="HouseAddProvince != null">HouseAddProvince,</if>
            <if test="HouseAddCity != null">HouseAddCity,</if>
            <if test="HouseAddCounty != null">HouseAddCounty,</if>
            <if test="HouseAddTown != null">HouseAddTown,</if>
            <if test="HouseAddVillage != null">HouseAddVillage,</if>
            <if test="HouseAddHouseNo != null">HouseAddHouseNo,</if>
            <if test="BirthAddress != null">BirthAddress,</if>
            <if test="BirthAddProvince != null">BirthAddProvince,</if>
            <if test="BirthAddCity != null">BirthAddCity,</if>
            <if test="BirthAddCounty != null">BirthAddCounty,</if>
            <if test="BirthAddTown != null">BirthAddTown,</if>
            <if test="BirthAddVillage != null">BirthAddVillage,</if>
            <if test="BirthAddHouseNo != null">BirthAddHouseNo,</if>
            <if test="ContactsAddress != null">ContactsAddress,</if>
            <if test="ContactsAddProvince != null">ContactsAddProvince,</if>
            <if test="ContactsAddCity != null">ContactsAddCity,</if>
            <if test="ContactsAddCounty != null">ContactsAddCounty,</if>
            <if test="ContactsAddTown != null">ContactsAddTown,</if>
            <if test="ContactsAddVillage != null">ContactsAddVillage,</if>
            <if test="ContactsAddHouseNo != null">ContactsAddHouseNo,</if>
            <if test="NativeAddress != null">NativeAddress,</if>
            <if test="NativeAddProvince != null">NativeAddProvince,</if>
            <if test="NativeAddCity != null">NativeAddCity,</if>
            <if test="NativeAddCounty != null">NativeAddCounty,</if>
            <if test="NativeAddTown != null">NativeAddTown,</if>
            <if test="NativeAddVillage != null">NativeAddVillage,</if>
            <if test="NativeAddHouseNo != null">NativeAddHouseNo,</if>
            <if test="PostalCode != null">PostalCode,</if>
            <if test="HouseCode != null">HouseCode,</if>
            <if test="WorkCode != null">WorkCode,</if>
            <if test="MaritalStatus != null">MaritalStatus,</if>
            <if test="Country != null">Country,</if>
            <if test="Nation != null">Nation,</if>
            <if test="NationCode != null">NationCode,</if>
            <if test="OccupType != null">OccupType,</if>
            <if test="OccupTypeCode != null">OccupTypeCode,</if>
            <if test="WorkUnit != null">WorkUnit,</if>
            <if test="WorkPhone != null">WorkPhone,</if>
            <if test="HCardNo != null">HCardNo,</if>
            <if test="HCIssuersCode != null">HCIssuersCode,</if>
            <if test="HUrbanCode != null">HUrbanCode,</if>
            <if test="MedOrgCode != null">MedOrgCode,</if>
            <if test="paycode != null">paycode,</if>
            <if test="payname != null">payname,</if>
            <if test="ConRelShip != null">ConRelShip,</if>
            <if test="ConPerPhone != null">ConPerPhone,</if>
            <if test="ConPerName != null">ConPerName,</if>
            <if test="RegOrgCode != null">RegOrgCode,</if>
            <if test="RegOrgDesc != null">RegOrgDesc,</if>
            <if test="InsureOrgName != null">InsureOrgName,</if>
            <if test="InsureOrgCode != null">InsureOrgCode,</if>
            <if test="RegEmpCode != null">RegEmpCode,</if>
            <if test="RegEmpName != null">RegEmpName,</if>
            <if test="INEnroomno != null">INEnroomno,</if>
            <if test="OUTEnroomno != null">OUTEnroomno,</if>
            <if test="EncAdmSource != null">EncAdmSource,</if>
            <if test="Directordoc != null">Directordoc,</if>
            <if test="Attenddoc != null">Attenddoc,</if>
            <if test="Beddoc != null">Beddoc,</if>
            <if test="Bednur != null">Bednur,</if>
            <if test="Regdoc != null">Regdoc,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="SourceSystem != null">#{SourceSystem},</if>
            <if test="MessageID != null">#{MessageID},</if>
            <if test="CreateTime != null and CreateTime != ''">#{CreateTime},</if>
            <if test="MethodName != null">#{MethodName},</if>
            <if test="ReqIimRules != null">#{ReqIimRules},</if>
            <if test="PatientID != null">#{PatientID},</if>
            <if test="VisitNum != null">#{VisitNum},</if>
            <if test="RegDate != null">#{RegDate},</if>
            <if test="IdentityID != null">#{IdentityID},</if>
            <if test="PatName != null">#{PatName},</if>
            <if test="Phone != null">#{Phone},</if>
            <if test="PatSex != null">#{PatSex},</if>
            <if test="BirthDate != null">#{BirthDate},</if>
            <if test="Address != null">#{Address},</if>
            <if test="AddProvince != null">#{AddProvince},</if>
            <if test="AddCity != null">#{AddCity},</if>
            <if test="AddCounty != null">#{AddCounty},</if>
            <if test="AddTown != null">#{AddTown},</if>
            <if test="AddVillage != null">#{AddVillage},</if>
            <if test="AddHouseNo != null">#{AddHouseNo},</if>
            <if test="HouseAddress != null">#{HouseAddress},</if>
            <if test="HouseAddProvince != null">#{HouseAddProvince},</if>
            <if test="HouseAddCity != null">#{HouseAddCity},</if>
            <if test="HouseAddCounty != null">#{HouseAddCounty},</if>
            <if test="HouseAddTown != null">#{HouseAddTown},</if>
            <if test="HouseAddVillage != null">#{HouseAddVillage},</if>
            <if test="HouseAddHouseNo != null">#{HouseAddHouseNo},</if>
            <if test="BirthAddress != null">#{BirthAddress},</if>
            <if test="BirthAddProvince != null">#{BirthAddProvince},</if>
            <if test="BirthAddCity != null">#{BirthAddCity},</if>
            <if test="BirthAddCounty != null">#{BirthAddCounty},</if>
            <if test="BirthAddTown != null">#{BirthAddTown},</if>
            <if test="BirthAddVillage != null">#{BirthAddVillage},</if>
            <if test="BirthAddHouseNo != null">#{BirthAddHouseNo},</if>
            <if test="ContactsAddress != null">#{ContactsAddress},</if>
            <if test="ContactsAddProvince != null">#{ContactsAddProvince},</if>
            <if test="ContactsAddCity != null">#{ContactsAddCity},</if>
            <if test="ContactsAddCounty != null">#{ContactsAddCounty},</if>
            <if test="ContactsAddTown != null">#{ContactsAddTown},</if>
            <if test="ContactsAddVillage != null">#{ContactsAddVillage},</if>
            <if test="ContactsAddHouseNo != null">#{ContactsAddHouseNo},</if>
            <if test="NativeAddress != null">#{NativeAddress},</if>
            <if test="NativeAddProvince != null">#{NativeAddProvince},</if>
            <if test="NativeAddCity != null">#{NativeAddCity},</if>
            <if test="NativeAddCounty != null">#{NativeAddCounty},</if>
            <if test="NativeAddTown != null">#{NativeAddTown},</if>
            <if test="NativeAddVillage != null">#{NativeAddVillage},</if>
            <if test="NativeAddHouseNo != null">#{NativeAddHouseNo},</if>
            <if test="PostalCode != null">#{PostalCode},</if>
            <if test="HouseCode != null">#{HouseCode},</if>
            <if test="WorkCode != null">#{WorkCode},</if>
            <if test="MaritalStatus != null">#{MaritalStatus},</if>
            <if test="Country != null">#{Country},</if>
            <if test="Nation != null">#{Nation},</if>
            <if test="NationCode != null">#{NationCode},</if>
            <if test="OccupType != null">#{OccupType},</if>
            <if test="OccupTypeCode != null">#{OccupTypeCode},</if>
            <if test="WorkUnit != null">#{WorkUnit},</if>
            <if test="WorkPhone != null">#{WorkPhone},</if>
            <if test="HCardNo != null">#{HCardNo},</if>
            <if test="HCIssuersCode != null">#{HCIssuersCode},</if>
            <if test="HUrbanCode != null">#{HUrbanCode},</if>
            <if test="MedOrgCode != null">#{MedOrgCode},</if>
            <if test="paycode != null">#{paycode},</if>
            <if test="payname != null">#{payname},</if>
            <if test="ConRelShip != null">#{ConRelShip},</if>
            <if test="ConPerPhone != null">#{ConPerPhone},</if>
            <if test="ConPerName != null">#{ConPerName},</if>
            <if test="RegOrgCode != null">#{RegOrgCode},</if>
            <if test="RegOrgDesc != null">#{RegOrgDesc},</if>
            <if test="InsureOrgName != null">#{InsureOrgName},</if>
            <if test="InsureOrgCode != null">#{InsureOrgCode},</if>
            <if test="RegEmpCode != null">#{RegEmpCode},</if>
            <if test="RegEmpName != null">#{RegEmpName},</if>
            <if test="INEnroomno != null">#{INEnroomno},</if>
            <if test="OUTEnroomno != null">#{OUTEnroomno},</if>
            <if test="EncAdmSource != null">#{EncAdmSource},</if>
            <if test="Directordoc != null">#{Directordoc},</if>
            <if test="Attenddoc != null">#{Attenddoc},</if>
            <if test="Beddoc != null">#{Beddoc},</if>
            <if test="Bednur != null">#{Bednur},</if>
            <if test="Regdoc != null">#{Regdoc},</if>
        </trim>
    </insert>

    <update id="updateHospitalUserinfo" parameterType="HospitalUserinfo">
        update hospital_userinfo
        <trim prefix="SET" suffixOverrides=",">
            <if test="SourceSystem != null">SourceSystem = #{SourceSystem},</if>
            <if test="MessageID != null">MessageID = #{MessageID},</if>
            <if test="CreateTime != null">CreateTime = #{CreateTime},</if>
            <if test="MethodName != null">MethodName = #{MethodName},</if>
            <if test="ReqIimRules != null">ReqIimRules = #{ReqIimRules},</if>
            <if test="PatientID != null">PatientID = #{PatientID},</if>
            <if test="VisitNum != null">VisitNum = #{VisitNum},</if>
            <if test="RegDate != null">RegDate = #{RegDate},</if>
            <if test="IdentityID != null">IdentityID = #{IdentityID},</if>
            <if test="PatName != null">PatName = #{PatName},</if>
            <if test="Phone != null">Phone = #{Phone},</if>
            <if test="PatSex != null">PatSex = #{PatSex},</if>
            <if test="BirthDate != null">BirthDate = #{BirthDate},</if>
            <if test="Address != null">Address = #{Address},</if>
            <if test="AddProvince != null">AddProvince = #{AddProvince},</if>
            <if test="AddCity != null">AddCity = #{AddCity},</if>
            <if test="AddCounty != null">AddCounty = #{AddCounty},</if>
            <if test="AddTown != null">AddTown = #{AddTown},</if>
            <if test="AddVillage != null">AddVillage = #{AddVillage},</if>
            <if test="AddHouseNo != null">AddHouseNo = #{AddHouseNo},</if>
            <if test="HouseAddress != null">HouseAddress = #{HouseAddress},</if>
            <if test="HouseAddProvince != null">HouseAddProvince = #{HouseAddProvince},</if>
            <if test="HouseAddCity != null">HouseAddCity = #{HouseAddCity},</if>
            <if test="HouseAddCounty != null">HouseAddCounty = #{HouseAddCounty},</if>
            <if test="HouseAddTown != null">HouseAddTown = #{HouseAddTown},</if>
            <if test="HouseAddVillage != null">HouseAddVillage = #{HouseAddVillage},</if>
            <if test="HouseAddHouseNo != null">HouseAddHouseNo = #{HouseAddHouseNo},</if>
            <if test="BirthAddress != null">BirthAddress = #{BirthAddress},</if>
            <if test="BirthAddProvince != null">BirthAddProvince = #{BirthAddProvince},</if>
            <if test="BirthAddCity != null">BirthAddCity = #{BirthAddCity},</if>
            <if test="BirthAddCounty != null">BirthAddCounty = #{BirthAddCounty},</if>
            <if test="BirthAddTown != null">BirthAddTown = #{BirthAddTown},</if>
            <if test="BirthAddVillage != null">BirthAddVillage = #{BirthAddVillage},</if>
            <if test="BirthAddHouseNo != null">BirthAddHouseNo = #{BirthAddHouseNo},</if>
            <if test="ContactsAddress != null">ContactsAddress = #{ContactsAddress},</if>
            <if test="ContactsAddProvince != null">ContactsAddProvince = #{ContactsAddProvince},</if>
            <if test="ContactsAddCity != null">ContactsAddCity = #{ContactsAddCity},</if>
            <if test="ContactsAddCounty != null">ContactsAddCounty = #{ContactsAddCounty},</if>
            <if test="ContactsAddTown != null">ContactsAddTown = #{ContactsAddTown},</if>
            <if test="ContactsAddVillage != null">ContactsAddVillage = #{ContactsAddVillage},</if>
            <if test="ContactsAddHouseNo != null">ContactsAddHouseNo = #{ContactsAddHouseNo},</if>
            <if test="NativeAddress != null">NativeAddress = #{NativeAddress},</if>
            <if test="NativeAddProvince != null">NativeAddProvince = #{NativeAddProvince},</if>
            <if test="NativeAddCity != null">NativeAddCity = #{NativeAddCity},</if>
            <if test="NativeAddCounty != null">NativeAddCounty = #{NativeAddCounty},</if>
            <if test="NativeAddTown != null">NativeAddTown = #{NativeAddTown},</if>
            <if test="NativeAddVillage != null">NativeAddVillage = #{NativeAddVillage},</if>
            <if test="NativeAddHouseNo != null">NativeAddHouseNo = #{NativeAddHouseNo},</if>
            <if test="PostalCode != null">PostalCode = #{PostalCode},</if>
            <if test="HouseCode != null">HouseCode = #{HouseCode},</if>
            <if test="WorkCode != null">WorkCode = #{WorkCode},</if>
            <if test="MaritalStatus != null">MaritalStatus = #{MaritalStatus},</if>
            <if test="Country != null">Country = #{Country},</if>
            <if test="Nation != null">Nation = #{Nation},</if>
            <if test="NationCode != null">NationCode = #{NationCode},</if>
            <if test="OccupType != null">OccupType = #{OccupType},</if>
            <if test="OccupTypeCode != null">OccupTypeCode = #{OccupTypeCode},</if>
            <if test="WorkUnit != null">WorkUnit = #{WorkUnit},</if>
            <if test="WorkPhone != null">WorkPhone = #{WorkPhone},</if>
            <if test="HCardNo != null">HCardNo = #{HCardNo},</if>
            <if test="HCIssuersCode != null">HCIssuersCode = #{HCIssuersCode},</if>
            <if test="HUrbanCode != null">HUrbanCode = #{HUrbanCode},</if>
            <if test="MedOrgCode != null">MedOrgCode = #{MedOrgCode},</if>
            <if test="paycode != null">paycode = #{paycode},</if>
            <if test="payname != null">payname = #{payname},</if>
            <if test="ConRelShip != null">ConRelShip = #{ConRelShip},</if>
            <if test="ConPerPhone != null">ConPerPhone = #{ConPerPhone},</if>
            <if test="ConPerName != null">ConPerName = #{ConPerName},</if>
            <if test="RegOrgCode != null">RegOrgCode = #{RegOrgCode},</if>
            <if test="RegOrgDesc != null">RegOrgDesc = #{RegOrgDesc},</if>
            <if test="InsureOrgName != null">InsureOrgName = #{InsureOrgName},</if>
            <if test="InsureOrgCode != null">InsureOrgCode = #{InsureOrgCode},</if>
            <if test="RegEmpCode != null">RegEmpCode = #{RegEmpCode},</if>
            <if test="RegEmpName != null">RegEmpName = #{RegEmpName},</if>
            <if test="INEnroomno != null">INEnroomno = #{INEnroomno},</if>
            <if test="OUTEnroomno != null">OUTEnroomno = #{OUTEnroomno},</if>
            <if test="EncAdmSource != null">EncAdmSource = #{EncAdmSource},</if>
            <if test="Directordoc != null">Directordoc = #{Directordoc},</if>
            <if test="Attenddoc != null">Attenddoc = #{Attenddoc},</if>
            <if test="Beddoc != null">Beddoc = #{Beddoc},</if>
            <if test="Bednur != null">Bednur = #{Bednur},</if>
            <if test="Regdoc != null">Regdoc = #{Regdoc},</if>
        </trim>
        where ID = #{ID}
    </update>

    <delete id="deleteHospitalUserinfoByID" parameterType="Long">
        delete
        from hospital_userinfo
        where ID = #{ID}
    </delete>

    <delete id="deleteHospitalUserinfoByIDs" parameterType="String">
        delete from hospital_userinfo where ID in
        <foreach item="ID" collection="array" open="(" separator="," close=")">
            #{ID}
        </foreach>
    </delete>
</mapper>

 smartor/src/main/resources/mapper/smartor/IvrLibaTemplateScriptMapper.xml

@@ -68,6 +68,7 @@
            resultMap="IvrLibaTemplateScriptResult">
        <include refid="selectIvrLibaTemplateScriptVo"/>
        <where>
            del_flag=0
            <if test="templateQuestionNum != null ">and templateQuestionNum = #{templateQuestionNum}</if>
            <if test="templateID != null ">and templateID = #{templateID}</if>
            <if test="questionPoint != null  and questionPoint != ''">and questionPoint = #{questionPoint}</if>
@@ -109,7 +110,7 @@
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateQuestionNum != null">templateQuestionNum,</if>
            <if test="templateID != null">templateID,</if>
            <if test="scriptID != null">scriptID,</if>
            <if test="scriptid != null">scriptID,</if>
            <if test="questionPoint != null and questionPoint != ''">questionPoint,</if>
            <if test="questionText != null">questionText,</if>
            <if test="questionVoice != null">questionVoice,</if>
@@ -143,7 +144,7 @@
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="templateQuestionNum != null">#{templateQuestionNum},</if>
            <if test="templateID != null">#{templateID},</if>
            <if test="scriptID != null">#{scriptID},</if>
            <if test="scriptid != null">#{scriptid},</if>
            <if test="questionPoint != null and questionPoint != ''">#{questionPoint},</if>
            <if test="questionText != null">#{questionText},</if>
            <if test="questionVoice != null">#{questionVoice},</if>
@@ -181,7 +182,7 @@
        <trim prefix="SET" suffixOverrides=",">
            <if test="templateQuestionNum != null">templateQuestionNum = #{templateQuestionNum},</if>
            <if test="templateID != null">templateID = #{templateID},</if>
            <if test="scriptID != null">scriptID = #{scriptID},</if>
            <if test="scriptid != null">scriptID = #{scriptid},</if>
            <if test="questionPoint != null and questionPoint != ''">questionPoint = #{questionPoint},</if>
            <if test="questionText != null">questionText = #{questionText},</if>
            <if test="questionVoice != null">questionVoice = #{questionVoice},</if>

 smartor/src/main/resources/mapper/smartor/IvrLibaTemplateTagMapper.xml

@@ -20,7 +20,7 @@
        <result property="targetid" column="targetid"/>
        <result property="pid" column="pid"/>
        <result property="guid" column="guid"/>
        <result property="guid" column="guid"/>
        <result property="tagname" column="tag_name"/>
    </resultMap>

    <sql id="selectIvrLibaTemplateTagVo">
@@ -38,7 +38,8 @@
               upload_time,
               targetid,
               pid,
               guid
               guid,
               tag_name
        from ivr_liba_template_tag
    </sql>

@@ -46,6 +47,7 @@
            resultMap="IvrLibaTemplateTagResult">
        <include refid="selectIvrLibaTemplateTagVo"/>
        <where>
            del_flag=0
            <if test="tagcategoryid != null ">and tagcategoryid = #{tagcategoryid}</if>
            <if test="templateid != null ">and templateid = #{templateid}</if>
            <if test="tagid != null ">and tagid = #{tagid}</if>
@@ -81,6 +83,7 @@
            <if test="targetid != null">targetid,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
            <if test="tagname != null">tag_name,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">#{tagcategoryid},</if>
@@ -97,6 +100,7 @@
            <if test="targetid != null">#{targetid},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
            <if test="tagname != null">#{tagname},</if>
        </trim>
    </insert>

@@ -117,6 +121,7 @@
            <if test="targetid != null">targetid = #{targetid},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
            <if test="tagname != null">tag_name = #{tagname},</if>
        </trim>
        where id = #{id}
    </update>

 smartor/src/main/resources/mapper/smartor/IvrLibaTemplateTargetoptionMapper.xml

@@ -51,6 +51,7 @@
            resultMap="IvrLibaTemplateTargetoptionResult">
        <include refid="selectIvrLibaTemplateTargetoptionVo"/>
        <where>
            del_flag=0
            <if test="targetid != null ">and targetid = #{targetid}</if>
            <if test="targetname != null ">and targetname = #{targetname}</if>
            <if test="templateID != null ">and templateID = #{templateID}</if>

 smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml

@@ -33,6 +33,7 @@
        <result property="uploadTime" column="upload_time"/>
        <result property="tag" column="tag"/>
        <result property="pattype" column="pattype"/>
        <result property="bedNo" column="bedno"/>
    </resultMap>

    <sql id="selectPatArchiveVo">
@@ -296,7 +297,8 @@
        a.create_time,
        a.isupload,
        a.upload_time,
        a.pattype
        a.pattype,
        d.bedno
        from pat_archive a,pat_archivetag b ,base_tag c,pat_med_inhosp d
        <where>
            a.patid = b.patid and b.tagid = c.tagid and a.patid = d.patid
@@ -405,7 +407,7 @@
        select
        c.tagname as tag,
        b.tagid as tagid,
        a.patid,
        a.patid as id,
        a.name,
        a.sex,
        d.deptname,

 smartor/src/main/resources/mapper/smartor/PatHetaskRelevanceMapper.xml

@@ -6,7 +6,7 @@

    <resultMap type="com.smartor.domain.PatHetaskRelevance" id="PatHetaskRelevanceResult">
        <result property="id" column="id"/>
        <result property="patId" column="pat_id"/>
        <result property="patid" column="pat_id"/>
        <result property="heTaskId" column="he_task_id"/>
        <result property="delFlag" column="del_flag"/>
        <result property="createTime" column="create_time"/>
@@ -15,11 +15,15 @@
        <result property="name" column="name"/>
        <result property="age" column="age"/>
        <result property="sex" column="sex"/>
        <result property="badNo" column="bad_no"/>
        <result property="bedno" column="bed_no"/>
        <result property="dept" column="dept"/>
        <result property="icdName" column="icd_name"/>
        <result property="phone" column="phone"/>
        <result property="medicalRecordNo" column="medical_record_no"/>
        <result property="sendStatus" column="send_status"/>
        <result property="sendTime" column="send_time"/>
        <result property="operatePerson" column="operate_person"/>
        <result property="receiveTime" column="receive_time"/>
    </resultMap>

    <sql id="selectPatHetaskRelevanceVo">
@@ -33,11 +37,15 @@
               name,
               age,
               sex,
               bad_no,
               bed_no,
               dept,
               icd_name,
               phone,
               medical_record_no
               medical_record_no,
               send_status,
               send_time,
               operate_person,
               receive_time
        from pat_hetask_relevance
    </sql>

@@ -46,17 +54,21 @@
        <include refid="selectPatHetaskRelevanceVo"/>
        <where>
            del_flag=0
            <if test="patId != null ">and pat_id = #{patId}</if>
            <if test="patid != null ">and pat_id = #{patid}</if>
            <if test="heTaskId != null ">and he_task_id = #{heTaskId}</if>
            <if test="name != null  and name != ''">and name like concat('%', #{name}, '%')</if>
            <if test="age != null ">and age = #{age}</if>
            <if test="sex != null ">and sex = #{sex}</if>
            <if test="badNo != null ">and bad_no = #{badNo}</if>
            <if test="bedno != null ">and bed_no = #{bedno}</if>
            <if test="dept != null  and dept != ''">and dept = #{dept}</if>
            <if test="phone != null  and phone != ''">and phone = #{phone}</if>
            <if test="medicalRecordNo != null  and medicalRecordNo != ''">and medical_record_no = #{medicalRecordNo}
            </if>
            <if test="icdName != null  and icdName != ''">and icd_name like concat('%', #{icdName}, '%')</if>
            <if test="sendStatus != null ">and send_status = #{sendStatus}</if>
            <if test="sendTime != null ">and send_time = #{sendTime}</if>
            <if test="receiveTime != null ">and receive_time = #{receiveTime}</if>
            <if test="operatePerson != null   and operatePerson != ''">and operate_person = #{operatePerson}</if>
        </where>
    </select>

@@ -68,7 +80,7 @@
    <insert id="insertPatHetaskRelevance" parameterType="com.smartor.domain.PatHetaskRelevance">
        insert into pat_hetask_relevance
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="patId != null">pat_id,</if>
            <if test="patid != null">pat_id,</if>
            <if test="heTaskId != null">he_task_id,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createTime != null">create_time,</if>
@@ -77,14 +89,18 @@
            <if test="name != null">name,</if>
            <if test="age != null">age,</if>
            <if test="sex != null">sex,</if>
            <if test="badNo != null">bad_no,</if>
            <if test="bedno != null">bed_no,</if>
            <if test="dept != null">dept,</if>
            <if test="icdName != null">icd_name,</if>
            <if test="phone != null">phone,</if>
            <if test="medicalRecordNo != null">medical_record_no,</if>
            <if test="sendStatus != null">send_status,</if>
            <if test="sendTime != null">send_time,</if>
            <if test="receiveTime != null">receive_time,</if>
            <if test="operatePerson != null and operatePerson != ''">operate_person,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="patId != null">#{patId},</if>
            <if test="patid != null">#{patid},</if>
            <if test="heTaskId != null">#{heTaskId},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createTime != null">#{createTime},</if>
@@ -93,18 +109,22 @@
            <if test="name != null">#{name},</if>
            <if test="age != null">#{age},</if>
            <if test="sex != null">#{sex},</if>
            <if test="badNo != null">#{badNo},</if>
            <if test="bedno != null">#{bedno},</if>
            <if test="dept != null">#{dept},</if>
            <if test="icdName != null">#{icdName},</if>
            <if test="phone != null">#{phone},</if>
            <if test="medicalRecordNo != null">#{medicalRecordNo},</if>
            <if test="sendStatus != null">#{sendStatus},</if>
            <if test="sendTime != null">#{sendTime},</if>
            <if test="receiveTime != null">#{receiveTime},</if>
            <if test="operatePerson != null and operatePerson != ''">#{operatePerson},</if>
        </trim>
    </insert>

    <update id="updatePatHetaskRelevance" parameterType="com.smartor.domain.PatHetaskRelevance">
        update pat_hetask_relevance
        <trim prefix="SET" suffixOverrides=",">
            <if test="patId != null">pat_id = #{patId},</if>
            <if test="patid != null">pat_id = #{patid},</if>
            <if test="heTaskId != null">he_task_id = #{heTaskId},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
@@ -113,11 +133,15 @@
            <if test="name != null">name = #{name},</if>
            <if test="age != null">age = #{age},</if>
            <if test="sex != null">sex = #{sex},</if>
            <if test="badNo != null">bad_no = #{badNo},</if>
            <if test="bedno != null">bed_no = #{bedno},</if>
            <if test="dept != null">dept = #{dept},</if>
            <if test="icdName != null">icd_name = #{icdName},</if>
            <if test="phone != null">phone = #{phone},</if>
            <if test="medicalRecordNo != null">medical_record_no = #{medicalRecordNo},</if>
            <if test="sendStatus != null">send_status=#{sendStatus},</if>
            <if test="sendTime != null">send_time=#{sendTime},</if>
            <if test="receiveTime != null">receive_time=#{receiveTime},</if>
            <if test="operatePerson != null and operatePerson != ''">operate_person=#{operatePerson},</if>
        </trim>
        where id = #{id}
    </update>

 smartor/src/main/resources/mapper/smartor/ServiceThirdDataMapper.xml

@@ -29,6 +29,7 @@
            <if test="dataInfo != null  and dataInfo != ''">and data_info = #{dataInfo}</if>
            <if test="factory != null  and factory != ''">and factory = #{factory}</if>
            <if test="isDeal != null">and is_deal = #{isDeal}</if>
            <if test="createTime != null ">and create_time &lt;= #{createTime}</if>
        </where>
    </select>

@@ -52,4 +53,52 @@
        </trim>
    </insert>

    <insert id="insertThirdDataZxyzjh" parameterType="com.smartor.domain.ServiceThirdData">
        insert into service_third_data_zxyzjh
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="dataType != null">data_type,</if>
            <if test="dataTypeExplain != null">data_type_explain,</if>
            <if test="dataInfo != null">data_info,</if>
            <if test="factory != null">factory,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isDeal != null">is_deal,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="dataType != null">#{dataType},</if>
            <if test="dataTypeExplain != null">#{dataTypeExplain},</if>
            <if test="dataInfo != null">#{dataInfo},</if>
            <if test="factory != null">#{factory},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isDeal != null">#{isDeal}</if>
        </trim>
    </insert>
    <insert id="insertThirdDataCfxzsq" parameterType="com.smartor.domain.ServiceThirdData">
        insert into service_third_data_cfxzsq
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="dataType != null">data_type,</if>
            <if test="dataTypeExplain != null">data_type_explain,</if>
            <if test="dataInfo != null">data_info,</if>
            <if test="factory != null">factory,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isDeal != null">is_deal,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="dataType != null">#{dataType},</if>
            <if test="dataTypeExplain != null">#{dataTypeExplain},</if>
            <if test="dataInfo != null">#{dataInfo},</if>
            <if test="factory != null">#{factory},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isDeal != null">#{isDeal}</if>
        </trim>
    </insert>


    <update id="updateIsDeal" parameterType="long">
        update service_third_data
        <trim prefix="SET" suffixOverrides=",">
            is_deal=1
        </trim>
        where id = #{id}
    </update>

</mapper>

 smartor/src/main/resources/mapper/smartor/SvyLibTopicMapper.xml

@@ -107,9 +107,9 @@
            <if test="tag != null">tag,</if>
            <if test="svyTopicId != null">svy_topicid,</if>
            <if test="categoryid != null">categoryid,</if>
            <if test="topicContent != null">topic_content,</if>
            <if test="suitway != null">suitway,</if>
            <if test="isavailable != null">isavailable,</if>
            <if test="topicContent != null and topicContent != ''">topic_content,</if>
            <if test="suitway != null and suitway != ''">suitway,</if>
            <if test="isavailable != null and isavailable != ''">isavailable,</if>
            <if test="language != null and language!=''">language,</if>
            <if test="otherdata != null and otherdata!=''">otherdata,</if>
        </trim>
@@ -133,11 +133,11 @@
            <if test="tag != null">#{tag},</if>
            <if test="svyTopicId != null">#{svyTopicId},</if>
            <if test="categoryid != null">#{categoryid},</if>
            <if test="topicContent != null">#{topicContent},</if>
            <if test="suitway != null">#{suitway},</if>
            <if test="isavailable != null">#{isavailable},</if>
            <if test="language != null">#{language},</if>
            <if test="otherdata != null">#{otherdata},</if>
            <if test="topicContent != null and topicContent != ''">#{topicContent},</if>
            <if test="suitway != null  and suitway != ''">#{suitway},</if>
            <if test="isavailable != null and isavailable != ''">#{isavailable},</if>
            <if test="language != null  and language!=''">#{language},</if>
            <if test="otherdata != null and otherdata!=''">#{otherdata},</if>
        </trim>
    </insert>


 smartor/src/main/resources/mapper/smartor/TempDetpRelevanceMapper.xml

@@ -21,6 +21,7 @@
    <select id="selectTempDetpRelevanceList" parameterType="com.smartor.domain.TempDetpRelevance" resultMap="TempDetpRelevanceResult">
        <include refid="selectTempDetpRelevanceVo"/>
        <where>  
            del_flag=0
            <if test="tempid != null "> and tempid = #{tempid}</if>
            <if test="deptId != null "> and dept_id = #{deptId}</if>
            <if test="type != null "> and type = #{type}</if>