odd_job/app/agent/controller/Home.php

<?php

namespace app\agent\controller;

use app\agent\BaseController;

use app\common\model\User as UserModel;
use app\common\model\Broker as BrokerModel;


class Home extends BaseController
{

    public function index()
    {
        return view('index', [
            'access_agent' => session('access_agent'),
        ]);
    }

    public function console()
    {

        $agentid     = $this->access_agent['id'];
        $brokeridarr = BrokerModel::where('agentid', '=', $agentid)->column('id');

        $stime = strtotime(date("Y-m-d"), time());

        $tuserCount = UserModel::whereIn('brokerid', $brokeridarr)->where('brokerid', '<>', 0)->where('createtime', 'between', [$stime, $stime + 86400])->count();
        $yuserCount = UserModel::whereIn('brokerid', $brokeridarr)->where('brokerid', '<>', 0)->where('createtime', 'between', [$stime - 86400, $stime])->count();

        $userCount   = UserModel::whereIn('brokerid', $brokeridarr)->where('brokerid', '<>', 0)->count();
        $brolerCount = BrokerModel::where('agentid', '=', $agentid)->count();
        /*$entryCount = ReportEntryModel::where('agentid', '=', $agentid)->count();

        $entryfactorylist = ReportEntryModel::with('reportFactory')->where('agentid', '=', $agentid)->field('agentid,factoryid,COUNT(id) AS entrytol')->group('factoryid')->order('entrytol','desc')->select()->toArray();
        $entryfnamearr = array();
        $entryfvaluearr = array();
        if (!empty($entryfactorylist)){
            foreach($entryfactorylist as $k=>$v){
                $entryfnamearr[$k] = $v['reportFactory']['title'] ." - ".$v['reportFactory']['idnumber'];
                $entryfvaluearr[$k]['name'] = $v['reportFactory']['title'] ." - ".$v['reportFactory']['idnumber'];
                $entryfvaluearr[$k]['value'] = $v['entrytol'];
            }
        }*/

        $userlist = UserModel::whereIn('brokerid', $brokeridarr)->where('brokerid', '<>', 0)->where('createtime', 'between', [$stime - 86400 * 30, $stime + 86399])->withAttr('createtime', function ($value, $data) {
            return date("Y-m-d", $value);
        })->select()->toArray();
        $userarr  = periodDate(date('Y-m-d', time() - 86400 * 30), date("Y-m-d"));
        if (!empty($userlist)) {
            foreach ($userlist as $k => $v) {
                $userarr[$v['createtime']] += 1;
            }
        }
        /*$usertolarr = arrKeyVal($userarr);

        $entrylist = ReportEntryModel::where('agentid', '=', $agentid)->where('createtime','between',[$stime-86400*30, $stime+86399])->withAttr('createtime',function ($value,$data) { return date("Y-m-d",$value); })->select()->toArray();
        $entryarr = periodDate( date('Y-m-d', time()-86400*30), date("Y-m-d") );
        if (!empty($entrylist)){
            foreach($entrylist as $k=>$v){
                $entryarr[$v['createtime']] += 1;
            }
        }
        $entrytolarr = arrKeyVal($entryarr);*/

        return view('home/console', [
            'tuserCount'  => $tuserCount,
            'yuserCount'  => $yuserCount,
            'userCount'   => $userCount,
            'brolerCount' => $brolerCount,
            'agent'       => $this->access_agent,
            //			'entryCount'		=> $entryCount,
            //
            //			'entryfnamearr'		=> json_encode($entryfnamearr),
            //			'entryfvaluearr'	=> json_encode($entryfvaluearr),
            //
            //			'usernamearr'	=> json_encode($usertolarr['keyarr']),
            //			'uservaluearr'	=> json_encode($usertolarr['valarr']),
            //
            //			'entrynamearr'	=> json_encode($entrytolarr['keyarr']),
            //			'entryvaluearr'	=> json_encode($entrytolarr['valarr'])
        ]);
    }


}