Changeset deea3c4 for src/main/java/com/example/rezevirajmasa/demo/repository

Timestamp:

04/28/25 14:21:17 (3 weeks ago)

Author:

Aleksandar Panovski <apano77@…>

Branches:

main

Children:

e15e8d9

Parents:

f5b256e

Message:

Big change done fully handle_reservation_update() trigger works

Location:

src/main/java/com/example/rezevirajmasa/demo/repository

Files:

• ReservationRepository.java (modified) (1 diff)
• TableRepository.java (modified) (1 diff)

src/main/java/com/example/rezevirajmasa/demo/repository/ReservationRepository.java

@@ -15 +15 @@
     List<Reservation> findByCheckInTimeAfterAndCheckInTimeBefore(LocalDateTime startTime, LocalDateTime endTime);
     List<Reservation> findALlByUserAndCheckInTimeBefore(User user, LocalDateTime now);
+    List<Reservation> findAllByUser(User user);
+
+    List<Reservation> findAllByUserAndCheckInTimeAfter(User user, LocalDateTime now);
+
+    List<Reservation> findAllByUserAndCheckInTimeBefore(User user, LocalDateTime now);
+    List<Reservation> findAllByTableAndCheckInTime(TableEntity table, LocalDateTime now);
+    List<Reservation> findAllByRestaurantAndCheckInTimeAfter(Restaurant restaurant, LocalDateTime now);
 }

src/main/java/com/example/rezevirajmasa/demo/repository/TableRepository.java

@@ -12 +12 @@
 public interface TableRepository extends JpaRepository<TableEntity, Long> {
     List<TableEntity> findByRestaurant(Restaurant restaurant);
-//    @Query("SELECT t FROM TableEntity t JOIN FETCH t.restaurant WHERE t.id = :id")
-//    TableEntity findTableEntityByIdWithRestaurant(@Param("id") Long id);
-    List<TableEntity> findAllByTimeSlotsContainingAndCapacityGreaterThanEqual(LocalDateTime timeSlot, Integer partySize);
+    List<TableEntity> findAllByCapacityGreaterThanEqual(int capacity);
+    @Query("SELECT t FROM TableEntity t WHERE t.capacity >= :capacity AND NOT EXISTS (" +
+            "SELECT r FROM t.reservations r WHERE r.checkInTime <= :checkOutTime AND r.checkOutTime >= :checkInTime)")
+    List<TableEntity> findAvailableTables(@Param("checkInTime") LocalDateTime checkInTime,
+                                          @Param("checkOutTime") LocalDateTime checkOutTime,
+                                          @Param("capacity") int capacity);
 }