package org.activityinfo.legacy.shared.impl.pivot;
/*
* #%L
* ActivityInfo Server
* %%
* Copyright (C) 2009 - 2013 UNICEF
* %%
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU 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 General Public License for more details.
*
* You should have received a copy of the GNU General Public
* License along with this program. If not, see
* <http://www.gnu.org/licenses/gpl-3.0.html>.
* #L%
*/
import com.bedatadriven.rebar.sql.client.query.SqlQuery;
import org.activityinfo.legacy.shared.command.DimensionType;
import org.activityinfo.legacy.shared.command.PivotSites;
import org.activityinfo.legacy.shared.command.PivotSites.ValueType;
import org.activityinfo.legacy.shared.impl.Tables;
import org.activityinfo.legacy.shared.model.IndicatorDTO;
import org.activityinfo.legacy.shared.reports.content.TargetCategory;
/**
* Base table for counting the number of sites that match a certain criteria. This class behaves just like the
* SiteCounts query, but only selects the linked sites (via database -> activity -> indicator -> indicatorlink ->
* indicator -> activity -> site) instead of the sites that are directly linked to the database or activity the filter
* is set to (via database -> activity -> site).
*/
public class LinkedSiteCounts extends BaseTable {
@Override
public boolean accept(PivotSites command) {
return command.getValueType() == ValueType.TOTAL_SITES;
}
@Override
public void setupQuery(PivotSites command, SqlQuery query) {
query.from(Tables.INDICATOR_LINK, "IndicatorLink");
query.leftJoin(Tables.INDICATOR_VALUE, "V").on("IndicatorLink.SourceIndicatorId=V.IndicatorId");
query.leftJoin(Tables.INDICATOR, "Indicator").on("IndicatorLink.DestinationIndicatorId=Indicator.IndicatorId");
query.leftJoin(Tables.ACTIVITY, "Activity").on("Activity.ActivityId=Indicator.ActivityId");
query.leftJoin(Tables.USER_DATABASE, "UserDatabase").on("UserDatabase.DatabaseId=Activity.DatabaseId");
query.leftJoin(Tables.REPORTING_PERIOD, "Period").on("Period.ReportingPeriodId=V.ReportingPeriodId");
query.leftJoin(Tables.SITE, "Site").on("Site.SiteId=Period.SiteId");
query.appendColumn("COUNT(DISTINCT Site.SiteId)", ValueFields.COUNT);
query.appendColumn(Integer.toString(IndicatorDTO.AGGREGATE_SITE_COUNT), ValueFields.AGGREGATION);
}
@Override
public String getDimensionIdColumn(DimensionType type) {
switch (type) {
case Partner:
return "Site.PartnerId";
case Activity:
return "Indicator.ActivityId";
case Database:
return "Activity.DatabaseId";
case Site:
return "Site.SiteId";
case Project:
return "Site.ProjectId";
case Location:
return "Site.LocationId";
case Indicator:
return "IndicatorLink.DestinationIndicatorId";
}
throw new UnsupportedOperationException(type.name());
}
@Override
public String getDateCompleteColumn() {
return "Period.Date2";
}
@Override
public TargetCategory getTargetCategory() {
return TargetCategory.REALIZED;
}
}