统计图

index.html

<div id="index_public_main" class="easyui-panel" data-options="fit:true,title:'<{$currentpos}>',border:false">
    <div id="users_index_datalist_datagrid_toolbar" class="datagrid-toolbar" style="">
        <form style="margin-bottom:1px;padding:5px">       
            类型：
            <select class="easyui-combobox" id="types" name="search[type]" style="150px;">
                <option value="none">==请选择查询分类==</option>
                <option value="loginDay">每日用户登录</option>
                <option value="regDay">网站每日注册</option>
                <option value="paysuccess">用户充值统计</option>
                <option value="carryMoney">用户提现统计</option>
                <option value="investMoney">每日投资统计</option>
                <option value="repayMoney">每日还款统计</option>
                <option value="repayManFee">每日收取管理费</option>
            </select> &nbsp;&nbsp;
            开始日期: 
            <input class="easyui-datebox searchfield validatebox-text" type="text" name="search[starttime]" style="150px;">
            结束日期:
            <input class="easyui-datebox searchfield validatebox-text" type="text" name="search[endtime]" style="150px;">
            <a href="javascript:;" onclick="doSearch(this)" class="easyui-linkbutton l-btn" iconcls="icons-map-magnifier" group="" id=""><span class="l-btn-left">搜索</span></a>
        </form>
    </div>

    <div id="container" style="height: 400px; margin: 0 auto"></div>
    <div id="containers" style="height: 400px; margin: 0 auto"></div>
</div> 

<script type="text/javascript">
var loading=0;
function doSearch(that) {
    if (loading==0 && $('#types').combobox('getValue')!="none") {
        loading=1;
        $('#container').html("");
        $('#containers').html("");
        $.post('<{:U('Tongji/index')}>', $(that).parent('form').serialize(), function(data){
            loading=0;
            var res= eval('(' + data + ')');
            var obj={
                title: {text: res['title']},
                xAxis: {categories: res['xaxisv']},
                yAxis: {
                    title: {text: res['unit']},
                    plotLines: [{value: 0, 1,color: '#808080'}]
                },
                legend: {enabled: false},
                tooltip: {valueSuffix:res['unitsimple']},
                series: [{
                    name: res['subtitle'],
                    data: res['yaxisv']
                }]
            };
            
            
            $('#container').highcharts(obj);
            if($('#types').combobox('getValue')=="paysuccess"){
                 var objs={
                    title: {text: res['titles']},
                    xAxis: {categories: res['xaxisvs']},
                    yAxis: {
                        title: {text: res['unit']},
                        plotLines: [{value: 0, 1,color: '#808080'}]
                    },
                    legend: {enabled: false},
                    tooltip: {valueSuffix:res['unitsimple']},
                    series: [{
                        name: res['subtitle'],
                        data: res['yaxisvs']
                    }]
                };
                
                $('#containers').highcharts(objs);
            }
        });
    }
}

</script>

TongjiController.class.php

public function index(){
        if(IS_POST) {
        $search=I('post.search');
        $type=$search['type'];
        $starttime=$search['starttime'];
        $endtime=$search['endtime'];
        
            if (!$starttime && !$endtime) {
                $starttime=date('Y-m-d',strtotime('-9 days'));
                $endtime=date('Y-m-d');
            } else if ($starttime && !$endtime) {
                $endtime=date('Y-m-d');
            } else {
                $starttime=min($starttime,$endtime);
                $endtime=max($starttime,$endtime);
            }
            $data=M('Tongji')->where("title='%s' AND datetime>='%d' AND datetime<='%d'",$type,date('Ymd',strtotime($starttime)),date('Ymd',strtotime($endtime)))->select();
            foreach ($data as $val) {
                $temp[$val['datetime']]=$val['nums'];
            }
            for($i=date('Ymd',strtotime($starttime));$i<=date('Ymd',strtotime($endtime));$i++) {
                $xaxisv[]=date('m-d',strtotime($i));
                $v=$temp[date('Ymd',strtotime($i))];
                $yaxisv[]=floatval($v)?floatval($v):0;
            }    
            
            //近12个月的用户充值统计 开始
            //获取12个月到现在的数据
            $sql="select zx_recharge.* from (select *,from_unixtime(paytime,'%Y-%m-%d') as datetime from zx_recharge) zx_recharge where  DATE_FORMAT(datetime,'%Y-%m')>DATE_FORMAT(date_sub(curdate(), interval 12 month),'%Y-%m')";
            $datab=M('recharge')->query($sql);
            //过去12个月中每个月money列的数据之和
            foreach($datab as $v){
                $str=$v['datetime'];
                $stra=substr($str,0,7);
                $re[$stra][] = $v['money'];
            }
            
            foreach($re as $k=>$v){
                
                foreach($v as $vv){
                    
                    $attr[$k]+=$vv;    
                    
                }
                $xaxisvs[]=$k;
            }
            foreach($attr as $v){
                
                $yaxisvs[]=$v;    
            }
            //近12个月的用户充值统计 结束
            
            $conf=array(
                'paysuccess'=>array('title'=>'用户充值统计','titles'=>'近12个月用户充值统计','subtitle'=>'充值金额','unit'=>'金额（元）','unitsimple'=>'元'),
                'carryMoney'=>array('title'=>'用户提现统计','subtitle'=>'提现金额','unit'=>'金额（元）','unitsimple'=>'元'),
                'investMoney'=>array('title'=>'用户投资统计','subtitle'=>'投资金额','unit'=>'金额（元）','unitsimple'=>'元'),
                'repayMoney'=>array('title'=>'借款者还款统计','subtitle'=>'还款金额','unit'=>'金额（元）','unitsimple'=>'元'),
                'repayManFee'=>array('title'=>'每日收取管理费统计','subtitle'=>'总管理费','unit'=>'金额（元）','unitsimple'=>'元'),
                'loginDay'=>array('title'=>'每日登录用户统计','subtitle'=>'登录人数','unit'=>'人数','unitsimple'=>'人'),
                'regDay'=>array('title'=>'每日注册用户统计','subtitle'=>'注册人数','unit'=>'人数','unitsimple'=>'人'),
            );

            $info['title']=$conf[$type]['title'];
            $info['titles']=$conf[$type]['titles'];
            $info['subtitle']=$conf[$type]['subtitle'];
            $info['unit']=$conf[$type]['unit'];
            $info['unitsimple']=$conf[$type]['unitsimple'];
            $info['xaxisv']=$xaxisv;
            $info['yaxisv']=$yaxisv;
            $info['xaxisvs']=$xaxisvs;
            $info['yaxisvs']=$yaxisvs;

            echo json_encode($info);
        
         } else {    
        
             $currentpos = D('Menu')->currentPos(I('get.menuid'));
            $this->assign('currentpos',$currentpos);
             $this->display();
         }
    }

效果图