station-test-api/catch/hydraulic/model/MaintenanceMapper.php

<?php

namespace catchAdmin\hydraulic\model;

use catcher\base\CatchModel as Model;
use catchAdmin\system\model\SysDictData;
use catchAdmin\permissions\model\DataRangScopeTrait;
use \think\facade\Db;

class maintenancemapper extends Model
{
    use DataRangScopeTrait;
    // 表名
    public $name = 'maintenance_mapper';
    // 数据库字段映射
    public $field = array(
        'id',
        // 设备类型
        'device_type',
        // 唯一值
        'value',
        // 名称
        'name',
        //部件
        'parts',
        //风机型号
        'fan_model',
        // 创建人ID
        'creator_id',
        // 创建时间
        'created_at',
        // 更新时间
        'updated_at',
        // 软删除
        'deleted_at',
    );
    /**
     * 获取列表
     */
    public function getList()
    {
        $res =  $this->dataRange()
            ->catchSearch()
            ->append(['device_type_name', 'creator_name', 'fan_model_name'])
            ->order($this->aliasField('id'), 'desc')
            ->paginate();
        return $res;
    }


    /**
     * 名称搜索
     */
    public function searchNameAttr($query, $value, $data)
    {
        return $query->where('name', 'like', '%' . $value . '%');
    }
    /**
     * 设备类型搜索
     */
    public function searchDeviceTypeAttr($query, $value, $data)
    {

        return $query->where('device_type', '=', $value);
    }


    /**
     * 设备类型名称
     */
    public function getDeviceTypeNameAttr()
    {
        $value = $this->getData('device_type');

        return (new SysDictData())->getValueByCode('Maintenance', $value) ?: '';
    }
    public function getFanModelAttr()
    {
        $value = $this->getData('fan_model');
        return $value ? intval($value) : null;
    }
    public function getFanModelNameAttr()
    {
        $value = $this->getData('fan_model');
        $where[] = ['device_type', '=', 4];
        $where[] = ['id', '=', $value];
        $name = Db::name('device_mold')->where($where)->value('name');
        return $name;
    }
}