Resolve "Reviewing Badges: Zusätzliche Icons"

Related to #397 (closed)

src/main/java/at/ac/uibk/gitsearch/repository/jpa/ReviewRatingJPARepository.java

@@ -3,7 +3,9 @@ package at.ac.uibk.gitsearch.repository.jpa;
 import at.ac.uibk.gitsearch.domain.ReviewRating;
 import at.ac.uibk.gitsearch.domain.User;
 import at.ac.uibk.gitsearch.domain.enumeration.ReviewStatus;
+
 import java.util.List;
+
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;
@@ -33,16 +35,16 @@ public interface ReviewRatingJPARepository extends JpaRepository<ReviewRating, L
     @Query("SELECT rr FROM  ReviewRating rr WHERE rr.review.id=:reviewId")
     List<ReviewRating> findByReview(@Param("reviewId") Long reviewId);
 
-    @Query("SELECT rr.status as status, count(*) as statusCount from ReviewRating rr WHERE rr.user = :user group by status")
-    List<StatusAndCount> countReviewsForUserByStatus(@Param("user") User user);
+    @Query("SELECT rr.status as status, count(*) as statusCount FROM Review r LEFT JOIN ReviewRating rr ON rr.review = r WHERE r.requestedBy = :userId GROUP BY status")
+    List<StatusAndCount> countReviewsForUserByStatus(@Param("userId") long userIdl);
 
     @Query(
-        "SELECT rr.status as status, count(*) as statusCount from Review r LEFT JOIN ReviewRating rr ON rr.review=r.id WHERE r.requestedBy = :userId GROUP BY status"
+    "SELECT rr.status as status, count(*) as statusCount FROM ReviewRating rr WHERE rr.user = :user GROUP BY status"
     )
-    List<StatusAndCount> countReviewsForRequestingUserByStatus(@Param("userId") Long userId);
+    List<StatusAndCount> countReviewsTasksForUserByStatus(@Param("user") User user);
 
     @Query("SELECT count(*) as statusCount from Review r LEFT JOIN ReviewRating rr ON rr.review=r.id WHERE r.requestedBy = :userId")
-    Integer countReviewsRequestedByUser(@Param("userId") Long userId);
+    Integer countreviewsRequestedByReviewer(@Param("userId") Long userId);
 
     @Query(
         "SELECT count(*) as statusCount from Review r JOIN Statistics s ON r.resourceid = s.exerciseID WHERE r.requestedBy = :userId AND s.badgeRewarded=true "