| Line 370... |
Line 370... |
| 370 |
JOIN inventory.warehouse w ON w.id = s.warehouseId WHERE s.type in ('MARKED_BAD','DOA_IN','SALE_RET_UNUSABLE','DOA_REJECTED')
|
370 |
JOIN inventory.warehouse w ON w.id = s.warehouseId WHERE s.type in ('MARKED_BAD','DOA_IN','SALE_RET_UNUSABLE','DOA_REJECTED')
|
| 371 |
AND w.billingWarehouseId not in (9,12) AND s.scannedAt > '2013-01-01'
|
371 |
AND w.billingWarehouseId not in (9,12) AND s.scannedAt > '2013-01-01'
|
| 372 |
AND s.scannedAt < #{date} GROUP BY i.itemId, w.billingWarehouseId ) as x
|
372 |
AND s.scannedAt < #{date} GROUP BY i.itemId, w.billingWarehouseId ) as x
|
| 373 |
LEFT JOIN (SELECT i.itemId, sum(quantity) as outx, w.billingWarehouseId FROM scanNew s JOIN inventoryItem i on i.id = s.inventoryItemId
|
373 |
LEFT JOIN (SELECT i.itemId, sum(quantity) as outx, w.billingWarehouseId FROM scanNew s JOIN inventoryItem i on i.id = s.inventoryItemId
|
| 374 |
JOIN catalog.item c ON i.itemId = c.id JOIN inventory.warehouse w ON w.id = s.warehouseId
|
374 |
JOIN catalog.item c ON i.itemId = c.id JOIN inventory.warehouse w ON w.id = s.warehouseId
|
| 375 |
WHERE s.type in ('DOA_OUT','BAD_SALE','MARKED_GOOD','BAD_PURCHASE_RETURN','LOST_IN_WAREHOUSE_BAD')
|
375 |
WHERE s.type in ('DOA_OUT','BAD_SALE','MARKED_GOOD','BAD_PURCHASE_RETURN','LOST_IN_WAREHOUSE_BAD','EMPTY_PRODUCT_RECEIVED','WRONG_PRODUCT_RECEIVED')
|
| 376 |
AND w.billingWarehouseId not in (9,12) AND s.scannedAt > '2013-01-01'
|
376 |
AND w.billingWarehouseId not in (9,12) AND s.scannedAt > '2013-01-01'
|
| 377 |
AND s.scannedAt < #{date} GROUP BY i.itemId, w.billingWarehouseId ) as y ON (x.itemId = y.itemId
|
377 |
AND s.scannedAt < #{date} GROUP BY i.itemId, w.billingWarehouseId ) as y ON (x.itemId = y.itemId
|
| 378 |
AND x.billingWarehouseId = y.billingWarehouseId) JOIN catalog.item ci ON ci.id = x.itemId
|
378 |
AND x.billingWarehouseId = y.billingWarehouseId) JOIN catalog.item ci ON ci.id = x.itemId
|
| 379 |
JOIN inventory.warehouse wh on (x.billingWarehouseId = wh.id) having quantity>0) as z group by z.Item_Id
|
379 |
JOIN inventory.warehouse wh on (x.billingWarehouseId = wh.id) having quantity>0) as z group by z.Item_Id
|
| 380 |
</select>
|
380 |
</select>
|