org.openconcerto.erp.panel.compta.ExportEBP_ComptaPro.java Source code

Introduction

Here is the source code for org.openconcerto.erp.panel.compta.ExportEBP_ComptaPro.java

Source

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
 * 
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
 * language governing permissions and limitations under the License.
 * 
 * When distributing the software, include this License Header Notice in each file.
 */

package org.openconcerto.erp.panel.compta;

import org.openconcerto.sql.model.DBRoot;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.utils.StringUtils;
import org.openconcerto.utils.StringUtils.Side;

import java.io.IOException;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.math.BigDecimal;
import java.nio.charset.Charset;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.DecimalFormatSymbols;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Locale;

import org.apache.commons.dbutils.handlers.ArrayListHandler;

public class ExportEBP_ComptaPro extends AbstractExport {
    static private final Charset CHARSET = StringUtils.Cp1252;
    static private final char SEP = 0x0E;
    static private final int[] WIDTHS = new int[] { 6, 8, 40, 8, 15, 60, 15, 60, 14 };
    static private final String SPACES = "                                                       ";

    // needs . for decimal separator
    static private final DecimalFormat DECIMAL_FORMAT = new DecimalFormat("##0.00",
            DecimalFormatSymbols.getInstance(Locale.UK));

    static private String formatCents(final Number n) {
        return DECIMAL_FORMAT.format(BigDecimal.valueOf(n.longValue()).movePointLeft(2));
    }

    private List<Object[]> data;

    public ExportEBP_ComptaPro(DBRoot rootSociete) {
        super(rootSociete, "EBPPro", ".txt");
    }

    @Override
    protected int fetchData(Date from, Date to, SQLRow selectedJournal, boolean onlyNew) {
        final SQLTable tableEcriture = getEcritureT();
        final SQLTable tableMouvement = tableEcriture.getForeignTable("ID_MOUVEMENT");
        final SQLTable tableCompte = tableEcriture.getForeignTable("ID_COMPTE_PCE");
        final SQLTable tableJrnl = tableEcriture.getForeignTable("ID_JOURNAL");

        final SQLSelect sel = createSelect(from, to, selectedJournal, onlyNew);
        sel.addSelect(tableJrnl.getField("CODE"));
        sel.addSelect(tableJrnl.getField("NOM"));
        sel.addSelect(tableEcriture.getField("DATE"));
        sel.addSelect(tableCompte.getField("NUMERO"));
        sel.addSelect(tableCompte.getField("NOM"));
        // width wider than 15, so replace with MOUVEMENT
        // sel.addSelect(tablePiece.getField("NOM"));
        sel.addSelect(tableMouvement.getField("NUMERO"));
        sel.addSelect(tableEcriture.getField("NOM"));
        sel.addSelect(tableEcriture.getField("DEBIT"));
        sel.addSelect(tableEcriture.getField("CREDIT"));

        sel.addFieldOrder(tableJrnl.getField("CODE"));
        sel.addFieldOrder(tableEcriture.getField("DATE"));
        sel.addFieldOrder(tableMouvement.getField("NUMERO"));

        @SuppressWarnings("unchecked")
        final List<Object[]> l = (List<Object[]>) this.getRootSociete().getDBSystemRoot().getDataSource()
                .execute(sel.asString(), new ArrayListHandler());
        this.data = l;
        return l == null ? 0 : l.size();
    }

    private final String align(final Object o, final int widthIndex) {
        return align(o, widthIndex, false);
    }

    private final String align(final Object o, final int widthIndex, final boolean allowTruncate) {
        final String s = String.valueOf(o).trim();
        return StringUtils.getFixedWidthString(s, WIDTHS[widthIndex], Side.LEFT);
    }

    @Override
    protected void export(OutputStream out) throws IOException {
        final Writer bufOut = new OutputStreamWriter(out, CHARSET);
        final DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
        final String firstField = SPACES.substring(0, WIDTHS[0]);
        for (final Object[] array : this.data) {
            int fieldIndex = 0;
            bufOut.write(align(firstField, fieldIndex++));
            bufOut.write(SEP);
            bufOut.write(align(array[0], fieldIndex++));
            bufOut.write(SEP);
            // JOURNAL.NOM
            bufOut.write(align(array[1], fieldIndex++, true));
            bufOut.write(SEP);
            bufOut.write(align(dateFormat.format(array[2]), fieldIndex++));
            bufOut.write(SEP);
            bufOut.write(align(array[3], fieldIndex++));
            bufOut.write(SEP);
            // COMPTE_PCE.NOM
            bufOut.write(align(array[4], fieldIndex++, true));
            bufOut.write(SEP);
            System.err.println("ExportEBP_Pro.export() " + array[5]);
            bufOut.write(align(array[5], fieldIndex++));
            bufOut.write(SEP);
            // ECRITURE.NOM
            bufOut.write(align(array[6], fieldIndex++, true));
            bufOut.write(SEP);

            // Amount
            final long debit = ((Number) array[7]).longValue();
            final long credit = ((Number) array[8]).longValue();
            if (debit > 0 && credit > 0)
                throw new IllegalStateException("Both credit and debit");
            final long cents;
            final char sign;
            if (credit > 0) {
                cents = credit;
                sign = '-';
            } else {
                cents = debit;
                sign = ' ';
            }
            bufOut.write(sign);
            // -1 since we wrote the sign
            bufOut.write(StringUtils.getFixedWidthString(formatCents(cents), WIDTHS[fieldIndex++] - 1, Side.RIGHT,
                    false));

            bufOut.write("\r\n");
        }
    }
}