odd_job/app/partner/controller/Home.php

<?php

namespace app\partner\controller;

use app\partner\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_partner' => session('access_partner'),
        ]);
    }

    public function console()
    {

        $partnerid   = $this->access_partner['id'];
        $brokerids = BrokerModel::where('pid|id', '=', $partnerid)->column('id');

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

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

        $userCount   = UserModel::whereIn('brokerid', $brokerids)->where('brokerid', '<>', 0)->count();
        $brokerCount = BrokerModel::where('pid', '=', $partnerid)->count();

        $partnerIncome = BrokerModel::whereIn('id',$brokerids)->sum('income');
        $partnerIncomeTotal = BrokerModel::whereIn('id',$brokerids)->sum('income_total');


        return view('home/console', [
            'tuserCount'  => $tuserCount,
            'yuserCount'  => $yuserCount,
            'userCount'   => $userCount,
            'brokerCount' => $brokerCount,
            'partnerIncome' => $partnerIncome,
            'partnerIncomeTotal' => $partnerIncomeTotal,
            'partner'     => $this->access_partner,
        ]);
    }


}