smartor update

qianxj

2023-02-23 0839b96dce23c1e53934dfd1f0ae8c1720ca8dfd

smartor update

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

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

import java.util.List;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * æ‚£è€…档案对象 pat_archive
 * 
 * @author ruoyi
 * @date 2023-02-22
 */
public class PatArchive extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /**  è‡ªå¢žID  */
    private Long PatID;

    /**  å§“名  */
    @Excel(name = " å§“名 ")
    private String Name;

    /**  æ€§åˆ«  */
    @Excel(name = " æ€§åˆ« ")
    private Long Gender;

    /**  è¯ä»¶å·ç   */
    @Excel(name = " è¯ä»¶å·ç  ")
    private String PapersNumber;

    /**  ç”Ÿæ—¥  */
    private Date BirthDate;

    /**  æ¥æº  */
    @Excel(name = " æ¥æº ")
    private Long Source;

    /**  å»ºæ¡£æ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " å»ºæ¡£æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date MakeArchiveTime;

    /**  å»ºæ¡£äºº  */
    private String MakeArchivePeople;

    /**  æ‰‹æœºå·ç   */
    @Excel(name = " æ‰‹æœºå·ç  ")
    private String MobileNumberCode;

    /**  äº²å±žå·ç   */
    private String RelativesNumber;

    /**  è¯ä»¶ç±»åž‹  */
    private String PapersType;

    /**  æœºæž„ID  */
    @Excel(name = " æœºæž„ID ")
    private String OrgID;

    /**  åˆ é™¤æ ‡è®°  */
    @Excel(name = " åˆ é™¤æ ‡è®° ")
    private String delFlag;

    /**  ä¸Šä¼ æ ‡è®°  */
    private Long IsUpload;

    /**  ä¸Šä¼ æ—¶é—´  */
    private Date uploadTime;

    /**  å¹´é¾„  */
    @Excel(name = " å¹´é¾„ ")
    private Long Age;

    /**  å¾®ä¿¡openid  */
    private String OpenId;

    /** æ‚£è€…门诊记录信息 */
    private List<PatMedOuthosp> patMedOuthospList;

    public void setPatID(Long PatID) 
    {
        this.PatID = PatID;
    }

    public Long getPatID() 
    {
        return PatID;
    }
    public void setName(String Name) 
    {
        this.Name = Name;
    }

    public String getName() 
    {
        return Name;
    }
    public void setGender(Long Gender) 
    {
        this.Gender = Gender;
    }

    public Long getGender() 
    {
        return Gender;
    }
    public void setPapersNumber(String PapersNumber) 
    {
        this.PapersNumber = PapersNumber;
    }

    public String getPapersNumber() 
    {
        return PapersNumber;
    }
    public void setBirthDate(Date BirthDate) 
    {
        this.BirthDate = BirthDate;
    }

    public Date getBirthDate() 
    {
        return BirthDate;
    }
    public void setSource(Long Source) 
    {
        this.Source = Source;
    }

    public Long getSource() 
    {
        return Source;
    }
    public void setMakeArchiveTime(Date MakeArchiveTime) 
    {
        this.MakeArchiveTime = MakeArchiveTime;
    }

    public Date getMakeArchiveTime() 
    {
        return MakeArchiveTime;
    }
    public void setMakeArchivePeople(String MakeArchivePeople) 
    {
        this.MakeArchivePeople = MakeArchivePeople;
    }

    public String getMakeArchivePeople() 
    {
        return MakeArchivePeople;
    }
    public void setMobileNumberCode(String MobileNumberCode) 
    {
        this.MobileNumberCode = MobileNumberCode;
    }

    public String getMobileNumberCode() 
    {
        return MobileNumberCode;
    }
    public void setRelativesNumber(String RelativesNumber) 
    {
        this.RelativesNumber = RelativesNumber;
    }

    public String getRelativesNumber() 
    {
        return RelativesNumber;
    }
    public void setPapersType(String PapersType) 
    {
        this.PapersType = PapersType;
    }

    public String getPapersType() 
    {
        return PapersType;
    }
    public void setOrgID(String OrgID) 
    {
        this.OrgID = OrgID;
    }

    public String getOrgID() 
    {
        return OrgID;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsUpload(Long IsUpload) 
    {
        this.IsUpload = IsUpload;
    }

    public Long getIsUpload() 
    {
        return IsUpload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setAge(Long Age) 
    {
        this.Age = Age;
    }

    public Long getAge() 
    {
        return Age;
    }
    public void setOpenId(String OpenId) 
    {
        this.OpenId = OpenId;
    }

    public String getOpenId() 
    {
        return OpenId;
    }

    public List<PatMedOuthosp> getPatMedOuthospList()
    {
        return patMedOuthospList;
    }

    public void setPatMedOuthospList(List<PatMedOuthosp> patMedOuthospList)
    {
        this.patMedOuthospList = patMedOuthospList;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("PatID", getPatID())
            .append("Name", getName())
            .append("Gender", getGender())
            .append("PapersNumber", getPapersNumber())
            .append("BirthDate", getBirthDate())
            .append("Source", getSource())
            .append("MakeArchiveTime", getMakeArchiveTime())
            .append("MakeArchivePeople", getMakeArchivePeople())
            .append("MobileNumberCode", getMobileNumberCode())
            .append("RelativesNumber", getRelativesNumber())
            .append("PapersType", getPapersType())
            .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("Age", getAge())
            .append("OpenId", getOpenId())
            .append("patMedOuthospList", getPatMedOuthospList())
            .toString();
    }
}

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

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

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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;

/**
 * æ‚£è€…门诊记录对象 pat_med_outhosp
 * 
 * @author ruoyi
 * @date 2023-02-22
 */
public class PatMedOuthosp extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /**  è‡ªå¢žID  */
    private Long ID;

    /**  æµæ°´å·  */
    @Excel(name = " æµæ°´å· ")
    private String SerialNum;

    /**  æ¡£æ¡ˆID  */
    @Excel(name = " æ¡£æ¡ˆID ")
    private Long PatID;

    /**  åŒ»é™¢åç§°  */
    @Excel(name = " åŒ»é™¢åç§° ")
    private String HospitalName;

    /**  åŒ»é™¢ç¼–号  */
    @Excel(name = " åŒ»é™¢ç¼–号 ")
    private String HospitalCode;

    /**  è¯Šæ–­ICD值  */
    @Excel(name = " è¯Šæ–­ICD值 ")
    private String Icd10Code;

    /**  è¯Šæ–­åç§°  */
    @Excel(name = " è¯Šæ–­åç§° ")
    private String DiagName;

    /**  ç§‘室代码  */
    @Excel(name = " ç§‘室代码 ")
    private String DeptCode;

    /**  ç§‘室名称  */
    @Excel(name = " ç§‘室名称 ")
    private String DeptName;

    /**  åŒ»ç”Ÿå·¥å·  */
    @Excel(name = " åŒ»ç”Ÿå·¥å· ")
    private String DrCode;

    /**  åŒ»ç”Ÿåç§°  */
    @Excel(name = " åŒ»ç”Ÿåç§° ")
    private String DrName;

    /**  å°±è¯Šæ—¥æœŸ  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " å°±è¯Šæ—¥æœŸ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date AdmitDate;

    /**  æœºæž„ID  */
    @Excel(name = " æœºæž„ID ")
    private String OrgID;

    /**  åˆ é™¤æ ‡è®°  */
    @Excel(name = " åˆ é™¤æ ‡è®° ")
    private String delFlag;

    /**  ä¸Šä¼ æ ‡è®°  */
    @Excel(name = " ä¸Šä¼ æ ‡è®° ")
    private Long IsUpload;

    /**  ä¸Šä¼ æ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " ä¸Šä¼ æ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date uploadTime;

    /**  æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成就诊 9无匹配方案  */
    @Excel(name = " æ˜¯å¦ç”Ÿæˆæ–¹æ¡ˆçŠ¶æ€;0未生成 1生成就诊 9无匹配方案 ")
    private Long SchemeStatus;

    /**  ç§‘室ID  */
    @Excel(name = " ç§‘室ID ")
    private Long DeptID;

    /**  æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = " æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´ ", width = 30, dateFormat = "yyyy-MM-dd")
    private Date SchemeTime;

    /**  çŽ°ç—…史  */
    @Excel(name = " çŽ°ç—…史 ")
    private String HPI;

    /**  ä¸»è¿°  */
    @Excel(name = " ä¸»è¿° ")
    private String MainSuit;

    public void setID(Long ID) 
    {
        this.ID = ID;
    }

    public Long getID() 
    {
        return ID;
    }
    public void setSerialNum(String SerialNum) 
    {
        this.SerialNum = SerialNum;
    }

    public String getSerialNum() 
    {
        return SerialNum;
    }
    public void setPatID(Long PatID) 
    {
        this.PatID = PatID;
    }

    public Long getPatID() 
    {
        return PatID;
    }
    public void setHospitalName(String HospitalName) 
    {
        this.HospitalName = HospitalName;
    }

    public String getHospitalName() 
    {
        return HospitalName;
    }
    public void setHospitalCode(String HospitalCode) 
    {
        this.HospitalCode = HospitalCode;
    }

    public String getHospitalCode() 
    {
        return HospitalCode;
    }
    public void setIcd10Code(String Icd10Code) 
    {
        this.Icd10Code = Icd10Code;
    }

    public String getIcd10Code() 
    {
        return Icd10Code;
    }
    public void setDiagName(String DiagName) 
    {
        this.DiagName = DiagName;
    }

    public String getDiagName() 
    {
        return DiagName;
    }
    public void setDeptCode(String DeptCode) 
    {
        this.DeptCode = DeptCode;
    }

    public String getDeptCode() 
    {
        return DeptCode;
    }
    public void setDeptName(String DeptName) 
    {
        this.DeptName = DeptName;
    }

    public String getDeptName() 
    {
        return DeptName;
    }
    public void setDrCode(String DrCode) 
    {
        this.DrCode = DrCode;
    }

    public String getDrCode() 
    {
        return DrCode;
    }
    public void setDrName(String DrName) 
    {
        this.DrName = DrName;
    }

    public String getDrName() 
    {
        return DrName;
    }
    public void setAdmitDate(Date AdmitDate) 
    {
        this.AdmitDate = AdmitDate;
    }

    public Date getAdmitDate() 
    {
        return AdmitDate;
    }
    public void setOrgID(String OrgID) 
    {
        this.OrgID = OrgID;
    }

    public String getOrgID() 
    {
        return OrgID;
    }
    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }
    public void setIsUpload(Long IsUpload) 
    {
        this.IsUpload = IsUpload;
    }

    public Long getIsUpload() 
    {
        return IsUpload;
    }
    public void setUploadTime(Date uploadTime) 
    {
        this.uploadTime = uploadTime;
    }

    public Date getUploadTime() 
    {
        return uploadTime;
    }
    public void setSchemeStatus(Long SchemeStatus) 
    {
        this.SchemeStatus = SchemeStatus;
    }

    public Long getSchemeStatus() 
    {
        return SchemeStatus;
    }
    public void setDeptID(Long DeptID) 
    {
        this.DeptID = DeptID;
    }

    public Long getDeptID() 
    {
        return DeptID;
    }
    public void setSchemeTime(Date SchemeTime) 
    {
        this.SchemeTime = SchemeTime;
    }

    public Date getSchemeTime() 
    {
        return SchemeTime;
    }
    public void setHPI(String HPI) 
    {
        this.HPI = HPI;
    }

    public String getHPI() 
    {
        return HPI;
    }
    public void setMainSuit(String MainSuit) 
    {
        this.MainSuit = MainSuit;
    }

    public String getMainSuit() 
    {
        return MainSuit;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("ID", getID())
            .append("SerialNum", getSerialNum())
            .append("PatID", getPatID())
            .append("HospitalName", getHospitalName())
            .append("HospitalCode", getHospitalCode())
            .append("Icd10Code", getIcd10Code())
            .append("DiagName", getDiagName())
            .append("DeptCode", getDeptCode())
            .append("DeptName", getDeptName())
            .append("DrCode", getDrCode())
            .append("DrName", getDrName())
            .append("AdmitDate", getAdmitDate())
            .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("SchemeStatus", getSchemeStatus())
            .append("DeptID", getDeptID())
            .append("SchemeTime", getSchemeTime())
            .append("HPI", getHPI())
            .append("MainSuit", getMainSuit())
            .toString();
    }
}

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

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

import java.util.List;
import com.smartor.domain.PatArchive;
import com.smartor.domain.PatMedOuthosp;

/**
 * æ‚£è€…档案Mapper接口
 * 
 * @author ruoyi
 * @date 2023-02-22
 */
public interface PatArchiveMapper 
{
    /**
     * æŸ¥è¯¢æ‚£è€…档案
     * 
     * @param PatID æ‚£è€…档案主键
     * @return æ‚£è€…档案
     */
    public PatArchive selectPatArchiveByPatID(Long PatID);

    /**
     * æŸ¥è¯¢æ‚£è€…档案列表
     * 
     * @param patArchive æ‚£è€…档案
     * @return æ‚£è€…档案集合
     */
    public List<PatArchive> selectPatArchiveList(PatArchive patArchive);

    /**
     * æ–°å¢žæ‚£è€…档案
     * 
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
    public int insertPatArchive(PatArchive patArchive);

    /**
     * ä¿®æ”¹æ‚£è€…档案
     * 
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
    public int updatePatArchive(PatArchive patArchive);

    /**
     * åˆ é™¤æ‚£è€…档案
     * 
     * @param PatID æ‚£è€…档案主键
     * @return ç»“æžœ
     */
    public int deletePatArchiveByPatID(Long PatID);

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…档案
     * 
     * @param PatIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deletePatArchiveByPatIDs(Long[] PatIDs);

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…门诊记录
     * 
     * @param PatIDs éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deletePatMedOuthospByPatIDs(Long[] PatIDs);
    
    /**
     * æ‰¹é‡æ–°å¢žæ‚£è€…门诊记录
     * 
     * @param patMedOuthospList æ‚£è€…门诊记录列表
     * @return ç»“æžœ
     */
    public int batchPatMedOuthosp(List<PatMedOuthosp> patMedOuthospList);
    

    /**
     * é€šè¿‡æ‚£è€…档案主键删除患者门诊记录信息
     * 
     * @param PatID æ‚£è€…档案ID
     * @return ç»“æžœ
     */
    public int deletePatMedOuthospByPatID(Long PatID);
}

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

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

import java.util.List;
import com.smartor.domain.PatArchive;

/**
 * æ‚£è€…档案Service接口
 * 
 * @author ruoyi
 * @date 2023-02-22
 */
public interface IPatArchiveService 
{
    /**
     * æŸ¥è¯¢æ‚£è€…档案
     * 
     * @param PatID æ‚£è€…档案主键
     * @return æ‚£è€…档案
     */
    public PatArchive selectPatArchiveByPatID(Long PatID);

    /**
     * æŸ¥è¯¢æ‚£è€…档案列表
     * 
     * @param patArchive æ‚£è€…档案
     * @return æ‚£è€…档案集合
     */
    public List<PatArchive> selectPatArchiveList(PatArchive patArchive);

    /**
     * æ–°å¢žæ‚£è€…档案
     * 
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
    public int insertPatArchive(PatArchive patArchive);

    /**
     * ä¿®æ”¹æ‚£è€…档案
     * 
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
    public int updatePatArchive(PatArchive patArchive);

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…档案
     * 
     * @param PatIDs éœ€è¦åˆ é™¤çš„患者档案主键集合
     * @return ç»“æžœ
     */
    public int deletePatArchiveByPatIDs(Long[] PatIDs);

    /**
     * åˆ é™¤æ‚£è€…档案信息
     * 
     * @param PatID æ‚£è€…档案主键
     * @return ç»“æžœ
     */
    public int deletePatArchiveByPatID(Long PatID);
}

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

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

import java.util.List;
import com.ruoyi.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import com.ruoyi.common.utils.StringUtils;
import org.springframework.transaction.annotation.Transactional;
import com.smartor.domain.PatMedOuthosp;
import com.smartor.mapper.PatArchiveMapper;
import com.smartor.domain.PatArchive;
import com.smartor.service.IPatArchiveService;

/**
 * æ‚£è€…档案Service业务层处理
 * 
 * @author ruoyi
 * @date 2023-02-22
 */
@Service
public class PatArchiveServiceImpl implements IPatArchiveService 
{
    @Autowired
    private PatArchiveMapper patArchiveMapper;

    /**
     * æŸ¥è¯¢æ‚£è€…档案
     * 
     * @param PatID æ‚£è€…档案主键
     * @return æ‚£è€…档案
     */
    @Override
    public PatArchive selectPatArchiveByPatID(Long PatID)
    {
        return patArchiveMapper.selectPatArchiveByPatID(PatID);
    }

    /**
     * æŸ¥è¯¢æ‚£è€…档案列表
     * 
     * @param patArchive æ‚£è€…档案
     * @return æ‚£è€…档案
     */
    @Override
    public List<PatArchive> selectPatArchiveList(PatArchive patArchive)
    {
        return patArchiveMapper.selectPatArchiveList(patArchive);
    }

    /**
     * æ–°å¢žæ‚£è€…档案
     * 
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
    @Transactional
    @Override
    public int insertPatArchive(PatArchive patArchive)
    {
        patArchive.setCreateTime(DateUtils.getNowDate());
        int rows = patArchiveMapper.insertPatArchive(patArchive);
        insertPatMedOuthosp(patArchive);
        return rows;
    }

    /**
     * ä¿®æ”¹æ‚£è€…档案
     * 
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
    @Transactional
    @Override
    public int updatePatArchive(PatArchive patArchive)
    {
        patArchive.setUpdateTime(DateUtils.getNowDate());
        patArchiveMapper.deletePatMedOuthospByPatID(patArchive.getPatID());
        insertPatMedOuthosp(patArchive);
        return patArchiveMapper.updatePatArchive(patArchive);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…档案
     * 
     * @param PatIDs éœ€è¦åˆ é™¤çš„患者档案主键
     * @return ç»“æžœ
     */
    @Transactional
    @Override
    public int deletePatArchiveByPatIDs(Long[] PatIDs)
    {
        patArchiveMapper.deletePatMedOuthospByPatIDs(PatIDs);
        return patArchiveMapper.deletePatArchiveByPatIDs(PatIDs);
    }

    /**
     * åˆ é™¤æ‚£è€…档案信息
     * 
     * @param PatID æ‚£è€…档案主键
     * @return ç»“æžœ
     */
    @Transactional
    @Override
    public int deletePatArchiveByPatID(Long PatID)
    {
        patArchiveMapper.deletePatMedOuthospByPatID(PatID);
        return patArchiveMapper.deletePatArchiveByPatID(PatID);
    }

    /**
     * æ–°å¢žæ‚£è€…门诊记录信息
     * 
     * @param patArchive æ‚£è€…档案对象
     */
    public void insertPatMedOuthosp(PatArchive patArchive)
    {
        List<PatMedOuthosp> patMedOuthospList = patArchive.getPatMedOuthospList();
        Long PatID = patArchive.getPatID();
        if (StringUtils.isNotNull(patMedOuthospList))
        {
            List<PatMedOuthosp> list = new ArrayList<PatMedOuthosp>();
            for (PatMedOuthosp patMedOuthosp : patMedOuthospList)
            {
                patMedOuthosp.setPatID(PatID);
                list.add(patMedOuthosp);
            }
            if (list.size() > 0)
            {
                patArchiveMapper.batchPatMedOuthosp(list);
            }
        }
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,190 @@
<?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.PatArchiveMapper">
    
    <resultMap type="PatArchive" id="PatArchiveResult">
        <result property="PatID"    column="PatID"    />
        <result property="Name"    column="Name"    />
        <result property="Gender"    column="Gender"    />
        <result property="PapersNumber"    column="PapersNumber"    />
        <result property="BirthDate"    column="BirthDate"    />
        <result property="Source"    column="Source"    />
        <result property="MakeArchiveTime"    column="MakeArchiveTime"    />
        <result property="MakeArchivePeople"    column="MakeArchivePeople"    />
        <result property="MobileNumberCode"    column="MobileNumberCode"    />
        <result property="RelativesNumber"    column="RelativesNumber"    />
        <result property="PapersType"    column="PapersType"    />
        <result property="OrgID"    column="OrgID"    />
        <result property="delFlag"    column="Del_Flag"    />
        <result property="updateBy"    column="Update_By"    />
        <result property="updateTime"    column="Update_Time"    />
        <result property="createBy"    column="Create_By"    />
        <result property="createTime"    column="Create_Time"    />
        <result property="IsUpload"    column="IsUpload"    />
        <result property="uploadTime"    column="Upload_Time"    />
        <result property="Age"    column="Age"    />
        <result property="OpenId"    column="OpenId"    />
    </resultMap>

    <resultMap id="PatArchivePatMedOuthospResult" type="PatArchive" extends="PatArchiveResult">
        <collection property="patMedOuthospList" notNullColumn="sub_ID" javaType="java.util.List" resultMap="PatMedOuthospResult" />
    </resultMap>

    <resultMap type="PatMedOuthosp" id="PatMedOuthospResult">
        <result property="ID"    column="sub_ID"    />
        <result property="SerialNum"    column="sub_SerialNum"    />
        <result property="PatID"    column="sub_PatID"    />
        <result property="HospitalName"    column="sub_HospitalName"    />
        <result property="HospitalCode"    column="sub_HospitalCode"    />
        <result property="Icd10Code"    column="sub_Icd10Code"    />
        <result property="DiagName"    column="sub_DiagName"    />
        <result property="DeptCode"    column="sub_DeptCode"    />
        <result property="DeptName"    column="sub_DeptName"    />
        <result property="DrCode"    column="sub_DrCode"    />
        <result property="DrName"    column="sub_DrName"    />
        <result property="AdmitDate"    column="sub_AdmitDate"    />
        <result property="OrgID"    column="sub_OrgID"    />
        <result property="delFlag"    column="sub_Del_Flag"    />
        <result property="updateBy"    column="sub_Update_By"    />
        <result property="updateTime"    column="sub_Update_Time"    />
        <result property="createBy"    column="sub_Create_By"    />
        <result property="createTime"    column="sub_Create_Time"    />
        <result property="IsUpload"    column="sub_IsUpload"    />
        <result property="uploadTime"    column="sub_Upload_Time"    />
        <result property="SchemeStatus"    column="sub_SchemeStatus"    />
        <result property="DeptID"    column="sub_DeptID"    />
        <result property="SchemeTime"    column="sub_SchemeTime"    />
        <result property="HPI"    column="sub_HPI"    />
        <result property="MainSuit"    column="sub_MainSuit"    />
    </resultMap>

    <sql id="selectPatArchiveVo">
        select PatID, Name, Gender, PapersNumber, BirthDate, Source, MakeArchiveTime, MakeArchivePeople, MobileNumberCode, RelativesNumber, PapersType, OrgID, Del_Flag, Update_By, Update_Time, Create_By, Create_Time, IsUpload, Upload_Time, Age, OpenId from pat_archive
    </sql>

    <select id="selectPatArchiveList" parameterType="PatArchive" resultMap="PatArchiveResult">
        <include refid="selectPatArchiveVo"/>
        <where>  
            <if test="Name != null  and Name != ''"> and Name like concat('%', #{Name}, '%')</if>
            <if test="PapersNumber != null  and PapersNumber != ''"> and PapersNumber = #{PapersNumber}</if>
            <if test="Source != null "> and Source = #{Source}</if>
            <if test="MobileNumberCode != null  and MobileNumberCode != ''"> and MobileNumberCode = #{MobileNumberCode}</if>
            <if test="OrgID != null  and OrgID != ''"> and OrgID = #{OrgID}</if>
            <if test="delFlag != null  and delFlag != ''"> and Del_Flag = #{delFlag}</if>
        </where>
    </select>
    
    <select id="selectPatArchiveByPatID" parameterType="Long" resultMap="PatArchivePatMedOuthospResult">
        select a.PatID, a.Name, a.Gender, a.PapersNumber, a.BirthDate, a.Source, a.MakeArchiveTime, a.MakeArchivePeople, a.MobileNumberCode, a.RelativesNumber, a.PapersType, a.OrgID, a.Del_Flag, a.Update_By, a.Update_Time, a.Create_By, a.Create_Time, a.IsUpload, a.Upload_Time, a.Age, a.OpenId,
 b.ID as sub_ID, b.SerialNum as sub_SerialNum, b.PatID as sub_PatID, b.HospitalName as sub_HospitalName, b.HospitalCode as sub_HospitalCode, b.Icd10Code as sub_Icd10Code, b.DiagName as sub_DiagName, b.DeptCode as sub_DeptCode, b.DeptName as sub_DeptName, b.DrCode as sub_DrCode, b.DrName as sub_DrName, b.AdmitDate as sub_AdmitDate, b.OrgID as sub_OrgID, b.Del_Flag as sub_Del_Flag, b.Update_By as sub_Update_By, b.Update_Time as sub_Update_Time, b.Create_By as sub_Create_By, b.Create_Time as sub_Create_Time, b.IsUpload as sub_IsUpload, b.Upload_Time as sub_Upload_Time, b.SchemeStatus as sub_SchemeStatus, b.DeptID as sub_DeptID, b.SchemeTime as sub_SchemeTime, b.HPI as sub_HPI, b.MainSuit as sub_MainSuit
        from pat_archive a
        left join pat_med_outhosp b on b.PatID = a.PatID
        where a.PatID = #{PatID}
    </select>
        
    <insert id="insertPatArchive" parameterType="PatArchive" useGeneratedKeys="true" keyProperty="PatID">
        insert into pat_archive
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="Name != null">Name,</if>
            <if test="Gender != null">Gender,</if>
            <if test="PapersNumber != null">PapersNumber,</if>
            <if test="BirthDate != null">BirthDate,</if>
            <if test="Source != null">Source,</if>
            <if test="MakeArchiveTime != null">MakeArchiveTime,</if>
            <if test="MakeArchivePeople != null">MakeArchivePeople,</if>
            <if test="MobileNumberCode != null">MobileNumberCode,</if>
            <if test="RelativesNumber != null">RelativesNumber,</if>
            <if test="PapersType != null">PapersType,</if>
            <if test="OrgID != null">OrgID,</if>
            <if test="delFlag != null and delFlag != ''">Del_Flag,</if>
            <if test="updateBy != null">Update_By,</if>
            <if test="updateTime != null">Update_Time,</if>
            <if test="createBy != null">Create_By,</if>
            <if test="createTime != null">Create_Time,</if>
            <if test="IsUpload != null">IsUpload,</if>
            <if test="uploadTime != null">Upload_Time,</if>
            <if test="Age != null">Age,</if>
            <if test="OpenId != null">OpenId,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="Name != null">#{Name},</if>
            <if test="Gender != null">#{Gender},</if>
            <if test="PapersNumber != null">#{PapersNumber},</if>
            <if test="BirthDate != null">#{BirthDate},</if>
            <if test="Source != null">#{Source},</if>
            <if test="MakeArchiveTime != null">#{MakeArchiveTime},</if>
            <if test="MakeArchivePeople != null">#{MakeArchivePeople},</if>
            <if test="MobileNumberCode != null">#{MobileNumberCode},</if>
            <if test="RelativesNumber != null">#{RelativesNumber},</if>
            <if test="PapersType != null">#{PapersType},</if>
            <if test="OrgID != null">#{OrgID},</if>
            <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="IsUpload != null">#{IsUpload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="Age != null">#{Age},</if>
            <if test="OpenId != null">#{OpenId},</if>
         </trim>
    </insert>

    <update id="updatePatArchive" parameterType="PatArchive">
        update pat_archive
        <trim prefix="SET" suffixOverrides=",">
            <if test="Name != null">Name = #{Name},</if>
            <if test="Gender != null">Gender = #{Gender},</if>
            <if test="PapersNumber != null">PapersNumber = #{PapersNumber},</if>
            <if test="BirthDate != null">BirthDate = #{BirthDate},</if>
            <if test="Source != null">Source = #{Source},</if>
            <if test="MakeArchiveTime != null">MakeArchiveTime = #{MakeArchiveTime},</if>
            <if test="MakeArchivePeople != null">MakeArchivePeople = #{MakeArchivePeople},</if>
            <if test="MobileNumberCode != null">MobileNumberCode = #{MobileNumberCode},</if>
            <if test="RelativesNumber != null">RelativesNumber = #{RelativesNumber},</if>
            <if test="PapersType != null">PapersType = #{PapersType},</if>
            <if test="OrgID != null">OrgID = #{OrgID},</if>
            <if test="delFlag != null and delFlag != ''">Del_Flag = #{delFlag},</if>
            <if test="updateBy != null">Update_By = #{updateBy},</if>
            <if test="updateTime != null">Update_Time = #{updateTime},</if>
            <if test="createBy != null">Create_By = #{createBy},</if>
            <if test="createTime != null">Create_Time = #{createTime},</if>
            <if test="IsUpload != null">IsUpload = #{IsUpload},</if>
            <if test="uploadTime != null">Upload_Time = #{uploadTime},</if>
            <if test="Age != null">Age = #{Age},</if>
            <if test="OpenId != null">OpenId = #{OpenId},</if>
        </trim>
        where PatID = #{PatID}
    </update>

    <delete id="deletePatArchiveByPatID" parameterType="Long">
        delete from pat_archive where PatID = #{PatID}
    </delete>

    <delete id="deletePatArchiveByPatIDs" parameterType="String">
        delete from pat_archive where PatID in 
        <foreach item="PatID" collection="array" open="(" separator="," close=")">
            #{PatID}
        </foreach>
    </delete>
    
    <delete id="deletePatMedOuthospByPatIDs" parameterType="String">
        delete from pat_med_outhosp where PatID in 
        <foreach item="patID" collection="array" open="(" separator="," close=")">
            #{patID}
        </foreach>
    </delete>

    <delete id="deletePatMedOuthospByPatID" parameterType="Long">
        delete from pat_med_outhosp where PatID = #{patID}
    </delete>

    <insert id="batchPatMedOuthosp">
        insert into pat_med_outhosp( ID, SerialNum, PatID, HospitalName, HospitalCode, Icd10Code, DiagName, DeptCode, DeptName, DrCode, DrName, AdmitDate, OrgID, Del_Flag, Update_By, Update_Time, Create_By, Create_Time, IsUpload, Upload_Time, SchemeStatus, DeptID, SchemeTime, HPI, MainSuit) values
        <foreach item="item" index="index" collection="list" separator=",">
            ( #{item.ID}, #{item.SerialNum}, #{item.PatID}, #{item.HospitalName}, #{item.HospitalCode}, #{item.Icd10Code}, #{item.DiagName}, #{item.DeptCode}, #{item.DeptName}, #{item.DrCode}, #{item.DrName}, #{item.AdmitDate}, #{item.OrgID}, #{item.delFlag}, #{item.updateBy}, #{item.updateTime}, #{item.createBy}, #{item.createTime}, #{item.IsUpload}, #{item.uploadTime}, #{item.SchemeStatus}, #{item.DeptID}, #{item.SchemeTime}, #{item.HPI}, #{item.MainSuit})
        </foreach>
    </insert>
</mapper>