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

Timestamp:

10/18/21 00:19:16 (3 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

188ee53

Parents:

fa375fe

Message:

editing location-form on frontend and backend

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

@@ -44 +44 @@
             "GROUP BY l.id_location ORDER BY CASE l.priority WHEN 'high' THEN 1 WHEN 'medium' THEN 2 WHEN 'low' THEN 3 END", nativeQuery = true)
     List<Location> findLocationsFromCountry(@Param("locName") String ime, @Param("companion") String companion, @Param("region") String region, @Param("categories") List<String> categories);
+
+    @Query(value = "SELECT  * FROM locations AS l  " +
+            "LEFT JOIN recommended_companion AS rc ON l.id_location = rc.id_location " +
+            "LEFT JOIN companions AS com ON rc.id_companion = com.id_companion " +
+            "LEFT JOIN locations_belong lb ON l.id_location = lb.id_location " +
+            "LEFT JOIN categories AS cate ON lb.id_category = cate.id_category " +
+            "LEFT JOIN regions AS r" +
+            " ON l.id_region = r.id_region" +
+            " LEFT JOIN cities AS cit" +
+            " ON r.id_region = cit.id_region AND cit.id_city = l.id_city " +
+            "WHERE cit.id_city = :locationId and com.id_companion = :companionId and cate.id_category in (:categories) " +
+            "GROUP BY l.id_location " +
+            "ORDER BY CASE l.priority WHEN 'high' THEN 1 WHEN 'medium' THEN 2 WHEN 'low' THEN 3 END", nativeQuery = true)
+    List<Location> findLocationsFromForm(@Param("locationId") Long locationId, @Param("companionId") Long companionId, @Param("categories") List<Long> categories);
 }