From 2a2d0aa9f6c42789faeb90ccda0bdf415614d533 Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期二, 05 八月 2025 10:46:58 +0800
Subject: [PATCH] 1
---
src/main/java/com/zy/asrs/controller/ReviewController.java | 47 ++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 44 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/ReviewController.java b/src/main/java/com/zy/asrs/controller/ReviewController.java
index bb93522..c5cff58 100644
--- a/src/main/java/com/zy/asrs/controller/ReviewController.java
+++ b/src/main/java/com/zy/asrs/controller/ReviewController.java
@@ -1,6 +1,7 @@
package com.zy.asrs.controller;
import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.core.annotations.ManagerAuth;
@@ -10,6 +11,7 @@
import com.core.common.SnowflakeIdWorker;
import com.core.exception.CoolException;
import com.zy.asrs.entity.Review;
+import com.zy.asrs.entity.ReviewDetl;
import com.zy.asrs.importexcle.ImportReviewDto;
import com.zy.asrs.importexcle.ImportReviewListener;
import com.zy.asrs.mapper.ReviewDetlMapper;
@@ -28,9 +30,10 @@
import org.springframework.web.multipart.MultipartFile;
import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
-import java.util.Date;
-import java.util.Map;
+import java.net.URLEncoder;
+import java.util.*;
@RestController
public class ReviewController extends BaseController {
@@ -47,6 +50,34 @@
@Resource
private ReviewDetlMapper reviewDetlMapper;
+
+ @Resource
+ private HttpServletResponse response;
+
+
+ @RequestMapping("/exportReview")
+ public synchronized void exportReview(String ids) throws IOException {
+ if (Cools.isEmpty(ids)) {
+ return;
+ }
+ String[] idsArr = ids.split(",");
+ Set set = new HashSet<Long>();
+ for (String id : idsArr) {
+ if (!Cools.isEmpty(id)) {
+ set.add(Long.parseLong(id));
+ }
+ }
+ List<ReviewDetl> reviewDetls = reviewDetlService.selectList(new EntityWrapper<ReviewDetl>().in("order_id", set));
+
+ 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(), ReviewDetl.class)
+ .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
+ .sheet("琛�1")
+ .doWrite(reviewDetls);
+ }
@PostMapping("/importReview")
@ManagerAuth(memo = "鍗曟嵁瀵煎叆")
@@ -65,7 +96,7 @@
public void importOrder(MultipartFile multipartFile) throws IOException {
// 鑰冩牳鏁版嵁鐨勫垽閲嶄娇鐢╫rder_id,check_type鐨勭粍鍚堝敮涓�绱㈠紩瑙ｅ喅
EasyExcel.read(multipartFile.getInputStream(), ImportReviewDto.class,
- new ImportReviewListener(transactionManager,reviewService, reviewDetlService, snowflakeIdWorker, getUserId())).sheet().doReadSync();
+ new ImportReviewListener(transactionManager, reviewService, reviewDetlService, snowflakeIdWorker, getUserId())).sheet().doReadSync();
}
@@ -117,4 +148,14 @@
return R.ok();
}
+
+ @RequestMapping(value = "/review/delete/auth")
+ @ManagerAuth(memo = "鎵嬪姩鍒犻櫎璁㈠崟")
+ @Transactional
+ public R delete(@RequestParam Long orderId) {
+ Review review = reviewService.selectById(orderId);
+ reviewDetlService.delete(new EntityWrapper<ReviewDetl>().eq("order_id", orderId));
+ reviewService.deleteById(orderId);
+ return R.ok();
+ }
}
--
Gitblit v1.9.1