Subversion Repositories SmartDukaan

Rev

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

Rev 34300 Rev 34322
Line 12... Line 12...
12 
        ),
 12 
        ),
13 
        @NamedQuery(
 13 
        @NamedQuery(
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 
        ),
- 
 
 18 
        @NamedQuery(
- 
 
 19 
                name = "Visit.FindRbmFeedback",
- 
 
 20 
                query = "SELECT r FROM RbmRating r" +
- 
 
 21 
                        " WHERE r.rbmId IN :rbmIds" +
- 
 
 22 
                        " AND r.createTimeStamp BETWEEN :startDate AND :endDate"
17 
        )
 23 
        )
18 
})
 24 
})
19 
public class RbmRating {
 25 
public class RbmRating {
20 
    @Id
 26 
    @Id
21 
    @Column(name = "id", unique = true, updatable = false)
 27 
    @Column(name = "id", unique = true, updatable = false)