src/Sulu/Bundle/WebsiteBundle/Navigation/NavigationQueryBuilder.php
protected function buildWhere($webspaceKey, $locale)
    {
        $where = [];
        if (null !== $this->context) {
            $where[] = sprintf("page.[i18n:%s-navContexts] = '%s'", $locale, $this->context);
        }
        if (null !== $this->parent) {
            $where[] = sprintf("ISDESCENDANTNODE(page, '%s')", $this->parent);
        } else {
            $where[] = sprintf("ISDESCENDANTNODE(page, '%s')", '/cmf/' . $webspaceKey . '/contents');
        }

        return implode(' AND ', $where);
    }
protected function buildWhere($webspaceKey, $locale)
    {
        $where = [];
        if (null !== $this->context) {
            $where[] = sprintf("page.[i18n:%s-navContexts] = '%s'", $locale, $this->context);
        }
        if (null !== $this->parent) {
            $where[] = sprintf("ISDESCENDANTNODE(page, '%s')", $this->parent);
        } else {
            $where[] = sprintf("ISDESCENDANTNODE(page, '%s')", '/cmf/' . $webspaceKey . '/contents');
        }

        return implode(' AND ', $where);
    }
protected function buildWhere ( $ webspaceKey , $ locale ) { $ where = [ ] ; if ( null !== $ this -> context ) { $ where [ ] = sprintf ( "page.[i18n:%s-navContexts] = '%s'" , $ locale , $ this -> context ) ; } if ( null !== $ this -> parent ) { $ where [ ] = sprintf ( "ISDESCENDANTNODE(page, '%s')" , $ this -> parent ) ; } else { $ where [ ] = sprintf ( "ISDESCENDANTNODE(page, '%s')" , '/cmf/' . $ webspaceKey . '/contents' ) ; } return implode ( ' AND ' , $ where ) ; }
Returns custom select statement.
Returns custom select statement .