EDIT

import eu.etaxonomy.cdm.model.name.NameRelationshipType;

import eu.etaxonomy.cdm.model.name.Rank;

import eu.etaxonomy.cdm.model.name.SpecimenTypeDesignationStatus;

import eu.etaxonomy.cdm.model.name.TypeDesignationBase;

import eu.etaxonomy.cdm.model.name.TypeDesignationStatusBase;

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

 */

@Repository

@Qualifier("taxonNameDaoHibernateImpl")

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

    private IHomotypicalGroupDao homotypicalGroupDao;

    public TaxonNameDaoHibernateImpl() {

        indexedClasses = new Class[1];

    }

    @Override

    @Override

    public int countNames(String queryString) {

        checkNotInPriorView("TaxonNameDaoHibernateImpl.countNames(String queryString)");

        if (queryString != null) {

            criteria.add(Restrictions.ilike("nameCache", queryString));

    public int countNames(String genusOrUninomial, String infraGenericEpithet,	String specificEpithet, String infraSpecificEpithet, Rank rank) {

        AuditEvent auditEvent = getAuditEventFromContext();

        if(auditEvent.equals(AuditEvent.CURRENT_VIEW)) {

            /**

             * Given HHH-2951 - "Restrictions.eq when passed null, should create a NullRestriction"

            criteria.setProjection(Projections.rowCount());

            return ((Number)criteria.uniqueResult()).intValue();

        } else {

            if(genusOrUninomial != null) {

                query.add(AuditEntity.property("genusOrUninomial").eq(genusOrUninomial));

    }

    @Override

        AuditEvent auditEvent = getAuditEventFromContext();

        if(auditEvent.equals(AuditEvent.CURRENT_VIEW)) {

    @Override

        Query query = null;

        if(status == null) {

            query = getSession().createQuery("select count(designation) from TypeDesignationBase designation join designation.typifiedNames name where name = :name");

    }

    @Override

            NameRelationshipType type, Integer pageSize, Integer pageNumber, List<OrderHint> orderHints,

            List<String> propertyPaths) {

    }

    @Override

        return getTypeDesignations(name, null, status, pageSize, pageNumber, propertyPaths);

    }

    @Override

                Class<T> type,

                TypeDesignationStatusBase status, Integer pageSize, Integer pageNumber,

                List<String> propertyPaths){

        Query query = null;

        String queryString = "select designation from TypeDesignationBase designation join designation.typifiedNames name where name = :name";

    }

        checkNotInPriorView("TaxonNameDaoHibernateImpl.searchNames(String queryString, Integer pageSize, Integer pageNumber)");

        if (queryString != null) {

            criteria.add(Restrictions.ilike("nameCache", queryString));

                criteria.setFirstResult(0);

            }

        }

        return results;

    }

    @Override

        return searchNames(queryString, MatchMode.BEGINNING, pageSize, pageNumber);

    }

    @Override

            List<String> propertyPaths) {

        AuditEvent auditEvent = getAuditEventFromContext();

        if(auditEvent.equals(AuditEvent.CURRENT_VIEW)) {

            /**

             * Given HHH-2951 - "Restrictions.eq when passed null, should create a NullRestriction"

            addOrder(criteria, orderHints);

            defaultBeanInitializer.initializeAll(results, propertyPaths);

            return results;

        } else {

            if(genusOrUninomial != null) {

                query.add(AuditEntity.property("genusOrUninomial").eq(genusOrUninomial));

                }

            }

            defaultBeanInitializer.initializeAll(results, propertyPaths);

            return results;

        }

    }

    @Override

            String queryString, MatchMode matchmode, Integer pageSize,

            Integer pageNumber, List<Criterion> criteria, List<String> propertyPaths) {

        }

        @SuppressWarnings("unchecked")

        defaultBeanInitializer.initializeAll(results, propertyPaths);

        return results;

    }

    @Override

            MatchMode matchmode, Integer pageSize, Integer pageNumber, List<Criterion> criteria, List<String> propertyPaths) {

        Criteria crit = getSession().createCriteria(type);

            }

        }

        defaultBeanInitializer.initializeAll(results, propertyPaths);

        return results;

    @Override

        Criteria crit = getSession().createCriteria(type);

        }

        crit.addOrder(Order.asc("uuid"));

        if (results.size() == 1) {

            defaultBeanInitializer.initializeAll(results, propertyPaths);

            return taxonName;

        } else if (results.size() > 1) {

            logger.error("Multiple results for UUID: " + uuid);

    public Integer countByName(String queryString, MatchMode matchmode, List<Criterion> criteria) {

        //TODO improve performance

        boolean includeAuthors = false;

                includeAuthors,queryString, matchmode, null, null, criteria, null);

        return results.size();

    @Override

    public List<UuidAndTitleCache> getUuidAndTitleCacheOfNames(Integer limit, String pattern) {

        @SuppressWarnings("unchecked")

        List<Object[]> result = getSession().createSQLQuery(queryString).list();

    }

    @Override

        return super.countByParam(clazz, "nameCache", queryString, matchmode, criteria);

    }

    @Override

        return super.findByParam(clazz, "nameCache", queryString, matchmode, criteria, pageSize, pageNumber, orderHints, propertyPaths);

    }

    @Override

        Set<TaxonBase> taxonBases = persistentObject.getTaxonBases();

        if (persistentObject == null){

        }

        @SuppressWarnings("unchecked")

        if (results.size() == 1) {

            defaultBeanInitializer.initializeAll(results, null);

            if (taxonName.isZoological()) {

                IZoologicalName zoologicalName = taxonName;

                return zoologicalName;

    	String sql= "SELECT"

    			+ "  (SELECT famName.namecache FROM TaxonNode famNode"

    			+ "  LEFT OUTER JOIN TaxonBase famTax ON famNode.taxon_id = famTax.id"

    			+ " WHERE famName.rank_id = 795 AND famNode.treeIndex = SUBSTRING(tn.treeIndex, 1, length(famNode.treeIndex))"

    			+ "	) as famName, "

    			+ " (SELECT famName.namecache FROM TaxonNode famNode "

    			+ " LEFT OUTER JOIN TaxonBase famTax ON famNode.taxon_id = famTax.id "

    			+ " WHERE famName.rank_id = 795 AND famNode.treeIndex = SUBSTRING(tnAcc.treeIndex, 1, length(famNode.treeIndex))"

    			+ "	) as accFamName,tb.DTYPE, tb.id as TaxonID ,tb.titleCache taxonTitle,  tnb.rank_id as RankID, tnb.id as NameID,"

    			+ " tnb.namecache as name, tnb.titleCache as nameAuthor, tnb.fullTitleCache nameAndNomRef,"

    			+ "	r.titleCache as nomRef, r.abbrevTitle nomRefAbbrevTitle, r.title nomRefTitle, r.datepublished_start nomRefPublishedStart, r.datepublished_end nomRefPublishedEnd, r.pages nomRefPages, inRef.abbrevTitle inRefAbbrevTitle,tnb.nomenclaturalmicroreference as detail,"

    			+ "	nameType.namecache nameType, nameType.titleCache nameTypeAuthor, nameType.fullTitleCache nameTypeFullTitle, nameTypeRef.titleCache nameTypeRef, inRef.seriespart as inRefSeries, inRef.datepublished_start inRefPublishedStart, inRef.datepublished_end inRefPublishedEnd, inRef.volume as inRefVolume"

    			+ " FROM TaxonBase tb"

    			+ "	LEFT OUTER JOIN Reference r ON tnb.nomenclaturalreference_id = r.id"

    			+ "	LEFT OUTER JOIN TaxonNode tn ON tn.taxon_id = tb.id"

    			+ " LEFT OUTER JOIN TypeDesignationBase tdb ON tdb.id = typeMN.typedesignations_id"

    			+ "	LEFT OUTER JOIN Reference nameTypeRef ON nameType.nomenclaturalreference_id = nameTypeRef.id"

    			+ "		LEFT OUTER JOIN Reference inRef ON inRef.id = r.inreference_id"

    			+ "	LEFT OUTER JOIN TaxonBase accT ON accT.id = tb.acceptedTaxon_id"