Application: gvSIG desktop » gvSIG tools: Expression Field

#Thu Feb 24 22:56:34 CET 2022

buildNumber=2256

package org.gvsig.expressionfield;

import junit.framework.Test;

import junit.framework.TestSuite;

public class AllTests {

	public static Test suite() {

		TestSuite suite = new TestSuite(

				"Test for com.iver.cit.gvsig.expressionField");

		//$JUnit-BEGIN$

		//$JUnit-END$

		return suite;

	}

}

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    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 3

    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.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<assembly>

  <id>gvsig-plugin-package</id>

  <formats>

    <format>zip</format>

  </formats>

  <baseDirectory>${project.artifactId}</baseDirectory>

  <includeBaseDirectory>true</includeBaseDirectory>

  <files>

    <file>

      <source>target/${project.artifactId}-${project.version}.jar</source>

      <outputDirectory>lib</outputDirectory>

    </file>

    <file>

      <source>target/package.info</source>

    </file>

  </files>

  <fileSets>

    <fileSet>

      <directory>src/main/resources-plugin</directory>

      <outputDirectory>.</outputDirectory>

    </fileSet>

  </fileSets>

  <dependencySets>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

        <include>bsf:bsf</include>

        <include>org.python:jython</include>

        <include>com.fifesoft:rsyntaxtextarea</include>

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

/**

 * *****************************************************************************

 *

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

 * 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.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 *

 ******************************************************************************

 */

package org.gvsig.expressionfield;

import java.awt.Component;

import java.util.ArrayList;

import java.util.Iterator;

import javax.swing.JOptionPane;

import org.apache.bsf.BSFManager;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.app.project.documents.table.gui.FeatureTableDocumentPanel;

import org.gvsig.expressionfield.gui.FieldExpressionPage;

import org.gvsig.expressionfield.project.documents.table.IOperator;

import org.gvsig.expressionfield.project.documents.table.gui.EvalExpressionDialog;

import org.gvsig.expressionfield.project.documents.table.operators.Abs;

import org.gvsig.expressionfield.project.documents.table.operators.Acos;

import org.gvsig.expressionfield.project.documents.table.operators.After;

import org.gvsig.expressionfield.project.documents.table.operators.Area;

import org.gvsig.expressionfield.project.documents.table.operators.Asin;

import org.gvsig.expressionfield.project.documents.table.operators.Atan;

import org.gvsig.expressionfield.project.documents.table.operators.Before;

import org.gvsig.expressionfield.project.documents.table.operators.Ceil;

import org.gvsig.expressionfield.project.documents.table.operators.Cos;

import org.gvsig.expressionfield.project.documents.table.operators.DateToString;

import org.gvsig.expressionfield.project.documents.table.operators.Distinct;

import org.gvsig.expressionfield.project.documents.table.operators.Division;

import org.gvsig.expressionfield.project.documents.table.operators.E;

import org.gvsig.expressionfield.project.documents.table.operators.EndsWith;

import org.gvsig.expressionfield.project.documents.table.operators.Equal;

import org.gvsig.expressionfield.project.documents.table.operators.Equals;

import org.gvsig.expressionfield.project.documents.table.operators.Exp;

import org.gvsig.expressionfield.project.documents.table.operators.Floor;

import org.gvsig.expressionfield.project.documents.table.operators.Geometry;

import org.gvsig.expressionfield.project.documents.table.operators.GetTimeDate;

import org.gvsig.expressionfield.project.documents.table.operators.IndexOf;

import org.gvsig.expressionfield.project.documents.table.operators.IsNumber;

import org.gvsig.expressionfield.project.documents.table.operators.LastIndexOf;

import org.gvsig.expressionfield.project.documents.table.operators.Length;

import org.gvsig.expressionfield.project.documents.table.operators.LessEquals;

import org.gvsig.expressionfield.project.documents.table.operators.LessThan;

import org.gvsig.expressionfield.project.documents.table.operators.Log;

import org.gvsig.expressionfield.project.documents.table.operators.Max;

import org.gvsig.expressionfield.project.documents.table.operators.Min;

import org.gvsig.expressionfield.project.documents.table.operators.Minus;

import org.gvsig.expressionfield.project.documents.table.operators.MoreEquals;

import org.gvsig.expressionfield.project.documents.table.operators.MoreThan;

import org.gvsig.expressionfield.project.documents.table.operators.Perimeter;

import org.gvsig.expressionfield.project.documents.table.operators.Pi;

import org.gvsig.expressionfield.project.documents.table.operators.Plus;

import org.gvsig.expressionfield.project.documents.table.operators.PointX;

import org.gvsig.expressionfield.project.documents.table.operators.PointY;

import org.gvsig.expressionfield.project.documents.table.operators.Pow;

import org.gvsig.expressionfield.project.documents.table.operators.Random;

import org.gvsig.expressionfield.project.documents.table.operators.RecordIndex;

import org.gvsig.expressionfield.project.documents.table.operators.Replace;

import org.gvsig.expressionfield.project.documents.table.operators.Round;

import org.gvsig.expressionfield.project.documents.table.operators.SetTimeDate;

import org.gvsig.expressionfield.project.documents.table.operators.Sin;

import org.gvsig.expressionfield.project.documents.table.operators.Sqrt;

import org.gvsig.expressionfield.project.documents.table.operators.StartsWith;

import org.gvsig.expressionfield.project.documents.table.operators.SubString;

import org.gvsig.expressionfield.project.documents.table.operators.Tan;

import org.gvsig.expressionfield.project.documents.table.operators.Times;

import org.gvsig.expressionfield.project.documents.table.operators.ToDate;

import org.gvsig.expressionfield.project.documents.table.operators.ToDegrees;

import org.gvsig.expressionfield.project.documents.table.operators.ToLowerCase;

import org.gvsig.expressionfield.project.documents.table.operators.ToNumber;

import org.gvsig.expressionfield.project.documents.table.operators.ToRadians;

import org.gvsig.expressionfield.project.documents.table.operators.ToString;

import org.gvsig.expressionfield.project.documents.table.operators.ToUpperCase;

import org.gvsig.expressionfield.project.documents.table.operators.Trim;

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

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.extensionpoint.ExtensionPoint;

import org.gvsig.tools.extensionpoint.ExtensionPointManager;

import org.gvsig.utils.swing.threads.AbstractMonitorableTask;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * @author Vicente Caballero Navarro

 */

public class ExpressionFieldExtension extends Extension {

    private static Logger logger = LoggerFactory.getLogger(ExpressionFieldExtension.class);

    public static final String JYTHON = "jython";

    private static BSFManager interpreter = new BSFManager();

    private FeatureTableDocumentPanel table = null;

    private static ArrayList<IOperator> operators = new ArrayList<IOperator>();

    public void initialize() {

        registerIcons();

        registerOperations();

    }

    public void execute(String actionCommand) {

        if ( "table-expression-field".equalsIgnoreCase(actionCommand) ) {

            org.gvsig.andami.ui.mdiManager.IWindow window = PluginServices.getMDIManager().getActiveWindow();

            table = (FeatureTableDocumentPanel) window;

            if ( !table.getModel().getStore().isEditing() ) {

                int option = JOptionPane.showConfirmDialog((Component) PluginServices.getMainFrame(), PluginServices.getText(this, "is_not_in_editing_are_you_sure"));

                if ( option != JOptionPane.OK_OPTION ) {

                    return;

                }

            }

            if ( operators.isEmpty() ) {

                PluginServices.cancelableBackgroundExecution(new EvalOperatorsTask());

            } else {

                EvalExpressionDialog eed = new EvalExpressionDialog(table, interpreter, operators);

                PluginServices.getMDIManager().addWindow(eed);

            }

        }

    }

    public void postInitialize() {

    }

    public boolean isEnabled() {

        org.gvsig.andami.ui.mdiManager.IWindow window = PluginServices.getMDIManager().getActiveWindow();

        if ( window instanceof FeatureTableDocumentPanel ) {

            FeatureTableDocumentPanel table = (FeatureTableDocumentPanel) window;

            int columnSelected = 0;

            try {

                columnSelected = table.getTablePanel().getTable().getSelectedColumnCount();

            } catch (DataException e) {

                logger.error("Can't get selected column in table.", e);

            }

            if ( columnSelected > 0 && table.getModel().getStore().isEditing() ) {

                return true;

            }

        }

        return false;

    }

    public boolean isVisible() {

        org.gvsig.andami.ui.mdiManager.IWindow window = PluginServices.getMDIManager().getActiveWindow();

        if ( window instanceof FeatureTableDocumentPanel ) {

            return true;

        }

        return false;

    }

    private void registerOperations() {

        ExtensionPointManager extensionPointsManager =ToolsLocator.getExtensionPointManager();

        ExtensionPoint ep = extensionPointsManager.add("AplicationPreferences", "");

        ep.append("fieldExpression", "", new FieldExpressionPage());

        ExtensionPoint extensionPoints = ToolsLocator.getExtensionPointManager().add(

                "ColumnOperators", "");

        extensionPoints.append(Abs.class.toString(), "", Abs.class);

        extensionPoints.append(Acos.class.toString(), "", Acos.class);

        extensionPoints.append(After.class.toString(), "", After.class);

        extensionPoints.append(Area.class.toString(), "", Area.class);

        extensionPoints.append(Asin.class.toString(), "", Asin.class);

        extensionPoints.append(Atan.class.toString(), "", Atan.class);

        extensionPoints.append(Acos.class.toString(), "", Acos.class);

        extensionPoints.append(Before.class.toString(), "", Before.class);

        extensionPoints.append(Ceil.class.toString(), "", Ceil.class);

        extensionPoints.append(Cos.class.toString(), "", Cos.class);

        extensionPoints.append(DateToString.class.toString(), "", DateToString.class);

        extensionPoints.append(Distinct.class.toString(), "", Distinct.class);

        extensionPoints.append(Division.class.toString(), "", Division.class);

        extensionPoints.append(E.class.toString(), "", E.class);

        extensionPoints.append(EndsWith.class.toString(), "", EndsWith.class);

        extensionPoints.append(Equal.class.toString(), "", Equal.class);

        extensionPoints.append(Equals.class.toString(), "", Equals.class);

        extensionPoints.append(Exp.class.toString(), "", Exp.class);

        extensionPoints.append(Floor.class.toString(), "", Floor.class);

        extensionPoints.append(Geometry.class.toString(), "", Geometry.class);

        extensionPoints.append(GetTimeDate.class.toString(), "", GetTimeDate.class);

        extensionPoints.append(IndexOf.class.toString(), "", IndexOf.class);

        extensionPoints.append(IsNumber.class.toString(), "", IsNumber.class);

        extensionPoints.append(LastIndexOf.class.toString(), "", LastIndexOf.class);

        extensionPoints.append(Length.class.toString(), "", Length.class);

        extensionPoints.append(LessEquals.class.toString(), "", LessEquals.class);

        extensionPoints.append(LessThan.class.toString(), "", LessThan.class);

        extensionPoints.append(Log.class.toString(), "", Log.class);

        extensionPoints.append(Max.class.toString(), "", Max.class);

        extensionPoints.append(Min.class.toString(), "", Min.class);

        extensionPoints.append(Minus.class.toString(), "", Minus.class);

        extensionPoints.append(MoreEquals.class.toString(), "", MoreEquals.class);

        extensionPoints.append(MoreThan.class.toString(), "", MoreThan.class);

        extensionPoints.append(Perimeter.class.toString(), "", Perimeter.class);

        extensionPoints.append(Pi.class.toString(), "", Pi.class);

        extensionPoints.append(Plus.class.toString(), "", Plus.class);

        extensionPoints.append(PointX.class.toString(), "", PointX.class);

        extensionPoints.append(PointY.class.toString(), "", PointY.class);

        extensionPoints.append(Pow.class.toString(), "", Pow.class);

        extensionPoints.append(Random.class.toString(), "", Random.class);

        // Added November 2013

        extensionPoints.append(RecordIndex.class.toString(), "", RecordIndex.class);

        extensionPoints.append(Replace.class.toString(), "", Replace.class);

        extensionPoints.append(Round.class.toString(), "", Round.class);

        extensionPoints.append(SetTimeDate.class.toString(), "", SetTimeDate.class);

        extensionPoints.append(Sin.class.toString(), "", Sin.class);

        extensionPoints.append(Sqrt.class.toString(), "", Sqrt.class);

        extensionPoints.append(StartsWith.class.toString(), "", StartsWith.class);

        extensionPoints.append(SubString.class.toString(), "", SubString.class);

        extensionPoints.append(Tan.class.toString(), "", Tan.class);

        extensionPoints.append(Times.class.toString(), "", Times.class);

        extensionPoints.append(ToDate.class.toString(), "", ToDate.class);

        extensionPoints.append(ToDegrees.class.toString(), "", ToDegrees.class);

        extensionPoints.append(ToLowerCase.class.toString(), "", ToLowerCase.class);

        extensionPoints.append(ToNumber.class.toString(), "", ToNumber.class);

        extensionPoints.append(ToRadians.class.toString(), "", ToRadians.class);

        extensionPoints.append(ToString.class.toString(), "", ToString.class);

        extensionPoints.append(ToUpperCase.class.toString(), "", ToUpperCase.class);

        extensionPoints.append(Trim.class.toString(), "", Trim.class);

    }

    private void registerIcons() {

        IconThemeHelper.registerIcon("action", "table-expression-field", this);

        IconThemeHelper.registerIcon("preferences", "expression-field-preferences", this);

    }

    private class EvalOperatorsTask extends AbstractMonitorableTask {

        private ExtensionPoint extensionPoint;

        public EvalOperatorsTask() {

            setInitialStep(0);

            setDeterminatedProcess(true);

            setStatusMessage(PluginServices.getText(this, "charging_operators") + "...");

            this.extensionPoint = ToolsLocator.getExtensionPointManager().get(

                    "ColumnOperators");

            setFinalStep(extensionPoint.getCount() + 1);

        }

        public void run() throws Exception {

            NotificationManager.addInfo(PluginServices.getText(this, "charging_operators"));

            long t1 = System.currentTimeMillis();

            Iterator iterator = extensionPoint.iterator();

            while ( iterator.hasNext() ) {

                try {

                    if ( isCanceled() ) {

                        return;

                    }

                    org.gvsig.tools.extensionpoint.ExtensionPoint.Extension obj = (org.gvsig.tools.extensionpoint.ExtensionPoint.Extension) iterator.next();

                    IOperator operator = (IOperator) extensionPoint.create(obj.getName());

                    operator.eval(interpreter);

                    operators.add(operator);

                    reportStep();

                    setNote(operator.getClass().getName());

                } catch (InstantiationException e) {

                    e.printStackTrace();

                } catch (IllegalAccessException e) {

                    e.printStackTrace();

                } catch (ClassCastException e) {

                    e.printStackTrace();

                }

            }

            long t2 = System.currentTimeMillis();

            System.out.println("Tiempo en evaluar y crear del extension point = " + (t2 - t1));

            long t3 = System.currentTimeMillis();

            System.out.println("Tiempo en a?adir los operadores correctos = " + (t3 - t2));

            reportStep();

        }

        public void finished() {

            if ( isCanceled() ) {

                return;

            }

            NotificationManager.addInfo(PluginServices.getText(this, "charged_operators"));

            EvalExpressionDialog eed = new EvalExpressionDialog(table, interpreter, operators);

            PluginServices.getMDIManager().addWindow(eed);

        }

    }

}

/*******************************************************************************

 *

 *   gvSIG. Desktop Geographic Information System.

 *  

 *   Copyright (C) 2007-2013 gvSIG Association.

 *  

 *   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 3

 *   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.

 *  

 *   For any additional information, do not hesitate to contact us

 *   at info AT gvsig.com, or visit our website www.gvsig.com.

 *   

 *******************************************************************************/

package org.gvsig.expressionfield.gui;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import java.util.prefs.Preferences;

import javax.swing.ImageIcon;

import javax.swing.JCheckBox;

import javax.swing.JPanel;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.preferences.AbstractPreferencePage;

import org.gvsig.andami.preferences.StoreException;

/**

 * @author Vicente Caballero Navarro

 */

public class FieldExpressionPage extends AbstractPreferencePage {

	private static Preferences prefs = Preferences.userRoot().node( "fieldExpressionOptions" );

	private JTextArea jTextArea = null;

	private JTextField txtLimit;

	private JCheckBox ckLimit=null;

	private ImageIcon icon;

	public FieldExpressionPage() {

		super();

		icon = IconThemeHelper.getImageIcon("expression-field-preferences");

		addComponent(getJTextArea());

		addComponent(PluginServices.getText(this, "limit_rows_in_memory") + ":",

			txtLimit = new JTextField("", 15));

		addComponent(ckLimit = new JCheckBox(PluginServices.getText(this, "without_limit")));

		ckLimit.addMouseListener(new MouseListener() {

			public void mouseClicked(MouseEvent e) {

				if (ckLimit.isSelected()) {

					txtLimit.setText(PluginServices.getText(this, "without_limit"));

				}else {

					if (txtLimit.getText().equals(PluginServices.getText(this, "without_limit")))

					txtLimit.setText("500000");

				}

			}

			public void mouseEntered(MouseEvent e) {

			}

			public void mouseExited(MouseEvent e) {

			}

			public void mousePressed(MouseEvent e) {

			}

			public void mouseReleased(MouseEvent e) {

			}

		});

	}

	public void initializeValues() {

		int limit = prefs.getInt("limit_rows_in_memory",-1);

		if (limit==-1) {

			ckLimit.setSelected(true);

			txtLimit.setText(PluginServices.getText(this,"without_limit"));

		}else {

			ckLimit.setSelected(false);

			txtLimit.setText(String.valueOf(limit));

		}

	}

	public String getID() {

		return this.getClass().getName();

	}

	public String getTitle() {

		return PluginServices.getText(this, "limit_rows_in_memory");

	}

	public JPanel getPanel() {

		return this;

	}

	public void storeValues() throws StoreException {

		int limit;

		try{

			if (ckLimit.isSelected()) {

				limit=-1;

			}else {

//			if (txtLimit.getText().equals(PluginServices.getText(this,"without_limit"))) {

//				limit=-1;

//			}else {

				limit=Integer.parseInt(txtLimit.getText());

			}

		}catch (Exception e) {

			throw new StoreException(PluginServices.getText(this,"limit_rows_in_memory")+PluginServices.getText(this,"error"));

		}

		prefs.putInt("limit_rows_in_memory", limit);

	}

	public void initializeDefaults() {

		int limit=prefs.getInt("limit_rows_in_memory",-1);

		if (limit==-1) {

			ckLimit.setSelected(true);

			txtLimit.setText(PluginServices.getText(this,"without_limit"));

		}else {

			ckLimit.setSelected(false);

			txtLimit.setText(String.valueOf(limit));

		}

	}

	public ImageIcon getIcon() {

		return icon;

	}

	/**

	 * This method initializes jTextArea

	 *

	 * @return javax.swing.JTextArea

	 */

	private JTextArea getJTextArea() {

		if (jTextArea == null) {

			jTextArea = new JTextArea();

			jTextArea.setBounds(new java.awt.Rectangle(13,7,285,57));

			jTextArea.setForeground(java.awt.Color.black);

			jTextArea.setBackground(java.awt.SystemColor.control);

			jTextArea.setRows(3);

			jTextArea.setWrapStyleWord(true);

			jTextArea.setLineWrap(true);

			jTextArea.setEditable(false);

			jTextArea.setText(PluginServices.getText(this,"specifies_the_limit_rows_in_memory_when_the_program_eval_the_expression"));

		}

		return jTextArea;

	}

	public boolean isValueChanged() {

		return super.hasChanged();

	}

	public void setChangesApplied() {

		setChanged(false);

	}

}

/*******************************************************************************

 *

 *   gvSIG. Desktop Geographic Information System.

 *  

 *   Copyright (C) 2007-2013 gvSIG Association.

 *  

 *   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 3

 *   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.

 *  

 *   For any additional information, do not hesitate to contact us

 *   at info AT gvsig.com, or visit our website www.gvsig.com.

 *   

 *******************************************************************************/

package org.gvsig.expressionfield.project.documents.table;

import org.apache.bsf.BSFException;

import org.apache.bsf.BSFManager;

/**

 * @author Vicente Caballero Navarro

 */

public interface IOperator {

	int NUMBER = 0;

	int STRING = 1;

	int DATE = 2;

	public String addText(String s);

	public String toString();

	public void eval(BSFManager interpreter) throws BSFException ;

	public boolean isEnable();

	public void setType(int fieldType);

	public String getTooltip();

}

/*******************************************************************************

 *

 *   gvSIG. Desktop Geographic Information System.

 *  

 *   Copyright (C) 2007-2013 gvSIG Association.

 *  

 *   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 3

 *   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.

 *  

 *   For any additional information, do not hesitate to contact us

 *   at info AT gvsig.com, or visit our website www.gvsig.com.

 *   

 *******************************************************************************/

package org.gvsig.expressionfield.project.documents.table.gui;

import java.util.Date;

import org.apache.bsf.BSFException;

import org.gvsig.app.project.documents.table.gui.FeatureTableDocumentPanel;

import org.gvsig.fmap.dal.DataTypes;

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

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

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

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

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

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

/**

 * @author Vicente Caballero Navarro

 */

public class EvalExpression {

	private FeatureType featureType;

	private FeatureAttributeDescriptor selectedDescriptor;

	public EvalExpression() {

	}

	public void setTable(FeatureTableDocumentPanel table) {

		try {

			selectedDescriptor = table.getTablePanel().getTable().getSelectedColumnsAttributeDescriptor()[0];

		    featureType = table.getModel().getStore().getDefaultFeatureType();

		} catch (DataException e) {

			e.printStackTrace();

		}

	}

	public void setValue(FeatureSet featureSet,Feature feature,Object obj) {

		Object objBoolean=obj;

		EditableFeature eFeature=feature.getEditable();

		int type=((FeatureAttributeDescriptor)featureSet.getDefaultFeatureType().get(selectedDescriptor.getName())).getType();

		if (type==DataTypes.BOOLEAN){

			Integer integer=((Integer)obj).intValue();

			if (integer==0){

				objBoolean=new Boolean(false);

			}else{

				objBoolean=new Boolean(true);

			}

		}

		eFeature.set(selectedDescriptor.getName(), objBoolean);

		try {

			featureSet.update(eFeature);

		} catch (DataException e) {

			e.printStackTrace();

		}

	}

	 public void isCorrectValue(Object obj) throws BSFException {

	        if (obj instanceof Number || obj instanceof Date || obj instanceof Boolean || obj instanceof String || obj == null ) {

	        }else{

	        	throw new BSFException("incorrect");

	        }

	 }

	public FeatureAttributeDescriptor getFieldDescriptorSelected() {

		return selectedDescriptor;

	}

	public FeatureType getFieldDescriptors() {

		return featureType;

	}

}

/**

 * *****************************************************************************

 *

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

 * 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.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 *

 ******************************************************************************

 */

package org.gvsig.expressionfield.project.documents.table.gui;

import java.awt.BorderLayout;

import java.awt.Component;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.GridLayout;

import java.awt.Insets;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import java.io.File;

import java.io.FileReader;

import java.io.IOException;

import java.io.UnsupportedEncodingException;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.prefs.Preferences;

import javax.swing.BoxLayout;

import javax.swing.ButtonGroup;

import javax.swing.JFileChooser;

import javax.swing.JLabel;

import javax.swing.JList;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JScrollPane;

import javax.swing.JTabbedPane;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import javax.swing.UIManager;

import javax.swing.event.CaretEvent;

import javax.swing.event.CaretListener;

import org.apache.bsf.BSFException;

import org.apache.bsf.BSFManager;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.andami.ui.mdiManager.IWindow;

import org.gvsig.andami.ui.mdiManager.WindowInfo;

import org.gvsig.app.project.documents.table.gui.FeatureTableDocumentPanel;

import org.gvsig.expressionfield.ExpressionFieldExtension;

import org.gvsig.expressionfield.project.documents.table.FeatureIndex;

import org.gvsig.expressionfield.project.documents.table.GraphicOperator;

import org.gvsig.expressionfield.project.documents.table.IOperator;

import org.gvsig.expressionfield.project.documents.table.operators.Field;

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

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

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

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

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

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

import org.gvsig.fmap.mapcontext.layers.vectorial.FLyrVect;

import org.gvsig.gui.beans.AcceptCancelPanel;

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

import org.gvsig.tools.dispose.DisposableIterator;

import org.gvsig.tools.dispose.DisposeUtils;

import org.gvsig.utils.GenericFileFilter;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import bsh.EvalError;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.app.ApplicationLocator;

import org.gvsig.app.ApplicationManager;

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.i18n.I18nManager;

public class EvalExpressionDialog extends JPanel implements IWindow {

    private static Logger logger = LoggerFactory.getLogger(EvalExpressionDialog.class);

    private static Preferences prefs = Preferences.userRoot().node("fieldExpressionOptions");

    private JPanel pNorth = null;

    private JPanel pCentral = null;

    private JScrollPane jScrollPane = null;

    private JTextArea txtExp = null;

    private AcceptCancelPanel acceptCancel;

    private FeatureTableDocumentPanel table;

    private FLyrVect lv;

    private JPanel pNorthEast = null;

    private JPanel pNorthCenter = null;

    private JPanel pNorthWest = null;

    private JScrollPane jScrollPane1 = null;

    private JList listFields = null;

    private JRadioButton rbNumber = null;

    private JRadioButton rbString = null;

    private JRadioButton rbDate = null;

    private JScrollPane jScrollPane2 = null;

    private JList listCommand = null;

    private BSFManager interpreter = null; // Construct an interpreter

    private Feature feature;

    private FeatureStore featureStore = null;

    private EvalExpression evalExpression = null;

    /*

     * Keeps index of row in feature set currently used.

     */

    private FeatureIndex fIndex = new FeatureIndex();

    private JPanel pMessage;

    private FeatureContainer featureContainer;

    private static ArrayList<IOperator> operators = new ArrayList<IOperator>();

    public EvalExpressionDialog(FeatureTableDocumentPanel table, BSFManager interpreter, ArrayList<IOperator> operators) {

        super();

        this.operators = operators;

        this.interpreter = interpreter;

        this.table = table;

        initialize();

    }

    /**

     * This method initializes this

     */

    private void initialize() {

        try {

            evalExpressions();

        } catch (BSFException e) {

            NotificationManager.addError(e);

        }

        evalExpression = new EvalExpression();

        evalExpression.setTable(table);

        /*

         *  Keeps index of row in feature set currently used

         */

        try {

            interpreter.declareBean("featureIndex", fIndex, FeatureIndex.class);

        } catch (BSFException e) {

            logger.error("While declaring featureIndex (Long).", e);

        }

        lv = (FLyrVect) table.getModel().getAssociatedLayer();

        ButtonGroup bg = new ButtonGroup();

        bg.add(getRbNumber());

        bg.add(getRbString());

        bg.add(getRbDate());

        this.setLayout(new GridBagLayout());

        this.setSize(549, 480);

        GridBagConstraints constr = new GridBagConstraints();

        constr.gridwidth = GridBagConstraints.REMAINDER;

        constr.gridheight = 1;

        constr.fill = GridBagConstraints.BOTH;

        constr.ipadx = 5;

        constr.ipady = 5;

        constr.weightx = 1;

        constr.weighty = 0.3;

        this.add(getPMessage(), constr);

        constr.gridheight = 5;

        constr.weighty = 1;

        this.add(getTabPrincipal(), constr);

        GridBagConstraints constr2 = new GridBagConstraints();

        constr2.gridwidth = GridBagConstraints.REMAINDER;

        constr2.gridheight = 1;

        constr2.fill = GridBagConstraints.HORIZONTAL;

        constr2.anchor = GridBagConstraints.LAST_LINE_END;

        constr2.weightx = 1;

        constr2.weighty = 0;

        this.add(getAcceptCancel(), constr2);

    }

    /**

     * This method initializes pCentral

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPNorth() {

        if ( pNorth == null ) {

            pNorth = new JPanel();

            pNorth.setLayout(new GridBagLayout());

            GridBagConstraints contr = new GridBagConstraints();

            contr.ipadx = 5;

            contr.ipady = 5;

            contr.fill = GridBagConstraints.BOTH;

            contr.weightx = 1;

            contr.weighty = 1;

            pNorth.add(getPNorthWest(), contr);

            contr.fill = GridBagConstraints.VERTICAL;

            contr.weightx = 0;

            contr.weighty = 1;

            pNorth.add(getPNorthCenter(), contr);

            contr.fill = GridBagConstraints.BOTH;

            contr.weightx = 0.5;

            contr.weighty = 1;

            pNorth.add(getPNorthEast(), contr);

        }

        return pNorth;

    }

    /**

     * This method initializes pNorth

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPCentral() {

        if ( pCentral == null ) {

            StringBuilder tit = new StringBuilder();

            tit.append(PluginServices.getText(this, "expression"));

            tit.append(" ");

            tit.append(PluginServices.getText(this, "column"));

            tit.append(" : ");

            tit.append(evalExpression.getFieldDescriptorSelected().getName());

            pCentral = new JPanel();

            pCentral.setLayout(new GridBagLayout());

            pCentral.setBorder(javax.swing.BorderFactory.createTitledBorder(

                    null, tit.toString(),

                    javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

                    javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

            GridBagConstraints contr = new GridBagConstraints();

            contr.gridwidth = GridBagConstraints.REMAINDER;

            contr.gridheight = 1;

            contr.fill = GridBagConstraints.BOTH;

            contr.ipadx = 5;

            contr.ipady = 5;

            contr.weightx = 1;

            contr.weighty = 1;

            pCentral.add(getJScrollPane(), contr);

            GridBagConstraints contr1 = new GridBagConstraints();

            contr1.gridwidth = 1;

            contr1.gridheight = 1;

            contr1.fill = GridBagConstraints.NONE;

            contr1.ipadx = 5;

            contr1.ipady = 5;

            contr1.anchor = GridBagConstraints.CENTER;

            pCentral.add(getBClear(), contr1);

        }

        return pCentral;

    }

    /**

     * This method initializes pSouth

     *

     * @return javax.swing.JPanel

     */

    private AcceptCancelPanel getAcceptCancel() {

        if ( this.acceptCancel == null ) {

            this.acceptCancel = new AcceptCancelPanel(

                    new java.awt.event.ActionListener() {

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

                            boolean isAccepted = true;

                            Preferences prefs = Preferences.userRoot().node(

                                    "fieldExpressionOptions");

                            int limit;

                            limit = prefs.getInt("limit_rows_in_memory", -1);

                            if ( limit != -1 ) {

                                int option = JOptionPane

                                .showConfirmDialog(

                                        (Component) PluginServices

                                        .getMainFrame(),

                                        PluginServices

                                        .getText(

                                                this,

                                                "it_has_established_a_limit_of_rows_will_lose_the_possibility_to_undo_wants_to_continue"));

                                if ( option != JOptionPane.OK_OPTION ) {

                                    return;

                                }

                            }

                            try {

                                long t1 = System.currentTimeMillis();

                                isAccepted = evalExpression();

                                long t2 = System.currentTimeMillis();

                                logger.info("Tiempo evaluar expresiones = " + (t2 - t1));

                            } catch (BSFException e1) {

                                NotificationManager.addError(e1);

                            }

                            if ( isAccepted ) {

                                PluginServices.getMDIManager().closeWindow(

                                        EvalExpressionDialog.this);

                            }

                        }

                    }, new java.awt.event.ActionListener() {

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

                            PluginServices.getMDIManager().closeWindow(

                                    EvalExpressionDialog.this);

                        }

                    });

            acceptCancel.setOkButtonEnabled(false);

        }

        return this.acceptCancel;

    }

    private String replaceFields(String expression) {

        String s = expression;

        JList list = getListFields();

        ListOperatorsModel model = (ListOperatorsModel) list.getModel();

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

            Field f = (Field) model.getElementAt(i);

            s = StringUtils.replace(s, f.toString(), "field(\"" + f.getName() + "\")");

        }

        return s;

    }

    /**

     * Evaluate the expression.

     *

     * @throws BSFException

     */

    private boolean evalExpression() throws BSFException {

        final I18nManager i18nManager = ToolsLocator.getI18nManager();

        final ApplicationManager application = ApplicationLocator.getManager();

        String expression = getTxtExp().getText();

        byte[] expressionBytes;

        String encoding = System.getProperty("file.encoding");

        try {

            expressionBytes = expression.getBytes(encoding);

            expression = new String(expressionBytes, "ISO-8859-1");

        } catch (UnsupportedEncodingException e) {

            logger.warn("Can't apply enconding ("+encoding+").",e);

        }

        String advancedCode = advancedPanel.getCode();

        if( advancedCode != null ) {

            try {

                interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, advancedCode);

            } catch (BSFException ex) {

                logger.warn("Can't execute script from advanced tab:\n" + advancedCode + "\n", ex);

                application.messageDialog(

                    i18nManager.getTranslation("_Se_han_producido_errores_ejecutando_el_codigo_de_la_pesta?a_avanzado") + "\n\n" + ex.getMessage(),

                    i18nManager.getTranslation("_Atencion"),

                    JOptionPane.WARNING_MESSAGE);

            }

        }

        expression = replaceFields(expression);

        interpreter.declareBean("evalExpression", evalExpression, EvalExpression.class);

        interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "def expression():\n"

                + "  return " + expression + "");

        try {

            interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "def isCorrect():\n"

                    + "    evalExpression.isCorrectValue(expression())\n");

            interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "isCorrect()");

        } catch (BSFException ee) {

            String message = ee.getMessage();

            if ( message.length() > 200 ) {

                message = message.substring(0, 200);

            }

            int option = JOptionPane.showConfirmDialog((Component) PluginServices.getMainFrame(),

                    PluginServices.getText(this,

                            "error_expression") + "\n" + message + "\n" + PluginServices.getText(this, "continue?"));

            if ( option != JOptionPane.OK_OPTION ) {

                return false;

            }

        }

        try {

            boolean select = true;

            interpreter.declareBean("select", select, boolean.class);

            if ( featureStore.isEditing() ) {

                evalInEditing();

            } else {

                evalOutEditing();

            }

        } catch (DataException e) {

            logger.warn("Can't evaluate expresion ("+expression+").",e);

        }

        return true;

    }

    private void evalInEditing() throws BSFException, DataException {

        int limit = prefs.getInt("limit_rows_in_memory", -1);

        ArrayList exceptions = new ArrayList();

        interpreter.declareBean("exceptions", exceptions, ArrayList.class);

        boolean emptySelection = ((FeatureSelection) featureStore.getSelection()).isEmpty();

        FeatureSet set = null;

        DisposableIterator iterator = null;

        try {

            set = featureStore.getFeatureSet(table.getModel().getQuery());

            iterator = set.fastIterator();

            interpreter.declareBean("featureSet", set, FeatureSet.class);

            interpreter.declareBean("iterator", iterator, Iterator.class);

            interpreter.declareBean("limit", limit, int.class);

            if ( limit == -1 ) {

                featureStore.beginEditingGroup(PluginServices.getText(this, "expression"));

                if ( !emptySelection ) {

                    interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "def p():\n"

                            + "  \n"

                            + "  featureIndex.set(0)\n"

                            + "  while iterator.hasNext():\n"

                            + "    feature=iterator.next()\n"

                            + "    select=featureStore.getSelection().isSelected(feature)\n"

                            + "    if select:\n"

                            + "      featureContainer.setFeature(feature)\n"

                            + "      obj=expression()\n"

                            + "      evalExpression.setValue(featureSet,feature,obj)\n"

                            + "      featureIndex.next()\n"

                            + "  iterator.dispose()\n"

                            + "  featureSet.dispose\n"

                    );

                } else {

                    interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "def p():\n"

                            + "  \n"

                            + "  featureIndex.set(0)\n"

                            + "  while iterator.hasNext():\n"

                            + "    feature=iterator.next()\n"

                            + "    featureContainer.setFeature(feature)\n"

                            + "    obj=expression()\n"

                            + "    evalExpression.setValue(featureSet,feature,obj)\n"

                            + "    featureIndex.next()\n"

                            + "  iterator.dispose()\n"

                            + "  featureSet.dispose\n"

                    );

                }

                try {

                    interpreter.eval(ExpressionFieldExtension.JYTHON, null, -1, -1, "p()");

                } catch (BSFException ee) {

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

                            PluginServices.getText(this, "evaluate_expression_with_errors") + " " + exceptions.size() + ee.getMessage());

                }

                featureStore.endEditingGroup();

            } else {

                long size = set.getSize();

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

	//    			featureStore.finishEditing();

                    //    			featureStore.edit();

                    featureStore.beginEditingGroup(PluginServices.getText(this, "expression"));

                    set = featureStore.getFeatureSet(table.getModel().getQuery());

                    interpreter.declareBean("featureSet", set, FeatureSet.class);

                    iterator = set.fastIterator(i);

                    interpreter.declareBean("iterator", iterator, Iterator.class);

                    if ( !emptySelection ) {

                        interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "def p():\n"

                                + "  \n"

                                + "  pos=0\n"

                                + "  featureIndex.set(0)\n"

                                + "  while iterator.hasNext() and pos<limit:\n"

                                + "    feature=iterator.next()\n"

                                + "    select=featureStore.getSelection().isSelected(feature)\n"

                                + "    if select:\n"

                                + "      featureContainer.setFeature(feature)\n"

                                + "      obj=expression()\n"

                                + "      evalExpression.setValue(featureSet,feature,obj)\n"

                                + "      featureIndex.next()\n"

                                + "    pos=pos+1\n"

                                + "  iterator.dispose()\n"

                                + "  featureSet.dispose\n"

                        );

                    } else {

                        interpreter.exec(ExpressionFieldExtension.JYTHON, null, -1, -1, "def p():\n"

                                + "  \n"

                                + "  pos=0\n"

                                + "  featureIndex.set(0)\n"

                                + "  while iterator.hasNext() and pos<limit:\n"

                                + "    feature=iterator.next()\n"

                                + "    featureContainer.setFeature(feature)\n"

                                + "    obj=expression()\n"

                                + "    evalExpression.setValue(featureSet,feature,obj)\n"

                                + "    pos=pos+1\n"

                                + "    featureIndex.next()\n"

                                + "  iterator.dispose()\n"

                                + "  featureSet.dispose\n"

                        );

                    }

                    try {

                        interpreter.eval(ExpressionFieldExtension.JYTHON, null, -1, -1, "p()");

                    } catch (BSFException ee) {

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

                                PluginServices.getText(this, "evaluate_expression_with_errors") + " " + exceptions.size() + ee.getMessage());

                    }

                    featureStore.endEditingGroup();

                    featureStore.finishEditing();

                    featureStore.edit();

                }

            }

        } finally {

            DisposeUtils.dispose(set);

            DisposeUtils.dispose(iterator);

        }

    }

    private void evalOutEditing() throws BSFException, DataException {

    }

    /**

     * This method initializes pMessage

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPMessage() {

        if ( pMessage == null ) {

            pMessage = new JPanel();

            pMessage.setLayout(new GridLayout());

            pMessage.setBorder(javax.swing.BorderFactory.createTitledBorder(null, PluginServices.getText(this, "information"), javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

            pMessage.add(getJScrollPane3(), null);

        }

        return pMessage;

    }

    private void evalExpressions() throws BSFException {

        featureStore = table.getModel().getStore();

        interpreter.declareBean("featureStore", featureStore, FeatureStore.class);

        featureContainer = new FeatureContainer();

        DisposableIterator iterator = null;

        FeatureSet set = null;

        try {

            set = featureStore.getFeatureSet(table.getModel().getQuery());

            iterator = set.iterator();

            if ( iterator.hasNext() ) {

                feature = (Feature) iterator.next();

            }

            featureContainer.setFeature(feature);

            interpreter.declareBean("featureContainer", featureContainer, Feature.class);

        } catch (DataException e) {

            e.printStackTrace();

        } finally {

            if ( iterator != null ) {

                iterator.dispose();

            }

            if ( set != null ) {

                set.dispose();

            }

        }

    }

    /**

     * Evaluate the fields.

     *

     * @param interpreter

     *

     * @throws EvalError

     */

    int lastType = -1;

    private JButton bClear = null;

    private JTabbedPane tabPrincipal = null;

    private JPanel pPrincipal = null;

    private JPanel pAdvanced = null;

    private AdvancedPanel advancedPanel = null; 

//    private JPanel pAdvancedNorth = null;

//    private JTextField jTextField = null;

//    private JButton bFile = null;

//    private JPanel pAdvancedCenter = null;

//    private JLabel lblLeng = null;

//    private JButton bEval = null;

    private JScrollPane jScrollPane3 = null;

    private JTextArea txtMessage2 = null;

    private void refreshOperators(int type) {

        if ( lastType != -1 && lastType == type ) {

            return;

        }

        lastType = type;

        ListOperatorsModel lom = (ListOperatorsModel) getListCommand().getModel();

        lom.clear();

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

            IOperator operator = (IOperator) operators.get(i);

            operator.setType(type);

            //Comprobar si tiene una capa asociada y pasarsela al GraphicOperator.

            if ( (lv != null) && operator instanceof GraphicOperator ) {

                GraphicOperator igo = (GraphicOperator) operator;

                igo.setLayer(lv);

            }

            if ( operator.isEnable() ) {

                lom.addOperator(operator);

                //System.out.println("Operator = "+operator.toString());

            }

        }

        getListCommand().repaint();

        getJScrollPane2().repaint();

        getJScrollPane2().doLayout();

        this.doLayout();

    }

    /**

     * This method initializes jScrollPane

     *

     * @return javax.swing.JScrollPane

     */

    private JScrollPane getJScrollPane() {

        if ( jScrollPane == null ) {

            jScrollPane = new JScrollPane();

            jScrollPane.setPreferredSize(new java.awt.Dimension(480, 80));

            jScrollPane.setViewportView(getTxtExp());

        }

        return jScrollPane;

    }

    /**

     * This method initializes txtExp

     *

     * @return javax.swing.JTextArea

     */

    private JTextArea getTxtExp() {

        if ( txtExp == null ) {

            txtExp = new JTextArea();

            txtExp.addCaretListener(new CaretListener() {

                public void caretUpdate(CaretEvent e) {

                    if ( txtExp.getText().length() > 0 ) {

                        getAcceptCancel().setOkButtonEnabled(true);

                    } else {

                        getAcceptCancel().setOkButtonEnabled(false);

                    }

                }

            });

        }

        return txtExp;

    }

    public WindowInfo getWindowInfo() {

        WindowInfo wi = new WindowInfo(WindowInfo.MODALDIALOG + WindowInfo.RESIZABLE);

        wi.setTitle(PluginServices.getText(this, "calculate_expression"));

        return wi;

    }

    /**

     * This method initializes pNorthEast

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPNorthEast() {

        if ( pNorthEast == null ) {

            pNorthEast = new JPanel(new GridLayout());

            pNorthEast.setBorder(javax.swing.BorderFactory.createTitledBorder(

                    null, PluginServices.getText(this, "commands"),

                    javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

                    javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

            pNorthEast.add(getJScrollPane2(), null);

        }

        return pNorthEast;

    }

    /**

     * This method initializes pNorthCenter

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPNorthCenter() {

        if ( pNorthCenter == null ) {

            pNorthCenter = new JPanel();

            pNorthCenter.setLayout(new BoxLayout(getPNorthCenter(),

                    BoxLayout.Y_AXIS));

            pNorthCenter.setBorder(javax.swing.BorderFactory.createTitledBorder(

                    null, PluginServices.getText(this, "type"),

                    javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

                    javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

            pNorthCenter.add(getRbNumber(), null);

            pNorthCenter.add(getRbString(), null);

            pNorthCenter.add(getRbDate(), null);

        }

        return pNorthCenter;

    }

    /**

     * This method initializes pNorthWest

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPNorthWest() {

        if ( pNorthWest == null ) {

            pNorthWest = new JPanel(new GridLayout());

            pNorthWest.setBorder(javax.swing.BorderFactory.createTitledBorder(

                    null, PluginServices.getText(this, "field"),

                    javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

                    javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

            pNorthWest.add(getJScrollPane1(), null);

        }

        return pNorthWest;

    }

    /**

     * This method initializes jScrollPane1

     *

     * @return javax.swing.JScrollPane

     */

    private JScrollPane getJScrollPane1() {

        if ( jScrollPane1 == null ) {

            jScrollPane1 = new JScrollPane();

            jScrollPane1.setPreferredSize(new java.awt.Dimension(175, 100));

            jScrollPane1.setViewportView(getListFields());

        }

        return jScrollPane1;

    }

    /**

     * This method initializes listFields

     *

     * @return javax.swing.JList

     */

    private JList getListFields() {

        if ( listFields == null ) {

            listFields = new JList();

            listFields.setModel(new ListOperatorsModel());

            ListOperatorsModel lm = (ListOperatorsModel) listFields.getModel();

            FeatureType fds = evalExpression.getFieldDescriptors();

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