Subversion Repositories SmartDukaan

Rev

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