| 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();
|
|
|
52 |
|
| 13243 |
manish.sha |
53 |
public static void main(String[] args) throws IOException{
|
|
|
54 |
File file = new File("/home/manish/alerts/fkhold.txt");
|
|
|
55 |
BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
|
|
|
56 |
|
| 12589 |
manish.sha |
57 |
HttpClient client = new DefaultHttpClient();
|
|
|
58 |
HttpPost post = new HttpPost("https://seller.flipkart.com/login");
|
|
|
59 |
BufferedReader rd= null;
|
|
|
60 |
try {
|
|
|
61 |
List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
|
|
|
62 |
nameValuePairs.add(new BasicNameValuePair("authName",
|
|
|
63 |
"flipkart"));
|
|
|
64 |
nameValuePairs.add(new BasicNameValuePair("username",
|
|
|
65 |
"flipkart-support@saholic.com"));
|
|
|
66 |
nameValuePairs.add(new BasicNameValuePair("password",
|
| 13181 |
manish.sha |
67 |
"bestmobiledeals2010"));
|
|
|
68 |
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 |
69 |
post.addHeader("User-agent", "Mozilla/4.0");
|
|
|
70 |
post.addHeader("Referer", "seller.flipkart.com");
|
| 12589 |
manish.sha |
71 |
post.setEntity(new UrlEncodedFormEntity(nameValuePairs,"utf-8"));
|
|
|
72 |
HttpResponse response = client.execute(post);
|
|
|
73 |
rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
|
|
|
74 |
String line = "";
|
|
|
75 |
HttpGet get_new;
|
|
|
76 |
|
| 12596 |
manish.sha |
77 |
List<FlipkartOrder> pendingOrderList = new ArrayList<FlipkartOrder>();
|
|
|
78 |
List<FlipkartOrder> acceptedOrderList = new ArrayList<FlipkartOrder>();
|
|
|
79 |
List<FlipkartOrder> cancelledOrderList = new ArrayList<FlipkartOrder>();
|
|
|
80 |
List<FlipkartOrder> errorOrderList = new ArrayList<FlipkartOrder>();
|
|
|
81 |
|
| 12589 |
manish.sha |
82 |
while ((line = rd.readLine()) != null) {
|
|
|
83 |
System.out.println(line);
|
|
|
84 |
}
|
|
|
85 |
|
|
|
86 |
//https://seller.flipkart.com/order_management/search_order_items?order_id=OD40827062297&sellerId=m2z93iskuj81qiid
|
|
|
87 |
TransactionClient transactionServiceClient = new TransactionClient();
|
|
|
88 |
in.shop2020.model.v1.order.TransactionService.Client tClient = transactionServiceClient.getClient();
|
|
|
89 |
List<FlipkartOrder> pendingFkOrdersList = tClient.getVerificationPendingOrdersFK();
|
|
|
90 |
StringBuffer sb = new StringBuffer();
|
| 12596 |
manish.sha |
91 |
StringBuffer resB = new StringBuffer();
|
| 12589 |
manish.sha |
92 |
for(FlipkartOrder fkOrder : pendingFkOrdersList){
|
|
|
93 |
get_new = new HttpGet("https://seller.flipkart.com/order_management/search_order_items?order_id="+fkOrder.getFlipkartOrderId()+"&sellerId=m2z93iskuj81qiid");
|
| 13636 |
manish.sha |
94 |
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; is_login=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)");
|
| 12589 |
manish.sha |
95 |
response = client.execute(get_new);
|
|
|
96 |
rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
|
|
|
97 |
line = "";
|
|
|
98 |
line = rd.readLine();
|
| 13194 |
manish.sha |
99 |
System.out.println("Response... "+line);
|
| 12589 |
manish.sha |
100 |
JSONObject jsonDataObj = null;
|
|
|
101 |
JSONArray jsonObjArr = null;
|
|
|
102 |
if(line == null || line.isEmpty()){
|
|
|
103 |
sb.append("Flipkart Order Id -"+ fkOrder.getFlipkartOrderId()+" Response - "+line);
|
|
|
104 |
sb.append("\n");
|
|
|
105 |
continue;
|
|
|
106 |
} else if (!line.startsWith("{")){
|
|
|
107 |
sb.append("Flipkart Order Id -"+ fkOrder.getFlipkartOrderId()+" Response - "+line);
|
|
|
108 |
sb.append("\n");
|
|
|
109 |
continue;
|
|
|
110 |
}
|
|
|
111 |
else{
|
|
|
112 |
jsonDataObj = new JSONObject(line);
|
|
|
113 |
}
|
|
|
114 |
|
|
|
115 |
if(jsonDataObj!=null){
|
|
|
116 |
jsonObjArr = new JSONArray(jsonDataObj.get("items").toString());
|
|
|
117 |
}
|
|
|
118 |
|
|
|
119 |
if(jsonObjArr!=null && jsonObjArr.length()>0){
|
|
|
120 |
JSONObject jsonObj = null;
|
|
|
121 |
jsonObj = jsonObjArr.getJSONObject(0);
|
|
|
122 |
if(jsonObj!=null){
|
|
|
123 |
if(jsonObj.get("status")!=null){
|
|
|
124 |
String status = jsonObj.get("status").toString();
|
| 12607 |
manish.sha |
125 |
String statusLabel = jsonObj.get("statusLabel").toString();
|
|
|
126 |
if("on_hold".equalsIgnoreCase(status) || "On hold".equalsIgnoreCase(statusLabel)){
|
| 12596 |
manish.sha |
127 |
pendingOrderList.add(fkOrder);
|
| 12589 |
manish.sha |
128 |
}
|
| 12607 |
manish.sha |
129 |
if("approved".equalsIgnoreCase(status) || "Approved".equalsIgnoreCase(statusLabel) || "confirmed".equalsIgnoreCase(statusLabel)){
|
| 12589 |
manish.sha |
130 |
if(tClient ==null || !tClient.isAlive()){
|
|
|
131 |
tClient = transactionServiceClient.getClient();
|
|
|
132 |
}
|
|
|
133 |
tClient.verifyOrder(fkOrder.getOrderId());
|
|
|
134 |
tClient.acceptOrder(fkOrder.getOrderId());
|
| 12596 |
manish.sha |
135 |
acceptedOrderList.add(fkOrder);
|
| 12589 |
manish.sha |
136 |
}
|
| 12607 |
manish.sha |
137 |
if("cancelled".equalsIgnoreCase(status) || "Cancelled".equalsIgnoreCase(statusLabel)){
|
| 12589 |
manish.sha |
138 |
if(tClient ==null || !tClient.isAlive()){
|
|
|
139 |
tClient = transactionServiceClient.getClient();
|
|
|
140 |
}
|
|
|
141 |
tClient.refundOrder(fkOrder.getOrderId(), "flipkart", "As per Buyer's Request");
|
| 12596 |
manish.sha |
142 |
cancelledOrderList.add(fkOrder);
|
| 12589 |
manish.sha |
143 |
}
|
|
|
144 |
}else{
|
| 12596 |
manish.sha |
145 |
errorOrderList.add(fkOrder);
|
| 12589 |
manish.sha |
146 |
}
|
|
|
147 |
}
|
|
|
148 |
}
|
| 13191 |
manish.sha |
149 |
Thread.sleep(3000);
|
| 12589 |
manish.sha |
150 |
}
|
|
|
151 |
|
| 12596 |
manish.sha |
152 |
resB.append("Still Pending Orders:-\n");
|
| 12605 |
manish.sha |
153 |
System.out.println("Still Pending Orders:-");
|
| 12596 |
manish.sha |
154 |
for(FlipkartOrder order: pendingOrderList){
|
|
|
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("Accepeted Orders:-\n");
|
| 12605 |
manish.sha |
159 |
System.out.println("Accepeted Orders:-");
|
| 12596 |
manish.sha |
160 |
for(FlipkartOrder order: acceptedOrderList){
|
|
|
161 |
resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
|
| 12605 |
manish.sha |
162 |
System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
|
| 12596 |
manish.sha |
163 |
}
|
|
|
164 |
resB.append("Cancelled Orders:-\n");
|
| 12605 |
manish.sha |
165 |
System.out.println("Cancelled Orders:-");
|
| 12596 |
manish.sha |
166 |
for(FlipkartOrder order: cancelledOrderList){
|
|
|
167 |
resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
|
| 12605 |
manish.sha |
168 |
System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
|
| 12596 |
manish.sha |
169 |
}
|
|
|
170 |
resB.append("Response not found Orders:-\n");
|
| 12605 |
manish.sha |
171 |
System.out.println("Response not found Orders:-");
|
| 12596 |
manish.sha |
172 |
for(FlipkartOrder order: errorOrderList){
|
|
|
173 |
resB.append(order.getOrderId()+" "+ order.getFlipkartOrderId()+"\n");
|
| 12605 |
manish.sha |
174 |
System.out.println(order.getOrderId()+" "+ order.getFlipkartOrderId());
|
| 12596 |
manish.sha |
175 |
}
|
|
|
176 |
String emailSubjectTxt = " Flipkart Hold Order Reconcilaition Process "+sdf.format(cal.getTime());
|
|
|
177 |
mailer.sendSSLMessage(sendTo, emailSubjectTxt, resB.toString(), emailFromAddress, password, new ArrayList<File>());
|
| 12589 |
manish.sha |
178 |
System.out.println(sb.toString());
|
| 13243 |
manish.sha |
179 |
|
|
|
180 |
bufferedWriter.write(StringUtils.join(new String[] {"FlipkartHoldUpdationDate",sdf.format(new Date())}, '\t'));
|
|
|
181 |
bufferedWriter.close();
|
| 12596 |
manish.sha |
182 |
} catch (Exception e) {
|
| 12589 |
manish.sha |
183 |
e.printStackTrace();
|
| 13182 |
manish.sha |
184 |
try{
|
| 13196 |
manish.sha |
185 |
mailer.sendSSLMessage(sendTo, "Error in Hold Order Recon Process", "Please inform Engineering Team", emailFromAddress, password, new ArrayList<File>());
|
| 13182 |
manish.sha |
186 |
}catch (Exception e1) {
|
|
|
187 |
e1.printStackTrace();
|
|
|
188 |
}
|
| 12589 |
manish.sha |
189 |
}
|
|
|
190 |
}
|
|
|
191 |
}
|