use of org.activityinfo.legacy.shared.reports.content.DimensionCategory in project activityinfo by bedatadriven.
the class DimBinding method extractEntityCategories.
protected final DimensionCategory[] extractEntityCategories(ColumnSet columnSet, String idColumn, String labelColumn) {
ColumnView id = columnSet.getColumnView(idColumn);
ColumnView label = columnSet.getColumnView(labelColumn);
int numRows = columnSet.getNumRows();
DimensionCategory[] categories = new DimensionCategory[numRows];
for (int i = 0; i < numRows; i++) {
categories[i] = extractEntityCategory(id, label, i);
}
return categories;
}
use of org.activityinfo.legacy.shared.reports.content.DimensionCategory in project activityinfo by bedatadriven.
the class PivotAdapter method executeSiteCountQueryOnSite.
private void executeSiteCountQueryOnSite(final Activity activity, LinkedActivity linkedActivity) {
Preconditions.checkState(!indicatorDimension.isPresent());
FormTree formTree = formTrees.get(linkedActivity.getSiteFormClassId());
QueryModel queryModel = new QueryModel(linkedActivity.getSiteFormClassId());
queryModel.setFilter(composeFilter(formTree));
// Add dimensions columns as needed
for (DimBinding dimension : groupBy) {
for (ColumnModel columnModel : dimension.getColumnQuery(formTree)) {
queryModel.addColumn(columnModel);
}
}
// Query the table
enqueueQuery(queryModel, new Function<ColumnSet, Void>() {
@Nullable
@Override
public Void apply(@Nullable ColumnSet columnSet) {
// Now add the counts to the buckets
DimensionCategory[][] categories = extractCategories(activity, columnSet);
for (int i = 0; i < columnSet.getNumRows(); i++) {
Map<Dimension, DimensionCategory> key = bucketKey(i, categories, null);
Accumulator bucket = bucketForKey(key, IndicatorDTO.AGGREGATE_SITE_COUNT);
bucket.addCount(1);
}
return null;
}
});
}
use of org.activityinfo.legacy.shared.reports.content.DimensionCategory in project activityinfo by bedatadriven.
the class PivotAdapter method executeSiteCountQueryOnReportingPeriod.
private void executeSiteCountQueryOnReportingPeriod(final Activity activity, LinkedActivity linkedActivity) {
Preconditions.checkArgument(activity.isMonthly());
// Query the linked activity
FormTree formTree = formTrees.get(linkedActivity.getLeafFormClassId());
QueryModel queryModel = new QueryModel(activity.getLeafFormClassId());
queryModel.setFilter(composeFilter(formTree));
// Add dimensions columns as needed
for (DimBinding dimension : groupBy) {
for (ColumnModel columnModel : dimension.getColumnQuery(formTree)) {
queryModel.addColumn(columnModel);
}
}
addSiteIdToQuery(activity, queryModel);
// Query the table
enqueueQuery(queryModel, new Function<ColumnSet, Void>() {
@Nullable
@Override
public Void apply(@Nullable ColumnSet columnSet) {
// Now add the counts to the buckets
DimensionCategory[][] categories = extractCategories(activity, columnSet);
int[] siteId = extractSiteIds(columnSet);
for (int i = 0; i < columnSet.getNumRows(); i++) {
Map<Dimension, DimensionCategory> key = bucketKey(i, categories, null);
Accumulator bucket = bucketForKey(key, IndicatorDTO.AGGREGATE_SITE_COUNT);
bucket.addSite(siteId[i]);
}
return null;
}
});
}
use of org.activityinfo.legacy.shared.reports.content.DimensionCategory in project activityinfo by bedatadriven.
the class PivotAdapter method executeTargetValuesQuery.
private void executeTargetValuesQuery(Integer databaseId) {
if (filter.isRestricted(DimensionType.AttributeGroup) || filter.isRestricted(DimensionType.AdminLevel) || filter.isRestricted(DimensionType.Site) || filter.isRestricted(DimensionType.Location)) {
// No results, exit now
return;
}
ResourceId targetFormClassId = CuidAdapter.cuid(CuidAdapter.TARGET_FORM_CLASS_DOMAIN, databaseId);
QueryModel queryModel = new QueryModel(targetFormClassId);
QueryFilter queryFilter = new QueryFilter(filter, attributeFilters, LOGGER);
queryModel.setFilter(queryFilter.composeTargetFilter());
final Collection<Activity> activities = databases.get(databaseId);
// Add all indicators we're querying for
for (Activity activity : activities) {
for (ActivityField indicator : selectedIndicators(activity)) {
queryModel.selectField(targetFieldExpr(indicator)).as(alias(indicator));
}
}
for (DimBinding dimension : groupBy) {
for (ColumnModel columnModel : dimension.getTargetColumnQuery(targetFormClassId)) {
queryModel.addColumn(columnModel);
}
}
enqueueQuery(queryModel, new Function<ColumnSet, Void>() {
@Nullable
@Override
public Void apply(@Nullable ColumnSet columnSet) {
for (Activity activity : activities) {
for (ActivityField indicator : selectedIndicators(activity)) {
ColumnView measureView = columnSet.getColumnView(alias(indicator));
DimensionCategory indicatorCategory = null;
if (indicatorDimension.isPresent()) {
indicatorCategory = indicatorDimension.get().category(indicator);
}
for (int i = 0; i < columnSet.getNumRows(); i++) {
double value = measureView.getDouble(i);
if (!Double.isNaN(value) && !Double.isInfinite(value)) {
Map<Dimension, DimensionCategory> key = new HashMap<>();
for (DimBinding dim : groupBy) {
DimensionCategory category = dim.extractTargetCategory(activity, columnSet, i);
if (category != null) {
key.put(dim.getModel(), category);
}
}
if (indicatorCategory != null) {
key.put(indicatorDimension.get().getModel(), indicatorCategory);
}
Accumulator bucket = bucketForKey(key, indicator.getAggregation());
bucket.addValue(value);
}
}
}
}
return null;
}
});
}
use of org.activityinfo.legacy.shared.reports.content.DimensionCategory in project activityinfo by bedatadriven.
the class PivotAdapter method executeIndicatorValuesQuery.
private void executeIndicatorValuesQuery(final Activity activity, LinkedActivity linkedActivity) throws SQLException {
// Double check that this activity has not been deleted
if (isDeleted(activity, linkedActivity)) {
return;
}
// Query the SOURCE form tree
FormTree formTree = formTrees.get(linkedActivity.getLeafFormClassId());
Preconditions.checkNotNull(formTree, "No form tree for form " + linkedActivity.getLeafFormClassId());
QueryModel queryModel = new QueryModel(linkedActivity.getLeafFormClassId());
List<ActivityField> indicators = selectedIndicators(activity);
// Add Indicators to the query
// Keep track of alias to destination map
final Multimap<String, ActivityField> aliasToIndicator = HashMultimap.create();
for (ActivityField indicator : indicators) {
Collection<Integer> sourceIndicatorIds = linkedActivity.getSourceIndicatorIdsFor(indicator.getId());
for (Integer sourceIndicatorId : sourceIndicatorIds) {
String alias = "I" + sourceIndicatorId;
queryModel.selectExpr(fieldExpression(sourceIndicatorId)).as(alias);
aliasToIndicator.put(alias, indicator);
}
}
// These are the columns we will use for grouping
for (DimBinding dimension : groupBy) {
for (ColumnModel columnModel : dimension.getColumnQuery(formTree)) {
queryModel.addColumn(columnModel);
}
}
// if any of the indicators are "site count" indicators, then we need
// to query the site id as well
addSiteIdToQuery(activity, queryModel);
// declare the filter
queryModel.setFilter(composeFilter(formTree));
// Query the table
enqueueQuery(queryModel, new Function<ColumnSet, Void>() {
@Nullable
@Override
public Void apply(@Nullable ColumnSet columnSet) {
// Now add the results to the buckets
int[] siteIds = extractSiteIds(columnSet);
DimensionCategory[][] categories = extractCategories(activity, columnSet);
for (String sourceAlias : aliasToIndicator.keySet()) {
ColumnView measureView = columnSet.getColumnView(sourceAlias);
// A single source indicator may be mapped to multiple destination Indicators
for (ActivityField destinationIndicator : aliasToIndicator.get(sourceAlias)) {
DimensionCategory indicatorCategory = null;
if (indicatorDimension.isPresent()) {
indicatorCategory = indicatorDimension.get().category(destinationIndicator);
}
for (int i = 0; i < columnSet.getNumRows(); i++) {
if (destinationIndicator.getAggregation() == IndicatorDTO.AGGREGATE_SITE_COUNT) {
Map<Dimension, DimensionCategory> key = bucketKey(i, categories, indicatorCategory);
Accumulator bucket = bucketForKey(key, destinationIndicator.getAggregation());
bucket.addSite(siteIds[i]);
} else {
double value = measureView.getDouble(i);
if (!Double.isNaN(value) && !Double.isInfinite(value)) {
Map<Dimension, DimensionCategory> key = bucketKey(i, categories, indicatorCategory);
if (command.getValueType() == PivotSites.ValueType.INDICATOR) {
Accumulator bucket = bucketForKey(key, destinationIndicator.getAggregation());
bucket.addValue(value);
} else {
Accumulator bucket = bucketForKey(key, IndicatorDTO.AGGREGATE_SITE_COUNT);
bucket.addSite(siteIds[i]);
}
}
}
}
}
}
return null;
}
});
}
Aggregations