Subversion Repositories SmartDukaan

Rev

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

Rev 7678 Rev 7802
Line 122... Line 122...
122 
                DATEDIFF(now(), MAX(s.scannedAt)) / 7 as age
 122 
                DATEDIFF(now(), MAX(s.scannedAt)) / 7 as age
123 
           FROM inventoryItem ii
123 
           FROM inventoryItem ii
124 
           JOIN scanNew s
124 
           JOIN scanNew s
125 
                ON (s.inventoryItemId = ii.id)
125 
                ON (s.inventoryItemId = ii.id)
126 
           WHERE ii.lastScanType IN ('PURCHASE', 'SALE_RET')
126 
           WHERE ii.lastScanType IN ('PURCHASE', 'SALE_RET')
- 
 
 127 
           AND ii.physicalWarehouseId !=16
127 
           GROUP BY ii.id, ii.itemId, ii.currentQuantity) t
128 
           GROUP BY ii.id, ii.itemId, ii.currentQuantity) t
128 
    JOIN purchase p
129 
    JOIN purchase p
129 
        ON (p.id = t.purchaseId)
130 
        ON (p.id = t.purchaseId)
130 
    JOIN lineitem l
131 
    JOIN lineitem l
131 
        ON (l.purchaseOrder_id = p.purchaseOrder_id AND l.itemId = t.itemId)
 132 
        ON (l.purchaseOrder_id = p.purchaseOrder_id AND l.itemId = t.itemId)