| Line 8... |
Line 8... |
| 8 |
@Table(name = "fofo.rbm_rating")
|
8 |
@Table(name = "fofo.rbm_rating")
|
| 9 |
@NamedQueries({
|
9 |
@NamedQueries({
|
| 10 |
@NamedQuery(name = "RbMRatingByMonth", query = "" +
|
10 |
@NamedQuery(name = "RbMRatingByMonth", query = "" +
|
| 11 |
"SELECT r FROM RbmRating r WHERE r.fofoId = :fofoId AND r.rbmId = :rbmId AND r.createTimeStamp BETWEEN :startOfMonth AND :endOfMonth"
|
11 |
"SELECT r FROM RbmRating r WHERE r.fofoId = :fofoId AND r.rbmId = :rbmId AND r.createTimeStamp BETWEEN :startOfMonth AND :endOfMonth"
|
| 12 |
),
|
12 |
),
|
| - |
|
13 |
@NamedQuery(name = "RbMRatingByFofoIdAndWeek", query = "" +
|
| - |
|
14 |
"SELECT r FROM RbmRating r WHERE r.fofoId = :fofoId AND r.createTimeStamp BETWEEN :startOfMonth AND :endOfMonth"
|
| - |
|
15 |
),
|
| 13 |
@NamedQuery(
|
16 |
@NamedQuery(
|
| 14 |
name = "Visit.FindAverageRatingByRbmIds",
|
17 |
name = "Visit.FindAverageRatingByRbmIds",
|
| 15 |
query = "SELECT new com.spice.profitmandi.dao.model.RbMRatingModel(v.rbmId, AVG(v.rating)) " +
|
18 |
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"
|
19 |
"FROM RbmRating v WHERE v.rbmId IN :rbmIds GROUP BY v.rbmId"
|
| 17 |
),
|
20 |
),
|