Subversion Repositories SmartDukaan

Rev

Rev 10515 | Rev 11673 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 10515 Rev 10772
Line 191... Line 191...
191 
			}
 191 
			}
192 
			else{
 192 
			else{
193 
				itemInventoryMap.put(row.getCell(6).getStringCellValue(),0L);
 193 
				itemInventoryMap.put(row.getCell(6).getStringCellValue(),0L);
194 
			}
 194 
			}
195 
		}
 195 
		}
- 
 
 196 
		get = new HttpGet("https://seller.flipkart.com/sellerListing/listing/downloadTemplateForExistingProducts?category=Computers+%26+Gaming&sellerId=m2z93iskuj81qiid&feedType=PRICING_STOCK&useDefaultTemplate=false");
- 
 
 197 
		response = client.execute(get);
- 
 
 198 
		in = response.getEntity().getContent();
- 
 
 199 
		wb = new HSSFWorkbook(in);
- 
 
 200 
		sheet = wb.getSheetAt(0);
- 
 
 201 
		firstRow = sheet.getRow(0);
- 
 
 202 
		SecondRow = sheet.getRow(1);
- 
 
 203 
		for (Row row : sheet) {
- 
 
 204 
			if(row.equals(firstRow) || row.equals(SecondRow))
- 
 
 205 
				continue;
- 
 
 206 
			row.getCell(6).setCellType(Cell.CELL_TYPE_STRING);
- 
 
 207 
			row.getCell(15).setCellType(Cell.CELL_TYPE_STRING);
- 
 
 208 
			System.out.println("SKU " + row.getCell(6).getStringCellValue() + " " + "Quantity "+ row.getCell(15).getStringCellValue());
- 
 
 209 
			if(!row.getCell(15).getStringCellValue().equals("")){
- 
 
 210 
				itemInventoryMap.put(row.getCell(6).getStringCellValue(), Long.parseLong(row.getCell(15).getStringCellValue()));
- 
 
 211 
			}
- 
 
 212 
			else{
- 
 
 213 
				itemInventoryMap.put(row.getCell(6).getStringCellValue(),0L);
- 
 
 214 
			}
- 
 
 215 
		}
196 
		return itemInventoryMap;
 216 
		return itemInventoryMap;
197 
	}
 217 
	}
198 
	static String getProductName(Item item){
 218 
	static String getProductName(Item item){
199 
		return getName(item.getBrand())+" " + getName(item.getModelName())+" " + getName(item.getModelNumber())+" " + getName(item.getColor());
219 
		return getName(item.getBrand())+" " + getName(item.getModelName())+" " + getName(item.getModelNumber())+" " + getName(item.getColor());
200 
 
 220