EDIT

/**

* Copyright (C) 2017 EDIT

* European Distributed Institute of Taxonomy

* http://www.e-taxonomy.eu

*

* 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.persistence.dao.hibernate.name;

import java.util.Collection;

import java.util.Collections;

import java.util.List;

import java.util.Optional;

import org.apache.log4j.Logger;

import org.hibernate.Query;

import org.springframework.stereotype.Repository;

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

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

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

import eu.etaxonomy.cdm.persistence.dao.hibernate.common.AnnotatableDaoImpl;

import eu.etaxonomy.cdm.persistence.dao.name.IRegistrationDao;

/**

 * @author a.kohlbecker

 * @since May 2, 2017

 *

 */

@Repository

public class RegistrationDaoHibernateImpl

            extends AnnotatableDaoImpl<Registration>

            implements IRegistrationDao {

    @SuppressWarnings("unused")

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

    /**

     * @param type

     */

    public RegistrationDaoHibernateImpl() {

        super(Registration.class);

    }

    /**

     * {@inheritDoc}

     */

    @Override

    public Long count(Optional<Reference> reference, Collection<RegistrationStatus> includedStatus) {

        //return 0 for detached volatile references

        if (isVolatile(reference)){

            return Long.valueOf(0);

        }

        Query query = makeReferenceQuery(reference, includedStatus, true);

        @SuppressWarnings("unchecked")

        List<Long> list = query.list();

        return list.isEmpty()? Long.valueOf(0) : list.get(0);

    }

    /**

     * {@inheritDoc}

     */

    @Override

    public List<Registration> list(Optional<Reference> reference, Collection<RegistrationStatus> includedStatus,

            Integer limit, Integer start, List<String> propertyPaths) {

        if (isVolatile(reference)){

            return Collections.emptyList();

        }

        Query query = makeReferenceQuery(reference, includedStatus, false);

        // TODO complete ....

        if(limit != null /*&&  !doCount*/) {

            query.setMaxResults(limit);

            if(start != null) {

                query.setFirstResult(start);

            }

        }

        //TODO order hints do not work with queries

        @SuppressWarnings("unchecked")

        List<Registration> results = query.list();

        defaultBeanInitializer.initializeAll(results, propertyPaths);

        return results;

    }

    /**

     * @param reference

     * @return

     */

    private boolean isVolatile(Optional<Reference> reference) {

        return reference != null && reference.isPresent() && reference.get().getId() == 0;

    }

    /**

     * @param reference

     * @param includedStatus

     * @param isCount

     * @return

     */

    private Query makeReferenceQuery(Optional<Reference> reference,

            Collection<RegistrationStatus> includedStatus,

            boolean isCount) {

        String select = "SELECT " + (isCount? " count(DISTINCT r) as cn ": "DISTINCT r ");

        String from = " FROM Registration r LEFT JOIN r.typeDesignations desig "

                + "     LEFT JOIN r.name n ";

        String where = " WHERE (1=1) ";

        String orderBy = isCount ? "" : " ORDER BY r.id ";

        if (reference == null){

            //do nothing

        }else if (reference.isPresent()){

           where += " AND ((n IS NOT NULL AND n.nomenclaturalReference =:ref)"

                    + "     OR desig.citation =:ref "

                    + ")";

        }else{  //ref is null

            where += " AND ((r.name IS NULL AND size(r.typeDesignations) = 0 ) "

                    + "     OR (n IS NOT NULL AND r.name.nomenclaturalReference IS NULL ) "

                    + "     OR (size(r.typeDesignations) > 0 AND desig.citation IS NULL )"

                    + ") "

                    ;

        }

        boolean hasStatus = includedStatus != null && !includedStatus.isEmpty();

        if (hasStatus){

            where += " AND r.status IN (:status) ";

        }

        String hql = select + from + where + orderBy;

        Query query = getSession().createQuery(hql);

        if (reference != null && reference.isPresent()){

            query.setParameter("ref", reference.get());

        }

        if (hasStatus){

            query.setParameterList("status", includedStatus);

        }

        return query;

    }

}