WebCMS\Entity\PageRepository::getTreeForSelect()

Complexity

Conditions	6
Paths	8

Size

Total Lines	25
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	42

Importance

Changes

0

<?php
    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;
    }
}