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;
}
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;
}
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;
}
Aggregations