山西直流电源系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
whycxzp
17 小时以前 84d046dc899853dd475768b6bee01e136deda432 
 src/main/java/com/whyc/service/DeviceSpareService.java


@@ -1,8 +1,9 @@


package com.whyc.service;




import cn.afterturn.easypoi.excel.ExcelExportUtil;


import cn.afterturn.easypoi.excel.entity.TemplateExportParams;


import com.baomidou.mybatisplus.core.conditions.Wrapper;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;


import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;


import com.baomidou.mybatisplus.core.toolkit.Wrappers;


import com.github.pagehelper.PageHelper;


import com.github.pagehelper.PageInfo;


@@ -13,21 +14,23 @@


import com.whyc.util.CommonUtil;


import com.whyc.util.ThreadLocalUtil;


import org.apache.commons.lang.StringUtils;


import org.apache.poi.openxml4j.opc.OPCPackage;


import org.apache.poi.ss.usermodel.*;


import org.apache.poi.xssf.usermodel.*;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.core.io.ClassPathResource;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.web.multipart.MultipartFile;




import javax.annotation.Resource;


import javax.servlet.http.HttpServletResponse;


import java.io.File;


import java.io.FileOutputStream;


import java.io.IOException;


import java.util.ArrayList;


import java.util.Date;


import java.util.List;


import java.net.URLEncoder;


import java.time.LocalDateTime;


import java.time.format.DateTimeFormatter;


import java.util.*;




@Service


public class DeviceSpareService {


@@ -319,4 +322,29 @@


    private void updateQuantityAndPictureBatch(List<DeviceSpare> spareListUpdate) {


        mapper.updateQuantityAndPictureBatch(spareListUpdate);


    }




    public void excelExport(HttpServletResponse response) {


        //查询所有的设备器件


        List<DeviceSpare> deviceSpareList = mapper.selectList((Wrapper<DeviceSpare>) CommonUtil.nullObject);


        //获取导出模板地址


        ClassPathResource classPathResource = new ClassPathResource("excel_templates/template_device_spare.xlsx");


        String path = classPathResource.getPath();


        TemplateExportParams templateExportParams1 = new TemplateExportParams(path,true);


        // 构建导出数据模型


        Map<String, Object> map = new HashMap<>();


        map.put("deviceSpareList", deviceSpareList); // 假设模板中使用 ${deviceSpareList} 作为变量名




        Workbook wb = ExcelExportUtil.exportExcel(templateExportParams1, map);


        try {


            LocalDateTime now = LocalDateTime.now();


            String fileName = "维修管理器件库存_"+now.format(DateTimeFormatter.ofPattern("yyyyMMddHHmmss"))+".xlsx";


            response.setContentType("application/vnd.ms-excel");


            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "utf-8"));


            response.flushBuffer();


            wb.write(response.getOutputStream());


        } catch (IOException e) {


            e.printStackTrace();


        }




    }


}