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\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class AssetController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(Request $request)
    {
        $assets = Asset::query()->where("parent_id", 0)->where('company_id',Auth::user()->company_id)->with(['children','children.children'])->paginate();

        $items = [];
        foreach ($assets as $asset) {
            $items[] = new AssetResource($asset);
        }

        return $this->success([
            'data' => $items,
            'meta' => [
                "current_page" => $assets->currentPage(),
                "per_page" => $assets->perPage(),
                "total" => $assets->total(),
            ]
        ]);
    }

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

        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);

        $asset->update([
            ...$request->all(),
            'whitelist' => $request->whitelist ? sprintf(",%s", implode(',', $request->whitelist)) : null,
        ]);

        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'])->findOrFail($id);

        return new AssetReportResource($asset);
    }
}