Subversion Repositories SmartDukaan

Rev

Rev 29966 | Rev 30017 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
21716 ashik.ali 1 
package com.spice.profitmandi.dao.entity.transaction;
21545 ashik.ali 2 
 
29966 amit.gupta 3 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
4 
import in.shop2020.model.v1.order.OrderStatus;
5 
import in.shop2020.model.v1.order.TaxType;
6 
 
7 
import javax.persistence.*;
21545 ashik.ali 8 
import java.io.Serializable;
9 
import java.time.LocalDateTime;
23075 ashik.ali 10 
import java.time.format.DateTimeFormatter;
21545 ashik.ali 11 
 
12 
/**
13 
 * This class basically contains order details
29966 amit.gupta 14 
 *
21545 ashik.ali 15 
 * @author ashikali
16 
 */
21634 ashik.ali 17 
 
21545 ashik.ali 18 
@Entity
27723 tejbeer 19 
@Table(name = "transaction.`order`", schema = "transaction")
30003 tejbeer 20 
@NamedQueries({ @NamedQuery(name = "Order.selectAll", query = "select o from Order o"),
27723 tejbeer 21 
		@NamedQuery(name = "Order.selectById", query = "select o from Order o where o.id= :id"),
22 
		@NamedQuery(name = "Order.selectByTransactionId", query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
23 
				+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
24 
				+ "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 "
25 
				+ "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"),
26 
 
27 
		@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"),
28 
 
29 
		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderBillingModel(li.brand, "
30 
				+ "sum(case when o.billingTimestamp >= :today then CAST(o.totalAmount  AS int) else 0 end),"
27749 tejbeer 31 
				+ "sum(case when o.billingTimestamp >= :threedays  and o.billingTimestamp < :endDate  then CAST(o.totalAmount  AS int) else 0 end),"
27723 tejbeer 32 
				+ "sum(case when concat(year(o.billingTimestamp ), month(o.billingTimestamp ))= :mtd  then CAST(o.totalAmount AS int) else 0 end),"
33 
				+ "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(o.totalAmount  AS int) else 0 end),"
27749 tejbeer 34 
				+ "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmsEndDate  then CAST(o.totalAmount  AS int) else 0 end),"
27723 tejbeer 35 
				+ "	sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"
27726 tejbeer 36 
				+ "	sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"
27723 tejbeer 37 
				+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd  then li.quantity else 0 end),"
27749 tejbeer 38 
				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end),"
39 
				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmsEndDate  then li.quantity else 0 end)"
40 
				+ " )"
27832 amit.gupta 41 
				+ "	 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)"
27903 tejbeer 42 
				+ "	and o.billingTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId and fs.internal = 0 group by li.brand"),
27723 tejbeer 43 
 
28468 tejbeer 44 
		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrandFofoId", query = "select new com.spice.profitmandi.dao.model.BrandWiseModel(li.brand,"
45 
				+ "	DATE_FORMAT(o.billingTimestamp, '%m-%Y'),sum(cast(o.totalAmount As int)))"
28439 tejbeer 46 
				+ "	 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)"
28468 tejbeer 47 
				+ "	and o.billingTimestamp >= :startDate and o.retailerId =:fofoId  group by li.brand,DATE_FORMAT(o.billingTimestamp, '%m-%Y')"),
28439 tejbeer 48 
 
27867 tejbeer 49 
		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrandWarehouse", query = "select new com.spice.profitmandi.dao.model.SecondaryWarehouseWiseOrderBilllingModel(fs.warehouseId,date(o.billingTimestamp), li.brand, "
50 
				+ "sum(CAST(o.totalAmount  AS int)),sum( li.quantity))"
51 
				+ "	 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)"
27903 tejbeer 52 
				+ "	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"),
27867 tejbeer 53 
 
27749 tejbeer 54 
		@NamedQuery(name = "Order.selectAllBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "
27738 tejbeer 55 
				+ " i.modelNumber, i.color," + "o.totalAmount," + "	 li.quantity)"
27832 amit.gupta 56 
				+ "	 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)"
27903 tejbeer 57 
				+ "	and date(o.billingTimestamp) in :date and fs.warehouseId in :warehouseId and li.brand = :brand and fs.internal = 0 order by li.itemId desc"),
27738 tejbeer 58 
 
27749 tejbeer 59 
		@NamedQuery(name = "Order.selectTodayBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "
27738 tejbeer 60 
				+ " i.modelNumber, i.color," + "o.totalAmount," + "	 li.quantity)"
27832 amit.gupta 61 
				+ "	 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)"
27893 tejbeer 62 
				+ "	and o.billingTimestamp >= :startDate and fs.warehouseId in :warehouseId and li.brand in :brand order by li.itemId desc"),
27738 tejbeer 63 
 
27893 tejbeer 64 
		@NamedQuery(name = "Order.selectAllBilledOrderBrandByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockBrandModel(li.brand,"
65 
				+ "	 Sum(li.quantity),Sum(CAST(o.totalAmount As int)))"
66 
				+ "	 from Order o join LineItem li on o.id = li.orderId where o.status in (7,9,10,12)"
67 
				+ "	and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate and o.retailerId = :fofoId group by li.brand"),
68 
 
69 
		@NamedQuery(name = "Order.selectAllBilledOrderBrandItemByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockBrandItemModel("
70 
				+ " i.brand, i.modelName, i.modelNumber, i.color,Sum(li.quantity), Sum(CAST(o.totalAmount As int)))"
71 
				+ "	 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)"
72 
				+ "	and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate and o.retailerId = :fofoId  group by i.id"),
73 
 
28004 tejbeer 74 
		@NamedQuery(name = "Order.selectAllGrnPendingOrderByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdQtyModel("
28020 tejbeer 75 
				+ "  fs.warehouseId,fs.id,sum(li.quantity )) from FofoStore fs join  Order o on fs.id = o.retailerId "
28004 tejbeer 76 
				+ "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
77 
				+ "  join Item i on (i.id = tl.itemId ) where " + "	 fs.active = 1 and fs.internal = 0 and"
29715 tejbeer 78 
				+ "  o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null"
28020 tejbeer 79 
				+ "  and i.catalogItemId in :catalogItemId group by fs.id"),
28004 tejbeer 80 
 
81 
		@NamedQuery(name = "Order.selectAllPendingIndentOrderByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdQtyModel("
28020 tejbeer 82 
				+ "  fs.warehouseId,fs.id,sum(case when li.quantity is null then 0 else  li.quantity end))"
28004 tejbeer 83 
				+ "	 from FofoStore fs  join  Order o on fs.id = o.retailerId"
84 
				+ "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
85 
				+ "  join Item i on i.id = tl.itemId  where "
28020 tejbeer 86 
				+ "	 fs.active = 1 and fs.internal = 0 and o.status in (3,4) and i.catalogItemId in :catalogItemId group by fs.id"),
28004 tejbeer 87 
 
28486 tejbeer 88 
		@NamedQuery(name = "Order.selectGrnPendingOrdersByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdCatalogQtyModel("
28474 tejbeer 89 
				+ "  fs.warehouseId,fs.id,i.catalogItemId,sum(li.quantity )) from FofoStore fs join  Order o on fs.id = o.retailerId "
90 
				+ "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
91 
				+ "  join Item i on (i.id = tl.itemId ) where " + "	 fs.active = 1 and fs.internal = 0 and"
29715 tejbeer 92 
				+ "  o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null"
28477 tejbeer 93 
				+ "  and i.catalogItemId in :catalogItemId and fs.warehouseId in :warehouseId group by i.catalogItemId, fs.id"),
28474 tejbeer 94 
 
28486 tejbeer 95 
		@NamedQuery(name = "Order.selectPendingIndentOrdersByCatalogId", query = "select new com.spice.profitmandi.dao.model.FofoIdCatalogQtyModel("
28474 tejbeer 96 
				+ "  fs.warehouseId,fs.id,i.catalogItemId,sum(case when li.quantity is null then 0 else  li.quantity end))"
97 
				+ "	 from FofoStore fs  join  Order o on fs.id = o.retailerId"
98 
				+ "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
99 
				+ "  join Item i on i.id = tl.itemId  where "
28477 tejbeer 100 
				+ "	 fs.active = 1 and fs.internal = 0 and o.status in (3,4) and i.catalogItemId in :catalogItemId and fs.warehouseId in :warehouseId group by i.catalogItemId, fs.id"),
28474 tejbeer 101 
 
28004 tejbeer 102 
		@NamedQuery(name = "Order.selectAllGrnPendingOrderByRange", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
28020 tejbeer 103 
				+ "  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 "
28004 tejbeer 104 
				+ "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
105 
				+ "  join Item i on (i.id = tl.itemId ) where " + "	 fs.active = 1 and fs.internal = 0 and"
29715 tejbeer 106 
				+ "  o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null"
28004 tejbeer 107 
				+ "  and tl.mop between :startPrice and :endPrice and i.categoryId=10006 group by fs.id,i.catalogItemId,i.brand,i.modelName,i.modelNumber"),
108 
 
109 
		@NamedQuery(name = "Order.selectAllPendingIndentOrderByRange", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
28020 tejbeer 110 
				+ "  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)"
28004 tejbeer 111 
				+ "	 from FofoStore fs  join  Order o on fs.id = o.retailerId"
112 
				+ "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
113 
				+ "  join Item i on i.id = tl.itemId  where "
114 
				+ "	 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"),
115 
 
28032 tejbeer 116 
		@NamedQuery(name = "Order.selectAllGrnPendingOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
117 
				+ "  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 "
118 
				+ "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
119 
				+ "  join Item i on (i.id = tl.itemId ) where " + "	 fs.active = 1 and fs.internal = 0 and"
29715 tejbeer 120 
				+ "  o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null"
28032 tejbeer 121 
				+ "  and i.catalogItemId in :catalogItemId and  i.categoryId=10006 and fs.id = :fofoId group by i.catalogItemId, i.brand,i.modelName,i.modelNumber"),
122 
 
123 
		@NamedQuery(name = "Order.selectAllPendingIndentOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel("
124 
				+ "   fs.warehouseId, fs.id, sum(li.quantity), i.brand, i.modelName, i.modelNumber, i.catalogItemId)"
125 
				+ "	 from FofoStore fs  join  Order o on fs.id = o.retailerId"
126 
				+ "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
127 
				+ "  join Item i on i.id = tl.itemId  where "
128 
				+ "	 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"),
129 
 
28461 tejbeer 130 
		@NamedQuery(name = "Order.selectGroupByBrandLmp", query = "select new com.spice.profitmandi.dao.model.BrandWiseModel(li.brand,"
131 
				+ " DATE_FORMAT(o.billingTimestamp, '%m-%Y'),sum(cast(o.totalAmount As int)))"
132 
				+ "	 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)"
133 
				+ "	and o.billingTimestamp >= :lmsStartDate and fs.id in :fofoId and fs.warehouseId in :warehouseId and fs.internal = 0 group by li.brand,DATE_FORMAT(o.billingTimestamp, '%m-%Y')"),
134 
 
28486 tejbeer 135 
		@NamedQuery(name = "Order.selectGrnPendingOrderQtyByCatalogId", query = "select sum(case when li.quantity is null then 0 else  li.quantity end)"
136 
				+ "  from FofoStore fs join  Order o on fs.id = o.retailerId "
137 
				+ "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId "
138 
				+ "  join Item i on (i.id = tl.itemId ) where " + "	 fs.active = 1 and fs.internal = 0 and"
29715 tejbeer 139 
				+ "  o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null"
28486 tejbeer 140 
				+ "  and i.catalogItemId = :catalogItemId and fs.id = :fofoId group by i.catalogItemId, fs.id"),
141 
 
142 
		@NamedQuery(name = "Order.selectPendingIndentOrderQtyByCatalogId", query = "select sum(case when li.quantity is null then 0 else  li.quantity end)"
143 
				+ "	 from FofoStore fs  join  Order o on fs.id = o.retailerId"
144 
				+ "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId "
145 
				+ "  join Item i on i.id = tl.itemId  where "
146 
				+ "	 fs.active = 1 and fs.internal = 0 and o.status in (3,4)and i.catalogItemId = :catalogItemId and fs.id = :fofoId group by i.catalogItemId, fs.id"),
147 
 
29966 amit.gupta 148 
		@NamedQuery(name = "Order.selectTodayOrders", query = "select new com.spice.profitmandi.dao.model.BrandRegionPOModel(fs.warehouseId, li.brand, "
149 
				+ " sum(case when (o.createTimestamp between :startDate and :endDate) then cast(o.totalAmount as integer) else 0 end),"
150 
				+ " sum(case when (o.billingTimestamp is not null and (o.createTimestamp between :startDate and :endDate)) then cast(o.totalAmount as integer) else 0 end),"
151 
				+ " sum(case when o.billingTimestamp is not null then cast(o.totalAmount as integer) else 0 end))"
152 
				+ "	from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId "
153 
				+ " where o.refundTimestamp is null and ((o.createTimestamp between :startDate and :endDate) or (o.billingTimestamp between :startDate and :endDate)) and fs.internal = 0 and li.brand not in ('Smartdukaan','Dummy')"
154 
				+ " group by fs.warehouseId , li.brand"),
155 
 
30003 tejbeer 156 
		@NamedQuery(name = "Order.selectAllPendingIndentAccessoriesTvGroupByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockAccessoriesTvFofoIdModel("
157 
				+ "  o.retailerId, SUM(case when c.parentCategoryId  = 10011 then CAST(o.totalAmount  AS int) else 0 end), SUM(case when c.parentCategoryId  = 14200 then  CAST(o.totalAmount  AS int) else 0 end))"
158 
				+ "	 from  Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId  join Category c on c.id = i.categoryId "
159 
				+ "  where o.retailerId in :fofoIds and o.status in (3,4) and i.categoryId != 10006 group by o.retailerId"),
160 
 
161 
		@NamedQuery(name = "Order.selectAllGrnPendingAccessoriesTvGroupByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockAccessoriesTvFofoIdModel("
162 
				+ "  o.retailerId, SUM(case when c.parentCategoryId  = 10011 then CAST(o.totalAmount  AS int) else 0 end), SUM(case when c.parentCategoryId  = 14200 then  CAST(o.totalAmount  AS int) else 0 end))"
163 
				+ "	 from  Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId  join Category c on c.id = i.categoryId "
164 
				+ "  where o.retailerId in :fofoIds and o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null and i.categoryId != 10006 group by o.retailerId"),
165 
 
21545 ashik.ali 166 
})
27723 tejbeer 167 
public class Order implements Serializable {
168 
 
21545 ashik.ali 169 
	private static final long serialVersionUID = 1L;
27723 tejbeer 170 
 
21545 ashik.ali 171 
	public Order() {
172 
	}
27723 tejbeer 173 
 
21545 ashik.ali 174 
	@Id
27723 tejbeer 175 
	@Column(name = "id", unique = true, updatable = false)
21545 ashik.ali 176 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
21629 kshitij.so 177 
	private Integer id;
27723 tejbeer 178 
 
21545 ashik.ali 179 
	@Column(name = "warehouse_id")
21629 kshitij.so 180 
	private Integer warehouseId;
27723 tejbeer 181 
 
21545 ashik.ali 182 
	@Column(name = "seller_id")
21629 kshitij.so 183 
	private Integer sellerId;
27723 tejbeer 184 
 
21545 ashik.ali 185 
	@Column(name = "warehouse_address_id")
21629 kshitij.so 186 
	private Integer warehouseAddressId;
27723 tejbeer 187 
 
21545 ashik.ali 188 
	@Column(name = "logistics_provider_id")
21629 kshitij.so 189 
	private Integer logisticsProviderId;
27723 tejbeer 190 
 
21614 kshitij.so 191 
	@Column(name = "airwaybill_no", length = 50)
21545 ashik.ali 192 
	private String airwayBillNumber;
27723 tejbeer 193 
 
21545 ashik.ali 194 
	@Column(name = "tracking_id", length = 50)
195 
	private String trackingId;
27723 tejbeer 196 
 
22009 ashik.ali 197 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 198 
	@Column(name = "expected_delivery_time")
199 
	private LocalDateTime expectedDeliveryTime;
27723 tejbeer 200 
 
22009 ashik.ali 201 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 202 
	@Column(name = "promised_delivery_time")
203 
	private LocalDateTime promisedDeliveryTime;
27723 tejbeer 204 
 
22009 ashik.ali 205 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 206 
	@Column(name = "expected_shipping_time")
207 
	private LocalDateTime expectedShippingTime;
27723 tejbeer 208 
 
22009 ashik.ali 209 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 210 
	@Column(name = "promised_shipping_time")
211 
	private LocalDateTime promisedShippingTime;
27723 tejbeer 212 
 
23884 amit.gupta 213 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
214 
	@Column(name = "partner_grn_timestamp")
215 
	private LocalDateTime partnerGrnTimestamp;
27723 tejbeer 216 
 
23902 amit.gupta 217 
	public LocalDateTime getPartnerGrnTimestamp() {
23884 amit.gupta 218 
		return partnerGrnTimestamp;
219 
	}
27723 tejbeer 220 
 
23902 amit.gupta 221 
	public void setPartnerGrnTimestamp(LocalDateTime partnerGrnTimestamp) {
23884 amit.gupta 222 
		this.partnerGrnTimestamp = partnerGrnTimestamp;
223 
	}
224 
 
21545 ashik.ali 225 
	@Column(name = "customer_id")
21629 kshitij.so 226 
	private Integer retailerId;
27723 tejbeer 227 
 
21545 ashik.ali 228 
	@Column(name = "customer_name", length = 50)
229 
	private String retailerName;
27723 tejbeer 230 
 
21545 ashik.ali 231 
	@Column(name = "customer_mobilenumber", length = 20)
232 
	private String retailerMobileNumber;
27723 tejbeer 233 
 
21545 ashik.ali 234 
	@Column(name = "customer_pincode", length = 10)
235 
	private String retailerPinCode;
27723 tejbeer 236 
 
21545 ashik.ali 237 
	@Column(name = "customer_address1", length = 100)
238 
	private String retailerAddress1;
27723 tejbeer 239 
 
21545 ashik.ali 240 
	@Column(name = "customer_address2", length = 100)
241 
	private String retailerAddress2;
27723 tejbeer 242 
 
21545 ashik.ali 243 
	@Column(name = "customer_city", length = 100)
244 
	private String retailerCity;
27723 tejbeer 245 
 
21545 ashik.ali 246 
	@Column(name = "customer_state", length = 100)
247 
	private String retailerState;
27723 tejbeer 248 
 
21545 ashik.ali 249 
	@Column(name = "customer_email", length = 50)
250 
	private String retailerEmailId;
27723 tejbeer 251 
 
21545 ashik.ali 252 
	@Column(name = "status")
253 
	@Enumerated(EnumType.ORDINAL)
254 
	private OrderStatus status;
27723 tejbeer 255 
 
21545 ashik.ali 256 
	@Column(name = "statusDescription", length = 50)
257 
	private String statusDescription;
27723 tejbeer 258 
 
21545 ashik.ali 259 
	@Column(name = "total_amount")
21629 kshitij.so 260 
	private Float totalAmount;
27723 tejbeer 261 
 
21545 ashik.ali 262 
	@Column(name = "gvAmount")
21629 kshitij.so 263 
	private Float gvAmount;
27723 tejbeer 264 
 
21545 ashik.ali 265 
	@Column(name = "total_weight")
21629 kshitij.so 266 
	private Float totalWeight;
27723 tejbeer 267 
 
21545 ashik.ali 268 
	@Column(name = "invoice_number", length = 30)
269 
	private String invoiceNumber;
27723 tejbeer 270 
 
21545 ashik.ali 271 
	@Column(name = "billed_by", length = 30)
272 
	private String billedBy;
27723 tejbeer 273 
 
22009 ashik.ali 274 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 275 
	@Column(name = "created_timestamp")
276 
	private LocalDateTime createTimestamp;
27723 tejbeer 277 
 
22009 ashik.ali 278 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 279 
	@Column(name = "accepted_timestamp")
280 
	private LocalDateTime acceptedTimestamp;
27723 tejbeer 281 
 
22009 ashik.ali 282 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 283 
	@Column(name = "billing_timestamp")
284 
	private LocalDateTime billingTimestamp;
27723 tejbeer 285 
 
22009 ashik.ali 286 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 287 
	@Column(name = "shipping_timestamp")
288 
	private LocalDateTime shippingTimestamp;
27723 tejbeer 289 
 
22009 ashik.ali 290 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 291 
	@Column(name = "pickup_timestamp")
292 
	private LocalDateTime pickupTimestamp;
27723 tejbeer 293 
 
22009 ashik.ali 294 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 295 
	@Column(name = "delivery_timestamp")
296 
	private LocalDateTime deliveryTimestamp;
27723 tejbeer 297 
 
22009 ashik.ali 298 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 299 
	@Column(name = "outofstock_timestamp")
300 
	private LocalDateTime outOfStockTimestamp;
27723 tejbeer 301 
 
21545 ashik.ali 302 
	@Column(name = "transaction_id")
27723 tejbeer 303 
	private Integer transactionId;
304 
 
305 
	/*
306 
	 * @Column(name = "jacket_number", length = 10) private Integer jacketNumber;
307 
	 */
308 
 
21545 ashik.ali 309 
	@Column(name = "receiver", length = 50)
310 
	private String receiver;
27723 tejbeer 311 
 
21545 ashik.ali 312 
	@Column(name = "batchNo")
21629 kshitij.so 313 
	private Integer batchNumber;
27723 tejbeer 314 
 
21545 ashik.ali 315 
	@Column(name = "serialNo")
21629 kshitij.so 316 
	private Integer serialNumber;
27723 tejbeer 317 
 
318 
	@Column(name = "doaFlag", columnDefinition = "tinyInteger(1) default 0")
21629 kshitij.so 319 
	private Boolean doaFlag;
27723 tejbeer 320 
 
21545 ashik.ali 321 
	@Column(name = "pickupRequestNo")
21629 kshitij.so 322 
	private Integer pickupRequestNumber;
27723 tejbeer 323 
 
21545 ashik.ali 324 
	@Column(name = "new_order_id")
21629 kshitij.so 325 
	private Integer newOrderId;
27723 tejbeer 326 
 
21545 ashik.ali 327 
	@Column(name = "doa_auth_timestamp")
328 
	private LocalDateTime doaAuthTimestamp;
27723 tejbeer 329 
 
22009 ashik.ali 330 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 331 
	@Column(name = "doa_pickup_timestamp")
332 
	private LocalDateTime doaPickupTimestamp;
27723 tejbeer 333 
 
22009 ashik.ali 334 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 335 
	@Column(name = "received_return_timestamp")
336 
	private LocalDateTime receiverReturnTimestamp;
27723 tejbeer 337 
 
22009 ashik.ali 338 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 339 
	@Column(name = "reship_timestamp")
340 
	private LocalDateTime reShipTimestamp;
27723 tejbeer 341 
 
22009 ashik.ali 342 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 343 
	@Column(name = "refund_timestamp")
344 
	private LocalDateTime refundTimestamp;
27723 tejbeer 345 
 
21545 ashik.ali 346 
	@Column(name = "purchase_order_id")
21629 kshitij.so 347 
	private Integer purchaseOrderId;
27723 tejbeer 348 
 
349 
	@Column(name = "cod", columnDefinition = "tinyInteger(1) default 0")
21629 kshitij.so 350 
	private Boolean cod;
27723 tejbeer 351 
 
22009 ashik.ali 352 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 353 
	@Column(name = "verification_timestamp")
354 
	private LocalDateTime verificationTimestamp;
27723 tejbeer 355 
 
21629 kshitij.so 356 
	@Column(name = "refunded_by", length = 30)
21545 ashik.ali 357 
	private String refundBy;
27723 tejbeer 358 
 
21545 ashik.ali 359 
	@Column(name = "refund_reason", length = 256)
360 
	private String refundReason;
27723 tejbeer 361 
 
362 
	/*
363 
	 * @Column(name = "delay_reason") private DelayReason delayReason;
364 
	 */
365 
 
22009 ashik.ali 366 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 367 
	@Column(name = "cod_reconciliation_timestamp")
368 
	private LocalDateTime codReconciliationTimestamp;
27723 tejbeer 369 
 
21629 kshitij.so 370 
	private Integer previousStatus;
27723 tejbeer 371 
 
21545 ashik.ali 372 
	@Column(name = "vendorId")
21629 kshitij.so 373 
	private Integer vendorId;
27723 tejbeer 374 
 
21545 ashik.ali 375 
	@Column(name = "delayReasonText", length = 250)
376 
	private String delayReasonText;
27723 tejbeer 377 
 
21545 ashik.ali 378 
	@Column(name = "doa_logistics_provider_id")
21629 kshitij.so 379 
	private Integer doaLogisticsProviderId;
27723 tejbeer 380 
 
381 
	@Column(name = "vendor_paid", columnDefinition = "tinyInteger(1) default 0")
21629 kshitij.so 382 
	private Boolean vendorPaid;
27723 tejbeer 383 
 
22009 ashik.ali 384 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 385 
	@Column(name = "local_connected_timestamp")
386 
	private LocalDateTime localConnectedTimestamp;
27723 tejbeer 387 
 
22009 ashik.ali 388 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 389 
	@Column(name = "reached_destination_timestamp")
390 
	private LocalDateTime reachedDestinationTimestamp;
27723 tejbeer 391 
 
22009 ashik.ali 392 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 393 
	@Column(name = "first_dlvyatmp_timestamp")
394 
	private LocalDateTime firstDlvyatmpTimestamp;
27723 tejbeer 395 
 
21545 ashik.ali 396 
	@Column(name = "originalOrderId")
21629 kshitij.so 397 
	private Integer originalOrderId;
27723 tejbeer 398 
 
21545 ashik.ali 399 
	@Column(name = "fulfilmentWarehouseId")
21629 kshitij.so 400 
	private Integer fulfilmentWarehouseId;
27723 tejbeer 401 
 
21545 ashik.ali 402 
	@Column(name = "orderType")
21629 kshitij.so 403 
	private Integer orderType;
27723 tejbeer 404 
 
21545 ashik.ali 405 
	@Column(name = "pickupStoreId")
21629 kshitij.so 406 
	private Integer pickupStoreId;
27723 tejbeer 407 
 
408 
	@Column(name = "otg", columnDefinition = "tinyInteger(1) default 0")
21629 kshitij.so 409 
	private Boolean otg;
27723 tejbeer 410 
 
22009 ashik.ali 411 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
21545 ashik.ali 412 
	@Column(name = "courier_delivery_time")
413 
	private LocalDateTime courierDeliveryTimestamp;
27723 tejbeer 414 
 
21545 ashik.ali 415 
	@Column(name = "insurer")
21629 kshitij.so 416 
	private Integer insurer;
27723 tejbeer 417 
 
21545 ashik.ali 418 
	@Column(name = "insuranceAmount")
21629 kshitij.so 419 
	private Float insuranceAmount;
27723 tejbeer 420 
 
21545 ashik.ali 421 
	@Column(name = "freebieItemId")
21629 kshitij.so 422 
	private Integer freebieItemId;
27723 tejbeer 423 
 
21545 ashik.ali 424 
	@Column(name = "source")
21629 kshitij.so 425 
	private Integer source;
27723 tejbeer 426 
 
21545 ashik.ali 427 
	@Column(name = "advanceAmount")
21629 kshitij.so 428 
	private Float advanceAmount;
27723 tejbeer 429 
 
21545 ashik.ali 430 
	@Column(name = "storeId")
21629 kshitij.so 431 
	private Integer storeId;
27723 tejbeer 432 
 
21545 ashik.ali 433 
	@Column(name = "productCondition")
21629 kshitij.so 434 
	private Integer productCondition;
27723 tejbeer 435 
 
21545 ashik.ali 436 
	@Column(name = "dataProtectionInsurer")
21629 kshitij.so 437 
	private Integer dataProtectionInsurer;
27723 tejbeer 438 
 
21545 ashik.ali 439 
	@Column(name = "dataProtectionAmount")
21629 kshitij.so 440 
	private Integer dataProtectionAmount;
27723 tejbeer 441 
 
21545 ashik.ali 442 
	@Column(name = "taxType")
21629 kshitij.so 443 
	@Enumerated(EnumType.ORDINAL)
21545 ashik.ali 444 
	private TaxType taxType;
27723 tejbeer 445 
 
21545 ashik.ali 446 
	@Column(name = "logisticsTransactionId", length = 100)
447 
	private String logisticsTransactionId;
27723 tejbeer 448 
 
21545 ashik.ali 449 
	@Column(name = "shippingCost")
21629 kshitij.so 450 
	private Float shippingCost;
27723 tejbeer 451 
 
21545 ashik.ali 452 
	@Column(name = "codCharges")
21629 kshitij.so 453 
	private Float codCharges;
27723 tejbeer 454 
 
21545 ashik.ali 455 
	@Column(name = "wallet_amount")
21629 kshitij.so 456 
	private Float walletAmount;
27723 tejbeer 457 
 
21545 ashik.ali 458 
	@Column(name = "net_payable_amount")
21629 kshitij.so 459 
	private Float netPayableAmount;
27723 tejbeer 460 
 
21545 ashik.ali 461 
	@Column(name = "shippingRefund")
21629 kshitij.so 462 
	private Float shippingRefund;
27723 tejbeer 463 
 
464 
	@ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
28677 amit.gupta 465 
	@JoinColumn(name = "id", insertable = false, updatable = false, nullable = false, referencedColumnName = "order_id")
21653 ashik.ali 466 
	private LineItem lineItem;
27723 tejbeer 467 
 
21629 kshitij.so 468 
	public Integer getId() {
21545 ashik.ali 469 
		return id;
470 
	}
27723 tejbeer 471 
 
21629 kshitij.so 472 
	public void setId(Integer id) {
21545 ashik.ali 473 
		this.id = id;
474 
	}
27723 tejbeer 475 
 
21629 kshitij.so 476 
	public Integer getWarehouseId() {
21545 ashik.ali 477 
		return warehouseId;
478 
	}
27723 tejbeer 479 
 
21629 kshitij.so 480 
	public void setWarehouseId(Integer warehouseId) {
21545 ashik.ali 481 
		this.warehouseId = warehouseId;
482 
	}
27723 tejbeer 483 
 
21629 kshitij.so 484 
	public Integer getSellerId() {
21545 ashik.ali 485 
		return sellerId;
486 
	}
27723 tejbeer 487 
 
21629 kshitij.so 488 
	public void setSellerId(Integer sellerId) {
21545 ashik.ali 489 
		this.sellerId = sellerId;
490 
	}
27723 tejbeer 491 
 
21629 kshitij.so 492 
	public Integer getWarehouseAddressId() {
21545 ashik.ali 493 
		return warehouseAddressId;
494 
	}
27723 tejbeer 495 
 
21629 kshitij.so 496 
	public void setWarehouseAddressId(Integer warehouseAddressId) {
21545 ashik.ali 497 
		this.warehouseAddressId = warehouseAddressId;
498 
	}
27723 tejbeer 499 
 
21629 kshitij.so 500 
	public Integer getLogisticsProviderId() {
21545 ashik.ali 501 
		return logisticsProviderId;
502 
	}
27723 tejbeer 503 
 
21629 kshitij.so 504 
	public void setLogisticsProviderId(Integer logisticsProviderId) {
21545 ashik.ali 505 
		this.logisticsProviderId = logisticsProviderId;
506 
	}
27723 tejbeer 507 
 
21545 ashik.ali 508 
	public String getAirwayBillNumber() {
509 
		return airwayBillNumber;
510 
	}
27723 tejbeer 511 
 
21545 ashik.ali 512 
	public void setAirwayBillNumber(String airwayBillNumber) {
513 
		this.airwayBillNumber = airwayBillNumber;
514 
	}
27723 tejbeer 515 
 
21545 ashik.ali 516 
	public String getTrackingId() {
517 
		return trackingId;
518 
	}
27723 tejbeer 519 
 
21545 ashik.ali 520 
	public void setTrackingId(String trackingId) {
521 
		this.trackingId = trackingId;
522 
	}
27723 tejbeer 523 
 
21545 ashik.ali 524 
	public LocalDateTime getExpectedDeliveryTime() {
525 
		return expectedDeliveryTime;
526 
	}
27723 tejbeer 527 
 
21545 ashik.ali 528 
	public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {
529 
		this.expectedDeliveryTime = expectedDeliveryTime;
530 
	}
27723 tejbeer 531 
 
21545 ashik.ali 532 
	public LocalDateTime getPromisedDeliveryTime() {
533 
		return promisedDeliveryTime;
534 
	}
27723 tejbeer 535 
 
21545 ashik.ali 536 
	public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {
537 
		this.promisedDeliveryTime = promisedDeliveryTime;
538 
	}
27723 tejbeer 539 
 
21545 ashik.ali 540 
	public LocalDateTime getExpectedShippingTime() {
541 
		return expectedShippingTime;
542 
	}
27723 tejbeer 543 
 
21545 ashik.ali 544 
	public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {
545 
		this.expectedShippingTime = expectedShippingTime;
546 
	}
27723 tejbeer 547 
 
21545 ashik.ali 548 
	public LocalDateTime getPromisedShippingTime() {
549 
		return promisedShippingTime;
550 
	}
27723 tejbeer 551 
 
21545 ashik.ali 552 
	public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {
553 
		this.promisedShippingTime = promisedShippingTime;
554 
	}
27723 tejbeer 555 
 
21629 kshitij.so 556 
	public Integer getRetailerId() {
21545 ashik.ali 557 
		return retailerId;
558 
	}
27723 tejbeer 559 
 
21629 kshitij.so 560 
	public void setRetailerId(Integer retailerId) {
21545 ashik.ali 561 
		this.retailerId = retailerId;
562 
	}
27723 tejbeer 563 
 
21545 ashik.ali 564 
	public String getRetailerName() {
565 
		return retailerName;
566 
	}
27723 tejbeer 567 
 
21545 ashik.ali 568 
	public void setRetailerName(String retailerName) {
569 
		this.retailerName = retailerName;
570 
	}
27723 tejbeer 571 
 
21545 ashik.ali 572 
	public String getRetailerMobileNumber() {
573 
		return retailerMobileNumber;
574 
	}
27723 tejbeer 575 
 
21545 ashik.ali 576 
	public void setRetailerMobileNumber(String retailerMobileNumber) {
577 
		this.retailerMobileNumber = retailerMobileNumber;
578 
	}
27723 tejbeer 579 
 
21545 ashik.ali 580 
	public String getRetailerPinCode() {
581 
		return retailerPinCode;
582 
	}
27723 tejbeer 583 
 
21545 ashik.ali 584 
	public void setRetailerPinCode(String retailerPinCode) {
585 
		this.retailerPinCode = retailerPinCode;
586 
	}
27723 tejbeer 587 
 
21545 ashik.ali 588 
	public String getRetailerAddress1() {
589 
		return retailerAddress1;
590 
	}
27723 tejbeer 591 
 
21545 ashik.ali 592 
	public void setRetailerAddress1(String retailerAddress1) {
593 
		this.retailerAddress1 = retailerAddress1;
594 
	}
27723 tejbeer 595 
 
21545 ashik.ali 596 
	public String getRetailerAddress2() {
597 
		return retailerAddress2;
598 
	}
27723 tejbeer 599 
 
21545 ashik.ali 600 
	public void setRetailerAddress2(String retailerAddress2) {
601 
		this.retailerAddress2 = retailerAddress2;
602 
	}
27723 tejbeer 603 
 
21545 ashik.ali 604 
	public String getRetailerCity() {
605 
		return retailerCity;
606 
	}
27723 tejbeer 607 
 
21545 ashik.ali 608 
	public void setRetailerCity(String retailerCity) {
609 
		this.retailerCity = retailerCity;
610 
	}
27723 tejbeer 611 
 
21545 ashik.ali 612 
	public String getRetailerState() {
613 
		return retailerState;
614 
	}
27723 tejbeer 615 
 
21545 ashik.ali 616 
	public void setRetailerState(String retailerState) {
617 
		this.retailerState = retailerState;
618 
	}
27723 tejbeer 619 
 
21545 ashik.ali 620 
	public String getRetailerEmailId() {
621 
		return retailerEmailId;
622 
	}
27723 tejbeer 623 
 
21545 ashik.ali 624 
	public void setRetailerEmailId(String retailerEmailId) {
625 
		this.retailerEmailId = retailerEmailId;
626 
	}
27723 tejbeer 627 
 
21545 ashik.ali 628 
	public OrderStatus getStatus() {
629 
		return status;
630 
	}
27723 tejbeer 631 
 
21545 ashik.ali 632 
	public void setStatus(OrderStatus status) {
633 
		this.status = status;
634 
	}
27723 tejbeer 635 
 
21545 ashik.ali 636 
	public String getStatusDescription() {
637 
		return statusDescription;
638 
	}
27723 tejbeer 639 
 
21545 ashik.ali 640 
	public void setStatusDescription(String statusDescription) {
641 
		this.statusDescription = statusDescription;
642 
	}
27723 tejbeer 643 
 
21629 kshitij.so 644 
	public Float getTotalAmount() {
21545 ashik.ali 645 
		return totalAmount;
646 
	}
27723 tejbeer 647 
 
21629 kshitij.so 648 
	public void setTotalAmount(Float totalAmount) {
21545 ashik.ali 649 
		this.totalAmount = totalAmount;
650 
	}
27723 tejbeer 651 
 
21629 kshitij.so 652 
	public Float getGvAmount() {
21545 ashik.ali 653 
		return gvAmount;
654 
	}
27723 tejbeer 655 
 
21629 kshitij.so 656 
	public void setGvAmount(Float gvAmount) {
21545 ashik.ali 657 
		this.gvAmount = gvAmount;
658 
	}
27723 tejbeer 659 
 
21629 kshitij.so 660 
	public Float getTotalWeight() {
21545 ashik.ali 661 
		return totalWeight;
662 
	}
27723 tejbeer 663 
 
21629 kshitij.so 664 
	public void setTotalWeight(Float totalWeight) {
21545 ashik.ali 665 
		this.totalWeight = totalWeight;
666 
	}
27723 tejbeer 667 
 
21545 ashik.ali 668 
	public String getInvoiceNumber() {
669 
		return invoiceNumber;
670 
	}
27723 tejbeer 671 
 
21545 ashik.ali 672 
	public void setInvoiceNumber(String invoiceNumber) {
673 
		this.invoiceNumber = invoiceNumber;
674 
	}
27723 tejbeer 675 
 
21545 ashik.ali 676 
	public String getBilledBy() {
677 
		return billedBy;
678 
	}
27723 tejbeer 679 
 
21545 ashik.ali 680 
	public void setBilledBy(String billedBy) {
681 
		this.billedBy = billedBy;
682 
	}
27723 tejbeer 683 
 
21545 ashik.ali 684 
	public LocalDateTime getCreateTimestamp() {
685 
		return createTimestamp;
686 
	}
27723 tejbeer 687 
 
21545 ashik.ali 688 
	public void setCreateTimestamp(LocalDateTime createTimestamp) {
689 
		this.createTimestamp = createTimestamp;
690 
	}
27723 tejbeer 691 
 
21545 ashik.ali 692 
	public LocalDateTime getAcceptedTimestamp() {
693 
		return acceptedTimestamp;
694 
	}
27723 tejbeer 695 
 
21545 ashik.ali 696 
	public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {
697 
		this.acceptedTimestamp = acceptedTimestamp;
698 
	}
27723 tejbeer 699 
 
21545 ashik.ali 700 
	public LocalDateTime getBillingTimestamp() {
701 
		return billingTimestamp;
702 
	}
27723 tejbeer 703 
 
21545 ashik.ali 704 
	public void setBillingTimestamp(LocalDateTime billingTimestamp) {
705 
		this.billingTimestamp = billingTimestamp;
706 
	}
27723 tejbeer 707 
 
21545 ashik.ali 708 
	public LocalDateTime getShippingTimestamp() {
709 
		return shippingTimestamp;
710 
	}
27723 tejbeer 711 
 
21545 ashik.ali 712 
	public void setShippingTimestamp(LocalDateTime shippingTimestamp) {
713 
		this.shippingTimestamp = shippingTimestamp;
714 
	}
27723 tejbeer 715 
 
21545 ashik.ali 716 
	public LocalDateTime getPickupTimestamp() {
717 
		return pickupTimestamp;
718 
	}
27723 tejbeer 719 
 
21545 ashik.ali 720 
	public void setPickupTimestamp(LocalDateTime pickupTimestamp) {
721 
		this.pickupTimestamp = pickupTimestamp;
722 
	}
27723 tejbeer 723 
 
21545 ashik.ali 724 
	public LocalDateTime getDeliveryTimestamp() {
725 
		return deliveryTimestamp;
726 
	}
27723 tejbeer 727 
 
21545 ashik.ali 728 
	public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {
729 
		this.deliveryTimestamp = deliveryTimestamp;
730 
	}
27723 tejbeer 731 
 
21545 ashik.ali 732 
	public LocalDateTime getOutOfStockTimestamp() {
733 
		return outOfStockTimestamp;
734 
	}
27723 tejbeer 735 
 
21545 ashik.ali 736 
	public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {
737 
		this.outOfStockTimestamp = outOfStockTimestamp;
738 
	}
27723 tejbeer 739 
 
21629 kshitij.so 740 
	public Integer getTransactionId() {
21545 ashik.ali 741 
		return transactionId;
742 
	}
27723 tejbeer 743 
 
21629 kshitij.so 744 
	public void setTransactionId(Integer transactionId) {
21545 ashik.ali 745 
		this.transactionId = transactionId;
746 
	}
27723 tejbeer 747 
 
748 
	/*
749 
	 * public Integer getJacketNumber() { return jacketNumber; } public void
750 
	 * setJacketNumber(Integer jacketNumber) { this.jacketNumber = jacketNumber; }
751 
	 */
21545 ashik.ali 752 
	public String getReceiver() {
753 
		return receiver;
754 
	}
27723 tejbeer 755 
 
21545 ashik.ali 756 
	public void setReceiver(String receiver) {
757 
		this.receiver = receiver;
758 
	}
27723 tejbeer 759 
 
21629 kshitij.so 760 
	public Integer getBatchNumber() {
21545 ashik.ali 761 
		return batchNumber;
762 
	}
27723 tejbeer 763 
 
21629 kshitij.so 764 
	public void setBatchNumber(Integer batchNumber) {
21545 ashik.ali 765 
		this.batchNumber = batchNumber;
766 
	}
27723 tejbeer 767 
 
21629 kshitij.so 768 
	public Integer getSerialNumber() {
21545 ashik.ali 769 
		return serialNumber;
770 
	}
27723 tejbeer 771 
 
21629 kshitij.so 772 
	public void setSerialNumber(Integer serialNumber) {
21545 ashik.ali 773 
		this.serialNumber = serialNumber;
774 
	}
27723 tejbeer 775 
 
21629 kshitij.so 776 
	public Boolean isDoaFlag() {
21545 ashik.ali 777 
		return doaFlag;
778 
	}
27723 tejbeer 779 
 
21629 kshitij.so 780 
	public void setDoaFlag(Boolean doaFlag) {
21545 ashik.ali 781 
		this.doaFlag = doaFlag;
782 
	}
27723 tejbeer 783 
 
21629 kshitij.so 784 
	public Integer getPickupRequestNumber() {
21545 ashik.ali 785 
		return pickupRequestNumber;
786 
	}
27723 tejbeer 787 
 
21629 kshitij.so 788 
	public void setPickupRequestNumber(Integer pickupRequestNumber) {
21545 ashik.ali 789 
		this.pickupRequestNumber = pickupRequestNumber;
790 
	}
27723 tejbeer 791 
 
21629 kshitij.so 792 
	public Integer getNewOrderId() {
21545 ashik.ali 793 
		return newOrderId;
794 
	}
27723 tejbeer 795 
 
21629 kshitij.so 796 
	public void setNewOrderId(Integer newOrderId) {
21545 ashik.ali 797 
		this.newOrderId = newOrderId;
798 
	}
27723 tejbeer 799 
 
21545 ashik.ali 800 
	public LocalDateTime getDoaAuthTimestamp() {
801 
		return doaAuthTimestamp;
802 
	}
27723 tejbeer 803 
 
21545 ashik.ali 804 
	public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {
805 
		this.doaAuthTimestamp = doaAuthTimestamp;
806 
	}
27723 tejbeer 807 
 
21545 ashik.ali 808 
	public LocalDateTime getDoaPickupTimestamp() {
809 
		return doaPickupTimestamp;
810 
	}
27723 tejbeer 811 
 
21545 ashik.ali 812 
	public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {
813 
		this.doaPickupTimestamp = doaPickupTimestamp;
814 
	}
27723 tejbeer 815 
 
21545 ashik.ali 816 
	public LocalDateTime getReceiverReturnTimestamp() {
817 
		return receiverReturnTimestamp;
818 
	}
27723 tejbeer 819 
 
21545 ashik.ali 820 
	public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {
821 
		this.receiverReturnTimestamp = receiverReturnTimestamp;
822 
	}
27723 tejbeer 823 
 
21545 ashik.ali 824 
	public LocalDateTime getReShipTimestamp() {
825 
		return reShipTimestamp;
826 
	}
27723 tejbeer 827 
 
21545 ashik.ali 828 
	public void setReShipTimestamp(LocalDateTime reShipTimestamp) {
829 
		this.reShipTimestamp = reShipTimestamp;
830 
	}
27723 tejbeer 831 
 
21545 ashik.ali 832 
	public LocalDateTime getRefundTimestamp() {
833 
		return refundTimestamp;
834 
	}
27723 tejbeer 835 
 
21545 ashik.ali 836 
	public void setRefundTimestamp(LocalDateTime refundTimestamp) {
837 
		this.refundTimestamp = refundTimestamp;
838 
	}
27723 tejbeer 839 
 
21629 kshitij.so 840 
	public Integer getPurchaseOrderId() {
21545 ashik.ali 841 
		return purchaseOrderId;
842 
	}
27723 tejbeer 843 
 
21629 kshitij.so 844 
	public void setPurchaseOrderId(Integer purchaseOrderId) {
21545 ashik.ali 845 
		this.purchaseOrderId = purchaseOrderId;
846 
	}
27723 tejbeer 847 
 
21629 kshitij.so 848 
	public Boolean isCod() {
21545 ashik.ali 849 
		return cod;
850 
	}
27723 tejbeer 851 
 
21629 kshitij.so 852 
	public void setCod(Boolean cod) {
21545 ashik.ali 853 
		this.cod = cod;
854 
	}
27723 tejbeer 855 
 
21545 ashik.ali 856 
	public LocalDateTime getVerificationTimestamp() {
857 
		return verificationTimestamp;
858 
	}
27723 tejbeer 859 
 
21545 ashik.ali 860 
	public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {
861 
		this.verificationTimestamp = verificationTimestamp;
862 
	}
27723 tejbeer 863 
 
21545 ashik.ali 864 
	public String getRefundBy() {
865 
		return refundBy;
866 
	}
27723 tejbeer 867 
 
21545 ashik.ali 868 
	public void setRefundBy(String refundBy) {
869 
		this.refundBy = refundBy;
870 
	}
27723 tejbeer 871 
 
21545 ashik.ali 872 
	public String getRefundReason() {
873 
		return refundReason;
874 
	}
27723 tejbeer 875 
 
21545 ashik.ali 876 
	public void setRefundReason(String refundReason) {
877 
		this.refundReason = refundReason;
878 
	}
27723 tejbeer 879 
 
880 
	/*
881 
	 * public DelayReason getDelayReason() { return delayReason; } public void
882 
	 * setDelayReason(DelayReason delayReason) { this.delayReason = delayReason; }
883 
	 */
21545 ashik.ali 884 
	public LocalDateTime getCodReconciliationTimestamp() {
885 
		return codReconciliationTimestamp;
886 
	}
27723 tejbeer 887 
 
21545 ashik.ali 888 
	public void setCodReconciliationTimestamp(LocalDateTime codReconciliationTimestamp) {
889 
		this.codReconciliationTimestamp = codReconciliationTimestamp;
890 
	}
27723 tejbeer 891 
 
21629 kshitij.so 892 
	public Integer getPreviousStatus() {
21545 ashik.ali 893 
		return previousStatus;
894 
	}
27723 tejbeer 895 
 
21629 kshitij.so 896 
	public void setPreviousStatus(Integer previousStatus) {
21545 ashik.ali 897 
		this.previousStatus = previousStatus;
898 
	}
27723 tejbeer 899 
 
21629 kshitij.so 900 
	public Integer getVendorId() {
21545 ashik.ali 901 
		return vendorId;
902 
	}
27723 tejbeer 903 
 
21629 kshitij.so 904 
	public void setVendorId(Integer vendorId) {
21545 ashik.ali 905 
		this.vendorId = vendorId;
906 
	}
27723 tejbeer 907 
 
21545 ashik.ali 908 
	public String getDelayReasonText() {
909 
		return delayReasonText;
910 
	}
27723 tejbeer 911 
 
21545 ashik.ali 912 
	public void setDelayReasonText(String delayReasonText) {
913 
		this.delayReasonText = delayReasonText;
914 
	}
27723 tejbeer 915 
 
21629 kshitij.so 916 
	public Integer getDoaLogisticsProviderId() {
21545 ashik.ali 917 
		return doaLogisticsProviderId;
918 
	}
27723 tejbeer 919 
 
21629 kshitij.so 920 
	public void setDoaLogisticsProviderId(Integer doaLogisticsProviderId) {
21545 ashik.ali 921 
		this.doaLogisticsProviderId = doaLogisticsProviderId;
922 
	}
27723 tejbeer 923 
 
21629 kshitij.so 924 
	public Boolean isVendorPaid() {
21545 ashik.ali 925 
		return vendorPaid;
926 
	}
27723 tejbeer 927 
 
21629 kshitij.so 928 
	public void setVendorPaid(Boolean vendorPaid) {
21545 ashik.ali 929 
		this.vendorPaid = vendorPaid;
930 
	}
27723 tejbeer 931 
 
21545 ashik.ali 932 
	public LocalDateTime getLocalConnectedTimestamp() {
933 
		return localConnectedTimestamp;
934 
	}
27723 tejbeer 935 
 
21545 ashik.ali 936 
	public void setLocalConnectedTimestamp(LocalDateTime localConnectedTimestamp) {
937 
		this.localConnectedTimestamp = localConnectedTimestamp;
938 
	}
27723 tejbeer 939 
 
21545 ashik.ali 940 
	public LocalDateTime getReachedDestinationTimestamp() {
941 
		return reachedDestinationTimestamp;
942 
	}
27723 tejbeer 943 
 
21545 ashik.ali 944 
	public void setReachedDestinationTimestamp(LocalDateTime reachedDestinationTimestamp) {
945 
		this.reachedDestinationTimestamp = reachedDestinationTimestamp;
946 
	}
27723 tejbeer 947 
 
21545 ashik.ali 948 
	public LocalDateTime getFirstDlvyatmpTimestamp() {
949 
		return firstDlvyatmpTimestamp;
950 
	}
27723 tejbeer 951 
 
21545 ashik.ali 952 
	public void setFirstDlvyatmpTimestamp(LocalDateTime firstDlvyatmpTimestamp) {
953 
		this.firstDlvyatmpTimestamp = firstDlvyatmpTimestamp;
954 
	}
27723 tejbeer 955 
 
21629 kshitij.so 956 
	public Integer getOriginalOrderId() {
21545 ashik.ali 957 
		return originalOrderId;
958 
	}
27723 tejbeer 959 
 
21629 kshitij.so 960 
	public void setOriginalOrderId(Integer originalOrderId) {
21545 ashik.ali 961 
		this.originalOrderId = originalOrderId;
962 
	}
27723 tejbeer 963 
 
21629 kshitij.so 964 
	public Integer getFulfilmentWarehouseId() {
21545 ashik.ali 965 
		return fulfilmentWarehouseId;
966 
	}
27723 tejbeer 967 
 
21629 kshitij.so 968 
	public void setFulfilmentWarehouseId(Integer fulfilmentWarehouseId) {
21545 ashik.ali 969 
		this.fulfilmentWarehouseId = fulfilmentWarehouseId;
970 
	}
27723 tejbeer 971 
 
21629 kshitij.so 972 
	public Integer getOrderType() {
21545 ashik.ali 973 
		return orderType;
974 
	}
27723 tejbeer 975 
 
21629 kshitij.so 976 
	public void setOrderType(Integer orderType) {
21545 ashik.ali 977 
		this.orderType = orderType;
978 
	}
27723 tejbeer 979 
 
21629 kshitij.so 980 
	public Integer getPickupStoreId() {
21545 ashik.ali 981 
		return pickupStoreId;
982 
	}
27723 tejbeer 983 
 
21629 kshitij.so 984 
	public void setPickupStoreId(Integer pickupStoreId) {
21545 ashik.ali 985 
		this.pickupStoreId = pickupStoreId;
986 
	}
27723 tejbeer 987 
 
21629 kshitij.so 988 
	public Boolean isOtg() {
21545 ashik.ali 989 
		return otg;
990 
	}
27723 tejbeer 991 
 
21629 kshitij.so 992 
	public void setOtg(Boolean otg) {
21545 ashik.ali 993 
		this.otg = otg;
994 
	}
27723 tejbeer 995 
 
21545 ashik.ali 996 
	public LocalDateTime getCourierDeliveryTimestamp() {
997 
		return courierDeliveryTimestamp;
998 
	}
27723 tejbeer 999 
 
21545 ashik.ali 1000 
	public void setCourierDeliveryTimestamp(LocalDateTime courierDeliveryTimestamp) {
1001 
		this.courierDeliveryTimestamp = courierDeliveryTimestamp;
1002 
	}
27723 tejbeer 1003 
 
21629 kshitij.so 1004 
	public Integer getInsurer() {
21545 ashik.ali 1005 
		return insurer;
1006 
	}
27723 tejbeer 1007 
 
21629 kshitij.so 1008 
	public void setInsurer(Integer insurer) {
21545 ashik.ali 1009 
		this.insurer = insurer;
1010 
	}
27723 tejbeer 1011 
 
21629 kshitij.so 1012 
	public Float getInsuranceAmount() {
21545 ashik.ali 1013 
		return insuranceAmount;
1014 
	}
27723 tejbeer 1015 
 
21629 kshitij.so 1016 
	public void setInsuranceAmount(Float insuranceAmount) {
21545 ashik.ali 1017 
		this.insuranceAmount = insuranceAmount;
1018 
	}
27723 tejbeer 1019 
 
21629 kshitij.so 1020 
	public Integer getFreebieItemId() {
21545 ashik.ali 1021 
		return freebieItemId;
1022 
	}
27723 tejbeer 1023 
 
21629 kshitij.so 1024 
	public void setFreebieItemId(Integer freebieItemId) {
21545 ashik.ali 1025 
		this.freebieItemId = freebieItemId;
1026 
	}
27723 tejbeer 1027 
 
21629 kshitij.so 1028 
	public Integer getSource() {
21545 ashik.ali 1029 
		return source;
1030 
	}
27723 tejbeer 1031 
 
21629 kshitij.so 1032 
	public void setSource(Integer source) {
21545 ashik.ali 1033 
		this.source = source;
1034 
	}
27723 tejbeer 1035 
 
21629 kshitij.so 1036 
	public Float getAdvanceAmount() {
21545 ashik.ali 1037 
		return advanceAmount;
1038 
	}
27723 tejbeer 1039 
 
21629 kshitij.so 1040 
	public void setAdvanceAmount(Float advanceAmount) {
21545 ashik.ali 1041 
		this.advanceAmount = advanceAmount;
1042 
	}
27723 tejbeer 1043 
 
21629 kshitij.so 1044 
	public Integer getStoreId() {
21545 ashik.ali 1045 
		return storeId;
1046 
	}
27723 tejbeer 1047 
 
21629 kshitij.so 1048 
	public void setStoreId(Integer storeId) {
21545 ashik.ali 1049 
		this.storeId = storeId;
1050 
	}
27723 tejbeer 1051 
 
21629 kshitij.so 1052 
	public Integer getProductCondition() {
21545 ashik.ali 1053 
		return productCondition;
1054 
	}
27723 tejbeer 1055 
 
21629 kshitij.so 1056 
	public void setProductCondition(Integer productCondition) {
21545 ashik.ali 1057 
		this.productCondition = productCondition;
1058 
	}
27723 tejbeer 1059 
 
21629 kshitij.so 1060 
	public Integer getDataProtectionInsurer() {
21545 ashik.ali 1061 
		return dataProtectionInsurer;
1062 
	}
27723 tejbeer 1063 
 
21629 kshitij.so 1064 
	public void setDataProtectionInsurer(Integer dataProtectionInsurer) {
21545 ashik.ali 1065 
		this.dataProtectionInsurer = dataProtectionInsurer;
1066 
	}
27723 tejbeer 1067 
 
21629 kshitij.so 1068 
	public Integer getDataProtectionAmount() {
21545 ashik.ali 1069 
		return dataProtectionAmount;
1070 
	}
27723 tejbeer 1071 
 
21629 kshitij.so 1072 
	public void setDataProtectionAmount(Integer dataProtectionAmount) {
21545 ashik.ali 1073 
		this.dataProtectionAmount = dataProtectionAmount;
1074 
	}
27723 tejbeer 1075 
 
21545 ashik.ali 1076 
	public TaxType getTaxType() {
1077 
		return taxType;
1078 
	}
27723 tejbeer 1079 
 
21545 ashik.ali 1080 
	public void setTaxType(TaxType taxType) {
1081 
		this.taxType = taxType;
1082 
	}
27723 tejbeer 1083 
 
21545 ashik.ali 1084 
	public String getLogisticsTransactionId() {
1085 
		return logisticsTransactionId;
1086 
	}
27723 tejbeer 1087 
 
21545 ashik.ali 1088 
	public void setLogisticsTransactionId(String logisticsTransactionId) {
1089 
		this.logisticsTransactionId = logisticsTransactionId;
1090 
	}
27723 tejbeer 1091 
 
21629 kshitij.so 1092 
	public Float getShippingCost() {
21545 ashik.ali 1093 
		return shippingCost;
1094 
	}
27723 tejbeer 1095 
 
21629 kshitij.so 1096 
	public void setShippingCost(Float shippingCost) {
21545 ashik.ali 1097 
		this.shippingCost = shippingCost;
1098 
	}
27723 tejbeer 1099 
 
21629 kshitij.so 1100 
	public Float getCodCharges() {
21545 ashik.ali 1101 
		return codCharges;
1102 
	}
27723 tejbeer 1103 
 
21629 kshitij.so 1104 
	public void setCodCharges(Float codCharges) {
21545 ashik.ali 1105 
		this.codCharges = codCharges;
1106 
	}
27723 tejbeer 1107 
 
21629 kshitij.so 1108 
	public Float getWalletAmount() {
21545 ashik.ali 1109 
		return walletAmount;
1110 
	}
27723 tejbeer 1111 
 
21629 kshitij.so 1112 
	public void setWalletAmount(Float walletAmount) {
21545 ashik.ali 1113 
		this.walletAmount = walletAmount;
1114 
	}
27723 tejbeer 1115 
 
21629 kshitij.so 1116 
	public Float getNetPayableAmount() {
21545 ashik.ali 1117 
		return netPayableAmount;
1118 
	}
27723 tejbeer 1119 
 
21629 kshitij.so 1120 
	public void setNetPayableAmount(Float netPayableAmount) {
21545 ashik.ali 1121 
		this.netPayableAmount = netPayableAmount;
1122 
	}
27723 tejbeer 1123 
 
21629 kshitij.so 1124 
	public Float getShippingRefund() {
21545 ashik.ali 1125 
		return shippingRefund;
1126 
	}
27723 tejbeer 1127 
 
21629 kshitij.so 1128 
	public void setShippingRefund(Float shippingRefund) {
21545 ashik.ali 1129 
		this.shippingRefund = shippingRefund;
1130 
	}
27723 tejbeer 1131 
 
21653 ashik.ali 1132 
	public LineItem getLineItem() {
1133 
		return lineItem;
1134 
	}
27723 tejbeer 1135 
 
21653 ashik.ali 1136 
	public void setLineItem(LineItem lineItem) {
1137 
		this.lineItem = lineItem;
1138 
	}
27723 tejbeer 1139 
 
1140 
	public String getFormattedDate() {
1141 
		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");
23075 ashik.ali 1142 
		return this.createTimestamp.format(formatter);
27723 tejbeer 1143 
	}
1144 
 
21545 ashik.ali 1145 
	@Override
21924 ashik.ali 1146 
	public int hashCode() {
1147 
		final int prime = 31;
1148 
		int result = 1;
1149 
		result = prime * result + ((id == null) ? 0 : id.hashCode());
1150 
		return result;
1151 
	}
27723 tejbeer 1152 
 
21924 ashik.ali 1153 
	@Override
1154 
	public boolean equals(Object obj) {
1155 
		if (this == obj)
1156 
			return true;
1157 
		if (obj == null)
1158 
			return false;
1159 
		if (getClass() != obj.getClass())
1160 
			return false;
1161 
		Order other = (Order) obj;
1162 
		if (id == null) {
1163 
			if (other.id != null)
1164 
				return false;
1165 
		} else if (!id.equals(other.id))
1166 
			return false;
1167 
		return true;
1168 
	}
27723 tejbeer 1169 
 
21924 ashik.ali 1170 
	@Override
21545 ashik.ali 1171 
	public String toString() {
1172 
		return "Order [id=" + id + ", warehouseId=" + warehouseId + ", sellerId=" + sellerId + ", warehouseAddressId="
1173 
				+ warehouseAddressId + ", logisticsProviderId=" + logisticsProviderId + ", airwayBillNumber="
1174 
				+ airwayBillNumber + ", trackingId=" + trackingId + ", expectedDeliveryTime=" + expectedDeliveryTime
1175 
				+ ", promisedDeliveryTime=" + promisedDeliveryTime + ", expectedShippingTime=" + expectedShippingTime
27723 tejbeer 1176 
				+ ", promisedShippingTime=" + promisedShippingTime + ", partnerPurchaseTimestamp=" + partnerGrnTimestamp
1177 
				+ ", retailerId=" + retailerId + ", retailerName=" + retailerName + ", retailerMobileNumber="
1178 
				+ retailerMobileNumber + ", retailerPinCode=" + retailerPinCode + ", retailerAddress1="
1179 
				+ retailerAddress1 + ", retailerAddress2=" + retailerAddress2 + ", retailerCity=" + retailerCity
1180 
				+ ", retailerState=" + retailerState + ", retailerEmailId=" + retailerEmailId + ", status=" + status
1181 
				+ ", statusDescription=" + statusDescription + ", totalAmount=" + totalAmount + ", gvAmount=" + gvAmount
1182 
				+ ", totalWeight=" + totalWeight + ", invoiceNumber=" + invoiceNumber + ", billedBy=" + billedBy
1183 
				+ ", createTimestamp=" + createTimestamp + ", acceptedTimestamp=" + acceptedTimestamp
1184 
				+ ", billingTimestamp=" + billingTimestamp + ", shippingTimestamp=" + shippingTimestamp
1185 
				+ ", pickupTimestamp=" + pickupTimestamp + ", deliveryTimestamp=" + deliveryTimestamp
1186 
				+ ", outOfStockTimestamp=" + outOfStockTimestamp + ", transactionId=" + transactionId + ", receiver="
1187 
				+ receiver + ", batchNumber=" + batchNumber + ", serialNumber=" + serialNumber + ", doaFlag=" + doaFlag
1188 
				+ ", pickupRequestNumber=" + pickupRequestNumber + ", newOrderId=" + newOrderId + ", doaAuthTimestamp="
1189 
				+ doaAuthTimestamp + ", doaPickupTimestamp=" + doaPickupTimestamp + ", receiverReturnTimestamp="
1190 
				+ receiverReturnTimestamp + ", reShipTimestamp=" + reShipTimestamp + ", refundTimestamp="
1191 
				+ refundTimestamp + ", purchaseOrderId=" + purchaseOrderId + ", cod=" + cod + ", verificationTimestamp="
1192 
				+ verificationTimestamp + ", refundBy=" + refundBy + ", refundReason=" + refundReason
1193 
				+ ", codReconciliationTimestamp=" + codReconciliationTimestamp + ", previousStatus=" + previousStatus
1194 
				+ ", vendorId=" + vendorId + ", delayReasonText=" + delayReasonText + ", doaLogisticsProviderId="
1195 
				+ doaLogisticsProviderId + ", vendorPaid=" + vendorPaid + ", localConnectedTimestamp="
1196 
				+ localConnectedTimestamp + ", reachedDestinationTimestamp=" + reachedDestinationTimestamp
1197 
				+ ", firstDlvyatmpTimestamp=" + firstDlvyatmpTimestamp + ", originalOrderId=" + originalOrderId
1198 
				+ ", fulfilmentWarehouseId=" + fulfilmentWarehouseId + ", orderType=" + orderType + ", pickupStoreId="
1199 
				+ pickupStoreId + ", otg=" + otg + ", courierDeliveryTimestamp=" + courierDeliveryTimestamp
1200 
				+ ", insurer=" + insurer + ", insuranceAmount=" + insuranceAmount + ", freebieItemId=" + freebieItemId
1201 
				+ ", source=" + source + ", advanceAmount=" + advanceAmount + ", storeId=" + storeId
1202 
				+ ", productCondition=" + productCondition + ", dataProtectionInsurer=" + dataProtectionInsurer
1203 
				+ ", dataProtectionAmount=" + dataProtectionAmount + ", taxType=" + taxType
1204 
				+ ", logisticsTransactionId=" + logisticsTransactionId + ", shippingCost=" + shippingCost
1205 
				+ ", codCharges=" + codCharges + ", walletAmount=" + walletAmount + ", netPayableAmount="
23884 amit.gupta 1206 
				+ netPayableAmount + ", shippingRefund=" + shippingRefund + ", lineItem=" + lineItem + "]";
21545 ashik.ali 1207 
	}
27723 tejbeer 1208 
 
21545 ashik.ali 1209 
}