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

 package in.shop2020.support.controllers;
 import in.shop2020.model.v1.catalog.Amazonlisted;
 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.SnapdealItem;
+import in.shop2020.model.v1.catalog.SnapdealItemDetails;
 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.TransactionClient;
 import java.io.FileOutputStream;
 import java.io.FileWriter;
 import java.io.IOException;
 import java.io.InputStream;
 import java.util.ArrayList;
+import java.util.Arrays;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
 import javax.servlet.ServletContext;
 	private String warehouseId;
 	private File file;
 	private String errMsg;
 	private String next;
 	private String id;
+	private String searchText;
+	private List<SnapdealItemDetails> snapdealItems;
+	private long searchCount;
+	private long totalCount;
 	public String index() {
 		if (!ReportsUtils.canAccessReport((Long) session.getAttribute(ReportsUtils.ROLE),request.getServletPath())) {
 			return "authfail";
+		}
 		return "index";
+	}
+	public String fetchItems() throws TException {
+		Client CatalogClient = new CatalogClient().getClient();
+		if (searchText.length() == 0) {
+			snapdealItems = CatalogClient.getSnapdealItems(Long.valueOf(next), 10);
+			totalCount = CatalogClient.getCountForSnapdealItems();
+			setSearchCount(totalCount);
+		} else {
+			List<String> subString = Arrays.asList(searchText.split(" "));
+			snapdealItems = CatalogClient.searchSnapdealItems(subString,Long.valueOf(next), 10);
+			totalCount = CatalogClient.getCountForSnapdealItems();
+			searchCount = CatalogClient.getSnapdealSearchResultCount(subString);
+		}
+		return "snapdeal-item-table";
+	}
 	public String uploadBulkSheet(){
 		if(!ReportsUtils.canAccessReport((Long)session.getAttribute(ReportsUtils.ROLE), request.getRequestURI().substring(request.getContextPath().length()).split("/")[1].split("!")[0])) {
 			logger.info(request.getRequestURI().substring(request.getContextPath().length()).split("/")[1].split("!")[0]);
 			return "authfail";
+		}
 		return "snapdeal-bulk-upload";
+	}
 	public void downloadSnapdealListings() throws IOException, TException{
 		File file = new File("/tmp/snapdeal-bulk-upload-template.xls");
 		HSSFWorkbook hwb=new HSSFWorkbook();
 		HSSFSheet sheet =  hwb.createSheet("Snapdeal-Listings");
 		HSSFRow rowhead=   sheet.createRow((short)0);
 		rowhead.createCell((short) 0).setCellValue("ITEM-ID");
 		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("COURIER-COST");
+		rowhead.createCell((short) 7).setCellValue("COMMISION");
+		rowhead.createCell((short) 8).setCellValue("SERVICE-TAX");
 		CatalogClient catalogServiceClient = null;
-		List<SnapdealItem> snapdealItems = null;
+		List<SnapdealItemDetails> snapdealItems = null;
 		try {
-			//catalogServiceClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port");
 			catalogServiceClient = new CatalogClient();
 			in.shop2020.model.v1.catalog.CatalogService.Client catalogClient= catalogServiceClient.getClient();
 			snapdealItems = catalogClient.getAllSnapdealItems();
 		} catch (Exception e) {
-			// TODO Auto-generated catch block
 			e.printStackTrace();
+		}
 		int iterator=1;
-		for(SnapdealItem snapdealItem:snapdealItems){
+		for(SnapdealItemDetails snapdealItem:snapdealItems){
 			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());
 			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) 5).setCellValue(snapdealItem.getSellingPrice());
+			rowhead.createCell((short) 6).setCellValue(snapdealItem.getCourierCost());
+			rowhead.createCell((short) 7).setCellValue(snapdealItem.getCommission());
+			rowhead.createCell((short) 8).setCellValue(snapdealItem.getServiceTax());
 			iterator++;
+		}
 		FileOutputStream fileOut = null;
 		try {
 			fileOut = new FileOutputStream(file);
 		} catch (FileNotFoundException e) {
 			// TODO Auto-generated catch block
 			sos.flush();
 		} catch (IOException e) {
 			System.out.println("Unable to stream the manifest file");
+		}
+	}
 	public void uploadsnapdealBulkSheet() throws IOException, TException{
 		File fileToCreate = new File("/tmp/", "Snapdeal-bulk-upload.xls");
 		FileUtils.copyFile(this.file, fileToCreate);
 		HSSFWorkbook workbook = new HSSFWorkbook(iFile);
 		HSSFSheet sheet = workbook.getSheetAt(0);
 		Client catalogClient=null;
 		StringBuilder sb = new StringBuilder();
 		try {
-			//catalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
 			catalogClient = new CatalogClient().getClient();
 		} catch (TTransportException e) {
-			// TODO Auto-generated catch block
 			e.printStackTrace();
+		}
 		for (int iterator=(sheet.getFirstRowNum()+1);iterator<=sheet.getLastRowNum();iterator++){
 			SnapdealItem snapdealItem =null;
+			Item item = null;
 			Long sku;
 			if (checkEmptyString(sheet.getRow(iterator).getCell(0))){
 				continue;
+			}
 			else {
 				sku=(long) sheet.getRow(iterator).getCell(0).getNumericCellValue();
 				snapdealItem = catalogClient.getSnapdealItem(sku);
+				try {
+					item = catalogClient.getItem(sku);
+				} catch (CatalogServiceException e) {
+					sb.append(sku + " Item not Present"+"\n");
+				}
 				if(snapdealItem.getItem_id()==0){
 					snapdealItem = new SnapdealItem();
 					snapdealItem.setItem_id(sku);
+				}
+			}
 			if (!checkEmptyString(sheet.getRow(iterator).getCell(1))){
 				long warehouseId = (long) sheet.getRow(iterator).getCell(1).getNumericCellValue();
 				snapdealItem.setWarehouseId(warehouseId);
+			}
+				}
 				if ((long)sheet.getRow(iterator).getCell(3).getNumericCellValue()==0){
 					snapdealItem.setIsListedOnSnapdeal(false);
+				}
+			}
+			double transferPrice = 0,sellingPrice,commission,courierCost =45,serviceTax;
+			if (!checkEmptyString(sheet.getRow(iterator).getCell(4))){
+				transferPrice = sheet.getRow(iterator).getCell(4).getNumericCellValue();
+				if(transferPrice==0){
+					sb.append(sku + " Transfer Price cannot be zero"+"\n");
+					continue;
+				}
+				snapdealItem.setTransferPrice(transferPrice);
+			}
+			double weight = item.getWeight();
+			if(weight==0){
+				sb.append(sku + " Please add weight"+"\n");
+				continue;
+			}
+			int slabs = (int) (weight/.5);
+			for(int i=0;i<slabs;i++){
+				courierCost = courierCost + 35;
+			}
+			snapdealItem.setCourierCost(courierCost);
+			sellingPrice = ((transferPrice + courierCost*1.1236)/(100 - 3.59*1.1236))*100;
+			snapdealItem.setSellingPrice(sellingPrice);
+			double commision_value = .0359*sellingPrice + courierCost;
+			commission = ((.0359*sellingPrice + courierCost)/sellingPrice)*100;
+			snapdealItem.setCommission(commission);
+			serviceTax = (commision_value * .1236);
+			snapdealItem.setServiceTax(serviceTax);
 			if(!catalogClient.addOrUpdateSnapdealItem(snapdealItem)){
 				sb.append(sku + "\n");
+			}
+		}
 		//logger.info("Amazon Bulk Map "+amazonBulkUpdate.toString());
+		}
 		if (StringUtils.equals(id, "snapdeal-options")){
 			return "snapdeal-options";
+		}
+		if (StringUtils.equals(id, "item-table")){
+			return "snapdeal-item-table";
+		}
 		return "id";
+	}
 	public void setId(String id) {
+	}
 	public void setServletResponse(HttpServletResponse response) {
 		this.response = response;
+	}
+	public void setSearchText(String searchText) {
+		this.searchText = searchText;
+	}
+	public String getSearchText() {
+		return searchText;
+	}
+	public long getSearchCount() {
+		return searchCount;
+	}
+	public long getTotalCount() {
+		return totalCount;
+	}
+	public void setSearchCount(long count) {
+		this.searchCount = count;
+	}
+}

Subversion Repositories SmartDukaan

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