java/mx_charging_pile.git

			@@ -9,6 +9,7 @@
			import com.ruoyi.chargingPile.api.dto.ApplyChargingQuery;
			import com.ruoyi.chargingPile.api.dto.ApplyChargingRemarkDto;
			import com.ruoyi.chargingPile.api.model.TApplyChargingPile;
			import com.ruoyi.chargingPile.dto.TApplyChargingPileExportDto;
			import com.ruoyi.chargingPile.service.TApplyChargingPileService;
			import com.ruoyi.common.core.constant.Constants;
			import com.ruoyi.common.core.domain.R;
			@@ -19,6 +20,7 @@
			import com.ruoyi.common.security.service.TokenService;
			import io.swagger.annotations.ApiOperation;
			import org.apache.commons.codec.CharEncoding;
			import org.springframework.beans.BeanUtils;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.web.bind.annotation.*;

			@@ -26,7 +28,9 @@
			import java.io.IOException;
			import java.io.InputStream;
			import java.io.UnsupportedEncodingException;
			import java.net.URL;
			import java.net.URLEncoder;
			import java.util.ArrayList;
			import java.util.List;

			/**
			@@ -96,6 +100,15 @@
			try {
			List<TApplyChargingPile> list = applyChargingPileService.lambdaQuery().list();

			List<TApplyChargingPileExportDto> exportDtos =new ArrayList<>();
			for (TApplyChargingPile tApplyChargingPile : list) {
			TApplyChargingPileExportDto applyChargingPileExportDto = new TApplyChargingPileExportDto();
			BeanUtils.copyProperties(tApplyChargingPile,applyChargingPileExportDto);
			applyChargingPileExportDto.setImage(new URL("https://img-blog.csdnimg.cn/direct/c11088e1790049a5b84a0fda21a271b1.png"));
			exportDtos.add(applyChargingPileExportDto);

			}

			// excel模板封装
			ExcelWriterBuilder excelWriterBuilder = EasyExcelFactory.write(response.getOutputStream());
			InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"充电桩申请记录" + ".xlsx");

	ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TApplyChargingPileController.java	13 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/dto/TApplyChargingPileExportDto.java	12 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	ruoyi-service/ruoyi-chargingPile/src/main/resources/template/充电桩申请记录.xlsx	补丁 \| 查看 \| 原始文档 \| blame \| 历史

New file
			@@ -0,0 +1,12 @@
			package com.ruoyi.chargingPile.dto;

			import lombok.Data;

			import java.net.URL;

			@Data

			public class TApplyChargingPileExportDto {
			private String address;
			private URL image;
			}