/* * Electronic Logistics Management Information System (eLMIS) is a supply chain management system for health commodities in a developing country setting. * * Copyright (C) 2015 John Snow, Inc (JSI). This program was produced for the U.S. Agency for International Development (USAID). It was prepared under the USAID | DELIVER PROJECT, Task Order 4. * * This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ package org.openlmis.report.mapper; import org.apache.ibatis.annotations.Options; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.SelectProvider; import org.apache.ibatis.mapping.ResultSetType; import org.apache.ibatis.session.RowBounds; import org.openlmis.report.builder.VaccineTemperatureReportQueryBuilder; import org.openlmis.report.model.params.ColdChainTemperatureReportParam; import org.openlmis.report.model.report.ColdChainTemperature; import org.springframework.stereotype.Repository; import java.util.List; @Repository public interface ColdChainTemperaturesReportMapper { @SelectProvider(type=VaccineTemperatureReportQueryBuilder.class, method="getColdChainTemperatureData") @Options(resultSetType = ResultSetType.SCROLL_SENSITIVE, fetchSize=10,timeout=0,useCache=true,flushCache=true) public List<ColdChainTemperature> getReportData( @Param("filterCriteria") ColdChainTemperatureReportParam coldChainTemperatureReportParam , @Param("RowBounds") RowBounds rowBounds , @Param("userId") Long userId); @SelectProvider(type=VaccineTemperatureReportQueryBuilder.class, method="getColdChainTemperatureMinMaxAggregateData") @Options(resultSetType = ResultSetType.SCROLL_SENSITIVE, fetchSize=10,timeout=0,useCache=true,flushCache=true) public List<ColdChainTemperature> getMainReportMinMaxAggregate( @Param("filterCriteria") ColdChainTemperatureReportParam coldChainTemperatureReportParam , @Param("RowBounds") RowBounds rowBounds , @Param("userId") Long userId); @SelectProvider(type=VaccineTemperatureReportQueryBuilder.class, method="getColdChainTemperatureReportAggregateTotalData") @Options(resultSetType = ResultSetType.SCROLL_SENSITIVE, fetchSize=10,timeout=0,useCache=true,flushCache=true) public List<ColdChainTemperature> getMainReportAggregateTotal( @Param("filterCriteria") ColdChainTemperatureReportParam coldChainTemperatureReportParam , @Param("RowBounds") RowBounds rowBounds , @Param("userId") Long userId); @SelectProvider(type=VaccineTemperatureReportQueryBuilder.class, method="getColdChainTemperatureMinMaxRecorededTemprature") @Options(resultSetType = ResultSetType.SCROLL_SENSITIVE, fetchSize=10,timeout=0,useCache=true,flushCache=true) public List<ColdChainTemperature> getMainReportAggregateMinMaxTempRecorded( @Param("filterCriteria") ColdChainTemperatureReportParam coldChainTemperatureReportParam , @Param("RowBounds") RowBounds rowBounds , @Param("userId") Long userId); @SelectProvider(type=VaccineTemperatureReportQueryBuilder.class, method="getColdChainTemperatureSubReportData") @Options(resultSetType = ResultSetType.SCROLL_SENSITIVE, fetchSize=10,timeout=0,useCache=true,flushCache=true) public List<ColdChainTemperature> getSubReportData( @Param("filterCriteria") ColdChainTemperatureReportParam coldChainTemperatureReportParam , @Param("RowBounds") RowBounds rowBounds , @Param("userId") Long userId); }