Subversion Repositories SmartDukaan

Rev

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