Java tutorial
/* This file is part of Cyclos (www.cyclos.org). A project of the Social Trade Organisation (www.socialtrade.org). Cyclos is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. Cyclos is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with Cyclos; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package nl.strohalm.cyclos.controls.reports.members.transactions; import java.math.BigDecimal; import java.util.Collection; import java.util.Iterator; import java.util.List; import java.util.Map; import nl.strohalm.cyclos.annotations.Inject; import nl.strohalm.cyclos.controls.ActionContext; import nl.strohalm.cyclos.controls.BaseCsvAction; import nl.strohalm.cyclos.entities.access.User; import nl.strohalm.cyclos.entities.accounts.transactions.PaymentFilter; import nl.strohalm.cyclos.entities.members.MemberTransactionSummaryReportData; import nl.strohalm.cyclos.entities.settings.LocalSettings; import nl.strohalm.cyclos.services.transactions.TransactionSummaryVO; import nl.strohalm.cyclos.services.transfertypes.PaymentFilterService; import nl.strohalm.cyclos.utils.EntityHelper; import nl.strohalm.cyclos.utils.IteratorListImpl; import nl.strohalm.cyclos.utils.Pair; import nl.strohalm.cyclos.utils.SpringHelper; import nl.strohalm.cyclos.utils.conversion.Converter; import nl.strohalm.cyclos.utils.csv.CSVWriter; import org.apache.commons.collections.IteratorUtils; import org.apache.commons.collections.Predicate; public class ExportMembersTransactionsReportToCsvAction extends BaseCsvAction { class SummaryByPaymentFilterConverter implements Converter<Map<PaymentFilter, TransactionSummaryVO>> { private static final long serialVersionUID = -4821798713533063020L; private final PaymentFilter paymentFilter; private final boolean isCount; SummaryByPaymentFilterConverter(final PaymentFilter paymentFilter, final boolean isCount) { this.paymentFilter = paymentFilter; this.isCount = isCount; } @Override public String toString(final Map<PaymentFilter, TransactionSummaryVO> map) { String string = ""; final TransactionSummaryVO vo = map.get(paymentFilter); if (vo != null) { if (isCount) { final int count = vo.getCount(); string = "" + count; } else { final BigDecimal amount = vo.getAmount(); string = settingsService.getLocalSettings().getNumberConverter().toString(amount); } } return string; } @Override public Map<PaymentFilter, TransactionSummaryVO> valueOf(final String string) { return null; } } class TransactionSummaryVOConverter implements Converter<TransactionSummaryVO> { private static final long serialVersionUID = -3481170993171107591L; private final boolean isCount; TransactionSummaryVOConverter(final boolean isCount) { this.isCount = isCount; } @Override public String toString(final TransactionSummaryVO vo) { String string = ""; if (vo != null) { if (isCount) { final int count = vo.getCount(); string = "" + count; } else { final BigDecimal amount = vo.getAmount(); string = settingsService.getLocalSettings().getNumberConverter().toString(amount); } } return string; } @Override public TransactionSummaryVO valueOf(final String string) { return null; } } private MembersReportHandler reportHandler; private PaymentFilterService paymentFilterService; public MembersReportHandler getReportHandler() { if (reportHandler == null) { reportHandler = new MembersReportHandler(settingsService.getLocalSettings()); SpringHelper.injectBeans(getServlet().getServletContext(), reportHandler); } return reportHandler; } @Inject public void setPaymentFilterService(final PaymentFilterService paymentFilterService) { this.paymentFilterService = paymentFilterService; } @Override @SuppressWarnings({ "unchecked", "rawtypes" }) protected List<?> executeQuery(final ActionContext context) { final MembersReportHandler reportHandler = getReportHandler(); final Pair<MembersTransactionsReportDTO, Iterator<MemberTransactionSummaryReportData>> pair = reportHandler .handleTransactionsSummary(context); final MembersTransactionsReportDTO dto = pair.getFirst(); final Iterator<MemberTransactionSummaryReportData> reportIterator = pair.getSecond(); final Iterator iterator = IteratorUtils.filteredIterator(reportIterator, new Predicate() { @Override public boolean evaluate(final Object element) { final MemberTransactionSummaryReportData data = (MemberTransactionSummaryReportData) element; if (dto.isIncludeNoTraders()) { return true; } return data.isHasData(); } }); return new IteratorListImpl(iterator); } @Override protected String fileName(final ActionContext context) { final User loggedUser = context.getUser(); return "members_transactions_summaries_" + loggedUser.getUsername() + ".csv"; } @Override protected CSVWriter<MemberTransactionSummaryReportData> resolveCSVWriter(final ActionContext context) { final MembersTransactionsReportForm form = context.getForm(); final MembersTransactionsReportDTO dto = getReportHandler().getDataBinder() .readFromString(form.getMembersTransactionsReport()); dto.setTransactionsPaymentFilters( paymentFilterService.load(EntityHelper.toIdsAsList(dto.getTransactionsPaymentFilters()))); final LocalSettings settings = settingsService.getLocalSettings(); final CSVWriter<MemberTransactionSummaryReportData> csv = CSVWriter .instance(MemberTransactionSummaryReportData.class, settings); csv.addColumn(context.message("member.username"), "member.username"); // Add the conditional columns if (dto.isMemberName()) { csv.addColumn(context.message("member.name"), "member.name"); } if (dto.isBrokerUsername()) { csv.addColumn(context.message("member.brokerUsername"), "member.broker.username"); } if (dto.isBrokerName()) { csv.addColumn(context.message("member.brokerName"), "member.broker.name"); } final Collection<PaymentFilter> transactionsPaymentFilters = dto.getTransactionsPaymentFilters(); final boolean incomingTransactions = dto.isIncomingTransactions(); final boolean outgoingTransactions = dto.isOutgoingTransactions(); for (final PaymentFilter paymentFilter : transactionsPaymentFilters) { if (incomingTransactions) { csv.addColumn( // number column context.message("reports.transactions_report.transactions", paymentFilter.getName(), // message arg0 context.message("reports.transactions_report.number"), // message arg1 context.message("reports.transactions_report.credits") // message arg2 ), "credits", new SummaryByPaymentFilterConverter(paymentFilter, true)); csv.addColumn( // amount column context.message("reports.transactions_report.transactions", paymentFilter.getName(), // message arg0 context.message("reports.transactions_report.amount"), // message arg1 context.message("reports.transactions_report.credits") // message arg2 ), "credits", new SummaryByPaymentFilterConverter(paymentFilter, false)); } if (outgoingTransactions) { csv.addColumn( // number column context.message("reports.transactions_report.transactions", paymentFilter.getName(), // message arg0 context.message("reports.transactions_report.number"), // message arg1 context.message("reports.transactions_report.debits") // message arg2 ), "debits", new SummaryByPaymentFilterConverter(paymentFilter, true)); csv.addColumn( // amount column context.message("reports.transactions_report.transactions", paymentFilter.getName(), // message arg0 context.message("reports.transactions_report.amount"), // message arg1 context.message("reports.transactions_report.debits") // message arg2 ), "debits", new SummaryByPaymentFilterConverter(paymentFilter, false)); } } return csv; } }