This is the codeAbility Sharing Platform! Learn more about the codeAbility Sharing Platform.

Skip to content
Snippets Groups Projects

Resolve "Reviewing Badges: Zusätzliche Icons"

Merged Michael Breu requested to merge 397-reviewing-badges-zusatzliche-icons into development
Files
9
@@ -3,9 +3,7 @@ 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;
@@ -35,12 +33,12 @@ 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 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 ReviewRating rr WHERE rr.user = :user GROUP BY status"
"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 ReviewRating rr WHERE rr.user = :user GROUP BY status")
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")