From e8f0b3422d307c686b3a81269f9e9e4fb34a846e Mon Sep 17 00:00:00 2001
From: wjli <591616088@qq.com>
Date: 星期五, 12 四月 2024 10:49:46 +0800
Subject: [PATCH] 指纹登陆返回客户端加密信息
---
xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SignCountController.java | 40 ++++++++++++++++++++++++++++++++++++----
1 files changed, 36 insertions(+), 4 deletions(-)
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SignCountController.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SignCountController.java
index 43f2a49..720b10a 100644
--- a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SignCountController.java
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SignCountController.java
@@ -4,6 +4,7 @@
import cn.exrick.xboot.core.common.utils.ResultUtil;
import cn.exrick.xboot.core.common.vo.PageVo;
import cn.exrick.xboot.core.common.vo.Result;
+import cn.exrick.xboot.your.common.ExcelFillCellMergeStrategy;
import cn.exrick.xboot.your.entity.OrderStatusCount;
import cn.exrick.xboot.your.entity.QueryRequest;
import cn.exrick.xboot.your.entity.SignCount;
@@ -19,6 +20,7 @@
import org.springframework.web.bind.annotation.*;
import org.springframework.transaction.annotation.Transactional;
+import javax.annotation.security.PermitAll;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
@@ -32,6 +34,7 @@
@Api(tags = "鐘舵�佺粺璁℃姤琛ㄦ帴鍙�")
@RequestMapping("/xboot/signCount")
@Transactional
+@PermitAll
public class SignCountController {
@Autowired
@@ -83,21 +86,50 @@
@GetMapping("/outExcels")
@ApiOperation(value = "瀵煎嚭绛炬敹缁熻淇℃伅琛�", notes = "瀵煎嚭绛炬敹缁熻淇℃伅琛�")
- public void export1(OrderStatusCount orderStatusCount, HttpServletResponse response,QueryRequest queryRequest) throws IOException {
- List<OrderStatusCount> orderStatus = this.iSignCountService.signCounts(orderStatusCount,queryRequest).getRecords();
+ @PermitAll
+ public void export1(OrderStatusCount orderStatusCount, HttpServletResponse response) throws IOException {
+ if(orderStatusCount.getSendDateStart()!=null){
+ orderStatusCount.setSendDateStart(orderStatusCount.getSendDateStart() + " 00:00:00");
+ }
+ if(orderStatusCount.getSendDateEnd()!=null){
+ orderStatusCount.setSendDateEnd(orderStatusCount.getSendDateEnd() + " 23:59:59");
+ }
+ List<OrderStatusCount> orderStatus = this.iSignCountService.signCounts2New(orderStatusCount);
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
String fileName = URLEncoder.encode("绛炬敹鏁伴噺缁熻鎶ヨ〃", "UTF-8");
String fileName2 = new String(fileName.getBytes("UTF-8"), "ISO8859-1");
// response.setHeader("Content-dispostion", "attachment;filename="+fileName+".xls");
response.setHeader("Content-disposition", "attachment;filename=" + fileName2 + ".xlsx");
- EasyExcel.write(response.getOutputStream(),OrderStatusCount.class).
- sheet(0).doWrite(orderStatus);
+ EasyExcel.write(response.getOutputStream(),OrderStatusCount.class)
+ .registerWriteHandler(new ExcelFillCellMergeStrategy(1,new int[]{0,1,2,9})) // 鍩轰簬 column 闀垮害锛岃嚜鍔ㄩ�傞厤銆傛渶澶� 255 瀹藉害
+ .sheet(0).doWrite(orderStatus);
}
@GetMapping(value = "/selectBySign")
+ @ApiOperation(value = "绛炬敹缁熻淇℃伅琛�", notes = "绛炬敹缁熻淇℃伅琛�")
public Result<IPage<OrderStatusCount>> signCounts(OrderStatusCount orderStatusCount,QueryRequest queryRequest) {
+ if(orderStatusCount.getSendDateStart()!=null){
+ orderStatusCount.setSendDateStart(orderStatusCount.getSendDateStart() + " 00:00:00");
+ }
+ if(orderStatusCount.getSendDateEnd()!=null){
+ orderStatusCount.setSendDateEnd(orderStatusCount.getSendDateEnd() + " 23:59:59");
+ }
IPage<OrderStatusCount> data = this.iSignCountService.signCounts(orderStatusCount,queryRequest);
return new ResultUtil<IPage<OrderStatusCount>>().setData(data);
}
+
+ @GetMapping(value = "/selectBySignNew")
+ @ApiOperation(value = "绛炬敹缁熻淇℃伅琛�1", notes = "绛炬敹缁熻淇℃伅琛�1")
+ @PermitAll
+ public Result<IPage<OrderStatusCount>> signCountsNew(OrderStatusCount orderStatusCount,QueryRequest queryRequest) {
+ if(orderStatusCount.getSendDateStart()!=null){
+ orderStatusCount.setSendDateStart(orderStatusCount.getSendDateStart() + " 00:00:00");
+ }
+ if(orderStatusCount.getSendDateEnd()!=null){
+ orderStatusCount.setSendDateEnd(orderStatusCount.getSendDateEnd() + " 23:59:59");
+ }
+ IPage<OrderStatusCount> data = this.iSignCountService.signCountsNew(orderStatusCount,queryRequest);
+ return new ResultUtil<IPage<OrderStatusCount>>().setData(data);
+ }
}
--
Gitblit v1.9.1