/* (non-Javadoc)
* @see com.mg.merp.reference.CatalogPriceServiceLocal#findActual(java.util.Date, com.mg.merp.reference.model.Catalog, com.mg.merp.reference.model.Currency)
*/
@PermitAll
public CatalogPrice findActual(Date actualityDate, Catalog catalog, Currency currency) {
DetachedCriteria dc =
DetachedCriteria.forClass(CatalogPrice.class, "cp")
.setProjection(Projections.max("cp.InAction"))
.add(Restrictions.eq("cp.Catalog", catalog))
.add(Restrictions.eq("cp.Currency", currency))
.add(Restrictions.le("cp.InAction", actualityDate));
return OrmTemplate.getInstance()
.findUniqueByCriteria(
OrmTemplate.createCriteria(CatalogPrice.class)
.add(Restrictions.eq("Catalog", catalog))
.add(Subqueries.propertyEq("InAction", dc)));
}
