| gvSIG desktop 1

import java.awt.Component;

import javax.swing.JOptionPane;

import com.iver.cit.gvsig.fmap.layers.FLayers;

 * Revision 1.4.2.12  2007-01-08 10:09:12  ppiqueras

 * Corridos bugs + nueva funcionalidad.

 *

 * Revision 1.4.2.11  2007/01/04 10:06:25  jcampos

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

	    if (info!=null){

	}

    /**

     * Merge two FLayers in one

     * @param group1

     * @param group2

     * @return

     */

    private FLayers mergeFLayers(FLayers group1, FLayers group2)

    {    	

    	FLayer layer;

    	for(int i = 0; i < group2.getLayersCount(); i++)

    	{

    		layer = group2.getLayer( i );

    		if(group1.getLayer( layer.getName()) == null ){

    			group1.addLayer( layer );

    		}

    	}

    	return group1;

    }

	private class CommandListener implements ActionListener {

		public CommandListener(WFSPropsDialog tp) {

		}

		/* (non-Javadoc)

		 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)

		 */

		public void actionPerformed(ActionEvent e) {

			if ((e.getActionCommand() == "CANCEL") || (!getBtnApply().isEnabled())) {

				close();

				return;

			}else{					

				 } 

				if (e.getActionCommand() == "APPLY"){

					// We can't 'apply' if there is a filter query and it's incorrect

					if (wfsParamsTabbedPane.getFilterQuery() != null) {					

						BaseView vista = (BaseView) PluginServices.getMDIManager().getActiveWindow();

						MapControl mapCtrl = vista.getMapControl();					 

						mapCtrl.getMapContext().getLayers().replaceLayer(layerName, fLayer);					 

						mapCtrl.getMapContext().invalidate();

						applied = true;

						getBtnApply().setEnabled(!applied);

						refreshLayouts();						 

						// If we load another layer, or the same but we've selected others attributes -> notify it to he WFSFilter panel

						if (getWFSFilterPanelIsAsTabForWFSLayersLoad() || (wfsParamsTabbedPane.getFieldsSelectedOfSameLayerHasChanged())) {

							setWFSFilterPanelIsAsTabForWFSLayersLoad(false);

							wfsParamsTabbedPane.resetFieldsSelectedOfSameLayerHasChanged(); // reset that attribute

						}

						// Update values associated to the current selected field

						wfsParamsTabbedPane.updateWFSFilterFieldValues();	

					}

					return;				 

				}

				if (e.getActionCommand() == "OK") {

					// We can't 'apply' if there is a filter query and it's incorrect

					if (wfsParamsTabbedPane.getFilterQuery() != null) {	

						if (!applied) {

							if (getBtnApply().isEnabled()){

								layerName = prepareFlyrWFSLayer();

								View vista = (View) PluginServices.getMDIManager().getActiveWindow();

								MapControl mapCtrl = vista.getMapControl();

								mapCtrl.getMapContext().getLayers().replaceLayer(layerName, fLayer);

								mapCtrl.getMapContext().invalidate();

								refreshLayouts();	

							}

						}	

						close();

						// Update all fields and values known about the current layer loaded (and selected)

						((FLyrWFS)fLayer).setAllFieldsAndValuesKnown(wfsParamsTabbedPane.getAllFieldsAndValuesKnownOfCurrentLayer());

					}

				}

			}

		}

		/**

		 * Updates data in the current layer of current active view

		 * 

		 * @param currentView The current active view

		 * @return Te name of the layer

		 */

		private String prepareFlyrWFSLayer() {

//			 layerName = fLayer.getName();

	//	 	 View activeView = (View) PluginServices.getMDIManager().getActiveWindow();

			VectorialLegend legend = (VectorialLegend)((FLyrVect)fLayer).getLegend();

		 	FMapWFSDriver driver = wfsParamsTabbedPane.getDriver();						

		 	try {

		 		fLayer = wfsParamsTabbedPane.getLayer();

		 		URL host = new URL(wfsParamsTabbedPane.getData().getHost());

		 		String onlineResource = wfsParamsTabbedPane.getData().getOnlineResource();

		 		fLayer = new FLyrWFSFactory().getFLyrWFS(fLayer,host,onlineResource,driver,true);

		 		if (fLayer != null) {

		 			((FLyrWFS)fLayer).setLegend(legend);

		 			 // Update all fields and values known about the current layer loaded (and selected)

		 			((FLyrWFS)fLayer).setAllFieldsAndValuesKnown(wfsParamsTabbedPane.getAllFieldsAndValuesKnownOfCurrentLayer());

		 		}

			} catch (MalformedURLException e1) {

				e1.printStackTrace();

			} catch (FieldNotFoundException e1) {

				e1.printStackTrace();

			} catch (DriverException e1) {

				e1.printStackTrace();

			}

			return fLayer.getName();

		}

		private boolean loadLayer(FLayer flayer) {

			try {

				((FLyrWFS)fLayer).load();

				if (((FLyrWFS)fLayer).getNumfeatures() == ((FLyrWFS)fLayer).getWfsDriver().getRowCount()) {

					JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),

						PluginServices.getText(this,"maxFeatures_aviso"));	

				}

			} catch (Exception e1) {

				e1.printStackTrace();

				JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),

						PluginServices.getText(this,"cantLoad"));

				return false;

			}

			return true;

		}

	}

	 * Sets all fielsd and values known of current layer to WFSFilterPanel

	 */

	public void updateAllFieldsAndValuesKnownOfCurrentLayerToWFSFilterPanel() {

		this.wfsParamsTabbedPane.setAllFieldsAndValuesKnownOfCurrentLayer(((FLyrWFS)this.getFLayer()).getAllFieldsAndValuesKnown());

	}

	/**

import java.text.DateFormat;

import java.util.HashMap;

import java.util.Map;

import java.util.Set;

import java.util.StringTokenizer;

import javax.swing.JOptionPane;

import org.gvsig.gui.beans.Messages;

import com.iver.cit.gvsig.gui.panels.sqlQueryValidation.SQLQueryValidation;

import com.iver.cit.gvsig.project.documents.view.gui.View;

import com.iver.utiles.stringNumberUtilities.StringNumberUtilities;

	private Map allFieldsAndValuesKnownOfCurrentLayer; // This will have all values (not repeated) known of all fields (not repeated)

	///// GUI METHODS ////

	 * 

	 * @param parent A reference to the parent container component of this component

		allFieldsAndValuesKnownOfCurrentLayer = new HashMap(); // Initial capacity = 0

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

					String valor = (String) valuesListModel.getElementAt(index);

					// If value is an string -> set it between apostrophes

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

						putSymbol(valor);

					}

		});

		// Listener: when a user writes something on the textarea -> set it's foreground color to black

		getTxtExpression().getDocument().addDocumentListener(new DocumentListener() {

			/*

			 *  (non-Javadoc)

			 * @see javax.swing.event.DocumentListener#changedUpdate(javax.swing.event.DocumentEvent)

			 */

			public void changedUpdate(DocumentEvent e) {

			}

			/*

			 *  (non-Javadoc)

			 * @see javax.swing.event.DocumentListener#insertUpdate(javax.swing.event.DocumentEvent)

			 */

			public void insertUpdate(DocumentEvent e) {

				getTxtExpression().setForeground(Color.BLACK);

			}

			/*

			 *  (non-Javadoc)

			 * @see javax.swing.event.DocumentListener#removeUpdate(javax.swing.event.DocumentEvent)

			 */

			public void removeUpdate(DocumentEvent e) {				

				getTxtExpression().setForeground(Color.BLACK);

			}			

		});

	 * Gets the element that the 'currentPath' field aims

	 * 

	 * @return An XMLElement

	private XMLElement getNodeOfCurrentPath() {

			Object node = currentPath.getLastPathComponent();

			if ((node != null) && (node instanceof XMLElement)) {

//				XMLElement element = (XMLElement) node;

				return (XMLElement) node;

		return null;

	 * Puts the symbol of selected brach

	 * 

	 * @param mouseEvent A MouseEvent with information  of the selected branch

	public void putSymbolOfSelectedByMouseBranch(TreePath treePath) {

		// Sets the node selected

		if (treePath != null) {

			Object node = treePath.getLastPathComponent();

			if ((node != null) && (node instanceof XMLElement)) {

				XMLElement element = (XMLElement) node;

				XMLElement parent = element.getParentElement();

				String path = element.getName();

				while (parent.getParentElement() != null){

					path = parent.getName() + "/" + path;

					parent = parent.getParentElement();

				putSymbol("\"" + path + "\"");

	 * Gets the value of the inner attribute: 'panelAsATabForWFSLayersLoad'

	 * 

	 * @return A boolean value

	public boolean getWFSFilterPanelIsAsTabForWFSLayersLoad() {

		return this.panelAsATabForWFSLayersLoad;

			super.getValuesJList().setBackground(new Color(220, 220, 220)); // a grey color

			this.allFieldsAndValuesKnownOfCurrentLayer.clear();

			// Loads values known of fields

			this.setValuesKnownOfFields();

	 * Refresh all information about fields

	 * @param feature

	public void refresh(WFSLayerNode feature) {

		featureName = feature.getTitle();

		setFields(feature);

	///// END GUI METHODS /////

	///// METHODS FOR THE FILTER QUERY /////

		String writtenQuery = txtExpression.getText().trim();

		// Validate expression

		if (!this.validateExpression(writtenQuery)) {

			getTxtExpression().setForeground(Color.red);

		}

		else

			// Codify expression (only if the validation has been successful)

			return this.codifyExpression(writtenQuery); // Ignores the spaces at beginning and end of the chain of characters

	 * Removes text in the JTextArea that has the filter subconsultation

	public void removeFilterExpression() {

		getTxtExpression().setText("");

	 * Codifies the expression to ISO ISO-8859_1 and a format that the SQL parser could validate

	 * 

	 * @param expression The expression to be codified 

	 * 

	 * @return The expression codified

	private String codifyExpression(String expression) {

		String result = new String("");

		try

		{			

			// Encode each string of the query

			int index = 0;

			int lastIndex = 0;

			boolean endInnerLoop;

			// Encodes all inner strings to the equivalent codification in ISO-8859_1 with each ' symbol converted to ''

			while (index != -1) {

				index = expression.indexOf("'", index);

				// Add the parts of the chain of characters that not are string

				if (index == -1) {

					result += expression.substring(lastIndex, expression.length());

				}

				else {

					result += expression.substring(lastIndex, index).replaceAll(" [ ]+", " ");

				}

				lastIndex = index;

				endInnerLoop = false;

				// Tries to find each first apostrophe of each string of the query

				if ((index > 0) && (expression.charAt(index - 1) == ' ')) {

					index++;

					// Ignore all inner apostrophes and try to find the last of the string

					while (!endInnerLoop)  {

						index = expression.indexOf("'", index);

						index++;

						// If we haven't arrived to the finish of the string

						if (index != expression.length()) {

							if ((index == -1) || (expression.charAt(index) == ' ')) {

								result += translateString(expression.substring(lastIndex, index));

								endInnerLoop = true;

							}

						}

						else {

							result += translateString(expression.substring(lastIndex, index));

							endInnerLoop = true;

							index = -1; // Force to finish the external loop

						}

					}

					lastIndex = index;

				}

			}

			// Field names are transformated in xix variables that will be analyzed

			// Date(date) is substituted by the correct date format

			result = translateDates(result);

			result = translateNumber(result);

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

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

			logger.debug(result);			

		}

		catch(Exception e) {

			JOptionPane.showMessageDialog(this, Messages.getText("error_coding_filter_query"), Messages.getText("error"), JOptionPane.ERROR_MESSAGE);

			return null;

		}

		return result;

	 * Checks the filter expression if it's correct

	 * 

	 * @param query The query expression to analyze

	 * @return True if it's valid or false if not

	private boolean validateExpression(String query) {

		SQLQueryValidation sQLQueryValidation = new SQLQueryValidation(query, true);

		// Analyzes tokens in query

		StringTokenizer tokens = new StringTokenizer(query, " ");

		String token;

		Set operatorNamesAndSymbols = getOperatorNamesAndSymbols();

		while (tokens.hasMoreTokens()) {

			token = tokens.nextToken().trim();

			// Tries to find an invalid token

			if (token.length() > 0) {

				// Validates if a supposed field exists

				if ( (token.length() > 2) && (token.charAt(0) == '\"') && (token.charAt(token.length()-1) == '\"') ) {

					if (! this.isAField(token.substring(1, token.length()-1))) {

						JOptionPane.showMessageDialog(null, PluginServices.getText(null, "error_validating_sql_filter_query") + ":\n" + PluginServices.getText(null, "the_token") + ": " + token + " " + PluginServices.getText(null, "isnt_a_field_of_layer"), PluginServices.getText(null, "error"), JOptionPane.ERROR_MESSAGE);

						return false;

					}

				}

				else {

					// If it's an string -> ignore

					if (! ((token.charAt(0) == token.charAt(token.length() - 1)) && (token.charAt(0) == '\''))) {

						// If it's a date -> ignore

						int returnValue = validateDate(token);

						if (returnValue == 1) {

							JOptionPane.showMessageDialog(null, PluginServices.getText(null, "error_validating_sql_filter_query") + ":\n" + PluginServices.getText(null, "date_format") + " " + token.substring(5, 16) + " " + PluginServices.getText(null, "incorrect"), PluginServices.getText(null, "error"), JOptionPane.ERROR_MESSAGE);

							return false;

						}

						if (returnValue == 2) {								

							// Else -> Checks if the current token is a valid number or symbol

							if ((! StringNumberUtilities.isNumber(token)) && (! this.isAnOperatorNameOrSymbol(token, operatorNamesAndSymbols))) {

								JOptionPane.showMessageDialog(null, PluginServices.getText(null, "error_validating_sql_filter_query") + ":\n" + PluginServices.getText(null, "not_valid_token") + ": " + token, PluginServices.getText(null, "error"), JOptionPane.ERROR_MESSAGE);

								return false;

							}

							else

								return true;

						}

					}

				}

			}

		}

		// Tries to validate the query, and if fails shows a message

		if (!sQLQueryValidation.validateQuery()) {

			JOptionPane.showMessageDialog(null, PluginServices.getText(null, "error_validating_sql_filter_query") + ":\n" + sQLQueryValidation.getErrorMessage(), PluginServices.getText(null, "error"), JOptionPane.ERROR_MESSAGE);

			return false;

		}

		else	

			return true;

	 * Returns true if there is a field with the same name as 'text'

	 * 

	 * @param text An string

	 * @return A boolean value

	private boolean isAField(String text) {

		return this.allFieldsAndValuesKnownOfCurrentLayer.containsKey(text);		

	 * Validates if a text has a correct date format as Date(dd-mmm-yyyy)  (Ex. Date(03-feb-2004) )

	 * 

	 * @param text

	 * @return 0 -> if has a date format; 1 -> if it's a date that has a but format; 2 -> if it isn't a date

	private int validateDate(String text) {

		// If it's a date -> check if format is correct (Ex.  Date(01-feb-2004) )

		if ( ((text.length() == 17) && (text.startsWith("Date(")) && (text.endsWith(")"))) && (text.charAt(7) == '-') && (text.charAt(11) == '-') ) {

			if ( (StringNumberUtilities.isNaturalNumber(text.substring(5, 7))) && (StringNumberUtilities.isNaturalNumber(text.substring(12, 16))) ) {

				try {

					// If can parse the date -> date with a correct format 

					DateFormat.getDateInstance().parse(text.substring(5, 16));

					return 0;

				} catch (ParseException e) {

					// If can't parse the date -> date with an incorrect format 

					return 1;

			}

			else {

				return 1;

			}

		return 2;

	 * Returns true if there is the 'text' is a symbol or a operator name

	 * 

	 * @param text An string

	 * @return A boolean value

	 */

	private boolean isAnOperatorNameOrSymbol(String text, Set operatorNamesAndSymbols) {		

		return operatorNamesAndSymbols.contains(text);

	}

	/**

	 * @return DOCUMENT ME!

	 * @throws ParseException DOCUMENT ME!

	 * @deprecated In this moments its a reference of the old Validate Expression method

	private String oldValidateExpressionMethod() 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;

	///// END METHODS FOR THE FILTER QUERY /////

	///// METHODS FOR TRANSLATE DATA IN FILTER SENTENCES /////

	/** 

	private String translateWord(String expresion, String word,	String translation) throws ParseException {

		String date = StringUtilities.substringDelimited(expresion, "Date(", ")", 0);

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

	private String translateNumber(String expresion) throws ParseException {

	 * 

	///// END METHODS FOR TRANSLATE DATA IN FILTER SENTENCES /////

	///// METHODS FOR MANIPULATE 'fields' and 'values' /////

	 *

	 * @param t DOCUMENT ME!

	public void setModel(ExpressionDataSource t) {

		try {

			model = t;

            model.start();

        } catch (DriverException e1) {

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

        }

        try {

        	int numberOfFields = model.getFieldCount();

        	if (numberOfFields > 0) {

        		Vector fields = new Vector(0, 1);

        		int j = 0;

				for (int i = 0; i < numberOfFields; i++) {

					 Object field = model.getFieldName(i);

					if (field != null) {

						fields.add(field);

						j++;

				attributesTreeTableModel = new AttributesTreeTableModel(fields.toArray());			

        	}

		} catch (FilterException e) {

			throwException(e);

	 * If there is a field selected, show its new values

	public void updateFieldValues() {

		if (currentPath != null) {

			DataReturnedOfDataLoadingFromActiveView data = DataLoadingFromActiveView.getDefaultExpressionDataSource();

			if ((data != null) && (data.getData() != null)) {

				setModel(data.getData());				

				fillValuesByPath(currentPath);

//				valuesListModel.clear();

				// Updates all tables that their data is about the changed view

				this.updateTablesThatHasNewData();				

				// Adjust JScrollPanes to the the beginning

				getFieldsJScrollPane().getHorizontalScrollBar().setValue(-1);

				getFieldsJScrollPane().getVerticalScrollBar().setValue(-1);

				// Adjust JScrollPanes to the the beginning

				getValuesJScrollPane().getHorizontalScrollBar().setValue(-1);

				getValuesJScrollPane().getVerticalScrollBar().setValue(-1);

				// Adjusts valuesJList to the default position

				getValuesJList().setSelectedIndex(-1); // No item selected

			}

	 * @param feature A Layer node with fields information

						case IXMLType.GML_GEOMETRY: // Don't add branch / field

						case IXMLType.COMPLEX: case IXMLType.SIMPLE: // Add branch / field

			// Stores the name of all leafs (fields) of treeTableModel			

			Object root = attributesTreeTableModel.getRoot();

			if (root != null) {

				Vector fieldsNames = attributesTreeTableModel.getLeafsFromNodeBranch(root);

				for (int j = 0; j < fieldsNames.size(); j++) {

					Object field = fieldsNames.get(j);

					// Avoid errors

					if ( (! (field instanceof XMLElement)) || (field == null) )

						continue;

					// Don't load a geometry field					

					if ( ((XMLElement)field).getEntityType().getType() == IXMLType.GML_GEOMETRY )

						continue;					

					if (! allFieldsAndValuesKnownOfCurrentLayer.containsKey( ((XMLElement)field).getName()) ) {

						allFieldsAndValuesKnownOfCurrentLayer.put(((XMLElement)field).getName(), new HashMap());

					}

				}

			}

	 * This method load all values known of all fields known

	 * (It's used when a new layer is load)

	 */

	private void setValuesKnownOfFields() {

		// Desde el modelo se deber?a acceder a los campos y sus valores cargados		

		try {

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

				String fieldName = model.getFieldName(i);

				HashMap fieldValues = (HashMap) allFieldsAndValuesKnownOfCurrentLayer.get(fieldName);

				if (fieldValues != null) {

					for (int j = 0; j < model.getRowCount(); j++) {

						Value value = model.getFieldValue(j, i);					

						if (value instanceof NullValue)

						    continue;

						Object obj = (Object)value;

						if (obj == null)

							continue;

						fieldValues.put(obj.toString(), obj.toString());

					}

				}

			}

		}

		catch (Exception e) {

			e.printStackTrace();

		}

	}

	/**

	/** 

	 * FIlls list with the values of selected field

	 * 

	 * @param treePath A path in the tree

	 */

	private void fillValuesByPath(TreePath treePath) {

		// Duplicates are removed

		TreeSet conjunto = new TreeSet(new Comparator() {

			public int compare(Object o1, Object o2) {

				if ((o1 != null) && (o2 != null)) {

					Value v2 = (Value) o2;

					Value v1 = (Value) o1;

					BooleanValue boolVal;

					try {

						boolVal = (BooleanValue) (v1.greater(v2));

						if (boolVal.getValue()) {

							return 1;

						}

						boolVal = (BooleanValue) (v1.less(v2));

						if (boolVal.getValue()) {

							return -1;

						}

					} catch (IncompatibleTypesException e) {

						throw new RuntimeException(e);

					}

				}

				return 0;

			}

		}); // For ordernation

		// Remove the previous items

		valuesListModel.clear();

		try {

			//Object root = treePath.getPath()[0];

			XMLElement element = ((XMLElement)treePath.getLastPathComponent());

			// Gets the values associated to the selected branch 

			switch (element.getEntityType().getType()) {

				case IXMLType.SIMPLE:

					if(element.getParentElement().getParentElement() == null) {					

						// Find the selected field and try to obtein values related

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

							String name = model.getFieldName(i);

							// If we find the field (this means that are loaded its values and we can obtein them)

							if (name.equals(element.getName())) {						

								for (int j = 0; j < model.getRowCount(); j++) {					

									Value value = model.getFieldValue(j, i);

									if (value instanceof NullValue)

									    continue;

									if (!conjunto.contains(value)) {

										conjunto.add(value);