From 783b9ee7a8caa508d123d34bfbbf294716211dd7 Mon Sep 17 00:00:00 2001 From: nickchange <126672920+nickchange@users.noreply.github.com> Date: 星期三, 18 十月 2023 16:50:16 +0800 Subject: [PATCH] 10.18.2 --- cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java | 198 ++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 160 insertions(+), 38 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..fbb18c6 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 @@ -156,57 +167,168 @@ * @throws Exception */ @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())); + public List<QuerySiteTimes> querySiteTimes(Integer id, String day,String halfName,String siteName) 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())); +// +// 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).eq("nextName",siteName).like("times",day)); + System.out.println("=======siteBookings======"+siteBookings); + for (SiteBooking siteBooking : siteBookings) { - SimpleDateFormat sdfs = new SimpleDateFormat("HH:mm"); - while (true){ + String[] split = siteBooking.getTimes().split(";"); - String start = sdfs.format(s.getTime()); + if (siteBooking.getIsHalf() == 2) { + for (String s : split) { + String convertedValue = s.substring(11); + strings.add(convertedValue); + } + }else { - s.set(Calendar.MINUTE, s.get(Calendar.MINUTE) + 30); + if (siteBooking.getHalfName().equals(halfName)){ + for (String s : split) { + String convertedValue = s.substring(11); + strings.add(convertedValue); + } - 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; + 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); + }else { + orderDto.setSelectable(1); + } + + + 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); + + } @@ -225,7 +347,7 @@ for (String s : split) { String day = s.split(" ")[0]; String time = s.split(" ")[1]; - List<QuerySiteTimes> querySiteTimes = querySiteTimes(reservationSite.getId(), day); + List<QuerySiteTimes> querySiteTimes = querySiteTimes(reservationSite.getId(), day,reservationSite.getHalfName(),reservationSite.getNextName()); for (QuerySiteTimes querySiteTime : querySiteTimes) { if(querySiteTime.getTime().equals(time) && querySiteTime.getSelectable() == 0){ return ResultUtil.error("【" + s + "】时间段已被使用"); -- Gitblit v1.7.1