FOF30\Model\TreeModel::getLevel PHP Method

    public function getLevel()
    {
        // Sanity checks on current node position
        if ($this->lft >= $this->rgt) {
            throw new TreeInvalidLftRgtCurrent();
        }
        if (is_null($this->treeDepth)) {
            $db = $this->getDbo();
            $fldLft = $db->qn($this->getFieldAlias('lft'));
            $fldRgt = $db->qn($this->getFieldAlias('rgt'));
            $query = $db->getQuery(true)->select('(COUNT(' . $db->qn('parent') . '.' . $fldLft . ') - 1) AS ' . $db->qn('depth'))->from($db->qn($this->tableName) . ' AS ' . $db->qn('node'))->join('CROSS', $db->qn($this->tableName) . ' AS ' . $db->qn('parent'))->where($db->qn('node') . '.' . $fldLft . ' >= ' . $db->qn('parent') . '.' . $fldLft)->where($db->qn('node') . '.' . $fldLft . ' <= ' . $db->qn('parent') . '.' . $fldRgt)->where($db->qn('node') . '.' . $fldLft . ' = ' . $db->q($this->lft))->group($db->qn('node') . '.' . $fldLft)->order($db->qn('node') . '.' . $fldLft . ' ASC');
            $this->treeDepth = $db->setQuery($query, 0, 1)->loadResult();
        }
        return $this->treeDepth;
    }