/**
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this file,
* You can obtain one at http://mozilla.org/MPL/2.0/.
*/
package org.mifosplatform.portfolio.floatingrates.domain;
import java.util.Collection;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
public interface FloatingRateRepository extends
JpaRepository<FloatingRate, Long>,
JpaSpecificationExecutor<FloatingRate> {
@Query("from FloatingRate floatingRate where floatingRate.isBaseLendingRate = 1 and floatingRate.isActive = 1")
FloatingRate retrieveBaseLendingRate();
@Query("from FloatingRate floatingRate " +
" inner join floatingRate.floatingRatePeriods as periods" +
" where floatingRate.isActive = 1 " +
" and periods.isActive = 1 " +
" and periods.isDifferentialToBaseLendingRate = 1")
Collection<FloatingRate> retrieveFloatingRatesLinkedToBLR();
}