| gvSIG desktop 1

/* gvSIG. Geographic Information System of the Valencian Government

 *

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

 * of the Valencian Government (CIT)

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, 

 * MA  02110-1301, USA.

 * 

 */

/*

 * AUTHORS (In addition to CIT):

 * 2008 Prodevelop S.L. main development

 */

package org.gvsig.normalization.operations;

import java.sql.Types;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.BitSet;

import java.util.Date;

import java.util.List;

import javax.swing.event.ChangeEvent;

import javax.swing.event.ChangeListener;

import org.gvsig.normalization.patterns.Datevalue;

import org.gvsig.normalization.patterns.Decimalvalue;

import org.gvsig.normalization.patterns.Element;

import org.gvsig.normalization.patterns.Fieldtype;

import org.gvsig.normalization.patterns.Integervalue;

import org.gvsig.normalization.patterns.Patternnormalization;

import org.gvsig.normalization.patterns.Stringvalue;

import com.hardcode.gdbms.engine.values.Vabvlue;

import com.hardcode.gdbms.engine.values.ValueFactory;

import com.iver.cit.gvsig.fmap.drivers.FieldDescription;

import com.iver.cit.gvsig.fmap.edition.IEditableSource;

import com.iver.cit.gvsig.project.documents.table.ProjectTable;

import com.iver.cit.gvsig.project.documents.table.gui.Table;

/**

 * @author <a href="mailto:jsanz@prodevelop.es"> Jorge Gaspar Sanz Salinas</a>

 * @author <a href="mailto:vsanjaime@prodevelop.es"> Vicente Sanjaime Calvet</a>

 */

public abstract class AbstractNormalization implements Normalization,

                ChangeListener {

        @SuppressWarnings("unchecked")

        private List listeners = new ArrayList();

        // ATTRIBUTES

        protected NormAlgorithm nAlgorithm;

        // Pattern

        protected Patternnormalization pattern;

        protected String[] nameNewFields;

        protected int[] posNameNewFields;

        /**

         * builder

         * 

         * @param pat

         *            pattern

         */

        public AbstractNormalization(Patternnormalization pat) {

                this.pattern = pat;

                nAlgorithm = new NormAlgorithm(pat);

                nAlgorithm.registerListener(this);

                loadNamesNewFields();

        }

        /**

         * This method gets the name of the main field

         * 

         * @param _tab

         * @return name of the selected field

         */

        public static String getNameMainField(Table _tab) {

                BitSet _columnSelected = _tab.getSelectedFieldIndices();

                int po = _columnSelected.nextSetBit(0);

                ProjectTable oriPT = _tab.getModel();

                IEditableSource ies = oriPT.getModelo();

                FieldDescription[] fd = ies.getFieldsDescription();

                String name = fd[po].getFieldName();

                return name.toUpperCase();

        }

        /**

         * Get the pattern

         * 

         * @return pattern

         */

        public Patternnormalization getPattern() {

                return pattern;

        }

        /**

         * Get the number of rows

         * 

         * @return number of rows

         */

        public abstract long getRowCount();

        /**

         * This method formats the date from a date pattern

         * 

         * @see http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html

         * 

         * @param date

         * @param pattern

         * @return Value

         * @throws ParseException

         */

        public Value formatDates(String date, String pattern) throws ParseException {

                Value result = ValueFactory.createNullValue();

                Date fecha = null;

                SimpleDateFormat sdf = new SimpleDateFormat(pattern);

                fecha = sdf.parse(date);

                result = ValueFactory.createValue(fecha);

                return result;

        }

        /**

         * This method in its base implementations returns the same value as the

         * rowCount method

         * 

         * @return number of rows estimated

         */

        public long getEstimatedRowCount() {

                return getRowCount();

        }

        /**

         * Tasks necessary before normalize

         * 

         * @return process ok

         */

        public boolean preProcess() {

                return false;

        }

        /**

         * Tasks necessary after normalize

         * 

         * @return process ok

         */

        public boolean postProcess() {

                return false;

        }

        /**

         * Get the number of the new imported fields

         * 

         * @return number of imported fields

         */

        public int numNewImportedFields() {

                int contImported = 0;

                int contTotal = this.pattern.getElements().size();

                for (int i = 0; i < contTotal; i++) {

                        if (((Element) this.pattern.getElements().get(i)).getImportfield()) {

                                contImported++;

                        }

                }

                return contImported;

        }

        /**

         * Register a listeners

         * 

         * @param l

         *            listener

         */

        @SuppressWarnings("unchecked")

        public void registerListener(ChangeListener l) {

                this.listeners.add(l);

        }

        /**

         * Remove a listener

         * 

         * @param l

         *            listener

         */

        public void removeListener(ChangeListener l) {

                this.listeners.remove(l);

        }

        /**

         * Renove all listeners

         */

        public void removeAllListeners() {

                this.nAlgorithm.removeAllListeners();

                this.listeners.clear();

        }

        /**

         * 

         * @param evt

         */

        public void update(ChangeEvent evt) {

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

                        ((ChangeListener) listeners.get(i)).stateChanged(evt);

                }

        }

        /**

         * Add a new message

         * 

         * @param message

         */

        public void update(String message) {

                ChangeEvent evt = new ChangeEvent(message);

                update(evt);

        }

        /**

         * Add new event

         * 

         * @param e

         */

        public void stateChanged(ChangeEvent e) {

                update(e);

        }

        /**

         * Delete all listeners

         */

        public void clearConsoleInfo() {

                listeners.clear();

        }

        /**

         * This method loads the names of the new fields and his position

         */

        @SuppressWarnings("unchecked")

        protected void loadNamesNewFields() {

                int co = pattern.getElements().size();

                ArrayList eles = new ArrayList();

                ArrayList pos = new ArrayList();

                for (int i = 0; i < co; i++) {

                        Element ade = (Element) pattern.getElements().get(i);

                        if (ade.getImportfield()) {

                                eles.add(ade.getFieldname());

                                pos.add(new Integer(i));

                        }

                }

                int cou = eles.size();

                nameNewFields = new String[cou];

                posNameNewFields = new int[cou];

                String aux;

                int auxint;

                for (int i = 0; i < cou; i++) {

                        aux = (String) eles.get(i);

                        auxint = ((Integer) pos.get(i)).intValue();

                        nameNewFields[i] = aux;

                        posNameNewFields[i] = auxint;

                }

        }

        /**

         * This method gets the Date format of a field from pattern

         * 

         * @param posi

         * @return date formatted

         */

        protected String getDateFormat(int posi) {

                String format = "";

                Element adres = (Element) pattern.getElements().get(posi);

                format = adres.getFieldtype().getDatevalue().getDatevalueformat();

                return format;

        }

        /**

         * This method gets the field type from the pattern

         * 

         * @param adr

         * @return field description

         */

        protected FieldDescription readAddressNormPattern(Element adr) {

                FieldDescription fd = new FieldDescription();

                // Field Name and Field Alias

                fd.setFieldName(adr.getFieldname());

                fd.setFieldAlias(adr.getFieldname());

                // Field Type and particular width, precision

                Fieldtype nft = adr.getFieldtype();

                // Field type (STRING)

                if (((Stringvalue) nft.getStringvalue()) != null) {

                        fd.setFieldType(Types.VARCHAR);

                        Stringvalue strVal = ((Stringvalue) nft.getStringvalue());

                        fd.setFieldLength(strVal.getStringvaluewidth());

                }

                // Field type (DATE)

                if (((Datevalue) nft.getDatevalue()) != null) {

                        fd.setFieldType(Types.DATE);

                        Datevalue dateVal = ((Datevalue) nft.getDatevalue());

                        dateVal.getDatevalueformat().trim().length();

                        fd.setFieldLength(dateVal.getDatevalueformat().trim().length());

                }

                // Field type (INTEGER)

                if (((Integervalue) nft.getIntegervalue()) != null) {

                        fd.setFieldType(Types.INTEGER);

                        Integervalue intVal = ((Integervalue) nft.getIntegervalue());

                        fd.setFieldLength(intVal.getIntegervaluewidth());

                }

                // Field type (DOUBLE)

                if (((Decimalvalue) nft.getDecimalvalue()) != null) {

                        fd.setFieldType(Types.DOUBLE);

                        Decimalvalue decVal = ((Decimalvalue) nft.getDecimalvalue());

                        fd.setFieldLength(decVal.getDecimalvalueint());

                        fd.setFieldDecimalCount(decVal.getDecimalvaluedec());

                }

                return fd;

        }

        protected Value createValue(int row, int tipoCampo, int posi, String cadena) {

                Value val = ValueFactory.createNullValue();

                // DATE

                if (tipoCampo == Types.DATE) {

                        try {

                                String format = getDateFormat(posi);

                                val = formatDates(cadena, format);

                                return val;

                        } catch (Exception e) {

                                val = ValueFactory.createNullValue();

                                update("ERROR.errorformattingdaterow." + (row + 1));

                        }

                }

                // Integer

                if (tipoCampo == Types.INTEGER) {

                        try {

                                val = ValueFactory.createValueByType(cadena, tipoCampo);

                                return val;

                        } catch (Exception e) {

                                val = ValueFactory.createNullValue();

                                update("ERROR.errorformattingintegerrow." + (row + 1));

                        }

                }

                // Decimal

                if (tipoCampo == Types.DOUBLE) {

                        try {

                                val = ValueFactory.createValueByType(cadena, tipoCampo);

                                return val;

                        } catch (Exception e) {

                                val = ValueFactory.createNullValue();

                                update("ERROR.errorformattingdecimalrow." + (row + 1));

                        }

                }

                // String

                if (tipoCampo == Types.VARCHAR) {

                        try {

                                val = ValueFactory.createValueByType(cadena, tipoCampo);

                                return val;

                        } catch (Exception e) {

                                val = ValueFactory.createNullValue();

                                update("ERROR.errorformattingstringrow." + (row + 1));

                        }

                }

                return val;

        }

}