单灯数据导出

liuhaonan

2022-04-02 c807f0ed336fecbbea89eb040e28b6fa0046fb6f

单灯数据导出

 dao/src/main/java/com/sandu/ximon/dao/domain/LightReportData.java

@@ -9,7 +9,8 @@
import java.io.Serializable;
import java.time.LocalDateTime;

import javafx.util.converter.LocalDateStringConverter;

import com.sandu.ximon.dao.utils.LocalDateStringConverter;
import lombok.Data;

/**
@@ -108,13 +109,13 @@
    /**
     * 鍒涘缓鏃堕棿
     */
//    @ExcelProperty(value = "鍒涘缓鏃堕棿",converter = LocalDateStringConverter.class)
    @ExcelProperty(value = "鍒涘缓鏃堕棿",converter = LocalDateStringConverter.class)
    private LocalDateTime createTime;

    /**
     * 
     */
    @ExcelProperty("鏇存柊鏃堕棿")
    @ExcelProperty(value = "鏇存柊鏃堕棿",converter = LocalDateStringConverter.class)
    private LocalDateTime updateTime;

    @TableField(exist = false)

 dao/src/main/java/com/sandu/ximon/dao/utils/LocalDateStringConverter.java

文件名从 ximon-admin/src/main/java/com/sandu/ximon/admin/security/LocalDateStringConverter.java 修改
@@ -1,4 +1,4 @@
package com.sandu.ximon.admin.security;
package com.sandu.ximon.dao.utils;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;

 ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java

@@ -82,7 +82,7 @@
//        excelWriter.fill(list, writeSheet);
//        excelWriter.finish();

        EasyExcel.write(file, LightReportDataBo.class).sheet("妯℃澘").doWrite(list);
        EasyExcel.write(file, LightReportDataBo.class).sheet("鍗曠伅鏁版嵁").doWrite(list);
        String url = file.getPath().replace(properties.getUploadRootPath(), "");
       return ResUtils.addPrefix(url);