kefu/app/admin/command/OperationData.php

<?php
namespace app\admin\command;

use think\console\Command;
use think\console\Input;
use think\console\Output;
use app\admin\model\OperationData as OperationDataModel;
use app\admin\model\KefuTime;

/**
 * Worker 命令行类
 */
class OperationData extends Command
{
    public function configure()
    {
        $this->setName('operation:data')
            ->setDescription('每日0点统计前一天的数据');
    }

    public function execute(Input $input, Output $output)
    {
        //统计前一天的接线总数
        OperationDataModel::create([
            'type' => 1,
            'num' => $this->chatNum(),
            'date' => date('Y-m-d', strtotime('-1 day')),
        ]);
    }

    /**
     * 统计前一天的接线总数
     */
    public function chatNum()
    {
        return  KefuTime::where('type', 3)
                    ->where('created_at', '>=', date('Y-m-d 00:00:00', strtotime('-1 day')))
                    ->where('created_at', '<=', date('Y-m-d 23:59:59', strtotime('-1 day')))
                    ->count();
    }

}