<?php
|
|
namespace app\common\model\supplier\member;
|
|
use app\common\model\BaseModel;
|
|
/**
|
* 供应商会员模型
|
* 记录供应商拥有的年卡信息
|
*/
|
class Member extends BaseModel
|
{
|
// 表名
|
protected $name = 'supplier_member';
|
protected $pk = 'member_id';
|
protected $append=['expire_time_text'];
|
/**
|
* 过期时间文本
|
*/
|
public function getExpireTimeTextAttr($value, $data)
|
{
|
return $data['expire_time'] > 0 ? date('Y-m-d H:i:s', $data['expire_time']) : '长期有效';
|
}
|
|
/**
|
* 关联供应商表
|
*/
|
public function supplier()
|
{
|
return $this->belongsTo('app\common\model\supplier\Supplier', 'shop_supplier_id', 'shop_supplier_id');
|
}
|
|
/**
|
* 关联年卡计划表
|
*/
|
public function plan()
|
{
|
return $this->belongsTo('app\common\model\supplier\member\Plan', 'plan_id', 'plan_id');
|
}
|
|
/**
|
* 判断是否过期
|
*/
|
public function isExpired()
|
{
|
return $this->expire_time < time();
|
}
|
|
/**
|
* 获取供应商当前有效的年卡
|
*/
|
public static function getCurrentMember($supplierId, $appId)
|
{
|
return self::where([
|
'shop_supplier_id' => $supplierId,
|
'app_id' => $appId,
|
'is_expire' => 0
|
])->where('expire_time', '>', time())->find();
|
}
|
|
/**
|
* 获取详情
|
*/
|
public static function detail($memberId)
|
{
|
return (new static())->where('member_id', '=', $memberId)->where('is_expire', '=', 0)->find();
|
}
|
}
|
