Subversion Repositories SmartDukaan

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

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

import in.shop2020.model.v1.order.TransactionStatus;

import javax.persistence.*;

import java.io.Serializable;

import java.time.LocalDateTime;

/**

 * This class basically contains transaction details

 * 

 * @author ashikali

 *

 */

@Entity

@Table(name = "transaction.transaction")

@NamedQueries({

	@NamedQuery(name = "Transaction.selectCount", query = "select count(t) from Transaction t"),

	@NamedQuery(name = "Transaction.selectCountByRetailerId", query = "select count(t) from Transaction t where t.retailerId = :retailerId"),

	@NamedQuery(name="Transaction.selectAll", query="select t from Transaction t"),

	//and t.status in (1,2,4,5,6)

	@NamedQuery(name = "Transaction.selectIdsByRetailerId", query = "select t.id from Transaction t where t.retailerId = :retailerId and t.status != 0 order by t.id desc"),

	@NamedQuery(

			name = "Transaction.selectByIds", 

			query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "

					+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "

					+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id "

					+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id = li.itemId where t.id in :ids and o.status not in(0,1) order by t.id desc")

	})

public class Transaction implements Serializable{

	private static final long serialVersionUID = 1L;

	public Transaction() {

	}

	@Id

	@Column(name="id", unique=true, updatable=false)

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "createdOn")

	private LocalDateTime createTimestamp;

	@Enumerated(EnumType.ORDINAL)

	@Column(name = "status")

	private TransactionStatus status;

	@Column(name = "status_message", length = 100)

	private String statusMessage;

	@Column(name = "customer_id")

	private int retailerId;

	@Column(name = "shopping_cart_id")

	private int shoppingCartId;

	@Column(name = "coupon_code", length = 20)

	private String couponCode;

	@Column(name = "session_source", length = 100)

	private String sessionSource;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "session_start_time")

	private LocalDateTime sessionStateTime;

	@Column(name = "first_source")

	private String firstSource;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "first_source_start_time")

	private LocalDateTime firstSourceStateTime;

	@Column(name = "totalShippingCost")

	private float totalShippingCost;

	@Column(name = "totalCodCharges")

	private float totalCodCharges;

	@Column(name = "payment_option")

	private int paymentOption;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public TransactionStatus getStatus() {

		return status;

	}

	public void setStatus(TransactionStatus status) {

		this.status = status;

	}

	public String getStatusMessage() {

		return statusMessage;

	}

	public void setStatusMessage(String statusMessage) {

		this.statusMessage = statusMessage;

	}

	public int getRetailerId() {

		return retailerId;

	}

	public void setRetailerId(int retailerId) {

		this.retailerId = retailerId;

	}

	public int getShoppingCartId() {

		return shoppingCartId;

	}

	public void setShoppingCartId(int shoppingCartId) {

		this.shoppingCartId = shoppingCartId;

	}

	public String getCouponCode() {

		return couponCode;

	}

	public void setCouponCode(String couponCode) {

		this.couponCode = couponCode;

	}

	public String getSessionSource() {

		return sessionSource;

	}

	public void setSessionSource(String sessionSource) {

		this.sessionSource = sessionSource;

	}

	public LocalDateTime getSessionStateTime() {

		return sessionStateTime;

	}

	public void setSessionStateTime(LocalDateTime sessionStateTime) {

		this.sessionStateTime = sessionStateTime;

	}

	public String getFirstSource() {

		return firstSource;

	}

	public void setFirstSource(String firstSource) {

		this.firstSource = firstSource;

	}

	public LocalDateTime getFirstSourceStateTime() {

		return firstSourceStateTime;

	}

	public void setFirstSourceStateTime(LocalDateTime firstSourceStateTime) {

		this.firstSourceStateTime = firstSourceStateTime;

	}

	public float getTotalShippingCost() {

		return totalShippingCost;

	}

	public void setTotalShippingCost(float totalShippingCost) {

		this.totalShippingCost = totalShippingCost;

	}

	public float getTotalCodCharges() {

		return totalCodCharges;

	}

	public void setTotalCodCharges(float totalCodCharges) {

		this.totalCodCharges = totalCodCharges;

	}

	public int getPaymentOption() {

		return paymentOption;

	}

	public void setPaymentOption(int paymentOption) {

		this.paymentOption = paymentOption;

	}

	@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;

		Transaction other = (Transaction) obj;

		if (id != other.id)

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "Transaction [createTimestamp=" + createTimestamp + ", status=" + status + ", statusMessage="

				+ statusMessage + ", retailerId=" + retailerId + ", shoppingCartId=" + shoppingCartId + ", couponCode="

				+ couponCode + ", sessionSource=" + sessionSource + ", sessionStateTime=" + sessionStateTime

				+ ", firstSource=" + firstSource + ", firstSourceStateTime=" + firstSourceStateTime

				+ ", totalShippingCost=" + totalShippingCost + ", totalCodCharges=" + totalCodCharges

				+ ", paymentOption=" + paymentOption + "]";

	}

}