BlogCategory.php

<?php
/**
 * Author: Patrik Gmitter <[email protected]>
 * Date: 4/24/12
 */

namespace Model;

use Doctrine\ORM\Mapping as ORM,
Doctrine\ORM\Proxy,
Doctrine\Common\Collections;


/**
 * @ORM\Entity
 * @ORM\Table(name="blogcategory")
 */
class BlogCategory extends \Nette\Object
{

	/**
	 * @ORM\Id
	 * @ORM\Column(type="integer")
	 * @ORM\GeneratedValue
	 */
	protected $id;

	/**
	 * @ORM\Column(type="integer", nullable=true)
	 */
	protected $blogcategory_id;


	/**
	 * @ORM\Column(type="string")
	 */
	protected $title;

	/**
	 * @ORM\Column(type="string")
	 */
	protected $slug;

	/**
	 * @ORM\Column(type="text")
	 */
	protected $description;

	/**
	 * @ORM\Column(type="integer")
	 */
	protected $status;

	/**
	 * @ORM\ManyToOne(targetEntity="BlogCategory", inversedBy="id", cascade={"persist", "remove"})
	 * @ORM\JoinColumn(name="blogcategory_id", referencedColumnName="id", onDelete="CASCADE")
	 */
	protected $parent;

	/**
	 * @ORM\OneToMany(targetEntity="BlogCategory", mappedBy="parent", cascade={"persist", "remove"}, orphanRemoval=true)
	 * @ORM\OrderBy({"id" = "ASC"})
	 */
	protected $childrens;


	public function __construct()
	{
		parent::__construct();
		$this->childrens = new \Doctrine\Common\Collections\ArrayCollection();

	}


	public function getId()
	{
		return $this->id;
	}


	public function getTitle()
	{
		return $this->title;
	}


	public function getChildrens()
	{
		return $this->childrens;
	}


}

NavigationControl.php

<?php
/**
 * Author: Patrik Gmitter <[email protected]>
 * Date: 4/26/12
 */


use Nette\Application\UI\Control,
Nette\Caching\Cache;

class NavigationControl extends Control
{

	const CACHE_NAMESPACE = 'Navigation';

	protected $em;
	protected $cache;
	private $menuTemplate;

	public function __construct(\Doctrine\ORM\EntityManager $em, \Nette\Caching\IStorage $cacheStorage)
	{
		$this->em = $em;
		$this->cache = new Cache($cacheStorage, self::CACHE_NAMESPACE);

	}

	public function render($position = 'top')
	{

		$template = $this->template;
		$template->setFile(__DIR__ . '/' . $position . '.latte');

		$navigacia = $this->cache->load('navigation');
		if ($navigacia === NULL) {

			$qb = $this->em->createQueryBuilder();
			$db_result = $qb
				->select('bc')
				->from('Model\BlogCategory', 'bc')
				->where('bc.blogcategory_id is NULL')


				->getQuery()->getResult();



			$this->cache->save('navigation', $db_result, array(
				Cache::EXPIRE => '+ 1 month'
				//Cache::TAGS => array("navigacia""),
			));

		}
		$template->navigation = $this->cache->load('navigation');

		$template->render();


	}


}

OUTPUT

* kategoria 1
* kategoria 2
* kategoria 3

top.latte

{block #menu}
<ul class="control menu">
	<li n:foreach="$navigation as $item">
		{if count($item->childrens)>0 }
			<span class="active"><strong>{$item->title}</strong></span>
		{include #menu, navigation => $item->childrens}
			{else}
			<span class="active"><strong>{$item->title}</strong></span>
		{/if}

	</li>
</ul>
{/block}