Subversion Repositories SmartDukaan

Rev

Rev 21820 | Rev 21984 | Go to most recent revision | View as "text/plain" | Blame | Compare with Previous | Last modification | View Log | RSS feed

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.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;
        
        @OneToOne(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) {
                        if (other.billingTimestamp != null)
                                return false;
                } else if (!billingTimestamp.equals(other.billingTimestamp))
                        return false;
                if (cod == null) {
                        if (other.cod != null)
                                return false;
                } else if (!cod.equals(other.cod))
                        return false;
                if (codCharges == null) {
                        if (other.codCharges != null)
                                return false;
                } else if (!codCharges.equals(other.codCharges))
                        return false;
                if (codReconciliationTimestamp == null) {
                        if (other.codReconciliationTimestamp != null)
                                return false;
                } else if (!codReconciliationTimestamp.equals(other.codReconciliationTimestamp))
                        return false;
                if (courierDeliveryTimestamp == null) {
                        if (other.courierDeliveryTimestamp != null)
                                return false;
                } else if (!courierDeliveryTimestamp.equals(other.courierDeliveryTimestamp))
                        return false;
                if (createTimestamp == null) {
                        if (other.createTimestamp != null)
                                return false;
                } else if (!createTimestamp.equals(other.createTimestamp))
                        return false;
                if (dataProtectionAmount == null) {
                        if (other.dataProtectionAmount != null)
                                return false;
                } else if (!dataProtectionAmount.equals(other.dataProtectionAmount))
                        return false;
                if (dataProtectionInsurer == null) {
                        if (other.dataProtectionInsurer != null)
                                return false;
                } else if (!dataProtectionInsurer.equals(other.dataProtectionInsurer))
                        return false;
                if (delayReason != other.delayReason)
                        return false;
                if (delayReasonText == null) {
                        if (other.delayReasonText != null)
                                return false;
                } else if (!delayReasonText.equals(other.delayReasonText))
                        return false;
                if (deliveryTimestamp == null) {
                        if (other.deliveryTimestamp != null)
                                return false;
                } else if (!deliveryTimestamp.equals(other.deliveryTimestamp))
                        return false;
                if (doaAuthTimestamp == null) {
                        if (other.doaAuthTimestamp != null)
                                return false;
                } else if (!doaAuthTimestamp.equals(other.doaAuthTimestamp))
                        return false;
                if (doaFlag == null) {
                        if (other.doaFlag != null)
                                return false;
                } else if (!doaFlag.equals(other.doaFlag))
                        return false;
                if (doaLogisticsProviderId == null) {
                        if (other.doaLogisticsProviderId != null)
                                return false;
                } else if (!doaLogisticsProviderId.equals(other.doaLogisticsProviderId))
                        return false;
                if (doaPickupTimestamp == null) {
                        if (other.doaPickupTimestamp != null)
                                return false;
                } else if (!doaPickupTimestamp.equals(other.doaPickupTimestamp))
                        return false;
                if (expectedDeliveryTime == null) {
                        if (other.expectedDeliveryTime != null)
                                return false;
                } else if (!expectedDeliveryTime.equals(other.expectedDeliveryTime))
                        return false;
                if (expectedShippingTime == null) {
                        if (other.expectedShippingTime != null)
                                return false;
                } else if (!expectedShippingTime.equals(other.expectedShippingTime))
                        return false;
                if (firstDlvyatmpTimestamp == null) {
                        if (other.firstDlvyatmpTimestamp != null)
                                return false;
                } else if (!firstDlvyatmpTimestamp.equals(other.firstDlvyatmpTimestamp))
                        return false;
                if (freebieItemId == null) {
                        if (other.freebieItemId != null)
                                return false;
                } else if (!freebieItemId.equals(other.freebieItemId))
                        return false;
                if (fulfilmentWarehouseId == null) {
                        if (other.fulfilmentWarehouseId != null)
                                return false;
                } else if (!fulfilmentWarehouseId.equals(other.fulfilmentWarehouseId))
                        return false;
                if (gvAmount == null) {
                        if (other.gvAmount != null)
                                return false;
                } else if (!gvAmount.equals(other.gvAmount))
                        return false;
                if (id == null) {
                        if (other.id != null)
                                return false;
                } else if (!id.equals(other.id))
                        return false;
                if (insuranceAmount == null) {
                        if (other.insuranceAmount != null)
                                return false;
                } else if (!insuranceAmount.equals(other.insuranceAmount))
                        return false;
                if (insurer == null) {
                        if (other.insurer != null)
                                return false;
                } else if (!insurer.equals(other.insurer))
                        return false;
                if (invoiceNumber == null) {
                        if (other.invoiceNumber != null)
                                return false;
                } else if (!invoiceNumber.equals(other.invoiceNumber))
                        return false;
                if (jacketNumber == null) {
                        if (other.jacketNumber != null)
                                return false;
                } else if (!jacketNumber.equals(other.jacketNumber))
                        return false;
                if (lineItem == null) {
                        if (other.lineItem != null)
                                return false;
                } else if (!lineItem.equals(other.lineItem))
                        return false;
                if (localConnectedTimestamp == null) {
                        if (other.localConnectedTimestamp != null)
                                return false;
                } else if (!localConnectedTimestamp.equals(other.localConnectedTimestamp))
                        return false;
                if (logisticsProviderId == null) {
                        if (other.logisticsProviderId != null)
                                return false;
                } else if (!logisticsProviderId.equals(other.logisticsProviderId))
                        return false;
                if (logisticsTransactionId == null) {
                        if (other.logisticsTransactionId != null)
                                return false;
                } else if (!logisticsTransactionId.equals(other.logisticsTransactionId))
                        return false;
                if (netPayableAmount == null) {
                        if (other.netPayableAmount != null)
                                return false;
                } else if (!netPayableAmount.equals(other.netPayableAmount))
                        return false;
                if (newOrderId == null) {
                        if (other.newOrderId != null)
                                return false;
                } else if (!newOrderId.equals(other.newOrderId))
                        return false;
                if (orderType == null) {
                        if (other.orderType != null)
                                return false;
                } else if (!orderType.equals(other.orderType))
                        return false;
                if (originalOrderId == null) {
                        if (other.originalOrderId != null)
                                return false;
                } else if (!originalOrderId.equals(other.originalOrderId))
                        return false;
                if (otg == null) {
                        if (other.otg != null)
                                return false;
                } else if (!otg.equals(other.otg))
                        return false;
                if (outOfStockTimestamp == null) {
                        if (other.outOfStockTimestamp != null)
                                return false;
                } else if (!outOfStockTimestamp.equals(other.outOfStockTimestamp))
                        return false;
                if (pickupRequestNumber == null) {
                        if (other.pickupRequestNumber != null)
                                return false;
                } else if (!pickupRequestNumber.equals(other.pickupRequestNumber))
                        return false;
                if (pickupStoreId == null) {
                        if (other.pickupStoreId != null)
                                return false;
                } else if (!pickupStoreId.equals(other.pickupStoreId))
                        return false;
                if (pickupTimestamp == null) {
                        if (other.pickupTimestamp != null)
                                return false;
                } else if (!pickupTimestamp.equals(other.pickupTimestamp))
                        return false;
                if (previousStatus == null) {
                        if (other.previousStatus != null)
                                return false;
                } else if (!previousStatus.equals(other.previousStatus))
                        return false;
                if (productCondition == null) {
                        if (other.productCondition != null)
                                return false;
                } else if (!productCondition.equals(other.productCondition))
                        return false;
                if (promisedDeliveryTime == null) {
                        if (other.promisedDeliveryTime != null)
                                return false;
                } else if (!promisedDeliveryTime.equals(other.promisedDeliveryTime))
                        return false;
                if (promisedShippingTime == null) {
                        if (other.promisedShippingTime != null)
                                return false;
                } else if (!promisedShippingTime.equals(other.promisedShippingTime))
                        return false;
                if (purchaseOrderId == null) {
                        if (other.purchaseOrderId != null)
                                return false;
                } else if (!purchaseOrderId.equals(other.purchaseOrderId))
                        return false;
                if (reShipTimestamp == null) {
                        if (other.reShipTimestamp != null)
                                return false;
                } else if (!reShipTimestamp.equals(other.reShipTimestamp))
                        return false;
                if (reachedDestinationTimestamp == null) {
                        if (other.reachedDestinationTimestamp != null)
                                return false;
                } else if (!reachedDestinationTimestamp.equals(other.reachedDestinationTimestamp))
                        return false;
                if (receiver == null) {
                        if (other.receiver != null)
                                return false;
                } else if (!receiver.equals(other.receiver))
                        return false;
                if (receiverReturnTimestamp == null) {
                        if (other.receiverReturnTimestamp != null)
                                return false;
                } else if (!receiverReturnTimestamp.equals(other.receiverReturnTimestamp))
                        return false;
                if (refundBy == null) {
                        if (other.refundBy != null)
                                return false;
                } else if (!refundBy.equals(other.refundBy))
                        return false;
                if (refundReason == null) {
                        if (other.refundReason != null)
                                return false;
                } else if (!refundReason.equals(other.refundReason))
                        return false;
                if (refundTimestamp == null) {
                        if (other.refundTimestamp != null)
                                return false;
                } else if (!refundTimestamp.equals(other.refundTimestamp))
                        return false;
                if (retailerAddress1 == null) {
                        if (other.retailerAddress1 != null)
                                return false;
                } else if (!retailerAddress1.equals(other.retailerAddress1))
                        return false;
                if (retailerAddress2 == null) {
                        if (other.retailerAddress2 != null)
                                return false;
                } else if (!retailerAddress2.equals(other.retailerAddress2))
                        return false;
                if (retailerCity == null) {
                        if (other.retailerCity != null)
                                return false;
                } else if (!retailerCity.equals(other.retailerCity))
                        return false;
                if (retailerEmailId == null) {
                        if (other.retailerEmailId != null)
                                return false;
                } else if (!retailerEmailId.equals(other.retailerEmailId))
                        return false;
                if (retailerId == null) {
                        if (other.retailerId != null)
                                return false;
                } else if (!retailerId.equals(other.retailerId))
                        return false;
                if (retailerMobileNumber == null) {
                        if (other.retailerMobileNumber != null)
                                return false;
                } else if (!retailerMobileNumber.equals(other.retailerMobileNumber))
                        return false;
                if (retailerName == null) {
                        if (other.retailerName != null)
                                return false;
                } else if (!retailerName.equals(other.retailerName))
                        return false;
                if (retailerPinCode == null) {
                        if (other.retailerPinCode != null)
                                return false;
                } else if (!retailerPinCode.equals(other.retailerPinCode))
                        return false;
                if (retailerState == null) {
                        if (other.retailerState != null)
                                return false;
                } else if (!retailerState.equals(other.retailerState))
                        return false;
                if (sellerId == null) {
                        if (other.sellerId != null)
                                return false;
                } else if (!sellerId.equals(other.sellerId))
                        return false;
                if (serialNumber == null) {
                        if (other.serialNumber != null)
                                return false;
                } else if (!serialNumber.equals(other.serialNumber))
                        return false;
                if (shippingCost == null) {
                        if (other.shippingCost != null)
                                return false;
                } else if (!shippingCost.equals(other.shippingCost))
                        return false;
                if (shippingRefund == null) {
                        if (other.shippingRefund != null)
                                return false;
                } else if (!shippingRefund.equals(other.shippingRefund))
                        return false;
                if (shippingTimestamp == null) {
                        if (other.shippingTimestamp != null)
                                return false;
                } else if (!shippingTimestamp.equals(other.shippingTimestamp))
                        return false;
                if (source == null) {
                        if (other.source != null)
                                return false;
                } else if (!source.equals(other.source))
                        return false;
                if (status != other.status)
                        return false;
                if (statusDescription == null) {
                        if (other.statusDescription != null)
                                return false;
                } else if (!statusDescription.equals(other.statusDescription))
                        return false;
                if (storeId == null) {
                        if (other.storeId != null)
                                return false;
                } else if (!storeId.equals(other.storeId))
                        return false;
                if (taxType != other.taxType)
                        return false;
                if (totalAmount == null) {
                        if (other.totalAmount != null)
                                return false;
                } else if (!totalAmount.equals(other.totalAmount))
                        return false;
                if (totalWeight == null) {
                        if (other.totalWeight != null)
                                return false;
                } else if (!totalWeight.equals(other.totalWeight))
                        return false;
                if (trackingId == null) {
                        if (other.trackingId != null)
                                return false;
                } else if (!trackingId.equals(other.trackingId))
                        return false;
                if (transactionId == null) {
                        if (other.transactionId != null)
                                return false;
                } else if (!transactionId.equals(other.transactionId))
                        return false;
                if (vendorId == null) {
                        if (other.vendorId != null)
                                return false;
                } else if (!vendorId.equals(other.vendorId))
                        return false;
                if (vendorPaid == null) {
                        if (other.vendorPaid != null)
                                return false;
                } else if (!vendorPaid.equals(other.vendorPaid))
                        return false;
                if (verificationTimestamp == null) {
                        if (other.verificationTimestamp != null)
                                return false;
                } else if (!verificationTimestamp.equals(other.verificationTimestamp))
                        return false;
                if (walletAmount == null) {
                        if (other.walletAmount != null)
                                return false;
                } else if (!walletAmount.equals(other.walletAmount))
                        return false;
                if (warehouseAddressId == null) {
                        if (other.warehouseAddressId != null)
                                return false;
                } else if (!warehouseAddressId.equals(other.warehouseAddressId))
                        return false;
                if (warehouseId == null) {
                        if (other.warehouseId != null)
                                return false;
                } else if (!warehouseId.equals(other.warehouseId))
                        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 + "]";
        }
    
}