O2System\Reactor\Models\Sql\Traits\AdjacencyTrait

Complexity

Total Complexity

6

Size/Duplication

Total Lines	62
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getChildren()	0	11	3
A	hasChildren()	0	13	3

<?php
/**
 * This file is part of the O2System PHP Framework package.
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 *
 * @author         Steeve Andrian Salim
 * @copyright      Copyright (c) Steeve Andrian Salim
 */

// ------------------------------------------------------------------------

namespace O2System\Reactor\Models\Sql\Traits;

// ------------------------------------------------------------------------

/**
 * Class AdjacencyTrait
 *
 * @package O2System\Reactor\Models\Sql\Traits
 */
trait AdjacencyTrait
{
    /**
     * Parent Key Field
     *
     * @access  public
     * @type    string
     */
    public $parentKey = 'id_parent';

    /**
     * Adjacency Enabled Flag
     *
     * @access  protected
     * @type    bool
     */
    protected $isUseAdjacency = true;

    /**
     * Get Children
     *
     * @param int         $id_parent
     * @param string|null $table
     *
     * @access  public
     * @return  mixed
     */
    public function getChildren($id_parent, $table = null)
    {
        $table = isset($table) ? $table : $this->table;

        $result = $this->qb->table($table)->getWhere([$this->parentKey => $id_parent]);

        if ($result->count() > 0) {
            return $result;
        }

        return false;
    }

    /**
     * Has Children
     *
     * @param int         $id_parent
     * @param string|null $table
     *
     * @access  public
     * @return  bool
     */
    public function hasChildren($id_parent, $table = null)
    {
        $table = isset($table) ? $table : $this->table;

        $result = $this->qb->select('id')->table($table)->getWhere([$this->parentKey => $id_parent]);

        print_out($this->db->getLastQuery());

        if ($result->count() > 0) {
            return true;
        }

        return false;
    }
}