Application: gvSIG desktop

package org.gvsig.fmap.dal.swing.impl.searchpanel;

import java.awt.BorderLayout;

import java.awt.Cursor;

import java.awt.Dimension;

import java.awt.FlowLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.net.URL;

import java.util.ArrayList;

import java.util.Collection;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.logging.Level;

import javax.swing.AbstractAction;

import javax.swing.Action;

import static javax.swing.Action.ACTION_COMMAND_KEY;

import static javax.swing.Action.NAME;

import javax.swing.BorderFactory;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComponent;

import javax.swing.JOptionPane;

import javax.swing.SwingUtilities;

import javax.swing.event.ListSelectionEvent;

import javax.swing.event.ListSelectionListener;

import javax.swing.table.TableModel;

import org.apache.commons.io.FilenameUtils;

import org.apache.commons.lang.mutable.MutableObject;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.configurableactions.ConfigurableActionsMamager;

import org.gvsig.expressionevaluator.Expression;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionUtils;

import static org.gvsig.fmap.dal.DataManager.DAL_USE_LABELS;

import static org.gvsig.fmap.dal.DataManager.USE_LABELS_BOTH;

import static org.gvsig.fmap.dal.DataManager.USE_LABELS_NO;

import static org.gvsig.fmap.dal.DataManager.USE_LABELS_YES;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.complements.Search;

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

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

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

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

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

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

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

import org.gvsig.fmap.dal.feature.paging.FacadeOfAFeaturePagingHelper;

import org.gvsig.fmap.dal.swing.AbstractDALActionFactory.AbstractDALActionContext;

import org.gvsig.fmap.dal.swing.DALActionFactory;

import org.gvsig.fmap.dal.swing.DALSwingLocator;

import org.gvsig.fmap.dal.swing.featurequery.FeatureQueryCalculatedColumnsPanel;

import org.gvsig.fmap.dal.swing.impl.featuretable.SimpleFeaturesTableModel;

import org.gvsig.fmap.dal.swing.impl.featurequery.DefaultFeatureQueryGroupByPanel;

import org.gvsig.fmap.dal.swing.searchpanel.FeatureStoreSearchPanel;

import org.gvsig.fmap.dal.swing.searchpanel.SearchConditionPanel;

import org.gvsig.fmap.dal.swing.searchpanel.SearchConditionPanel.SearchConditionPanelFactory;

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.dataTypes.DataType;

import org.gvsig.tools.dynobject.Tags;

import org.gvsig.tools.i18n.I18nManager;

import org.gvsig.tools.swing.api.ActionListenerSupport;

import org.gvsig.tools.swing.api.ToolsSwingLocator;

import org.gvsig.tools.swing.api.ToolsSwingManager;

import org.gvsig.tools.swing.api.windowmanager.Dialog;

import org.gvsig.tools.swing.api.windowmanager.WindowManager;

import org.gvsig.tools.swing.api.windowmanager.WindowManager_v2;

import org.gvsig.tools.swing.icontheme.IconTheme;

import org.gvsig.tools.util.ToolsUtilLocator;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.fmap.dal.swing.featurequery.FeatureQueryGroupByPanel;

import org.gvsig.fmap.dal.swing.featurequery.FeatureQueryOrderPanel;

import org.gvsig.fmap.dal.swing.impl.featurequery.DefaultFeatureQueryCalculatedColumnsPanel;

import org.gvsig.fmap.dal.swing.featuretype.FeatureAttributesSelectionPanel;

import org.gvsig.tools.swing.api.threadsafedialogs.ThreadSafeDialogsManager;

/**

 *

 * @author jjdelcerro

 */

@SuppressWarnings({"UseSpecificCatch"})

public class DefaultSearchPanel

        extends DefaultSearchPanelView

        implements FeatureStoreSearchPanel {

    private static final Logger LOGGER = LoggerFactory.getLogger(DefaultSearchPanel.class);

    static /* friend */ Integer useLabels = null;

    public static class UseLabelsYesAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public UseLabelsYesAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Use_labels"));

            this.putValue(ACTION_COMMAND_KEY, "UseLabelsYes");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Use_labels");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel.useLabels = USE_LABELS_YES;

        }

    }

    public static class UseLabelsNoAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public UseLabelsNoAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Use_names"));

            this.putValue(ACTION_COMMAND_KEY, "UseLabelsNo");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Use_names");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel.useLabels = USE_LABELS_NO;

        }

    }

    public static class UseLabelsBothAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public UseLabelsBothAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Use_labels_and_names"));

            this.putValue(ACTION_COMMAND_KEY, "UseLabelsBoth");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Use_labels_and_names");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel.useLabels = USE_LABELS_BOTH;

        }

    }

    public static class SelectColumnsAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public SelectColumnsAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Select_columns_to_display"));

            this.putValue(ACTION_COMMAND_KEY, "SelectColumns");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Select_columns_to_display");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel panel = (DefaultSearchPanel) ae.getSource();

            panel.doSelectResultColumnNames();

        }

    }

    public static class CalculatedColumnsAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public CalculatedColumnsAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Calculated_columns"));

            this.putValue(ACTION_COMMAND_KEY, "CalculatedColumns");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Calculated_columns");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel panel = (DefaultSearchPanel) ae.getSource();

            panel.doCalculatedColumns();

        }

    }

    public static class GroupByAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public GroupByAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Group_by"));

            this.putValue(ACTION_COMMAND_KEY, "GroupBy");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Group_by");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel panel = (DefaultSearchPanel) ae.getSource();

            panel.doGroupBy();

        }

    }

    public static class OrderByAction extends AbstractAction {

        @SuppressWarnings("OverridableMethodCallInConstructor")

        public OrderByAction() {

            I18nManager i18n = ToolsLocator.getI18nManager();

            this.putValue(NAME, i18n.getTranslation("_Order_by"));

            this.putValue(ACTION_COMMAND_KEY, "SelectOrderBy");

        }

        @Override

        public Object getValue(String key) {

            if( NAME.equals(key) ) {

                // Cuando se registra la accion aun no se han cargado las traducciones

                I18nManager i18n = ToolsLocator.getI18nManager();

                return i18n.getTranslation("_Order_by");

            }

            return super.getValue(key);

        }

        @Override

        public void actionPerformed(ActionEvent ae) {

            DefaultSearchPanel panel = (DefaultSearchPanel) ae.getSource();

            panel.doOrderBy();

        }

    }

    private class ActionButtons {

        private final DALActionFactory factory;

        private final Action action;

        private final JButton button;

        public ActionButtons(DALActionFactory factory, Action action, JButton button) {

            this.factory = factory;

            this.action = action;

            this.button = button;

        }

    }

    public static class SearchActionContext extends AbstractDALActionContext {

        private final DefaultSearchPanel panel;

        public SearchActionContext(DefaultSearchPanel panel) {

            super(FeatureStoreSearchPanel.ACTION_CONTEXT_NAME);

            this.panel = panel;

        }

        @Override

        public DataStore getStore() {

            return this.panel.getStore();

        }

        @Override

        public JComponent getActionButton(String actionName) {

            return this.panel.getActionButton(actionName);

        }

        @Override

        public int getSelectedsCount() {

            return this.panel.getSelectedFeatureCount();

        }

        @Override

        public Expression getFilterForSelecteds() {

            return this.panel.getFilterForSelectedFeature();

        }

        @Override

        public FeatureQuery getQuery() {

            return this.panel.getQuery();

        }

    }

    private final FeatureStore store;

    private final ActionListenerSupport acctionListeners;

    private final Map<String, ActionButtons> actions;

    private boolean showActions = true;

    private SearchParameters parameters;

    private List<SearchConditionPanel> conditionPanels;

    private static final int PANEL_SIMPLIFIED = 0;

    private static final int PANEL_ADVANCED = 1;

    public DefaultSearchPanel(FeatureStore store) {

        this.store = store;

        this.acctionListeners = ToolsSwingLocator.getToolsSwingManager().createActionListenerSupport();

        this.actions = new HashMap<>();        

        this.parameters = new SearchParameters();

        FeatureQuery featureQuery = this.store.createFeatureQuery();

        featureQuery.retrievesAllAttributes();

        this.parameters.setQuery(featureQuery);

        Search search = (Search) ToolsLocator.getComplementsManager().get(

                Search.COMPLEMENT_MANE, getFeatureType()

        );

        List<Search.OrderedAttribute> attributos = search.getOrderedAttributes(

                Search.BASIC_TYPES_FILTER,

                Search.STR_INT_LONG_LABEL_ORDER,

                12

        );

        for (Search.OrderedAttribute attrdesc : attributos) {

            this.parameters.getResultColumnNames().add(attrdesc.getDescriptor().getName());

        }

    }

    @Override

    public JComponent asJComponent() {

        if( this.conditionPanels==null ) {

            this.initComponents();

        }

        return this;

    }

    private void addActions() {

        if( !this.showActions ) {

            return;

        }

        this.pnlActions.removeAll();

        this.pnlActions.setLayout(new FlowLayout(FlowLayout.TRAILING, 8, 4));

        SearchActionContext actionContext = new SearchActionContext(this);

        Collection<DALActionFactory> factories = DALSwingLocator.getSwingManager().getStoreActions();

        for (DALActionFactory factory : factories) {

            Action action = factory.createAction(actionContext);

            JButton button = new JButton(action);

            this.actions.put(factory.getName(), new ActionButtons(factory, action, button));

            button.setBorder(BorderFactory.createEmptyBorder());

            button.setBorderPainted(false);

            button.setFocusPainted(false);

            button.setContentAreaFilled(false);

            button.setCursor(new Cursor(Cursor.HAND_CURSOR));

            this.pnlActions.add(button);

        }

        this.pnlActions.revalidate();

        this.pnlActions.repaint();

    }

    @Override

    public void addActionListener(ActionListener listener) {

        this.acctionListeners.addActionListener(listener);

    }

    @Override

    public ActionListener[] getActionListeners() {

        return this.acctionListeners.getActionListeners();

    }

    @Override

    public void removeActionListener(ActionListener listener) {

        this.acctionListeners.removeActionListener(listener);

    }

    @Override

    public void removeAllActionListener() {

        this.acctionListeners.removeAllActionListener();

    }

    @Override

    public void fireActionEvent(ActionEvent event) {

        this.acctionListeners.fireActionEvent(event);

    }

    @Override

    public boolean hasActionListeners() {

        return this.acctionListeners.hasActionListeners();

    }

     private void initComponents() {

        this.conditionPanels = new ArrayList<>();

        ToolsSwingManager swingManager = ToolsSwingLocator.getToolsSwingManager();

        swingManager.translate(this.tabSearchMode);

        swingManager.translate(this.btnSearch);

        swingManager.translate(this.btnClear);

        swingManager.translate(this.lblExpressionDeBusqueda);

        swingManager.translate(this.btnAddAccumulatedFilter);

        swingManager.translate(this.btnRemoveAccumulatedFilter);

        swingManager.translate(this.btnViewAccumulatedFilter);

        ConfigurableActionsMamager cfgActionsManager = ToolsUtilLocator.getConfigurableActionsMamager();

        JComponent c = cfgActionsManager.getConfigurableActionsComponent(CONFIGURABLE_PANEL_ID, this);

        this.pnlCfgActions.setLayout(new BorderLayout(0,0));

        this.pnlCfgActions.add(c, BorderLayout.CENTER);

        this.conditionPanels.add(

            new SearchConditionPanelSimplified(

                store,

                btnAddAccumulatedFilter,

                btnRemoveAccumulatedFilter,

                btnViewAccumulatedFilter,

                lblField1,

                lblExtraFields1,

                lblRelationalOperator1,

                cboValue1,

                lblLogicalOperators1,

                lblField2,

                lblExtraFields2,

                lblRelationalOperator2,

                cboValue2,

                lblLogicalOperators2,

                lblField3,

                lblExtraFields3,

                lblRelationalOperator3,

                cboValue3,

                lblLogicalOperators3,

                lblField4,

                lblExtraFields4,

                lblRelationalOperator4,

                cboValue4,

                null

            )

        );

        this.conditionPanels.add(

            new SearchConditionPanelAdvanced(

                this.store,

                txtAdvancedExpression, 

                btnAdvancedExpression,

                btnAdvancedExpressionHistory,

                btnAdvancedExpressionBookmarks

            )

        );

        for (SearchConditionPanelFactory factory : DALSwingLocator.getManager().getSearchConditionPanels()) {

          String factoryName = "unknown";

          try {

            factoryName = factory.getName();

            if( factory.isApplicable(store) ) {

             SearchConditionPanel panel = factory.create(this);

              this.conditionPanels.add(panel);

              this.tabSearchMode.add(factory.getName(), panel.asJComponent());

            }

          } catch(Throwable th) {

              LOGGER.warn("Can't create search panel '"+factoryName+"'.");

          }

        }

        this.btnSearch.addActionListener((ActionEvent e) -> {

          search();

        });

        this.tblResults.getSelectionModel().addListSelectionListener((ListSelectionEvent e) -> {

          for (ActionButtons actionButton : actions.values()) {

            if( actionButton.action instanceof ListSelectionListener) {

              ((ListSelectionListener) actionButton.action).valueChanged(e);

            }

          }

        });

        this.btnClear.addActionListener((ActionEvent e) -> {

          clear();

        });

        addActions();

        this.setPreferredSize(new Dimension(DEFAULT_WIDTH, DEFAULT_HEIGHT));

        search();

    }

    private FeatureType getFeatureType() {

      try {

        return store.getDefaultFeatureType();

      } catch (Exception ex) {

        throw new RuntimeException("Can't retrieve the feature type.", ex);

      }

    }

    @Override

    public void setEnabled(boolean enabled) {

        if( this.conditionPanels==null ) {

            this.initComponents();

        }

        for (SearchConditionPanel conditionPanel : conditionPanels) {

          conditionPanel.setEnabled(enabled);

        }

        this.btnClear.setEnabled(enabled);

        this.btnSearch.setEnabled(enabled);

        for (ActionButtons actionButton : actions.values()) {

            actionButton.action.setEnabled(enabled);

        }

    }

    @Override

    public void clear() {

        if( this.conditionPanels==null ) {

            return;

        }

        for (SearchConditionPanel conditionPanel : conditionPanels) {

          conditionPanel.clear();

        }

    }

    @Override

    public FeatureQuery getQuery() {

        FeatureQuery query;

        try {

          int searchMode = this.tabSearchMode.getSelectedIndex();

          SearchConditionPanel panel = this.conditionPanels.get(searchMode);

          Expression filter = panel.get();

          if( searchMode!=PANEL_ADVANCED ) {

            this.conditionPanels.get(PANEL_ADVANCED).set(filter);

          }

          query = (FeatureQuery) this.parameters.getQuery().clone();

          query.retrievesAllAttributes();

          if (ExpressionUtils.isPhraseEmpty(filter)) {

              return query;

          }

          query.setFilter(filter);

          query.retrievesAllAttributes();

          return query;

        } catch (Exception ex) {

          LOGGER.warn("Can't build query.",ex);

          return null;

        }

    }

    @Override

    public FeatureQuery getLastQuery() {

        return this.parameters.getQuery();

    }

    public boolean isValid(StringBuilder message) {

        int searchMode = this.tabSearchMode.getSelectedIndex();

        SearchConditionPanel panel = this.conditionPanels.get(searchMode);

        boolean valid = panel.isValid(message);

        return valid;

    }

    @Override

    public void search() {

        final MutableObject model = new MutableObject(null);

        StringBuilder message = new StringBuilder();

        if( !this.isValid(message) ) {

          ThreadSafeDialogsManager dialogManager = ToolsSwingLocator.getThreadSafeDialogsManager();

          dialogManager.messageDialog(

                  "_The_specified_search_condition_is_not_valid", 

                  "_Search",

                  JOptionPane.WARNING_MESSAGE

          );

          return;

        }

        lblMsg.setText("Searching...");

        setEnabled(false);

        Thread th = new Thread(() -> {

          try {

            final List<Feature> features;

            features = store.getFeatures(this.getQuery());

            FacadeOfAFeaturePagingHelper facade = (FacadeOfAFeaturePagingHelper) features;

            FeatureType ftype = facade.getFeaturePagingHelper().getFeatureSet().getDefaultFeatureType();

            // al modelo le pasamos el ftype de esas features

            model.setValue( new SimpleFeaturesTableModel(

                    ftype,

                    parameters.getResultColumnNames(),

                    features

            )

            );

          } catch (Exception ex) {

            LOGGER.warn("Can't get features or create table model",ex);

          } finally {

            SwingUtilities.invokeLater(() -> {

              I18nManager i18n = ToolsLocator.getI18nManager();

              TableModel m = (TableModel) model.getValue();

              tblResults.setModel(m);

              lblMsg.setText(String.format("%d "+i18n.getTranslation("_elements"), m.getRowCount()));

              setEnabled(true);

            });

          }

        });

        th.start();

    }

    public void setResultColumnNames(List<String> names) {

      this.parameters.getResultColumnNames().clear();

      this.parameters.getResultColumnNames().addAll(names);

      if( this.conditionPanels==null ) {

        return;

      }

      SimpleFeaturesTableModel model;

      model = (SimpleFeaturesTableModel) this.tblResults.getModel();

      List<Feature> features = store.getFeatures(this.parameters.getQuery());

      FacadeOfAFeaturePagingHelper facade = (FacadeOfAFeaturePagingHelper) features;

      FeatureType ftype = facade.getFeaturePagingHelper().getFeatureSet().getDefaultFeatureType();

      model = new SimpleFeaturesTableModel(

          ftype,

          this.parameters.getResultColumnNames(),

          features

      );

      tblResults.setModel(model);

    }

    @Override

    public boolean setFilter(Expression filter) {

        try {

            if( this.conditionPanels==null ) {

                this.initComponents();

            }

            if( ExpressionUtils.isPhraseEmpty(filter) ) {

              this.clear();

              return true;

            }

            int panel = 0;

            int selected = PANEL_ADVANCED;

            for (SearchConditionPanel conditionPanel : conditionPanels) {

              if( panel!=PANEL_ADVANCED && conditionPanel.set(filter) ) {

                selected = panel;

              }

              panel++;

            }

            this.tabSearchMode.setSelectedIndex(selected);

//            SimpleFeaturesTableModel model = new SimpleFeaturesTableModel(this.getStore());

//            tblResults.setModel(model);

//            lblMsg.setText("");

            return true;

        } catch(Exception ex) {

            LOGGER.warn("Can't set current search", ex);

            return false;

        }

    }

    @Override

    public List<SearchConditionPanel> getConditionPanels() {

      return Collections.unmodifiableList(this.conditionPanels);

    }

    @Override

    public SearchConditionPanel getConditionPanel(String name) {

      for (SearchConditionPanel panel : conditionPanels) {

        if( StringUtils.equalsIgnoreCase(name, panel.getFactory().getName()) ) {

          return panel;

        }

      }

      return null;

    }

    @Override

    public Expression getFilterForSelectedFeature() {

        if( this.conditionPanels==null ) {

            return null;

        }

        int selectedRow = this.tblResults.getSelectedRow();

        if (selectedRow < 0) {

            return null;

        }

        try {

            List<Feature> features = ((SimpleFeaturesTableModel) this.tblResults.getModel()).getFeatures();

            Feature feature = features.get(selectedRow);

            ExpressionBuilder builder = ExpressionUtils.createExpressionBuilder();

            FeatureType ftype = this.store.getDefaultFeatureType();

            for (FeatureAttributeDescriptor attrdesc : ftype.getPrimaryKey()) {

                builder.and(

                        builder.eq(

                                builder.column(attrdesc.getName()),

                                builder.constant(feature.get(attrdesc.getName()))

                        )

                );

            }

            Expression filter = ExpressionUtils.createExpression(builder.toString());

            return filter;

        } catch (Exception ex) {

            LOGGER.warn("Can't build search for the selected feature.", ex);

            return null;

        }

    }

    @Override

    public FeatureStore getStore() {

        return store;

    }

    private void doOrderBy() {

        I18nManager i18n = ToolsLocator.getI18nManager();

        WindowManager_v2 windowManager = (WindowManager_v2) ToolsSwingLocator.getWindowManager();

        FeatureQueryOrderPanel orderPanel = DALSwingLocator.getDataSwingManager().createFeatureStoreOrderPanel();

        orderPanel.setStore(store);

        orderPanel.put(parameters.getQuery());

        Dialog dialog = windowManager.createDialog(

                orderPanel.asJComponent(),

                i18n.getTranslation("_Select_order"),

                null, 

                WindowManager_v2.BUTTONS_OK_CANCEL

        );

        dialog.addActionListener((ActionEvent e) -> {

          if( dialog.getAction()==WindowManager_v2.BUTTON_OK ) {

            orderPanel.fetch(this.parameters.getQuery());

            search();

          }

        });

        dialog.show(WindowManager.MODE.DIALOG);

    }

    @Override

    public ImageIcon loadImage(String imageName) {

        String name = FilenameUtils.getBaseName(imageName);

        IconTheme theme = ToolsSwingLocator.getIconThemeManager().getDefault();

        if (theme.exists(name)) {

            return theme.get(name);

        }

        URL url = this.getClass().getResource(name + ".png");

        if (url == null) {

            return null;

        }

        return new ImageIcon(url);

    }

    @Override

    public int getSelectedFeatureCount() {

        if( this.conditionPanels==null ) {

            return 0;

        }

        return this.tblResults.getSelectedRowCount();

    }

    @Override

    public JComponent getActionButton(String name) {

        ActionButtons actionButton = this.actions.get(name);

        if( actionButton==null ) {

            return null;

        }

        return actionButton.button;

    }

    @Override

    public void setShowActions(boolean showActions) {

        this.showActions = showActions;

    }

    @Override

    public boolean isShowActions() {

        return this.showActions;

    }

    public static String getAttributeDescriptorLabel(FeatureAttributeDescriptor attrdesc, String tableName) {

        String theLabel;

        int theUseLabels;

        if( useLabels == null ) {

            Tags tags = attrdesc.getTags();

            if( tags.has(DAL_USE_LABELS) ) {

                theUseLabels = tags.getInt(DAL_USE_LABELS, USE_LABELS_NO);

            } else {

                tags = attrdesc.getFeatureType().getTags();

                theUseLabels = tags.getInt(DAL_USE_LABELS, USE_LABELS_NO);

            }

        } else {

            theUseLabels = useLabels;

        }

        switch(theUseLabels) {

            case USE_LABELS_YES:

                if( StringUtils.isBlank(tableName) ) {

                    theLabel = attrdesc.getLocalizedLabel();

                } else {

                    theLabel = String.format("%s [%s]", attrdesc.getLocalizedLabel(), tableName);

                }

                break;

            default:

            case USE_LABELS_NO:

                if( StringUtils.isBlank(tableName) ) {

                    theLabel = attrdesc.getName();

                } else {

                    theLabel = String.format("%s [%s]", attrdesc.getName(), tableName);

                }

                break;

            case USE_LABELS_BOTH:

                if( StringUtils.isBlank(tableName) ) {

                    theLabel = String.format("%s [%s]", attrdesc.getLocalizedLabel(), attrdesc.getName());

                } else {

                    theLabel = String.format("%s [%s/%s]", attrdesc.getLocalizedLabel(), attrdesc.getName(), tableName);

                }

                break;

        }

        return theLabel;

    }

    private void doCalculatedColumns() {

      WindowManager_v2 winmanager = (WindowManager_v2) ToolsSwingLocator.getWindowManager();

      I18nManager i18n = ToolsLocator.getI18nManager();

      final FeatureQueryCalculatedColumnsPanel panel = new DefaultFeatureQueryCalculatedColumnsPanel();

      panel.setStore(this.store);

      panel.put(this.parameters.getQuery());

      final Dialog dialog = winmanager.createDialog(

              panel.asJComponent(),

              i18n.getTranslation("_Calculated_columns"),

              null, 

              WindowManager_v2.BUTTONS_OK_CANCEL

      );

      dialog.addActionListener((ActionEvent e) -> {

        if( dialog.getAction()==WindowManager_v2.BUTTONS_OK ) {

            panel.fetch(this.parameters.getQuery());

            search();

        }

      });

      dialog.show(WindowManager.MODE.DIALOG);

    }

    private void doGroupBy() {

      int allowGroupBy = ((FeatureStoreProviderFactory)(this.store.getProviderFactory())).allowGroupBy();

      if( allowGroupBy!=DataType.YES ) {

        // FIXME: mensaje al usaurio.

        return;

      }

      WindowManager_v2 winmanager = (WindowManager_v2) ToolsSwingLocator.getWindowManager();

      I18nManager i18n = ToolsLocator.getI18nManager();

      final FeatureQueryGroupByPanel panel = new DefaultFeatureQueryGroupByPanel();

      panel.setStore(this.store);

      panel.put(this.parameters.getQuery());

      final Dialog dialog = winmanager.createDialog(

              panel.asJComponent(),

              i18n.getTranslation("_Select_group_columns_and_aggregate_functions"),

              null, 

              WindowManager_v2.BUTTONS_OK_CANCEL

      );

      dialog.addActionListener((ActionEvent e) -> {

        if( dialog.getAction()==WindowManager_v2.BUTTONS_OK ) {

            panel.fetch(this.parameters.getQuery());

            search();

        }

      });

      dialog.show(WindowManager.MODE.DIALOG);

    }

    private void doSelectResultColumnNames() {

      WindowManager_v2 winmanager = (WindowManager_v2) ToolsSwingLocator.getWindowManager();

      I18nManager i18n = ToolsLocator.getI18nManager();

      final FeatureAttributesSelectionPanel panel = DALSwingLocator.getManager().createFeatureAttributeSelectionPanel();

      FeatureType ftype;

        try {

            ftype = store.findFirst(this.parameters.getQuery()).getType();

        } catch (DataException ex) {

            ftype = this.getFeatureType();

        }

      panel.setFeatureType(ftype);

      panel.setSelectedNames(this.parameters.getResultColumnNames());

      final Dialog dialog = winmanager.createDialog(

              panel.asJComponent(),

              i18n.getTranslation("_Select_the_columns_to_display"),

              null, 

              WindowManager_v2.BUTTONS_OK_CANCEL

      );

      dialog.addActionListener((ActionEvent e) -> {

        if( dialog.getAction()==WindowManager_v2.BUTTONS_OK ) {

           this.setResultColumnNames(panel.getSelectedNames());

        }

      });

      dialog.show(WindowManager.MODE.DIALOG);

    }

    public static void selfRegister() {

        String[][] iconNames = new String[][]{

            new String[]{"dalswing", "featurestore-column"},

            new String[]{"dalswing", "featurestore-foreing-key"},

            new String[]{"dalswing", "featurestore-table"},

            new String[]{"dalswing", "search-action-showform"},

            new String[]{"dalswing", "search-action-select"},

            new String[]{"dalswing", "search-action-select-add"},

            new String[]{"dalswing", "search-action-select-filter"}

        };

        IconTheme theme = ToolsSwingLocator.getIconThemeManager().getCurrent();

        for (String[] icon : iconNames) {

            URL url = DefaultSearchPanel.class.getResource(icon[1] + ".png");

            theme.registerDefault("DALSwing", icon[0], icon[1], null, url);

        }

        ConfigurableActionsMamager cfgActionsManager = ToolsUtilLocator.getConfigurableActionsMamager();

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new UseLabelsYesAction());

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new UseLabelsNoAction());

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new UseLabelsBothAction());

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new SelectColumnsAction());

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new CalculatedColumnsAction());

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new GroupByAction());

        cfgActionsManager.addConfigurableAction(CONFIGURABLE_PANEL_ID, new OrderByAction());

    }

}