| Line 31... |
Line 31... |
| 31 |
@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId order by id desc"),
|
31 |
@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId order by id desc"),
|
| 32 |
@NamedQuery(
|
32 |
@NamedQuery(
|
| 33 |
name = "Transaction.selectByIds",
|
33 |
name = "Transaction.selectByIds",
|
| 34 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
34 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
| 35 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
35 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
| 36 |
+ "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 "
|
36 |
+ "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 "
|
| 37 |
+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId where t.id in :ids order by t.id desc")
|
37 |
+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId where t.id in :ids order by t.id desc")
|
| 38 |
})
|
38 |
})
|
| 39 |
|
39 |
|
| 40 |
public class Transaction implements Serializable{
|
40 |
public class Transaction implements Serializable{
|
| 41 |
|
41 |
|