<?php
|
|
namespace app\common\model\plus\vip;
|
|
use app\common\model\BaseModel;
|
use app\common\model\order\OrderProduct;
|
use app\common\model\plus\vip\GradeLog as GradeLogModel;
|
use app\common\enum\user\grade\ChangeTypeEnum;
|
|
/**
|
* VIP专区用户模型
|
*/
|
class User extends BaseModel
|
{
|
protected $name = 'vip_area_user';
|
protected $pk = 'user_id';
|
|
/**
|
* 关联会员记录表
|
* @return \think\model\relation\BelongsTo
|
*/
|
public function user()
|
{
|
return $this->belongsTo('app\\common\\model\\user\\User');
|
}
|
|
/**
|
* 关联推荐人表
|
* @return \think\model\relation\BelongsTo
|
*/
|
public function referee()
|
{
|
return $this->belongsTo('app\\common\\model\\user\\User', 'referee_id', 'user_id');
|
}
|
|
/**
|
* 关联VIP等级记录表
|
* @return \think\model\relation\BelongsTo
|
*/
|
public function grade()
|
{
|
return $this->belongsTo('app\\common\\model\\plus\\vip\\Grade','grade_id', 'grade_id');
|
}
|
|
/**
|
* 详情
|
*/
|
public static function detail($user_id, $with = ['user', 'referee', 'grade'])
|
{
|
return (new static())->with($with)->find($user_id);
|
}
|
|
/**
|
* 是否为VIP专区用户
|
*/
|
public static function isVipUser($user_id)
|
{
|
$vip = self::detail($user_id);
|
return !!$vip && !$vip['is_delete'];
|
}
|
|
/**
|
* 新增VIP专区用户记录
|
* @param $user_id
|
* @param $data
|
* @return bool
|
*/
|
public static function add($user_id, $data)
|
{
|
$model = static::detail($user_id) ?: new static;
|
$user=(new \app\common\model\user\User())->detail($user_id);
|
$model->save(array_merge([
|
'user_id' => $user_id,
|
'real_name' => $user['real_name']?: $user['nickName'],
|
'mobile' => $user['mobile'],
|
'is_delete' => 0,
|
'app_id' => $model::$app_id,
|
'grade_id' => Grade::getDefaultGradeId()
|
], $data));
|
return true;
|
}
|
|
/**
|
* 发放VIP专区佣金
|
* @param $user_id
|
* @param $money
|
* @param string $description 佣金描述
|
* @return bool
|
*/
|
public static function grantMoney($user_id, $money, $description = '订单佣金结算')
|
{
|
// VIP专区用户详情
|
$model = static::detail($user_id);
|
if (!$model || $model['is_delete']) {
|
return false;
|
}
|
// 累加VIP专区用户可提现佣金
|
$model->where('user_id', '=', $user_id)->inc('money', $money)->update();
|
// 记录VIP专区资金明细
|
Capital::add([
|
'user_id' => $user_id,
|
'flow_type' => 10,
|
'money' => $money,
|
'describe' => $description,
|
'app_id' => $model['app_id'],
|
]);
|
return true;
|
}
|
|
/**
|
* 批量设置会员等级
|
*/
|
public function upgradeGrade($user, $upgradeGrade)
|
{
|
// 更新会员等级的数据
|
$this->where('user_id', '=', $user['user_id'])
|
->update([
|
'grade_id' => $upgradeGrade['grade_id']
|
]);
|
(new GradeLogModel)->save([
|
'old_grade_id' => $user['grade_id'],
|
'new_grade_id' => $upgradeGrade['grade_id'],
|
'change_type' => ChangeTypeEnum::AUTO_UPGRADE,
|
'user_id' => $user['user_id'],
|
'app_id' => $user['app_id']
|
]);
|
return true;
|
}
|
|
/**
|
* 提现打款成功：累积提现佣金
|
*/
|
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,
|
]);
|
}
|
|
/**
|
* 提现驳回：解冻VIP专区资金
|
*/
|
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,
|
]);
|
}
|
|
/**
|
* 冻结VIP专区资金
|
*/
|
public static function freezeMoney($user_id, $money)
|
{
|
$model = self::detail($user_id);
|
if ($model['money'] < $money) {
|
return false;
|
}
|
return $model->save([
|
'money' => $model['money'] - $money,
|
'freeze_money' => $model['freeze_money'] + $money,
|
]);
|
}
|
|
|
public function getViewpointMoneyQualification($user_id,$setting)
|
{
|
$userNum=$this->where('referee_id','=',$user_id)->count();
|
$consumption=(new OrderProduct())
|
->alias('order_product')
|
->where('order_product.user_id','=',$user_id)
|
->join('order','order_product.order_id=order.order_id')
|
->where('order.order_status','=',30)
|
->where('order_product.create_time','>=',strtotime(date('Y-m-01 00:00:00')))
|
->where('order_product.create_time','<',strtotime('+1 month',strtotime(date('Y-m-01 00:00:00'))))
|
->where('order_product.is_repurchase','=',1)->sum('order_product.total_pay_price');
|
if($userNum>=$setting['viewpoint_buy_count']&&$consumption>=$setting['repurchase_consumption']){
|
return true;
|
}
|
return false;
|
}
|
}
|
