@SuppressWarnings("unchecked")
@Override
public List<AccountStateEntity> findAllAccountStateEntities() {
HashMap<String, Object> queryParameters = new HashMap<String, Object>();
queryParameters.put("prdTypeId", AccountTypes.LOAN_ACCOUNT.getValue());
List<AccountStateEntity> queryResult =
(List<AccountStateEntity>)
this.genericDao.executeNamedQuery(
NamedQueryConstants.RETRIEVEALLACCOUNTSTATES, queryParameters);
initializeAccountStates(queryResult);
List<AccountStateEntity> allStateEntities = new ArrayList<AccountStateEntity>(queryResult);
queryParameters = new HashMap<String, Object>();
queryParameters.put("prdTypeId", AccountTypes.SAVINGS_ACCOUNT.getValue());
queryResult =
(List<AccountStateEntity>)
this.genericDao.executeNamedQuery(
NamedQueryConstants.RETRIEVEALLACCOUNTSTATES, queryParameters);
initializeAccountStates(queryResult);
allStateEntities.addAll(queryResult);
return allStateEntities;
}
public List<AccountBO> findApprovedLoansForClientWithPhoneNumber(String phoneNumber)
throws PersistenceException {
Map<String, Object> queryParameters = new HashMap<String, Object>();
queryParameters.put("phoneNumberStripped", MifosStringUtils.removeNondigits(phoneNumber));
queryParameters.put("loanAccountTypeId", AccountTypes.LOAN_ACCOUNT.getValue());
return executeNamedQuery(
NamedQueryConstants.FIND_APPROVED_LOANS_FOR_CLIENT_WITH_PHONE_NUMBER, queryParameters);
}
public AccountBO findLoanByClientPhoneNumberAndProductShortName(
String phoneNumber, String productShortName) throws PersistenceException {
Map<String, Object> queryParameters = new HashMap<String, Object>();
queryParameters.put("phoneNumberStripped", MifosStringUtils.removeNondigits(phoneNumber));
queryParameters.put("loanAccountTypeId", AccountTypes.LOAN_ACCOUNT.getValue());
queryParameters.put("productShortName", productShortName);
Object queryResult =
execUniqueResultNamedQuery(
NamedQueryConstants.FIND_LOAN_ACCOUNT_BY_CLIENT_PHONE_NUMBER_AND_PRODUCT_SHORT_NAME,
queryParameters);
return queryResult == null ? null : (AccountBO) queryResult;
}
public AccountBO findLoanByClientGovernmentIdAndProductShortName(
String clientGovernmentId, String productShortName) throws PersistenceException {
Map<String, Object> queryParameters = new HashMap<String, Object>();
queryParameters.put("clientGovernmentId", clientGovernmentId);
queryParameters.put("loanAccountTypeId", AccountTypes.LOAN_ACCOUNT.getValue());
queryParameters.put("productShortName", productShortName);
Object queryResult =
execUniqueResultNamedQuery(
NamedQueryConstants.FIND_LOAN_ACCOUNT_BY_CLIENT_GOVERNMENT_ID_AND_PRODUCT_SHORT_NAME,
queryParameters);
return queryResult == null ? null : (AccountBO) queryResult;
}
