Add tree structure to Eloquent models. In this package try to use optimize queries.
just run below command:
composer require aminsamadzadeh/simorghCreate migration.
...
public function up()
{
Schema::table('categories', function (Blueprint $table) {
// vispobish pckage
$table->string('path')->nullable(); // save path of tree
$table->unsignedInteger('parent_id')->nullable();
$table->foreign('parent_id')->references('id')->on('categories');
});
}
...Add Treeable trait to model.
...
use Illuminate\Database\Eloquent\Model;
use AminSamadzadeh\Vispobish\Treeable;
class Category extends Model
{
use Treeable;
}
...if you want save path with spicial name you can add public $namedPathWith property to your model and add named_path to migration.
...
public function up()
{
Schema::table('categories', function (Blueprint $table) {
$table->string('named_path')->unique(); // just used when set $pahtNamedWith
});
}
......
class Category extends Model
{
use Treeable;
public $namedPathWith = 'name';
}
...$cat->parent()get parent$cat->children()get children$cat->descendants()get flatten children of childrens$cat->ancestors()get flatten all parents