bug修改

黎星凯

2024-04-15 62b6a7fac3f2acde70b578431147c4a01f19c182

 consum-base/src/main/java/com/consum/base/controller/DepFormScrappedController.java

@@ -146,7 +146,7 @@
    @ApiOperation(value = "导出报废单", notes = "导出报废单")
    @ApiImplicitParams({@ApiImplicitParam(name = "id", value = "报废单id", dataType = "Long", paramType = "query")})
    @GetMapping("/deptList/export")
    public void export(Long id, HttpServletResponse response) throws Exception {
    public ResponseValue<String> export(Long id, HttpServletResponse response) throws Exception {
        if (id == null) {
            throw new RuntimeException("报废单id为空");
        }
@@ -174,12 +174,15 @@

        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, map);
        // 设置响应头
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode("部门报废单.xlsx", "utf-8"));
        try (OutputStream outputStream = response.getOutputStream()) {
            workbook.write(outputStream);
            workbook.close();
        }
//        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
//        response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode("部门报废单.xlsx", "utf-8"));
//        try (OutputStream outputStream = response.getOutputStream()) {
//            workbook.write(outputStream);
//            workbook.close();
//        }
        String filePath = downLoadExcel("采购入库单", workbook);
        return ResponseValue.success("导出成功", filePath);

    }

    @GetMapping("/deptListByModel")
@@ -224,62 +227,4 @@
        return ResponseValue.success(depFormScrappedService.listByModel2(param));
    }

    // public static void main(String[] args) {
    // TemplateExportParams exportParams = new
    // TemplateExportParams("D:\\MyProjects\\jmy\\低值易耗品\\low-consum-manage\\deploy-jar-single\\src\\main\\resources\\import\\deptScrapped.xlsx");
    // exportParams.setHeadingStartRow(2);
    //
    // List<Map<String, Object>> export = new ArrayList<>();
    //
    // // 创建第一条数据
    // Map<String, Object> data1 = new HashMap<>();
    // data1.put("agencyName", 1);
    // data1.put("baseGoodsTemplateName", "Bob");
    // data1.put("scrappedName", "Bob");
    // data1.put("bz", "Bob");
    // data1.put("baseGoodsModelsName", 30);
    // data1.put("counts", 30);
    // data1.put("totalPrice", 30);
    // export.add(data1);
    //
    // // 创建第二条数据
    // Map<String, Object> data2 = new HashMap<>();
    // data2.put("agencyName", 2);
    // data2.put("baseGoodsTemplateName", "Bob");
    // data2.put("scrappedName", "Bob");
    // data2.put("bz", "Bob");
    // data2.put("baseGoodsModelsName", 30);
    // data2.put("counts", 30);
    // data2.put("totalPrice", 30);
    // export.add(data2);
    //
    //
    // Map<String, Object> map = new HashMap<>();
    // map.put("code", "2023");
    // map.put("date", "2023");
    // map.put("name", "operatorName");
    // map.put("countNum", 0);
    // map.put("totalAmount", 0);
    // map.put("maplist", export);
    //
    // Workbook workbook = ExcelExportUtil.exportExcel(exportParams, map);
    //
    // File file = new File("C:\\Users\\cy\\Desktop\\新建文件夹");
    // OutputStream stream = null;
    // try {
    // SimpleDateFormat sdf = new SimpleDateFormat("yyyy_MM_dd");
    // stream = new FileOutputStream(new File(file, "机构客户信息表.xls"));
    // //document.write(stream);
    // workbook.write(stream);
    // } catch (Exception e) {
    // e.printStackTrace();
    // } finally {
    // if (stream != null) ;
    // try {
    // stream.close();
    // } catch (IOException e) {
    // e.printStackTrace();
    // }
    // }
    // }
}