From 552c700f584700316e8d1919dd1ad7f551c53ec4 Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期二, 12 十一月 2024 10:03:22 +0800
Subject: [PATCH] fix : 新增日统计接口

---
 src/main/java/com/boying/controller/WhiteListController.java |   20 ++++++++++++++++----
 1 files changed, 16 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/boying/controller/WhiteListController.java b/src/main/java/com/boying/controller/WhiteListController.java
index c49ada2..6fba87b 100644
--- a/src/main/java/com/boying/controller/WhiteListController.java
+++ b/src/main/java/com/boying/controller/WhiteListController.java
@@ -13,6 +13,10 @@
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RestController;
 
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
 
 @RestController
 @RequestMapping("ffzf/whiteList")
@@ -27,8 +31,8 @@
     public Object findPage(Page page, String carNo) {
         QueryWrapper<WhiteList> wrapper = new QueryWrapper<>();
         wrapper.lambda()
-                .orderByDesc(WhiteList::getId)
-                .like(StringUtils.isNotBlank(carNo),WhiteList::getCarNo,carNo);
+                .like(StringUtils.isNotBlank(carNo),WhiteList::getCarNo,carNo)
+                .orderByDesc(WhiteList::getId);
         Page<WhiteList> page1 = whiteListService.page(page, wrapper);
         for (WhiteList record : page1.getRecords()) {
             if(record.getParkId() != null){
@@ -39,11 +43,19 @@
     }
 
     @PostMapping("/findPageNew")
-    public Object findPageNew(Page page, String carNo) {
+    public Object findPageNew(Page page, String carNo,Integer type,String date) throws ParseException {
+        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
+        if(StringUtils.isNotBlank(date)){
+            System.out.println(date);
+            Date parse = sdf.parse(date);
+            date = sdf.format(parse);
+        }
         QueryWrapper<WhiteList> wrapper = new QueryWrapper<>();
         wrapper.lambda()
                 .orderByDesc(WhiteList::getId)
-                .eq(StringUtils.isNotBlank(carNo),WhiteList::getCarNo,carNo);
+                .like(StringUtils.isNotBlank(carNo),WhiteList::getCarNo,carNo)
+                .eq(type!=null,WhiteList::getType,type)
+                .le(StringUtils.isNotBlank(date),WhiteList::getEndTime,date);
         Page<WhiteList> page1 = whiteListService.page(page, wrapper);
         for (WhiteList record : page1.getRecords()) {
             if(StringUtils.isNotBlank(record.getParkIds())){

--
Gitblit v1.9.1