| Line 37... |
Line 37... |
| 37 |
@NamedQuery(name = "Order.selectCountByTransactionId", query = "select count(o) from Order o where o.transactionId = :transactionId"),
|
37 |
@NamedQuery(name = "Order.selectCountByTransactionId", query = "select count(o) from Order o where o.transactionId = :transactionId"),
|
| 38 |
@NamedQuery(
|
38 |
@NamedQuery(
|
| 39 |
name = "Order.selectByTransactionId",
|
39 |
name = "Order.selectByTransactionId",
|
| 40 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
40 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
| 41 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
41 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
| 42 |
+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName from Transaction t join Order o on o.transactionId = t.id "
|
42 |
+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status from Transaction t join Order o on o.transactionId = t.id "
|
| 43 |
+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId where o.transactionId = :transactionId and t.status in (2,4,5,6)"),
|
43 |
+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId where o.transactionId = :transactionId"),
|
| 44 |
@NamedQuery(
|
44 |
@NamedQuery(
|
| 45 |
name = "Order.selectByAirwayBillOrInvoiceNumberRetailerId",
|
45 |
name = "Order.selectByAirwayBillOrInvoiceNumberRetailerId",
|
| 46 |
query = "select li.itemId, li.brand, li.modelName, li.modelNumber, li.color, li.quantity, li.unitPrice, i.type, sum(li.quantity), o.invoiceNumber from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where (o.airwayBillNumber = :airwayBillOrInvoiceNumber or o.invoiceNumber = :airwayBillOrInvoiceNumber) and o.retailerId = :retailerId group by li.itemId"),
|
46 |
query = "select li.itemId, li.brand, li.modelName, li.modelNumber, li.color, li.quantity, li.unitPrice, i.type, sum(li.quantity), o.invoiceNumber from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where (o.airwayBillNumber = :airwayBillOrInvoiceNumber or o.invoiceNumber = :airwayBillOrInvoiceNumber) and o.retailerId = :retailerId group by li.itemId"),
|
| 47 |
|
47 |
|
| 48 |
@NamedQuery(
|
48 |
@NamedQuery(
|