Search in sources :

Example 6 with CoordinateAttributeDefinition

use of org.openforis.idm.metamodel.CoordinateAttributeDefinition in project collect by openforis.

the class UIOptionsMigrator method createField.

protected UIField createField(UIFormContentContainer parent, NodeDefinition nodeDefn) {
    CollectSurvey survey = (CollectSurvey) nodeDefn.getSurvey();
    UIOptions uiOptions = survey.getUIOptions();
    CollectAnnotations annotations = survey.getAnnotations();
    UIField field;
    if (nodeDefn instanceof CodeAttributeDefinition) {
        UICodeField codeField = parent.createCodeField();
        CodeAttributeDefinition codeAttrDefn = (CodeAttributeDefinition) nodeDefn;
        codeField.setLayout(uiOptions.getLayoutType(codeAttrDefn));
        codeField.setShowCode(uiOptions.getShowCode(codeAttrDefn));
        codeField.setItemsOrientation(uiOptions.getLayoutDirection(codeAttrDefn));
        field = codeField;
    } else {
        field = parent.createField();
    }
    field.setAttributeDefinitionId(nodeDefn.getId());
    if (nodeDefn instanceof TextAttributeDefinition) {
        String autoCompleteGroup = annotations.getAutoCompleteGroup((TextAttributeDefinition) nodeDefn);
        field.setAutoCompleteGroup(autoCompleteGroup);
    } else if (nodeDefn instanceof CoordinateAttributeDefinition) {
        CoordinateAttributeFieldsOrder fieldsOrder = uiOptions.getFieldsOrder((CoordinateAttributeDefinition) nodeDefn);
        field.setFieldsOrder(fieldsOrder);
    }
    field.setHidden(uiOptions.isHidden(nodeDefn));
    return field;
}
Also used : CoordinateAttributeDefinition(org.openforis.idm.metamodel.CoordinateAttributeDefinition) CodeAttributeDefinition(org.openforis.idm.metamodel.CodeAttributeDefinition) TextAttributeDefinition(org.openforis.idm.metamodel.TextAttributeDefinition) CollectAnnotations(org.openforis.collect.metamodel.CollectAnnotations) CollectSurvey(org.openforis.collect.model.CollectSurvey) CoordinateAttributeFieldsOrder(org.openforis.collect.metamodel.ui.UIOptions.CoordinateAttributeFieldsOrder)

Example 7 with CoordinateAttributeDefinition

use of org.openforis.idm.metamodel.CoordinateAttributeDefinition in project collect by openforis.

the class MondrianCubeGenerator method generateDimension.

/*	private List<Dimension> generatePredefinedDimensions() {
		List<Dimension> dimensions = new ArrayList<Dimension>();
		//Slope category
		{
			Dimension d = new Dimension("Slope category");
			d.foreignKey = "slope_id";
			d.highCardinality = "false";
			Hierarchy h = new Hierarchy();
			h.table = new Table("slope_category");
			Level l = new Level("Slope_category");
			l.table = "slope_category";
			l.column = "slope_id";
			l.nameColumn = "slope_caption";
			l.type = "String";
			l.levelType = "Regular";
			l.uniqueMembers = "false";
			h.levels.add(l);
			d.hierarchy = h;
			dimensions.add(d);
		}
		//Initial Land Use
		{
			Dimension d = new Dimension("Initial Land Use");
			d.foreignKey = "dynamics_id";
			d.highCardinality = "false";
			Hierarchy h = new Hierarchy();
			h.table = new Table("dynamics_category");
			Level l = new Level("Initial_land_use");
			l.table = "dynamics_category";
			l.column = "dynamics_id";
			l.nameColumn = "dynamics_caption";
			l.type = "String";
			l.levelType = "Regular";
			l.uniqueMembers = "false";
			l.hideMemberIf = "Never";
			h.levels.add(l);
			d.hierarchy = h;
			dimensions.add(d);
		}
		//Elevation Range
		{
			Dimension d = new Dimension("Elevation range");
			d.foreignKey = "elevation_id";
			d.highCardinality = "false";
			Hierarchy h = new Hierarchy();
			h.table = new Table("elevation_category");
			Level l = new Level("Elevation_range");
			l.table = "elevation_category";
			l.column = "elevation_id";
			l.nameColumn = "elevation_caption";
			l.type = "String";
			l.levelType = "Regular";
			l.uniqueMembers = "false";
			l.hideMemberIf = "Never";
			h.levels.add(l);
			d.hierarchy = h;
			dimensions.add(d);
		}
		return dimensions;
	}
*/
private Dimension generateDimension(NodeDefinition nodeDef, EntityDefinition rootEntityDef) {
    String attrLabel = extractFailsafeLabel(nodeDef);
    Dimension dimension = new Dimension(attrLabel);
    Hierarchy hierarchy = dimension.hierarchy;
    if (nodeDef instanceof CodeAttributeDefinition) {
        CodeAttributeDefinition codeDef = (CodeAttributeDefinition) nodeDef;
        DataTable dataTable = nodeDef.isMultiple() ? rdbSchema.getDataTable(nodeDef) : rdbSchema.getDataTable(nodeDef.getParentDefinition());
        CodeTable codeListTable = rdbSchema.getCodeListTable(codeDef);
        String codeListTableName = codeListTable.getName();
        String codeFKColumnName = DataTables.getCodeFKColumnName(rdbConfig, dataTable, codeDef);
        String rootEntityIdColumnName = getRootEntityIdColumnName(rootEntityDef);
        if (nodeDef.isMultiple()) {
            dimension.foreignKey = rootEntityIdColumnName;
            hierarchy.primaryKey = rootEntityIdColumnName;
            hierarchy.primaryKeyTable = dataTable.getName();
            Join join = new Join(null);
            join.leftKey = codeFKColumnName;
            join.rightKey = CodeListTables.getIdColumnName(rdbConfig, codeListTableName);
            join.tables = Arrays.asList(new Table(dataTable.getName()), new Table(codeListTableName));
            hierarchy.join = join;
        } else {
            dimension.foreignKey = codeFKColumnName;
            hierarchy.table = new Table(codeListTableName);
        }
    }
    if (nodeDef instanceof DateAttributeDefinition) {
        dimension.type = "";
        hierarchy.type = "TimeDimension";
        hierarchy.allMemberName = "attrLabel";
        String[] levelNames = new String[] { "Year", "Month", "Day" };
        for (String levelName : levelNames) {
            Level level = new Level(attrLabel + " - " + levelName);
            level.column = nodeDef.getName() + "_" + levelName.toLowerCase(Locale.ENGLISH);
            level.levelType = String.format("Time%ss", levelName);
            level.type = "Numeric";
            // Avoids grouping the values of the sane day over multiple months!!!
            level.uniqueMembers = "false";
            hierarchy.levels.add(level);
        }
    } else if (nodeDef instanceof CoordinateAttributeDefinition) {
        dimension.type = "";
        hierarchy.type = "StandardDimension";
        Level level = new Level(attrLabel + " - Latitude");
        level.column = nodeDef.getName() + "_y";
        hierarchy.levels.add(level);
        Level level2 = new Level(attrLabel + " - Longitude");
        level2.column = nodeDef.getName() + "_x";
        hierarchy.levels.add(level2);
    } else {
        List<Level> levels = generateLevel(nodeDef);
        hierarchy.levels.addAll(levels);
    }
    return dimension;
}
Also used : CodeTable(org.openforis.collect.relational.model.CodeTable) DataTable(org.openforis.collect.relational.model.DataTable) CodeTable(org.openforis.collect.relational.model.CodeTable) DataTable(org.openforis.collect.relational.model.DataTable) DateAttributeDefinition(org.openforis.idm.metamodel.DateAttributeDefinition) CoordinateAttributeDefinition(org.openforis.idm.metamodel.CoordinateAttributeDefinition) CodeAttributeDefinition(org.openforis.idm.metamodel.CodeAttributeDefinition) CodeListLevel(org.openforis.idm.metamodel.CodeListLevel) ArrayList(java.util.ArrayList) CodeList(org.openforis.idm.metamodel.CodeList) List(java.util.List)

Example 8 with CoordinateAttributeDefinition

use of org.openforis.idm.metamodel.CoordinateAttributeDefinition in project collect by openforis.

the class NewMondrianSchemaGenerator method generateDimension.

private Dimension generateDimension(Cube cube, AttributeDefinition attrDef) {
    Dimension dimension = new Dimension(determineDimensionName(attrDef));
    EntityDefinition ancestorMultipleEntity = attrDef.getNearestAncestorMultipleEntity();
    if (ancestorMultipleEntity.isRoot()) {
        dimension.caption = extractLabel(attrDef);
    } else {
        dimension.caption = String.format("%s %s", extractLabel(ancestorMultipleEntity), extractLabel(attrDef));
    }
    Hierarchy hierarchy = dimension.hierarchy;
    hierarchy.table = new Table(dbSchemaName, cube.tables.get(0).name);
    if (attrDef instanceof CodeAttributeDefinition) {
        CodeAttributeDefinition codeAttrDef = (CodeAttributeDefinition) attrDef;
        if (!codeAttrDef.getList().isExternal()) {
            if (attrDef.isMultiple()) {
                DataTable dataTable = rdbSchema.getDataTable(attrDef);
                String parentEntityPKColumnName = getEntityPKColumnName(ancestorMultipleEntity);
                dimension.foreignKey = parentEntityPKColumnName;
                hierarchy.table = null;
                hierarchy.primaryKey = parentEntityPKColumnName;
                hierarchy.primaryKeyTable = dataTable.getName();
                Join join = new Join(null);
                String codeListTableName = CodeListTables.getTableName(rdbConfig, codeAttrDef);
                join.leftKey = dataTable.getForeignKeyCodeColumn(codeAttrDef).getName();
                join.rightKey = CodeListTables.getIdColumnName(rdbConfig, codeListTableName);
                join.tables = Arrays.asList(new Table(dbSchemaName, dataTable.getName()), new Table(dbSchemaName, codeListTableName));
                hierarchy.join = join;
            } else {
                String codeListTableName = CodeListTables.getTableName(rdbConfig, codeAttrDef);
                hierarchy.table = new Table(dbSchemaName, codeListTableName);
                DataTable dataTable = rdbSchema.getDataTable(attrDef.getParentEntityDefinition());
                CodeValueFKColumn foreignKeyCodeColumn = dataTable.getForeignKeyCodeColumn(codeAttrDef);
                dimension.foreignKey = foreignKeyCodeColumn.getName();
            }
        }
        hierarchy.levels.add(generateLevel(attrDef));
    } else if (attrDef instanceof CoordinateAttributeDefinition) {
        dimension.type = "";
        hierarchy.type = "StandardDimension";
        {
            String fieldName = CoordinateAttributeDefinition.Y_FIELD_NAME;
            Level level = new Level(dimension.name + "_" + fieldName, extractLabel(attrDef) + " - Latitude");
            level.column = attrDef.getName() + "_" + fieldName;
            hierarchy.levels.add(level);
        }
        {
            String fieldName = CoordinateAttributeDefinition.X_FIELD_NAME;
            Level level = new Level(dimension.name + "_" + fieldName, extractLabel(attrDef) + " - Longitude");
            level.column = attrDef.getName() + "_" + fieldName;
            hierarchy.levels.add(level);
        }
    } else if (attrDef instanceof DateAttributeDefinition) {
        dimension.type = "";
        hierarchy.type = "TimeDimension";
        hierarchy.allMemberName = "attrLabel";
        String[] fieldNames = new String[] { DateAttributeDefinition.YEAR_FIELD_NAME, DateAttributeDefinition.MONTH_FIELD_NAME, DateAttributeDefinition.DAY_FIELD_NAME };
        for (String fieldName : fieldNames) {
            String fieldLabel = StringUtils.capitalize(fieldName);
            Level level = new Level(dimension.name + "_" + fieldName, determineLevelCaption(attrDef, fieldLabel));
            level.column = attrDef.getName() + "_" + fieldName.toLowerCase(Locale.ENGLISH);
            level.levelType = String.format("Time%ss", fieldLabel);
            level.type = NUMERIC_DATATYPE;
            hierarchy.levels.add(level);
        }
    } else if (attrDef instanceof TaxonAttributeDefinition) {
        {
            String fieldName = TaxonAttributeDefinition.CODE_FIELD_NAME;
            Level level = new Level(dimension.name + "_" + fieldName, extractLabel(attrDef) + " - Code");
            level.column = attrDef.getName() + "_" + fieldName;
            hierarchy.levels.add(level);
        }
        {
            String fieldName = TaxonAttributeDefinition.SCIENTIFIC_NAME_FIELD_NAME;
            Level level = new Level(dimension.name + "_" + fieldName, extractLabel(attrDef) + " - Scientific name");
            level.column = attrDef.getName() + "_" + fieldName;
            hierarchy.levels.add(level);
        }
    } else if (attrDef instanceof TimeAttributeDefinition) {
        dimension.type = "";
        hierarchy.type = "TimeDimension";
        hierarchy.allMemberName = "attrLabel";
        String[] fieldNames = new String[] { TimeAttributeDefinition.HOUR_FIELD, TimeAttributeDefinition.MINUTE_FIELD };
        for (String fieldName : fieldNames) {
            String fieldLabel = StringUtils.capitalize(fieldName);
            Level level = new Level(dimension.name + "_" + fieldName, determineLevelCaption(attrDef, fieldLabel));
            level.column = attrDef.getName() + "_" + fieldName.toLowerCase(Locale.ENGLISH);
            level.levelType = String.format("Time%ss", fieldLabel);
            level.type = NUMERIC_DATATYPE;
            hierarchy.levels.add(level);
        }
    } else {
        hierarchy.levels.add(generateLevel(attrDef));
    }
    return dimension;
}
Also used : DataTable(org.openforis.collect.relational.model.DataTable) TimeAttributeDefinition(org.openforis.idm.metamodel.TimeAttributeDefinition) CodeTable(org.openforis.collect.relational.model.CodeTable) DataTable(org.openforis.collect.relational.model.DataTable) TaxonAttributeDefinition(org.openforis.idm.metamodel.TaxonAttributeDefinition) DateAttributeDefinition(org.openforis.idm.metamodel.DateAttributeDefinition) CodeValueFKColumn(org.openforis.collect.relational.model.CodeValueFKColumn) EntityDefinition(org.openforis.idm.metamodel.EntityDefinition) CoordinateAttributeDefinition(org.openforis.idm.metamodel.CoordinateAttributeDefinition) CodeAttributeDefinition(org.openforis.idm.metamodel.CodeAttributeDefinition)

Aggregations

CoordinateAttributeDefinition (org.openforis.idm.metamodel.CoordinateAttributeDefinition)8 CodeAttributeDefinition (org.openforis.idm.metamodel.CodeAttributeDefinition)4 CollectSurvey (org.openforis.collect.model.CollectSurvey)3 DateAttributeDefinition (org.openforis.idm.metamodel.DateAttributeDefinition)3 Coordinate (org.openforis.idm.model.Coordinate)3 ArrayList (java.util.ArrayList)2 Test (org.junit.Test)2 CodeTable (org.openforis.collect.relational.model.CodeTable)2 DataTable (org.openforis.collect.relational.model.DataTable)2 EntityDefinition (org.openforis.idm.metamodel.EntityDefinition)2 TaxonAttributeDefinition (org.openforis.idm.metamodel.TaxonAttributeDefinition)2 TextAttributeDefinition (org.openforis.idm.metamodel.TextAttributeDefinition)2 TimeAttributeDefinition (org.openforis.idm.metamodel.TimeAttributeDefinition)2 DistanceCheck (org.openforis.idm.metamodel.validation.DistanceCheck)2 Code (org.openforis.idm.model.Code)2 CoordinateAttribute (org.openforis.idm.model.CoordinateAttribute)2 List (java.util.List)1 CollectAnnotations (org.openforis.collect.metamodel.CollectAnnotations)1 UIOptions (org.openforis.collect.metamodel.ui.UIOptions)1 CoordinateAttributeFieldsOrder (org.openforis.collect.metamodel.ui.UIOptions.CoordinateAttributeFieldsOrder)1