Subversion Repositories SmartDukaan

Rev

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

Rev 23088 Rev 23089
Line 203... Line 203...
203 
 
 203 
 
204 
		Workbook workbook = new HSSFWorkbook(inputStream);
 204 
		Workbook workbook = new HSSFWorkbook(inputStream);
205 
		Sheet firstSheet = workbook.getSheetAt(0);
 205 
		Sheet firstSheet = workbook.getSheetAt(0);
206
206
207 
		Iterator<Row> iterator = firstSheet.iterator();
 207 
		Iterator<Row> iterator = firstSheet.iterator();
208 
		List<String> imeis = new ArrayList<String>();
 208 
		Set<String> imeisSet = new HashSet<String>();
209 
		// Ignore first row as it is header
 209 
		// Ignore first row as it is header
210 
		if (iterator.hasNext()) {
 210 
		if (iterator.hasNext()) {
211 
			iterator.next();
 211 
			iterator.next();
212 
		}
 212 
		}
213 
		while (iterator.hasNext()) {
 213 
		while (iterator.hasNext()) {
Line 216... Line 216...
216 
			String imei = String.valueOf((long)(nextRow.getCell(0).getNumericCellValue()));
 216 
			String imei = String.valueOf((long)(nextRow.getCell(0).getNumericCellValue()));
217 
			if (imei.length() < 15) {
 217 
			if (imei.length() < 15) {
218 
				addActionError("IMEI size should be of 15 digit - " + imei);
 218 
				addActionError("IMEI size should be of 15 digit - " + imei);
219 
				return INDEX;
 219 
				return INDEX;
220 
			}
 220 
			}
- 
 
 221 
			imeisSet.add(imei);
221 
		}
 222 
		}
222 
		// Check if all imeis belong to specified item
 223 
		// Check if all imeis belong to specified item
223 
		wc = new WarehouseClient();
 224 
		wc = new WarehouseClient();
224 
		wClient = wc.getClient();
 225 
		wClient = wc.getClient();
- 
 
 226 
		List<String> imeisList= new ArrayList<String>(imeisSet);
225 
		if (imeis.size() > 0) {
 227 
		if (imeisSet.size() > 0) {
226 
			List<InventoryItem> inventoryItems = wClient.getInventoryItems(imeis);
 228 
			List<InventoryItem> inventoryItems = wClient.getInventoryItems(imeisList);
227 
			Map<String, InventoryItem> inventoryItemMap = new HashMap<String, InventoryItem>();
 229 
			Map<String, InventoryItem> inventoryItemMap = new HashMap<String, InventoryItem>();
228
230
229 
			for(InventoryItem inventoryItem : inventoryItems) {
 231 
			for(InventoryItem inventoryItem : inventoryItems) {
230 
				inventoryItemMap.put(inventoryItem.getSerialNumber(), inventoryItem);
 232 
				inventoryItemMap.put(inventoryItem.getSerialNumber(), inventoryItem);
231 
			}
 233 
			}
232 
			if(inventoryItems.size() != imeis.size()) {
 234 
			if(inventoryItems.size() != imeisSet.size()) {
233 
				addActionError("Few IMEIs are missing");
 235 
				addActionError("Few IMEIs are missing");
234 
				for (String imei : imeis) {
 236 
				for (String imei : imeisSet) {
235 
					if(!inventoryItemMap.containsKey(imei)) {
 237 
					if(!inventoryItemMap.containsKey(imei)) {
236 
						addActionError(imei);
 238 
						addActionError(imei);
237 
					}
 239 
					}
238 
				}
 240 
				}
239 
			}
 241 
			}
Line 244... Line 246...
244 
				}
 246 
				}
245 
			}
 247 
			}
246
248
247 
			tsc = new TransactionClient();
 249 
			tsc = new TransactionClient();
248 
			tClient = tsc.getClient();
 250 
			tClient = tsc.getClient();
249 
			tClient.addPriceDrop(itemId, imeis, this.priceDrop, affectedDateLong);
 251 
			tClient.addPriceDrop(itemId, imeisList, this.priceDrop, affectedDateLong);
250
252
251 
		} else {
 253 
		} else {
252 
			addActionError("Serial numbers should not be empty");
 254 
			addActionError("Serial numbers should not be empty");
253 
		}
 255 
		}
254
256