EDIT

/**

* Copyright (C) 2007 EDIT

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.app.cyprus;

import java.io.FileNotFoundException;

import java.net.URI;

import java.net.URISyntaxException;

import java.util.HashSet;

import java.util.UUID;

import org.apache.commons.lang.StringUtils;

import org.apache.log4j.Logger;

import org.springframework.transaction.TransactionStatus;

import eu.etaxonomy.cdm.api.application.CdmApplicationController;

import eu.etaxonomy.cdm.app.common.CdmDestinations;

import eu.etaxonomy.cdm.common.ExcelUtils;

import eu.etaxonomy.cdm.database.DbSchemaValidation;

import eu.etaxonomy.cdm.database.ICdmDataSource;

import eu.etaxonomy.cdm.io.api.application.CdmIoApplicationController;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;

import eu.etaxonomy.cdm.model.common.CdmBase;

import eu.etaxonomy.cdm.model.description.Feature;

import eu.etaxonomy.cdm.model.description.MeasurementUnit;

import eu.etaxonomy.cdm.model.description.QuantitativeData;

import eu.etaxonomy.cdm.model.description.StatisticalMeasure;

import eu.etaxonomy.cdm.model.description.StatisticalMeasurementValue;

import eu.etaxonomy.cdm.model.description.TaxonDescription;

import eu.etaxonomy.cdm.model.reference.ReferenceFactory;

import eu.etaxonomy.cdm.model.taxon.Synonym;

import eu.etaxonomy.cdm.model.taxon.Taxon;

import eu.etaxonomy.cdm.model.taxon.TaxonBase;

/**

 * @author a.mueller

public class CyprusAltitudeActivator {

	private static final Logger logger = Logger.getLogger(CyprusAltitudeActivator.class);

	static DbSchemaValidation hbm2dll = DbSchemaValidation.VALIDATE;

	static final URI source = cyprus_altitude();

//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql_test();

//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_dev();

	public static final UUID featureTreeUuid = UUID.fromString("14d1e912-5ec2-4d10-878b-828788b70a87");

	static final UUID classificationUuid = UUID.fromString("0c2b5d25-7b15-4401-8b51-dd4be0ee5cab");

	static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;

			excel = ExcelUtils.parseXLS(source, "coreTax");

		} catch (FileNotFoundException e) {

			e.printStackTrace();

			return;

		}

		UUID uuidMikle85 = UUID.fromString("994403c4-c400-413d-9a1a-8531a40bfd8c");

		Reference mikle77 = app.getReferenceService().find(uuidMikle77);

		Reference mikle85 = app.getReferenceService().find(uuidMikle85);

		if (altitudeFeature == null){

			UUID baseUuid = makeUuid(row, "uuid");

			UUID acceptedUuid = makeUuid(row, "acceptedNameUuid");

			UUID parentUuid = makeUuid(row, "parentUuid");

			String altitudeMax = row.get("Max");

			String acceptedName = row.get("AcceptedName");

			}

				TaxonDescription desc = getDescription(taxon, sourceRef);

					if(desc.getTaxon() == null){

						taxon.addDescription(desc);

					}

					taxaToSave.add(taxon);

					logger.warn("HasALtitude is false in " + count);

			}else{

				logger.warn("Taxon not recognized in line " + count);

			}

		}

		app.getTaxonService().saveOrUpdate(taxaToSave);

	}

	private Taxon getTaxon(CdmApplicationController app, UUID baseUuid, UUID acceptedUuid, UUID parentUuid, String acceptedName, int row) {

		if (base.isInstanceOf(Taxon.class)){

			Taxon t = CdmBase.deproxy(base, Taxon.class);

			if (t.getTaxonNodes().size() == 1 && t.getTaxonNodes().iterator().next().getClassification().getUuid().equals(classificationUuid)){

				result = t;

			}else{

				logger.warn("Base taxon (uuid) not in classification. Row: " + row +  ", Taxon: " + base.getTitleCache());

			}

		}

		if (result == null){

			TaxonBase<?> accepted = app.getTaxonService().find(acceptedUuid);

			Taxon t = CdmBase.deproxy(accepted, Taxon.class);;

			if (t.getTaxonNodes().size() == 1 && t.getTaxonNodes().iterator().next().getClassification().getUuid().equals(classificationUuid)){

				if (hasSynonym(t, base)){

					result = t;

				}else{

					logger.warn("Synonym relation has changed somehow. Row: " + row +  ", Taxon: " + base.getTitleCache());

				}

				logger.warn("Accepted taxon not in classification. Row: " + row +  ", Taxon: " + base.getTitleCache());

			}

		}

			if (! result.getName().getTitleCache().equals(acceptedName)){

				logger.warn("AcceptedName and taxon name is not equal in " + row + ".\n" +

						" Accepted Name: " + acceptedName + ";\n" +

						" Taxon    Name: " + result.getName().getTitleCache());

			}

		}

	}

	private boolean hasSynonym(Taxon t, TaxonBase<?> base) {

		if (base.isInstanceOf(Synonym.class)){

				if (syn.equals(base)){

				}

			}

		}

		return false;

	}

			Reference sourceRef, TaxonDescription desc, MeasurementUnit meter, int row) {

		if (source != null){

		}

		data.setUnit(meter);

		StatisticalMeasurementValue minValue = StatisticalMeasurementValue.NewInstance(StatisticalMeasure.MIN(), min);

		data.addStatisticalValue(minValue);

		Integer max = Integer.valueOf(altitudeMax);

		StatisticalMeasurementValue maxValue = StatisticalMeasurementValue.NewInstance(StatisticalMeasure.MAX(), max);

		data.addStatisticalValue(maxValue);

		return true;

	}

	private TaxonDescription getDescription(Taxon taxon, Reference sourceRef) {

			//TODO Mikle existiert derzeit nicht also Source

			desc.setTitleCache("Import from " + getSourceReference().getTitleCache(), true);

			desc.addSource(OriginalSourceType.PrimaryTaxonomicSource, null, null, sourceRef,null);

			desc.addSource(OriginalSourceType.Import, null, null, getSourceReference(), null);

		}

		return null;

	}

			if (source.equals("Meikle 1977")){

				return m77;

			}else if (source.equals("Meikle 1985")){

				return m85;

			}else{

				logger.warn("Source not recognized: " + source);

			}

		}

		return null;

	}

	/**

	 * @param row

	 * @return

	 */

			return null;

		}else{

			return UUID.fromString(row.get(colName));

		}

	}

	private Reference getSourceReference() {

			sourceReference = ReferenceFactory.newGeneric();

			sourceReference.setTitleCache(sourceReferenceTitle, true);

		}

		return sourceReference;

	//Cyprus

	public static URI cyprus_altitude() {

		URI sourceUrl;

		try {

//			sourceUrl = new URI("file:/F:/data/cyprus/Zypern-Altitude.xls");

		} catch (URISyntaxException e) {

			e.printStackTrace();

			return null;

		}

	}

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		CyprusAltitudeActivator me = new CyprusAltitudeActivator();

		me.doImport(cdmDestination);

	}