WebSVN – SmartDukaan – Diff – /trunk/FlipkartFeeds/src/main/java/in/shop2020/NlcLeftOutInventoryDetailScript.java

 //import inventory.SnapdealItemForInventory;
 import java.io.BufferedReader;
 import java.io.BufferedWriter;
 import java.io.File;
+import java.io.FileReader;
 import java.io.FileWriter;
 import java.io.IOException;
 import java.io.InputStreamReader;
 import java.util.ArrayList;
 import java.util.Collections;
 	static {
 		emailFromAddress = "build-staging@shop2020.in";
 		password = "shop2020";
 		mailer = new GmailUtils();
 		sendTo = new String[] { "vikram.raghav@shop2020.in",
-				"manish.sharma@shop2020.in" };
+		"manish.sharma@shop2020.in" };
 		/*
 		 * sendTo = new String[]{ "sandeep.sachdeva@shop2020.in",
 		 * "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
 		 * "khushal.bhatia@shop2020.in"
 		 * ,"manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
 		} catch (TTransportException e1) {
 			// TODO Auto-generated catch block
 			e1.printStackTrace();
+		}
 		in.shop2020.model.v1.catalog.CatalogService.Client catalogClient = catalogServiceClient
-				.getClient();
+		.getClient();
 		try {
 			snapdealItems = catalogClient.getAllSnapdealItems();
 			flipkartItems = catalogClient.getAllFlipkartItems();
 		} catch (TException e) {
 			catalogServiceClient = new CatalogClient();
 		} catch (TTransportException e) {
 			e.printStackTrace();
+		}
 		in.shop2020.model.v1.catalog.CatalogService.Client catalogClient = catalogServiceClient
-				.getClient();
+		.getClient();
 		try {
 			List<Item> aliveItems = catalogClient.getAllAliveItems();
 			Map<Long, Item> aliveItemsMap = new HashMap<Long, Item>();
 			for (in.shop2020.model.v1.catalog.Item thriftItem : aliveItems) {
 				aliveItemsMap.put(thriftItem.getId(), thriftItem);
 				inventoryServiceClient = new InventoryClient();
 			} catch (TTransportException e) {
 				e.printStackTrace();
+			}
 			in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient
-					.getClient();
+			.getClient();
 			List<Vendor> allVendors = inventoryClient.getAllVendors();
 			for (Vendor v : allVendors) {
 				vendorDataMap.put(v.getId(), v.getName());
+			}
 			List<in.shop2020.model.v1.inventory.IgnoredInventoryUpdateItems> ignoreItems = inventoryClient
-					.getIgnoredWarehouseidsAndItemids();
+			.getIgnoredWarehouseidsAndItemids();
 			availability = inventoryClient.getInventorySnapshot(0);
 			List<Warehouse> allwarehouses = inventoryClient.getWarehouses(null,
 					null, 0, 0, 0);
 			Map<Long, Warehouse> allWarehousesMap = new HashMap<Long, Warehouse>();
 							if (warehouse.getBillingWarehouseId() != 7) {
 								if (warehouse.getLogisticsLocation().equals(
 										WarehouseLocation.Delhi)
 										&& warehouse.getWarehouseType().equals(
 												WarehouseType.THIRD_PARTY)
-										&& warehouse.getVendor().getId() != 1) {
+												&& warehouse.getVendor().getId() != 1) {
 								} else {
 									continue;
+								}
+							}
 							in.shop2020.model.v1.inventory.IgnoredInventoryUpdateItems ignoredItem = new in.shop2020.model.v1.inventory.IgnoredInventoryUpdateItems();
 							ignoredItem.setItemId(thriftItem.getId());
 							ignoredItem.setWarehouseId(warehouse.getId());
 							if (itemavailability.get(warehouse.getId()) != null
 									&& !thirdpartywarehouseids
-											.contains(warehouse.getId())
+									.contains(warehouse.getId())
 									&& !ignoreItems.contains(ignoredItem)) {
 								try {
 									nlc = inventoryClient.getNlcForWarehouse(
 											warehouse.getId(),
 											thriftItem.getId());
 								} catch (TTransportException e) {
 									inventoryClient = inventoryServiceClient
-											.getClient();
+									.getClient();
 									nlc = inventoryClient.getNlcForWarehouse(
 											warehouse.getId(),
 											thriftItem.getId());
+								}
 										// + total_held + "\theldForSource:" +
 										// heldForSource + "\tavailable:" +
 										// available);
 									} else {
 										long available = itemavailability
-												.get(warehouse.getId());
+										.get(warehouse.getId());
 										if (available > 0) {
 											nlcLOISD = new NlcLeftOutInventory();
 											nlcLOISD.setItemId(snapdealItem
 													.getItem_id());
 											nlcLOISD.setProductName(snapdealItem
 													.getBrand()
 													+ " "
 													+ snapdealItem
-															.getModel_name()
+													.getModel_name()
 													+ " "
 													+ snapdealItem
-															.getModel_number()
+													.getModel_number()
 													+ " "
 													+ snapdealItem.getColor());
 											nlcLOISD.setOurNlc(maxnlcSD);
 											nlcLOISD.setSkuAtSource(snapdealItem
 													.getSkuAtSnapdeal());
 										// + total_held + "\theldForSource:" +
 										// heldForSource + "\tavailable:" +
 										// available);
 									} else {
 										long available = itemavailability
-												.get(warehouse.getId());
+										.get(warehouse.getId());
 										if (available > 0) {
 											nlcLOIFK = new NlcLeftOutInventory();
 											nlcLOIFK.setItemId(flipkartItem
 													.getItem_id());
 											nlcLOIFK.setProductName(thriftItem
 													.getBrand()
 													+ " "
 													+ thriftItem.getModelName()
 													+ " "
 													+ thriftItem
-															.getModelNumber()
+													.getModelNumber()
 													+ " "
 													+ thriftItem.getColor());
 											nlcLOIFK.setOurNlc(maxnlcFK);
 											nlcLOIFK.setSkuAtSource(flipkartItem
 													.getSkuAtFlipkart());
 									.getBillingWarehouseId() != 7) {
 								if (allWarehousesMap.get(entry.getKey())
 										.getLogisticsLocation()
 										.equals(WarehouseLocation.Delhi)
 										&& allWarehousesMap
-												.get(entry.getKey())
+										.get(entry.getKey())
-												.getWarehouseType()
+										.getWarehouseType()
-												.equals(WarehouseType.THIRD_PARTY)
+										.equals(WarehouseType.THIRD_PARTY)
 										&& allWarehousesMap.get(entry.getKey())
-												.getVendor().getId() != 1) {
+										.getVendor().getId() != 1) {
 								} else {
 									continue;
+								}
+							}
 										// + total_held + "\theldForSource:" +
 										// heldForSource + "\tavailable:" +
 										// available);
 									} else {
 										long available = itemavailability
-												.get(entry.getKey());
+										.get(entry.getKey());
 										if (available > 0) {
 											nlcLOISD = new NlcLeftOutInventory();
 											nlcLOISD.setItemId(snapdealItem
 													.getItem_id());
 											nlcLOISD.setProductName(snapdealItem
 													.getBrand()
 													+ " "
 													+ snapdealItem
-															.getModel_name()
+													.getModel_name()
 													+ " "
 													+ snapdealItem
-															.getModel_number()
+													.getModel_number()
 													+ " "
 													+ snapdealItem.getColor());
 											nlcLOISD.setOurNlc(maxnlcSD);
 											nlcLOISD.setSkuAtSource(snapdealItem
 													.getSkuAtSnapdeal());
 										// + total_held + "\theldForSource:" +
 										// heldForSource + "\tavailable:" +
 										// available);
 									} else {
 										long available = itemavailability
-												.get(entry.getKey());
+										.get(entry.getKey());
 										if (available > 0) {
 											nlcLOIFK = new NlcLeftOutInventory();
 											nlcLOIFK.setItemId(flipkartItem
 													.getItem_id());
 											nlcLOIFK.setProductName(thriftItem
 													.getBrand()
 													+ " "
 													+ thriftItem.getModelName()
 													+ " "
 													+ thriftItem
-															.getModelNumber()
+													.getModelNumber()
 													+ " "
 													+ thriftItem.getColor());
 											nlcLOIFK.setOurNlc(maxnlcFK);
 											nlcLOIFK.setSkuAtSource(flipkartItem
 													.getSkuAtFlipkart());
 							if (warehouse.getBillingWarehouseId() != 7) {
 								if (warehouse.getLogisticsLocation().equals(
 										WarehouseLocation.Delhi)
 										&& warehouse.getWarehouseType().equals(
 												WarehouseType.THIRD_PARTY)
-										&& warehouse.getVendor().getId() != 1) {
+												&& warehouse.getVendor().getId() != 1) {
 								} else {
 									continue;
+								}
+							}
 							in.shop2020.model.v1.inventory.IgnoredInventoryUpdateItems ignoredItem = new in.shop2020.model.v1.inventory.IgnoredInventoryUpdateItems();
 							ignoredItem.setItemId(thriftItem.getId());
 							ignoredItem.setWarehouseId(warehouse.getId());
 							if (itemreserve.get(warehouse.getId()) != null
 									&& !thirdpartywarehouseids
-											.contains(warehouse.getId())
+									.contains(warehouse.getId())
 									&& !ignoreItems.contains(warehouse.getId())) {
 								nlc = inventoryClient.getNlcForWarehouse(
 										warehouse.getId(), thriftItem.getId());
 								// maxnlc =
 								// catalogClient.getSnapdealItem(thriftItem.getId()).getMaxNlc();
 									} else {
 										if (snapdealLeftInvDataMap
 												.containsKey(snapdealItem
 														.getSkuAtSnapdeal())) {
 											Map<Long, NlcLeftOutInventory> newNlcObjMap = snapdealLeftInvDataMap
-													.get(snapdealItem
+											.get(snapdealItem
-															.getSkuAtSnapdeal());
+													.getSkuAtSnapdeal());
 											if (newNlcObjMap
 													.containsKey(warehouse
 															.getId())) {
 												NlcLeftOutInventory newObj = newNlcObjMap
-														.get(warehouse.getId());
+												.get(warehouse.getId());
 												newObj.setReserved(itemreserve
 														.get(warehouse.getId()));
 												newObj.setTotalAvailability(newObj
 														.getVendorAvailability()
 														- itemreserve.get(warehouse
 									} else {
 										if (flipkartLeftInvDataMap
 												.containsKey(flipkartItem
 														.getSkuAtFlipkart())) {
 											Map<Long, NlcLeftOutInventory> newNlcObjMap = flipkartLeftInvDataMap
-													.get(flipkartItem
+											.get(flipkartItem
-															.getSkuAtFlipkart());
+													.getSkuAtFlipkart());
 											if (newNlcObjMap
 													.containsKey(warehouse
 															.getId())) {
 												NlcLeftOutInventory newObj = newNlcObjMap
-														.get(warehouse.getId());
+												.get(warehouse.getId());
 												newObj.setReserved(itemreserve
 														.get(warehouse.getId()));
 												newObj.setTotalAvailability(newObj
 														.getVendorAvailability()
 														- itemreserve.get(warehouse
 									.getBillingWarehouseId() != 7) {
 								if (allWarehousesMap.get(entry.getKey())
 										.getLogisticsLocation()
 										.equals(WarehouseLocation.Delhi)
 										&& allWarehousesMap
-												.get(entry.getKey())
+										.get(entry.getKey())
-												.getWarehouseType()
+										.getWarehouseType()
-												.equals(WarehouseType.THIRD_PARTY)
+										.equals(WarehouseType.THIRD_PARTY)
 										&& allWarehousesMap.get(entry.getKey())
-												.getVendor().getId() != 1) {
+										.getVendor().getId() != 1) {
 								} else {
 									continue;
+								}
+							}
 									} else {
 										if (snapdealLeftInvDataMap
 												.containsKey(snapdealItem
 														.getSkuAtSnapdeal())) {
 											Map<Long, NlcLeftOutInventory> newNlcObjMap = snapdealLeftInvDataMap
-													.get(snapdealItem
+											.get(snapdealItem
-															.getSkuAtSnapdeal());
+													.getSkuAtSnapdeal());
 											if (newNlcObjMap.containsKey(entry
 													.getKey())) {
 												NlcLeftOutInventory newObj = newNlcObjMap
-														.get(entry.getKey());
+												.get(entry.getKey());
 												newObj.setReserved(itemreserve
 														.get(entry.getKey()));
 												newObj.setTotalAvailability(newObj
 														.getVendorAvailability()
 														- itemreserve.get(entry
 									} else {
 										if (flipkartLeftInvDataMap
 												.containsKey(flipkartItem
 														.getSkuAtFlipkart())) {
 											Map<Long, NlcLeftOutInventory> newNlcObjMap = flipkartLeftInvDataMap
-													.get(flipkartItem
+											.get(flipkartItem
-															.getSkuAtFlipkart());
+													.getSkuAtFlipkart());
 											if (newNlcObjMap.containsKey(entry
 													.getKey())) {
 												NlcLeftOutInventory newObj = newNlcObjMap
-														.get(entry.getKey());
+												.get(entry.getKey());
 												newObj.setReserved(itemreserve
 														.get(entry.getKey()));
 												newObj.setTotalAvailability(newObj
 														.getVendorAvailability()
 														- itemreserve.get(entry
+				}
 				nlcLoiItemsMapSD = snapdealLeftInvDataMap;
 				nlcLoiItemsMapFK = flipkartLeftInvDataMap;
-				List<NlcLeftOutInventory> subNlcLoiItemsListSD1 = new ArrayList<NlcLeftOutInventory>();
-				List<NlcLeftOutInventory> subNlcLoiItemsListSD2 = new ArrayList<NlcLeftOutInventory>();
-				List<NlcLeftOutInventory> subNlcLoiItemsListFK1 = new ArrayList<NlcLeftOutInventory>();
-				List<NlcLeftOutInventory> subNlcLoiItemsListFK2 = new ArrayList<NlcLeftOutInventory>();
-				for (Map<Long, NlcLeftOutInventory> nlcLOImap : nlcLoiItemsMapSD
-						.values()) {
-					// System.out.println("Inner Map Size "+nlcLOImap.size());
-					for (NlcLeftOutInventory nlcLOI : nlcLOImap.values()) {
-						if (nlcLOI.getWarehouseType().equalsIgnoreCase("OURS")) {
-							subNlcLoiItemsListSD1.add(nlcLOI);
-						}
-						if (nlcLOI.getWarehouseType().equalsIgnoreCase(
-								"THIRD_PARTY")) {
-							subNlcLoiItemsListSD2.add(nlcLOI);
-						}
-					}
-				}
-				if (subNlcLoiItemsListSD1 != null
-						&& subNlcLoiItemsListSD1.size() >= 2) {
-					Collections.sort(subNlcLoiItemsListSD1,
-							new NlcLeftOutInventoryComparator());
-				}
-				if (subNlcLoiItemsListSD2 != null
-						&& subNlcLoiItemsListSD2.size() >= 2) {
-					Collections.sort(subNlcLoiItemsListSD2,
-							new NlcLeftOutInventoryComparator());
-				}
-				mainNlcLoiItemsListSD.addAll(subNlcLoiItemsListSD1);
-				mainNlcLoiItemsListSD.addAll(subNlcLoiItemsListSD2);
-				for (Map<Long, NlcLeftOutInventory> nlcLOImap : nlcLoiItemsMapFK
-						.values()) {
-					// System.out.println("Inner Map Size "+nlcLOImap.size());
-					for (NlcLeftOutInventory nlcLOI : nlcLOImap.values()) {
-						if (nlcLOI.getWarehouseType().equalsIgnoreCase("OURS")) {
-							subNlcLoiItemsListFK1.add(nlcLOI);
-						}
-						if (nlcLOI.getWarehouseType().equalsIgnoreCase("THIRD_PARTY")) {
-							subNlcLoiItemsListFK2.add(nlcLOI);
-						}
-					}
-				}
-				if (subNlcLoiItemsListFK1 != null
-						&& subNlcLoiItemsListFK1.size() >= 2) {
-					Collections.sort(subNlcLoiItemsListFK1,
-							new NlcLeftOutInventoryComparator());
-				}
-				if (subNlcLoiItemsListFK2 != null
-						&& subNlcLoiItemsListFK2.size() >= 2) {
-					Collections.sort(subNlcLoiItemsListFK2,
-							new NlcLeftOutInventoryComparator());
-				}
-				mainNlcLoiItemsListFK.addAll(subNlcLoiItemsListFK1);
-				mainNlcLoiItemsListFK.addAll(subNlcLoiItemsListFK2);
+			}
 		} catch (TException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
+		}
 	private static void createAndSendLeftOutInventoryFile(
 			Map<String, Map<Long, NlcLeftOutInventory>> nlcLeftoutInventoryItems,
 			String fileName) {
 		try {
+			File file = new File("/tmp/" + fileName + "-leftOutInv.xls");
+			BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(
+					file));
+			bufferedWriter.write(StringUtils.join(new String[] { "ItemId",
+					"Product Name", "SkuAtSource", "Vendor Name",
+					"Vendor Warehouse Id", "Warehouse Type", "Max Our NLC",
+					"Vendor NLC", "Availability Count", "Reserved Count",
+			"Net Availabilty" }, '\t'));
+             //id -0, name -1, sku - 2, vname 3, wh 4, wt 5, mnlc 6, vnlc 7, av8, r9, na 10
+			// System.out.println(fileName+
+			// " Main Map Size "+nlcLeftoutInventoryItems.size());
+			for (Map<Long, NlcLeftOutInventory> nlcLOImap : nlcLeftoutInventoryItems
+					.values()) {
+				// System.out.println("Inner Map Size "+nlcLOImap.size());
+				for (NlcLeftOutInventory nlcLOI : nlcLOImap.values()) {
+					bufferedWriter.newLine();
+					bufferedWriter.write(StringUtils.join(
+							new String[] {
+									String.valueOf(nlcLOI.getItemId()),
+									nlcLOI.getProductName(),
+									nlcLOI.getSkuAtSource(),
+									nlcLOI.getVendorName(),
+									String.valueOf(nlcLOI
+											.getVendorWarehouseId()),
+											nlcLOI.getWarehouseType(),
+											String.valueOf(nlcLOI.getOurNlc()),
+											String.valueOf(nlcLOI.getVendorNlc()),
+											String.valueOf(nlcLOI
+													.getVendorAvailability()),
+													String.valueOf(nlcLOI.getReserved()),
+													String.valueOf(nlcLOI
+															.getTotalAvailability()) }, '\t'));
+				}
+			}
+			bufferedWriter.close();
+			List<NlcLeftOutInventory> subNlcLoiItemsListSD1 = new ArrayList<NlcLeftOutInventory>();
+			List<NlcLeftOutInventory> subNlcLoiItemsListSD2 = new ArrayList<NlcLeftOutInventory>();
+			List<NlcLeftOutInventory> subNlcLoiItemsListFK1 = new ArrayList<NlcLeftOutInventory>();
+			List<NlcLeftOutInventory> subNlcLoiItemsListFK2 = new ArrayList<NlcLeftOutInventory>();
+			BufferedReader reader = null;
+			File readfile = new File("/tmp/" + fileName + "-leftOutInv.xls");
+		    reader = new BufferedReader(new FileReader(readfile));
+		    String line;
+		    String values[];
+		  //id -0, name -1, sku - 2, vname 3, wh 4, wt 5, mnlc 6, vnlc 7, av8, r9, na 10
+		    while ((line = reader.readLine()) != null) {
+		        values = line.split("\t");
+		        NlcLeftOutInventory nlcLoI = new NlcLeftOutInventory();
+		        nlcLoI.setItemId(Long.parseLong(values[0]));
+		        nlcLoI.setProductName(values[1]);
+		        nlcLoI.setOurNlc(Double.parseDouble(values[6]));
+		        nlcLoI.setSkuAtSource(values[2]);
+		        nlcLoI.setVendorName(values[3]);
+		        nlcLoI.setVendorAvailability(Long.parseLong(values[8]));
+		        nlcLoI.setVendorNlc(Double.parseDouble(values[7]));
+		        nlcLoI.setVendorWarehouseId(Long.parseLong(values[4]));
+		        nlcLoI.setWarehouseType(values[5]);
+		        nlcLoI.setReserved(Long.parseLong(values[9]));
+		        nlcLoI.setTotalAvailability(Long.parseLong(values[10]));
+		        if(fileName.equalsIgnoreCase("SNAPDEAL")){
+		        	if (nlcLoI.getWarehouseType().equalsIgnoreCase("OURS")) {
+						subNlcLoiItemsListSD1.add(nlcLoI);
+					}
+					if (nlcLoI.getWarehouseType().equalsIgnoreCase("THIRD_PARTY")) {
+						subNlcLoiItemsListSD2.add(nlcLoI);
+					}
+		        }
+		        if(fileName.equalsIgnoreCase("FLIPKART")){
+		        	if (nlcLoI.getWarehouseType().equalsIgnoreCase("OURS")) {
+						subNlcLoiItemsListFK1.add(nlcLoI);
+					}
+					if (nlcLoI.getWarehouseType().equalsIgnoreCase("THIRD_PARTY")) {
+						subNlcLoiItemsListFK2.add(nlcLoI);
+					}
+		        }
+		    }
-			StringBuffer sb = new StringBuffer();
+		    StringBuffer sb = new StringBuffer();
 			sb.append("<html><table border=\"1\" align=\"center\">"
 					+ "<caption><b>" + "LEFT OUT INVENTORY DETAIL" + "</b></caption>"
 					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>" + "<td><b>"
 					+ "PRODUCT-NAME" + "</b></td>" + "<td><b>" + "SKU-AT-SOURCE"
 					+ "</b></td>" + "<td><b>" + "VENDOR-NAME" + "</b></td>"
 					+ "</b></td>" + "</b></td>" + "<td><b>" + "VENDOR-NLC"
 					+ "</b></td>" + "<td><b>" + "AVAILABILITY-COUNT" + "</b></td>"
 					+ "<td><b>" + "RESERVED-COUNT" + "</b></td>"
 					+ "<td><b>" + "NET-AVAILABILITY" + "</b></td>"
 					+ "</tr>");
-			if(fileName.equalsIgnoreCase("SNAPDEAL")){
+		    if(fileName.equalsIgnoreCase("SNAPDEAL")){
+			    if (subNlcLoiItemsListSD1 != null
+						&& subNlcLoiItemsListSD1.size() >= 2) {
+					Collections.sort(subNlcLoiItemsListSD1,
+							new NlcLeftOutInventoryComparator());
+				}
+				if (subNlcLoiItemsListSD2 != null
+						&& subNlcLoiItemsListSD2.size() >= 2) {
+					Collections.sort(subNlcLoiItemsListSD2,
+							new NlcLeftOutInventoryComparator());
+				}
+				mainNlcLoiItemsListSD.addAll(subNlcLoiItemsListSD1);
+				mainNlcLoiItemsListSD.addAll(subNlcLoiItemsListSD2);
 				for(NlcLeftOutInventory obj: mainNlcLoiItemsListSD){
 					sb.append("<tr>"+"<td>"+obj.getItemId()+"</td>"
 							+"<td>"+obj.getProductName()+"</td>"
 							+"<td>"+obj.getSkuAtSource()+"</td>"
 							+"<td>"+obj.getVendorName()+"</td>"
 							+"<td>"+obj.getOurNlc()+"</td>"
 							+"<td>"+obj.getVendorNlc()+"</td>"
 							+"<td>"+obj.getVendorAvailability()+"</td>"
 							+"<td>"+obj.getReserved()+"</td>"
 							+"<td>"+obj.getTotalAvailability()+"</td>"+"</tr>"
-							);
+					);
+				}
-			}
+		    }
-			if(fileName.equalsIgnoreCase("FLIPKART")){
+		    if(fileName.equalsIgnoreCase("FLIPKART")){
+				if (subNlcLoiItemsListFK1 != null
+						&& subNlcLoiItemsListFK1.size() >= 2) {
+					Collections.sort(subNlcLoiItemsListFK1,
+							new NlcLeftOutInventoryComparator());
+				}
+				if (subNlcLoiItemsListFK2 != null
+						&& subNlcLoiItemsListFK2.size() >= 2) {
+					Collections.sort(subNlcLoiItemsListFK2,
+							new NlcLeftOutInventoryComparator());
+				}
+				mainNlcLoiItemsListFK.addAll(subNlcLoiItemsListFK1);
+				mainNlcLoiItemsListFK.addAll(subNlcLoiItemsListFK2);
 				for(NlcLeftOutInventory obj: mainNlcLoiItemsListFK){
 					sb.append("<tr>"+"<td>"+obj.getItemId()+"</td>"
 							+"<td>"+obj.getProductName()+"</td>"
 							+"<td>"+obj.getSkuAtSource()+"</td>"
 							+"<td>"+obj.getVendorName()+"</td>"
 							+"<td>"+obj.getOurNlc()+"</td>"
 							+"<td>"+obj.getVendorNlc()+"</td>"
 							+"<td>"+obj.getVendorAvailability()+"</td>"
 							+"<td>"+obj.getReserved()+"</td>"
 							+"<td>"+obj.getTotalAvailability()+"</td>"+"</tr>"
-							);
+					);
+				}
-			}
+		    }
 			sb.append("</table></html>");
 			BufferedWriter out = new BufferedWriter(new FileWriter("/tmp/"+fileName+"-leftOutInv-file.htm"));
 			out.write(sb.toString());
 			out.flush();
 			out.close();
-			File file = new File("/tmp/" + fileName + "-leftOutInv.xls");
-			BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(
-					file));
-			bufferedWriter.write(StringUtils.join(new String[] { "ItemId",
-					"Product Name", "SkuAtSource", "Vendor Name",
-					"Vendor Warehouse Id", "Warehouse Type", "Max Our NLC",
-					"Vendor NLC", "Availability Count", "Reserved Count",
-					"Net Availabilty" }, '\t'));
-			// System.out.println(fileName+
-			// " Main Map Size "+nlcLeftoutInventoryItems.size());
-			for (Map<Long, NlcLeftOutInventory> nlcLOImap : nlcLeftoutInventoryItems
-					.values()) {
-				// System.out.println("Inner Map Size "+nlcLOImap.size());
-				for (NlcLeftOutInventory nlcLOI : nlcLOImap.values()) {
-					bufferedWriter.newLine();
-					bufferedWriter.write(StringUtils.join(
-							new String[] {
-									String.valueOf(nlcLOI.getItemId()),
-									nlcLOI.getProductName(),
-									nlcLOI.getSkuAtSource(),
-									nlcLOI.getVendorName(),
-									String.valueOf(nlcLOI
-											.getVendorWarehouseId()),
-									nlcLOI.getWarehouseType(),
-									String.valueOf(nlcLOI.getOurNlc()),
-									String.valueOf(nlcLOI.getVendorNlc()),
-									String.valueOf(nlcLOI
-											.getVendorAvailability()),
-									String.valueOf(nlcLOI.getReserved()),
-									String.valueOf(nlcLOI
-											.getTotalAvailability()) }, '\t'));
-				}
-			}
-			bufferedWriter.close();
 			List<File> files = new ArrayList<File>();
 			files.add(file);
 			mailer.sendSSLMessage(sendTo,
 					"Inventory not Sent due to NLC Limitaion in case of - "
-							+ fileName, "Please find attached file.",
+					+ fileName, "Please find attached file.",
 					emailFromAddress, password, "/tmp/" + fileName + "-leftOutInv.xls", "/tmp/"+fileName+"-leftOutInv-file.htm");
 			/*mailer.sendSSLMessage(sendTo,
 					"Inventory not Sent due to NLC Limitaion in case of - "
 							+ fileName, "Please find attached file.",
 					emailFromAddress, password, files);*/

Subversion Repositories SmartDukaan

(root)/trunk/FlipkartFeeds/src/main/java/in/shop2020/NlcLeftOutInventoryDetailScript.java – Rev 11940 → 11944