| gvSIG desktop 1

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.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 bsh.EvalError;

/**

 * DOCUMENT ME!

 *

 * @author Vicente Caballero Navarro

 */

public class EvalExpressionDialog extends JPanel implements IWindow {

        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;

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

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

                                                                System.out

                                                                                .println("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;

        }

    /**

         * Evaluate the expression.

         * @throws BSFException

         */

    private boolean evalExpression() throws BSFException{

        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) {

                        // TODO Auto-generated catch block

                        e.printStackTrace();

                }

        expression=expression.replaceAll("\\[","field(\"").replaceAll("\\]","\")");

            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) {

                    NotificationManager.addError(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.iterator();

                        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" +

                                                    "  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" +

                                                    "  iterator.dispose()\n" +

                                                    "  featureSet.dispose\n"

                                    );

                            }else{

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

                                                    "  \n" +

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

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

                                                    "    featureContainer.setFeature(feature)\n" +

                                                    "    obj=expression()\n" +

                                                    "    evalExpression.setValue(featureSet,feature,obj)\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.iterator(i);

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

                                    if (!emptySelection){

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

                                                            "  \n" +

                                                            "  pos=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" +

                                                            "    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" +

                                                            "  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" +

                                                            "  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 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++) {

                Field field=new Field();

                field.setFieldDescription(fds.getAttributeDescriptor(i));

                try {

                        field.eval(interpreter);

                } catch (BSFException e) {

                                        e.printStackTrace();

                                }

                lm.addOperator(field);

            }

            listFields.addMouseListener(new MouseListener() {

                    public void mouseClicked(MouseEvent e) {

                            IOperator operator=((IOperator) listFields.getSelectedValue());

                            if (operator!=null){

                                    getTxtMessage2().setText(operator.getTooltip());

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

                                            getTxtExp().setText(operator.addText(

                                                            getTxtExp().getText()));

                                    }

                            }

                    }

                    public void mouseEntered(MouseEvent e) {

                    }

                    public void mouseExited(MouseEvent e) {

                    }

                    public void mousePressed(MouseEvent e) {

                    }

                    public void mouseReleased(MouseEvent e) {

                    }

                });

        }

        return listFields;

    }

    /**

     * This method initializes rbNumber

     *

     * @return javax.swing.JRadioButton

     */

    private JRadioButton getRbNumber() {

        if (rbNumber == null) {

            rbNumber = new JRadioButton();

            rbNumber.setText(PluginServices.getText(this,"numeric"));

            rbNumber.setSelected(true);

            rbNumber.addChangeListener(new javax.swing.event.ChangeListener() {

                public void stateChanged(javax.swing.event.ChangeEvent e) {

                     if (rbNumber.isSelected())

                         refreshCommands();

                }

            });

        }

        return rbNumber;

    }

    /**

     * This method initializes rbString

     *

     * @return javax.swing.JRadioButton

     */

    private JRadioButton getRbString() {

        if (rbString == null) {

            rbString = new JRadioButton();

            rbString.setText(PluginServices.getText(this,"string"));

            rbString.addChangeListener(new javax.swing.event.ChangeListener() {

                public void stateChanged(javax.swing.event.ChangeEvent e) {

                     if (rbString.isSelected())

                         refreshCommands();

                }

            });

        }

        return rbString;

    }

    /**

     * This method initializes rbData

     *

     * @return javax.swing.JRadioButton

     */

    private JRadioButton getRbDate() {

        if (rbDate == null) {

            rbDate = new JRadioButton();

            rbDate.setText(PluginServices.getText(this,"date"));

            rbDate.addChangeListener(new javax.swing.event.ChangeListener() {

                public void stateChanged(javax.swing.event.ChangeEvent e) {

                    if (rbDate.isSelected())

                         refreshCommands();

                }

            });

        }

        return rbDate;

    }

    /**

     * This method initializes jScrollPane2

     *

     * @return javax.swing.JScrollPane

     */

    private JScrollPane getJScrollPane2() {

        if (jScrollPane2 == null) {

            jScrollPane2 = new JScrollPane();

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

            jScrollPane2.setViewportView(getListCommand());

        }

        return jScrollPane2;

    }

    /**

     * Refresh the commands.

     */

    private void refreshCommands() {

        int type=IOperator.NUMBER;

        if (getRbNumber().isSelected()) {

            type=IOperator.NUMBER;

        } else if (getRbString().isSelected()) {

            type=IOperator.STRING;

        } else if (getRbDate().isSelected()) {

            type=IOperator.DATE;

        }

        refreshOperators(type);

    }

    /**

     * This method initializes ListCommand

     *

     * @return javax.swing.JList

     */

    private JList getListCommand() {

        if (listCommand == null) {

            listCommand = new JList();

            listCommand.setModel(new ListOperatorsModel());

            listCommand.addMouseListener(new MouseListener() {

                    public void mouseClicked(MouseEvent e) {

                            IOperator operator=((IOperator) listCommand.getSelectedValue());

                            if (operator!=null){

                                    getTxtMessage2().setText(operator.getTooltip());

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

                                            if (listCommand.getSelectedValue()==null)

                                                    return;

                                            getTxtExp().setText(operator.addText(

                                                            getTxtExp().getText()));

                                    }

                            }

                    }

                    public void mouseEntered(MouseEvent e) {

                    }

                    public void mouseExited(MouseEvent e) {

                    }

                    public void mousePressed(MouseEvent e) {

                    }

                    public void mouseReleased(MouseEvent e) {

                    }

                });

            refreshOperators(IOperator.NUMBER);

        }

        return listCommand;

    }

    /**

         * This method initializes bClear

         *

         * @return javax.swing.JButton

         */

        private JButton getBClear() {

                if (bClear == null) {

                        bClear = new JButton();

                        bClear.setText(PluginServices.getText(this,"clear_expression"));

                        bClear.addActionListener(new java.awt.event.ActionListener() {

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

                                        getTxtExp().setText("");

                                }

                        });

                }

                return bClear;

        }

        /**

         * This method initializes tabPrincipal

         *

         * @return javax.swing.JTabbedPane

         */

        private JTabbedPane getTabPrincipal() {

                if (tabPrincipal == null) {

                        tabPrincipal = new JTabbedPane();

                        tabPrincipal.addTab(PluginServices.getText(this,"general"), null, getPPrincipal(), null);

                        tabPrincipal.addTab(PluginServices.getText(this,"advanced"), null, getPAdvanced(), null);

                }

                return tabPrincipal;

        }

        /**

         * This method initializes pPrincipal

         *

         * @return javax.swing.JPanel

         */

        private JPanel getPPrincipal() {

                if (pPrincipal == null) {

                        pPrincipal = new JPanel();

                        pPrincipal.setLayout(new BorderLayout());

//                        pPrincipal.setPreferredSize(new java.awt.Dimension(540,252));

                        pPrincipal.add(getPNorth(), java.awt.BorderLayout.NORTH);

                        pPrincipal.add(getPCentral(), java.awt.BorderLayout.CENTER);

                }

                return pPrincipal;

        }

        /**

         * This method initializes pAdvanced

         *

         * @return javax.swing.JPanel

         */

        private JPanel getPAdvanced() {

                if (pAdvanced == null) {

                        pAdvanced = new JPanel();

                        pAdvanced.setLayout(new BorderLayout());

                        pAdvanced.add(getPAdvancedNorth(), java.awt.BorderLayout.NORTH);

                        pAdvanced.add(getPAdvancedCenter(), java.awt.BorderLayout.CENTER);

                }

                return pAdvanced;

        }

        /**

         * This method initializes pAdvancedNorth

         *

         * @return javax.swing.JPanel

         */

        private JPanel getPAdvancedNorth() {

                if (pAdvancedNorth == null) {

                        pAdvancedNorth = new JPanel(new GridBagLayout());

//                        pAdvancedNorth.setPreferredSize(new java.awt.Dimension(873,100));

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

                        GridBagConstraints contr = new GridBagConstraints();

                        contr.anchor = GridBagConstraints.FIRST_LINE_START;

                        contr.fill = GridBagConstraints.HORIZONTAL;

                        contr.weighty =0;

                        contr.weightx =1;

                        contr.insets = new Insets(3,3,3,3);

                        contr.ipadx=5;

                        contr.ipady=5;

                        pAdvancedNorth.add(getJTextField(), contr);

                        contr.fill = GridBagConstraints.NONE;

                        contr.weighty =0;

                        contr.weightx =0;

                        pAdvancedNorth.add(getBFile(), null);

                        pAdvancedNorth.add(getBEval(), null);

                }

                return pAdvancedNorth;

        }

        /**

         * This method initializes jTextField

         *

         * @return javax.swing.JTextField

         */

        private JTextField getJTextField() {

                if (jTextField == null) {

                        jTextField = new JTextField();

                        jTextField.setPreferredSize(new java.awt.Dimension(250,20));

                }

                return jTextField;

        }

        /**

         * This method initializes bFile

         *

         * @return javax.swing.JButton

         */

        private JButton getBFile() {

                if (bFile == null) {

                        bFile = new JButton();

                        bFile.setText(PluginServices.getText(this,"explorer"));

                        bFile.addActionListener(new java.awt.event.ActionListener() {

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

                                        JFileChooser jfc = new JFileChooser();

                                        jfc.addChoosableFileFilter(new GenericFileFilter("py",

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

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

                                                File fileExpression = jfc.getSelectedFile();

                                                getJTextField().setText(fileExpression.getAbsolutePath());

                                        }

                                }

                                });

                }

                return bFile;

        }

        private String readFile(File aFile) throws IOException {

                StringBuffer fileContents = new StringBuffer();

                FileReader fileReader = new FileReader(aFile);

                int c;

                while ((c = fileReader.read()) > -1) {

                        fileContents.append((char)c);

                }

                fileReader.close();

                return fileContents.toString();

        }

        /**

         * This method initializes pAdvancedCenter

         *

         * @return javax.swing.JPanel

         */

        private JPanel getPAdvancedCenter() {

                if (pAdvancedCenter == null) {

                        lblLeng = new JLabel();

                        lblLeng.setText("");

                        pAdvancedCenter = new JPanel();

                        pAdvancedCenter.add(lblLeng, null);

                }

                return pAdvancedCenter;

        }

        /**

         * This method initializes bEval

         *

         * @return javax.swing.JButton

         */

        private JButton getBEval() {

                if (bEval == null) {

                        bEval = new JButton();

                        bEval.setText(PluginServices.getText(this,"evaluate"));

                        bEval.addActionListener(new java.awt.event.ActionListener() {

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

                                        File file=new File(getJTextField().getText());

                                        if (!file.exists()) {

                                                JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),PluginServices.getText(this,"incorrect_file"));

                                                return;

                                        }

                                        try {

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

                                        } catch (IOException e1) {

                                                e1.printStackTrace();

                                        } catch (BSFException e1) {

                                                e1.printStackTrace();

                                        }

                                }

                        });

                }

                return bEval;

        }

        /**

         * This method initializes jScrollPane3

         *

         * @return javax.swing.JScrollPane

         */

        private JScrollPane getJScrollPane3() {

                if (jScrollPane3 == null) {

                        jScrollPane3 = new JScrollPane();

                        jScrollPane3.setPreferredSize(new java.awt.Dimension(530,80));

                        jScrollPane3.setViewportView(getTxtMessage2());

                }

                return jScrollPane3;

        }

        /**

         * This method initializes txtMessage2

         *

         * @return javax.swing.JTextArea

         */

        private JTextArea getTxtMessage2() {

                if (txtMessage2 == null) {

                        txtMessage2 = new JTextArea();

                        txtMessage2.setText(PluginServices.getText(this,"eval_expression_will_be_carried_out_right_now_with_current_values_in_table"));

                        txtMessage2.setEditable(false);

                        txtMessage2.setBackground(UIManager.getColor(this));

                }

                return txtMessage2;

        }

        public Object getWindowProfile() {

                return WindowInfo.DIALOG_PROFILE;

        }

} //  @jve:decl-index=0:visual-constraint="10,10"