From 5d99227a97b7b244893b748af28e7f78238d2951 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期五, 05 九月 2025 01:15:15 +0800
Subject: [PATCH] 任务提醒，增加导出提醒；
---
blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/producedivision/controller/QinzheFgbController.java | 81 +++++++++++++++++++++++++++++++++++++++-
1 files changed, 78 insertions(+), 3 deletions(-)
diff --git a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/producedivision/controller/QinzheFgbController.java b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/producedivision/controller/QinzheFgbController.java
index 5ca9460..66e7940 100644
--- a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/producedivision/controller/QinzheFgbController.java
+++ b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/producedivision/controller/QinzheFgbController.java
@@ -1,12 +1,12 @@
package org.springblade.mdm.basesetting.producedivision.controller;
-import com.alibaba.excel.util.StringUtils;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jakarta.servlet.http.HttpServletResponse;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.io.IOUtils;
+import org.apache.commons.lang3.StringUtils;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.oss.OssTemplate;
@@ -24,16 +24,20 @@
import org.springframework.web.multipart.MultipartFile;
import java.io.InputStream;
+import java.util.Collections;
+import java.util.List;
@Slf4j
@RestController
@RequestMapping("/producedivision")
@Tag(name = "涓诲埗鍒嗗伐琛�", description = "涓诲埗鍒嗗伐琛�")
public class QinzheFgbController {
-
+ @Autowired
+ private ParamService paramService;
@Autowired
private QinzheFgbService qinzheFgbService;
-
+ @Autowired
+ private OssTemplate ossTemplate;
/**
* 鍒嗛〉
*/
@@ -42,5 +46,76 @@
public R<IPage<QinzheFgb>> page(String ljh,String zggy, Query query) {
return R.data(qinzheFgbService.lambdaQuery().like(StringUtils.isNotBlank(ljh), QinzheFgb::getLjh,ljh).like(StringUtils.isNotBlank(zggy), QinzheFgb::getZggy,zggy).page(Condition.getPage(query)));
}
+ @Operation(summary = "淇敼鍕ゅ摬", description = "淇敼鍕ゅ摬")
+ @PostMapping("/update-qz")
+ public R<Void> update(@RequestBody QinzheFgb fgb) {
+ try {
+ qinzheFgbService.updateFgb(fgb);
+ return R.success();
+ } catch (Exception e) {
+ throw new RuntimeException(e);
+ }
+ }
+
+
+ @Operation(summary = "鍒犻櫎鍕ゅ摬", description = "鍒犻櫎鍕ゅ摬")
+ @PostMapping("/remove-qz")
+ public R<Void> remove(@RequestParam String ljhs) {
+ try {
+
+ List<String> ljhlist = Func.toStrList(",",ljhs);
+ qinzheFgbService.lambdaUpdate().in(QinzheFgb::getLjh,ljhlist).remove();
+ return R.success();
+ } catch (Exception e) {
+ log.error("鍒犻櫎寮傚父",e);
+ return R.fail(e.getMessage());
+ }
+ }
+
+ @Operation(summary = "瀵煎叆鍕ゅ摬鍒嗗伐琛�", description = "瀵煎叆鍕ゅ摬鍒嗗伐琛�")
+ @PostMapping("/import-qinzhe")
+ public R<Void> importQinzheFgb(@RequestParam MultipartFile file) {
+ try {
+ qinzheFgbService.importFgb(file);
+ return R.success("瀵煎叆鎴愬姛");
+ }catch(Exception e) {
+ log.error("瀵煎叆寮傚父",e);
+ return R.fail(e.getMessage());
+ }
+ }
+
+ @Operation(summary = "涓嬭浇鍕ゅ摬鍒嗗伐琛ㄥ鍏ユā鏉�", description = "涓嬭浇鍕ゅ摬鍒嗗伐琛ㄥ鍏ユā鏉�")
+ @GetMapping("/download-template-qz")
+ public void downloadTemplate(HttpServletResponse response) {
+ String PARAMKEY = "QINZHE_TEMPLATE";
+
+ try {
+ String filename = "qinzhetemplate.xlsx";
+ response.setHeader("Content-Disposition", "attachment; filename="+filename);
+ response.setContentType("application/octet-stream");
+ String ossName = paramService.getParamValue(PARAMKEY,"");
+ try(InputStream ins = ossTemplate.statFileStream(ossName);){
+ IOUtils.copy(ins,response.getOutputStream());
+ }
+
+ } catch (Exception e) {
+ log.error("瀵煎嚭鍕ゅ摬鍒嗗伐琛ㄦā鏉垮紓甯�", e);
+ }
+ }
+
+ @Operation(summary = "鍕ゅ摬闆朵欢鍙锋悳绱㈠缓璁�", description = "鍕ゅ摬闆朵欢鍙锋悳绱㈠缓璁�")
+ @GetMapping("/select-data")
+ public R<List<QinzheFgb>> selectData(@RequestParam String drawingNo) {
+ if(StringUtils.isBlank(drawingNo)){
+ return R.data(Collections.emptyList());
+ }
+ try {
+ String ljh = drawingNo.trim();
+ return R.data(qinzheFgbService.lambdaQuery().likeRight(QinzheFgb::getLjh,ljh).last("LIMIT 20").list());
+ } catch (Exception e) {
+ log.error("鑾峰彇闆朵欢鍙峰紓甯�",e);
+ return R.fail(e.getMessage());
+ }
+ }
}
--
Gitblit v1.9.3