Changeset ceaed42 for trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa

Timestamp:

11/11/21 12:59:26 (3 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

59329aa

Parents:

6c1585f

Message:

add location to planner

File:

• trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java (modified) (1 diff)

trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java

@@ -77 +77 @@
             "GROUP BY location.id_location ORDER BY CASE location.priority WHEN 'high' THEN 1 WHEN 'medium' THEN 2 WHEN 'low' THEN 3 END", nativeQuery = true)
     List<Location> findLocationsFromRegionForm(@Param("regionId") Long regionId, @Param("companionId") Long companionId, @Param("categoryIds") List<Long> categoryIds);
+
+    @Query(value = "SELECT * " +
+            "FROM locations AS l " +
+            "WHERE l.id_location IN " +
+            "(SELECT pl.id_location FROM planners_contain AS pl WHERE pl.id_planner = :plannerId)", nativeQuery = true)
+    List<Location> getAllLocationsForPlanner(@Param("plannerId") Long plannerId);
 }