Application\Categories\Table

Complexity

Total Complexity

7

Size/Duplication

Total Lines	71
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes	2
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getRootCategories()	0	4	1
A	buildTree()	0	5	1
A	buildTreeByAlias()	0	6	1
A	generateTree()	0	18	4

<?php
/**
 * @copyright Bluz PHP Team
 * @link https://github.com/bluzphp/skeleton
 */

/**
 * @namespace
 */
namespace Application\Categories;

use Bluz\Proxy\Db;

/**
 * Class Table
 *
 * @package Application\Categories
 *
 * @method  static Row findRow($primaryKey)
 * @method  static Row findRowWhere($whereList)
 */
class Table extends \Bluz\Db\Table
{
    /**
     * Table
     *
     * @var string
     */
    protected $table = 'categories';

    /**
     * Primary key(s)
     * @var array
     */
    protected $primary = array('id');

    /**
     * Get root categories
     * @return array
     */
    public function getRootCategories()
    {
        return $this->select()->where('parentId IS NULL')->orderBy('name', 'ASC')->execute();
    }
    
    /**
     * Build tree by root id
     * @param int $id
     * @return Row
     */
    public function buildTree($id = null)
    {
        $tree = $this->generateTree($id);
        return $tree[$id];
    }

    /**
     * Build tree by root alias
     * @param string $alias
     * @return Row
     */
    public function buildTreeByAlias($alias)
    {
        $current = $this->findRow(['alias' => $alias]);

        return $this->buildTree($current['id']);
    }

    /**
     * Get all categories in tree by rootId
     * @param integer $rootId
     * @return Row[]
     */
    protected function generateTree($rootId)
    {
        /** @var Row[] $categories */
        $categories = Db::fetchGroup(
            'SELECT id, categories.* FROM categories WHERE rootId = :id or id = :id ORDER BY `name`',
            ['id' => $rootId],
            $this->rowClass

The call to Db::fetchGroup() has too many arguments starting with $this->rowClass.

        );
        $categories = array_map('reset', $categories);


        foreach ($categories as $category) {
            if ($category->parentId && $category->id != $category->parentId) {
                $categories[$category->parentId]->addChild($category);
            }
        }
        return $categories;
    }
}