From 1b201ef1ff8a098b6c2fa31d89e7c53650012af9 Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期一, 04 八月 2025 17:31:45 +0800
Subject: [PATCH] 1
---
src/main/java/com/zy/asrs/controller/ReviewController.java | 38 ++++++++++++++++++++++++++++++++++----
1 files changed, 34 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/ReviewController.java b/src/main/java/com/zy/asrs/controller/ReviewController.java
index f2af395..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;
@@ -29,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 {
@@ -48,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 = "鍗曟嵁瀵煎叆")
@@ -66,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();
}
@@ -122,7 +152,7 @@
@RequestMapping(value = "/review/delete/auth")
@ManagerAuth(memo = "鎵嬪姩鍒犻櫎璁㈠崟")
@Transactional
- public R delete(@RequestParam Long orderId){
+ public R delete(@RequestParam Long orderId) {
Review review = reviewService.selectById(orderId);
reviewDetlService.delete(new EntityWrapper<ReviewDetl>().eq("order_id", orderId));
reviewService.deleteById(orderId);
--
Gitblit v1.9.1