Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
12589 manish.sha 1
package in.shop2020.serving.services;
2
 
3
import java.io.BufferedReader;
12596 manish.sha 4
import java.io.File;
12589 manish.sha 5
import java.io.IOException;
6
import java.io.InputStreamReader;
7
import java.util.ArrayList;
12596 manish.sha 8
import java.util.Calendar;
9
import java.util.GregorianCalendar;
12589 manish.sha 10
import java.util.List;
11
 
12
import in.shop2020.model.v1.order.FlipkartOrder;
13
import in.shop2020.model.v1.order.TransactionServiceException;
14
 
15
import in.shop2020.serving.model.Order;
16
import in.shop2020.serving.model.OrderItems;
17
import in.shop2020.thrift.clients.TransactionClient;
12596 manish.sha 18
import in.shop2020.utils.GmailUtils;
12589 manish.sha 19
 
20
import org.apache.http.HttpResponse;
21
import org.apache.http.NameValuePair;
22
import org.apache.http.client.HttpClient;
23
import org.apache.http.client.entity.UrlEncodedFormEntity;
24
import org.apache.http.client.methods.HttpGet;
25
import org.apache.http.client.methods.HttpPost;
26
import org.apache.http.impl.client.DefaultHttpClient;
27
import org.apache.http.message.BasicNameValuePair;
28
import org.apache.thrift.TException;
29
import org.apache.thrift.transport.TTransportException;
30
import org.json.JSONArray;
31
import org.json.JSONException;
32
import org.json.JSONObject;
33
 
34
import com.google.gson.Gson;
35
 
36
public class FlipkartHoldOrdersReconciliation{
12605 manish.sha 37
	private static String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in", "eng@shop2020.in" ,
12596 manish.sha 38
			"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
12605 manish.sha 39
			"yukti.jain@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
12596 manish.sha 40
	private static java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
41
	private static Calendar cal=GregorianCalendar.getInstance();
12605 manish.sha 42
	private static String emailFromAddress = "build-staging@shop2020.in";
43
	private static String password = "shop2020";
12596 manish.sha 44
	private static GmailUtils mailer = new GmailUtils();
45
 
12589 manish.sha 46
	public static void main(String[] args) throws TException, TransactionServiceException, JSONException {
47
		HttpClient client = new DefaultHttpClient();
48
		HttpPost post = new HttpPost("https://seller.flipkart.com/login");
49
		BufferedReader rd= null;
50
		try {
51
			List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
52
			nameValuePairs.add(new BasicNameValuePair("authName",
53
			"flipkart"));
54
			nameValuePairs.add(new BasicNameValuePair("username",
55
			"flipkart-support@saholic.com"));
56
			nameValuePairs.add(new BasicNameValuePair("password",
57
			"076c27ee24d7596b06608a8ed2559f87"));
12756 manish.sha 58
			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=");
59
			post.addHeader("User-agent", "Mozilla/4.0");
60
			post.addHeader("Referer", "seller.flipkart.com");
12589 manish.sha 61
			post.setEntity(new UrlEncodedFormEntity(nameValuePairs,"utf-8"));
62
			HttpResponse response = client.execute(post);
63
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
64
			String line = "";
65
			HttpGet get_new;
66
 
12596 manish.sha 67
			List<FlipkartOrder> pendingOrderList = new ArrayList<FlipkartOrder>();
68
			List<FlipkartOrder> acceptedOrderList = new ArrayList<FlipkartOrder>();
69
			List<FlipkartOrder> cancelledOrderList = new ArrayList<FlipkartOrder>();
70
			List<FlipkartOrder> errorOrderList = new ArrayList<FlipkartOrder>();
71
 
12589 manish.sha 72
			while ((line = rd.readLine()) != null) {
73
				System.out.println(line);
74
			}
75
 
76
			//https://seller.flipkart.com/order_management/search_order_items?order_id=OD40827062297&sellerId=m2z93iskuj81qiid
77
			TransactionClient transactionServiceClient = new TransactionClient();
78
			in.shop2020.model.v1.order.TransactionService.Client tClient = transactionServiceClient.getClient();
79
			List<FlipkartOrder> pendingFkOrdersList = tClient.getVerificationPendingOrdersFK();
80
			StringBuffer sb = new StringBuffer();
12596 manish.sha 81
			StringBuffer resB = new StringBuffer();
12589 manish.sha 82
			for(FlipkartOrder fkOrder : pendingFkOrdersList){
83
				get_new = new HttpGet("https://seller.flipkart.com/order_management/search_order_items?order_id="+fkOrder.getFlipkartOrderId()+"&sellerId=m2z93iskuj81qiid");
12756 manish.sha 84
				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=");
12589 manish.sha 85
				response = client.execute(get_new);
86
				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
87
				line = "";
88
				line = rd.readLine();
89
				JSONObject jsonDataObj = null;
90
				JSONArray jsonObjArr = null;
91
				if(line == null || line.isEmpty()){
92
					sb.append("Flipkart Order Id -"+ fkOrder.getFlipkartOrderId()+" Response - "+line);
93
					sb.append("\n");
94
					continue;
95
				} else if (!line.startsWith("{")){
96
					sb.append("Flipkart Order Id -"+ fkOrder.getFlipkartOrderId()+" Response - "+line);
97
					sb.append("\n");
98
					continue;
99
				}
100
				else{
101
					jsonDataObj = new JSONObject(line);
102
				}
103
 
104
				if(jsonDataObj!=null){
105
					jsonObjArr = new JSONArray(jsonDataObj.get("items").toString());
106
				}
107
 
108
				if(jsonObjArr!=null && jsonObjArr.length()>0){
109
					JSONObject jsonObj = null;
110
					jsonObj = jsonObjArr.getJSONObject(0);
111
					if(jsonObj!=null){
112
						if(jsonObj.get("status")!=null){
113
							String status = jsonObj.get("status").toString();
12607 manish.sha 114
							String statusLabel = jsonObj.get("statusLabel").toString();
115
							if("on_hold".equalsIgnoreCase(status) || "On hold".equalsIgnoreCase(statusLabel)){
12596 manish.sha 116
								pendingOrderList.add(fkOrder);
12589 manish.sha 117
							}
12607 manish.sha 118
							if("approved".equalsIgnoreCase(status) || "Approved".equalsIgnoreCase(statusLabel) || "confirmed".equalsIgnoreCase(statusLabel)){
12589 manish.sha 119
								if(tClient ==null || !tClient.isAlive()){
120
									tClient = transactionServiceClient.getClient();
121
								}
122
								tClient.verifyOrder(fkOrder.getOrderId());
123
								tClient.acceptOrder(fkOrder.getOrderId());
12596 manish.sha 124
								acceptedOrderList.add(fkOrder);
12589 manish.sha 125
							}
12607 manish.sha 126
							if("cancelled".equalsIgnoreCase(status) || "Cancelled".equalsIgnoreCase(statusLabel)){
12589 manish.sha 127
								if(tClient ==null || !tClient.isAlive()){
128
									tClient = transactionServiceClient.getClient();
129
								}
130
								tClient.refundOrder(fkOrder.getOrderId(), "flipkart", "As per Buyer's Request");
12596 manish.sha 131
								cancelledOrderList.add(fkOrder);
12589 manish.sha 132
							}
133
						}else{
12596 manish.sha 134
							errorOrderList.add(fkOrder);
12589 manish.sha 135
						}
136
					}
137
				}
138
			}
139
 
12596 manish.sha 140
			resB.append("Still Pending Orders:-\n");
12605 manish.sha 141
			System.out.println("Still Pending Orders:-");
12596 manish.sha 142
			for(FlipkartOrder order: pendingOrderList){
143
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 144
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 145
			}
146
			resB.append("Accepeted Orders:-\n");
12605 manish.sha 147
			System.out.println("Accepeted Orders:-");
12596 manish.sha 148
			for(FlipkartOrder order: acceptedOrderList){
149
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 150
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 151
			}
152
			resB.append("Cancelled Orders:-\n");
12605 manish.sha 153
			System.out.println("Cancelled Orders:-");
12596 manish.sha 154
			for(FlipkartOrder order: cancelledOrderList){
155
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 156
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 157
			}
158
			resB.append("Response not found Orders:-\n");
12605 manish.sha 159
			System.out.println("Response not found Orders:-");
12596 manish.sha 160
			for(FlipkartOrder order: errorOrderList){
161
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 162
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 163
			}
164
			String emailSubjectTxt = " Flipkart Hold Order Reconcilaition Process "+sdf.format(cal.getTime());
165
			mailer.sendSSLMessage(sendTo, emailSubjectTxt, resB.toString(), emailFromAddress, password, new ArrayList<File>());
12589 manish.sha 166
			System.out.println(sb.toString());
12596 manish.sha 167
		} catch (Exception e) {
12589 manish.sha 168
			e.printStackTrace();
169
		}
170
	}
171
}