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

     private String productName;
     private String startDate;
     private String endDate;
     private String courierCostMarketplace;
     private String packagingCost;
+    private String sdVoiItemCode;
+    private String voiSellingPrice;
+    private String isSuppressVoiPriceFeed;
+    private String isVoiListedOnSnapdeal;
+    private String minPosSpVoi;
+    private String minPosTpVoi;
+    private String transferPriceVOI;
+    private String serviceTaxVOI;
+    private String courierCostVoi;
+    private String commissionVoi;
     public String courierCostMarketplace() {
         return courierCostMarketplace;
+    }
     public void setCourierCostMarketplace(String courierCostMarketplace) {
         Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
         SnapdealItemDetails sdItemDetails = CatalogClient.getSnapdealItemDetails(Long.valueOf(id));
         lastUpdatedInventoryTimeStampForItem(sdItemDetails.getLastUpdatedInventoryTimestamp());
         return sdItemDetails;
+    }
+    public SnapdealItem fetchSdItem() throws NumberFormatException, TException {
+        Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
+        SnapdealItem sdItemDetails = CatalogClient.getSnapdealItem(Long.valueOf(id));
+        return sdItemDetails;
+    }
     public MarketplaceItems fetchMarketplaceDetail() throws NumberFormatException, TException {
         Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
         MarketplaceItems mpItemDetails = CatalogClient.getMarketplacedetailsForItem(Long.valueOf(id), 7);
         lastCheckedTimeStampForItem(mpItemDetails.getLastCheckedTimestamp());
         Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
         //Client catalogClientProd = new CatalogClient().getClient();
         Long timestamp = System.currentTimeMillis();
         SnapdealItem snapdealItem = catalogClient.getSnapdealItem(Long.valueOf(itemId));
         boolean toUpdate = false;
+        if (snapdealItem.getSellingPrice()!=Double.valueOf(sellingPrice)
+        		|| snapdealItem.isIsListedOnSnapdeal()!=Boolean.valueOf(isListedOnSnapdeal)
-        if (snapdealItem.getSellingPrice()!=Double.valueOf(sellingPrice) || snapdealItem.isIsListedOnSnapdeal()!=Boolean.valueOf(isListedOnSnapdeal) || snapdealItem.isSuppressPriceFeed()!=Boolean.valueOf(isSuppressPriceFeed)){
+        		|| snapdealItem.isSuppressPriceFeed()!=Boolean.valueOf(isSuppressPriceFeed)){
             toUpdate=true;
+        }
+        if(sdVoiItemCode!=null && sdVoiItemCode.trim().length()>0){
+        	if(snapdealItem.isIsVoiListed()!=Boolean.valueOf(isVoiListedOnSnapdeal)
+            		|| snapdealItem.isSuppressVoiPriceFeed()!=Boolean.valueOf(isSuppressVoiPriceFeed)
+            		|| snapdealItem.getVoiSellingPrice()!=Double.valueOf(voiSellingPrice)){
+        		toUpdate=true;
+        	}
+        }
         Item item = catalogClient.getItem(Long.valueOf(itemId));
         MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));
         if (mpCosting.getSource()==0){
             throw new CatalogServiceException();
+        }
         snapdealItem.setServiceTax(Double.valueOf(serviceTax));
         snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
         snapdealItem.setSkuAtSnapdeal(sdItemCode);
         snapdealItem.setSupc(supc);
         snapdealItem.setCourierCostMarketplace(Double.valueOf(courierCostMarketplace));
+        if(sdVoiItemCode!=null && sdVoiItemCode.trim().length()>0){
+        	snapdealItem.setVoiSkuAtSnapdeal(sdVoiItemCode.trim());
+        	snapdealItem.setIsVoiListed(Boolean.valueOf(isVoiListedOnSnapdeal));
+            snapdealItem.setVoiSellingPrice(Double.parseDouble(voiSellingPrice));
+            snapdealItem.setSuppressVoiPriceFeed(Boolean.valueOf(isSuppressVoiPriceFeed));
+            snapdealItem.setMinimumPossibleSpVoi(Double.parseDouble(minPosSpVoi));
+        	snapdealItem.setMinimumPossibleTpVoi(Double.parseDouble(minPosTpVoi));
+        	snapdealItem.setCourierCostVoi(Double.parseDouble(courierCostVoi));
+        	snapdealItem.setCommissionVoi(Double.parseDouble(commissionVoi));
+        	snapdealItem.setServiceTaxVoi(Double.parseDouble(serviceTaxVOI));
+        	snapdealItem.setTransferPriceVoi(Double.parseDouble(transferPriceVOI));
+        }
         MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
         //double vat = catalogClientProd.getVatPercentageForItem(Long.valueOf(itemId), warehouse.getStateId(), Double.valueOf(sellingPrice));
         //t_mpItem.setVat(vat);
         t_mpItem.setCourierCostMarketplace(Double.valueOf(courierCostMarketplace));
         snapdealItem.setUpdatedBy(getUserName());
             sendAlert(t_mpItem.getItemId(),t_mpItem.getCurrentSp(),t_mpItem.getMinimumPossibleSp());
+        }
         logger.info("\nUpdate Method Item Id "+itemId+"\nSelling Price "+sellingPrice+"\nWarehouse Id "+warehouseId+"\nMax Nlc "+maxNlc+"\nUpdated By: "+session.getAttribute(ReportsUtils.USER_NAME).toString());
         if(toUpdate && Boolean.valueOf(live) && (!snapdealItem.isSuppressPriceFeed()) && snapdealItem.isIsListedOnSnapdeal()){
             logger.info("Calling Method to update price at snapdeal");
-            UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(sellingPrice),supc,item,timestamp);
+            UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(sellingPrice),supc,item,timestamp,false);
+            logger.info("Calling Thread to update price at snapdeal");
+            updatePriceOnSnapdeal.start();
+        }
+        if(toUpdate && Boolean.valueOf(live) && (!snapdealItem.isSuppressVoiPriceFeed()) && snapdealItem.isIsVoiListed()){
+            logger.info("Calling Method to update price at snapdeal");
+            UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(voiSellingPrice),supc,item,timestamp,true);
             logger.info("Calling Thread to update price at snapdeal");
             updatePriceOnSnapdeal.start();
+        }
         return "snapdeal-update-result";
+    }
     public void updateForAutoPricing() throws NumberFormatException, CatalogServiceException, TException{
         logger.info("Calling Method to update price at snapdeal for auto pricing");
         Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
         Item item = catalogClient.getItem(Long.valueOf(itemId));
-        UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(sellingPrice),supc,item,System.currentTimeMillis());
+        UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(sellingPrice),supc,item,System.currentTimeMillis(),false);
         logger.info("Calling Thread to update price at snapdeal for auto pricing");
         updatePriceOnSnapdeal.start();
+    }
             compare_result=false;
+        }
         return compare_result;
+    }
+    public boolean compareParametersVOI(MarketplaceItems mpItem,SnapdealItem snapdealItem, Warehouse warehouse,double weight, Long categoryId) throws TException, JSONException, CatalogServiceException{
+    	double nlc =getNlcForWarehouse(snapdealItem.getWarehouseId(),snapdealItem.getItem_id());
+    	double courierCostMp = getCourierCostVOI(weight);
+        double vat = (snapdealItem.getVoiSellingPrice()/(1+(mpItem.getVat()/100))-(nlc/(1+(mpItem.getVat()/100))))*(mpItem.getVat()/100);
+        double inHouseCost = mpItem.getPackagingCost()+vat+(mpItem.getReturnProvision()/100)*snapdealItem.getVoiSellingPrice()+mpItem.getOtherCost();
+        double lowest_possible_tp = nlc+inHouseCost;
+        double our_tp =  snapdealItem.getVoiSellingPrice()- snapdealItem.getVoiSellingPrice()*((mpItem.getCommission()/100)+mpItem.getEmiFee()/100)*(1+(mpItem.getServiceTax()/100))-(courierCostMp+mpItem.getClosingFee())*(1+(Double.parseDouble(serviceTaxVOI)/100))-(Math.max(20,(mpItem.getPgFee()/100)*snapdealItem.getVoiSellingPrice())*(1+(Double.parseDouble(serviceTaxVOI)/100)));
+        double commission=0.0;
+        if ((mpItem.getPgFee()/100)*snapdealItem.getVoiSellingPrice()>=20){
+            commission =  (((mpItem.getCommission()/100)+mpItem.getPgFee()/100)*snapdealItem.getVoiSellingPrice());
+        }
+        else{
+            commission =  ((mpItem.getCommission()/100)*snapdealItem.getVoiSellingPrice()+20);
+        }
+        double service_tax = (Double.parseDouble(serviceTaxVOI)/100)*(snapdealItem.getCommission()+courierCostMp);
+        double lowest_possible_sp = 0.0;
+        if ((mpItem.getPgFee()/100)*snapdealItem.getVoiSellingPrice()>=20){
+            lowest_possible_sp = (nlc+(courierCostMp+mpItem.getClosingFee())*(1+(Double.parseDouble(serviceTaxVOI)/100))*(1+(mpItem.getVat()/100))+(mpItem.getPackagingCost()+mpItem.getOtherCost())*(1+(mpItem.getVat())/100))/(1-((mpItem.getCommission()/100)+mpItem.getEmiFee()/100+mpItem.getPgFee()/100)*(1+(Double.parseDouble(serviceTaxVOI)/100))*(1+(mpItem.getVat())/100)-(mpItem.getReturnProvision()/100)*(1+(mpItem.getVat())/100));
+        }
+        else{
+            lowest_possible_sp = (nlc+(courierCostMp+mpItem.getClosingFee()+20)*(1+(Double.parseDouble(serviceTaxVOI)/100))*(1+(mpItem.getVat()/100))+(mpItem.getPackagingCost()+mpItem.getOtherCost())*(1+(mpItem.getVat())/100))/(1-((mpItem.getCommission()/100)+mpItem.getEmiFee()/100)*(1+(Double.parseDouble(serviceTaxVOI)/100))*(1+(mpItem.getVat())/100)-(mpItem.getReturnProvision()/100)*(1+(mpItem.getVat())/100));
+        }
+        double vat_rate_prod = getVatRateForItem(warehouse,snapdealItem.getVoiSellingPrice(),snapdealItem.getItem_id());
+        JSONObject x = new JSONObject();
+        x.put("NLC", nlc);
+        x.put("VAT", vat);
+        x.put("COURIER COST",getCourierCost(weight));
+        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);
+        x.put("VAT RATE",vat_rate_prod);
+        logger.info("Snapdeal VOI Backend validation "+x.toString());
+        boolean compare_result=true;
+        if(!(mpItem.getPackagingCost()==computePackagingCost(categoryId))){
+            compare_result=false;
+        }
+        if(!(vat_rate_prod==mpItem.getVat())){
+            compare_result=false;
+        }
+        if(!(nlc==snapdealItem.getMaxNlc())){
+            compare_result=false;
+        }
+        if(!(lowest_possible_tp-Double.parseDouble(minPosTpVoi)>-1 && lowest_possible_tp-Double.parseDouble(minPosTpVoi)<1)){
+            compare_result=false;
+        }
+        if(!(our_tp-snapdealItem.getTransferPriceVoi()>-1 && our_tp-snapdealItem.getTransferPriceVoi()<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-Double.parseDouble(minPosSpVoi)>-1 && lowest_possible_sp-Double.parseDouble(minPosSpVoi)<1)){
+            compare_result=false;
+        }
+        return compare_result;
+    }
     private double computePackagingCost(Long categoryId) {
         double pc = 15.0;
         if (categoryId==10006 || categoryId==10010){
             pc =pc + 43.0;
         for(int i=0;i<slabs;i++){
             cCost = cCost + 35;
+        }
         return cCost;
+    }
+    public double getCourierCostVOI(double weight){
+        double cCost = 40.0;
+        int slabs = (int) ((weight+.05 - .001)/(.5));
+        for(int i=0;i<slabs;i++){
+            cCost = cCost + 30;
+        }
+        return cCost;
+    }
     public void getLastNDaySaleForItem(String itemId,String days) {
         try{
             InventoryClient inventoryServiceClient = new InventoryClient();
             in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
         snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
         snapdealItem.setSkuAtSnapdeal(sdItemCode);
         snapdealItem.setSupc(supc);
         snapdealItem.setUpdatedBy(getUserName());
         snapdealItem.setCourierCostMarketplace(Double.valueOf(courierCostMarketplace));
+        if(sdVoiItemCode!=null && sdVoiItemCode.trim().length()>0){
+        	snapdealItem.setIsVoiListed(Boolean.parseBoolean(isVoiListedOnSnapdeal));
+        	snapdealItem.setSuppressVoiPriceFeed(Boolean.valueOf(isSuppressVoiPriceFeed));
+        	snapdealItem.setVoiSkuAtSnapdeal(sdVoiItemCode.trim());
+        	snapdealItem.setVoiSellingPrice(Double.parseDouble(voiSellingPrice));
+        	snapdealItem.setMinimumPossibleSpVoi(Double.parseDouble(minPosSpVoi));
+        	snapdealItem.setMinimumPossibleTpVoi(Double.parseDouble(minPosTpVoi));
+        	snapdealItem.setCourierCostVoi(Double.parseDouble(courierCostVoi));
+        	snapdealItem.setCommissionVoi(Double.parseDouble(commissionVoi));
+        	snapdealItem.setServiceTaxVoi(Double.parseDouble(serviceTaxVOI));
+        	snapdealItem.setTransferPriceVoi(Double.parseDouble(transferPriceVOI));
+        }
         MarketplaceItems mpItem = new MarketplaceItems();
         MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
         /*double vat = catalogClientProd.getVatPercentageForItem(Long.valueOf(itemId), warehouse.getStateId(), Double.valueOf(sellingPrice));
 		t_mpItem.setVat(vat);*/
             throw new CatalogServiceException();
+        }
         if (t_mpItem.getCurrentSp()< t_mpItem.getMinimumPossibleSp()){
             sendAlert(t_mpItem.getItemId(),t_mpItem.getCurrentSp(),t_mpItem.getMinimumPossibleSp());
+        }
         if (Boolean.valueOf(live) && (!snapdealItem.isSuppressPriceFeed()) && snapdealItem.isIsListedOnSnapdeal()){
             logger.info("Calling Method to update new item price at snapdeal");
-            UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(sellingPrice),supc,item,timestamp);
+            UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(sellingPrice),supc,item,timestamp,false);
             logger.info("Calling Thread to update new item price at snapdeal");
             updatePriceOnSnapdeal.start();
+        }
+        if(Boolean.valueOf(live) && (!snapdealItem.isSuppressVoiPriceFeed()) && snapdealItem.isIsVoiListed()){
+            logger.info("Calling Method to update price at snapdeal");
+            UpdateSDPricingUsingPanel updatePriceOnSnapdeal = new UpdateSDPricingUsingPanel(Float.valueOf(voiSellingPrice),supc,item,timestamp,true);
+            logger.info("Calling Thread to update price at snapdeal");
+            updatePriceOnSnapdeal.start();
+        }
         return "snapdeal-update-result";
+    }
     public String getAddNewItemForm(){
     public void setPackagingCost(String packagingCost) {
         this.packagingCost = packagingCost;
+    }
+	public String getSdVoiItemCode() {
+		return sdVoiItemCode;
+	}
+	public void setSdVoiItemCode(String sdVoiItemCode) {
+		this.sdVoiItemCode = sdVoiItemCode;
+	}
+	public String getVoiSellingPrice() {
+		return voiSellingPrice;
+	}
+	public void setVoiSellingPrice(String voiSellingPrice) {
+		this.voiSellingPrice = voiSellingPrice;
+	}
+	public String getIsSuppressVoiPriceFeed() {
+		return isSuppressVoiPriceFeed;
+	}
+	public void setIsSuppressVoiPriceFeed(String isSuppressVoiPriceFeed) {
+		this.isSuppressVoiPriceFeed = isSuppressVoiPriceFeed;
+	}
+	public String getIsVoiListedOnSnapdeal() {
+		return isVoiListedOnSnapdeal;
+	}
+	public void setIsVoiListedOnSnapdeal(String isVoiListedOnSnapdeal) {
+		this.isVoiListedOnSnapdeal = isVoiListedOnSnapdeal;
+	}
+	public String getMinPosSpVoi() {
+		return minPosSpVoi;
+	}
+	public void setMinPosSpVoi(String minPosSpVoi) {
+		this.minPosSpVoi = minPosSpVoi;
+	}
+	public String getMinPosTpVoi() {
+		return minPosTpVoi;
+	}
+	public void setMinPosTpVoi(String minPosTpVoi) {
+		this.minPosTpVoi = minPosTpVoi;
+	}
+	public String getTransferPriceVOI() {
+		return transferPriceVOI;
+	}
+	public void setTransferPriceVOI(String transferPriceVOI) {
+		this.transferPriceVOI = transferPriceVOI;
+	}
+	public String getServiceTaxVOI() {
+		return serviceTaxVOI;
+	}
+	public void setServiceTaxVOI(String serviceTaxVOI) {
+		this.serviceTaxVOI = serviceTaxVOI;
+	}
+	public String getCourierCostVoi() {
+		return courierCostVoi;
+	}
+	public void setCourierCostVoi(String courierCostVoi) {
+		this.courierCostVoi = courierCostVoi;
+	}
+	public String getCommissionVoi() {
+		return commissionVoi;
+	}
+	public void setCommissionVoi(String commissionVoi) {
+		this.commissionVoi = commissionVoi;
+	}
+}

Subversion Repositories SmartDukaan

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