Nette Hierarchy

Usage

Nette forum model, _(*1)

``` php use \Nette\Diagnostics\Debugger, \Nette\Database\Connection;, _(*2)

class ForumModel extends Nette\Object {, _(*3)

/** @var \Nette\Database\Connection */
private $database;    

public function __construct(Connection $db) {
    $this->database = $db;
}

/**
 * Load forums from database.
 * @return Hierarchy 
 */
public function getForums() {

    $forums = $this->database->query('SELECT *
                                      FROM forums
                                      ORDER BY root_id'); // No need to be ordered but it's faster


    /*$forums = $this->database->query('SELECT f.*,
                                            t.changed,
                                            COUNT(t.id) AS topics
                                     FROM forums f
                                     LEFT JOIN (SELECT * 
                                                FROM topics
                                                ORDER BY changed DESC) t ON t.forum_id=f.id
                                     GROUP BY f.id
                                     ORDER BY root_id, f.order'); */

    return new Tree\Hierarchy($forums, 'ForumNode');
}

}, _(*4)

```, _(*5)