TP5统计本月每天注册的人数(注册时间为时间戳)

public function countMonthUsers()
    {
        $month = date('Y-m',time());
        $prefix = config('database.prefix');
        $semRes = Db::query("select FROM_UNIXTIME(create_time,'%Y-%m-%d') days,count(id) count from ".$prefix."user_submit WHERE FROM_UNIXTIME(create_time,'%Y-%m') = '".$month."' AND delete_time = 0 group by days");
 
        $seoRes = Db::query("select FROM_UNIXTIME(create_time,'%Y-%m-%d') days,count(id) count from ".$prefix."user_submit WHERE FROM_UNIXTIME(create_time,'%Y-%m') = '".$month."' AND delete_time = 0 group by days");
 
 
        // x 轴数据,作为 x 轴标注
        $j = date("t"); //获取当前月份天数
        $start_time = strtotime(date('Y-m-01'));  //获取本月第一天时间戳
        $xData = array();
        for($i=0;$i<$j;$i++)
        {
            $xData[] = date('Y-m-d',$start_time+$i*86400); //每隔一天赋值给数组
        }
        //处理获取到的数据
        $ySemData = array();
        if(!empty($semRes))
        {
            foreach ($xData as $k=>$v)
            {
                foreach ($semRes as $kk=>$vv)
                {
                    if($v == $vv['days'])
                    {
                        $ySemData[$k] = $vv['count'];
                        break;
                    }else{
                        $ySemData[$k] = 0;
                        continue;
                    }
                }
            }
        }else{
            foreach ($xData as $k=>$v)
            {
                $ySemData[$k] = 0;
            }
        }
 
        $ySeoData = array();
        if(!empty($seoRes))
        {
            foreach ($xData as $k=>$v)
            {
                foreach ($seoRes as $kk=>$vv)
                {
                    if($v == $vv['days'])
                    {
                        $ySeoData[$k] = $vv['count'];
                        break;
                    }else{
                        $ySeoData[$k] = 0;
                        continue;
                    }
                }
            }
        }else{
            foreach ($xData as $k=>$v)
            {
                $ySeoData[$k] = 0;
            }
        }
        return [$xData,$ySemData,$ySeoData];
    }

返回

array(3) {
  [0] => array(28) {
    [0] => string(10) "2018-02-01"
    [1] => string(10) "2018-02-02"
    [2] => string(10) "2018-02-03"
    [3] => string(10) "2018-02-04"
    [4] => string(10) "2018-02-05"
    [5] => string(10) "2018-02-06"
    [6] => string(10) "2018-02-07"
    [7] => string(10) "2018-02-08"
    [8] => string(10) "2018-02-09"
    [9] => string(10) "2018-02-10"
    [10] => string(10) "2018-02-11"
    [11] => string(10) "2018-02-12"
    [12] => string(10) "2018-02-13"
    [13] => string(10) "2018-02-14"
    [14] => string(10) "2018-02-15"
    [15] => string(10) "2018-02-16"
    [16] => string(10) "2018-02-17"
    [17] => string(10) "2018-02-18"
    [18] => string(10) "2018-02-19"
    [19] => string(10) "2018-02-20"
    [20] => string(10) "2018-02-21"
    [21] => string(10) "2018-02-22"
    [22] => string(10) "2018-02-23"
    [23] => string(10) "2018-02-24"
    [24] => string(10) "2018-02-25"
    [25] => string(10) "2018-02-26"
    [26] => string(10) "2018-02-27"
    [27] => string(10) "2018-02-28"
  }
  [1] => array(28) {
    [0] => int(0)
    [1] => int(0)
    [2] => int(0)
    [3] => int(0)
    [4] => int(0)
    [5] => int(0)
    [6] => int(0)
    [7] => int(0)
    [8] => int(0)
    [9] => int(0)
    [10] => int(0)
    [11] => int(0)
    [12] => int(0)
    [13] => int(0)
    [14] => int(0)
    [15] => int(0)
    [16] => int(0)
    [17] => int(0)
    [18] => int(0)
    [19] => int(0)
    [20] => int(0)
    [21] => int(0)
    [22] => int(0)
    [23] => int(30)
    [24] => int(0)
    [25] => int(6)
    [26] => int(17)
    [27] => int(0)
  }
  [2] => array(28) {
    [0] => int(0)
    [1] => int(0)
    [2] => int(0)
    [3] => int(0)
    [4] => int(0)
    [5] => int(0)
    [6] => int(0)
    [7] => int(0)
    [8] => int(0)
    [9] => int(0)
    [10] => int(0)
    [11] => int(0)
    [12] => int(0)
    [13] => int(0)
    [14] => int(0)
    [15] => int(0)
    [16] => int(0)
    [17] => int(0)
    [18] => int(0)
    [19] => int(0)
    [20] => int(0)
    [21] => int(0)
    [22] => int(0)
    [23] => int(0)
    [24] => int(0)
    [25] => int(0)
    [26] => int(6)
    [27] => int(0)
  }
}
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值