Subversion Repositories SmartDukaan

Rev

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