Subversion Repositories SmartDukaan

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

import java.io.Serializable;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Convert;

import javax.persistence.Entity;

import javax.persistence.EnumType;

import javax.persistence.Enumerated;

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.Table;

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

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

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

/**

 * This class basically contains order details

 * 

 * @author ashikali

 *

 */

@Entity

@Table(name="transaction.`order`", schema = "transaction")

@NamedQueries({

	@NamedQuery(name="Order.selectAll",query="select o from Order o"),

	@NamedQuery(name="Order.selectById",query="select o from Order o where o.id= :id"),

	@NamedQuery(name = "Order.selectCountByTransactionId", query = "select count(o) from Order o where o.transactionId = :transactionId"),

	@NamedQuery(

		name = "Order.selectByTransactionId", 

		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 o.transactionId = :transactionId"),

	@NamedQuery(

		name = "Order.selectSerialNumbersByItemIdInvoiceNumberRetailerId",

		query = "select li.serialNumber from Order o join LineItem li on li.orderId = o.id where o.retailerId = :retailerId and o.invoiceNumber = :invoiceNumber and li.itemId = :itemId"),

	@NamedQuery(

		name = "Order.selectItemIdTypeQuantity",

		query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId")

})

public class Order implements Serializable{

	private static final long serialVersionUID = 1L;

	public Order() {

	}

	@Id

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

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private Integer id;

	@Column(name = "warehouse_id")

	private Integer warehouseId;

	@Column(name = "seller_id")

	private Integer sellerId;

	@Column(name = "warehouse_address_id")

	private Integer warehouseAddressId;

	@Column(name = "logistics_provider_id")

	private Integer logisticsProviderId;

	@Column(name = "airwaybill_no", length = 50)

	private String airwayBillNumber;

	@Column(name = "tracking_id", length = 50)

	private String trackingId;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "expected_delivery_time")

	private LocalDateTime expectedDeliveryTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "promised_delivery_time")

	private LocalDateTime promisedDeliveryTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "expected_shipping_time")

	private LocalDateTime expectedShippingTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "promised_shipping_time")

	private LocalDateTime promisedShippingTime;

	@Column(name = "customer_id")

	private Integer retailerId;

	@Column(name = "customer_name", length = 50)

	private String retailerName;

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

	private String retailerMobileNumber;

	@Column(name = "customer_pincode", length = 10)

	private String retailerPinCode;

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

	private String retailerAddress1;

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

	private String retailerAddress2;

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

	private String retailerCity;

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

	private String retailerState;

	@Column(name = "customer_email", length = 50)

	private String retailerEmailId;

	@Column(name = "status")

	@Enumerated(EnumType.ORDINAL)

	private OrderStatus status;

	@Column(name = "statusDescription", length = 50)

	private String statusDescription;

	@Column(name = "total_amount")

	private Float totalAmount;

	@Column(name = "gvAmount")

	private Float gvAmount;

	@Column(name = "total_weight")

	private Float totalWeight;

	@Column(name = "invoice_number", length = 30)

	private String invoiceNumber;

	@Column(name = "billed_by", length = 30)

	private String billedBy;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "created_timestamp")

	private LocalDateTime createTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "accepted_timestamp")

	private LocalDateTime acceptedTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "billing_timestamp")

	private LocalDateTime billingTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "shipping_timestamp")

	private LocalDateTime shippingTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "pickup_timestamp")

	private LocalDateTime pickupTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "delivery_timestamp")

	private LocalDateTime deliveryTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "outofstock_timestamp")

	private LocalDateTime outOfStockTimestamp;

	@Column(name = "transaction_id")

    private Integer transactionId;

	/*@Column(name = "jacket_number", length = 10)

	private Integer jacketNumber;*/

	@Column(name = "receiver", length = 50)

	private String receiver;

	@Column(name = "batchNo")

	private Integer batchNumber;

	@Column(name = "serialNo")

	private Integer serialNumber;

	@Column(name = "doaFlag", columnDefinition="tinyInteger(1) default 0")

	private Boolean doaFlag;

	@Column(name = "pickupRequestNo")

	private Integer pickupRequestNumber;

	@Column(name = "new_order_id")

	private Integer newOrderId;

	@Column(name = "doa_auth_timestamp")

	private LocalDateTime doaAuthTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "doa_pickup_timestamp")

	private LocalDateTime doaPickupTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "received_return_timestamp")

	private LocalDateTime receiverReturnTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "reship_timestamp")

	private LocalDateTime reShipTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "refund_timestamp")

	private LocalDateTime refundTimestamp;

	@Column(name = "purchase_order_id")

	private Integer purchaseOrderId;

	@Column(name = "cod", columnDefinition="tinyInteger(1) default 0")

	private Boolean cod;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "verification_timestamp")

	private LocalDateTime verificationTimestamp;

	@Column(name = "refunded_by", length = 30)

	private String refundBy;

	@Column(name = "refund_reason", length = 256)

	private String refundReason;

	/*@Column(name = "delay_reason")

	private DelayReason delayReason;*/

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "cod_reconciliation_timestamp")

	private LocalDateTime codReconciliationTimestamp;

	private Integer previousStatus;

	@Column(name = "vendorId")

	private Integer vendorId;

	@Column(name = "delayReasonText", length = 250)

	private String delayReasonText;

	@Column(name = "doa_logistics_provider_id")

	private Integer doaLogisticsProviderId;

	@Column(name = "vendor_paid", columnDefinition="tinyInteger(1) default 0")

	private Boolean vendorPaid;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "local_connected_timestamp")

	private LocalDateTime localConnectedTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "reached_destination_timestamp")

	private LocalDateTime reachedDestinationTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "first_dlvyatmp_timestamp")

	private LocalDateTime firstDlvyatmpTimestamp;

	@Column(name = "originalOrderId")

	private Integer originalOrderId;

	@Column(name = "fulfilmentWarehouseId")

	private Integer fulfilmentWarehouseId;

	@Column(name = "orderType")

	private Integer orderType;

	@Column(name = "pickupStoreId")

	private Integer pickupStoreId;

	@Column(name = "otg", columnDefinition="tinyInteger(1) default 0")

	private Boolean otg;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "courier_delivery_time")

	private LocalDateTime courierDeliveryTimestamp;

	@Column(name = "insurer")

	private Integer insurer;

	@Column(name = "insuranceAmount")

	private Float insuranceAmount;

	@Column(name = "freebieItemId")

	private Integer freebieItemId;

	@Column(name = "source")

	private Integer source;

	@Column(name = "advanceAmount")

	private Float advanceAmount;

	@Column(name = "storeId")

	private Integer storeId;

	@Column(name = "productCondition")

	private Integer productCondition;

	@Column(name = "dataProtectionInsurer")

	private Integer dataProtectionInsurer;

	@Column(name = "dataProtectionAmount")

	private Integer dataProtectionAmount;

	@Column(name = "taxType")

	@Enumerated(EnumType.ORDINAL)

	private TaxType taxType;

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

	private String logisticsTransactionId;

	@Column(name = "shippingCost")

	private Float shippingCost;

	@Column(name = "codCharges")

	private Float codCharges;

	@Column(name = "wallet_amount")

	private Float walletAmount;

	@Column(name = "net_payable_amount")

	private Float netPayableAmount;

	@Column(name = "shippingRefund")

	private Float shippingRefund;

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

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

	private LineItem lineItem;

	public Integer getId() {

		return id;

	}

	public void setId(Integer id) {

		this.id = id;

	}

	public Integer getWarehouseId() {

		return warehouseId;

	}

	public void setWarehouseId(Integer warehouseId) {

		this.warehouseId = warehouseId;

	}

	public Integer getSellerId() {

		return sellerId;

	}

	public void setSellerId(Integer sellerId) {

		this.sellerId = sellerId;

	}

	public Integer getWarehouseAddressId() {

		return warehouseAddressId;

	}

	public void setWarehouseAddressId(Integer warehouseAddressId) {

		this.warehouseAddressId = warehouseAddressId;

	}

	public Integer getLogisticsProviderId() {

		return logisticsProviderId;

	}

	public void setLogisticsProviderId(Integer logisticsProviderId) {

		this.logisticsProviderId = logisticsProviderId;

	}

	public String getAirwayBillNumber() {

		return airwayBillNumber;

	}

	public void setAirwayBillNumber(String airwayBillNumber) {

		this.airwayBillNumber = airwayBillNumber;

	}

	public String getTrackingId() {

		return trackingId;

	}

	public void setTrackingId(String trackingId) {

		this.trackingId = trackingId;

	}

	public LocalDateTime getExpectedDeliveryTime() {

		return expectedDeliveryTime;

	}

	public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {

		this.expectedDeliveryTime = expectedDeliveryTime;

	}

	public LocalDateTime getPromisedDeliveryTime() {

		return promisedDeliveryTime;

	}

	public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {

		this.promisedDeliveryTime = promisedDeliveryTime;

	}

	public LocalDateTime getExpectedShippingTime() {

		return expectedShippingTime;

	}

	public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {

		this.expectedShippingTime = expectedShippingTime;

	}

	public LocalDateTime getPromisedShippingTime() {

		return promisedShippingTime;

	}

	public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {

		this.promisedShippingTime = promisedShippingTime;

	}

	public Integer getRetailerId() {

		return retailerId;

	}

	public void setRetailerId(Integer retailerId) {

		this.retailerId = retailerId;

	}

	public String getRetailerName() {

		return retailerName;

	}

	public void setRetailerName(String retailerName) {

		this.retailerName = retailerName;

	}

	public String getRetailerMobileNumber() {

		return retailerMobileNumber;

	}

	public void setRetailerMobileNumber(String retailerMobileNumber) {

		this.retailerMobileNumber = retailerMobileNumber;

	}

	public String getRetailerPinCode() {

		return retailerPinCode;

	}

	public void setRetailerPinCode(String retailerPinCode) {

		this.retailerPinCode = retailerPinCode;

	}

	public String getRetailerAddress1() {

		return retailerAddress1;

	}

	public void setRetailerAddress1(String retailerAddress1) {

		this.retailerAddress1 = retailerAddress1;

	}

	public String getRetailerAddress2() {

		return retailerAddress2;

	}

	public void setRetailerAddress2(String retailerAddress2) {

		this.retailerAddress2 = retailerAddress2;

	}

	public String getRetailerCity() {

		return retailerCity;

	}

	public void setRetailerCity(String retailerCity) {

		this.retailerCity = retailerCity;

	}

	public String getRetailerState() {

		return retailerState;

	}

	public void setRetailerState(String retailerState) {

		this.retailerState = retailerState;

	}

	public String getRetailerEmailId() {

		return retailerEmailId;

	}

	public void setRetailerEmailId(String retailerEmailId) {

		this.retailerEmailId = retailerEmailId;

	}

	public OrderStatus getStatus() {

		return status;

	}

	public void setStatus(OrderStatus status) {

		this.status = status;

	}

	public String getStatusDescription() {

		return statusDescription;

	}

	public void setStatusDescription(String statusDescription) {

		this.statusDescription = statusDescription;

	}

	public Float getTotalAmount() {

		return totalAmount;

	}

	public void setTotalAmount(Float totalAmount) {

		this.totalAmount = totalAmount;

	}

	public Float getGvAmount() {

		return gvAmount;

	}

	public void setGvAmount(Float gvAmount) {

		this.gvAmount = gvAmount;

	}

	public Float getTotalWeight() {

		return totalWeight;

	}

	public void setTotalWeight(Float totalWeight) {

		this.totalWeight = totalWeight;

	}

	public String getInvoiceNumber() {

		return invoiceNumber;

	}

	public void setInvoiceNumber(String invoiceNumber) {

		this.invoiceNumber = invoiceNumber;

	}

	public String getBilledBy() {

		return billedBy;

	}

	public void setBilledBy(String billedBy) {

		this.billedBy = billedBy;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public LocalDateTime getAcceptedTimestamp() {

		return acceptedTimestamp;

	}

	public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {

		this.acceptedTimestamp = acceptedTimestamp;

	}

	public LocalDateTime getBillingTimestamp() {

		return billingTimestamp;

	}

	public void setBillingTimestamp(LocalDateTime billingTimestamp) {

		this.billingTimestamp = billingTimestamp;

	}

	public LocalDateTime getShippingTimestamp() {

		return shippingTimestamp;

	}

	public void setShippingTimestamp(LocalDateTime shippingTimestamp) {

		this.shippingTimestamp = shippingTimestamp;

	}

	public LocalDateTime getPickupTimestamp() {

		return pickupTimestamp;

	}

	public void setPickupTimestamp(LocalDateTime pickupTimestamp) {

		this.pickupTimestamp = pickupTimestamp;

	}

	public LocalDateTime getDeliveryTimestamp() {

		return deliveryTimestamp;

	}

	public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {

		this.deliveryTimestamp = deliveryTimestamp;

	}

	public LocalDateTime getOutOfStockTimestamp() {

		return outOfStockTimestamp;

	}

	public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {

		this.outOfStockTimestamp = outOfStockTimestamp;

	}

	public Integer getTransactionId() {

		return transactionId;

	}

	public void setTransactionId(Integer transactionId) {

		this.transactionId = transactionId;

	}

	/*public Integer getJacketNumber() {

		return jacketNumber;

	}

	public void setJacketNumber(Integer jacketNumber) {

		this.jacketNumber = jacketNumber;

	}*/

	public String getReceiver() {

		return receiver;

	}

	public void setReceiver(String receiver) {

		this.receiver = receiver;

	}

	public Integer getBatchNumber() {

		return batchNumber;

	}

	public void setBatchNumber(Integer batchNumber) {

		this.batchNumber = batchNumber;

	}

	public Integer getSerialNumber() {

		return serialNumber;

	}

	public void setSerialNumber(Integer serialNumber) {

		this.serialNumber = serialNumber;

	}

	public Boolean isDoaFlag() {

		return doaFlag;

	}

	public void setDoaFlag(Boolean doaFlag) {

		this.doaFlag = doaFlag;

	}

	public Integer getPickupRequestNumber() {

		return pickupRequestNumber;

	}

	public void setPickupRequestNumber(Integer pickupRequestNumber) {

		this.pickupRequestNumber = pickupRequestNumber;

	}

	public Integer getNewOrderId() {

		return newOrderId;

	}

	public void setNewOrderId(Integer newOrderId) {

		this.newOrderId = newOrderId;

	}

	public LocalDateTime getDoaAuthTimestamp() {

		return doaAuthTimestamp;

	}

	public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {

		this.doaAuthTimestamp = doaAuthTimestamp;

	}

	public LocalDateTime getDoaPickupTimestamp() {

		return doaPickupTimestamp;

	}

	public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {

		this.doaPickupTimestamp = doaPickupTimestamp;

	}

	public LocalDateTime getReceiverReturnTimestamp() {

		return receiverReturnTimestamp;

	}

	public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {

		this.receiverReturnTimestamp = receiverReturnTimestamp;

	}

	public LocalDateTime getReShipTimestamp() {

		return reShipTimestamp;

	}

	public void setReShipTimestamp(LocalDateTime reShipTimestamp) {

		this.reShipTimestamp = reShipTimestamp;

	}

	public LocalDateTime getRefundTimestamp() {

		return refundTimestamp;

	}

	public void setRefundTimestamp(LocalDateTime refundTimestamp) {

		this.refundTimestamp = refundTimestamp;

	}

	public Integer getPurchaseOrderId() {

		return purchaseOrderId;

	}

	public void setPurchaseOrderId(Integer purchaseOrderId) {

		this.purchaseOrderId = purchaseOrderId;

	}

	public Boolean isCod() {

		return cod;

	}

	public void setCod(Boolean cod) {

		this.cod = cod;

	}

	public LocalDateTime getVerificationTimestamp() {

		return verificationTimestamp;

	}

	public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {

		this.verificationTimestamp = verificationTimestamp;

	}

	public String getRefundBy() {

		return refundBy;

	}

	public void setRefundBy(String refundBy) {

		this.refundBy = refundBy;

	}

	public String getRefundReason() {

		return refundReason;

	}

	public void setRefundReason(String refundReason) {

		this.refundReason = refundReason;

	}

	/*public DelayReason getDelayReason() {

		return delayReason;

	}

	public void setDelayReason(DelayReason delayReason) {

		this.delayReason = delayReason;

	}*/

	public LocalDateTime getCodReconciliationTimestamp() {

		return codReconciliationTimestamp;

	}

	public void setCodReconciliationTimestamp(LocalDateTime codReconciliationTimestamp) {

		this.codReconciliationTimestamp = codReconciliationTimestamp;

	}

	public Integer getPreviousStatus() {

		return previousStatus;

	}

	public void setPreviousStatus(Integer previousStatus) {

		this.previousStatus = previousStatus;

	}

	public Integer getVendorId() {

		return vendorId;

	}

	public void setVendorId(Integer vendorId) {

		this.vendorId = vendorId;

	}

	public String getDelayReasonText() {

		return delayReasonText;

	}

	public void setDelayReasonText(String delayReasonText) {

		this.delayReasonText = delayReasonText;

	}

	public Integer getDoaLogisticsProviderId() {

		return doaLogisticsProviderId;

	}

	public void setDoaLogisticsProviderId(Integer doaLogisticsProviderId) {

		this.doaLogisticsProviderId = doaLogisticsProviderId;

	}

	public Boolean isVendorPaid() {

		return vendorPaid;

	}

	public void setVendorPaid(Boolean vendorPaid) {

		this.vendorPaid = vendorPaid;

	}

	public LocalDateTime getLocalConnectedTimestamp() {

		return localConnectedTimestamp;

	}

	public void setLocalConnectedTimestamp(LocalDateTime localConnectedTimestamp) {

		this.localConnectedTimestamp = localConnectedTimestamp;

	}

	public LocalDateTime getReachedDestinationTimestamp() {

		return reachedDestinationTimestamp;

	}

	public void setReachedDestinationTimestamp(LocalDateTime reachedDestinationTimestamp) {

		this.reachedDestinationTimestamp = reachedDestinationTimestamp;

	}

	public LocalDateTime getFirstDlvyatmpTimestamp() {

		return firstDlvyatmpTimestamp;

	}

	public void setFirstDlvyatmpTimestamp(LocalDateTime firstDlvyatmpTimestamp) {

		this.firstDlvyatmpTimestamp = firstDlvyatmpTimestamp;

	}

	public Integer getOriginalOrderId() {

		return originalOrderId;

	}

	public void setOriginalOrderId(Integer originalOrderId) {

		this.originalOrderId = originalOrderId;

	}

	public Integer getFulfilmentWarehouseId() {

		return fulfilmentWarehouseId;

	}

	public void setFulfilmentWarehouseId(Integer fulfilmentWarehouseId) {

		this.fulfilmentWarehouseId = fulfilmentWarehouseId;

	}

	public Integer getOrderType() {

		return orderType;

	}

	public void setOrderType(Integer orderType) {

		this.orderType = orderType;

	}

	public Integer getPickupStoreId() {

		return pickupStoreId;

	}

	public void setPickupStoreId(Integer pickupStoreId) {

		this.pickupStoreId = pickupStoreId;

	}

	public Boolean isOtg() {

		return otg;

	}

	public void setOtg(Boolean otg) {

		this.otg = otg;

	}

	public LocalDateTime getCourierDeliveryTimestamp() {

		return courierDeliveryTimestamp;

	}

	public void setCourierDeliveryTimestamp(LocalDateTime courierDeliveryTimestamp) {

		this.courierDeliveryTimestamp = courierDeliveryTimestamp;

	}

	public Integer getInsurer() {

		return insurer;

	}

	public void setInsurer(Integer insurer) {

		this.insurer = insurer;

	}

	public Float getInsuranceAmount() {

		return insuranceAmount;

	}

	public void setInsuranceAmount(Float insuranceAmount) {

		this.insuranceAmount = insuranceAmount;

	}

	public Integer getFreebieItemId() {

		return freebieItemId;

	}

	public void setFreebieItemId(Integer freebieItemId) {

		this.freebieItemId = freebieItemId;

	}

	public Integer getSource() {

		return source;

	}

	public void setSource(Integer source) {

		this.source = source;

	}

	public Float getAdvanceAmount() {

		return advanceAmount;

	}

	public void setAdvanceAmount(Float advanceAmount) {

		this.advanceAmount = advanceAmount;

	}

	public Integer getStoreId() {

		return storeId;

	}

	public void setStoreId(Integer storeId) {

		this.storeId = storeId;

	}

	public Integer getProductCondition() {

		return productCondition;

	}

	public void setProductCondition(Integer productCondition) {

		this.productCondition = productCondition;

	}

	public Integer getDataProtectionInsurer() {

		return dataProtectionInsurer;

	}

	public void setDataProtectionInsurer(Integer dataProtectionInsurer) {

		this.dataProtectionInsurer = dataProtectionInsurer;

	}

	public Integer getDataProtectionAmount() {

		return dataProtectionAmount;

	}

	public void setDataProtectionAmount(Integer dataProtectionAmount) {

		this.dataProtectionAmount = dataProtectionAmount;

	}

	public TaxType getTaxType() {

		return taxType;

	}

	public void setTaxType(TaxType taxType) {

		this.taxType = taxType;

	}

	public String getLogisticsTransactionId() {

		return logisticsTransactionId;

	}

	public void setLogisticsTransactionId(String logisticsTransactionId) {

		this.logisticsTransactionId = logisticsTransactionId;

	}

	public Float getShippingCost() {

		return shippingCost;

	}

	public void setShippingCost(Float shippingCost) {

		this.shippingCost = shippingCost;

	}

	public Float getCodCharges() {

		return codCharges;

	}

	public void setCodCharges(Float codCharges) {

		this.codCharges = codCharges;

	}

	public Float getWalletAmount() {

		return walletAmount;

	}

	public void setWalletAmount(Float walletAmount) {

		this.walletAmount = walletAmount;

	}

	public Float getNetPayableAmount() {

		return netPayableAmount;

	}

	public void setNetPayableAmount(Float netPayableAmount) {

		this.netPayableAmount = netPayableAmount;

	}

	public Float getShippingRefund() {

		return shippingRefund;

	}

	public void setShippingRefund(Float shippingRefund) {

		this.shippingRefund = shippingRefund;

	}

	public LineItem getLineItem() {

		return lineItem;

	}

	public void setLineItem(LineItem lineItem) {

		this.lineItem = lineItem;

	}

	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 == null) ? 0 : id.hashCode());

		return result;

	}

	@Override

	public boolean equals(Object obj) {

		if (this == obj)

			return true;

		if (obj == null)

			return false;

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

			return false;

		Order other = (Order) obj;

		if (id == null) {

			if (other.id != null)

				return false;

		} else if (!id.equals(other.id))

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "Order [id=" + id + ", warehouseId=" + warehouseId + ", sellerId=" + sellerId + ", warehouseAddressId="

				+ warehouseAddressId + ", logisticsProviderId=" + logisticsProviderId + ", airwayBillNumber="

				+ airwayBillNumber + ", trackingId=" + trackingId + ", expectedDeliveryTime=" + expectedDeliveryTime

				+ ", promisedDeliveryTime=" + promisedDeliveryTime + ", expectedShippingTime=" + expectedShippingTime

				+ ", promisedShippingTime=" + promisedShippingTime + ", retailerId=" + retailerId + ", retailerName="

				+ retailerName + ", retailerMobileNumber=" + retailerMobileNumber + ", retailerPinCode="

				+ retailerPinCode + ", retailerAddress1=" + retailerAddress1 + ", retailerAddress2=" + retailerAddress2

				+ ", retailerCity=" + retailerCity + ", retailerState=" + retailerState + ", retailerEmailId="

				+ retailerEmailId + ", status=" + status + ", statusDescription=" + statusDescription + ", totalAmount="

				+ totalAmount + ", gvAmount=" + gvAmount + ", totalWeight=" + totalWeight + ", invoiceNumber="

				+ invoiceNumber + ", billedBy=" + billedBy + ", createTimestamp=" + createTimestamp

				+ ", acceptedTimestamp=" + acceptedTimestamp + ", billingTimestamp=" + billingTimestamp

				+ ", shippingTimestamp=" + shippingTimestamp + ", pickupTimestamp=" + pickupTimestamp

				+ ", deliveryTimestamp=" + deliveryTimestamp + ", outOfStockTimestamp=" + outOfStockTimestamp

				/*+ ", jacketNumber=" + jacketNumber*/ + ", receiver=" + receiver

				+ ", batchNumber=" + batchNumber + ", serialNumber=" + serialNumber + ", doaFlag=" + doaFlag

				+ ", pickupRequestNumber=" + pickupRequestNumber + ", newOrderId=" + newOrderId + ", doaAuthTimestamp="

				+ doaAuthTimestamp + ", doaPickupTimestamp=" + doaPickupTimestamp + ", receiverReturnTimestamp="

				+ receiverReturnTimestamp + ", reShipTimestamp=" + reShipTimestamp + ", refundTimestamp="

				+ refundTimestamp + ", purchaseOrderId=" + purchaseOrderId + ", cod=" + cod + ", verificationTimestamp="

				+ verificationTimestamp + ", refundBy=" + refundBy + ", refundReason=" + refundReason /*+ ", delayReason="

				+ delayReason*/ + ", codReconciliationTimestamp=" + codReconciliationTimestamp + ", previousStatus="

				+ previousStatus + ", vendorId=" + vendorId + ", delayReasonText=" + delayReasonText

				+ ", doaLogisticsProviderId=" + doaLogisticsProviderId + ", vendorPaid=" + vendorPaid

				+ ", localConnectedTimestamp=" + localConnectedTimestamp + ", reachedDestinationTimestamp="

				+ reachedDestinationTimestamp + ", firstDlvyatmpTimestamp=" + firstDlvyatmpTimestamp

				+ ", originalOrderId=" + originalOrderId + ", fulfilmentWarehouseId=" + fulfilmentWarehouseId

				+ ", orderType=" + orderType + ", pickupStoreId=" + pickupStoreId + ", otg=" + otg

				+ ", courierDeliveryTimestamp=" + courierDeliveryTimestamp + ", insurer=" + insurer

				+ ", insuranceAmount=" + insuranceAmount + ", freebieItemId=" + freebieItemId + ", source=" + source

				+ ", advanceAmount=" + advanceAmount + ", storeId=" + storeId + ", productCondition=" + productCondition

				+ ", dataProtectionInsurer=" + dataProtectionInsurer + ", dataProtectionAmount=" + dataProtectionAmount

				+ ", taxType=" + taxType + ", logisticsTransactionId=" + logisticsTransactionId + ", shippingCost="

				+ shippingCost + ", codCharges=" + codCharges + ", walletAmount=" + walletAmount + ", netPayableAmount="

				+ netPayableAmount + ", shippingRefund=" + shippingRefund + "]";

	}

}