Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity;

import java.io.Serializable;
import java.time.LocalDateTime;

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

@Entity
@Table(name="fofo.fofo_order", schema = "fofo")
@NamedQueries({
        @NamedQuery(name = "FofoOrder.selectCount", query = "select count(fo) from FofoOrder fo"),
        @NamedQuery(name = "FofoOrder.selectById", query = "select fo from FofoOrder fo where fo.id = :id"),
        @NamedQuery(name = "FofoOrder.selectByFofoId", query = "select fo from FofoOrder fo where fo.fofoId = :fofoId"),
        @NamedQuery(name = "FofoOrder.selectTotolAmountByFofoId", query = "select sum(fo.totalAmount) from FofoOrder fo where fo.fofoId = :fofoId group by fo.fofoId"),
        @NamedQuery(name = "FofoOrder.selectByInvoiceNumber", query = "select fo from FofoOrder fo where fo.invoiceNumber = :invoiceNumber")
})
public class FofoOrder implements Serializable{

        private static final long serialVersionUID = 1L;

        @Id
        @Column(name = "id")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;
        
        @Column(name = "fofo_id")
        private int fofoId;
        
        @Column(name = "customer_id")
        private int customerId;
        
        @Column(name = "customer_address_id")
        private int customerAddressId;
        
        @Column(name = "total_amount")
        private float totalAmount;
        
        @Column(name = "invoice_number", length = 50)
        private String invoiceNumber;
        
        @Column(name = "create_timestamp")
        private LocalDateTime createTimestamp = LocalDateTime.now();
        
        public int getId() {
                return id;
        }
        public void setId(int id) {
                this.id = id;
        }
        public int getFofoId() {
                return fofoId;
        }
        public void setFofoId(int fofoId) {
                this.fofoId = fofoId;
        }
        public int getCustomerId() {
                return customerId;
        }
        public void setCustomerId(int customerId) {
                this.customerId = customerId;
        }
        public int getCustomerAddressId() {
                return customerAddressId;
        }
        public void setCustomerAddressId(int customerAddressId) {
                this.customerAddressId = customerAddressId;
        }
        public float getTotalAmount() {
                return totalAmount;
        }
        public void setTotalAmount(float totalAmount) {
                this.totalAmount = totalAmount;
        }
        public String getInvoiceNumber() {
                return invoiceNumber;
        }
        public void setInvoiceNumber(String invoiceNumber) {
                this.invoiceNumber = invoiceNumber;
        }
        public LocalDateTime getCreateTimestamp() {
                return createTimestamp;
        }
        public void setCreateTimestamp(LocalDateTime createTimestamp) {
                this.createTimestamp = createTimestamp;
        }
        @Override
        public String toString() {
                return "FofoOrder [id=" + id + ", fofoId=" + fofoId + ", customerId=" + customerId + ", customerAddressId="
                                + customerAddressId + ", totalAmount=" + totalAmount + ", invoiceNumber=" + invoiceNumber
                                + ", createTimestamp=" + createTimestamp + "]";
        }
        
        
}