Subversion Repositories SmartDukaan

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

import java.io.Serializable;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

import java.util.List;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Convert;

import javax.persistence.Entity;

import javax.persistence.FetchType;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.JoinColumn;

import javax.persistence.ManyToOne;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.OneToMany;

import javax.persistence.Table;

import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;

@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 = "cashback")

	private float cashback;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "create_timestamp")

	private LocalDateTime createTimestamp = LocalDateTime.now();

	@OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY)

	@JoinColumn(name="order_id",insertable=false,updatable=false,nullable=false)

	private List<FofoOrderItem> fofoLineItem;	

	@OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY)

	@JoinColumn(name="order_id",insertable=false,updatable=false,nullable=false)

	private List<PaymentOption> paymentOption;	

	public List<PaymentOption> getPaymentOption() {

		return paymentOption;

	}

	public void setPaymentOption(List<PaymentOption> paymentOption) {

		this.paymentOption = paymentOption;

	}

	public List<FofoOrderItem> getFofoLineItem() {

		return fofoLineItem;

	}

	public void setFofoLineItem(List<FofoOrderItem> fofoLineItem) {

		this.fofoLineItem = fofoLineItem;

	}

	@ManyToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)

	@JoinColumn(name="customer_id",insertable=false,updatable=false,nullable=false, referencedColumnName="id")

	private Customer customer;	

	@ManyToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)

	@JoinColumn(name="customer_address_id",insertable=false,updatable=false,nullable=false, referencedColumnName="id")

	private CustomerAddress customerAddress;	

	public CustomerAddress getCustomerAddress() {

		return customerAddress;

	}

	public void setCustomerAddress(CustomerAddress customerAddress) {

		this.customerAddress = customerAddress;

	}

	public Customer getCustomer() {

		return customer;

	}

	public void setCustomer(Customer customer) {

		this.customer = customer;

	}

	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 float getCashback() {

		return cashback;

	}

	public void setCashback(float cashback) {

		this.cashback = cashback;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public String getFormattedDate(){

    	DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-YYYY HH:mm");

		return this.createTimestamp.format(formatter);

    }

	@Override

	public int hashCode() {

		final int prime = 31;

		int result = 1;

		result = prime * result + id;

		return result;

	}

	@Override

	public boolean equals(Object obj) {

		if (this == obj)

			return true;

		if (obj == null)

			return false;

		if (getClass() != obj.getClass())

			return false;

		FofoOrder other = (FofoOrder) obj;

		if (id != other.id)

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "FofoOrder [id=" + id + ", fofoId=" + fofoId + ", customerId=" + customerId + ", customerAddressId="

				+ customerAddressId + ", totalAmount=" + totalAmount + ", invoiceNumber=" + invoiceNumber

				+ ", cashback=" + cashback + ", createTimestamp=" + createTimestamp + ", fofoLineItem=" + fofoLineItem

				+ ", paymentOption=" + paymentOption + ", customer=" + customer + ", customerAddress=" + customerAddress

				+ "]";

	}

}