Subversion Repositories SmartDukaan

Rev

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