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

 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.OOSStatus;
 import in.shop2020.model.v1.inventory.Warehouse;
 import in.shop2020.model.v1.inventory.WarehouseType;
 import in.shop2020.model.v1.order.SnapdealOrder;
 import in.shop2020.support.utils.ReportsUtils;
 import in.shop2020.thrift.clients.CatalogClient;
 	private String currentTp;
 	private String minPosSp;
 	private String minPosTp;
 	private String vat;
 	private String comparsionResult;
+	private String maxSp;
+	private String nDaySale;
+	public String getnDaySale() {
+		return nDaySale;
+	}
+	public void setnDaySale(String nDaySale) {
+		this.nDaySale = nDaySale;
+	}
+	private String avgSale;
+	public String getAvgSale() {
+		return avgSale;
+	}
+	public void setAvgSale(String avgSale) {
+		this.avgSale = avgSale;
+	}
+	public String getMaxSp() {
+		return maxSp;
+	}
+	public void setMaxSp(String maxSp) {
+		this.maxSp = maxSp;
+	}
 	public String getComparsionResult() {
 		return comparsionResult;
+	}
 	public void setComparsionResult(String comparsionResult) {
 		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, Warehouse warehouse,double weight) throws TException, JSONException, CatalogServiceException{
 		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+mpItem.getEmiFee()/100)*(1+(mpItem.getServiceTax()/100))-(snapdealItem.getCourierCost()+mpItem.getClosingFee())*(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()+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));
+		double vat_rate_prod = getVatRateForItem(warehouse,snapdealItem.getSellingPrice(),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 Backend validation "+x.toString());
 		boolean compare_result=true;
 		if(!(getCourierCost(weight)==snapdealItem.getCourierCost())){
 			compare_result=false;
+		}
-		if(!(getVatRateForItem(warehouse,snapdealItem.getSellingPrice(),snapdealItem.getItem_id())==mpItem.getVat())){
+		if(!(vat_rate_prod==mpItem.getVat())){
 			compare_result=false;
+		}
 		if(!(nlc==snapdealItem.getMaxNlc())){
 			compare_result=false;
+		}
 		if(!(lowest_possible_tp-mpItem.getMinimumPossibleTp()>-1 && lowest_possible_tp-mpItem.getMinimumPossibleTp()<1)){
 			compare_result=false;
 			compare_result=false;
+		}
 		return compare_result;
+	}
 	public double getVatRateForItem(Warehouse warehouse, double sellingPrice,long itemId) throws CatalogServiceException, TException{
 		Client catalogClientProd = new CatalogClient().getClient();
 		return catalogClientProd.getVatPercentageForItem(itemId, warehouse.getStateId(), sellingPrice);
+	}
 			cCost = cCost + 35;
+		}
 		return cCost;
+	}
+	public void getLastNDaySaleForItem(String itemId,String days) {
+		try{
+			InventoryClient inventoryServiceClient = new InventoryClient();
+			in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
+			List<OOSStatus> oosStatuses = inventoryClient.getOosStatusesForXDaysForItem(Long.valueOf(itemId), 7, Integer.valueOf(days));
+			String lastNdaySale="";
+			double avgSale = 0.0;
+			long count = 0,sale = 0;
+			for(OOSStatus oosStatus : oosStatuses){
+				if(oosStatus.isIs_oos()){
+					lastNdaySale += "X-";
+				}else{
+					lastNdaySale += oosStatus.getNum_orders() + "-";
+					sale = sale + oosStatus.getNum_orders();
+					count+=1;
+				}
+			}
+			lastNdaySale = lastNdaySale.substring(0, lastNdaySale.length()-1);
+			lastNdaySale += "\n";
+			setnDaySale(lastNdaySale);
+			if (count!=0){
+				setAvgSale(String.valueOf(roundTwoDecimals(sale/count)));
+			}
+			else{
+				setAvgSale("0");
+			}
+		}
+		catch (Exception e){
+			setAvgSale("0");
+			setnDaySale("Unable to fetch");
+			logger.error("Unable to get last n day sale",e);
+		}
+	}
 	private MarketplaceItems updateMarketplaceItemDetails(MarketplaceItems mpItem){
 		mpItem.setItemId(Long.valueOf(itemId));
 		mpItem.setSource(7);
 		mpItem.setVat(Double.valueOf(vat));
 		mpItem.setAutoDecrement(Boolean.valueOf(isAutoDecrement));
 		mpItem.setAutoIncrement(Boolean.valueOf(isAutoIncrement));
 		mpItem.setManualFavourite(Boolean.valueOf(isManualFavourite));
 		mpItem.setMinimumPossibleSp(Double.valueOf(minPosSp));
 		mpItem.setMinimumPossibleTp(Double.valueOf(minPosTp));
+		mpItem.setMaximumSellingPrice(Double.valueOf(maxSp));
 		return mpItem;
+	}
 	private void sendAlert(long itemId,double sp,double minSp){
 		Item item;
 		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
 		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 		Item item = catalogClient.getItem(Long.valueOf(itemId));
 		//Client catalogClientProd = new CatalogClient().getClient();
 		MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));
 		if (mpCosting.getSource()==0){
 			throw new CatalogServiceException();
+		}
 		Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
 		/*if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
+	}
 	public double getRoundOfValue(String val){
 		return roundTwoDecimals(Double.valueOf(val));
+	}
 	public String getVaildName(String name){
 		return name!=null?name:"";
+	}

Subversion Repositories SmartDukaan

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