zikula / core

     *

     * @return ArrayCollection Collection containing retrieved routeEntity instances

     */

    public function selectWhere($where = '', $orderBy = '', $useJoins = true, $slimMode = false)

    {

        $qb = $this->getListQueryBuilder($where, $orderBy, $useJoins, $slimMode);

        $query = $this->getQueryFromBuilder($qb);

        return $this->retrieveCollectionResult($query, false);

    }

    /**

     * Returns query builder instance for retrieving a list of objects with a given where clause and pagination parameters.

     *

     * @return array Retrieved collection and amount of total records affected by this query

     */

    public function selectWherePaginated($where = '', $orderBy = '', $currentPage = 1, $resultsPerPage = 25, $useJoins = true, $slimMode = false)

    {

        $qb = $this->getListQueryBuilder($where, $orderBy, $useJoins, $slimMode);

        $query = $this->getSelectWherePaginatedQuery($qb, $currentPage, $resultsPerPage);

        return $this->retrieveCollectionResult($query, true);

    }

    /**

     * Selects entities by a given search fragment.