<?php
|
|
namespace app\api\model\plus\vip;
|
|
use app\common\model\plus\vip\User as VipUserModel;
|
|
use app\common\model\plus\vip\Capital as VipCapitalModel;
|
use app\common\model\plus\vip\Order as VipOrderModel;
|
|
/**
|
* VIP专区用户API模型
|
*/
|
class User extends VipUserModel
|
{
|
/**
|
* 隐藏属性
|
* @var array
|
*/
|
protected $hidden = [
|
'app_id',
|
'update_time'
|
];
|
|
/**
|
* 获取VIP专区用户信息
|
* @param $user_id
|
* @return array|null|static
|
* @throws \think\db\exception\DataNotFoundException
|
* @throws \think\db\exception\ModelNotFoundException
|
* @throws \think\exception\DbException
|
*/
|
public static function getDetail($user_id)
|
{
|
return self::detail($user_id, ['user', 'referee', 'grade']);
|
}
|
|
/**
|
* 获取VIP专区统计数据
|
* @param $user_id
|
* @return array
|
*/
|
public static function getStatistics($user_id)
|
{
|
// VIP专区用户信息
|
$vipUser = self::detail($user_id);
|
if (!$vipUser) {
|
return [];
|
}
|
|
// 获取推荐人数
|
$inviteCount = self::where('referee_id', '=', $user_id)->count();
|
|
// 获取未结算订单数
|
$unsettledCount = VipOrderModel::where('vip_area_user_id', '=', $user_id)
|
->where('is_settled', '=', 0)
|
->count();
|
|
// 获取已结算佣金
|
$settledMoney = VipCapitalModel::where('user_id', '=', $user_id)
|
->where('flow_type', '=', 10)
|
->sum('money');
|
|
return [
|
'user' => $vipUser,
|
'invite_count' => $inviteCount,
|
'unsettled_count' => $unsettledCount,
|
'settled_money' => $settledMoney,
|
];
|
}
|
}
|
