/*
* Copyright (c) 2009-2010 Lockheed Martin Corporation
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.eurekastreams.server.persistence;
import java.util.List;
import javax.persistence.Query;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.eurekastreams.commons.hibernate.QueryOptimizer;
import org.eurekastreams.server.domain.Job;
/**
* This class provides the mapper functionality for Job entities.
*/
public class JobMapper extends DomainEntityMapper<Job>
{
/**
* Local log instance.
*/
private static Log logger = LogFactory.getLog(JobMapper.class);
/**
* The person mapper.
*/
private PersonMapper personMapper;
/**
* Constructor.
*
* @param inQueryOptimizer
* the QueryOptimizer to use for specialized functions.
*
* @param inPersonMapper
* the person mapper.
*/
public JobMapper(final QueryOptimizer inQueryOptimizer, final PersonMapper inPersonMapper)
{
super(inQueryOptimizer);
personMapper = inPersonMapper;
}
/**
* Get the domain entity name for the generic query operations.
*
* @return the domain entity name for the gadget query operations.
*/
@Override
protected String getDomainEntityName()
{
return "Job";
}
/**
* Find a person's jobs.
*
* @param inOpenSocialId
* Open Social ID of the person
*
* @return list of jobs for the person
*/
@SuppressWarnings("unchecked")
public List<Job> findPersonJobsByOpenSocialId(final String inOpenSocialId)
{
Query q = getEntityManager().createQuery(
"from Job j where j.person.openSocialId = :openSocialId order by j.dateTo DESC, j.dateFrom DESC")
.setParameter("openSocialId", inOpenSocialId);
return q.getResultList();
}
/**
* Find a person's jobs by person id.
*
* @param inId
* ID of the person
*
* @return list of jobs for the person
*/
@SuppressWarnings("unchecked")
public List<Job> findPersonJobsById(final Long inId)
{
Query q = getEntityManager().createQuery(
"from Job j where j.person.id = :id order by j.dateTo DESC, j.dateFrom DESC").setParameter("id", inId);
return q.getResultList();
}
/**
* Delete a person's job.
*
* @param inJobId
* The Job to delete.
*/
public void delete(final long inJobId)
{
Job job = findById(inJobId);
getEntityManager().remove(job);
}
/**
* Look up company names starting with the given prefix.
*
* @param prefix
* the company name prefix to search for
* @param limit
* the maximum number of companies to return
* @return the list of company names
*/
@SuppressWarnings("unchecked")
public List<String> findCompaniesByPrefix(final String prefix, final int limit)
{
String searchParam = prefix.toLowerCase() + "%";
Query query = getEntityManager().createQuery(
"select distinct(companyName) from Job j where lower(j.companyName) like :prefix "
+ "order by companyName");
query.setMaxResults(limit);
query.setParameter("prefix", searchParam);
return query.getResultList();
}
/**
* Look up job titles starting with the given prefix.
*
* @param prefix
* the title prefix to search for
* @param limit
* the maximum number of titles to return
* @return the list of titles
*/
@SuppressWarnings("unchecked")
public List<String> findTitlesByPrefix(final String prefix, final int limit)
{
String searchParam = prefix.toLowerCase() + "%";
Query query = getEntityManager().createQuery(
"select distinct(title) from Job j where lower(j.title) like :prefix "
+ "order by title");
query.setMaxResults(limit);
query.setParameter("prefix", searchParam);
return query.getResultList();
}
/**
* Flushes and updates the index of the person.
*
* @param uuid
* the uuid of the person to update.
*/
public void flush(final String uuid)
{
flush();
getFullTextSession().index(personMapper.findByOpenSocialId(uuid));
}
}