1、inspectionRecordVo传入筛选条件
@AutoLog(value = "导出excel")
@ApiOperation(value="导出excel", notes="导出excel")
@RequestMapping(value = "/exportInspectionXls")
public ModelAndView exportInspectionXls( InspectionRecordVo inspectionRecordVo,HttpServletRequest request) {
// Step.1 组装查询条件
//Step.2 AutoPoi 导出Excel
ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
Page<InspectionRecordVo> page = new Page<InspectionRecordVo>(1, 999999);
//根据筛选条件筛出符合条件的数据
IPage<InspectionRecordVo> pageList = inspectionRecordService.queryPageList(page, inspectionRecordVo);
List<InspectionRecordVo> inspectionRecordList = pageList.getRecords();
SimpleDateFormat dateFormat= new SimpleDateFormat("yyyyMMddhhmm");
//导出文件名称
mv.addObject(NormalExcelConstants.FILE_NAME, "巡查管理-巡查记录列表"+"_"+ dateFormat.format(new Date()));
mv.addObject(NormalExcelConstants.CLASS, InspectionRecordVo.class);
mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("巡查管理-巡查记录列表数据", "导出信息"));
mv.addObject(NormalExcelConstants.DATA_LIST, inspectionRecordList);
return mv;
}
2、实体类注解,翻译字典项及定义显示位置
@Data
public class InspectionRecordVo extends InspectionRecord {
/**老人姓名*/
/**orderNum = "2" 导出位置排第二列*/
@Excel(name = "客户姓名", width = 15 ,orderNum = "2")
@Dict(dicCode = "id",dictTable = "enter_elder_info",dicText = "name")
private String elderName;
/**房间id*/
/**数据字典翻译,在@Excel后加翻译项*/
@Excel(name = "房间号", width = 15 ,dicCode = "id",dictTable = "org_room",dicText = "name",orderNum = "1")
@Dict(dicCode = "id",dictTable = "org_room",dicText = "name")
@ApiModelProperty(value = "房间id")
private java.lang.String roomId;