Dépôt officiel du code source de l'ERP OpenConcerto

/*

 * 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 = "                                                       ";

    // Format : largeur fixe, separateur : 0x0E (Shift Out)

    // l: 6 : espaces...

    // l: 8 : code du journal, aligné à gauche

    // l: 40 : nom du journal, aligné à gauche

    // l: 8 : date de l'écriture, AAAAMMJJ

    // l: 15 : numéro du compte, aligné à gauche

    // l: 60 : nom du compte, aligné à gauche

    // l: 15 : numéro de l'écriture, aligné à gauche

    // l: 60 : nom de l'écriture, aligné à gauche

    // l: 14 : montant, aligné à droite, premier caractère : le signe

    // 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"));

        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) {

        String s = String.valueOf(o).trim();

        final int width = WIDTHS[widthIndex];

        if (s.length() > width) {

            s = s.substring(0, width);

        }

        return StringUtils.getFixedWidthString(s, width, Side.LEFT, false);

    }

    @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;

            // ESPACES...

            bufOut.write(align(firstField, fieldIndex++));

            bufOut.write(SEP);

            // JOURNAL.CODE

            bufOut.write(align(array[0], fieldIndex++));

            bufOut.write(SEP);

            // JOURNAL.NOM

            bufOut.write(align(array[1], fieldIndex++, true));

            bufOut.write(SEP);

            // ECRITURE.DATE

            bufOut.write(align(dateFormat.format(array[2]), fieldIndex++));

            bufOut.write(SEP);

            // COMPTE_PCE.NUMERO

            bufOut.write(align(array[3], fieldIndex++));

            bufOut.write(SEP);

            // COMPTE_PCE.NOM

            bufOut.write(align(array[4], fieldIndex++, true));

            bufOut.write(SEP);

            // MOUVEMENT.NUMERO

            bufOut.write(align(array[5], fieldIndex++));

            bufOut.write(SEP);

            // ECRITURE.NOM

            bufOut.write(align(array[6], fieldIndex++, true));

            bufOut.write(SEP);

            // Montant

            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

            final int wAmount = WIDTHS[fieldIndex++] - 1;

            String amount = formatCents(cents);

            if (amount.length() > wAmount) {

                amount = amount.substring(0, wAmount);

            }

            bufOut.write(StringUtils.getFixedWidthString(amount, wAmount, Side.RIGHT, false));

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

        }

        bufOut.flush();

    }

}