患者信息批量上传

liusheng

2023-06-06 e975b2b18607732086feefe522c93b4b8d3391a5

患者信息批量上传

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

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

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

import com.smartor.domain.BaseTag;
import com.smartor.service.IBaseTagService;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * æ ‡ç­¾Controller
 *
 * @author ruoyi
 * @date 2023-06-06
 */
@RestController
@RequestMapping("/base/tag")
public class BaseTagController extends BaseController {
    @Autowired
    private IBaseTagService baseTagService;

    /**
     * æŸ¥è¯¢æ ‡ç­¾åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:tag:list')")
    @GetMapping("/list")
    public TableDataInfo list(BaseTag baseTag) {
        startPage();
        List<BaseTag> list = baseTagService.selectBaseTagList(baseTag);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ ‡ç­¾åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('system:tag:export')")
    @Log(title = "标签", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, BaseTag baseTag) {
        List<BaseTag> list = baseTagService.selectBaseTagList(baseTag);
        ExcelUtil<BaseTag> util = new ExcelUtil<BaseTag>(BaseTag.class);
        util.exportExcel(response, list, "标签数据");
    }

    /**
     * èŽ·å–标签详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:tag:query')")
    @GetMapping(value = "/{tagid}")
    public AjaxResult getInfo(@PathVariable("tagid") Long tagid) {
        return success(baseTagService.selectBaseTagByTagid(tagid));
    }

    /**
     * æ–°å¢žæ ‡ç­¾
     */
    @PreAuthorize("@ss.hasPermi('system:tag:add')")
    @Log(title = "标签", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody BaseTag baseTag) {
        return toAjax(baseTagService.insertBaseTag(baseTag));
    }

    /**
     * ä¿®æ”¹æ ‡ç­¾
     */
    @PreAuthorize("@ss.hasPermi('system:tag:edit')")
    @Log(title = "标签", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody BaseTag baseTag) {
        return toAjax(baseTagService.updateBaseTag(baseTag));
    }

    /**
     * åˆ é™¤æ ‡ç­¾
     */
    @PreAuthorize("@ss.hasPermi('system:tag:remove')")
    @Log(title = "标签", businessType = BusinessType.DELETE)
    @DeleteMapping("/{tagids}")
    public AjaxResult remove(@PathVariable Long[] tagids) {
        return toAjax(baseTagService.deleteBaseTagByTagids(tagids));
    }
}

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

@@ -6,17 +6,13 @@
import com.dingtalk.api.DingTalkClient;
import com.dingtalk.api.request.OapiGettokenRequest;
import com.dingtalk.api.request.OapiMessageCorpconversationAsyncsendV2Request;
import com.dingtalk.api.request.OapiUserGetByMobileRequest;
import com.dingtalk.api.request.OapiUserListidRequest;
import com.dingtalk.api.response.*;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.taobao.api.ApiException;
import org.apache.commons.lang3.StringUtils;

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

public class DingTalkService {


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

@@ -1,17 +1,20 @@
package com.smartor.controller;

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

import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.domain.model.LoginUser;
import com.smartor.domain.PatUpInfoVO;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.bind.annotation.*;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
@@ -20,17 +23,17 @@
import com.smartor.service.IPatArchiveService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;
import org.springframework.web.multipart.MultipartFile;

/**
 * æ‚£è€…档案Controller
 * 
 *
 * @author smartor
 * @date 2023-03-04
 */
@RestController
@RequestMapping("/smartor/patarchive")
public class PatArchiveController extends BaseController
{
public class PatArchiveController extends BaseController {
    @Autowired
    private IPatArchiveService patArchiveService;

@@ -39,8 +42,7 @@
     */
    @PreAuthorize("@ss.hasPermi('smartor:patarchive:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatArchive patArchive)
    {
    public TableDataInfo list(PatArchive patArchive) {
        startPage();
        List<PatArchive> list = patArchiveService.selectPatArchiveList(patArchive);
        return getDataTable(list);
@@ -52,8 +54,7 @@
    @PreAuthorize("@ss.hasPermi('smartor:patarchive:export')")
    @Log(title = "患者档案", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatArchive patArchive)
    {
    public void export(HttpServletResponse response, PatArchive patArchive) {
        List<PatArchive> list = patArchiveService.selectPatArchiveList(patArchive);
        ExcelUtil<PatArchive> util = new ExcelUtil<PatArchive>(PatArchive.class);
        util.exportExcel(response, list, "患者档案数据");
@@ -64,8 +65,7 @@
     */
    @PreAuthorize("@ss.hasPermi('smartor:patarchive:query')")
    @GetMapping(value = "/{patid}")
    public AjaxResult getInfo(@PathVariable("patid") Long patid)
    {
    public AjaxResult getInfo(@PathVariable("patid") Long patid) {
        return success(patArchiveService.selectPatArchiveByPatid(patid));
    }

@@ -75,8 +75,7 @@
    @PreAuthorize("@ss.hasPermi('smartor:patarchive:add')")
    @Log(title = "患者档案", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody PatArchive patArchive)
    {
    public AjaxResult add(@RequestBody PatArchive patArchive) {
        return toAjax(patArchiveService.insertPatArchive(patArchive));
    }

@@ -86,8 +85,7 @@
    @PreAuthorize("@ss.hasPermi('smartor:patarchive:edit')")
    @Log(title = "患者档案", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody PatArchive patArchive)
    {
    public AjaxResult edit(@RequestBody PatArchive patArchive) {
        return toAjax(patArchiveService.updatePatArchive(patArchive));
    }

@@ -96,9 +94,27 @@
     */
    @PreAuthorize("@ss.hasPermi('smartor:patarchive:remove')")
    @Log(title = "患者档案", businessType = BusinessType.DELETE)
    @DeleteMapping("/{patids}")
    public AjaxResult remove(@PathVariable Long[] patids)
    {
    @DeleteMapping("/{patids}")
    public AjaxResult remove(@PathVariable Long[] patids) {
        return toAjax(patArchiveService.deletePatArchiveByPatids(patids));
    }


    /**
     * æ‚£è€…文件处理
     *
     * @param title
     * @param multipartFile
     */
    @PostMapping("/filehandle")
    public AjaxResult fileHandle(@RequestParam("multipartFile") MultipartFile multipartFile) {
        //获取当前登陆人
        LoginUser loginUser = getLoginUser();
        SysUser user = loginUser.getUser();
        String userName = user.getUserName();

        PatUpInfoVO patUpInfoVO = patArchiveService.fileHandle(userName, multipartFile);

        return success(patUpInfoVO);
    }
}

 ruoyi-common/pom.xml

@@ -159,7 +159,10 @@
            <artifactId>alibaba-dingtalk-service-sdk</artifactId>
            <version>2.0.0</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-websocket</artifactId>
        </dependency>
    </dependencies>

</project>

 ruoyi-common/src/main/java/com/ruoyi/common/utils/DtoConversionUtils.java

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

import org.springframework.beans.BeanUtils;

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

/**
 * DTO和entity相互转化工具类
 *
 * @author liusheng
 * @date 2023/5/06
 */
public class DtoConversionUtils {

    /**
     * entity转化为DTO
     *
     * @param source å®žä½“ç±»entity
     * @param target ç›®æ ‡ç±»DTO
     * @return è½¬åŒ–后的DTO
     */
    public static <T> T sourceToTarget(Object source, Class<T> target){
        if(source == null){
            return null;
        }
        T targetObject = null;
        try {
            targetObject = target.newInstance();
            BeanUtils.copyProperties(source, targetObject);
        } catch (Exception e) {
            e.printStackTrace();
        }

        return targetObject;
    }

    /**
     * List<entity>转化为List<DTO>
     *
     * @param sourceList å®žä½“类集合Collection<entity>
     * @param target     ç›®æ ‡ç±»DTO
     * @return è½¬åŒ–后的Collection<DTO>
     */
    public static <T> List<T> sourceToTarget(Collection<?> sourceList, Class<T> target){
        if(sourceList == null){
            return null;
        }

        ArrayList<T> targetList = new ArrayList<>(sourceList.size());
        try {
            for(Object source : sourceList){
                T targetObject = target.newInstance();
                BeanUtils.copyProperties(source, targetObject);
                targetList.add(targetObject);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return targetList;
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,149 @@
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;

/**
 * æ ‡ç­¾å¯¹è±¡ base_tag
 *
 * @author ruoyi
 * @date 2023-06-02
 */
public class BaseTag extends BaseEntity {
    private static final long serialVersionUID = 1L;

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

    /**
     * æ ‡ç­¾åˆ†ç±»ID
     */
    @Excel(name = " æ ‡ç­¾åˆ†ç±»ID ")
    private Long tagcategoryid;

    /**
     * æ ‡ç­¾åç§°
     */
    @Excel(name = " æ ‡ç­¾åç§° ")
    private String tagname;

    /**
     * æ ‡ç­¾æè¿°
     */
    @Excel(name = " æ ‡ç­¾æè¿° ")
    private String tagdescription;

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

    /**
     * åˆ é™¤æ ‡è®°
     */
    private String delFlag;

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

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

    /**
     * æ˜¯å¦å¼€å¯
     */
    @Excel(name = " æ˜¯å¦å¼€å¯ ")
    private Long isenable;

    public void setTagid(Long tagid) {
        this.tagid = tagid;
    }

    public Long getTagid() {
        return tagid;
    }

    public void setTagcategoryid(Long tagcategoryid) {
        this.tagcategoryid = tagcategoryid;
    }

    public Long getTagcategoryid() {
        return tagcategoryid;
    }

    public void setTagname(String tagname) {
        this.tagname = tagname;
    }

    public String getTagname() {
        return tagname;
    }

    public void setTagdescription(String tagdescription) {
        this.tagdescription = tagdescription;
    }

    public String getTagdescription() {
        return tagdescription;
    }

    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 setIsenable(Long isenable) {
        this.isenable = isenable;
    }

    public Long getIsenable() {
        return isenable;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE).append("tagid", getTagid()).append("tagcategoryid", getTagcategoryid()).append("tagname", getTagname()).append("tagdescription", getTagdescription()).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("isenable", getIsenable()).toString();
    }
}

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

@@ -24,7 +24,7 @@
    @Excel(name = " å§“名 ")
    private String name;

    /**  æ€§åˆ«  */
    /**  æ€§åˆ«  1:男 2:女*/
    @Excel(name = " æ€§åˆ« ")
    private Long sex;


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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,141 @@
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_archivetag
 * 
 * @author ruoyi
 * @date 2023-06-02
 */
public class PatArchivetag extends BaseEntity
{
    private static final long serialVersionUID = 1L;

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

    /**  æ ‡ç­¾åˆ†ç±»ID  */
    @Excel(name = " æ ‡ç­¾åˆ†ç±»ID ")
    private Long tagcategoryid;

    /**  æ ‡ç­¾ID  */
    @Excel(name = " æ ‡ç­¾ID ")
    private Long tagid;

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

    /**  åˆ é™¤æ ‡è®°  */
    private String delFlag;

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

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

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

    public void setId(Long id) 
    {
        this.id = id;
    }

    public Long getId() 
    {
        return id;
    }
    public void setTagcategoryid(Long tagcategoryid) 
    {
        this.tagcategoryid = tagcategoryid;
    }

    public Long getTagcategoryid() 
    {
        return tagcategoryid;
    }
    public void setTagid(Long tagid) 
    {
        this.tagid = tagid;
    }

    public Long getTagid() 
    {
        return tagid;
    }
    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 setPatid(Long patid) 
    {
        this.patid = patid;
    }

    public Long getPatid() 
    {
        return patid;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .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/PatUpInfoVO.java

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

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

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

/**
 * æ‚£è€…错误信息返回
 *
 * @author åˆ˜çœ
 * @date 2023-06-06
 */
@Data
public class PatUpInfoVO {

    /**
     * æˆåŠŸæ•°é‡
     */
    private Integer successNum;

    /**
     * å¤±è´¥æ•°é‡
     */
    private Integer failNum;

    /**
     * å¤±è´¥æ‚£è€…集合
     */
    private List<PatArchive> patArchiveList;
}

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

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

public class PatientManageDto {
}

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

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

import java.util.List;

import com.smartor.domain.BaseTag;
import org.apache.ibatis.annotations.Mapper;

/**
 * æ ‡ç­¾Mapper接口
 *
 * @author ruoyi
 * @date 2023-06-02
 */
@Mapper
public interface BaseTagMapper {
    /**
     * æŸ¥è¯¢æ ‡ç­¾
     *
     * @param tagid æ ‡ç­¾ä¸»é”®
     * @return æ ‡ç­¾
     */
    public BaseTag selectBaseTagByTagid(Long tagid);

    /**
     * æŸ¥è¯¢æ ‡ç­¾åˆ—表
     *
     * @param baseTag æ ‡ç­¾
     * @return æ ‡ç­¾é›†åˆ
     */
    public List<BaseTag> selectBaseTagList(BaseTag baseTag);

    /**
     * æ–°å¢žæ ‡ç­¾
     *
     * @param baseTag æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int insertBaseTag(BaseTag baseTag);

    /**
     * ä¿®æ”¹æ ‡ç­¾
     *
     * @param baseTag æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int updateBaseTag(BaseTag baseTag);

    /**
     * åˆ é™¤æ ‡ç­¾
     *
     * @param tagid æ ‡ç­¾ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteBaseTagByTagid(Long tagid);

    /**
     * æ‰¹é‡åˆ é™¤æ ‡ç­¾
     *
     * @param tagids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteBaseTagByTagids(Long[] tagids);
}

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

@@ -1,19 +1,21 @@
package com.smartor.mapper;

import java.util.List;

import com.smartor.domain.PatArchive;
import org.apache.ibatis.annotations.Mapper;

/**
 * æ‚£è€…档案Mapper接口
 * 
 *
 * @author smartor
 * @date 2023-03-04
 */
public interface PatArchiveMapper 
{
@Mapper
public interface PatArchiveMapper {
    /**
     * æŸ¥è¯¢æ‚£è€…档案
     * 
     *
     * @param patid æ‚£è€…档案主键
     * @return æ‚£è€…档案
     */
@@ -21,7 +23,7 @@

    /**
     * æŸ¥è¯¢æ‚£è€…档案列表
     * 
     *
     * @param patArchive æ‚£è€…档案
     * @return æ‚£è€…档案集合
     */
@@ -29,7 +31,7 @@

    /**
     * æ–°å¢žæ‚£è€…档案
     * 
     *
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
@@ -37,7 +39,7 @@

    /**
     * ä¿®æ”¹æ‚£è€…档案
     * 
     *
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
@@ -45,7 +47,7 @@

    /**
     * åˆ é™¤æ‚£è€…档案
     * 
     *
     * @param patid æ‚£è€…档案主键
     * @return ç»“æžœ
     */
@@ -53,7 +55,7 @@

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…档案
     * 
     *
     * @param patids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */

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

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

import java.util.List;

import com.smartor.domain.PatArchivetag;
import org.apache.ibatis.annotations.Mapper;

/**
 * æ‚£è€…档案标签Mapper接口
 *
 * @author ruoyi
 * @date 2023-06-02
 */
@Mapper
public interface PatArchivetagMapper {
    /**
     * æŸ¥è¯¢æ‚£è€…档案标签
     *
     * @param id æ‚£è€…档案标签主键
     * @return æ‚£è€…档案标签
     */
    public PatArchivetag selectPatArchivetagById(Long id);

    /**
     * æŸ¥è¯¢æ‚£è€…档案标签列表
     *
     * @param patArchivetag æ‚£è€…档案标签
     * @return æ‚£è€…档案标签集合
     */
    public List<PatArchivetag> selectPatArchivetagList(PatArchivetag patArchivetag);

    /**
     * æ–°å¢žæ‚£è€…档案标签
     *
     * @param patArchivetag æ‚£è€…档案标签
     * @return ç»“æžœ
     */
    public int insertPatArchivetag(PatArchivetag patArchivetag);

    /**
     * ä¿®æ”¹æ‚£è€…档案标签
     *
     * @param patArchivetag æ‚£è€…档案标签
     * @return ç»“æžœ
     */
    public int updatePatArchivetag(PatArchivetag patArchivetag);

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

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

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

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

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

/**
 * æ ‡ç­¾Service接口
 * 
 * @author ruoyi
 * @date 2023-06-02
 */
public interface IBaseTagService 
{
    /**
     * æŸ¥è¯¢æ ‡ç­¾
     * 
     * @param tagid æ ‡ç­¾ä¸»é”®
     * @return æ ‡ç­¾
     */
    public BaseTag selectBaseTagByTagid(Long tagid);

    /**
     * æŸ¥è¯¢æ ‡ç­¾åˆ—表
     * 
     * @param baseTag æ ‡ç­¾
     * @return æ ‡ç­¾é›†åˆ
     */
    public List<BaseTag> selectBaseTagList(BaseTag baseTag);

    /**
     * æ–°å¢žæ ‡ç­¾
     * 
     * @param baseTag æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int insertBaseTag(BaseTag baseTag);

    /**
     * ä¿®æ”¹æ ‡ç­¾
     * 
     * @param baseTag æ ‡ç­¾
     * @return ç»“æžœ
     */
    public int updateBaseTag(BaseTag baseTag);

    /**
     * æ‰¹é‡åˆ é™¤æ ‡ç­¾
     * 
     * @param tagids éœ€è¦åˆ é™¤çš„标签主键集合
     * @return ç»“æžœ
     */
    public int deleteBaseTagByTagids(Long[] tagids);

    /**
     * åˆ é™¤æ ‡ç­¾ä¿¡æ¯
     * 
     * @param tagid æ ‡ç­¾ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteBaseTagByTagid(Long tagid);
}

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

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

import java.util.List;

import com.smartor.domain.PatArchive;
import com.smartor.domain.PatUpInfoVO;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;

/**
 * æ‚£è€…档案Service接口
 * 
 *
 * @author smartor
 * @date 2023-03-04
 */
public interface IPatArchiveService 
{
public interface IPatArchiveService {
    /**
     * æŸ¥è¯¢æ‚£è€…档案
     * 
     *
     * @param patid æ‚£è€…档案主键
     * @return æ‚£è€…档案
     */
@@ -21,7 +24,7 @@

    /**
     * æŸ¥è¯¢æ‚£è€…档案列表
     * 
     *
     * @param patArchive æ‚£è€…档案
     * @return æ‚£è€…档案集合
     */
@@ -29,7 +32,7 @@

    /**
     * æ–°å¢žæ‚£è€…档案
     * 
     *
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
@@ -37,7 +40,7 @@

    /**
     * ä¿®æ”¹æ‚£è€…档案
     * 
     *
     * @param patArchive æ‚£è€…档案
     * @return ç»“æžœ
     */
@@ -45,7 +48,7 @@

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…档案
     * 
     *
     * @param patids éœ€è¦åˆ é™¤çš„患者档案主键集合
     * @return ç»“æžœ
     */
@@ -53,9 +56,17 @@

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

    /**
     * æ‚£è€…信息批量插入
     *
     * @param title
     * @param file
     */
    public PatUpInfoVO fileHandle( String username, MultipartFile file);
}

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

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

import java.util.List;

import com.smartor.domain.PatArchivetag;

/**
 * æ‚£è€…档案标签Service接口
 *
 * @author ruoyi
 * @date 2023-06-02
 */
public interface IPatArchivetagService {
    /**
     * æŸ¥è¯¢æ‚£è€…档案标签
     *
     * @param id æ‚£è€…档案标签主键
     * @return æ‚£è€…档案标签
     */
    public PatArchivetag selectPatArchivetagById(Long id);

    /**
     * æŸ¥è¯¢æ‚£è€…档案标签列表
     *
     * @param patArchivetag æ‚£è€…档案标签
     * @return æ‚£è€…档案标签集合
     */
    public List<PatArchivetag> selectPatArchivetagList(PatArchivetag patArchivetag);

    /**
     * æ–°å¢žæ‚£è€…档案标签
     *
     * @param patArchivetag æ‚£è€…档案标签
     * @return ç»“æžœ
     */
    public int insertPatArchivetag(PatArchivetag patArchivetag);

    /**
     * ä¿®æ”¹æ‚£è€…档案标签
     *
     * @param patArchivetag æ‚£è€…档案标签
     * @return ç»“æžœ
     */
    public int updatePatArchivetag(PatArchivetag patArchivetag);

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

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

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

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

import java.util.List;

import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.BaseTag;
import com.smartor.mapper.BaseTagMapper;
import com.smartor.service.IBaseTagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * æ ‡ç­¾Service业务层处理
 *
 * @author ruoyi
 * @date 2023-06-02
 */
@Service
public class BaseTagServiceImpl implements IBaseTagService {
    @Autowired
    private BaseTagMapper baseTagMapper;

    /**
     * æŸ¥è¯¢æ ‡ç­¾
     *
     * @param tagid æ ‡ç­¾ä¸»é”®
     * @return æ ‡ç­¾
     */
    @Override
    public BaseTag selectBaseTagByTagid(Long tagid) {
        return baseTagMapper.selectBaseTagByTagid(tagid);
    }

    /**
     * æŸ¥è¯¢æ ‡ç­¾åˆ—表
     *
     * @param baseTag æ ‡ç­¾
     * @return æ ‡ç­¾
     */
    @Override
    public List<BaseTag> selectBaseTagList(BaseTag baseTag) {
        return baseTagMapper.selectBaseTagList(baseTag);
    }

    /**
     * æ–°å¢žæ ‡ç­¾
     *
     * @param baseTag æ ‡ç­¾
     * @return ç»“æžœ
     */
    @Override
    public int insertBaseTag(BaseTag baseTag) {
        baseTag.setCreateTime(DateUtils.getNowDate());
        return baseTagMapper.insertBaseTag(baseTag);
    }

    /**
     * ä¿®æ”¹æ ‡ç­¾
     *
     * @param baseTag æ ‡ç­¾
     * @return ç»“æžœ
     */
    @Override
    public int updateBaseTag(BaseTag baseTag) {
        baseTag.setUpdateTime(DateUtils.getNowDate());
        return baseTagMapper.updateBaseTag(baseTag);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ ‡ç­¾
     *
     * @param tagids éœ€è¦åˆ é™¤çš„标签主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteBaseTagByTagids(Long[] tagids) {
        return baseTagMapper.deleteBaseTagByTagids(tagids);
    }

    /**
     * åˆ é™¤æ ‡ç­¾ä¿¡æ¯
     *
     * @param tagid æ ‡ç­¾ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteBaseTagByTagid(Long tagid) {
        return baseTagMapper.deleteBaseTagByTagid(tagid);
    }
}

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

@@ -1,96 +1,255 @@
package com.smartor.service.impl;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.DtoConversionUtils;
import com.ruoyi.common.utils.StringUtils;
import com.smartor.domain.BaseTag;
import com.smartor.domain.PatArchivetag;
import com.smartor.domain.PatUpInfoVO;
import com.smartor.mapper.BaseTagMapper;
import com.smartor.mapper.PatArchivetagMapper;
import org.apache.commons.lang3.ObjectUtils;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.smartor.mapper.PatArchiveMapper;
import com.smartor.domain.PatArchive;
import com.smartor.service.IPatArchiveService;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

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

    @Autowired
    private BaseTagMapper baseTagMapper;

    @Autowired
    private PatArchivetagMapper patArchivetagMapper;


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

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

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

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

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

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

    @Override
    @Transactional
    public PatUpInfoVO fileHandle(String username, MultipartFile file) {
        PatUpInfoVO patUpInfoVO = new PatUpInfoVO();
        Integer successNum = 0;
        Integer failNum = 0;

        List<PatArchive> errorpatArchiveList = new ArrayList<>();
        try {
            Workbook workbook = new XSSFWorkbook(file.getInputStream());
            Sheet sheet = workbook.getSheetAt(0);

            for (int i = sheet.getFirstRowNum() + 1; i < sheet.getLastRowNum(); i++) {
                Row row = sheet.getRow(i);
                //如果行为空，进行下一次循环
                if (ObjectUtils.isEmpty(row)) {
                    continue;
                }
                PatArchive patArchive = new PatArchive();
                if (ObjectUtils.isEmpty(row.getCell(3))) {
                    patArchive.setRemark("身份证号为空");
                } else {
                    patArchive.setIccardno(row.getCell(3).toString());
                    //根据身份证，先去患者管理表里看看有没有这个人,如果有这个人，也不需要插入患者表
                    List<PatArchive> patArchiveList1 = patArchiveMapper.selectPatArchiveList(patArchive);
                    if (patArchiveList1.size() > 0) {
                        patArchive.setRemark("该患者已存在");
                    }
                }

                //判断姓名是否为空
                if (ObjectUtils.isEmpty(row.getCell(0))) {
                    patArchive.setRemark(patArchive.getRemark() + "," + "姓名为空");
                    errorpatArchiveList.add(patArchive);
                } else {
                    patArchive.setName(row.getCell(0).toString());
                }

                //判断性别是否为空

                if (ObjectUtils.isEmpty(row.getCell(1))) {
                    patArchive.setRemark(patArchive.getRemark() + "," + "性别为空");
                } else {
                    patArchive.setSex(row.getCell(1).toString().equals("男") ? 1L : 2L);
                }

                //判断证件类型是否为空
                if (ObjectUtils.isEmpty(row.getCell(2))) {
                    patArchive.setRemark("证件类型为空");
                } else {
                    patArchive.setIccardtype(row.getCell(2).toString());
                }

                //判断出生日期是否为空
                if (ObjectUtils.isEmpty(row.getCell(4))) {
                    patArchive.setRemark("出生日期为空");
                } else {
                    //格式转换，转成日期
                    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
                    Date javaDate = new Date();
                    if (row.getCell(4).getCellType().toString().equals("NUMERIC")) {
                        javaDate = HSSFDateUtil.getJavaDate(row.getCell(4).getNumericCellValue());
                    } else {
                        javaDate = new Date(row.getCell(4).toString());
                    }
                    dateFormat.format(javaDate);
                    patArchive.setBirthdate(javaDate);
                }

                //判断本人联系是否为空，和长度是否正确
                if (ObjectUtils.isEmpty(row.getCell(5))) {
                    patArchive.setRemark("本人联系电话为空");
                } else {
                    //格式转换，转成文本
                    if (row.getCell(5).getCellType().toString().equals("NUMERIC")) {
                        String cellData = String.valueOf((long) row.getCell(5).getNumericCellValue());
                        patArchive.setTelcode(cellData);
                    } else {
                        DataFormatter dataFormatter = new DataFormatter();
                        String cellValue = dataFormatter.formatCellValue(row.getCell(5));
                        patArchive.setTelcode(cellValue);
                    }
                }

                //判断亲属联系方式是否为空，长度是否正确
                if (ObjectUtils.isEmpty(row.getCell(6))) {
                    patArchive.setRemark("本人联系电话为空");
                } else {
                    //格式转换，转成文本
                    if (row.getCell(6).getCellType().toString().equals("NUMERIC")) {
                        String cellData = String.valueOf((long) row.getCell(6).getNumericCellValue());
                        patArchive.setRelativetelcode(cellData);
                    } else {
                        DataFormatter dataFormatter = new DataFormatter();
                        String cellValue = dataFormatter.formatCellValue(row.getCell(6));
                        patArchive.setRelativetelcode(cellValue);
                    }
                }

                //患都标签是否为空
                if (ObjectUtils.isEmpty(row.getCell(7))) {
                    patArchive.setRemark("患者标签为空");
                }

                //判断备注是否为空
                if (!StringUtils.isEmpty(patArchive.getRemark())) {
                    //如果备注字段不为空，说有该患者填写有问题
                    errorpatArchiveList.add(patArchive);
                    failNum = failNum + 1;
                    continue;
                }

                //往患者表里新增,并获取到新增ID
                patArchiveMapper.insertPatArchive(patArchive);

                //根据标签名查询出标签信息
                BaseTag baseTag = new BaseTag();
                baseTag.setTagname(row.getCell(7).toString());
                List<BaseTag> baseTags = baseTagMapper.selectBaseTagList(baseTag);
                BaseTag baseTag1 = baseTags.get(0);

                // æ–°å¢žæ‚£è€…档案标签
                PatArchivetag patArchivetag = DtoConversionUtils.sourceToTarget(baseTag1, PatArchivetag.class);
                patArchivetag.setUpdateBy(username);
                patArchivetag.setCreateTime(new Date());
                patArchivetag.setPatid(patArchive.getPatid());
                patArchivetagMapper.insertPatArchivetag(patArchivetag);
                successNum = successNum + 1;
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

        patUpInfoVO.setFailNum(failNum);
        patUpInfoVO.setSuccessNum(successNum);
        patUpInfoVO.setPatArchiveList(errorpatArchiveList);
        return patUpInfoVO;
    }

}


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

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

import java.util.List;
import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.PatArchivetag;
import com.smartor.mapper.PatArchivetagMapper;
import com.smartor.service.IPatArchivetagService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
 * æ‚£è€…档案标签Service业务层处理
 * 
 * @author ruoyi
 * @date 2023-06-02
 */
@Service
public class PatArchivetagServiceImpl implements IPatArchivetagService
{
    @Autowired
    private PatArchivetagMapper patArchivetagMapper;

    /**
     * æŸ¥è¯¢æ‚£è€…档案标签
     * 
     * @param id æ‚£è€…档案标签主键
     * @return æ‚£è€…档案标签
     */
    @Override
    public PatArchivetag selectPatArchivetagById(Long id)
    {
        return patArchivetagMapper.selectPatArchivetagById(id);
    }

    /**
     * æŸ¥è¯¢æ‚£è€…档案标签列表
     * 
     * @param patArchivetag æ‚£è€…档案标签
     * @return æ‚£è€…档案标签
     */
    @Override
    public List<PatArchivetag> selectPatArchivetagList(PatArchivetag patArchivetag)
    {
        return patArchivetagMapper.selectPatArchivetagList(patArchivetag);
    }

    /**
     * æ–°å¢žæ‚£è€…档案标签
     * 
     * @param patArchivetag æ‚£è€…档案标签
     * @return ç»“æžœ
     */
    @Override
    public int insertPatArchivetag(PatArchivetag patArchivetag)
    {
        patArchivetag.setCreateTime(DateUtils.getNowDate());
        return patArchivetagMapper.insertPatArchivetag(patArchivetag);
    }

    /**
     * ä¿®æ”¹æ‚£è€…档案标签
     * 
     * @param patArchivetag æ‚£è€…档案标签
     * @return ç»“æžœ
     */
    @Override
    public int updatePatArchivetag(PatArchivetag patArchivetag)
    {
        patArchivetag.setUpdateTime(DateUtils.getNowDate());
        return patArchivetagMapper.updatePatArchivetag(patArchivetag);
    }

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

    /**
     * åˆ é™¤æ‚£è€…档案标签信息
     * 
     * @param id æ‚£è€…档案标签主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatArchivetagById(Long id)
    {
        return patArchivetagMapper.deletePatArchivetagById(id);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,106 @@
<?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.BaseTagMapper">
    
    <resultMap type="com.smartor.domain.BaseTag" id="BaseTagResult">
        <result property="tagid"    column="tagid"    />
        <result property="tagcategoryid"    column="tagcategoryid"    />
        <result property="tagname"    column="tagname"    />
        <result property="tagdescription"    column="tagdescription"    />
        <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="isenable"    column="isenable"    />
    </resultMap>

    <sql id="selectBaseTagVo">
        select tagid, tagcategoryid, tagname, tagdescription, orgid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, isenable from base_tag
    </sql>

    <select id="selectBaseTagList" parameterType="com.smartor.domain.BaseTag" resultMap="BaseTagResult">
        <include refid="selectBaseTagVo"/>
        <where>  
            <if test="tagcategoryid != null "> and tagcategoryid = #{tagcategoryid}</if>
            <if test="tagname != null  and tagname != ''"> and tagname like concat('%', #{tagname}, '%')</if>
            <if test="tagdescription != null  and tagdescription != ''"> and tagdescription = #{tagdescription}</if>
            <if test="orgid != null  and orgid != ''"> and orgid = #{orgid}</if>
            <if test="isupload != null "> and isupload = #{isupload}</if>
            <if test="uploadTime != null "> and upload_time = #{uploadTime}</if>
            <if test="isenable != null "> and isenable = #{isenable}</if>
        </where>
    </select>
    
    <select id="selectBaseTagByTagid" parameterType="Long" resultMap="BaseTagResult">
        <include refid="selectBaseTagVo"/>
        where tagid = #{tagid}
    </select>
        
    <insert id="insertBaseTag" parameterType="com.smartor.domain.BaseTag" useGeneratedKeys="true" keyProperty="tagid">
        insert into base_tag
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid,</if>
            <if test="tagname != null">tagname,</if>
            <if test="tagdescription != null">tagdescription,</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="isenable != null">isenable,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">#{tagcategoryid},</if>
            <if test="tagname != null">#{tagname},</if>
            <if test="tagdescription != null">#{tagdescription},</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="isenable != null">#{isenable},</if>
         </trim>
    </insert>

    <update id="updateBaseTag" parameterType="com.smartor.domain.BaseTag">
        update base_tag
        <trim prefix="SET" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid = #{tagcategoryid},</if>
            <if test="tagname != null">tagname = #{tagname},</if>
            <if test="tagdescription != null">tagdescription = #{tagdescription},</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="isenable != null">isenable = #{isenable},</if>
        </trim>
        where tagid = #{tagid}
    </update>

    <delete id="deleteBaseTagByTagid" parameterType="Long">
        delete from base_tag where tagid = #{tagid}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,117 @@
<?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.PatArchivetagMapper">

    <resultMap type="com.smartor.domain.PatArchivetag" id="PatArchivetagResult">
        <result property="id" column="id"/>
        <result property="tagcategoryid" column="tagcategoryid"/>
        <result property="tagid" column="tagid"/>
        <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="patid" column="patid"/>
    </resultMap>

    <sql id="selectPatArchivetagVo">
        select id,
               tagcategoryid,
               tagid,
               orgid,
               del_flag,
               update_by,
               update_time,
               create_by,
               create_time,
               isupload,
               upload_time,
               patid
        from pat_archivetag
    </sql>

    <select id="selectPatArchivetagList" parameterType="com.smartor.domain.PatArchivetag"
            resultMap="PatArchivetagResult">
        <include refid="selectPatArchivetagVo"/>
        <where>
            <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>
            <if test="isupload != null ">and isupload = #{isupload}</if>
            <if test="uploadTime != null ">and upload_time = #{uploadTime}</if>
            <if test="patid != null ">and patid = #{patid}</if>
        </where>
    </select>

    <select id="selectPatArchivetagById" parameterType="Long" resultMap="PatArchivetagResult">
        <include refid="selectPatArchivetagVo"/>
        where id = #{id}
    </select>

    <insert id="insertPatArchivetag" parameterType="com.smartor.domain.PatArchivetag" useGeneratedKeys="true"
            keyProperty="id">
        insert into pat_archivetag
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid,</if>
            <if test="tagid != null">tagid,</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="patid != null">patid,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="tagcategoryid != null">#{tagcategoryid},</if>
            <if test="tagid != null">#{tagid},</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="patid != null">#{patid},</if>
        </trim>
    </insert>

    <update id="updatePatArchivetag" parameterType="com.smartor.domain.PatArchivetag">
        update pat_archivetag
        <trim prefix="SET" suffixOverrides=",">
            <if test="tagcategoryid != null">tagcategoryid = #{tagcategoryid},</if>
            <if test="tagid != null">tagid = #{tagid},</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="patid != null">patid = #{patid},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deletePatArchivetagById" parameterType="Long">
        delete
        from pat_archivetag
        where id = #{id}
    </delete>

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