机床回传文件增加excel导出

yangys

2025-06-24 f2d89e470636e90a81a6ee446e8349c5037f7eb9

机床回传文件增加excel导出

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/machineback/controller/MachineBackFileController.java

@@ -3,17 +3,26 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jakarta.servlet.http.HttpServletResponse;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.Func;
import org.springblade.mdm.basesetting.machine.MachineService;
import org.springblade.mdm.basesetting.machine.vo.MachineExcelVO;
import org.springblade.mdm.basesetting.machine.vo.MachineQueryVO;
import org.springblade.mdm.basesetting.machine.vo.MachineVO;
import org.springblade.mdm.machineback.service.MachineBackFileService;
import org.springblade.mdm.machineback.vo.MachineBackFileExcelVO;
import org.springblade.mdm.machineback.vo.MachineBackFileQueryVO;
import org.springblade.mdm.machineback.vo.MachineBackFileVO;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.ArrayList;
import java.util.List;

@Slf4j
@RestController
@@ -59,4 +68,24 @@
        IPage<MachineBackFileVO> pages = service.pageQuery(query);
        return R.data(pages);
    }

    /**
     * åˆ†é¡µ
     */
    @Operation(summary = "导出Excel", description = "导出Excel")
    @GetMapping("/export-excel")
    public void exportExcel(MachineBackFileQueryVO query, HttpServletResponse response) {
        query.setCurrent(1);
        query.setSize(Integer.MAX_VALUE);

        IPage<MachineBackFileVO> pages = service.pageQuery(query);
        List<MachineBackFileExcelVO> list = new ArrayList<>();
        pages.getRecords().forEach(m ->{
            MachineBackFileExcelVO excelVO = new MachineBackFileExcelVO();
            BeanUtils.copyProperties(m, excelVO);
            excelVO.setCureStatus(m.getIsCured()==1?"已固化":"未固化");
            list.add(excelVO);
        });
        ExcelUtil.export(response, "机床回传文件" + DateUtil.time(), "机床回传文件表", list, MachineBackFileExcelVO.class);
    }
}

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/machineback/vo/MachineBackFileExcelVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,33 @@
package org.springblade.mdm.machineback.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;
import org.springblade.mdm.commons.vo.BaseVO;

import java.util.Date;
@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
@Setter
@Getter
public class MachineBackFileExcelVO extends BaseVO {

    @ExcelProperty("文件名称")
    private String name;
    @ExcelProperty("回传机床")
    private String machineCode;
    @ExcelProperty("程序名称")
    private String programName;

    @ExcelProperty("固化状态")
    private String cureStatus;
    @ExcelProperty("文件到达时间")
    private Date arrivedTime;
}