Subversion Repositories SmartDukaan

Rev

Rev 8603 | Rev 8626 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 8603 Rev 8625
Line 123... Line 123...
123 
    FROM  (SELECT ii.id, ii.itemId, ii.currentQuantity, ii.purchaseId,
 123 
    FROM  (SELECT ii.id, ii.itemId, ii.currentQuantity, ii.purchaseId,
124 
                DATEDIFF(now(), MIN(s.scannedAt)) / 7 as age
 124 
                DATEDIFF(now(), MIN(s.scannedAt)) / 7 as age
125 
           FROM inventoryItem ii
125 
           FROM inventoryItem ii
126 
           JOIN scanNew s
126 
           JOIN scanNew s
127 
                ON (s.inventoryItemId = ii.id)
127 
                ON (s.inventoryItemId = ii.id)
128 
           WHERE ii.lastScanType IN ('PURCHASE', 'SALE_RET')
128 
           WHERE (ii.lastScanType IN ('PURCHASE', 'SALE_RET', 'MARKED_GOOD')
- 
 
 129 
           OR ii.currentQuantity>1)
- 
 
 130 
           AND ii.transferStatus!='IN_TRANSIT'
129 
           AND ii.physicalWarehouseId !=16
 131 
           AND ii.physicalWarehouseId !=16
130 
           GROUP BY ii.id, ii.itemId, ii.currentQuantity) t
132 
           GROUP BY ii.id, ii.itemId, ii.currentQuantity) t
131 
    JOIN purchase p
133 
    JOIN purchase p
132 
        ON (p.id = t.purchaseId)
134 
        ON (p.id = t.purchaseId)
133 
    JOIN lineitem l
135 
    JOIN lineitem l