Subversion Repositories SmartDukaan

Rev

Rev 36336 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 36336 Rev 36356
Line 24... Line 24...
24 
                        "FROM RbmRating v WHERE v.rbmId IN :rbmIds " +
 24 
                        "FROM RbmRating v WHERE v.rbmId IN :rbmIds " +
25 
                        "AND v.createTimeStamp BETWEEN :startDate AND :endDate " +
 25 
                        "AND v.createTimeStamp BETWEEN :startDate AND :endDate " +
26 
                        "GROUP BY v.rbmId"
 26 
                        "GROUP BY v.rbmId"
27 
        ),
 27 
        ),
28 
        @NamedQuery(
 28 
        @NamedQuery(
- 
 
 29 
                name = "Visit.FindUniquePartnerRatingByRbmIdsAndDateRange",
- 
 
 30 
                query = "SELECT new com.spice.profitmandi.dao.model.RbMRatingModel(v.rbmId, AVG(v.rating), COUNT(DISTINCT v.fofoId)) " +
- 
 
 31 
                        "FROM RbmRating v WHERE v.rbmId IN :rbmIds " +
- 
 
 32 
                        "AND v.createTimeStamp BETWEEN :startDate AND :endDate " +
- 
 
 33 
                        "GROUP BY v.rbmId"
- 
 
 34 
        ),
- 
 
 35 
        @NamedQuery(
29 
                name = "Visit.FindRbmFeedback",
 36 
                name = "Visit.FindRbmFeedback",
30 
                query = "SELECT r FROM RbmRating r" +
 37 
                query = "SELECT r FROM RbmRating r" +
31 
                        " WHERE r.rbmId IN :rbmIds" +
 38 
                        " WHERE r.rbmId IN :rbmIds" +
32 
                        " AND r.createTimeStamp BETWEEN :startDate AND :endDate"
 39 
                        " AND r.createTimeStamp BETWEEN :startDate AND :endDate"
33 
        )
 40 
        )