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

                @NamedQuery(name = "Order.selectAllBilledOrderGroupByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderBillingModel(li.brand, "
                                + "sum(case when o.billingTimestamp >= :today then CAST(o.totalAmount  AS int) else 0 end),"
                                + "sum(case when o.billingTimestamp >= :threedays  and o.billingTimestamp < :endDate  then CAST(o.totalAmount  AS int) else 0 end),"
                                + "sum(case when concat(year(o.billingTimestamp ), month(o.billingTimestamp ))= :mtd  then CAST(o.totalAmount AS int) else 0 end),"
                                + "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(o.totalAmount  AS int) else 0 end),"
                                + "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmsEndDate  then CAST(o.totalAmount  AS int) else 0 end),"
                                + "     sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"
                                + "     sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"
                                + " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd  then li.quantity else 0 end),"
                                + "     sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end),"
                                + "     sum(case when o.billingTimestamp between  :lmtdStartDate and :lmsEndDate  then li.quantity else 0 end)"
                                + " )"
                                + "      from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"
                                + "     and o.billingTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId and fs.internal = 0 group by li.brand"),

                @NamedQuery(name = "Order.selectAllBilledOrderGroupByBrandWarehouse", query = "select new com.spice.profitmandi.dao.model.SecondaryWarehouseWiseOrderBilllingModel(fs.warehouseId,date(o.billingTimestamp), li.brand, "
                                + "sum(CAST(o.totalAmount  AS int)),sum( li.quantity))"
                                + "      from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"
                                + "     and o.billingTimestamp >= :startDate and  o.billingTimestamp < :endDate and (null is :brand or li.brand = :brand) and fs.internal = 0 group by fs.warehouseId, date(o.billingTimestamp), li.brand"),

                @NamedQuery(name = "Order.selectAllBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "
                                + " i.modelNumber, i.color," + "o.totalAmount," + "      li.quantity)"
                                + "      from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"
                                + "     and date(o.billingTimestamp) in :date and fs.warehouseId in :warehouseId and li.brand = :brand and fs.internal = 0 order by li.itemId desc"),

                @NamedQuery(name = "Order.selectTodayBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "
                                + " i.modelNumber, i.color," + "o.totalAmount," + "      li.quantity)"
                                + "      from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"
                                + "     and o.billingTimestamp >= :startDate and fs.warehouseId in :warehouseId and li.brand in :brand order by li.itemId desc"),

                @NamedQuery(name = "Order.selectAllBilledOrderBrandByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockBrandModel(li.brand,"
                                + "      Sum(li.quantity),Sum(CAST(o.totalAmount As int)))"
                                + "      from Order o join LineItem li on o.id = li.orderId where o.status in (7,9,10,12)"
                                + "     and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate and o.retailerId = :fofoId group by li.brand"),

                @NamedQuery(name = "Order.selectAllBilledOrderBrandItemByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockBrandItemModel("
                                + " i.brand, i.modelName, i.modelNumber, i.color,Sum(li.quantity), Sum(CAST(o.totalAmount As int)))"
                                + "      from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where o.status in (7,9,10,12)"
                                + "     and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate and o.retailerId = :fofoId  group by i.id"),

                @NamedQuery(name = "Order.selectAllGrnPendingOrderByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdQtyModel("
                                + "  fs.warehouseId,fs.id,sum(li.quantity )) from FofoStore fs join  Order o on fs.id = o.retailerId "
                                + "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
                                + "  join Item i on (i.id = tl.itemId ) where " + "      fs.active = 1 and fs.internal = 0 and"
                                + "  o.billingTimestamp is not null and o.refundTimestamp is null and o.deliveryTimestamp is null"
                                + "  and i.catalogItemId in :catalogItemId group by fs.id"),

                @NamedQuery(name = "Order.selectAllPendingIndentOrderByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdQtyModel("
                                + "  fs.warehouseId,fs.id,sum(case when li.quantity is null then 0 else  li.quantity end))"
                                + "      from FofoStore fs  join  Order o on fs.id = o.retailerId"
                                + "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
                                + "  join Item i on i.id = tl.itemId  where "
                                + "      fs.active = 1 and fs.internal = 0 and o.status in (3,4) and i.catalogItemId in :catalogItemId group by fs.id"),

                @NamedQuery(name = "Order.selectAllGrnPendingOrderByRange", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
                                + "  fs.warehouseId,fs.id,sum(li.quantity ),i.brand,i.modelName,i.modelNumber,i.catalogItemId) from FofoStore fs join  Order o on fs.id = o.retailerId "
                                + "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
                                + "  join Item i on (i.id = tl.itemId ) where " + "      fs.active = 1 and fs.internal = 0 and"
                                + "  o.billingTimestamp is not null and o.refundTimestamp is null and o.deliveryTimestamp is null"
                                + "  and tl.mop between :startPrice and :endPrice and i.categoryId=10006 group by fs.id,i.catalogItemId,i.brand,i.modelName,i.modelNumber"),

                @NamedQuery(name = "Order.selectAllPendingIndentOrderByRange", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
                                + "  fs.warehouseId, fs.id,sum(case when li.quantity is null then 0 else  li.quantity end),i.brand,i.modelName,i.modelNumber,i.catalogItemId)"
                                + "      from FofoStore fs  join  Order o on fs.id = o.retailerId"
                                + "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
                                + "  join Item i on i.id = tl.itemId  where "
                                + "      fs.active = 1 and fs.internal = 0 and o.status in (3,4) and tl.mop between :startPrice and :endPrice  and i.categoryId=10006 group by fs.id,i.catalogItemId,i.brand,i.modelName,i.modelNumber"),

                @NamedQuery(name = "Order.selectAllGrnPendingOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
                                + "  fs.warehouseId, fs.id, sum(li.quantity), i.brand, i.modelName, i.modelNumber, i.catalogItemId) from FofoStore fs join  Order o on fs.id = o.retailerId "
                                + "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
                                + "  join Item i on (i.id = tl.itemId ) where " + "      fs.active = 1 and fs.internal = 0 and"
                                + "  o.billingTimestamp is not null and o.refundTimestamp is null and o.deliveryTimestamp is null"
                                + "  and i.catalogItemId in :catalogItemId and  i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),

                @NamedQuery(name = "Order.selectAllPendingIndentOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
                                + "   fs.warehouseId, fs.id, sum(li.quantity), i.brand, i.modelName, i.modelNumber, i.catalogItemId)"
                                + "      from FofoStore fs  join  Order o on fs.id = o.retailerId"
                                + "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
                                + "  join Item i on i.id = tl.itemId  where "
                                + "      fs.active = 1 and fs.internal = 0 and o.status in (3,4) and i.catalogItemId in :catalogItemId and  i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),

})
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.EAGER)
        @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 + "]";
        }

}