NN2024010801/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\BelongsTo
     */
    public function merchant()
    {
        return $this->belongsTo(MerchantModel::class, 'id','user_id')
            ->where(['mark'=>1])
            ->select(['id','user_id','usdt','name','audit_remark','status']);
    }

    /**
     * 承兑商
     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
     */
    public function acceptor()
    {
        return $this->belongsTo(AcceptorModel::class, 'id','user_id')
            ->where(['mark'=>1])
            ->select(['id','user_id','realname','mobile','usdt','quota','audit_remark','status']);
    }

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

    /**
     * 滑落推荐人
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function point()
    {
        return $this->hasOne(MemberModel::class, 'id','point_id')
            ->where(['mark'=>1])
            ->select(['id','nickname','parent_id','point_id','balance','usdt','email','mobile','username','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','upgrade_usdt_profit','power_multiple','box_num','score_rate','global_bonus_rate','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']);
            }
            // 出生日期
            if ($info['birthday']) {
                $info['birthday'] = datetime($info['birthday']);
            }
            // 城市
            if ($info['province_id'] && $info['city_id'] && $info['district_id']) {
                $city = [];
                $city[] = $info['province_id'];
                $city[] = $info['city_id'];
                $city[] = $info['district_id'];
                $info['city'] = $city;
            }
        }
        return $info;
    }

}