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

 import in.shop2020.model.v1.catalog.CatalogService.Client;
 import in.shop2020.model.v1.catalog.CatalogServiceException;
 import in.shop2020.model.v1.catalog.Item;
 import in.shop2020.model.v1.catalog.MarketplaceItems;
+import in.shop2020.model.v1.catalog.MarketplacePercentage;
 import in.shop2020.model.v1.catalog.SnapdealItem;
 import in.shop2020.model.v1.catalog.SnapdealItemDetails;
 import in.shop2020.model.v1.inventory.InventoryServiceException;
 import in.shop2020.model.v1.inventory.InventoryType;
 import in.shop2020.model.v1.inventory.ItemInventory;
 import in.shop2020.model.v1.inventory.Warehouse;
 import in.shop2020.model.v1.inventory.WarehouseType;
-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;
+	}
 	public String update() throws NumberFormatException, TException, InventoryServiceException, CatalogServiceException, JSONException{
 		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 		SnapdealItem snapdealItem = catalogClient.getSnapdealItem(Long.valueOf(itemId));
+		MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));
+		if (mpCosting.getSource()==0){
+			throw new CatalogServiceException();
+		}
 		MarketplaceItems mpItem = catalogClient.getMarketplacedetailsForItem(Long.valueOf(itemId),7);
+		mpItem.setEmiFee(mpCosting.getEmiFee());
+		mpItem.setReturnProvision(mpCosting.getReturnProvision());
+		mpItem.setClosingFee(mpCosting.getClosingFee());
+		mpItem.setServiceTax(mpCosting.getServiceTax());
+		mpItem.setCommission(mpCosting.getCommission());
 		InventoryClient inventoryServiceClient = new InventoryClient();
 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
-		Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
+		/*Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
 		if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
 			throw new InventoryServiceException();
-		}
+		}*/
-		boolean commit = false;
-		if (snapdealItem.getWarehouseId()!=Long.valueOf(warehouseId)){
-			snapdealItem.setWarehouseId(Long.valueOf(warehouseId));
+		snapdealItem.setWarehouseId(Long.valueOf(warehouseId));
-			commit = true;
-		}
-		if (snapdealItem.isIsListedOnSnapdeal()!=Boolean.valueOf(isListedOnSnapdeal)){
-			snapdealItem.setIsListedOnSnapdeal(Boolean.valueOf(isListedOnSnapdeal));
+		snapdealItem.setIsListedOnSnapdeal(Boolean.valueOf(isListedOnSnapdeal));
-			commit = true;
-		}
-		if (snapdealItem.isSuppressInventoryFeed()!=Boolean.valueOf(isSuppressInventoryFeed)){
-			snapdealItem.setSuppressInventoryFeed(Boolean.valueOf(isSuppressInventoryFeed));
+		snapdealItem.setSuppressInventoryFeed(Boolean.valueOf(isSuppressInventoryFeed));
-			commit = true;
-		}
-		if (snapdealItem.isSuppressPriceFeed()!=Boolean.valueOf(isSuppressPriceFeed)){
-			snapdealItem.setSuppressPriceFeed(Boolean.valueOf(isSuppressPriceFeed));
+		snapdealItem.setSuppressPriceFeed(Boolean.valueOf(isSuppressPriceFeed));
-			commit = true;
-		}
-		if (snapdealItem.getTransferPrice()!=Double.valueOf(transferPrice)){
-			snapdealItem.setTransferPrice(Double.valueOf(transferPrice));
+		snapdealItem.setTransferPrice(Double.valueOf(transferPrice));
-			commit = true;
-		}
-		if (snapdealItem.getExceptionPrice()!=Double.valueOf(exceptionPrice)){
-			snapdealItem.setExceptionPrice(Double.valueOf(exceptionPrice));
+		snapdealItem.setExceptionPrice(Double.valueOf(exceptionPrice));
-			commit = true;
-		}
-		if (snapdealItem.getSellingPrice()!=Double.valueOf(sellingPrice)){
-			snapdealItem.setSellingPrice(Double.valueOf(sellingPrice));
+		snapdealItem.setSellingPrice(Double.valueOf(sellingPrice));
-			commit = true;
-		}
-		if (snapdealItem.getCourierCost()!=Double.valueOf(courierCost)){
-			snapdealItem.setCourierCost(Double.valueOf(courierCost));
+		snapdealItem.setCourierCost(Double.valueOf(courierCost));
-			commit = true;
-		}
-		if (snapdealItem.getCommission()!=Double.valueOf(commission)){
-			snapdealItem.setCommission(Double.valueOf(commission));
+		snapdealItem.setCommission(Double.valueOf(commission));
-			commit = true;
-		}
-		if (snapdealItem.getServiceTax()!=Double.valueOf(serviceTax)){
-			snapdealItem.setServiceTax(Double.valueOf(serviceTax));
+		snapdealItem.setServiceTax(Double.valueOf(serviceTax));
-			commit = true;
-		}
-		if (snapdealItem.getMaxNlc()!=Double.valueOf(maxNlc)){
-			snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
+		snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
-			commit = true;
-		}
-		if (!StringUtils.equalsIgnoreCase(snapdealItem.getSkuAtSnapdeal(), sdItemCode)){
-			snapdealItem.setSkuAtSnapdeal(sdItemCode);
+		snapdealItem.setSkuAtSnapdeal(sdItemCode);
-			commit=true;
-		}
-		if (!StringUtils.equalsIgnoreCase(snapdealItem.getSupc(), supc)){
-			snapdealItem.setSupc(supc);
+		snapdealItem.setSupc(supc);
-			commit=true;
-		}
 		MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
+		snapdealItem.setUpdatedBy(getUserName());
+		snapdealItem.setMarketplaceItems(t_mpItem);
 		if(!compareParameters(t_mpItem,snapdealItem)){
 			setComparsionResult("0");
 			return "snapdeal-update-result";
+		}
 		else{
 			setComparsionResult("1");
+		}
-		if (commit){
-			if(!catalogClient.addOrUpdateSnapdealItem(snapdealItem)){
+		if(!catalogClient.addOrUpdateSnapdealItem(snapdealItem)){
-				throw new CatalogServiceException();
-			}
-		}
-		boolean result = catalogClient.updateMarketplaceAttributesForItem(t_mpItem);
-		if(!result){
 			throw new CatalogServiceException();
+		}
 		if (t_mpItem.getCurrentSp()< t_mpItem.getMinimumPossibleSp()){
 			sendAlert(t_mpItem.getItemId(),t_mpItem.getCurrentSp(),t_mpItem.getMinimumPossibleSp());
+		}
 		return "snapdeal-update-result";
+	}
 	public boolean compareParameters(MarketplaceItems mpItem, SnapdealItem snapdealItem) throws TException, JSONException{
 		double nlc =getNlcForWarehouse(snapdealItem.getWarehouseId(),snapdealItem.getItem_id());
 		double vat = (snapdealItem.getSellingPrice()/(1+(mpItem.getVat()/100))-(nlc/(1+(mpItem.getVat()/100))))*(mpItem.getVat()/100);
 		double inHouseCost = 15+vat+(mpItem.getReturnProvision()/100)*snapdealItem.getSellingPrice()+mpItem.getOtherCost();
-	    double lowest_possible_tp = nlc+inHouseCost;
+		double lowest_possible_tp = nlc+inHouseCost;
-	    double our_tp =  snapdealItem.getSellingPrice()- snapdealItem.getSellingPrice()*(mpItem.getCommission()/100)*(1+(mpItem.getServiceTax()/100))-snapdealItem.getCourierCost()*(1+(mpItem.getServiceTax()/100));
+		double our_tp =  snapdealItem.getSellingPrice()- snapdealItem.getSellingPrice()*(mpItem.getCommission()/100+mpItem.getEmiFee()/100)*(1+(mpItem.getServiceTax()/100))-(snapdealItem.getCourierCost()+mpItem.getClosingFee())*(1+(mpItem.getServiceTax()/100));
-	    double commission =  ((mpItem.getCommission()/100)*snapdealItem.getSellingPrice());
+		double commission =  ((mpItem.getCommission()/100)*snapdealItem.getSellingPrice());
-	    double service_tax = (mpItem.getServiceTax()/100)*(snapdealItem.getCommission()+snapdealItem.getCourierCost());
+		double service_tax = (mpItem.getServiceTax()/100)*(snapdealItem.getCommission()+snapdealItem.getCourierCost());
-	    double lowest_possible_sp = (nlc+(snapdealItem.getCourierCost()+0)*1.1236*(1+(mpItem.getVat()/100))+(15+mpItem.getOtherCost())*(1+(mpItem.getVat())/100))/(1-(mpItem.getCommission()/100+0)*1.1236*(1+(mpItem.getVat())/100)-.005*(1+(mpItem.getVat())/100));
+		double lowest_possible_sp = (nlc+(snapdealItem.getCourierCost()+mpItem.getClosingFee())*(1+(mpItem.getServiceTax()/100))*(1+(mpItem.getVat()/100))+(15+mpItem.getOtherCost())*(1+(mpItem.getVat())/100))/(1-(mpItem.getCommission()/100+mpItem.getEmiFee()/100)*(1+(mpItem.getServiceTax()/100))*(1+(mpItem.getVat())/100)-(mpItem.getReturnProvision()/100)*(1+(mpItem.getVat())/100));
-	    JSONObject x = new JSONObject();
+		JSONObject x = new JSONObject();
-	    x.put("NLC", nlc);
+		x.put("NLC", nlc);
-	    x.put("VAT", vat);
+		x.put("VAT", vat);
-	    x.put("LOWEST POS TP", lowest_possible_tp);
+		x.put("LOWEST POS TP", lowest_possible_tp);
-	    x.put("TP", our_tp);
+		x.put("TP", our_tp);
-	    x.put("COMMISSION", commission);
+		x.put("COMMISSION", commission);
-	    x.put("SERVICE TAX", service_tax);
+		x.put("SERVICE TAX", service_tax);
-	    x.put("LOWEST POS SP", lowest_possible_sp);
+		x.put("LOWEST POS SP", lowest_possible_sp);
-	    logger.info("Snapdeal Backend validation "+x.toString());
+		logger.info("Snapdeal Backend validation "+x.toString());
-	    boolean compare_result=true;
+		boolean compare_result=true;
-	    if(!(nlc==snapdealItem.getMaxNlc())){
+		if(!(nlc==snapdealItem.getMaxNlc())){
-	    	compare_result=false;
+			compare_result=false;
-	    }
+		}
-	    if(!(lowest_possible_tp-mpItem.getMinimumPossibleTp()>-1 && lowest_possible_tp-mpItem.getMinimumPossibleTp()<1)){
+		if(!(lowest_possible_tp-mpItem.getMinimumPossibleTp()>-1 && lowest_possible_tp-mpItem.getMinimumPossibleTp()<1)){
-	    	compare_result=false;
+			compare_result=false;
-	    }
+		}
-	    if(!(our_tp-snapdealItem.getTransferPrice()>-1 && our_tp-snapdealItem.getTransferPrice()<1)){
+		if(!(our_tp-snapdealItem.getTransferPrice()>-1 && our_tp-snapdealItem.getTransferPrice()<1)){
-	    	compare_result=false;
+			compare_result=false;
-	    }
+		}
-	    if(!(commission-snapdealItem.getCommission()>-1 && commission-snapdealItem.getCommission()<1)){
+		if(!(commission-snapdealItem.getCommission()>-1 && commission-snapdealItem.getCommission()<1)){
-	    	compare_result=false;
+			compare_result=false;
-	    }
+		}
-	    if(!(service_tax-snapdealItem.getServiceTax()>-1 && service_tax-snapdealItem.getServiceTax()<1)){
+		if(!(service_tax-snapdealItem.getServiceTax()>-1 && service_tax-snapdealItem.getServiceTax()<1)){
-	    	compare_result=false;
+			compare_result=false;
-	    }
+		}
-	    if(!(lowest_possible_sp-mpItem.getMinimumPossibleSp()>-1 && lowest_possible_sp-mpItem.getMinimumPossibleSp()<1)){
+		if(!(lowest_possible_sp-mpItem.getMinimumPossibleSp()>-1 && lowest_possible_sp-mpItem.getMinimumPossibleSp()<1)){
-	    	compare_result=false;
+			compare_result=false;
-	    }
+		}
-	    return compare_result;
+		return compare_result;
+	}
 	public double getNlcForWarehouse(long warehouseId,long item_id) throws TException{
 		InventoryClient inventoryServiceClient = new InventoryClient();
 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
 		return inventoryClient.getNlcForWarehouse(warehouseId, item_id);
+	}
 	public double getCourierCost(double weight){
 		double cCost = 45;
 		int slabs = (int) ((weight - .001)/(.5));
 		for(int i=0;i<slabs;i++){
 			cCost = cCost + 35;
 			e.printStackTrace();
 			return;
+		}
 		String emailSubjectTxt="Snapdeal SP is set below Min Possible SP";
 		String[] sendTo=new String[]{ "kshitij.sood@saholic.com","rajneesh.arora@saholic.com","rajveer.singh@saholic.com","vikram.raghav@saholic.com"};
-		String text = "Item Details\nItem Id: "+itemId+"\nProduct Name: "+item.getBrand()+" "+item.getModelName()+" "+item.getModelNumber()+" "+item.getColor()+"\nSellingPrice: "+sp+"\nMinPossibleSp: "+minSp+"\nUpdated By: "+session.getAttribute(ReportsUtils.USER_NAME).toString();
+		String text = "Item Details-\nItem Id: "+itemId+"\nProduct Name: "+item.getBrand()+" "+item.getModelName()+" "+item.getModelNumber()+" "+item.getColor()+"\nSellingPrice: "+sp+"\nMinPossibleSp: "+minSp+"\nUpdated By: "+session.getAttribute(ReportsUtils.USER_NAME).toString();
 		logger.info(text);
 		String emailFromAddress = "build@shop2020.in";
 		String password = "cafe@nes";
 		GmailUtils mailer = new GmailUtils();
 		try {
-			//mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
+			mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
+		}
 		catch (Exception e) {
 			logger.info(e.toString());
+		}
+	}
-	public void addNewItem() throws TException, NumberFormatException, InventoryServiceException, CatalogServiceException{
+	public String addNewItem() throws TException, NumberFormatException, InventoryServiceException, CatalogServiceException, JSONException{
 		InventoryClient inventoryServiceClient = new InventoryClient();
 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
+		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
+		MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));
+		if (mpCosting.getSource()==0){
+			throw new CatalogServiceException();
+		}
-		Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
+		/*Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
 		if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
 			throw new InventoryServiceException();
-		}
+		}*/
 		SnapdealItem snapdealItem = new SnapdealItem();
 		snapdealItem.setItem_id(Long.valueOf(itemId));
 		snapdealItem.setWarehouseId(Long.valueOf(warehouseId));
 		snapdealItem.setIsListedOnSnapdeal(Boolean.valueOf(isListedOnSnapdeal));
 		snapdealItem.setSuppressInventoryFeed(Boolean.valueOf(isSuppressInventoryFeed));
 		snapdealItem.setCommission(Double.valueOf(commission));
 		snapdealItem.setServiceTax(Double.valueOf(serviceTax));
 		snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
 		snapdealItem.setSkuAtSnapdeal(sdItemCode);
 		snapdealItem.setSupc(supc);
+		snapdealItem.setUpdatedBy(getUserName());
 		MarketplaceItems mpItem = new MarketplaceItems();
 		MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
+		t_mpItem.setCommission(mpCosting.getCommission());
+		t_mpItem.setServiceTax(mpCosting.getServiceTax());
-		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
+		t_mpItem.setReturnProvision(mpCosting.getReturnProvision());
+		t_mpItem.setEmiFee(mpCosting.getEmiFee());
+		t_mpItem.setClosingFee(mpCosting.getClosingFee());
-		catalogClient.addOrUpdateSnapdealItem(snapdealItem);
+		if(!compareParameters(t_mpItem,snapdealItem)){
+			setComparsionResult("0");
+			return "snapdeal-update-result";
+		}
+		else{
+			setComparsionResult("1");
+		}
+		snapdealItem.setMarketplaceItems(t_mpItem);
-		boolean result =catalogClient.updateMarketplaceAttributesForItem(t_mpItem);
+		boolean result = catalogClient.addOrUpdateSnapdealItem(snapdealItem);
 		if(!result){
 			throw new CatalogServiceException();
+		}
 		if (t_mpItem.getCurrentSp()< t_mpItem.getMinimumPossibleSp()){
 			sendAlert(t_mpItem.getItemId(),t_mpItem.getCurrentSp(),t_mpItem.getMinimumPossibleSp());
+		}
+		return "snapdeal-update-result";
+	}
 	public String getAddNewItemForm(){
 		return "snapdeal-add-item";
+	}
 	public String getItemDetailsInJson() throws NumberFormatException, CatalogServiceException, TException, JSONException, InventoryServiceException{
 		Client catalogClient =new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 		SnapdealItem snapdealItem = catalogClient.getSnapdealItem(Long.valueOf(itemId));
+		MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));
 		if (snapdealItem.getItem_id()!=0){
 			throw new CatalogServiceException();
+		}
 		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();
-		Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
+		/*Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
 		if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
 			throw new InventoryServiceException();
-		}
+		}*/
 		double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
+		if (maxNLC==0){
+			throw new InventoryServiceException();
+		}
 		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("Risky", item.isRisky());
 		itemObj.put("Status", item.getItemStatus());
 		itemObj.put("MRP", item.getMrp());
 		itemObj.put("SellingPrice", item.getSellingPrice());
 		itemObj.put("MaxNlc", maxNLC);
+		itemObj.put("CommissionRate", mpCosting.getCommission());
+		itemObj.put("ServiceTaxRate", mpCosting.getServiceTax());
+		itemObj.put("ReturnProvision", mpCosting.getReturnProvision());
+		itemObj.put("EmiFee", mpCosting.getEmiFee());
+		itemObj.put("ClosingFee", mpCosting.getClosingFee());
 		return "item-details-json";
+	}
 	public String ke$ha() throws NumberFormatException, TException, JSONException, InventoryServiceException{
 		InventoryClient inventoryServiceClient = new InventoryClient();
 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
-		Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
+		//Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
-		if (warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD){
+		//if (warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD){
-			double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
+		double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
-			itemObj = new JSONObject();
+		itemObj = new JSONObject();
-			itemObj.put("ItemId", itemId);
+		itemObj.put("ItemId", itemId);
-			itemObj.put("WarehouseId", warehouseId);
+		itemObj.put("WarehouseId", warehouseId);
-			itemObj.put("MaxNlc", maxNLC);
+		itemObj.put("MaxNlc", maxNLC);
-		}
+		/*}
 		else{
 			itemObj = new JSONObject();
 			throw new InventoryServiceException();
-		}
+		}*/
 		return "item-details-json";
+	}
 	public ItemInventory getItemInventory(String itemId) throws NumberFormatException, InventoryServiceException, TException{
 		try{
 		rowhead.createCell((short) 1).setCellValue("WAREHOUSE-ID");
 		rowhead.createCell((short) 2).setCellValue("EXCEPTIONAL-PRICE");
 		rowhead.createCell((short) 3).setCellValue("SNAPDEAL-LISTED");
 		rowhead.createCell((short) 4).setCellValue("TRANSFER-PRICE");
 		rowhead.createCell((short) 5).setCellValue("SELLING-PRICE");
+		rowhead.createCell((short) 6).setCellValue("LOWEST POSSIBLE SP");
+		rowhead.createCell((short) 7).setCellValue("LOWEST POSSIBLE TP");
+		rowhead.createCell((short) 8).setCellValue("OTHER COST");
-		rowhead.createCell((short) 6).setCellValue("COURIER-COST");
+		rowhead.createCell((short) 9).setCellValue("COURIER-COST");
-		rowhead.createCell((short) 7).setCellValue("COMMISION");
+		rowhead.createCell((short) 10).setCellValue("COMMISION");
-		rowhead.createCell((short) 8).setCellValue("SERVICE-TAX");
+		rowhead.createCell((short) 11).setCellValue("SERVICE-TAX");
-		rowhead.createCell((short) 9).setCellValue("Suppress Inventory Feed");
+		rowhead.createCell((short) 12).setCellValue("Suppress Inventory Feed");
-		rowhead.createCell((short) 10).setCellValue("Suppress Price Feed");
+		rowhead.createCell((short) 13).setCellValue("Suppress Price Feed");
+		rowhead.createCell((short) 14).setCellValue("AUTO FAVOURITE");
+		rowhead.createCell((short) 15).setCellValue("MANUAL FAVOURITE");
+		rowhead.createCell((short) 16).setCellValue("AUTO INCREMENT");
+		rowhead.createCell((short) 17).setCellValue("AUTO DECREMENT");
-		rowhead.createCell((short) 11).setCellValue("Max NLC");
+		rowhead.createCell((short) 18).setCellValue("Max NLC");
-		rowhead.createCell((short) 12).setCellValue("SKU @ Snapdeal");
+		rowhead.createCell((short) 19).setCellValue("SKU @ Snapdeal");
-		rowhead.createCell((short) 13).setCellValue("SUPC");
+		rowhead.createCell((short) 20).setCellValue("SUPC");
-		CatalogClient catalogServiceClient = null;
+		Client catalogClient = null;
 		List<SnapdealItemDetails> snapdealItems = null;
 		try {
-			catalogServiceClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port");
+			catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
-			in.shop2020.model.v1.catalog.CatalogService.Client catalogClient= catalogServiceClient.getClient();
 			snapdealItems = catalogClient.getAllSnapdealItems();
 		} catch (Exception e) {
 			e.printStackTrace();
+		}
 		int iterator=1;
 		for(SnapdealItemDetails snapdealItem:snapdealItems){
+			MarketplaceItems marketplaceItem = catalogClient.getMarketplacedetailsForItem(snapdealItem.getItem_id(), 7);
 			HSSFRow row = sheet.createRow((short)iterator);
 			row.createCell((short) 0).setCellValue(snapdealItem.getItem_id());
 			row.createCell((short) 1).setCellValue(snapdealItem.getWarehouseId());
-			row.createCell((short) 2).setCellValue(snapdealItem.getExceptionPrice());
+			row.createCell((short) 2).setCellValue(roundTwoDecimals(snapdealItem.getExceptionPrice()));
 			if(snapdealItem.isIsListedOnSnapdeal()){
 				row.createCell((short) 3).setCellValue(1);
+			}
 			else{
 				row.createCell((short) 3).setCellValue(0);
+			}
-			row.createCell((short) 4).setCellValue(snapdealItem.getTransferPrice());
+			row.createCell((short) 4).setCellValue(roundTwoDecimals(snapdealItem.getTransferPrice()));
-			row.createCell((short) 5).setCellValue(snapdealItem.getSellingPrice());
+			row.createCell((short) 5).setCellValue(roundTwoDecimals(snapdealItem.getSellingPrice()));
+			row.createCell((short) 6).setCellValue(roundTwoDecimals(marketplaceItem.getMinimumPossibleSp()));
+			row.createCell((short) 7).setCellValue(roundTwoDecimals(marketplaceItem.getMinimumPossibleTp()));
+			row.createCell((short) 8).setCellValue(roundTwoDecimals(marketplaceItem.getOtherCost()));
-			row.createCell((short) 6).setCellValue(snapdealItem.getCourierCost());
+			row.createCell((short) 9).setCellValue(snapdealItem.getCourierCost());
-			row.createCell((short) 7).setCellValue(snapdealItem.getCommission());
+			row.createCell((short) 10).setCellValue(roundTwoDecimals(snapdealItem.getCommission()));
-			row.createCell((short) 8).setCellValue(snapdealItem.getServiceTax());
+			row.createCell((short) 11).setCellValue(roundTwoDecimals(snapdealItem.getServiceTax()));
-			row.createCell((short) 9).setCellValue(snapdealItem.isSuppressInventoryFeed());
+			if(snapdealItem.isSuppressInventoryFeed()){
+				row.createCell((short) 12).setCellValue(1);
+			}
+			else{
+				row.createCell((short) 12).setCellValue(0);
+			}
+			if(snapdealItem.isSuppressPriceFeed()){
+				row.createCell((short) 13).setCellValue(1);
+			}
+			else{
+				row.createCell((short) 13).setCellValue(0);
+			}
+			if(marketplaceItem.isAutoFavourite()){
+				row.createCell((short) 14).setCellValue(1);
+			}
+			else{
-			row.createCell((short) 10).setCellValue(snapdealItem.isSuppressPriceFeed());
+				row.createCell((short) 14).setCellValue(0);
+			}
+			if(marketplaceItem.isManualFavourite()){
+				row.createCell((short) 15).setCellValue(1);
+			}
+			else{
+				row.createCell((short) 15).setCellValue(0);
+			}
+			if(marketplaceItem.isAutoIncrement()){
+				row.createCell((short) 16).setCellValue(1);
+			}
+			else{
+				row.createCell((short) 16).setCellValue(0);
+			}
+			if(marketplaceItem.isAutoDecrement()){
+				row.createCell((short) 17).setCellValue(1);
+			}
+			else{
+				row.createCell((short) 17).setCellValue(0);
+			}
-			row.createCell((short) 11).setCellValue(snapdealItem.getMaxNlc());
+			row.createCell((short) 18).setCellValue(snapdealItem.getMaxNlc());
-			row.createCell((short) 12).setCellValue(snapdealItem.getSkuAtSnapdeal());
+			row.createCell((short) 19).setCellValue(snapdealItem.getSkuAtSnapdeal());
-			row.createCell((short) 13).setCellValue(snapdealItem.getSupc());
+			row.createCell((short) 20).setCellValue(snapdealItem.getSupc());
 			iterator++;
+		}
 		FileOutputStream fileOut = null;
 		try {
+		}
+	}
-	public void uploadsnapdealBulkSheet() throws IOException, TException, NumberFormatException, InventoryServiceException{
+	public void uploadsnapdealBulkSheet() throws IOException, TException, NumberFormatException, InventoryServiceException, CatalogServiceException{
 		File fileToCreate = new File("/tmp/", "Snapdeal-bulk-upload.xls");
 		FileUtils.copyFile(this.file, fileToCreate);
 		FileInputStream iFile = new FileInputStream(new File(file.getAbsolutePath()));
 		HSSFWorkbook workbook = new HSSFWorkbook(iFile);
 		HSSFSheet sheet = workbook.getSheetAt(0);
+		String updatedBy = getUserName();
 		Client catalogClient=null;
+		Client catalogClientProd=null;
 		StringBuilder sb = new StringBuilder();
 		try {
 			catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
+			catalogClientProd = new CatalogClient().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++){
+			if (sheet.getLastRowNum()-1>100){
+				sb.append("Number of items to update can't be greater than 100");
+				break;
+			}
-			SnapdealItem snapdealItem =null;
+			SnapdealItem snapdealItem = null;
+			MarketplaceItems marketplaceItem = null;
+			MarketplacePercentage mpCosting = null;
 			Item item = null;
 			Long sku;
 			boolean new_item = false;
 			if (checkEmptyString(sheet.getRow(iterator).getCell(0))){
 				continue;
+			}
 			else {
 				sku=(long) sheet.getRow(iterator).getCell(0).getNumericCellValue();
 				snapdealItem = catalogClient.getSnapdealItem(sku);
+				mpCosting = catalogClient.getCostingForMarketplace(7, sku);
+				marketplaceItem  = catalogClient.getMarketplacedetailsForItem(sku, 7);
+				marketplaceItem.setItemId(sku);
+				marketplaceItem.setSource(7);
+				marketplaceItem.setCommission(mpCosting.getCommission());
+				marketplaceItem.setServiceTax(mpCosting.getServiceTax());
+				marketplaceItem.setReturnProvision(mpCosting.getReturnProvision());
+				marketplaceItem.setEmiFee(mpCosting.getEmiFee());
+				marketplaceItem.setClosingFee(mpCosting.getClosingFee());
 				try {
 					item = catalogClient.getItem(sku);
 					if (item.getId()==0){
-						sb.append(sku + " Item not Present"+"\n");
+						sb.append(sku + " Item not valid"+"\n");
 						continue;
+					}
 				} catch (CatalogServiceException e) {
-					sb.append(sku + " Item not Present"+"\n");
+					sb.append(sku + " Item not valid"+"\n");
 					continue;
+				}
 				if(snapdealItem.getItem_id()==0){
 					new_item = true;
 					snapdealItem = new SnapdealItem();
 				sb.append(sku + " New Listing - Warehouse Id not Present"+"\n");
 				continue;
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(1))){
-				Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
+				/*Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
 				if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
 					sb.append(sku + "Not acceptable warehouse"+"\n");
 					continue;
-				}
+				}*/
 				long warehouseId = (long) sheet.getRow(iterator).getCell(1).getNumericCellValue();
 				double maxNLC = inventoryClient.getNlcForWarehouse(warehouseId, item.getId());
 				if (maxNLC==0){
 					sb.append(sku + "Max Nlc can't be 0"+"\n");
 					continue;
+				}
 				if ((long)sheet.getRow(iterator).getCell(3).getNumericCellValue()==0){
 					snapdealItem.setIsListedOnSnapdeal(false);
+				}
+			}
-			double transferPrice = 0,sellingPrice,commission,courierCost =45,serviceTax;
+			double transferPrice = 0,sellingPrice,commission,courierCost =45,serviceTax,otherCost;
-			if (checkEmptyString(sheet.getRow(iterator).getCell(4))){
+			if (checkEmptyString(sheet.getRow(iterator).getCell(4))&& new_item){
-				sb.append(sku + " Transfer Price cannot be empty"+"\n");
+				sb.append(sku + "New Item -  Selling Price cannot be empty"+"\n");
 				continue;
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(4))){
-				transferPrice = sheet.getRow(iterator).getCell(4).getNumericCellValue();
+				sellingPrice = sheet.getRow(iterator).getCell(4).getNumericCellValue();
-				if(transferPrice==0){
+				if(sellingPrice==0){
-					sb.append(sku + " Transfer Price cannot be zero"+"\n");
+					sb.append(sku + " Selling Price cannot be zero"+"\n");
 					continue;
+				}
-				snapdealItem.setTransferPrice(transferPrice);
+				snapdealItem.setSellingPrice(sellingPrice);
+				marketplaceItem.setCurrentSp(sellingPrice);
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(5))){
+				otherCost = sheet.getRow(iterator).getCell(5).getNumericCellValue();
+				marketplaceItem.setOtherCost(otherCost);
+			}
+			if (!checkEmptyString(sheet.getRow(iterator).getCell(6))){
-				if ((long)sheet.getRow(iterator).getCell(5).getNumericCellValue()==1){
+				if ((long)sheet.getRow(iterator).getCell(6).getNumericCellValue()==1){
 					snapdealItem.setSuppressPriceFeed(true);
+				}
-				if ((long)sheet.getRow(iterator).getCell(5).getNumericCellValue()==0){
+				if ((long)sheet.getRow(iterator).getCell(6).getNumericCellValue()==0){
 					snapdealItem.setSuppressPriceFeed(false);
+				}
+			}
-			if (!checkEmptyString(sheet.getRow(iterator).getCell(6))){
+			if (!checkEmptyString(sheet.getRow(iterator).getCell(7))){
-				if ((long)sheet.getRow(iterator).getCell(6).getNumericCellValue()==1){
+				if ((long)sheet.getRow(iterator).getCell(7).getNumericCellValue()==1){
 					snapdealItem.setSuppressInventoryFeed(true);
+				}
-				if ((long)sheet.getRow(iterator).getCell(6).getNumericCellValue()==0){
+				if ((long)sheet.getRow(iterator).getCell(7).getNumericCellValue()==0){
 					snapdealItem.setSuppressInventoryFeed(false);
+				}
+			}
-			if (!checkEmptyString(sheet.getRow(iterator).getCell(7))){
+			if (checkEmptyString(sheet.getRow(iterator).getCell(8)) && new_item){
-				sheet.getRow(iterator).getCell(7).setCellType(Cell.CELL_TYPE_STRING);
+				sb.append(sku + " New Item -  SKU@Snapdeal cannot be empty"+"\n");
-				String snapdealItemCode = sheet.getRow(iterator).getCell(7).getStringCellValue();
-				snapdealItem.setSkuAtSnapdeal(snapdealItemCode);
+				continue;
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(8))){
 				sheet.getRow(iterator).getCell(8).setCellType(Cell.CELL_TYPE_STRING);
+				String snapdealItemCode = sheet.getRow(iterator).getCell(8).getStringCellValue();
+				if (snapdealItemCode.length()==0 && new_item){
+					sb.append(sku + " New Item -  SKU@Snapdeal cannot be empty"+"\n");
+					continue;
+				}
+				snapdealItem.setSkuAtSnapdeal(snapdealItemCode);
+			}
+			if (checkEmptyString(sheet.getRow(iterator).getCell(9)) && new_item){
+				sb.append(sku + " New Item -  SUPC code cannot be empty"+"\n");
+				continue;
+			}
+			if (!checkEmptyString(sheet.getRow(iterator).getCell(9))){
+				sheet.getRow(iterator).getCell(9).setCellType(Cell.CELL_TYPE_STRING);
-				String supc = sheet.getRow(iterator).getCell(8).getStringCellValue();
+				String supc = sheet.getRow(iterator).getCell(9).getStringCellValue();
+				if (supc.length()==0 && new_item){
+					sb.append(sku + "  New Item -  SUPC code cannot be empty"+"\n");
+					continue;
+				}
 				snapdealItem.setSupc(supc);
+			}
 			double weight = item.getWeight();
-			/*
-			 *TODO Uncomment this for pricing feed.
-			 * if(weight==0){
+			if(weight==0){
 				sb.append(sku + " Please add weight"+"\n");
 				continue;
-			}*/
+			}
 			if (weight!=0){
+				weight = weight+.05;
 				int slabs = (int) ((weight - .001)/(.5));
 				for(int i=0;i<slabs;i++){
 					courierCost = courierCost + 35;
+				}
+			}
 			snapdealItem.setCourierCost(courierCost);
+			marketplaceItem.setCourierCost(courierCost);
-			sellingPrice = roundTwoDecimals(((transferPrice + courierCost*1.1236)/(100 - 3.59*1.1236))*100);
+			transferPrice = roundTwoDecimals(snapdealItem.getSellingPrice()- snapdealItem.getSellingPrice()*(marketplaceItem.getCommission()/100+marketplaceItem.getEmiFee()/100)*(1+(marketplaceItem.getServiceTax()/100))-(snapdealItem.getCourierCost()+marketplaceItem.getClosingFee())*(1+(marketplaceItem.getServiceTax()/100)));
-			snapdealItem.setSellingPrice(sellingPrice);
+			snapdealItem.setTransferPrice(transferPrice);
-			double commision_value = roundTwoDecimals(.0359*sellingPrice + courierCost);
+			marketplaceItem.setCurrentTp(transferPrice);
-			commission = roundTwoDecimals(((.0359*sellingPrice + courierCost)/sellingPrice)*100);
+			commission = roundTwoDecimals(((marketplaceItem.getCommission()/100)*snapdealItem.getSellingPrice()));
 			snapdealItem.setCommission(commission);
-			serviceTax = roundTwoDecimals((commision_value * .1236));
+			serviceTax = roundTwoDecimals((marketplaceItem.getServiceTax()/100)*(snapdealItem.getCommission()+snapdealItem.getCourierCost()));
 			snapdealItem.setServiceTax(serviceTax);
+			double vatRate = catalogClientProd.getVatPercentageForItem(snapdealItem.getItem_id(),0,snapdealItem.getSellingPrice());
+			marketplaceItem.setVat(vatRate);
+			double vat = roundTwoDecimals((snapdealItem.getSellingPrice()/(1+(marketplaceItem.getVat()/100))-(snapdealItem.getMaxNlc()/(1+(marketplaceItem.getVat()/100))))*(marketplaceItem.getVat()/100));
+			double inHouseCost = roundTwoDecimals(15+vat+(marketplaceItem.getReturnProvision()/100)*snapdealItem.getSellingPrice()+marketplaceItem.getOtherCost());
+			double lowest_possible_tp = roundTwoDecimals(snapdealItem.getMaxNlc()+inHouseCost);
+			marketplaceItem.setMinimumPossibleTp(lowest_possible_tp);
+			double lowest_possible_sp = roundTwoDecimals((snapdealItem.getMaxNlc()+(snapdealItem.getCourierCost()+marketplaceItem.getClosingFee())*(1+marketplaceItem.getServiceTax()/100)*(1+(marketplaceItem.getVat()/100))+(15+marketplaceItem.getOtherCost())*(1+(marketplaceItem.getVat())/100))/(1-(marketplaceItem.getCommission()/100+marketplaceItem.getEmiFee()/100)*(1+(marketplaceItem.getServiceTax()/100))*(1+(marketplaceItem.getVat())/100)-(marketplaceItem.getReturnProvision()/100)*(1+(marketplaceItem.getVat())/100)));
+			marketplaceItem.setMinimumPossibleSp(lowest_possible_sp);
+			snapdealItem.setUpdatedBy(updatedBy);
+			snapdealItem.setMarketplaceItems(marketplaceItem);
 			if(!catalogClient.addOrUpdateSnapdealItem(snapdealItem)){
-				sb.append(sku + "\n");
+				sb.append(sku + " Service Error\n");
+			}
+		}
-		//logger.info("Amazon Bulk Map "+amazonBulkUpdate.toString());
-		File file = new File("/tmp/amazonbulk");
+		File file = new File("/tmp/snapdealbulk");
 		FileWriter writer = new FileWriter(file);
 		writer.append(sb.toString());
 		writer.close();
 		byte[] buffer = new byte[(int)file.length()];
 		InputStream input = null;
 		return Double.valueOf(twoPlaces.format(d));
+	}
 	public String show() {
-		logger.info("Before fetching role");
-		logger.info(request.getSession().toString());
-		logger.info(ReportsUtils.ROLE);
-		logger.info(session.getAttribute(ReportsUtils.USER_NAME).toString());
-		logger.info(request.getRequestURI().substring(request.getContextPath().length()).split("/")[1]);
 		if(!ReportsUtils.canAccessReport((Long)session.getAttribute(ReportsUtils.ROLE), request.getRequestURI().substring(request.getContextPath().length()).split("/")[1])) {
-			logger.info(request.getRequestURI().substring(request.getContextPath().length()).split("/")[1]);
 			return "authfail";
+		}
 		if (StringUtils.equals(id, "snapdeal-options")){
 			return "snapdeal-options";
 	public void setId(String id) {
 		this.id = id;
+	}
+	public String getUserName(){
+		return session.getAttribute(ReportsUtils.USER_NAME).toString();
+	}
 	public HttpServletRequest getRequest() {
 		logger.info("set request"+request.toString());
 		return request;
+	}
 	public HttpSession getSession() {
 		return session;
+	}
 	public void setSession(HttpSession session) {
-		logger.info("set session"+session.toString());
 		this.session = session;
+	}
 	public ServletContext getContext() {
 		return context;

Subversion Repositories SmartDukaan

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