baoshi-was/app/Station.php

<?php

namespace App;

use App\Traits\ModelTimeFormat;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasOne;
use App\Traits\ModelLogChanging;

class Station extends Model
{
    use ModelLogChanging;
    use ModelTimeFormat;

    protected $fillable=['name', 'code', 'station_type_id','sequence','parent_id',"material_box_id","status"];

    const STATUS=[
        0 => "正常",
        1 => "占用",
    ];

    public function materialBox():BelongsTo
    {
        return $this->belongsTo(MaterialBox::class);
    }
    public function stationType(){
        return $this->belongsTo(StationType::class);
    }
    public function parent(){
        return $this->belongsTo(Station::class);
    }
    public function child(){
        return $this->hasOne(Station::class,'parent_id');
    }
    public function currentStationTask(){
        return $this->hasOne(StationTask::class)
            ->where('status','=','处理中');
    }
    public function stationTasks_today(){
        return $this->hasMany(StationTask::class)
            ->where('created_at','>=',now()->format('Y-m-d'))
            ->orderBy('status')
            ->orderByDesc('id')
            ;
    }
    public function stationTasks()
    {   //站任务
        return $this->hasMany(StationTask::class,"id","station_type_id");
    }
    public function stationTypeBinMonitor(){
        return $this->hasOne(StationTypeBinMonitor::class);
    }

    public function pendingStationTask(): HasOne
    {
        return $this->hasOne(StationTask::class)
            ->where('status','=','待处理');
    }

    public function storage(): HasOne
    {
        return $this->hasOne(Storage::class);
    }

}