Subversion Repositories SmartDukaan

Rev

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