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',
        '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;
    }



    

}