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

import javax.persistence.Enumerated;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import com.spice.profitmandi.dao.enumuration.DelayReason;

import com.spice.profitmandi.dao.enumuration.OrderStatus;

import com.spice.profitmandi.dao.enumuration.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 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.selectByAirwayBillOrInvoiceNumber",

		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")

})

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 int id;

	@Column(name = "warehouse_id")

	private int warehouseId;

	@Column(name = "seller_id")

	private int sellerId;

	@Column(name = "warehouse_address_id")

	private int warehouseAddressId;

	@Column(name = "logistics_provider_id")

	private int 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 int 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 int transactionId;

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

	private int jacketNumber;

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

	private String receiver;

	@Column(name = "batchNo")

	private int batchNumber;

	@Column(name = "serialNo")

	private int serialNumber;

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

	private boolean doaFlag;

	@Column(name = "pickupRequestNo")

	private int pickupRequestNumber;

	@Column(name = "new_order_id")

	private int 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 int purchaseOrderId;

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

	private boolean cod;

	@Column(name = "verification_timestamp")

	private LocalDateTime verificationTimestamp;

	@Column(name = "refund_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;

	@Column(name = "previous_status")

	private int previousStatus;

	@Column(name = "vendorId")

	private int vendorId;

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

	private String delayReasonText;

	@Column(name = "doa_logistics_provider_id")

	private int doaLogisticsProviderId;

	@Column(name = "vendor_paid", columnDefinition="tinyint(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 int originalOrderId;

	@Column(name = "fulfilmentWarehouseId")

	private int fulfilmentWarehouseId;

	@Column(name = "orderType")

	private int orderType;

	@Column(name = "pickupStoreId")

	private int pickupStoreId;

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

	private boolean otg;

	@Column(name = "courier_delivery_time")

	private LocalDateTime courierDeliveryTimestamp;

	@Column(name = "insurer")

	private int insurer;

	@Column(name = "insuranceAmount")

	private float insuranceAmount;

	@Column(name = "freebieItemId")

	private int freebieItemId;

	@Column(name = "source")

	private int source;

	@Column(name = "advanceAmount")

	private float advanceAmount;

	@Column(name = "storeId")

	private int storeId;

	@Column(name = "productCondition")

	private int productCondition;

	@Column(name = "dataProtectionInsurer")

	private int dataProtectionInsurer;

	@Column(name = "dataProtectionAmount")

	private int dataProtectionAmount;

	@Column(name = "taxType")

	@Enumerated(EnumType.STRING)

	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;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public int getWarehouseId() {

		return warehouseId;

	}

	public void setWarehouseId(int warehouseId) {

		this.warehouseId = warehouseId;

	}

	public int getSellerId() {

		return sellerId;

	}

	public void setSellerId(int sellerId) {

		this.sellerId = sellerId;

	}

	public int getWarehouseAddressId() {

		return warehouseAddressId;

	}

	public void setWarehouseAddressId(int warehouseAddressId) {

		this.warehouseAddressId = warehouseAddressId;

	}

	public int getLogisticsProviderId() {

		return logisticsProviderId;

	}

	public void setLogisticsProviderId(int 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 int getRetailerId() {

		return retailerId;

	}

	public void setRetailerId(int 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 int getTransactionId() {

		return transactionId;

	}

	public void setTransactionId(int transactionId) {

		this.transactionId = transactionId;

	}

	public int getJacketNumber() {

		return jacketNumber;

	}

	public void setJacketNumber(int jacketNumber) {

		this.jacketNumber = jacketNumber;

	}

	public String getReceiver() {

		return receiver;

	}

	public void setReceiver(String receiver) {

		this.receiver = receiver;

	}

	public int getBatchNumber() {

		return batchNumber;

	}

	public void setBatchNumber(int batchNumber) {

		this.batchNumber = batchNumber;

	}

	public int getSerialNumber() {

		return serialNumber;

	}

	public void setSerialNumber(int serialNumber) {

		this.serialNumber = serialNumber;

	}

	public boolean isDoaFlag() {

		return doaFlag;

	}

	public void setDoaFlag(boolean doaFlag) {

		this.doaFlag = doaFlag;

	}

	public int getPickupRequestNumber() {

		return pickupRequestNumber;

	}

	public void setPickupRequestNumber(int pickupRequestNumber) {

		this.pickupRequestNumber = pickupRequestNumber;

	}

	public int getNewOrderId() {

		return newOrderId;

	}

	public void setNewOrderId(int 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 int getPurchaseOrderId() {

		return purchaseOrderId;

	}

	public void setPurchaseOrderId(int 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 int getPreviousStatus() {

		return previousStatus;

	}

	public void setPreviousStatus(int previousStatus) {

		this.previousStatus = previousStatus;

	}

	public int getVendorId() {

		return vendorId;

	}

	public void setVendorId(int vendorId) {

		this.vendorId = vendorId;

	}

	public String getDelayReasonText() {

		return delayReasonText;

	}

	public void setDelayReasonText(String delayReasonText) {

		this.delayReasonText = delayReasonText;

	}

	public int getDoaLogisticsProviderId() {

		return doaLogisticsProviderId;

	}

	public void setDoaLogisticsProviderId(int 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 int getOriginalOrderId() {

		return originalOrderId;

	}

	public void setOriginalOrderId(int originalOrderId) {

		this.originalOrderId = originalOrderId;

	}

	public int getFulfilmentWarehouseId() {

		return fulfilmentWarehouseId;

	}

	public void setFulfilmentWarehouseId(int fulfilmentWarehouseId) {

		this.fulfilmentWarehouseId = fulfilmentWarehouseId;

	}

	public int getOrderType() {

		return orderType;

	}

	public void setOrderType(int orderType) {

		this.orderType = orderType;

	}

	public int getPickupStoreId() {

		return pickupStoreId;

	}

	public void setPickupStoreId(int 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 int getInsurer() {

		return insurer;

	}

	public void setInsurer(int insurer) {

		this.insurer = insurer;

	}

	public float getInsuranceAmount() {

		return insuranceAmount;

	}

	public void setInsuranceAmount(float insuranceAmount) {

		this.insuranceAmount = insuranceAmount;

	}

	public int getFreebieItemId() {

		return freebieItemId;

	}

	public void setFreebieItemId(int freebieItemId) {

		this.freebieItemId = freebieItemId;

	}

	public int getSource() {

		return source;

	}

	public void setSource(int source) {

		this.source = source;

	}

	public float getAdvanceAmount() {

		return advanceAmount;

	}

	public void setAdvanceAmount(float advanceAmount) {

		this.advanceAmount = advanceAmount;

	}

	public int getStoreId() {

		return storeId;

	}

	public void setStoreId(int storeId) {

		this.storeId = storeId;

	}

	public int getProductCondition() {

		return productCondition;

	}

	public void setProductCondition(int productCondition) {

		this.productCondition = productCondition;

	}

	public int getDataProtectionInsurer() {

		return dataProtectionInsurer;

	}

	public void setDataProtectionInsurer(int dataProtectionInsurer) {

		this.dataProtectionInsurer = dataProtectionInsurer;

	}

	public int getDataProtectionAmount() {

		return dataProtectionAmount;

	}

	public void setDataProtectionAmount(int 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;

	}

	@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 + "]";

	}

}