fabarea / vidi

     *

     * @return string

     */

    public function getForeignClause()

    {

        $result = '';

        $configuration = $this->getConfiguration();

        if (!empty($configuration['foreign_table_where'])) {

            $parts = explode('ORDER BY', $configuration['foreign_table_where']);

            if (!empty($parts[0])) {

                $result = $parts[0];

            }

        }

        // Substitute some variables

        return $this->substituteKnownMarkers($result);

    }

    /**

     * Substitute some known markers from the where clause in the Frontend Context.

     *

     * @return string

     */

    public function getForeignOrder()

    {

        $result = '';

        $configuration = $this->getConfiguration();

        if (!empty($configuration['foreign_table_where'])) {

            $parts = explode('ORDER BY', $configuration['foreign_table_where']);

            if (!empty($parts[1])) {

                $result = $parts[1];

            }

        }

        return $result;

    }

    /**

     * Returns the MM table of a field.