当前位置: 首页 > 后端技术 > PHP

近一周及近30天用户数据PHP统计

时间:2023-03-29 18:22:47 PHP

首先这里之前的效果图使用了echarts插件http://echarts.baidu.com/源码部分

按周排列按月排列
这些是html代码,需要导入一个erchars.js文件从上面的网址下载,接下来的统计代码/***VIP列表**/publicfunctionindexOp(){$model_shop=Model('店铺');$model_admin=模型('admin');$model_member=模型('成员');$model_ap=模型('ap');$user=$this->getAdminInfo();$admin=$model_admin->getOneAdmin($user["id"]);if($admin["admin_area"]){$condition["areacode"]=array("in",$admin["admin_area"]);}//ap$shop_id=$model_shop->getShopList($condition,'*');$sid=数组();foreach($shop_idas$shid){$sid[]=$shid["id"];}$condition_ap["shop_id"]=array("in",$sid);如果($_GET['get_data']=='week'){echo$this->get_json_arr(6);}elseif($_GET['get_data']=='month'){echo$this->get_json_arr(30);}else{Tpl::showpage('welcome.index');}}publicfunctionget_json_arr($num=6){$model_shop=Model('shop');$model_ap=模型('ap');//统计商铺for($i=$num;$i>=0;$i--){$daystr=date('Y-m-d',strtotime("-$iday"));$searchstr="TO_DAYS(from_unixtime(addtime,'%Y-%m-%d'))=TO_DAYS('".$daystr."')";$shopCount=$model_shop->where($searchstr)->count();$shopDayCountArray[]=$shopCount;}//统计apfor($i=$num;$i>=0;$i--){$daystr=date('Y-m-d',strtotime("-$iday"));$searchstr="TO_DAYS(from_unixtime(addtime,'%Y-%m-%d'))=TO_DAYS('".$daystr."')";$apCount=$model_ap->where($searchstr)->count();$dateArray[]=date('m-d',strtotime("-$iday"));$apDayCountArray[]=$apCount;}//echo"
";//print_r($dateArray);死亡;if($num==6){$title='上周店铺和AP统计';}else{$title='近一个月店铺和AP统计';}//处理json包$json_arr=array('title'=>array('text'=>$title),'tooltip'=>array('trigger'=>'axis'),'legend'=>array('data'=>array('Shop','AP')),'toolbox'=>array('show'=>true,'feature'=>array('dataZoom'=>array('yAxisIndex'=>'none'),'dataView'=>array('readOnly'=>false),'magicType'=>array('type'=>array('line','bar')),'restore'=>array(),'saveAsImage'=>array()),),'xAxis'=>array('type'=>'category','boundaryGap'=>false,'data'=>$dateArray),'yAxis'=>array('type'=>'value','interval'=>1,'min'=>0,'axisLabel'=>array('formatter'=>'{value}个')),'series'=>array(array('name'=>'商铺','type'=>'line','data'=>$shopDayCountArray),array('name'=>'AP','type'=>'line','data'=>$apDayCountArray)));返回json_encode($json_arr);退出;}