| Line 43... |
Line 43... |
| 43 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
43 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
| 44 |
+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId from Transaction t join Order o on o.transactionId = t.id "
|
44 |
+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId from Transaction t join Order o on o.transactionId = t.id "
|
| 45 |
+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),
|
45 |
+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),
|
| 46 |
|
46 |
|
| 47 |
@NamedQuery(
|
47 |
@NamedQuery(
|
| 48 |
name = "Order.selectSerialNumbersByItemIdInvoiceNumberRetailerId",
|
- |
|
| 49 |
query = "select li.serialNumber from Order o join LineItem li on li.orderId = o.id where o.retailerId = :retailerId and o.invoiceNumber = :invoiceNumber and li.itemId = :itemId"),
|
- |
|
| 50 |
|
- |
|
| 51 |
@NamedQuery(
|
- |
|
| 52 |
name = "Order.selectItemIdTypeQuantity",
|
48 |
name = "Order.selectItemIdTypeQuantity",
|
| 53 |
query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId")
|
49 |
query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId")
|
| 54 |
})
|
50 |
})
|
| 55 |
public class Order implements Serializable{
|
51 |
public class Order implements Serializable{
|
| 56 |
|
52 |
|