Subversion Repositories SmartDukaan

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

import java.io.Serializable;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Convert;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;

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

/**
 * This class basically contains order details
 * 
 * @author ashikali
 *
 */

@Entity
@Table(name="transaction.`order`", schema = "transaction")
@NamedQueries({
        @NamedQuery(name="Order.selectAll",query="select o from Order o"),
        @NamedQuery(name="Order.selectById",query="select o from Order o where o.id= :id"),
        @NamedQuery(
                name = "Order.selectByTransactionId", 
                query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
                        + "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
                        + "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name,  o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id "
                        + "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),
        
        @NamedQuery(
                name = "Order.selectItemIdTypeQuantity",
                query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId")
})
public class Order implements Serializable{
        
        private static final long serialVersionUID = 1L;
        
        public Order() {
        }
        
        @Id
        @Column(name="id", unique=true, updatable=false)
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private Integer id;
        
        @Column(name = "warehouse_id")
        private Integer warehouseId;
        
        @Column(name = "seller_id")
        private Integer sellerId;
        
        @Column(name = "warehouse_address_id")
        private Integer warehouseAddressId;
        
        @Column(name = "logistics_provider_id")
        private Integer logisticsProviderId;
        
        @Column(name = "airwaybill_no", length = 50)
        private String airwayBillNumber;
        
        @Column(name = "tracking_id", length = 50)
        private String trackingId;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "expected_delivery_time")
        private LocalDateTime expectedDeliveryTime;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "promised_delivery_time")
        private LocalDateTime promisedDeliveryTime;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "expected_shipping_time")
        private LocalDateTime expectedShippingTime;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "promised_shipping_time")
        private LocalDateTime promisedShippingTime;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "partner_grn_timestamp")
        private LocalDateTime partnerGrnTimestamp;
        
        public LocalDateTime getPartnerGrnTimestamp() {
                return partnerGrnTimestamp;
        }
        public void setPartnerGrnTimestamp(LocalDateTime partnerGrnTimestamp) {
                this.partnerGrnTimestamp = partnerGrnTimestamp;
        }

        @Column(name = "customer_id")
        private Integer retailerId;
        
        @Column(name = "customer_name", length = 50)
        private String retailerName;
        
        @Column(name = "customer_mobilenumber", length = 20)
        private String retailerMobileNumber;
        
        @Column(name = "customer_pincode", length = 10)
        private String retailerPinCode;
        
        @Column(name = "customer_address1", length = 100)
        private String retailerAddress1;
        
        @Column(name = "customer_address2", length = 100)
        private String retailerAddress2;
        
        @Column(name = "customer_city", length = 100)
        private String retailerCity;
        
        @Column(name = "customer_state", length = 100)
        private String retailerState;
        
        @Column(name = "customer_email", length = 50)
        private String retailerEmailId;
        
        @Column(name = "status")
        @Enumerated(EnumType.ORDINAL)
        private OrderStatus status;
        
        @Column(name = "statusDescription", length = 50)
        private String statusDescription;
        
        @Column(name = "total_amount")
        private Float totalAmount;
        
        @Column(name = "gvAmount")
        private Float gvAmount;
        
        @Column(name = "total_weight")
        private Float totalWeight;
        
        @Column(name = "invoice_number", length = 30)
        private String invoiceNumber;
        
        @Column(name = "billed_by", length = 30)
        private String billedBy;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "created_timestamp")
        private LocalDateTime createTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "accepted_timestamp")
        private LocalDateTime acceptedTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "billing_timestamp")
        private LocalDateTime billingTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "shipping_timestamp")
        private LocalDateTime shippingTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "pickup_timestamp")
        private LocalDateTime pickupTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "delivery_timestamp")
        private LocalDateTime deliveryTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "outofstock_timestamp")
        private LocalDateTime outOfStockTimestamp;
        
        @Column(name = "transaction_id")
    private Integer transactionId;
        
        /*@Column(name = "jacket_number", length = 10)
        private Integer jacketNumber;*/
        
        @Column(name = "receiver", length = 50)
        private String receiver;
        
        @Column(name = "batchNo")
        private Integer batchNumber;
        
        @Column(name = "serialNo")
        private Integer serialNumber;
        
        @Column(name = "doaFlag", columnDefinition="tinyInteger(1) default 0")
        private Boolean doaFlag;
        
        @Column(name = "pickupRequestNo")
        private Integer pickupRequestNumber;
        
        @Column(name = "new_order_id")
        private Integer newOrderId;
        
        @Column(name = "doa_auth_timestamp")
        private LocalDateTime doaAuthTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "doa_pickup_timestamp")
        private LocalDateTime doaPickupTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "received_return_timestamp")
        private LocalDateTime receiverReturnTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "reship_timestamp")
        private LocalDateTime reShipTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "refund_timestamp")
        private LocalDateTime refundTimestamp;
        
        @Column(name = "purchase_order_id")
        private Integer purchaseOrderId;
        
        @Column(name = "cod", columnDefinition="tinyInteger(1) default 0")
        private Boolean cod;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "verification_timestamp")
        private LocalDateTime verificationTimestamp;
        
        @Column(name = "refunded_by", length = 30)
        private String refundBy;
        
        @Column(name = "refund_reason", length = 256)
        private String refundReason;
        
        /*@Column(name = "delay_reason")
        private DelayReason delayReason;*/
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "cod_reconciliation_timestamp")
        private LocalDateTime codReconciliationTimestamp;
        
        private Integer previousStatus;
        
        
        @Column(name = "vendorId")
        private Integer vendorId;
        
        @Column(name = "delayReasonText", length = 250)
        private String delayReasonText;
        
        @Column(name = "doa_logistics_provider_id")
        private Integer doaLogisticsProviderId;
        
        @Column(name = "vendor_paid", columnDefinition="tinyInteger(1) default 0")
        private Boolean vendorPaid;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "local_connected_timestamp")
        private LocalDateTime localConnectedTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "reached_destination_timestamp")
        private LocalDateTime reachedDestinationTimestamp;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "first_dlvyatmp_timestamp")
        private LocalDateTime firstDlvyatmpTimestamp;
        
        @Column(name = "originalOrderId")
        private Integer originalOrderId;
        
        @Column(name = "fulfilmentWarehouseId")
        private Integer fulfilmentWarehouseId;
        
        @Column(name = "orderType")
        private Integer orderType;
        
        @Column(name = "pickupStoreId")
        private Integer pickupStoreId;
        
        @Column(name = "otg", columnDefinition="tinyInteger(1) default 0")
        private Boolean otg;
        
        @Convert(converter = LocalDateTimeAttributeConverter.class)
        @Column(name = "courier_delivery_time")
        private LocalDateTime courierDeliveryTimestamp;
        
        
        @Column(name = "insurer")
        private Integer insurer;
        
        @Column(name = "insuranceAmount")
        private Float insuranceAmount;
        
        @Column(name = "freebieItemId")
        private Integer freebieItemId;
        
        @Column(name = "source")
        private Integer source;
        
        @Column(name = "advanceAmount")
        private Float advanceAmount;
        
        @Column(name = "storeId")
        private Integer storeId;
        
        @Column(name = "productCondition")
        private Integer productCondition;
        
        
        @Column(name = "dataProtectionInsurer")
        private Integer dataProtectionInsurer;
        
        @Column(name = "dataProtectionAmount")
        private Integer dataProtectionAmount;
        
        @Column(name = "taxType")
        @Enumerated(EnumType.ORDINAL)
        private TaxType taxType;
        
        @Column(name = "logisticsTransactionId", length = 100)
        private String logisticsTransactionId;
        
        @Column(name = "shippingCost")
        private Float shippingCost;
        
        @Column(name = "codCharges")
        private Float codCharges;
        
        @Column(name = "wallet_amount")
        private Float walletAmount;
        
        @Column(name = "net_payable_amount")
        private Float netPayableAmount;
        
        @Column(name = "shippingRefund")
        private Float shippingRefund;
        
        @ManyToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)
        @JoinColumn(name="id",insertable=false,updatable=false,nullable=false, referencedColumnName="order_id")
        private LineItem lineItem;
        
        public Integer getId() {
                return id;
        }
        public void setId(Integer id) {
                this.id = id;
        }
        public Integer getWarehouseId() {
                return warehouseId;
        }
        public void setWarehouseId(Integer warehouseId) {
                this.warehouseId = warehouseId;
        }
        public Integer getSellerId() {
                return sellerId;
        }
        public void setSellerId(Integer sellerId) {
                this.sellerId = sellerId;
        }
        public Integer getWarehouseAddressId() {
                return warehouseAddressId;
        }
        public void setWarehouseAddressId(Integer warehouseAddressId) {
                this.warehouseAddressId = warehouseAddressId;
        }
        public Integer getLogisticsProviderId() {
                return logisticsProviderId;
        }
        public void setLogisticsProviderId(Integer logisticsProviderId) {
                this.logisticsProviderId = logisticsProviderId;
        }
        public String getAirwayBillNumber() {
                return airwayBillNumber;
        }
        public void setAirwayBillNumber(String airwayBillNumber) {
                this.airwayBillNumber = airwayBillNumber;
        }
        public String getTrackingId() {
                return trackingId;
        }
        public void setTrackingId(String trackingId) {
                this.trackingId = trackingId;
        }
        public LocalDateTime getExpectedDeliveryTime() {
                return expectedDeliveryTime;
        }
        public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {
                this.expectedDeliveryTime = expectedDeliveryTime;
        }
        public LocalDateTime getPromisedDeliveryTime() {
                return promisedDeliveryTime;
        }
        public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {
                this.promisedDeliveryTime = promisedDeliveryTime;
        }
        public LocalDateTime getExpectedShippingTime() {
                return expectedShippingTime;
        }
        public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {
                this.expectedShippingTime = expectedShippingTime;
        }
        public LocalDateTime getPromisedShippingTime() {
                return promisedShippingTime;
        }
        public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {
                this.promisedShippingTime = promisedShippingTime;
        }
        public Integer getRetailerId() {
                return retailerId;
        }
        public void setRetailerId(Integer retailerId) {
                this.retailerId = retailerId;
        }
        public String getRetailerName() {
                return retailerName;
        }
        public void setRetailerName(String retailerName) {
                this.retailerName = retailerName;
        }
        public String getRetailerMobileNumber() {
                return retailerMobileNumber;
        }
        public void setRetailerMobileNumber(String retailerMobileNumber) {
                this.retailerMobileNumber = retailerMobileNumber;
        }
        public String getRetailerPinCode() {
                return retailerPinCode;
        }
        public void setRetailerPinCode(String retailerPinCode) {
                this.retailerPinCode = retailerPinCode;
        }
        public String getRetailerAddress1() {
                return retailerAddress1;
        }
        public void setRetailerAddress1(String retailerAddress1) {
                this.retailerAddress1 = retailerAddress1;
        }
        public String getRetailerAddress2() {
                return retailerAddress2;
        }
        public void setRetailerAddress2(String retailerAddress2) {
                this.retailerAddress2 = retailerAddress2;
        }
        public String getRetailerCity() {
                return retailerCity;
        }
        public void setRetailerCity(String retailerCity) {
                this.retailerCity = retailerCity;
        }
        public String getRetailerState() {
                return retailerState;
        }
        public void setRetailerState(String retailerState) {
                this.retailerState = retailerState;
        }
        public String getRetailerEmailId() {
                return retailerEmailId;
        }
        public void setRetailerEmailId(String retailerEmailId) {
                this.retailerEmailId = retailerEmailId;
        }
        public OrderStatus getStatus() {
                return status;
        }
        public void setStatus(OrderStatus status) {
                this.status = status;
        }
        public String getStatusDescription() {
                return statusDescription;
        }
        public void setStatusDescription(String statusDescription) {
                this.statusDescription = statusDescription;
        }
        public Float getTotalAmount() {
                return totalAmount;
        }
        public void setTotalAmount(Float totalAmount) {
                this.totalAmount = totalAmount;
        }
        public Float getGvAmount() {
                return gvAmount;
        }
        public void setGvAmount(Float gvAmount) {
                this.gvAmount = gvAmount;
        }
        public Float getTotalWeight() {
                return totalWeight;
        }
        public void setTotalWeight(Float totalWeight) {
                this.totalWeight = totalWeight;
        }
        public String getInvoiceNumber() {
                return invoiceNumber;
        }
        public void setInvoiceNumber(String invoiceNumber) {
                this.invoiceNumber = invoiceNumber;
        }
        public String getBilledBy() {
                return billedBy;
        }
        public void setBilledBy(String billedBy) {
                this.billedBy = billedBy;
        }
        public LocalDateTime getCreateTimestamp() {
                return createTimestamp;
        }
        public void setCreateTimestamp(LocalDateTime createTimestamp) {
                this.createTimestamp = createTimestamp;
        }
        public LocalDateTime getAcceptedTimestamp() {
                return acceptedTimestamp;
        }
        public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {
                this.acceptedTimestamp = acceptedTimestamp;
        }
        public LocalDateTime getBillingTimestamp() {
                return billingTimestamp;
        }
        public void setBillingTimestamp(LocalDateTime billingTimestamp) {
                this.billingTimestamp = billingTimestamp;
        }
        public LocalDateTime getShippingTimestamp() {
                return shippingTimestamp;
        }
        public void setShippingTimestamp(LocalDateTime shippingTimestamp) {
                this.shippingTimestamp = shippingTimestamp;
        }
        public LocalDateTime getPickupTimestamp() {
                return pickupTimestamp;
        }
        public void setPickupTimestamp(LocalDateTime pickupTimestamp) {
                this.pickupTimestamp = pickupTimestamp;
        }
        public LocalDateTime getDeliveryTimestamp() {
                return deliveryTimestamp;
        }
        public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {
                this.deliveryTimestamp = deliveryTimestamp;
        }
        public LocalDateTime getOutOfStockTimestamp() {
                return outOfStockTimestamp;
        }
        public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {
                this.outOfStockTimestamp = outOfStockTimestamp;
        }
        public Integer getTransactionId() {
                return transactionId;
        }
        public void setTransactionId(Integer transactionId) {
                this.transactionId = transactionId;
        }
        
        /*public Integer getJacketNumber() {
                return jacketNumber;
        }
        public void setJacketNumber(Integer jacketNumber) {
                this.jacketNumber = jacketNumber;
        }*/
        public String getReceiver() {
                return receiver;
        }
        public void setReceiver(String receiver) {
                this.receiver = receiver;
        }
        public Integer getBatchNumber() {
                return batchNumber;
        }
        public void setBatchNumber(Integer batchNumber) {
                this.batchNumber = batchNumber;
        }
        public Integer getSerialNumber() {
                return serialNumber;
        }
        public void setSerialNumber(Integer serialNumber) {
                this.serialNumber = serialNumber;
        }
        public Boolean isDoaFlag() {
                return doaFlag;
        }
        public void setDoaFlag(Boolean doaFlag) {
                this.doaFlag = doaFlag;
        }
        public Integer getPickupRequestNumber() {
                return pickupRequestNumber;
        }
        public void setPickupRequestNumber(Integer pickupRequestNumber) {
                this.pickupRequestNumber = pickupRequestNumber;
        }
        public Integer getNewOrderId() {
                return newOrderId;
        }
        public void setNewOrderId(Integer newOrderId) {
                this.newOrderId = newOrderId;
        }
        public LocalDateTime getDoaAuthTimestamp() {
                return doaAuthTimestamp;
        }
        public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {
                this.doaAuthTimestamp = doaAuthTimestamp;
        }
        public LocalDateTime getDoaPickupTimestamp() {
                return doaPickupTimestamp;
        }
        public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {
                this.doaPickupTimestamp = doaPickupTimestamp;
        }
        public LocalDateTime getReceiverReturnTimestamp() {
                return receiverReturnTimestamp;
        }
        public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {
                this.receiverReturnTimestamp = receiverReturnTimestamp;
        }
        public LocalDateTime getReShipTimestamp() {
                return reShipTimestamp;
        }
        public void setReShipTimestamp(LocalDateTime reShipTimestamp) {
                this.reShipTimestamp = reShipTimestamp;
        }
        public LocalDateTime getRefundTimestamp() {
                return refundTimestamp;
        }
        public void setRefundTimestamp(LocalDateTime refundTimestamp) {
                this.refundTimestamp = refundTimestamp;
        }
        public Integer getPurchaseOrderId() {
                return purchaseOrderId;
        }
        public void setPurchaseOrderId(Integer purchaseOrderId) {
                this.purchaseOrderId = purchaseOrderId;
        }
        public Boolean isCod() {
                return cod;
        }
        public void setCod(Boolean cod) {
                this.cod = cod;
        }
        public LocalDateTime getVerificationTimestamp() {
                return verificationTimestamp;
        }
        public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {
                this.verificationTimestamp = verificationTimestamp;
        }
        public String getRefundBy() {
                return refundBy;
        }
        public void setRefundBy(String refundBy) {
                this.refundBy = refundBy;
        }
        public String getRefundReason() {
                return refundReason;
        }
        public void setRefundReason(String refundReason) {
                this.refundReason = refundReason;
        }
        /*public DelayReason getDelayReason() {
                return delayReason;
        }
        public void setDelayReason(DelayReason delayReason) {
                this.delayReason = delayReason;
        }*/
        public LocalDateTime getCodReconciliationTimestamp() {
                return codReconciliationTimestamp;
        }
        public void setCodReconciliationTimestamp(LocalDateTime codReconciliationTimestamp) {
                this.codReconciliationTimestamp = codReconciliationTimestamp;
        }
        public Integer getPreviousStatus() {
                return previousStatus;
        }
        public void setPreviousStatus(Integer previousStatus) {
                this.previousStatus = previousStatus;
        }
        public Integer getVendorId() {
                return vendorId;
        }
        public void setVendorId(Integer vendorId) {
                this.vendorId = vendorId;
        }
        public String getDelayReasonText() {
                return delayReasonText;
        }
        public void setDelayReasonText(String delayReasonText) {
                this.delayReasonText = delayReasonText;
        }
        public Integer getDoaLogisticsProviderId() {
                return doaLogisticsProviderId;
        }
        public void setDoaLogisticsProviderId(Integer doaLogisticsProviderId) {
                this.doaLogisticsProviderId = doaLogisticsProviderId;
        }
        public Boolean isVendorPaid() {
                return vendorPaid;
        }
        public void setVendorPaid(Boolean vendorPaid) {
                this.vendorPaid = vendorPaid;
        }
        public LocalDateTime getLocalConnectedTimestamp() {
                return localConnectedTimestamp;
        }
        public void setLocalConnectedTimestamp(LocalDateTime localConnectedTimestamp) {
                this.localConnectedTimestamp = localConnectedTimestamp;
        }
        public LocalDateTime getReachedDestinationTimestamp() {
                return reachedDestinationTimestamp;
        }
        public void setReachedDestinationTimestamp(LocalDateTime reachedDestinationTimestamp) {
                this.reachedDestinationTimestamp = reachedDestinationTimestamp;
        }
        public LocalDateTime getFirstDlvyatmpTimestamp() {
                return firstDlvyatmpTimestamp;
        }
        public void setFirstDlvyatmpTimestamp(LocalDateTime firstDlvyatmpTimestamp) {
                this.firstDlvyatmpTimestamp = firstDlvyatmpTimestamp;
        }
        public Integer getOriginalOrderId() {
                return originalOrderId;
        }
        public void setOriginalOrderId(Integer originalOrderId) {
                this.originalOrderId = originalOrderId;
        }
        public Integer getFulfilmentWarehouseId() {
                return fulfilmentWarehouseId;
        }
        public void setFulfilmentWarehouseId(Integer fulfilmentWarehouseId) {
                this.fulfilmentWarehouseId = fulfilmentWarehouseId;
        }
        public Integer getOrderType() {
                return orderType;
        }
        public void setOrderType(Integer orderType) {
                this.orderType = orderType;
        }
        public Integer getPickupStoreId() {
                return pickupStoreId;
        }
        public void setPickupStoreId(Integer pickupStoreId) {
                this.pickupStoreId = pickupStoreId;
        }
        public Boolean isOtg() {
                return otg;
        }
        public void setOtg(Boolean otg) {
                this.otg = otg;
        }
        public LocalDateTime getCourierDeliveryTimestamp() {
                return courierDeliveryTimestamp;
        }
        public void setCourierDeliveryTimestamp(LocalDateTime courierDeliveryTimestamp) {
                this.courierDeliveryTimestamp = courierDeliveryTimestamp;
        }
        public Integer getInsurer() {
                return insurer;
        }
        public void setInsurer(Integer insurer) {
                this.insurer = insurer;
        }
        public Float getInsuranceAmount() {
                return insuranceAmount;
        }
        public void setInsuranceAmount(Float insuranceAmount) {
                this.insuranceAmount = insuranceAmount;
        }
        public Integer getFreebieItemId() {
                return freebieItemId;
        }
        public void setFreebieItemId(Integer freebieItemId) {
                this.freebieItemId = freebieItemId;
        }
        public Integer getSource() {
                return source;
        }
        public void setSource(Integer source) {
                this.source = source;
        }
        public Float getAdvanceAmount() {
                return advanceAmount;
        }
        public void setAdvanceAmount(Float advanceAmount) {
                this.advanceAmount = advanceAmount;
        }
        public Integer getStoreId() {
                return storeId;
        }
        public void setStoreId(Integer storeId) {
                this.storeId = storeId;
        }
        public Integer getProductCondition() {
                return productCondition;
        }
        public void setProductCondition(Integer productCondition) {
                this.productCondition = productCondition;
        }
        public Integer getDataProtectionInsurer() {
                return dataProtectionInsurer;
        }
        public void setDataProtectionInsurer(Integer dataProtectionInsurer) {
                this.dataProtectionInsurer = dataProtectionInsurer;
        }
        public Integer getDataProtectionAmount() {
                return dataProtectionAmount;
        }
        public void setDataProtectionAmount(Integer dataProtectionAmount) {
                this.dataProtectionAmount = dataProtectionAmount;
        }
        public TaxType getTaxType() {
                return taxType;
        }
        public void setTaxType(TaxType taxType) {
                this.taxType = taxType;
        }
        public String getLogisticsTransactionId() {
                return logisticsTransactionId;
        }
        public void setLogisticsTransactionId(String logisticsTransactionId) {
                this.logisticsTransactionId = logisticsTransactionId;
        }
        public Float getShippingCost() {
                return shippingCost;
        }
        public void setShippingCost(Float shippingCost) {
                this.shippingCost = shippingCost;
        }
        public Float getCodCharges() {
                return codCharges;
        }
        public void setCodCharges(Float codCharges) {
                this.codCharges = codCharges;
        }
        public Float getWalletAmount() {
                return walletAmount;
        }
        public void setWalletAmount(Float walletAmount) {
                this.walletAmount = walletAmount;
        }
        public Float getNetPayableAmount() {
                return netPayableAmount;
        }
        public void setNetPayableAmount(Float netPayableAmount) {
                this.netPayableAmount = netPayableAmount;
        }
        public Float getShippingRefund() {
                return shippingRefund;
        }
        public void setShippingRefund(Float shippingRefund) {
                this.shippingRefund = shippingRefund;
        }
        
        public LineItem getLineItem() {
                return lineItem;
        }
        public void setLineItem(LineItem lineItem) {
                this.lineItem = lineItem;
        }
        
        public String getFormattedDate(){
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-YYYY HH:mm");
                return this.createTimestamp.format(formatter);
    }
        
        
        @Override
        public int hashCode() {
                final int prime = 31;
                int result = 1;
                result = prime * result + ((id == null) ? 0 : id.hashCode());
                return result;
        }
        @Override
        public boolean equals(Object obj) {
                if (this == obj)
                        return true;
                if (obj == null)
                        return false;
                if (getClass() != obj.getClass())
                        return false;
                Order other = (Order) obj;
                if (id == null) {
                        if (other.id != null)
                                return false;
                } else if (!id.equals(other.id))
                        return false;
                return true;
        }
        @Override
        public String toString() {
                return "Order [id=" + id + ", warehouseId=" + warehouseId + ", sellerId=" + sellerId + ", warehouseAddressId="
                                + warehouseAddressId + ", logisticsProviderId=" + logisticsProviderId + ", airwayBillNumber="
                                + airwayBillNumber + ", trackingId=" + trackingId + ", expectedDeliveryTime=" + expectedDeliveryTime
                                + ", promisedDeliveryTime=" + promisedDeliveryTime + ", expectedShippingTime=" + expectedShippingTime
                                + ", promisedShippingTime=" + promisedShippingTime + ", partnerPurchaseTimestamp="
                                + partnerGrnTimestamp + ", 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
                                + ", transactionId=" + transactionId + ", 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 + ", 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 + ", lineItem=" + lineItem + "]";
        }
    
}