WebSVN – SmartDukaan – Diff – /trunk/CatalogDashboard/src/main/java/in/shop2020/catalog/util/ReportGenerator.java

 import in.shop2020.config.ConfigException;
 import in.shop2020.model.v1.catalog.CatalogService;
 import in.shop2020.model.v1.catalog.ItemType;
 import in.shop2020.model.v1.catalog.status;
 import in.shop2020.model.v1.inventory.InventoryService.Client;
+import in.shop2020.model.v1.inventory.Vendor;
 import in.shop2020.thrift.clients.CatalogClient;
 import in.shop2020.thrift.clients.InventoryClient;
 import in.shop2020.thrift.clients.config.ConfigClient;
 import in.shop2020.utils.CategoryManager;
 import in.shop2020.utils.ConfigClientKeys;
 import java.io.ByteArrayOutputStream;
 import java.io.IOException;
 import java.text.DecimalFormat;
 import java.util.ArrayList;
 import java.util.HashMap;
+import java.util.Hashtable;
 import java.util.List;
 import java.util.Map;
 import org.apache.log4j.Logger;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
                     ConfigClientKeys.catalog_service_server_port.toString());
             CatalogService.Client catalogClient = catalogServiceClient.getClient();
             InventoryClient inventoryServiceClient = new InventoryClient();
             Client inventoryClient = inventoryServiceClient.getClient();
+            List<Vendor> vendors = inventoryClient.getAllVendors();
+            Map<Long, String> vendorIdNameMap = new Hashtable<Long, String>();
+            for(Vendor vendor : vendors){
+            	vendorIdNameMap.put(vendor.getId(), vendor.getName());
+            }
             thriftItemListInactive.addAll(catalogClient.getAllItemsByStatus(status.PAUSED));
             if(TYPE_INACTIVE != type){
             	catalogServiceClient = new CatalogClient(ConfigClientKeys.catalog_service_server_host_prod.toString(),
                         ConfigClientKeys.catalog_service_server_port.toString());
             	catalogClient = catalogServiceClient.getClient();
 	            headerRow.getCell(2).setCellStyle(styleBold);
 	            headerRow.createCell(3).setCellValue("Model Number");
 	            headerRow.getCell(3).setCellStyle(styleBold);
 	            headerRow.createCell(4).setCellValue("Color");
 	            headerRow.getCell(4).setCellStyle(styleBold);
-	            headerRow.createCell(5).setCellValue("Selling Price");
+	            headerRow.createCell(5).setCellValue("Transfer Price");
 	            headerRow.getCell(5).setCellStyle(styleBold);
-	            headerRow.createCell(6).setCellValue("Break Even Price");
+	            headerRow.createCell(6).setCellValue("Vendor");
 	            headerRow.getCell(6).setCellStyle(styleBold);
-	            headerRow.createCell(7).setCellValue("Current Status");
+	            headerRow.createCell(7).setCellValue("Selling Price");
 	            headerRow.getCell(7).setCellStyle(styleBold);
-	            headerRow.createCell(8).setCellValue("Reason");
+	            headerRow.createCell(8).setCellValue("Break Even Price");
 	            headerRow.getCell(8).setCellStyle(styleBold);
+	            headerRow.createCell(9).setCellValue("Current Status");
+	            headerRow.getCell(9).setCellStyle(styleBold);
+	            headerRow.createCell(10).setCellValue("Reason");
+	            headerRow.getCell(10).setCellStyle(styleBold);
 	            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItemList) {
 	            	List<in.shop2020.model.v1.inventory.VendorItemPricing> vip = inventoryClient.getAllItemPricing(thriftItem.getId());
 	            	Item item = getItemFromThriftItem(thriftItem, vip);
 	            	List<Object> breakeven = isBreakeven(item);
 	            	if(!(Boolean)breakeven.get(0)){
 	            		itemRow.createCell(1).setCellValue(item.getBrand());
 	            		itemRow.createCell(2).setCellValue(item.getModelName());
 	            		itemRow.createCell(3).setCellValue(item.getModelNumber());
 	            		itemRow.createCell(4).setCellValue(item.getColor());
+	            		try{
+	            			itemRow.createCell(5).setCellValue(numberFormat.format((Double)breakeven.get(2)));
+	            		} catch (Exception e){
+	            			itemRow.createCell(5).setCellValue("Empty");
+	            		}
+	            		try{
+	            			itemRow.createCell(6).setCellValue(vendorIdNameMap.get(breakeven.get(3)));
+	            		} catch (Exception e){
+	            			itemRow.createCell(6).setCellValue("Empty");
+	            		}
 	            		Double sellingPrice = item.getSellingPrice();
 	            		if(sellingPrice != null){
-	            			itemRow.createCell(5).setCellValue(numberFormat.format(sellingPrice));
+	            			itemRow.createCell(7).setCellValue(numberFormat.format(sellingPrice));
 	            		} else {
-	            			itemRow.createCell(5).setCellValue("NULL");
+	            			itemRow.createCell(7).setCellValue("NULL");
+	            		}
 	            		try{
-	            			itemRow.createCell(6).setCellValue(numberFormat.format((Double)breakeven.get(1)));
+	            			itemRow.createCell(8).setCellValue(numberFormat.format((Double)breakeven.get(1)));
 	            		} catch (Exception e){
-	            			itemRow.createCell(6).setCellValue("Empty");
+	            			itemRow.createCell(8).setCellValue("Empty");
+	            		}
-	            		itemRow.createCell(7).setCellValue(thriftItem.getItemStatus().toString());
+	            		itemRow.createCell(9).setCellValue(thriftItem.getItemStatus().toString());
 	            		try {
-	            			itemRow.createCell(8).setCellValue((String)breakeven.get(1));
+	            			itemRow.createCell(10).setCellValue((String)breakeven.get(1));
 	            		}catch (Exception e) {
-	            			itemRow.createCell(8).setCellValue("");
+	            			itemRow.createCell(10).setCellValue("");
+						}
 	            		}catch (Exception e) {
 							logger.info("Error occurred for item : " + item.getId());
 							System.out.println("Item id failed for breakeven report: " + item.getId());
+						}
+	}
 	private List<Object> isBreakeven(Item newItem) {
 		List<Object> list = new ArrayList<Object>();
 		boolean message = true;
+		Long vendor = 0L;
 		if (newItem.getSellingPrice() == null || newItem.getSellingPrice().compareTo(0d) <= 0) {
 			message=false;
 			list.add(message);
 			list.add("Selling price is empty or 0");
 			for (VendorPricings vendorDetail : newItem.getVendorPricesMap()
 					.values()) {
 				if (transferPrice > vendorDetail.getTransferPrice()
 						|| transferPrice == -1) {
 					transferPrice = vendorDetail.getTransferPrice();
+					vendor = vendorDetail.getVendorId();
+				}
+			}
 		} else if (!newItem.getVendorPricesMap().isEmpty()
 				&& newItem.getVendorPricesMap().containsKey(
 						newItem.getPreferredVendor())) {
 			transferPrice = newItem.getVendorPricesMap()
 					.get(newItem.getPreferredVendor()).getTransferPrice();
+			vendor = newItem.getVendorPricesMap().get(newItem.getPreferredVendor()).getVendorId();
 		} else {
 			message = false;
 			list.add(message);
 			list.add("Preferred vendor is not in Vendor Item Mapping.");
 			return list;
 		if (Double.compare(breakeven, newItem.getSellingPrice())>=0) {
 			message=false;
 			list.add(message);
 			list.add(breakeven);
+			list.add(transferPrice);
+			list.add(vendor);
 			return list;
+		}
 		list.add(message);
 		return list;
+	}

Subversion Repositories SmartDukaan

(root)/trunk/CatalogDashboard/src/main/java/in/shop2020/catalog/util/ReportGenerator.java – Rev 5946 → 6165