WebSVN – SmartDukaan – Diff – /trunk/Common/src/main/java/in/shop2020/serving/services/FetchNewFlipCartOrders.java

 			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
 			String line = "";
 			Gson gson;
 			List<Order> orders = new ArrayList<Order>();
 			OrderItems new_orders;
-			OrderItems conf_orders;
 			HttpGet get_new;
-			HttpGet get_conf;
-			long time;
 			int i=1;
 			while ((line = rd.readLine()) != null) {
 				System.out.println(line);
+			}
-			time = System.currentTimeMillis();
 			while(true){
-				get_new = new HttpGet("https://seller.flipkart.com/dashboard/som/new_order_items?status=on_hold%2Capproved.payment_approved&sort=confirm_by_date&page="+i+"&page_size=100&_="+time);
-				//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=");
+				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");
-				get_new.addHeader("Cookie","T=TI138130450866706710769873257251497444628820234222703981199700765991; __gads=ID=dfe0374cf04d1576:T=1381304511:S=ALNI_Ma2TpDrlF9_amkoqp3MOYJBaFAOUg; km_lv=x; __sonar=6631097455123118581; aid=hza%2BEupBpLdvNfHSTTVkzPDeZavQVl0jiaoxm60MwkPxf6e9zXq1Ho9iF8zyzcFU; __isReg=true; S=d1t12jFfBeu92qxIHRlvZT9LAVzb3n%2B79fEDwno5E%2FvZDEo1Syw0WInkl26DP7Ao0ZahzYI9eBXeTU%2BPOKG2zwpIPkQ%3D%3D; __utma=19769839.1733153395.1408690721.1412567812.1412571695.8; __utmb=19769839.210.9.1412578093111; __utmc=19769839; __utmz=19769839.1409028689.3.2.utmcsr=savemoneyindia.com|utmccn=(referral)|utmcmd=referral|utmcct=/; s_cc=true; gpv_pn=FozPage; gpv_pn_t=no%20value; s_sq=%5B%5BB%5D%5D; pincode=110001; s_ppv=61; SN=2.VI4876EB87B4D54359BF5BDC59495E6FAC.SI6012869365F2495BA20E3841985048BE.VS141257169849670393137.1412582357; VID=2.VI4876EB87B4D54359BF5BDC59495E6FAC.1412582357.VS141257169849670393137; NSID=2.SI6012869365F2495BA20E3841985048BE.1412582357.VI4876EB87B4D54359BF5BDC59495E6FAC; __utmt=1; connect.sid=s%3AWwlGdtrLzj38cMjvZPI6ib5J.YUhinXC189untGw58i2CE9k7BGgKQJs9L%2BVIYPIW9Ok; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1156779613.1390806906.1412575623.1412581840.30; __utmb=143439159.7.9.1412582883309; __utmc=143439159; __utmz=143439159.1390806906.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1156779613.1390806906; kvcd=1412583087629; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
+				get_new.addHeader("Cookie","T=TI138130450866706710769873257251497444628820234222703981199700765991; __gads=ID=dfe0374cf04d1576:T=1381304511:S=ALNI_Ma2TpDrlF9_amkoqp3MOYJBaFAOUg; km_lv=x; pincode=110001; __sonar=6631097455123118581; S=d1t173VTuVxLMgd3in7R3mbHGNz0STqFkHgnidNrhKqBdz8wEKt%2BO9d%2B%2FRDHtf6fmq2ugaE7nZHV7zYSxOLcWBzq31A%3D%3D; __isReg=true; AFFID=contactsav; s_cc=true; s_sq=%5B%5BB%5D%5D; __utma=19769839.1733153395.1408690721.1413449375.1414584301.20; __utmc=19769839; __utmz=19769839.1414584301.20.3.utmcsr=savemoneyindia.com|utmccn=(referral)|utmcmd=referral|utmcct=/; SN=2.VIB1DBEC9C6CD94162ACB61060135212D1.SI47EBA2DE47044D0AA7C05F24AD4F42EB.VS141458430307180444379.1414584302; VID=2.VIB1DBEC9C6CD94162ACB61060135212D1.1414584302.VS141458430307180444379; NSID=2.SI47EBA2DE47044D0AA7C05F24AD4F42EB.1414584302.VIB1DBEC9C6CD94162ACB61060135212D1; s_ppv=18; connect.sid=s%3ANdpq7cPYsBMoYM5bKXqEOH3%2F.HskhywfXpyD0pzgOVJMWmzju1lPL9%2B1VGRinaTcKo3A; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1156779613.1390806906.1413548938.1414650817.38; __utmb=143439159.10.10.1414650817; __utmc=143439159; __utmz=143439159.1390806906.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1156779613.1390806906; kvcd=1414651844807; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
-				/*get_new.addHeader("User-agent", "Mozilla/4.0");
-				get_new.addHeader("Referer", "https://seller.flipkart.com/dashboard");*/
 				response = client.execute(get_new);
 				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
 				line = "";
 				gson = new Gson();
 				new_orders = (OrderItems) gson.fromJson(rd, OrderItems.class);
-				if(new_orders.getOrder_items().size()>0){
+				if(new_orders.getItems().size()>0){
-					orders.addAll(new_orders.getOrder_items());
+					orders.addAll(new_orders.getItems());
+				}
 				else{
 					break;
+				}
-				i++;
-			}
-			i=1;
-			time = System.currentTimeMillis();
-			while(true){
-				get_conf = new HttpGet("https://seller.flipkart.com/dashboard/som/confirmed_order_items?status=approved.seller_approved&sort=confirm_by_date&page="+i+"&page_size=100&_="+time);
-				//get_conf.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=");
-				get_conf.addHeader("Cookie","T=TI138130450866706710769873257251497444628820234222703981199700765991; __gads=ID=dfe0374cf04d1576:T=1381304511:S=ALNI_Ma2TpDrlF9_amkoqp3MOYJBaFAOUg; km_lv=x; __sonar=6631097455123118581; aid=hza%2BEupBpLdvNfHSTTVkzPDeZavQVl0jiaoxm60MwkPxf6e9zXq1Ho9iF8zyzcFU; __isReg=true; S=d1t12jFfBeu92qxIHRlvZT9LAVzb3n%2B79fEDwno5E%2FvZDEo1Syw0WInkl26DP7Ao0ZahzYI9eBXeTU%2BPOKG2zwpIPkQ%3D%3D; __utma=19769839.1733153395.1408690721.1412567812.1412571695.8; __utmb=19769839.210.9.1412578093111; __utmc=19769839; __utmz=19769839.1409028689.3.2.utmcsr=savemoneyindia.com|utmccn=(referral)|utmcmd=referral|utmcct=/; s_cc=true; gpv_pn=FozPage; gpv_pn_t=no%20value; s_sq=%5B%5BB%5D%5D; pincode=110001; s_ppv=61; SN=2.VI4876EB87B4D54359BF5BDC59495E6FAC.SI6012869365F2495BA20E3841985048BE.VS141257169849670393137.1412582357; VID=2.VI4876EB87B4D54359BF5BDC59495E6FAC.1412582357.VS141257169849670393137; NSID=2.SI6012869365F2495BA20E3841985048BE.1412582357.VI4876EB87B4D54359BF5BDC59495E6FAC; __utmt=1; connect.sid=s%3AWwlGdtrLzj38cMjvZPI6ib5J.YUhinXC189untGw58i2CE9k7BGgKQJs9L%2BVIYPIW9Ok; is_login=true; sellerId=m2z93iskuj81qiid; __utma=143439159.1156779613.1390806906.1412575623.1412581840.30; __utmb=143439159.7.9.1412582883309; __utmc=143439159; __utmz=143439159.1390806906.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.2.1156779613.1390806906; kvcd=1412583087629; km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid; km_vs=1; km_uq=");
+				if(!new_orders.isHasMore())
-				response = client.execute(get_conf);
-				rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
-				line = "";
-				gson = new Gson();
-				conf_orders = (OrderItems) gson.fromJson(rd, OrderItems.class);
-				if(conf_orders.getOrder_items().size()>0){
-					orders.addAll(conf_orders.getOrder_items());
-				}
-				else{
 					break;
-				}
 				i++;
+			}
 			for(Order order:orders){
-				System.out.println("Order  " + order.getExternalId() +" "+order.getOrderItemId() + " : "+ order.getStatus() + " "+order.getStatusDateMessage() + " "
+				System.out.println("Order  " + order.getOrderId() +" "+order.getOrderItemId() + " : "+ order.getStatus() + " "+order.getStatusLabel() + " "
-						+ order.getStatusLabel() + " " + order.getPickup_by_date() + " "+ order.getTrackingId());
+						 + order.getConfirmByDate() + " "+ order.getTrackingId());
 				/*if(order.getFreebie_items()!=null && order.getFreebie_items().size()>0){
 					System.out.println("Freebie Item ID :"+order.getFreebie_items().get(0).getSku());
 				}*/
+			}
 			processOrders(orders);
 		int not_approved = 0;
 		for(Order order : orders){
 			String status = "";
 			boolean isHold = false;
 			total_orders++;
-			if(order.getExternalId().length()==0 || order.getOrderItemId().length()==0 ){
+			if(order.getOrderId().length()==0 || order.getOrderId().length()==0 ){
-				sb.append(" Could not parse order id " + order.getExternalId()+ " " + order.getExternalId() + "\n");
+				sb.append(" Could not parse order id " + order.getOrderId()+ " " + order.getOrderItemId() + "\n");
 				continue;
+			}
 			else{
-				logger.info("Processing Order  " +  order.getExternalId() + " " + order.getOrderItemId());
+				logger.info("Processing Order  " +  order.getOrderId() + " " + order.getOrderItemId());
-				orderId = order.getExternalId();
+				orderId = order.getOrderId();
 				subOrderId = order.getOrderItemId();
+			}
-			if(order.getCreatedDate()!=null){
+			if(order.getOrderDate()!=null){
-				create_date = order.getCreatedDate()+" "+order.getCreatedTime();
+				create_date = order.getOrderDate()+" "+order.getCreatedTime();
+			}
 			else{
 				sb.append(orderId+" "+subOrderId + " Could not parse order date" +"\n");
 				logger.info(orderId+" "+subOrderId + " Could not parse order date");
 				continue;
+			}
-			if(order.getService_profile()!=null && "NON_FBF".equalsIgnoreCase(order.getService_profile())){
+			/*if(order.getService_profile()!=null && "NON_FBF".equalsIgnoreCase(order.getService_profile())){
 				String fulfillByUs = order.getService_profile();
 			} else {
 				fa_orders++;
 				continue;
-			}
+			}*/
-			if(order.getPickup_by_date()!=null){
+			if(order.getConfirmByDate()!=null){
-				ship_date = order.getPickup_by_date();
+				ship_date = order.getConfirmByDate();
+			}
 			if(order.getSku().equals("")){
 				sb.append(orderId+" "+subOrderId + " Could not parse sku" +"\n");
 				logger.info(orderId+" "+subOrderId + " Could not parse sku");
 				continue;
 				logger.info(orderId+" "+subOrderId + " Ship to date not available " +"\n");
 				continue;
+			}
 			//String shipByDate = nextLine[26];
 			SimpleDateFormat createDateFormatter = new SimpleDateFormat("MMM dd, yyyy hh:mm aaa");
-			SimpleDateFormat shipDateFormatter = new SimpleDateFormat("MMM dd, yyyy");
+			SimpleDateFormat shipDateFormatter = new SimpleDateFormat("MMM dd, yyyy HH:mm:ss aaa");//Nov 01, 2014 11:59:59 PM
 			Date flipkartTxnDate = null;
 			Date shipByDate = null;
 			try {
 				flipkartTxnDate = createDateFormatter.parse(create_date);
 			} catch (ParseException e) {
 				logger.error(orderId+" "+subOrderId + " Could not parse flipkart order date from file " , e);
 				sb.append(orderId+" "+subOrderId + " Could not parse order date" +"\n");
 				continue;
+			}
-			if(ship_date!=null){
+			if(ship_date!=null && ship_date.length()>0){
 				try {
 					shipByDate = shipDateFormatter.parse(ship_date);
 				} catch (ParseException e) {
 					logger.error(orderId+" "+subOrderId + " ship date " , e);
 					sb.append(orderId+" "+subOrderId + "cannot parse ship date" +"\n");

Subversion Repositories SmartDukaan

(root)/trunk/Common/src/main/java/in/shop2020/serving/services/FetchNewFlipCartOrders.java – Rev 12971 → 12974