Subversion Repositories SmartDukaan

Rev

Rev 8845 | Rev 8849 | 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;
7
import in.shop2020.model.v1.inventory.InventoryService;
8
import in.shop2020.model.v1.inventory.InventoryServiceException;
8759 vikram.rag 9
 
8616 vikram.rag 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;
8773 vikram.rag 37
import java.util.GregorianCalendar;
8616 vikram.rag 38
import java.util.List;
39
import javax.xml.bind.JAXBContext;
40
import javax.xml.bind.JAXBException;
41
import javax.xml.bind.Marshaller;
42
import javax.xml.bind.Unmarshaller;
8739 vikram.rag 43
 
8616 vikram.rag 44
import org.apache.thrift.TException;
45
import org.apache.thrift.transport.TTransportException;
8645 vikram.rag 46
import org.slf4j.Logger;
47
import org.slf4j.LoggerFactory;
8773 vikram.rag 48
import in.shop2020.utils.GmailUtils;
8616 vikram.rag 49
 
50
import order.SaholicAPI;
51
import order.SaholicAPI.Order;
52
 
53
public class ProcessSnapdealOrder {
54
	private static final int SNAPDEAL_SOURCE_ID = 7;
55
	private static final String FIRSTFLIGHT = "First Flight";
8627 vikram.rag 56
	private static final String DELHIVERY = "DELHIVERY";
57
	private static final String BLUEDART = "Bluedart";
8715 vikram.rag 58
	private static final String CHHOTU = "CHHOTU";	
59
	private static final String LAST_MILE = "LAST_MILE";
8844 amar.kumar 60
	private static final String  ECOMM_EXP = "Ecom Express";
8715 vikram.rag 61
	private static final String  EWINGS = "EWINGS";
62
	private static final String DTDC = "DTDC";
63
	private static final String WAREOLOG = "DTDC";
64
	private static final String  MIRAKLE = "MIRAKLE";
65
	private static final String RAJIV_TRANSPORT = "RAJIV_TRANSPORT";
66
	private static final String BLUEDART_HIGH_VALUE = "BLUEDART_HIGH_VALUE";
67
	private static final String BLUEDART_SURFACE = "BLUEDART_SURFACE";
68
	private static final String BLUEDART_APEX = "BLUEDART_APEX";
69
	private static final String ARAMEX = "ARAMEX";
70
	private static final String GATI = "GATI";
71
	private static final String INDIA_POST = "INDIA_POST";
72
	private static final String FEDEX = "FEDEX";
73
	private static final String IOT = "IOT";
74
	private static final String RED_EXP = "RED_EXP";
75
	private static final String GHARPAY = "GHARPAY";
76
	private static final String QUANTIUM = "QUANTIUM";
77
	private static final String GATI_AIR = "GATI_AIR`";
78
	private static final String VDELIVER = "VDELIVER";
8627 vikram.rag 79
	private static String transactionId;
80
	private static final int SNAPDEAL_GATEWAY_ID = 18;
8646 vikram.rag 81
	private static Logger logger;
8627 vikram.rag 82
 
8616 vikram.rag 83
	public static void processSnapdealOrders(File file) throws JAXBException{
8646 vikram.rag 84
		logger = LoggerFactory.getLogger(ProcessSnapdealOrder.class);
8616 vikram.rag 85
		JAXBContext jc = JAXBContext.newInstance(SaholicAPI.class);
86
		Unmarshaller unmarshaller = jc.createUnmarshaller();
87
		SaholicAPI orders = (SaholicAPI) unmarshaller.unmarshal(file);
88
		Marshaller marshaller = jc.createMarshaller();
89
		marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
90
		marshaller.marshal(orders, System.out);
91
		SourceDetail sourceDetail = null;
92
		User user = null;
93
		TransactionClient tsc = null;
94
		try {
95
			tsc = new TransactionClient();
96
			sourceDetail = tsc.getClient().getSourceDetail(SNAPDEAL_SOURCE_ID);
97
		} catch (Exception e) {
8773 vikram.rag 98
			logger.error("Unable to establish connection to the transaction service while getting Snapdeal Source Detail ", e);
8616 vikram.rag 99
		}
100
		try {   
101
			in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
102
			user = userClient.getUserByEmail(sourceDetail.getEmail());
103
		} catch (Exception e) {
8773 vikram.rag 104
			logger.error("Unable to establish connection to the User service ", e);
8616 vikram.rag 105
		}
8800 vikram.rag 106
		int duplicate_orders = 0;
107
		int new_orders = 0;
8773 vikram.rag 108
		int processed_orders = 0;
109
		StringBuffer sb = new StringBuffer();
8616 vikram.rag 110
		for(Order order:orders.getOrder()){
8627 vikram.rag 111
			long subOrderId = (long) order.getSuborderId();
112
			Client transaction_client = null;
113
			try {
114
				transaction_client = new TransactionClient().getClient();
8802 amar.kumar 115
				if(transaction_client.snapdealOrderExists(subOrderId, order.getReferenceCode())) {
8739 vikram.rag 116
					logger.error("Snapdeal suborder id exists " + subOrderId);
8800 vikram.rag 117
					duplicate_orders++;
8627 vikram.rag 118
					continue;
119
				}
120
 
121
			} catch (TTransportException e1) {
8773 vikram.rag 122
				logger.error("Problem with Transaction service " , e1);
8627 vikram.rag 123
				e1.printStackTrace();
124
			} catch (TException e) {
8773 vikram.rag 125
				logger.error("Problem.. thrift exception with Transaction service " , e);
8627 vikram.rag 126
				e.printStackTrace();
127
			}
8800 vikram.rag 128
			new_orders++;
8616 vikram.rag 129
			Transaction txn = new Transaction();
130
			txn.setShoppingCartid(user.getActiveCartId());
131
			txn.setCustomer_id(user.getUserId());
8627 vikram.rag 132
			System.out.println("User Id is " + user.getUserId());
8616 vikram.rag 133
			txn.setCreatedOn(new Date().getTime());
134
			txn.setTransactionStatus(TransactionStatus.INIT);
135
			txn.setStatusDescription("Order for Snapdeal ");
136
			List<in.shop2020.model.v1.order.Order> orderlist = new ArrayList<in.shop2020.model.v1.order.Order>();
137
			LineItem lineItem = null;
8739 vikram.rag 138
			CatalogService.Client catalogClient = null;
139
			SnapdealItem snapdealItem = null;
140
			double SellingPrice = 0;
8616 vikram.rag 141
			try {
8739 vikram.rag 142
				catalogClient =  new CatalogClient().getClient();
143
				snapdealItem = catalogClient.getSnapdealItem(order.getSKUCode());
8742 vikram.rag 144
				if(snapdealItem.getItem_id()!=0 && order.getSellingPricePerItem() <  snapdealItem.getExceptionPrice()){
8739 vikram.rag 145
					SellingPrice = snapdealItem.getExceptionPrice();
146
				}
147
				else{
148
					SellingPrice = order.getSellingPricePerItem();
149
				}
150
				lineItem = createLineItem(order.getSKUCode(),SellingPrice);
8773 vikram.rag 151
				if(lineItem == null){
152
					sb.append(order.getSuborderId() +" "+"SKU not found" + "\n");
153
					continue;
154
				}
8846 vikram.rag 155
				lineItem.setExtra_info("SubOrderId = " + order.getSuborderId() + " ReferenceCode = " + order.getReferenceCode());
8616 vikram.rag 156
			} catch (CatalogServiceException e) {
8773 vikram.rag 157
				logger.error("Unable to create order for suborderid  " + order.getSuborderId() , e);
8616 vikram.rag 158
				e.printStackTrace();
8773 vikram.rag 159
				sb.append(order.getSuborderId() + " " + "Problem with catalog service" + "\n");
8744 vikram.rag 160
				continue;
8616 vikram.rag 161
			} catch (TException e) {
8773 vikram.rag 162
				logger.error("Unable to create order for suborderid  " + order.getSuborderId() , e);
8616 vikram.rag 163
				e.printStackTrace();
8773 vikram.rag 164
				sb.append(order.getSuborderId() + " " + "Thrift Exception in Catalog Service" + "\n");
8744 vikram.rag 165
				continue;
8616 vikram.rag 166
			}
167
			in.shop2020.model.v1.order.Order t_order = new in.shop2020.model.v1.order.Order();
8627 vikram.rag 168
			t_order.setCustomer_id(user.getUserId());
169
			t_order.setCustomer_email(sourceDetail.getEmail());
170
			t_order.setCustomer_name(order.getCustomerName());
171
			t_order.setCustomer_address1("");
172
			t_order.setCustomer_address2("");
173
			t_order.setCustomer_city(order.getCity());
174
			t_order.setCustomer_state(order.getState());
175
			t_order.setCustomer_pincode(String.valueOf(order.getPINCode()));
8742 vikram.rag 176
			t_order.setTotal_amount(SellingPrice);            
8627 vikram.rag 177
			t_order.setTotal_weight(lineItem.getTotal_weight());
178
			t_order.setLineitems(Collections.singletonList(lineItem));            
8759 vikram.rag 179
			t_order.setStatus(OrderStatus.PAYMENT_PENDING);
8844 amar.kumar 180
			t_order.setStatusDescription("In Process");
8627 vikram.rag 181
			t_order.setCreated_timestamp(new Date().getTime());
182
			t_order.setOrderType(OrderType.B2C);
183
			t_order.setCod(false);
184
			System.out.println("t order created");
185
			try {
8804 vikram.rag 186
				SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
8661 vikram.rag 187
				Date shipDate = null;
188
				try {
189
					shipDate= istFormatter.parse(order.getShipByDate());
190
				} catch (ParseException e) {
8773 vikram.rag 191
					logger.error("Could not parse order ship date from file " , e);
8661 vikram.rag 192
					e.printStackTrace();
8775 vikram.rag 193
					sb.append(order.getSuborderId() + " Could not parse ship date" + " " + "\n");
8744 vikram.rag 194
					continue;
8661 vikram.rag 195
				}
8627 vikram.rag 196
				Calendar time = Calendar.getInstance();
8661 vikram.rag 197
				t_order.setPromised_shipping_time(shipDate.getTime());
198
				t_order.setExpected_shipping_time(shipDate.getTime());
8744 vikram.rag 199
				time.add(Calendar.DAY_OF_MONTH, 4);
8627 vikram.rag 200
				t_order.setPromised_delivery_time(time.getTimeInMillis());
201
				t_order.setExpected_delivery_time(time.getTimeInMillis());
202
				System.out.println("Dates set in transaction");
8697 vikram.rag 203
			} catch(Exception e) {	
8645 vikram.rag 204
				logger.error("Error in updating Shipping or Delivery Time for suborderid  " + order.getSuborderId());
8775 vikram.rag 205
				sb.append(order.getSuborderId() + " Could not update delivery time" + " " + "\n");
8627 vikram.rag 206
				continue;
207
			}
8657 vikram.rag 208
			InventoryService.Client inventoryClient = null;
8739 vikram.rag 209
			Warehouse fulfillmentWarehouse= null;
210
			try {
211
				inventoryClient = new InventoryClient().getClient();
212
				if(snapdealItem.getItem_id()!=0 && snapdealItem.getWarehouseId()!=0) {
213
					fulfillmentWarehouse = inventoryClient.getWarehouse(snapdealItem.getWarehouseId());
214
				} else {
215
					List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(order.getSKUCode(), 1);
216
					fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
8789 vikram.rag 217
					if(fulfillmentWarehouse.getStateId()!=0){
218
						fulfillmentWarehouse = inventoryClient.getWarehouse(7);
219
					}
8739 vikram.rag 220
				}
221
				t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
222
				logger.info("Billing warehouse id for suborderid  " + order.getSuborderId() + " is " + fulfillmentWarehouse.getBillingWarehouseId());
223
				t_order.setWarehouse_id(fulfillmentWarehouse.getBillingWarehouseId());
8845 amar.kumar 224
				VendorItemPricing vendorItemPricing = new VendorItemPricing();
225
				if(fulfillmentWarehouse.getId()==7) {
226
					Item item = new CatalogClient().getClient().getItem(lineItem.getItem_id());
227
					vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
228
				} else {
229
					vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
230
				}
231
 
8739 vikram.rag 232
				t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
233
				t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
8616 vikram.rag 234
			} catch (InventoryServiceException e) {
8846 vikram.rag 235
				logger.error("Error connecting inventory service for suborderid  " + order.getSuborderId() , e);
8775 vikram.rag 236
				sb.append(order.getSuborderId() + " Inventory Service Exception" + " " + "\n");
8739 vikram.rag 237
				continue;
8616 vikram.rag 238
			} catch (TTransportException e) {
8773 vikram.rag 239
				logger.error("Transport Exception with Inventory Service for suborderid  " + order.getSuborderId() , e);
8775 vikram.rag 240
				sb.append(order.getSuborderId() + " Transport Exception with Inventory Service" + " " + "\n");
8744 vikram.rag 241
				continue;
8616 vikram.rag 242
			} catch (TException e) {
8773 vikram.rag 243
				logger.error("Exception with Inventory Service for suborderid  " + order.getSuborderId() , e);
8775 vikram.rag 244
				sb.append(order.getSuborderId() + " Exception in Inventory Service" + " " + "\n");
8744 vikram.rag 245
				continue;
8845 amar.kumar 246
			} catch (CatalogServiceException e) {
247
				logger.error("Exception with Catalog Service for suborderid  " + order.getSuborderId() + " while getting item " + lineItem.getItem_id(), e);
248
				sb.append(order.getSuborderId() + " Exception in Catalog Service" + " " + "\n");
249
				continue;
8657 vikram.rag 250
			}
8616 vikram.rag 251
			if(order.getCourier().equalsIgnoreCase(FIRSTFLIGHT)) {
252
				t_order.setLogistics_provider_id(12);
253
			} else if(order.getCourier().equalsIgnoreCase(DELHIVERY)) {
254
				t_order.setLogistics_provider_id(13);
255
			} else if(order.getCourier().equalsIgnoreCase(BLUEDART)) {
256
				t_order.setLogistics_provider_id(14);
8642 vikram.rag 257
			}else if(order.getCourier().equalsIgnoreCase(CHHOTU)) {
258
				t_order.setLogistics_provider_id(16);
8715 vikram.rag 259
			}
260
			else if(order.getCourier().equalsIgnoreCase(LAST_MILE)){
261
				t_order.setLogistics_provider_id(17);
262
			}
263
			else if(order.getCourier().equalsIgnoreCase(ECOMM_EXP)){
264
				t_order.setLogistics_provider_id(18);
265
			}
266
			else if(order.getCourier().equalsIgnoreCase(EWINGS)){
267
				t_order.setLogistics_provider_id(19);
268
			}
269
			else if(order.getCourier().equalsIgnoreCase(DTDC)){
270
				t_order.setLogistics_provider_id(20);
271
			}
272
			else if(order.getCourier().equalsIgnoreCase(WAREOLOG)){
273
				t_order.setLogistics_provider_id(21);
274
			}
275
			else if(order.getCourier().equalsIgnoreCase(MIRAKLE)){
276
				t_order.setLogistics_provider_id(22);
277
			}
278
			else if(order.getCourier().equalsIgnoreCase(RAJIV_TRANSPORT)){
279
				t_order.setLogistics_provider_id(23);
280
			}
281
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_HIGH_VALUE)){
282
				t_order.setLogistics_provider_id(24);
283
			}
284
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_SURFACE)){
285
				t_order.setLogistics_provider_id(25);
286
			}
287
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_APEX)){
288
				t_order.setLogistics_provider_id(26);
289
			}
290
			else if(order.getCourier().equalsIgnoreCase(ARAMEX)){
291
				t_order.setLogistics_provider_id(27);
292
			}
293
			else if(order.getCourier().equalsIgnoreCase(GATI)){
294
				t_order.setLogistics_provider_id(28);
295
			}
296
			else if(order.getCourier().equalsIgnoreCase(INDIA_POST)){
297
				t_order.setLogistics_provider_id(29);
298
			}
299
			else if(order.getCourier().equalsIgnoreCase(FEDEX)){
300
				t_order.setLogistics_provider_id(30);
301
			}
302
			else if(order.getCourier().equalsIgnoreCase(IOT)){
303
				t_order.setLogistics_provider_id(31);
304
			}
305
			else if(order.getCourier().equalsIgnoreCase(RED_EXP)){
306
				t_order.setLogistics_provider_id(32);
307
			}
308
			else if(order.getCourier().equalsIgnoreCase(VDELIVER)){
309
				t_order.setLogistics_provider_id(33);
310
			}
311
			else if(order.getCourier().equalsIgnoreCase(GHARPAY)){
312
				t_order.setLogistics_provider_id(34);
313
			}
314
			else if(order.getCourier().equalsIgnoreCase(QUANTIUM)){
315
				t_order.setLogistics_provider_id(35);
316
			}
317
			else if(order.getCourier().equalsIgnoreCase(GATI_AIR)){
318
				t_order.setLogistics_provider_id(36);
319
			}
320
			else {
8652 vikram.rag 321
				logger.error("Error No Courier Match please add courier to our system for suborderid  " + order.getSuborderId() + "Courier Name " + order.getCourier());
8773 vikram.rag 322
				sb.append(order.getSuborderId() + " Error No Courier Match " + order.getCourier() +"\n");
8627 vikram.rag 323
				continue;
8616 vikram.rag 324
			}
8627 vikram.rag 325
 
8616 vikram.rag 326
			t_order.setAirwaybill_no(String.valueOf(order.getAWBNumber()));
327
			t_order.setTracking_id(String.valueOf(order.getAWBNumber()));
8739 vikram.rag 328
			t_order.setTotal_amount(SellingPrice);
8627 vikram.rag 329
			t_order.setOrderType(OrderType.B2C);
330
			t_order.setSource(SNAPDEAL_SOURCE_ID);
331
			t_order.setOrderType(OrderType.B2C);
332
			orderlist.add(t_order);
333
			txn.setOrders(orderlist);
8739 vikram.rag 334
			String referenceCode = order.getReferenceCode();
335
			String productName = order.getProduct();
336
			SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
337
			Date snapdealTxnDate = null;
338
			try {
339
				snapdealTxnDate = istFormatter.parse(order.getOrderPlacedDate());
340
			} catch (ParseException e) {
8773 vikram.rag 341
				logger.error(order.getSuborderId() + " Could not parse snapdeal order date from file " , e);
342
				sb.append(order.getSuborderId() + " Could not parse order date" +"\n");
8744 vikram.rag 343
				continue;
8739 vikram.rag 344
			}
345
			try {
346
				transactionId =  String.valueOf(transaction_client.createTransaction(txn));
347
			} catch (TransactionServiceException e) {
8773 vikram.rag 348
				logger.error(order.getSuborderId() + " Could not create transaction " , e);
349
				sb.append(order.getSuborderId() + " Could not create transaction" +"\n");
8744 vikram.rag 350
				continue;
8739 vikram.rag 351
			} catch (TException e) {
8773 vikram.rag 352
				logger.error("Problem with transaction service while creating transaction", e);
8775 vikram.rag 353
				sb.append(order.getSuborderId() + " Transaction Service Exception could not create transaction" +"\n");
8744 vikram.rag 354
				continue;
8739 vikram.rag 355
			}
8806 vikram.rag 356
			try{
357
				createPayment(user, (new Long(subOrderId)).toString(),lineItem.getTotal_price());
358
			}
359
			catch (NumberFormatException e) {
360
				logger.error("Could not create payment",e);
361
				sb.append(order.getSuborderId() + " Could not create payment");
362
				e.printStackTrace();
363
				continue;
364
			} catch (PaymentException e) {
365
				logger.error("Could not create payment payment exception",e);
366
				sb.append(order.getSuborderId() + " Could not create payment Payment exception");
367
				e.printStackTrace();
368
				continue;
369
			} catch (TException e) {
370
				logger.error("Could not create payment thrift exception",e);
371
				sb.append(order.getSuborderId() + " Could not create payment Thrift exception");
372
				e.printStackTrace();
373
				continue;
374
			}
8739 vikram.rag 375
			Transaction transaction = null;
376
			try {
377
				transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
378
			} catch (NumberFormatException e) {
379
				logger.error("Problem parsing transaction id " + transactionId);
8773 vikram.rag 380
				sb.append(order.getSuborderId() + " Problem parsing transaction id "+ transactionId +"\n");
8739 vikram.rag 381
				e.printStackTrace();
8744 vikram.rag 382
				continue;
8739 vikram.rag 383
			} catch (TransactionServiceException e) {
384
				logger.error("Problem getting transaction from service transaction id " + transactionId);
8773 vikram.rag 385
				sb.append(order.getSuborderId() + " Problem getting transaction id "+ transactionId +"\n");
8739 vikram.rag 386
				e.printStackTrace();
8744 vikram.rag 387
				continue;
8739 vikram.rag 388
			} catch (TException e) {
389
				logger.error("Problem with transaction service while getting transaction id " + transactionId);
8773 vikram.rag 390
				sb.append(order.getSuborderId() + " Problem with transaction service while getting transaction id "+ transactionId +"\n");
8739 vikram.rag 391
				e.printStackTrace();
8744 vikram.rag 392
				continue;
8739 vikram.rag 393
			}
394
			in.shop2020.model.v1.order.Order snapdealorder = transaction.getOrders().get(0);
8744 vikram.rag 395
			try {
396
				inventoryClient.reserveItemInWarehouse(lineItem.getItem_id(), fulfillmentWarehouse.getId(), 1, 
8773 vikram.rag 397
						snapdealorder.getId(), snapdealorder.getCreated_timestamp(), snapdealorder.getPromised_shipping_time(), snapdealorder.getLineitems().get(0).getQuantity());
8744 vikram.rag 398
			} catch (InventoryServiceException e1) {
399
				logger.error("Problem while reserving item in inventory service" + snapdealorder.getId());
8773 vikram.rag 400
				sb.append(order.getSuborderId() + " Could not reserve inventory for sku "+ order.getSKUCode() +"\n");
8744 vikram.rag 401
				continue;
402
			} catch (TException e1) {
403
				logger.error("Problem with inventory service" + snapdealorder.getId());
8773 vikram.rag 404
				sb.append(order.getSuborderId() + " Problem with inventory service while reserving inventory for sku "+ order.getSKUCode() +"\n");
8744 vikram.rag 405
				continue;
406
			}
8739 vikram.rag 407
			SnapdealOrder snapdealOrder = new SnapdealOrder();
408
			snapdealOrder.setOrderId(snapdealorder.getId());
409
			snapdealOrder.setSubOrderId(subOrderId);
410
			snapdealOrder.setReferenceCode(referenceCode);
411
			snapdealOrder.setProductName(productName);
412
			snapdealOrder.setSnapdealTxnDate(snapdealTxnDate.getTime());
413
			snapdealOrder.setListingPrice(order.getSellingPricePerItem());
414
			try {
415
				transaction_client.createSnapdealOrder(snapdealOrder);
416
			} catch (TException e) {
417
				logger.error("Could not create Snapdeal Order");
8773 vikram.rag 418
				sb.append(order.getSuborderId() + " Could not create snapdeal order"+"\n");
8739 vikram.rag 419
			}
8773 vikram.rag 420
			processed_orders++;
8789 vikram.rag 421
 
8773 vikram.rag 422
		}
423
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
424
		Calendar cal=GregorianCalendar.getInstance();
425
		String emailFromAddress = "build@shop2020.in";
426
		String password = "cafe@nes";
427
		GmailUtils mailer = new GmailUtils();
8808 vikram.rag 428
		//String sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
429
		String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
430
				"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
431
				"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
8806 vikram.rag 432
 
8773 vikram.rag 433
		try {
8800 vikram.rag 434
			if(new_orders==processed_orders && new_orders > 0){
435
				String emailSubjectTxt = "Snapdeal Orders Created Successfully "+sdf.format(cal.getTime());
436
				String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" + 
8801 vikram.rag 437
				"Orders Already Existing : " + duplicate_orders + "\n" +
8800 vikram.rag 438
				"Processed Orders : " + processed_orders + "\n" +
439
				"Failed Orders : " + (new_orders - processed_orders);
8773 vikram.rag 440
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
441
			}
8800 vikram.rag 442
			else if(new_orders > 0){
443
				String emailSubjectTxt = "Snapdeal Orders Failed while creation "+sdf.format(cal.getTime());
444
				String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" + 
8801 vikram.rag 445
				"Orders Already Existing : " + duplicate_orders + "\n" +
8800 vikram.rag 446
				"Processed Orders : " + processed_orders + "\n" +
447
				"Failed Orders : " + (new_orders - processed_orders) + "\n"+ "\n" +
448
				sb.toString();
8773 vikram.rag 449
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
450
			}
8800 vikram.rag 451
			else{
8808 vikram.rag 452
				//sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
453
				sendTo = new String[]{"engg@shop2020.in","sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
454
						"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
455
						"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
456
 
8800 vikram.rag 457
				String emailSubjectTxt = "No new Snapdeal Orders " + sdf.format(cal.getTime());
458
				String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" + 
8801 vikram.rag 459
				"Orders Already Existing : " + duplicate_orders + "\n" +
8800 vikram.rag 460
				"Processed Orders : " + processed_orders + "\n" +
461
				"Failed Orders : " + (new_orders - processed_orders) + "\n"+ "\n" +
462
				sb.toString();
463
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
464
			}
8773 vikram.rag 465
		}
466
		catch (Exception e) {
467
			e.printStackTrace();
468
		}
8627 vikram.rag 469
 
8616 vikram.rag 470
 
8773 vikram.rag 471
 
8616 vikram.rag 472
	}
473
 
8806 vikram.rag 474
	public static void createPayment(User user, String subOrderId, double amount) throws NumberFormatException, PaymentException, TException {
475
	    in.shop2020.payments.PaymentService.Client client = new PaymentClient().getClient();
476
        long paymentId = client.createPayment(user.getUserId(), amount, SNAPDEAL_GATEWAY_ID, Long.valueOf(transactionId), false);
477
        client.updatePaymentDetails(paymentId, null, null, null, null, null, null, subOrderId, null, PaymentStatus.AUTHORIZED, null, null);
8627 vikram.rag 478
	}   
479
 
8616 vikram.rag 480
	public static LineItem createLineItem(long itemId, double amount) throws CatalogServiceException, TException {
8627 vikram.rag 481
		LineItem lineItem = new LineItem();
482
		CatalogService.Client catalogClient = new CatalogClient().getClient();
483
		Item item = catalogClient.getItem(itemId);
8773 vikram.rag 484
		if(item.getId()==0){
485
			//in case item id is incorrect..
486
			return null;
487
		}
8616 vikram.rag 488
 
8627 vikram.rag 489
		lineItem.setProductGroup(item.getProductGroup());
490
		lineItem.setBrand(item.getBrand());
491
		lineItem.setModel_number(item.getModelNumber());
492
		lineItem.setModel_name(item.getModelName());
493
		lineItem.setExtra_info(item.getFeatureDescription());
494
		lineItem.setQuantity(1);
495
		lineItem.setItem_id(item.getId());
496
		lineItem.setUnit_weight(item.getWeight());
497
		lineItem.setTotal_weight(item.getWeight());
498
		lineItem.setUnit_price(amount);
499
		lineItem.setTotal_price(amount);
500
 
8739 vikram.rag 501
		if (item.getColor() == null || "NA".equals(item.getColor())) {
8627 vikram.rag 502
			lineItem.setColor("");
503
		} else {
504
			lineItem.setColor(item.getColor());
505
		}
506
		return lineItem;
8616 vikram.rag 507
	}
508
 
509
}