LoanDaoHibernate.java

package org.mifos.accounts.loan.persistance;

import java.math.BigInteger;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.joda.time.LocalDate;
import org.mifos.accounts.loan.business.LoanBO;
import org.mifos.accounts.loan.util.helpers.LoanConstants;
import org.mifos.accounts.savings.persistence.GenericDao;
import org.mifos.application.NamedQueryConstants;
import org.mifos.dto.domain.SurveyDto;
import org.mifos.framework.fileupload.domain.LoanFileEntity;
import org.springframework.beans.factory.annotation.Autowired;

public class LoanDaoHibernate implements LoanDao {

    private final GenericDao genericDao;

    @Autowired
    public LoanDaoHibernate(GenericDao genericDao) {
        this.genericDao = genericDao;
    }

    @Override
    public LoanBO findByGlobalAccountNum(String globalAccountNum) {
        Map<String, String> queryParameters = new HashMap<String, String>();
        queryParameters.put("globalAccountNumber", globalAccountNum);
        return (LoanBO) this.genericDao.executeUniqueResultNamedQuery(NamedQueryConstants.FIND_LOAN_ACCOUNT_BY_SYSTEM_ID, queryParameters);
    }

    @Override
    public LoanBO findById(Integer accountId) {
        Map<String, Integer> queryParameters = new HashMap<String, Integer>();
        queryParameters.put("ACCOUNT_ID", accountId);
        return (LoanBO) this.genericDao.executeUniqueResultNamedQuery("loan.findById", queryParameters);
    }

    @SuppressWarnings("unchecked")
    @Override
    public List<SurveyDto> getAccountSurveyDto(final Integer accountId) {

        Map<String, Object> queryParameters = new HashMap<String, Object>();
        queryParameters.put("ACCOUNT_ID", accountId);
        List<Object[]> queryResult = (List<Object[]>) this.genericDao.executeNamedQuery(
                "Account.getAccountSurveyDto", queryParameters);

        if (queryResult.size() == 0) {
            return null;
        }

        List<SurveyDto> accountSurveys = new ArrayList<SurveyDto>();
        Integer instanceId;
        String surveyName;
        Date dateConducted;

        for (Object[] accountSurvey : queryResult) {
            instanceId = (Integer) accountSurvey[0];
            surveyName = (String) accountSurvey[1];
            dateConducted = (Date) accountSurvey[2];

            accountSurveys.add(new SurveyDto(instanceId, surveyName, dateConducted));
        }
        return accountSurveys;
    }

    @Override
    public void save(LoanBO loanAccount) {
        this.genericDao.createOrUpdate(loanAccount);
    }

    @Override
	@SuppressWarnings("unchecked")
    public List<LoanBO> findIndividualLoans(final Integer accountId) {

        List<LoanBO> individualLoans = new ArrayList<LoanBO>();

        Map<String, Integer> queryParameters = new HashMap<String, Integer>();
        queryParameters.put(LoanConstants.LOANACCOUNTID, accountId);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQuery(NamedQueryConstants.FIND_INDIVIDUAL_LOANS, queryParameters);
        if (queryResult != null) {
            individualLoans.addAll(queryResult);
        }

        return individualLoans;
    }

    @Override
    @SuppressWarnings("unchecked")
    public List<LoanBO> findAllLoansWaitingForApproval(int position,int noOfObjects,String ordering) {
        List<LoanBO> inapprovedLoansList = new ArrayList<LoanBO>();
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        if(ordering==null){
            ordering = "loan.globalAccountNum";
        }
        queryParameters.put("ordering",ordering);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQueryWithOffsetAndOrderAppend(NamedQueryConstants.GET_ALL_WAITING_FOR_APPROVAL_LOANS, queryParameters,position,noOfObjects);
        if (queryResult != null) {
            inapprovedLoansList.addAll(queryResult);
        }
        return inapprovedLoansList;
    }

    @Override
    @SuppressWarnings("unchecked")
    public List<LoanBO> findAllBadStandingLoans(int position,int noOfObjects,String ordering) {
        List<LoanBO> badStandingLoans = new ArrayList<LoanBO>();
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        if(ordering==null){
            ordering = "loan.globalAccountNum";
        }
        queryParameters.put("ordering",ordering);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQueryWithOffsetAndOrderAppend(NamedQueryConstants.GET_ALL_BAD_STANDING_LOANS, queryParameters,position,noOfObjects);
        if (queryResult != null) {
            badStandingLoans.addAll(queryResult);
        }
        return badStandingLoans;
    }

    @Override
    @SuppressWarnings("unchecked")
    public List<LoanBO> findLoansToBePaidCurrentWeek(int position,int noOfObjects,String ordering) {
        List<LoanBO> loans = new ArrayList<LoanBO>();
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        LocalDate lDate = new LocalDate();
        queryParameters.put("START_DATE", lDate.toDateTimeAtStartOfDay().toDate());
        lDate=lDate.plusWeeks(1);
        queryParameters.put("END_DATE",lDate.toDateTimeAtStartOfDay().toDate());
        if(ordering==null){
            ordering = "loan.globalAccountNum";
        }
        queryParameters.put("ordering",ordering);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQueryWithOffsetAndOrderAppend(NamedQueryConstants.GET_ALL_LOANS_TO_BE_PAID_CURRENT_WEEK, queryParameters,position,noOfObjects);
        if (queryResult != null) {
            loans.addAll(queryResult);
        }
        return loans;
    }

    @Override
    public int countAllBadStandingLoans() {
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        List queryResult = this.genericDao.executeNamedQuery(NamedQueryConstants.COUNT_ALL_BAD_STANDING_LOANS, queryParameters);
        return ((BigInteger) queryResult.get(0)).intValue();
    }

    @Override
    public int countAllLoansWaitingForApproval() {
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        List queryResult = this.genericDao.executeNamedQuery(NamedQueryConstants.COUNT_ALL_WAITING_FOR_APPROVAL_LOANS, queryParameters);
        return ((BigInteger) queryResult.get(0)).intValue();
    }

    @Override
    public int countLoansToBePaidCurrentWeek() {
        Map<String, String> queryParameters = new HashMap<String, String>();
        LocalDate lDate = new LocalDate();
        queryParameters.put("START_DATE", lDate.toString("yyyy-MM-dd"));
        lDate=lDate.plusWeeks(1);
        queryParameters.put("END_DATE",lDate.toString("yyyy-MM-dd"));
        List queryResult = this.genericDao.executeNamedQuery(NamedQueryConstants.COUNT_ALL_LOANS_TO_BE_PAID_CURRENT_WEEK, queryParameters);
        return ((BigInteger) queryResult.get(0)).intValue();
    }

    @Override
    public List<LoanBO> findBadStandingLoansUnderLoanOfficer(int position,int noOfObjects,Short loanOfficerId,String ordering) {
        List<LoanBO> badStandingLoans = new ArrayList<LoanBO>();
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        queryParameters.put("ID",loanOfficerId);
        if(ordering==null){
            ordering = "loan.globalAccountNum";
        }
        queryParameters.put("ordering",ordering);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQueryWithOffsetAndOrderAppend(NamedQueryConstants.GET_BAD_STANDING_LOANS_UNDER_LOANOFF, queryParameters,position,noOfObjects);
        if (queryResult != null) {
            badStandingLoans.addAll(queryResult);
        }
        return badStandingLoans;
    }

    @Override
    public int countBadStandingLoansUnderLoanOfficer(Short loanOfficerId) {
        Map<String, Short> queryParameters = new HashMap<String, Short>();
        queryParameters.put("ID",loanOfficerId);
        List queryResult = this.genericDao.executeNamedQuery(NamedQueryConstants.COUNT_BAD_STANDING_LOANS_UNDER_LOANOFF, queryParameters);
        return ((BigInteger) queryResult.get(0)).intValue();
    }

    @Override
    public List<LoanBO> findLoansWaitingForApprovalUnderLoanOfficer(int position,int noOfObjects,Short loanOfficerId,String ordering) {
        List<LoanBO> inapprovedLoansList = new ArrayList<LoanBO>();
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        queryParameters.put("ID",loanOfficerId);
        if(ordering==null){
            ordering = "loan.globalAccountNum";
        }
        queryParameters.put("ordering",ordering);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQueryWithOffsetAndOrderAppend(NamedQueryConstants.GET_WAITING_FOR_APPROVAL_LOANS_UNDER_LOANOFF, queryParameters,position,noOfObjects);
        if (queryResult != null) {
            inapprovedLoansList.addAll(queryResult);
        }
        return inapprovedLoansList;
    }

    @Override
    public int countLoansWaitingForApprovalUnderLoanOfficer(Short loanOfficerId) {
        Map<String, Short> queryParameters = new HashMap<String, Short>();
        queryParameters.put("ID",loanOfficerId);
        List queryResult = this.genericDao.executeNamedQuery(NamedQueryConstants.COUNT_WAITING_FOR_APPROVAL_LOANS_UNDER_LOANOFF, queryParameters);
        return ((BigInteger) queryResult.get(0)).intValue();
    }

    @Override
    public List<LoanBO> findLoansToBePaidCurrentWeekUnderLoanOfficer(int position,int noOfObjects,Short loanOfficerId,String ordering) {
        List<LoanBO> loans = new ArrayList<LoanBO>();
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        LocalDate lDate = new LocalDate();
        queryParameters.put("START_DATE", lDate.toDateTimeAtStartOfDay().toDate());
        lDate=lDate.plusWeeks(1);
        queryParameters.put("END_DATE",lDate.toDateTimeAtStartOfDay().toDate());
        queryParameters.put("ID",loanOfficerId);
        if(ordering==null){
            ordering = "loan.globalAccountNum";
        }
        queryParameters.put("ordering",ordering);
        List<LoanBO> queryResult = (List<LoanBO>) this.genericDao.executeNamedQueryWithOffsetAndOrderAppend(NamedQueryConstants.GET_LOANS_TO_BE_PAID_CURRENT_WEEK_UNDER_LOANOFF,queryParameters,position,noOfObjects);
        if (queryResult != null){
            loans.addAll(queryResult);
        }
        return loans;
    }

    @Override
    public int countLoansToBePaidCurrentWeekUnderLoanOfficer(Short loanOfficerId) {
        Map<String, String> queryParameters = new HashMap<String, String>();
        LocalDate lDate = new LocalDate();
        queryParameters.put("START_DATE", lDate.toString("yyyy-MM-dd"));
        lDate=lDate.plusWeeks(1);
        queryParameters.put("END_DATE",lDate.toString("yyyy-MM-dd"));
        queryParameters.put("ID",loanOfficerId.toString());
        List queryResult = this.genericDao.executeNamedQuery(NamedQueryConstants.COUNT_LOANS_TO_BE_PAID_CURRENT_WEEK_UNDER_LOANOFF, queryParameters);
        return ((BigInteger) queryResult.get(0)).intValue();
    }
    
    @Override
    public LoanFileEntity getUploadedFile(Long fileId) {
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        queryParameters.put("fileId", fileId);
        return (LoanFileEntity) this.genericDao.executeUniqueResultNamedQuery(
                NamedQueryConstants.GET_LOAN_UPLOADED_FILE, queryParameters);
    }
    
    @Override
    public List<LoanFileEntity> getLoanAllUploadedFiles(Integer loanId) {
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        queryParameters.put("loanId", loanId);
        Object result =  this.genericDao.executeNamedQuery(NamedQueryConstants.GET_LOAN_ALL_UPLOADED_FILES, queryParameters);
        return (List<LoanFileEntity>) result;
    }
    
    @Override
    public LoanFileEntity getLoanUploadedFileByName(Integer loanId, String fileName) {
        Map<String, Object> queryParameters = new HashMap<String, Object>();
        queryParameters.put("loanId", loanId);
        queryParameters.put("fileName", fileName);
        Object[] result = ((Object[])this.genericDao.executeUniqueResultNamedQuery(NamedQueryConstants.GET_LOAN_UPLOADED_FILE_BY_NAME, queryParameters));
        if (result != null) {
            return (LoanFileEntity) result[0];
        }
        return null;
    }
}