| Line 30... |
Line 30... |
| 30 |
@NamedQueries({
|
30 |
@NamedQueries({
|
| 31 |
@NamedQuery(name = "Transaction.selectCount", query = "select count(t) from Transaction t"),
|
31 |
@NamedQuery(name = "Transaction.selectCount", query = "select count(t) from Transaction t"),
|
| 32 |
@NamedQuery(name = "Transaction.selectCountByRetailerId", query = "select count(t) from Transaction t where t.retailerId = :retailerId"),
|
32 |
@NamedQuery(name = "Transaction.selectCountByRetailerId", query = "select count(t) from Transaction t where t.retailerId = :retailerId"),
|
| 33 |
@NamedQuery(name="Transaction.selectAll", query="select t from Transaction t"),
|
33 |
@NamedQuery(name="Transaction.selectAll", query="select t from Transaction t"),
|
| 34 |
//and t.status in (1,2,4,5,6)
|
34 |
//and t.status in (1,2,4,5,6)
|
| 35 |
@NamedQuery(name="Transaction.selectById", query="select t from Transaction t where t.id= :id"),
|
- |
|
| 36 |
@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId and t.status != 0 order by t.id desc"),
|
35 |
@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId and t.status != 0 order by t.id desc"),
|
| 37 |
@NamedQuery(
|
36 |
@NamedQuery(
|
| 38 |
name = "Transaction.selectByIds",
|
37 |
name = "Transaction.selectByIds",
|
| 39 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
38 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
| 40 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
39 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|