| gvSIG desktop 1

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.tools.dispose.DisposableIterator;

 * 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

 * 

public class FilterDialog extends TableFilterQueryJPanel implements IWindow,

    IWindowListener {

    /**

     * 

     */

    private static final long serialVersionUID = -149317534873551735L;

    private static final Logger logger =

        LoggerFactory.getLogger(FilterDialog.class);

    private FeatureStore model = null;

    private ArrayList expressionListeners = new ArrayList();

    private ExceptionHandlingSupport exceptionHandlingSupport =

        new ExceptionHandlingSupport();

    private NumberFormat nf = NumberFormat.getNumberInstance();

    private String title;

    private final int filterDialog_Width = 500;

    private final int filterDialog_Height = 362;

    private final int widthIncrementForAndami = 20; // This is necessary because

                                                    // when the panel is sent to

                                                    // Andami, that needs a bit

                                                    // more width-space to show

                                                    // that panel.

    /**

     * This is the default constructor

     */

    public FilterDialog(String _title) {

        super();

        title = _title;

        defaultTreeModel = (DefaultTreeModel) fieldsJTree.getModel();

    }

    /**

     * This is the default constructor

     */

    public FilterDialog() {

        super();

        defaultTreeModel = (DefaultTreeModel) fieldsJTree.getModel();

    }

    /*

     * (non-Javadoc)

     * 

     * @see

     * org.gvsig.gui.beans.filterPanel.AbstractFilterQueryJPanel#initialize()

     */

    @Override

    protected void initialize() {

        super.initialize();

        super.resizeHeight(filterDialog_Height);

        super.resizeWidth(filterDialog_Width - widthIncrementForAndami);

        this.addNewListeners();

    }

    /**

     * Adds some listeners

     */

    private void addNewListeners() {

        // Listener for "btnAdd"

        // Adds more elements to the current set

        getBtnAddToCurrentSet().addActionListener(

            new java.awt.event.ActionListener() {

                /*

                 * (non-Javadoc)

                 * 

                 * @see

                 * java.awt.event.ActionListener#actionPerformed(java.awt.event

                 * .ActionEvent)

                 */

                public void actionPerformed(java.awt.event.ActionEvent e) {

                    // final String expr = "select * from '" +

                    // model.getName() + "' where " +

                    // getTxtExpression().getText() + ";";

                    final String expr = getTxtExpression().getText();

                    logger.debug(expr);

                    PluginServices.backgroundExecution(new Runnable() {

                        public void run() {

                            for (int i = 0; i < expressionListeners.size(); i++) {

                                ExpressionListener l =

                                    (ExpressionListener) expressionListeners

                                        .get(i);

                                try {

                                    l.addToSet(expr);

                                } catch (DataException e) {

                                    e.printStackTrace();

                                }

                            }

                        }

                    });

                }

            });

        // Listener for "btnNuevo"

        // Adds a new set

        getBtnNewSet().addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent e) {

                // final String expr = "select * from '" +

                // model.getName() + "' where " +

                // getTxtExpression().getText() + ";";

                final String expr = getTxtExpression().getText();

                logger.debug(expr);

                PluginServices.backgroundExecution(new Runnable() {

                    public void run() {

                        for (int i = 0; i < expressionListeners.size(); i++) {

                            ExpressionListener l =

                                (ExpressionListener) expressionListeners.get(i);

                            try {

                                l.newSet(expr);

                            } catch (DataException e) {

                                // TODO Auto-generated catch block

                                NotificationManager.addError(e);

                            }

                        }

                    }

                });

            }

        });

        // Listener for "btnFromSet"

        // Selects elements from the current filtered selection

        getBtnFromSet().addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent e) {

                // final String expr = "select * from '" +

                // model.getName() + "' where " +

                // getTxtExpression().getText() + ";";

                final String expr = getTxtExpression().getText();

                logger.debug(expr);

                PluginServices.backgroundExecution(new Runnable() {

                    public void run() {

                        for (int i = 0; i < expressionListeners.size(); i++) {

                            ExpressionListener l =

                                (ExpressionListener) expressionListeners.get(i);

                            try {

                                l.fromSet(expr);

                            } catch (DataException e) {

                                NotificationManager.addError(e);

                            }

                        }

                    }

                });

            }

        });

        // Listener for "fieldsJTree"

        getFieldsJTree().addMouseListener(new MouseAdapter() {

            /*

             * (non-Javadoc)

             * 

             * @see

             * java.awt.event.MouseListener#mouseClicked(java.awt.event.MouseEvent

             * )

             */

            @Override

            public void mouseClicked(MouseEvent e) {

                int row = fieldsJTree.getRowForLocation(e.getX(), e.getY());

                if (row > -1) {

                    switch (e.getClickCount()) {

                    case 1:

                        fillValues(row);

                        break;

                    case 2:

                        putSymbol(jtreeRoot.getChildAt(row).toString());

                        break;

                    }

                }

            }

        });

        // Listener for "valuesJList"

        getValuesJList().addMouseListener(new MouseAdapter() {

            /*

             * (non-Javadoc)

             * 

             * @see

             * java.awt.event.MouseListener#mouseClicked(java.awt.event.MouseEvent

             * )

             */

            @Override

            public void mouseClicked(MouseEvent e) {

                if (e.getClickCount() == 2) {

                    Object valor =

                        valuesListModel.getElementAt(getValuesJList()

                            .getSelectedIndex());

                    if (valor instanceof Date) {

                        putSymbol("date('" + valor + "')");

                    } else

                        if (valor instanceof Boolean) {

                            putSymbol("boolean('" + valor.toString() + "')");

                        } else

                            if (valor instanceof String) {

                                putSymbol("'" + valor + "'");

                            } else {

                                putSymbol(valor.toString());

                            }

                }

            }

        });

    }

    /**

     * Rellena la lista con los valores del campo seleccionado

     */

    private void fillValues(int row) {

        // int index = lstCampos.getSelectedIndex();

        // Index es ahora el ?ndice del campo seleccionado

        // Se eliminan los duplicados

        Collection conjunto = new TreeSet(new Comparator() {

            public int compare(Object o1, Object o2) {

                return ((Comparable) o1).compareTo(o2);

            }

        }); // Para poder ordenar

        valuesListModel.clear();

        FeatureSet fs = null;

        DisposableIterator iterator = null;

        try {

            String[] fieldName =

                new String[] { ((FeatureAttributeDescriptor) model

                    .getDefaultFeatureType().get(row)).getName() };

            FeatureQuery query = model.createFeatureQuery();

            query.setAttributeNames(fieldName);

            fs = model.getFeatureSet(query);

            iterator = fs.iterator();

            while (iterator.hasNext()) {

                Feature feature = (Feature) iterator.next();

                Object value = feature.get(fieldName[0]);

                if (value == null) {

                    continue;

                }

                conjunto.add(value);

            }

            Iterator it = conjunto.iterator();

            while (it.hasNext()) {

                valuesListModel.addElement(it.next());

            }

        } catch (DataException e) {

            throwException(e);

        } finally {

            DisposeUtils.dispose(iterator);

            DisposeUtils.dispose(fs);

        }

    }

    /**

     * DOCUMENT ME!

     * 

     * @param t

     *            DOCUMENT ME!

     */

    public void setModel(FeatureStore t) {

        // try {

        model = t;

        // model.start();

        // } catch (ReadException e1) {

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

        // }

            Iterator attributes = model.getDefaultFeatureType().iterator();

            while (attributes.hasNext()) {

                FeatureAttributeDescriptor descriptor =

                    (FeatureAttributeDescriptor) attributes.next();

                Object field = descriptor.getName();

                if (field != null) {

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

                }

            }

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

            // Object field = model.getFieldName(i);

            //

            // if (field != null) {

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

            // }

            // }

            defaultTreeModel.setRoot(jtreeRoot);

        } catch (DataException 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, ...

     */

    @Override

    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);

        // if (System.getProperty("os.name")co.compareTo(arg0))

        vi.setHeight(this.filterDialog_Height);

        vi.setWidth(this.filterDialog_Width);

        // Old instructions

        // 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)

     * 

    /*

     * (non-Javadoc)

     * 

        // try {

        // model.stop();

        // } catch (ReadDriverException e) {

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

        // }

        return WindowInfo.TOOL_PROFILE;

    }

}

 * 

    protected FeatureStore featureStore = null;

    private String filterTitle;

    /**

     * DOCUMENT ME!

     */

    public void initialize() {

        registerIcons();

    }

    private void registerIcons() {

        PluginServices.getIconTheme().registerDefault("table-filter",

            this.getClass().getClassLoader().getResource("images/Filtro.png"));

    }

    /**

     * DOCUMENT ME!

     * 

     * @param actionCommand

     *            DOCUMENT ME!

     */

    public void execute(String actionCommand) {

        if ("FILTRO".equals(actionCommand)) {

            // try {

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

                ViewDocument pv =

                    ((org.gvsig.app.project.documents.view.gui.DefaultViewPanel) v)

                        .getModel();

                filterTitle =

                    ((org.gvsig.app.project.documents.view.gui.DefaultViewPanel) v)

                        .getModel().getName();

                FLayer layer = pv.getMapContext().getLayers().getActives()[0];

                featureStore = ((FLyrVect) layer).getFeatureStore();// pv.getProject().getDataSourceByLayer(layer);

                ((AbstractDocument) pv).setModified(true);

            }

            // } catch (ReadException e) {

            // NotificationManager.addError("Error filtrando", e);

            // }

            doExecute();

        }

    }

    /**

     * "execute" method action.

     * 

     */

    protected void doExecute() {

        // DefaultExpressionDataSource ds = new DefaultExpressionDataSource();

        // ds.setTable(featureStore);

        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);

    }

    /**

     * DOCUMENT ME!

     * 

     * @return DOCUMENT ME!

     */

    public boolean isEnabled() {

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

                    && (seleccionadas[0] instanceof FLyrVect)) {

    }

    /**

     * DOCUMENT ME!

     * 

     * @return DOCUMENT ME!

     */

    public boolean isVisible() {

    }

    /**

     * DOCUMENT ME!

     * 

     * @param expression

     *            DOCUMENT ME!

     */

    // 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) {

                    // throw new RuntimeException("Not a 'where' clause?");

                    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();

        }

    }

    /**

     * @throws DataException

     * @see org.gvsig.app.gui.filter.ExpressionListener#newSet(java.lang.String)

     */

    private FeatureSet doSet(String expression) throws DataException {

        FeatureQuery query = featureStore.createFeatureQuery();

        DataManager manager = DALLocator.getDataManager();

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

        return featureStore.getFeatureSet(query);

        // try {

        // DataSource ds =

        // LayerFactory.getDataSourceFactory().executeSQL(expression,

        // DataSourceFactory.MANUAL_OPENING);

        //

        // return ds.getWhereFilter();

        // } catch (DriverLoadException e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"driver_error")+"\n"+e.getMessage());

        // } catch (ReadDriverException e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"driver_error")+"\n"+e.getMessage());

        // } catch (ParseException e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"parse_expresion_error")+"\n"+e.getMessage());

        // } catch (SemanticException e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"semantic_expresion_error")+"\n"+e.getMessage());

        // } catch (IOException e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"input_output_error")+"\n"+e.getMessage());

        // } catch (EvaluationException e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"parse_expresion_error")+"\n"+e.getMessage());

        // } catch (com.hardcode.gdbms.parser.TokenMgrError e) {

        // JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"expresion_error")+"\n"+e.getMessage());

        // }

        // return null;

    }

    /**

     * DOCUMENT ME!

     * 

     * @param expression

     *            DOCUMENT ME!

     * @throws DataException

     */

    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);