org.shoulder.batch.endpoint.ExportController Maven / Gradle / Ivy

package org.shoulder.batch.endpoint;

/**
 * 导出
 *
 * @param     实体
 * @param  分页查询参数
 * @author lym
 * 
 * 导出Excel
 * @param params   参数
 * @param request  请求
 * @param response 响应
 * 

 * 预览Excel
 * @param params 预览参数
 * @return 预览html
 * 
 * 构建导出参数
 * @param params 分页参数
 * @param page   分页
 * @return 导出参数
 */
/*
public interface ExportController {

    */
/**
 * 导出Excel
 *
 * @param params   参数
 * @param request  请求
 * @param response 响应
 *//*

    @ApiOperation(value = "导出Excel")
    @RequestMapping(value = "/export", method = RequestMethod.POST, produces = "application/octet-stream")
    @OperationLog(operation = OperationLog.Operations.EXPORT)
    default void exportExcel(@RequestBody @Validated PageParams params, HttpServletRequest request, HttpServletResponse response) {
        IPage page = params.buildPage();
        ExportParams exportParams = getExportParams(params, page);

        Map map = new HashMap<>(7);
        map.put(NormalExcelConstants.DATA_LIST, page.getRecords());
        map.put(NormalExcelConstants.CLASS, getEntityClass());
        map.put(NormalExcelConstants.PARAMS, exportParams);
        Object fileName = params.getExtra().getOrDefault(NormalExcelConstants.FILE_NAME, "临时文件");
        map.put(NormalExcelConstants.FILE_NAME, fileName);
        PoiBaseView.render(map, request, response, NormalExcelConstants.EASYPOI_EXCEL_VIEW);
    }

    */
/**
 * 预览Excel
 *
 * @param params 预览参数
 * @return 预览html
 *//*

    @ApiOperation(value = "预览Excel")
    @OperationLog(operation = OperationLog.Operations.EXPORT)
    @RequestMapping(value = "/preview", method = RequestMethod.POST)
    default BaseResult preview(@RequestBody @Validated PageParams params) {
        IPage page = params.buildPage();
        ExportParams exportParams = getExportParams(params, page);

        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, getEntityClass(), page.getRecords());
        return BaseResult.success(ExcelXorHtmlUtil.excelToHtml(new ExcelToHtmlParams(workbook)));
    }


    */
/**
 * 构建导出参数
 *
 * @param params 分页参数
 * @param page   分页
 * @return 导出参数
 *//*

    default ExportParams getExportParams(PageParams params, IPage page) {
        query(params, page, params.getSize() == -1 ? Convert.toLong(Integer.MAX_VALUE) : params.getSize());

        Object title = params.getExtra().get("title");
        Object type = params.getExtra().getOrDefault("type", ExcelType.XSSF.name());
        Object sheetName = params.getExtra().getOrDefault("sheetName", "SheetName");

        ExcelType excelType = ExcelType.XSSF.name().equals(type) ? ExcelType.XSSF : ExcelType.HSSF;
        return new ExportParams(String.valueOf(title), sheetName.toString(), excelType);
    }

}
*/