* +---------------------------------------------------------------------- */ namespace App\Http\Model\User; use App\Http\Model\BaseModel; use App\Http\Model\Company\Company; use Illuminate\Database\Eloquent\Relations\HasOne; use Illuminate\Database\Query\Builder; /** * 企业邀请用户加入申请表 * Class UserEnterpriseApply. */ class UserEnterpriseApply extends BaseModel { /** * 自动写入时间. * @var bool */ public $timestamps = false; /** * 表名. * @var string */ protected $table = 'user_enterprise_apply'; /** * 主键. * @var string */ protected $primaryKey = 'id'; /** * status作用域 * @return mixed */ public function scopeStatusApply($query, $value) { if ($value != '') { return $query->where('status', $value); } } /** * 用户. * @return HasOne */ public function user() { return $this->hasOne(User::class, 'uid', 'uid')->select(['uid', 'phone', 'real_name', 'avatar']); } /** * 企业. * @return HasOne */ public function enterprise() { return $this->hasOne(Company::class, 'id', 'entid'); } /** * entids作用域 * @param Builder $query * @return mixed */ public function scopeEntids($query, $value) { return $query->whereIn('entid', $value); } /** * verify作用域 * @param Builder $query * @return mixed */ public function scopeVerify($query, $value) { if (is_array($value)) { $query->whereIn('verify', $value); } elseif ($value !== '') { $query->where('verify', $value); } } /** * id作用域 * @param Builder $query * @return mixed */ public function scopeId($query, $value) { if ($value !== '') { return $query->where('id', $value); } } /** * entid作用域 * @param Builder $query * @return mixed */ public function scopeEntid($query, $value) { if ($value !== '') { return $query->where('entid', $value); } } /** * @param Builder $query * @return mixed */ public function scopeStatus($query, $value) { return is_array($value) ? $query->whereIn('status', $value) : $query->where('status', $value); } }