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
*/
public class SiteCounts extends BaseTable {
@Override
public boolean accept(PivotSites command) {
return command.getValueType() == ValueType.TOTAL_SITES;
}
@Override
public void setupQuery(PivotSites command, SqlQuery query) {
if (command.getFilter().isRestricted(DimensionType.Indicator)) {
// we only need to pull in indicator values if there is a filter on indicators
query.from(Tables.INDICATOR_VALUE, "V");
query.leftJoin(Tables.REPORTING_PERIOD, "RP").on("V.ReportingPeriodId = RP.ReportingPeriodId");
query.leftJoin(Tables.SITE, "Site").on("RP.SiteId = Site.SiteId");
} else {
query.from(Tables.SITE, "Site");
}
query.leftJoin(Tables.ACTIVITY, "Activity").on("Activity.ActivityId = Site.ActivityId");
query.leftJoin(Tables.USER_DATABASE, "UserDatabase").on("Activity.DatabaseId = UserDatabase.DatabaseId");
query.leftJoin(Tables.REPORTING_PERIOD, "Period").on("Period.SiteId = Site.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 "Site.ActivityId";
case Database:
return "Activity.DatabaseId";
case Site:
return "Site.SiteId";
case Project:
return "Site.ProjectId";
case Location:
return "Site.LocationId";
case Indicator:
return "V.IndicatorId";
}
throw new UnsupportedOperationException(type.name());
}
@Override
public String getDateCompleteColumn() {
return "Period.Date2";
}
@Override
public TargetCategory getTargetCategory() {
return TargetCategory.REALIZED;
}
}