| Line 15... |
Line 15... |
| 15 |
@NamedQuery(name = "Catalog.findOtherORNullCategoryAndPartnerInStock", query = "select i.catalogItemId "
|
15 |
@NamedQuery(name = "Catalog.findOtherORNullCategoryAndPartnerInStock", query = "select i.catalogItemId "
|
| 16 |
+ " from CurrentInventorySnapshot cis "
|
16 |
+ " from CurrentInventorySnapshot cis "
|
| 17 |
+ " join Item i on i.id = cis.itemId"
|
17 |
+ " join Item i on i.id = cis.itemId"
|
| 18 |
+ " left join CategorisedCatalog cc on cc.catalogId = i.catalogItemId and cc.endDate is null "
|
18 |
+ " left join CategorisedCatalog cc on cc.catalogId = i.catalogItemId and cc.endDate is null "
|
| 19 |
+ " where ((cc.status is null OR cc.status = 'OTHER' OR cc.status = 'SLOWMOVING')) and i.categoryId in (10006,10009,10010) and i.brand= :brand and cis.fofoId = :fofoId group by i.catalogItemId having sum(cis.availability) > 0"),
|
19 |
+ " where ((cc.status is null OR cc.status = 'OTHER' OR cc.status = 'SLOWMOVING')) and i.categoryId in (10006,10009,10010) and i.brand= :brand and cis.fofoId = :fofoId group by i.catalogItemId having sum(cis.availability) > 0"),
|
| - |
|
20 |
|
| - |
|
21 |
@NamedQuery(name = "Catalog.findAllWithEOLWithOutStockItemId", query = "select i.id "
|
| - |
|
22 |
+ " from WarehouseInventoryItem wi "
|
| - |
|
23 |
+ " join Item i on i.id = wi.itemId"
|
| - |
|
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 wi.itemId having sum(wi.currentQuantity) = 0"),
|
| - |
|
26 |
|
| 20 |
})
|
27 |
})
|
| 21 |
|
28 |
|
| 22 |
@Entity
|
29 |
@Entity
|
| 23 |
@Table(name = "catalog.catalog")
|
30 |
@Table(name = "catalog.catalog")
|
| 24 |
public class Catalog {
|
31 |
public class Catalog {
|