PHP code example of nevadskiy / laravel-tree

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

nevadskiy / laravel-tree example snippets

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Nevadskiy\Tree\AsTree;

class Category extends Model
{
    use AsTree;
}

$table->ltree('path')->nullable()->spatialIndex();

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->ltree('path')->nullable()->spatialIndex();
            $table->timestamps();
        });

        Schema::table('categories', function (Blueprint $table) {
            $table->foreignId('parent_id')
                ->nullable()
                ->index()
                ->constrained('categories')
                ->cascadeOnDelete();
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('categories');
    }
};

$table->string('path')->nullable()->index();

$root = new Category();
$root->name = 'Science';
$root->save();

$child = new Category;
$child->name = 'Physics';
$child->parent()->associate($root);
$child->save();

echo $category->parent->name;

foreach ($category->children as $child) {
    echo $child->name;
}

foreach ($category->ancestors as $ancestor) {
    echo $ancestor->name;
}

$ancestors = $category->ancestors()->get();

$hierarchy = $category->joinAncestors();

foreach ($category->descendants as $descendant) {
    echo $descendant->name;
}

$ancestors = $category->descendants()->get();

$roots = Category::query()->root()->get();

$categories = Category::query()->whereDepth(3)->get();

$ancestors = Category::query()->whereSelfOrAncestorOf($category)->get();

$descendants = Category::query()->whereSelfOrDescendantOf($category)->get();

$categories = Category::query()->orderByDepth()->get();
$categories = Category::query()->orderByDepthDesc()->get();

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Nevadskiy\Tree\AsTree;
use Nevadskiy\Tree\Relations\HasManyDeep;

class Category extends Model
{
    use AsTree;

    public function products(): HasManyDeep
    {
        return HasManyDeep::between($this, Product::class);
    }
}

$products = $category->products()->paginate(20);

$products = Product::query()
    ->join('categories', function (JoinClause $join) {
        $join->on('products.category_id', 'categories.id');
    })
    ->whereSelfOrDescendantOf($category)
    ->paginate(24, ['products.*']);

$products = Product::query()
    ->whereHas('category', function (Builder $query) use ($category) {
        $query->whereSelfOrDescendantOf($category);
    })
    ->paginate(24);

$science = Category::query()->where('name', 'Science')->firstOrFail();
$physics = Category::query()->where('name', 'Physics')->firstOrFail();

$physics->parent()->associate($science);
$physics->save();

$tree = Category::query()->orderBy('name')->get()->tree();

echo $category->joinAncestors()->reverse()->implode('name', ' > ');

$category->newQuery()->whereSelfOrDescendantOf($category)->delete();

bash
php artisan vendor:publish --tag=pgsql-ltree-migration