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