Application: gvSIG desktop

package org.gvsig.crs.gui.panels;

import java.awt.Dimension;

import java.awt.FlowLayout;

import java.awt.Font;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.BorderFactory;

import javax.swing.JButton;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.ListSelectionModel;

import javax.swing.table.DefaultTableModel;

import org.cresques.ui.DefaultDialogPanel;

import org.gvsig.crs.EpsgConnection;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.Query;

import com.iver.andami.PluginServices;

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

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

import com.iver.cit.gvsig.gui.TableSorter;

public class InfoTransformationsRecentsPanel extends JPanel implements IWindow, ActionListener{

        private static final long serialVersionUID = 1L;

        private JPanel panelLabels;

        private JTable jTable;

        public DefaultTableModel dtm = null;

        private JScrollPane jScrollPane1 = null;

        private JPanel jPanelbuttons;

        private JButton jButtonOk;

        public TableSorter sorter = null;

        String[] data = null;

        private ICrs proj;

        public InfoTransformationsRecentsPanel(String[] data) {

                super();

                // TODO Auto-generated constructor stub

                this.data = data;

                inicializate();

        }

        private void inicializate() {

                setLayout(new GridLayout(2,1));

                setLayout(new FlowLayout(FlowLayout.LEADING,5,10));

                setPreferredSize(new Dimension(400, 200));

                add(getJScrollPane1(), null);

                add(getJPanelButtons(), null);

        }

        private JPanel getJPanelButtons() {

                if(jPanelbuttons == null) {

                        jPanelbuttons = new JPanel();

                        jPanelbuttons.setLayout(new FlowLayout(FlowLayout.RIGHT));

                        jPanelbuttons.setPreferredSize(new Dimension(400,50));

                        jPanelbuttons.add(getJButtonOk(),null);

                }

                return jPanelbuttons;

        }

        private JButton getJButtonOk() {

                if(jButtonOk == null) {

                        jButtonOk = new JButton();

                        jButtonOk.setText(PluginServices.getText(this,"ok"));

                        jButtonOk.setPreferredSize(new Dimension(100,25));

                        jButtonOk.setMnemonic('O');

                        jButtonOk.setToolTipText("Accept");

                        jButtonOk.addActionListener(this);

                }

                return jButtonOk;

        }

        private JScrollPane getJScrollPane1() {

                if(jScrollPane1 == null) {

                        jScrollPane1 = new JScrollPane();

                        jScrollPane1.setPreferredSize(new Dimension(400,150));        

                        jScrollPane1.setBorder(

                                    BorderFactory.createCompoundBorder(

                                        BorderFactory.createCompoundBorder(

                                                        BorderFactory.createTitledBorder(PluginServices.getText(this,"info_transformations")),

                                                        BorderFactory.createEmptyBorder(5,5,5,5)),

                                                        jScrollPane1.getBorder()));

                        jScrollPane1.setViewportView(getJTable());

                }

                return jScrollPane1;

        }

        private JTable getJTable() {

                if(jTable == null) {

                        String[] columnNames = {PluginServices.getText(this,"nombre")

                                        ,PluginServices.getText(this,"valor")};

                        Object[][] datos = obtainData();

                        dtm = new DefaultTableModel(datos, columnNames)

                         {

                                public boolean isCellEditable(int row, int column) {

                                        return false;

                                }                

                        };

                        sorter = new TableSorter(dtm);                        

                        jTable = new JTable(sorter);

                        jTable.setCellSelectionEnabled(false);

                        jTable.setRowSelectionAllowed(true);

                        jTable.setColumnSelectionAllowed(false);

                        jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

                }

                return jTable;

        }

        private String[][] obtainData(){        

                String[][] valid = null;

                if (data[0].equals("EPSG")){

                        valid = new String[6][2];

                        valid[0][0] = PluginServices.getText(this,"source_crs");

                        valid[0][1] = data[2];

                        valid[1][0] = PluginServices.getText(this,"target_crs");

                        valid[1][1] = data[3];

                        EpsgConnection conn = new EpsgConnection();

                        conn.setConnectionEPSG();

                        String sentence = "SELECT coord_op_code, area_of_use_code " +

                                                        "FROM epsg_coordoperation " +                        

                                                        "WHERE coord_op_name LIKE '" + data[1]+ "'" ;

                    ResultSet result = Query.select(sentence,conn.getConnection());                   

                        try {

                                result.next();                                

                                valid[2][0] =  PluginServices.getText(this,"transformation_code");

                                valid[2][1] = result.getString("coord_op_code");                                

                                sentence = "SELECT area_of_use FROM epsg_area " +

                                                                "WHERE area_code = "+ Integer.parseInt(result.getString("area_of_use_code"));

                        } catch (SQLException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

                        valid[3][0] = PluginServices.getText(this,"transformation_name");

                        valid[3][1] = data[1];

                        valid[4][0] = PluginServices.getText(this,"details");

                        result = Query.select(sentence, conn.getConnection());

                        try {

                                result.next();

                                valid[4][1] = result.getString("area_of_use");

                        } catch (SQLException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

                }

                else if (data[0].equals("USR")){

                        valid = new String[3][2];

                        valid[0][0] = PluginServices.getText(this,"source_crs");

                        valid[0][1] = data[2];

                        valid[1][0] = PluginServices.getText(this,"target_crs");

                        valid[1][1] = data[3];

                        valid[2][0] = PluginServices.getText(this,"details");

                        valid[2][1] = data[4];                        

                } else {

                        valid = new String[4][2];

                        String[] partes = data[4].split("\\(");

                        String nadFile = partes[0];                

                        String codigoNad = partes[1].substring(0,partes[1].length()-1);

                        valid[0][0] = PluginServices.getText(this,"source_crs");

                        valid[0][1] = data[2];

                        valid[1][0] =PluginServices.getText(this,"target_crs");

                        valid[1][1] = data[3];

                        valid[2][0] = PluginServices.getText(this,"nadgrids_file");

                        valid[2][1] = nadFile;        

                        valid[3][0] = PluginServices.getText(this,"calculated_in");

                        valid[3][1] = codigoNad;

                }

                return valid;

        }

        public WindowInfo getWindowInfo() {

                WindowInfo m_viewinfo=new WindowInfo(WindowInfo.MODALDIALOG);

                   m_viewinfo.setTitle("Info");//PluginServices.getText(this,proj.getCrsWkt().getName()));

                return m_viewinfo;

        }

        public void actionPerformed(ActionEvent e) {

                if (e.getSource() == getJButtonOk()){

                        PluginServices.getMDIManager().closeWindow(this);

                }

        }

}