Subversion Repositories SmartDukaan

Rev

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

Rev 8291 Rev 8303
Line 130... Line 130...
130 
        Workbook wb = null;
 130 
        Workbook wb = null;
131 
        try {
 131 
        try {
132 
            wb = new HSSFWorkbook(new FileInputStream(fileToCreate));
 132 
            wb = new HSSFWorkbook(new FileInputStream(fileToCreate));
133 
        } catch (Exception e) {
 133 
        } catch (Exception e) {
134 
            logger.error("Unable to open the File for Order Creation for Ebay ", e);
 134 
            logger.error("Unable to open the File for Order Creation for Ebay ", e);
- 
 
 135 
            setErrorMsg(getErrorMsg() + "Error in opening File for Order creation");
135 
            addActionError("Unable to open the File for Order creation");
 136 
            addActionError("Unable to open the File for Order creation");
136 
        }
 137 
        }
137 
        if(checkForErrors())
 138 
        if(checkForErrors())
138 
            return "authsuccess";
 139 
            return "authsuccess";
139
140
Line 143... Line 144...
143 
        try {
 144 
        try {
144 
            tsc = new TransactionClient();
 145 
            tsc = new TransactionClient();
145 
			sourceDetail = tsc.getClient().getSourceDetail(EBAY_SOURCE_ID);
 146 
			sourceDetail = tsc.getClient().getSourceDetail(EBAY_SOURCE_ID);
146 
        } catch (Exception e) {
 147 
        } catch (Exception e) {
147 
            logger.error("Unable to establish connection to the transaction service", e);
 148 
            logger.error("Unable to establish connection to the transaction service", e);
- 
 
 149 
            setErrorMsg(getErrorMsg() + "Error in Order Service while getting Ebay Source Detail");
148 
            addActionError("Unable to establish connection to the transaction service");
 150 
            addActionError("Error in Order Service");
149 
		}
 151 
		}
150
152
151 
        if(checkForErrors())
 153 
        if(checkForErrors())
152 
            return "authsuccess";
 154 
            return "authsuccess";
153
155
154 
	    try {
156 
	    try {
155 
	        in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
 157 
	        in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
156 
	        user = userClient.getUserByEmail(sourceDetail.getEmail());
 158 
	        user = userClient.getUserByEmail(sourceDetail.getEmail());
157 
	    } catch (Exception e) {
 159 
	    } catch (Exception e) {
158 
	        logger.error("Unable to establish connection to the User service", e);
 160 
	        logger.error("Unable to establish connection to the User service", e);
- 
 
 161 
	        setErrorMsg(getErrorMsg() + "Unable to get Default Email for Ebay ");
159 
	        addActionError("Unable to establish connection to the User service");
 162 
	        addActionError("Unable to get Default Email for Ebay ");
160 
		}
 163 
		}
161 
 
 164 
 
162 
        if (user == null) {
 - 
 
163 
            addActionError("Could not find default user for Ebay: ");
 - 
 
164 
        }
 - 
 
165 
 
 - 
 
166 
        if(checkForErrors())
 165 
        if(checkForErrors())
167 
            return "authsuccess";
 166 
            return "authsuccess";
168
167
169 
        Sheet sheet = wb.getSheetAt(0);
 168 
        Sheet sheet = wb.getSheetAt(0);
170 
        Row firstRow = sheet.getRow(0);
 169 
        Row firstRow = sheet.getRow(0);
171 
        logger.info("Last row number is:" + sheet.getLastRowNum());
 - 
 
172 
        for (Row row : sheet) {
 170 
        for (Row row : sheet) {
173 
        	long orderCountForRow = 0;
 171 
        	long orderCountForRow = 0;
- 
 
 172 
        	rowId++;
174 
            if(row.equals(firstRow))
 173 
            if(row.equals(firstRow))
175 
                continue;
 174 
                continue;
176 
            rowId++;
 - 
 
177 
            Transaction txn = new Transaction();
 - 
 
178 
            txn.setShoppingCartid(user.getActiveCartId());
 - 
 
179 
            txn.setCustomer_id(user.getUserId());
 - 
 
180 
            txn.setCreatedOn(new Date().getTime());
 - 
 
181 
            txn.setTransactionStatus(TransactionStatus.INIT);
 - 
 
182 
            txn.setStatusDescription("Order for Ebay ");
 - 
 
183
- 
 
184 
            List<Order> orders = new ArrayList<Order>();
 - 
 
185
- 
 
186 
            row.getCell(EBAY_LISTINGID_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 - 
 
187 
            String ebayListingId = row.getCell(EBAY_LISTINGID_INDEX).getStringCellValue();
 - 
 
188 
    		CatalogService.Client catalogClient = new CatalogClient().getClient();
 - 
 
189 
    		EbayItem ebayItem = catalogClient.getEbayItem(ebayListingId);
 - 
 
190 
    		double listingPrice = 0;
 - 
 
191 
    		double overriddenPrice = 0;
 - 
 
192 
    		double totalPrice = 0;
 - 
 
193 
    		Cell overriddenPriceCell = row.getCell(LISTING_PRICE_INDEX);
 - 
 
194 
        	if(overriddenPriceCell  != null && overriddenPriceCell .getCellType() != Cell.CELL_TYPE_BLANK) {
 - 
 
195 
        		overriddenPrice = row.getCell(LISTING_PRICE_INDEX).getNumericCellValue();
 - 
 
196 
        	}
 - 
 
197
- 
 
198 
    		long quantity = new Double(row.getCell(QUANTITY_INDEX).getNumericCellValue()).longValue();
 - 
 
199 
    		String totalPriceString = row.getCell(AMOUNT_INDEX).getStringCellValue();
 - 
 
200 
    		if(overriddenPrice>=1) {
 - 
 
201 
    			totalPrice = overriddenPrice*quantity;
 - 
 
202 
    			listingPrice = (Double.parseDouble(totalPriceString.substring(3).replace(",","")))/quantity;
 - 
 
203 
    		} else {
 - 
 
204 
    			totalPrice = Double.parseDouble(totalPriceString.substring(3).replace(",",""));
 - 
 
205 
    			listingPrice = totalPrice/quantity;
 - 
 
206 
    		}
 - 
 
207
- 
 
208 
        	LineItem lineItem = null;
 - 
 
209 
        	try {
 175 
        	try {
- 
 
 176 
	            Transaction txn = new Transaction();
- 
 
 177 
	            txn.setShoppingCartid(user.getActiveCartId());
- 
 
 178 
	            txn.setCustomer_id(user.getUserId());
- 
 
 179 
	            txn.setCreatedOn(new Date().getTime());
- 
 
 180 
	            txn.setTransactionStatus(TransactionStatus.INIT);
- 
 
 181 
	            txn.setStatusDescription("Order for Ebay ");
- 
 
 182
- 
 
 183 
	            List<Order> orders = new ArrayList<Order>();
- 
 
 184
- 
 
 185 
	            row.getCell(EBAY_LISTINGID_INDEX).setCellType(Cell.CELL_TYPE_STRING);
- 
 
 186 
	            String ebayListingId = row.getCell(EBAY_LISTINGID_INDEX).getStringCellValue();
- 
 
 187 
	    		CatalogService.Client catalogClient = new CatalogClient().getClient();
- 
 
 188 
	    		EbayItem ebayItem = catalogClient.getEbayItem(ebayListingId);
- 
 
 189 
	    		double listingPrice = 0;
- 
 
 190 
	    		double overriddenPrice = 0;
- 
 
 191 
	    		double totalPrice = 0;
- 
 
 192 
	    		Cell overriddenPriceCell = row.getCell(LISTING_PRICE_INDEX);
- 
 
 193 
	        	if(overriddenPriceCell  != null && overriddenPriceCell .getCellType() != Cell.CELL_TYPE_BLANK) {
- 
 
 194 
	        		overriddenPrice = row.getCell(LISTING_PRICE_INDEX).getNumericCellValue();
- 
 
 195 
	        	}
- 
 
 196
- 
 
 197 
	    		long quantity = new Double(row.getCell(QUANTITY_INDEX).getNumericCellValue()).longValue();
- 
 
 198 
	    		String totalPriceString = row.getCell(AMOUNT_INDEX).getStringCellValue();
- 
 
 199 
	    		if(overriddenPrice>=1) {
- 
 
 200 
	    			totalPrice = overriddenPrice*quantity;
- 
 
 201 
	    			listingPrice = (Double.parseDouble(totalPriceString.substring(3).replace(",","")))/quantity;
- 
 
 202 
	    		} else {
- 
 
 203 
	    			totalPrice = Double.parseDouble(totalPriceString.substring(3).replace(",",""));
- 
 
 204 
	    			listingPrice = totalPrice/quantity;
- 
 
 205 
	    		}
- 
 
 206
- 
 
 207 
	        	LineItem lineItem = null;
- 
 
 208 
	        	try {
210 
        		lineItem = createLineItem(ebayItem.getItemId(), quantity, totalPrice);
 209 
	        		lineItem = createLineItem(ebayItem.getItemId(), quantity, totalPrice);
211 
        	} catch (Exception tex) {
 210 
	        	} catch (Exception tex) {
212 
        		logger.error("Unable to create order for sales Rec Number " + row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue(), tex);
 211 
	        		logger.error("Unable to create order for sales Rec Number " + row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue(), tex);
- 
 
 212 
	        		setErrorMsg(getErrorMsg() + "<br>Unable to create lineitem using catalog info for RowId " + rowId);
213 
    	        addActionError("Unable to create order for sales Rec Number " + row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue());
 213 
	    	        addActionError("Unable to create order for sales Rec Number " + row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue());
- 
 
 214 
	    	        continue;
- 
 
 215 
	        	}
- 
 
 216 
	            Order t_order = new Order();
- 
 
 217 
	            t_order.setCustomer_id(user.getUserId());
- 
 
 218 
	            t_order.setCustomer_email(sourceDetail.getEmail());
- 
 
 219 
	        	t_order.setCustomer_name("Ebay");
- 
 
 220 
	            try {
- 
 
 221 
	            	row.getCell(CUST_MOBILE_INDEX).setCellType(Cell.CELL_TYPE_STRING);
- 
 
 222 
	            	t_order.setCustomer_mobilenumber(row.getCell(CUST_MOBILE_INDEX).getStringCellValue());
- 
 
 223 
	            } catch (Exception e) {
- 
 
 224 
	            	addActionError("Error in reading mobile Number for rowNumber " + row.getRowNum());
- 
 
 225 
	            	setErrorMsg(getErrorMsg() + "<br>Unable to create lineitem using catalog info for RowId " + rowId);
- 
 
 226 
	            	logger.error("Error in reading mobile Number for rowNumber " + row.getRowNum());
- 
 
 227 
	            }
- 
 
 228 
	            //t_order.setTotal_amount(lineItem.getTotal_price());
- 
 
 229 
	            t_order.setTotal_weight(lineItem.getTotal_weight());
- 
 
 230 
	            t_order.setLineitems(Collections.singletonList(lineItem));
- 
 
 231 
	            t_order.setStatus(OrderStatus.PAYMENT_PENDING);
- 
 
 232 
	            t_order.setStatusDescription("Payment Pending");
- 
 
 233 
	            t_order.setCreated_timestamp(new Date().getTime());
- 
 
 234 
	            t_order.setCod(false);
- 
 
 235 
	            try {
- 
 
 236 
	            	Date shippingDate = interchangeDateAndMonth(row.getCell(SHIP_DATE_INDEX).getDateCellValue());
- 
 
 237 
	            	t_order.setPromised_shipping_time(shippingDate.getTime());
- 
 
 238 
	            	t_order.setExpected_shipping_time(shippingDate.getTime());
- 
 
 239 
	            	/*t_order.setPromised_shipping_time(sdf.parse(row.getCell(SHIP_DATE_INDEX).getStringCellValue()).getTime());
- 
 
 240 
	            	t_order.setExpected_shipping_time(sdf.parse(row.getCell(SHIP_DATE_INDEX).getStringCellValue()).getTime());*/
- 
 
 241 
	            	Calendar time = Calendar.getInstance();
- 
 
 242 
	            	time.setTimeInMillis(t_order.getExpected_shipping_time());
- 
 
 243 
	            	time.add(Calendar.DAY_OF_MONTH, 3);
- 
 
 244 
	            	t_order.setPromised_delivery_time(time.getTimeInMillis());
- 
 
 245 
	            	t_order.setExpected_delivery_time(time.getTimeInMillis());
- 
 
 246 
	            } catch(Exception e) {
- 
 
 247 
	            	addActionError("Error in updating Shipping Time for row number " + rowId);
- 
 
 248 
	            	logger.error("Error in updating Shipping Time for row number " + rowId,e);
- 
 
 249 
	            }
- 
 
 250
- 
 
 251 
	            //TODO Delivery time
- 
 
 252 
	            InventoryService.Client inventoryClient = null;
- 
 
 253 
	            Warehouse fulfillmentWarehouse= null;
- 
 
 254 
	            try {
- 
 
 255 
	            	inventoryClient = new InventoryClient().getClient();
- 
 
 256 
	            	Cell warehouseCell = row.getCell(WAREHOUSE_ID_INDEX);
- 
 
 257 
	            	if(warehouseCell != null && warehouseCell.getCellType() != Cell.CELL_TYPE_BLANK) {
- 
 
 258 
	            		fulfillmentWarehouse = inventoryClient.getWarehouse(new Double(row.getCell(WAREHOUSE_ID_INDEX).getNumericCellValue()).longValue());
- 
 
 259
- 
 
 260 
	            	} else if (ebayItem.getDefaultWarehouseId()!=0 ){
- 
 
 261 
	            		fulfillmentWarehouse = inventoryClient.getWarehouse(ebayItem.getDefaultWarehouseId());
- 
 
 262 
	            	} else {
- 
 
 263 
	            		List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(ebayItem.getItemId(), 1);
- 
 
 264 
	            		fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
- 
 
 265 
	            	}
- 
 
 266 
	            	t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
- 
 
 267 
	        		t_order.setWarehouse_id(fulfillmentWarehouse.getBillingWarehouseId());
- 
 
 268
- 
 
 269 
	        		VendorItemPricing vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
- 
 
 270 
	        		t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
- 
 
 271 
	        		t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
- 
 
 272 
				} catch (InventoryServiceException e) {
- 
 
 273 
					addActionError("Error in updating WarehouseId for row number " + rowId);
- 
 
 274 
					setErrorMsg(getErrorMsg() + "<br>Error in updating WarehouseId for row number  " + rowId);
- 
 
 275 
	            	logger.error("Error in updating WarehouseId for row number " + rowId,e);
214 
    	        return "authsuccess";
 276 
	            	return "authsuccess";
- 
 
 277 
				}
- 
 
 278
- 
 
 279 
				String provider = row.getCell(COURIER_INDEX).getStringCellValue();
- 
 
 280 
				if(provider.equals(bluedart)) {
- 
 
 281 
					t_order.setLogistics_provider_id(8);
- 
 
 282 
				} else if(provider.equals(aramex)) {
- 
 
 283 
					t_order.setLogistics_provider_id(9);
- 
 
 284 
				} else if(provider.equals(dtdc)) {
- 
 
 285 
					t_order.setLogistics_provider_id(10);
- 
 
 286 
				} else if(provider.equals(fedex)) {
- 
 
 287 
					t_order.setLogistics_provider_id(11);
- 
 
 288 
				} else {
- 
 
 289 
					//TODO Continue and proceed with next row
- 
 
 290 
				}
- 
 
 291
- 
 
 292 
				row.getCell(AWB_INDEX).setCellType(Cell.CELL_TYPE_STRING);
- 
 
 293 
				t_order.setAirwaybill_no(row.getCell(AWB_INDEX).getStringCellValue());
- 
 
 294 
				t_order.setTracking_id(row.getCell(AWB_INDEX).getStringCellValue());
- 
 
 295 
	            t_order.setTotal_amount(totalPrice);
- 
 
 296 
	            t_order.setOrderType(OrderType.B2C);
- 
 
 297 
	            t_order.setSource(EBAY_SOURCE_ID);
- 
 
 298 
	            orders.add(t_order);
- 
 
 299 
	            orderCountForRow++;
- 
 
 300
- 
 
 301 
	            txn.setOrders(orders);
- 
 
 302 
	            Client transaction_client = new TransactionClient().getClient();
- 
 
 303 
	            try {
- 
 
 304 
	            	long salesRecNumber = new Double(row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue()).longValue();
- 
 
 305 
	            	if(transaction_client.ebayOrderExists(salesRecNumber, ebayItem.getEbayListingId())) {
- 
 
 306 
	            		setErrorMsg(getErrorMsg() + "<br>Duplicate order for salesRecNumber " + salesRecNumber + " and listingId " + ebayItem.getEbayListingId() + " for row number  " + rowId);
- 
 
 307 
	            		logger.error("Duplicate order for salesRecNumber " + salesRecNumber + " and listingId " + ebayItem.getEbayListingId());
- 
 
 308 
	            	}
- 
 
 309
- 
 
 310 
	            	transactionId =  String.valueOf(transaction_client.createTransaction(txn));
- 
 
 311 
	            	row.getCell(PAISAPAY_ID_INDEX).setCellType(Cell.CELL_TYPE_STRING);
- 
 
 312 
	            	String paisaPayId = row.getCell(PAISAPAY_ID_INDEX).getStringCellValue();
- 
 
 313 
	            	createPayment(user, paisaPayId, totalPrice);
- 
 
 314
- 
 
 315 
	                logger.info("Successfully created transaction: " + transactionId + " for amount: " + totalPrice);
- 
 
 316
- 
 
 317 
	                Transaction transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
- 
 
 318 
	                Order order = transaction.getOrders().get(0);
- 
 
 319
- 
 
 320 
	                inventoryClient.reserveItemInWarehouse(ebayItem.getItemId(), fulfillmentWarehouse.getId(), 1,
- 
 
 321 
	                		order.getId(), order.getCreated_timestamp(), order.getPromised_shipping_time(), order.getLineitems().get(0).getQuantity());
- 
 
 322
- 
 
 323 
	                EbayOrder ebayOrder = new EbayOrder();
- 
 
 324 
	                ebayOrder.setEbayListingId(ebayItem.getEbayListingId());
- 
 
 325 
	                ebayOrder.setSalesRecordNumber(new Double(row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue()).longValue());
- 
 
 326 
	                try {
- 
 
 327 
	                	Date ebayTransactionDate = interchangeDateAndMonth(row.getCell(TRANSACTION_DATE_INDEX).getDateCellValue());
- 
 
 328 
	                	ebayOrder.setEbayTxnDate(ebayTransactionDate.getTime());
- 
 
 329 
	                } catch (Exception e) {
- 
 
 330 
	                	logger.error("Error in setting transaction date for Ebay Order with OrderId : " + order.getId());
- 
 
 331 
	                }
- 
 
 332 
	                ebayOrder.setOrderId(order.getId());
- 
 
 333 
	                ebayOrder.setPaisaPayId(paisaPayId);
- 
 
 334 
	                ebayOrder.setListingName(ebayItem.getListingName());
- 
 
 335 
	                ebayOrder.setSubsidyAmount(ebayItem.getSubsidy()*quantity);
- 
 
 336 
	                ebayOrder.setListingPrice(listingPrice);
- 
 
 337 
	                transaction_client.createEbayOrder(ebayOrder);
- 
 
 338 
	            } catch (Exception e) {
- 
 
 339 
	                logger.error("Error while creating order for rowId " + rowId, e);
- 
 
 340 
	                addActionError("Error while creating order for rowId " + rowId);
- 
 
 341 
	                setErrorMsg(getErrorMsg() + "<br>Error while creating order for row number " + rowId);
- 
 
 342 
	                continue;
- 
 
 343 
	    		}
- 
 
 344 
        	} catch (Exception e) {
- 
 
 345 
        		logger.error("Error while creating order for row number " + rowId);
- 
 
 346 
        		setErrorMsg(getErrorMsg() + "<br>Error while creating order for row number " + rowId);
- 
 
 347 
        		continue;
215 
        	}
 348 
        	}
216 
            Order t_order = new Order();
 - 
 
217 
            t_order.setCustomer_id(user.getUserId());
 - 
 
218 
            t_order.setCustomer_email(sourceDetail.getEmail());
 - 
 
219 
        	t_order.setCustomer_name("Ebay");
 - 
 
220 
            try {
 - 
 
221 
            	row.getCell(CUST_MOBILE_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 - 
 
222 
            	t_order.setCustomer_mobilenumber(row.getCell(CUST_MOBILE_INDEX).getStringCellValue());
 - 
 
223 
            } catch (Exception e) {
 - 
 
224 
            	addActionError("Error in reading mobile Number for rowNumber " + row.getRowNum());
 - 
 
225 
            	logger.error("Error in reading mobile Number for rowNumber " + row.getRowNum());
 - 
 
226 
            }
- 
 
227 
            //t_order.setTotal_amount(lineItem.getTotal_price());
- 
 
228 
            t_order.setTotal_weight(lineItem.getTotal_weight());
 - 
 
229 
            t_order.setLineitems(Collections.singletonList(lineItem));
- 
 
230 
            t_order.setStatus(OrderStatus.PAYMENT_PENDING);
 - 
 
231 
            t_order.setStatusDescription("Payment Pending");
 - 
 
232 
            t_order.setCreated_timestamp(new Date().getTime());
 - 
 
233 
            try {
 - 
 
234 
            	Date shippingDate = interchangeDateAndMonth(row.getCell(SHIP_DATE_INDEX).getDateCellValue());
 - 
 
235 
            	t_order.setPromised_shipping_time(shippingDate.getTime());
 - 
 
236 
            	t_order.setExpected_shipping_time(shippingDate.getTime());
 - 
 
237 
            	/*t_order.setPromised_shipping_time(sdf.parse(row.getCell(SHIP_DATE_INDEX).getStringCellValue()).getTime());
 - 
 
238 
            	t_order.setExpected_shipping_time(sdf.parse(row.getCell(SHIP_DATE_INDEX).getStringCellValue()).getTime());*/
 - 
 
239 
            	Calendar time = Calendar.getInstance();
 - 
 
240 
            	time.setTimeInMillis(t_order.getExpected_shipping_time());
 - 
 
241 
            	time.add(Calendar.DAY_OF_MONTH, 3);
 - 
 
242 
            	t_order.setPromised_delivery_time(time.getTimeInMillis());
 - 
 
243 
            	t_order.setExpected_delivery_time(time.getTimeInMillis());
 - 
 
244 
            } catch(Exception e) {
 - 
 
245 
            	addActionError("Error in updating Shipping Time for row number " + (rowId + 1));
 - 
 
246 
            	logger.error("Error in updating Shipping Time for row number " + (rowId + 1),e);
 - 
 
247 
            }
 - 
 
248
- 
 
249 
            //TODO Delivery time
 - 
 
250 
            InventoryService.Client inventoryClient = null;
 - 
 
251 
            Warehouse fulfillmentWarehouse= null;
- 
 
252 
            try {
 - 
 
253 
            	inventoryClient = new InventoryClient().getClient();
 - 
 
254 
            	Cell warehouseCell = row.getCell(WAREHOUSE_ID_INDEX);
 - 
 
255 
            	if(warehouseCell != null && warehouseCell.getCellType() != Cell.CELL_TYPE_BLANK) {
- 
 
256 
            		fulfillmentWarehouse = inventoryClient.getWarehouse(new Double(row.getCell(WAREHOUSE_ID_INDEX).getNumericCellValue()).longValue());
 - 
 
257
- 
 
258 
            	} else if (ebayItem.getDefaultWarehouseId()!=0 ){
 - 
 
259 
            		fulfillmentWarehouse = inventoryClient.getWarehouse(ebayItem.getDefaultWarehouseId());
 - 
 
260 
            	} else {
 - 
 
261 
            		List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(ebayItem.getItemId(), 1);
 - 
 
262 
            		fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
 - 
 
263 
            	}
 - 
 
264 
            	t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
 - 
 
265 
        		t_order.setWarehouse_id(fulfillmentWarehouse.getBillingWarehouseId());
 - 
 
266
- 
 
267 
        		VendorItemPricing vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
 - 
 
268 
        		t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
 - 
 
269 
        		t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
 - 
 
270 
			} catch (InventoryServiceException e) {
 - 
 
271 
				addActionError("Error in updating WarehouseId for row number " + (rowId + 1));
 - 
 
272 
            	logger.error("Error in updating WarehouseId for row number " + (rowId + 1),e);
 - 
 
273 
            	return "authsuccess";
 - 
 
274 
			}
 - 
 
275
- 
 
276 
			String provider = row.getCell(COURIER_INDEX).getStringCellValue();
 - 
 
277 
			if(provider.equals(bluedart)) {
 - 
 
278 
				t_order.setLogistics_provider_id(8);
 - 
 
279 
			} else if(provider.equals(aramex)) {
 - 
 
280 
				t_order.setLogistics_provider_id(9);
 - 
 
281 
			} else if(provider.equals(dtdc)) {
 - 
 
282 
				t_order.setLogistics_provider_id(10);
 - 
 
283 
			} else if(provider.equals(fedex)) {
 - 
 
284 
				t_order.setLogistics_provider_id(11);
 - 
 
285 
			} else {
 - 
 
286 
				//TODO Continue and proceed with next row
 - 
 
287 
			}
 - 
 
288
- 
 
289 
			row.getCell(AWB_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 - 
 
290 
			t_order.setAirwaybill_no(row.getCell(AWB_INDEX).getStringCellValue());
 - 
 
291 
			t_order.setTracking_id(row.getCell(AWB_INDEX).getStringCellValue());
 - 
 
292 
            t_order.setTotal_amount(totalPrice);
 - 
 
293 
            t_order.setOrderType(OrderType.B2C);
 - 
 
294 
            t_order.setSource(EBAY_SOURCE_ID);
 - 
 
295 
            orders.add(t_order);
 - 
 
296 
            orderCountForRow++;
 - 
 
297
- 
 
298 
            txn.setOrders(orders);
 - 
 
299 
            Client transaction_client = new TransactionClient().getClient();
 - 
 
300 
            try {
 - 
 
301 
            	long salesRecNumber = new Double(row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue()).longValue();
 - 
 
302 
            	if(transaction_client.ebayOrderExists(salesRecNumber, ebayItem.getEbayListingId())) {
 - 
 
303 
            		throw new Exception("Duplicate order for salesRecNumber " + salesRecNumber + " and listingId " + ebayItem.getEbayListingId());
 - 
 
304 
            	}
 - 
 
305
- 
 
306 
            	transactionId =  String.valueOf(transaction_client.createTransaction(txn));
 - 
 
307 
            	row.getCell(PAISAPAY_ID_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 - 
 
308 
            	String paisaPayId = row.getCell(PAISAPAY_ID_INDEX).getStringCellValue();
 - 
 
309 
            	createPayment(user, paisaPayId, totalPrice);
 - 
 
310
- 
 
311 
            	/*in.shop2020.model.v1.order.Attribute orderAttribute = new in.shop2020.model.v1.order.Attribute();
 - 
 
312 
                orderAttribute.setName("tinNumber");
 - 
 
313 
                orderAttribute.setValue(sourceDetail.getTinNumber());
 - 
 
314
- 
 
315 
                if(!sourceDetail.getTinNumber().equals("") && !(sourceDetail.getTinNumber() == null)) {
 - 
 
316 
                	transaction_client.setOrderAttributeForTransaction(Long.parseLong(transactionId), orderAttribute);
 - 
 
317 
                }*/
 - 
 
318 
                //transaction_client.changeTransactionStatus(Long.valueOf(transactionId), TransactionStatus.AUTHORIZED, "Dummy Payment received for the order of Source " + sourceId, pickUpType, OrderType.findByValue(orderType.intValue()), OrderSource.findByValue(sourceId.intValue()));
 - 
 
319 
                //transaction_client.changeTransactionStatus(Long.valueOf(transactionId), TransactionStatus.IN_PROCESS, "Dummy RTGS Payment accepted for order of Source " + sourceId, pickUpType, OrderType.findByValue(orderType.intValue()), OrderSource.findByValue(sourceId.intValue()));
 - 
 
320 
                logger.info("Successfully created transaction: " + transactionId + " for amount: " + totalPrice);
 - 
 
321
- 
 
322 
                Transaction transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
 - 
 
323 
                Order order = transaction.getOrders().get(0);
 - 
 
324
- 
 
325 
                inventoryClient.reserveItemInWarehouse(ebayItem.getItemId(), fulfillmentWarehouse.getId(), 1,
- 
 
326 
                		order.getId(), order.getCreated_timestamp(), order.getPromised_shipping_time(), order.getLineitems().get(0).getQuantity());
 - 
 
327
- 
 
328 
                EbayOrder ebayOrder = new EbayOrder();
 - 
 
329 
                ebayOrder.setEbayListingId(ebayItem.getEbayListingId());
 - 
 
330 
                ebayOrder.setSalesRecordNumber(new Double(row.getCell(SALES_RECORD_NUM_INDEX).getNumericCellValue()).longValue());
 - 
 
331 
                try {
 - 
 
332 
//                	ebayOrder.setEbayTxnDate(sdf.parse(row.getCell(TRANSACTION_DATE_INDEX).getStringCellValue()).getTime());
 - 
 
333 
                	Date ebayTransactionDate = interchangeDateAndMonth(row.getCell(TRANSACTION_DATE_INDEX).getDateCellValue());
 - 
 
334 
                	ebayOrder.setEbayTxnDate(ebayTransactionDate.getTime());
 - 
 
335 
                } catch (Exception e) {
 - 
 
336 
                	logger.error("Error in setting transaction date for Ebay Order with OrderId : " + order.getId());
 - 
 
337 
                }
 - 
 
338 
                ebayOrder.setOrderId(order.getId());
 - 
 
339 
                ebayOrder.setPaisaPayId(paisaPayId);
 - 
 
340 
                ebayOrder.setListingName(ebayItem.getListingName());
 - 
 
341 
                ebayOrder.setSubsidyAmount(ebayItem.getSubsidy()*quantity);
 - 
 
342 
                ebayOrder.setListingPrice(listingPrice);
 - 
 
343 
                transaction_client.createEbayOrder(ebayOrder);
 - 
 
344 
            } catch (Exception e) {
 - 
 
345 
                logger.error("Unable to create order for rowId " + (rowId + 1), e);
 - 
 
346 
                addActionError("Unable to create order for rowId " + (rowId + 1));
 - 
 
347 
                return "authsuccess";
 - 
 
348 
    		}
 - 
 
349 
        }
 349 
        }
350
350
351 
        checkForErrors();
 351 
        checkForErrors();
352 
        return "authsuccess";
 352 
        return "authsuccess";
353 
    }
 353 
    }
Line 439... Line 439...
439 
 
 439 
 
440 
	public void setOrderDataFile(File orderDataFile) {
 440 
	public void setOrderDataFile(File orderDataFile) {
441 
		this.orderDataFile = orderDataFile;
 441 
		this.orderDataFile = orderDataFile;
442 
	}
 442 
	}
443
443
- 
 
 444
444 
 
 445 
 
445 
}
 446 
}