Application: gvSIG desktop

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.app.extension;

import java.awt.Component;

import javax.swing.JOptionPane;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.andami.ui.mdiManager.IWindow;

import org.gvsig.app.gui.filter.ExpressionListener;

import org.gvsig.app.gui.filter.FilterDialog;

import org.gvsig.app.project.documents.table.gui.FeatureTableDocumentPanel;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.FeatureQuery;

import org.gvsig.fmap.dal.feature.FeatureSet;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.utils.exceptionHandling.ExceptionListener;

/**

 * Extensi?n que abre un di?logo para poder hacer un filtro de una capa o tabla.

 * 

 * @author Vicente Caballero Navarro

 */

public class FiltroExtension extends Extension implements ExpressionListener {

    protected FeatureStore featureStore = null;

    protected FeatureTableDocumentPanel table;

    private String filterTitle;

    public void initialize() {

        registerIcons();

    }

    private void registerIcons() {

            IconThemeHelper.registerIcon("action", "table-filter", this);

    }

    public void execute(String actionCommand) {

        if ("table-filter".equals(actionCommand)) {

            IWindow v = PluginServices.getMDIManager().getActiveWindow();

            if (v instanceof FeatureTableDocumentPanel) {

                table = (FeatureTableDocumentPanel) v;

                featureStore = table.getModel().getStore();

                filterTitle = table.getModel().getName();

                table.getModel().setModified(true);

            }

            doExecute();

        }

    }

    protected void doExecute() {

        FilterDialog dlg = new FilterDialog(filterTitle);

        dlg.addExpressionListener(this);

        dlg.addExceptionListener(new ExceptionListener() {

            public void exceptionThrown(Throwable t) {

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

            }

        });

        dlg.setModel(featureStore);

        PluginServices.getMDIManager().addWindow(dlg);

    }

    public boolean isEnabled() {

        return isVisible();

    }

    public boolean isVisible() {

        IWindow v = PluginServices.getMDIManager().getActiveWindow();

        return (v instanceof FeatureTableDocumentPanel);

    }

    // By Pablo: if no filter expression -> no element selected

    public void newSet(String expression) throws DataException {

        if (!this.filterExpressionFromWhereIsEmpty(expression)) {

            FeatureSet set = null;

            try {

                set = doSet(expression);

                if (set == null) {

                    return;

                }

                featureStore.setSelection(set);

            } catch (Exception e) {

                JOptionPane.showMessageDialog(

                    (Component) PluginServices.getMainFrame(),

                    "Asegurate de que la consulta es correcta.");

            } finally {

                if (set != null) {

                    set.dispose();

                }

            }

        } else {

            // By Pablo: if no expression -> no element selected

            featureStore.getFeatureSelection().deselectAll();

        }

    }

    private FeatureSet doSet(String expression) throws DataException {

        FeatureQuery query = featureStore.createFeatureQuery();

        DataManager manager = DALLocator.getDataManager();

        query.setFilter(manager.createExpresion(expression));

        return featureStore.getFeatureSet(query);

    }

    public void addToSet(String expression) throws DataException {

        // By Pablo: if no filter expression -> don't add more elements to set

        if (!this.filterExpressionFromWhereIsEmpty(expression)) {

            FeatureSet set = null;

            try {

                set = doSet(expression);

                if (set == null) {

                    return;

                }

                featureStore.getFeatureSelection().select(set);

            } finally {

                if (set != null) {

                    set.dispose();

                }

            }

        }

    }

    public void fromSet(String expression) throws DataException {

        // By Pablo: if no filter expression -> no element selected

        try {

            if (!this.filterExpressionFromWhereIsEmpty(expression)) {

                NotificationManager.showMessageInfo("Falta por implementar",

                    null);

            } else {

                // By Pablo: if no expression -> no element selected

                featureStore.getFeatureSelection().deselectAll();

            }

        } catch (DataException e) {

            NotificationManager.addError(e);

        }

    }

    /**

     * Returns true if the WHERE subconsultation of the filterExpression is

     * empty ("")

     * 

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

     * @param expression

     *            An string

     * @return A boolean value

     */

    private boolean filterExpressionFromWhereIsEmpty(String expression) {

        if (expression == null) {

            return true;

        }

        String subExpression = expression.trim();

        if (subExpression.length() == 0) {

            return true;

        }

        int pos;

        // Remove last ';' if exists

        if (subExpression.charAt(subExpression.length() - 1) == ';') {

            subExpression =

                subExpression.substring(0, subExpression.length() - 1).trim();

        }

        // If there is no 'where' clause

        if ((pos = subExpression.indexOf("where")) == -1) {

            return false;

        }

        // If there is no subexpression in the WHERE clause -> true

        subExpression =

            subExpression.substring(pos + 5, subExpression.length()).trim(); // +

                                                                             // 5

                                                                             // is

                                                                             // the

                                                                             // length

                                                                             // of

                                                                             // 'where'

        if (subExpression.length() == 0) {

            return true;

        } else {

            return false;

        }

    }

}