Subversion Repositories SmartDukaan

Rev

Rev 34322 | Rev 36336 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34322 Rev 36101
Line 14... Line 14...
14 
                name = "Visit.FindAverageRatingByRbmIds",
 14 
                name = "Visit.FindAverageRatingByRbmIds",
15 
                query = "SELECT new com.spice.profitmandi.dao.model.RbMRatingModel(v.rbmId, AVG(v.rating)) " +
 15 
                query = "SELECT new com.spice.profitmandi.dao.model.RbMRatingModel(v.rbmId, AVG(v.rating)) " +
16 
                        "FROM RbmRating v WHERE v.rbmId IN :rbmIds GROUP BY v.rbmId"
 16 
                        "FROM RbmRating v WHERE v.rbmId IN :rbmIds GROUP BY v.rbmId"
17 
        ),
 17 
        ),
18 
        @NamedQuery(
 18 
        @NamedQuery(
- 
 
 19 
                name = "Visit.FindAverageRatingByRbmIdsAndDateRange",
- 
 
 20 
                query = "SELECT new com.spice.profitmandi.dao.model.RbMRatingModel(v.rbmId, AVG(v.rating), COUNT(v.id)) " +
- 
 
 21 
                        "FROM RbmRating v WHERE v.rbmId IN :rbmIds " +
- 
 
 22 
                        "AND v.createTimeStamp BETWEEN :startDate AND :endDate " +
- 
 
 23 
                        "GROUP BY v.rbmId"
- 
 
 24 
        ),
- 
 
 25 
        @NamedQuery(
19 
                name = "Visit.FindRbmFeedback",
 26 
                name = "Visit.FindRbmFeedback",
20 
                query = "SELECT r FROM RbmRating r" +
 27 
                query = "SELECT r FROM RbmRating r" +
21 
                        " WHERE r.rbmId IN :rbmIds" +
 28 
                        " WHERE r.rbmId IN :rbmIds" +
22 
                        " AND r.createTimeStamp BETWEEN :startDate AND :endDate"
 29 
                        " AND r.createTimeStamp BETWEEN :startDate AND :endDate"
23 
        )
 30 
        )