autocde2.0/app/Models/Container.php

<?php

namespace App\Models;

use App\Models\Enums\ActionObjectType;
use App\Models\Enums\ContainerACL;
use App\Models\Scopes\CompanyScope;
use EloquentFilter\Filterable;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Facades\Auth;

class Container extends Model
{
    use HasFactory, SoftDeletes, Filterable;

    protected $fillable = [
        'name', 'library_id', 'naming_rule_id', 'naming_rules', 'mailto', 'email_subject', 'acl', 'whitelist',
        'doc_stage', 'doc_type'
    ];

    protected $casts = [
        'mailto' => 'array',
        'naming_rules' => 'array',
        'created_at' => 'datetime:Y-m-d H:i:s',
        'updated_at' => 'datetime:Y-m-d H:i:s',
    ];

    protected static function booted(): void
    {
        static::addGlobalScope(new CompanyScope);
    }

    public function scopeAllowed(Builder $query, string $id = null)
    {
        $query->where(function (Builder $query) {
            return $query->where('acl', ContainerACL::PRIVATE->value)->where('created_by', Auth::id());
        })->orWhere(function (Builder $query) {
            return $query->where('acl', ContainerACL::CUSTOM->value)->where('whitelist', 'like', '%,' . Auth::id() . ',%');
        });
    }

    public function library(): \Illuminate\Database\Eloquent\Relations\BelongsTo
    {
        return $this->belongsTo(Library::class, "library_id");
    }

    public function namingRule(): \Illuminate\Database\Eloquent\Relations\BelongsTo
    {
        return $this->belongsTo(NamingRule::class);
    }

    public function createdBy(): \Illuminate\Database\Eloquent\Relations\BelongsTo
    {
        return $this->belongsTo(User::class, 'created_by');
    }

    public function content(int $version = 0): \Illuminate\Database\Eloquent\Relations\HasOne
    {
        $version = $version > 0 ? $version : $this->version;

        return $this->hasOne(ContainerContent::class, "container_id")->where("version", $version);
    }

    public function folder()
    {
        return $this->hasMany(Folder::class, "object_id")->where("object_type", ActionObjectType::CONTAINER->value);
    }

    public function files()
    {
        return $this->hasMany(File::class, "object_id")->where("object_type", ActionObjectType::CONTAINER->value);
    }
}