public function getChildrenDirectByCategorie(Categorie $categorie = null)
{
$query = $this->createQueryBuilder('c');
if ($categorie != null) {
$query->where('c.lvl = ' . ($categorie->getLvl() + 1))->andWhere('c.rgt < ' . $categorie->getRgt())->andWhere('c.lft > ' . $categorie->getLft())->andWhere('c.root = ' . $categorie->getRoot());
} else {
$query->where('c.lvl = 0');
}
$query->orderBy('c.lft')->leftJoin('c.children', 'children')->addSelect('children')->leftJoin('children.lastPost', 'p')->addSelect('p');
return $query->getQuery()->getResult();
}
