| Line 51... |
Line 51... |
| 51 |
" JOIN warehouse.scanNew s ON s.orderId = o.id" +
|
51 |
" JOIN warehouse.scanNew s ON s.orderId = o.id" +
|
| 52 |
" JOIN warehouse.inventoryItem ii ON ii.id = s.inventoryItemId" +
|
52 |
" JOIN warehouse.inventoryItem ii ON ii.id = s.inventoryItemId" +
|
| 53 |
" JOIN warehouse.inventoryItem ii2 ON ii.serialNumber = ii2.serialNumber AND ii2.lastScanType != 'PURCHASE_RETURN'" +
|
53 |
" JOIN warehouse.inventoryItem ii2 ON ii.serialNumber = ii2.serialNumber AND ii2.lastScanType != 'PURCHASE_RETURN'" +
|
| 54 |
" JOIN warehouse.purchase p ON p.id = ii2.purchaseId" +
|
54 |
" JOIN warehouse.purchase p ON p.id = ii2.purchaseId" +
|
| 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.invoiceNumber = inv.invoiceNumber 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 DATEDIFF(NOW(), inv.invoiceDate) > 15" +
|
60 |
" and DATEDIFF(NOW(), inv.invoiceDate) > 15" +
|
| 61 |
" GROUP BY a.auth_id, a.Rbm_Name",
|
61 |
" GROUP BY a.auth_id, a.Rbm_Name",
|