jeecg 导入、导出 excel

最新推荐文章于 2024-09-13 11:14:40 发布

助助助助助手

最新推荐文章于 2024-09-13 11:14:40 发布

阅读量6.1k

点赞数 6

CC 4.0 BY-SA版权

分类专栏： java 文章标签： excel servlet java

本文链接：https://blog.youkuaiyun.com/qq_39445235/article/details/128430621

java 专栏收录该内容

15 篇文章

订阅专栏

这段代码展示了JeecgBoot项目中QuarantineMemberController、IQuarantineMemberService和QuarantineMemberServiceImpl的实现，用于隔离人员信息的Excel导入和导出。导入功能解析Excel数据并进行业务处理，如身份证转换性别和生日，地址编码转省市区，异常处理等。导出功能根据查询条件生成Excel，包括数据转换和导出配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

jeecg 导入、导出 excel

1.QuarantineMemberController

    /**
    * 导出excel
    *
    * @param request
    * @param quarantineMember
    */
    //@RequiresPermissions("org.jeecg.modules:quarantine_member:exportXls")
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, QuarantineMember quarantineMember) {
//        return super.exportXls(request, quarantineMember, QuarantineMember.class, "quarantine_member");
		return quarantineMemberService.exportingExcel(request, quarantineMember, QuarantineMember.class, "隔离人员");
    }

    /**
      * 通过excel导入数据
    *
    * @param request
    * @param response
    * @return
    */
    //@RequiresPermissions("quarantine_member:importExcel")
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
        return quarantineMemberService.importExcel(request, response);
    }

2.IQuarantineMemberService

package org.jeecg.modules.quarantine.service;

import org.jeecg.common.api.vo.Result;
import org.jeecg.modules.quarantine.entity.QuarantineMember;
import com.baomidou.mybatisplus.extension.service.IService;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * @Description: quarantine_member
 * @Author: jeecg-boot
 * @Date:   2022-11-03
 * @Version: V1.0
 */
public interface IQuarantineMemberService extends IService<QuarantineMember> {
  
    Result<?> importExcel(HttpServletRequest request, HttpServletResponse response);

    ModelAndView exportingExcel(HttpServletRequest request, QuarantineMember quarantineMember, Class<QuarantineMember> quarantineMemberClass, String quarantine_member);

}

3.QuarantineMemberServiceImpl

package org.jeecg.modules.quarantine.service.impl;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.common.util.AreaUtil;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.quarantine.entity.QuarantineMember;
import org.jeecg.modules.quarantine.mapper.QuarantineMemberMapper;
import org.jeecg.modules.quarantine.service.IQuarantineMemberService;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * @Description: quarantine_member
 * @Author: jeecg-boot
 * @Date:   2022-11-03
 * @Version: V1.0
 */
@Service
@Slf4j
public class QuarantineMemberServiceImpl extends ServiceImpl<QuarantineMemberMapper, QuarantineMember> implements IQuarantineMemberService {

    @Autowired
    private QuarantineMemberMapper quarantineMemberMapper;

    /**
     * 导入
     * @param request
     * @param response
     * @return
     */
    @Override
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
        MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
        Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
        JSONArray areaData = AreaUtil.getAreaData();
        for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
            // 获取上传文件对象
            MultipartFile file = entity.getValue();
            if(Objects.requireNonNull(file.getContentType()).indexOf("excel") > 0 || Objects.requireNonNull(file.getContentType()).indexOf("sheet") > 0){
                ImportParams params = new ImportParams();
                params.setTitleRows(1);
                params.setHeadRows(2);
                params.setNeedSave(true);
                try {
                    List<QuarantineMember> list = ExcelImportUtil.importExcel(file.getInputStream(), QuarantineMember.class, params);
                    //update-begin-author:taoyan date:20190528 for:批量插入数据
                    long start = System.currentTimeMillis();
                    for (int i = 0; i < list.size(); i++) {
                        QuarantineMember quarantineMember = list.get(i);
                        quarantineMember.setStatus("1");

                        if (!StringUtils.isNotEmpty(quarantineMember.getName()))
                            return Result.error("文件导入失败: 第" + (i + 1) + "行姓名不能为空");

                        //解析身份证
                        if (quarantineMember.getIdCard().length() == 18) {
                            String bstr = quarantineMember.getIdCard().substring(6, 10)
                                    + "-" + quarantineMember.getIdCard().substring(10, 12)
                                    + "-" + quarantineMember.getIdCard().substring(12, 14);
                            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
                            Date birtaDay = sdf.parse(bstr);
                            quarantineMember.setBirthday(birtaDay);

                            //性别
                            String genderStr = quarantineMember.getIdCard().substring(16, 17);
                            quarantineMember.setSex(Integer.parseInt(genderStr) % 2 == 0 ? "2" : "1");
                        }

//                        家庭地址（省市区 转 编码）
                        String homeProvince = quarantineMember.getHomeProvince();
                        String homeCity = quarantineMember.getHomeCity();
                        String homeArea = quarantineMember.getHomeArea();
                        if (!(StringUtils.isNotEmpty(homeProvince) && StringUtils.isNotEmpty(homeCity) && StringUtils.isNotEmpty(homeArea)))
                            continue;
                        JSONObject provinceJson = AreaUtil.getProvinceByName(homeProvince.trim());
                        if (null == provinceJson)
                            continue;
                        JSONObject cityJson = AreaUtil.getCityByName(provinceJson, homeCity.trim());
                        if (null == cityJson)
                            continue;
                        JSONObject areaJson = AreaUtil.getAreaByName(cityJson, homeArea.trim());
                        if (null == areaJson)
                            continue;
                        String code = areaJson.getString("value");
                        quarantineMember.setHomeAreaCode(code);

//                        风险地区（省市区 转 编码）
                        String sourceProvince = quarantineMember.getSourceProvince();
                        String sourceCity = quarantineMember.getSourceCity();
                        String sourceDistrict = quarantineMember.getSourceDistrict();
                        if (!(StringUtils.isNotEmpty(sourceProvince) && StringUtils.isNotEmpty(sourceCity) && StringUtils.isNotEmpty(sourceDistrict)))
                            continue;
                        JSONObject provinceJson2 = AreaUtil.getProvinceByName(sourceProvince.trim());
                        if (null == provinceJson2)
                            continue;
                        JSONObject cityJson2 = AreaUtil.getCityByName(provinceJson, sourceCity.trim());
                        if (null == cityJson2)
                            continue;
                        JSONObject areaJson2 = AreaUtil.getAreaByName(cityJson, sourceDistrict.trim());
                        if (null == areaJson2)
                            continue;
                        String code2 = areaJson2.getString("value");
                        quarantineMember.setSourceArea(code2);

                    }
                    this.saveBatch(list);
                    //400条 saveBatch消耗时间1592毫秒  循环插入消耗时间1947毫秒
                    //1200条  saveBatch消耗时间3687毫秒 循环插入消耗时间5212毫秒
                    log.info("消耗时间" + (System.currentTimeMillis() - start) + "毫秒");
                    //update-end-author:taoyan date:20190528 for:批量插入数据
                    return Result.ok("文件导入成功！数据行数：" + list.size());
                } catch (Exception e) {
                    //update-begin-author:taoyan date:20211124 for: 导入数据重复增加提示
                    String msg = e.getMessage();
                    log.error(msg, e);
                    if(msg!=null && msg.indexOf("Duplicate entry")>=0){
                        return Result.error("文件导入失败:有重复数据！");
                    }else{
                        return Result.error("文件导入失败:" + e.getMessage());
                    }
                    //update-end-author:taoyan date:20211124 for: 导入数据重复增加提示
                } finally {
                    try {
                        file.getInputStream().close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
            }else{
                return Result.error("文件导入失败:文件格式有误！");
            }

        }
        return Result.error("文件导入失败！");
    }


    @Value("${jeecg.path.upload}")
    private String upLoadPath;

    /**
     * 导出
     * @param request
     * @param quarantineMember
     * @param quarantineMemberClass
     * @param quarantine_member
     * @return
     */
    @Override
    public ModelAndView exportingExcel(HttpServletRequest request, QuarantineMember quarantineMember, Class<QuarantineMember> quarantineMemberClass, String quarantine_member) {
        // Step.1 组装查询条件
        QueryWrapper<QuarantineMember> queryWrapper = QueryGenerator.initQueryWrapper(quarantineMember, request.getParameterMap());
        LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();

        // 过滤选中数据
        String selections = request.getParameter("selections");
        if (oConvertUtils.isNotEmpty(selections)) {
            List<String> selectionList = Arrays.asList(selections.split(","));
            queryWrapper.in("id",selectionList);
        }

        // Step.2 获取导出数据
        List<QuarantineMember> list = quarantineMemberMapper.selectList(queryWrapper);

        for (QuarantineMember member : list) {

            //   家庭地址（编码 转 省市区）
            String homeAreaCode = member.getHomeAreaCode();
            if(StringUtils.isNotEmpty(homeAreaCode)){
                JSONObject provinceJSON = AreaUtil.getNameByProvinceCode(homeAreaCode.substring(0, 2) + "0000");
                String province = provinceJSON.getString("label");

                JSONObject CityJSON = AreaUtil.getNameByCityCode(provinceJSON, homeAreaCode.substring(0, 4) + "00");
                String city = CityJSON.getString("label");

                JSONObject areaJSON = AreaUtil.getNameByAreaCode(CityJSON, homeAreaCode);
                String area = areaJSON.getString("label");


                member.setHomeProvince(province);
                member.setHomeCity(city);
                member.setHomeArea(area);
            }

//            风险地区（ 编码 转 省市区）
            String sourceAreaCode = member.getSourceArea();
            if(StringUtils.isNotEmpty(sourceAreaCode)){
                JSONObject provinceJSON = AreaUtil.getNameByProvinceCode(sourceAreaCode.substring(0,2) + "0000");
                String province2 = provinceJSON.getString("label");

                JSONObject CityJSON = AreaUtil.getNameByCityCode(provinceJSON, sourceAreaCode.substring(0, 4) + "00");
                String city2 = CityJSON.getString("label");

                JSONObject areaJSON = AreaUtil.getNameByAreaCode(CityJSON, sourceAreaCode);
                String area2 = areaJSON.getString("label");


                member.setSourceProvince(province2);
                member.setSourceCity(city2);
                member.setSourceDistrict(area2);
            }

        }


        // Step.3 AutoPoi 导出Excel
        ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
        //此处设置的filename无效 ,前端会重更新设置一下
        mv.addObject(NormalExcelConstants.FILE_NAME, quarantine_member);
        mv.addObject(NormalExcelConstants.CLASS, quarantineMemberClass);
        //update-begin--Author:liusq  Date:20210126 for：图片导出报错，ImageBasePath未设置--------------------
//        ExportParams exportParams=new ExportParams(quarantine_member + "报表", "导出人:" + sysUser.getRealname(), quarantine_member);
        ExportParams exportParams=new ExportParams(quarantine_member + "报表", quarantine_member);
        exportParams.setImageBasePath(upLoadPath);
        //update-end--Author:liusq  Date:20210126 for：图片导出报错，ImageBasePath未设置----------------------
        mv.addObject(NormalExcelConstants.PARAMS,exportParams);
        mv.addObject(NormalExcelConstants.DATA_LIST, list);
        return mv;
    }

}

4.QuarantineMember

package org.jeecg.modules.quarantine.entity;

import java.io.Serializable;
import java.io.UnsupportedEncodingException;
import java.util.Date;
import java.math.BigDecimal;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.jeecgframework.poi.excel.annotation.ExcelCollection;
import org.springframework.format.annotation.DateTimeFormat;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.jeecg.common.aspect.annotation.Dict;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

/**
 * @Description: quarantine_member
 * @Author: jeecg-boot
 * @Date:   2022-11-03
 * @Version: V1.0
 */
@Data
@TableName("quarantine_member")
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="quarantine_member对象", description="quarantine_member")
public class QuarantineMember implements Serializable {
    private static final long serialVersionUID = 1L;

	/**ID*/
//	@TableId(type = IdType.ASSIGN_ID)
    @ApiModelProperty(value = "ID")
    private java.lang.String id;
	/**姓名*/
	@Excel(name = "姓名", width = 15, orderNum = "10")
    @ApiModelProperty(value = "姓名")
    private java.lang.String name;
	/**性别*/
	@Excel(name = "性别", width = 15, orderNum = "20", dicCode = "sex")
    @Dict(dicCode = "sex")
    @ApiModelProperty(value = "性别")
    private java.lang.String sex;
	/**出生日期*/
//	@Excel(name = "出生日期", width = 20, format = "yyyy-MM-dd")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @ApiModelProperty(value = "出生日期")
    private java.util.Date birthday;
	/**联系电话*/
	@Excel(name = "联系电话", width = 15, orderNum = "40")
    @ApiModelProperty(value = "联系电话")
    private java.lang.String phone;
	/**常住地址*/
    @Excel(name = "常住地址", width = 15, orderNum = "77",groupName = "风险地区")
    @ApiModelProperty(value = "常住地址（风险地区）")
    private java.lang.String address;
	/**户籍地址*/
	@Excel(name = "户籍地址", width = 15, orderNum = "57",groupName = "家庭详细地址")
    @ApiModelProperty(value = "户籍地址（家庭地址）")
    private java.lang.String censusAdress;
	/**国籍*/
//	@Excel(name = "国籍", width = 15)
    @ApiModelProperty(value = "国籍")
    @Dict(dicCode = "nationality")
    private java.lang.String nationality;
	/**身份证号码*/
	@Excel(name = "身份证号或护照号", width = 15, orderNum = "30")
    @ApiModelProperty(value = "身份证号码")
    private java.lang.String idCard;
	/**是否境外输入*/
//	@Excel(name = "是否境外输入", width = 15)
    @Dict(dicCode = "is_input_outside")
    @ApiModelProperty(value = "是否境外输入")
    private java.lang.String isInputOutside;
	/**来源地是否本市*/
//	@Excel(name = "来源地是否本市", width = 15)
    @Dict(dicCode = "is_this_city")
    @ApiModelProperty(value = "来源地是否本市")
    private java.lang.String isThisCity;
	/**中高风险地区*/
//	@Excel(name = "中高风险地区", width = 15)
    @Dict(dicCode = "high_risk")
    @ApiModelProperty(value = "中高风险地区")
    private java.lang.String highRisk;
	/**来源地*/
//	@Excel(name = "省市区", width = 15, orderNum = "70",groupName = "风险地区")
    @ApiModelProperty(value = "来源地code（风险地区）")
    private java.lang.String sourceArea;

    /**归属区*/
    @Dict(dicCode = "belong_area")
    @ApiModelProperty(value = "归属区")
    private java.lang.String belongArea;
    /**其他归属区*/
    @ApiModelProperty(value = "其他归属区")
    private java.lang.String otherBelongArea;

	/**类别*/
	@Excel(name = "人员类别", width = 15, orderNum = "60", dicCode = "type")
    @Dict(dicCode = "type")
    @ApiModelProperty(value = "类别")
    private java.lang.String type;
	/**隔离时间*/
//	@Excel(name = "隔离时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "隔离时间")
    private java.util.Date quarantineTime;
	/**计划解除隔离日期*/
	@Excel(name = "拟定解除日期", width = 20, format = "yyyy-MM-dd HH:mm:ss", orderNum = "90")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "计划解除隔离日期")
    private java.util.Date planQuarantineTime;
	/**末次暴露时间*/
	@Excel(name = "离开风险地区/末次接触时间", width = 20, format = "yyyy-MM-dd HH:mm:ss", orderNum = "80")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "末次暴露时间")
    private java.util.Date lastExposeTime;
    /**隔离点ID*/
//    @Excel(name = "隔离点ID", width = 15, dictTable = "quarantine_site", dicText = "quarantine_name", dicCode = "id")
    @Dict(dictTable = "quarantine_site", dicText = "quarantine_name", dicCode = "id")
    @ApiModelProperty(value = "隔离点ID")
	private String siteId;
    /**所属区域*/
//    @Excel(name = "所属区域", width = 15)
    @Dict(dicCode = "region")
    @ApiModelProperty(value = "所属区域")
    private java.lang.String region;
	/**隔离点房间楼层*/
//	@Excel(name = "隔离点房间楼层", width = 15)
    @Dict(dicCode = "room_floor")
    @ApiModelProperty(value = "隔离点房间楼层")
    private java.lang.String roomFloor;
	/**隔离点房间ID*/
//	@Excel(name = "隔离点房间ID", width = 15, dictTable = "quarantine_site_room", dicText = "room_name", dicCode = "id")
    @Dict(dictTable = "quarantine_site_room", dicText = "room_name", dicCode = "id")
    @ApiModelProperty(value = "隔离点房间ID")
    private java.lang.String roomId;
	/**收治医生*/
//	@Excel(name = "收治医生", width = 15)
    @ApiModelProperty(value = "收治医生")
    private java.lang.String receiveDoctor;
	/**收治护士*/
//	@Excel(name = "收治护士", width = 15)
    @ApiModelProperty(value = "收治护士")
    private java.lang.String receiveNurse;
	/**人员来源*/
//	@Excel(name = "人员来源", width = 15)
    @Dict(dicCode = "member_source")
    @ApiModelProperty(value = "人员来源")
    private java.lang.String memberSource;
	/**解除隔离意向去往*/
//	@Excel(name = "解除隔离意向去往", width = 15)
    @Dict(dicCode = "head_for")
    @ApiModelProperty(value = "解除隔离意向去往")
    private java.lang.String headFor;
    /**解除隔离意向区县*/
//    @Excel(name = "解除隔离意向去往区县", width = 15)
    @Dict(dicCode = "head_for_area")
    @ApiModelProperty(value = "解除隔离意向去往区县")
    private java.lang.String headForArea;
    /**解除隔离意向地址*/
//    @Excel(name = "解除隔离意向去往地址", width = 15)
    @ApiModelProperty(value = "解除隔离意向去往地址")
    private java.lang.String headForAddress;
	/**温度*/
//	@Excel(name = "温度", width = 15)
    @ApiModelProperty(value = "温度")
    private java.lang.String temperature;
	/**血氧*/
//	@Excel(name = "血氧", width = 15)
    @ApiModelProperty(value = "血氧")
    private java.lang.String bloodOxygen;
	/**心率*/
//	@Excel(name = "心率", width = 15)
    @ApiModelProperty(value = "心率")
    private java.lang.String heartRate;
	/**高压*/
//	@Excel(name = "高压", width = 15)
    @ApiModelProperty(value = "高压")
    private java.lang.String highPressure;
	/**低压*/
//	@Excel(name = "低压", width = 15)
    @ApiModelProperty(value = "低压")
    private java.lang.String lowTension;
	/**白细胞*/
//	@Excel(name = "白细胞", width = 15)
    @Dict(dicCode = "hemameba")
    @ApiModelProperty(value = "白细胞")
    private java.lang.String hemameba;
	/**淋巴细胞*/
//	@Excel(name = "淋巴细胞", width = 15)
    @Dict(dicCode = "lymphocyte")
    @ApiModelProperty(value = "淋巴细胞")
    private java.lang.String lymphocyte;
	/**CT检查*/
//	@Excel(name = "CT检查", width = 15)
    @Dict(dicCode = "CT_examination")
    @ApiModelProperty(value = "CT检查")
    private java.lang.String ctExamination;
	/**家庭联系人*/
//	@Excel(name = "家庭联系人", width = 15)
    @ApiModelProperty(value = "家庭联系人")
    private java.lang.String familyPerson;
	/**家属电话*/
//	@Excel(name = "家属电话", width = 15)
    @ApiModelProperty(value = "家属电话")
    private java.lang.String familyPersonPhone;
	/**基本症状*/
//	@Excel(name = "基本症状", width = 15)
    @Dict(dicCode = "fundamental_symptoms")
    @ApiModelProperty(value = "基本症状")
    private java.lang.String fundamentalSymptoms;
	/**基础疾病*/
//	@Excel(name = "基础疾病", width = 15)
    @Dict(dicCode = "underlying_disease")
    @ApiModelProperty(value = "基础疾病")
    private java.lang.String underlyingDisease;
	/**出院时间*/
//	@Excel(name = "出院时间", width = 15, format = "yyyy-MM-dd")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @ApiModelProperty(value = "出院时间")
    private java.util.Date dischargeTime;
	/**是否收费*/
//	@Excel(name = "是否收费", width = 15)
    @Dict(dicCode = "is_rate")
    @ApiModelProperty(value = "是否收费")
    private java.lang.String isRate;
	/**结算金额*/
//	@Excel(name = "结算金额", width = 15)
    @ApiModelProperty(value = "结算金额")
    private java.math.BigDecimal settlementAmount;
	/**状态*/
//	@Excel(name = "状态", width = 15)
    @Dict(dicCode = "admission_status")
    @ApiModelProperty(value = "状态")
    private java.lang.String status;
    /**离开当地日期*/
    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "离开当地日期")
    private java.util.Date leaveDate;
    /**返回荆门日期*/
    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "返回荆门日期")
    private java.util.Date enterDate;
    /**二维码*/
    @ApiModelProperty(value = "二维码")
    private String onlyCode;
    @ApiModelProperty(value = "主身份证")
    private String mainIdCard;
    /**备注*/
    @Excel(name = "备注", width = 15, orderNum = "100")
    @ApiModelProperty(value = "备注")
    private java.lang.String note;
    /**家庭地址code（家庭地址）*/
//    @Excel(name = "省市区", width = 15, orderNum = "50",groupName = "家庭详细地址")
    @ApiModelProperty(value = "家庭地址code（家庭地址）")
    private String homeAreaCode;
    /**街道/乡镇（家庭地址）*/
    @Excel(name = "街道/乡镇(家)", width = 15, orderNum = "55",groupName = "家庭详细地址")
    @ApiModelProperty(value = "街道/乡镇（家庭地址）")
    private String homeStreet;
    /**所在社区（家庭地址）*/
    @Excel(name = "社区(家)", width = 15, orderNum = "56",groupName = "家庭详细地址")
    @ApiModelProperty(value = "所在社区（家庭地址）")
    private String homeCommunity;
    /**社区联系电话（家庭地址）*/
    @ApiModelProperty(value = "社区联系电话（家庭地址）")
    private String homeCommunityPhone;
    /**社区联系人（家庭地址）*/
    @ApiModelProperty(value = "社区联系人（家庭地址）")
    private String homeCommunityPerson;
    /**街道/乡镇（风险地区）*/
    @Excel(name = "街道/乡镇", width = 15, orderNum = "75",groupName = "风险地区")
    @ApiModelProperty(value = "街道/乡镇（风险地区）")
    private String sourceStreet;
    /**所在社区（风险地区）*/
    @Excel(name = "社区", width = 15, orderNum = "76",groupName = "风险地区")
    @ApiModelProperty(value = "所在社区（风险地区）")
    private String sourceCommunity;
    /**社区联系电话（风险地区）*/
    @ApiModelProperty(value = "社区联系电话（风险地区）")
    private String sourceCommunityPhone;
    /**社区联系人（风险地区）*/
    @ApiModelProperty(value = "社区联系人（风险地区）")
    private String sourceCommunityPerson;

	/**创建人*/
    @ApiModelProperty(value = "创建人")
    private java.lang.String createBy;
	/**创建日期*/
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @ApiModelProperty(value = "创建日期")
    private java.util.Date createTime;
	/**更新人*/
    @ApiModelProperty(value = "更新人")
    private java.lang.String updateBy;
	/**更新日期*/
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @ApiModelProperty(value = "更新日期")
    private java.util.Date updateTime;
	/**delFlag*/
    @ApiModelProperty(value = "delFlag")
    private java.lang.String delFlag;



    /**隔离点房间名称*/
//    @Excel(name = "隔离点房间名称", width = 15)
    @ApiModelProperty(value = "隔离点房间名称")
    @TableField(exist = false)
    private java.lang.String roomName;

    /**查房结果*/
//    @Excel(name = "查房结果", width = 15)
    @Dict(dicCode = "round_result")
    @ApiModelProperty(value = "查房结果")
    @TableField(exist = false)
    private java.lang.String roundResult;
    /**查房时间*/
//    @Excel(name = "查房时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "查房时间")
    @TableField(exist = false)
    private java.util.Date roundTime;

    /**转运车辆*/
//    @Excel(name = "转运车辆", width = 15)
    @ApiModelProperty(value = "转运车辆")
    @TableField(exist = false)
    private java.lang.String transferCar;
    /**转运目的地*/
//    @Excel(name = "转运目的地", width = 15)
    @ApiModelProperty(value = "转运目的地")
    @TableField(exist = false)
    private java.lang.String transferDestination;
    /**转运时间*/
//    @Excel(name = "转运时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "转运时间")
    @TableField(exist = false)
    private java.util.Date transferTime;



    /****************************导入数据Start***************************/
    @Excel(name = "省(家)", width = 15, orderNum = "51",groupName = "家庭详细地址")
    @TableField(exist = false)
    private String homeProvince;
    @Excel(name = "市(家)", width = 15, orderNum = "52",groupName = "家庭详细地址")
    @TableField(exist = false)
    private String homeCity;
    @Excel(name = "区(家)", width = 15, orderNum = "53",groupName = "家庭详细地址")
    @TableField(exist = false)
    private String homeArea;

    @Excel(name = "省", width = 15, orderNum = "71",groupName = "风险地区")
    @TableField(exist = false)
    private String sourceProvince;
    @Excel(name = "市", width = 15, orderNum = "72",groupName = "风险地区")
    @TableField(exist = false)
    private String sourceCity;
    @Excel(name = "区", width = 15, orderNum = "73",groupName = "风险地区")
    @TableField(exist = false)
    private String sourceDistrict;
    /****************************导入数据End***************************/

}