| Line 392... |
Line 392... |
| 392 |
" ON o.id = li.order_id" +
|
392 |
" ON o.id = li.order_id" +
|
| 393 |
" JOIN fofo.fofo_store fs ON fs.id = o.customer_id" +
|
393 |
" JOIN fofo.fofo_store fs ON fs.id = o.customer_id" +
|
| 394 |
" join catalog.item i on i.id = li.item_id" +
|
394 |
" join catalog.item i on i.id = li.item_id" +
|
| 395 |
" join catalog.catagoriesd_catalog cc on i.catalog_item_id = cc.catalog_id AND cc.end_date IS NULL" +
|
395 |
" join catalog.catagoriesd_catalog cc on i.catalog_item_id = cc.catalog_id AND cc.end_date IS NULL" +
|
| 396 |
" WHERE o.refund_timestamp IS NULL" +
|
396 |
" WHERE o.refund_timestamp IS NULL" +
|
| 397 |
" AND (" +
|
- |
|
| 398 |
" (o.created_timestamp BETWEEN :startDate AND :endDate)" +
|
397 |
" AND o.created_timestamp BETWEEN :startDate AND :endDate" +
|
| 399 |
" OR (o.billing_timestamp BETWEEN :startDate AND :endDate)" +
|
- |
|
| 400 |
" )" +
|
- |
|
| 401 |
" AND fs.internal = FALSE" +
|
398 |
" AND fs.internal = FALSE" +
|
| 402 |
" AND fs.active = TRUE" +
|
399 |
" AND fs.active = TRUE" +
|
| 403 |
" AND li.brand NOT IN ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')" +
|
400 |
" AND li.brand NOT IN ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')" +
|
| 404 |
"GROUP BY o.customer_id, i.catalog_item_id",
|
401 |
"GROUP BY o.customer_id, i.catalog_item_id",
|
| 405 |
resultSetMapping = "TodayPoByCatalog"
|
402 |
resultSetMapping = "TodayPoByCatalog"
|