WebSVN – SmartDukaan – Diff – /trunk/Support/src/main/java/in/shop2020/support/utils/NewStockSalesReportFetcher.java



				Long websiteOrderCount  = 0L;
				Long ebayOrderCount     = 0L;
				Long snapdealOrderCount = 0L;
				Long flipkartOrderCount = 0L;
				Long amzn_mfnOrderCount = 0L;
				Long homeshopOrderCount = 0L;
				Long totalInStockDays    = 0L;
				Long websiteInStockDays  = 0L;
				Long ebayInStockDays     = 0L;
				Long snapdealInStockDays = 0L;
				Long flipkartInStockDays = 0L;
				Long amzn_mfnInStockDays = 0L;
				Long homeshopInStockDays= 0L;
				Double websiteAverageSale  = 0.0;
				Double totalAverageSale = 0.0;
				Double ebayAverageSale     = 0.0;
				Double snapdealAverageSale = 0.0;
				Double flipkartAverageSale = 0.0;
				Double amzn_mfnAverageSale  = 0.0;
				Double homeshopAverageSale  = 0.0;			
				StringBuilder totalSaleHistory    = new StringBuilder("");
				StringBuilder websiteSaleHistory  = new StringBuilder("");
				StringBuilder ebaySaleHistory     = new StringBuilder("");
				StringBuilder snapdealSaleHistory = new StringBuilder("");
				StringBuilder flipkartSaleHistory = new StringBuilder("");
				StringBuilder amzn_mfnSaleHistory = new StringBuilder("");
				StringBuilder homeshopSaleHistory = new StringBuilder("");
 
				ItemInventory itemInventory = inventoryMap.get(item.getId());
				Map<Long, Long> availabilityMap;
				if(itemInventory!= null) {
					//System.out.println("itemId =" + item.getId());

								amzn_mfnSaleHistory.append(oosStatus.getNum_orders() + "-");
							} else {
								amzn_mfnSaleHistory.append("X-");
							}
							break;
						case 4:
							if(oosStatus.isIs_oos()== false) {
								homeshopInStockDays++;
								homeshopOrderCount += oosStatus.getNum_orders();
								homeshopSaleHistory.append(oosStatus.getNum_orders() + "-");
							} else {
								amzn_mfnSaleHistory.append("X-");
							}
							break;
						case 6: 
							if(oosStatus.isIs_oos()== false) {
								ebayInStockDays++;
								ebayOrderCount += oosStatus.getNum_orders();
								ebaySaleHistory.append(oosStatus.getNum_orders() + "-");

				snapdealAverageSale = Math.round(snapdealAverageSale * 10.0)/10.0;
				flipkartAverageSale = (double)flipkartOrderCount/flipkartInStockDays;
				flipkartAverageSale = Math.round(flipkartAverageSale * 10.0)/10.0;
				amzn_mfnAverageSale = (double)amzn_mfnOrderCount/amzn_mfnInStockDays;
				amzn_mfnAverageSale = Math.round(amzn_mfnAverageSale * 10.0)/10.0;
				homeshopAverageSale = (double)homeshopOrderCount/homeshopInStockDays;
				homeshopAverageSale = Math.round(homeshopAverageSale * 10.0)/10.0;
 
				if(totalAverageSale<=0.0) {
					StockSaleDetail ssDetail = new StockSaleDetail();
					ssDetail.setItemId(item.getId());
					ssDetail.setCategory(categoryIdLabelMap.get(item.getCategory()));

					ssDetail.setAvgSalesSD(snapdealAverageSale);
					ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));
					ssDetail.setAvgSalesFK(flipkartAverageSale);
					ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));
					ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);
					ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));
					ssDetail.setAvgSalesHomeShop(homeshopAverageSale);
					if(item.getCategory() == 10006 || item.getCategory() == 10010){
						nonMovingStockSaleListMT.add(ssDetail);
					} else {
						nonMovingStockSaleListEMT.add(ssDetail);
					}            		

						ssDetail.setAvgSalesSD(snapdealAverageSale);
						ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));
						ssDetail.setAvgSalesFK(flipkartAverageSale);
						ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));
						ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);
						ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));
						ssDetail.setAvgSalesHomeShop(homeshopAverageSale);
						if(item.getCategory() == 10006 || item.getCategory() == 10010){
							slowMovingStockSaleListMT.add(ssDetail);
						} else {
							slowMovingStockSaleListEMT.add(ssDetail);
						} 

						ssDetail.setAvgSalesSD(snapdealAverageSale);
						ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));
						ssDetail.setAvgSalesFK(flipkartAverageSale);
						ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));
						ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);
						ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));
						ssDetail.setAvgSalesHomeShop(homeshopAverageSale);
						if(item.getCategory() == 10006 || item.getCategory() == 10010){
							movingStockSaleListMT.add(ssDetail);
						} else {
							movingStockSaleListEMT.add(ssDetail);
						} 

			row.createCell(18).setCellValue("Avg Sales(Snapdeal)");
			row.createCell(19).setCellValue("Sales History(Flipkart)");
			row.createCell(20).setCellValue("Avg Sales(Flipkart)");
			row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
			row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
			row.createCell(23).setCellValue("Sales History(HomeShop18)");
			row.createCell(24).setCellValue("Avg Sales(HomeShop18)");
			
			int i=1;
			for(StockSaleDetail ssDetail : movingStockSaleList){
				row = movingSheet.createRow(i);
				row.createCell(0).setCellValue(ssDetail.getItemId()+"");
				row.createCell(1).setCellValue(ssDetail.getCategory());

				row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");
				row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());
				row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");
				row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());
				row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());
				row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());
				row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");
				i++;
			}
 
			row = nonMovingSheet.createRow(0);
 

			row.createCell(18).setCellValue("Avg Sales(Snapdeal)");
			row.createCell(19).setCellValue("Sales History(Flipkart)");
			row.createCell(20).setCellValue("Avg Sales(Flipkart)");
			row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
			row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
			row.createCell(23).setCellValue("Sales History(HomeShop18)");
			row.createCell(24).setCellValue("Avg Sales(HomeShop18)");
 
			i=1;
			for(StockSaleDetail ssDetail : nonMovingStockSaleList){
				row = nonMovingSheet.createRow(i);
				row.createCell(0).setCellValue(ssDetail.getItemId()+"");

				row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");
				row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());
				row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");
				row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());
				row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());
				row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());
				row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");
				i++;
			}
 
			row = slowMovingSheet.createRow(0);
 

			row.createCell(18).setCellValue("Avg Sales(Snapdeal)");
			row.createCell(19).setCellValue("Sales History(Flipkart)");
			row.createCell(20).setCellValue("Avg Sales(Flipkart)");
			row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
			row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
			row.createCell(23).setCellValue("Sales History(HomeShop18)");
			row.createCell(24).setCellValue("Avg Sales(HomeShop18)");
 
			i=1;
			for(StockSaleDetail ssDetail : slowMovingStockSaleList){
				row = slowMovingSheet.createRow(i);
				row.createCell(0).setCellValue(ssDetail.getItemId()+"");

				row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");
				row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());
				row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");
				row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());
				row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());
				row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());
				row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");
				i++;
			}
 
			FileOutputStream out = null;
			if(mobTab){

Subversion Repositories SmartDukaan

(root)/trunk/Support/src/main/java/in/shop2020/support/utils/NewStockSalesReportFetcher.java – Rev 12235 → 14655

Rev 12235		Rev 14655
Line 136...		Line 136...
136	`Long websiteOrderCount = 0L;`	136	`Long websiteOrderCount = 0L;`
137	`Long ebayOrderCount = 0L;`	137	`Long ebayOrderCount = 0L;`
138	`Long snapdealOrderCount = 0L;`	138	`Long snapdealOrderCount = 0L;`
139	`Long flipkartOrderCount = 0L;`	139	`Long flipkartOrderCount = 0L;`
140	`Long amzn_mfnOrderCount = 0L;`	140	`Long amzn_mfnOrderCount = 0L;`
-		141	`Long homeshopOrderCount = 0L;`
141	`Long totalInStockDays = 0L;`	142	`Long totalInStockDays = 0L;`
142	`Long websiteInStockDays = 0L;`	143	`Long websiteInStockDays = 0L;`
143	`Long ebayInStockDays = 0L;`	144	`Long ebayInStockDays = 0L;`
144	`Long snapdealInStockDays = 0L;`	145	`Long snapdealInStockDays = 0L;`
145	`Long flipkartInStockDays = 0L;`	146	`Long flipkartInStockDays = 0L;`
146	`Long amzn_mfnInStockDays = 0L;`	147	`Long amzn_mfnInStockDays = 0L;`
-		148	`Long homeshopInStockDays= 0L;`
147	`Double websiteAverageSale = 0.0;`	149	`Double websiteAverageSale = 0.0;`
148	`Double totalAverageSale = 0.0;`	150	`Double totalAverageSale = 0.0;`
149	`Double ebayAverageSale = 0.0;`	151	`Double ebayAverageSale = 0.0;`
150	`Double snapdealAverageSale = 0.0;`	152	`Double snapdealAverageSale = 0.0;`
151	`Double flipkartAverageSale = 0.0;`	153	`Double flipkartAverageSale = 0.0;`
152	`Double amzn_mfnAverageSale = 0.0;`	154	`Double amzn_mfnAverageSale = 0.0;`
-		155	`Double homeshopAverageSale = 0.0;`
153	`StringBuilder totalSaleHistory = new StringBuilder("");`	156	`StringBuilder totalSaleHistory = new StringBuilder("");`
154	`StringBuilder websiteSaleHistory = new StringBuilder("");`	157	`StringBuilder websiteSaleHistory = new StringBuilder("");`
155	`StringBuilder ebaySaleHistory = new StringBuilder("");`	158	`StringBuilder ebaySaleHistory = new StringBuilder("");`
156	`StringBuilder snapdealSaleHistory = new StringBuilder("");`	159	`StringBuilder snapdealSaleHistory = new StringBuilder("");`
157	`StringBuilder flipkartSaleHistory = new StringBuilder("");`	160	`StringBuilder flipkartSaleHistory = new StringBuilder("");`
158	`StringBuilder amzn_mfnSaleHistory = new StringBuilder("");`	161	`StringBuilder amzn_mfnSaleHistory = new StringBuilder("");`
-		162	`StringBuilder homeshopSaleHistory = new StringBuilder("");`
159		163
160	`ItemInventory itemInventory = inventoryMap.get(item.getId());`	164	`ItemInventory itemInventory = inventoryMap.get(item.getId());`
161	`Map<Long, Long> availabilityMap;`	165	`Map<Long, Long> availabilityMap;`
162	`if(itemInventory!= null) {`	166	`if(itemInventory!= null) {`
163	`//System.out.println("itemId =" + item.getId());`	167	`//System.out.println("itemId =" + item.getId());`
Line 209...		Line 213...
209	`amzn_mfnSaleHistory.append(oosStatus.getNum_orders() + "-");`	213	`amzn_mfnSaleHistory.append(oosStatus.getNum_orders() + "-");`
210	`} else {`	214	`} else {`
211	`amzn_mfnSaleHistory.append("X-");`	215	`amzn_mfnSaleHistory.append("X-");`
212	`}`	216	`}`
213	`break;`	217	`break;`
-		218	`case 4:`
-		219	`if(oosStatus.isIs_oos()== false) {`
-		220	`homeshopInStockDays++;`
-		221	`homeshopOrderCount += oosStatus.getNum_orders();`
-		222	`homeshopSaleHistory.append(oosStatus.getNum_orders() + "-");`
-		223	`} else {`
-		224	`amzn_mfnSaleHistory.append("X-");`
-		225	`}`
-		226	`break;`
214	`case 6:`	227	`case 6:`
215	`if(oosStatus.isIs_oos()== false) {`	228	`if(oosStatus.isIs_oos()== false) {`
216	`ebayInStockDays++;`	229	`ebayInStockDays++;`
217	`ebayOrderCount += oosStatus.getNum_orders();`	230	`ebayOrderCount += oosStatus.getNum_orders();`
218	`ebaySaleHistory.append(oosStatus.getNum_orders() + "-");`	231	`ebaySaleHistory.append(oosStatus.getNum_orders() + "-");`
Line 258...		Line 271...
258	`snapdealAverageSale = Math.round(snapdealAverageSale * 10.0)/10.0;`	271	`snapdealAverageSale = Math.round(snapdealAverageSale * 10.0)/10.0;`
259	`flipkartAverageSale = (double)flipkartOrderCount/flipkartInStockDays;`	272	`flipkartAverageSale = (double)flipkartOrderCount/flipkartInStockDays;`
260	`flipkartAverageSale = Math.round(flipkartAverageSale * 10.0)/10.0;`	273	`flipkartAverageSale = Math.round(flipkartAverageSale * 10.0)/10.0;`
261	`amzn_mfnAverageSale = (double)amzn_mfnOrderCount/amzn_mfnInStockDays;`	274	`amzn_mfnAverageSale = (double)amzn_mfnOrderCount/amzn_mfnInStockDays;`
262	`amzn_mfnAverageSale = Math.round(amzn_mfnAverageSale * 10.0)/10.0;`	275	`amzn_mfnAverageSale = Math.round(amzn_mfnAverageSale * 10.0)/10.0;`
-		276	`homeshopAverageSale = (double)homeshopOrderCount/homeshopInStockDays;`
-		277	`homeshopAverageSale = Math.round(homeshopAverageSale * 10.0)/10.0;`
263		278
264	`if(totalAverageSale<=0.0) {`	279	`if(totalAverageSale<=0.0) {`
265	`StockSaleDetail ssDetail = new StockSaleDetail();`	280	`StockSaleDetail ssDetail = new StockSaleDetail();`
266	`ssDetail.setItemId(item.getId());`	281	`ssDetail.setItemId(item.getId());`
267	`ssDetail.setCategory(categoryIdLabelMap.get(item.getCategory()));`	282	`ssDetail.setCategory(categoryIdLabelMap.get(item.getCategory()));`
Line 283...		Line 298...
283	`ssDetail.setAvgSalesSD(snapdealAverageSale);`	298	`ssDetail.setAvgSalesSD(snapdealAverageSale);`
284	`ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));`	299	`ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));`
285	`ssDetail.setAvgSalesFK(flipkartAverageSale);`	300	`ssDetail.setAvgSalesFK(flipkartAverageSale);`
286	`ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));`	301	`ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));`
287	`ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);`	302	`ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);`
-		303	`ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));`
-		304	`ssDetail.setAvgSalesHomeShop(homeshopAverageSale);`
288	`if(item.getCategory() == 10006 \|\| item.getCategory() == 10010){`	305	`if(item.getCategory() == 10006 \|\| item.getCategory() == 10010){`
289	`nonMovingStockSaleListMT.add(ssDetail);`	306	`nonMovingStockSaleListMT.add(ssDetail);`
290	`} else {`	307	`} else {`
291	`nonMovingStockSaleListEMT.add(ssDetail);`	308	`nonMovingStockSaleListEMT.add(ssDetail);`
292	`}`	309	`}`
Line 315...		Line 332...
315	`ssDetail.setAvgSalesSD(snapdealAverageSale);`	332	`ssDetail.setAvgSalesSD(snapdealAverageSale);`
316	`ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));`	333	`ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));`
317	`ssDetail.setAvgSalesFK(flipkartAverageSale);`	334	`ssDetail.setAvgSalesFK(flipkartAverageSale);`
318	`ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));`	335	`ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));`
319	`ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);`	336	`ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);`
-		337	`ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));`
-		338	`ssDetail.setAvgSalesHomeShop(homeshopAverageSale);`
320	`if(item.getCategory() == 10006 \|\| item.getCategory() == 10010){`	339	`if(item.getCategory() == 10006 \|\| item.getCategory() == 10010){`
321	`slowMovingStockSaleListMT.add(ssDetail);`	340	`slowMovingStockSaleListMT.add(ssDetail);`
322	`} else {`	341	`} else {`
323	`slowMovingStockSaleListEMT.add(ssDetail);`	342	`slowMovingStockSaleListEMT.add(ssDetail);`
324	`}`	343	`}`
Line 344...		Line 363...
344	`ssDetail.setAvgSalesSD(snapdealAverageSale);`	363	`ssDetail.setAvgSalesSD(snapdealAverageSale);`
345	`ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));`	364	`ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));`
346	`ssDetail.setAvgSalesFK(flipkartAverageSale);`	365	`ssDetail.setAvgSalesFK(flipkartAverageSale);`
347	`ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));`	366	`ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));`
348	`ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);`	367	`ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);`
-		368	`ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));`
-		369	`ssDetail.setAvgSalesHomeShop(homeshopAverageSale);`
349	`if(item.getCategory() == 10006 \|\| item.getCategory() == 10010){`	370	`if(item.getCategory() == 10006 \|\| item.getCategory() == 10010){`
350	`movingStockSaleListMT.add(ssDetail);`	371	`movingStockSaleListMT.add(ssDetail);`
351	`} else {`	372	`} else {`
352	`movingStockSaleListEMT.add(ssDetail);`	373	`movingStockSaleListEMT.add(ssDetail);`
353	`}`	374	`}`
Line 662...		Line 683...
662	`row.createCell(18).setCellValue("Avg Sales(Snapdeal)");`	683	`row.createCell(18).setCellValue("Avg Sales(Snapdeal)");`
663	`row.createCell(19).setCellValue("Sales History(Flipkart)");`	684	`row.createCell(19).setCellValue("Sales History(Flipkart)");`
664	`row.createCell(20).setCellValue("Avg Sales(Flipkart)");`	685	`row.createCell(20).setCellValue("Avg Sales(Flipkart)");`
665	`row.createCell(21).setCellValue("Sales History(Amazon-MFN)");`	686	`row.createCell(21).setCellValue("Sales History(Amazon-MFN)");`
666	`row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");`	687	`row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");`
-		688	`row.createCell(23).setCellValue("Sales History(HomeShop18)");`
-		689	`row.createCell(24).setCellValue("Avg Sales(HomeShop18)");`
667		690
668	`int i=1;`	691	`int i=1;`
669	`for(StockSaleDetail ssDetail : movingStockSaleList){`	692	`for(StockSaleDetail ssDetail : movingStockSaleList){`
670	`row = movingSheet.createRow(i);`	693	`row = movingSheet.createRow(i);`
671	`row.createCell(0).setCellValue(ssDetail.getItemId()+"");`	694	`row.createCell(0).setCellValue(ssDetail.getItemId()+"");`
672	`row.createCell(1).setCellValue(ssDetail.getCategory());`	695	`row.createCell(1).setCellValue(ssDetail.getCategory());`
Line 689...		Line 712...
689	`row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");`	712	`row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");`
690	`row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());`	713	`row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());`
691	`row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");`	714	`row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");`
692	`row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());`	715	`row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());`
693	`row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());`	716	`row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());`
-		717	`row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());`
-		718	`row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");`
694	`i++;`	719	`i++;`
695	`}`	720	`}`
696		721
697	`row = nonMovingSheet.createRow(0);`	722	`row = nonMovingSheet.createRow(0);`
698		723
Line 717...		Line 742...
717	`row.createCell(18).setCellValue("Avg Sales(Snapdeal)");`	742	`row.createCell(18).setCellValue("Avg Sales(Snapdeal)");`
718	`row.createCell(19).setCellValue("Sales History(Flipkart)");`	743	`row.createCell(19).setCellValue("Sales History(Flipkart)");`
719	`row.createCell(20).setCellValue("Avg Sales(Flipkart)");`	744	`row.createCell(20).setCellValue("Avg Sales(Flipkart)");`
720	`row.createCell(21).setCellValue("Sales History(Amazon-MFN)");`	745	`row.createCell(21).setCellValue("Sales History(Amazon-MFN)");`
721	`row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");`	746	`row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");`
-		747	`row.createCell(23).setCellValue("Sales History(HomeShop18)");`
-		748	`row.createCell(24).setCellValue("Avg Sales(HomeShop18)");`
722		749
723	`i=1;`	750	`i=1;`
724	`for(StockSaleDetail ssDetail : nonMovingStockSaleList){`	751	`for(StockSaleDetail ssDetail : nonMovingStockSaleList){`
725	`row = nonMovingSheet.createRow(i);`	752	`row = nonMovingSheet.createRow(i);`
726	`row.createCell(0).setCellValue(ssDetail.getItemId()+"");`	753	`row.createCell(0).setCellValue(ssDetail.getItemId()+"");`
Line 744...		Line 771...
744	`row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");`	771	`row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");`
745	`row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());`	772	`row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());`
746	`row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");`	773	`row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");`
747	`row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());`	774	`row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());`
748	`row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());`	775	`row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());`
-		776	`row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());`
-		777	`row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");`
749	`i++;`	778	`i++;`
750	`}`	779	`}`
751		780
752	`row = slowMovingSheet.createRow(0);`	781	`row = slowMovingSheet.createRow(0);`
753		782
Line 772...		Line 801...
772	`row.createCell(18).setCellValue("Avg Sales(Snapdeal)");`	801	`row.createCell(18).setCellValue("Avg Sales(Snapdeal)");`
773	`row.createCell(19).setCellValue("Sales History(Flipkart)");`	802	`row.createCell(19).setCellValue("Sales History(Flipkart)");`
774	`row.createCell(20).setCellValue("Avg Sales(Flipkart)");`	803	`row.createCell(20).setCellValue("Avg Sales(Flipkart)");`
775	`row.createCell(21).setCellValue("Sales History(Amazon-MFN)");`	804	`row.createCell(21).setCellValue("Sales History(Amazon-MFN)");`
776	`row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");`	805	`row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");`
-		806	`row.createCell(23).setCellValue("Sales History(HomeShop18)");`
-		807	`row.createCell(24).setCellValue("Avg Sales(HomeShop18)");`
777		808
778	`i=1;`	809	`i=1;`
779	`for(StockSaleDetail ssDetail : slowMovingStockSaleList){`	810	`for(StockSaleDetail ssDetail : slowMovingStockSaleList){`
780	`row = slowMovingSheet.createRow(i);`	811	`row = slowMovingSheet.createRow(i);`
781	`row.createCell(0).setCellValue(ssDetail.getItemId()+"");`	812	`row.createCell(0).setCellValue(ssDetail.getItemId()+"");`
Line 799...		Line 830...
799	`row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");`	830	`row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");`
800	`row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());`	831	`row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());`
801	`row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");`	832	`row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");`
802	`row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());`	833	`row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());`
803	`row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());`	834	`row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());`
-		835	`row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());`
-		836	`row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");`
804	`i++;`	837	`i++;`
805	`}`	838	`}`
806		839
807	`FileOutputStream out = null;`	840	`FileOutputStream out = null;`
808	`if(mobTab){`	841	`if(mobTab){`