| Line 12... |
Line 12... |
| 12 |
import javax.persistence.NamedQuery;
|
12 |
import javax.persistence.NamedQuery;
|
| 13 |
import javax.persistence.Table;
|
13 |
import javax.persistence.Table;
|
| 14 |
|
14 |
|
| 15 |
import in.shop2020.model.v1.order.TransactionStatus;
|
15 |
import in.shop2020.model.v1.order.TransactionStatus;
|
| 16 |
|
16 |
|
| 17 |
//import com.spice.profitmandi.dao.enumuration.TransactionStatus;
|
- |
|
| 18 |
|
- |
|
| 19 |
/**
|
17 |
/**
|
| 20 |
* This class basically contains transaction details
|
18 |
* This class basically contains transaction details
|
| 21 |
*
|
19 |
*
|
| 22 |
* @author ashikali
|
20 |
* @author ashikali
|
| 23 |
*
|
21 |
*
|
| Line 26... |
Line 24... |
| 26 |
@Table(name="transaction.transaction", schema = "transaction")
|
24 |
@Table(name="transaction.transaction", schema = "transaction")
|
| 27 |
@NamedQueries({
|
25 |
@NamedQueries({
|
| 28 |
@NamedQuery(name = "Transaction.selectCount", query = "select count(t) from Transaction t"),
|
26 |
@NamedQuery(name = "Transaction.selectCount", query = "select count(t) from Transaction t"),
|
| 29 |
@NamedQuery(name = "Transaction.selectCountByRetailerId", query = "select count(t) from Transaction t where t.retailerId = :retailerId"),
|
27 |
@NamedQuery(name = "Transaction.selectCountByRetailerId", query = "select count(t) from Transaction t where t.retailerId = :retailerId"),
|
| 30 |
@NamedQuery(name="Transaction.selectAll", query="select t from Transaction t"),
|
28 |
@NamedQuery(name="Transaction.selectAll", query="select t from Transaction t"),
|
| 31 |
@NamedQuery(name="Transaction.selectById", query="select t from Transaction t where t.id= :id and status in (1,2,4,5,6)"),
|
29 |
@NamedQuery(name="Transaction.selectById", query="select t from Transaction t where t.id= :id and t.status in (1,2,4,5,6)"),
|
| 32 |
@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId"),
|
30 |
@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId"),
|
| 33 |
@NamedQuery(
|
31 |
@NamedQuery(
|
| 34 |
name = "Transaction.selectByIds",
|
32 |
name = "Transaction.selectByIds",
|
| 35 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
33 |
query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
|
| 36 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|
34 |
+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
|