Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.fofo;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;

import com.spice.profitmandi.dao.enumuration.fofo.PaymentOptionType;

/**
 * This class basically contains api details
 * 
 * @author ashikali
 *
 */
@Entity
@Table(name="fofo.payment_option", schema = "fofo", uniqueConstraints = {@UniqueConstraint(columnNames = {"order_id","type"})})
@NamedQueries({
        @NamedQuery(name = "PaymentOption.selectById", query = "select po from PaymentOption po where po.id = :id"),
        @NamedQuery(name = "PaymentOption.selectByOrderId", query = "select po from PaymentOption po where po.orderId = :orderId"),
        @NamedQuery(name = "PaymentOption.selectTotalAmountByType", query = "select sum(po.amount) from PaymentOption po where po.type = :type group by po.type"),
        @NamedQuery(name = "PaymentOption.selectTotalAmountByOrderId", query = "select sum(po.amount) from PaymentOption po where po.orderId = :orderId group by po.orderId")
})
public class PaymentOption implements Serializable{
        
        private static final long serialVersionUID = 1L;
        
        public PaymentOption() {
        }
        
        @Id
        @Column(name="id")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;
        
        @Column(name = "order_id")
        private int orderId;
        
        @Enumerated(EnumType.STRING)
        @Column(name = "type")
        private PaymentOptionType type;
        
        @Column(name = "amount")
        private float amount;
        
        public int getId() {
                return id;
        }
        public void setId(int id) {
                this.id = id;
        }
        public int getOrderId() {
                return orderId;
        }
        public void setOrderId(int orderId) {
                this.orderId = orderId;
        }
        public PaymentOptionType getType() {
                return type;
        }
        public void setType(PaymentOptionType type) {
                this.type = type;
        }
        public float getAmount() {
                return amount;
        }
        public void setAmount(float amount) {
                this.amount = amount;
        }
        @Override
        public String toString() {
                return "PaymentOption [id=" + id + ", orderId=" + orderId + ", type=" + type + ", amount=" + amount + "]";
        }
        
        
        
}