| Line 23... |
Line 23... |
| 23 |
*
|
23 |
*
|
| 24 |
*/
|
24 |
*/
|
| 25 |
@Entity
|
25 |
@Entity
|
| 26 |
@Table(name="fofo.payment_option", schema = "fofo", uniqueConstraints = {@UniqueConstraint(columnNames = {"order_id","type"})})
|
26 |
@Table(name="fofo.payment_option", schema = "fofo", uniqueConstraints = {@UniqueConstraint(columnNames = {"order_id","type"})})
|
| 27 |
@NamedQueries({
|
27 |
@NamedQueries({
|
| 28 |
@NamedQuery(name = "PaymentOption.selectById", query = "select po from PaymentOption po where po.id = :id"),
|
- |
|
| 29 |
@NamedQuery(name = "PaymentOption.selectByOrderId", query = "select po from PaymentOption po where po.orderId = :orderId"),
|
28 |
@NamedQuery(name = "PaymentOption.selectByOrderId", query = "select po from PaymentOption po where po.orderId = :orderId")
|
| 30 |
@NamedQuery(name = "PaymentOption.selectTotalAmountByType", query = "select sum(po.amount) from PaymentOption po where po.type = :type group by po.type"),
|
- |
|
| 31 |
@NamedQuery(name = "PaymentOption.selectTotalAmountByOrderId", query = "select sum(po.amount) from PaymentOption po where po.orderId = :orderId group by po.orderId")
|
- |
|
| 32 |
})
|
29 |
})
|
| 33 |
public class PaymentOption implements Serializable{
|
30 |
public class PaymentOption implements Serializable{
|
| 34 |
|
31 |
|
| 35 |
private static final long serialVersionUID = 1L;
|
32 |
private static final long serialVersionUID = 1L;
|
| 36 |
|
33 |
|