use of org.hisp.dhis.category.CategoryCombo in project dhis2-core by dhis2.
the class DataElementTest method testGetCategoryComboDataSet.
@Test
void testGetCategoryComboDataSet() {
CategoryCombo ccA = new CategoryCombo("CategoryComboA", DataDimensionType.DISAGGREGATION);
CategoryCombo ccB = new CategoryCombo("CategoryComboB", DataDimensionType.DISAGGREGATION);
DataSet dsA = new DataSet("DataSetA");
DataSet dsB = new DataSet("DataSetB");
DataElement deA = new DataElement("DataElementA");
DataElement deB = new DataElement("DataElementB");
deA.setCategoryCombo(ccA);
dsA.addDataSetElement(deA);
dsB.addDataSetElement(deA, ccB);
assertEquals(ccA, deA.getDataElementCategoryCombo(dsA));
assertEquals(ccB, deA.getDataElementCategoryCombo(dsB));
deB.setCategoryCombo(ccA);
dsA.addDataSetElement(deB);
assertEquals(ccA, deB.getDataElementCategoryCombo(dsA));
assertEquals(ccA, deB.getDataElementCategoryCombo(dsB));
}
use of org.hisp.dhis.category.CategoryCombo in project dhis2-core by dhis2.
the class OperandTest method testHashCode.
@Test
void testHashCode() {
DataElement dataElementA = new DataElement("DataElement A");
DataElement dataElementB = new DataElement("DataElement B");
CategoryCombo categoryComboA = new CategoryCombo("CategoryCombo A", DISAGGREGATION);
CategoryCombo categoryComboB = new CategoryCombo("CategoryCombo B", DISAGGREGATION);
CategoryCombo defaultCatCombo = new CategoryCombo(DEFAULT_CATEGORY_COMBO_NAME, DISAGGREGATION);
CategoryOptionCombo categoryOptionComboA = new CategoryOptionCombo();
categoryOptionComboA.setCategoryCombo(categoryComboA);
CategoryOptionCombo categoryOptionComboB = new CategoryOptionCombo();
categoryOptionComboB.setCategoryCombo(categoryComboB);
CategoryOptionCombo defaultCatOptionCombo = new CategoryOptionCombo();
defaultCatOptionCombo.setCategoryCombo(defaultCatCombo);
DataElementOperand dataElementOperandA = new DataElementOperand(dataElementA, categoryOptionComboA);
DataElementOperand dataElementOperandB = new DataElementOperand(dataElementB, categoryOptionComboB);
DataElementOperand dataElementOperandC = new DataElementOperand(dataElementA, categoryOptionComboB);
DataElementOperand dataElementOperandD = new DataElementOperand(dataElementB, categoryOptionComboA);
DataElementOperand dataElementOperandE = new DataElementOperand(dataElementA, categoryOptionComboA, categoryOptionComboA);
DataElementOperand dataElementOperandF = new DataElementOperand(dataElementA, categoryOptionComboB, categoryOptionComboB);
DataElementOperand dataElementOperandG = new DataElementOperand(dataElementA, categoryOptionComboA, categoryOptionComboB);
DataElementOperand dataElementOperandH = new DataElementOperand(dataElementA, categoryOptionComboB, categoryOptionComboA);
DataElementOperand dataElementOperandI = new DataElementOperand(dataElementA);
DataElementOperand dataElementOperandJ = new DataElementOperand(dataElementA, defaultCatOptionCombo);
Set<DataElementOperand> dataElementOperands = new HashSet<>();
dataElementOperands.add(dataElementOperandA);
dataElementOperands.add(dataElementOperandB);
dataElementOperands.add(dataElementOperandC);
dataElementOperands.add(dataElementOperandD);
dataElementOperands.add(dataElementOperandE);
dataElementOperands.add(dataElementOperandF);
dataElementOperands.add(dataElementOperandG);
dataElementOperands.add(dataElementOperandH);
dataElementOperands.add(dataElementOperandI);
dataElementOperands.add(dataElementOperandJ);
assertEquals(10, dataElementOperands.size());
}
use of org.hisp.dhis.category.CategoryCombo in project dhis2-core by dhis2.
the class JdbcEventAnalyticsTableManagerTest method verifyGetTableWithCategoryCombo.
@Test
void verifyGetTableWithCategoryCombo() {
Program program = createProgram('A');
Category categoryA = createCategory('A');
categoryA.setCreated(getDate(2019, 12, 3));
Category categoryB = createCategory('B');
categoryA.setCreated(getDate(2018, 8, 5));
CategoryCombo categoryCombo = createCategoryCombo('B', categoryA, categoryB);
addCategoryCombo(program, categoryCombo);
when(idObjectManager.getAllNoAcl(Program.class)).thenReturn(Lists.newArrayList(program));
when(jdbcTemplate.queryForList(getYearQueryForCurrentYear(program, true), Integer.class)).thenReturn(Lists.newArrayList(2018, 2019));
AnalyticsTableUpdateParams params = AnalyticsTableUpdateParams.newBuilder().withLastYears(2).withStartTime(START_TIME).withToday(today).build();
List<AnalyticsTable> tables = subject.getAnalyticsTables(params);
assertThat(tables, hasSize(1));
new AnalyticsTableAsserter.Builder(tables.get(0)).withTableType(AnalyticsTableType.EVENT).withTableName(TABLE_PREFIX + program.getUid().toLowerCase()).withColumnSize(52).withDefaultColumns(subject.getFixedColumns()).addColumns(periodColumns).addColumn(categoryA.getUid(), CHARACTER_11, "acs.", categoryA.getCreated()).addColumn(categoryB.getUid(), CHARACTER_11, "acs.", categoryB.getCreated()).build().verify();
}
use of org.hisp.dhis.category.CategoryCombo in project dhis2-core by dhis2.
the class HibernateDataApprovalStore method getDataApprovalStatuses.
@Override
public List<DataApprovalStatus> getDataApprovalStatuses(DataApprovalWorkflow workflow, Period period, Collection<OrganisationUnit> orgUnits, int orgUnitLevel, CategoryCombo attributeCombo, Set<CategoryOptionCombo> attributeOptionCombos, List<DataApprovalLevel> userApprovalLevels, Map<Integer, DataApprovalLevel> levelMap) {
// ---------------------------------------------------------------------
// Get validation criteria
// ---------------------------------------------------------------------
final User user = currentUserService.getCurrentUser();
final String strArrayUserGroups = CollectionUtils.isEmpty(user.getGroups()) ? null : "{" + String.join(",", user.getGroups().stream().map(group -> group.getUid()).collect(Collectors.toList())) + "}";
final String co_group_sharing_check_query = strArrayUserGroups != null ? " and (not " + JsonbFunctions.HAS_USER_GROUP_IDS + "( co.sharing, '" + strArrayUserGroups + "') or not " + JsonbFunctions.CHECK_USER_GROUPS_ACCESS + "( co.sharing, '" + AclService.LIKE_READ_METADATA + "', '" + strArrayUserGroups + "') )" : "";
List<DataApprovalLevel> approvalLevels = workflow.getSortedLevels();
Set<OrganisationUnit> userOrgUnits = user.getDataViewOrganisationUnitsWithFallback();
boolean isDefaultCombo = attributeOptionCombos != null && attributeOptionCombos.size() == 1 && categoryService.getDefaultCategoryOptionCombo().equals(attributeOptionCombos.toArray()[0]);
boolean maySeeDefaultCategoryCombo = (CollectionUtils.isEmpty(user.getCogsDimensionConstraints()) && CollectionUtils.isEmpty(user.getCatDimensionConstraints()));
if (isDefaultCombo && !maySeeDefaultCategoryCombo) {
log.warn("DefaultCategoryCombo selected but user " + user.getUsername() + " lacks permission to see it.");
// Unapprovable.
return new ArrayList<>();
}
if (CollectionUtils.isEmpty(approvalLevels)) {
log.warn("No approval levels configured for workflow " + workflow.getName());
// Unapprovable.
return new ArrayList<>();
}
if (CollectionUtils.isEmpty(userApprovalLevels)) {
log.warn("No user approval levels for user " + user.getUsername() + ", workflow " + workflow.getName());
// Unapprovable.
return new ArrayList<>();
}
if (orgUnits != null) {
for (OrganisationUnit orgUnit : orgUnits) {
if (!orgUnit.isDescendant(userOrgUnits)) {
log.debug("User " + user.getUsername() + " can't see orgUnit " + orgUnit.getName());
// Unapprovable.
return new ArrayList<>();
}
}
}
// ---------------------------------------------------------------------
// Get other information
// ---------------------------------------------------------------------
boolean acceptanceRequiredForApproval = systemSettingManager.getBoolSetting(SettingKey.ACCEPTANCE_REQUIRED_FOR_APPROVAL);
final boolean isSuperUser = currentUserService.currentUserIsSuper();
final String startDate = DateUtils.getMediumDateString(period.getStartDate());
final String endDate = DateUtils.getMediumDateString(period.getEndDate());
DataApprovalLevel highestApprovalLevel = approvalLevels.get(0);
DataApprovalLevel highestUserApprovalLevel = userApprovalLevels.get(0);
DataApprovalLevel lowestApprovalLevelForOrgUnit = null;
DataApprovalLevel approvalLevelAboveOrgUnit = null;
DataApprovalLevel approvalLevelBelowOrgUnit = null;
DataApprovalLevel approvalLevelAboveUser = null;
if (orgUnits == null) {
orgUnitLevel = approvalLevels.get(approvalLevels.size() - 1).getOrgUnitLevel();
}
for (DataApprovalLevel dal : approvalLevels) {
int dalOrgUnitLevel = dal.getOrgUnitLevel();
if (dal.getLevel() < highestUserApprovalLevel.getLevel()) {
approvalLevelAboveUser = dal;
}
if (dalOrgUnitLevel < orgUnitLevel) {
approvalLevelAboveOrgUnit = dal;
} else if (dal.getOrgUnitLevel() == orgUnitLevel) {
lowestApprovalLevelForOrgUnit = dal;
} else // dal.getOrgUnitLevel() > orgUnitLevel
{
approvalLevelBelowOrgUnit = dal;
break;
}
}
DataApprovalLevel approvedAboveLevel = null;
if (highestUserApprovalLevel.getLevel() != highestApprovalLevel.getLevel() && (orgUnits == null || orgUnitLevel == highestUserApprovalLevel.getOrgUnitLevel())) {
approvedAboveLevel = approvalLevelAboveUser;
} else if (orgUnits != null && orgUnitLevel != highestUserApprovalLevel.getOrgUnitLevel()) {
approvedAboveLevel = approvalLevelAboveOrgUnit;
}
log.debug("Workflow '" + workflow.getName() + "' levels: " + approvalLevels.size() + ", user levels: " + userApprovalLevels.size() + ", lowestApprovalLevelForOrgUnit: " + (lowestApprovalLevelForOrgUnit == null ? "-" : lowestApprovalLevelForOrgUnit.getLevel()) + ", approvalLevelAboveOrgUnit: " + (approvalLevelAboveOrgUnit == null ? "-" : approvalLevelAboveOrgUnit.getLevel()) + ", approvalLevelBelowOrgUnit: " + (approvalLevelBelowOrgUnit == null ? "-" : approvalLevelBelowOrgUnit.getLevel()) + ", approvalLevelAboveUser: " + (approvalLevelAboveUser == null ? "-" : approvalLevelAboveUser.getLevel()) + ", approvedAboveLevel: " + (approvedAboveLevel == null ? "-" : approvedAboveLevel.getLevel()));
// ---------------------------------------------------------------------
// Construct query
// ---------------------------------------------------------------------
String userOrgUnitRestrictions = "";
if (!isSuperUser && !userOrgUnits.isEmpty()) {
for (OrganisationUnit ou : userOrgUnits) {
userOrgUnitRestrictions += (userOrgUnitRestrictions.length() == 0 ? " and ( " : " or ") + statementBuilder.position("'" + ou.getUid() + "'", "o.path") + " <> 0";
}
userOrgUnitRestrictions += " )";
}
String highestApprovedOrgUnitJoin = "";
String highestApprovedOrgUnitCompare;
String orgUnitIds = "";
if (orgUnits != null) {
orgUnitIds = StringUtils.join(IdentifiableObjectUtils.getIdentifiers(orgUnits), ",");
highestApprovedOrgUnitCompare = "da.organisationunitid in (" + orgUnitIds + ") ";
} else {
highestApprovedOrgUnitJoin = "join organisationunit dao on dao.organisationunitid = da.organisationunitid ";
highestApprovedOrgUnitCompare = statementBuilder.position("dao.uid", "o.path") + " <> 0 ";
}
String userApprovalLevelRestrictions = "";
if (!isSuperUser && userApprovalLevels.size() != approvalLevels.size()) {
for (DataApprovalLevel dal : userApprovalLevels) {
userApprovalLevelRestrictions += (userApprovalLevelRestrictions.length() == 0 ? "and dal.dataapprovallevelid in ( " : ", ") + dal.getId() + " ";
}
userApprovalLevelRestrictions += ") ";
}
String coEndDateExtension = workflow.getSqlCoEndDateExtension();
// Not approved above if this is
String approvedAboveSubquery = "false";
if (approvedAboveLevel != null) {
approvedAboveSubquery = "exists ( " + "select 1 " + "from dataapproval da " + "join period p on p.periodid = da.periodid " + "join organisationunit dao on dao.organisationunitid = da.organisationunitid " + "where " + statementBuilder.position("dao.uid", "o.path") + " = " + pathPositionAtLevel(approvedAboveLevel) + " " + "and '" + endDate + "' >= p.startdate and '" + endDate + "' <= p.enddate " + "and da.dataapprovallevelid = " + approvedAboveLevel.getId() + " " + "and da.workflowid = " + workflow.getId() + " " + "and da.attributeoptioncomboid = coc.categoryoptioncomboid " + ")";
}
// Ready below if this is the lowest
String readyBelowSubquery = "true";
if (approvalLevelBelowOrgUnit != null) {
readyBelowSubquery = // Ready if nothing expected
"not exists ( " + // unapproved(/unaccepted)
"select 1 " + // Lower-level Data Approval
"from organisationunit dao " + // is needed to be ready.
"where " + statementBuilder.position("o.uid", "dao.path") + " = " + pathPositionAtLevel(orgUnitLevel) + " " + "and dao.hierarchylevel = " + approvalLevelBelowOrgUnit.getOrgUnitLevel() + " " + // Data for this workflow is collected
"and exists ( " + // somewhere at or below DAO
"select 1 from organisationunit child " + "where " + statementBuilder.position("dao.uid", "child.path") + " <> 0 " + "and child.organisationunitid in ( " + "select distinct sourceid " + "from datasetsource dss " + "join dataset ds on ds.datasetid = dss.datasetid " + "where ds.workflowid = " + workflow.getId() + ") " + ") " + (// Default combo options never have an
isDefaultCombo ? // Default combo options never have an
"" : // organisation unit mapping.
// No AOCs without all attribute
"and not exists (" + // options valid for org unit.
"select 1 " + "from categoryoptioncombos_categoryoptions cc1 " + "where cc1.categoryoptioncomboid = coc.categoryoptioncomboid " + "and ( " + // If there are orgUnit mappings...
"exists ( " + "select 1 " + "from categoryoption_organisationunits co1 " + "where co1.categoryoptionid = cc1.categoryoptionid ) " + // then one of them should map to
"and not exists (" + // this orgUnit.
"select 1 " + "from categoryoption_organisationunits co1 " + "join organisationunit o1 on o1.organisationunitid = co1.organisationunitid " + "where co1.categoryoptionid = cc1.categoryoptionid " + "and " + statementBuilder.position("o1.uid", "dao.path") + " between 2 and " + pathPositionAtLevel(approvalLevelBelowOrgUnit) + " " + ") " + ") " + ") ") + // Data not approved(/accepted) below where
"and not exists (" + // it needs to be if ready.
"select 1 from dataapproval da " + "join period p on p.periodid = da.periodid " + "where da.organisationunitid = dao.organisationunitid " + "and da.dataapprovallevelid = " + approvalLevelBelowOrgUnit.getId() + " " + "and '" + endDate + "' >= p.startdate and '" + endDate + "' <= p.enddate " + "and da.workflowid = " + workflow.getId() + " " + "and da.attributeoptioncomboid = coc.categoryoptioncomboid " + (acceptanceRequiredForApproval ? "and da.accepted " : "") + ") " + ") ";
}
final String sql = "select coc.uid as cocuid, o.uid as ouuid, o.name as ouname, " + "(select min(" + statementBuilder.concatenate(MAX_APPROVAL_LEVEL + " + dal.level", SQL_CAT, "da.accepted", SQL_CAT, "da.organisationunitid") + ") " + "from dataapproval da " + "join dataapprovallevel dal on dal.dataapprovallevelid = da.dataapprovallevelid " + highestApprovedOrgUnitJoin + "where da.workflowid = " + workflow.getId() + " " + "and da.periodid = " + getWorkflowPeriodId(workflow, endDate) + " " + "and da.attributeoptioncomboid = coc.categoryoptioncomboid " + "and " + highestApprovedOrgUnitCompare + userApprovalLevelRestrictions + ") as highest_approved, " + readyBelowSubquery + " as ready_below, " + approvedAboveSubquery + " as approved_above " + "from categoryoptioncombo coc " + "join organisationunit o on " + (orgUnits != null ? "o.organisationunitid in (" + orgUnitIds + ") " : "o.hierarchylevel = " + orgUnitLevel + userOrgUnitRestrictions + " ") + // Exclude any attribute option combo (COC)
"where not exists ( " + // unwanted attribute option (CO):
"select 1 " + "from categoryoptioncombos_categoryoptions cocco " + "join dataelementcategoryoption co on co.categoryoptionid = cocco.categoryoptionid " + "where cocco.categoryoptioncomboid = coc.categoryoptioncomboid " + "and ( " + "(co.startdate is not null and co.startdate > '" + endDate + // CO
"') " + // late.
"or (co.enddate is not null and co.enddate" + coEndDateExtension + " < '" + startDate + // CO
"') " + // early
"or ( " + // This CO has orgunit mapping
"exists ( " + "select 1 " + "from categoryoption_organisationunits coo " + "where coo.categoryoptionid = co.categoryoptionid " + // and not mapped to an orgunit we are
") and not exists (" + // looking for
"select 1 " + "from categoryoption_organisationunits coo " + "join organisationunit o2 on o2.organisationunitid = coo.organisationunitid " + "where coo.categoryoptionid = co.categoryoptionid " + "and ( " + statementBuilder.position("o.uid", "o2.path") + " <> 0 or " + statementBuilder.position("o2.uid", "o.path") + " <> 0 " + ") " + ") " + ") " + (// Filter out COs the user doesn't have
isSuperUser ? // Filter out COs the user doesn't have
"" : // permission to see.
"or ( ( co.sharing->>'public' is null or left(co.sharing->>'public', 1) != 'r' )" + " and ( co.sharing->>'owner' is null or co.sharing->>'owner' != '" + user.getUid() + "' )" + " and ( not " + JsonbFunctions.HAS_USER_ID + "( co.sharing, '" + user.getUid() + "') or not " + JsonbFunctions.CHECK_USER_ACCESS + "( co.sharing, '" + user.getUid() + "', '" + AclService.LIKE_READ_METADATA + "') )" + co_group_sharing_check_query + " )") + ") " + ") " + (attributeCombo == null ? "" : "and coc.categoryoptioncomboid in (select c9.categoryoptioncomboid from categorycombos_optioncombos c9 where c9.categorycomboid = " + attributeCombo.getId() + " ) ") + (attributeOptionCombos == null || attributeOptionCombos.isEmpty() ? "" : "and coc.categoryoptioncomboid in (" + StringUtils.join(IdentifiableObjectUtils.getIdentifiers(attributeOptionCombos), ",") + ") ") + // Filter AOCs if specified.
"and exists ( " + // mapped to a dataset of the workflow.
"select 1 from organisationunit o3 " + "where o3.path like o.path || '%' and o3.organisationunitid in ( " + "select distinct sourceid " + "from datasetsource dss " + "join dataset ds on ds.datasetid = dss.datasetid " + "where ds.workflowid = " + workflow.getId() + ") " + ")";
log.debug("User " + user.getUsername() + " superuser " + isSuperUser + " workflow " + workflow.getName() + " period " + period.getIsoDate() + " orgUnits " + (orgUnits == null ? "null" : orgUnits) + " attributeCombo " + (attributeCombo == null ? "null" : attributeCombo.getName()));
log.debug("Get approval SQL: " + sql);
// ---------------------------------------------------------------------
// Fetch query results and process them
// ---------------------------------------------------------------------
SqlRowSet rowSet = jdbcTemplate.queryForRowSet(sql);
List<DataApprovalStatus> statusList = new ArrayList<>();
while (rowSet.next()) {
final String aocUid = rowSet.getString(1);
final String ouUid = rowSet.getString(2);
final String ouName = rowSet.getString(3);
final String highestApproved = rowSet.getString(4);
final boolean readyBelow = rowSet.getBoolean(5);
boolean approvedAbove = rowSet.getBoolean(6);
final String[] approved = highestApproved == null ? null : highestApproved.split(SQL_CONCAT);
final int level = approved == null ? 0 : Integer.parseInt(approved[0]) - MAX_APPROVAL_LEVEL;
final boolean accepted = approved == null ? false : approved[1].substring(0, 1).equalsIgnoreCase("t");
final int approvedOrgUnitId = approved == null ? 0 : Integer.parseInt(approved[2]);
// null if not approved
DataApprovalLevel approvedLevel = (level == 0 ? null : levelMap.get(level));
DataApprovalLevel actionLevel = (approvedLevel == null ? lowestApprovalLevelForOrgUnit : approvedLevel);
if (approvedAbove && accepted && acceptanceRequiredForApproval && approvedAboveLevel == approvalLevelAboveUser) {
// Hide higher-level approval from user.
approvedAbove = false;
}
if (ouUid != null) {
DataApprovalState state = (approvedAbove ? APPROVED_ABOVE : approvedLevel == null ? lowestApprovalLevelForOrgUnit == null ? approvalLevelAboveOrgUnit == null ? UNAPPROVABLE : UNAPPROVED_ABOVE : readyBelow ? UNAPPROVED_READY : UNAPPROVED_WAITING : accepted ? ACCEPTED_HERE : APPROVED_HERE);
statusList.add(DataApprovalStatus.builder().state(state).approvedLevel(approvedLevel).approvedOrgUnitId(approvedOrgUnitId).actionLevel(actionLevel).organisationUnitUid(ouUid).organisationUnitName(ouName).attributeOptionComboUid(aocUid).accepted(accepted).build());
}
}
return statusList;
}
use of org.hisp.dhis.category.CategoryCombo in project dhis2-core by dhis2.
the class DataElementDefaultDimensionPopulator method executeInTransaction.
// -------------------------------------------------------------------------
// Execute
// -------------------------------------------------------------------------
@Override
public void executeInTransaction() {
Category defaultCategory = categoryService.getCategoryByName(Category.DEFAULT_NAME);
if (defaultCategory == null) {
categoryService.generateDefaultDimension();
defaultCategory = categoryService.getCategoryByName(Category.DEFAULT_NAME);
log.info("Added default category");
}
categoryService.updateCategory(defaultCategory);
String defaultName = CategoryCombo.DEFAULT_CATEGORY_COMBO_NAME;
CategoryCombo categoryCombo = categoryService.getCategoryComboByName(defaultName);
if (categoryCombo == null) {
categoryService.generateDefaultDimension();
log.info("Added default dataelement dimension");
categoryCombo = categoryService.getCategoryComboByName(defaultName);
}
// ---------------------------------------------------------------------
// Any data elements without dimensions need to be associated at least
// with the default dimension
// ---------------------------------------------------------------------
Collection<DataElement> dataElements = dataElementService.getAllDataElements();
for (DataElement dataElement : dataElements) {
if (dataElement.getCategoryCombo() == null) {
dataElement.setCategoryCombo(categoryCombo);
dataElementService.updateDataElement(dataElement);
}
}
}
Aggregations