/**
* 量测生意-解密流量-流量口分析-7天总数
* http://223.6.252.143:30005/yanShulcsyData1/servencount?thedate=20170609,20170616&seller_id=601879343
* @param datetime
* @param sellerid
* @return
* 7天总数
*/
@RequestMapping(value="/servencount",method = { RequestMethod.POST,
RequestMethod.GET }, produces = "text/json;charset=UTF-8")
public String findServencount(@RequestParam("thedate")Object[] datetime,@RequestParam("seller_id") String sellerid){
String startdate=null;
String enddate=null;
for(int i=0;i<datetime.length;i++){
startdate=datetime[0].toString();
enddate=datetime[1].toString();
System.out.println("startdate=="+startdate+"startdate==="+startdate);
}
System.out.println("seller_id="+sellerid);
if(!AppUtil.isNullorEmpty(startdate)&&!AppUtil.isNullorEmpty(enddate)&&!AppUtil.isNullorEmpty(sellerid)){
//7天总数据
StringBuilder sb=new StringBuilder();
sb.append(" select sum(uv) as 访客数, sum(pv) as 浏览量 , round(sum(cast(pv as float))").append("/").append("sum(cast(uv as float)),4) as 平均访问深度 ,sum(visit_repeat_num) as 新访客数 from [dbo].[ysf_ShopTraffic] where thedate between ? and ? and seller_id=?");
String sql= sb.toString();
//20170705 20170712 1036319921
String[] params={startdate,enddate,sellerid};
Map<String, Object> mps = new Tables().findliangce(sql, params);
if(AppUtil.isNullorEmpty(mps)){
SupperJason jason=new SupperJason();
jason.setResult("0");
return JSON.toJSONString(jason);
}
else{
// System.out.println("maps=="+maps.toString());
return JSON.toJSONString(mps);
}
}
return null ;
}
* 量测生意-解密流量-流量口分析-7天总数
* http://223.6.252.143:30005/yanShulcsyData1/servencount?thedate=20170609,20170616&seller_id=601879343
* @param datetime
* @param sellerid
* @return
* 7天总数
*/
@RequestMapping(value="/servencount",method = { RequestMethod.POST,
RequestMethod.GET }, produces = "text/json;charset=UTF-8")
public String findServencount(@RequestParam("thedate")Object[] datetime,@RequestParam("seller_id") String sellerid){
String startdate=null;
String enddate=null;
for(int i=0;i<datetime.length;i++){
startdate=datetime[0].toString();
enddate=datetime[1].toString();
System.out.println("startdate=="+startdate+"startdate==="+startdate);
}
System.out.println("seller_id="+sellerid);
if(!AppUtil.isNullorEmpty(startdate)&&!AppUtil.isNullorEmpty(enddate)&&!AppUtil.isNullorEmpty(sellerid)){
//7天总数据
StringBuilder sb=new StringBuilder();
sb.append(" select sum(uv) as 访客数, sum(pv) as 浏览量 , round(sum(cast(pv as float))").append("/").append("sum(cast(uv as float)),4) as 平均访问深度 ,sum(visit_repeat_num) as 新访客数 from [dbo].[ysf_ShopTraffic] where thedate between ? and ? and seller_id=?");
String sql= sb.toString();
//20170705 20170712 1036319921
String[] params={startdate,enddate,sellerid};
Map<String, Object> mps = new Tables().findliangce(sql, params);
if(AppUtil.isNullorEmpty(mps)){
SupperJason jason=new SupperJason();
jason.setResult("0");
return JSON.toJSONString(jason);
}
else{
// System.out.println("maps=="+maps.toString());
return JSON.toJSONString(mps);
}
}
return null ;
}