From be76c17568e365170626c88963bfb9e16fb38793 Mon Sep 17 00:00:00 2001
From: nickchange <126672920+nickchange@users.noreply.github.com>
Date: 星期三, 18 十月 2023 10:37:44 +0800
Subject: [PATCH] 10.18

---
 cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java |  192 +++++++++++++++++++++++++++++++++++++----------
 1 files changed, 149 insertions(+), 43 deletions(-)

diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java
index 27297b4..471b41c 100644
--- a/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java
+++ b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java
@@ -28,6 +28,7 @@
 import java.math.BigDecimal;
 import java.math.RoundingMode;
 import java.text.SimpleDateFormat;
+import java.time.LocalTime;
 import java.util.*;
 
 /**
@@ -115,7 +116,10 @@
         querySiteInfoVo.setStoreLat(store.getLat());
         querySiteInfoVo.setStorePhone(store.getPhone());
         querySiteInfoVo.setImgs(site.getImgs());
+
         querySiteInfoVo.setDistance(0D);
+
+
         querySiteInfoVo.setCashPriceOne(site.getCashPriceOne());
         if(site.getPlayPaiCoinOne()!=null){
             querySiteInfoVo.setPlayPaiCoinOne(site.getPlayPaiCoinOne().intValue());
@@ -148,6 +152,13 @@
     }
 
 
+
+
+
+    @Autowired
+    private ISiteBookingService iSiteBookingService;
+    @Autowired
+    private ISiteService siteService;
     /**
      * 获取场地预约日期数据
      * @param id
@@ -157,56 +168,151 @@
      */
     @Override
     public List<QuerySiteTimes> querySiteTimes(Integer id, String day) throws Exception {
-        Site site = this.getById(id);
-        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
-        Calendar s = Calendar.getInstance();
-        s.setTime(sdf.parse(day + " " + site.getAppointmentStartTime()));
-        Calendar e = Calendar.getInstance();
-        e.setTime(sdf.parse(day + " " + site.getAppointmentEndTime()));
+//        Site site = this.getById(id);
+//        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
+//        Calendar s = Calendar.getInstance();
+//        s.setTime(sdf.parse(day + " " + site.getAppointmentStartTime()));
+//        Calendar e = Calendar.getInstance();
+//        e.setTime(sdf.parse(day + " " + site.getAppointmentEndTime()));
+//
+//        int hour = e.get(Calendar.HOUR_OF_DAY);
+//
+//        int minute = e.get(Calendar.MINUTE);
+//
+//        List<QuerySiteTimes> list = new ArrayList<>();
+//
+//        SimpleDateFormat sdfs = new SimpleDateFormat("HH:mm");
+//
+//        while (true){
+//
+//            String start = sdfs.format(s.getTime());
+//
+//            s.set(Calendar.MINUTE, s.get(Calendar.MINUTE) + 30);
+//
+//            int e_hour = s.get(Calendar.HOUR_OF_DAY);
+//
+//            int e_minute = s.get(Calendar.MINUTE);
+//
+//            String end = sdfs.format(s.getTime());
+//
+//            QuerySiteTimes querySiteTimes = new QuerySiteTimes();
+//
+//            querySiteTimes.setTime(start + "-" + end);
+//
+//            querySiteTimes.setSelectable(1);
+//
+//            SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>().eq("siteId", id).eq("state", 1)
+//                    .in("status", Arrays.asList(3, 4, 5)).last(" and DATE_FORMAT(startTime, '%Y-%m-%d %H:%i') <= '" + day + " " + start + "' and DATE_FORMAT(endTime, '%Y-%m-%d %H:%i') >= '" + day + " " + end + "'"));
+//            if(null != siteBooking){
+//                querySiteTimes.setSelectable(0);
+//            }
+//            int count = siteLockService.count(new QueryWrapper<SiteLock>().eq("siteId", id).last(" and DATE_FORMAT(startTime, '%Y-%m-%d %H:%i') <= '" + day + " " + start + "' and DATE_FORMAT(endTime, '%Y-%m-%d %H:%i') >= '" + day + " " + end + "'"));
+//            if(count > 0){
+//                querySiteTimes.setSelectable(0);
+//            }
+//
+//            list.add(querySiteTimes);
+//
+//            if(e_hour == hour && minute == e_minute){
+//                break;
+//            }
+//        }
+//        return list;
 
-        int hour = e.get(Calendar.HOUR_OF_DAY);
+        System.out.println("=======date======"+day);
 
-        int minute = e.get(Calendar.MINUTE);
+        List<String> strings = new ArrayList<>();
 
-        List<QuerySiteTimes> list = new ArrayList<>();
+//        List<SiteBooking> siteBookings = siteClient.listBooks(id);
+        List<SiteBooking> siteBookings = iSiteBookingService.list(new QueryWrapper<SiteBooking>().eq("siteId", id).like("times",date));
+        System.out.println("=======siteBookings======"+siteBookings);
+        for (SiteBooking siteBooking : siteBookings) {
+            String[] split = siteBooking.getTimes().split(";");
+            for (String s : split) {
 
-        SimpleDateFormat sdfs = new SimpleDateFormat("HH:mm");
-
-        while (true){
-
-            String start = sdfs.format(s.getTime());
-
-            s.set(Calendar.MINUTE, s.get(Calendar.MINUTE) + 30);
-
-            int e_hour = s.get(Calendar.HOUR_OF_DAY);
-
-            int e_minute = s.get(Calendar.MINUTE);
-
-            String end = sdfs.format(s.getTime());
-
-            QuerySiteTimes querySiteTimes = new QuerySiteTimes();
-
-            querySiteTimes.setTime(start + "-" + end);
-
-            querySiteTimes.setSelectable(1);
-
-            SiteBooking siteBooking = siteBookingService.getOne(new QueryWrapper<SiteBooking>().eq("siteId", id).eq("state", 1)
-                    .in("status", Arrays.asList(3, 4, 5)).last(" and DATE_FORMAT(startTime, '%Y-%m-%d %H:%i') <= '" + day + " " + start + "' and DATE_FORMAT(endTime, '%Y-%m-%d %H:%i') >= '" + day + " " + end + "'"));
-            if(null != siteBooking){
-                querySiteTimes.setSelectable(0);
-            }
-            int count = siteLockService.count(new QueryWrapper<SiteLock>().eq("siteId", id).last(" and DATE_FORMAT(startTime, '%Y-%m-%d %H:%i') <= '" + day + " " + start + "' and DATE_FORMAT(endTime, '%Y-%m-%d %H:%i') >= '" + day + " " + end + "'"));
-            if(count > 0){
-                querySiteTimes.setSelectable(0);
+                String convertedValue = s.substring(11);
+                strings.add(convertedValue);
             }
 
-            list.add(querySiteTimes);
-
-            if(e_hour == hour && minute == e_minute){
-                break;
-            }
         }
-        return list;
+        System.out.println("======strings======="+strings);
+
+
+        List<QuerySiteTimes> timeRanges = new ArrayList<>();
+
+
+        Site site =  siteService.getById(id);
+        System.out.println("================"+site);
+        String appointmentStartTime = site.getAppointmentStartTime();
+        String appointmentEndTime = site.getAppointmentEndTime();
+
+        String currentTime = appointmentStartTime;
+        while (currentTime.compareTo(appointmentEndTime) < 0) {
+            String nextTime = getNextTime(currentTime);
+
+
+            String timeRange = currentTime + "-" + nextTime;
+            QuerySiteTimes orderDto = new QuerySiteTimes();
+            orderDto.setTime(timeRange);
+
+            LocalTime currentTime1 = LocalTime.now();
+            LocalTime targetTime = LocalTime.parse(currentTime);
+
+            boolean hasExceeded = currentTime1.isAfter(targetTime);
+            if (hasExceeded){
+                orderDto.setSelectable(0);
+            }
+            if (strings.contains(timeRange)){
+                orderDto.setSelectable(0);
+            }
+
+
+            timeRanges.add(orderDto);
+            currentTime = nextTime;
+        }
+        System.out.println("-------------"+timeRanges);
+
+        return timeRanges;
+
+
+
+
+
+    }
+
+
+    public static String getNextTime(String currentTime) {
+        String[] parts = currentTime.split(":");
+        int hour = Integer.parseInt(parts[0]);
+        int minute = Integer.parseInt(parts[1]);
+
+        if (minute == 30) {
+            hour++;
+            minute = 0;
+        } else {
+            minute = 30;
+        }
+
+        return String.format("%02d:%02d", hour, minute);
+
+//        String[] parts = currentTime.split(":");
+//        int hour = Integer.parseInt(parts[0]);
+//        int minute = Integer.parseInt(parts[1]);
+//
+//        if (minute == 45) {
+//            hour++;
+//            minute = 0;
+//        } else if (minute == 0){
+//            minute = 15;
+//        }else if (minute == 15){
+//            minute = 30;
+//        }else if (minute == 30){
+//            minute = 45;
+//        }
+//
+//        return String.format("%02d:%02d", hour, minute);
+
+
     }
 
 

--
Gitblit v1.7.1