WebSVN – SmartDukaan – Diff – //trunk/Support/src/main/java/in/shop2020/support/controllers/SnapdealListController.java

 import in.shop2020.model.v1.catalog.SnapdealItemDetails;
 import in.shop2020.model.v1.order.AmazonFbaSalesSnapshot;
 import in.shop2020.model.v1.order.SnapdealOrder;
 import in.shop2020.support.utils.ReportsUtils;
 import in.shop2020.thrift.clients.CatalogClient;
+import in.shop2020.thrift.clients.InventoryClient;
 import in.shop2020.thrift.clients.TransactionClient;
 import java.io.BufferedInputStream;
 import java.io.File;
 import java.io.FileInputStream;
 	private String serviceTax;
 	private String courierCost;
 	private JSONObject itemObj;
 	private String isSuppressInventoryFeed;
 	private String isSuppressPriceFeed;
+	private String maxNlc;
+	private String sdItemCode;
+	public String getSdItemCode() {
+		return sdItemCode;
+	}
+	public void setSdItemCode(String sdItemCode) {
+		this.sdItemCode = sdItemCode;
+	}
 	public String index() {
 		if (!ReportsUtils.canAccessReport((Long) session.getAttribute(ReportsUtils.ROLE),request.getServletPath())) {
 			return "authfail";
+		}
 		return "index";
+		}
 		if (snapdealItem.getServiceTax()!=Double.valueOf(serviceTax)){
 			snapdealItem.setServiceTax(Double.valueOf(serviceTax));
 			commit = true;
+		}
+		if (snapdealItem.getMaxNlc()!=Double.valueOf(maxNlc)){
+			snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
+			commit = true;
+		}
+		if (!StringUtils.equalsIgnoreCase(snapdealItem.getSkuAtSnapdeal(), sdItemCode)){
+			snapdealItem.setSkuAtSnapdeal(sdItemCode);
+			commit=true;
+		}
 		if (commit){
 			catalogClient.addOrUpdateSnapdealItem(snapdealItem);
+		}
 		return "index";
+	}
 		snapdealItem.setExceptionPrice(Double.valueOf(exceptionPrice));
 		snapdealItem.setSellingPrice(Double.valueOf(sellingPrice));
 		snapdealItem.setCourierCost(Double.valueOf(courierCost));
 		snapdealItem.setCommission(Double.valueOf(commission));
 		snapdealItem.setServiceTax(Double.valueOf(serviceTax));
+		snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
+		snapdealItem.setSkuAtSnapdeal(sdItemCode);
 		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 		catalogClient.addOrUpdateSnapdealItem(snapdealItem);
 		return "index";
+	}
+		}
 		Item item = catalogClient.getItem(Long.valueOf(itemId));
 		if (item.getId()==0){
 			throw new CatalogServiceException();
+		}
+		InventoryClient inventoryServiceClient = new InventoryClient();
+		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
+		double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
 		itemObj = new JSONObject();
 		itemObj.put("ItemId", item.getId());
 		itemObj.put("Brand", item.getBrand());
 		itemObj.put("ModelName", item.getModelName());
 		itemObj.put("ModelNumber", item.getModelNumber());
 		itemObj.put("Weight", item.getWeight());
 		itemObj.put("Risky", item.isRisky());
 		itemObj.put("Status", item.getItemStatus());
 		itemObj.put("MRP", item.getMrp());
 		itemObj.put("SellingPrice", item.getSellingPrice());
+		itemObj.put("MaxNlc", maxNLC);
+		return "item-details-json";
+	}
+	public String ke$ha() throws NumberFormatException, TException, JSONException{
+		InventoryClient inventoryServiceClient = new InventoryClient();
+		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
+		double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
+		itemObj = new JSONObject();
+		itemObj.put("ItemId", itemId);
+		itemObj.put("WarehouseId", warehouseId);
+		itemObj.put("MaxNlc", maxNLC);
 		return "item-details-json";
+	}
 	public void downloadSnapdealListings() throws IOException, TException{
 		File file = new File("/tmp/snapdeal-bulk-upload-template.xls");
 		try {
 			catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 		} catch (TTransportException e) {
 			e.printStackTrace();
+		}
+		InventoryClient inventoryServiceClient = new InventoryClient();
+		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
 		for (int iterator=(sheet.getFirstRowNum()+1);iterator<=sheet.getLastRowNum();iterator++){
 			SnapdealItem snapdealItem =null;
 			Item item = null;
 			Long sku;
 			if (checkEmptyString(sheet.getRow(iterator).getCell(0))){
 					snapdealItem.setItem_id(sku);
+				}
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(1))){
 				long warehouseId = (long) sheet.getRow(iterator).getCell(1).getNumericCellValue();
+				double maxNLC = inventoryClient.getNlcForWarehouse(warehouseId, item.getId());
 				snapdealItem.setWarehouseId(warehouseId);
+				snapdealItem.setMaxNlc(maxNLC);
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(2))){
 				double exceptionPrice = sheet.getRow(iterator).getCell(2).getNumericCellValue();
 				snapdealItem.setExceptionPrice(exceptionPrice);
+				}
 				if ((long)sheet.getRow(iterator).getCell(6).getNumericCellValue()==0){
 					snapdealItem.setSuppressInventoryFeed(false);
+				}
+			}
+			if (!checkEmptyString(sheet.getRow(iterator).getCell(7))){
+				String snapdealItemCode = sheet.getRow(iterator).getCell(7).getStringCellValue();
+				snapdealItem.setSkuAtSnapdeal(snapdealItemCode);
+			}
 			double weight = item.getWeight();
 			/*
 			 *TODO Uncomment this for pricing feed.
 			 * if(weight==0){
 	public String getCourierCost() {
 		return courierCost;
+	}
+	public void setMaxNlc(String maxNlc) {
+		this.maxNlc = maxNlc;
+	}
+	public String getMaxNlc() {
+		return maxNlc;
+	}
 	public String getItemDetails(){
 		return itemObj.toString();
+	}

Subversion Repositories SmartDukaan

(root)//trunk/Support/src/main/java/in/shop2020/support/controllers/SnapdealListController.java – Rev 9242 → 9478