@Override public String allowDeleteCategoryOptionCombo( CategoryOptionCombo optionCombo ) { String sql = "SELECT COUNT(*) FROM datavalueaudit where categoryoptioncomboid=" + optionCombo.getId() + " or attributeoptioncomboid=" + optionCombo.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; } }
@Override public String allowDeleteCategoryOptionCombo( CategoryOptionCombo optionCombo ) { String sql = "SELECT COUNT(*) FROM datavalue where categoryoptioncomboid=" + optionCombo.getId() + " or attributeoptioncomboid=" + optionCombo.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; } }
@Override public String allowDeleteCategoryOptionCombo( CategoryOptionCombo optionCombo ) { String sql = "SELECT COUNT(*) FROM completedatasetregistration where attributeoptioncomboid=" + optionCombo.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; } }
@Override public String allowDeleteCategoryOptionCombo( CategoryOptionCombo optionCombo ) { String sql = "SELECT COUNT(*) FROM datadimensionitem where dataelementoperand_categoryoptioncomboid=" + optionCombo.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; } }
@Override public String allowDeleteCategoryOptionCombo( CategoryOptionCombo optionCombo ) { String sql = "select count(*) from dataelementoperand where categoryoptioncomboid=" + optionCombo.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; } }
@Override public String allowDeleteCategoryOptionCombo( CategoryOptionCombo optionCombo ) { String sql = "select count(*) from dataapproval where attributeoptioncomboid=" + optionCombo.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; } }
@Override public int addCategoryOptionCombo( CategoryOptionCombo dataElementCategoryOptionCombo ) { categoryOptionComboStore.save( dataElementCategoryOptionCombo ); return dataElementCategoryOptionCombo.getId(); }
@Override public String toString() { return "{" + "\"class\":\"" + getClass() + "\", " + "\"id\":\"" + getId() + "\", " + "\"uid\":\"" + getUid() + "\", " + "\"code\":\"" + getCode() + "\", " + "\"categoryCombo\":" + categoryCombo + ", " + "\"categoryOptions\":" + categoryOptions + "}"; }
private void addToAocCache( CategoryOptionCombo aoc ) { context.getAocIdMap().put( aoc.getId(), aoc ); context.getAocUidMap().put( aoc.getUid(), aoc ); }
public void addDataElementOperand( DataElementOperand deo ) { dataElementOperands.add( deo ); String deoIdKey = getDeoIds( deo.getDataElement().getId(), deo.getCategoryOptionCombo().getId() ); dataElementOperandIdMap.put( deoIdKey, deo ); }
private boolean isGreyField( org.hisp.dhis.dataset.Section section, int id, int categoryOptionComboId ) { for ( DataElementOperand operand : section.getGreyedFields() ) { if ( id == operand.getDataElement().getId() && categoryOptionComboId == operand.getCategoryOptionCombo().getId() ) { return true; } } return false; }
@Override public List<Object> getUniqueValues( MinMaxDataElement dataElement ) { return getObjectList( dataElement.getSource().getId(), dataElement.getDataElement().getId(), dataElement.getOptionCombo().getId() ); }
@Override public List<Object> getUniqueValues( CompleteDataSetRegistration registration ) { return getObjectList( registration.getDataSet().getId(), registration.getPeriod().getId(), registration.getSource().getId(), registration.getAttributeOptionCombo().getId() ); }
@Override public List<Object> getValues( DataValueAudit dataValueAudit ) { return getObjectList( dataValueAudit.getDataElement().getId(), dataValueAudit.getPeriod().getId(), dataValueAudit.getOrganisationUnit().getId(), dataValueAudit.getCategoryOptionCombo().getId(), dataValueAudit.getAttributeOptionCombo().getId(), dataValueAudit.getValue(), dataValueAudit.getModifiedBy(), getLongDateString( dataValueAudit.getCreated() ), dataValueAudit.getAuditType().toString() ); }
@Override public List<Object> getIdentifierValues( CompleteDataSetRegistration registration ) { return getObjectList( registration.getDataSet().getId(), registration.getPeriod().getId(), registration.getSource().getId(), registration.getAttributeOptionCombo().getId() ); }
@Override public List<Object> getValues( MinMaxDataElement dataElement ) { return getObjectList( dataElement.getSource().getId(), dataElement.getDataElement().getId(), dataElement.getOptionCombo().getId(), dataElement.getMin(), dataElement.getMax(), dataElement.isGenerated() ); }
@Override public List<Object> getUniqueValues( ValidationResult validationResult ) { return getObjectList( validationResult.getValidationRule().getId(), validationResult.getPeriod().getId(), validationResult.getOrganisationUnit().getId(), validationResult.getAttributeOptionCombo().getId(), validationResult.getDayInPeriod() ); }
@Override public List<Object> getValues( ValidationResult validationResult ) { return getObjectList( validationResult.getLeftsideValue(), validationResult.getRightsideValue(), validationResult.getValidationRule().getId(), validationResult.getPeriod().getId(), validationResult.getOrganisationUnit().getId(), validationResult.getAttributeOptionCombo().getId(), validationResult.getDayInPeriod() ); }