Subversion Repositories SmartDukaan

Rev

Rev 15412 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
12166 manish.sha 1 
package in.shop2020.support.utils;
2 
 
3 
import java.io.BufferedWriter;
4 
import java.io.File;
5 
import java.io.FileOutputStream;
6 
import java.io.FileWriter;
7 
import java.util.ArrayList;
8 
import java.util.Collections;
9 
import java.util.Date;
10 
import java.util.HashMap;
11 
import java.util.Hashtable;
12 
import java.util.List;
13 
import java.util.Map;
14 
 
15 
import org.apache.commons.lang.StringUtils;
16 
import org.apache.commons.logging.Log;
17 
import org.apache.poi.hssf.usermodel.HSSFSheet;
18 
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
19 
import org.apache.poi.ss.usermodel.Cell;
20 
import org.apache.poi.ss.usermodel.Row;
21 
 
22 
import java.util.Set;
23 
import org.slf4j.Logger;
24 
import org.slf4j.LoggerFactory;
25 
 
26 
import com.mysql.jdbc.log.LogFactory;
27 
import in.shop2020.model.v1.catalog.CatalogService;
28 
import in.shop2020.model.v1.catalog.Category;
29 
import in.shop2020.model.v1.catalog.Item;
30 
import in.shop2020.model.v1.inventory.InventoryService;
31 
import in.shop2020.model.v1.inventory.InventoryType;
32 
import in.shop2020.model.v1.inventory.ItemInventory;
33 
import in.shop2020.model.v1.inventory.OOSStatus;
34 
import in.shop2020.model.v1.inventory.VendorItemPricing;
35 
import in.shop2020.model.v1.inventory.Warehouse;
36 
import in.shop2020.model.v1.inventory.WarehouseType;
37 
import in.shop2020.support.models.MovingStockSaleDetailComparator;
38 
import in.shop2020.support.models.SnmMovingStockSaleDetailComparator;
39 
import in.shop2020.support.models.StockSaleDetail;
40 
import in.shop2020.thrift.clients.CatalogClient;
41 
import in.shop2020.thrift.clients.InventoryClient;
42 
import in.shop2020.utils.GmailUtils;
43 
 
44 
public class NewStockSalesReportFetcher {
45 
	private static final int NUMBER_OF_DAYS_SALE = 5;
19353 manish.sha 46 
	private static final String[] mailToMT = {"chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com", "khushal.bhatia@saholic.com", "rajneesh.arora@saholic.com", "manish.sharma@shop2020.in", "yatin.singh@saholic.com","amit.gupta@shop2020.in","kshitij.sood@saholic.com"};
12166 manish.sha 47 
	private static final String[] mailTo = {"manish.sharma@shop2020.in"};
48 
	private static final String senderAccountMail = "build-staging@shop2020.in";
49 
	private static final String senderAccountPswd = "shop2020";
50 
 
51 
	static String tmpDir = System.getProperty("java.io.tmpdir");
52 
	static File stockSalesReportMT = new File(tmpDir + "/StockSaleReport-MT" + (new Date()) + ".xls");
53 
	static File stockSalesReportEMT = new File(tmpDir + "/StockSaleReport-EMT" + (new Date()) + ".xls");
54 
 
55 
	static List<StockSaleDetail> movingStockSaleListMT = new ArrayList<StockSaleDetail>();
56 
	static List<StockSaleDetail> nonMovingStockSaleListMT = new ArrayList<StockSaleDetail>();
57 
	static List<StockSaleDetail> slowMovingStockSaleListMT = new ArrayList<StockSaleDetail>();
58 
	static List<StockSaleDetail> movingStockSaleListEMT = new ArrayList<StockSaleDetail>();
59 
	static List<StockSaleDetail> nonMovingStockSaleListEMT = new ArrayList<StockSaleDetail>();
60 
	static List<StockSaleDetail> slowMovingStockSaleListEMT = new ArrayList<StockSaleDetail>();
61 
 
62 
	private static Logger logger = LoggerFactory.getLogger(StockSalesReportFetcher.class);
63 
 
64 
	private static void createAndMailReport() {
65 
		try {
66 
			CatalogClient catalogServiceClient = new CatalogClient();
67 
			CatalogService.Client catalogClient = catalogServiceClient.getClient();
68 
			List<Item> itemList = catalogClient.getAllAliveItems();
69 
 
70 
			if(!catalogClient.isAlive()){
71 
				catalogClient = catalogServiceClient.getClient();
72 
			}
73 
			List<Category> allCategories = catalogClient.getAllCategories();
74 
			Map<Long, String> categoryIdLabelMap = new Hashtable<Long, String>();
75 
			for(Category category : allCategories) {
76 
				categoryIdLabelMap.put(category.getId(), category.getLabel());
77 
			}
78 
 
79 
			InventoryClient inventoryServiceClient = new InventoryClient();
80 
			InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
81 
			Map<Long, ItemInventory> inventoryMap = inventoryClient.getInventorySnapshot(0);
82 
 
83 
			if(!inventoryClient.isAlive()){
84 
				inventoryClient = inventoryServiceClient.getClient();
85 
			}
86 
			List<OOSStatus> oosStatuses = inventoryClient.getOosStatusesForXDays(-1, NUMBER_OF_DAYS_SALE);
87 
			Map<Long, List<OOSStatus>> oosStatusMapByItem = new Hashtable<Long, List<OOSStatus>>(5000);
88 
			for(OOSStatus oosStatus : oosStatuses) {
89 
				List<OOSStatus> oosStatusList;
90 
				Long itemId = oosStatus.getItem_id();
91 
				if(oosStatusMapByItem.containsKey(itemId)) {
92 
					oosStatusList = oosStatusMapByItem.get(itemId);
93 
					oosStatusList.add(oosStatus);
94 
				} else {
95 
					oosStatusList = new ArrayList<OOSStatus>(6);
96 
					oosStatusList.add(oosStatus);
97 
				}
98 
				oosStatusMapByItem.put(itemId, oosStatusList);
99 
			}
100 
 
101 
			if(!inventoryClient.isAlive()){
102 
				inventoryClient = inventoryServiceClient.getClient();
103 
			}
104 
			List<Warehouse>  ourGoodWarehouses = inventoryClient.getWarehouses(WarehouseType.OURS, InventoryType.GOOD, 0, 0, 0);
105 
			Map<Long, Warehouse> ourWarehouseMap = new Hashtable<Long, Warehouse>(200);
106 
			for(Warehouse warehouse : ourGoodWarehouses) {
107 
				//System.out.println("Warehouse = " + warehouse.getId());
108 
				ourWarehouseMap.put(warehouse.getId(), warehouse);
109 
			}
110 
 
111 
			if(!inventoryClient.isAlive()){
112 
				inventoryClient = inventoryServiceClient.getClient();
113 
			}
114 
			List<VendorItemPricing> vendorItemPricings = inventoryClient.getAllVendorItemPricing(0, 0);
115 
			Map<Long, List<VendorItemPricing>> itemPricingMap = new Hashtable<Long, List<VendorItemPricing>>(5000);
116 
			for(VendorItemPricing vendorItemPricing : vendorItemPricings) {
117 
				List<VendorItemPricing> pricingListForItem;
118 
				Long itemId = vendorItemPricing.getItemId();
119 
				if(itemPricingMap.containsKey(itemId)) {
120 
					pricingListForItem = itemPricingMap.get(itemId);
121 
					pricingListForItem.add(vendorItemPricing);
122 
				} else {
123 
					pricingListForItem = new ArrayList<VendorItemPricing>();
124 
					pricingListForItem.add(vendorItemPricing);
125 
				}
126 
				itemPricingMap.put(itemId, pricingListForItem);
127 
			}
128 
 
129 
			Long stockCount;
130 
			Double stockValue;
131 
			for (Item item : itemList) {
132 
				stockCount = 0L;
133 
				stockValue = 0.0;
134 
				Long totalOrderCount    = 0L;
135 
				Long websiteOrderCount  = 0L;
136 
				Long ebayOrderCount     = 0L;
137 
				Long snapdealOrderCount = 0L;
138 
				Long flipkartOrderCount = 0L;
139 
				Long amzn_mfnOrderCount = 0L;
14655 manish.sha 140 
				Long homeshopOrderCount = 0L;
12166 manish.sha 141 
				Long totalInStockDays    = 0L;
142 
				Long websiteInStockDays  = 0L;
143 
				Long ebayInStockDays     = 0L;
144 
				Long snapdealInStockDays = 0L;
145 
				Long flipkartInStockDays = 0L;
146 
				Long amzn_mfnInStockDays = 0L;
14655 manish.sha 147 
				Long homeshopInStockDays= 0L;
12166 manish.sha 148 
				Double websiteAverageSale  = 0.0;
149 
				Double totalAverageSale = 0.0;
150 
				Double ebayAverageSale     = 0.0;
151 
				Double snapdealAverageSale = 0.0;
152 
				Double flipkartAverageSale = 0.0;
153 
				Double amzn_mfnAverageSale  = 0.0;
14655 manish.sha 154 
				Double homeshopAverageSale  = 0.0;
12166 manish.sha 155 
				StringBuilder totalSaleHistory    = new StringBuilder("");
156 
				StringBuilder websiteSaleHistory  = new StringBuilder("");
157 
				StringBuilder ebaySaleHistory     = new StringBuilder("");
158 
				StringBuilder snapdealSaleHistory = new StringBuilder("");
159 
				StringBuilder flipkartSaleHistory = new StringBuilder("");
160 
				StringBuilder amzn_mfnSaleHistory = new StringBuilder("");
14655 manish.sha 161 
				StringBuilder homeshopSaleHistory = new StringBuilder("");
12166 manish.sha 162 
 
163 
				ItemInventory itemInventory = inventoryMap.get(item.getId());
164 
				Map<Long, Long> availabilityMap;
165 
				if(itemInventory!= null) {
166 
					//System.out.println("itemId =" + item.getId());
167 
					availabilityMap = itemInventory.getAvailability();
168 
					for (Long warehouseId : availabilityMap.keySet()) {
169 
						if(ourWarehouseMap.containsKey(warehouseId)) {
170 
							long currentAvailability = availabilityMap.get(warehouseId);
171 
							//System.out.println("itemId =" + item.getId() + " availability = "+ currentAvailability);
172 
							stockCount += currentAvailability;
173 
							if(currentAvailability>0) {
174 
								List<VendorItemPricing> pricingList = itemPricingMap.get(item.getId());
175 
								for(VendorItemPricing vendorItemPricing: pricingList) {
176 
									if(vendorItemPricing.getVendorId() == ourWarehouseMap.get(warehouseId).getVendor().getId()) {
177 
										stockValue = stockValue + (vendorItemPricing.getNlc()*currentAvailability);
178 
									}
179 
								}
180 
							}
181 
						}
182 
					}
183 
				}
184 
				if(stockCount<=0) {
185 
					continue;
186 
				}
12221 manish.sha 187 
				if(oosStatusMapByItem.containsKey(item.getId())){
188 
					for(OOSStatus oosStatus : oosStatusMapByItem.get(item.getId())) {
189 
						switch(oosStatus.getSourceId()) {
190 
						case 0:
191 
							if(oosStatus.isIs_oos()== false) {
192 
								totalInStockDays++;
193 
								totalOrderCount += oosStatus.getNum_orders();
194 
								totalSaleHistory.append(oosStatus.getNum_orders() + "-");
195 
							} else {
196 
								totalSaleHistory.append("X-");
197 
							}
198 
							break;
199 
						case 1:
200 
							if(oosStatus.isIs_oos()== false) {
201 
								websiteInStockDays++;
202 
								websiteOrderCount += oosStatus.getNum_orders();
203 
								websiteSaleHistory.append(oosStatus.getNum_orders() + "-");
204 
							} else {
205 
								websiteSaleHistory.append("X-");
206 
							}
207 
							break;
208 
						case 3:
209 
							if(oosStatus.isIs_oos()== false) {
210 
								amzn_mfnInStockDays++;
211 
								amzn_mfnOrderCount += oosStatus.getNum_orders();
212 
								amzn_mfnSaleHistory.append(oosStatus.getNum_orders() + "-");
213 
							} else {
214 
								amzn_mfnSaleHistory.append("X-");
215 
							}
216 
							break;
14655 manish.sha 217 
						case 4:
218 
							if(oosStatus.isIs_oos()== false) {
219 
								homeshopInStockDays++;
220 
								homeshopOrderCount += oosStatus.getNum_orders();
221 
								homeshopSaleHistory.append(oosStatus.getNum_orders() + "-");
222 
							} else {
14657 manish.sha 223 
								homeshopSaleHistory.append("X-");
14655 manish.sha 224 
							}
225 
							break;
12221 manish.sha 226 
						case 6:
227 
							if(oosStatus.isIs_oos()== false) {
228 
								ebayInStockDays++;
229 
								ebayOrderCount += oosStatus.getNum_orders();
230 
								ebaySaleHistory.append(oosStatus.getNum_orders() + "-");
231 
							} else {
232 
								ebaySaleHistory.append("X-");
233 
							}
234 
							break;
235 
						case 7:
236 
							if(oosStatus.isIs_oos()== false) {
237 
								snapdealInStockDays++;
238 
								snapdealOrderCount += oosStatus.getNum_orders();
239 
								snapdealSaleHistory.append(oosStatus.getNum_orders() + "-");
240 
							} else {
241 
								snapdealSaleHistory.append("X-");
242 
							}
243 
							break;
244 
						case 8:
245 
							if(oosStatus.isIs_oos()== false) {
246 
								flipkartInStockDays++;
247 
								flipkartOrderCount += oosStatus.getNum_orders();
248 
								flipkartSaleHistory.append(oosStatus.getNum_orders() + "-");
249 
							} else {
250 
								flipkartSaleHistory.append("X-");
251 
							}
252 
							break;
253 
						default:
254 
							//do nothing
255 
							break;
12166 manish.sha 256 
						}
257 
					}
258 
				}
12221 manish.sha 259 
				else{
260 
					System.out.println("Oos Status is not available for item : - "+ item.getId());
12222 manish.sha 261 
					continue;
12221 manish.sha 262 
				}
12166 manish.sha 263 
				totalAverageSale    = (double)totalOrderCount/totalInStockDays;
12178 manish.sha 264 
				totalAverageSale    = Math.round(totalAverageSale * 10.0)/10.0;
12166 manish.sha 265 
				websiteAverageSale  = (double)websiteOrderCount/websiteInStockDays;
12178 manish.sha 266 
				websiteAverageSale  = Math.round(websiteAverageSale * 10.0)/10.0;
12166 manish.sha 267 
				ebayAverageSale     = (double)ebayOrderCount/ebayInStockDays;
12178 manish.sha 268 
				ebayAverageSale     = Math.round(ebayAverageSale * 10.0)/10.0;
12166 manish.sha 269 
				snapdealAverageSale = (double)snapdealOrderCount/snapdealInStockDays;
12178 manish.sha 270 
				snapdealAverageSale = Math.round(snapdealAverageSale * 10.0)/10.0;
12166 manish.sha 271 
				flipkartAverageSale = (double)flipkartOrderCount/flipkartInStockDays;
12178 manish.sha 272 
				flipkartAverageSale = Math.round(flipkartAverageSale * 10.0)/10.0;
12166 manish.sha 273 
				amzn_mfnAverageSale = (double)amzn_mfnOrderCount/amzn_mfnInStockDays;
12178 manish.sha 274 
				amzn_mfnAverageSale = Math.round(amzn_mfnAverageSale * 10.0)/10.0;
14655 manish.sha 275 
				homeshopAverageSale = (double)homeshopOrderCount/homeshopInStockDays;
276 
				homeshopAverageSale = Math.round(homeshopAverageSale * 10.0)/10.0;
12166 manish.sha 277 
 
278 
				if(totalAverageSale<=0.0) {
279 
					StockSaleDetail ssDetail = new StockSaleDetail();
280 
					ssDetail.setItemId(item.getId());
281 
					ssDetail.setCategory(categoryIdLabelMap.get(item.getCategory()));
282 
					ssDetail.setProductGroup(item.getProductGroup());
283 
					ssDetail.setBrand(item.getBrand());
284 
					ssDetail.setModelName(item.getModelName());
285 
					ssDetail.setModelNumber(item.getModelNumber());
286 
					ssDetail.setColor(item.getColor());
287 
					ssDetail.setStockQuantity(stockCount);
288 
					ssDetail.setStockValue(stockValue);
289 
					ssDetail.setNodStock(totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()) : 0);
290 
					ssDetail.setSalesHistoryAll(totalSaleHistory.substring(0, totalSaleHistory.length()-1));
291 
					ssDetail.setAvgSalesAll(totalAverageSale);
292 
					ssDetail.setSalesHistoryWS(websiteSaleHistory.substring(0, websiteSaleHistory.length()-1));
293 
					ssDetail.setAvgSalesWS(websiteAverageSale);
294 
					ssDetail.setSalesHistoryEbay(ebaySaleHistory.substring(0, ebaySaleHistory.length()-1));
295 
					ssDetail.setAvgSalesEbay(ebayAverageSale);
296 
					ssDetail.setSalesHistorySD(snapdealSaleHistory.substring(0, snapdealSaleHistory.length()-1));
297 
					ssDetail.setAvgSalesSD(snapdealAverageSale);
298 
					ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));
299 
					ssDetail.setAvgSalesFK(flipkartAverageSale);
300 
					ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));
301 
					ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);
14655 manish.sha 302 
					ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));
303 
					ssDetail.setAvgSalesHomeShop(homeshopAverageSale);
12166 manish.sha 304 
					if(item.getCategory() == 10006 || item.getCategory() == 10010){
305 
						nonMovingStockSaleListMT.add(ssDetail);
306 
					} else {
307 
						nonMovingStockSaleListEMT.add(ssDetail);
308 
					}
309 
				}
310 
				else {
311 
					double nodStock = totalAverageSale > 0 ? new Double(stockCount/totalAverageSale): 0;
312 
					if(nodStock>30) {
313 
						StockSaleDetail ssDetail = new StockSaleDetail();
314 
						ssDetail.setItemId(item.getId());
315 
						ssDetail.setCategory(categoryIdLabelMap.get(item.getCategory()));
316 
						ssDetail.setProductGroup(item.getProductGroup());
317 
						ssDetail.setBrand(item.getBrand());
318 
						ssDetail.setModelName(item.getModelName());
319 
						ssDetail.setModelNumber(item.getModelNumber());
320 
						ssDetail.setColor(item.getColor());
321 
						ssDetail.setStockQuantity(stockCount);
322 
						ssDetail.setStockValue(stockValue);
323 
						ssDetail.setNodStock(totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()) : 0);
324 
						ssDetail.setSalesHistoryAll(totalSaleHistory.substring(0, totalSaleHistory.length()-1));
325 
						ssDetail.setAvgSalesAll(totalAverageSale);
326 
						ssDetail.setSalesHistoryWS(websiteSaleHistory.substring(0, websiteSaleHistory.length()-1));
327 
						ssDetail.setAvgSalesWS(websiteAverageSale);
328 
						ssDetail.setSalesHistoryEbay(ebaySaleHistory.substring(0, ebaySaleHistory.length()-1));
329 
						ssDetail.setAvgSalesEbay(ebayAverageSale);
330 
						ssDetail.setSalesHistorySD(snapdealSaleHistory.substring(0, snapdealSaleHistory.length()-1));
331 
						ssDetail.setAvgSalesSD(snapdealAverageSale);
332 
						ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));
333 
						ssDetail.setAvgSalesFK(flipkartAverageSale);
334 
						ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));
335 
						ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);
14655 manish.sha 336 
						ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));
337 
						ssDetail.setAvgSalesHomeShop(homeshopAverageSale);
12166 manish.sha 338 
						if(item.getCategory() == 10006 || item.getCategory() == 10010){
339 
							slowMovingStockSaleListMT.add(ssDetail);
340 
						} else {
341 
							slowMovingStockSaleListEMT.add(ssDetail);
342 
						}
343 
					} else {
344 
						StockSaleDetail ssDetail = new StockSaleDetail();
345 
						ssDetail.setItemId(item.getId());
346 
						ssDetail.setCategory(categoryIdLabelMap.get(item.getCategory()));
347 
						ssDetail.setProductGroup(item.getProductGroup());
348 
						ssDetail.setBrand(item.getBrand());
349 
						ssDetail.setModelName(item.getModelName());
350 
						ssDetail.setModelNumber(item.getModelNumber());
351 
						ssDetail.setColor(item.getColor());
352 
						ssDetail.setStockQuantity(stockCount);
353 
						ssDetail.setStockValue(stockValue);
354 
						ssDetail.setNodStock(totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()) : 0);
355 
						ssDetail.setSalesHistoryAll(totalSaleHistory.substring(0, totalSaleHistory.length()-1));
356 
						ssDetail.setAvgSalesAll(totalAverageSale);
357 
						ssDetail.setSalesHistoryWS(websiteSaleHistory.substring(0, websiteSaleHistory.length()-1));
358 
						ssDetail.setAvgSalesWS(websiteAverageSale);
359 
						ssDetail.setSalesHistoryEbay(ebaySaleHistory.substring(0, ebaySaleHistory.length()-1));
360 
						ssDetail.setAvgSalesEbay(ebayAverageSale);
361 
						ssDetail.setSalesHistorySD(snapdealSaleHistory.substring(0, snapdealSaleHistory.length()-1));
362 
						ssDetail.setAvgSalesSD(snapdealAverageSale);
363 
						ssDetail.setSalesHistoryFK(flipkartSaleHistory.substring(0, flipkartSaleHistory.length()-1));
364 
						ssDetail.setAvgSalesFK(flipkartAverageSale);
365 
						ssDetail.setSalesHistoryMFN(amzn_mfnSaleHistory.substring(0, amzn_mfnSaleHistory.length()-1));
366 
						ssDetail.setAvgSalesMFN(amzn_mfnAverageSale);
14655 manish.sha 367 
						ssDetail.setSalesHistoryHomeShop(homeshopSaleHistory.substring(0, homeshopSaleHistory.length()-1));
368 
						ssDetail.setAvgSalesHomeShop(homeshopAverageSale);
12166 manish.sha 369 
						if(item.getCategory() == 10006 || item.getCategory() == 10010){
370 
							movingStockSaleListMT.add(ssDetail);
371 
						} else {
372 
							movingStockSaleListEMT.add(ssDetail);
373 
						}
374 
					}
375 
				}
376 
			}
377 
 
378 
			if(movingStockSaleListMT!=null && movingStockSaleListMT.size()>2){
379 
				Collections.sort(movingStockSaleListMT, new MovingStockSaleDetailComparator());
380 
			}
381 
			if(movingStockSaleListEMT!=null && movingStockSaleListEMT.size()>2){
382 
				Collections.sort(movingStockSaleListEMT, new MovingStockSaleDetailComparator());
383 
			}
384 
			if(slowMovingStockSaleListMT!=null && slowMovingStockSaleListMT.size()>2){
385 
				Collections.sort(slowMovingStockSaleListMT, new SnmMovingStockSaleDetailComparator());
386 
			}
387 
			if(slowMovingStockSaleListEMT!=null && slowMovingStockSaleListEMT.size()>2){
388 
				Collections.sort(slowMovingStockSaleListEMT, new SnmMovingStockSaleDetailComparator());
389 
			}
390 
			if(nonMovingStockSaleListMT!=null && nonMovingStockSaleListMT.size()>2){
391 
				Collections.sort(nonMovingStockSaleListMT, new SnmMovingStockSaleDetailComparator());
392 
			}
393 
			if(nonMovingStockSaleListEMT!=null && nonMovingStockSaleListEMT.size()>2){
394 
				Collections.sort(nonMovingStockSaleListEMT, new SnmMovingStockSaleDetailComparator());
395 
			}
12221 manish.sha 396 
 
397 
 
12220 manish.sha 398 
			List<StockSaleDetail> itemToReplenishMT = new ArrayList<StockSaleDetail>();
399 
			List<StockSaleDetail> itemToReplenishEMT = new ArrayList<StockSaleDetail>();
400 
			for(StockSaleDetail ssDetail  : movingStockSaleListMT){
401 
				if(ssDetail.getNodStock() <= 5){
402 
					itemToReplenishMT.add(ssDetail);
403 
				}
404 
			}
405 
			for(StockSaleDetail ssDetail  : movingStockSaleListEMT){
406 
				if(ssDetail.getNodStock() <= 5){
407 
					itemToReplenishEMT.add(ssDetail);
408 
				}
409 
			}
12221 manish.sha 410 
 
12220 manish.sha 411 
			if(itemToReplenishMT!=null && itemToReplenishMT.size()>2){
412 
				Collections.sort(itemToReplenishMT, new MovingStockSaleDetailComparator());
413 
			}
414 
			if(itemToReplenishEMT!=null && itemToReplenishEMT.size()>2){
415 
				Collections.sort(itemToReplenishEMT, new MovingStockSaleDetailComparator());
416 
			}
12221 manish.sha 417 
 
12166 manish.sha 418 
			StringBuffer sb = new StringBuffer();
419 
			sb.append("<html>" );
420 
			sb.append("<table border=\"1\" align=\"center\">"
421 
					+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
422 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
423 
					+ "<td><b>" + "BRAND" + "</b></td>"
424 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
425 
					+ "<td><b>" + "PRODUCT-GROUP" + "</b></td>"
426 
					+ "<td><b>" + "PRODUCT-NAME" + "</b></td>"
427 
					+ "<td><b>" + "STOCK-QTY" + "</b></td>"
428 
					+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
429 
					+ "<td><b>" + "NOD-STOCK" + "</b></td>"
430 
					+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
431 
					+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
432 
					+ "</tr>");
433 
			int i=1;
12220 manish.sha 434 
			for(StockSaleDetail ssDetail  : itemToReplenishMT){
12166 manish.sha 435 
				if(i==10){
436 
					break;
437 
				}
438 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
12221 manish.sha 439 
						+ "<td>" + ssDetail.getBrand() + "</td>"
440 
						+ "<td>" + ssDetail.getCategory() + "</td>"
441 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
442 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
443 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
444 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
445 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
446 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
447 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
448 
						+ "</tr>");
12166 manish.sha 449 
				i++;
450 
			}
12221 manish.sha 451 
 
12166 manish.sha 452 
			sb.append("</table>" );
12221 manish.sha 453 
 
12166 manish.sha 454 
			sb.append("<table border=\"1\" align=\"center\">"
455 
					+ "<caption><b>" + "SLOW MOVING ITEMS" + "</b></caption>"
456 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
457 
					+ "<td><b>" + "BRAND" + "</b></td>"
458 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
459 
					+ "<td><b>" + "PRODUCT-GROUP" + "</b></td>"
460 
					+ "<td><b>" + "PRODUCT-NAME" + "</b></td>"
461 
					+ "<td><b>" + "STOCK-QTY" + "</b></td>"
462 
					+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
463 
					+ "<td><b>" + "NOD-STOCK" + "</b></td>"
464 
					+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
465 
					+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
466 
					+ "</tr>");
467 
			i=1;
468 
			for(StockSaleDetail ssDetail  : slowMovingStockSaleListMT){
469 
				if(i==10){
470 
					break;
471 
				}
472 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
12221 manish.sha 473 
						+ "<td>" + ssDetail.getBrand() + "</td>"
474 
						+ "<td>" + ssDetail.getCategory() + "</td>"
475 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
476 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
477 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
478 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
479 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
480 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
481 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
482 
						+ "</tr>");
12166 manish.sha 483 
				i++;
484 
			}
12221 manish.sha 485 
 
12166 manish.sha 486 
			sb.append("</table>" );
12221 manish.sha 487 
 
12166 manish.sha 488 
			sb.append("<table border=\"1\" align=\"center\">"
489 
					+ "<caption><b>" + "NON MOVING ITEMS" + "</b></caption>"
490 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
491 
					+ "<td><b>" + "BRAND" + "</b></td>"
492 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
493 
					+ "<td><b>" + "PRODUCT-GROUP" + "</b></td>"
494 
					+ "<td><b>" + "PRODUCT-NAME" + "</b></td>"
495 
					+ "<td><b>" + "STOCK-QTY" + "</b></td>"
496 
					+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
497 
					+ "<td><b>" + "NOD-STOCK" + "</b></td>"
498 
					+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
499 
					+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
500 
					+ "</tr>");
501 
			i=1;
502 
			for(StockSaleDetail ssDetail  : nonMovingStockSaleListMT){
503 
				if(i==10){
504 
					break;
505 
				}
506 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
12221 manish.sha 507 
						+ "<td>" + ssDetail.getBrand() + "</td>"
508 
						+ "<td>" + ssDetail.getCategory() + "</td>"
509 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
510 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
511 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
512 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
513 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
514 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
515 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
516 
						+ "</tr>");
12166 manish.sha 517 
				i++;
518 
			}
12221 manish.sha 519 
 
12166 manish.sha 520 
			sb.append("</table>");
521 
			sb.append("</html>");
12221 manish.sha 522 
 
12166 manish.sha 523 
			BufferedWriter out = new BufferedWriter(new FileWriter("/tmp/MobileTablets-StockSales-file.htm"));
524 
			out.write(sb.toString());
525 
			out.flush();
526 
			out.close();
12221 manish.sha 527 
 
528 
 
12166 manish.sha 529 
			sb = new StringBuffer();
530 
			sb.append("<html>" );
531 
			sb.append("<table border=\"1\" align=\"center\">"
532 
					+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
533 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
534 
					+ "<td><b>" + "BRAND" + "</b></td>"
535 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
536 
					+ "<td><b>" + "PRODUCT-GROUP" + "</b></td>"
537 
					+ "<td><b>" + "PRODUCT-NAME" + "</b></td>"
538 
					+ "<td><b>" + "STOCK-QTY" + "</b></td>"
539 
					+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
540 
					+ "<td><b>" + "NOD-STOCK" + "</b></td>"
541 
					+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
542 
					+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
543 
					+ "</tr>");
544 
			i=1;
12220 manish.sha 545 
			for(StockSaleDetail ssDetail  : itemToReplenishEMT){
12166 manish.sha 546 
				if(i==10){
547 
					break;
548 
				}
549 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
12221 manish.sha 550 
						+ "<td>" + ssDetail.getBrand() + "</td>"
551 
						+ "<td>" + ssDetail.getCategory() + "</td>"
552 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
553 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
554 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
555 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
556 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
557 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
558 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
559 
						+ "</tr>");
12166 manish.sha 560 
				i++;
561 
			}
12221 manish.sha 562 
 
12166 manish.sha 563 
			sb.append("</table>" );
12221 manish.sha 564 
 
12166 manish.sha 565 
			sb.append("<table border=\"1\" align=\"center\">"
566 
					+ "<caption><b>" + "SLOW MOVING ITEMS" + "</b></caption>"
567 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
568 
					+ "<td><b>" + "BRAND" + "</b></td>"
569 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
570 
					+ "<td><b>" + "PRODUCT-GROUP" + "</b></td>"
571 
					+ "<td><b>" + "PRODUCT-NAME" + "</b></td>"
572 
					+ "<td><b>" + "STOCK-QTY" + "</b></td>"
573 
					+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
574 
					+ "<td><b>" + "NOD-STOCK" + "</b></td>"
575 
					+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
576 
					+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
577 
					+ "</tr>");
578 
			i=1;
579 
			for(StockSaleDetail ssDetail  : slowMovingStockSaleListEMT){
580 
				if(i==10){
581 
					break;
582 
				}
583 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
12221 manish.sha 584 
						+ "<td>" + ssDetail.getBrand() + "</td>"
585 
						+ "<td>" + ssDetail.getCategory() + "</td>"
586 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
587 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
588 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
589 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
590 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
591 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
592 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
593 
						+ "</tr>");
12166 manish.sha 594 
				i++;
595 
			}
12221 manish.sha 596 
 
12166 manish.sha 597 
			sb.append("</table>" );
12221 manish.sha 598 
 
12166 manish.sha 599 
			sb.append("<table border=\"1\" align=\"center\">"
600 
					+ "<caption><b>" + "NON MOVING ITEMS" + "</b></caption>"
601 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
602 
					+ "<td><b>" + "BRAND" + "</b></td>"
603 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
604 
					+ "<td><b>" + "PRODUCT-GROUP" + "</b></td>"
605 
					+ "<td><b>" + "PRODUCT-NAME" + "</b></td>"
606 
					+ "<td><b>" + "STOCK-QTY" + "</b></td>"
607 
					+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
608 
					+ "<td><b>" + "NOD-STOCK" + "</b></td>"
609 
					+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
610 
					+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
611 
					+ "</tr>");
612 
			i=1;
613 
			for(StockSaleDetail ssDetail  : nonMovingStockSaleListEMT){
614 
				if(i==10){
615 
					break;
616 
				}
617 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
12221 manish.sha 618 
						+ "<td>" + ssDetail.getBrand() + "</td>"
619 
						+ "<td>" + ssDetail.getCategory() + "</td>"
620 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
621 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
622 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
623 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
624 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
625 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
626 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
627 
						+ "</tr>");
12166 manish.sha 628 
				i++;
629 
			}
12221 manish.sha 630 
 
12166 manish.sha 631 
			sb.append("</table>");
632 
			sb.append("</html>");
12221 manish.sha 633 
 
12166 manish.sha 634 
			out = new BufferedWriter(new FileWriter("/tmp/ExceptMobileTablets-StockSales-file.htm"));
635 
			out.write(sb.toString());
636 
			out.flush();
637 
			out.close();
12221 manish.sha 638 
 
12177 manish.sha 639 
			createXlsFile(movingStockSaleListMT, slowMovingStockSaleListMT, nonMovingStockSaleListMT, true);
640 
			createXlsFile(movingStockSaleListEMT, slowMovingStockSaleListEMT, nonMovingStockSaleListEMT, false);
12166 manish.sha 641 
 
12221 manish.sha 642 
 
12166 manish.sha 643 
			GmailUtils mailer = new GmailUtils();
12234 manish.sha 644 
			mailer.sendSSLMessage(mailToMT, "Stock Sales Report - Mobile And Tablets ", "", senderAccountMail, senderAccountPswd, tmpDir +"/"+ stockSalesReportMT.getName(), "/tmp/MobileTablets-StockSales-file.htm");
19353 manish.sha 645 
			mailer.sendSSLMessage(mailToMT, "Stock Sales Report - Except Mobile And Tablets ", "", senderAccountMail, senderAccountPswd, tmpDir +"/"+stockSalesReportEMT.getName(), "/tmp/ExceptMobileTablets-StockSales-file.htm");
12166 manish.sha 646 
		} catch (Exception e) {
647 
			logger.error("Error in generating/sending Stock Sales Report", e);
648 
		}
649 
 
650 
 
651 
	}
652 
 
12177 manish.sha 653 
	private static void createXlsFile(List<StockSaleDetail> movingStockSaleList,
12166 manish.sha 654 
			List<StockSaleDetail> slowMovingStockSaleList,
655 
			List<StockSaleDetail> nonMovingStockSaleList,
656 
			boolean mobTab) {
657 
		try{
12177 manish.sha 658 
			HSSFWorkbook workbook = new HSSFWorkbook();
659 
			HSSFSheet movingSheet = workbook.createSheet("Moving-Stock");
660 
			HSSFSheet nonMovingSheet = workbook.createSheet("Non-Moving-Stock");
661 
			HSSFSheet slowMovingSheet = workbook.createSheet("Slow-Moving-Stock");
12166 manish.sha 662 
			Row row = movingSheet.createRow(0);
663 
 
664 
			row.createCell(0).setCellValue("ItemId");
665 
			row.createCell(1).setCellValue("Category");
666 
			row.createCell(2).setCellValue("ProductGroup");
667 
			row.createCell(3).setCellValue("Brand");
668 
			row.createCell(4).setCellValue("Model Name");
669 
			row.createCell(5).setCellValue("Model Number");
670 
			row.createCell(6).setCellValue("Color");
671 
			row.createCell(7).setCellValue("Product");
672 
			row.createCell(8).setCellValue("Stock Qty");
673 
			row.createCell(9).setCellValue("Stock Value");
674 
			row.createCell(10).setCellValue("NOD Stock");
675 
			row.createCell(11).setCellValue("Sales History(All-Sources)");
676 
			row.createCell(12).setCellValue("Avg Sales(All-Sources)");
677 
			row.createCell(13).setCellValue("Sales History(Website)");
678 
			row.createCell(14).setCellValue("Avg Sales(Website)");
679 
			row.createCell(15).setCellValue("Sales History(Ebay)");
680 
			row.createCell(16).setCellValue("Avg Sales(Ebay)");
681 
			row.createCell(17).setCellValue("Sales History(Snapdeal)");
682 
			row.createCell(18).setCellValue("Avg Sales(Snapdeal)");
683 
			row.createCell(19).setCellValue("Sales History(Flipkart)");
684 
			row.createCell(20).setCellValue("Avg Sales(Flipkart)");
685 
			row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
686 
			row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
14655 manish.sha 687 
			row.createCell(23).setCellValue("Sales History(HomeShop18)");
688 
			row.createCell(24).setCellValue("Avg Sales(HomeShop18)");
689 
 
12166 manish.sha 690 
			int i=1;
691 
			for(StockSaleDetail ssDetail : movingStockSaleList){
692 
				row = movingSheet.createRow(i);
693 
				row.createCell(0).setCellValue(ssDetail.getItemId()+"");
694 
				row.createCell(1).setCellValue(ssDetail.getCategory());
695 
				row.createCell(2).setCellValue(ssDetail.getProductGroup());
696 
				row.createCell(3).setCellValue(ssDetail.getBrand());
697 
				row.createCell(4).setCellValue(ssDetail.getModelName());
698 
				row.createCell(5).setCellValue(ssDetail.getModelNumber());
699 
				row.createCell(6).setCellValue(ssDetail.getColor());
700 
				row.createCell(7).setCellValue(ssDetail.getBrand()+" "+ssDetail.getModelName()+" "+ssDetail.getModelNumber()+" "+ssDetail.getColor());
701 
				row.createCell(8).setCellValue(ssDetail.getStockQuantity()+"");
702 
				row.createCell(9).setCellValue(ssDetail.getStockValue()+"");
703 
				row.createCell(10).setCellValue(ssDetail.getNodStock()+"");
704 
				row.createCell(11).setCellValue(ssDetail.getSalesHistoryAll());
705 
				row.createCell(12).setCellValue(ssDetail.getAvgSalesAll()+"");
706 
				row.createCell(13).setCellValue(ssDetail.getSalesHistoryWS());
707 
				row.createCell(14).setCellValue(ssDetail.getAvgSalesWS()+"");
708 
				row.createCell(15).setCellValue(ssDetail.getSalesHistoryEbay());
709 
				row.createCell(16).setCellValue(ssDetail.getAvgSalesEbay()+"");
710 
				row.createCell(17).setCellValue(ssDetail.getSalesHistorySD());
711 
				row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");
712 
				row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());
713 
				row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");
714 
				row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());
715 
				row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());
14655 manish.sha 716 
				row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());
717 
				row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");
12166 manish.sha 718 
				i++;
719 
			}
720 
 
721 
			row = nonMovingSheet.createRow(0);
722 
 
723 
			row.createCell(0).setCellValue("ItemId");
724 
			row.createCell(1).setCellValue("Category");
725 
			row.createCell(2).setCellValue("ProductGroup");
726 
			row.createCell(3).setCellValue("Brand");
727 
			row.createCell(4).setCellValue("Model Name");
728 
			row.createCell(5).setCellValue("Model Number");
729 
			row.createCell(6).setCellValue("Color");
730 
			row.createCell(7).setCellValue("Product");
731 
			row.createCell(8).setCellValue("Stock Qty");
732 
			row.createCell(9).setCellValue("Stock Value");
733 
			row.createCell(10).setCellValue("NOD Stock");
734 
			row.createCell(11).setCellValue("Sales History(All-Sources)");
735 
			row.createCell(12).setCellValue("Avg Sales(All-Sources)");
736 
			row.createCell(13).setCellValue("Sales History(Website)");
737 
			row.createCell(14).setCellValue("Avg Sales(Website)");
738 
			row.createCell(15).setCellValue("Sales History(Ebay)");
739 
			row.createCell(16).setCellValue("Avg Sales(Ebay)");
740 
			row.createCell(17).setCellValue("Sales History(Snapdeal)");
741 
			row.createCell(18).setCellValue("Avg Sales(Snapdeal)");
742 
			row.createCell(19).setCellValue("Sales History(Flipkart)");
743 
			row.createCell(20).setCellValue("Avg Sales(Flipkart)");
744 
			row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
745 
			row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
14655 manish.sha 746 
			row.createCell(23).setCellValue("Sales History(HomeShop18)");
747 
			row.createCell(24).setCellValue("Avg Sales(HomeShop18)");
12166 manish.sha 748 
 
749 
			i=1;
750 
			for(StockSaleDetail ssDetail : nonMovingStockSaleList){
12179 manish.sha 751 
				row = nonMovingSheet.createRow(i);
12166 manish.sha 752 
				row.createCell(0).setCellValue(ssDetail.getItemId()+"");
753 
				row.createCell(1).setCellValue(ssDetail.getCategory());
754 
				row.createCell(2).setCellValue(ssDetail.getProductGroup());
755 
				row.createCell(3).setCellValue(ssDetail.getBrand());
756 
				row.createCell(4).setCellValue(ssDetail.getModelName());
757 
				row.createCell(5).setCellValue(ssDetail.getModelNumber());
758 
				row.createCell(6).setCellValue(ssDetail.getColor());
759 
				row.createCell(7).setCellValue(ssDetail.getBrand()+" "+ssDetail.getModelName()+" "+ssDetail.getModelNumber()+" "+ssDetail.getColor());
760 
				row.createCell(8).setCellValue(ssDetail.getStockQuantity()+"");
761 
				row.createCell(9).setCellValue(ssDetail.getStockValue()+"");
762 
				row.createCell(10).setCellValue(ssDetail.getNodStock()+"");
763 
				row.createCell(11).setCellValue(ssDetail.getSalesHistoryAll());
764 
				row.createCell(12).setCellValue(ssDetail.getAvgSalesAll()+"");
765 
				row.createCell(13).setCellValue(ssDetail.getSalesHistoryWS());
766 
				row.createCell(14).setCellValue(ssDetail.getAvgSalesWS()+"");
767 
				row.createCell(15).setCellValue(ssDetail.getSalesHistoryEbay());
768 
				row.createCell(16).setCellValue(ssDetail.getAvgSalesEbay()+"");
769 
				row.createCell(17).setCellValue(ssDetail.getSalesHistorySD());
770 
				row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");
771 
				row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());
772 
				row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");
773 
				row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());
774 
				row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());
14655 manish.sha 775 
				row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());
776 
				row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");
12166 manish.sha 777 
				i++;
778 
			}
779 
 
780 
			row = slowMovingSheet.createRow(0);
781 
 
782 
			row.createCell(0).setCellValue("ItemId");
783 
			row.createCell(1).setCellValue("Category");
784 
			row.createCell(2).setCellValue("ProductGroup");
785 
			row.createCell(3).setCellValue("Brand");
786 
			row.createCell(4).setCellValue("Model Name");
787 
			row.createCell(5).setCellValue("Model Number");
788 
			row.createCell(6).setCellValue("Color");
789 
			row.createCell(7).setCellValue("Product");
790 
			row.createCell(8).setCellValue("Stock Qty");
791 
			row.createCell(9).setCellValue("Stock Value");
792 
			row.createCell(10).setCellValue("NOD Stock");
793 
			row.createCell(11).setCellValue("Sales History(All-Sources)");
794 
			row.createCell(12).setCellValue("Avg Sales(All-Sources)");
795 
			row.createCell(13).setCellValue("Sales History(Website)");
796 
			row.createCell(14).setCellValue("Avg Sales(Website)");
797 
			row.createCell(15).setCellValue("Sales History(Ebay)");
798 
			row.createCell(16).setCellValue("Avg Sales(Ebay)");
799 
			row.createCell(17).setCellValue("Sales History(Snapdeal)");
800 
			row.createCell(18).setCellValue("Avg Sales(Snapdeal)");
801 
			row.createCell(19).setCellValue("Sales History(Flipkart)");
802 
			row.createCell(20).setCellValue("Avg Sales(Flipkart)");
803 
			row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
804 
			row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
14655 manish.sha 805 
			row.createCell(23).setCellValue("Sales History(HomeShop18)");
806 
			row.createCell(24).setCellValue("Avg Sales(HomeShop18)");
12166 manish.sha 807 
 
808 
			i=1;
809 
			for(StockSaleDetail ssDetail : slowMovingStockSaleList){
12179 manish.sha 810 
				row = slowMovingSheet.createRow(i);
12166 manish.sha 811 
				row.createCell(0).setCellValue(ssDetail.getItemId()+"");
812 
				row.createCell(1).setCellValue(ssDetail.getCategory());
813 
				row.createCell(2).setCellValue(ssDetail.getProductGroup());
814 
				row.createCell(3).setCellValue(ssDetail.getBrand());
815 
				row.createCell(4).setCellValue(ssDetail.getModelName());
816 
				row.createCell(5).setCellValue(ssDetail.getModelNumber());
817 
				row.createCell(6).setCellValue(ssDetail.getColor());
818 
				row.createCell(7).setCellValue(ssDetail.getBrand()+" "+ssDetail.getModelName()+" "+ssDetail.getModelNumber()+" "+ssDetail.getColor());
819 
				row.createCell(8).setCellValue(ssDetail.getStockQuantity()+"");
820 
				row.createCell(9).setCellValue(ssDetail.getStockValue()+"");
821 
				row.createCell(10).setCellValue(ssDetail.getNodStock()+"");
822 
				row.createCell(11).setCellValue(ssDetail.getSalesHistoryAll());
823 
				row.createCell(12).setCellValue(ssDetail.getAvgSalesAll()+"");
824 
				row.createCell(13).setCellValue(ssDetail.getSalesHistoryWS());
825 
				row.createCell(14).setCellValue(ssDetail.getAvgSalesWS()+"");
826 
				row.createCell(15).setCellValue(ssDetail.getSalesHistoryEbay());
827 
				row.createCell(16).setCellValue(ssDetail.getAvgSalesEbay()+"");
828 
				row.createCell(17).setCellValue(ssDetail.getSalesHistorySD());
829 
				row.createCell(18).setCellValue(ssDetail.getAvgSalesSD()+"");
830 
				row.createCell(19).setCellValue(ssDetail.getSalesHistoryFK());
831 
				row.createCell(20).setCellValue(ssDetail.getAvgSalesFK()+"");
832 
				row.createCell(21).setCellValue(ssDetail.getSalesHistoryMFN());
833 
				row.createCell(22).setCellValue(ssDetail.getAvgSalesMFN());
14655 manish.sha 834 
				row.createCell(23).setCellValue(ssDetail.getSalesHistoryHomeShop());
835 
				row.createCell(24).setCellValue(ssDetail.getAvgSalesHomeShop()+"");
12166 manish.sha 836 
				i++;
837 
			}
838 
 
12177 manish.sha 839 
			FileOutputStream out = null;
12166 manish.sha 840 
			if(mobTab){
841 
				out = new FileOutputStream(stockSalesReportMT);
842 
			} else {
843 
				out = new FileOutputStream(stockSalesReportEMT);
844 
			}
12177 manish.sha 845 
			workbook.write(out);
12166 manish.sha 846 
			out.close();
847 
			System.out.println("Excel written successfully..");
848 
		}catch(Exception e){
849 
			e.printStackTrace();
850 
		}
851 
 
852 
	}
853 
 
854 
	public static void main(String[] args) {
855 
		createAndMailReport();
856 
	}
857 
 
858 
}