/** * Most of the code in the Qalingo project is copyrighted Hoteia and licensed * under the Apache License Version 2.0 (release version 0.8.0) * http://www.apache.org/licenses/LICENSE-2.0 * * Copyright (c) Hoteia, 2012-2014 * http://www.hoteia.com - http://twitter.com/hoteia - contact@hoteia.com * */ package org.hoteia.qalingo.core.dao; import java.util.ArrayList; import java.util.List; import org.hibernate.Criteria; import org.hibernate.criterion.Order; import org.hibernate.criterion.Restrictions; import org.hoteia.qalingo.core.domain.Localization; import org.hoteia.qalingo.core.domain.MarketArea; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Repository; @Repository("localizationDao") public class LocalizationDao extends AbstractGenericDao { private final Logger logger = LoggerFactory.getLogger(getClass()); public Localization getLocalizationById(final Long localizationId, Object... params) { Criteria criteria = createDefaultCriteria(Localization.class); criteria.add(Restrictions.eq("id", localizationId)); Localization localization = (Localization) criteria.uniqueResult(); return localization; } public Localization getLocalizationByCode(final String code, Object... params) { Criteria criteria = createDefaultCriteria(Localization.class); criteria.add(Restrictions.eq("code", handleCodeValue(code))); Localization localization = (Localization) criteria.uniqueResult(); return localization; } public Localization getDefaultLocalizationByCountryCode(final String countryCode, Object... params) { Criteria criteria = createDefaultCriteria(Localization.class); criteria.add(Restrictions.eq("country", handleCodeValue(countryCode))); criteria.add(Restrictions.eq("isDefault", true)); Localization localization = (Localization) criteria.uniqueResult(); return localization; } public List<Localization> getLocalizationByCountryCode(final String countryCode, Object... params) { Criteria criteria = createDefaultCriteria(Localization.class); criteria.add(Restrictions.eq("country", handleCodeValue(countryCode))); @SuppressWarnings("unchecked") List<Localization> localizations = criteria.list(); return localizations; } public List<Localization> findLocalizations(Object... params) { Criteria criteria = createDefaultCriteria(Localization.class); criteria.addOrder(Order.asc("language")); @SuppressWarnings("unchecked") List<Localization> localizations = criteria.list(); return localizations; } public List<Localization> findActiveLocalizations(Object... params) { Criteria criteria = createDefaultCriteria(Localization.class); criteria.add(Restrictions.eq("active", true)); criteria.addOrder(Order.asc("language")); @SuppressWarnings("unchecked") List<Localization> localizations = criteria.list(); return localizations; } public List<Localization> findLocalizationsByMarketAreaCode(final String marketAreaCode, Object... params) { Criteria criteria = createDefaultCriteria(MarketArea.class); criteria.add(Restrictions.eq("code", handleCodeValue(marketAreaCode))); MarketArea marketArea = (MarketArea) criteria.uniqueResult(); List<Localization> localizations = new ArrayList<Localization>(marketArea.getLocalizations()); return localizations; } public Localization saveOrUpdateLocalization(Localization localization) { if (localization.getId() != null) { if(em.contains(localization)){ em.refresh(localization); } Localization mergedLocalization = em.merge(localization); em.flush(); return mergedLocalization; } else { em.persist(localization); return localization; } } public void deleteLocalization(Localization localization) { em.remove(em.contains(localization) ? localization : em.merge(localization)); } }