EDIT

* The contents of this file are subject to the Mozilla Public License Version 1.1

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

*/

package eu.etaxonomy.cdm.io.eflora.centralAfrica.ferns;

import java.sql.ResultSet;

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

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

/**

 * @author a.mueller

 */

@Component

	private static final String pluralString = "taxon relations";

	private static final String dbTableName = "[African pteridophytes]";

	private static final Class<?> cdmTargetClass = TaxonBase.class;

	public CentralAfricaFernsTaxonRelationImport(){

		super(pluralString, dbTableName, cdmTargetClass);

	}

	@Override

	protected String getIdQuery() {

		String strQuery = " SELECT [Taxon number] FROM " + dbTableName;;

		return mapping;

	}

	@Override

	protected String getRecordQuery(CentralAfricaFernsImportConfigurator config) {

		String strSelect = " SELECT * ";

		return strRecordQuery;

	}

	@Override

	protected void doInvoke(CentralAfricaFernsImportState state) {

		fillTaxonMap();

		super.doInvoke(state);

		return;

	}

	/**

	 * Fills the nameCache and the titleCache maps. The maps are used to find existing taxa

	 * by titleCache or nameCache matching.

		}

	}

	@Override

	public Map<Object, Map<String, ? extends CdmBase>> getRelatedObjectsForPartition(ResultSet rs, CentralAfricaFernsImportState state) {

		String nameSpace;

			Map<String, TaxonBase> taxonMap = getCommonService().getSourcedObjectsByIdInSourceC((Class<TaxonBase>) cdmClass, taxonIdSet, nameSpace);

			result.put(nameSpace, taxonMap);

			//reference map

			this.sourceReference = getFernsSourceReference(state);

//			nameSpace = "Reference";

		return result;

	}

	@Override

	public TaxonBase createObject(ResultSet rs, CentralAfricaFernsImportState state) throws SQLException {

		TaxonBase<?> result = null;

			e.printStackTrace();

			return result;

		}

	}

	/**

	 * Class to store all epithets of the database record. Maybe extended with business logic.

	 */

		private String subFormaName;

	}

	/**

	 * Handles records with status synonym. The synonym is attached to the accepted taxon.

	 */

	private Synonym handleSynonym(ResultSet rs, CentralAfricaFernsImportState state) throws SQLException {

		String accTaxonId = rs.getString("Current");

				Taxon taxon = CdmBase.deproxy(taxonBase, Taxon.class);

				taxon.addSynonym(synonym, SynonymType.SYNONYM_OF());

				if ("p.p.".equalsIgnoreCase(nomRemarksString)){

				}

			}else{

				logger.warn("Accepted taxon (" + accTaxonId + ") for synonym (" + synonymId +") is not of type 'Current'");

	/**

	 * Handles all records with status 'current'. Creates parent-child relationships to the

	 * higher taxa. Uses a complex algorithm to reuse existing higher taxa.

	 */

	private Taxon handleTaxon(ResultSet rs, CentralAfricaFernsImportState state) throws SQLException {

		String taxonNumber = rs.getString("Taxon number");

	/**

	 * Handles the case when the database record has data for a taxon of a higher rank

	 * than the <code>child</code> taxon's rank.

	 */

	private void handleHigherTaxonMustExist(CentralAfricaFernsImportState state, ResultSet rs, Taxon child, Epithets epithets, Taxon constructedHigherTaxon, Reference citation, String microCitation) throws SQLException {

		Taxon parentTaxon = getParent(child);

	/**

	 * Merges author information of the constructed taxon into the existing taxon.

	 * Returns the existing taxon.

	 */

	private Taxon mergeExistingAndConstructedTaxon(CentralAfricaFernsImportState state, Taxon existingTaxon, Taxon constructedTaxon) {

		INonViralName constructedName = constructedTaxon.getName();

		return constructedHigherTaxon;

	}

	/**

	 * Handles the case that the existing parent taxon and the constructed parent taxon

	 * have a diffent rank. Returns the constructedHigherTaxon if no common grand parent exists.

	/**

	 * Checks if a taxon is a grand parent of another taxon

	 */

	private Taxon checkIsGrandParent(Taxon childTaxon, Taxon grandParentTaxon) {

		IBotanicalName lowerName = childTaxon.getName();

		}

	}

	/**

	 * Checks if the name caches match.

	 */

	private boolean nameCachesMatch(IBotanicalName name1, IBotanicalName name2) {

		return CdmUtils.nullSafeEqual(name1.getNameCache(), name2.getNameCache());

	/**

	 * Checks if the name caches of the related names match.

	 */

	private boolean nameCachesMatch(Taxon taxon1, Taxon taxon2) {

		IBotanicalName name1 = taxon1.getName();

	/**

	 * Checks if all authors match

	 */

	private boolean authorsMatch(INonViralName name1, INonViralName name2) {

		String combinationAuthor1 = name1.computeCombinationAuthorNomenclaturalTitle();

	/**

	 * Checks if all authors of the related names match.

	 */

	private boolean authorsMatch(Taxon taxon1, Taxon taxon2) {

		IBotanicalName name1 = taxon1.getName();

	/**

	 * Compares ranks of 2 names.

	 */

	private int compareRanks(IBotanicalName name1, IBotanicalName name2) {

		return name1.getRank().compareTo(name2.getRank());

	/**

	 * Compares the ranks of the according names.

	 */

	private int compareRanks(Taxon taxon1, Taxon taxon2) {

		IBotanicalName name1 = taxon1.getName();

	/**

	 * Checks if 2 names match.

	 * Current strategy: true, if ranks are equal, nameCaches match and authors match

	 */

	private boolean namesMatch(IBotanicalName name1, IBotanicalName name2) {

		return compareRanks(name1, name2)==0 && nameCachesMatch(name1, name2) && authorsMatch(name1, name2);

	/**

	 * Checks if the according names match.

	 * @see #namesMatch(BotanicalName, BotanicalName)

	 */

	private boolean namesMatch(Taxon taxon1, Taxon taxon2) {

		IBotanicalName name1 = taxon1.getName();

		}

	}

	/**

	 * Persists and saves the newly created taxon to the CDM store and to the look-up

	 * maps.

	/**

	 * Adds the parent child relationship. Creates and saves the classification if needed.

	 * Adds parent and child to the classification.

	 */

	private boolean makeTaxonomicallyIncluded(CentralAfricaFernsImportState state, Integer treeRefFk, Taxon child, Taxon parent, Reference citation, String microCitation){

		String treeKey;

		return taxonName;

	}

	private IBotanicalName handleUninomial(Rank lowerTaxonRank, IBotanicalName taxonName,  Epithets epithets) {

		Rank newRank = null;

		return taxonName;

	}

	/**

	 * for internal use only, used by MethodMapper

	 */

		return taxonBase;

	}

	/**

	 * for internal use only, used by MethodMapper

	 */

		}

	}

	/**

	 * for internal use only, used by MethodMapper

	 * @param commonNames

		return taxonBase;

	}

	private void makeDistributionDetailed(Taxon taxon, String distributionDetailed) {

		if (StringUtils.isNotBlank(distributionDetailed)){

			TaxonDescription description = getTaxonDescription(taxon, false, true);

		}

	}

	private void makeProvince(Taxon taxon, String province) {

		if (StringUtils.isNotBlank(province)){

			TaxonDescription description = getTaxonDescription(taxon, false, true);

		}

	}

	private void makeCountries(CentralAfricaFernsImportState state, String taxonNumber, Taxon taxon, TaxonName nameUsedInSource, String countriesString, String province, String distributionDetailed) {

		countriesString = countriesString.replaceAll("\\*", "");

		countriesString = countriesString.replace("  ", " ");

		}

	}

	private void makeSingleCountry(CentralAfricaFernsImportState state, String taxonNumber, Taxon taxon, TaxonName nameUsedInSource, String country) throws UndefinedTransformerMethodException {

		boolean areaDoubtful = false;

		Distribution distribution = Distribution.NewInstance(null, PresenceAbsenceTerm.PRESENT());

			country = country.replace("Islands", "Is.");

		}

		//areas

		if (TdwgAreaProvider.isTdwgAreaLabel(country)){

			//tdwg

		description.addElement(distribution);

	}

	private Reference sourceReference = null;

	private Reference getFernsSourceReference(CentralAfricaFernsImportState state) {

//		if (sourceReference == null || true){

		return sourceReference;

	}

	private String makeCountryBrackets(CentralAfricaFernsImportState state, String taxonNumber, Taxon taxon,

	        TaxonName nameUsedInSource, String country) {

		String[] split = (country + " ").split("\\(.*\\)");

		return country;

	}

	@Override

	protected boolean doCheck(CentralAfricaFernsImportState state){

		IOValidator<CentralAfricaFernsImportState> validator = new CentralAfricaFernsTaxonImportValidator();

		return validator.validate(state);

	}

	@Override

	protected boolean isIgnore(CentralAfricaFernsImportState state){

		return ! state.getConfig().isDoRelTaxa();

	}

//************************ OLD **********************************************************

	/**

		}

	}

	/**

	 * Tests if this the child taxon already is a child of the higher taxon.

	 */

	private boolean includedRelationshipExists_Old(Taxon child, Taxon higherTaxon) {

		int countNodes = higherTaxon.getTaxonNodes().size();

		}

	}

	private boolean childExists_old(Taxon child, TaxonNode higherNode) {

		for (TaxonNode childNode : higherNode.getChildNodes()){

			String existingChildTitle = childNode.getTaxon().getName().getTitleCache();

		}

		return false;

	}