From 5dd0071775a7252ed22e4c6bfd1c3ee7daeb012a Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期六, 06 六月 2020 09:36:26 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/MatCodeController.java | 37 ++++++++++++++---- src/main/java/com/zy/common/utils/excel/ExcelUtils.java | 44 ++++++++++++++++++++++ src/main/webapp/static/js/matCode/matCode.js | 18 ++++---- src/main/java/com/zy/common/web/FileController.java | 18 +++----- 4 files changed, 89 insertions(+), 28 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/MatCodeController.java b/src/main/java/com/zy/asrs/controller/MatCodeController.java index a2c24a4..eb80c17 100644 --- a/src/main/java/com/zy/asrs/controller/MatCodeController.java +++ b/src/main/java/com/zy/asrs/controller/MatCodeController.java @@ -13,14 +13,16 @@ import com.core.common.R; import com.zy.asrs.entity.MatCode; import com.zy.asrs.service.MatCodeService; -import com.zy.common.utils.excel.matcode.MatCodeExcelListener; import com.zy.common.utils.excel.matcode.MatCodeExcel; +import com.zy.common.utils.excel.matcode.MatCodeExcelListener; import com.zy.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; +import javax.servlet.http.HttpServletResponse; import java.io.IOException; +import java.net.URLEncoder; import java.util.*; @RestController @@ -100,13 +102,32 @@ // 瀵煎嚭 @RequestMapping(value = "/matCode/export/auth") @ManagerAuth - public R export(@RequestBody JSONObject param){ - List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); - EntityWrapper<MatCode> wrapper = new EntityWrapper<>(); - Map<String, Object> map = excludeTrash(param.getJSONObject("matCode")); - convert(map, wrapper); - List<MatCode> list = matCodeService.selectList(wrapper); - return R.ok(exportSupport(list, fields)); + public void export(@RequestBody JSONObject param, HttpServletResponse response) throws Exception{ +// List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); +// EntityWrapper<MatCode> wrapper = new EntityWrapper<>(); +// Map<String, Object> map = excludeTrash(param.getJSONObject("matCode")); +// convert(map, wrapper); +// List<MatCode> list = matCodeService.selectList(wrapper); + + + List<MatCode> list = matCodeService.selectList(new EntityWrapper<>()); + + + List<MatCodeExcel> excels = new ArrayList<>(); + for (MatCode matCode : list) { + MatCodeExcel excel = new MatCodeExcel(); + excel.setMatNo(matCode.getMatNo()); + excel.setBarcode(matCode.getBarcode()); + excel.setMatName(matCode.getMatName()); + excel.setStr1(matCode.getStr1()); + excel.setStr2(matCode.getStr2()); + excels.add(excel); + } + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + String fileName = URLEncoder.encode("娴嬭瘯", "UTF-8"); + response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); + EasyExcel.write(response.getOutputStream(), MatCodeExcel.class).sheet("妯℃澘").doWrite(excels); } // 瀵煎叆 diff --git a/src/main/java/com/zy/common/utils/excel/ExcelUtils.java b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java new file mode 100644 index 0000000..d51ec8e --- /dev/null +++ b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java @@ -0,0 +1,44 @@ +package com.zy.common.utils.excel; + +import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.read.builder.ExcelReaderBuilder; +import com.zy.common.utils.excel.matcode.MatCodeExcel; +import com.zy.common.utils.excel.matcode.MatCodeExcelListener; + +import java.util.ArrayList; +import java.util.List; + +/** + * Created by vincent on 2019-11-24 + */ +public class ExcelUtils { + + public static void main(String[] args) { +// new ExcelUtils().simpleRead(); + new ExcelUtils().simpleWrite(); + } + + public void simpleRead(){ + ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", MatCodeExcel.class, new MatCodeExcelListener()); + // 璇诲彇绗竴涓猻heet(琛�),鏂囦欢娴佷細鑷姩鍏抽棴 + read.sheet().doRead(); + } + + public void simpleWrite(){ + EasyExcel.write("/Users/vincent/Desktop/writeDemo.xls", MatCodeExcel.class).sheet("lxt").doWrite(data()); + } + + public static List<MatCodeExcel> data(){ + List<MatCodeExcel> list = new ArrayList<>(); + for (int i = 0; i<1000; i++) { + MatCodeExcel data = new MatCodeExcel(); + data.setMatNo("1"); + data.setBarcode("2"); + data.setMatName("3"); + data.setStr1("5"); + data.setStr2("6"); + list.add(data); + } + return list; + } +} diff --git a/src/main/java/com/zy/common/web/FileController.java b/src/main/java/com/zy/common/web/FileController.java index 5dbea13..d7b9c83 100644 --- a/src/main/java/com/zy/common/web/FileController.java +++ b/src/main/java/com/zy/common/web/FileController.java @@ -1,15 +1,11 @@ package com.zy.common.web; import com.alibaba.excel.EasyExcel; -import com.zy.common.utils.excel.EnInitData; -import com.zy.common.utils.excel.matcode.MatCodeExcelListener; -import com.zy.common.utils.excel.ExcelUtils; import com.core.common.R; -import org.springframework.stereotype.Controller; -import org.springframework.web.bind.annotation.GetMapping; -import org.springframework.web.bind.annotation.PostMapping; -import org.springframework.web.bind.annotation.RequestMapping; -import org.springframework.web.bind.annotation.ResponseBody; +import com.zy.common.utils.excel.ExcelUtils; +import com.zy.common.utils.excel.matcode.MatCodeExcel; +import com.zy.common.utils.excel.matcode.MatCodeExcelListener; +import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; @@ -20,7 +16,7 @@ * todo * Created by vincent on 2019-11-25 */ -@Controller +@RestController @RequestMapping("excel/") public class FileController { @@ -30,7 +26,7 @@ @PostMapping("upload") @ResponseBody public R upload(MultipartFile file) throws IOException { - EasyExcel.read(file.getInputStream(), EnInitData.class, new MatCodeExcelListener()).sheet().doRead(); + EasyExcel.read(file.getInputStream(), MatCodeExcel.class, new MatCodeExcelListener()).sheet().doRead(); return R.ok(); } @@ -45,7 +41,7 @@ // 杩欓噷URLEncoder.encode鍙互闃叉涓枃涔辩爜 褰撶劧鍜宔asyexcel娌℃湁鍏崇郴 String fileName = URLEncoder.encode("娴嬭瘯", "UTF-8"); response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); - EasyExcel.write(response.getOutputStream(), EnInitData.class).sheet("妯℃澘").doWrite(ExcelUtils.data()); + EasyExcel.write(response.getOutputStream(), MatCodeExcel.class).sheet("妯℃澘").doWrite(ExcelUtils.data()); } } diff --git a/src/main/webapp/static/js/matCode/matCode.js b/src/main/webapp/static/js/matCode/matCode.js index 1aa6c3f..2e6971b 100644 --- a/src/main/webapp/static/js/matCode/matCode.js +++ b/src/main/webapp/static/js/matCode/matCode.js @@ -192,18 +192,18 @@ url: baseUrl+"/matCode/export/auth", headers: {'token': localStorage.getItem('token')}, data: JSON.stringify(param), - dataType:'json', + // dataType:'json', contentType:'application/json;charset=UTF-8', method: 'POST', success: function (res) { - layer.closeAll(); - if (res.code === 200) { - table.exportFile(titles,res.data,'xls'); - } else if (res.code === 403) { - top.location.href = baseUrl; - } else { - layer.msg(res.msg) - } + // layer.closeAll(); + // if (res.code === 200) { + // table.exportFile(titles,res.data,'xls'); + // } else if (res.code === 403) { + // top.location.href = baseUrl; + // } else { + // layer.msg(res.msg) + // } } }); }); -- Gitblit v1.9.1