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

 	private String currentSp;
 	private String currentTp;
 	private String minPosSp;
 	private String minPosTp;
 	private String vat;
+	private String comparsionResult;
+	public String getComparsionResult() {
+		return comparsionResult;
+	}
+	public void setComparsionResult(String comparsionResult) {
+		this.comparsionResult = comparsionResult;
+	}
+	private Map<Integer, Long> holdInventoryMap;
 	public String getVat() {
 		return vat;
+	}
 			return "authfail";
+		}
 		return "snapdeal-bulk-upload";
+	}
-	public void update() throws NumberFormatException, TException, InventoryServiceException, CatalogServiceException{
+	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));
 		MarketplaceItems mpItem = catalogClient.getMarketplacedetailsForItem(Long.valueOf(itemId),7);
 		InventoryClient inventoryServiceClient = new InventoryClient();
 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
+		}
 		if (!StringUtils.equalsIgnoreCase(snapdealItem.getSupc(), supc)){
 			snapdealItem.setSupc(supc);
 			commit=true;
+		}
+		MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
+		if(!compareParameters(t_mpItem,snapdealItem)){
+			setComparsionResult("0");
+			return "snapdeal-update-result";
+		}
+		else{
+			setComparsionResult("1");
+		}
 		if (commit){
-			catalogClient.addOrUpdateSnapdealItem(snapdealItem);
+			if(!catalogClient.addOrUpdateSnapdealItem(snapdealItem)){
+				throw new CatalogServiceException();
+			}
+		}
-		MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
-		boolean result =catalogClient.updateMarketplaceAttributesForItem(t_mpItem);
+		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 our_tp =  snapdealItem.getSellingPrice()- snapdealItem.getSellingPrice()*(mpItem.getCommission()/100)*(1+(mpItem.getServiceTax()/100))-snapdealItem.getCourierCost()*(1+(mpItem.getServiceTax()/100));
+	    double commission =  ((mpItem.getCommission()/100)*snapdealItem.getSellingPrice());
+	    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));
+	    JSONObject x = new JSONObject();
+	    x.put("NLC", nlc);
+	    x.put("VAT", vat);
+	    x.put("LOWEST POS TP", lowest_possible_tp);
+	    x.put("TP", our_tp);
+	    x.put("COMMISSION", commission);
+	    x.put("SERVICE TAX", service_tax);
+	    x.put("LOWEST POS SP", lowest_possible_sp);
+	    logger.info("Snapdeal Backend validation "+x.toString());
+	    boolean compare_result=true;
+	    if(!(nlc==snapdealItem.getMaxNlc())){
+	    	compare_result=false;
+	    }
+	    if(!(lowest_possible_tp-mpItem.getMinimumPossibleTp()>-1 && lowest_possible_tp-mpItem.getMinimumPossibleTp()<1)){
+	    	compare_result=false;
+	    }
+	    if(!(our_tp-snapdealItem.getTransferPrice()>-1 && our_tp-snapdealItem.getTransferPrice()<1)){
+	    	compare_result=false;
+	    }
+	    if(!(commission-snapdealItem.getCommission()>-1 && commission-snapdealItem.getCommission()<1)){
+	    	compare_result=false;
+	    }
+	    if(!(service_tax-snapdealItem.getServiceTax()>-1 && service_tax-snapdealItem.getServiceTax()<1)){
+	    	compare_result=false;
+	    }
+	    if(!(lowest_possible_sp-mpItem.getMinimumPossibleSp()>-1 && lowest_possible_sp-mpItem.getMinimumPossibleSp()<1)){
+	    	compare_result=false;
+	    }
+	    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;
+		}
+		return cCost;
+	}
 	private MarketplaceItems updateMarketplaceItemDetails(MarketplaceItems mpItem){
 		mpItem.setItemId(Long.valueOf(itemId));
 		mpItem.setSource(7);
 		mpItem.setVat(Double.valueOf(vat));
 		mpItem.setCourierCost(Double.valueOf(courierCost));
 		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());
+		}
+	}
 		snapdealItem.setCommission(Double.valueOf(commission));
 		snapdealItem.setServiceTax(Double.valueOf(serviceTax));
 		snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
 		snapdealItem.setSkuAtSnapdeal(sdItemCode);
 		snapdealItem.setSupc(supc);
 		MarketplaceItems mpItem = new MarketplaceItems();
 		MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
 		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 		catalogClient.addOrUpdateSnapdealItem(snapdealItem);
 		boolean result =catalogClient.updateMarketplaceAttributesForItem(t_mpItem);
 			logger.error("Unable to get inventory info for item",e);
 			return null;
+		}
+	}
-	public Warehouse getWarehouse(String warehouseId) throws NumberFormatException, TException, InventoryServiceException {
+	public Warehouse getWarehouse(String warehouseId,String itemId) throws NumberFormatException, TException, InventoryServiceException {
 		InventoryClient inventoryServiceClient = new InventoryClient();
+		holdInventoryMap =inventoryServiceClient.getClient().getHeldInventoryMapForItem(Long.valueOf(itemId), Long.valueOf(warehouseId));
 		return inventoryServiceClient.getClient().getWarehouse(Long.valueOf(warehouseId));
+	}
+	public Map<Integer, Long> getHoldInventoryMapForItem(){
+		return holdInventoryMap;
+	}
 	public void changeHeldForSource() throws NumberFormatException, TException, InventoryServiceException{
 		InventoryClient inventoryServiceClient = new InventoryClient();
 		Warehouse warehouse = inventoryServiceClient.getClient().getWarehouse(Long.valueOf(warehouseId));
 		if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
 			throw new InventoryServiceException();

Subversion Repositories SmartDukaan

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