#

luxiaotao1123

2020-06-06 5dd0071775a7252ed22e4c6bfd1c3ee7daeb012a

#

 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);
    }

    // 导入

 src/main/java/com/zy/common/utils/excel/ExcelUtils.java

New file
@@ -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());
        // 读取第一个sheet(表),文件流会自动关闭
        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;
    }
}

 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可以防止中文乱码 当然和easyexcel没有关系
        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());
    }

}

 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)
                            // }
                        }
                    });
                });