PHP Kalnoy\Nestedset NestedSet Examples

Example #1

File: 2016_07_31_120003_HierarchyCreateNodesTable.php Project: NuclearCMS/Hierarchy

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('nodes', function (Blueprint $table) {
         $table->increments('id');
         $table->integer('node_type_id')->unsigned();
         $table->integer('user_id')->unsigned();
         NestedSet::columns($table);
         $table->boolean('mailing')->default(0);
         $table->boolean('visible')->default(1);
         $table->boolean('sterile')->default(0);
         $table->boolean('home')->default(0);
         $table->boolean('locked')->default(0);
         $table->integer('status')->default(30);
         $table->boolean('hides_children')->default(0);
         $table->double('priority')->unsigned()->default(1);
         $table->timestamp('published_at')->nullable();
         $table->string('children_order')->default('_lft');
         $table->string('children_order_direction', 4)->default('asc');
         $table->enum('children_display_mode', ['tree', 'list'])->default('list');
         $table->timestamps();
         $table->index('mailing');
         $table->index('home');
         $table->index('node_type_id');
         $table->foreign('node_type_id')->references('id')->on('node_types')->onDelete('cascade');
         $table->foreign('user_id')->references('id')->on('users');
     });
 }

Example #2

File: DescendantsRelation.php Project: nutsdo/nong-store

 /**
  * DescendantsRelation constructor.
  *
  * @param QueryBuilder $builder
  * @param Model $model
  */
 public function __construct(QueryBuilder $builder, Model $model)
 {
     if (!NestedSet::isNode($model)) {
         throw new InvalidArgumentException('Model must be node.');
     }
     parent::__construct($builder, $model);
 }

Example #3

File: 2015_07_18_160922_create_categories_table.php Project: DiCore/hours

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         \Kalnoy\Nestedset\NestedSet::columns($table);
     });
 }

Example #4

File: 2015_10_26_112710_create_categories_table.php Project: elieandraos/project-evey

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('title');
         $table->string('image');
         NestedSet::columns($table);
         $table->timestamps();
     });
 }

Example #5

File: 2016_01_12_124608_create_categories_table.php Project: mmonbr/20Pavos

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         $table->text('description')->nullable();
         $table->string('slug');
         NestedSet::columns($table);
         $table->timestamps();
     });
 }

Example #6

File: 2015_08_28_202925_create_categories_table.php Project: nutsdo/nong-store

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('title');
         $table->string('description');
         $table->string('icon');
         \Kalnoy\Nestedset\NestedSet::columns($table);
         $table->timestamps();
     });
 }

Example #7

File: 2016_06_11_135420_create_prso_categories_table.php Project: danilchican/CallForMaster

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('prso_categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         $table->string('slug')->nullable();
         $table->text('desc')->nullable();
         NestedSet::columns($table);
         $table->timestamps();
         $table->index(['_lft', '_rgt', 'parent_id', 'slug']);
     });
 }

Example #8

File: 2015_11_17_230319_create_structure_teble.php Project: iAxel/my-site

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('structure', function (Blueprint $table) {
         $table->increments('id');
         $table->boolean('published')->default(true);
         $table->integer('position')->unsigned();
         $table->string('alias');
         Nestedset\NestedSet::columns($table);
         $table->string('controller');
         $table->timestamps();
     });
 }

Example #9

File: 2015_03_27_151236_create_categories_table.php Project: elvinmakhmudov/shopping.app

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('title');
         $table->string('slug')->unique();
         $table->boolean('is_main')->default(0);
         $table->timestamps();
         $table->softDeletes();
         NestedSet::columns($table);
     });
 }

Example #10

File: NodeTest.php Project: nutsdo/nong-store

 public static function setUpBeforeClass()
 {
     $schema = Capsule::schema();
     $schema->dropIfExists('categories');
     $schema->create('categories', function (\Illuminate\Database\Schema\Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         $table->softDeletes();
         NestedSet::columns($table);
     });
     Capsule::enableQueryLog();
 }

Example #11

File: 2015_09_05_115352_create_article_categories_table.php Project: nutsdo/nong-store

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('article_categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         $table->string('type');
         $table->string('keywords');
         $table->string('description');
         \Kalnoy\Nestedset\NestedSet::columns($table);
         $table->timestamps();
     });
 }

Example #12

File: create_comments_table.php Project: DraperStudio/Laravel-Commentable

 public function up()
 {
     Schema::create('comments', function (Blueprint $table) {
         $table->increments('id');
         $table->string('title')->nullable();
         $table->text('body');
         $table->morphs('commentable');
         $table->morphs('creator');
         NestedSet::columns($table);
         $table->timestamps();
     });
 }

Example #13

File: 2014_10_13_300000_create_permissions_table.php Project: recca0120/laravel-rbac

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('permissions', function (Blueprint $table) {
         $table->increments('id');
         NestedSet::columns($table);
         $table->string('name');
         $table->enum('type', ['directory', 'resource', 'permission'])->default('directory');
         $table->string('icon')->nullable();
         $table->string('as')->nullable();
         $table->string('uses')->nullable();
         $table->timestamps();
     });
 }

Example #14

File: ScopedNodeTest.php Project: nutsdo/nong-store

 public static function setUpBeforeClass()
 {
     $schema = Capsule::schema();
     $schema->dropIfExists('menu_items');
     Capsule::disableQueryLog();
     $schema->create('menu_items', function (\Illuminate\Database\Schema\Blueprint $table) {
         $table->increments('id');
         $table->unsignedInteger('menu_id');
         $table->string('title')->nullable();
         NestedSet::columns($table);
     });
     Capsule::enableQueryLog();
 }

Example #15

File: 2016_02_18_050341_create_new_peoples_table.php Project: brights1de/LiveTex-Test

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('peoples', function (Blueprint $peoples) {
         $peoples->increments('id');
         $peoples->string('name', 25);
         $peoples->string('surname', 25);
         $peoples->integer('age')->unsigned();
         $peoples->enum('gender', ['male', 'female']);
         $peoples->integer('spouse')->nullable()->unsigned();
         $peoples->foreign('spouse')->references('id')->on('peoples');
         NestedSet::columns($peoples);
     });
 }

Example #16

File: 2016_03_11_111122_create_menus_table.php Project: SocietyCMS/Menu

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('menu__menus', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name');
         $table->string('url')->nullable();
         $table->string('attribute_target')->nullable();
         $table->string('attribute_id')->nullable();
         $table->string('attribute_class')->nullable();
         $table->boolean('active')->default(false);
         $table->boolean('useSubject')->default(false);
         $table->integer('subject_id')->nullable()->index();
         $table->string('subject_type')->nullable()->index();
         NestedSet::columns($table);
         $table->timestamps();
         $table->engine = 'InnoDB';
     });
 }

Example #17

File: Collection.php Project: nutsdo/nong-store

 /**
  * @param mixed $root
  *
  * @return int
  */
 protected function getRootNodeId($root = false)
 {
     if (NestedSet::isNode($root)) {
         return $root->getKey();
     }
     if ($root !== false) {
         return $root;
     }
     // If root node is not specified we take parent id of node with
     // least lft value as root node id.
     $leastValue = null;
     /** @var Model|NodeTrait $node */
     foreach ($this->items as $node) {
         if ($leastValue === null || $node->getLft() < $leastValue) {
             $leastValue = $node->getLft();
             $root = $node->getParentId();
         }
     }
     return $root;
 }

Example #18

File: 2014_10_12_000000_create_categories_table.php Project: schel4ok/steklo

 public function up()
 {
     Schema::create('categories', function ($table) {
         $table->increments('id')->unsigned();
         NestedSet::columns($table);
         //	вместо NestedSet::columns($table); можно использовать 3 такие столбца
         //	$table->unsignedInteger('_lft');
         //	$table->unsignedInteger('_rgt');
         //	$table->tinyInteger('parent_id')->unsigned()->nullable();
         $table->tinyInteger('level')->unsigned();
         $table->string('type', 20);
         $table->string('menutype', 20);
         $table->string('title', 100);
         $table->string('sef', 50)->nullable();
         $table->string('class', 50);
         $table->text('body')->nullable();
         $table->string('image', 255)->nullable();
         $table->string('metatitle', 255)->nullable();
         $table->string('metakey', 255)->nullable();
         $table->string('metadesc', 255)->nullable();
     });
 }

Example #19

File: 2015_12_23_165943_create_products_table.php Project: yurilabatsevich/test.dev

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     Schema::create('categories', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name', 30);
         $table->string('name_ru', 30);
         $table->softDeletes();
         NestedSet::columns($table);
     });
     Schema::create('products', function (Blueprint $table) {
         $table->increments('id');
         $table->string('model', 15)->unique();
         $table->string('article', 15)->nullable();
         $table->integer('category_id')->unsigned();
         $table->string('growth')->nullable();
         $table->string('size')->nullable();
         $table->text('description')->nullable();
         $table->boolean('new')->default(0);
         $table->boolean('published')->default(0);
         $table->string('photo')->nullable();
         $table->timestamps();
         $table->foreign('category_id')->references('id')->on('categories')->uonUpdate('cascade');
     });
 }

Example #20

File: 2016_06_08_100642_create_library_categories_table.php Project: hisambahaa/DARES

 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     Schema::drop('library_categories');
     NestedSet::dropColumns($table);
 }

Example #21

File: 2016_01_14_052015_create_ticket_departments_table.php Project: hisambahaa/DARES

 /**
  * Reverse the migrations.
  *
  * @return void
  */
 public function down()
 {
     NestedSet::dropColumns($table);
     Schema::drop('ticket_departments');
 }

Example #22

File: QueryBuilder.php Project: nutsdo/nong-store

 /**
  * @param $id
  * @param $operator
  * @param $boolean
  *
  * @return $this
  */
 protected function whereIsBeforeOrAfter($id, $operator, $boolean)
 {
     if (NestedSet::isNode($id)) {
         $value = '?';
         $this->query->addBinding($id->getLft());
     } else {
         $valueQuery = $this->model->newQuery()->toBase()->select('_n.' . $this->model->getLftName())->from($this->model->getTable() . ' as _n')->where('_n.' . $this->model->getKeyName(), '=', $id);
         $this->query->mergeBindings($valueQuery);
         $value = '(' . $valueQuery->toSql() . ')';
     }
     list($lft, ) = $this->wrappedColumns();
     $this->query->whereRaw("{$lft} {$operator} {$value}", [], $boolean);
     return $this;
 }

Example #23

File: 2015_07_21_052741_create_comments_table.php Project: bailianhua/KruKan-Blog

 /**
  * Reverse the migrations.
  */
 public function down()
 {
     Schema::drop('comments');
     NestedSet::dropColumns('comments');
 }