WebCMS\Entity\PageRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	28
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	getTreeForSelect()	0	25	6

<?php

namespace WebCMS\Entity;

use Gedmo\Tree\Entity\Repository\NestedTreeRepository;

class PageRepository extends NestedTreeRepository
{
    public function getTreeForSelect($order = null, $where = null)
    {
        $qb = $this->_em->createQueryBuilder();

        if ($order) {
            foreach ($order as $o) {
                $qb->addOrderBy('l.'.$o['by'], $o['dir']);
            }
        }

        if ($where) {
            foreach ($where as $w) {
                $qb->andWhere('l.'.$w);
            }
        }

        $tree = $qb->select('l')->from("WebCMS\Entity\Page", 'l')->getQuery()->getResult();

        $array = array();
        foreach ($tree as $node) {
            $array[$node->getId()] = str_repeat("-", $node->getLevel()).$node->getTitle();
        }

        return $array;
    }
}