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***************************/
}
11本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
