spring boot导出数据（条件筛选、字典项过滤）

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;