105 lines
2.4 KiB
PHP
105 lines
2.4 KiB
PHP
<?php
|
|
|
|
namespace app\common\model\app\vip;
|
|
|
|
use think\Model;
|
|
|
|
/**
|
|
* 付费会员卡绑定会员
|
|
*/
|
|
class CardUser extends Model
|
|
{
|
|
|
|
// 表名,不含前缀
|
|
protected $name = 'app_vip_card_user';
|
|
// 自动写入时间戳字段
|
|
protected $autoWriteTimestamp = false;
|
|
// 定义时间戳字段名
|
|
protected $createTime = false;
|
|
protected $updateTime = false;
|
|
// 追加属性
|
|
protected $append = [
|
|
];
|
|
|
|
|
|
/**
|
|
* 开通会员
|
|
* @param $userId 用户
|
|
* @param $cardId 会员卡ID
|
|
* @param $time 开通时长 天数
|
|
* @return void
|
|
*/
|
|
public static function openVip($userId,$cardId,$time){
|
|
|
|
$data = self::where([
|
|
'user_id'=>$userId,
|
|
'card_id'=>$cardId,
|
|
])->find();
|
|
|
|
$time *= 86400;
|
|
|
|
if($data){
|
|
$endtime = ( $data['end_time'] > time() ? $data['end_time'] :time() ) + $time;
|
|
self::where([
|
|
'id'=>$data['id']
|
|
])->update([
|
|
'updatetime'=>time(),
|
|
'end_time'=>$endtime
|
|
]);
|
|
}else{
|
|
$endtime = time() + $time;
|
|
self::insert([
|
|
'updatetime'=>time(),
|
|
'createtime'=>time(),
|
|
'end_time'=>$endtime,
|
|
'status'=>1,
|
|
'user_id'=>$userId,
|
|
'card_id'=>$cardId,
|
|
'uniacid'=>UNIACID
|
|
]);
|
|
}
|
|
|
|
return true;
|
|
}
|
|
|
|
|
|
/**
|
|
* 获取用户VIP信息
|
|
* @param $userId
|
|
* @return void
|
|
*/
|
|
public static function getUserVipInfo($userId){
|
|
$data = self::with(['card'])->where([
|
|
'card_user.user_id'=>$userId,
|
|
'card_user.status'=>1,
|
|
// 'card.status'=>1,
|
|
'card_user.end_time'=>['>',time()]
|
|
])->order('card_user.updatetime','desc')->find();
|
|
|
|
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* 获取用户VIP信息
|
|
* @param $userId
|
|
* @return void
|
|
*/
|
|
public static function getUserAllVipInfo($userId){
|
|
$data = self::with(['card'])->where([
|
|
'card_user.user_id'=>$userId,
|
|
'card_user.status'=>1,
|
|
// 'card.status'=>1,
|
|
'card_user.end_time'=>['>',time()]
|
|
])->order('card_user.updatetime','desc')->select();
|
|
|
|
|
|
return $data;
|
|
}
|
|
|
|
|
|
public function card()
|
|
{
|
|
return $this->belongsTo('app\api\model\app\vip\Card', 'card_id', 'id', [], 'Right')->setEagerlyType(0);
|
|
}
|
|
} |