autocde2.0/app/Models/Asset.php

<?php

namespace App\Models;

use App\Models\Enums\AssetACL;
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\Support\Facades\Auth;

/**
 * @method static \Illuminate\Database\Eloquent\Builder allowed()
 */
class Asset extends Model
{
    use HasFactory, Filterable;

    protected $fillable = [
        "name", "code", "description", "company_id", "status", "created_by",
        "owner", "address", "group_id", "geo_address_code", "acl",
        "whitelist", "latitude", "longitude","parent_id", "path",
        "equity_interest","developer","date_completed","total_floor_area","contact_person","contact_phone","contact_email","property","building_type_description"
    ];

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

    public function scopeAllowed(Builder $query): void
    {
        $userId =  Auth::id();
        $query->where(function (Builder $query) use ($userId){
            return $query->whereIn('id', function ($query) use ($userId) {
                $query->select('asset_id')
                    ->from('project_asset')
                    ->whereIn('project_id', function ($query) use ($userId) {
                        $query->select('project_id')
                            ->from('team_members')
                            ->where('user_id', $userId);
                    });
            });
        })->orWhere(function (Builder $query)use ($userId) {
            return $query->where('acl', AssetACL::PRIVATE->value)->where('owner',$userId);
        })->orWhere(function (Builder $query)use ($userId) {
            return $query->where('acl', AssetACL::CUSTOM->value)->where('whitelist', 'like', '%,' .$userId . ',%');
        });
//        $query->where(function (Builder $query) {
//            return $query->where('acl', AssetACL::PRIVATE->value)->where('owner', Auth::id());
//        })->orWhere(function (Builder $query) {
//            return $query->where('acl', AssetACL::CUSTOM->value)->where('whitelist', 'like', '%,' . Auth::id() . ',%');
//        });
    }

    public function children(){
        return $this->hasMany(Asset::class ,'parent_id');
    }
    public function parent(){
        return $this->belongsTo(Asset::class ,'parent_id');
    }

    public function requirementGroups(){
        return $this->hasMany(RequirementGroup::class ,'asset_id');
    }

    public function requirements(){
        return $this->hasMany(Requirement::class ,'asset_id');
    }

    public function plans(){
        return $this->hasMany(Plan::class ,'asset_id');
    }

    public function projects(){
        return $this->belongsToMany(Project::class,'project_asset');
    }

    //获取子级需求数量
    public function getTotalRequirementsCountAttribute()
    {
        $childIds = [];
        Asset::where('path','like','%,'.$this->id.',%')->get('id')->each(function ($id)use (&$childIds){
            $childIds[]=$id['id'];
        });
        return Requirement::whereIn('asset_id',$childIds)->count();
    }

    //获取子级计划数量
    public function getTotalPlansCountAttribute()
    {
        $childIds = [];
        Asset::where('path','like','%,'.$this->id.',%')->get('id')->each(function ($id)use (&$childIds){
            $childIds[]=$id['id'];
        });
        return Plan::whereIn('asset_id',$childIds)->count();
    }

    public function library(){
        return $this->hasMany(Library::class ,'asset_id')->where('type', 'asset');
    }

}