jianlizaojia/app/xzgl/model/XzglStaffCert.php

<?php

namespace app\xzgl\model;

use jerryyan\staff\model\StaffUser;
use think\admin\Model;
use think\admin\model\SystemBase;
use think\db\Query;

class XzglStaffCert extends Model
{
    protected $createTime = 'create_at';
    protected $updateTime = 'update_at';
    protected $oplogName = '员工证书';
    protected $oplogType = '员工证书管理';
    protected $globalScope = ['notDeleted'];
    protected $append = ['staff_name', 'zclb_name', 'zczy_name', 'zsjb_name'];
    public function scopeDeleted(Query $query): void
    {
        $query->where('is_deleted', '=', 1);
    }

    public function scopeNotDeleted(Query $query): void
    {
        $query->where('is_deleted', '=', 0);
    }

    public function staff()
    {
        return $this->hasOne(StaffUser::class, 'id', 'staff_id');
    }

    public function getStaffNameAttr($value, $data)
    {
        return $this->staff ? $this->staff['name'] : '';
    }

    public function getZclbNameAttr($value, $data)
    {
        $zclb = SystemBase::items('员工注册类别');
        if (isset($zclb[$data['zclb']])) {
            return $zclb[$data['zclb']]['name'];
        } else {
            return $data['zclb'];
        }
    }

    public function getZczyNameAttr($value, $data)
    {
        $zczy = SystemBase::items('员工注册专业');
        if (isset($zczy[$data['zczy']])) {
            return $zczy[$data['zczy']]['name'];
        } else {
            return $data['zczy'];
        }
    }

    public function getZsjbNameAttr($value, $data)
    {
        $zsjb = SystemBase::items('员工证书级别');
        if (isset($zsjb[$data['zsjb']])) {
            return $zsjb[$data['zsjb']]['name'];
        } else {
            return $data['zsjb'];
        }
    }
}