| gvSIG desktop 1

package org.gvsig.project.document.table.gui;

import java.awt.BorderLayout;

import java.awt.FlowLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.util.ArrayList;

import java.util.List;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextArea;

import org.gvsig.gui.beans.swing.JButton;

import org.gvsig.project.document.table.ExportStatisticsFile;

import com.iver.andami.PluginServices;

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

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

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class Statistics extends JPanel implements IWindow {

	private JScrollPane jScrollPane = null;

	private JTextArea txtStatistics = null;

	private JButton jButton = null;

	private JPanel jPanel = null;

private JButton jButtonExport;

//	private Hashtable<String, Number> valores = new Hashtable<String, Number>();

	//private TreeMap<String, Number> valores = new TreeMap<String, Number>();

	private List<MyObjectStatistics> valores = new ArrayList<MyObjectStatistics>();

//	private HashSet<String, Number> valores = new HashSet<String, Number>();

	/**

	 * This is the default constructor

	 */

	public Statistics() {

		super();

		initialize();

	}

	/**

	 * This method initializes this

	 *

	 * @return void

	 */

	private  void initialize() {

		this.setLayout(new BorderLayout());

		this.setSize(300,200);

		this.add(getJScrollPane(), java.awt.BorderLayout.CENTER);

		this.add(getJPanel(), java.awt.BorderLayout.SOUTH);

	}

	/**

	 * This method initializes jScrollPane

	 *

	 * @return javax.swing.JScrollPane

	 */

	private JScrollPane getJScrollPane() {

		if (jScrollPane == null) {

			jScrollPane = new JScrollPane();

			jScrollPane.setViewportView(getTxtStatistics());

		}

		return jScrollPane;

	}

	/**

	 * This method initializes jTextArea

	 *

	 * @return javax.swing.JTextArea

	 */

	private JTextArea getTxtStatistics() {

		if (txtStatistics == null) {

			txtStatistics = new JTextArea();

		}

		return txtStatistics;

	}

	/**

	 * This method initializes jButton

	 *

	 * @return JButton

	 */

	private JButton getJButton() {

		if (jButton == null) {

			jButton = new JButton();

			jButton.setPreferredSize(new java.awt.Dimension(100,18));

			jButton.setText(PluginServices.getText(this, "cerrar"));

			jButton.addActionListener(new ActionListener() {

                public void actionPerformed(ActionEvent e) {

                    PluginServices.getMDIManager().closeWindow(Statistics.this);

                }

            });

		}

		return jButton;

	}

	/**

	 * This method initializes jButton

	 *

	 * @return JButton

	 * 				- New JButton to Export the statistics

	 */

	private JButton getJButtonExport() {

		if (jButtonExport == null) {

			jButtonExport = new JButton();

			jButtonExport.setPreferredSize(new java.awt.Dimension(100,18));

			jButtonExport.setText(PluginServices.getText(this, "exportar"));

			jButtonExport.addActionListener(new ActionListener() {

				public void actionPerformed(ActionEvent e) {

					new ExportStatisticsFile(valores); // Class to export statistics to dbf or csv format

				}

            });//listener

		}

		return jButtonExport;

	}

	/**

	 * This method initializes jPanel

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getJPanel() {

		if (jPanel == null) {

			jPanel = new JPanel();

			FlowLayout layout = new FlowLayout();

			layout.setAlignment(FlowLayout.RIGHT);

			jPanel.setLayout(layout);

			jPanel.add(getJButtonExport(),null);

			jPanel.add(getJButton(), null);

		}

		return jPanel;

	}

    /**

     * @see com.iver.andami.ui.mdiManager.IWindow#getWindowInfo()

     */

    public WindowInfo getWindowInfo() {

        WindowInfo vi = new WindowInfo(WindowInfo.MODALDIALOG);

        vi.setTitle(PluginServices.getText(this, "estadisticas"));

        return vi;

    }

    /**

     * @param i

     * @param j

     * @param k

     * @param l

     * @param m

     * @param n

     * @param o

     * @param p

     */

    public void setStatistics(double media, double maximo, double minimo, double varianza, double desviacion, int numero, double ambito, double suma) {

        getTxtStatistics().setText(PluginServices.getText(this, "suma") + ": " + suma + "\n"+

                PluginServices.getText(this, "recuento") + ": " + numero + "\n"+

                PluginServices.getText(this, "media") + ": " + media + "\n"+

                PluginServices.getText(this, "maximo") + ": " + maximo + "\n"+

                PluginServices.getText(this, "minimo") + ": " + minimo + "\n"+

                PluginServices.getText(this, "ambito") + ": " + ambito + "\n"+

                PluginServices.getText(this, "varianza") + ": " + varianza + "\n"+

                PluginServices.getText(this, "desviacion_tipica") + ": " + desviacion);

        // Saving the statistics table values necessary in ExportStatisticsFile.java

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "suma"),suma));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "recuento"),numero));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "media"),media));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "maximo"),maximo));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "minimo"),minimo));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "ambito"),ambito));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "varianza"),varianza));

		valores.add(new MyObjectStatistics(PluginServices.getText(this, "desviacion_tipica"),desviacion));

    }

    /**

	 * Class to create an object with key and value.

	 *

	 * @author ?ngel Fraile Gri??n  e-mail: angel.fraile@iver.es

	 *

	 */

	public class MyObjectStatistics{

		private String key;

		private double value;

		public MyObjectStatistics(String key, double value) {

			this.key = key;

			this.value = value;

		}

		public String getKey() {

			return this.key;

		}

		public double getValue() {

			return this.value;

		}

	}

    }

/**

 *

 */

package org.gvsig.project.document.table.gui;

import java.awt.Dimension;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import javax.swing.ImageIcon;

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

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

import org.gvsig.project.document.table.FeatureTableDocument;

import jwizardcomponent.FinishAction;

import com.iver.andami.PluginServices;

import com.iver.andami.messages.NotificationManager;

import com.iver.cit.gvsig.TableOperations;

import com.iver.cit.gvsig.gui.simpleWizard.SimpleWizard;

import com.iver.cit.gvsig.project.documents.table.FieldSelectionModel;

public class JoinWizardController {

	private final TableOperations tableOperations;

	/**

	 * @param tableOperations

	 */

	public JoinWizardController(TableOperations tableOperations) {

		this.tableOperations = tableOperations;

	}

	public void runWizard(FeatureTableDocument[] pts) {

		// create wizard

		ImageIcon logo = PluginServices.getIconTheme().get("table-join");

		final SimpleWizard wizard = new SimpleWizard(logo);

		wizard.getWindowInfo().setTitle(PluginServices.getText(this, "Table_Join"));

		// create first step (source table)

		final TableWizardStep srcTableWzrd = new TableWizardStep(wizard.getWizardComponents(), "Title" );

		srcTableWzrd.getHeaderLbl().setText(PluginServices.getText(this,"Source_table_options"));

		srcTableWzrd.getTableNameLbl().setText(PluginServices.getText(this,"Source_table_"));

		srcTableWzrd.getFieldNameLbl().setText(PluginServices.getText(this,"Field_to_use_for_JOIN_"));

		srcTableWzrd.getFieldPrefixLbl().setText(PluginServices.getText(this,"Field_prefix_"));

		srcTableWzrd.getTableNameCmb().addItemListener(

				new ItemListener() {

					public void itemStateChanged(ItemEvent e) {

						if (e.getStateChange()==e.SELECTED) {

							FeatureTableDocument pt = (FeatureTableDocument) srcTableWzrd.getTableNameCmb().getSelectedItem();

							try {

								srcTableWzrd.setFieldModel(new FieldSelectionModel(

										pt.getStore(),

										PluginServices.getText(this, "seleccione_campo_enlace"),

										-1));

								srcTableWzrd.getFieldPrefixTxt().setText(tableOperations.sanitizeFieldName(pt.getName()));

							} catch (ReadException e1) {

								NotificationManager.addError(

										PluginServices.getText(this, "Error_getting_table_fields"),

										e1);

							}

						}

					}

				}

		);

		for (int i=0; i<pts.length; i++) {

			srcTableWzrd.getTableNameCmb().addItem(pts[i]);

		}

		// create second step (target table)

		final TableWizardStep targTableWzrd = new TableWizardStep(wizard.getWizardComponents(), "Title" );

		targTableWzrd.getHeaderLbl().setText(PluginServices.getText(this,"Target_table_options"));

		targTableWzrd.getTableNameLbl().setText(PluginServices.getText(this,"Target_table_"));

		targTableWzrd.getFieldNameLbl().setText(PluginServices.getText(this,"Field_to_use_for_JOIN_"));

		targTableWzrd.getFieldPrefixLbl().setText(PluginServices.getText(this,"Field_prefix_"));

		targTableWzrd.getTableNameCmb().addItemListener(

				new ItemListener() {

					public void itemStateChanged(ItemEvent e) {

						if (e.getStateChange()==e.SELECTED) {

							try {

								//tabla

								FeatureTableDocument sourcePt = (FeatureTableDocument) srcTableWzrd.getTableNameCmb().getSelectedItem();

								FeatureTableDocument targetPt = (FeatureTableDocument) targTableWzrd.getTableNameCmb().getSelectedItem();

								targTableWzrd.getFieldPrefixTxt().setText(tableOperations.sanitizeFieldName(targetPt.getName()));

								//?ndice del campo

								FeatureStore sds = sourcePt.getStore();

								String fieldName = (String) srcTableWzrd.getFieldNameCmb().getSelectedItem();

								int fieldIndex = sds.getFieldIndexByName(fieldName);

								if (fieldIndex!=-1) {

									int type = sds.getFieldType(fieldIndex);

									targTableWzrd.setFieldModel(new FieldSelectionModel(

											targetPt.getModelo().getRecordset(),

											PluginServices.getText(this, "seleccione_campo_enlace"),

											type));

								}

								else {

									NotificationManager.addError(PluginServices.getText(this, "Error_getting_table_fields")

											, new Exception());

								}

							} catch (ReadException e2) {

								NotificationManager.addError(PluginServices.getText(this, "Error_getting_table_fields"),

										e2);

							}

						}

					}

				}

		);

		for (int i=0; i<pts.length; i++) {

			targTableWzrd.getTableNameCmb().addItem(pts[i]);

		}

		// add steps and configure wizard

		wizard.getWizardComponents().addWizardPanel(srcTableWzrd);

		wizard.getWizardComponents().addWizardPanel(targTableWzrd);

		wizard.getWizardComponents().updateComponents();

		wizard.setSize(new Dimension(450, 230));

		wizard.getWizardComponents().setFinishAction(new FinishAction(wizard.getWizardComponents()) {

			public void performAction() {

				FeatureTableDocument sourceProjectTable = (FeatureTableDocument) srcTableWzrd.getTableNameCmb().getSelectedItem();

				String field1 = (String) srcTableWzrd.getFieldNameCmb().getSelectedItem();

				String prefix1 = srcTableWzrd.getFieldPrefixTxt().getText();

				if (sourceProjectTable==null || field1==null || prefix1 == null) {

					NotificationManager.showMessageError(

							PluginServices.getText(this, "Join_parameters_are_incomplete"), new InvalidParameterException());

					return;

				}

				FeatureTableDocument targetProjectTable = (FeatureTableDocument) targTableWzrd.getTableNameCmb().getSelectedItem();

				String field2 = (String) targTableWzrd.getFieldNameCmb().getSelectedItem();

				String prefix2 = targTableWzrd.getFieldPrefixTxt().getText();

				if (targetProjectTable==null || field2==null || prefix2 == null) {

					NotificationManager.showMessageError(

							PluginServices.getText(this, "Join_parameters_are_incomplete"), new InvalidParameterException());

					return;

				}

				tableOperations.execJoin(sourceProjectTable, field1, prefix1, targetProjectTable, field2, prefix2);

				PluginServices.getMDIManager().closeWindow(wizard);

			}

		}

		);

		// show the wizard

		PluginServices.getMDIManager().addWindow(wizard);

	}

	private class InvalidParameterException extends Exception {

	}

}

/**

 *

 */

package org.gvsig.project.document.table.gui;

import java.awt.Font;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import javax.swing.JLabel;

import javax.swing.JTextField;

import jwizardcomponent.JWizardComponents;

import jwizardcomponent.JWizardPanel;

import com.iver.andami.PluginServices;

import com.iver.andami.messages.NotificationManager;

import com.iver.utiles.swing.JComboBox;

import com.iver.utiles.swing.objectSelection.ObjectSelectionModel;

public class TableWizardStep extends JWizardPanel {

	private JLabel lbl_header = null;

	private static final long serialVersionUID = 1L;

	private JLabel tableNameLbl = null;

	private JComboBox tableNameCmb = null;

	private JLabel fieldNameLbl = null;

	private JComboBox fieldNameCmb = null;

	private JLabel fieldPrefixLbl = null;

	private JTextField fieldPrefixTxt = null;

	public TableWizardStep(JWizardComponents wizardComponents, String title) {

		super(wizardComponents, title);

		initialize();

	}

	public void setTableModel(ObjectSelectionModel model) {

		getTableNameCmb().removeAllItems();

		Object[] tableNames;

		try {

			tableNames = model.getObjects();

			for (int i=0; i<tableNames.length; i++) {

				getTableNameCmb().addItem(tableNames[i]);

			}

		} catch (Exception e) {

			NotificationManager.addError(PluginServices.getText(this, "Error_getting_table_fields"), e);

		}

	}

	public void setFieldModel(ObjectSelectionModel model) {

		getFieldNameCmb().removeAllItems();

		Object[] fieldNames;

		try {

			fieldNames = model.getObjects();

			for (int i=0; i<fieldNames.length; i++) {

				getFieldNameCmb().addItem(fieldNames[i]);

			}

		} catch (Exception e) {

			NotificationManager.addError(PluginServices.getText(this, "Error_getting_table_fields"), e);

		}

	}

	private void initialize() {

		this.setLayout(new GridBagLayout());

		GridBagConstraints constraints = new GridBagConstraints();

		constraints.gridx = 0;

		constraints.gridy = 0;

		constraints.gridwidth = 2;

		constraints.anchor = GridBagConstraints.NORTH;

		constraints.fill = GridBagConstraints.HORIZONTAL;

		constraints.weightx = 1.0;

		constraints.weighty = 0.0;

		constraints.insets = new Insets(4,10,8,4);

		this.add(getHeaderLbl(), constraints);

		constraints.gridx = 0;

		constraints.gridy = 1;

		constraints.gridwidth = 1;

		constraints.anchor = GridBagConstraints.NORTHWEST;

		constraints.fill = GridBagConstraints.NONE;

		constraints.weightx = 0.0;

		constraints.weighty = 0.0;

		constraints.insets = new Insets(4,10,4,6);

		this.add(getTableNameLbl(), constraints);

		constraints.gridx = 1;

		constraints.gridy = 1;

		constraints.gridwidth = 1;

		constraints.anchor = GridBagConstraints.NORTHWEST;

		constraints.fill = GridBagConstraints.HORIZONTAL;

		constraints.weightx = 0.5;

		constraints.weighty = 0.0;

		this.add(getTableNameCmb(), constraints);

		constraints.gridx = 0;

		constraints.gridy = 2;

		constraints.gridwidth = 1;

		constraints.anchor = GridBagConstraints.NORTHWEST;

		constraints.fill = GridBagConstraints.NONE;

		constraints.weightx = 0.0;

		constraints.weighty = 0.0;

		constraints.insets = new Insets(4,10,4,6);

		this.add(getFieldNameLbl(), constraints);

		constraints.gridx = 1;

		constraints.gridy = 2;

		constraints.gridwidth = 1;

		constraints.anchor = GridBagConstraints.NORTHWEST;

		constraints.fill = GridBagConstraints.HORIZONTAL;

		constraints.weightx = 0.5;

		constraints.weighty = 0.0;

		this.add(getFieldNameCmb(), constraints);

		constraints.gridx = 0;

		constraints.gridy = 3;

		constraints.gridwidth = 1;

		constraints.anchor = GridBagConstraints.NORTHWEST;

		constraints.fill = GridBagConstraints.NONE;

		constraints.weightx = 0.0;

		constraints.weighty = 0.0;

		constraints.insets = new Insets(4,10,4,6);

		this.add(getFieldPrefixLbl(), constraints);

		constraints.gridx = 1;

		constraints.gridy = 3;

		constraints.gridwidth = 1;

		constraints.anchor = GridBagConstraints.NORTHWEST;

		constraints.fill = GridBagConstraints.HORIZONTAL;

		constraints.weightx = 0.5;

		constraints.weighty = 0.0;

		this.add(getFieldPrefixTxt(), constraints);

	}

	public JLabel getHeaderLbl() {

		if (lbl_header==null) {

			lbl_header = new JLabel();

			Font font = lbl_header.getFont();

			lbl_header.setFont(font.deriveFont(Font.BOLD));

		}

		return lbl_header;

	}

	public JLabel getTableNameLbl() {

		if (tableNameLbl == null) {

			tableNameLbl = new JLabel();

		}

		return tableNameLbl;

	}

	public JComboBox getTableNameCmb() {

		if (tableNameCmb == null) {

			tableNameCmb = new JComboBox();

		}

		return tableNameCmb;

	}

	public JLabel getFieldNameLbl() {

		if (fieldNameLbl==null) {

			fieldNameLbl = new JLabel();

		}

		return fieldNameLbl;

	}

	public JComboBox getFieldNameCmb() {

		if (fieldNameCmb==null) {

			fieldNameCmb = new JComboBox();

		}

		return fieldNameCmb;

	}

	public JLabel getFieldPrefixLbl() {

		if (fieldPrefixLbl==null) {

			fieldPrefixLbl = new JLabel();

		}

		return fieldPrefixLbl;

	}

	public JTextField getFieldPrefixTxt() {

		if (fieldPrefixTxt==null) {

			fieldPrefixTxt = new JTextField();

		}

		return fieldPrefixTxt;

	}

}

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

*

* Copyright (C) 2005 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.

*/

package org.gvsig.project.document.table.gui;

import java.awt.GridBagConstraints;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JTextField;

import com.iver.andami.PluginServices;

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

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

/**

 * Class to create csv file at disk with the statistics group generated from a table with an Specifically separator

 *

 *  Basic separator "," -> csv basic file

 *  Excel separator ";" -> csv file to work in gvSIG documents

 *

 *  Optionally separator -> the user can enter a character or a string

 *

 *

 * @author ?ngel Fraile Gri??n  e-mail: angel.fraile@iver.es

 *

 */

public class CSVSeparatorOptionsPanel extends JPanel implements IWindow,ItemListener,ActionListener{

	private static final long serialVersionUID = 1L;

	public static final String commaChar = ",";

	public static final String semicolonChar = ";";

	private JButton buttonAccept;

	private JButton buttonCancel;

	private JRadioButton commaOption;

	private JRadioButton semicolonOption;

	private JRadioButton otherSymbol;

	private JTextField symbol;

	private String separator = null;

	public CSVSeparatorOptionsPanel() {

		setName("Separation options");

		// Initialize component

		inicialize();

	}

	/**

	 * Creating  a basic option separator panel

	 *

	 */

	private void inicialize() {

		GridBagConstraints gridBagConstraints = new GridBagConstraints();

		setLayout(new java.awt.GridBagLayout());

        gridBagConstraints = new java.awt.GridBagConstraints();

        gridBagConstraints.fill = java.awt.GridBagConstraints.HORIZONTAL;

        gridBagConstraints.insets = new java.awt.Insets(10, 10, 5, 5);

        add(getJCheckBoxPointComma(), gridBagConstraints);

        gridBagConstraints = new java.awt.GridBagConstraints();

        gridBagConstraints.gridwidth = 2;

        gridBagConstraints.fill = java.awt.GridBagConstraints.HORIZONTAL;

        gridBagConstraints.weightx = 1.0;

        gridBagConstraints.insets = new java.awt.Insets(10, 5, 5, 10);

        add(getJCheckBoxComma(), gridBagConstraints);

        gridBagConstraints = new java.awt.GridBagConstraints();

        gridBagConstraints.gridx = 0;

        gridBagConstraints.gridy = 1;

        gridBagConstraints.anchor = java.awt.GridBagConstraints.NORTH;

        gridBagConstraints.weighty = 1.0;

        gridBagConstraints.insets = new java.awt.Insets(5, 10, 5, 5);

        add(getJCheckBoxOtherSymbol(), gridBagConstraints);

        gridBagConstraints = new java.awt.GridBagConstraints();

        gridBagConstraints.gridx = 1;

        gridBagConstraints.gridy = 1;

        gridBagConstraints.gridwidth = 2;

        gridBagConstraints.fill = java.awt.GridBagConstraints.HORIZONTAL;

        gridBagConstraints.anchor = java.awt.GridBagConstraints.NORTH;

        gridBagConstraints.weightx = 1.0;

        gridBagConstraints.weighty = 1.0;

        gridBagConstraints.insets = new java.awt.Insets(5, 5, 5, 10);

        add(getTextFieldSymbol(), gridBagConstraints);

        gridBagConstraints = new java.awt.GridBagConstraints();

        gridBagConstraints.gridx = 1;

        gridBagConstraints.gridy = 2;

        gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;

        gridBagConstraints.weightx = 1.0;

        gridBagConstraints.insets = new java.awt.Insets(10, 10, 10, 10);

        add(getAcceptButton(), gridBagConstraints);

	    gridBagConstraints = new java.awt.GridBagConstraints();

	    gridBagConstraints.gridx = 2;

	    gridBagConstraints.gridy = 2;

	    add(getCancelButton(), gridBagConstraints);

	    ButtonGroup group = new ButtonGroup();

	    group.add(commaOption);

	    group.add(semicolonOption);

	    group.add(otherSymbol);

	}

	/**

	 * Selection option comma as the separator

	 *

	 *

	 * @return JRadioButton

	 */

	private JRadioButton getJCheckBoxComma() {

		if (commaOption == null) {

			commaOption = new JRadioButton(PluginServices.getText(this, "comma"),

					false);

			commaOption.setEnabled(true);

			commaOption.setToolTipText(PluginServices.getText(this, "sepatator_info_coma"));

		}

		return commaOption;

	}

	/**

	 * Selection option semicolon as the separator

	 *

	 * @return JRadioButton

	 */

	private JRadioButton getJCheckBoxPointComma() {

		if (semicolonOption == null) {

			semicolonOption = new JRadioButton(PluginServices.getText(this, "semicolon"),

					true);

			semicolonOption.setEnabled(true);

			semicolonOption.setToolTipText(PluginServices.getText(this, "sepatator_info_semicolon"));

		}

		return semicolonOption;

	}

	/**

	 * The user can enter the separator

	 *

	 * @return JRadioButton

	 */

	private JRadioButton getJCheckBoxOtherSymbol() {

		if (otherSymbol == null) {

			otherSymbol = new JRadioButton(PluginServices.getText(this, "otro_simbolo"),

					false);

			otherSymbol.setEnabled(true);

			otherSymbol.addItemListener(this);

			otherSymbol.setToolTipText(PluginServices.getText(this, "sepatator_info_other"));

		}

		return otherSymbol;

	}

	/**

	 * Return textfield where the user can enter a separator (char or string)

	 *

	 * @return TextField.

	 */

	private JTextField getTextFieldSymbol() {

		if (symbol == null) {

			symbol = new JTextField(null, 4);

			symbol.setHorizontalAlignment(JTextField.RIGHT);

			symbol.setEnabled(otherSymbol.isSelected());

			symbol.setToolTipText(PluginServices.getText(this, "sepatator_info"));

		}

		return symbol;

	}

	/**

	 * Method that generates the button to accept selected separator

 	 *

	 * @return JButton

	 */

	private JButton getAcceptButton() {

		if (buttonAccept == null) {

			buttonAccept = new JButton();

			buttonAccept.setText(PluginServices.getText(this, "Aceptar"));

			buttonAccept.addActionListener(this);

			buttonAccept.setToolTipText(PluginServices.getText(this, "Aceptar"));

		}

		return buttonAccept;

	}

	/**

	 * Method that generates the button to cancel csv file creation

	 *

	 * @return JButton

	 */

	private JButton getCancelButton() {

		if (buttonCancel == null) {

			buttonCancel = new JButton();

			buttonCancel.setText(PluginServices.getText(this, "Cancelar"));

			buttonCancel.addActionListener(this);

			buttonCancel.setToolTipText(PluginServices.getText(this, "Cancelar"));

		}

		return buttonCancel;

	}

	/**

	 * Window properties

	 *

	 * @see com.iver.andami.ui.mdiManager.IWindow#getWindowInfo()

	 */

	public WindowInfo getWindowInfo() {

		WindowInfo m_viewinfo = new WindowInfo(WindowInfo.MODALDIALOG | WindowInfo.RESIZABLE);

		m_viewinfo.setTitle(PluginServices.getText(this, "opciones_separacion"));

		m_viewinfo.setHeight(100);

		m_viewinfo.setWidth(300);

		return m_viewinfo;

	}

	/**

	 * Getting the window profile

	 */

//	public Object getWindowProfile() {

//		return WindowInfo.DIALOG_PROFILE;

//	}

	/**

	 * JRadioButton to enter the separator listener

	 */

	public void itemStateChanged(ItemEvent e) {

		symbol.setEnabled(otherSymbol.isSelected());

	}

	/**

	 * JButtons Accept and Cancel listener

	 */

	public void actionPerformed(ActionEvent event) {

		if (event.getSource() == this.buttonAccept) {

			if(commaOption.isSelected()) {

				separator = commaChar;

			}else if(semicolonOption.isSelected()) {

				separator = semicolonChar;

			}else if(otherSymbol.isSelected()) {

				separator = symbol.getText();

			}

			PluginServices.getMDIManager().closeWindow(this);

		}

		if (event.getSource() == this.buttonCancel) {

			separator = null;

			PluginServices.getMDIManager().closeWindow(this);

			return;

		}

	}

	/**

	 *

	 * @return separator

	 * 					- Chosen as the separator character or separator string

	 */

	public String getSeparator() {

		return separator;

	}

}

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

*

* Copyright (C) 2005 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.

*/

package org.gvsig.project.document.table;

import java.awt.Component;

import java.io.File;

import java.io.FileWriter;

import java.io.IOException;

import java.sql.Types;

import java.util.Hashtable;

import java.util.Iterator;

import java.util.List;

import javax.swing.JFileChooser;

import javax.swing.JOptionPane;

import javax.swing.filechooser.FileFilter;

import org.apache.log4j.Logger;

import org.gvsig.project.document.table.gui.CSVSeparatorOptionsPanel;

import org.gvsig.project.document.table.gui.Statistics.MyObjectStatistics;

import com.iver.andami.PluginServices;

/**

 * Class to create dbf and csv files at disk with the statistics group generated from a table.

 *

 * dbf -> Data Base File

 * csv -> Comma Separated Value

 *

 * @author ?ngel Fraile Gri??n  e-mail: angel.fraile@iver.es

 *

 */

public class ExportStatisticsFile {

	private String lastPath = null;

	private Hashtable<String, MyFileFilter> dbfExtensionsSupported; // Supported extensions.

	private Hashtable<String, MyFileFilter> csvExtensionsSupported;

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

	public ExportStatisticsFile(List<MyObjectStatistics> valores) {

        	JFileChooser jfc = new JFileChooser(lastPath);

			jfc.removeChoosableFileFilter(jfc.getAcceptAllFileFilter());

			// Adding required extensions (dbf, csv)

			dbfExtensionsSupported = new Hashtable<String, MyFileFilter>();

			csvExtensionsSupported = new Hashtable<String, MyFileFilter>();

			dbfExtensionsSupported.put("dbf", new MyFileFilter("dbf",PluginServices.getText(this, "Ficheros_dbf"), "dbf"));

			csvExtensionsSupported.put("csv", new MyFileFilter("csv",PluginServices.getText(this, "Ficheros_csv"), "csv"));

			Iterator<MyFileFilter> iter = csvExtensionsSupported.values().iterator();

			while (iter.hasNext()) {

				jfc.addChoosableFileFilter(iter.next());

			}

			iter = dbfExtensionsSupported.values().iterator();

			while (iter.hasNext()) {

				jfc.addChoosableFileFilter(iter.next());

			}

			// Opening a JFileCooser

			if (jfc.showSaveDialog((Component) PluginServices.getMainFrame()) == JFileChooser.APPROVE_OPTION) {

					File endFile = jfc.getSelectedFile();

						if (endFile.exists()){// File exists in the directory.

							int resp = JOptionPane.showConfirmDialog(

									(Component) PluginServices.getMainFrame(),

									PluginServices.getText(this,

											"fichero_ya_existe_seguro_desea_guardarlo")+"\n"+endFile.getAbsolutePath(),

									PluginServices.getText(this,"guardar"), JOptionPane.YES_NO_OPTION);// Informing the user

							if (resp != JOptionPane.YES_OPTION) {//cancel pressed.

								return;

							}

						}//end if exits.

						MyFileFilter filter = (MyFileFilter)jfc.getFileFilter();// dbf, csv

						endFile = filter.normalizeExtension(endFile);//"name" + "." + "dbf", "name" + "." + "csv"

						if(filter.getExtensionOfAFile(endFile).toLowerCase().compareTo("csv") == 0) { // csv file

							exportToCSVFile(valores,endFile); // export to csv format

						}

						else if(filter.getExtensionOfAFile(endFile).toLowerCase().compareTo("dbf") == 0) {// dbf file

							exportToDBFFile(valores,endFile); // export to dbf format

						}

			}//end if aprove option.

	}

	/**

	 * Creating  cvs format file with the statistics.

	 * Option to select the two columns separator.

	 *

	 * Example with semicolon: Name;data\n

	 * 					   Name2;data2\n

	 *

	 * @param valores

	 * 			- Pairs: String name (key) + Double value (

	 * @param endFile

	 * 			- File to write the information

	 */

	private void exportToCSVFile(List<MyObjectStatistics> valores, File endFile) {

		try {

			CSVSeparatorOptionsPanel csvSeparatorOptions = new CSVSeparatorOptionsPanel();

			PluginServices.getMDIManager().addWindow(csvSeparatorOptions);

			String separator = csvSeparatorOptions.getSeparator();

			if(separator != null) {

				FileWriter fileCSV = new FileWriter(endFile);

				fileCSV.write(PluginServices.getText(this, "Nombre") + separator + PluginServices.getText(this, "Valor")+ "\n");

				Iterator<MyObjectStatistics> iterador = valores.listIterator();

				while (iterador.hasNext()) {// Writing value,value\n

					 MyObjectStatistics data= (MyObjectStatistics) iterador.next();

					 fileCSV.write(data.getKey() + separator + (data.getValue())+ "\n");

				}

				fileCSV.close();

				JOptionPane.showMessageDialog(null, PluginServices.getText(this, "fichero_creado_en") + " " + endFile.getAbsolutePath(),

						PluginServices.getText(this, "fichero_creado_en_formato")+ " csv "+

						PluginServices.getText(this, "mediante_el_separador")+

						" \""+ separator + "\"", JOptionPane.INFORMATION_MESSAGE);// Informing the user

			}

			else

				return;

		} catch (IOException e) {// Informing the user

			logger.error("Error exportando a formato csv");

			JOptionPane.showMessageDialog(null, PluginServices.getText(this, "Error_exportando_las_estadisticas") + " " + endFile.getAbsolutePath(),

					PluginServices.getText(this, "Error"), JOptionPane.ERROR_MESSAGE);

		}

	}

	/**

	 * Creating dbf format file with the statistics

	 * @param valores

	 * 			- Pairs String name (key) + Double value

	 * @param endFile

	 * 			- File to write the information

	 */

	private void exportToDBFFile(List<MyObjectStatistics> valores, File endFile) {

		try {

			FileDriver driver = null;

			try {

				driver = (FileDriver) LayerFactory.getDM().getDriver("gdbms dbf driver");

			} catch (DriverLoadException e1) {

				logger.error("Error Creando el driver dbf");

			}

			try {

				if (!endFile.exists()){

					try {

						driver.createSource(endFile.getAbsolutePath(),new String[] {"0"},new int[] {Types.DOUBLE} );

					} catch (ReadDriverException e) {

						logger.error("Error en createSource");

					}

					endFile.createNewFile();

				}

				try {

					driver.open(endFile);

				} catch (OpenDriverException e) {

					logger.error("Error abriendo el fichero de destino");

				}

			} catch (IOException e) {

				try {

					throw new Exception("Error creando el fichero de destino", e);

				} catch (Exception e1) {

					logger.error("Error creando el fichero de destino");

				}

			}

			IWriter writer = ((IWriteable)driver).getWriter();

			ITableDefinition orgDef = new TableDefinition();

			try {

				// Preparing the total rows in the new dbf file, in this case two rows : Name  Value

				FieldDescription[] fields = new FieldDescription[2];

				fields[0] = new FieldDescription();

				fields[0].setFieldType(Types.VARCHAR);

				fields[0].setFieldName(PluginServices.getText(this, "Nombre"));

				fields[0].setFieldLength(50);

				fields[1] = new FieldDescription();

				fields[1].setFieldType(Types.DOUBLE);

				fields[1].setFieldName(PluginServices.getText(this, "Valor"));

				fields[1].setFieldLength(50);

				fields[1].setFieldDecimalCount(25);

				fields[1].setFieldLength(100);

				orgDef.setFieldsDesc(fields);

				writer.initialize(orgDef);

			} catch (InitializeWriterException e) {

				logger.error("Error en la inicializaci?n del writer");

			}

			try {

				writer.preProcess();

			} catch (StartWriterVisitorException e) {

				logger.error("Error en el preProcess del writer");

			}

			try {

				int index = 0;

				Value[] value = new Value[2];

				IFeature feat = null;

				Iterator<MyObjectStatistics> iterador = valores.listIterator();

				while (iterador.hasNext()) {

					MyObjectStatistics data= (MyObjectStatistics) iterador.next();

					value[0] = ValueFactory.createValue(data.getKey());

					value[1] = ValueFactory.createValue(data.getValue());

					feat = new DefaultFeature(null, value,"" + index++);

					write(writer, feat, index);

				}

			} catch (Exception e) {

				logger.error("Error en el write");

			}

			try {

				writer.postProcess();// Operation finished

				JOptionPane.showMessageDialog(null, PluginServices.getText(this, "fichero_creado_en") + " " + endFile.getAbsolutePath(),

						PluginServices.getText(this, "fichero_creado_en_formato")+ " dbf", JOptionPane.INFORMATION_MESSAGE);// Informing the user

			} catch (StopWriterVisitorException e) {

				logger.error("Error en el postProcess del writer");

			}

		} catch (Exception e) {// Informing the user

			logger.error("Error exportando a formato dbf");

			JOptionPane.showMessageDialog(null, PluginServices.getText(this, "Error_exportando_las_estadisticas") + " " + endFile.getAbsolutePath(),

					PluginServices.getText(this, "Error"), JOptionPane.ERROR_MESSAGE);

		}

	}

	/**

	 * Writer to create dbf file

	 *

	 * @param writer

	 * @param feature

	 * 				- fill with the corresponding rows

	 * @param index

	 * 				- fill file position

	 */

	private void write(IWriter writer, IFeature feature, int index) {

		DefaultRowEdited edRow = new DefaultRowEdited(feature,

				 DefaultRowEdited.STATUS_ADDED, index);

		 try {

			writer.process(edRow);

		} catch (VisitorException e) {

			logger.error("Error en la generaci?n del fichero dbf");

		}

	}

}

/**

 * @author ?ngel Fraile Gri??n  e-mail: angel.fraile@iver.es

 *

 * Class to work with the file extensions.

 */

class MyFileFilter extends FileFilter {

	private String[] extensiones = new String[1];

	private String description;

	private boolean dirs = true;

	private String info = null;

	public MyFileFilter(String[] ext, String desc) {

		extensiones = ext;

		description = desc;

	}

	public MyFileFilter(String[] ext, String desc, String info) {

		extensiones = ext;

		description = desc;

		this.info = info;

	}

	public MyFileFilter(String ext, String desc) {

		extensiones[0] = ext;

		description = desc;

	}

	public MyFileFilter(String ext, String desc, String info) {

		extensiones[0] = ext;

		description = desc;

		this.info = info;

	}

	public MyFileFilter(String ext, String desc, boolean dirs) {

		extensiones[0] = ext;

		description = desc;

		this.dirs = dirs;

	}

	public MyFileFilter(String ext, String desc, boolean dirs, String info) {

		extensiones[0] = ext;

		description = desc;

		this.dirs = dirs;

		this.info = info;

	}

	public boolean accept(File f) {

		if (f.isDirectory()) {

			if (dirs) {

				return true;

			} else {

				return false;

			}

		}

		for (int i = 0; i < extensiones.length; i++) {

			if (extensiones[i].equals("")) {

				continue;

			}

			if (getExtensionOfAFile(f).equalsIgnoreCase(extensiones[i])) {

				return true;

			}

		}

		return false;

	}

	public String getDescription() {

		return description;

	}

	public String[] getExtensions() {

		return extensiones;

	}

	public boolean isDirectory() {

		return dirs;

	}

	public String getExtensionOfAFile(File file) {

		String name;

		int dotPos;

		name = file.getName();

		dotPos = name.lastIndexOf(".");

		if (dotPos < 1) {

			return "";

		}

		return name.substring(dotPos + 1);

	}

	public File normalizeExtension(File file) {

		String ext = getExtensionOfAFile(file);

		if (ext.equals("") || !(this.accept(file))) {

			return new File(file.getAbsolutePath() + "." + extensiones[0]);

		}

		return file;

	}

	public String getInfo() {

		return this.info;

	}

	public void setInfo(String info) {

		this.info = info;

	}

}

import org.gvsig.project.document.table.gui.Statistics;

	public void execJoin(FeatureTableDocument sourceProjectTable, String field1, String prefix1,

			FeatureTableDocument targetProjectTable, String field2, String prefix2) {

		// get source table and source field

		FeatureStore sds=null;

		try {

			sds = sourceProjectTable.getStore();

		} catch (ReadException e) {

			e.printStackTrace();

		}

		String tableName1 = sds.getName();

		// get target table and target field

		try {

			sds = targetProjectTable.getStore();

		} catch (ReadException e) {

			e.printStackTrace();

		}

		String tableName2 = sds.getName();

		// compute the join

		String sql =

			"custom com_iver_cit_gvsig_arcjoin tables '" +

			tableName1 + "', '" + tableName2 + "' values(" +

			field1 + ", " + field2 + ");";

		PluginServices.getLogger().debug(sql);

		try {

			SelectableDataSource result = new SelectableDataSource(LayerFactory.getDataSourceFactory()

					.executeSQL(sql,

							DataSourceFactory.AUTOMATIC_OPENING));

			EditableAdapter auxea=new EditableAdapter();

			auxea.setOriginalDataSource(result);

			renameFields(auxea, sourceProjectTable, sanitizeFieldName(prefix1),

					targetProjectTable, sanitizeFieldName(prefix2));

			sourceProjectTable.replaceDataSource(auxea);

		} catch (ParseException e) {

			throw new RuntimeException(e);

		} catch (DriverLoadException e) {

			NotificationManager.addError(PluginServices.getText(this, "Error_loading_driver"),

					e);

		} catch (ReadException e) {

			NotificationManager.addError(PluginServices.getText(this, "Error_reading_from_the_driver"),

					e);

		} catch (SemanticException e) {

			throw new RuntimeException(e);

		} catch (EvaluationException e) {

			NotificationManager.addError(PluginServices.getText(this, "Error_evaluationg_expression"),

					e);

		}

	}

	/**

	 * Ensure that field name only has 'safe' characters

	 * (no spaces, special characters, etc).

	 */

	public String sanitizeFieldName(String fieldName) {

		return fieldName.replaceAll("\\W", "_"); // replace any non-word character by an underscore

	}

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

import org.gvsig.fmap.geom.Geometry;

					info += "\n" + PluginServices.getText(this,"type")+ ": "+getTypeVectorLayer() + "\n";

		} catch (DataException e) {

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

    private String getTypeVectorLayer() throws DataException {

    	if (layer instanceof FLyrVect){

        	String typeString="";

        	int typeShape=((FLyrVect)layer).getShapeType();

        	FeatureStore fs=((FLyrVect)layer).getFeatureStore();

			FeatureSet set=fs.getFeatureSet();

        	if (Geometry.TYPES.GEOMETRY==typeShape){

				if (set.getSize()>0){

					int type=((Geometry)set.getDefaultFeatureType().get(set.getDefaultFeatureType().getDefaultGeometryAttributeIndex())).getType();