@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;
}
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();
}
@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;
}
/*
* (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;
}