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



import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
 
import com.opensymphony.xwork2.ValidationAwareSupport;
 
@SuppressWarnings({"unused","deprecation"})
 
@InterceptorRefs({
	@InterceptorRef("defaultStack"),
	@InterceptorRef("login")
})

		return "snapdeal-bulk-upload";
	}
 
	public String update() throws NumberFormatException, TException, InventoryServiceException, CatalogServiceException, JSONException{
		Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
		//Client catalogClientProd = new CatalogClient().getClient();
		SnapdealItem snapdealItem = catalogClient.getSnapdealItem(Long.valueOf(itemId));
		Item item = catalogClient.getItem(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.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));
		/*if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
			throw new InventoryServiceException();
		}*/
		snapdealItem.setWarehouseId(Long.valueOf(warehouseId));
		snapdealItem.setIsListedOnSnapdeal(Boolean.valueOf(isListedOnSnapdeal));
		snapdealItem.setSuppressInventoryFeed(Boolean.valueOf(isSuppressInventoryFeed));

		snapdealItem.setServiceTax(Double.valueOf(serviceTax));
		snapdealItem.setMaxNlc(Double.valueOf(maxNlc));
		snapdealItem.setSkuAtSnapdeal(sdItemCode);
		snapdealItem.setSupc(supc);
		MarketplaceItems t_mpItem = updateMarketplaceItemDetails(mpItem);
		//double vat = catalogClientProd.getVatPercentageForItem(Long.valueOf(itemId), warehouse.getStateId(), Double.valueOf(sellingPrice));
		//t_mpItem.setVat(vat);
		snapdealItem.setUpdatedBy(getUserName());
		snapdealItem.setMarketplaceItems(t_mpItem);
 
		if(!compareParameters(t_mpItem,snapdealItem,warehouse,item.getWeight())){
			setComparsionResult("0");
			return "snapdeal-update-result";
		}
		else{
			setComparsionResult("1");

		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));

		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(!(getCourierCost(weight)==snapdealItem.getCourierCost())){
			compare_result=false;
		}
		
		if(!(getVatRateForItem(warehouse,snapdealItem.getSellingPrice(),snapdealItem.getItem_id())==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);
	}
 
	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.0;
		int slabs = (int) ((weight+.05 - .001)/(.5));
		for(int i=0;i<slabs;i++){
			cCost = cCost + 35;
		}
		return cCost;
	}

 
	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();
		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)){
			throw new InventoryServiceException();
		}*/
		SnapdealItem snapdealItem = new SnapdealItem();
		snapdealItem.setItem_id(Long.valueOf(itemId));
		snapdealItem.setWarehouseId(Long.valueOf(warehouseId));

		snapdealItem.setSupc(supc);
		snapdealItem.setUpdatedBy(getUserName());
 
		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);*/
		t_mpItem.setCommission(mpCosting.getCommission());
		t_mpItem.setServiceTax(mpCosting.getServiceTax());
		t_mpItem.setReturnProvision(mpCosting.getReturnProvision());
		t_mpItem.setEmiFee(mpCosting.getEmiFee());
		t_mpItem.setClosingFee(mpCosting.getClosingFee());
		if(!compareParameters(t_mpItem,snapdealItem,warehouse,item.getWeight())){
			setComparsionResult("0");
			return "snapdeal-update-result";
		}
		else{
			setComparsionResult("1");

	public String getAddNewItemForm(){
		return "snapdeal-add-item";
	}
 
	public String getItemDetailsInJson() throws NumberFormatException, CatalogServiceException, TException, JSONException, InventoryServiceException{
		Client catalogClientProd = new CatalogClient().getClient();
		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();

		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));
		/*if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){
			throw new InventoryServiceException();
		}*/
		double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
		double vat = catalogClientProd.getVatPercentageForItem(Long.valueOf(itemId), warehouse.getStateId(), Double.valueOf(sellingPrice));
		if (maxNLC==0){
			throw new InventoryServiceException();
		}
		itemObj = new JSONObject();
		itemObj.put("ItemId", item.getId());

		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("VatRate", vat);
		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, CatalogServiceException{
		Client catalogClientProd = new CatalogClient().getClient();
		InventoryClient inventoryServiceClient = new InventoryClient();
		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
		Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));
		//if (warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD){
		double maxNLC = inventoryClient.getNlcForWarehouse(Long.valueOf(warehouseId), Long.valueOf(itemId));
		double vat = catalogClientProd.getVatPercentageForItem(Long.valueOf(itemId), warehouse.getStateId(), Double.valueOf(sellingPrice));
		itemObj = new JSONObject();
		itemObj.put("ItemId", itemId);
		itemObj.put("WarehouseId", warehouseId);
		itemObj.put("MaxNlc", maxNLC);
		itemObj.put("VatRate", vat);
		/*}
		else{
			itemObj = new JSONObject();
			throw new 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);

		} 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;
			MarketplaceItems marketplaceItem = null;
			MarketplacePercentage mpCosting = null;
			Warehouse warehouse = null;
			Item item = null;
			Long sku;
			boolean new_item = false;
			if (checkEmptyString(sheet.getRow(iterator).getCell(0))){
				continue;

				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 valid"+"\n");
						continue;

				double maxNLC = inventoryClient.getNlcForWarehouse(warehouseId, item.getId());
				if (maxNLC==0){
					sb.append(sku + "Max Nlc can't be 0"+"\n");
					continue;
				}
				warehouse = inventoryClient.getWarehouse(warehouseId);
 
				snapdealItem.setWarehouseId(warehouseId);
				snapdealItem.setMaxNlc(maxNLC);
			}
 
			if (!checkEmptyString(sheet.getRow(iterator).getCell(2))){

				}
				if ((long)sheet.getRow(iterator).getCell(3).getNumericCellValue()==0){
					snapdealItem.setIsListedOnSnapdeal(false);
				}
			}
 
			double transferPrice = 0,sellingPrice,commission,courierCost =45,serviceTax,otherCost;
			if (checkEmptyString(sheet.getRow(iterator).getCell(4))&& new_item){
				sb.append(sku + "New Item -  Selling Price cannot be empty"+"\n");
				continue;
			}

					continue;
				}
				snapdealItem.setSellingPrice(sellingPrice);
				marketplaceItem.setCurrentSp(sellingPrice);
			}
 
			if (!checkEmptyString(sheet.getRow(iterator).getCell(5))){
				otherCost = sheet.getRow(iterator).getCell(5).getNumericCellValue();
				marketplaceItem.setOtherCost(otherCost);
			}
 

					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;
			}
 

				}
				snapdealItem.setSupc(supc);
			}
			double weight = item.getWeight();
 
 
			if(weight==0){
				sb.append(sku + " Please add weight"+"\n");
				continue;
			}
			if (weight!=0){

			marketplaceItem.setCurrentTp(transferPrice);
			commission = roundTwoDecimals(((marketplaceItem.getCommission()/100)*snapdealItem.getSellingPrice()));
			snapdealItem.setCommission(commission);
			serviceTax = roundTwoDecimals((marketplaceItem.getServiceTax()/100)*(snapdealItem.getCommission()+snapdealItem.getCourierCost())); 
			snapdealItem.setServiceTax(serviceTax);
			double vatRate = catalogClientProd.getVatPercentageForItem(snapdealItem.getItem_id(),warehouse.getStateId(),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);
			//logger.info(snapdealItem.toString());
			if(!catalogClient.addOrUpdateSnapdealItem(snapdealItem)){
				sb.append(sku + " Service Error\n");
			}	
		}
		File file = new File("/tmp/snapdealbulk");

	double roundTwoDecimals(double d) {
		DecimalFormat twoPlaces = new DecimalFormat("#.##");
		return Double.valueOf(twoPlaces.format(d));
	}
 
	/*String getLocation(String location){
		logger.info("Inside trim"+location);
		int loc = location.lastIndexOf(',');
		logger.info("end result "+location.substring(loc+1));
		return location.substring(loc+1);
	}*/
 
 
	public String show() {
		if(!ReportsUtils.canAccessReport((Long)session.getAttribute(ReportsUtils.ROLE), request.getRequestURI().substring(request.getContextPath().length()).split("/")[1])) {
			return "authfail";
		}

Subversion Repositories SmartDukaan

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

Rev 9812		Rev 9825
Line 59...		Line 59...
59	`import org.slf4j.Logger;`	59	`import org.slf4j.Logger;`
60	`import org.slf4j.LoggerFactory;`	60	`import org.slf4j.LoggerFactory;`
61		61
62	`import com.opensymphony.xwork2.ValidationAwareSupport;`	62	`import com.opensymphony.xwork2.ValidationAwareSupport;`
63		63
64	`@SuppressWarnings("unused")`	64	`@SuppressWarnings({"unused","deprecation"})`
65		65
66	`@InterceptorRefs({`	66	`@InterceptorRefs({`
67	`@InterceptorRef("defaultStack"),`	67	`@InterceptorRef("defaultStack"),`
68	`@InterceptorRef("login")`	68	`@InterceptorRef("login")`
69	`})`	69	`})`
Line 316...		Line 316...
316	`return "snapdeal-bulk-upload";`	316	`return "snapdeal-bulk-upload";`
317	`}`	317	`}`
318		318
319	`public String update() throws NumberFormatException, TException, InventoryServiceException, CatalogServiceException, JSONException{`	319	`public String update() throws NumberFormatException, TException, InventoryServiceException, CatalogServiceException, JSONException{`
320	`Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();`	320	`Client catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();`
-		321	`//Client catalogClientProd = new CatalogClient().getClient();`
321	`SnapdealItem snapdealItem = catalogClient.getSnapdealItem(Long.valueOf(itemId));`	322	`SnapdealItem snapdealItem = catalogClient.getSnapdealItem(Long.valueOf(itemId));`
-		323	`Item item = catalogClient.getItem(Long.valueOf(itemId));`
322	`MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));`	324	`MarketplacePercentage mpCosting = catalogClient.getCostingForMarketplace(7, Long.valueOf(itemId));`
323	`if (mpCosting.getSource()==0){`	325	`if (mpCosting.getSource()==0){`
324	`throw new CatalogServiceException();`	326	`throw new CatalogServiceException();`
325	`}`	327	`}`
326	`MarketplaceItems mpItem = catalogClient.getMarketplacedetailsForItem(Long.valueOf(itemId),7);`	328	`MarketplaceItems mpItem = catalogClient.getMarketplacedetailsForItem(Long.valueOf(itemId),7);`
Line 329...		Line 331...
329	`mpItem.setClosingFee(mpCosting.getClosingFee());`	331	`mpItem.setClosingFee(mpCosting.getClosingFee());`
330	`mpItem.setServiceTax(mpCosting.getServiceTax());`	332	`mpItem.setServiceTax(mpCosting.getServiceTax());`
331	`mpItem.setCommission(mpCosting.getCommission());`	333	`mpItem.setCommission(mpCosting.getCommission());`
332	`InventoryClient inventoryServiceClient = new InventoryClient();`	334	`InventoryClient inventoryServiceClient = new InventoryClient();`
333	`in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();`	335	`in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();`
334	`/*Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));`	336	`Warehouse warehouse = inventoryClient.getWarehouse(Long.valueOf(warehouseId));`
335	`if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){`	337	`/*if (!(warehouse.getWarehouseType()==WarehouseType.OURS && warehouse.getInventoryType() == InventoryType.GOOD)){`
336	`throw new InventoryServiceException();`	338	`throw new InventoryServiceException();`
337	`}*/`	339	`}*/`
338	`snapdealItem.setWarehouseId(Long.valueOf(warehouseId));`	340	`snapdealItem.setWarehouseId(Long.valueOf(warehouseId));`
339	`snapdealItem.setIsListedOnSnapdeal(Boolean.valueOf(isListedOnSnapdeal));`	341	`snapdealItem.setIsListedOnSnapdeal(Boolean.valueOf(isListedOnSnapdeal));`
340	`snapdealItem.setSuppressInventoryFeed(Boolean.valueOf(isSuppressInventoryFeed));`	342	`snapdealItem.setSuppressInventoryFeed(Boolean.valueOf(isSuppressInventoryFeed));`
Line 347...		Line 349...