コード例 #1
0
  @Override
  public Collection<MifosEntityAccessData> retrieveEntityAccessFor(
      Long firstEntityId,
      MifosEntityType firstEntityType,
      MifosEntityAccessType accessType,
      MifosEntityType secondEntityType,
      boolean includeAllSubOffices) {
    final AppUser currentUser = this.context.authenticatedUser();

    final String hierarchy = currentUser.getOffice().getHierarchy();
    String hierarchySearchString = null;
    if (includeAllSubOffices) {
      hierarchySearchString = "." + "%";
    } else {
      hierarchySearchString = hierarchy + "%";
    }
    String sql = getSQLForRetriveEntityAccessFor(firstEntityType, accessType, secondEntityType);

    Collection<MifosEntityAccessData> entityAccessData = null;
    MifosEntityAccessDataMapper mapper = new MifosEntityAccessDataMapper();

    if (includeAllSubOffices && (firstEntityType.getTable().equals("m_office"))) {
      sql += " where firstentity.hierarchy like ? order by firstEntity.hierarchy";
      entityAccessData =
          this.jdbcTemplate.query(sql, mapper, new Object[] {firstEntityId, hierarchySearchString});
    } else {
      entityAccessData = this.jdbcTemplate.query(sql, mapper, new Object[] {firstEntityId});
    }

    return entityAccessData;
  }
コード例 #2
0
 private String getSQLForRetriveEntityAccessFor(
     MifosEntityType firstEntityType,
     MifosEntityAccessType accessType,
     MifosEntityType secondEntityType) {
   StringBuffer str =
       new StringBuffer("select eea.entity_id as entity_id, entity_type as entity_type, ");
   str.append(
       "access_type_code_value_id as access_id, cv.code_value as access_type_desc, c.code_name as code, ");
   str.append("firstentity.id as first_entity_id, firstentity.name as entity_name, ");
   str.append("otherentity.id as second_entity_id, otherentity.name as second_entity_name, ");
   str.append("eea.second_entity_type as second_entity_type ");
   str.append("from m_entity_to_entity_access eea ");
   str.append("left join m_code_value cv on (cv.code_value = ");
   str.append("'");
   str.append(accessType.toStr());
   str.append("' ");
   str.append("and eea.access_type_code_value_id = cv.id) ");
   str.append("left join m_code c on (c.code_name = '");
   str.append(MifosEntityAccessConstants.ENTITY_ACCESS_CODENAME);
   str.append("' and cv.code_id = c.id) ");
   str.append("left join ");
   str.append(firstEntityType.getTable());
   str.append(" firstentity on (eea.entity_type = ");
   str.append("'");
   str.append(firstEntityType.getType());
   str.append("'");
   str.append(" and eea.entity_id = firstentity.id)        left join ");
   str.append(secondEntityType.getTable());
   str.append(" otherentity on (eea.second_entity_type = ");
   str.append("'");
   str.append(secondEntityType.getType());
   str.append("' ");
   str.append("and eea.second_entity_id = otherentity.id) ");
   str.append("where eea.access_type_code_value_id = cv.id ");
   str.append("and eea.entity_id = ? ");
   logger.debug(str.toString());
   return str.toString();
 }
コード例 #3
0
    @Override
    public MifosEntityAccessData mapRow(
        final ResultSet rs, @SuppressWarnings("unused") final int rowNum) throws SQLException {
      final String entityType = rs.getString("entity_type");
      final Long entityId = rs.getLong("entity_id");
      final String entityName = rs.getString("entity_name");
      final Long accessId = rs.getLong("access_id");
      final String accessTypeDesc = rs.getString("access_type_desc");
      final String code = rs.getString("code");
      final Long secondEntityId = rs.getLong("second_entity_id");
      final String secondEntityName = rs.getString("second_entity_name");
      final String secondEntityType = rs.getString("second_entity_type");

      MifosEntity firstEntity = null;
      MifosEntityType etype = MifosEntityType.get(entityType);
      if (entityId != null && etype != null) {
        firstEntity = new MifosEntity(entityId, etype);
      }

      MifosEntity secondEntity = null;
      MifosEntityType secondetype = MifosEntityType.get(secondEntityType);
      if (entityId != null && etype != null) {
        secondEntity = new MifosEntity(secondEntityId, secondetype);
      }

      MifosEntityAccessType accessType = null;
      if (accessTypeDesc != null) {
        accessType = MifosEntityAccessType.get(accessTypeDesc);
      }

      MifosEntityAccessData returnMifosEntityAccessData = null;
      if (firstEntity != null && secondEntity != null && accessType != null) {
        returnMifosEntityAccessData =
            new MifosEntityAccessData(firstEntity, accessType, secondEntity);
      }
      return returnMifosEntityAccessData;
    }
コード例 #4
0
  /*
   * (non-Javadoc)
   * @see org.mifosplatform.infrastructure.entityaccess.service.MifosEntityAccessReadService#getSQLQueryWithListOfIDsForEntityAccess
   *          (Long,
   *                  org.mifosplatform.infrastructure.entityaccess.domain.MifosEntityType,
   *                  org.mifosplatform.infrastructure.entityaccess.domain.MifosEntityAccessType,
   *                  org.mifosplatform.infrastructure.entityaccess.domain.MifosEntityType,
   *                  boolean)
   *
   * This method returns the list of entity IDs as a comma separated list
   * Or null if there is no entity restrictions or if there
   */
  @Override
  public String getSQLQueryInClause_WithListOfIDsForEntityAccess(
      Long firstEntityId,
      MifosEntityType firstEntityType,
      MifosEntityAccessType accessType,
      MifosEntityType secondEntityType,
      boolean includeAllOffices) {
    Collection<MifosEntityAccessData> accesslist =
        retrieveEntityAccessFor(
            firstEntityId, firstEntityType, accessType, secondEntityType, includeAllOffices);
    String returnIdListStr = null;
    StringBuffer accessListCSVStrBuf = null;
    if ((accesslist != null) && (accesslist.size() > 0)) {
      logger.debug(
          "Found "
              + accesslist.size()
              + " access type restrictions while getting entity access configuration for "
              + firstEntityType.getType()
              + ":"
              + firstEntityId
              + " with type "
              + accessType.toStr()
              + " against "
              + secondEntityType.getType());
      accessListCSVStrBuf = new StringBuffer(" ");
      for (int i = 0; i < accesslist.size(); i++) {
        MifosEntityAccessData accessData = (MifosEntityAccessData) accesslist.toArray()[i];
        if (accessData == null) {
          throw new MifosEntityAccessConfigurationException(
              firstEntityId, firstEntityType, accessType, secondEntityType);
        }
        if (accessData.getSecondEntity().getId()
            == 0) { // If there is any ID that zero, then allow access to all
          accessListCSVStrBuf = null;
          break;
        }
        if (i > 0) {
          accessListCSVStrBuf.append(',');
        }
        accessListCSVStrBuf.append(accessData.getSecondEntity().getId());
      }

    } else {
      logger.debug(
          "Found zero access type restrictions while getting entity access configuration for "
              + firstEntityType.getType()
              + ":"
              + firstEntityId
              + " with type "
              + accessType.toStr()
              + " against "
              + secondEntityType.getType());
      accessListCSVStrBuf = new StringBuffer();
      accessListCSVStrBuf.append("false"); // Append false so that no rows will be returned
    }
    if (accessListCSVStrBuf != null) {
      returnIdListStr = accessListCSVStrBuf.toString();
    }
    logger.debug("List of IDs applicable:" + returnIdListStr);
    return returnIdListStr;
  }