Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
13584 manish.sha 1 
package in.shop2020.serving.services;
2 
 
3 
import in.shop2020.model.v1.order.FlipkartFCWarehouseLocation;
4 
import in.shop2020.model.v1.order.FlipkartFaSalesSnapshot;
5 
import in.shop2020.utils.EmailUtils;
6 
import in.shop2020.utils.FlipkartConsumer;
7 
import in.shop2020.utils.GmailUtils;
8 
 
9 
import java.io.BufferedReader;
10 
import java.io.File;
11 
import java.io.FileWriter;
12 
import java.io.IOException;
13 
import java.io.InputStreamReader;
14 
import java.text.SimpleDateFormat;
15 
import java.util.ArrayList;
16 
import java.util.Calendar;
17 
import java.util.Date;
18 
import java.util.HashMap;
19 
import java.util.List;
20 
import java.util.Map;
21 
 
22 
import org.apache.http.HttpResponse;
23 
import org.apache.http.NameValuePair;
24 
import org.apache.http.client.ClientProtocolException;
25 
import org.apache.http.client.HttpClient;
26 
import org.apache.http.client.entity.UrlEncodedFormEntity;
27 
import org.apache.http.client.methods.HttpGet;
28 
import org.apache.http.client.methods.HttpPost;
29 
import org.apache.http.entity.StringEntity;
30 
import org.apache.http.impl.client.DefaultHttpClient;
31 
import org.apache.http.message.BasicNameValuePair;
32 
import org.json.JSONException;
33 
import org.json.JSONObject;
34 
import org.slf4j.Logger;
35 
import org.slf4j.LoggerFactory;
36 
 
37 
import au.com.bytecode.opencsv.CSVReader;
38 
import au.com.bytecode.opencsv.CSVWriter;
39 
 
40 
 
41 
public class FlipkartFaSaleSnapshotGetter{
42 
	private static Logger logger = LoggerFactory.getLogger(FlipkartFaSaleSnapshotGetter .class);
43 
	private static HttpClient client = new DefaultHttpClient();
44 
 
45 
	public static String getCsrfValue() throws ClientProtocolException, IOException, JSONException{
46 
		HttpResponse response;
47 
 
48 
		BufferedReader rd= null;
49 
		HttpGet get_new;
50 
 
51 
		String line = "";
52 
 
13613 manish.sha 53 
		get_new = new HttpGet("https://seller.flipkart.com/sfx");
13615 manish.sha 54 
		//get_new.addHeader("Cookie"," __isReg=true; s_cc=true;  pincode=110001;is_login=true;sellerId=m2z93iskuj81qiid;km_ai=m2z93iskuj81qiid; km_ni=m2z93iskuj81qiid;");
13636 manish.sha 55 
		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)");
13584 manish.sha 56 
 
57 
		response = client.execute(get_new);
58 
 
59 
		rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
60 
 
61 
		String csrfVal = "";
62 
		while ((line = rd.readLine()) != null) {
63 
			if(line.contains("var seller = ")){
64 
				String desiredLine = line;
65 
				desiredLine = desiredLine.split("var seller = ")[1].trim();
66 
				desiredLine = desiredLine.substring(0, desiredLine.length()-1);
67 
				System.out.println("desiredLine... "+desiredLine);
68 
				JSONObject jsonObj = new JSONObject(desiredLine);
69 
 
70 
				csrfVal=(String)jsonObj.get("csrf");
71 
				System.out.println(csrfVal);
72 
			}
73 
		}
74 
		return csrfVal;
75 
	}
76 
 
77 
	public static void main(String[] args){
78 
		HttpPost post = new HttpPost("https://seller.flipkart.com/login");
79 
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
80 
		SimpleDateFormat repSdf = new SimpleDateFormat("MM-dd-yyyy");
81 
		SimpleDateFormat flipkartRepFormat = new SimpleDateFormat("EEE MMM dd HH:mm:ss Z yyyy");
82 
		Calendar cal1 = Calendar.getInstance();
83 
		Calendar cal2 = Calendar.getInstance();
84 
		cal1.add(Calendar.DAY_OF_MONTH, -5);
85 
		String startDate = sdf.format(cal1.getTime());
86 
		//cal2.add(Calendar.DAY_OF_MONTH, -1);
87 
		String endDate = sdf.format(cal2.getTime());
88 
		cal1.add(Calendar.DAY_OF_MONTH, -1);
89 
		String repStartDate = repSdf.format(cal1.getTime());
90 
		cal2.add(Calendar.DAY_OF_MONTH, -1);
91 
		String repEndDate = repSdf.format(cal2.getTime());
92 
		BufferedReader rd= null;
93 
		Map<Date,Map<String,FlipkartFaSalesSnapshot>> orderDateItemIdFbaSaleSnapshotMap = new HashMap<Date,Map<String,FlipkartFaSalesSnapshot>>();
94 
		List<FlipkartFaSalesSnapshot> flipkartFaSalesSnapshotList = new ArrayList<FlipkartFaSalesSnapshot>();
95 
		Map<Long, Double> skuInventoryPriceMap = new HashMap<Long, Double>();
96 
		try {
97 
			List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
98 
			nameValuePairs.add(new BasicNameValuePair("authName",
99 
			"flipkart"));
100 
			nameValuePairs.add(new BasicNameValuePair("username",
101 
			"flipkart-support@saholic.com"));
102 
			nameValuePairs.add(new BasicNameValuePair("password",
103 
			"bestmobiledeals2010"));
104 
			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)");
105 
			post.addHeader("User-agent", "Mozilla/4.0");
106 
			post.addHeader("Referer", "https://seller.flipkart.com/dashboard");
107 
			post.setEntity(new UrlEncodedFormEntity(nameValuePairs,"utf-8"));
108 
			HttpResponse response = client.execute(post);
109 
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
110 
			String line = "";
111 
			int i=1;
13602 manish.sha 112 
 
13584 manish.sha 113 
			while ((line = rd.readLine()) != null) {
114 
				System.out.println(line);
115 
			}
116 
			HttpPost post_1;
117 
			HttpGet get_new;
118 
			String csrfVal= getCsrfValue();
13602 manish.sha 119 
 
13584 manish.sha 120 
			Thread.sleep(5000);
13602 manish.sha 121 
 
13584 manish.sha 122 
			get_new = new HttpGet("https://seller.flipkart.com/sfx/inventory/stock/download?inventoryType=all&sellerId=m2z93iskuj81qiid&warehouse_id=del");
13636 manish.sha 123 
			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)");
13584 manish.sha 124 
			get_new.addHeader("Connection","keep-alive");
125 
 
126 
			response = client.execute(get_new);
127 
 
128 
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
13602 manish.sha 129 
 
13584 manish.sha 130 
			CSVReader csvInventoryReader = new CSVReader(rd);
131 
			String[] values;
13611 manish.sha 132 
 
133 
			File inventoryFile = new File("/home/FAInventory.csv");
134 
 
135 
			if(inventoryFile.exists()){
136 
				inventoryFile.delete();
137 
			}
13602 manish.sha 138 
 
13587 manish.sha 139 
			CSVWriter writer = new CSVWriter(new FileWriter("/home/FAInventory.csv", true));
13584 manish.sha 140 
			while ((values = csvInventoryReader.readNext()) != null) {
141 
				writer.writeNext(values);
142 
				if(i==1){
143 
					i++;
144 
					continue;
145 
				}
146 
				skuInventoryPriceMap.put(Long.parseLong(values[0]),Double.parseDouble(values[2]));
147 
				i++;
148 
			}
149 
			writer.close();
13602 manish.sha 150 
 
13584 manish.sha 151 
			String paramVal = "{\"fromDate\":\""+startDate+"\",\"toDate\":\""+endDate+"\",\"warehouseId\":\"del\",\"type\":\"InvoiceReport\",\"_csrf\":\""+csrfVal+"\"}";
152 
			System.out.println(paramVal);
153 
			StringEntity entity = new StringEntity(paramVal, "utf-8");
13602 manish.sha 154 
 
155 
 
13584 manish.sha 156 
			post_1 = new HttpPost("https://seller.flipkart.com/sfx/reports/submit?sellerId=m2z93iskuj81qiid");
13636 manish.sha 157 
			post_1.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)");
13584 manish.sha 158 
			post_1.addHeader("fk-csrf-token",csrfVal);
159 
			post_1.addHeader("Content-Type","application/json;charset=UTF-8");
160 
			post_1.addHeader("Host","seller.flipkart.com");
161 
			post_1.addHeader("Origin","https://seller.flipkart.com");
162 
			post_1.addHeader("Accept","application/json, text/plain, *//*");
163 
			post_1.addHeader("Accept-Language","en-US,en;q=0.8");
164 
			post_1.addHeader("Referer","https://seller.flipkart.com/sfx");
165 
			post_1.addHeader("User-Agent","Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.104 Safari/537.36");
166 
 
167 
			post_1.setEntity(entity);
168 
 
169 
			response = client.execute(post_1);
13602 manish.sha 170 
 
13584 manish.sha 171 
			response.getEntity().consumeContent();
172 
 
173 
			Thread.sleep(120000);
13602 manish.sha 174 
 
13584 manish.sha 175 
			//https://seller.flipkart.com/sfx/reports/download/?sellerId=m2z93iskuj81qiid&downloadurl=/reports/invoices/invoice_csv_m2z93iskuj81qiid_09-30-2014_10-30-2014/download_csv
176 
			get_new = new HttpGet("https://seller.flipkart.com/sfx/reports/download/?sellerId=m2z93iskuj81qiid&downloadurl=/reports/invoices/invoice_csv_m2z93iskuj81qiid_"+repStartDate+"_"+repEndDate+"/download_csv");
13636 manish.sha 177 
			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)");
13584 manish.sha 178 
			get_new.addHeader("Connection","keep-alive");
179 
 
180 
			response = client.execute(get_new);
181 
 
13602 manish.sha 182 
 
13584 manish.sha 183 
			rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
13602 manish.sha 184 
 
13584 manish.sha 185 
			i=1;
186 
			CSVReader csvReader = new CSVReader(rd);
187 
			while ((values = csvReader.readNext()) != null) {
188 
				if(i==1){
189 
					i++;
190 
					continue;
191 
				}
192 
				System.out.println(values[0]);
13602 manish.sha 193 
				Date date = flipkartRepFormat.parse(values[5]);
13584 manish.sha 194 
				Date date_key = sdf.parse(sdf.format(date));
13602 manish.sha 195 
				if(!(values[12].equalsIgnoreCase("SalesInvoice")||values[12].equalsIgnoreCase("CourierReturnInvoice")||values[12].equalsIgnoreCase("CustomerReturnInvoice"))){
196 
					i++;
197 
					continue;
198 
				}
199 
				if(orderDateItemIdFbaSaleSnapshotMap.containsKey(date_key)){
200 
					FlipkartFaSalesSnapshot faSalesSnapshot;
201 
					if(orderDateItemIdFbaSaleSnapshotMap.get(date_key).containsKey(values[7])){
202 
						faSalesSnapshot = orderDateItemIdFbaSaleSnapshotMap.get(date_key).get(values[7]);
203 
						if(values[12].equalsIgnoreCase("SalesInvoice")){
204 
							faSalesSnapshot.setTotalOrderCount(faSalesSnapshot.getTotalOrderCount()+Integer.parseInt(values[13]));
205 
							faSalesSnapshot.setTotalSale(faSalesSnapshot.getTotalSale()+ Double.parseDouble(values[9]));
13584 manish.sha 206 
						}
13602 manish.sha 207 
						if(values[12].equalsIgnoreCase("CourierReturnInvoice")||values[12].equalsIgnoreCase("CustomerReturnInvoice")){
208 
							faSalesSnapshot.setTotalOrderCount(faSalesSnapshot.getTotalOrderCount()+0);
209 
							faSalesSnapshot.setTotalSale(faSalesSnapshot.getTotalSale()+0.0);
210 
							faSalesSnapshot.setReturnQuantity(faSalesSnapshot.getReturnQuantity()+Integer.parseInt(values[13]));
211 
							faSalesSnapshot.setReturnValue(faSalesSnapshot.getReturnValue()+Double.parseDouble(values[9]));
212 
						}
213 
						Map<String,FlipkartFaSalesSnapshot> itemIdFaSnapshotMap = orderDateItemIdFbaSaleSnapshotMap.get(date_key);
214 
						itemIdFaSnapshotMap.put(values[7], faSalesSnapshot);
215 
						orderDateItemIdFbaSaleSnapshotMap.put(date_key, itemIdFaSnapshotMap);
216 
					} else{
217 
						faSalesSnapshot = new FlipkartFaSalesSnapshot();
13584 manish.sha 218 
						faSalesSnapshot.setDateOfSale(date_key.getTime());
219 
						faSalesSnapshot.setItem_id(Long.parseLong(values[7]));
220 
						faSalesSnapshot.setOurPrice(Double.parseDouble(values[9])/Double.parseDouble(values[13]));
221 
						if(values[12].equalsIgnoreCase("SalesInvoice")){
222 
							faSalesSnapshot.setTotalOrderCount(Integer.parseInt(values[13]));
223 
							faSalesSnapshot.setTotalSale(Double.parseDouble(values[9]));
13602 manish.sha 224 
						}
225 
						if(values[12].equalsIgnoreCase("CourierReturnInvoice")||values[12].equalsIgnoreCase("CustomerReturnInvoice")){
13584 manish.sha 226 
							faSalesSnapshot.setTotalOrderCount(0);
227 
							faSalesSnapshot.setTotalSale(0.0);
228 
							faSalesSnapshot.setReturnQuantity(Integer.parseInt(values[13]));
229 
							faSalesSnapshot.setReturnValue(Double.parseDouble(values[9]));
230 
						}
231 
						faSalesSnapshot.setFcLocation(FlipkartFCWarehouseLocation.Delhi);
232 
						faSalesSnapshot.setIsOutOfStock(false);
13602 manish.sha 233 
						Map<String,FlipkartFaSalesSnapshot> itemIdFaSnapshotMap = orderDateItemIdFbaSaleSnapshotMap.get(date_key);
13584 manish.sha 234 
						itemIdFaSnapshotMap.put(values[7], faSalesSnapshot);
235 
						orderDateItemIdFbaSaleSnapshotMap.put(date_key, itemIdFaSnapshotMap);
236 
					}
13602 manish.sha 237 
				} else {
238 
					FlipkartFaSalesSnapshot faSalesSnapshot = new FlipkartFaSalesSnapshot();
239 
					faSalesSnapshot.setDateOfSale(date_key.getTime());
240 
					faSalesSnapshot.setItem_id(Long.parseLong(values[7]));
241 
					faSalesSnapshot.setOurPrice(Double.parseDouble(values[9])/Double.parseDouble(values[13]));
242 
					if(values[12].equalsIgnoreCase("SalesInvoice")){
243 
						faSalesSnapshot.setTotalOrderCount(Integer.parseInt(values[13]));
244 
						faSalesSnapshot.setTotalSale(Double.parseDouble(values[9]));
245 
					}
246 
					if(values[12].equalsIgnoreCase("CourierReturnInvoice")||values[12].equalsIgnoreCase("CustomerReturnInvoice")){
247 
						faSalesSnapshot.setTotalOrderCount(0);
248 
						faSalesSnapshot.setTotalSale(0.0);
249 
						faSalesSnapshot.setReturnQuantity(Integer.parseInt(values[13]));
250 
						faSalesSnapshot.setReturnValue(Double.parseDouble(values[9]));
251 
					}
252 
					faSalesSnapshot.setFcLocation(FlipkartFCWarehouseLocation.Delhi);
253 
					faSalesSnapshot.setIsOutOfStock(false);
254 
					Map<String,FlipkartFaSalesSnapshot> itemIdFaSnapshotMap = new HashMap<String,FlipkartFaSalesSnapshot>();
255 
					itemIdFaSnapshotMap.put(values[7], faSalesSnapshot);
256 
					orderDateItemIdFbaSaleSnapshotMap.put(date_key, itemIdFaSnapshotMap);
257 
				}
258 
				i++;
13584 manish.sha 259 
			}
13602 manish.sha 260 
 
13584 manish.sha 261 
			for(Long itemId : skuInventoryPriceMap.keySet()){
262 
				for(Date dateOfSale : orderDateItemIdFbaSaleSnapshotMap.keySet()){
263 
					if(orderDateItemIdFbaSaleSnapshotMap.get(dateOfSale).containsKey(itemId.toString())){
264 
						continue;
265 
					}else{
266 
						FlipkartFaSalesSnapshot faSalesSnapshot = new FlipkartFaSalesSnapshot();
267 
						faSalesSnapshot.setItem_id(itemId);
268 
						faSalesSnapshot.setDateOfSale(dateOfSale.getTime());
269 
						faSalesSnapshot.setOurPrice(skuInventoryPriceMap.get(itemId));
270 
						faSalesSnapshot.setTotalOrderCount(0);
271 
						faSalesSnapshot.setTotalSale(0.0);
272 
						faSalesSnapshot.setReturnQuantity(0);
273 
						faSalesSnapshot.setReturnValue(0.0);
274 
						faSalesSnapshot.setIsOutOfStock(true);
275 
						faSalesSnapshot.setFcLocation(FlipkartFCWarehouseLocation.Delhi);
276 
						orderDateItemIdFbaSaleSnapshotMap.get(dateOfSale).put(itemId.toString(), faSalesSnapshot);
277 
					}
278 
				}
279 
			}
13602 manish.sha 280 
 
13584 manish.sha 281 
			for(Date dateOfSale : orderDateItemIdFbaSaleSnapshotMap.keySet()){
282 
				Map<String,FlipkartFaSalesSnapshot> itemIdFaSnapshotMap = orderDateItemIdFbaSaleSnapshotMap.get(dateOfSale);
283 
				for(String itemId : itemIdFaSnapshotMap.keySet()){
284 
					flipkartFaSalesSnapshotList.add(itemIdFaSnapshotMap.get(itemId));
285 
				}
286 
			}
287 
			boolean valuesUpdated = FlipkartConsumer.bulkAddOrUpdateFlipkartFbaSalesSnapshot(flipkartFaSalesSnapshotList);
13602 manish.sha 288 
 
13584 manish.sha 289 
			if(valuesUpdated){
290 
				System.out.println("Values are updated");
291 
			}
292 
 
293 
		}
294 
		catch(Exception e){
13612 manish.sha 295 
			e.printStackTrace();
13587 manish.sha 296 
			String[] sendTo = new String[] { "manish.sharma@shop2020.in","kshitij.sood@shop2020.in","amit.gupta@shop2020.in","anikendra.das@shop2020.in"};
13602 manish.sha 297 
			String emailSubjectTxt = "Error while generating Flipkart Sale Snapshot";
298 
			String message = "Run FlipkartFaSaleSnapshotGetter in Common Project. \nSend all Flipkart Reports Again. \nJobs are configured at Support-backup Machine";
299 
			try {
300 
				GmailUtils mailer = new GmailUtils();
13620 manish.sha 301 
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, message, "build-staging@shop2020.in", "shop2020", new ArrayList<File>());
13602 manish.sha 302 
			} catch (Exception ex) {
303 
				ex.printStackTrace();
304 
 
305 
			}
13584 manish.sha 306 
		}
307 
	}
308 
}