Changeset a70b5a4 for src/main/java/com/example/skychasemk

Timestamp:

02/13/25 11:03:11 (4 months ago)

Author:

ste08 <sjovanoska@…>

Branches:

master

Children:

9868304

Parents:

3d60932

Message:

Report added

Location:

src/main/java/com/example/skychasemk

Files:

• controller/ReviewController.java (modified) (3 diffs)
• controller/TopMonthlyReportController.java (added)
• model/TopMonthlyReport.java (added)
• repository/ReviewRepository.java (modified) (2 diffs)
• repository/TopMonthlyReportRepository.java (added)
• services/ReviewService.java (modified) (1 diff)
• services/TopMonthlyReportService.java (added)

src/main/java/com/example/skychasemk/controller/ReviewController.java

@@ -3 +3 @@
 import com.example.skychasemk.dto.ReviewDTO;
 import com.example.skychasemk.model.Review;
+import com.example.skychasemk.repository.ReviewRepository;
 import com.example.skychasemk.services.ReviewService;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -17 +18 @@
     @Autowired
     private ReviewService reviewService;
+    @Autowired
+    private ReviewRepository reviewRepository;
 
     // Get all reviews
@@ -22 +25 @@
     public List<Review> getAllReviews() {
         return reviewService.getAllReviews();
+    }
+
+
+    @GetMapping("/{flightId}")
+    public List<Review> getReviewsByFlightId(@PathVariable("flightId") Integer flightId) {
+        return reviewRepository.findReviews(flightId);
     }
 

src/main/java/com/example/skychasemk/repository/ReviewRepository.java

@@ -4 +4 @@
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
 
 import java.util.List;
@@ -9 +10 @@
 public interface ReviewRepository extends JpaRepository<Review, Integer> {
     @Query("SELECT r from Review r where r.targetID = :flightId")
-    List<Review> findReviews();
+    List<Review> findReviews(@Param("flightId") Integer flightId);
 }
 

src/main/java/com/example/skychasemk/services/ReviewService.java

@@ -18 +18 @@
 
     public List<Review> getAllReviews() {
-        return reviewRepository.findReviews();
+        return reviewRepository.findAll();
     }