Search in sources :

Example 11 with Bucket

use of org.activityinfo.legacy.shared.command.result.Bucket in project activityinfo by bedatadriven.

the class DrillDownProxy method toRows.

private List<DrillDownRow> toRows(PivotSites.PivotResult result) {
    List<DrillDownRow> rows = new ArrayList<>();
    for (Bucket bucket : result.getBuckets()) {
        DrillDownRow row = new DrillDownRow(getEntity(bucket, siteDimension).getId());
        row.set("partner", getEntity(bucket, partnerDimension).getLabel());
        EntityCategory location = getEntity(bucket, locationDimension);
        if (location != null) {
            row.set("location", location.getLabel());
        }
        row.set("date", getDate(bucket));
        row.set("database", getEntity(bucket, databaseDimension).getLabel());
        row.set("activity", getEntity(bucket, actvitiyDimension).getLabel());
        row.set("indicator", getEntity(bucket, indicatorDimension).getLabel());
        row.set("value", bucket.doubleValue());
        rows.add(row);
    }
    return rows;
}
Also used : Bucket(org.activityinfo.legacy.shared.command.result.Bucket) ArrayList(java.util.ArrayList) EntityCategory(org.activityinfo.legacy.shared.reports.content.EntityCategory)

Example 12 with Bucket

use of org.activityinfo.legacy.shared.command.result.Bucket in project activityinfo by bedatadriven.

the class CustomerCalcIndicatorTest method pivotByAttributeGroup.

private PivotSites pivotByAttributeGroup(int activityId) {
    AttributeGroupDTO group = getAttributeGroup(activityId);
    PivotSites pivot = new PivotSites();
    pivot.setDimensions(INDICATOR_DIMENSION, new AttributeGroupDimension(group.getId()));
    pivot.setFilter(Filter.filter().onActivity(activityId));
    List<Bucket> buckets = execute(pivot).getBuckets();
    System.out.println(Joiner.on("\n").join(buckets));
    // assertThat(buckets, hasItem(total("Total Value of Initial Cost", 48500)));
    return pivot;
}
Also used : Bucket(org.activityinfo.legacy.shared.command.result.Bucket) AttributeGroupDimension(org.activityinfo.legacy.shared.reports.model.AttributeGroupDimension)

Example 13 with Bucket

use of org.activityinfo.legacy.shared.command.result.Bucket in project activityinfo by bedatadriven.

the class PivotTableGeneratorTest method testIndicatorSortOrder.

@Test
public void testIndicatorSortOrder() {
    // test input data: user
    User user = new User();
    user.setLocale("fr");
    // test input data: PivotTableElement
    PivotTableReportElement element = new PivotTableReportElement();
    Dimension indicatorDim = new Dimension(DimensionType.Indicator);
    element.addRowDimension(indicatorDim);
    // test input data: aggregated results
    List<Bucket> buckets = new ArrayList<Bucket>();
    buckets.add(newBucket(300, category(indicatorDim, 1, "Nb. menages", 3)));
    buckets.add(newBucket(400, category(indicatorDim, 2, "Nb. personnes", 1)));
    buckets.add(newBucket(600, category(indicatorDim, 3, "Nb. deplaces", 2)));
    // collaborator : PivotDAO
    DispatcherSync dispatcher = createMock(DispatcherSync.class);
    expect(dispatcher.execute(isA(PivotSites.class))).andReturn(new PivotSites.PivotResult(buckets));
    replay(dispatcher);
    // CLASS UNDER TEST!!
    PivotTableGenerator generator = new PivotTableGenerator(dispatcher);
    generator.generate(user, element, dummyFilter(), null);
    Assert.assertNotNull("element content", element.getContent());
    List<PivotTableData.Axis> rows = element.getContent().getData().getRootRow().getChildren();
    Assert.assertEquals(2, ((EntityCategory) rows.get(0).getCategory()).getId());
    Assert.assertEquals(3, ((EntityCategory) rows.get(1).getCategory()).getId());
    Assert.assertEquals(1, ((EntityCategory) rows.get(2).getCategory()).getId());
}
Also used : PivotSites(org.activityinfo.legacy.shared.command.PivotSites) User(org.activityinfo.server.database.hibernate.entity.User) Bucket(org.activityinfo.legacy.shared.command.result.Bucket) ArrayList(java.util.ArrayList) Dimension(org.activityinfo.legacy.shared.reports.model.Dimension) AdminDimension(org.activityinfo.legacy.shared.reports.model.AdminDimension) PivotTableReportElement(org.activityinfo.legacy.shared.reports.model.PivotTableReportElement) DispatcherSync(org.activityinfo.server.command.DispatcherSync) Test(org.junit.Test)

Aggregations

Bucket (org.activityinfo.legacy.shared.command.result.Bucket)13 Dimension (org.activityinfo.legacy.shared.reports.model.Dimension)7 AdminDimension (org.activityinfo.legacy.shared.reports.model.AdminDimension)5 PivotSites (org.activityinfo.legacy.shared.command.PivotSites)4 EntityCategory (org.activityinfo.legacy.shared.reports.content.EntityCategory)4 AttributeGroupDimension (org.activityinfo.legacy.shared.reports.model.AttributeGroupDimension)4 ArrayList (java.util.ArrayList)3 DateDimension (org.activityinfo.legacy.shared.reports.model.DateDimension)3 PivotResult (org.activityinfo.legacy.shared.command.PivotSites.PivotResult)2 PivotTableData (org.activityinfo.legacy.shared.reports.content.PivotTableData)2 PivotTableReportElement (org.activityinfo.legacy.shared.reports.model.PivotTableReportElement)2 DispatcherSync (org.activityinfo.server.command.DispatcherSync)2 User (org.activityinfo.server.database.hibernate.entity.User)2 Test (org.junit.Test)2 SqlResultCallback (com.bedatadriven.rebar.sql.client.SqlResultCallback)1 SqlResultSet (com.bedatadriven.rebar.sql.client.SqlResultSet)1 SqlResultSetRow (com.bedatadriven.rebar.sql.client.SqlResultSetRow)1 SqlTransaction (com.bedatadriven.rebar.sql.client.SqlTransaction)1 SqlQuery (com.bedatadriven.rebar.sql.client.query.SqlQuery)1 GetPartnersDimension (org.activityinfo.legacy.shared.command.GetPartnersDimension)1