Subversion Repositories SmartDukaan

Rev

Rev 15737 | 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;
13243 manish.sha 4
import java.io.BufferedWriter;
12596 manish.sha 5
import java.io.File;
13243 manish.sha 6
import java.io.FileWriter;
12589 manish.sha 7
import java.io.IOException;
8
import java.io.InputStreamReader;
13243 manish.sha 9
import java.text.SimpleDateFormat;
12589 manish.sha 10
import java.util.ArrayList;
12596 manish.sha 11
import java.util.Calendar;
13243 manish.sha 12
import java.util.Date;
12596 manish.sha 13
import java.util.GregorianCalendar;
12589 manish.sha 14
import java.util.List;
13189 manish.sha 15
import java.util.concurrent.TimeUnit;
12589 manish.sha 16
 
17
import in.shop2020.model.v1.order.FlipkartOrder;
18
import in.shop2020.model.v1.order.TransactionServiceException;
19
 
20
import in.shop2020.serving.model.Order;
21
import in.shop2020.serving.model.OrderItems;
22
import in.shop2020.thrift.clients.TransactionClient;
12596 manish.sha 23
import in.shop2020.utils.GmailUtils;
12589 manish.sha 24
 
13243 manish.sha 25
import org.apache.commons.lang.StringUtils;
12589 manish.sha 26
import org.apache.http.HttpResponse;
27
import org.apache.http.NameValuePair;
28
import org.apache.http.client.HttpClient;
29
import org.apache.http.client.entity.UrlEncodedFormEntity;
30
import org.apache.http.client.methods.HttpGet;
31
import org.apache.http.client.methods.HttpPost;
32
import org.apache.http.impl.client.DefaultHttpClient;
33
import org.apache.http.message.BasicNameValuePair;
34
import org.apache.thrift.TException;
35
import org.apache.thrift.transport.TTransportException;
36
import org.json.JSONArray;
37
import org.json.JSONException;
38
import org.json.JSONObject;
39
 
40
import com.google.gson.Gson;
41
 
42
public class FlipkartHoldOrdersReconciliation{
12605 manish.sha 43
	private static String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in", "eng@shop2020.in" ,
12596 manish.sha 44
			"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
12605 manish.sha 45
			"yukti.jain@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
13196 manish.sha 46
	//private static String sendTo1[]  = new String[]{"manish.sharma@shop2020.in"};
13243 manish.sha 47
	private static java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
12596 manish.sha 48
	private static Calendar cal=GregorianCalendar.getInstance();
12605 manish.sha 49
	private static String emailFromAddress = "build-staging@shop2020.in";
50
	private static String password = "shop2020";
12596 manish.sha 51
	private static GmailUtils mailer = new GmailUtils();
13667 manish.sha 52
	private static String cookies;
12596 manish.sha 53
 
13243 manish.sha 54
	public static void main(String[] args) throws IOException{
55
		File file = new File("/home/manish/alerts/fkhold.txt");
56
		BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
57
 
12589 manish.sha 58
		HttpClient client = new DefaultHttpClient();
59
		HttpPost post = new HttpPost("https://seller.flipkart.com/login");
60
		BufferedReader rd= null;
61
		try {
13667 manish.sha 62
			HttpGet get_new;
63
			get_new = new HttpGet("https://seller.flipkart.com/");
64
			get_new.addHeader("Host","seller.flipkart.com");
65
            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");
66
            get_new.addHeader("Connection","keep-alive");
67
 
68
            HttpResponse response = client.execute(get_new);
69
            rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
70
            String line = "";
71
            while ((line = rd.readLine()) != null) {
72
                System.out.println(line);
73
            }
74
            cookies = response.getFirstHeader("Set-Cookie") == null ? "" : 
75
                response.getFirstHeader("Set-Cookie").getValue();
76
 
77
            System.out.println("Cookies Before Login "+ cookies);
78
 
12589 manish.sha 79
			List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
80
			nameValuePairs.add(new BasicNameValuePair("authName",
81
			"flipkart"));
82
			nameValuePairs.add(new BasicNameValuePair("username",
83
			"flipkart-support@saholic.com"));
84
			nameValuePairs.add(new BasicNameValuePair("password",
13181 manish.sha 85
			"bestmobiledeals2010"));
13667 manish.sha 86
			post.addHeader("Cookie",cookies);
12756 manish.sha 87
			post.addHeader("User-agent", "Mozilla/4.0");
88
			post.addHeader("Referer", "seller.flipkart.com");
12589 manish.sha 89
			post.setEntity(new UrlEncodedFormEntity(nameValuePairs,"utf-8"));
13667 manish.sha 90
			response = client.execute(post);
91
			cookies = response.getFirstHeader("Set-Cookie") == null ? "" : 
92
                response.getFirstHeader("Set-Cookie").getValue();
93
			System.out.println("Cookies After Login "+cookies);
12589 manish.sha 94
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
13667 manish.sha 95
			line = "";
12589 manish.sha 96
 
12596 manish.sha 97
			List<FlipkartOrder> pendingOrderList = new ArrayList<FlipkartOrder>();
98
			List<FlipkartOrder> acceptedOrderList = new ArrayList<FlipkartOrder>();
99
			List<FlipkartOrder> cancelledOrderList = new ArrayList<FlipkartOrder>();
100
			List<FlipkartOrder> errorOrderList = new ArrayList<FlipkartOrder>();
101
 
12589 manish.sha 102
			while ((line = rd.readLine()) != null) {
103
				System.out.println(line);
104
			}
105
 
106
			//https://seller.flipkart.com/order_management/search_order_items?order_id=OD40827062297&sellerId=m2z93iskuj81qiid
107
			TransactionClient transactionServiceClient = new TransactionClient();
108
			in.shop2020.model.v1.order.TransactionService.Client tClient = transactionServiceClient.getClient();
109
			List<FlipkartOrder> pendingFkOrdersList = tClient.getVerificationPendingOrdersFK();
110
			StringBuffer sb = new StringBuffer();
12596 manish.sha 111
			StringBuffer resB = new StringBuffer();
12589 manish.sha 112
			for(FlipkartOrder fkOrder : pendingFkOrdersList){
113
				get_new = new HttpGet("https://seller.flipkart.com/order_management/search_order_items?order_id="+fkOrder.getFlipkartOrderId()+"&sellerId=m2z93iskuj81qiid");
15738 manish.sha 114
				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");
13667 manish.sha 115
				get_new.addHeader("Host","seller.flipkart.com");
116
	            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");
117
	            get_new.addHeader("Connection","keep-alive");
12589 manish.sha 118
				response = client.execute(get_new);
119
				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
15736 manish.sha 120
 
12589 manish.sha 121
				line = "";
122
				line = rd.readLine();
13194 manish.sha 123
				System.out.println("Response... "+line);
15736 manish.sha 124
				response.getEntity().consumeContent();
12589 manish.sha 125
				JSONObject jsonDataObj = null;
126
				JSONArray jsonObjArr = null;
127
				if(line == null || line.isEmpty()){
128
					sb.append("Flipkart Order Id -"+ fkOrder.getFlipkartOrderId()+" Response - "+line);
129
					sb.append("\n");
130
					continue;
131
				} else if (!line.startsWith("{")){
132
					sb.append("Flipkart Order Id -"+ fkOrder.getFlipkartOrderId()+" Response - "+line);
133
					sb.append("\n");
134
					continue;
135
				}
136
				else{
137
					jsonDataObj = new JSONObject(line);
138
				}
139
 
140
				if(jsonDataObj!=null){
141
					jsonObjArr = new JSONArray(jsonDataObj.get("items").toString());
142
				}
143
 
144
				if(jsonObjArr!=null && jsonObjArr.length()>0){
145
					JSONObject jsonObj = null;
146
					jsonObj = jsonObjArr.getJSONObject(0);
147
					if(jsonObj!=null){
148
						if(jsonObj.get("status")!=null){
149
							String status = jsonObj.get("status").toString();
12607 manish.sha 150
							String statusLabel = jsonObj.get("statusLabel").toString();
151
							if("on_hold".equalsIgnoreCase(status) || "On hold".equalsIgnoreCase(statusLabel)){
12596 manish.sha 152
								pendingOrderList.add(fkOrder);
12589 manish.sha 153
							}
12607 manish.sha 154
							if("approved".equalsIgnoreCase(status) || "Approved".equalsIgnoreCase(statusLabel) || "confirmed".equalsIgnoreCase(statusLabel)){
12589 manish.sha 155
								if(tClient ==null || !tClient.isAlive()){
156
									tClient = transactionServiceClient.getClient();
157
								}
158
								tClient.verifyOrder(fkOrder.getOrderId());
159
								tClient.acceptOrder(fkOrder.getOrderId());
12596 manish.sha 160
								acceptedOrderList.add(fkOrder);
12589 manish.sha 161
							}
12607 manish.sha 162
							if("cancelled".equalsIgnoreCase(status) || "Cancelled".equalsIgnoreCase(statusLabel)){
12589 manish.sha 163
								if(tClient ==null || !tClient.isAlive()){
164
									tClient = transactionServiceClient.getClient();
165
								}
166
								tClient.refundOrder(fkOrder.getOrderId(), "flipkart", "As per Buyer's Request");
12596 manish.sha 167
								cancelledOrderList.add(fkOrder);
12589 manish.sha 168
							}
169
						}else{
12596 manish.sha 170
							errorOrderList.add(fkOrder);
12589 manish.sha 171
						}
172
					}
173
				}
13191 manish.sha 174
				Thread.sleep(3000);
12589 manish.sha 175
			}
176
 
12596 manish.sha 177
			resB.append("Still Pending Orders:-\n");
12605 manish.sha 178
			System.out.println("Still Pending Orders:-");
12596 manish.sha 179
			for(FlipkartOrder order: pendingOrderList){
180
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 181
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 182
			}
183
			resB.append("Accepeted Orders:-\n");
12605 manish.sha 184
			System.out.println("Accepeted Orders:-");
12596 manish.sha 185
			for(FlipkartOrder order: acceptedOrderList){
186
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 187
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 188
			}
189
			resB.append("Cancelled Orders:-\n");
12605 manish.sha 190
			System.out.println("Cancelled Orders:-");
12596 manish.sha 191
			for(FlipkartOrder order: cancelledOrderList){
192
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 193
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 194
			}
195
			resB.append("Response not found Orders:-\n");
12605 manish.sha 196
			System.out.println("Response not found Orders:-");
12596 manish.sha 197
			for(FlipkartOrder order: errorOrderList){
198
				resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
12605 manish.sha 199
				System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
12596 manish.sha 200
			}
201
			String emailSubjectTxt = " Flipkart Hold Order Reconcilaition Process "+sdf.format(cal.getTime());
202
			mailer.sendSSLMessage(sendTo, emailSubjectTxt, resB.toString(), emailFromAddress, password, new ArrayList<File>());
12589 manish.sha 203
			System.out.println(sb.toString());
13243 manish.sha 204
 
205
			bufferedWriter.write(StringUtils.join(new String[] {"FlipkartHoldUpdationDate",sdf.format(new Date())}, '\t'));
206
			bufferedWriter.close();
12596 manish.sha 207
		} catch (Exception e) {
12589 manish.sha 208
			e.printStackTrace();
13182 manish.sha 209
			try{
15737 manish.sha 210
				//mailer.sendSSLMessage(sendTo, "Error in Hold Order Recon Process", "Please inform Engineering Team", emailFromAddress, password, new ArrayList<File>());
13182 manish.sha 211
			}catch (Exception e1) {
212
				e1.printStackTrace();
213
			}
12589 manish.sha 214
		}
215
	}
216
}