Subversion Repositories SmartDukaan

Rev

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