| Line 114... |
Line 114... |
| 114 |
" join PartnerPosition pp on pp.fofoId = o.retailerId\n" +
|
114 |
" join PartnerPosition pp on pp.fofoId = o.retailerId\n" +
|
| 115 |
" join Position p on p.id = pp.positionId\n" +
|
115 |
" join Position p on p.id = pp.positionId\n" +
|
| 116 |
"where o.refundTimestamp is null\n" +
|
116 |
"where o.refundTimestamp is null\n" +
|
| 117 |
" and ((o.createTimestamp between :startDate and :endDate) or (o.billingTimestamp between :startDate and :endDate))\n" +
|
117 |
" and ((o.createTimestamp between :startDate and :endDate) or (o.billingTimestamp between :startDate and :endDate))\n" +
|
| 118 |
" and fs.internal = false\n" +
|
118 |
" and fs.internal = false\n" +
|
| 119 |
" and p.categoryId = 18\n" +
|
119 |
" and p.categoryId = :categoryId\n" +
|
| 120 |
" and p.escalationType = 'L1'\n" +
|
120 |
" and p.escalationType = :escalationType\n" +
|
| 121 |
" and li.brand not in ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')\n" +
|
121 |
" and li.brand not in ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')\n" +
|
| 122 |
"group by p.authUserId, li.brand"),
|
122 |
"group by p.authUserId, li.brand"),
|
| 123 |
|
123 |
|
| 124 |
@NamedQuery(name = "Order.selectTodayPartnersBilledRBM", query = "select new com.spice.profitmandi.dao.model.AuthIdPartnerCountModel( p.authUserId,\n" +
|
124 |
@NamedQuery(name = "Order.selectTodayPartnersBilledRBM", query = "select new com.spice.profitmandi.dao.model.AuthIdPartnerCountModel( p.authUserId,\n" +
|
| 125 |
" cast (count(distinct o.retailerId) as int))\n" +
|
125 |
" cast (count(distinct o.retailerId) as int))\n" +
|