Subversion Repositories SmartDukaan

Rev

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

Rev 35365 Rev 35421
Line 20... Line 20...
20 
 
 20 
 
21 
        @NamedQuery(name = "Catalog.findAllWithEOLWithOutStock", query = "select i.catalogItemId "
 21 
        @NamedQuery(name = "Catalog.findAllWithEOLWithOutStock", query = "select i.catalogItemId "
22 
                + " from Item i "
 22 
                + " from Item i "
23 
                + " left join  WarehouseInventoryItem wi on i.id = wi.itemId"
 23 
                + " left join  WarehouseInventoryItem wi on i.id = wi.itemId"
24 
                + " left join CategorisedCatalog cc on cc.catalogId = i.catalogItemId and cc.endDate is null "
 24 
                + " left join CategorisedCatalog cc on cc.catalogId = i.catalogItemId and cc.endDate is null "
25 
                + " where ((cc.status is null OR cc.status = 'OTHER' OR cc.status = 'SLOWMOVING')) and i.categoryId in (10006,10009,10010) group by i.catalogItemId having (sum(wi.currentQuantity) = 0 OR sum(wi.currentQuantity) IS NULL)"),
 25 
                + " where ((cc.status is null OR cc.status = 'OTHER' OR cc.status = 'SLOWMOVING')) and i.categoryId in (10006,10009,10010) and wi.lastScanType not in (:scanTypes) group by i.catalogItemId having (sum(wi.currentQuantity) = 0 OR sum(wi.currentQuantity) IS NULL)"),
26 
 
 26 
 
27 
})
 27 
})
28 
 
 28 
 
29 
@Entity
 29 
@Entity
30 
@Table(name = "catalog.catalog")
 30 
@Table(name = "catalog.catalog")