public JsonResult GetWeiChatTrends(string startDate, string endDate)
{
if (string.IsNullOrWhiteSpace(startDate))
{
startDate = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
}
if (string.IsNullOrWhiteSpace(endDate))
{
endDate = DateTime.Now.ToString("yyyy-MM-dd");
}
//todo:返回微信指数
string url = "http://zhishu.sogou.com/getDateData?kwdNamesStr=%E6%A2%B5%E8%AE%AF%E6%88%BF%E5%B1%8B%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F,%E6%88%BF%E5%8F%8B,%E5%A5%BD%E6%88%BF%E9%80%9A,%E6%98%93%E6%88%BF%E5%A4%A7%E5%B8%88,%E6%88%BF%E5%9C%A8%E7%BA%BF"
+ $"&startDate={startDate.Replace("-","")}&endDate={endDate.Replace("-", "")}&dataType=MEDIA_WECHAT&queryType=INPUT";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "GET";
var response = request.GetResponse();
var sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
string retXml = sr.ReadToEnd();
sr.Close();
WeiChatTrendsModel r = JsonConvert.DeserializeObject <WeiChatTrendsModel>(retXml);
//TrendsModel trendsModel = new TrendsModel();
//trendsModel.Fooww = r.Data.PvList[0].Select(p => new string[] { p.PV.ToString(), DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString() }).ToList();
//trendsModel.FangYou = r.Data.PvList[1].Select(p => new string[] { p.PV, DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture) }).ToList();
//trendsModel.HaoFangTong = r.Data.PvList[2].Select(p => new string[] { p.PV, DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture) }).ToList();
//trendsModel.YiFangDaShi = r.Data.PvList[3].Select(p => new string[] { p.PV, DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture) }).ToList();
//trendsModel.FangZaiXian = r.Data.PvList[4].Select(p => new string[] { p.PV, DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture) }).ToList();
List <List <string[]> > model = new List <List <string[]> >();
model.Add(r.Data.PvList[0].Select(p => new string[] { DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"), p.PV.ToString() }).ToList());
model.Add(r.Data.PvList[1].Select(p => new string[] { DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"), p.PV.ToString() }).ToList());
model.Add(r.Data.PvList[2].Select(p => new string[] { DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"), p.PV.ToString() }).ToList());
model.Add(r.Data.PvList[3].Select(p => new string[] { DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"), p.PV.ToString() }).ToList());
model.Add(r.Data.PvList[4].Select(p => new string[] { DateTime.ParseExact(p.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"), p.PV.ToString() }).ToList());
return(Json(model));
}
public JsonResult GetTrends(string startDate, string endDate)
{
if (string.IsNullOrWhiteSpace(startDate))
{
startDate = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
}
if (string.IsNullOrWhiteSpace(endDate))
{
endDate = DateTime.Now.ToString("yyyy-MM-dd");
}
//todo:返回所有竞品数据
Process p = new Process();
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "baidu/demo.py");
string sArguments = $"{path} {startDate} {endDate}";
p.StartInfo.FileName = m_configuration["Python"];
p.StartInfo.Arguments = sArguments;
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.RedirectStandardInput = true;
p.StartInfo.RedirectStandardError = true;
p.StartInfo.CreateNoWindow = true;
p.Start();
StreamReader sReader = p.StandardOutput;
string[] output = sReader.ReadToEnd().Split('\r');
TrendsModel trendsModel = new TrendsModel();
trendsModel.Fooww = JsonConvert.DeserializeObject <List <Trend> >(output[0]);
trendsModel.FangYou = JsonConvert.DeserializeObject <List <Trend> >(output[1]);
trendsModel.HaoFangTong = JsonConvert.DeserializeObject <List <Trend> >(output[2]);
trendsModel.YiFangDaShi = JsonConvert.DeserializeObject <List <Trend> >(output[3]);
trendsModel.FangZaiXian = JsonConvert.DeserializeObject <List <Trend> >(output[4]);
//trendsModel.FangWangTong = JsonConvert.DeserializeObject<List<Trend>>(output[5]);
//todo:返回微信指数
string url = "http://zhishu.sogou.com/getDateData?kwdNamesStr=%E6%A2%B5%E8%AE%AF%E6%88%BF%E5%B1%8B%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F,%E6%88%BF%E5%8F%8B,%E5%A5%BD%E6%88%BF%E9%80%9A,%E6%98%93%E6%88%BF%E5%A4%A7%E5%B8%88,%E6%88%BF%E5%9C%A8%E7%BA%BF"
+ $"&startDate={startDate.Replace("-", "")}&endDate={endDate.Replace("-", "")}&dataType=SEARCH_ALL&queryType=INPUT";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "GET";
var response = request.GetResponse();
var sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
string retXml = sr.ReadToEnd();
sr.Close();
WeiChatTrendsModel r = JsonConvert.DeserializeObject <WeiChatTrendsModel>(retXml);
trendsModel.Fooww.AddRange(r.Data.PvList[0].Select(x => new Trend {
Index = x.PV, Date = DateTime.ParseExact(x.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)
}));
trendsModel.FangYou.AddRange(r.Data.PvList[1].Select(x => new Trend {
Index = x.PV, Date = DateTime.ParseExact(x.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)
}));
trendsModel.HaoFangTong.AddRange(r.Data.PvList[2].Select(x => new Trend {
Index = x.PV, Date = DateTime.ParseExact(x.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)
}));
trendsModel.YiFangDaShi.AddRange(r.Data.PvList[3].Select(x => new Trend {
Index = x.PV, Date = DateTime.ParseExact(x.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)
}));
trendsModel.FangZaiXian.AddRange(r.Data.PvList[4].Select(x => new Trend {
Index = x.PV, Date = DateTime.ParseExact(x.Date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)
}));
trendsModel.Fooww = trendsModel.Fooww.GroupBy(x => new { x.Date }).Select(group => new Trend {
Index = group.Sum(g => g.Index), Date = group.Key.Date
}).ToList();
trendsModel.FangYou = trendsModel.FangYou.GroupBy(x => new { x.Date }).Select(group => new Trend {
Index = group.Sum(g => g.Index), Date = group.Key.Date
}).ToList();
trendsModel.HaoFangTong = trendsModel.HaoFangTong.GroupBy(x => new { x.Date }).Select(group => new Trend {
Index = group.Sum(g => g.Index), Date = group.Key.Date
}).ToList();
trendsModel.YiFangDaShi = trendsModel.YiFangDaShi.GroupBy(x => new { x.Date }).Select(group => new Trend {
Index = group.Sum(g => g.Index), Date = group.Key.Date
}).ToList();
trendsModel.FangZaiXian = trendsModel.FangZaiXian.GroupBy(x => new { x.Date }).Select(group => new Trend {
Index = group.Sum(g => g.Index), Date = group.Key.Date
}).ToList();
List <List <string[]> > model = new List <List <string[]> >();
model.Add(trendsModel.Fooww.Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
model.Add(trendsModel.FangYou.Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
model.Add(trendsModel.HaoFangTong.Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
model.Add(trendsModel.YiFangDaShi.Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
model.Add(trendsModel.FangZaiXian.Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
//List<List<string[]>> model = new List<List<string[]>>();
//model.Add(JsonConvert.DeserializeObject<List<Trend>>(output[0]).Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
//model.Add(JsonConvert.DeserializeObject<List<Trend>>(output[1]).Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
//model.Add(JsonConvert.DeserializeObject<List<Trend>>(output[2]).Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
//model.Add(JsonConvert.DeserializeObject<List<Trend>>(output[3]).Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
//model.Add(JsonConvert.DeserializeObject<List<Trend>>(output[4]).Select(a => new string[] { a.Date.ToString("yyyy-MM-dd"), a.Index.ToString() }).ToList());
return(Json(model));
}
