Application: gvSIG desktop

/**

 *

 */

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.DataException;

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

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

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

							srcTableWzrd.setFieldModel(new FieldSelectionModel(

									pt.getStore(),

									PluginServices.getText(this, "seleccione_campo_enlace"),

									-1));

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

						}

					}

				}

		);

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

								FeatureAttributeDescriptor fad=sds.getDefaultFeatureType().getAttributeDescriptor(fieldName);

//								int fieldIndex = sds.getFieldIndexByName(fieldName);

//								if (fieldIndex!=-1) {

//									int type = sds.getFieldType(fieldIndex);

									targTableWzrd.setFieldModel(new FieldSelectionModel(

											targetPt.getStore(),

											PluginServices.getText(this, "seleccione_campo_enlace"),

											fad.getDataType()));

//								}

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

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

	}

}

import org.gvsig.app.daltransform.FeatureTransformManager;

	public static final String FEATURE_TRANSFORM_MANAGER_NAME = "appgsigLocator.manager.transform";

	public static final String FEATURE_TRANSFORM_MANAGER_DESCRIPTION = "Manager for the feature transforms";

	}

	/**

	 * Return a reference to FeatureTransformManager.

	 *

	 * @return a reference to FeatureTransformManager

	 * @throws LocatorException

	 *             if there is no access to the class or the class cannot be

	 *             instantiated

	 * @see Locator#get(String)

	 */

	public static FeatureTransformManager getFeatureTransformManager()

			throws LocatorException {

		return (FeatureTransformManager) getInstance().get(FEATURE_TRANSFORM_MANAGER_NAME);

	}

	/**

	 * Registers the Class implementing the FeatureTransformManager interface.

	 *

	 * @param clazz

	 *            implementing the PersistenceManager interface

	 */

	public static void registerFeatureTransformManager(Class clazz) {

		getInstance().register(FEATURE_TRANSFORM_MANAGER_NAME,

				FEATURE_TRANSFORM_MANAGER_DESCRIPTION, clazz);

	}

	public static void registerDefaultFeatureTransformManager(Class clazz) {

		getInstance().registerDefault(FEATURE_TRANSFORM_MANAGER_NAME,

				FEATURE_TRANSFORM_MANAGER_DESCRIPTION, clazz);

	}

import org.gvsig.app.daltransform.impl.DefaultFeatureTransformManager;

		AppGvSigLocator

				.registerDefaultFeatureTransformManager(DefaultFeatureTransformManager.class);

package com.iver.cit.gvsig;

import org.gvsig.app.join.dal.feature.JoinTransform;

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

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

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

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

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

import com.iver.andami.PluginServices;

import com.iver.andami.plugins.Extension;

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

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class RemoveTableUnion extends Extension{

	/**

	 * @see com.iver.andami.plugins.IExtension#initialize()

	 */

	public void initialize() {

		// TODO Auto-generated method stub

	}

	/**

	 * @see com.iver.andami.plugins.IExtension#execute(java.lang.String)

	 */

	public void execute(String actionCommand) {

		FeatureTableDocumentPanel t = (FeatureTableDocumentPanel) PluginServices.getMDIManager().getActiveWindow();

		FeatureTableDocument pt = t.getModel();

		FeatureStore fs = pt.getStore();

		this.removeJoinTransfor(fs);

		//		TODO

		//		if (fs instanceof JoinFeatureStore) {

		//			DataManager dm = DALLocator.getDataManager();

		//			DataStoreParameters originalParams = ((JoinFeatureStoreParameters) fs

		//					.getParameters()).getStorePrimary();

		//			FeatureStore original = null;

		//			try {

		//				original = (FeatureStore) dm.createStore(originalParams);

		//			} catch (InitializeException e) {

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

		//				return;

		//			}

		//

		//			pt.setStore(original);

		//			try {

		//				fs.dispose();

		//			} catch (CloseException e) {

		//				NotificationManager.addError(e);

		//			}

		//			t.setModel(pt);

		//

		//		}

		//		t.clearSelectedFields();

		t.getModel().setModified(true);

	}

	public void removeJoinTransfor(FeatureStore store) {

		FeatureStoreTransforms transforms = store.getTransforms();

		int size = transforms.size();

		if (size < 1) {

			return;

		}

		FeatureStoreTransform join = transforms.getTransform(size - 1);

		if (join instanceof JoinTransform) {

			transforms.remove(join);

		} else {

			return;

		}

	}

	public boolean hasJoinTransform(FeatureStore store) {

		FeatureStoreTransforms transforms = store.getTransforms();

		int size = transforms.size();

		if (size < 1) {

			return false;

		}

		return (transforms.getTransform(size - 1) instanceof JoinTransform);

	}

	/**

	 * @see com.iver.andami.plugins.IExtension#isEnabled()

	 */

	public boolean isEnabled() {

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

		if (v == null) {

			return false;

		}

		if (v.getClass() == FeatureTableDocumentPanel.class) {

			FeatureTableDocumentPanel t = (FeatureTableDocumentPanel) v;

			// FIXME !!!! Asi se hacia antes

			//			if (t.getModel().getOriginal() != null){

			//				return true;

			//			}

			FeatureTableDocument pt = t.getModel();

			FeatureStore fs = pt.getStore();

			return this.hasJoinTransform(fs);

//			TODO

//			if (fs instanceof JoinFeatureStore) {

//				return true;

//			}

		}

		return false;

	}

	/**

	 * @see com.iver.andami.plugins.IExtension#isVisible()

	 */

	public boolean isVisible() {

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

		if (v == null) {

			return false;

		}

		if (v instanceof FeatureTableDocumentPanel) {

			return true;

		} else {

			return false;

		}

	}

}

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

* 

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

* MA  02110-1301, USA.

* 

*/

/*

* AUTHORS (In addition to CIT):

* 2009 {Iver T.I.}   {Task}

*/

package com.iver.cit.gvsig;

import org.gvsig.AppGvSigLocator;

import org.gvsig.app.daltransform.FeatureTransformManager;

import org.gvsig.app.daltransform.gui.FeatureTransformSelectionAction;

import org.gvsig.app.daltransform.gui.FeatureTransformWizardModel;

import org.gvsig.app.join.daltransform.JoinTransformGui;

import com.iver.andami.PluginServices;

import com.iver.andami.plugins.Extension;

import com.iver.andami.ui.wizard.WizardAndami;

/**

 * @author <a href="mailto:jpiera@gvsig.org">Jorge Piera</a>

 */

public class FeatureTransformExtension extends Extension{

	public static final int WIDTH = 315;

	public static final int HEIGHT = 600;

	/* (non-Javadoc)

	 * @see com.iver.andami.plugins.IExtension#execute(java.lang.String)

	 */

	public void execute(String actionCommand) {

		WizardAndami wizard = new WizardAndami(

				PluginServices.getIconTheme().get("feature-transform"));

		wizard.setSize(HEIGHT, WIDTH);

		wizard.getWizardComponents().getFinishButton().setEnabled(false);

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

		FeatureTransformWizardModel featureTransformWizardModel = new FeatureTransformWizardModel(wizard);

		wizard.getWizardComponents().setFinishAction(new FeatureTransformSelectionAction(featureTransformWizardModel));

		PluginServices.getMDIManager().addWindow(wizard);

	}	

	/* (non-Javadoc)

	 * @see com.iver.andami.plugins.IExtension#initialize()

	 */

	public void initialize() {

		registerIcons();

		registerTranformations();

	}

	private void registerTranformations(){

		FeatureTransformManager transformManager = AppGvSigLocator.getFeatureTransformManager();

		transformManager.registerFeatureTransform("join", JoinTransformGui.class);

	}

	private void registerIcons(){

		PluginServices.getIconTheme().registerDefault(

				"feature-transform",

				this.getClass().getClassLoader().getResource("images/transform.png")

		);

	}

	/* (non-Javadoc)

	 * @see com.iver.andami.plugins.IExtension#isEnabled()

	 */

	public boolean isEnabled() {

		return true;

	}

	/* (non-Javadoc)

	 * @see com.iver.andami.plugins.IExtension#isVisible()

	 */

	public boolean isVisible() {		

		return true;

	}

}

import java.util.ArrayList;

import java.util.Iterator;

import org.gvsig.app.join.dal.feature.JoinTransform;

import org.gvsig.fmap.dal.DataManager;

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

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

				ProjectExtension pe = (ProjectExtension) PluginServices.getExtension(ProjectExtension.class);

				com.iver.cit.gvsig.project.Project project=pe.getProject();

				FeatureTableDocument[] pts = project.getDocumentsByType(FeatureTableDocumentFactory.registerName)

					.toArray(new FeatureTableDocument[0]);

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

					JoinWizardController wizardController = new JoinWizardController(

					this);

			wizardController.runWizard(pts);

		}else if ("LINK".equals(actionCommand)) {

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

						public void cancel(WizardEvent w) {

							PluginServices.getMDIManager().closeWindow(wiz);

						}

						public void finished(WizardEvent w) {

							PluginServices.getMDIManager().closeWindow(wiz);

							FeatureTableDocument sourceProjectTable = (FeatureTableDocument) sourceTable.getSelected();

							FeatureStore sds1 = sourceProjectTable.getStore();

							FeatureTableDocument targetProjectTable = (FeatureTableDocument) targetTable.getSelected();

							FeatureStore sds2 = targetProjectTable.getStore();

							String field1 = (String) firstTableField.getSelected();

							String field2 = (String) secondTableField.getSelected();

							sourceProjectTable.setLinkTable(sds2.getName(),field1,field2);

							((ProjectExtension)PluginServices.getExtension(ProjectExtension.class)).getProject().setLinkTable();

						}

						public void next(WizardEvent w) {

							WizardControl wiz = w.wizard;

							wiz.enableBack(true);

							wiz.enableNext(((ObjectSelectionStep) wiz.getCurrentStep()).getSelectedItem() != null);

							if (w.currentStep == 1) {

								FeatureTableDocument pt = (FeatureTableDocument) sourceTable.getSelected();

								try {

									firstTableField.setModel(new FieldSelectionModel(

											pt.getStore(),

											PluginServices.getText(this, "seleccione_campo_enlace"),

											DataTypes.STRING));

								} catch (SelectionException e) {

									NotificationManager.addError("Error obteniendo los campos de la tabla",

								}

							} else if (w.currentStep == 3) {

								try {

									//tabla

									FeatureTableDocument pt = (FeatureTableDocument) sourceTable.getSelected();

									//?ndice del campo

									FeatureStore fs = pt.getStore();

									String fieldName = (String) firstTableField.getSelected();

									int type = ((FeatureAttributeDescriptor)fs.getDefaultFeatureType().get(fieldName)).getDataType();

									secondTableField.setModel(new FieldSelectionModel(

											((FeatureTableDocument) targetTable

														.getSelected())

														.getStore(),

											PluginServices.getText(this, "seleccione_campo_enlace"),

											type));

								} catch (SelectionException e) {

									NotificationManager.addError("Error obteniendo los campos de la tabla",

								} catch (DataException e) {

									NotificationManager.addError("Error obteniendo los campos de la tabla",

											e);

								}

						public void back(WizardEvent w) {

							WizardControl wiz = w.wizard;

							wiz.enableBack(true);

							wiz.enableNext(((ObjectSelectionStep) wiz.getCurrentStep()).getSelectedItem() != null);

						}

					});

      	}

				.setFilter(DALLocator.getDataManager().createExpresion(

						expression));

						.createFeatureSelection();

*/

			return false;

//		FIXME

//		org.gvsig.fmap.data.feature.joinstore.Register.selfRegister();

			);

			);

	public void execJoin(FeatureTableDocument sourceProjectTable,

			String field1, String prefix1,

			FeatureTableDocument targetProjectTable, String field2,

			String prefix2) {

		FeatureStore fs1 = sourceProjectTable.getStore();

		FeatureStore fs2 = targetProjectTable.getStore();

		if (fs1 == fs2) {

			NotificationManager

					.addInfo("no_es_posible_aplicar_join_sobre_la_misma_fuente");

		}

		try {

			DataManager dm = DALLocator.getDataManager();

			JoinTransform jt = new JoinTransform();

			ArrayList<String> fields = new ArrayList<String>();

			Iterator iterator2 = fs2.getDefaultFeatureType().iterator();

			while (iterator2.hasNext()) {

				FeatureAttributeDescriptor descriptor = (FeatureAttributeDescriptor) iterator2

						.next();

				String name = descriptor.getName();

				if (!name.equals(field2)) {

					fields.add(name);

				}

			}

			jt.initialize(fs1, fs2, field1, field2, prefix1, prefix2, fields

					.toArray(new String[0]));

			fs1.getTransforms().add(jt);

			// featureStore=fs1;

		} catch (ReadException e) {

			NotificationManager.addError("Error leyendo del driver", e);

		} catch (DataException e) {

			NotificationManager.addError(e);

		}

	}

			<menu text="Tabla/join" icon="table-join" action-command="JOIN"/>

				<action-tool icon="table-join" action-command="JOIN" tooltip="join" position="1"/>

		<extension class-name="com.iver.cit.gvsig.RemoveTableUnion"

			description="Extensi?n encargada de quitar uniones de las tablas."

			active="true">

			<menu text="Tabla/quitar_uniones"/>

		</extension>

		<extension class-name="com.iver.cit.gvsig.FeatureTransformExtension"

			description=""

			active="true">

			<menu text="tools/feature_transform" />

		</extension>