Example usage for org.apache.ibatis.session RowBounds RowBounds

Introduction

In this page you can find the example usage for org.apache.ibatis.session RowBounds RowBounds.

Prototype

public RowBounds(int offset, int limit)

Source Link

Usage

From source file:org.openlmis.report.service.LabEquipmentStatusReportDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sorter, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    return mapper.getFilteredSortedLabEquipmentStatusReport(getReportFilterData(filterCriteria), rowBounds,
            this.getUserId());
}

From source file:org.openlmis.report.service.MailingLabelReportDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sorterCriteria, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    return mailingLabelReportMapper.SelectFilteredSortedPagedFacilities(getReportFilterData(filterCriteria),
            rowBounds);//from w  w w. j  av  a 2  s . c  o  m
}

From source file:org.openlmis.report.service.NonReportingFacilityReportDataProvider.java

License:Open Source License

@Override
protected List<? extends ReportData> getResultSet(Map<String, String[]> filterCriteria) {
    RowBounds rowBounds = new RowBounds(RowBounds.NO_ROW_OFFSET, RowBounds.NO_ROW_LIMIT);
    return reportMapper.getReport(getFilterParameters(filterCriteria), rowBounds, this.getUserId());
}

From source file:org.openlmis.report.service.NonReportingFacilityReportDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sortCriteria, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    NonReportingFacilityParam nonReportingFacilityParam = getFilterParameters(filterCriteria);
    List<MasterReport> reportList = new ArrayList<>();
    MasterReport report = new MasterReport();
    report.setDetails(reportMapper.getReport(nonReportingFacilityParam, rowBounds, this.getUserId()));
    List<NameCount> summary = reportMapper.getReportSummary(nonReportingFacilityParam, this.getUserId());

    Double totalFacilities = reportMapper.getTotalFacilities(nonReportingFacilityParam, this.getUserId());
    Double nonReporting = reportMapper.getNonReportingTotalFacilities(nonReportingFacilityParam,
            this.getUserId());

    // Assume by default that the 100% of facilities didn't report
    Long percentNonReporting = 100L;
    Long percentReporting = 100L;
    if (totalFacilities != 0) {
        percentNonReporting = Math.round((nonReporting / totalFacilities) * 100);
        percentReporting = 100 - percentNonReporting;
    }//from www  . j  a va 2  s  .  c o  m

    NameCount percentageNonReporting = new NameCount();
    NameCount percentageReporting = new NameCount();

    percentageNonReporting.setName("Percentage not-reporting");
    percentageNonReporting.setCount(percentNonReporting.toString() + "%");
    summary.add(1, percentageNonReporting);

    percentageReporting.setName("Percentage reporting");
    percentageReporting.setCount(percentReporting.toString() + "%");
    summary.add(percentageReporting);

    NameCount percentageNonReportingChart = new NameCount();
    NameCount percentageReportingChart = new NameCount();

    percentageNonReportingChart.setName("Percentage not-reporting");
    percentageNonReportingChart.setCount(percentNonReporting.toString());
    summary.add(percentageNonReportingChart);

    percentageReportingChart.setName("Percentage reporting");
    percentageReportingChart.setCount(percentReporting.toString());
    summary.add(percentageReportingChart);

    report.setSummary(summary);
    reportList.add(report);

    List<? extends ReportData> list;
    list = reportList;
    return list;
}

From source file:org.openlmis.report.service.OrderFillRateReportDataProvider.java

License:Open Source License

@Override
protected List<? extends ReportData> getResultSet(Map<String, String[]> filterCriteria) {
    RowBounds rowBounds = new RowBounds(RowBounds.NO_ROW_OFFSET, RowBounds.NO_ROW_LIMIT);
    return reportMapper.getReport(ParameterAdaptor.parse(filterCriteria, OrderFillRateReportParam.class),
            rowBounds, this.getUserId());
}

From source file:org.openlmis.report.service.OrderFillRateReportDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sortCriteria, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);

    OrderFillRateReportParam parameter = ParameterAdaptor.parse(filterCriteria, OrderFillRateReportParam.class);
    List<MasterReport> reportList = new ArrayList<MasterReport>();
    MasterReport report = new MasterReport();
    report.setDetails(reportMapper.getReport(parameter, rowBounds, this.getUserId()));
    List<OrderFillRateReport> summary = reportMapper.getReportSummary(parameter, this.getUserId());
    OrderFillRateReport percentage = new OrderFillRateReport();
    percentage.setName("Order Fill Rate:");

    List<Integer> totalProductsReceivedList = reportMapper.getTotalProductsReceived(parameter,
            this.getUserId());
    List<Integer> totalProductsOrderedList = reportMapper.getTotalProductsOrdered(parameter, this.getUserId());

    if (totalProductsReceivedList.size() > 0 && totalProductsOrderedList.size() > 0) {
        String totalProductsReceived = totalProductsReceivedList.get(0).toString();
        String totalProductsOrdered = totalProductsOrderedList.get(0).toString();

        // Assume by default that the 100% of facilities didn't report
        Long percent = Long.parseLong("0");
        if (totalProductsOrdered != "0") {
            percent = Math.round(
                    (Double.parseDouble(totalProductsReceived) / Double.parseDouble(totalProductsOrdered))
                            * 100);/*from   w w  w .  jav  a 2s . c  o  m*/
        }
        percentage.setCount(percent.toString() + "%");
    }

    summary.add(0, percentage);

    report.setSummary(summary);

    reportList.add(report);

    List<? extends ReportData> list;
    list = reportList;
    return list;
}

From source file:org.openlmis.report.service.OrderFillRateReportSummaryDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sorter, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    return mapper.getFilteredSortedOrderFillRateSummaryReport(filterCriteria, rowBounds, this.getUserId());
}

From source file:org.openlmis.report.service.OrderSummaryReportDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sortCriteria, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    OrderReportParam orderReportParam = getReportFilterData(filterCriteria);
    orderReportParam.setTitle(getTitle(orderReportParam));

    return reportMapper.getOrderSummaryReport(orderReportParam, sortCriteria, rowBounds);
}

From source file:org.openlmis.report.service.PipelineExportReportProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sortCriteria, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    return reportMapper.getReport(getReportFilterData(filterCriteria), sortCriteria, rowBounds);
}

From source file:org.openlmis.report.service.PushedProductReportDataProvider.java

License:Open Source License

@Override
public List<? extends ReportData> getReportBody(Map<String, String[]> filterCriteria,
        Map<String, String[]> sorter, int page, int pageSize) {
    RowBounds rowBounds = new RowBounds((page - 1) * pageSize, pageSize);
    return reportMapper.getPushedProducts(
            ParameterAdaptor.parse(filterCriteria, OrderFillRateReportParam.class), rowBounds,
            this.getUserId());
}