Subversion Repositories SmartDukaan

@Table(name = "transaction.`order`", schema = "transaction")

@Table(name = "transaction.`order`")

@NamedQueries({ @NamedQuery(name = "Order.selectAll", query = "select o from Order o"),

@NamedQueries({@NamedQuery(name = "Order.selectAll", query = "select o from Order o"), @NamedQuery(name = "Order.selectById", query = "select o from Order o where o.id= :id"), @NamedQuery(name = "Order.selectByTransactionId", query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, " + "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, " + "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name,  o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id " + "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),

		@NamedQuery(name = "Order.selectById", query = "select o from Order o where o.id= :id"),

		@NamedQuery(name = "Order.selectByTransactionId", query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "

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

				+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "

				+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name,  o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id "

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

				+ "join LineItem li on li.orderId = o.id left join Provider p on p.id = o.logisticsProviderId join Item i on i.id=li.itemId where o.transactionId = :transactionId"),

        @NamedQuery(name = "Order.selectAllBilledOrderGroupByBrandFofoId", query = "select new com.spice.profitmandi.dao.model.BrandWiseModel(li.brand," + "	DATE_FORMAT(o.billingTimestamp, '%m-%Y'),sum(cast(o.totalAmount AS integer)))" + "	 from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)" + "	and o.billingTimestamp >= :startDate and o.retailerId =:fofoId  group by li.brand,DATE_FORMAT(o.billingTimestamp, '%m-%Y')"),

		@NamedQuery(name = "Order.selectItemIdTypeQuantity", query = "select new com.spice.profitmandi.dao.model.ItemIdTypeQuantity(li.itemId, i.type, li.quantity) from Order o join LineItem li on li.orderId = o.id join Item i on i.id = li.itemId where o.invoiceNumber = :invoiceNumber and o.retailerId = :retailerId"),

        @NamedQuery(name = "Order.selectSecondaryGroupByYearMonth", query = "select new com.spice.profitmandi.dao.model.PartnerMonthlySaleModel(o.retailerId," + "	DATE_FORMAT(o.billingTimestamp, '%m-%Y'),sum(cast(o.totalAmount AS integer)))" + "	 from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)" + "	and o.billingTimestamp >= :startDate and o.retailerId in:fofoIds  group by o.retailerId, DATE_FORMAT(o.billingTimestamp, '%m-%Y')"),

		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderBillingModel(li.brand, "

				+ "sum(case when o.billingTimestamp >= :today then CAST(o.totalAmount  AS integer) else 0 end),"

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

				+ "sum(case when o.billingTimestamp >= :threedays  and o.billingTimestamp < :endDate  then CAST(o.totalAmount  AS integer) else 0 end),"

				+ "sum(case when concat(year(o.billingTimestamp ), month(o.billingTimestamp ))= :mtd  then CAST(o.totalAmount AS integer) else 0 end),"

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

				+ "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(o.totalAmount  AS integer) else 0 end),"

				+ "sum(case when o.billingTimestamp between  :lmtdStartDate and :lmsEndDate  then CAST(o.totalAmount  AS integer) else 0 end),"

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

				+ "	sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"

				+ "	sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"

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

				+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd  then li.quantity else 0 end),"

				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end),"

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

				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmsEndDate  then li.quantity else 0 end)"

				+ " )"

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

				+ "	 from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"

				+ "	and o.billingTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId and fs.internal = false group by li.brand"),

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

		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrandFofoId", query = "select new com.spice.profitmandi.dao.model.BrandWiseModel(li.brand,"

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

				+ "	DATE_FORMAT(o.billingTimestamp, '%m-%Y'),sum(cast(o.totalAmount AS integer)))"

				+ "	 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)"

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

				+ "	and o.billingTimestamp >= :startDate and o.retailerId =:fofoId  group by li.brand,DATE_FORMAT(o.billingTimestamp, '%m-%Y')"),

        @NamedQuery(name = "Order.selectFirstBilling", query = "select new com.spice.profitmandi.dao.model.FofoFirstBillingModel(fs.id, min(o.billingTimestamp) )" + "	from FofoStore fs  join  Order o on fs.id = o.retailerId  group by fs.id"),

		@NamedQuery(name = "Order.selectSecondaryGroupByYearMonth", query = "select new com.spice.profitmandi.dao.model.PartnerMonthlySaleModel(o.retailerId,"

				+ "	DATE_FORMAT(o.billingTimestamp, '%m-%Y'),sum(cast(o.totalAmount AS integer)))"

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

				+ "	 from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"

				+ "	and o.billingTimestamp >= :startDate and o.retailerId in:fofoIds  group by o.retailerId, DATE_FORMAT(o.billingTimestamp, '%m-%Y')"),

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

		@NamedQuery(name = "Order.selectAllBilledOrderGroupByBrandWarehouse", query = "select new com.spice.profitmandi.dao.model.SecondaryWarehouseWiseOrderBilllingModel(fs.warehouseId,date(o.billingTimestamp), li.brand, "

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

				+ "sum(CAST(o.totalAmount  AS integer)),sum( li.quantity))"

				+ "	 from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"

        @NamedQuery(name = "Order.selectAllPendingIndentOrderItemByCatalogIdFofoId", query = "select new com.spice.profitmandi.dao.model.FofoIdItemDetailModel(" + "   fs.warehouseId, fs.id, sum(li.quantity), i.brand, i.modelName, i.modelNumber, i.catalogItemId)" + "	 from FofoStore fs  join  Order o on fs.id = o.retailerId" + "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId " + "  join Item i on i.id = tl.itemId  where " + "	 fs.active = true and fs.internal = false 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"),

				+ "	and o.billingTimestamp >= :startDate and  o.billingTimestamp < :endDate and (null is :brand or li.brand = :brand) and fs.internal = 0 group by fs.warehouseId, date(o.billingTimestamp), li.brand"),

        @NamedQuery(name = "Order.selectGroupByBrandLmp", query = "select new com.spice.profitmandi.dao.model.BrandWiseModel(li.brand," + " DATE_FORMAT(o.billingTimestamp,:groupParameter ),sum(cast(o.totalAmount AS integer)))" + "	 from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)" + "	and (o.billingTimestamp between :lmsStartDate and :endDate) and fs.id in :fofoId and fs.warehouseId in :warehouseId and fs.internal = false group by li.brand,DATE_FORMAT(o.billingTimestamp, :groupParameter)"),

		@NamedQuery(name = "Order.selectAllBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "

				+ " i.modelNumber, i.color," + "o.totalAmount," + "	 li.quantity)"

        @NamedQuery(name = "Order.selectGrnPendingOrderQtyByCatalogId", query = "select sum(case when li.quantity is null then 0 else  li.quantity end)" + "  from FofoStore fs join  Order o on fs.id = o.retailerId " + "  join LineItem li on o.id = li.orderId  join TagListing tl on tl.itemId = li.itemId " + "  join Item i on (i.id = tl.itemId ) where  fs.active = true and fs.internal = false and" + "  o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null" + "  and i.catalogItemId = :catalogItemId and fs.id = :fofoId group by i.catalogItemId, fs.id"),

				+ "	 from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"

				+ "	and date(o.billingTimestamp) in :date and fs.warehouseId in :warehouseId and li.brand = :brand and fs.internal = false order by li.itemId desc"),

        @NamedQuery(name = "Order.selectPendingIndentOrderQtyByCatalogId", query = "select sum(case when li.quantity is null then 0 else  li.quantity end)" + "	 from FofoStore fs  join  Order o on fs.id = o.retailerId" + "  join LineItem li on o.id = li.orderId " + "  join TagListing tl on tl.itemId = li.itemId " + "  join Item i on i.id = tl.itemId  where " + "	 fs.active = true and fs.internal = false and o.status in (3,4)and i.catalogItemId = :catalogItemId and fs.id = :fofoId group by i.catalogItemId, fs.id"),

		@NamedQuery(name = "Order.selectTodayBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "

        @NamedQuery(name = "Order.selectTodayOrders", query = "select new com.spice.profitmandi.dao.model.BrandRegionPOModel(" + " case when (pr.regionId is not null) then pr.regionId else fs.warehouseId end  , li.brand, " + " sum(case when (o.createTimestamp between :startDate and :endDate) then cast(o.totalAmount AS integer ) else 0 end)," + " sum(case when (o.billingTimestamp is not null and (o.createTimestamp between :startDate and :endDate)) then cast(o.totalAmount AS integer) else 0 end)," + " sum(case when o.billingTimestamp is not null then cast(o.totalAmount AS integer ) else 0 end))" + "	from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId" + " left join PartnerRegion pr on pr.fofoId=o.retailerId and pr.regionId=18" + " where o.refundTimestamp is null and ((o.createTimestamp between :startDate and :endDate) or (o.billingTimestamp between :startDate and :endDate)) and fs.internal = false and li.brand not in ('Smartdukaan','Dummy')" + " group by case when (pr.regionId is not null) then pr.regionId else fs.warehouseId end, li.brand"),

				+ " i.modelNumber, i.color," + "o.totalAmount," + "	 li.quantity)"

				+ "	 from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId join FofoStore fs on fs.id = o.retailerId where o.status in (7,9,10,12)"

        @NamedQuery(name = "Order.selectAllPendingIndentAccessoriesTvGroupByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockAccessoriesTvFofoIdModel(" + "  o.retailerId, SUM(case when c.parentCategoryId  = 10011 then CAST(o.totalAmount  AS integer) else 0 end), SUM(case when c.parentCategoryId  = 14200 then  CAST(o.totalAmount  AS integer) else 0 end))" + "	 from  Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId  join Category c on c.id = i.categoryId " + "  where o.retailerId in :fofoIds and o.status in (3,4) and i.categoryId != 10006 group by o.retailerId"),

				+ "	and o.billingTimestamp >= :startDate and fs.warehouseId in :warehouseId and li.brand in :brand order by li.itemId desc"),

        @NamedQuery(name = "Order.selectAllGrnPendingAccessoriesTvGroupByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockAccessoriesTvFofoIdModel(" + "  o.retailerId, SUM(case when c.parentCategoryId  = 10011 then CAST(o.totalAmount  AS integer) else 0 end), SUM(case when c.parentCategoryId  = 14200 then  CAST(o.totalAmount  AS integer) else 0 end))" + "	 from  Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId  join Category c on c.id = i.categoryId " + "  where o.retailerId in :fofoIds and o.billingTimestamp is not null and o.refundTimestamp is null and o.partnerGrnTimestamp is null and i.categoryId != 10006 group by o.retailerId"),

		@NamedQuery(name = "Order.selectAllBilledOrderBrandByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockBrandModel(li.brand,"

				+ "	 Sum(li.quantity),Sum(CAST(o.totalAmount AS integer)))"

        @NamedQuery(name = "Order.selectPartnersBilledBetweenDates", query = "select new com.spice.profitmandi.dao.model.PartnerSecondaryModel(fs.warehouseId, fs.id, count(o.id), sum(o.totalAmount) )" + " from FofoStore fs left join Order o on (fs.id=o.retailerId and o.billingTimestamp between :startDate and :endDate " + " and o.refundTimestamp is null) where" + " fs.internal = false and (fs.active= true or o.retailerId is not null)  group by fs.warehouseId, fs.id"),

				+ "	 from Order o join LineItem li on o.id = li.orderId where o.status in (7,9,10,12)"

				+ "	and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate and o.retailerId = :fofoId group by li.brand"),

        @NamedQuery(name = "Order.selectCollectionSummary", query = "select new com.spice.profitmandi.dao.model.CollectionSummary(pot.createTimestamp, " + "  pot.referenceType,sum(case when po.name = 'CASH' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'PINELABS' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'BAJAJ FINSERV' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'HOME CREDIT' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'PAYTM' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'CAPITAL FIRST' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'ZEST MONEY' then cast(pot.amount As int) else 0 end)," + "  sum(case when po.name = 'SAMSUNG SURE' then cast(pot.amount As int) else 0 end),sum(cast(pot.amount As int)))" + "	 from PaymentOptionTransaction pot join PaymentOption po on pot.paymentOptionId=po.id join com.spice.profitmandi.dao.entity.user.User u on u.id=pot.fofoId" + "	 join Address a on a.id=u.addressId where 1=1 and  pot.fofoId = :fofoId and pot.createTimestamp between :startDate and :endDate " + "  group by (pot.createTimestamp), pot.referenceType "),

		@NamedQuery(name = "Order.selectAllBilledOrderBrandItemByFofoId", query = "select new com.spice.profitmandi.dao.model.InStockBrandItemModel("

				+ " i.brand, i.modelName, i.modelNumber, i.color,Sum(li.quantity), Sum(CAST(o.totalAmount AS integer)))"

        @NamedQuery(name = "Order.getLastOrderByFofoId", query = "select o.id from  Order o where  o.retailerId = :fofoId and o.status in (7,9,10,12) and o.deliveryTimestamp != null order by o.id desc"),

				+ "	 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)"

				+ "where date(o.created_timestamp) between :startDate and :endDate  and o.status = 12 and i.hsnCode = '85171300' and i.brand != 'Live Demo'"

        @NamedNativeQuery(name = "Order.selectAllOrderWeight", query = "select i.catalog_item_id from transaction.`order` o join transaction.lineitem li on o.id = li.order_id " + "join catalog.item i on i.id = li.item_id   " + "where date(o.created_timestamp) between :startDate and :endDate  and o.status = 12 and i.hsnCode = '85171300' and i.brand != 'Live Demo'" + " group by i.catalog_item_id order by  sum((datediff(now(),o.created_timestamp)/30)*li.quantity) desc"),

				+ "fofo.fofo_store fs left join (select o.customer_id , li.brand as sb, li.total_price, psp.fofo_id , psp.brand, psp.secondary_plan,psp.auth_id,psp.commited_timestamp from transaction.`order` o join transaction.lineitem li on "

        @NamedNativeQuery(name = "selectPartnerSecondaryGroupByBrand", query = "select ifnull(a.customer_id,fs.id) as id,ifnull(a.sb,brand) as brand,a.secondary_plan,sum(a.total_price) as total_price,a.auth_id, a.commited_timestamp from " + "fofo.fofo_store fs left join (select o.customer_id , li.brand as sb, li.total_price, psp.fofo_id , psp.brand, psp.secondary_plan,psp.auth_id,psp.commited_timestamp from transaction.`order` o join transaction.lineitem li on " + "(o.id = li.order_id) left join  auth.partner_secondary_plan psp on (psp.fofo_id = o.customer_id  and date(psp.commited_timestamp) >= :startDate and " + "psp.active = 1 and psp.brand = li.brand ) where o.customer_id in :fofoIds and  o.status in (7,9,10,12) and date(o.billing_timestamp) = :startDate" + " union select if(li.brand is null, null, o.customer_id) as customer_id, li.brand as sb, li.total_price, psp.fofo_id , psp.brand, psp.secondary_plan,psp.auth_id, psp.commited_timestamp " + " from auth.partner_secondary_plan psp  left join transaction.`order` o on (psp.fofo_id = o.customer_id and o.status in (7,9,10,12) and date(o.billing_timestamp) = :startDate) " + "left join transaction.lineitem li on  (o.id = li.order_id and psp.brand=li.brand) where psp.fofo_id in :fofoIds and date(psp.commited_timestamp) >= :startDate " + "and psp.active = 1) a on fs.id = a.customer_id or fs.id = a.fofo_id where fs.id in :fofoIds group by id,brand;", resultSetMapping = "partnerSecondaryPlanModel"),

				+ " ci on ci.catalog_item_id=pd.catalog_id join fofo.fofo_store fs on fs.id=pdi.retailer_id where  pdi.retailer_id = :fofoId and pd.affected_on between :startDate and :endDate and pd.amount > 0;", resultSetMapping = "PriceDropReportModel")

        @NamedNativeQuery(name = "selectPriceDropReport", query = "select fs.code, pd.id, ci.brand,ci.model_name," + " ci.model_number,pd.affected_on, pd.amount, pd.partner_payout, pdi.imei, pdi.status, pdi.update_timestamp, pdi.rejection_reason" + " from transaction.price_drop pd join transaction.price_drop_imei pdi on pdi.price_drop_id = pd.id join (select catalog_item_id, brand, model_name, model_number from catalog.item group by catalog_item_id )" + " ci on ci.catalog_item_id=pd.catalog_id join fofo.fofo_store fs on fs.id=pdi.retailer_id where  pdi.retailer_id = :fofoId and pd.affected_on between :startDate and :endDate and pd.amount > 0;", resultSetMapping = "PriceDropReportModel"),

						@ColumnResult(name = "secondary_plan", type = Long.class),

        @SqlResultSetMapping(name = "partnerSecondaryPlanModel", classes = {@ConstructorResult(targetClass = PartnerSecondaryPlanModel.class, columns = {@ColumnResult(name = "id", type = Integer.class), @ColumnResult(name = "brand", type = String.class), @ColumnResult(name = "secondary_plan", type = Long.class), @ColumnResult(name = "total_price", type = Long.class), @ColumnResult(name = "auth_id", type = Integer.class), @ColumnResult(name = "commited_timestamp", type = LocalDateTime.class)})}),

						@ColumnResult(name = "update_timestamp", type = LocalDateTime.class),

        @SqlResultSetMapping(name = "PriceDropReportModel", classes = {@ConstructorResult(targetClass = PriceDropReportModel.class, columns = {@ColumnResult(name = "code", type = String.class), @ColumnResult(name = "id", type = Integer.class), @ColumnResult(name = "brand", type = String.class), @ColumnResult(name = "model_name", type = String.class), @ColumnResult(name = "model_number", type = String.class), @ColumnResult(name = "affected_on", type = LocalDateTime.class), @ColumnResult(name = "amount", type = Float.class), @ColumnResult(name = "partner_payout", type = Float.class), @ColumnResult(name = "imei", type = String.class), @ColumnResult(name = "status", type = String.class), @ColumnResult(name = "update_timestamp", type = LocalDateTime.class), @ColumnResult(name = "rejection_reason", type = String.class),})})

	private static final long serialVersionUID = 1L;

    private static final long serialVersionUID = 1L;

	@Id

    @Id

	@Column(name = "id", unique = true, updatable = false)

    @Column(name = "id", unique = true, updatable = false)

	@GeneratedValue(strategy = GenerationType.IDENTITY)

    @GeneratedValue(strategy = GenerationType.IDENTITY)

	private Integer id;

    private Integer id;

	@Column(name = "warehouse_id")

    @Column(name = "warehouse_id")

	private Integer warehouseId;

    private Integer warehouseId;

	@Column(name = "seller_id")

    @Column(name = "seller_id")

	private Integer sellerId;

    private Integer sellerId;

	@Column(name = "warehouse_address_id")

    @Column(name = "warehouse_address_id")

	private Integer warehouseAddressId;

    private Integer warehouseAddressId;

	@Column(name = "logistics_provider_id")

    @Column(name = "logistics_provider_id")

	private Integer logisticsProviderId;

    private Integer logisticsProviderId;

	@Column(name = "airwaybill_no", length = 50)

    @Column(name = "airwaybill_no", length = 50)

	private String airwayBillNumber;

    private String airwayBillNumber;

	@Column(name = "tracking_id", length = 50)

    @Column(name = "tracking_id", length = 50)

	private String trackingId;

    private String trackingId;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "expected_delivery_time")

    @Column(name = "expected_delivery_time")

	private LocalDateTime expectedDeliveryTime;

    private LocalDateTime expectedDeliveryTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "promised_delivery_time")

    @Column(name = "promised_delivery_time")

	private LocalDateTime promisedDeliveryTime;

    private LocalDateTime promisedDeliveryTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "expected_shipping_time")

    @Column(name = "expected_shipping_time")

	private LocalDateTime expectedShippingTime;

    private LocalDateTime expectedShippingTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "promised_shipping_time")

    @Column(name = "promised_shipping_time")

	private LocalDateTime promisedShippingTime;

    private LocalDateTime promisedShippingTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "partner_grn_timestamp")

    @Column(name = "partner_grn_timestamp")

	private LocalDateTime partnerGrnTimestamp;

    private LocalDateTime partnerGrnTimestamp;

	@Transient

    @Transient

	private List<String> returnedImeis;

    private List<String> returnedImeis;

	@Column(name = "customer_id")

    @Column(name = "customer_id")

	private Integer retailerId;

    private Integer retailerId;

	@Column(name = "customer_name", length = 50)

    @Column(name = "customer_name", length = 50)

	private String retailerName;

    private String retailerName;

	@Column(name = "customer_mobilenumber", length = 20)

    @Column(name = "customer_mobilenumber", length = 20)

	private String retailerMobileNumber;

    private String retailerMobileNumber;

	@Column(name = "customer_pincode", length = 10)

    @Column(name = "customer_pincode", length = 10)

	private String retailerPinCode;

    private String retailerPinCode;

	@Column(name = "customer_address1", length = 100)

    @Column(name = "customer_address1", length = 100)

	private String retailerAddress1;

    private String retailerAddress1;

	@Column(name = "customer_address2", length = 100)

    @Column(name = "customer_address2", length = 100)

	private String retailerAddress2;

    private String retailerAddress2;

	@Column(name = "customer_city", length = 100)

    @Column(name = "customer_city", length = 100)

	private String retailerCity;

    private String retailerCity;

	@Column(name = "customer_state", length = 100)

    @Column(name = "customer_state", length = 100)

	private String retailerState;

    private String retailerState;

	@Column(name = "customer_email", length = 50)

    @Column(name = "customer_email", length = 50)

	private String retailerEmailId;

    private String retailerEmailId;

	@Column(name = "status")

    @Column(name = "status")

	@Enumerated(EnumType.ORDINAL)

    @Enumerated(EnumType.ORDINAL)

	private OrderStatus status;

    private OrderStatus status;

	@Column(name = "statusDescription", length = 50)

    @Column(name = "statusDescription", length = 50)

	private String statusDescription;

    private String statusDescription;

	@Column(name = "total_amount")

    @Column(name = "total_amount")

	private Float totalAmount;

    private Float totalAmount;

	@Column(name = "gvAmount")

    @Column(name = "gvAmount")

	private Float gvAmount;

    private Float gvAmount;

	@Column(name = "total_weight")

    @Column(name = "total_weight")

	private Float totalWeight;

    private Float totalWeight;

	@Column(name = "invoice_number", length = 30)

    @Column(name = "invoice_number", length = 30)

	private String invoiceNumber;

    private String invoiceNumber;

	@Column(name = "billed_by", length = 30)

    @Column(name = "billed_by", length = 30)

	private String billedBy;

    private String billedBy;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "created_timestamp")

    @Column(name = "created_timestamp")

	private LocalDateTime createTimestamp;

    private LocalDateTime createTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "accepted_timestamp")

    @Column(name = "accepted_timestamp")

	private LocalDateTime acceptedTimestamp;

    private LocalDateTime acceptedTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "billing_timestamp")

    @Column(name = "billing_timestamp")

	private LocalDateTime billingTimestamp;

    private LocalDateTime billingTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "shipping_timestamp")

    @Column(name = "shipping_timestamp")

	private LocalDateTime shippingTimestamp;

    private LocalDateTime shippingTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "pickup_timestamp")

    @Column(name = "pickup_timestamp")

	private LocalDateTime pickupTimestamp;

    private LocalDateTime pickupTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "delivery_timestamp")

    @Column(name = "delivery_timestamp")

	private LocalDateTime deliveryTimestamp;

    private LocalDateTime deliveryTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "outofstock_timestamp")

    @Column(name = "outofstock_timestamp")

	private LocalDateTime outOfStockTimestamp;

    private LocalDateTime outOfStockTimestamp;

	@Column(name = "transaction_id")

    @Column(name = "transaction_id")

	private Integer transactionId;

    private Integer transactionId;

	@Column(name = "receiver", length = 50)

    @Column(name = "receiver", length = 50)

	private String receiver;

    private String receiver;

	@Column(name = "batchNo")

    @Column(name = "batchNo")

	private Integer batchNumber;

    private Integer batchNumber;

	@Column(name = "serialNo")

    @Column(name = "serialNo")

	private Integer serialNumber;

    private Integer serialNumber;

	@Column(name = "doaFlag", columnDefinition = "tinyInteger(1) default 0")

    @Column(name = "doaFlag", columnDefinition = "tinyInteger(1) default 0")

	private Boolean doaFlag;

    private Boolean doaFlag;

	@Column(name = "pickupRequestNo")

    @Column(name = "pickupRequestNo")

	private Integer pickupRequestNumber;

    private Integer pickupRequestNumber;

	/*

    /*

	 * @Column(name = "jacket_number", length = 10) private Integer jacketNumber;

     * @Column(name = "jacket_number", length = 10) private Integer jacketNumber;

	 */

     */

	@Column(name = "new_order_id")

    @Column(name = "new_order_id")

	private Integer newOrderId;

    private Integer newOrderId;

	@Column(name = "doa_auth_timestamp")

    @Column(name = "doa_auth_timestamp")

	private LocalDateTime doaAuthTimestamp;

    private LocalDateTime doaAuthTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "doa_pickup_timestamp")

    @Column(name = "doa_pickup_timestamp")

	private LocalDateTime doaPickupTimestamp;

    private LocalDateTime doaPickupTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "received_return_timestamp")

    @Column(name = "received_return_timestamp")

	private LocalDateTime receiverReturnTimestamp;

    private LocalDateTime receiverReturnTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "reship_timestamp")

    @Column(name = "reship_timestamp")

	private LocalDateTime reShipTimestamp;

    private LocalDateTime reShipTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "refund_timestamp")

    @Column(name = "refund_timestamp")

	private LocalDateTime refundTimestamp;

    private LocalDateTime refundTimestamp;

	@Column(name = "purchase_order_id")

    @Column(name = "purchase_order_id")

	private Integer purchaseOrderId;

    private Integer purchaseOrderId;

	@Column(name = "cod", columnDefinition = "tinyInteger(1) default 0")

    @Column(name = "cod", columnDefinition = "tinyInteger(1) default 0")

	private Boolean cod;

    private Boolean cod;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "verification_timestamp")

    @Column(name = "verification_timestamp")

	private LocalDateTime verificationTimestamp;

    private LocalDateTime verificationTimestamp;

	@Column(name = "refunded_by", length = 30)

    @Column(name = "refunded_by", length = 30)

	private String refundBy;

    private String refundBy;

	@Column(name = "refund_reason", length = 256)

    @Column(name = "refund_reason", length = 256)

	private String refundReason;

    private String refundReason;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "cod_reconciliation_timestamp")

    @Column(name = "cod_reconciliation_timestamp")

	private LocalDateTime codReconciliationTimestamp;

    private LocalDateTime codReconciliationTimestamp;

	private Integer previousStatus;

    private Integer previousStatus;

	@Column(name = "vendorId")

    @Column(name = "vendorId")

	private Integer vendorId;

    private Integer vendorId;

	@Column(name = "delayReasonText", length = 250)

    @Column(name = "delayReasonText", length = 250)

	private String delayReasonText;

    private String delayReasonText;

	@Column(name = "doa_logistics_provider_id")

    @Column(name = "doa_logistics_provider_id")

	private Integer doaLogisticsProviderId;

    private Integer doaLogisticsProviderId;

	/*

    /*

	 * @Column(name = "delay_reason") private DelayReason delayReason;

     * @Column(name = "delay_reason") private DelayReason delayReason;

	 */

     */

	@Column(name = "vendor_paid", columnDefinition = "tinyInteger(1) default 0")

    @Column(name = "vendor_paid", columnDefinition = "tinyInteger(1) default 0")

	private Boolean vendorPaid;

    private Boolean vendorPaid;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "local_connected_timestamp")

    @Column(name = "local_connected_timestamp")

	private LocalDateTime localConnectedTimestamp;

    private LocalDateTime localConnectedTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "reached_destination_timestamp")

    @Column(name = "reached_destination_timestamp")

	private LocalDateTime reachedDestinationTimestamp;

    private LocalDateTime reachedDestinationTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "first_dlvyatmp_timestamp")

    @Column(name = "first_dlvyatmp_timestamp")

	private LocalDateTime firstDlvyatmpTimestamp;

    private LocalDateTime firstDlvyatmpTimestamp;

	@Column(name = "originalOrderId")

    @Column(name = "originalOrderId")

	private Integer originalOrderId;

    private Integer originalOrderId;

	@Column(name = "fulfilmentWarehouseId")

    @Column(name = "fulfilmentWarehouseId")

	private Integer fulfilmentWarehouseId;

    private Integer fulfilmentWarehouseId;

	@Column(name = "orderType")

    @Column(name = "orderType")

	private Integer orderType;

    private Integer orderType;

	@Column(name = "pickupStoreId")

    @Column(name = "pickupStoreId")

	private Integer pickupStoreId;

    private Integer pickupStoreId;

	@Column(name = "otg", columnDefinition = "tinyInteger(1) default 0")

    @Column(name = "otg", columnDefinition = "tinyInteger(1) default 0")

	private Boolean otg;

    private Boolean otg;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

    @Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "courier_delivery_time")

    @Column(name = "courier_delivery_time")

	private LocalDateTime courierDeliveryTimestamp;

    private LocalDateTime courierDeliveryTimestamp;

	@Column(name = "insurer")

    @Column(name = "insurer")

	private Integer insurer;

    private Integer insurer;

	@Column(name = "insuranceAmount")

    @Column(name = "insuranceAmount")

	private Float insuranceAmount;

    private Float insuranceAmount;

	@Column(name = "freebieItemId")

    @Column(name = "freebieItemId")

	private Integer freebieItemId;

    private Integer freebieItemId;

	@Column(name = "source")

    @Column(name = "source")

	private Integer source;

    private Integer source;

	@Column(name = "advanceAmount")

    @Column(name = "advanceAmount")

	private Float advanceAmount;

    private Float advanceAmount;

	@Column(name = "storeId")

    @Column(name = "storeId")

	private Integer storeId;

    private Integer storeId;

	@Column(name = "productCondition")

    @Column(name = "productCondition")

	private Integer productCondition;

    private Integer productCondition;

	@Column(name = "dataProtectionInsurer")

    @Column(name = "dataProtectionInsurer")

	private Integer dataProtectionInsurer;

    private Integer dataProtectionInsurer;

	@Column(name = "dataProtectionAmount")

    @Column(name = "dataProtectionAmount")

	private Integer dataProtectionAmount;

    private Integer dataProtectionAmount;

	@Column(name = "taxType")

    @Column(name = "taxType")

	@Enumerated(EnumType.ORDINAL)

    @Enumerated(EnumType.ORDINAL)

	private TaxType taxType;

    private TaxType taxType;

	@Column(name = "logisticsTransactionId", length = 100)

    @Column(name = "logisticsTransactionId", length = 100)

	private String logisticsTransactionId;

    private String logisticsTransactionId;

	@Column(name = "shippingCost")

    @Column(name = "shippingCost")

	private Float shippingCost;

    private Float shippingCost;

	@Column(name = "codCharges")

    @Column(name = "codCharges")

	private Float codCharges;

    private Float codCharges;

	@Column(name = "wallet_amount")

    @Column(name = "wallet_amount")

	private Float walletAmount;

    private Float walletAmount;

	@Column(name = "net_payable_amount")

    @Column(name = "net_payable_amount")

	private Float netPayableAmount;

    private Float netPayableAmount;

	@Column(name = "shippingRefund")

    @Column(name = "shippingRefund")

	private Float shippingRefund;

    private Float shippingRefund;

	@Column(name = "irn_generated")

    @Column(name = "irn_generated")

	private Boolean irnGenerated;

    private Boolean irnGenerated;

	@Column(name = "shipment_hold")

    @Column(name = "shipment_hold")

	private Boolean shipmentHold;

    private Boolean shipmentHold;

	@ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER)

    @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER)

	@JoinColumn(name = "id", insertable = false, updatable = false, nullable = false, referencedColumnName = "order_id")

    @JoinColumn(name = "id", insertable = false, updatable = false, nullable = false, referencedColumnName = "order_id")

	private LineItem lineItem;

    private LineItem lineItem;

	public Order() {

    public Order() {

	}

    }

	public LocalDateTime getPartnerGrnTimestamp() {

    public LocalDateTime getPartnerGrnTimestamp() {

		return partnerGrnTimestamp;

        return partnerGrnTimestamp;

	}

    }

	public void setPartnerGrnTimestamp(LocalDateTime partnerGrnTimestamp) {

    public void setPartnerGrnTimestamp(LocalDateTime partnerGrnTimestamp) {

		this.partnerGrnTimestamp = partnerGrnTimestamp;

        this.partnerGrnTimestamp = partnerGrnTimestamp;

	}

    }

	public List<String> getReturnedImeis() {

    public List<String> getReturnedImeis() {

		return returnedImeis;

        return returnedImeis;

	}

    }

	public void setReturnedImeis(List<String> returnedImeis) {

    public void setReturnedImeis(List<String> returnedImeis) {

		this.returnedImeis = returnedImeis;

        this.returnedImeis = returnedImeis;

	}

    }

	public Integer getId() {

    public Integer getId() {

		return id;

        return id;

	}

    }

	public void setId(Integer id) {

    public void setId(Integer id) {

		this.id = id;

        this.id = id;

	}

    }

	public Integer getWarehouseId() {

    public Integer getWarehouseId() {

		return warehouseId;

        return warehouseId;

	}

    }

	public void setWarehouseId(Integer warehouseId) {

    public void setWarehouseId(Integer warehouseId) {

		this.warehouseId = warehouseId;

        this.warehouseId = warehouseId;

	}

    }

	public Integer getSellerId() {

    public Integer getSellerId() {

		return sellerId;

        return sellerId;

	}

    }

	public void setSellerId(Integer sellerId) {

    public void setSellerId(Integer sellerId) {

		this.sellerId = sellerId;

        this.sellerId = sellerId;

	}

    }

	public Integer getWarehouseAddressId() {

    public Integer getWarehouseAddressId() {

		return warehouseAddressId;

        return warehouseAddressId;

	}

    }

	public void setWarehouseAddressId(Integer warehouseAddressId) {

    public void setWarehouseAddressId(Integer warehouseAddressId) {

		this.warehouseAddressId = warehouseAddressId;

        this.warehouseAddressId = warehouseAddressId;

	}

    }

	public Integer getLogisticsProviderId() {

    public Integer getLogisticsProviderId() {

		return logisticsProviderId;

        return logisticsProviderId;

	}

    }

	public void setLogisticsProviderId(Integer logisticsProviderId) {

    public void setLogisticsProviderId(Integer logisticsProviderId) {

		this.logisticsProviderId = logisticsProviderId;

        this.logisticsProviderId = logisticsProviderId;

	}

    }

	public String getAirwayBillNumber() {

    public String getAirwayBillNumber() {

		return airwayBillNumber;

        return airwayBillNumber;

	}

    }

	public void setAirwayBillNumber(String airwayBillNumber) {

    public void setAirwayBillNumber(String airwayBillNumber) {

		this.airwayBillNumber = airwayBillNumber;

        this.airwayBillNumber = airwayBillNumber;

	}

    }

	public String getTrackingId() {

    public String getTrackingId() {

		return trackingId;

        return trackingId;

	}

    }

	public void setTrackingId(String trackingId) {

    public void setTrackingId(String trackingId) {

		this.trackingId = trackingId;

        this.trackingId = trackingId;

	}

    }

	public LocalDateTime getExpectedDeliveryTime() {

    public LocalDateTime getExpectedDeliveryTime() {

		return expectedDeliveryTime;

        return expectedDeliveryTime;

	}

    }

	public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {

    public void setExpectedDeliveryTime(LocalDateTime expectedDeliveryTime) {

		this.expectedDeliveryTime = expectedDeliveryTime;

        this.expectedDeliveryTime = expectedDeliveryTime;

	}

    }

	public LocalDateTime getPromisedDeliveryTime() {

    public LocalDateTime getPromisedDeliveryTime() {

		return promisedDeliveryTime;

        return promisedDeliveryTime;

	}

    }

	public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {

    public void setPromisedDeliveryTime(LocalDateTime promisedDeliveryTime) {

		this.promisedDeliveryTime = promisedDeliveryTime;

        this.promisedDeliveryTime = promisedDeliveryTime;

	}

    }

	public LocalDateTime getExpectedShippingTime() {

    public LocalDateTime getExpectedShippingTime() {

		return expectedShippingTime;

        return expectedShippingTime;

	}

    }

	public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {

    public void setExpectedShippingTime(LocalDateTime expectedShippingTime) {

		this.expectedShippingTime = expectedShippingTime;

        this.expectedShippingTime = expectedShippingTime;

	}

    }

	public LocalDateTime getPromisedShippingTime() {

    public LocalDateTime getPromisedShippingTime() {

		return promisedShippingTime;

        return promisedShippingTime;

	}

    }

	public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {

    public void setPromisedShippingTime(LocalDateTime promisedShippingTime) {

		this.promisedShippingTime = promisedShippingTime;

        this.promisedShippingTime = promisedShippingTime;

	}

    }

	public Integer getRetailerId() {

    public Integer getRetailerId() {

		return retailerId;

        return retailerId;

	}

    }

	public void setRetailerId(Integer retailerId) {

    public void setRetailerId(Integer retailerId) {

		this.retailerId = retailerId;

        this.retailerId = retailerId;

	}

    }

	public String getRetailerName() {

    public String getRetailerName() {

		return retailerName;

        return retailerName;

	}

    }

	public void setRetailerName(String retailerName) {

    public void setRetailerName(String retailerName) {

		this.retailerName = retailerName;

        this.retailerName = retailerName;

	}

    }

	public String getRetailerMobileNumber() {

    public String getRetailerMobileNumber() {

		return retailerMobileNumber;

        return retailerMobileNumber;

	}

    }

	public void setRetailerMobileNumber(String retailerMobileNumber) {

    public void setRetailerMobileNumber(String retailerMobileNumber) {

		this.retailerMobileNumber = retailerMobileNumber;

        this.retailerMobileNumber = retailerMobileNumber;

	}

    }

	public String getRetailerPinCode() {

    public String getRetailerPinCode() {

		return retailerPinCode;

        return retailerPinCode;

	}

    }

	public void setRetailerPinCode(String retailerPinCode) {

    public void setRetailerPinCode(String retailerPinCode) {

		this.retailerPinCode = retailerPinCode;

        this.retailerPinCode = retailerPinCode;

	}

    }

	public String getRetailerAddress1() {

    public String getRetailerAddress1() {

		return retailerAddress1;

        return retailerAddress1;

	}

    }

	public void setRetailerAddress1(String retailerAddress1) {

    public void setRetailerAddress1(String retailerAddress1) {

		this.retailerAddress1 = retailerAddress1;

        this.retailerAddress1 = retailerAddress1;

	}

    }

	public String getRetailerAddress2() {

    public String getRetailerAddress2() {

		return retailerAddress2;

        return retailerAddress2;

	}

    }

	public void setRetailerAddress2(String retailerAddress2) {

    public void setRetailerAddress2(String retailerAddress2) {

		this.retailerAddress2 = retailerAddress2;

        this.retailerAddress2 = retailerAddress2;

	}

    }

	public String getRetailerCity() {

    public String getRetailerCity() {

		return retailerCity;

        return retailerCity;

	}

    }

	public void setRetailerCity(String retailerCity) {

    public void setRetailerCity(String retailerCity) {

		this.retailerCity = retailerCity;

        this.retailerCity = retailerCity;

	}

    }

	public String getRetailerState() {

    public String getRetailerState() {

		return retailerState;

        return retailerState;

	}

    }

	public void setRetailerState(String retailerState) {

    public void setRetailerState(String retailerState) {

		this.retailerState = retailerState;

        this.retailerState = retailerState;

	}

    }

	public String getRetailerEmailId() {

    public String getRetailerEmailId() {

		return retailerEmailId;

        return retailerEmailId;

	}

    }

	public void setRetailerEmailId(String retailerEmailId) {

    public void setRetailerEmailId(String retailerEmailId) {

		this.retailerEmailId = retailerEmailId;

        this.retailerEmailId = retailerEmailId;

	}

    }

	public OrderStatus getStatus() {

    public OrderStatus getStatus() {

		return status;

        return status;

	}

    }

	public void setStatus(OrderStatus status) {

    public void setStatus(OrderStatus status) {

		this.status = status;

        this.status = status;

	}

    }

	public String getStatusDescription() {

    public String getStatusDescription() {

		return statusDescription;

        return statusDescription;

	}

    }

	public void setStatusDescription(String statusDescription) {

    public void setStatusDescription(String statusDescription) {

		this.statusDescription = statusDescription;

        this.statusDescription = statusDescription;

	}

    }

	public Float getTotalAmount() {

    public Float getTotalAmount() {

		return totalAmount;

        return totalAmount;

	}

    }

	public void setTotalAmount(Float totalAmount) {

    public void setTotalAmount(Float totalAmount) {

		this.totalAmount = totalAmount;

        this.totalAmount = totalAmount;

	}

    }

	public Float getGvAmount() {

    public Float getGvAmount() {

		return gvAmount;

        return gvAmount;

	}

    }

	public void setGvAmount(Float gvAmount) {

    public void setGvAmount(Float gvAmount) {

		this.gvAmount = gvAmount;

        this.gvAmount = gvAmount;

	}

    }

	public Float getTotalWeight() {

    public Float getTotalWeight() {

		return totalWeight;

        return totalWeight;

	}

    }

	public void setTotalWeight(Float totalWeight) {

    public void setTotalWeight(Float totalWeight) {

		this.totalWeight = totalWeight;

        this.totalWeight = totalWeight;

	}

    }

	public String getInvoiceNumber() {

    public String getInvoiceNumber() {

		return invoiceNumber;

        return invoiceNumber;

	}

    }

	public void setInvoiceNumber(String invoiceNumber) {

    public void setInvoiceNumber(String invoiceNumber) {

		this.invoiceNumber = invoiceNumber;

        this.invoiceNumber = invoiceNumber;

	}

    }

	public String getBilledBy() {

    public String getBilledBy() {

		return billedBy;

        return billedBy;

	}

    }

	public void setBilledBy(String billedBy) {

    public void setBilledBy(String billedBy) {

		this.billedBy = billedBy;

        this.billedBy = billedBy;

	}

    }

	public LocalDateTime getCreateTimestamp() {

    public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

        return createTimestamp;

	}

    }

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

    public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

        this.createTimestamp = createTimestamp;

	}

    }

	public LocalDateTime getAcceptedTimestamp() {

    public LocalDateTime getAcceptedTimestamp() {

		return acceptedTimestamp;

        return acceptedTimestamp;

	}

    }

	public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {

    public void setAcceptedTimestamp(LocalDateTime acceptedTimestamp) {

		this.acceptedTimestamp = acceptedTimestamp;

        this.acceptedTimestamp = acceptedTimestamp;

	}

    }

	public LocalDateTime getBillingTimestamp() {

    public LocalDateTime getBillingTimestamp() {

		return billingTimestamp;

        return billingTimestamp;

	}

    }

	public void setBillingTimestamp(LocalDateTime billingTimestamp) {

    public void setBillingTimestamp(LocalDateTime billingTimestamp) {

		this.billingTimestamp = billingTimestamp;

        this.billingTimestamp = billingTimestamp;

	}

    }

	public LocalDateTime getShippingTimestamp() {

    public LocalDateTime getShippingTimestamp() {

		return shippingTimestamp;

        return shippingTimestamp;

	}

    }

	public void setShippingTimestamp(LocalDateTime shippingTimestamp) {

    public void setShippingTimestamp(LocalDateTime shippingTimestamp) {

		this.shippingTimestamp = shippingTimestamp;

        this.shippingTimestamp = shippingTimestamp;

	}

    }

	public LocalDateTime getPickupTimestamp() {

    public LocalDateTime getPickupTimestamp() {

		return pickupTimestamp;

        return pickupTimestamp;

	}

    }

	public void setPickupTimestamp(LocalDateTime pickupTimestamp) {

    public void setPickupTimestamp(LocalDateTime pickupTimestamp) {

		this.pickupTimestamp = pickupTimestamp;

        this.pickupTimestamp = pickupTimestamp;

	}

    }

	public LocalDateTime getDeliveryTimestamp() {

    public LocalDateTime getDeliveryTimestamp() {

		return deliveryTimestamp;

        return deliveryTimestamp;

	}

    }

	public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {

    public void setDeliveryTimestamp(LocalDateTime deliveryTimestamp) {

		this.deliveryTimestamp = deliveryTimestamp;

        this.deliveryTimestamp = deliveryTimestamp;

	}

    }

	public LocalDateTime getOutOfStockTimestamp() {

    public LocalDateTime getOutOfStockTimestamp() {

		return outOfStockTimestamp;

        return outOfStockTimestamp;

	}

    }

	public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {

    public void setOutOfStockTimestamp(LocalDateTime outOfStockTimestamp) {

		this.outOfStockTimestamp = outOfStockTimestamp;

        this.outOfStockTimestamp = outOfStockTimestamp;

	}

    }

	public Integer getTransactionId() {

    public Integer getTransactionId() {

		return transactionId;

        return transactionId;

	}

    }

	public void setTransactionId(Integer transactionId) {

    public void setTransactionId(Integer transactionId) {

		this.transactionId = transactionId;

        this.transactionId = transactionId;

	}

    }

	/*

    /*

	 * public Integer getJacketNumber() { return jacketNumber; } public void

     * public Integer getJacketNumber() { return jacketNumber; } public void

	 * setJacketNumber(Integer jacketNumber) { this.jacketNumber = jacketNumber; }

     * setJacketNumber(Integer jacketNumber) { this.jacketNumber = jacketNumber; }

	 */

     */

	public String getReceiver() {

    public String getReceiver() {

		return receiver;

        return receiver;

	}

    }

	public void setReceiver(String receiver) {

    public void setReceiver(String receiver) {

		this.receiver = receiver;

        this.receiver = receiver;

	}

    }

	public Integer getBatchNumber() {

    public Integer getBatchNumber() {

		return batchNumber;

        return batchNumber;

	}

    }

	public void setBatchNumber(Integer batchNumber) {

    public void setBatchNumber(Integer batchNumber) {

		this.batchNumber = batchNumber;

        this.batchNumber = batchNumber;

	}

    }

	public Integer getSerialNumber() {

    public Integer getSerialNumber() {

		return serialNumber;

        return serialNumber;

	}

    }

	public void setSerialNumber(Integer serialNumber) {

    public void setSerialNumber(Integer serialNumber) {

		this.serialNumber = serialNumber;

        this.serialNumber = serialNumber;

	}

    }

	public Boolean getShipmentHold() {

    public Boolean getShipmentHold() {

		return shipmentHold;

        return shipmentHold;

	}

    }

	public void setShipmentHold(Boolean shipmentHold) {

    public void setShipmentHold(Boolean shipmentHold) {

		this.shipmentHold = shipmentHold;

        this.shipmentHold = shipmentHold;

	}

    }

	public Boolean isDoaFlag() {

    public Boolean isDoaFlag() {

		return doaFlag;

        return doaFlag;

	}

    }

	public void setDoaFlag(Boolean doaFlag) {

    public void setDoaFlag(Boolean doaFlag) {

		this.doaFlag = doaFlag;

        this.doaFlag = doaFlag;

	}

    }

	public Integer getPickupRequestNumber() {

    public Integer getPickupRequestNumber() {

		return pickupRequestNumber;

        return pickupRequestNumber;

	}

    }

	public void setPickupRequestNumber(Integer pickupRequestNumber) {

    public void setPickupRequestNumber(Integer pickupRequestNumber) {

		this.pickupRequestNumber = pickupRequestNumber;

        this.pickupRequestNumber = pickupRequestNumber;

	}

    }

	public Integer getNewOrderId() {

    public Integer getNewOrderId() {

		return newOrderId;

        return newOrderId;

	}

    }

	public void setNewOrderId(Integer newOrderId) {

    public void setNewOrderId(Integer newOrderId) {

		this.newOrderId = newOrderId;

        this.newOrderId = newOrderId;

	}

    }

	public LocalDateTime getDoaAuthTimestamp() {

    public LocalDateTime getDoaAuthTimestamp() {

		return doaAuthTimestamp;

        return doaAuthTimestamp;

	}

    }

	public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {

    public void setDoaAuthTimestamp(LocalDateTime doaAuthTimestamp) {

		this.doaAuthTimestamp = doaAuthTimestamp;

        this.doaAuthTimestamp = doaAuthTimestamp;

	}

    }

	public LocalDateTime getDoaPickupTimestamp() {

    public LocalDateTime getDoaPickupTimestamp() {

		return doaPickupTimestamp;

        return doaPickupTimestamp;

	}

    }

	public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {

    public void setDoaPickupTimestamp(LocalDateTime doaPickupTimestamp) {

		this.doaPickupTimestamp = doaPickupTimestamp;

        this.doaPickupTimestamp = doaPickupTimestamp;

	}

    }

	public LocalDateTime getReceiverReturnTimestamp() {

    public LocalDateTime getReceiverReturnTimestamp() {

		return receiverReturnTimestamp;

        return receiverReturnTimestamp;

	}

    }

	public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {

    public void setReceiverReturnTimestamp(LocalDateTime receiverReturnTimestamp) {

		this.receiverReturnTimestamp = receiverReturnTimestamp;

        this.receiverReturnTimestamp = receiverReturnTimestamp;

	}

    }

	public LocalDateTime getReShipTimestamp() {

    public LocalDateTime getReShipTimestamp() {

		return reShipTimestamp;

        return reShipTimestamp;

	}

    }

	public void setReShipTimestamp(LocalDateTime reShipTimestamp) {

    public void setReShipTimestamp(LocalDateTime reShipTimestamp) {

		this.reShipTimestamp = reShipTimestamp;

        this.reShipTimestamp = reShipTimestamp;

	}

    }

	public LocalDateTime getRefundTimestamp() {

    public LocalDateTime getRefundTimestamp() {

		return refundTimestamp;

        return refundTimestamp;

	}

    }

	public void setRefundTimestamp(LocalDateTime refundTimestamp) {

    public void setRefundTimestamp(LocalDateTime refundTimestamp) {

		this.refundTimestamp = refundTimestamp;

        this.refundTimestamp = refundTimestamp;

	}

    }

	public Integer getPurchaseOrderId() {

    public Integer getPurchaseOrderId() {

		return purchaseOrderId;

        return purchaseOrderId;

	}

    }

	public void setPurchaseOrderId(Integer purchaseOrderId) {

    public void setPurchaseOrderId(Integer purchaseOrderId) {

		this.purchaseOrderId = purchaseOrderId;

        this.purchaseOrderId = purchaseOrderId;

	}

    }

	public Boolean isCod() {

    public Boolean isCod() {

		return cod;

        return cod;

	}

    }

	public void setCod(Boolean cod) {

    public void setCod(Boolean cod) {

		this.cod = cod;

        this.cod = cod;

	}

    }

	public LocalDateTime getVerificationTimestamp() {

    public LocalDateTime getVerificationTimestamp() {

		return verificationTimestamp;

        return verificationTimestamp;

	}

    }

	public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {

    public void setVerificationTimestamp(LocalDateTime verificationTimestamp) {

		this.verificationTimestamp = verificationTimestamp;

        this.verificationTimestamp = verificationTimestamp;

	}

    }

	public String getRefundBy() {

    public String getRefundBy() {

		return refundBy;

        return refundBy;

	}

    }

	public void setRefundBy(String refundBy) {

    public void setRefundBy(String refundBy) {

		this.refundBy = refundBy;

        this.refundBy = refundBy;

	}

    }

	public String getRefundReason() {

    public String getRefundReason() {

		return refundReason;

        return refundReason;

	}

    }

	public void setRefundReason(String refundReason) {

    public void setRefundReason(String refundReason) {

		this.refundReason = refundReason;

        this.refundReason = refundReason;

	}

    }

	/*

    /*

	 * public DelayReason getDelayReason() { return delayReason; } public void

     * public DelayReason getDelayReason() { return delayReason; } public void

	 * setDelayReason(DelayReason delayReason) { this.delayReason = delayReason; }

     * setDelayReason(DelayReason delayReason) { this.delayReason = delayReason; }

	 */

     */

	public LocalDateTime getCodReconciliationTimestamp() {

    public LocalDateTime getCodReconciliationTimestamp() {

		return codReconciliationTimestamp;

        return codReconciliationTimestamp;

	}

    }