Rev 21820 | Rev 21984 | Go to most recent revision | View as "text/plain" | Blame | Compare with Previous | Last modification | View Log | RSS feed
package com.spice.profitmandi.dao.entity.transaction;import java.io.Serializable;import java.time.LocalDateTime;import javax.persistence.CascadeType;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.EnumType;import javax.persistence.Enumerated;import javax.persistence.FetchType;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.NamedQueries;import javax.persistence.NamedQuery;import javax.persistence.OneToOne;import javax.persistence.Table;import in.shop2020.model.v1.order.DelayReason;import in.shop2020.model.v1.order.OrderStatus;import in.shop2020.model.v1.order.TaxType;/*** This class basically contains order details** @author ashikali**/@Entity@Table(name="transaction.`order`", schema = "transaction")@NamedQueries({@NamedQuery(name="Order.selectAll",query="select o from Order o"),@NamedQuery(name="Order.selectById",query="select o from Order o where o.id= :id"),@NamedQuery(name = "Order.selectCountByTransactionId", query = "select count(o) from Order o where o.transactionId = :transactionId"),@NamedQuery(name = "Order.selectByTransactionId",query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name, o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status from Transaction t join Order o on o.transactionId = t.id "+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId where o.transactionId = :transactionId"),@NamedQuery(name = "Order.selectByAirwayBillOrInvoiceNumberRetailerId",query = "select li.itemId, li.brand, li.modelName, li.modelNumber, li.color, li.quantity, li.unitPrice, i.type, sum(li.quantity), o.invoiceNumber from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where (o.airwayBillNumber = :airwayBillOrInvoiceNumber or o.invoiceNumber = :airwayBillOrInvoiceNumber) and o.retailerId = :retailerId group by li.itemId"),@NamedQuery(name = "Order.selectSerialNumbersByItemIdInvoiceNumberRetailerId",query = "select li.serialNumber from Order o join LineItem li on li.orderId = o.id where o.retailerId = :retailerId and o.invoiceNumber = :invoiceNumber and li.itemId = :itemId"),@NamedQuery(name = "Order.selectItemIdTypeQuantity",query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId")})public class Order implements Serializable{private static final long serialVersionUID = 1L;public Order() {}@Id@Column(name="id", unique=true, updatable=false)@GeneratedValue(strategy = GenerationType.IDENTITY)private Integer id;@Column(name = "warehouse_id")private Integer warehouseId;@Column(name = "seller_id")private Integer sellerId;@Column(name = "warehouse_address_id")private Integer warehouseAddressId;@Column(name = "logistics_provider_id")private Integer logisticsProviderId;@Column(name = "airwaybill_no", length = 50)private String airwayBillNumber;@Column(name = "tracking_id", length = 50)private String trackingId;@Column(name = "expected_delivery_time")private LocalDateTime expectedDeliveryTime;@Column(name = "promised_delivery_time")private LocalDateTime promisedDeliveryTime;@Column(name = "expected_shipping_time")private LocalDateTime expectedShippingTime;@Column(name = "promised_shipping_time")private LocalDateTime promisedShippingTime;@Column(name = "customer_id")private Integer retailerId;@Column(name = "customer_name", length = 50)private String retailerName;@Column(name = "customer_mobilenumber", length = 20)private String retailerMobileNumber;@Column(name = "customer_pincode", length = 10)private String retailerPinCode;@Column(name = "customer_address1", length = 100)private String retailerAddress1;@Column(name = "customer_address2", length = 100)private String retailerAddress2;@Column(name = "customer_city", length = 100)private String retailerCity;@Column(name = "customer_state", length = 100)private String retailerState;@Column(name = "customer_email", length = 50)private String retailerEmailId;@Column(name = "status")@Enumerated(EnumType.ORDINAL)private OrderStatus status;@Column(name = "statusDescription", length = 50)private String statusDescription;@Column(name = "total_amount")private Float totalAmount;@Column(name = "gvAmount")private Float gvAmount;@Column(name = "total_weight")private Float totalWeight;@Column(name = "invoice_number", length = 30)private String invoiceNumber;@Column(name = "billed_by", length = 30)private String billedBy;@Column(name = "created_timestamp")private LocalDateTime createTimestamp;@Column(name = "accepted_timestamp")private LocalDateTime acceptedTimestamp;@Column(name = "billing_timestamp")private LocalDateTime billingTimestamp;@Column(name = "shipping_timestamp")private LocalDateTime shippingTimestamp;@Column(name = "pickup_timestamp")private LocalDateTime pickupTimestamp;@Column(name = "delivery_timestamp")private LocalDateTime deliveryTimestamp;@Column(name = "outofstock_timestamp")private LocalDateTime outOfStockTimestamp;@Column(name = "transaction_id")private Integer transactionId;@Column(name = "jacket_number", length = 10)private Integer jacketNumber;@Column(name = "receiver", length = 50)private String receiver;@Column(name = "batchNo")private Integer batchNumber;@Column(name = "serialNo")private Integer serialNumber;@Column(name = "doaFlag", columnDefinition="tinyInteger(1) default 0")private Boolean doaFlag;@Column(name = "pickupRequestNo")private Integer pickupRequestNumber;@Column(name = "new_order_id")private Integer newOrderId;@Column(name = "doa_auth_timestamp")private LocalDateTime doaAuthTimestamp;@Column(name = "doa_pickup_timestamp")private LocalDateTime doaPickupTimestamp;@Column(name = "received_return_timestamp")private LocalDateTime receiverReturnTimestamp;@Column(name = "reship_timestamp")private LocalDateTime reShipTimestamp;@Column(name = "refund_timestamp")private LocalDateTime refundTimestamp;@Column(name = "purchase_order_id")private Integer purchaseOrderId;@Column(name = "cod", columnDefinition="tinyInteger(1) default 0")private Boolean cod;@Column(name = "verification_timestamp")private LocalDateTime verificationTimestamp;@Column(name = "refunded_by", length = 30)private String refundBy;@Column(name = "refund_reason", length = 256)private String refundReason;@Column(name = "delay_reason")private DelayReason delayReason;@Column(name = "cod_reconciliation_timestamp")private LocalDateTime codReconciliationTimestamp;private Integer previousStatus;@Column(name = "vendorId")private Integer vendorId;@Column(name = "delayReasonText", length = 250)private String delayReasonText;@Column(name = "doa_logistics_provider_id")private Integer doaLogisticsProviderId;@Column(name = "vendor_paid", columnDefinition="tinyInteger(1) default 0")private Boolean vendorPaid;@Column(name = "local_connected_timestamp")private LocalDateTime localConnectedTimestamp;@Column(name = "reached_destination_timestamp")private LocalDateTime reachedDestinationTimestamp;@Column(name = "first_dlvyatmp_timestamp")private LocalDateTime firstDlvyatmpTimestamp;@Column(name = "originalOrderId")private Integer originalOrderId;@Column(name = "fulfilmentWarehouseId")private Integer fulfilmentWarehouseId;@Column(name = "orderType")private Integer orderType;@Column(name = "pickupStoreId")private Integer pickupStoreId;@Column(name = "otg", columnDefinition="tinyInteger(1) default 0")private Boolean otg;@Column(name = "courier_delivery_time")private LocalDateTime courierDeliveryTimestamp;@Column(name = "insurer")private Integer insurer;@Column(name = "insuranceAmount")private Float insuranceAmount;@Column(name = "freebieItemId")private Integer freebieItemId;@Column(name = "source")private Integer source;@Column(name = "advanceAmount")private Float advanceAmount;@Column(name = "storeId")private Integer storeId;@Column(name = "productCondition")private Integer productCondition;@Column(name = "dataProtectionInsurer")private Integer dataProtectionInsurer;@Column(name = "dataProtectionAmount")private Integer dataProtectionAmount;@Column(name = "taxType")@Enumerated(EnumType.ORDINAL)private TaxType taxType;@Column(name = "logisticsTransactionId", length = 100)private String logisticsTransactionId;@Column(name = "shippingCost")private Float shippingCost;@Column(name = "codCharges")private Float codCharges;@Column(name = "wallet_amount")private Float walletAmount;@Column(name = "net_payable_amount")private Float netPayableAmount;@Column(name = "shippingRefund")private Float shippingRefund;@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)@JoinColumn(name="id",insertable=false,updatable=false,nullable=false, referencedColumnName="order_id")private LineItem lineItem;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public Integer getWarehouseId() {return warehouseId;}public void setWarehouseId(Integer warehouseId) {this.warehouseId = warehouseId;}public Integer getSellerId() {return sellerId;}public void setSellerId(Integer sellerId) {this.sellerId = sellerId;}public Integer getWarehouseAddressId() {return warehouseAddressId;}public void setWarehouseAddressId(Integer warehouseAddressId) {this.warehouseAddressId = warehouseAddressId;}public Integer getLogisticsProviderId() {return logisticsProviderId;}public void setLogisticsProviderId(Integer logisticsProviderId) {this.logisticsProviderId = logisticsProviderId;}public String getAirwayBillNumber() {return airwayBillNumber;}public void setAirwayBillNumber(String airwayBillNumber) {this.airwayBillNumber = airwayBillNumber;}public String getTrackingId() {return trackingId;}public void setTrackingId(String trackingId) {this.trackingId = trackingId;}public LocalDateTime getExpectedDeliveryTime() {return expectedDeliveryTime;}public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {this.expectedDeliveryTime = expectedDeliveryTime;}public LocalDateTime getPromisedDeliveryTime() {return promisedDeliveryTime;}public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {this.promisedDeliveryTime = promisedDeliveryTime;}public LocalDateTime getExpectedShippingTime() {return expectedShippingTime;}public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {this.expectedShippingTime = expectedShippingTime;}public LocalDateTime getPromisedShippingTime() {return promisedShippingTime;}public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {this.promisedShippingTime = promisedShippingTime;}public Integer getRetailerId() {return retailerId;}public void setRetailerId(Integer retailerId) {this.retailerId = retailerId;}public String getRetailerName() {return retailerName;}public void setRetailerName(String retailerName) {this.retailerName = retailerName;}public String getRetailerMobileNumber() {return retailerMobileNumber;}public void setRetailerMobileNumber(String retailerMobileNumber) {this.retailerMobileNumber = retailerMobileNumber;}public String getRetailerPinCode() {return retailerPinCode;}public void setRetailerPinCode(String retailerPinCode) {this.retailerPinCode = retailerPinCode;}public String getRetailerAddress1() {return retailerAddress1;}public void setRetailerAddress1(String retailerAddress1) {this.retailerAddress1 = retailerAddress1;}public String getRetailerAddress2() {return retailerAddress2;}public void setRetailerAddress2(String retailerAddress2) {this.retailerAddress2 = retailerAddress2;}public String getRetailerCity() {return retailerCity;}public void setRetailerCity(String retailerCity) {this.retailerCity = retailerCity;}public String getRetailerState() {return retailerState;}public void setRetailerState(String retailerState) {this.retailerState = retailerState;}public String getRetailerEmailId() {return retailerEmailId;}public void setRetailerEmailId(String retailerEmailId) {this.retailerEmailId = retailerEmailId;}public OrderStatus getStatus() {return status;}public void setStatus(OrderStatus status) {this.status = status;}public String getStatusDescription() {return statusDescription;}public void setStatusDescription(String statusDescription) {this.statusDescription = statusDescription;}public Float getTotalAmount() {return totalAmount;}public void setTotalAmount(Float totalAmount) {this.totalAmount = totalAmount;}public Float getGvAmount() {return gvAmount;}public void setGvAmount(Float gvAmount) {this.gvAmount = gvAmount;}public Float getTotalWeight() {return totalWeight;}public void setTotalWeight(Float totalWeight) {this.totalWeight = totalWeight;}public String getInvoiceNumber() {return invoiceNumber;}public void setInvoiceNumber(String invoiceNumber) {this.invoiceNumber = invoiceNumber;}public String getBilledBy() {return billedBy;}public void setBilledBy(String billedBy) {this.billedBy = billedBy;}public LocalDateTime getCreateTimestamp() {return createTimestamp;}public void setCreateTimestamp(LocalDateTime createTimestamp) {this.createTimestamp = createTimestamp;}public LocalDateTime getAcceptedTimestamp() {return acceptedTimestamp;}public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {this.acceptedTimestamp = acceptedTimestamp;}public LocalDateTime getBillingTimestamp() {return billingTimestamp;}public void setBillingTimestamp(LocalDateTime billingTimestamp) {this.billingTimestamp = billingTimestamp;}public LocalDateTime getShippingTimestamp() {return shippingTimestamp;}public void setShippingTimestamp(LocalDateTime shippingTimestamp) {this.shippingTimestamp = shippingTimestamp;}public LocalDateTime getPickupTimestamp() {return pickupTimestamp;}public void setPickupTimestamp(LocalDateTime pickupTimestamp) {this.pickupTimestamp = pickupTimestamp;}public LocalDateTime getDeliveryTimestamp() {return deliveryTimestamp;}public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {this.deliveryTimestamp = deliveryTimestamp;}public LocalDateTime getOutOfStockTimestamp() {return outOfStockTimestamp;}public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {this.outOfStockTimestamp = outOfStockTimestamp;}public Integer getTransactionId() {return transactionId;}public void setTransactionId(Integer transactionId) {this.transactionId = transactionId;}public Integer getJacketNumber() {return jacketNumber;}public void setJacketNumber(Integer jacketNumber) {this.jacketNumber = jacketNumber;}public String getReceiver() {return receiver;}public void setReceiver(String receiver) {this.receiver = receiver;}public Integer getBatchNumber() {return batchNumber;}public void setBatchNumber(Integer batchNumber) {this.batchNumber = batchNumber;}public Integer getSerialNumber() {return serialNumber;}public void setSerialNumber(Integer serialNumber) {this.serialNumber = serialNumber;}public Boolean isDoaFlag() {return doaFlag;}public void setDoaFlag(Boolean doaFlag) {this.doaFlag = doaFlag;}public Integer getPickupRequestNumber() {return pickupRequestNumber;}public void setPickupRequestNumber(Integer pickupRequestNumber) {this.pickupRequestNumber = pickupRequestNumber;}public Integer getNewOrderId() {return newOrderId;}public void setNewOrderId(Integer newOrderId) {this.newOrderId = newOrderId;}public LocalDateTime getDoaAuthTimestamp() {return doaAuthTimestamp;}public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {this.doaAuthTimestamp = doaAuthTimestamp;}public LocalDateTime getDoaPickupTimestamp() {return doaPickupTimestamp;}public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {this.doaPickupTimestamp = doaPickupTimestamp;}public LocalDateTime getReceiverReturnTimestamp() {return receiverReturnTimestamp;}public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {this.receiverReturnTimestamp = receiverReturnTimestamp;}public LocalDateTime getReShipTimestamp() {return reShipTimestamp;}public void setReShipTimestamp(LocalDateTime reShipTimestamp) {this.reShipTimestamp = reShipTimestamp;}public LocalDateTime getRefundTimestamp() {return refundTimestamp;}public void setRefundTimestamp(LocalDateTime refundTimestamp) {this.refundTimestamp = refundTimestamp;}public Integer getPurchaseOrderId() {return purchaseOrderId;}public void setPurchaseOrderId(Integer purchaseOrderId) {this.purchaseOrderId = purchaseOrderId;}public Boolean isCod() {return cod;}public void setCod(Boolean cod) {this.cod = cod;}public LocalDateTime getVerificationTimestamp() {return verificationTimestamp;}public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {this.verificationTimestamp = verificationTimestamp;}public String getRefundBy() {return refundBy;}public void setRefundBy(String refundBy) {this.refundBy = refundBy;}public String getRefundReason() {return refundReason;}public void setRefundReason(String refundReason) {this.refundReason = refundReason;}public DelayReason getDelayReason() {return delayReason;}public void setDelayReason(DelayReason delayReason) {this.delayReason = delayReason;}public LocalDateTime getCodReconciliationTimestamp() {return codReconciliationTimestamp;}public void setCodReconciliationTimestamp(LocalDateTime codReconciliationTimestamp) {this.codReconciliationTimestamp = codReconciliationTimestamp;}public Integer getPreviousStatus() {return previousStatus;}public void setPreviousStatus(Integer previousStatus) {this.previousStatus = previousStatus;}public Integer getVendorId() {return vendorId;}public void setVendorId(Integer vendorId) {this.vendorId = vendorId;}public String getDelayReasonText() {return delayReasonText;}public void setDelayReasonText(String delayReasonText) {this.delayReasonText = delayReasonText;}public Integer getDoaLogisticsProviderId() {return doaLogisticsProviderId;}public void setDoaLogisticsProviderId(Integer doaLogisticsProviderId) {this.doaLogisticsProviderId = doaLogisticsProviderId;}public Boolean isVendorPaid() {return vendorPaid;}public void setVendorPaid(Boolean vendorPaid) {this.vendorPaid = vendorPaid;}public LocalDateTime getLocalConnectedTimestamp() {return localConnectedTimestamp;}public void setLocalConnectedTimestamp(LocalDateTime localConnectedTimestamp) {this.localConnectedTimestamp = localConnectedTimestamp;}public LocalDateTime getReachedDestinationTimestamp() {return reachedDestinationTimestamp;}public void setReachedDestinationTimestamp(LocalDateTime reachedDestinationTimestamp) {this.reachedDestinationTimestamp = reachedDestinationTimestamp;}public LocalDateTime getFirstDlvyatmpTimestamp() {return firstDlvyatmpTimestamp;}public void setFirstDlvyatmpTimestamp(LocalDateTime firstDlvyatmpTimestamp) {this.firstDlvyatmpTimestamp = firstDlvyatmpTimestamp;}public Integer getOriginalOrderId() {return originalOrderId;}public void setOriginalOrderId(Integer originalOrderId) {this.originalOrderId = originalOrderId;}public Integer getFulfilmentWarehouseId() {return fulfilmentWarehouseId;}public void setFulfilmentWarehouseId(Integer fulfilmentWarehouseId) {this.fulfilmentWarehouseId = fulfilmentWarehouseId;}public Integer getOrderType() {return orderType;}public void setOrderType(Integer orderType) {this.orderType = orderType;}public Integer getPickupStoreId() {return pickupStoreId;}public void setPickupStoreId(Integer pickupStoreId) {this.pickupStoreId = pickupStoreId;}public Boolean isOtg() {return otg;}public void setOtg(Boolean otg) {this.otg = otg;}public LocalDateTime getCourierDeliveryTimestamp() {return courierDeliveryTimestamp;}public void setCourierDeliveryTimestamp(LocalDateTime courierDeliveryTimestamp) {this.courierDeliveryTimestamp = courierDeliveryTimestamp;}public Integer getInsurer() {return insurer;}public void setInsurer(Integer insurer) {this.insurer = insurer;}public Float getInsuranceAmount() {return insuranceAmount;}public void setInsuranceAmount(Float insuranceAmount) {this.insuranceAmount = insuranceAmount;}public Integer getFreebieItemId() {return freebieItemId;}public void setFreebieItemId(Integer freebieItemId) {this.freebieItemId = freebieItemId;}public Integer getSource() {return source;}public void setSource(Integer source) {this.source = source;}public Float getAdvanceAmount() {return advanceAmount;}public void setAdvanceAmount(Float advanceAmount) {this.advanceAmount = advanceAmount;}public Integer getStoreId() {return storeId;}public void setStoreId(Integer storeId) {this.storeId = storeId;}public Integer getProductCondition() {return productCondition;}public void setProductCondition(Integer productCondition) {this.productCondition = productCondition;}public Integer getDataProtectionInsurer() {return dataProtectionInsurer;}public void setDataProtectionInsurer(Integer dataProtectionInsurer) {this.dataProtectionInsurer = dataProtectionInsurer;}public Integer getDataProtectionAmount() {return dataProtectionAmount;}public void setDataProtectionAmount(Integer dataProtectionAmount) {this.dataProtectionAmount = dataProtectionAmount;}public TaxType getTaxType() {return taxType;}public void setTaxType(TaxType taxType) {this.taxType = taxType;}public String getLogisticsTransactionId() {return logisticsTransactionId;}public void setLogisticsTransactionId(String logisticsTransactionId) {this.logisticsTransactionId = logisticsTransactionId;}public Float getShippingCost() {return shippingCost;}public void setShippingCost(Float shippingCost) {this.shippingCost = shippingCost;}public Float getCodCharges() {return codCharges;}public void setCodCharges(Float codCharges) {this.codCharges = codCharges;}public Float getWalletAmount() {return walletAmount;}public void setWalletAmount(Float walletAmount) {this.walletAmount = walletAmount;}public Float getNetPayableAmount() {return netPayableAmount;}public void setNetPayableAmount(Float netPayableAmount) {this.netPayableAmount = netPayableAmount;}public Float getShippingRefund() {return shippingRefund;}public void setShippingRefund(Float shippingRefund) {this.shippingRefund = shippingRefund;}public LineItem getLineItem() {return lineItem;}public void setLineItem(LineItem lineItem) {this.lineItem = lineItem;}@Overridepublic int hashCode() {final int prime = 31;int result = 1;result = prime * result + ((acceptedTimestamp == null) ? 0 : acceptedTimestamp.hashCode());result = prime * result + ((advanceAmount == null) ? 0 : advanceAmount.hashCode());result = prime * result + ((airwayBillNumber == null) ? 0 : airwayBillNumber.hashCode());result = prime * result + ((batchNumber == null) ? 0 : batchNumber.hashCode());result = prime * result + ((billedBy == null) ? 0 : billedBy.hashCode());result = prime * result + ((billingTimestamp == null) ? 0 : billingTimestamp.hashCode());result = prime * result + ((cod == null) ? 0 : cod.hashCode());result = prime * result + ((codCharges == null) ? 0 : codCharges.hashCode());result = prime * result + ((codReconciliationTimestamp == null) ? 0 : codReconciliationTimestamp.hashCode());result = prime * result + ((courierDeliveryTimestamp == null) ? 0 : courierDeliveryTimestamp.hashCode());result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());result = prime * result + ((dataProtectionAmount == null) ? 0 : dataProtectionAmount.hashCode());result = prime * result + ((dataProtectionInsurer == null) ? 0 : dataProtectionInsurer.hashCode());result = prime * result + ((delayReason == null) ? 0 : delayReason.hashCode());result = prime * result + ((delayReasonText == null) ? 0 : delayReasonText.hashCode());result = prime * result + ((deliveryTimestamp == null) ? 0 : deliveryTimestamp.hashCode());result = prime * result + ((doaAuthTimestamp == null) ? 0 : doaAuthTimestamp.hashCode());result = prime * result + ((doaFlag == null) ? 0 : doaFlag.hashCode());result = prime * result + ((doaLogisticsProviderId == null) ? 0 : doaLogisticsProviderId.hashCode());result = prime * result + ((doaPickupTimestamp == null) ? 0 : doaPickupTimestamp.hashCode());result = prime * result + ((expectedDeliveryTime == null) ? 0 : expectedDeliveryTime.hashCode());result = prime * result + ((expectedShippingTime == null) ? 0 : expectedShippingTime.hashCode());result = prime * result + ((firstDlvyatmpTimestamp == null) ? 0 : firstDlvyatmpTimestamp.hashCode());result = prime * result + ((freebieItemId == null) ? 0 : freebieItemId.hashCode());result = prime * result + ((fulfilmentWarehouseId == null) ? 0 : fulfilmentWarehouseId.hashCode());result = prime * result + ((gvAmount == null) ? 0 : gvAmount.hashCode());result = prime * result + ((id == null) ? 0 : id.hashCode());result = prime * result + ((insuranceAmount == null) ? 0 : insuranceAmount.hashCode());result = prime * result + ((insurer == null) ? 0 : insurer.hashCode());result = prime * result + ((invoiceNumber == null) ? 0 : invoiceNumber.hashCode());result = prime * result + ((jacketNumber == null) ? 0 : jacketNumber.hashCode());result = prime * result + ((lineItem == null) ? 0 : lineItem.hashCode());result = prime * result + ((localConnectedTimestamp == null) ? 0 : localConnectedTimestamp.hashCode());result = prime * result + ((logisticsProviderId == null) ? 0 : logisticsProviderId.hashCode());result = prime * result + ((logisticsTransactionId == null) ? 0 : logisticsTransactionId.hashCode());result = prime * result + ((netPayableAmount == null) ? 0 : netPayableAmount.hashCode());result = prime * result + ((newOrderId == null) ? 0 : newOrderId.hashCode());result = prime * result + ((orderType == null) ? 0 : orderType.hashCode());result = prime * result + ((originalOrderId == null) ? 0 : originalOrderId.hashCode());result = prime * result + ((otg == null) ? 0 : otg.hashCode());result = prime * result + ((outOfStockTimestamp == null) ? 0 : outOfStockTimestamp.hashCode());result = prime * result + ((pickupRequestNumber == null) ? 0 : pickupRequestNumber.hashCode());result = prime * result + ((pickupStoreId == null) ? 0 : pickupStoreId.hashCode());result = prime * result + ((pickupTimestamp == null) ? 0 : pickupTimestamp.hashCode());result = prime * result + ((previousStatus == null) ? 0 : previousStatus.hashCode());result = prime * result + ((productCondition == null) ? 0 : productCondition.hashCode());result = prime * result + ((promisedDeliveryTime == null) ? 0 : promisedDeliveryTime.hashCode());result = prime * result + ((promisedShippingTime == null) ? 0 : promisedShippingTime.hashCode());result = prime * result + ((purchaseOrderId == null) ? 0 : purchaseOrderId.hashCode());result = prime * result + ((reShipTimestamp == null) ? 0 : reShipTimestamp.hashCode());result = prime * result + ((reachedDestinationTimestamp == null) ? 0 : reachedDestinationTimestamp.hashCode());result = prime * result + ((receiver == null) ? 0 : receiver.hashCode());result = prime * result + ((receiverReturnTimestamp == null) ? 0 : receiverReturnTimestamp.hashCode());result = prime * result + ((refundBy == null) ? 0 : refundBy.hashCode());result = prime * result + ((refundReason == null) ? 0 : refundReason.hashCode());result = prime * result + ((refundTimestamp == null) ? 0 : refundTimestamp.hashCode());result = prime * result + ((retailerAddress1 == null) ? 0 : retailerAddress1.hashCode());result = prime * result + ((retailerAddress2 == null) ? 0 : retailerAddress2.hashCode());result = prime * result + ((retailerCity == null) ? 0 : retailerCity.hashCode());result = prime * result + ((retailerEmailId == null) ? 0 : retailerEmailId.hashCode());result = prime * result + ((retailerId == null) ? 0 : retailerId.hashCode());result = prime * result + ((retailerMobileNumber == null) ? 0 : retailerMobileNumber.hashCode());result = prime * result + ((retailerName == null) ? 0 : retailerName.hashCode());result = prime * result + ((retailerPinCode == null) ? 0 : retailerPinCode.hashCode());result = prime * result + ((retailerState == null) ? 0 : retailerState.hashCode());result = prime * result + ((sellerId == null) ? 0 : sellerId.hashCode());result = prime * result + ((serialNumber == null) ? 0 : serialNumber.hashCode());result = prime * result + ((shippingCost == null) ? 0 : shippingCost.hashCode());result = prime * result + ((shippingRefund == null) ? 0 : shippingRefund.hashCode());result = prime * result + ((shippingTimestamp == null) ? 0 : shippingTimestamp.hashCode());result = prime * result + ((source == null) ? 0 : source.hashCode());result = prime * result + ((status == null) ? 0 : status.hashCode());result = prime * result + ((statusDescription == null) ? 0 : statusDescription.hashCode());result = prime * result + ((storeId == null) ? 0 : storeId.hashCode());result = prime * result + ((taxType == null) ? 0 : taxType.hashCode());result = prime * result + ((totalAmount == null) ? 0 : totalAmount.hashCode());result = prime * result + ((totalWeight == null) ? 0 : totalWeight.hashCode());result = prime * result + ((trackingId == null) ? 0 : trackingId.hashCode());result = prime * result + ((transactionId == null) ? 0 : transactionId.hashCode());result = prime * result + ((vendorId == null) ? 0 : vendorId.hashCode());result = prime * result + ((vendorPaid == null) ? 0 : vendorPaid.hashCode());result = prime * result + ((verificationTimestamp == null) ? 0 : verificationTimestamp.hashCode());result = prime * result + ((walletAmount == null) ? 0 : walletAmount.hashCode());result = prime * result + ((warehouseAddressId == null) ? 0 : warehouseAddressId.hashCode());result = prime * result + ((warehouseId == null) ? 0 : warehouseId.hashCode());return result;}@Overridepublic boolean equals(Object obj) {if (this == obj)return true;if (obj == null)return false;if (getClass() != obj.getClass())return false;Order other = (Order) obj;if (acceptedTimestamp == null) {if (other.acceptedTimestamp != null)return false;} else if (!acceptedTimestamp.equals(other.acceptedTimestamp))return false;if (advanceAmount == null) {if (other.advanceAmount != null)return false;} else if (!advanceAmount.equals(other.advanceAmount))return false;if (airwayBillNumber == null) {if (other.airwayBillNumber != null)return false;} else if (!airwayBillNumber.equals(other.airwayBillNumber))return false;if (batchNumber == null) {if (other.batchNumber != null)return false;} else if (!batchNumber.equals(other.batchNumber))return false;if (billedBy == null) {if (other.billedBy != null)return false;} else if (!billedBy.equals(other.billedBy))return false;if (billingTimestamp == null) {if (other.billingTimestamp != null)return false;} else if (!billingTimestamp.equals(other.billingTimestamp))return false;if (cod == null) {if (other.cod != null)return false;} else if (!cod.equals(other.cod))return false;if (codCharges == null) {if (other.codCharges != null)return false;} else if (!codCharges.equals(other.codCharges))return false;if (codReconciliationTimestamp == null) {if (other.codReconciliationTimestamp != null)return false;} else if (!codReconciliationTimestamp.equals(other.codReconciliationTimestamp))return false;if (courierDeliveryTimestamp == null) {if (other.courierDeliveryTimestamp != null)return false;} else if (!courierDeliveryTimestamp.equals(other.courierDeliveryTimestamp))return false;if (createTimestamp == null) {if (other.createTimestamp != null)return false;} else if (!createTimestamp.equals(other.createTimestamp))return false;if (dataProtectionAmount == null) {if (other.dataProtectionAmount != null)return false;} else if (!dataProtectionAmount.equals(other.dataProtectionAmount))return false;if (dataProtectionInsurer == null) {if (other.dataProtectionInsurer != null)return false;} else if (!dataProtectionInsurer.equals(other.dataProtectionInsurer))return false;if (delayReason != other.delayReason)return false;if (delayReasonText == null) {if (other.delayReasonText != null)return false;} else if (!delayReasonText.equals(other.delayReasonText))return false;if (deliveryTimestamp == null) {if (other.deliveryTimestamp != null)return false;} else if (!deliveryTimestamp.equals(other.deliveryTimestamp))return false;if (doaAuthTimestamp == null) {if (other.doaAuthTimestamp != null)return false;} else if (!doaAuthTimestamp.equals(other.doaAuthTimestamp))return false;if (doaFlag == null) {if (other.doaFlag != null)return false;} else if (!doaFlag.equals(other.doaFlag))return false;if (doaLogisticsProviderId == null) {if (other.doaLogisticsProviderId != null)return false;} else if (!doaLogisticsProviderId.equals(other.doaLogisticsProviderId))return false;if (doaPickupTimestamp == null) {if (other.doaPickupTimestamp != null)return false;} else if (!doaPickupTimestamp.equals(other.doaPickupTimestamp))return false;if (expectedDeliveryTime == null) {if (other.expectedDeliveryTime != null)return false;} else if (!expectedDeliveryTime.equals(other.expectedDeliveryTime))return false;if (expectedShippingTime == null) {if (other.expectedShippingTime != null)return false;} else if (!expectedShippingTime.equals(other.expectedShippingTime))return false;if (firstDlvyatmpTimestamp == null) {if (other.firstDlvyatmpTimestamp != null)return false;} else if (!firstDlvyatmpTimestamp.equals(other.firstDlvyatmpTimestamp))return false;if (freebieItemId == null) {if (other.freebieItemId != null)return false;} else if (!freebieItemId.equals(other.freebieItemId))return false;if (fulfilmentWarehouseId == null) {if (other.fulfilmentWarehouseId != null)return false;} else if (!fulfilmentWarehouseId.equals(other.fulfilmentWarehouseId))return false;if (gvAmount == null) {if (other.gvAmount != null)return false;} else if (!gvAmount.equals(other.gvAmount))return false;if (id == null) {if (other.id != null)return false;} else if (!id.equals(other.id))return false;if (insuranceAmount == null) {if (other.insuranceAmount != null)return false;} else if (!insuranceAmount.equals(other.insuranceAmount))return false;if (insurer == null) {if (other.insurer != null)return false;} else if (!insurer.equals(other.insurer))return false;if (invoiceNumber == null) {if (other.invoiceNumber != null)return false;} else if (!invoiceNumber.equals(other.invoiceNumber))return false;if (jacketNumber == null) {if (other.jacketNumber != null)return false;} else if (!jacketNumber.equals(other.jacketNumber))return false;if (lineItem == null) {if (other.lineItem != null)return false;} else if (!lineItem.equals(other.lineItem))return false;if (localConnectedTimestamp == null) {if (other.localConnectedTimestamp != null)return false;} else if (!localConnectedTimestamp.equals(other.localConnectedTimestamp))return false;if (logisticsProviderId == null) {if (other.logisticsProviderId != null)return false;} else if (!logisticsProviderId.equals(other.logisticsProviderId))return false;if (logisticsTransactionId == null) {if (other.logisticsTransactionId != null)return false;} else if (!logisticsTransactionId.equals(other.logisticsTransactionId))return false;if (netPayableAmount == null) {if (other.netPayableAmount != null)return false;} else if (!netPayableAmount.equals(other.netPayableAmount))return false;if (newOrderId == null) {if (other.newOrderId != null)return false;} else if (!newOrderId.equals(other.newOrderId))return false;if (orderType == null) {if (other.orderType != null)return false;} else if (!orderType.equals(other.orderType))return false;if (originalOrderId == null) {if (other.originalOrderId != null)return false;} else if (!originalOrderId.equals(other.originalOrderId))return false;if (otg == null) {if (other.otg != null)return false;} else if (!otg.equals(other.otg))return false;if (outOfStockTimestamp == null) {if (other.outOfStockTimestamp != null)return false;} else if (!outOfStockTimestamp.equals(other.outOfStockTimestamp))return false;if (pickupRequestNumber == null) {if (other.pickupRequestNumber != null)return false;} else if (!pickupRequestNumber.equals(other.pickupRequestNumber))return false;if (pickupStoreId == null) {if (other.pickupStoreId != null)return false;} else if (!pickupStoreId.equals(other.pickupStoreId))return false;if (pickupTimestamp == null) {if (other.pickupTimestamp != null)return false;} else if (!pickupTimestamp.equals(other.pickupTimestamp))return false;if (previousStatus == null) {if (other.previousStatus != null)return false;} else if (!previousStatus.equals(other.previousStatus))return false;if (productCondition == null) {if (other.productCondition != null)return false;} else if (!productCondition.equals(other.productCondition))return false;if (promisedDeliveryTime == null) {if (other.promisedDeliveryTime != null)return false;} else if (!promisedDeliveryTime.equals(other.promisedDeliveryTime))return false;if (promisedShippingTime == null) {if (other.promisedShippingTime != null)return false;} else if (!promisedShippingTime.equals(other.promisedShippingTime))return false;if (purchaseOrderId == null) {if (other.purchaseOrderId != null)return false;} else if (!purchaseOrderId.equals(other.purchaseOrderId))return false;if (reShipTimestamp == null) {if (other.reShipTimestamp != null)return false;} else if (!reShipTimestamp.equals(other.reShipTimestamp))return false;if (reachedDestinationTimestamp == null) {if (other.reachedDestinationTimestamp != null)return false;} else if (!reachedDestinationTimestamp.equals(other.reachedDestinationTimestamp))return false;if (receiver == null) {if (other.receiver != null)return false;} else if (!receiver.equals(other.receiver))return false;if (receiverReturnTimestamp == null) {if (other.receiverReturnTimestamp != null)return false;} else if (!receiverReturnTimestamp.equals(other.receiverReturnTimestamp))return false;if (refundBy == null) {if (other.refundBy != null)return false;} else if (!refundBy.equals(other.refundBy))return false;if (refundReason == null) {if (other.refundReason != null)return false;} else if (!refundReason.equals(other.refundReason))return false;if (refundTimestamp == null) {if (other.refundTimestamp != null)return false;} else if (!refundTimestamp.equals(other.refundTimestamp))return false;if (retailerAddress1 == null) {if (other.retailerAddress1 != null)return false;} else if (!retailerAddress1.equals(other.retailerAddress1))return false;if (retailerAddress2 == null) {if (other.retailerAddress2 != null)return false;} else if (!retailerAddress2.equals(other.retailerAddress2))return false;if (retailerCity == null) {if (other.retailerCity != null)return false;} else if (!retailerCity.equals(other.retailerCity))return false;if (retailerEmailId == null) {if (other.retailerEmailId != null)return false;} else if (!retailerEmailId.equals(other.retailerEmailId))return false;if (retailerId == null) {if (other.retailerId != null)return false;} else if (!retailerId.equals(other.retailerId))return false;if (retailerMobileNumber == null) {if (other.retailerMobileNumber != null)return false;} else if (!retailerMobileNumber.equals(other.retailerMobileNumber))return false;if (retailerName == null) {if (other.retailerName != null)return false;} else if (!retailerName.equals(other.retailerName))return false;if (retailerPinCode == null) {if (other.retailerPinCode != null)return false;} else if (!retailerPinCode.equals(other.retailerPinCode))return false;if (retailerState == null) {if (other.retailerState != null)return false;} else if (!retailerState.equals(other.retailerState))return false;if (sellerId == null) {if (other.sellerId != null)return false;} else if (!sellerId.equals(other.sellerId))return false;if (serialNumber == null) {if (other.serialNumber != null)return false;} else if (!serialNumber.equals(other.serialNumber))return false;if (shippingCost == null) {if (other.shippingCost != null)return false;} else if (!shippingCost.equals(other.shippingCost))return false;if (shippingRefund == null) {if (other.shippingRefund != null)return false;} else if (!shippingRefund.equals(other.shippingRefund))return false;if (shippingTimestamp == null) {if (other.shippingTimestamp != null)return false;} else if (!shippingTimestamp.equals(other.shippingTimestamp))return false;if (source == null) {if (other.source != null)return false;} else if (!source.equals(other.source))return false;if (status != other.status)return false;if (statusDescription == null) {if (other.statusDescription != null)return false;} else if (!statusDescription.equals(other.statusDescription))return false;if (storeId == null) {if (other.storeId != null)return false;} else if (!storeId.equals(other.storeId))return false;if (taxType != other.taxType)return false;if (totalAmount == null) {if (other.totalAmount != null)return false;} else if (!totalAmount.equals(other.totalAmount))return false;if (totalWeight == null) {if (other.totalWeight != null)return false;} else if (!totalWeight.equals(other.totalWeight))return false;if (trackingId == null) {if (other.trackingId != null)return false;} else if (!trackingId.equals(other.trackingId))return false;if (transactionId == null) {if (other.transactionId != null)return false;} else if (!transactionId.equals(other.transactionId))return false;if (vendorId == null) {if (other.vendorId != null)return false;} else if (!vendorId.equals(other.vendorId))return false;if (vendorPaid == null) {if (other.vendorPaid != null)return false;} else if (!vendorPaid.equals(other.vendorPaid))return false;if (verificationTimestamp == null) {if (other.verificationTimestamp != null)return false;} else if (!verificationTimestamp.equals(other.verificationTimestamp))return false;if (walletAmount == null) {if (other.walletAmount != null)return false;} else if (!walletAmount.equals(other.walletAmount))return false;if (warehouseAddressId == null) {if (other.warehouseAddressId != null)return false;} else if (!warehouseAddressId.equals(other.warehouseAddressId))return false;if (warehouseId == null) {if (other.warehouseId != null)return false;} else if (!warehouseId.equals(other.warehouseId))return false;return true;}@Overridepublic 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 + "]";}}