From ffa5afb4e38d577c85813f48e41696f0c569c7a7 Mon Sep 17 00:00:00 2001
From: cuijian <cuijian@xalxzn.com>
Date: 星期二, 01 七月 2025 18:09:57 +0800
Subject: [PATCH] 质量-检验工具，检验项目
---
src/main/java/org/jeecg/modules/base/controller/SupplierController.java | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 49 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/jeecg/modules/base/controller/SupplierController.java b/src/main/java/org/jeecg/modules/base/controller/SupplierController.java
index 32a2574..c46995b 100644
--- a/src/main/java/org/jeecg/modules/base/controller/SupplierController.java
+++ b/src/main/java/org/jeecg/modules/base/controller/SupplierController.java
@@ -1,5 +1,7 @@
package org.jeecg.modules.base.controller;
+import java.io.File;
+import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
@@ -9,7 +11,11 @@
import java.net.URLDecoder;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.jeecg.common.api.vo.Result;
+import org.jeecg.common.constant.CommonConstant;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.base.entity.Supplier;
@@ -83,6 +89,7 @@
//@RequiresPermissions("org.jeecg.modules:base_supplier:add")
@PostMapping(value = "/add")
public Result<String> add(@RequestBody Supplier supplier) {
+ supplier.setSupplierStatus(CommonConstant.STATUS_1);
supplierService.save(supplier);
return Result.OK("娣诲姞鎴愬姛锛�");
}
@@ -174,4 +181,46 @@
return super.importExcel(request, response, Supplier.class);
}
+
+ @AutoLog(value = "渚涘簲鍟�-鍚敤&绂佺敤")
+ @ApiOperation(value = "渚涘簲鍟�-鍚敤&绂佺敤", notes = "渚涘簲鍟�-鍚敤&绂佺敤")
+ @PutMapping(value = "/active")
+ public Result<?> active(@RequestParam(name = "id", required = true) String id) {
+ Supplier supplier = supplierService.getById(id);
+ if (CommonConstant.STATUS_1.equals(supplier.getSupplierStatus())) {
+ supplier.setSupplierStatus(CommonConstant.STATUS_0);
+ } else {
+ supplier.setSupplierStatus(CommonConstant.STATUS_1);
+ }
+ supplierService.updateById(supplier);
+ return Result.ok("鎿嶄綔鎴愬姛锛�");
+ }
+
+ /**
+ * 瀵煎叆妯℃澘涓嬭浇
+ *
+ */
+ @RequestMapping(value = "/loadTemplate")
+ public void loadTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {
+
+ Map<String,String[]> req = request.getParameterMap();
+ Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\渚涘簲鍟嗕俊鎭鍏ユā鏉�.xlsx"));
+ //瀵煎嚭Workbook
+ //璁剧疆鍝嶅簲澶�
+ String fileName = "渚涘簲鍟嗕俊鎭鍏ユā鏉�.xlsx";
+ // 瀵规枃浠跺悕杩涜URL缂栫爜锛岄槻姝腑鏂囦贡鐮�
+ String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
+ // 灏哤orkbook鍐欏叆鍝嶅簲杈撳嚭娴�
+ try { // try-with-resources鑷姩鍏抽棴璧勬簮
+ workbook.write(response.getOutputStream());
+ response.flushBuffer();
+ } catch (IOException e) {
+ // 寮傚父澶勭悊锛堝璁板綍鏃ュ織锛�
+ throw new IOException("涓嬭浇妯℃澘澶辫触", e);
+ }
+
+ }
+
}
--
Gitblit v1.9.3