use of org.hisp.dhis.feedback.ErrorMessage in project dhis2-core by dhis2.
the class DefaultQueryValidator method validateForErrorMessage.
@Override
public ErrorMessage validateForErrorMessage(DataQueryParams params) {
ErrorMessage error = null;
if (params == null) {
throw new IllegalQueryException(ErrorCode.E7100);
}
final List<DimensionalItemObject> dataElements = Lists.newArrayList(params.getDataElements());
params.getProgramDataElements().forEach(pde -> dataElements.add(((ProgramDataElementDimensionItem) pde).getDataElement()));
final List<DataElement> nonAggDataElements = FilterUtils.inverseFilter(asTypedList(dataElements), AggregatableDataElementFilter.INSTANCE);
if (!params.isSkipDataDimensionValidation()) {
if (params.getDimensions().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7101);
} else if (!params.isSkipData() && params.getDataDimensionAndFilterOptions().isEmpty() && params.getAllDataElementGroups().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7102);
} else if (!params.getDimensionsAsFilters().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7103, getDimensions(params.getDimensionsAsFilters()));
}
}
if (!params.hasPeriods() && !params.isSkipPartitioning() && !params.hasStartEndDate()) {
error = new ErrorMessage(ErrorCode.E7104);
} else if (params.hasPeriods() && params.hasStartEndDate()) {
error = new ErrorMessage(ErrorCode.E7105);
} else if (params.hasStartEndDate() && params.startDateAfterEndDate()) {
error = new ErrorMessage(ErrorCode.E7106);
} else if (params.hasStartEndDate() && !params.getReportingRates().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7107);
} else if ((!params.getFilterIndicators().isEmpty() || !params.getFilterProgramIndicators().isEmpty()) && params.getFilterOptions(DATA_X_DIM_ID).size() > 1) {
error = new ErrorMessage(ErrorCode.E7108);
} else if (!params.getFilterReportingRates().isEmpty() && params.getFilterOptions(DATA_X_DIM_ID).size() > 1) {
error = new ErrorMessage(ErrorCode.E7109);
} else if (params.getFilters().contains(new BaseDimensionalObject(CATEGORYOPTIONCOMBO_DIM_ID))) {
error = new ErrorMessage(ErrorCode.E7110);
} else if (!params.getDuplicateDimensions().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7111, getDimensions(params.getDuplicateDimensions()));
} else if (!params.getAllReportingRates().isEmpty() && !params.containsOnlyDimensionsAndFilters(COMPLETENESS_DIMENSION_TYPES)) {
error = new ErrorMessage(ErrorCode.E7112, COMPLETENESS_DIMENSION_TYPES);
} else if (params.hasDimensionOrFilter(CATEGORYOPTIONCOMBO_DIM_ID) && params.getAllDataElements().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7113);
} else if (params.hasDimensionOrFilter(CATEGORYOPTIONCOMBO_DIM_ID) && (params.getAllDataElements().size() != params.getAllDataDimensionItems().size())) {
error = new ErrorMessage(ErrorCode.E7114);
} else if (!nonAggDataElements.isEmpty()) {
error = new ErrorMessage(ErrorCode.E7115, getUids(nonAggDataElements));
} else if (!params.getSkipTotalDataElements().isEmpty()) {
error = new ErrorMessage(ErrorCode.E7134);
} else if (params.isOutputFormat(OutputFormat.DATA_VALUE_SET)) {
if (!params.hasDimension(DATA_X_DIM_ID)) {
error = new ErrorMessage(ErrorCode.E7117);
} else if (!params.hasDimension(PERIOD_DIM_ID)) {
error = new ErrorMessage(ErrorCode.E7118);
} else if (!params.hasDimension(ORGUNIT_DIM_ID)) {
error = new ErrorMessage(ErrorCode.E7119);
}
}
return error;
}
use of org.hisp.dhis.feedback.ErrorMessage in project dhis2-core by dhis2.
the class DefaultDataQueryService method getDimension.
// TODO Optimize so that org unit levels + boundary are used in query
// instead of fetching all org units one by one.
@Override
public DimensionalObject getDimension(String dimension, List<String> items, Date relativePeriodDate, List<OrganisationUnit> userOrgUnits, I18nFormat format, boolean allowNull, boolean allowAllPeriodItems, IdScheme inputIdScheme) {
final boolean allItems = items.isEmpty();
User user = currentUserService.getCurrentUser();
if (DATA_X_DIM_ID.equals(dimension)) {
List<DimensionalItemObject> dataDimensionItems = new ArrayList<>();
DimensionItemKeywords dimensionalKeywords = new DimensionItemKeywords();
for (String uid : items) {
if (// DATA ELEMENT GROUP
uid.startsWith(KEY_DE_GROUP)) {
String groupUid = DimensionalObjectUtils.getUidFromGroupParam(uid);
DataElementGroup group = idObjectManager.getObject(DataElementGroup.class, inputIdScheme, groupUid);
if (group != null) {
dataDimensionItems.addAll(group.getMembers());
dimensionalKeywords.addKeyword(group);
}
} else if (// INDICATOR GROUP
uid.startsWith(KEY_IN_GROUP)) {
String groupUid = DimensionalObjectUtils.getUidFromGroupParam(uid);
IndicatorGroup group = idObjectManager.getObject(IndicatorGroup.class, inputIdScheme, groupUid);
if (group != null) {
dataDimensionItems.addAll(group.getMembers());
dimensionalKeywords.addKeyword(group);
}
} else {
DimensionalItemObject dimItemObject = dimensionService.getDataDimensionalItemObject(inputIdScheme, uid);
if (dimItemObject != null) {
dataDimensionItems.add(dimItemObject);
}
}
}
if (dataDimensionItems.isEmpty()) {
throwIllegalQueryEx(ErrorCode.E7124, DimensionalObject.DATA_X_DIM_ID);
}
return new BaseDimensionalObject(dimension, DimensionType.DATA_X, null, DISPLAY_NAME_DATA_X, dataDimensionItems, dimensionalKeywords);
} else if (CATEGORYOPTIONCOMBO_DIM_ID.equals(dimension)) {
return new BaseDimensionalObject(dimension, DimensionType.CATEGORY_OPTION_COMBO, null, DISPLAY_NAME_CATEGORYOPTIONCOMBO, getCategoryOptionComboList(items, inputIdScheme));
} else if (ATTRIBUTEOPTIONCOMBO_DIM_ID.equals(dimension)) {
return new BaseDimensionalObject(dimension, DimensionType.ATTRIBUTE_OPTION_COMBO, null, DISPLAY_NAME_ATTRIBUTEOPTIONCOMBO, getCategoryOptionComboList(items, inputIdScheme));
} else if (PERIOD_DIM_ID.equals(dimension)) {
Calendar calendar = PeriodType.getCalendar();
I18n i18n = i18nManager.getI18n();
List<Period> periods = new ArrayList<>();
DimensionItemKeywords dimensionalKeywords = new DimensionItemKeywords();
AnalyticsFinancialYearStartKey financialYearStart = systemSettingManager.getSystemSetting(SettingKey.ANALYTICS_FINANCIAL_YEAR_START, AnalyticsFinancialYearStartKey.class);
boolean containsRelativePeriods = false;
for (String isoPeriod : items) {
// Contains isoPeriod and timeField
IsoPeriodHolder isoPeriodHolder = IsoPeriodHolder.of(isoPeriod);
if (RelativePeriodEnum.contains(isoPeriodHolder.getIsoPeriod())) {
containsRelativePeriods = true;
RelativePeriodEnum relativePeriod = RelativePeriodEnum.valueOf(isoPeriodHolder.getIsoPeriod());
dimensionalKeywords.addKeyword(isoPeriodHolder.getIsoPeriod(), i18n.getString(isoPeriodHolder.getIsoPeriod()));
List<Period> relativePeriods = RelativePeriods.getRelativePeriodsFromEnum(relativePeriod, relativePeriodDate, format, true, financialYearStart);
// If custom time filter is specified, set it in periods
if (isoPeriodHolder.hasDateField()) {
relativePeriods.forEach(period -> period.setDateField(isoPeriodHolder.getDateField()));
}
periods.addAll(relativePeriods);
} else {
Period period = PeriodType.getPeriodFromIsoString(isoPeriodHolder.getIsoPeriod());
if (period != null) {
if (isoPeriodHolder.hasDateField()) {
period.setDescription(isoPeriodHolder.getIsoPeriod());
period.setDateField(isoPeriodHolder.getDateField());
}
dimensionalKeywords.addKeyword(isoPeriodHolder.getIsoPeriod(), format != null ? i18n.getString(format.formatPeriod(period)) : isoPeriodHolder.getIsoPeriod());
periods.add(period);
} else {
tryParseDateRange(isoPeriodHolder).ifPresent(periods::add);
}
}
}
// Remove duplicates
periods = periods.stream().distinct().collect(Collectors.toList());
if (containsRelativePeriods) {
periods.sort(new AscendingPeriodComparator());
}
for (Period period : periods) {
String name = format != null ? format.formatPeriod(period) : null;
if (!period.getPeriodType().getName().contains(WeeklyPeriodType.NAME)) {
period.setShortName(name);
}
period.setName(name);
if (!calendar.isIso8601()) {
period.setUid(getLocalPeriodIdentifier(period, calendar));
}
}
return new BaseDimensionalObject(dimension, DimensionType.PERIOD, null, DISPLAY_NAME_PERIOD, asList(periods), dimensionalKeywords);
} else if (ORGUNIT_DIM_ID.equals(dimension)) {
List<DimensionalItemObject> ous = new ArrayList<>();
List<Integer> levels = new ArrayList<>();
List<OrganisationUnitGroup> groups = new ArrayList<>();
for (String ou : items) {
if (KEY_USER_ORGUNIT.equals(ou) && userOrgUnits != null && !userOrgUnits.isEmpty()) {
ous.addAll(userOrgUnits);
} else if (KEY_USER_ORGUNIT_CHILDREN.equals(ou) && userOrgUnits != null && !userOrgUnits.isEmpty()) {
ous.addAll(OrganisationUnit.getSortedChildren(userOrgUnits));
} else if (KEY_USER_ORGUNIT_GRANDCHILDREN.equals(ou) && userOrgUnits != null && !userOrgUnits.isEmpty()) {
ous.addAll(OrganisationUnit.getSortedGrandChildren(userOrgUnits));
} else if (ou != null && ou.startsWith(KEY_LEVEL)) {
String level = DimensionalObjectUtils.getValueFromKeywordParam(ou);
Integer orgUnitLevel = organisationUnitService.getOrganisationUnitLevelByLevelOrUid(level);
if (orgUnitLevel != null) {
levels.add(orgUnitLevel);
}
} else if (ou != null && ou.startsWith(KEY_ORGUNIT_GROUP)) {
String uid = DimensionalObjectUtils.getUidFromGroupParam(ou);
OrganisationUnitGroup group = idObjectManager.getObject(OrganisationUnitGroup.class, inputIdScheme, uid);
if (group != null) {
groups.add(group);
}
} else if (!inputIdScheme.is(IdentifiableProperty.UID) || CodeGenerator.isValidUid(ou)) {
OrganisationUnit unit = idObjectManager.getObject(OrganisationUnit.class, inputIdScheme, ou);
if (unit != null) {
ous.add(unit);
}
}
}
// Remove duplicates
ous = ous.stream().distinct().collect(Collectors.toList());
List<DimensionalItemObject> orgUnits = new ArrayList<>();
List<OrganisationUnit> ousList = asTypedList(ous);
DimensionItemKeywords dimensionalKeywords = new DimensionItemKeywords();
if (!levels.isEmpty()) {
orgUnits.addAll(sort(organisationUnitService.getOrganisationUnitsAtLevels(levels, ousList)));
dimensionalKeywords.addKeywords(levels.stream().map(level -> organisationUnitService.getOrganisationUnitLevelByLevel(level)).filter(Objects::nonNull).collect(Collectors.toList()));
}
if (!groups.isEmpty()) {
orgUnits.addAll(sort(organisationUnitService.getOrganisationUnits(groups, ousList)));
dimensionalKeywords.addKeywords(groups.stream().map(group -> new BaseNameableObject(group.getUid(), group.getCode(), group.getName())).collect(Collectors.toList()));
}
if (levels.isEmpty() && groups.isEmpty()) {
orgUnits.addAll(ous);
}
if (!dimensionalKeywords.isEmpty()) {
dimensionalKeywords.addKeywords(ousList);
}
if (orgUnits.isEmpty()) {
throwIllegalQueryEx(ErrorCode.E7124, DimensionalObject.ORGUNIT_DIM_ID);
}
// Remove duplicates
orgUnits = orgUnits.stream().distinct().collect(Collectors.toList());
return new BaseDimensionalObject(dimension, DimensionType.ORGANISATION_UNIT, null, DISPLAY_NAME_ORGUNIT, orgUnits, dimensionalKeywords);
} else if (ORGUNIT_GROUP_DIM_ID.equals(dimension)) {
List<DimensionalItemObject> ougs = new ArrayList<>();
for (String uid : items) {
OrganisationUnitGroup organisationUnitGroup = idObjectManager.getObject(OrganisationUnitGroup.class, inputIdScheme, uid);
if (organisationUnitGroup != null) {
ougs.add(organisationUnitGroup);
}
}
return new BaseDimensionalObject(dimension, DimensionType.ORGANISATION_UNIT_GROUP, null, DISPLAY_NAME_ORGUNIT_GROUP, ougs);
} else if (LONGITUDE_DIM_ID.contains(dimension)) {
return new BaseDimensionalObject(dimension, DimensionType.STATIC, null, DISPLAY_NAME_LONGITUDE, new ArrayList<>());
} else if (LATITUDE_DIM_ID.contains(dimension)) {
return new BaseDimensionalObject(dimension, DimensionType.STATIC, null, DISPLAY_NAME_LATITUDE, new ArrayList<>());
} else {
DimensionalObject dimObject = idObjectManager.get(DataQueryParams.DYNAMIC_DIM_CLASSES, inputIdScheme, dimension);
if (dimObject != null && dimObject.isDataDimension()) {
Class<?> dimClass = HibernateProxyUtils.getRealClass(dimObject);
Class<? extends DimensionalItemObject> itemClass = DimensionalObject.DIMENSION_CLASS_ITEM_CLASS_MAP.get(dimClass);
List<DimensionalItemObject> dimItems = !allItems ? asList(idObjectManager.getOrdered(itemClass, inputIdScheme, items)) : getCanReadItems(user, dimObject);
return new BaseDimensionalObject(dimObject.getDimension(), dimObject.getDimensionType(), null, dimObject.getName(), dimItems, allItems);
}
}
if (allowNull) {
return null;
}
throw new IllegalQueryException(new ErrorMessage(ErrorCode.E7125, dimension));
}
use of org.hisp.dhis.feedback.ErrorMessage in project dhis2-core by dhis2.
the class DefaultSqlViewService method validateSqlView.
@Override
public void validateSqlView(SqlView sqlView, Map<String, String> criteria, Map<String, String> variables) throws IllegalQueryException {
ErrorMessage error = null;
if (sqlView == null || sqlView.getSqlQuery() == null) {
throw new IllegalQueryException(ErrorCode.E4300);
}
final Set<String> sqlVars = SqlViewUtils.getVariables(sqlView.getSqlQuery());
final String sql = sqlView.getSqlQuery().replaceAll("\\r|\\n", " ").toLowerCase();
final boolean ignoreSqlViewTableProtection = config.isDisabled(ConfigurationKey.SYSTEM_SQL_VIEW_TABLE_PROTECTION);
final Set<String> allowedVariables = variables == null ? STANDARD_VARIABLES : Sets.union(variables.keySet(), STANDARD_VARIABLES);
if (!SELECT_PATTERN.matcher(sql).matches()) {
error = new ErrorMessage(ErrorCode.E4301);
}
if (sql.contains(";") && !sql.trim().endsWith(";")) {
error = new ErrorMessage(ErrorCode.E4302);
}
if (variables != null && variables.containsKey(null)) {
error = new ErrorMessage(ErrorCode.E4303);
}
if (variables != null && variables.containsValue(null)) {
error = new ErrorMessage(ErrorCode.E4304);
}
if (variables != null && !getInvalidQueryParams(variables.keySet()).isEmpty()) {
error = new ErrorMessage(ErrorCode.E4305, getInvalidQueryParams(variables.keySet()));
}
if (variables != null && !getInvalidQueryValues(variables.values()).isEmpty()) {
error = new ErrorMessage(ErrorCode.E4306, getInvalidQueryValues(variables.values()));
}
if (sqlView.isQuery() && !sqlVars.isEmpty() && (!allowedVariables.containsAll(sqlVars))) {
error = new ErrorMessage(ErrorCode.E4307, sqlVars);
}
if (sqlView.isQuery() && !sqlVars.isEmpty() && !getInvalidQueryParams(sqlVars).isEmpty()) {
error = new ErrorMessage(ErrorCode.E4313, getInvalidQueryParams(sqlVars));
}
if (criteria != null && !getInvalidQueryParams(criteria.keySet()).isEmpty()) {
error = new ErrorMessage(ErrorCode.E4308, getInvalidQueryParams(criteria.keySet()));
}
if (criteria != null && !getInvalidQueryValues(criteria.values()).isEmpty()) {
error = new ErrorMessage(ErrorCode.E4309, getInvalidQueryValues(criteria.values()));
}
if (!ignoreSqlViewTableProtection && sql.matches(SqlView.getProtectedTablesRegex())) {
error = new ErrorMessage(ErrorCode.E4310);
}
if (sql.matches(SqlView.getIllegalKeywordsRegex())) {
error = new ErrorMessage(ErrorCode.E4311);
}
if (error != null) {
log.warn(String.format("Validation failed for SQL view '%s' with code: '%s' and message: '%s'", sqlView.getUid(), error.getErrorCode(), error.getMessage()));
throw new IllegalQueryException(error);
}
}
use of org.hisp.dhis.feedback.ErrorMessage in project dhis2-core by dhis2.
the class DefaultEventQueryValidator method validate.
// -------------------------------------------------------------------------
// EventQueryValidator implementation
// -------------------------------------------------------------------------
@Override
public void validate(EventQueryParams params) throws IllegalQueryException, MaintenanceModeException {
queryValidator.validateMaintenanceMode();
ErrorMessage error = validateForErrorMessage(params);
if (error != null) {
log.warn(String.format("Event analytics validation failed, code: '%s', message: '%s'", error.getErrorCode(), error.getMessage()));
throw new IllegalQueryException(error);
}
}
use of org.hisp.dhis.feedback.ErrorMessage in project dhis2-core by dhis2.
the class DefaultEventDataQueryService method getValueDimension.
private DimensionalItemObject getValueDimension(String value) {
if (value == null) {
return null;
}
DataElement de = dataElementService.getDataElement(value);
if (de != null && de.isNumericType()) {
return de;
}
TrackedEntityAttribute at = attributeService.getTrackedEntityAttribute(value);
if (at != null && at.isNumericType()) {
return at;
}
throw new IllegalQueryException(new ErrorMessage(ErrorCode.E7223, value));
}
Aggregations