| Line 55... |
Line 55... |
| 55 |
" JOIN warehouse.purchaseorder po ON po.id = p.purchaseOrder_id" +
|
55 |
" JOIN warehouse.purchaseorder po ON po.id = p.purchaseOrder_id" +
|
| 56 |
" JOIN warehouse.invoice inv ON p.invoice_id = inv.id AND po.supplierId = inv.supplierId AND po.warehouseId = ii2.physicalWarehouseId" +
|
56 |
" JOIN warehouse.invoice inv ON p.invoice_id = inv.id AND po.supplierId = inv.supplierId AND po.warehouseId = ii2.physicalWarehouseId" +
|
| 57 |
" JOIN warehouse.supplier su ON su.id = inv.supplierId AND su.internal = 0" +
|
57 |
" JOIN warehouse.supplier su ON su.id = inv.supplierId AND su.internal = 0" +
|
| 58 |
"" +
|
58 |
"" +
|
| 59 |
" where ((o.created_timestamp >= :startDate AND o.created_timestamp < :endDate) AND (o.billing_timestamp >= :startDate AND o.billing_timestamp < :endDate) AND o.refund_timestamp IS NULL)" +
|
59 |
" where ((o.created_timestamp >= :startDate AND o.created_timestamp < :endDate) AND (o.billing_timestamp >= :startDate AND o.billing_timestamp < :endDate) AND o.refund_timestamp IS NULL)" +
|
| 60 |
" and inv.invoiceDate < DATE_SUB(CURDATE(), INTERVAL 15 DAY)) b on b.customer_id = a.fofo_id" +
|
60 |
" and inv.invoiceDate < DATE_SUB(o.billing_timestamp, INTERVAL 15 DAY)) b on b.customer_id = a.fofo_id" +
|
| 61 |
" GROUP BY a.auth_id, a.Rbm_Name",
|
61 |
" GROUP BY a.auth_id, a.Rbm_Name",
|
| 62 |
resultSetMapping = "SoldAgingModel"),
|
62 |
resultSetMapping = "SoldAgingModel"),
|
| 63 |
|
63 |
|
| 64 |
})
|
64 |
})
|
| 65 |
|
65 |
|