NN2022081301/application/admin/model/users/MotorAgent.php

<?php

namespace app\admin\model\users;

use app\common\model\GoodsOrder;
use app\common\model\MissionOrder;
use app\common\model\SkillOrder;
use app\common\model\TaxiOrder;
use app\http\IResponse;
use think\Model;

class MotorAgent extends Model
{
    protected $name = 'users_motor_agent';

    protected $append = [
        'status_text'
    ];

    public function getStatusTextAttr($value, $data)
    {
        if (isset($data['status']) && $data) {
            $status = [10=>'待审核',20=>'已拒绝',30=>'已通过',40=>'已缴费',50=>'已锁定'];
            return $status[$data['status']];
        }
        return '待审核';
    }

    public function user(): \think\model\relation\HasOne
    {
        return $this->hasOne('\app\common\model\Users', 'id', 'user_id')
            ->field('id,nickname,partnership');
    }

    public function stats()
    {
        $user = $this->where('status', '>', 20)
            ->select();

        $agent_num = count($user);
        $total_num = 0;
        $total_amount = 0;
        if ($user) {
            $area_ids = [];
            foreach ($user as $item) {
                $area_ids[] =  $item->area_id;
            }

            $TaxiOrder = new TaxiOrder();

            $taxi_order = $TaxiOrder->whereIn('area_id', $area_ids)->whereNotIn('status', [1])->column('price', 'id');
            $total_num += count($taxi_order);
            $total_amount += array_sum($taxi_order);
        }

        return [
            'agent_num' => $agent_num,
            'total_num' => $total_num,
            'total_amount' => $total_amount,
        ];
    }
}