Subversion Repositories SmartDukaan

Rev

Rev 8715 | Rev 8740 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
8616 vikram.rag 1 
package in.shop2020;
2 
 
3 
import in.shop2020.model.v1.catalog.CatalogService;
8739 vikram.rag 4 
import in.shop2020.model.v1.catalog.SnapdealItem;
8616 vikram.rag 5 
import in.shop2020.model.v1.catalog.CatalogServiceException;
6 
import in.shop2020.model.v1.catalog.Item;
8739 vikram.rag 7 
import in.shop2020.model.v1.catalog.SnapdealItem;
8616 vikram.rag 8 
import in.shop2020.model.v1.inventory.InventoryService;
9 
import in.shop2020.model.v1.inventory.InventoryServiceException;
10 
import in.shop2020.model.v1.inventory.VendorItemPricing;
11 
import in.shop2020.model.v1.inventory.Warehouse;
12 
import in.shop2020.model.v1.order.LineItem;
13 
import in.shop2020.model.v1.order.OrderStatus;
14 
import in.shop2020.model.v1.order.OrderType;
15 
import in.shop2020.model.v1.order.SnapdealOrder;
16 
import in.shop2020.model.v1.order.SourceDetail;
17 
import in.shop2020.model.v1.order.Transaction;
8651 vikram.rag 18 
import in.shop2020.model.v1.order.TransactionServiceException;
8616 vikram.rag 19 
import in.shop2020.model.v1.order.TransactionStatus;
20 
import in.shop2020.model.v1.order.TransactionService.Client;
21 
import in.shop2020.model.v1.user.User;
22 
import in.shop2020.payments.PaymentException;
23 
import in.shop2020.payments.PaymentStatus;
24 
import in.shop2020.thrift.clients.CatalogClient;
25 
import in.shop2020.thrift.clients.InventoryClient;
26 
import in.shop2020.thrift.clients.PaymentClient;
27 
import in.shop2020.thrift.clients.TransactionClient;
28 
import in.shop2020.thrift.clients.UserClient;
29 
 
30 
import java.io.File;
8651 vikram.rag 31 
import java.text.ParseException;
8616 vikram.rag 32 
import java.text.SimpleDateFormat;
33 
import java.util.ArrayList;
34 
import java.util.Calendar;
35 
import java.util.Collections;
36 
import java.util.Date;
37 
import java.util.List;
38 
import java.util.TimeZone;
39 
 
40 
import javax.xml.bind.JAXBContext;
41 
import javax.xml.bind.JAXBException;
42 
import javax.xml.bind.Marshaller;
43 
import javax.xml.bind.Unmarshaller;
8739 vikram.rag 44 
 
45 
import org.apache.poi.ss.usermodel.Cell;
8616 vikram.rag 46 
import org.apache.thrift.TException;
47 
import org.apache.thrift.transport.TTransportException;
8645 vikram.rag 48 
import org.slf4j.Logger;
49 
import org.slf4j.LoggerFactory;
8616 vikram.rag 50 
 
51 
import order.SaholicAPI;
52 
import order.ObjectFactory;
53 
import order.SaholicAPI.Order;
54 
 
55 
public class ProcessSnapdealOrder {
56 
	private static final int SNAPDEAL_SOURCE_ID = 7;
57 
	private static final String FIRSTFLIGHT = "First Flight";
8627 vikram.rag 58 
	private static final String DELHIVERY = "DELHIVERY";
59 
	private static final String BLUEDART = "Bluedart";
8715 vikram.rag 60 
	private static final String CHHOTU = "CHHOTU";
61 
	private static final String LAST_MILE = "LAST_MILE";
62 
	private static final String  ECOMM_EXP = "ECOMM_EXP";
63 
	private static final String  EWINGS = "EWINGS";
64 
	private static final String DTDC = "DTDC";
65 
	private static final String WAREOLOG = "DTDC";
66 
	private static final String  MIRAKLE = "MIRAKLE";
67 
	private static final String RAJIV_TRANSPORT = "RAJIV_TRANSPORT";
68 
	private static final String BLUEDART_HIGH_VALUE = "BLUEDART_HIGH_VALUE";
69 
	private static final String BLUEDART_SURFACE = "BLUEDART_SURFACE";
70 
	private static final String BLUEDART_APEX = "BLUEDART_APEX";
71 
	private static final String ARAMEX = "ARAMEX";
72 
	private static final String GATI = "GATI";
73 
	private static final String INDIA_POST = "INDIA_POST";
74 
	private static final String FEDEX = "FEDEX";
75 
	private static final String IOT = "IOT";
76 
	private static final String RED_EXP = "RED_EXP";
77 
	private static final String GHARPAY = "GHARPAY";
78 
	private static final String QUANTIUM = "QUANTIUM";
79 
	private static final String GATI_AIR = "GATI_AIR`";
80 
	private static final String VDELIVER = "VDELIVER";
8627 vikram.rag 81 
	private static String transactionId;
82 
	private static final int SNAPDEAL_GATEWAY_ID = 18;
8646 vikram.rag 83 
	private static Logger logger;
8627 vikram.rag 84 
 
8616 vikram.rag 85 
	public static void processSnapdealOrders(File file) throws JAXBException{
8646 vikram.rag 86 
		logger = LoggerFactory.getLogger(ProcessSnapdealOrder.class);
8616 vikram.rag 87 
		JAXBContext jc = JAXBContext.newInstance(SaholicAPI.class);
88 
		Unmarshaller unmarshaller = jc.createUnmarshaller();
89 
		SaholicAPI orders = (SaholicAPI) unmarshaller.unmarshal(file);
90 
		Marshaller marshaller = jc.createMarshaller();
91 
		marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
92 
		marshaller.marshal(orders, System.out);
93 
		SourceDetail sourceDetail = null;
94 
		User user = null;
95 
		TransactionClient tsc = null;
96 
		try {
97 
			tsc = new TransactionClient();
98 
			sourceDetail = tsc.getClient().getSourceDetail(SNAPDEAL_SOURCE_ID);
99 
		} catch (Exception e) {
8645 vikram.rag 100 
			logger.error("Unable to establish connection to the transaction service while getting Snapdeal Source Detail", e);
8616 vikram.rag 101 
		}
102 
		try {
103 
			in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
104 
			user = userClient.getUserByEmail(sourceDetail.getEmail());
105 
		} catch (Exception e) {
8649 vikram.rag 106 
			logger.error("Unable to establish connection to the User service", e);
8616 vikram.rag 107 
		}
108 
		for(Order order:orders.getOrder()){
8627 vikram.rag 109 
			long subOrderId = (long) order.getSuborderId();
110 
			Client transaction_client = null;
111 
			try {
112 
				transaction_client = new TransactionClient().getClient();
113 
				System.out.println("Suborder id " + subOrderId);
114 
				if(transaction_client.snapdealOrderExists(subOrderId)) {
8739 vikram.rag 115 
					logger.error("Snapdeal suborder id exists " + subOrderId);
8627 vikram.rag 116 
					System.out.println("Suborder id exists");
117 
					continue;
118 
				}
119 
 
120 
			} catch (TTransportException e1) {
121 
				// TODO Auto-generated catch block
122 
				e1.printStackTrace();
123 
			} catch (TException e) {
124 
				// TODO Auto-generated catch block
125 
				e.printStackTrace();
126 
			}
8739 vikram.rag 127 
			//System.out.println("Inside Order Parsing");
8616 vikram.rag 128 
			Transaction txn = new Transaction();
8739 vikram.rag 129 
			//System.out.println("User details are " + user.getActiveCartId());
8616 vikram.rag 130 
			txn.setShoppingCartid(user.getActiveCartId());
8739 vikram.rag 131 
			//System.out.println("creating transaction");
8616 vikram.rag 132 
			txn.setCustomer_id(user.getUserId());
8627 vikram.rag 133 
			System.out.println("User Id is " + user.getUserId());
8616 vikram.rag 134 
			txn.setCreatedOn(new Date().getTime());
135 
			txn.setTransactionStatus(TransactionStatus.INIT);
136 
			txn.setStatusDescription("Order for Snapdeal ");
137 
			List<in.shop2020.model.v1.order.Order> orderlist = new ArrayList<in.shop2020.model.v1.order.Order>();
138 
			LineItem lineItem = null;
8739 vikram.rag 139 
			CatalogService.Client catalogClient = null;
140 
			SnapdealItem snapdealItem = null;
141 
			double SellingPrice = 0;
8616 vikram.rag 142 
			try {
8739 vikram.rag 143 
				catalogClient =  new CatalogClient().getClient();
144 
				snapdealItem = catalogClient.getSnapdealItem(order.getSKUCode());
145 
				if(order.getSellingPricePerItem() <  snapdealItem.getExceptionPrice()){
146 
					SellingPrice = snapdealItem.getExceptionPrice();
147 
				}
148 
				else{
149 
					SellingPrice = order.getSellingPricePerItem();
150 
				}
151 
				lineItem = createLineItem(order.getSKUCode(),SellingPrice);
8627 vikram.rag 152 
				System.out.println("Line item created");
8616 vikram.rag 153 
			} catch (CatalogServiceException e) {
8645 vikram.rag 154 
				logger.error("Unable to create order for suborderid  " + order.getSuborderId());
8616 vikram.rag 155 
				e.printStackTrace();
156 
			} catch (TException e) {
8645 vikram.rag 157 
				logger.error("Unable to create order for suborderid  " + order.getSuborderId());
8616 vikram.rag 158 
				e.printStackTrace();
159 
			}
160 
			in.shop2020.model.v1.order.Order t_order = new in.shop2020.model.v1.order.Order();
8627 vikram.rag 161 
			t_order.setCustomer_id(user.getUserId());
162 
			t_order.setCustomer_email(sourceDetail.getEmail());
163 
			t_order.setCustomer_name(order.getCustomerName());
164 
			t_order.setCustomer_address1("");
165 
			t_order.setCustomer_address2("");
166 
			t_order.setCustomer_city(order.getCity());
167 
			t_order.setCustomer_state(order.getState());
168 
			t_order.setCustomer_pincode(String.valueOf(order.getPINCode()));
169 
			t_order.setTotal_amount(lineItem.getTotal_price());
170 
			t_order.setTotal_weight(lineItem.getTotal_weight());
171 
			t_order.setLineitems(Collections.singletonList(lineItem));
172 
			t_order.setStatus(OrderStatus.SUBMITTED_FOR_PROCESSING);
173 
			t_order.setStatusDescription("In Process");
174 
			t_order.setCreated_timestamp(new Date().getTime());
175 
			t_order.setOrderType(OrderType.B2C);
176 
			t_order.setCod(false);
177 
			System.out.println("t order created");
178 
			try {
8661 vikram.rag 179 
				SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd");
180 
				Date shipDate = null;
181 
				try {
182 
					shipDate= istFormatter.parse(order.getShipByDate());
183 
				} catch (ParseException e) {
184 
					logger.error("Could not parse order date from file ");
185 
					e.printStackTrace();
186 
				}
8627 vikram.rag 187 
				Calendar time = Calendar.getInstance();
188 
				time.add(Calendar.DAY_OF_MONTH, 1);
8661 vikram.rag 189 
				t_order.setPromised_shipping_time(shipDate.getTime());
190 
				t_order.setExpected_shipping_time(shipDate.getTime());
8627 vikram.rag 191 
				time.add(Calendar.DAY_OF_MONTH, 3);
192 
				t_order.setPromised_delivery_time(time.getTimeInMillis());
193 
				t_order.setExpected_delivery_time(time.getTimeInMillis());
194 
				System.out.println("Dates set in transaction");
8697 vikram.rag 195 
			} catch(Exception e) {
8645 vikram.rag 196 
				logger.error("Error in updating Shipping or Delivery Time for suborderid  " + order.getSuborderId());
8627 vikram.rag 197 
				continue;
198 
			}
8657 vikram.rag 199 
			InventoryService.Client inventoryClient = null;
8739 vikram.rag 200 
			Warehouse fulfillmentWarehouse= null;
201 
			try {
202 
				inventoryClient = new InventoryClient().getClient();
203 
				if(snapdealItem.getItem_id()!=0 && snapdealItem.getWarehouseId()!=0) {
204 
					fulfillmentWarehouse = inventoryClient.getWarehouse(snapdealItem.getWarehouseId());
205 
				} else {
206 
					List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(order.getSKUCode(), 1);
207 
					fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
208 
				}
209 
				logger.info("Fulfillment warehouse id for suborderid  " + order.getSuborderId() + " is " + fulfillmentWarehouse.getId());
210 
				t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
211 
				logger.info("Billing warehouse id for suborderid  " + order.getSuborderId() + " is " + fulfillmentWarehouse.getBillingWarehouseId());
212 
				t_order.setWarehouse_id(fulfillmentWarehouse.getBillingWarehouseId());
213 
				VendorItemPricing vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
214 
				t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
215 
				t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
8616 vikram.rag 216 
			} catch (InventoryServiceException e) {
8662 vikram.rag 217 
				logger.error("Error connecting inventory service for suborderid  " + order.getSuborderId());
8739 vikram.rag 218 
				continue;
8616 vikram.rag 219 
			} catch (TTransportException e) {
220 
				// TODO Auto-generated catch block
221 
				e.printStackTrace();
222 
			} catch (TException e) {
223 
				// TODO Auto-generated catch block
224 
				e.printStackTrace();
8657 vikram.rag 225 
			}
8616 vikram.rag 226 
			if(order.getCourier().equalsIgnoreCase(FIRSTFLIGHT)) {
227 
				t_order.setLogistics_provider_id(12);
228 
			} else if(order.getCourier().equalsIgnoreCase(DELHIVERY)) {
229 
				t_order.setLogistics_provider_id(13);
230 
			} else if(order.getCourier().equalsIgnoreCase(BLUEDART)) {
231 
				t_order.setLogistics_provider_id(14);
8642 vikram.rag 232 
			}else if(order.getCourier().equalsIgnoreCase(CHHOTU)) {
233 
				t_order.setLogistics_provider_id(16);
8715 vikram.rag 234 
			}
235 
			else if(order.getCourier().equalsIgnoreCase(LAST_MILE)){
236 
				t_order.setLogistics_provider_id(17);
237 
			}
238 
			else if(order.getCourier().equalsIgnoreCase(ECOMM_EXP)){
239 
				t_order.setLogistics_provider_id(18);
240 
			}
241 
			else if(order.getCourier().equalsIgnoreCase(EWINGS)){
242 
				t_order.setLogistics_provider_id(19);
243 
			}
244 
			else if(order.getCourier().equalsIgnoreCase(DTDC)){
245 
				t_order.setLogistics_provider_id(20);
246 
			}
247 
			else if(order.getCourier().equalsIgnoreCase(WAREOLOG)){
248 
				t_order.setLogistics_provider_id(21);
249 
			}
250 
			else if(order.getCourier().equalsIgnoreCase(MIRAKLE)){
251 
				t_order.setLogistics_provider_id(22);
252 
			}
253 
			else if(order.getCourier().equalsIgnoreCase(RAJIV_TRANSPORT)){
254 
				t_order.setLogistics_provider_id(23);
255 
			}
256 
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_HIGH_VALUE)){
257 
				t_order.setLogistics_provider_id(24);
258 
			}
259 
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_SURFACE)){
260 
				t_order.setLogistics_provider_id(25);
261 
			}
262 
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_APEX)){
263 
				t_order.setLogistics_provider_id(26);
264 
			}
265 
			else if(order.getCourier().equalsIgnoreCase(ARAMEX)){
266 
				t_order.setLogistics_provider_id(27);
267 
			}
268 
			else if(order.getCourier().equalsIgnoreCase(GATI)){
269 
				t_order.setLogistics_provider_id(28);
270 
			}
271 
			else if(order.getCourier().equalsIgnoreCase(INDIA_POST)){
272 
				t_order.setLogistics_provider_id(29);
273 
			}
274 
			else if(order.getCourier().equalsIgnoreCase(FEDEX)){
275 
				t_order.setLogistics_provider_id(30);
276 
			}
277 
			else if(order.getCourier().equalsIgnoreCase(IOT)){
278 
				t_order.setLogistics_provider_id(31);
279 
			}
280 
			else if(order.getCourier().equalsIgnoreCase(RED_EXP)){
281 
				t_order.setLogistics_provider_id(32);
282 
			}
283 
			else if(order.getCourier().equalsIgnoreCase(VDELIVER)){
284 
				t_order.setLogistics_provider_id(33);
285 
			}
286 
			else if(order.getCourier().equalsIgnoreCase(GHARPAY)){
287 
				t_order.setLogistics_provider_id(34);
288 
			}
289 
			else if(order.getCourier().equalsIgnoreCase(QUANTIUM)){
290 
				t_order.setLogistics_provider_id(35);
291 
			}
292 
			else if(order.getCourier().equalsIgnoreCase(GATI_AIR)){
293 
				t_order.setLogistics_provider_id(36);
294 
			}
295 
			else {
8652 vikram.rag 296 
				logger.error("Error No Courier Match please add courier to our system for suborderid  " + order.getSuborderId() + "Courier Name " + order.getCourier());
8627 vikram.rag 297 
				continue;
8616 vikram.rag 298 
			}
8627 vikram.rag 299 
 
8616 vikram.rag 300 
			t_order.setAirwaybill_no(String.valueOf(order.getAWBNumber()));
301 
			t_order.setTracking_id(String.valueOf(order.getAWBNumber()));
8739 vikram.rag 302 
			t_order.setTotal_amount(SellingPrice);
8627 vikram.rag 303 
			t_order.setOrderType(OrderType.B2C);
304 
			t_order.setSource(SNAPDEAL_SOURCE_ID);
305 
			t_order.setOrderType(OrderType.B2C);
306 
			orderlist.add(t_order);
307 
			txn.setOrders(orderlist);
8739 vikram.rag 308 
			String referenceCode = order.getReferenceCode();
309 
			String productName = order.getProduct();
310 
			SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
311 
			Date snapdealTxnDate = null;
312 
			try {
313 
				snapdealTxnDate = istFormatter.parse(order.getOrderPlacedDate());
314 
			} catch (ParseException e) {
315 
				logger.error("Could not parse order date from file ");
316 
				e.printStackTrace();
317 
			}
318 
			try {
319 
				transactionId =  String.valueOf(transaction_client.createTransaction(txn));
320 
			} catch (TransactionServiceException e) {
321 
				logger.error("Could not create transaction ");
322 
				e.printStackTrace();
323 
			} catch (TException e) {
324 
				logger.error("Problem with transaction service while creating transaction");
325 
				e.printStackTrace();
326 
			}
327 
			createPayment(user, (new Long(subOrderId)).toString(),lineItem.getTotal_price());
8627 vikram.rag 328 
 
8739 vikram.rag 329 
			Transaction transaction = null;
330 
			try {
331 
				transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
332 
			} catch (NumberFormatException e) {
333 
				logger.error("Problem parsing transaction id " + transactionId);
334 
				e.printStackTrace();
335 
			} catch (TransactionServiceException e) {
336 
				logger.error("Problem getting transaction from service transaction id " + transactionId);
337 
				e.printStackTrace();
338 
			} catch (TException e) {
339 
				logger.error("Problem with transaction service while getting transaction id " + transactionId);
340 
				e.printStackTrace();
341 
			}
342 
			in.shop2020.model.v1.order.Order snapdealorder = transaction.getOrders().get(0);
8627 vikram.rag 343 
 
8739 vikram.rag 344 
			//inventoryClient.reserveItemInWarehouse(lineItem.getItem_id(), fulfillmentWarehouse.getId(), 1,
345 
			//		snapdealorder.getId(), snapdealorder.getCreated_timestamp(), snapdealorder.getPromised_shipping_time(), snapdealorder.getLineitems().get(0).getQuantity());
8627 vikram.rag 346 
 
347 
 
8739 vikram.rag 348 
			SnapdealOrder snapdealOrder = new SnapdealOrder();
349 
			snapdealOrder.setOrderId(snapdealorder.getId());
350 
			snapdealOrder.setSubOrderId(subOrderId);
351 
			snapdealOrder.setReferenceCode(referenceCode);
352 
			snapdealOrder.setProductName(productName);
353 
			snapdealOrder.setSnapdealTxnDate(snapdealTxnDate.getTime());
354 
			snapdealOrder.setListingPrice(order.getSellingPricePerItem());
355 
			try {
356 
				transaction_client.createSnapdealOrder(snapdealOrder);
357 
			} catch (TException e) {
358 
				logger.error("Could not create Snapdeal Order");
359 
				e.printStackTrace();
360 
			}
8627 vikram.rag 361 
 
8739 vikram.rag 362 
		}
8616 vikram.rag 363 
 
364 
	}
365 
 
8649 vikram.rag 366 
	public static void createPayment(User user, String subOrderId, double amount) {
367 
		in.shop2020.payments.PaymentService.Client client = null;
368 
		try {
369 
			client = new PaymentClient().getClient();
370 
		} catch (TTransportException e) {
371 
			logger.error("Could not connect to payment service ");
372 
			e.printStackTrace();
373 
		}
374 
		long paymentId = 0;
375 
		try {
376 
			paymentId = client.createPayment(user.getUserId(), amount, SNAPDEAL_GATEWAY_ID, Long.valueOf(transactionId), false);
377 
		} catch (NumberFormatException e) {
378 
			logger.error("Could not create payment");
379 
			e.printStackTrace();
380 
		} catch (PaymentException e) {
381 
			logger.error("Could not create payment payment exception");
382 
			e.printStackTrace();
383 
		} catch (TException e) {
384 
			logger.error("Could not create payment thrift exception");
385 
			e.printStackTrace();
386 
		}
387 
		try {
388 
			client.updatePaymentDetails(paymentId, null, null, null, null, null, null, subOrderId, null, PaymentStatus.AUTHORIZED, null, null);
389 
		} catch (PaymentException e) {
390 
			logger.error("Could not update payment to order");
391 
			e.printStackTrace();
392 
		} catch (TException e) {
393 
			logger.error("Could not update payment thrift exception");
394 
			e.printStackTrace();
395 
		}
8627 vikram.rag 396 
	}
397 
 
8616 vikram.rag 398 
	public static LineItem createLineItem(long itemId, double amount) throws CatalogServiceException, TException {
8627 vikram.rag 399 
		LineItem lineItem = new LineItem();
400 
		CatalogService.Client catalogClient = new CatalogClient().getClient();
401 
		Item item = catalogClient.getItem(itemId);
8616 vikram.rag 402 
 
8627 vikram.rag 403 
		lineItem.setProductGroup(item.getProductGroup());
404 
		lineItem.setBrand(item.getBrand());
405 
		lineItem.setModel_number(item.getModelNumber());
406 
		lineItem.setModel_name(item.getModelName());
407 
		lineItem.setExtra_info(item.getFeatureDescription());
408 
		lineItem.setQuantity(1);
409 
		lineItem.setItem_id(item.getId());
410 
		lineItem.setUnit_weight(item.getWeight());
411 
		lineItem.setTotal_weight(item.getWeight());
412 
		lineItem.setUnit_price(amount);
413 
		lineItem.setTotal_price(amount);
414 
 
8739 vikram.rag 415 
		if (item.getColor() == null || "NA".equals(item.getColor())) {
8627 vikram.rag 416 
			lineItem.setColor("");
417 
		} else {
418 
			lineItem.setColor(item.getColor());
419 
		}
420 
		return lineItem;
8616 vikram.rag 421 
	}
422 
 
423 
}