Changeset 59329aa for trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java

Timestamp:

11/23/21 14:58:44 (3 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

e29cc2e

Parents:

ceaed42

Message:

adding photos

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

@@ -83 +83 @@
             "(SELECT pl.id_location FROM planners_contain AS pl WHERE pl.id_planner = :plannerId)", nativeQuery = true)
     List<Location> getAllLocationsForPlanner(@Param("plannerId") Long plannerId);
+
+    @Query(value = "SELECT *, if(l.id_city is NOT NULL, c.city_name, l.location_name) as result " +
+            "FROM locations AS l " +
+            "LEFT JOIN cities AS c " +
+            "ON l.id_city = c.id_city " +
+            "LEFT JOIN locations_belong AS lb " +
+            "ON l.id_location = lb.id_location " +
+            "WHERE lb.id_category=20", nativeQuery = true)
+    List<Location> getWeekendGetaways();
+
+    @Query(value = "SELECT *, if(l.id_city is NOT NULL, c.city_name, l.location_name) as result " +
+            "FROM locations AS l " +
+            "LEFT JOIN cities AS c " +
+            "ON l.id_city = c.id_city " +
+            "LEFT JOIN locations_belong AS lb " +
+            "ON l.id_location = lb.id_location " +
+            "WHERE lb.id_category=4", nativeQuery = true)
+    List<Location> getVillages();
 }