Subversion Repositories SmartDukaan

Rev

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