ARAPersonDAOImpl.java

/**
 * 
 */
package org.inbio.m3s.dao.ara.impl;

import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Query;
import org.hibernate.Session;
import org.inbio.m3s.dao.GenericBaseDAOImpl;
import org.inbio.m3s.dao.core.PersonDAO;
import org.inbio.m3s.model.ara.ARAPerson;
import org.inbio.m3s.model.ara.PersonProfile;
import org.inbio.m3s.model.general.Person;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.HibernateTemplate;

/**
 * @author jgutierrez
 *
 */
public class ARAPersonDAOImpl extends GenericBaseDAOImpl<Person,Integer> implements PersonDAO {		
	private static Logger logger = Logger.getLogger(ARAPersonDAOImpl.class);

	private static final String PERSON_PROFILE_CLASS = ""+PersonProfile.class.getCanonicalName();
	public static final Integer IMAGES_PROCESOR_PROFILE_ID = new Integer(12);
	public static final Integer IMAGES_AUTHOR_PROFILE_ID = new Integer(21);
	public static final Integer GATHERING_PROFILE_ID = new Integer(13);
	
		
		@SuppressWarnings("unchecked")
		@Override
		public List<Person> findAll(Class entityClass) {
			HibernateTemplate template = getHibernateTemplate();
			return (List<Person>) template.execute(new HibernateCallback() {
				public Object doInHibernate(Session session) {
					Query query = session.createQuery(
							"select pp.person"
							+ " from "+PERSON_PROFILE_CLASS+" as pp"
							+ " where pp.profile.profileId =" + IMAGES_PROCESOR_PROFILE_ID
							+ " or pp.profile.profileId =" + IMAGES_AUTHOR_PROFILE_ID
							+ " and pp.person.firstName is not null "
							+ " and pp.person.lastName is not null "
							+ " order by pp.person.firstName asc, pp.person.lastName asc");
					//query.setParameter(0, nomenclaturalGroupId);
					query.setCacheable(true);
					return query.list();
				}
			});
		}

		/*
		 * (non-Javadoc)
		 * @see org.inbio.m3s.dao.core.PersonDAO#findAllByPartialNamePaginated(java.lang.String, int)
		 */
		@SuppressWarnings("unchecked")
		public List<Person> findAllByPartialNamePaginated(final String authorName, final int maxResults) {
			logger.debug("findAllByPartialNamePaginated for author name: '" + authorName + "'.");
			HibernateTemplate template = getHibernateTemplate();
			return (List<Person>) template.execute(new HibernateCallback() {
				public Object doInHibernate(Session session) {
					Query query = session.createQuery(
							"select pp.person"
							+ " from "+PERSON_PROFILE_CLASS+" as pp"
							+ " where ( pp.profile.profileId =" + IMAGES_PROCESOR_PROFILE_ID
							+         " or pp.profile.profileId =" + IMAGES_AUTHOR_PROFILE_ID + ")"
							+ " and ( pp.person.firstName is not null "
							+       " and pp.person.lastName is not null )"
							+ " and ( pp.person.firstName like :authorName "
							+       " or pp.person.lastName like :authorName )"
							+ " order by pp.person.firstName asc, pp.person.lastName asc");
					//query.setParameter(0, nomenclaturalGroupId);
					query.setParameter("authorName", authorName);
					query.setFirstResult(0);
					query.setMaxResults(maxResults);				
					query.setCacheable(true);					
					return query.list();
				}
			});
		}
		
		
		public List<Person> findAllGatheringResponsible()
				throws IllegalArgumentException {
			// TODO Auto-generated method stub
			return null;
		}


		public Person findGatheringResposibleById(Integer responsiblePersonId)
				throws IllegalArgumentException {
			// TODO Auto-generated method stub
			return null;
		}
		
		/*
		 * (non-Javadoc)
		 * @see org.inbio.m3s.dao.impl.BaseDAOImpl#create(java.lang.Object)
		 */
		@Override
		public void create(Person person) throws IllegalArgumentException {
			super.create((ARAPerson) person);
		}

		/*
		 * (non-Javadoc)
		 * 
		 * @see org.inbio.m3s.dao.BaseDAO#delete(java.lang.Object)
		 */
		@Override
		public void update(Person person) throws IllegalArgumentException {
			super.update((ARAPerson) person);
		}

		/*
		 * (non-Javadoc)
		 * 
		 * @see org.inbio.m3s.dao.BaseDAO#update(java.lang.Object)
		 */
		@Override
		public void delete(Person person) throws IllegalArgumentException {
			super.delete((ARAPerson) person);
		}
		
		/*
		 * (non-Javadoc)
		 * @see org.inbio.m3s.dao.BaseDAO#findById(java.lang.Class, java.lang.Object)
		 */
		@Override
		public Person findById(Class<Person> entityClass, Integer id) throws IllegalArgumentException {
			HibernateTemplate template = getHibernateTemplate();
			return (Person) template.get(ARAPerson.class, id);
		}
		
}