<?php

namespace app\operations\model\branch;

use app\common\model\branch\Member as MemberModel;
use app\common\model\user\User as UserModel;

/**
 * 连盟成员模型
 * Class Member
 * @package app\operations\model\branch
 */
class Member extends MemberModel
{
    /**
     * 获取连盟成员列表
     */
    public function getList($params = [])
    {
        // 构建查询规则
        $model = $this->alias('branch_member')
            ->field('branch_member.*, user.nickName, user.avatarUrl, user.real_name, user.mobile, branch_position.weight, branch_position.name as position_name')
            ->with(['branch'])
            ->join('user', 'user.user_id = branch_member.user_id')
            ->join('branch_position', 'branch_position.position_id = branch_member.position_id')
            ->where('branch_member.is_delete', '=', 0)
            ->order(['branch_position.weight' => 'desc', 'branch_member.create_time' => 'desc']);
        // 查询条件
        if (!empty($params['branch_id'])) {
           $model = $model->where('branch_member.branch_id', '=', $params['branch_id']);
        }
        if (!empty($params['keywords'])) {
            if ($params['keywords'] == 'user_id') {
                $model = $model->where('user.user_id', '=', (int)$params['keywords']);
            } else {
                $model = $model->where('user.nickName|user.real_name|user.mobile', 'like', '%' . $search . '%');
            }
        }
        return $model->paginate($params);
    }

    /**
     * 编辑连盟成员
     * @param $data
     * @return bool
     */
    public function edit($data)
    {
        return $this->save($data) !== false;
    }

    /**
     * 删除连盟成员
     * @return mixed
     */
    public function setDelete()
    {
        return $this->transaction(function () {
            // 标记当前股东记录为已删除
            return $this->save([
                'is_delete' => 1
            ]);
        });
    }
    
    /**
     * 提现打款成功：累积提现佣金
     */
    public static function totalMoney($user_id, $money)
    {
        $model = self::detail($user_id);
        return $model->save([
            'freeze_money' => $model['freeze_money'] - $money,
            'total_money' => $model['total_money'] + $money,
        ]);
    }

    /**
     * 提现驳回：解冻股东资金
     */
    public static function backFreezeMoney($user_id, $money)
    {
        $model = self::detail($user_id);
        return $model->save([
            'money' => $model['money'] + $money,
            'freeze_money' => $model['freeze_money'] - $money,
        ]);
    }

    /**
     * 获取平台的总销售额
     */
    public function getTotalMoney($type = 'all_money')
    {
        $model = $this;
        if($type == 'money'){
            return $model->sum('money');
        } else if($type == 'freeze_money'){
            return $model->sum('freeze_money');
        } else if($type == 'total_money'){
            return $model->sum('total_money');
        } else if($type == 'all_money'){
            return $model->sum('total_money') + $model->sum('freeze_money') + $model->sum('money');
        }
        return 0;
    }
}