| Line 109... |
Line 109... |
| 109 |
+ " from FofoStore fs join Order o on fs.id = o.retailerId"
|
109 |
+ " from FofoStore fs join Order o on fs.id = o.retailerId"
|
| 110 |
+ " join LineItem li on o.id = li.orderId " + " join TagListing tl on tl.itemId = li.itemId "
|
110 |
+ " join LineItem li on o.id = li.orderId " + " join TagListing tl on tl.itemId = li.itemId "
|
| 111 |
+ " join Item i on i.id = tl.itemId where "
|
111 |
+ " join Item i on i.id = tl.itemId where "
|
| 112 |
+ " fs.active = 1 and fs.internal = 0 and o.status in (3,4) and tl.mop between :startPrice and :endPrice and i.categoryId=10006 group by fs.id,i.catalogItemId,i.brand,i.modelName,i.modelNumber"),
|
112 |
+ " fs.active = 1 and fs.internal = 0 and o.status in (3,4) and tl.mop between :startPrice and :endPrice and i.categoryId=10006 group by fs.id,i.catalogItemId,i.brand,i.modelName,i.modelNumber"),
|
| 113 |
|
113 |
|
| - |
|
114 |
@NamedQuery(name = "Order.selectAllGrnPendingOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
|
| - |
|
115 |
+ " fs.warehouseId, fs.id, sum(li.quantity), i.brand, i.modelName, i.modelNumber, i.catalogItemId) from FofoStore fs join Order o on fs.id = o.retailerId "
|
| - |
|
116 |
+ " join LineItem li on o.id = li.orderId join TagListing tl on tl.itemId = li.itemId "
|
| - |
|
117 |
+ " join Item i on (i.id = tl.itemId ) where " + " fs.active = 1 and fs.internal = 0 and"
|
| - |
|
118 |
+ " o.billingTimestamp is not null and o.refundTimestamp is null and o.deliveryTimestamp is null"
|
| - |
|
119 |
+ " and i.catalogItemId in :catalogItemId and i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),
|
| - |
|
120 |
|
| - |
|
121 |
@NamedQuery(name = "Order.selectAllPendingIndentOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
|
| - |
|
122 |
+ " fs.warehouseId, fs.id, sum(li.quantity), i.brand, i.modelName, i.modelNumber, i.catalogItemId)"
|
| - |
|
123 |
+ " from FofoStore fs join Order o on fs.id = o.retailerId"
|
| - |
|
124 |
+ " join LineItem li on o.id = li.orderId " + " join TagListing tl on tl.itemId = li.itemId "
|
| - |
|
125 |
+ " join Item i on i.id = tl.itemId where "
|
| - |
|
126 |
+ " fs.active = 1 and fs.internal = 0 and o.status in (3,4) and i.catalogItemId in :catalogItemId and i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),
|
| - |
|
127 |
|
| 114 |
})
|
128 |
})
|
| 115 |
public class Order implements Serializable {
|
129 |
public class Order implements Serializable {
|
| 116 |
|
130 |
|
| 117 |
private static final long serialVersionUID = 1L;
|
131 |
private static final long serialVersionUID = 1L;
|
| 118 |
|
132 |
|