retrieveGLSL

/* #FSM-BOF-LDG-003, #FSM-BOF-LDG-002, #FSM-BOF-LDG-001 */
    @Override
    public GeneralLedger retrieveGLSL(LedgerDetails details, GLDescription description) {
        if (log.isDebugEnabled()) {
            log.debug("MCI >> retrieveGLSL");
        }

        GeneralLedger gl = null;
        try {

            if ( details.getLoanType().equalsIgnoreCase(LoanType.DACION.getValue()) ) {
                gov.bsp.lcmis.internal.domain.GeneralLedger tempGl = retrieveGlByDescRepo.retrieveGlByDesc(description.getDescription());
                gl = new GeneralLedger();
                gl.setGlId(tempGl.getGlId());
                gl.setGlCode(tempGl.getGlCode());
                gl.setGlDesc(tempGl.getGlDescription());
            }  else if (description != null) {
                Object[] glDetails = { details.getTransactionType(),
                        details.getLoanType(),
                        details.getBankStatus(),
                        details.getDebitCredit().toString(),
                        description.getDescription() };
                gl = jdbc.queryForObject(QUERY_RETRIEVE_GL_BY_DESCRIPTION, glDetails, new RowMapper<GeneralLedger>() {
                    @Override
                    public GeneralLedger mapRow(ResultSet rs, int i) throws SQLException {
                        GeneralLedger gl = new GeneralLedger();
                        gl.setGlId(rs.getInt(COLUMN_GL_ID));
                        gl.setGlCode(rs.getString(COLUMN_GL_CODE));
                        gl.setGlDesc(rs.getString(COLUMN_GL_DESCRIPTION));
                        gl.setMappingId(rs.getInt(COLUMN_GL_MAPPING_ID));
                        return gl;
                    }
                });
            }
            if (gl != null) {
            	SubsidiaryLedger sl = new SubsidiaryLedger();
            	if("BSP INTEROFFICE RECIPROCAL ACCOUNT".equals(description.getDescription())){
            		Object[] slDetails = {details.getSlDesc()};

            		sl =
                            jdbc.queryForObject(QUERY_RETRIEVE_SL_BY_GL_MAPPING_TOTAL_AMOUNT, slDetails, new RowMapper<SubsidiaryLedger>() {
                                @Override
                                public SubsidiaryLedger mapRow(ResultSet rs, int i) throws SQLException {
                                    SubsidiaryLedger sl = new SubsidiaryLedger();
                                    sl.setSlId(rs.getInt(COLUMN_SL_ID));
                                    sl.setSlCode(rs.getString(COLUMN_SL_CODE));
                                    sl.setSlDesc(rs.getString(COLUMN_SL_DESCRIPTION));
                                    return sl;
                                }
                            });
            	}else{
            		Object[] slDetails = { gl.getMappingId(), details.getBankType() };

            		sl =
                            jdbc.queryForObject(QUERY_RETRIEVE_SL_BY_GL_MAPPING, slDetails, new RowMapper<SubsidiaryLedger>() {
                                @Override
                                public SubsidiaryLedger mapRow(ResultSet rs, int i) throws SQLException {
                                    SubsidiaryLedger sl = new SubsidiaryLedger();
                                    sl.setSlId(rs.getInt(COLUMN_SL_ID));
                                    sl.setSlCode(rs.getString(COLUMN_SL_CODE));
                                    sl.setSlDesc(rs.getString(COLUMN_SL_DESCRIPTION));
                                    return sl;
                                }
                            });
            	}



                gl.setSl(sl);
            }

        } catch (EmptyResultDataAccessException e) {
            log.info("Empty result.", e.getMessage());

        } catch (DataAccessException e) {
            log.error("Error found", e);
            throw e;

        } catch (Exception e) {
            log.error("Error found", e);
            throw e;
        }

        if (log.isDebugEnabled()) {
            log.debug("MCO >> retrieveGLSL");
        }

        return gl;
    }