/*
* Copyright (c) 2009-2012 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.mappers.db;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.persistence.Query;
import org.eurekastreams.server.persistence.mappers.BaseArgDomainMapper;
/**
* DB mapper to get all of the interests.
*/
public class GetSkillsAndInterestsByEmployeeIdsDbMapper extends
BaseArgDomainMapper<Collection<Long>, Map<Long, List<String>>>
{
/**
* @see org.eurekastreams.server.persistence.mappers.DomainMapper#execute(java.lang.Object)
* @param inPersonIds
* person ids to search for skills and interests
* @return a map of PersonID -> skills & interests
*/
@Override
public Map<Long, List<String>> execute(final Collection<Long> inPersonIds)
{
Map<Long, List<String>> map = new HashMap<Long, List<String>>();
Query q = getEntityManager().createQuery(
"SELECT p.id, bgi.name FROM BackgroundItem bgi, Person p, PersonBackgroundItemSkill skill "
+ "WHERE bgi MEMBER OF p.background.skills AND p.id IN (:personIds) "
+ "and skill.pk.backgroundItemId = bgi.id and skill.pk.backgroundId = p.background.id "
+ "ORDER BY skill.pk.sortIndex").setParameter("personIds", inPersonIds);
List<Object[]> results = q.getResultList();
for (Object[] interestData : results)
{
Long personId = (Long) interestData[0];
String interest = (String) interestData[1];
List<String> interests;
if (map.containsKey(personId))
{
interests = map.get(personId);
}
else
{
interests = new ArrayList<String>();
map.put(personId, interests);
}
interests.add(interest);
}
return map;
}
}