| gvSIG desktop 1

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/**

 * 

 */

package com.iver.cit.gvsig.gui.filter;

import java.text.NumberFormat;

import java.text.ParseException;

import java.util.ArrayList;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

import javax.swing.tree.DefaultMutableTreeNode;

import org.apache.log4j.Logger;

import org.gvsig.gui.beans.filterPanel.tableFilterQueryPanel.TableFilterQueryJPanel;

import com.hardcode.gdbms.engine.data.driver.DriverException;

import com.iver.andami.PluginServices;

import com.iver.andami.messages.NotificationManager;

import com.iver.andami.ui.mdiManager.IWindow;

import com.iver.andami.ui.mdiManager.IWindowListener;

import com.iver.andami.ui.mdiManager.WindowInfo;

import com.iver.cit.gvsig.project.documents.table.gui.Table;

import com.iver.utiles.DefaultCharSet;

import com.iver.utiles.StringUtilities;

import com.iver.utiles.exceptionHandling.ExceptionHandlingSupport;

import com.iver.utiles.exceptionHandling.ExceptionListener;

/**

 * This class substitutes the old "FilterDialog" class made by "Fernando Gonz?lez Cort?s"

 * The functionality is the same, but now the class is made from separately (and reusable) components

 * 

 * @author Pablo Piqueras Bartolom? (p_queras@hotmail.com)

 */

public class NewFilterDialog extends TableFilterQueryJPanel implements IWindow, IWindowListener {

        private static Logger logger = Logger.getLogger(Table.class.getName());

        private ExpressionDataSource model = null;

        private ArrayList expressionListeners = new ArrayList();

        private ExceptionHandlingSupport exceptionHandlingSupport = new ExceptionHandlingSupport();

        private NumberFormat nf = NumberFormat.getNumberInstance();

        private String title;

        /**

         * This is the default constructor

         */

        public NewFilterDialog(String _title) {                

                super();

                initialize();

                title = _title;

        }

        /**

         * This is the default constructor

         */

        public NewFilterDialog() {                

                super();

                initialize();

        }

        /**

         * DOCUMENT ME!

         *

         * @param t DOCUMENT ME!

         */

        public void setModel(ExpressionDataSource t) {

                try {

                        model = t;

            model.start();

        } catch (DriverException e1) {

            NotificationManager.addError(e1.getMessage(), e1);

        }

        jtreeRoot.removeAllChildren();

        try {

                        for (int i = 0; i < model.getFieldCount(); i++) {

                                Object field = model.getFieldName(i);

                                layerFeaturesFields.addField(field);

                                jtreeRoot.add(new DefaultMutableTreeNode(field.toString()));

                        }

                } catch (FilterException e) {

                        throwException(e);

                }

        }

        /**

                 * DOCUMENT ME!

                 *

                 * @return DOCUMENT ME!

                 *

                 * @throws ParseException DOCUMENT ME!

                 */

                private String validateExpression() throws ParseException {

                        String expression = txtExpression.getText();

        //                HashSet variablesIndexes = new HashSet();

        //

        //                StringBuffer traducida = new StringBuffer();

                        //Se transforman los nombres de los campos en las variables xix que analizar?n

                        //Se quitan los Date(fecha) y se mete la fecha correspondiente

                        expression = translateDates(expression);

                        expression = translateNumber(expression);

                        expression = translateWord(expression, "true", "1");

                        expression = translateWord(expression, "false", "0");

                        String replacement;

                        Pattern patron = Pattern.compile("[^<>!]=");

                        Matcher m = patron.matcher(expression);

                        int index = 0;

                        while (m.find(index)) {

                                index = m.start();

                                replacement = expression.charAt(index) + "==";

                                m.replaceFirst(replacement);

                                index++;

                        }

                        expression = expression.replaceAll("[^<>!]=", "==");

                        logger.debug(expression);

                        return expression;

                }

        /**

         * Redefinition of the 'putSymbol' method of AbstractFilterQueryJPanel

         *   (I've made this redefinition for write the same code as the 'putSymbol'

         *    code of the original class (FilterDialog) that was in this project

         *    (appgvSIG) and didn't has path troubles to find 'StringUtilities').

         * 

         * Sets a symbol on the filter expression (JTextArea that stores and shows

         *   the current filter expression)

         *

         * @param symbol A symbol: character, characters, number, ...

         */

        protected void putSymbol(String symbol) {

                int position = txtExpression.getCaretPosition();

                txtExpression.setText(StringUtilities.insert(txtExpression.getText(),

                                position, symbol));

                if (symbol.equals(" () ")) {

                        position = position + 2;

                } else {

                        position = position + symbol.length();

                }

                txtExpression.setCaretPosition(position);

        }

        /**

         * DOCUMENT ME!

         *

         * @param expresion DOCUMENT ME!

         * @param substring DOCUMENT ME!

         * @param startingPos DOCUMENT ME!

         *

         * @return DOCUMENT ME!

         */

        private int getIndex(String expresion, String substring, int startingPos) {

                int index = startingPos;

                do {

                        index = expresion.indexOf(substring, index);

                } while ((StringUtilities.isBetweenSymbols(expresion, index, "\"")) &&

                                (index != -1));

                return index;

        }

        /**

         * DOCUMENT ME!

         *

         * @param expresion DOCUMENT ME!

         * @param word DOCUMENT ME!

         * @param translation DOCUMENT ME!

         *

         * @return DOCUMENT ME!

         *

         * @throws ParseException DOCUMENT ME!

         */

        private String translateWord(String expresion, String word,

                String translation) throws ParseException {

                int booleanIndex = 0;

                int endIndex = 0;

                StringBuffer res = new StringBuffer();

                while ((booleanIndex = getIndex(expresion, word, booleanIndex)) != -1) {

                        res.append(expresion.substring(endIndex, booleanIndex));

                        endIndex = booleanIndex + word.length();

                        booleanIndex++;

                        res.append(translation);

                }

                if (endIndex < expresion.length()) {

                        res.append(expresion.substring(endIndex));

                }

                return res.toString();

        }

        /**

         * DOCUMENT ME!

         *

         * @param expresion DOCUMENT ME!

         *

         * @return DOCUMENT ME!

         *

         * @throws ParseException DOCUMENT ME!

         */

        private String translateDates(String expresion) throws ParseException {

                //Se obtiene el valor de la fecha

                String date = StringUtilities.substringDelimited(expresion, "Date(",

                                ")", 0);

                if (date == null) {

                        return expresion;

                }

                //Se comprueba que no est? entre comillas 

                int startIndex = expresion.indexOf(date);

                while (startIndex != -1) {

                        if (!StringUtilities.isBetweenSymbols(expresion, startIndex, "\"")) {

                                //Se sustituye por el valor ordinal de la fecha

                                expresion = expresion.substring(0, startIndex - 5) +

                                        expresion.substring(startIndex).replaceFirst(date + "\\)",

                                                new Long((filterButtonsJPanel.getDateFormat().parse(date)).getTime()).toString());

                                ;

                        } else {

                                startIndex += date.length();

                        }

                        //Se obtiene el valor de la fecha

                        /*            date = StringUtilities.substringDelimited(expresion, "Date(", ")",

                           startIndex);

                         */

                        if (date == null) {

                                return expresion;

                        }

                        startIndex = expresion.indexOf(date, startIndex);

                }

                return expresion;

        }

        /**

         * DOCUMENT ME!

         *

         * @param expresion DOCUMENT ME!

         *

         * @return DOCUMENT ME!

         *

         * @throws ParseException DOCUMENT ME!

         */

        public String translateNumber(String expresion) throws ParseException {

                DefaultCharSet ss = new DefaultCharSet();

                ss.addInterval('0', '9');

                ss.addCharacter(',');

                ss.addCharacter('.');

                String number = StringUtilities.substringWithSymbols(expresion, ss, 0);

                if (number == null) {

                        return expresion;

                }

                int startIndex = expresion.indexOf(number);

                while (startIndex != -1) {

                        Number n = nf.parse(number);

                        if (!StringUtilities.isBetweenSymbols(expresion, startIndex, "\"")) {

                                //Se sustituye por el valor ordinal de la fecha

                                expresion = expresion.substring(0, startIndex) +

                                        expresion.substring(startIndex).replaceFirst(number,

                                                n.toString());

                        } else {

                                startIndex += n.toString().length();

                        }

                        number = StringUtilities.substringWithSymbols(expresion, ss,

                                        startIndex);

                        if (number == null) {

                                return expresion;

                        }

                        startIndex = expresion.indexOf(number, startIndex);

                }

                return expresion;

        }

        /**

         * DOCUMENT ME!

         *

         * @param arg0

         *

         * @return

         */

        public boolean addExpressionListener(ExpressionListener arg0) {

                return expressionListeners.add(arg0);

        }

        /**

         * DOCUMENT ME!

         *

         * @param arg0

         *

         * @return

         */

        public boolean removeExpressionListener(ExpressionListener arg0) {

                return expressionListeners.remove(arg0);

        }

        /**

         * @see com.iver.mdiApp.ui.MDIManager.IWindow#getWindowInfo()

         */

        public WindowInfo getWindowInfo() {

                WindowInfo vi = new WindowInfo(WindowInfo.ICONIFIABLE);

                vi.setWidth(480);

                vi.setHeight(362);

                vi.setTitle(PluginServices.getText( this, "filtro") + " (" + title + ")");

                return vi;

        }

        /**

         * DOCUMENT ME!

         *

         * @param o DOCUMENT ME!

         */

        public void addExceptionListener(ExceptionListener o) {

                exceptionHandlingSupport.addExceptionListener(o);

        }

        /**

         * DOCUMENT ME!

         *

         * @param o DOCUMENT ME!

         *

         * @return DOCUMENT ME!

         */

        public boolean removeExceptionListener(ExceptionListener o) {

                return exceptionHandlingSupport.removeExceptionListener(o);

        }

        /**

         * DOCUMENT ME!

         *

         * @param t DOCUMENT ME!

         */

        private void throwException(Throwable t) {

                exceptionHandlingSupport.throwException(t);

        }

    /* (non-Javadoc)

     * @see com.iver.andami.ui.mdiManager.ViewListener#viewActivated()

     */

    public void windowActivated() {

    }

    /* (non-Javadoc)

     * @see com.iver.andami.ui.mdiManager.ViewListener#viewClosed()

     */

    public void windowClosed() {

        try {

            model.stop();

        } catch (DriverException e) {

            NotificationManager.addError(e.getMessage(), e);

        }        

    }

}