| Line 14... |
Line 14... |
| 14 |
" JOIN catalog.item i on i.id=li.item_id" +
|
14 |
" JOIN catalog.item i on i.id=li.item_id" +
|
| 15 |
" JOIN catalog.tag_listing t on t.item_id=i.id" +
|
15 |
" JOIN catalog.tag_listing t on t.item_id=i.id" +
|
| 16 |
" JOIN catalog.catagoriesd_catalog cc on (cc.catalog_id=i.catalog_item_id and (cc.start_date <= o.billing_timestamp AND (cc.end_date IS NULL or cc.end_date > o.billing_timestamp)))" +
|
16 |
" JOIN catalog.catagoriesd_catalog cc on (cc.catalog_id=i.catalog_item_id and (cc.start_date <= o.billing_timestamp AND (cc.end_date IS NULL or cc.end_date > o.billing_timestamp)))" +
|
| 17 |
" WHERE (o.billing_timestamp >= :startDate AND o.billing_timestamp < :endDate and o.refund_timestamp is null) and li.brand not in ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')" +
|
17 |
" WHERE (o.billing_timestamp >= :startDate AND o.billing_timestamp < :endDate and o.refund_timestamp is null) and li.brand not in ('Smartdukaan', 'Dummy', 'FOC', 'Live Demo')" +
|
| 18 |
" GROUP BY o.customer_id , i.catalog_item_id",
|
18 |
" GROUP BY o.customer_id , i.catalog_item_id",
|
| 19 |
resultSetMapping = "SeoldCatalogReport"),
|
19 |
resultSetMapping = "SoldCatalogReport"),
|
| 20 |
|
20 |
|
| 21 |
})
|
21 |
})
|
| 22 |
|
22 |
|
| 23 |
@SqlResultSetMappings({
|
23 |
@SqlResultSetMappings({
|
| 24 |
|
24 |
|
| 25 |
@SqlResultSetMapping(name = "SeoldCatalogReport",
|
25 |
@SqlResultSetMapping(name = "SoldCatalogReport",
|
| 26 |
classes = {@ConstructorResult(targetClass = SoldCatalogsReportModel.class,
|
26 |
classes = {@ConstructorResult(targetClass = SoldCatalogsReportModel.class,
|
| 27 |
columns = {
|
27 |
columns = {
|
| 28 |
@ColumnResult(name = "customer_name", type = String.class),
|
28 |
@ColumnResult(name = "customer_name", type = String.class),
|
| 29 |
@ColumnResult(name = "warehouse_id", type = Integer.class),
|
29 |
@ColumnResult(name = "warehouse_id", type = Integer.class),
|
| 30 |
@ColumnResult(name = "billing_warehouse ", type = Integer.class),
|
30 |
@ColumnResult(name = "billing_warehouse ", type = Integer.class),
|