baoshi-was/app/ProcurementDeliverie.php

<?php

namespace App;

use App\Traits\ModelTimeFormat;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;

use App\Traits\ModelLogChanging;
use Illuminate\Support\Facades\App;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class ProcurementDeliverie extends Model
{
    use ModelLogChanging;
    use ModelTimeFormat;

    protected $fillable=[
        'procurement_id','amount', 'initiator','status','signer','signed_at','receipt_amount'
    ];
    const status=[
        0=>'待送货',
        1=>'送货中',
        2=>'送货完成',
    ];
    public function procurement(){
        return $this->belongsTo('App\Procurement','procurement_id','id');
    }

    public function receiver(){
        return $this->belongsTo('App\User','signer','id');
    }
    public function procurementCheckSheet(){
        return $this->belongsTo('App\ProcurementCheckSheet','id','procurement_delivery_id');
    }
    protected static function booted()
    {
        /** @var User $user */
        $user = Auth::user();
        if ($user && !$user->isSuperAdmin()) {
            /** @var \stdClass $user */
            $ids = array_column(DB::select(DB::raw("SELECT supplier_id FROM supplier_user WHERE user_id = ?"),[$user->id]),"supplier_id");
            if (count($ids)>0){
                static::addGlobalScope('supplier', function (Builder $builder)use ($ids) {
                    $builder->whereIn('supplier_id',  $ids);
                });
            }
        }
    }
}