| Line 8... |
Line 8... |
| 8 |
@Table(name = "fofo.sales_rating")
|
8 |
@Table(name = "fofo.sales_rating")
|
| 9 |
@NamedQueries({
|
9 |
@NamedQueries({
|
| 10 |
@NamedQuery(name = "SalesRatingByMonth", query = "" +
|
10 |
@NamedQuery(name = "SalesRatingByMonth", query = "" +
|
| 11 |
"SELECT r FROM SalesRating r WHERE r.fofoId = :fofoId AND r.salesL1Id = :salesL1Id AND r.createTimeStamp BETWEEN :startOfMonth AND :endOfMonth"
|
11 |
"SELECT r FROM SalesRating r WHERE r.fofoId = :fofoId AND r.salesL1Id = :salesL1Id AND r.createTimeStamp BETWEEN :startOfMonth AND :endOfMonth"
|
| 12 |
),
|
12 |
),
|
| - |
|
13 |
@NamedQuery(name = "SalesRatingByFofoIdAndWeek", query = "" +
|
| - |
|
14 |
"SELECT r FROM SalesRating r WHERE r.fofoId = :fofoId AND r.createTimeStamp BETWEEN :startOfMonth AND :endOfMonth"
|
| - |
|
15 |
),
|
| 13 |
@NamedQuery(
|
16 |
@NamedQuery(
|
| 14 |
name = "Visit.FindAverageRatingBySalesL1Ids",
|
17 |
name = "Visit.FindAverageRatingBySalesL1Ids",
|
| 15 |
query = "SELECT new com.spice.profitmandi.dao.model.SalesRatingModel(v.salesL1Id, AVG(v.rating)) " +
|
18 |
query = "SELECT new com.spice.profitmandi.dao.model.SalesRatingModel(v.salesL1Id, AVG(v.rating)) " +
|
| 16 |
"FROM SalesRating v WHERE v.salesL1Id IN :salesL1Ids GROUP BY v.salesL1Id"
|
19 |
"FROM SalesRating v WHERE v.salesL1Id IN :salesL1Ids GROUP BY v.salesL1Id"
|
| 17 |
),
|
20 |
),
|