Changeset 23a2bc5

Timestamp:

01/03/23 03:14:50 (18 months ago)

Author:

andrejtodorovski <82031894+andrejtodorovski@…>

Branches:

main

Children:

eaf0f1b

Parents:

101cbe2

Message:

Added some views and tested them

Location:

src/main/java/com/example/autopartz

Files:

• controller/UserController.java (modified) (3 diffs)
• model/OrdersForUser.java (added)
• model/OrdersForUserId.java (added)
• model/Part.java (modified) (2 diffs)
• model/PartsForCarTypeAndCategory.java (added)
• model/RepairShopReviewsSummary.java (modified) (1 diff)
• model/RepairsForUser.java (added)
• model/ReviewsForUser.java (added)
• repository/OrdersForUserRepository.java (added)
• repository/PartsForCarTypeAndCategoryRepository.java (added)
• repository/RepairsForUserRepository.java (added)
• repository/ReviewsForUserRepository.java (added)

src/main/java/com/example/autopartz/controller/UserController.java

@@ -1 +1 @@
 package com.example.autopartz.controller;
 
-import com.example.autopartz.model.RepairShopReviewsSummary;
-import com.example.autopartz.model.User;
-import com.example.autopartz.repository.RepairShopReviewSummaryRepository;
+import com.example.autopartz.model.*;
+import com.example.autopartz.repository.*;
 import com.example.autopartz.service.UserService;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.bind.annotation.*;
 
 import java.util.List;
@@ -15 +12 @@
 public class UserController {
     private final UserService userService;
-    private final RepairShopReviewSummaryRepository rspsr;
+    private final RepairShopReviewSummaryRepository repairShopReviewSummaryRepository;
+    private final PartsForCarTypeAndCategoryRepository partsForCarTypeAndCategoryRepository;
 
-    public UserController(UserService userService, RepairShopReviewSummaryRepository rspsr) {
+    private final OrdersForUserRepository ordersForUserRepository;
+    private final RepairsForUserRepository repairsForUserRepository;
+    private final ReviewsForUserRepository reviewsForUserRepository;
+    public UserController(UserService userService, RepairShopReviewSummaryRepository repairShopReviewSummaryRepository, PartsForCarTypeAndCategoryRepository partsForCarTypeAndCategoryRepository, OrdersForUserRepository ordersForUserRepository, RepairsForUserRepository repairsForUserRepository, ReviewsForUserRepository reviewsForUserRepository) {
         this.userService = userService;
-        this.rspsr = rspsr;
+        this.repairShopReviewSummaryRepository = repairShopReviewSummaryRepository;
+        this.partsForCarTypeAndCategoryRepository = partsForCarTypeAndCategoryRepository;
+        this.ordersForUserRepository = ordersForUserRepository;
+        this.repairsForUserRepository = repairsForUserRepository;
+        this.reviewsForUserRepository = reviewsForUserRepository;
     }
     @GetMapping("reportTest")
     public List<RepairShopReviewsSummary> getRepairShopReport(){
-        return rspsr.findAllByRsid(2L);
+        return repairShopReviewSummaryRepository.findAll();
     }
     @GetMapping("usersTest")
@@ -29 +34 @@
         return userService.findAllUsers();
     }
+    @GetMapping("parts")
+    public List<PartsForCarTypeAndCategory> getPartsForCarTypeAndCategory(@RequestParam String cartype, @RequestParam String category){
+        return partsForCarTypeAndCategoryRepository.findAllByCartypeAndCategory(cartype,category);
+    }
+    @GetMapping("orders/{id}")
+    public List<OrdersForUser> getOrdersForUser(@PathVariable Long id){
+        return ordersForUserRepository.findAllByUserid(id);
+    }
+    @GetMapping("repairs/{id}")
+    public List<RepairsForUser> getRepairsForUser(@PathVariable Long id){
+        return repairsForUserRepository.findAllByUserid(id);
+    }
+    @GetMapping("reviews/{id}")
+    public List<ReviewsForUser> getReviewsForUser(@PathVariable Long id){
+        return reviewsForUserRepository.findAllByUserid(id);
+    }
 }

src/main/java/com/example/autopartz/model/Part.java

@@ -1 +1 @@
 package com.example.autopartz.model;
 
-import jakarta.persistence.Entity;
-import jakarta.persistence.Id;
-import jakarta.persistence.JoinColumn;
-import jakarta.persistence.ManyToOne;
+import jakarta.persistence.*;
 import lombok.*;
 import org.hibernate.Hibernate;
 
+import java.util.ArrayList;
+import java.util.List;
 import java.util.Objects;
 
@@ -23 +22 @@
     @JoinColumn(name = "id_part_manufacturer")
     PartManufacturer partManufacturer;
+    @ManyToMany
+    @JoinTable(name = "part_is_from_category", joinColumns =
+    @JoinColumn(name = "id_part"),
+    inverseJoinColumns = @JoinColumn(name = "id_category"))
+    @ToString.Exclude
+    List<Category> categoryList;
 
     @Override

src/main/java/com/example/autopartz/model/RepairShopReviewsSummary.java

@@ -20 +20 @@
 @RequiredArgsConstructor
 @Immutable
-@Table(name = "repair_shop_reviews_summary")
-@Subselect("select * from repair_shop_reviews_summary")
+@Table(name = "`repair_shop_reviews_summary`")
 public class RepairShopReviewsSummary implements Serializable {
     @Serial