private String buildTellerTransactionQuery()

in service/src/main/java/org/apache/fineract/cn/reporting/service/internal/specification/TellerTransactionReportSpecification.java [342:381]

32 lines of code
6 McCabe index (conditional complexity)


    private String buildTellerTransactionQuery(final ReportRequest reportRequest, final String tellerIdentifier) {

        final StringBuilder query = new StringBuilder("SELECT ");

        final List<DisplayableField> displayableFields = reportRequest.getDisplayableFields();
        final ArrayList<String> columns = new ArrayList<>();
        displayableFields.forEach(displayableField -> {
            final String column = this.transactionColumnMapping.get(displayableField.getName());
            if (column != null) {
                columns.add(column);
            }
        });

        query.append(columns.stream().collect(Collectors.joining(", ")))
                .append(" FROM ")
                .append("tajet_teller_transactions trx " +
                        "LEFT JOIN tajet_teller teller on trx.teller_id = teller.id ");

        query.append("WHERE teller.id ='" + tellerIdentifier + "'");

        final List<QueryParameter> queryParameters = reportRequest.getQueryParameters();
        if (!queryParameters.isEmpty()) {
            final ArrayList<String> criteria = new ArrayList<>();
            queryParameters.forEach(queryParameter -> {
                if (queryParameter.getValue() != null && !queryParameter.getValue().isEmpty()) {
                    criteria.add(
                            CriteriaBuilder.buildCriteria(this.transactionColumnMapping.get(queryParameter.getName()), queryParameter)
                    );
                }
            });

            if (!criteria.isEmpty()) {
                query.append(" AND ");
                query.append(criteria.stream().collect(Collectors.joining(" AND ")));
            }

        }

        return query.toString();
    }