autocde2.0/app/Http/Controllers/API/AssetController.php

<?php

namespace App\Http\Controllers\API;

use App\Http\Controllers\Controller;
use App\Http\Requests\API\Asset\CreateOrUpdateRequest;
use App\Http\Resources\API\AssetReportResource;
use App\Http\Resources\API\AssetResource;
use App\Models\Asset;
use App\Models\File;
use App\Models\User;
use App\Services\File\ImageUrlService;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class AssetController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(Request $request)
    {
        $fullAsset=[];
        $paths = Asset::filter($request->all())
            ->where('company_id',Auth::user()->company_id)
            ->allowed()->pluck('path')->toArray();

            foreach ($paths as $path){
                $parentAssets = explode(',', substr($path, 1, -1));
                $fullAsset=  array_merge($parentAssets,$fullAsset);
            }

        $resultAssets = Asset::whereIn('id', $fullAsset)->get()->each(function ($asset) {
            $asset->requirement_total = $asset->total_requirements_count;
            $asset->plan_total = $asset->total_plans_count;
        });
        return make_tree($resultAssets->toArray());

    }

    /**
     * Store a newly created resource in storage.
     */
    public function store(CreateOrUpdateRequest $request)
    {
        $asset = Asset::create([
            ...$request->all(),
            'company_id' => Auth::user()->company_id,
            'whitelist' => $request->whitelist ? sprintf(",%s,", implode(',', $request->whitelist)) : null,
            'description' => $request->description? (new \App\Services\File\ImageUrlService)->interceptImageUrl($request->description) : null,
            'created_by' => Auth::id(),
        ]);

        $parentAsset = $request->parent_id > 0
            ? Asset::query()->findOrFail($request->parent_id)
            : null;

        $asset->path = $parentAsset ? $parentAsset?->path . $asset->id . "," : sprintf(",%s,", $asset->id);
        $asset->save();

        return $this->created();
    }

    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        $asset = Asset::allowed()->findOrFail($id);

        return new AssetResource($asset);
    }

    /**
     * Update the specified resource in storage.
     */
    public function update(Request $request, string $id)
    {
        $asset = Asset::allowed()->findOrFail($id);

        $parentAsset = $request->parent_id > 0
            ? Asset::query()->findOrFail($request->parent_id)
            : null;

        $isUpdateParent = $parentAsset?->id != $asset->parent_id;
        $path = $isUpdateParent ? $parentAsset->path . $asset->id . "," : $asset->path;
        $formData = [
            ...$request->all(),
            'whitelist' => $request->whitelist ? sprintf(",%s,", implode(',', $request->whitelist)) : null,
            'description' => $request->description? (new \App\Services\File\ImageUrlService)->interceptImageUrl($request->description) : null,
            'path' => $path
        ];

        if ($isUpdateParent) {
            $children = Asset::query()
                ->where("id", "!=", $asset->id)
                ->where("path", "like", "%," . $asset->id . ",%")
                ->get();

            foreach ($children as $child) {
                $child->fill([
                    'path' => str_replace($asset->path, $path, $child->path),
                ]);
                $child->save();
            }
        }

        $asset->fill($formData);
        $asset->save();

        return $this->noContent();
    }

    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
        $asset = Asset::allowed()->findOrFail($id);
        if(!empty($asset->children()->first())){
            throw new \Exception("Please remove the sub-level assets.");
        }

        $asset->delete();

        return $this->noContent();
    }

    public function report(string $id){
        $asset = Asset::allowed()->with(['requirements','plans','projects','children'])->findOrFail($id);
        //$asset = Asset::find($id);
        $assets=Asset::query()->where("path","like","%,".$id.",%")->pluck("id");
        $asset->setAttribute('child_id',$assets);


        return new AssetReportResource($asset);
    }

    public function tree()
    {
        $attachmentArray = [];
        $assets = Asset::allowed()->get(['id', 'name', 'parent_id'])->each(function ($assets)use (&$attachmentArray){
            $attachmentArray[]=[
            'parent_id'=>$assets->id,
            'type'=>'attachment',
            'name'=>'attachment',
            'uuId'=>'attachment_'.$assets->id,
            'id'=>'asset_id_'.$assets->id,
        ];
            $assets->type='asset';
            $assets->uniId=$assets->type.'_'.$assets->id;
        });

        return $this->success([
            'data' => make_tree(array_merge($assets->toArray(),$attachmentArray))
        ]);
    }
}