NN2024071001/app/Models/MemberModel.php

<?php
// +----------------------------------------------------------------------
// | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
// +----------------------------------------------------------------------
// | 版权所有 2017~2021 LARAVEL研发中心
// +----------------------------------------------------------------------
// | 官方网站: http://www.laravel.cn
// +----------------------------------------------------------------------
// | Author: laravel开发员 <laravel.qq.com>
// +----------------------------------------------------------------------

namespace App\Models;

/**
 * 会员-模型
 * @author laravel开发员
 * @since 2020/11/11
 * Class MemberModel
 * @package App\Models
 */
class MemberModel extends BaseModel
{
    // 设置数据表
    protected $table = 'member';

    /**
     * 上级
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function parent()
    {
        return $this->hasOne(MemberModel::class, 'id','parent_id')
            ->where(['mark'=>1])
            ->select(['id','parent_id','nickname','usdt','sbt','profit','code','bonus_rate','wallet_url','status']);
    }

    /**
     * 等级
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function level()
    {
        return $this->hasOne(MemberLevelModel::class, 'id','member_level')
            ->where(['mark'=>1])
            ->select(['id','name','upgrade_usdt','bonus_rate','weighting_rate','status']);
    }

    /**
     * 质押订单
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function pledge()
    {
        return $this->hasOne(PledgeOrderModel::class, 'user_id','id')
            ->where(function($query){
                $query->where('expired_at','>', date('Y-m-d H:i:s'))
                    ->orWhere(['status'=>1]);
            })
            ->where(['mark'=>1])
            ->select(['id','user_id','order_no','money','expired_at','status']);
    }

    /**
     * 获取会员信息
     * @param int $id 会员ID
     * @return array|string
     * @author laravel开发员
     * @since 2020/11/11
     */
    public function getInfo($id)
    {
        $info = parent::getInfo($id); // TODO: Change the autogenerated stub
        if ($info) {
            // 头像
            if ($info['avatar']) {
                $info['avatar'] = get_image_url($info['avatar']);
            }
        }
        return $info;
    }

}