station-test-api/catch/worklocation/model/Workplan.php

<?php
namespace catchAdmin\worklocation\model;

use catchAdmin\hydraulic\model\maintenancemapper as ModelMaintenancemapper;
use catchAdmin\permissions\model\DataRangScopeTrait;
use catchAdmin\wind\model\Fan;
use catchAdmin\wind\model\Wind;
use catcher\base\CatchModel as Model;
use Maintenancemapper;

class Workplan extends Model
{
    use DataRangScopeTrait;
    // 表名
    public $name = 'work_plan';
    // 数据库字段映射
    public $field = array(
        'id',
        // 风场id
        'wind_id',
        // 风机id
        'fan_id',
        // 工作位置
        'work_sign',
        // 部件类型
        'parts_sign',
        // 螺栓型号
        'boit_type_sign',
        // 计划名称
        'plan_name',
        // 详情
        'info',
        // 状态  1 启用，-1 失效
        'status',
        // 创建人ID
        'creator_id',
        // 创建时间
        'created_at',
        // 更新时间
        'updated_at',
        // 软删除
        'deleted_at',
    );
    public function getList()
    {
            return $this->dataRange()
            ->catchSearch()
            ->append(['wind_name','fan_number','work_sign_name','parts_sign_name','boit_type_sign_name','status_name'])
            ->field('*')
            ->catchOrder()
            ->creator()
            ->paginate();
    }
    //获取风场名称
   public function getWindNameAttr()
   {
       $wind_id = $this->wind_id;
       $name =  Wind::where('id',$wind_id)->value('name');
       return $name;
   }
   //获取风机机位号
   public function getFanNumberAttr()
   {
        $fan_id = $this->fan_id;
        $number =  Fan::where('id',$fan_id)->value('number');
        return $number;
   }
   //获取工作位置
   public function getWorkSignNameAttr()
   {
     
     $name =  ModelMaintenancemapper::where('device_type',2)->where('value',$this->work_sign)->value('name');
     return $name;

   }
   //获取部件
   public function getPartsSignNameAttr()
   {
        $name =  ModelMaintenancemapper::where('device_type',1)->where('value',$this->work_sign)->value('name');
        return $name;
   }
   //获取螺栓型号
   public function getBoitTypeSignNameAttr()
   {
    $name =  ModelMaintenancemapper::where('device_type',4)->where('value',$this->boit_type_sign_name)->value('name');
    return $name;
   }


}