Subversion Repositories SmartDukaan

Rev

Rev 12869 | Rev 12974 | 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"));
12840 manish.sha 82 
			//post.addHeader("Cookie","T=TI141147280750274359991498309202525657388536723248248488328249492067; __sonar=16983180403917152637; __gads=ID=c15eba68f7f44861:T=1411472817:S=ALNI_MYyU0QfJ923BqkcDhqFlRpZxMcA8w; cmp_id=hp_dotd_4_DOTDOnBajajMixerGrinder_Sep23.|1414064820638; S=d1t16GpsIdt0JTsYuFF%2FMaE7jTGYozxMXM5a3ktJD24TBohceobkUv8l4GDr4KNLkLs5BOgnhsqkZNQRh2Lzrx%2B77zQ%3D%3D; km_lv=x; __utma=19769839.1065606807.1411472808.1411472808.1411624009.2; __utmc=19769839; __utmz=19769839.1411472808.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); s_cc=true; s_sq=%5B%5BB%5D%5D; prd_day=2|1411645620637; s_ppv=21; SN=2.VI89D3B4F7B5534B3C9EADE3BBD925875A.SI05ED43E07EAF40E9B4F265F5F2B1074D.VS141162400679268773093.1411624676; VID=2.VI89D3B4F7B5534B3C9EADE3BBD925875A.1411624676.VS141162400679268773093; NSID=2.SI05ED43E07EAF40E9B4F265F5F2B1074D.1411624676.VI89D3B4F7B5534B3C9EADE3BBD925875A; connect.sid=s%3AaUlfUN00goYPkqRHXtAbM6Nh.EBDDk9%2F0rQDXGb%2B23IEJ4QgrAgKFpXU%2FLOjuQyxJo44; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1617147053.1411568832.1411568832.1411624688.2; __utmb=143439159.17.10.1411624688; __utmc=143439159; __utmz=143439159.1411568832.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1617147053.1411568832; _gat=1; kvcd=1411627978463; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
83 
			post.addHeader("Cookie","T=TI138130450866706710769873257251497444628820234222703981199700765991; __gads=ID=dfe0374cf04d1576:T=1381304511:S=ALNI_Ma2TpDrlF9_amkoqp3MOYJBaFAOUg; km_lv=x; __sonar=6631097455123118581; aid=hza%2BEupBpLdvNfHSTTVkzPDeZavQVl0jiaoxm60MwkPxf6e9zXq1Ho9iF8zyzcFU; __isReg=true; S=d1t12jFfBeu92qxIHRlvZT9LAVzb3n%2B79fEDwno5E%2FvZDEo1Syw0WInkl26DP7Ao0ZahzYI9eBXeTU%2BPOKG2zwpIPkQ%3D%3D; __utmt=1; _ga=GA1.2.1156779613.1390806906; _gat=1; kvcd=1412575659852; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=; connect.sid=s%3AROrSG%2B0P6rMMe25YVYJIppNR.kkwR0eSSBtvtMPMrWOTmUvld80bIIbEXhtH52qM5hSA; __utma=19769839.1733153395.1408690721.1412567812.1412571695.8; __utmb=19769839.123.9.1412574409958; __utmc=19769839; __utmz=19769839.1409028689.3.2.utmcsr=savemoneyindia.com|utmccn=(referral)|utmcmd=referral|utmcct=/; s_cc=true; gpv_pn=FozPage; gpv_pn_t=no%20value; s_sq=%5B%5BB%5D%5D; pincode=201301; Tkt=7e3de311; SN=2.VI4876EB87B4D54359BF5BDC59495E6FAC.SI6012869365F2495BA20E3841985048BE.VS141257169849670393137.1412575884; VID=2.VI4876EB87B4D54359BF5BDC59495E6FAC.1412575884.VS141257169849670393137; NSID=2.SI6012869365F2495BA20E3841985048BE.1412575884.VI4876EB87B4D54359BF5BDC59495E6FAC; __utma=143439159.1156779613.1390806906.1411920280.1412575623.29; __utmb=143439159.6.10.1412575623; __utmc=143439159; __utmz=143439159.1390806906.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); s_ppv=28");
12755 manish.sha 84 
			post.addHeader("User-agent", "Mozilla/4.0");
85 
			post.addHeader("Referer", "seller.flipkart.com");
9075 vikram.rag 86 
			post.setEntity(new UrlEncodedFormEntity(nameValuePairs,"utf-8"));
9073 vikram.rag 87 
			HttpResponse response = client.execute(post);
88 
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
89 
			String line = "";
9102 vikram.rag 90 
			Gson gson;
91 
			List<Order> orders = new ArrayList<Order>();
92 
			OrderItems new_orders;
93 
			OrderItems conf_orders;
94 
			HttpGet get_new;
95 
			HttpGet get_conf;
96 
			long time;
97 
			int i=1;
9073 vikram.rag 98 
			while ((line = rd.readLine()) != null) {
99 
				System.out.println(line);
100 
			}
9102 vikram.rag 101 
			time = System.currentTimeMillis();
102 
			while(true){
103 
				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);
12840 manish.sha 104 
				//get_new.addHeader("Cookie","T=TI141147280750274359991498309202525657388536723248248488328249492067; __sonar=16983180403917152637; __gads=ID=c15eba68f7f44861:T=1411472817:S=ALNI_MYyU0QfJ923BqkcDhqFlRpZxMcA8w; cmp_id=hp_dotd_4_DOTDOnBajajMixerGrinder_Sep23.|1414064820638; S=d1t16GpsIdt0JTsYuFF%2FMaE7jTGYozxMXM5a3ktJD24TBohceobkUv8l4GDr4KNLkLs5BOgnhsqkZNQRh2Lzrx%2B77zQ%3D%3D; km_lv=x; __utma=19769839.1065606807.1411472808.1411472808.1411624009.2; __utmc=19769839; __utmz=19769839.1411472808.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); s_cc=true; s_sq=%5B%5BB%5D%5D; prd_day=2|1411645620637; s_ppv=21; SN=2.VI89D3B4F7B5534B3C9EADE3BBD925875A.SI05ED43E07EAF40E9B4F265F5F2B1074D.VS141162400679268773093.1411624676; VID=2.VI89D3B4F7B5534B3C9EADE3BBD925875A.1411624676.VS141162400679268773093; NSID=2.SI05ED43E07EAF40E9B4F265F5F2B1074D.1411624676.VI89D3B4F7B5534B3C9EADE3BBD925875A; connect.sid=s%3AaUlfUN00goYPkqRHXtAbM6Nh.EBDDk9%2F0rQDXGb%2B23IEJ4QgrAgKFpXU%2FLOjuQyxJo44; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1617147053.1411568832.1411568832.1411624688.2; __utmb=143439159.17.10.1411624688; __utmc=143439159; __utmz=143439159.1411568832.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1617147053.1411568832; _gat=1; kvcd=1411627978463; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
105 
				get_new.addHeader("Cookie","T=TI138130450866706710769873257251497444628820234222703981199700765991; __gads=ID=dfe0374cf04d1576:T=1381304511:S=ALNI_Ma2TpDrlF9_amkoqp3MOYJBaFAOUg; km_lv=x; __sonar=6631097455123118581; aid=hza%2BEupBpLdvNfHSTTVkzPDeZavQVl0jiaoxm60MwkPxf6e9zXq1Ho9iF8zyzcFU; __isReg=true; S=d1t12jFfBeu92qxIHRlvZT9LAVzb3n%2B79fEDwno5E%2FvZDEo1Syw0WInkl26DP7Ao0ZahzYI9eBXeTU%2BPOKG2zwpIPkQ%3D%3D; __utma=19769839.1733153395.1408690721.1412567812.1412571695.8; __utmb=19769839.210.9.1412578093111; __utmc=19769839; __utmz=19769839.1409028689.3.2.utmcsr=savemoneyindia.com|utmccn=(referral)|utmcmd=referral|utmcct=/; s_cc=true; gpv_pn=FozPage; gpv_pn_t=no%20value; s_sq=%5B%5BB%5D%5D; pincode=110001; s_ppv=61; SN=2.VI4876EB87B4D54359BF5BDC59495E6FAC.SI6012869365F2495BA20E3841985048BE.VS141257169849670393137.1412582357; VID=2.VI4876EB87B4D54359BF5BDC59495E6FAC.1412582357.VS141257169849670393137; NSID=2.SI6012869365F2495BA20E3841985048BE.1412582357.VI4876EB87B4D54359BF5BDC59495E6FAC; __utmt=1; connect.sid=s%3AWwlGdtrLzj38cMjvZPI6ib5J.YUhinXC189untGw58i2CE9k7BGgKQJs9L%2BVIYPIW9Ok; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1156779613.1390806906.1412575623.1412581840.30; __utmb=143439159.7.9.1412582883309; __utmc=143439159; __utmz=143439159.1390806906.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1156779613.1390806906; kvcd=1412583087629; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
106 
				/*get_new.addHeader("User-agent", "Mozilla/4.0");
107 
				get_new.addHeader("Referer", "https://seller.flipkart.com/dashboard");*/
108 
 
9102 vikram.rag 109 
				response = client.execute(get_new);
110 
				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
111 
				line = "";
112 
				gson = new Gson();
113 
				new_orders = (OrderItems) gson.fromJson(rd, OrderItems.class);
114 
				if(new_orders.getOrder_items().size()>0){
115 
					orders.addAll(new_orders.getOrder_items());
116 
				}
117 
				else{
118 
					break;
119 
				}
120 
				i++;
121 
			}
122 
			i=1;
123 
			time = System.currentTimeMillis();
124 
			while(true){
125 
				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);
12840 manish.sha 126 
				//get_conf.addHeader("Cookie","T=TI141147280750274359991498309202525657388536723248248488328249492067; __sonar=16983180403917152637; __gads=ID=c15eba68f7f44861:T=1411472817:S=ALNI_MYyU0QfJ923BqkcDhqFlRpZxMcA8w; cmp_id=hp_dotd_4_DOTDOnBajajMixerGrinder_Sep23.|1414064820638; S=d1t16GpsIdt0JTsYuFF%2FMaE7jTGYozxMXM5a3ktJD24TBohceobkUv8l4GDr4KNLkLs5BOgnhsqkZNQRh2Lzrx%2B77zQ%3D%3D; km_lv=x; __utma=19769839.1065606807.1411472808.1411472808.1411624009.2; __utmc=19769839; __utmz=19769839.1411472808.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); s_cc=true; s_sq=%5B%5BB%5D%5D; prd_day=2|1411645620637; s_ppv=21; SN=2.VI89D3B4F7B5534B3C9EADE3BBD925875A.SI05ED43E07EAF40E9B4F265F5F2B1074D.VS141162400679268773093.1411624676; VID=2.VI89D3B4F7B5534B3C9EADE3BBD925875A.1411624676.VS141162400679268773093; NSID=2.SI05ED43E07EAF40E9B4F265F5F2B1074D.1411624676.VI89D3B4F7B5534B3C9EADE3BBD925875A; connect.sid=s%3AaUlfUN00goYPkqRHXtAbM6Nh.EBDDk9%2F0rQDXGb%2B23IEJ4QgrAgKFpXU%2FLOjuQyxJo44; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1617147053.1411568832.1411568832.1411624688.2; __utmb=143439159.17.10.1411624688; __utmc=143439159; __utmz=143439159.1411568832.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1617147053.1411568832; _gat=1; kvcd=1411627978463; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
127 
				get_conf.addHeader("Cookie","T=TI138130450866706710769873257251497444628820234222703981199700765991; __gads=ID=dfe0374cf04d1576:T=1381304511:S=ALNI_Ma2TpDrlF9_amkoqp3MOYJBaFAOUg; km_lv=x; __sonar=6631097455123118581; aid=hza%2BEupBpLdvNfHSTTVkzPDeZavQVl0jiaoxm60MwkPxf6e9zXq1Ho9iF8zyzcFU; __isReg=true; S=d1t12jFfBeu92qxIHRlvZT9LAVzb3n%2B79fEDwno5E%2FvZDEo1Syw0WInkl26DP7Ao0ZahzYI9eBXeTU%2BPOKG2zwpIPkQ%3D%3D; __utma=19769839.1733153395.1408690721.1412567812.1412571695.8; __utmb=19769839.210.9.1412578093111; __utmc=19769839; __utmz=19769839.1409028689.3.2.utmcsr=savemoneyindia.com|utmccn=(referral)|utmcmd=referral|utmcct=/; s_cc=true; gpv_pn=FozPage; gpv_pn_t=no%20value; s_sq=%5B%5BB%5D%5D; pincode=110001; s_ppv=61; SN=2.VI4876EB87B4D54359BF5BDC59495E6FAC.SI6012869365F2495BA20E3841985048BE.VS141257169849670393137.1412582357; VID=2.VI4876EB87B4D54359BF5BDC59495E6FAC.1412582357.VS141257169849670393137; NSID=2.SI6012869365F2495BA20E3841985048BE.1412582357.VI4876EB87B4D54359BF5BDC59495E6FAC; __utmt=1; connect.sid=s%3AWwlGdtrLzj38cMjvZPI6ib5J.YUhinXC189untGw58i2CE9k7BGgKQJs9L%2BVIYPIW9Ok; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1156779613.1390806906.1412575623.1412581840.30; __utmb=143439159.7.9.1412582883309; __utmc=143439159; __utmz=143439159.1390806906.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1156779613.1390806906; kvcd=1412583087629; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
9102 vikram.rag 128 
				response = client.execute(get_conf);
129 
				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
130 
				line = "";
131 
				gson = new Gson();
132 
				conf_orders = (OrderItems) gson.fromJson(rd, OrderItems.class);
133 
				if(conf_orders.getOrder_items().size()>0){
134 
					orders.addAll(conf_orders.getOrder_items());
135 
				}
136 
				else{
137 
					break;
138 
				}
139 
				i++;
140 
			}
9104 vikram.rag 141 
			for(Order order:orders){
142 
				System.out.println("Order  " + order.getExternalId() +" "+order.getOrderItemId() + " : "+ order.getStatus() + " "+order.getStatusDateMessage() + " "
143 
						+ order.getStatusLabel() + " " + order.getPickup_by_date() + " "+ order.getTrackingId());
12589 manish.sha 144 
				/*if(order.getFreebie_items()!=null && order.getFreebie_items().size()>0){
145 
					System.out.println("Freebie Item ID :"+order.getFreebie_items().get(0).getSku());
146 
				}*/
9104 vikram.rag 147 
			}
9116 vikram.rag 148 
			processOrders(orders);
9096 vikram.rag 149 
		} catch (IOException e) {
9073 vikram.rag 150 
			e.printStackTrace();
151 
		}
152 
	}
153 
 
154 
	public static void processOrders(List<Order> orders) throws IOException, CatalogServiceException, TException{
155 
		logger.info("Before Processing orders ");
156 
		StringBuffer sb = new StringBuffer();
157 
		String order_string = "";
158 
		User user = null;
159 
		TransactionClient tsc = null;
160 
		SourceDetail sourceDetail = null;
161 
		logger.info("Before Fetching sourcedetail");
162 
		try {
163 
			tsc = new TransactionClient();
164 
			sourceDetail = tsc.getClient().getSourceDetail(FLIPKART_SOURCE_ID);
165 
			logger.info("Flipkart sourcedetail " + sourceDetail.getEmail() + " " + sourceDetail.getName());
166 
		} catch (Exception e) {
167 
			logger.error("Unable to establish connection to the transaction service while getting Flipkart Source Detail ", e);
168 
		}
169 
		try {
170 
			in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
171 
			logger.info("Before Fetching User by Email");
172 
			user = userClient.getUserByEmail(sourceDetail.getEmail());
173 
			logger.info("User is " + user.getEmail());
174 
		} catch (Exception e) {
175 
			logger.error("Unable to establish connection to the User service ", e);
176 
		}
177 
		logger.info("Before iterating orders in file");
10140 vikram.rag 178 
		FlipkartItem flipkartItem;
179 
		String orderId,subOrderId,create_date,ship_date = null,skuAtFlipkart;
180 
		long sku = 0;
10975 vikram.rag 181 
		int total_orders = 0;
182 
		int duplicate_orders = 0;
183 
		int orders_processed = 0;
12869 manish.sha 184 
		int fa_orders = 0;
10979 vikram.rag 185 
		int not_approved = 0;
9073 vikram.rag 186 
		for(Order order : orders){
12589 manish.sha 187 
			String status = "";
188 
			boolean isHold = false;
10975 vikram.rag 189 
			total_orders++;
9073 vikram.rag 190 
			if(order.getExternalId().length()==0 || order.getOrderItemId().length()==0 ){
191 
				sb.append(" Could not parse order id " + order.getExternalId()+ " " + order.getExternalId() + "\n");
192 
				continue;
193 
			}
194 
			else{
195 
				logger.info("Processing Order  " +  order.getExternalId() + " " + order.getOrderItemId());
196 
				orderId = order.getExternalId();
197 
				subOrderId = order.getOrderItemId();
198 
			}
199 
 
200 
			if(order.getCreatedDate()!=null){
201 
				create_date = order.getCreatedDate()+" "+order.getCreatedTime();
202 
			}
203 
			else{
204 
				sb.append(orderId+" "+subOrderId + " Could not parse order date" +"\n");
205 
				logger.info(orderId+" "+subOrderId + " Could not parse order date");
206 
				continue;
207 
			}
12589 manish.sha 208 
 
209 
			if(order.getService_profile()!=null && "NON_FBF".equalsIgnoreCase(order.getService_profile())){
210 
				String fulfillByUs = order.getService_profile();
211 
			} else {
12869 manish.sha 212 
				fa_orders++;
12589 manish.sha 213 
				continue;
214 
			}
9104 vikram.rag 215 
			if(order.getPickup_by_date()!=null){
216 
				ship_date = order.getPickup_by_date();
217 
			}
10140 vikram.rag 218 
			if(order.getSku().equals("")){
9073 vikram.rag 219 
				sb.append(orderId+" "+subOrderId + " Could not parse sku" +"\n");
220 
				logger.info(orderId+" "+subOrderId + " Could not parse sku");
221 
				continue;
222 
			}
223 
			else{
10140 vikram.rag 224 
				skuAtFlipkart =  order.getSku();
225 
				logger.info(orderId+" "+subOrderId + " Processing  sku " + skuAtFlipkart);
9073 vikram.rag 226 
			}
12589 manish.sha 227 
			if(order.getStatusLabel().length()!=0 && (order.getStatusLabel().equalsIgnoreCase("Approved") || order.getStatusLabel().equalsIgnoreCase("On hold") || order.getStatusLabel().equalsIgnoreCase("confirmed"))){
228 
				status = order.getStatus();
229 
				if("on_hold".equalsIgnoreCase(status)){
230 
					isHold = true;
231 
				}
9073 vikram.rag 232 
			}
233 
			else{
12589 manish.sha 234 
				sb.append(orderId+" "+subOrderId + " Could not parse status " + "\n");
235 
				logger.info(orderId+" "+subOrderId + " Could not parse status " +"\n");
9073 vikram.rag 236 
				continue;
9091 vikram.rag 237 
			}
9073 vikram.rag 238 
			double unitSellingPrice,shippingPrice,octroiFee,emiFee;
239 
			if(order.getListPrice()!=0 ){
240 
				if(order.getListPrice() > 0){
241 
					unitSellingPrice =  order.getListPrice();
242 
				}
243 
				else{
244 
					sb.append(orderId+" "+subOrderId + " Unit Price set to 0 " +"\n");
245 
					logger.info(orderId+" "+subOrderId + " Unit Price set to 0 " +"\n");
246 
					continue;
247 
				}
248 
			}
249 
			else{
250 
				sb.append(orderId+" "+subOrderId + " Unit Price not set " +"\n");
251 
				logger.info(orderId+" "+subOrderId + " Unit Price not set " +"\n");
252 
				continue;
253 
			}
254 
			if(order.getShippingFees() > 0){
255 
				shippingPrice  =  order.getShippingFees();
11080 vikram.rag 256 
				//sb.append(orderId+" "+subOrderId + " Shipping Fee :"+ shippingPrice +"\n");
9073 vikram.rag 257 
				logger.info(orderId+" "+subOrderId + " Shipping Fee :"+ shippingPrice +"\n");
9080 vikram.rag 258 
 
9073 vikram.rag 259 
			}
260 
			else{
261 
				shippingPrice=0;
262 
			}
263 
			if(order.getOctroi()!=0){
264 
				octroiFee =  order.getOctroi();
265 
				if(octroiFee >0){
11080 vikram.rag 266 
					//sb.append(orderId+" "+subOrderId + " OctroiFee :"+ octroiFee +"\n");
9073 vikram.rag 267 
					logger.info(orderId+" "+subOrderId + " OctroiFee :"+ octroiFee +"\n");
268 
				}
269 
			}
270 
			else{
271 
				octroiFee=0;
272 
			}
273 
			if(order.getEmi()!=0){
274 
				emiFee =  order.getEmi();
275 
				if(emiFee >0){
11080 vikram.rag 276 
					//sb.append(orderId+" "+subOrderId + " EMI :"+ emiFee +"\n");
9073 vikram.rag 277 
					logger.info(orderId+" "+subOrderId + " EMI :"+ emiFee +"\n");
278 
				}
279 
			}
280 
			else{
281 
				emiFee = 0;
282 
			}
283 
			int quantity;
284 
			if(order.getQuantity()!=0){
285 
				quantity = order.getQuantity();
286 
				if(quantity > 1){
10975 vikram.rag 287 
					//sb.append(orderId+" "+subOrderId + " Quantity > 1 " +quantity+"\n");
9073 vikram.rag 288 
					logger.info(orderId+" "+subOrderId + " Quantity > 1 " +quantity+"\n");
289 
				}
290 
				else{
291 
					if(quantity==0){
292 
						sb.append(orderId+" "+subOrderId + " Quantity not set " +quantity+"\n");
293 
						logger.info(orderId+" "+subOrderId + " Quantity not set " +quantity+"\n");
294 
						continue;
295 
					}
296 
				}
297 
			}
298 
			else{
299 
				sb.append(orderId+" "+subOrderId + " Quantity not set " + "0" +"\n");
300 
				logger.info(orderId+" "+subOrderId + " Quantity not set " +"0"+"\n");
301 
				continue;
302 
			}
303 
			double totalsellingPrice;
304 
			if(order.getTotalPrice()!=0){
305 
				totalsellingPrice= order.getTotalPrice();
306 
				if(totalsellingPrice==0){
307 
					sb.append(orderId+" "+subOrderId + " Total Selling Price set to 0 " +"\n");
308 
					logger.info(orderId+" "+subOrderId + " Total Selling Price set to 0 " +"\n");
309 
					continue;
310 
				}
311 
			}
312 
			else{
313 
				sb.append(orderId+" "+subOrderId + " Total Selling Price not set " +"\n");
314 
				logger.info(orderId+" "+subOrderId + " Total Selling Price not set " +"\n");
315 
				continue;
316 
			}
317 
 
318 
			String shipToName,addressLine1,addressLine2,city,state,pincode,buyerName="unknown";
319 
			if(order.getCustomerName().length() > 0){
320 
				buyerName = order.getCustomerName();
321 
			}
322 
			else{
323 
				sb.append(orderId+" "+subOrderId + " Buyer Name not set " +"\n");
324 
				logger.info(orderId+" "+subOrderId + " Buyer Name not set " +"\n");
325 
			}
326 
			if(order.getShippingAddressName().length() > 0){
327 
				shipToName = order.getShippingAddressName();
328 
			}
329 
			else{
330 
				sb.append(orderId+" "+subOrderId + " Ship to Name not set " +"\n");
331 
				logger.info(orderId+" "+subOrderId + " Ship to Name not set " +"\n");
332 
				continue;
333 
			}
334 
			if(buyerName.contains("unknown")){
335 
				buyerName = shipToName;
336 
			}
9251 vikram.rag 337 
			if(order.getShippingAddressLine1()!=null && order.getShippingAddressLine1().length() > 0){
9073 vikram.rag 338 
				addressLine1 = order.getShippingAddressLine1();
339 
			}
340 
			else{
341 
				addressLine1 ="";
342 
			}
9251 vikram.rag 343 
			if(order.getShippingAddressLine2()!=null && order.getShippingAddressLine2().length() > 0){
9073 vikram.rag 344 
				addressLine2 = order.getShippingAddressLine2();
345 
			}
346 
			else{
347 
				addressLine2 ="";
348 
			}
9251 vikram.rag 349 
			if(order.getShippingAddressCity()!=null && order.getShippingAddressCity().length()>0){
9073 vikram.rag 350 
				city = order.getShippingAddressCity();
351 
			}
352 
			else{
353 
				sb.append(orderId+" "+subOrderId + " City not set " +"\n");
354 
				logger.info(orderId+" "+subOrderId + " City not set " +"\n");
355 
				continue;
356 
			}
357 
			if(order.getShippingAddressState().length()>0){
358 
				state = order.getShippingAddressState();
359 
			}
360 
			else{
361 
				sb.append(orderId+" "+subOrderId + " State not set " +"\n");
362 
				logger.info(orderId+" "+subOrderId + " State not set " +"\n");
363 
				continue;
364 
			}
365 
			if(order.getShippingAddressPincode().length()>0){
366 
				pincode = order.getShippingAddressPincode();
367 
			}
368 
			else{
369 
				sb.append(orderId+" "+subOrderId + " Pincode not set " +"\n");
370 
				logger.info(orderId+" "+subOrderId + " Pincode not set " +"\n");
371 
				continue;
372 
			}
373 
			int sla;
374 
			if(order.getSla()>0){
375 
				sla = order.getSla();
376 
			}
377 
			else{
378 
				sb.append(orderId+" "+subOrderId + " Ship to date not available " +"\n");
379 
				logger.info(orderId+" "+subOrderId + " Ship to date not available " +"\n");
380 
				continue;
381 
			}
382 
			//String shipByDate = nextLine[26];
9104 vikram.rag 383 
			SimpleDateFormat createDateFormatter = new SimpleDateFormat("MMM dd, yyyy hh:mm aaa");
384 
			SimpleDateFormat shipDateFormatter = new SimpleDateFormat("MMM dd, yyyy");
385 
			Date flipkartTxnDate = null;
386 
			Date shipByDate = null;
387 
			try {
388 
				flipkartTxnDate = createDateFormatter.parse(create_date);
389 
			} catch (ParseException e) {
390 
				logger.error(orderId+" "+subOrderId + " Could not parse flipkart order date from file " , e);
391 
				sb.append(orderId+" "+subOrderId + " Could not parse order date" +"\n");
392 
				continue;
393 
			}
394 
			if(ship_date!=null){
395 
				try {
396 
					shipByDate = shipDateFormatter.parse(ship_date);
397 
				} catch (ParseException e) {
398 
					logger.error(orderId+" "+subOrderId + " ship date " , e);
9112 vikram.rag 399 
					sb.append(orderId+" "+subOrderId + "cannot parse ship date" +"\n");
9104 vikram.rag 400 
					continue;
401 
				}
402 
			}
9073 vikram.rag 403 
			Client transaction_client = null;
404 
			try {
405 
				transaction_client = new TransactionClient().getClient();
10975 vikram.rag 406 
				boolean flag = false;
407 
				try{
10978 vikram.rag 408 
					flag = transaction_client.flipkartOrderExists(orderId,subOrderId);
10975 vikram.rag 409 
				}
410 
				catch(Exception e){
411 
					continue;
412 
				}
413 
				if(flag) {
9104 vikram.rag 414 
					if(shipByDate!=null && order.getTrackingId()!=null){
415 
						transaction_client.updateFlipkartOrderDatesAndAWB(orderId, subOrderId, shipByDate.getTime(), order.getTrackingId());
9125 vikram.rag 416 
						logger.error("Order exists updating info " + "id : " + orderId + " suborder id : " + subOrderId);
10975 vikram.rag 417 
						//sb.append("Order exists updating info " + orderId+" "+subOrderId+"\n");
9104 vikram.rag 418 
					}
9111 vikram.rag 419 
					else{
420 
						logger.error("Flipkart order exists " + "id : " + orderId + " suborder id : " + subOrderId);
10975 vikram.rag 421 
						//sb.append("Flipkart order exists " + orderId+" "+subOrderId+"\n");
9111 vikram.rag 422 
					}
10977 vikram.rag 423 
					duplicate_orders++;
9073 vikram.rag 424 
					continue;
425 
				}
426 
 
427 
			} catch (TTransportException e1) {
428 
				logger.error("Problem with Transaction service " , e1);
429 
				e1.printStackTrace();
10975 vikram.rag 430 
				continue;
9073 vikram.rag 431 
			} catch (TException e) {
432 
				logger.error("Problem.. thrift exception with Transaction service " , e);
433 
				e.printStackTrace();
10975 vikram.rag 434 
				continue;
9073 vikram.rag 435 
			}
12759 manish.sha 436 
			flipkartItem = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient().getFlipkartItemBySkyAtFlipkart(skuAtFlipkart);
437 
			//flipkartItem = new CatalogClient().getClient().getFlipkartItemBySkyAtFlipkart(skuAtFlipkart);
10982 vikram.rag 438 
			sku = flipkartItem.getItem_id();
439 
			if(sku==0){
440 
				System.out.println("SKU Mapping doesnt exists " + skuAtFlipkart);
441 
				sb.append(orderId + " "+ subOrderId  + " SKU Mapping doesnt exist" + " " +skuAtFlipkart+ "\n");
442 
				continue;
443 
			}
10991 vikram.rag 444 
 
9073 vikram.rag 445 
			Transaction txn = new Transaction();
446 
			txn.setShoppingCartid(user.getActiveCartId());
447 
			txn.setCustomer_id(user.getUserId());
448 
			System.out.println("User Id is " + user.getUserId());
449 
			txn.setCreatedOn(new Date().getTime());
450 
			txn.setTransactionStatus(TransactionStatus.INIT);
451 
			txn.setStatusDescription("Order for flipkart ");
452 
			List<in.shop2020.model.v1.order.Order> orderlist = new ArrayList<in.shop2020.model.v1.order.Order>();
453 
			double total_price=0;
454 
			InventoryService.Client inventoryClient = null;
455 
			Warehouse fulfillmentWarehouse= null;
9272 vikram.rag 456 
			LineItem lineItem = null;
457 
			lineItem = createLineItem(sku,unitSellingPrice,quantity);
458 
			logger.info(orderId+" "+subOrderId + "sku and Price " + sku + " " + unitSellingPrice);
459 
			lineItem.setExtra_info("flipkartOrderId = " + orderId + " flipkartsubOrderId = " + subOrderId);
460 
			in.shop2020.model.v1.order.Order t_order = new in.shop2020.model.v1.order.Order();
461 
			t_order.setCustomer_id(user.getUserId());
462 
			t_order.setCustomer_email(sourceDetail.getEmail());
12589 manish.sha 463 
			t_order.setCustomer_mobilenumber(order.getPhone());
9272 vikram.rag 464 
			t_order.setCustomer_name(shipToName);
465 
			t_order.setCustomer_address1(addressLine1);
466 
			t_order.setCustomer_address2(addressLine2);
467 
			t_order.setCustomer_city(city);
468 
			t_order.setCustomer_state(state);
469 
			t_order.setCustomer_pincode(pincode);
470 
			t_order.setTotal_weight(lineItem.getTotal_weight());
471 
			t_order.setLineitems(Collections.singletonList(lineItem));
472 
			t_order.setStatus(OrderStatus.PAYMENT_PENDING);
473 
			t_order.setCreated_timestamp(new Date().getTime());
474 
			t_order.setOrderType(OrderType.B2C);
12589 manish.sha 475 
			/*if(order.getFreebie_items().size()>0){
476 
				System.out.println("Freebie found");
477 
				FlipkartItem freebieItem = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient().getFlipkartItemBySkyAtFlipkart(order.getFreebie_items().get(0).getSku());
478 
				if(freebieItem.getItem_id()!=0){
479 
					t_order.setFreebieItemId(freebieItem.getItem_id());
480 
				}
481 
			}
482 
			else{
483 
				System.out.println("No Freebie");
484 
			}*/
485 
			if(isHold){
486 
				t_order.setCod(true);
487 
				t_order.setStatusDescription("Cod Verification Pending");
488 
			} else {
489 
				t_order.setStatusDescription("In Process");
490 
				t_order.setCod(false);
491 
			}
9272 vikram.rag 492 
			if(shipByDate!=null){
493 
				t_order.setPromised_shipping_time(shipByDate.getTime());
494 
				t_order.setExpected_shipping_time(shipByDate.getTime());
495 
				t_order.setPromised_delivery_time(shipByDate.getTime()+ 4*24*60*60);
496 
				t_order.setExpected_delivery_time(shipByDate.getTime()+ 4*24*60*60);
497 
			}
498 
			else{
499 
				try {
500 
					Date shipDate = new Date();
501 
					shipDate.setTime( flipkartTxnDate.getTime() + sla*24*60*60*1000);
9285 vikram.rag 502 
					Calendar calendar = Calendar.getInstance();
503 
					calendar.setTime(shipDate);
504 
					if(calendar.get(Calendar.DAY_OF_WEEK)!=1){
505 
						t_order.setPromised_shipping_time(shipDate.getTime());
506 
						t_order.setExpected_shipping_time(shipDate.getTime());
507 
					}
508 
					else{
509 
						t_order.setPromised_shipping_time(shipDate.getTime()+24*60*60*1000);
510 
						t_order.setExpected_shipping_time(shipDate.getTime()+24*60*60*1000);
511 
					}
512 
					calendar = Calendar.getInstance();
513 
					calendar.add(Calendar.DAY_OF_MONTH, 4);
514 
					t_order.setPromised_delivery_time(calendar.getTimeInMillis());
515 
					t_order.setExpected_delivery_time(calendar.getTimeInMillis());
9272 vikram.rag 516 
				} catch(Exception e) {
517 
					logger.error("Error in updating Shipping or Delivery Time for suborderid  " + subOrderId);
518 
					sb.append(orderId + " "+ subOrderId  + " Could not update delivery time" + " " + "\n");
519 
					continue;
9073 vikram.rag 520 
				}
9272 vikram.rag 521 
			}
522 
			inventoryClient = new InventoryClient().getClient();
523 
			try {
10140 vikram.rag 524 
				logger.info("Flipkart Item id is " + flipkartItem.getItem_id());
525 
				if(flipkartItem.getItem_id()!=0 && flipkartItem.getWarehouseId()!=0) {
10982 vikram.rag 526 
					logger.info("Flipkart Warehouse Id " + flipkartItem.getWarehouseId());
10140 vikram.rag 527 
					fulfillmentWarehouse = inventoryClient.getWarehouse(flipkartItem.getWarehouseId());
9272 vikram.rag 528 
					logger.info("fulfillmentWarehouse is " + fulfillmentWarehouse.getId() + " " + fulfillmentWarehouse.getDisplayName() );
529 
 
530 
				} else {
531 
					List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(sku, 1);
532 
					fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
533 
					if(fulfillmentWarehouse.getStateId()!=0){
534 
						fulfillmentWarehouse = inventoryClient.getWarehouse(7);
9104 vikram.rag 535 
					}
536 
				}
9272 vikram.rag 537 
				t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
538 
				long billingWarehouseId = 0;
539 
				if(fulfillmentWarehouse.getBillingWarehouseId()== 0) {
540 
					List<Warehouse> warehouses = inventoryClient.getWarehouses(WarehouseType.OURS, InventoryType.GOOD, fulfillmentWarehouse.getVendor().getId(), 0, 0);
541 
					for(Warehouse warehouse : warehouses) {
542 
						if(warehouse.getBillingWarehouseId()!=0) {
543 
							billingWarehouseId = warehouse.getBillingWarehouseId();
544 
							break;
9073 vikram.rag 545 
						}
546 
					}
9272 vikram.rag 547 
				}else {
548 
					billingWarehouseId = fulfillmentWarehouse.getBillingWarehouseId();
549 
				}
9073 vikram.rag 550 
 
9272 vikram.rag 551 
				//logger.info("Billing warehouse id for suborderid  " + order.getSuborderId() + " is " + fulfillmentWarehouse.getBillingWarehouseId());
552 
				t_order.setWarehouse_id(billingWarehouseId);
553 
				VendorItemPricing vendorItemPricing = new VendorItemPricing();
10991 vikram.rag 554 
				Item item = new CatalogClient().getClient().getItem(lineItem.getItem_id());
9272 vikram.rag 555 
				if(fulfillmentWarehouse.getId()==7) {
10992 vikram.rag 556 
 
10991 vikram.rag 557 
					try{
558 
						vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
559 
					}
560 
					catch(TTransportException e){
561 
						inventoryClient = new InventoryClient().getClient();
562 
						vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
563 
					}
564 
				}
565 
				else {
566 
					try{
567 
						vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
568 
					}
569 
					catch(TTransportException e){
570 
						inventoryClient = new InventoryClient().getClient();
571 
						vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
572 
					}
9272 vikram.rag 573 
				}
574 
				t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
575 
				t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
576 
			} catch (InventoryServiceException e) {
577 
				logger.error("Error connecting inventory service for suborderid  " + orderId + " " + subOrderId , e);
578 
				sb.append(orderId + " " + subOrderId+ " Inventory Service Exception" + " " + "\n");
579 
				continue;
580 
			} catch (TTransportException e) {
581 
				logger.error("Transport Exception with Inventory Service for suborderid  " + orderId + " " + subOrderId , e);
582 
				sb.append(orderId + " " + subOrderId + " Transport Exception with Inventory Service" + " " + "\n");
583 
				continue;
584 
			} catch (TException e) {
585 
				logger.error("Exception with Inventory Service for suborderid  " + orderId + " " + subOrderId , e);
586 
				sb.append(orderId + " " + subOrderId + " Exception in Inventory Service" + " " + "\n");
587 
				continue;
588 
			} catch (CatalogServiceException e) {
589 
				logger.error("Exception with Catalog Service for   " + orderId + " " + subOrderId + " while getting item " + lineItem.getItem_id(), e);
590 
				sb.append(orderId + " " + subOrderId + " Exception in Catalog Service" + " " + "\n");
591 
				continue;
9073 vikram.rag 592 
			}
9272 vikram.rag 593 
			t_order.setLogistics_provider_id(FLIPKART_LOGISTICS_ID);
594 
			t_order.setAirwaybill_no("");
595 
			t_order.setTracking_id("");
9275 vikram.rag 596 
			t_order.setTotal_amount(unitSellingPrice*quantity);
9272 vikram.rag 597 
			t_order.setOrderType(OrderType.B2C);
598 
			t_order.setSource(FLIPKART_SOURCE_ID);
599 
			t_order.setOrderType(OrderType.B2C);
600 
			total_price = unitSellingPrice*quantity;
601 
			orderlist.add(t_order);
9073 vikram.rag 602 
			txn.setOrders(orderlist);
603 
			try {
9196 vikram.rag 604 
				transactionId =  String.valueOf(transaction_client.createTransaction(txn));
9073 vikram.rag 605 
				logger.info("Transaction id is : " + transactionId);
606 
			} catch (TransactionServiceException e) {
607 
				logger.error(orderId+" "+subOrderId + " Could not create transaction " , e);
608 
				sb.append(orderId+" "+subOrderId + " Could not create transaction" +"\n");
609 
				continue;
610 
			} catch (TException e) {
10992 vikram.rag 611 
				transaction_client = new TransactionClient().getClient();
612 
				try {
613 
					transactionId =  String.valueOf(transaction_client.createTransaction(txn));
614 
				} catch (TransactionServiceException e1) {
615 
					sb.append(orderId+" "+subOrderId + " Transaction Service Exception could not create transaction" +"\n");
616 
					logger.info(orderId+" "+subOrderId + " Transaction Service Exception could not create transaction" +"\n" , e);
617 
					continue;
618 
				}
9073 vikram.rag 619 
			}
620 
			try{
9089 vikram.rag 621 
				logger.info("Creating payment for suborder id " + subOrderId +" ");
9200 vikram.rag 622 
				paymentId = createPayment(user,subOrderId,total_price);
9073 vikram.rag 623 
			}
624 
			catch (NumberFormatException e) {
625 
				logger.error("Could not create payment",e);
626 
				sb.append(orderId+" "+subOrderId + " Could not create payment");
627 
				e.printStackTrace();
628 
				continue;
629 
			} catch (PaymentException e) {
630 
				logger.error("Could not create payment payment exception",e);
631 
				sb.append(orderId+" "+subOrderId + " Could not create payment Payment exception");
632 
				e.printStackTrace();
633 
				continue;
634 
			} catch (TException e) {
635 
				logger.error("Could not create payment thrift exception",e);
9198 vikram.rag 636 
				sb.append(orderId+" "+subOrderId + " Could not create payment Thrift exception"+"\n");
9073 vikram.rag 637 
				e.printStackTrace();
638 
				continue;
639 
			}
9209 vikram.rag 640 
			Transaction transaction = null;
9073 vikram.rag 641 
			try {
9209 vikram.rag 642 
				transaction_client = tsc.getClient();
9196 vikram.rag 643 
				transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
9073 vikram.rag 644 
			} catch (NumberFormatException e) {
9089 vikram.rag 645 
				logger.error("Problem parsing transaction id " + transactionId +" ", e);
9073 vikram.rag 646 
				sb.append(orderId+" "+subOrderId  + " Problem parsing transaction id "+ transactionId +"\n");
647 
				e.printStackTrace();
648 
				continue;
649 
			} catch (TransactionServiceException e) {
9089 vikram.rag 650 
				logger.error("Problem getting transaction from service transaction id " + transactionId +" ",e);
9073 vikram.rag 651 
				sb.append(orderId+" "+subOrderId  + " Problem getting transaction id "+ transactionId +"\n");
652 
				e.printStackTrace();
653 
				continue;
654 
			} catch (TException e) {
9204 vikram.rag 655 
				logger.error("	 " + transactionId + " " , e);
9073 vikram.rag 656 
				sb.append(orderId+" "+subOrderId + " Problem with transaction service while getting transaction id "+ transactionId +"\n");
657 
				e.printStackTrace();
658 
				continue;
659 
			}
660 
			List<in.shop2020.model.v1.order.Order> flipkartorders = transaction.getOrders();
661 
			for(in.shop2020.model.v1.order.Order flipkartorder:flipkartorders){
662 
				try {
663 
					List<in.shop2020.model.v1.order.Attribute> attributeList = new ArrayList<in.shop2020.model.v1.order.Attribute>();
11014 vikram.rag 664 
					try{
11061 vikram.rag 665 
						inventoryClient.reserveItemInWarehouse(flipkartorder.getLineitems().get(0).getItem_id(), fulfillmentWarehouse.getId(), 1,
666 
								flipkartorder.getId(), flipkartorder.getCreated_timestamp(), flipkartorder.getPromised_shipping_time(), flipkartorder.getLineitems().get(0).getQuantity());
11014 vikram.rag 667 
					}
668 
					catch(TTransportException e){
669 
						new InventoryClient().getClient().reserveItemInWarehouse(flipkartorder.getLineitems().get(0).getItem_id(), fulfillmentWarehouse.getId(), 1,
670 
								flipkartorder.getId(), flipkartorder.getCreated_timestamp(), flipkartorder.getPromised_shipping_time(), flipkartorder.getLineitems().get(0).getQuantity());
671 
					}
9073 vikram.rag 672 
					FlipkartOrder flipkartOrder = new FlipkartOrder();
673 
					flipkartOrder.setOrderId(flipkartorder.getId());
674 
					flipkartOrder.setFlipkartOrderId(orderId);
675 
					flipkartOrder.setFlipkartSubOrderId(subOrderId);
676 
					flipkartOrder.setFlipkartTxnDate(flipkartTxnDate.getTime());
677 
					flipkartOrder.setEmiFee(emiFee);
678 
					flipkartOrder.setOctroiFee(octroiFee);
679 
					flipkartOrder.setShippingPrice(shippingPrice);
10140 vikram.rag 680 
					flipkartOrder.setMaxNlc(flipkartItem.getMaxNlc());
9073 vikram.rag 681 
					in.shop2020.model.v1.order.Attribute attribute = new in.shop2020.model.v1.order.Attribute();
682 
					attribute.setName("Buyer Name");
683 
					attribute.setValue(buyerName);
684 
					attributeList.add(attribute);
685 
					try {
9191 vikram.rag 686 
						transaction_client.createFlipkartOrder(flipkartOrder);
687 
						transaction_client.setOrderAttributes(flipkartOrder.getOrderId(),attributeList);
9200 vikram.rag 688 
						logger.info("transaction id : " + Long.valueOf(transactionId) + " Payment id : " + paymentId);
689 
						new PaymentClient().getClient().updatePaymentDetails(paymentId, null, null, null, null, null, null, subOrderId, null, PaymentStatus.SUCCESS, null, null);
9073 vikram.rag 690 
					} catch (TException e) {
9089 vikram.rag 691 
						logger.error("Could not create flipkart order ",e);
9073 vikram.rag 692 
						sb.append(orderId+" "+subOrderId + " Could not create flipkart order"+"\n");
693 
						continue;
9200 vikram.rag 694 
					} catch (PaymentException e) {
695 
						logger.error("Could not update flipkart order payment ",e);
696 
						sb.append(orderId+" "+subOrderId + " Could not update flipkart order payment"+"\n");
697 
						continue;
9073 vikram.rag 698 
					}
699 
 
700 
				} catch (InventoryServiceException e1) {
9089 vikram.rag 701 
					logger.error("Problem while reserving item in inventory service" + flipkartorder.getId() + " ",e1);
9073 vikram.rag 702 
					sb.append(orderId+" "+subOrderId + " Could not reserve inventory for sku "+ sku +"\n");
703 
					continue;
704 
				} catch (TException e1) {
9089 vikram.rag 705 
					logger.error("Problem with inventory service" + flipkartorder.getId()+" ",e1);
9073 vikram.rag 706 
					sb.append(orderId+" "+subOrderId + " Problem with inventory service while reserving inventory for sku "+ sku +"\n");
707 
					continue;
708 
				}
10990 vikram.rag 709 
				orders_processed++;
9073 vikram.rag 710 
			}
10991 vikram.rag 711 
 
9073 vikram.rag 712 
		}
713 
 
714 
		if(orders_processed==1){
715 
			order_string = "Order";
716 
		}
717 
		else{
718 
			order_string = "Orders";
719 
		}
9091 vikram.rag 720 
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
9077 vikram.rag 721 
		Calendar cal=GregorianCalendar.getInstance();
722 
		String emailFromAddress = "build@shop2020.in";
723 
		String password = "cafe@nes";
724 
		GmailUtils mailer = new GmailUtils();
12755 manish.sha 725 
		//String sendTo[] = new String[]{"manish.sharma@shop2020.in"};
12971 amit.gupta 726 
		String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in",  "rajneesh.arora@shop2020.in",
9077 vikram.rag 727 
				"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
12589 manish.sha 728 
				"yukti.jain@shop2020.in","manish.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in","anikendra.das@shop2020.in"};
11061 vikram.rag 729 
		try {
9097 vikram.rag 730 
			logger.info("Before Sending Emails");
10975 vikram.rag 731 
			String ordersProcessingStatus = "Total Orders : " + total_orders +"\n"+
10978 vikram.rag 732 
			"Processed Orders : " + orders_processed +"\n"+
733 
			"Existing Orders : " + duplicate_orders +"\n"+
12869 manish.sha 734 
			"Flipkart Advantage Orders : "+ fa_orders +"\n"+
735 
			"Failed Orders :" + (total_orders - orders_processed - duplicate_orders - not_approved - fa_orders)+"\n"+
10979 vikram.rag 736 
			"Unapproved Orders :" + not_approved;
9073 vikram.rag 737 
 
9097 vikram.rag 738 
			if(sb.toString().equalsIgnoreCase("")){
739 
				if(orders_processed!=0){
740 
					String emailSubjectTxt = orders_processed + " Flipkart " + order_string + " Created "+sdf.format(cal.getTime());
10975 vikram.rag 741 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,"Orders Created Successfully (No Alerts)"+"\n"+ordersProcessingStatus, emailFromAddress, password, new ArrayList<File>());
9097 vikram.rag 742 
					logger.info("Sending Email Flipkart Orders Created Successfully (No Alerts)");
743 
				}
744 
				else{
10986 vikram.rag 745 
					String emailSubjectTxt = "No new Flipkart orders created "+sdf.format(cal.getTime());
746 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,"No new orders created"+"\n\n"+ordersProcessingStatus, emailFromAddress, password, new ArrayList<File>());
9097 vikram.rag 747 
					logger.info("Sending Email Flipkart Orders Created Successfully (No Alerts)");
748 
				}
749 
			}
750 
			else{
751 
				if(orders_processed!=0){
11080 vikram.rag 752 
					/*String emailSubjectTxt = orders_processed + " Flipkart " + order_string + " Created "+sdf.format(cal.getTime());
10975 vikram.rag 753 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,ordersProcessingStatus+"\n"+sb.toString(), emailFromAddress, password, new ArrayList<File>());
9097 vikram.rag 754 
					logger.info("Sending Email Flipkart Orders Created Successfully (Check Alerts)");
12869 manish.sha 755 
					*/int failed_orders = (total_orders - orders_processed - duplicate_orders - not_approved - fa_orders);
11080 vikram.rag 756 
					if(failed_orders==1){
757 
						order_string = "Order";
758 
					}
759 
					else{
760 
						order_string = "Orders";
761 
					}
11509 vikram.rag 762 
					String emailSubjectTxt = failed_orders + " Flipkart " + order_string + " Failed while creation  "+sdf.format(cal.getTime());
11080 vikram.rag 763 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,ordersProcessingStatus+"\n"+sb.toString(), emailFromAddress, password, new ArrayList<File>());
764 
					logger.info("Sending Email Flipkart Orders Failed while creation");
9097 vikram.rag 765 
				}
766 
				else{
767 
					String emailSubjectTxt = "No new Flipkart orders created "+sdf.format(cal.getTime());
10975 vikram.rag 768 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt,ordersProcessingStatus+"\n"+sb.toString(), emailFromAddress, password, new ArrayList<File>());
9097 vikram.rag 769 
					logger.info("Sending Email Flipkart Orders Created Successfully (Check Alerts)");
770 
				}
771 
			}
772 
		}
773 
		catch (Exception e) {
774 
			e.printStackTrace();
775 
			logger.error("Exception ",e);
776 
		}
9077 vikram.rag 777 
 
9073 vikram.rag 778 
	}
779 
 
9272 vikram.rag 780 
	public static LineItem createLineItem(long itemId, double amount,int qty) throws CatalogServiceException, TException {
9073 vikram.rag 781 
		LineItem lineItem = new LineItem();
782 
		CatalogService.Client catalogClient = new CatalogClient().getClient();
783 
		Item item = catalogClient.getItem(itemId);
784 
		if(item.getId()==0){
785 
			//in case item id is incorrect..
786 
			return null;
787 
		}
788 
		lineItem.setProductGroup(item.getProductGroup());
789 
		lineItem.setBrand(item.getBrand());
790 
		lineItem.setModel_number(item.getModelNumber());
791 
		lineItem.setModel_name(item.getModelName());
792 
		lineItem.setExtra_info(item.getFeatureDescription());
9272 vikram.rag 793 
		lineItem.setQuantity(qty);
9073 vikram.rag 794 
		lineItem.setItem_id(item.getId());
795 
		lineItem.setUnit_weight(item.getWeight());
796 
		lineItem.setTotal_weight(item.getWeight());
797 
		lineItem.setUnit_price(amount);
9272 vikram.rag 798 
		lineItem.setTotal_price(amount*qty);
9073 vikram.rag 799 
		if (item.getColor() == null || "NA".equals(item.getColor())) {
800 
			lineItem.setColor("");
801 
		} else {
802 
			lineItem.setColor(item.getColor());
803 
		}
804 
		return lineItem;
805 
	}
9200 vikram.rag 806 
	public static long createPayment(User user, String subOrderId, double amount) throws PaymentException, TException {
9073 vikram.rag 807 
		in.shop2020.payments.PaymentService.Client client = new PaymentClient().getClient();
808 
		logger.info("Creating payment for user id " + user.getUserId() + " Gateway id " + FLIPKART_GATEWAY_ID);
809 
		logger.info("Long value of transaction id : " + Long.valueOf(transactionId));
810 
		long paymentId = client.createPayment(user.getUserId(), amount, FLIPKART_GATEWAY_ID, Long.valueOf(transactionId), false);
9200 vikram.rag 811 
		return paymentId;
9073 vikram.rag 812 
	}
813 
 
814 
 
815 
 
816 
}