<?php
|
|
namespace app\common\model\supplier\member;
|
|
use app\common\model\BaseModel;
|
|
/**
|
* 供应商年卡模型
|
* 用于管理供应商年卡类型及其权益
|
*/
|
class Plan extends BaseModel
|
{
|
// 表名
|
protected $name = 'supplier_member_plan';
|
protected $pk = 'plan_id';
|
|
/**
|
* 关联年卡权限
|
*/
|
public function planAccess()
|
{
|
return $this->hasMany('app\common\model\supplier\member\PlanAccess', 'plan_id', 'plan_id');
|
}
|
/**
|
* 获取启用的年卡列表
|
*/
|
public function getEnabledPlans()
|
{
|
return $this->where(['status' => 1, 'is_default' =>0])
|
->order(['sort' => 'asc', 'create_time' => 'desc'])
|
->select();
|
}
|
|
/**
|
* 获取详情
|
*/
|
public static function detail($planId)
|
{
|
return (new static())->with(['plan_access'])->where('plan_id', '=', $planId)->find();
|
}
|
|
/**
|
* 获取列表
|
*/
|
public function getList($data)
|
{
|
$model = $this;
|
if (!empty($data['name'])) {
|
$model = $model->where('name', 'like', '%' . $data['name'] . '%');
|
}
|
if (isset($data['status']) && $data['status'] >= 0) {
|
$model = $model->where('status', '=', $data['status']);
|
}
|
return $model->where('app_id', '=', $data['app_id'])
|
->order(['sort' => 'asc', 'create_time' => 'desc'])
|
->paginate($data);
|
}
|
}
|
