Application: gvSIG desktop

package org.gvsig.crs.ui;

import java.awt.BorderLayout;

import java.awt.Component;

import java.awt.Dimension;

import java.awt.FlowLayout;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

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

import javax.swing.ListSelectionModel;

import javax.swing.event.ListSelectionEvent;

import javax.swing.event.ListSelectionListener;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableColumn;

import org.cresques.cts.IProjection;

import org.cresques.ui.DefaultDialogPanel;

import org.gvsig.crs.CrsFactory;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.Query;

import org.gvsig.crs.ogr.GetTransepsg;

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.panels.ProjChooserPanelTransformation;

public class TransformationEpsgPanel extends DefaultDialogPanel implements IWindow {

        /**

         * 

         */

        private static final long serialVersionUID = 1L;

        private JPanel panel;

        private IProjection firstProj;

        String[] transformations = {"9603", "9606", "9607", "9613", "9615", "9633"};

        private int trasnformation_code = -1;

        private String[] values;

        private String params = "+towgs84=";

        private JTable transformationTable;        

        private JScrollPane jScrollPane = null;

        private JPanel buttonPane;

        private JButton accept;

        private JButton cancel;

        ProjChooserPanelTransformation pcpt;        

        int crs_target = -1;

        public DefaultTableModel dtm = null;

        private int codeEpsg;

        private String cadWKT = "";

        private ListSelectionModel lsm2 = null;

        public int selectedRowTable = -1;

        boolean tra = false;

        private JLabel wkt;

        private JTextArea info;

        private JScrollPane areaScrollPane;

        public TransformationEpsgPanel(String cad, int code, int target) {

                super(false);

                crs_target = target;

                pcpt = new ProjChooserPanelTransformation();                

                cadWKT = cad;                

                init();

                codeEpsg = code;

                callTransformation(code);                

        }

        private void init() {

                this.add(getJPanel());

                this.add(getJScrollPane());

                this.add(getButtonPane());

        }

        private JPanel getJPanel(){

                if (panel == null) {

                        panel = new JPanel();

                        panel.setLayout(new GridLayout(1,2));

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

                        panel.setPreferredSize(new Dimension(525, 100));

                        panel.add(getLabel());

                        panel.add(getScrollPanelArea(), BorderLayout.NORTH);

                }

                return panel;

        }

        private Component getLabel() {

                if (wkt == null){

                        wkt = new JLabel();

                        wkt.setPreferredSize(new Dimension(90, 80));

                        wkt.setText("Cadena WKT: ");

                }                

                return wkt;

        }

        private Component getInfo() {

                if (info == null){

                        info = new JTextArea();

                        info.setLineWrap(true);

                        info.setWrapStyleWord(true);

                        info.setPreferredSize(new Dimension(400, 240));

                        info.setEditable(false);

                        info.append(cadWKT);

                }

                return info;

        }

        private JScrollPane getScrollPanelArea() {

                if(areaScrollPane == null) {

                        areaScrollPane = new JScrollPane(getInfo());

                        areaScrollPane.setVerticalScrollBarPolicy(

                                        JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);

                        areaScrollPane.setPreferredSize(new Dimension(420, 90));

                        areaScrollPane.setBorder(

                            BorderFactory.createCompoundBorder(

                                BorderFactory.createCompoundBorder(

                                                BorderFactory.createTitledBorder("Wkt"),

                                                BorderFactory.createEmptyBorder(2,2,2,2)),

                                areaScrollPane.getBorder()));

                }

                return areaScrollPane;

        }

        private JTable getJTable() {

                if (transformationTable == null) {

                        String[] columnNames= {"Code of Transformation","Name of Transformation","Type of Transformation","Source CRS","Target CRS", "Description of Area"};

                        Object[][]data = {};

                        dtm = new DefaultTableModel(data, columnNames);

                        transformationTable = new JTable(dtm);

                        transformationTable.setCellSelectionEnabled(false);

                        transformationTable.setRowSelectionAllowed(true);

                        transformationTable.setColumnSelectionAllowed(false);

                        transformationTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

                        TableColumn column = null;

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

                            column = transformationTable.getColumnModel().getColumn(i);

                            if (i == 0 || i == 3 || i == 4) {

                                column.setPreferredWidth(40);                                     

                            }else if (i == 2) {

                                    column.setPreferredWidth(80);

                            }

                            else {                            

                                column.setPreferredWidth(160);

                            }

                        }

                        ListSelectionModel rowSM2 = transformationTable.getSelectionModel();

                        rowSM2.addListSelectionListener(new ListSelectionListener() {

                            public void valueChanged(ListSelectionEvent e) {

                                lsm2 = (ListSelectionModel)e.getSource();

                                if (lsm2.isSelectionEmpty()) {

                                        selectedRowTable = -1;

                                        tra = false;

                                } 

                                else {

                                    selectedRowTable = lsm2.getMinSelectionIndex();

                                    setTrasformation_code(Integer.parseInt((String)dtm.getValueAt(selectedRowTable,0)));

                                }

                            }

                        });

                }

                return transformationTable;

        }

        private JScrollPane getJScrollPane() {

                if (jScrollPane == null) {

                        jScrollPane = new JScrollPane();

                        jScrollPane.setPreferredSize(new Dimension(525,200));

                        jScrollPane.setBorder(

                                    BorderFactory.createCompoundBorder(

                                        BorderFactory.createCompoundBorder(

                                                        BorderFactory.createTitledBorder("Transformations"),

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

                                                        jScrollPane.getBorder()));

                        jScrollPane.setViewportView(getJTable());

                }

                return jScrollPane;

        }

        private JPanel getButtonPane() {

                if(buttonPane == null) {

                        buttonPane = new JPanel();

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

                        buttonPane.setPreferredSize(new Dimension(525,50));

                        buttonPane.add(getButtonAccept(),null);

                        buttonPane.add(getButtonCancel(),null);

                }

                return buttonPane;

        }

        private JButton getButtonCancel() {

                if(cancel == null) {

                        cancel = new JButton();

                        cancel.setText("Cancelar");

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

                        cancel.setMnemonic('C');

                        cancel.setToolTipText("Cancel");

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

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

                                        cancelButton_actionPerformed(e);                

                                }        

                        });

                }

                return cancel;

        }

        public void cancelButton_actionPerformed(ActionEvent e) {

                PluginServices.getMDIManager().closeWindow(this);

        }

        private JButton getButtonAccept() {

                if(accept == null) {

                        accept = new JButton();

                        accept.setText("Ok");

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

                        accept.setMnemonic('A');

                        accept.setToolTipText("Aceptar");

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

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

                                        acceptButton_actionPerformed(e);                

                                }        

                        });

                }

                return accept;

        }

        public void acceptButton_actionPerformed(ActionEvent e) {        

                GetTransepsg epsgParams = new GetTransepsg(trasnformation_code,pcpt);

                setValues(epsgParams.getParamValue());

                PluginServices.getMDIManager().closeWindow(this);

        }

        private void callTransformation(int crsCode){                

        int numRow = dtm.getRowCount();

        while (numRow != 0) {

                        numRow = numRow - 1;

                        dtm.removeRow(numRow);

                }

        String sentence = "SELECT source_geogcrs_code " +

                                                "FROM epsg_coordinatereferencesystem " +

                                                "WHERE coord_ref_sys_code = "+ crsCode ;

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

                int source = 0;

                try {

                        result.next();

                        source = result.getInt("source_geogcrs_code");

                } catch (SQLException e1) {

                        e1.printStackTrace();

                }

        ResultSet result2 = null;

        ResultSet result3 = null;

        if (source != 0){

                        crsCode = source;                                    

        }

        /*

         * Para buscar tambien transformaciones indirectas, tendremos que hacer un metodo

         * que nos devuelva la informacion necesaria para printarla en la tabla.

         */

        sentence =  "SELECT target_crs_code " +

                                        "FROM epsg_coordoperation " +                        

                                        "WHERE source_crs_code = " + crsCode;

        result = Query.select(sentence,pcpt.connect.getConnection());        

        ArrayList codecs = new ArrayList();

        codecs.add(String.valueOf(crsCode));

        try {

                while(result.next()) {                        

                        codecs.add(String.valueOf(result.getInt("target_crs_code")));

                }

        }         

        catch (SQLException e1) {

                e1.printStackTrace();

        }        

                /*

                 * tendremos que eliminar los codigos repetidos

                 * para no repetir resultados

                 */

                codecs = deleteItems(codecs);

                for (int j=0; j< codecs.size(); j++){

                        sentence = "SELECT coord_op_code, coord_op_name, coord_op_type, source_crs_code, target_crs_code, area_of_use_code, coord_op_method_code " +

                                        "FROM epsg_coordoperation " +                        

                                        "WHERE source_crs_code = " + codecs.get(j) + "AND target_crs_code = " + crs_target;

            result = Query.select(sentence,pcpt.connect.getConnection());        

            try {

                    while(result.next()) {

                            Object[]data = new Object[6];                                                            

                            data[0] = String.valueOf(result.getInt("coord_op_code"));

                            data[1] = result.getString("coord_op_name");

                            data[2] = result.getString("coord_op_type");

                            data[3] = String.valueOf(result.getInt("source_crs_code"));

                            data[4] = String.valueOf(result.getInt("target_crs_code"));

                            codecs.add(data[4]);

                            codecs = deleteItems(codecs);

                            int aouc = Integer.parseInt(result.getString("area_of_use_code"));

                                        sentence = "SELECT area_of_use FROM epsg_area " +

                                                                        "WHERE area_code = "+ aouc ;

                                        result2 = Query.select(sentence,pcpt.connect.getConnection());

                            while (result2.next())

                                    data[5] = result2.getString("area_of_use");

                            String coord_op_method = result.getString("coord_op_method_code");                                                            

                            sentence = "SELECT reverse_op FROM epsg_coordoperationmethod "+

                                                    "WHERE coord_op_method_code LIKE " + coord_op_method;

                            result3 = Query.select(sentence,pcpt.connect.getConnection());

                            while(result3.next()){

                                    if (Integer.parseInt(result3.getString("reverse_op")) == 1){

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

                                                    if (coord_op_method.equals(transformations[i])){

                                                            dtm.addRow(data);

                                                    }

                                            }                                            

                                    }

                            }

                    }

            }         

            catch (SQLException e1) {

                    e1.printStackTrace();

            }

                }

        }

        private ArrayList deleteItems(ArrayList codecs) {

                ArrayList cod = new ArrayList();

                boolean equal = false;

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

                        String c = (String) codecs.get(i);

                        for (int j = 0; j<cod.size(); j++){

                                if (cod.get(j).equals(c)){

                                        equal = true;

                                }

                        }

                        if (!equal){

                                cod.add(c);                                

                        }

                        equal = false;

                }

                return cod;

        }

        private void setValues(String[] val) {

                values = val;

        }

        public String[] getValues() {

                return values;

        }

        private void setTrasformation_code(int t_cod) {

                trasnformation_code = t_cod;

        }

        public ICrs getProjection() {

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

                        params +=values[i]+",";

                try {

                        ICrs crs = new CrsFactory().getCRS(codeEpsg,

                                        cadWKT,params);

                        return crs;

                } catch (org.gvsig.crs.CrsException e) {

                        e.printStackTrace();

                }

                return null;

        }

        public void setProjection(IProjection proj) {

                firstProj = proj;

                }

        public WindowInfo getWindowInfo() {

                WindowInfo m_viewinfo=new WindowInfo(WindowInfo.MODALDIALOG);

                   m_viewinfo.setTitle("Transformation EPSG");

                return m_viewinfo;

        }

}