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