Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
9073 vikram.rag 1
package in.shop2020.serving.services;
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.catalog.SnapdealItem;
7
import in.shop2020.model.v1.inventory.InventoryService;
8
import in.shop2020.model.v1.inventory.InventoryServiceException;
9
import in.shop2020.model.v1.inventory.InventoryType;
10
import in.shop2020.model.v1.inventory.VendorItemPricing;
11
import in.shop2020.model.v1.inventory.Warehouse;
12
import in.shop2020.model.v1.inventory.WarehouseType;
13
import in.shop2020.model.v1.order.FlipkartOrder;
14
import in.shop2020.model.v1.order.LineItem;
15
import in.shop2020.model.v1.order.OrderStatus;
16
import in.shop2020.model.v1.order.OrderType;
17
import in.shop2020.model.v1.order.SourceDetail;
18
import in.shop2020.model.v1.order.Transaction;
19
import in.shop2020.model.v1.order.TransactionServiceException;
20
import in.shop2020.model.v1.order.TransactionStatus;
21
import in.shop2020.model.v1.order.TransactionService.Client;
22
import in.shop2020.model.v1.user.User;
23
import in.shop2020.payments.PaymentException;
24
import in.shop2020.payments.PaymentStatus;
25
import in.shop2020.serving.model.Order;
26
import in.shop2020.serving.model.OrderItems;
27
import in.shop2020.thrift.clients.CatalogClient;
28
import in.shop2020.thrift.clients.InventoryClient;
29
import in.shop2020.thrift.clients.PaymentClient;
30
import in.shop2020.thrift.clients.TransactionClient;
31
import in.shop2020.thrift.clients.UserClient;
32
import in.shop2020.utils.GmailUtils;
33
import java.io.BufferedReader;
34
import java.io.File;
35
import java.io.FileInputStream;
36
import java.io.IOException;
37
import java.io.InputStreamReader;
38
import java.text.ParseException;
39
import java.text.SimpleDateFormat;
40
import java.util.ArrayList;
41
import java.util.Calendar;
42
import java.util.Collections;
43
import java.util.Date;
9077 vikram.rag 44
import java.util.GregorianCalendar;
9073 vikram.rag 45
import java.util.List;
46
import org.apache.http.client.HttpClient;
47
import org.apache.http.client.entity.UrlEncodedFormEntity;
48
import org.apache.http.client.methods.HttpGet;
49
import org.apache.http.client.methods.HttpPost;
50
import org.apache.http.impl.client.DefaultHttpClient;
51
import org.apache.http.message.BasicNameValuePair;
52
import org.apache.http.HttpResponse;
53
import org.apache.http.NameValuePair;
54
import org.apache.thrift.TException;
55
import org.apache.thrift.transport.TTransportException;
56
import org.slf4j.Logger;
57
import org.slf4j.LoggerFactory;
58
import com.google.gson.Gson;
59
 
60
 
61
 
62
public class FetchNewFlipCartOrders {
63
	private static final long FLIPKART_SOURCE_ID = 8;
64
	private static final int FLIPKART_GATEWAY_ID = 17;
65
	private static final int FLIPKART_LOGISTICS_ID = 19;
66
	private static String transactionId;
67
 
68
	private static Logger logger = LoggerFactory.getLogger(FetchNewFlipCartOrders .class);	
69
	public static void main(String[] args) throws  CatalogServiceException, TException, IOException {
70
		HttpClient client = new DefaultHttpClient();
71
		HttpPost post = new HttpPost("https://seller.flipkart.com/login");
72
		BufferedReader rd= null;
73
		try {
74
			List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
75
			nameValuePairs.add(new BasicNameValuePair("authName",
76
			"flipkart"));
77
			nameValuePairs.add(new BasicNameValuePair("username",
78
			"flipkart-support@saholic.com"));
79
			nameValuePairs.add(new BasicNameValuePair("password",
80
			"076c27ee24d7596b06608a8ed2559f87"));
9075 vikram.rag 81
			post.setEntity(new UrlEncodedFormEntity(nameValuePairs,"utf-8"));
9073 vikram.rag 82
			HttpResponse response = client.execute(post);
83
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
84
			String line = "";
9102 vikram.rag 85
			Gson gson;
86
			List<Order> orders = new ArrayList<Order>(); 
87
			OrderItems new_orders;
88
			OrderItems conf_orders;
89
			HttpGet get_new;
90
			HttpGet get_conf; 
91
			long time;
92
			int i=1;
9073 vikram.rag 93
			while ((line = rd.readLine()) != null) {
94
				System.out.println(line);
95
			}
9102 vikram.rag 96
			time = System.currentTimeMillis();
97
			while(true){
98
				get_new = new HttpGet("https://seller.flipkart.com/dashboard/som/new_order_items?status=on_hold%2Capproved.payment_approved&sort=confirm_by_date&page="+i+"&page_size=100&_="+time);
99
				response = client.execute(get_new);
100
				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
101
				line = "";
102
				gson = new Gson();
103
				new_orders = (OrderItems) gson.fromJson(rd, OrderItems.class);
104
				if(new_orders.getOrder_items().size()>0){
105
					orders.addAll(new_orders.getOrder_items());
106
				}
107
				else{
108
					break;
109
				}
110
				i++;
111
			}
112
			i=1;
113
			time = System.currentTimeMillis();
114
			while(true){
115
				get_conf = new HttpGet("https://seller.flipkart.com/dashboard/som/confirmed_order_items?status=approved.seller_approved&sort=confirm_by_date&page="+i+"&page_size=100&_="+time);
116
				response = client.execute(get_conf);
117
				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
118
				line = "";
119
				gson = new Gson();
120
				conf_orders = (OrderItems) gson.fromJson(rd, OrderItems.class);
121
				if(conf_orders.getOrder_items().size()>0){
122
					orders.addAll(conf_orders.getOrder_items());
123
				}
124
				else{
125
					break;
126
				}
127
				i++;
128
			}
9104 vikram.rag 129
			for(Order order:orders){
130
				System.out.println("Order  " + order.getExternalId() +" "+order.getOrderItemId() + " : "+ order.getStatus() + " "+order.getStatusDateMessage() + " "
131
						+ order.getStatusLabel() + " " + order.getPickup_by_date() + " "+ order.getTrackingId());
132
			}
9116 vikram.rag 133
			processOrders(orders);
9096 vikram.rag 134
		} catch (IOException e) {
9073 vikram.rag 135
			e.printStackTrace();
136
		}
137
	}
138
 
139
	public static void processOrders(List<Order> orders) throws IOException, CatalogServiceException, TException{
140
		logger.info("Before Processing orders ");
141
		StringBuffer sb = new StringBuffer();
142
		int orders_processed = 0;
143
		String order_string = "";
144
		User user = null;
145
		TransactionClient tsc = null;
146
		SourceDetail sourceDetail = null;
147
		logger.info("Before Fetching sourcedetail");
148
		try {
149
			tsc = new TransactionClient();
150
			sourceDetail = tsc.getClient().getSourceDetail(FLIPKART_SOURCE_ID);
151
			logger.info("Flipkart sourcedetail " + sourceDetail.getEmail() + " " + sourceDetail.getName());
152
		} catch (Exception e) {
153
			logger.error("Unable to establish connection to the transaction service while getting Flipkart Source Detail ", e);
154
		}
155
		try {   
156
			in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
157
			logger.info("Before Fetching User by Email");
158
			user = userClient.getUserByEmail(sourceDetail.getEmail());
159
			logger.info("User is " + user.getEmail());
160
		} catch (Exception e) {
161
			logger.error("Unable to establish connection to the User service ", e);
162
		}
163
		logger.info("Before iterating orders in file");
164
		for(Order order : orders){
165
 
9104 vikram.rag 166
			String orderId,subOrderId,create_date,ship_date = null;
9073 vikram.rag 167
			long sku;
9080 vikram.rag 168
 
9073 vikram.rag 169
			if(order.getExternalId().length()==0 || order.getOrderItemId().length()==0 ){
170
				sb.append(" Could not parse order id " + order.getExternalId()+ " " + order.getExternalId() + "\n");
171
				continue;
172
			}
173
			else{
174
				logger.info("Processing Order  " +  order.getExternalId() + " " + order.getOrderItemId());
175
				orderId = order.getExternalId();
176
				subOrderId = order.getOrderItemId();
177
			}
178
 
179
			if(order.getCreatedDate()!=null){
180
				create_date = order.getCreatedDate()+" "+order.getCreatedTime();
181
			}
182
			else{
183
				sb.append(orderId+" "+subOrderId + " Could not parse order date" +"\n");
184
				logger.info(orderId+" "+subOrderId + " Could not parse order date");
185
				continue;
186
			}
9104 vikram.rag 187
			if(order.getPickup_by_date()!=null){
188
				ship_date = order.getPickup_by_date();
189
			}
9073 vikram.rag 190
			if(order.getSku()==0L){
191
				sb.append(orderId+" "+subOrderId + " Could not parse sku" +"\n");
192
				logger.info(orderId+" "+subOrderId + " Could not parse sku");
193
				continue;
194
			}
195
			else{
196
				sku =  order.getSku();
197
				logger.info(orderId+" "+subOrderId + " Processing  sku " + sku);
198
			}
9104 vikram.rag 199
			if(order.getStatusLabel().length()!=0 && (order.getStatusLabel().equalsIgnoreCase("Approved") || order.getStatusLabel().equalsIgnoreCase("confirmed"))){
9073 vikram.rag 200
				String status = order.getStatus();	
201
			}
202
			else{
203
				if(order.getStatus().length()==0){
204
					sb.append(orderId+" "+subOrderId + " Could not parse status " + "\n");
205
					logger.info(orderId+" "+subOrderId + " Could not parse status " +"\n");
206
				}
207
				else{
208
					sb.append(orderId+" "+subOrderId + " Order not Approved" +"\n");
209
					logger.info(orderId+" "+subOrderId + " Order not Approved" +"\n");
210
				}
211
				continue;
9091 vikram.rag 212
			}
9073 vikram.rag 213
			double unitSellingPrice,shippingPrice,octroiFee,emiFee;
214
			if(order.getListPrice()!=0 ){
215
				if(order.getListPrice() > 0){
216
					unitSellingPrice =  order.getListPrice();
217
				}
218
				else{
219
					sb.append(orderId+" "+subOrderId + " Unit Price set to 0 " +"\n");
220
					logger.info(orderId+" "+subOrderId + " Unit Price set to 0 " +"\n");
221
					continue;
222
				}
223
			}
224
			else{
225
				sb.append(orderId+" "+subOrderId + " Unit Price not set " +"\n");
226
				logger.info(orderId+" "+subOrderId + " Unit Price not set " +"\n");
227
				continue;
228
			}
229
			if(order.getShippingFees() > 0){
230
				shippingPrice  =  order.getShippingFees();
231
				sb.append(orderId+" "+subOrderId + " Shipping Fee :"+ shippingPrice +"\n");
232
				logger.info(orderId+" "+subOrderId + " Shipping Fee :"+ shippingPrice +"\n");
9080 vikram.rag 233
 
9073 vikram.rag 234
			}
235
			else{
236
				shippingPrice=0;
237
			}
238
			if(order.getOctroi()!=0){
239
				octroiFee =  order.getOctroi();
240
				if(octroiFee >0){
241
					sb.append(orderId+" "+subOrderId + " OctroiFee :"+ octroiFee +"\n");
242
					logger.info(orderId+" "+subOrderId + " OctroiFee :"+ octroiFee +"\n");
243
				}
244
			}
245
			else{
246
				octroiFee=0;
247
			}
248
			if(order.getEmi()!=0){
249
				emiFee =  order.getEmi();
250
				if(emiFee >0){
251
					sb.append(orderId+" "+subOrderId + " EMI :"+ emiFee +"\n");
252
					logger.info(orderId+" "+subOrderId + " EMI :"+ emiFee +"\n");
253
				}
254
			}
255
			else{
256
				emiFee = 0;
257
			}
258
			int quantity;
259
			if(order.getQuantity()!=0){
260
				quantity = order.getQuantity();
261
				if(quantity > 1){
262
					sb.append(orderId+" "+subOrderId + " Quantity > 1 " +quantity+"\n");
263
					logger.info(orderId+" "+subOrderId + " Quantity > 1 " +quantity+"\n");
264
				}
265
				else{
266
					if(quantity==0){
267
						sb.append(orderId+" "+subOrderId + " Quantity not set " +quantity+"\n");
268
						logger.info(orderId+" "+subOrderId + " Quantity not set " +quantity+"\n");
269
						continue;
270
					}
271
				}
272
			}
273
			else{
274
				sb.append(orderId+" "+subOrderId + " Quantity not set " + "0" +"\n");
275
				logger.info(orderId+" "+subOrderId + " Quantity not set " +"0"+"\n");
276
				continue;
277
			}
278
			double totalsellingPrice; 
279
			if(order.getTotalPrice()!=0){
280
				totalsellingPrice= order.getTotalPrice();
281
				if(totalsellingPrice==0){
282
					sb.append(orderId+" "+subOrderId + " Total Selling Price set to 0 " +"\n");
283
					logger.info(orderId+" "+subOrderId + " Total Selling Price set to 0 " +"\n");
284
					continue;
285
				}
286
			}
287
			else{
288
				sb.append(orderId+" "+subOrderId + " Total Selling Price not set " +"\n");
289
				logger.info(orderId+" "+subOrderId + " Total Selling Price not set " +"\n");
290
				continue;
291
			}
292
 
293
			String shipToName,addressLine1,addressLine2,city,state,pincode,buyerName="unknown";
294
			if(order.getCustomerName().length() > 0){
295
				buyerName = order.getCustomerName();
296
			}
297
			else{
298
				sb.append(orderId+" "+subOrderId + " Buyer Name not set " +"\n");
299
				logger.info(orderId+" "+subOrderId + " Buyer Name not set " +"\n");
300
			}
301
			if(order.getShippingAddressName().length() > 0){
302
				shipToName = order.getShippingAddressName();
303
			}
304
			else{
305
				sb.append(orderId+" "+subOrderId + " Ship to Name not set " +"\n");
306
				logger.info(orderId+" "+subOrderId + " Ship to Name not set " +"\n");
307
				continue;
308
			}
309
			if(buyerName.contains("unknown")){
310
				buyerName = shipToName;
311
			}
312
			if(order.getShippingAddressLine1().length() > 0){
313
				addressLine1 = order.getShippingAddressLine1();
314
			}
315
			else{
316
				addressLine1 ="";
317
			}
318
			if(order.getShippingAddressLine2().length() > 0){
319
				addressLine2 = order.getShippingAddressLine2();
320
			}
321
			else{
322
				addressLine2 ="";
323
			}
324
			if(order.getShippingAddressCity().length()>0){
325
				city = order.getShippingAddressCity();
326
			}
327
			else{
328
				sb.append(orderId+" "+subOrderId + " City not set " +"\n");
329
				logger.info(orderId+" "+subOrderId + " City not set " +"\n");
330
				continue;
331
			}
332
			if(order.getShippingAddressState().length()>0){
333
				state = order.getShippingAddressState();
334
			}
335
			else{
336
				sb.append(orderId+" "+subOrderId + " State not set " +"\n");
337
				logger.info(orderId+" "+subOrderId + " State not set " +"\n");
338
				continue;
339
			}
340
			if(order.getShippingAddressPincode().length()>0){
341
				pincode = order.getShippingAddressPincode();
342
			}
343
			else{
344
				sb.append(orderId+" "+subOrderId + " Pincode not set " +"\n");
345
				logger.info(orderId+" "+subOrderId + " Pincode not set " +"\n");
346
				continue;
347
			}
348
			int sla; 
349
			if(order.getSla()>0){
350
				sla = order.getSla();
351
			}
352
			else{
353
				sb.append(orderId+" "+subOrderId + " Ship to date not available " +"\n");
354
				logger.info(orderId+" "+subOrderId + " Ship to date not available " +"\n");
355
				continue;
356
			}
357
			//String shipByDate = nextLine[26];
9104 vikram.rag 358
			SimpleDateFormat createDateFormatter = new SimpleDateFormat("MMM dd, yyyy hh:mm aaa");
359
			SimpleDateFormat shipDateFormatter = new SimpleDateFormat("MMM dd, yyyy");
360
			Date flipkartTxnDate = null;
361
			Date shipByDate = null;
362
			try {
363
				flipkartTxnDate = createDateFormatter.parse(create_date);
364
			} catch (ParseException e) {
365
				logger.error(orderId+" "+subOrderId + " Could not parse flipkart order date from file " , e);
366
				sb.append(orderId+" "+subOrderId + " Could not parse order date" +"\n");
367
				continue;
368
			}
369
			if(ship_date!=null){
370
				try {
371
					shipByDate = shipDateFormatter.parse(ship_date);
372
				} catch (ParseException e) {
373
					logger.error(orderId+" "+subOrderId + " ship date " , e);
9112 vikram.rag 374
					sb.append(orderId+" "+subOrderId + "cannot parse ship date" +"\n");
9104 vikram.rag 375
					continue;
376
				}
377
			}
9073 vikram.rag 378
			Client transaction_client = null;
379
			try {
380
				transaction_client = new TransactionClient().getClient();
381
				if(transaction_client.flipkartOrderExists(orderId,subOrderId)) {
9104 vikram.rag 382
					if(shipByDate!=null && order.getTrackingId()!=null){
383
						transaction_client.updateFlipkartOrderDatesAndAWB(orderId, subOrderId, shipByDate.getTime(), order.getTrackingId());
9125 vikram.rag 384
						logger.error("Order exists updating info " + "id : " + orderId + " suborder id : " + subOrderId);
385
						sb.append("Order exists updating info " + orderId+" "+subOrderId+"\n");
9111 vikram.rag 386
 
9104 vikram.rag 387
					}
9111 vikram.rag 388
					else{
389
						logger.error("Flipkart order exists " + "id : " + orderId + " suborder id : " + subOrderId);
390
						sb.append("Flipkart order exists " + orderId+" "+subOrderId+"\n");
391
					}
9073 vikram.rag 392
					continue;
393
				}
394
 
395
			} catch (TTransportException e1) {
396
				logger.error("Problem with Transaction service " , e1);
397
				e1.printStackTrace();
398
			} catch (TException e) {
399
				logger.error("Problem.. thrift exception with Transaction service " , e);
400
				e.printStackTrace();
401
			}
402
			Transaction txn = new Transaction();
403
			txn.setShoppingCartid(user.getActiveCartId());
404
			txn.setCustomer_id(user.getUserId());
405
			System.out.println("User Id is " + user.getUserId());
406
			txn.setCreatedOn(new Date().getTime());
407
			txn.setTransactionStatus(TransactionStatus.INIT);
408
			txn.setStatusDescription("Order for flipkart ");
409
			List<in.shop2020.model.v1.order.Order> orderlist = new ArrayList<in.shop2020.model.v1.order.Order>();
410
			double total_price=0;
411
			InventoryService.Client inventoryClient = null;
412
			Warehouse fulfillmentWarehouse= null;
413
			boolean exit = false;
414
			for(int i=0;i<quantity;i++){
415
				LineItem lineItem = null;
416
				lineItem = createLineItem(sku,unitSellingPrice);
417
				logger.info(orderId+" "+subOrderId + "sku and Price " + sku + " " + unitSellingPrice);
418
				lineItem.setExtra_info("flipkartOrderId = " + orderId + " flipkartsubOrderId = " + subOrderId);
419
				in.shop2020.model.v1.order.Order t_order = new in.shop2020.model.v1.order.Order();
420
				t_order.setCustomer_id(user.getUserId());
421
				t_order.setCustomer_email(sourceDetail.getEmail());
422
				t_order.setCustomer_name(shipToName);
423
				t_order.setCustomer_address1(addressLine1);
424
				t_order.setCustomer_address2(addressLine2);
425
				t_order.setCustomer_city(city);
426
				t_order.setCustomer_state(state);
427
				t_order.setCustomer_pincode(pincode);
428
				t_order.setTotal_amount(unitSellingPrice);            
429
				t_order.setTotal_weight(lineItem.getTotal_weight());
430
				t_order.setLineitems(Collections.singletonList(lineItem));            
431
				t_order.setStatus(OrderStatus.PAYMENT_PENDING);
432
				t_order.setStatusDescription("In Process");
433
				t_order.setCreated_timestamp(new Date().getTime());
434
				t_order.setOrderType(OrderType.B2C);
435
				t_order.setCod(false);
9104 vikram.rag 436
				if(shipByDate!=null){
437
					t_order.setPromised_shipping_time(shipByDate.getTime());
438
					t_order.setExpected_shipping_time(shipByDate.getTime());
439
					t_order.setPromised_delivery_time(shipByDate.getTime()+ 4*24*60*60);
440
					t_order.setExpected_delivery_time(shipByDate.getTime()+ 4*24*60*60);
9073 vikram.rag 441
				}
9104 vikram.rag 442
				else{
443
					try {
444
						Date shipDate = new Date();
445
						shipDate.setTime( flipkartTxnDate.getTime() + sla*24*60*60*1000);
446
						Calendar time = Calendar.getInstance();
447
						t_order.setPromised_shipping_time(shipDate.getTime());
448
						t_order.setExpected_shipping_time(shipDate.getTime());
449
						time.add(Calendar.DAY_OF_MONTH, 4);
450
						t_order.setPromised_delivery_time(time.getTimeInMillis());
451
						t_order.setExpected_delivery_time(time.getTimeInMillis());
452
					} catch(Exception e) {	
453
						logger.error("Error in updating Shipping or Delivery Time for suborderid  " + subOrderId);
454
						sb.append(orderId + " "+ subOrderId  + " Could not update delivery time" + " " + "\n");
455
						exit = true;
456
						continue;
457
					}
458
				}
9073 vikram.rag 459
				SnapdealItem snapdealItem = new CatalogClient().getClient().getSnapdealItem(sku);
460
				inventoryClient = new InventoryClient().getClient();
461
				try {
462
					logger.info("Snapdeal Item id is " + snapdealItem.getItem_id());
463
					if(snapdealItem.getItem_id()!=0 && snapdealItem.getWarehouseId()!=0) {
464
						logger.info("SnapdealItem Warehouse Id " + snapdealItem.getWarehouseId());
465
						fulfillmentWarehouse = inventoryClient.getWarehouse(snapdealItem.getWarehouseId());
466
						logger.info("fulfillmentWarehouse is " + fulfillmentWarehouse.getId() + " " + fulfillmentWarehouse.getDisplayName() );
467
 
468
					} else {
469
						List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(sku, 1);
470
						fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
471
						if(fulfillmentWarehouse.getStateId()!=0){
472
							fulfillmentWarehouse = inventoryClient.getWarehouse(7);
473
						}
474
					}
475
					t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
476
					long billingWarehouseId = 0;
477
					if(fulfillmentWarehouse.getBillingWarehouseId()== 0) {
478
						inventoryClient = new InventoryClient().getClient();
479
						List<Warehouse> warehouses = inventoryClient.getWarehouses(WarehouseType.OURS, InventoryType.GOOD, fulfillmentWarehouse.getVendor().getId(), 0, 0);
480
						for(Warehouse warehouse : warehouses) {
481
							if(warehouse.getBillingWarehouseId()!=0) {
482
								billingWarehouseId = warehouse.getBillingWarehouseId();
483
								break;
484
							}
485
						}
486
					}else {
487
						billingWarehouseId = fulfillmentWarehouse.getBillingWarehouseId();
488
					}
489
 
490
					//logger.info("Billing warehouse id for suborderid  " + order.getSuborderId() + " is " + fulfillmentWarehouse.getBillingWarehouseId());
491
					t_order.setWarehouse_id(billingWarehouseId);
492
					VendorItemPricing vendorItemPricing = new VendorItemPricing();
493
					if(fulfillmentWarehouse.getId()==7) {
494
						Item item = new CatalogClient().getClient().getItem(lineItem.getItem_id());
495
						vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
496
					} else {
497
						vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
498
					}
499
 
500
					t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
501
					t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
502
				} catch (InventoryServiceException e) {
503
					logger.error("Error connecting inventory service for suborderid  " + orderId + " " + subOrderId , e);
504
					sb.append(orderId + " " + subOrderId+ " Inventory Service Exception" + " " + "\n");
505
					exit = true;
506
					continue;
507
				} catch (TTransportException e) {
508
					logger.error("Transport Exception with Inventory Service for suborderid  " + orderId + " " + subOrderId , e);
509
					sb.append(orderId + " " + subOrderId + " Transport Exception with Inventory Service" + " " + "\n");
510
					exit = true;
511
					continue;
512
				} catch (TException e) {
513
					logger.error("Exception with Inventory Service for suborderid  " + orderId + " " + subOrderId , e);
514
					sb.append(orderId + " " + subOrderId + " Exception in Inventory Service" + " " + "\n");
515
					exit = true;
516
					continue;
517
				} catch (CatalogServiceException e) {
518
					logger.error("Exception with Catalog Service for   " + orderId + " " + subOrderId + " while getting item " + lineItem.getItem_id(), e);
519
					sb.append(orderId + " " + subOrderId + " Exception in Catalog Service" + " " + "\n");
520
					exit = true;
521
					continue;
522
				}
523
				t_order.setLogistics_provider_id(FLIPKART_LOGISTICS_ID);
524
				t_order.setAirwaybill_no("");
525
				t_order.setTracking_id("");
526
				t_order.setTotal_amount(unitSellingPrice);
527
				t_order.setOrderType(OrderType.B2C);
528
				t_order.setSource(FLIPKART_SOURCE_ID);
529
				t_order.setOrderType(OrderType.B2C);
530
				total_price = total_price + unitSellingPrice;
531
				orderlist.add(t_order);
532
			}
533
			if(exit){
534
				continue;
535
			}
536
			txn.setOrders(orderlist);
537
			try {
9196 vikram.rag 538
				transaction_client = new TransactionClient().getClient();
539
				transactionId =  String.valueOf(transaction_client.createTransaction(txn));
9073 vikram.rag 540
				logger.info("Transaction id is : " + transactionId);
541
			} catch (TransactionServiceException e) {
542
				logger.error(orderId+" "+subOrderId + " Could not create transaction " , e);
543
				sb.append(orderId+" "+subOrderId + " Could not create transaction" +"\n");
544
				continue;
545
			} catch (TException e) {
546
				sb.append(orderId+" "+subOrderId + " Transaction Service Exception could not create transaction" +"\n");
9084 vikram.rag 547
				logger.info(orderId+" "+subOrderId + " Transaction Service Exception could not create transaction" +"\n" , e);
9073 vikram.rag 548
				continue;
549
			}
550
			try{
9089 vikram.rag 551
				logger.info("Creating payment for suborder id " + subOrderId +" ");
9091 vikram.rag 552
				createPayment(user,subOrderId,total_price);
9073 vikram.rag 553
			}
554
			catch (NumberFormatException e) {
555
				logger.error("Could not create payment",e);
556
				sb.append(orderId+" "+subOrderId + " Could not create payment");
557
				e.printStackTrace();
558
				continue;
559
			} catch (PaymentException e) {
560
				logger.error("Could not create payment payment exception",e);
561
				sb.append(orderId+" "+subOrderId + " Could not create payment Payment exception");
562
				e.printStackTrace();
563
				continue;
564
			} catch (TException e) {
565
				logger.error("Could not create payment thrift exception",e);
566
				sb.append(orderId+" "+subOrderId + " Could not create payment Thrift exception");
567
				e.printStackTrace();
568
				continue;
569
			}
570
			Transaction transaction = null;
571
			try {
9196 vikram.rag 572
				transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
9073 vikram.rag 573
			} catch (NumberFormatException e) {
9089 vikram.rag 574
				logger.error("Problem parsing transaction id " + transactionId +" ", e);
9073 vikram.rag 575
				sb.append(orderId+" "+subOrderId  + " Problem parsing transaction id "+ transactionId +"\n");
576
				e.printStackTrace();
577
				continue;
578
			} catch (TransactionServiceException e) {
9089 vikram.rag 579
				logger.error("Problem getting transaction from service transaction id " + transactionId +" ",e);
9073 vikram.rag 580
				sb.append(orderId+" "+subOrderId  + " Problem getting transaction id "+ transactionId +"\n");
581
				e.printStackTrace();
582
				continue;
583
			} catch (TException e) {
9089 vikram.rag 584
				logger.error("Problem with transaction service while getting transaction id " + transactionId + " " , e);
9073 vikram.rag 585
				sb.append(orderId+" "+subOrderId + " Problem with transaction service while getting transaction id "+ transactionId +"\n");
586
				e.printStackTrace();
587
				continue;
588
			}
589
			List<in.shop2020.model.v1.order.Order> flipkartorders = transaction.getOrders();
590
			for(in.shop2020.model.v1.order.Order flipkartorder:flipkartorders){
591
				try {
592
					List<in.shop2020.model.v1.order.Attribute> attributeList = new ArrayList<in.shop2020.model.v1.order.Attribute>();
593
					inventoryClient.reserveItemInWarehouse(flipkartorder.getLineitems().get(0).getItem_id(), fulfillmentWarehouse.getId(), 1, 
594
							flipkartorder.getId(), flipkartorder.getCreated_timestamp(), flipkartorder.getPromised_shipping_time(), flipkartorder.getLineitems().get(0).getQuantity());
595
					FlipkartOrder flipkartOrder = new FlipkartOrder();
596
					flipkartOrder.setOrderId(flipkartorder.getId());
597
					flipkartOrder.setFlipkartOrderId(orderId);
598
					flipkartOrder.setFlipkartSubOrderId(subOrderId);
599
					flipkartOrder.setFlipkartTxnDate(flipkartTxnDate.getTime());
600
					flipkartOrder.setEmiFee(emiFee);
601
					flipkartOrder.setOctroiFee(octroiFee);
602
					flipkartOrder.setShippingPrice(shippingPrice);
603
					in.shop2020.model.v1.order.Attribute attribute = new in.shop2020.model.v1.order.Attribute();
604
					attribute.setName("Buyer Name");
605
					attribute.setValue(buyerName);
606
					attributeList.add(attribute);
607
					try {
9194 vikram.rag 608
						if(transaction_client == null){
609
							transaction_client = new TransactionClient().getClient();
610
						}
9191 vikram.rag 611
						transaction_client.createFlipkartOrder(flipkartOrder);
612
						transaction_client.setOrderAttributes(flipkartOrder.getOrderId(),attributeList);
9073 vikram.rag 613
						orders_processed++;
614
					} catch (TException e) {
9089 vikram.rag 615
						logger.error("Could not create flipkart order ",e);
9073 vikram.rag 616
						sb.append(orderId+" "+subOrderId + " Could not create flipkart order"+"\n");
617
						continue;
618
					}
619
 
620
				} catch (InventoryServiceException e1) {
9089 vikram.rag 621
					logger.error("Problem while reserving item in inventory service" + flipkartorder.getId() + " ",e1);
9073 vikram.rag 622
					sb.append(orderId+" "+subOrderId + " Could not reserve inventory for sku "+ sku +"\n");
623
					continue;
624
				} catch (TException e1) {
9089 vikram.rag 625
					logger.error("Problem with inventory service" + flipkartorder.getId()+" ",e1);
9073 vikram.rag 626
					sb.append(orderId+" "+subOrderId + " Problem with inventory service while reserving inventory for sku "+ sku +"\n");
627
					continue;
628
				}
629
			}
630
		}
631
 
632
		if(orders_processed==1){
633
			order_string = "Order";
634
		}
635
		else{
636
			order_string = "Orders";
637
		}
9091 vikram.rag 638
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
9077 vikram.rag 639
		Calendar cal=GregorianCalendar.getInstance();
640
		String emailFromAddress = "build@shop2020.in";
641
		String password = "cafe@nes";
642
		GmailUtils mailer = new GmailUtils();
9197 vikram.rag 643
		String sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
644
		/*String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
9077 vikram.rag 645
				"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
646
				"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in","amar.kumar@shop2020.in"};
9197 vikram.rag 647
		*/try {
9097 vikram.rag 648
			logger.info("Before Sending Emails");
9073 vikram.rag 649
 
9097 vikram.rag 650
			if(sb.toString().equalsIgnoreCase("")){
651
				if(orders_processed!=0){
652
					String emailSubjectTxt = orders_processed + " Flipkart " + order_string + " Created "+sdf.format(cal.getTime());
653
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,"Orders Created Successfully (No Alerts)", emailFromAddress, password, new ArrayList<File>());
654
					logger.info("Sending Email Flipkart Orders Created Successfully (No Alerts)");
655
				}
656
				else{
657
					String emailSubjectTxt = "No new orders created "+sdf.format(cal.getTime());
658
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,"No new orders created", emailFromAddress, password, new ArrayList<File>());
659
					logger.info("Sending Email Flipkart Orders Created Successfully (No Alerts)");
660
				}
661
			}
662
			else{
663
				if(orders_processed!=0){
664
					String emailSubjectTxt = orders_processed + " Flipkart " + order_string + " Created (Check Alerts) "+sdf.format(cal.getTime());
665
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,sb.toString(), emailFromAddress, password, new ArrayList<File>());
666
					logger.info("Sending Email Flipkart Orders Created Successfully (Check Alerts)");
667
				}
668
				else{
669
					String emailSubjectTxt = "No new Flipkart orders created "+sdf.format(cal.getTime());
670
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,sb.toString(), emailFromAddress, password, new ArrayList<File>());
671
					logger.info("Sending Email Flipkart Orders Created Successfully (Check Alerts)");
672
				}
673
			}
674
		}
675
		catch (Exception e) {
676
			e.printStackTrace();
677
			logger.error("Exception ",e);
678
		}
9077 vikram.rag 679
 
9073 vikram.rag 680
	}
681
 
682
	public static LineItem createLineItem(long itemId, double amount) throws CatalogServiceException, TException {
683
		LineItem lineItem = new LineItem();
684
		CatalogService.Client catalogClient = new CatalogClient().getClient();
685
		Item item = catalogClient.getItem(itemId);
686
		if(item.getId()==0){
687
			//in case item id is incorrect..
688
			return null;
689
		}
690
 
691
		lineItem.setProductGroup(item.getProductGroup());
692
		lineItem.setBrand(item.getBrand());
693
		lineItem.setModel_number(item.getModelNumber());
694
		lineItem.setModel_name(item.getModelName());
695
		lineItem.setExtra_info(item.getFeatureDescription());
696
		lineItem.setQuantity(1);
697
		lineItem.setItem_id(item.getId());
698
		lineItem.setUnit_weight(item.getWeight());
699
		lineItem.setTotal_weight(item.getWeight());
700
		lineItem.setUnit_price(amount);
701
		lineItem.setTotal_price(amount);
702
 
703
		if (item.getColor() == null || "NA".equals(item.getColor())) {
704
			lineItem.setColor("");
705
		} else {
706
			lineItem.setColor(item.getColor());
707
		}
708
		return lineItem;
709
	}
710
	public static void createPayment(User user, String subOrderId, double amount) throws PaymentException, TException {
711
		in.shop2020.payments.PaymentService.Client client = new PaymentClient().getClient();
712
		logger.info("Creating payment for user id " + user.getUserId() + " Gateway id " + FLIPKART_GATEWAY_ID);
713
		logger.info("Long value of transaction id : " + Long.valueOf(transactionId));
714
		long paymentId = client.createPayment(user.getUserId(), amount, FLIPKART_GATEWAY_ID, Long.valueOf(transactionId), false);
715
		logger.info("transaction id : " + Long.valueOf(transactionId) + " Payment id : " + paymentId);
716
		client.updatePaymentDetails(paymentId, null, null, null, null, null, null, subOrderId, null, PaymentStatus.AUTHORIZED, null, null);
717
	}   
718
 
719
 
720
 
721
}