Subversion Repositories SmartDukaan

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

import java.io.Serializable;

import java.time.LocalDateTime;

import javax.persistence.CascadeType;

import javax.persistence.Column;

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

import javax.persistence.Table;

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

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

	@NamedQuery(

		name = "Order.selectByAirwayBillOrInvoiceNumberRetailerId",

		query = "select li.itemId, li.brand, li.modelName, li.modelNumber, li.color, li.quantity, li.unitPrice, i.type, sum(li.quantity), o.invoiceNumber from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where (o.airwayBillNumber = :airwayBillOrInvoiceNumber or o.invoiceNumber = :airwayBillOrInvoiceNumber) and o.retailerId = :retailerId group by li.itemId"),

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

	@Column(name = "expected_delivery_time")

	private LocalDateTime expectedDeliveryTime;

	@Column(name = "promised_delivery_time")

	private LocalDateTime promisedDeliveryTime;

	@Column(name = "expected_shipping_time")

	private LocalDateTime expectedShippingTime;

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

	@Column(name = "created_timestamp")

	private LocalDateTime createTimestamp;

	@Column(name = "accepted_timestamp")

	private LocalDateTime acceptedTimestamp;

	@Column(name = "billing_timestamp")

	private LocalDateTime billingTimestamp;

	@Column(name = "shipping_timestamp")

	private LocalDateTime shippingTimestamp;

	@Column(name = "pickup_timestamp")

	private LocalDateTime pickupTimestamp;

	@Column(name = "delivery_timestamp")

	private LocalDateTime deliveryTimestamp;

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

	@Column(name = "doa_pickup_timestamp")

	private LocalDateTime doaPickupTimestamp;

	@Column(name = "received_return_timestamp")

	private LocalDateTime receiverReturnTimestamp;

	@Column(name = "reship_timestamp")

	private LocalDateTime reShipTimestamp;

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

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

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

	@Column(name = "local_connected_timestamp")

	private LocalDateTime localConnectedTimestamp;

	@Column(name = "reached_destination_timestamp")

	private LocalDateTime reachedDestinationTimestamp;

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

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

	}

	@Override

	public int hashCode() {

		final int prime = 31;

		int result = 1;

		result = prime * result + ((acceptedTimestamp == null) ? 0 : acceptedTimestamp.hashCode());

		result = prime * result + ((advanceAmount == null) ? 0 : advanceAmount.hashCode());

		result = prime * result + ((airwayBillNumber == null) ? 0 : airwayBillNumber.hashCode());

		result = prime * result + ((batchNumber == null) ? 0 : batchNumber.hashCode());

		result = prime * result + ((billedBy == null) ? 0 : billedBy.hashCode());

		result = prime * result + ((billingTimestamp == null) ? 0 : billingTimestamp.hashCode());

		result = prime * result + ((cod == null) ? 0 : cod.hashCode());

		result = prime * result + ((codCharges == null) ? 0 : codCharges.hashCode());

		result = prime * result + ((codReconciliationTimestamp == null) ? 0 : codReconciliationTimestamp.hashCode());

		result = prime * result + ((courierDeliveryTimestamp == null) ? 0 : courierDeliveryTimestamp.hashCode());

		result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());

		result = prime * result + ((dataProtectionAmount == null) ? 0 : dataProtectionAmount.hashCode());

		result = prime * result + ((dataProtectionInsurer == null) ? 0 : dataProtectionInsurer.hashCode());

		result = prime * result + ((delayReason == null) ? 0 : delayReason.hashCode());

		result = prime * result + ((delayReasonText == null) ? 0 : delayReasonText.hashCode());

		result = prime * result + ((deliveryTimestamp == null) ? 0 : deliveryTimestamp.hashCode());

		result = prime * result + ((doaAuthTimestamp == null) ? 0 : doaAuthTimestamp.hashCode());

		result = prime * result + ((doaFlag == null) ? 0 : doaFlag.hashCode());

		result = prime * result + ((doaLogisticsProviderId == null) ? 0 : doaLogisticsProviderId.hashCode());

		result = prime * result + ((doaPickupTimestamp == null) ? 0 : doaPickupTimestamp.hashCode());

		result = prime * result + ((expectedDeliveryTime == null) ? 0 : expectedDeliveryTime.hashCode());

		result = prime * result + ((expectedShippingTime == null) ? 0 : expectedShippingTime.hashCode());

		result = prime * result + ((firstDlvyatmpTimestamp == null) ? 0 : firstDlvyatmpTimestamp.hashCode());

		result = prime * result + ((freebieItemId == null) ? 0 : freebieItemId.hashCode());

		result = prime * result + ((fulfilmentWarehouseId == null) ? 0 : fulfilmentWarehouseId.hashCode());

		result = prime * result + ((gvAmount == null) ? 0 : gvAmount.hashCode());

		result = prime * result + ((id == null) ? 0 : id.hashCode());

		result = prime * result + ((insuranceAmount == null) ? 0 : insuranceAmount.hashCode());

		result = prime * result + ((insurer == null) ? 0 : insurer.hashCode());

		result = prime * result + ((invoiceNumber == null) ? 0 : invoiceNumber.hashCode());

		result = prime * result + ((jacketNumber == null) ? 0 : jacketNumber.hashCode());

		result = prime * result + ((lineItem == null) ? 0 : lineItem.hashCode());

		result = prime * result + ((localConnectedTimestamp == null) ? 0 : localConnectedTimestamp.hashCode());

		result = prime * result + ((logisticsProviderId == null) ? 0 : logisticsProviderId.hashCode());

		result = prime * result + ((logisticsTransactionId == null) ? 0 : logisticsTransactionId.hashCode());

		result = prime * result + ((netPayableAmount == null) ? 0 : netPayableAmount.hashCode());

		result = prime * result + ((newOrderId == null) ? 0 : newOrderId.hashCode());

		result = prime * result + ((orderType == null) ? 0 : orderType.hashCode());

		result = prime * result + ((originalOrderId == null) ? 0 : originalOrderId.hashCode());

		result = prime * result + ((otg == null) ? 0 : otg.hashCode());

		result = prime * result + ((outOfStockTimestamp == null) ? 0 : outOfStockTimestamp.hashCode());

		result = prime * result + ((pickupRequestNumber == null) ? 0 : pickupRequestNumber.hashCode());

		result = prime * result + ((pickupStoreId == null) ? 0 : pickupStoreId.hashCode());

		result = prime * result + ((pickupTimestamp == null) ? 0 : pickupTimestamp.hashCode());

		result = prime * result + ((previousStatus == null) ? 0 : previousStatus.hashCode());

		result = prime * result + ((productCondition == null) ? 0 : productCondition.hashCode());

		result = prime * result + ((promisedDeliveryTime == null) ? 0 : promisedDeliveryTime.hashCode());

		result = prime * result + ((promisedShippingTime == null) ? 0 : promisedShippingTime.hashCode());

		result = prime * result + ((purchaseOrderId == null) ? 0 : purchaseOrderId.hashCode());

		result = prime * result + ((reShipTimestamp == null) ? 0 : reShipTimestamp.hashCode());

		result = prime * result + ((reachedDestinationTimestamp == null) ? 0 : reachedDestinationTimestamp.hashCode());

		result = prime * result + ((receiver == null) ? 0 : receiver.hashCode());

		result = prime * result + ((receiverReturnTimestamp == null) ? 0 : receiverReturnTimestamp.hashCode());

		result = prime * result + ((refundBy == null) ? 0 : refundBy.hashCode());

		result = prime * result + ((refundReason == null) ? 0 : refundReason.hashCode());

		result = prime * result + ((refundTimestamp == null) ? 0 : refundTimestamp.hashCode());

		result = prime * result + ((retailerAddress1 == null) ? 0 : retailerAddress1.hashCode());

		result = prime * result + ((retailerAddress2 == null) ? 0 : retailerAddress2.hashCode());

		result = prime * result + ((retailerCity == null) ? 0 : retailerCity.hashCode());

		result = prime * result + ((retailerEmailId == null) ? 0 : retailerEmailId.hashCode());

		result = prime * result + ((retailerId == null) ? 0 : retailerId.hashCode());

		result = prime * result + ((retailerMobileNumber == null) ? 0 : retailerMobileNumber.hashCode());

		result = prime * result + ((retailerName == null) ? 0 : retailerName.hashCode());

		result = prime * result + ((retailerPinCode == null) ? 0 : retailerPinCode.hashCode());

		result = prime * result + ((retailerState == null) ? 0 : retailerState.hashCode());

		result = prime * result + ((sellerId == null) ? 0 : sellerId.hashCode());

		result = prime * result + ((serialNumber == null) ? 0 : serialNumber.hashCode());

		result = prime * result + ((shippingCost == null) ? 0 : shippingCost.hashCode());

		result = prime * result + ((shippingRefund == null) ? 0 : shippingRefund.hashCode());

		result = prime * result + ((shippingTimestamp == null) ? 0 : shippingTimestamp.hashCode());

		result = prime * result + ((source == null) ? 0 : source.hashCode());

		result = prime * result + ((status == null) ? 0 : status.hashCode());

		result = prime * result + ((statusDescription == null) ? 0 : statusDescription.hashCode());

		result = prime * result + ((storeId == null) ? 0 : storeId.hashCode());

		result = prime * result + ((taxType == null) ? 0 : taxType.hashCode());

		result = prime * result + ((totalAmount == null) ? 0 : totalAmount.hashCode());

		result = prime * result + ((totalWeight == null) ? 0 : totalWeight.hashCode());

		result = prime * result + ((trackingId == null) ? 0 : trackingId.hashCode());

		result = prime * result + ((transactionId == null) ? 0 : transactionId.hashCode());

		result = prime * result + ((vendorId == null) ? 0 : vendorId.hashCode());

		result = prime * result + ((vendorPaid == null) ? 0 : vendorPaid.hashCode());

		result = prime * result + ((verificationTimestamp == null) ? 0 : verificationTimestamp.hashCode());

		result = prime * result + ((walletAmount == null) ? 0 : walletAmount.hashCode());

		result = prime * result + ((warehouseAddressId == null) ? 0 : warehouseAddressId.hashCode());

		result = prime * result + ((warehouseId == null) ? 0 : warehouseId.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 (acceptedTimestamp == null) {

			if (other.acceptedTimestamp != null)

				return false;

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

			return false;

		if (advanceAmount == null) {

			if (other.advanceAmount != null)

				return false;

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

			return false;

		if (airwayBillNumber == null) {

			if (other.airwayBillNumber != null)

				return false;

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

			return false;

		if (batchNumber == null) {

			if (other.batchNumber != null)

				return false;

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

			return false;

		if (billedBy == null) {

			if (other.billedBy != null)

				return false;

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

			return false;

		if (billingTimestamp == null) {