| Line 82... |
Line 82... |
| 82 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId "
|
82 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId "
|
| 83 |
+ " join FofoOrderItem foi on foi.orderId = fo.id join TagListing tl on tl.itemId = foi.itemId "
|
83 |
+ " join FofoOrderItem foi on foi.orderId = fo.id join TagListing tl on tl.itemId = foi.itemId "
|
| 84 |
+ " join Item i on i.id = tl.itemId"
|
84 |
+ " join Item i on i.id = tl.itemId"
|
| 85 |
+ " where fs.active = 1 and fs.internal = 0 and fo.cancelledTimestamp is null and fo.createTimestamp > :startDate and i.catalogItemId in :catalogItemId and i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),
|
85 |
+ " where fs.active = 1 and fs.internal = 0 and fo.cancelledTimestamp is null and fo.createTimestamp > :startDate and i.catalogItemId in :catalogItemId and i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),
|
| 86 |
|
86 |
|
| - |
|
87 |
@NamedQuery(name = "FofoOrder.selectSaleByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdCatalogQtyModel("
|
| - |
|
88 |
+ " fs.warehouseId, fs.id,i.catalogItemId, sum(case when foi.quantity is null then 0 else foi.quantity end))"
|
| - |
|
89 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId "
|
| - |
|
90 |
+ " join FofoOrderItem foi on foi.orderId = fo.id join TagListing tl on tl.itemId = foi.itemId "
|
| - |
|
91 |
+ " join Item i on i.id = tl.itemId"
|
| - |
|
92 |
+ " where fs.active = 1 and fs.internal = 0 and fo.cancelledTimestamp is null and fo.createTimestamp > :startDate and i.catalogItemId in :catalogItemId and i.categoryId=10006 group by i.catalogItemId, fs.id"),
|
| - |
|
93 |
|
| 87 |
})
|
94 |
})
|
| 88 |
public class FofoOrder implements Serializable {
|
95 |
public class FofoOrder implements Serializable {
|
| 89 |
|
96 |
|
| 90 |
private static final long serialVersionUID = 1L;
|
97 |
private static final long serialVersionUID = 1L;
|
| 91 |
|
98 |
|