CRM/normandcrm/service/backend/models/Statistics.php

<?php 

namespace backend\models;

use Yii;

class Statistics extends \yii\db\ActiveRecord
{
    /**
     * @return \yii\db\Connection the database connection used by this AR class.
     */
    public static function getDb()
    {
        return Yii::$app->get('dbXcrm');
    }

    /**
     * @param array $post
     * @return array
     */
    public function getData($post)
    {
        $result = ['code' => 0, 'data' => [], 'message' => ''];

        $member_id = $post['member_id'];
        $login = !empty($post['login']) ? $post['login'] : 0;
        if (!$login) {
            $result['message'] = '参数错误';
            return $result;
        }

        $mt4UserModel = new Mt4Users();
        $allUsers = $mt4UserModel->getAllUsers($member_id);
        $logins = array_column($allUsers, 'login');
        if (!in_array($login, $logins)) {
            $result['message'] = '您没有权限查看这个页面';
            return $result;
        }
        
        // 所属代理
        $userMember = UserMember::find()->where(['login' => $login])
            ->asArray()
            ->limit(1)
            ->one();
        if (!$userMember) {
            $result['message'] = '找不到对应的用户';
            return $result;
        }
        $ib = Member::find()->where(['id' => $userMember['member_id']])
            ->asArray()
            ->limit(1)
            ->one();
        
        // 账户信息
        $mt4User = $mt4UserModel->findByLogin($login, true);
        $member = Member::findByLogin($login);
        
        $mt4TradesModel = new Mt4Trades();
        
        $data = [
            'ib' => $ib,
            'member' => $member,
            'mt4User' => $mt4User,
            'tradeCount' => $mt4TradesModel->getTradeCount($login),
            'profitSumByDay' => $mt4TradesModel->getProfitSumByDay($login),
            'volumeSumByDay' => $mt4TradesModel->getVolumeSumByDay($login),
            'symbolCount' => $mt4TradesModel->getSymbolCount($login),
            'reasonCount' => $mt4TradesModel->getReasonCount($login),
        ];

        $result['data'] = $data;
        $result['code'] = 1;

        return $result;
    }
    
}