<?php

namespace app\shop\model\plus\region;

use app\shop\model\plus\region\Referee as RefereeModel;
use app\common\model\plus\region\User as UserModel;
use app\common\enum\plus\region\RegionLevelEnum;

/**
 * 股东用户模型
 * Class User
 * @package app\shop\model\plus\region
 */
class User extends UserModel
{
    /**
     * 获取股东用户列表
     */
    public function getList($search, $limit = 15)
    {
        // 构建查询规则
        $model = $this->alias('region')
            ->field('region.*, user.nickName, user.avatarUrl')
            ->with(['grade'])
            ->join('user', 'user.user_id = region.user_id')
            ->where('region.is_delete', '=', 0)
            ->order(['region.create_time' => 'desc']);
        // 查询条件
        if (!empty($search)) {
            $model = $model->where('user.nickName|region.real_name|region.mobile', 'like', '%' . $search . '%');
        }
        // 获取列表数据
        $list = $model->paginate($limit);
        foreach ($list as $user){
            $user['total_money'] = sprintf('%.2f', $user['money'] + $user['freeze_money'] + $user['total_money']);
        }
        return $list;
    }

    public static function getListAll($grade_id = 0)
    {
        $model = new static;
        if($grade_id > 0) {
            $model->where('grade_id', '=', $grade_id);
        }
        return $model->where('is_delete', '=', 0)->with(['grade'])->select();
    }

    /**
     * 编辑股东用户
     * @param $region_id
     * @param $region_level
     */
    public static function getUser($region_id, $region_level = RegionLevelEnum::PROVINCE)
    {
        $model = new static;
        $model = $model->where('region_level', '=', $region_level);
        // 省代理
        if($region_level == RegionLevelEnum::PROVINCE) {
            $model = $model->where('province_id', '=', $region_id);
        }
        if($region_level == RegionLevelEnum::CITY) {
            $model = $model->where('city_id', '=', $region_id);
        }
        if($region_level == RegionLevelEnum::AREA) {
            $model = $model->where('area_id', '=', $region_id);
        }
        return $model->where('is_delete', '=', 0)->select();
    }

    /**
     * 编辑股东用户
     * @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;
    }
}