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

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * Copyright 2011-2019 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.generationDoc.provider;

import org.openconcerto.erp.generationDoc.SpreadSheetCellValueContext;

import org.openconcerto.erp.generationDoc.SpreadSheetCellValueProvider;

import org.openconcerto.erp.generationDoc.SpreadSheetCellValueProviderManager;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.utils.GestionDevise;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Collection;

import java.util.HashSet;

import java.util.Set;

public class RecapFactureProvider implements SpreadSheetCellValueProvider {

    private enum TypeRecapFactureProvider {

        HT, TTC;

    };

    private final TypeRecapFactureProvider type;

    private final boolean withDate, withAvoir;

    public RecapFactureProvider(TypeRecapFactureProvider t, boolean withDate, boolean withAvoir) {

        this.type = t;

        this.withDate = withDate;

        this.withAvoir = withAvoir;

    }

    public Object getValue(SpreadSheetCellValueContext context) {

        SQLRowAccessor row = context.getRow();

        Calendar c = row.getDate("DATE");

        Collection<? extends SQLRowAccessor> rows = row.getReferentRows(row.getTable().getTable("TR_COMMANDE_CLIENT"));

        StringBuffer result = new StringBuffer();

        Set<SQLRowAccessor> facture = new HashSet<SQLRowAccessor>();

        facture.add(row);

        for (SQLRowAccessor sqlRowAccessor : rows) {

            result.append(getPreviousAcompte(sqlRowAccessor.getForeign("ID_COMMANDE_CLIENT"), facture, c));

        }

        if (result.length() > 0) {

            return "Facturation précédente :" + result.toString();

        } else {

            return null;

        }

    }

    public static void register() {

        SpreadSheetCellValueProviderManager.put("sales.account.history", new RecapFactureProvider(TypeRecapFactureProvider.HT, false, false));

        SpreadSheetCellValueProviderManager.put("sales.account.history.ttc", new RecapFactureProvider(TypeRecapFactureProvider.TTC, false, false));

        SpreadSheetCellValueProviderManager.put("sales.account.history.withdate", new RecapFactureProvider(TypeRecapFactureProvider.HT, true, false));

        SpreadSheetCellValueProviderManager.put("sales.account.history.ttc.withdate", new RecapFactureProvider(TypeRecapFactureProvider.TTC, true, false));

        SpreadSheetCellValueProviderManager.put("sales.account.history.with.credit", new RecapFactureProvider(TypeRecapFactureProvider.HT, false, true));

        SpreadSheetCellValueProviderManager.put("sales.account.history.with.credit.ttc", new RecapFactureProvider(TypeRecapFactureProvider.TTC, false, true));

        SpreadSheetCellValueProviderManager.put("sales.account.history.with.credit.withdate", new RecapFactureProvider(TypeRecapFactureProvider.HT, true, true));

        SpreadSheetCellValueProviderManager.put("sales.account.history.with.credit.ttc.withdate", new RecapFactureProvider(TypeRecapFactureProvider.TTC, true, true));

    }

    public String getPreviousAcompte(SQLRowAccessor sqlRowAccessor, Set<SQLRowAccessor> alreadyAdded, Calendar c) {

        if (sqlRowAccessor == null || sqlRowAccessor.isUndefined()) {

            return "";

        }

        Collection<? extends SQLRowAccessor> rows = sqlRowAccessor.getReferentRows(sqlRowAccessor.getTable().getTable("TR_COMMANDE_CLIENT"));

        StringBuffer result = new StringBuffer();

        SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy");

        for (SQLRowAccessor sqlRowAccessor2 : rows) {

            SQLRowAccessor rowFact = sqlRowAccessor2.getForeign("ID_SAISIE_VENTE_FACTURE");

            if (rowFact != null && !rowFact.isUndefined() && !alreadyAdded.contains(rowFact) && rowFact.getDate("DATE").before(c)

                    && (!this.withAvoir || (this.withAvoir && rowFact.isForeignEmpty("ID_AVOIR_CLIENT")))) {

                alreadyAdded.add(rowFact);

                final String fieldTotal = this.type == TypeRecapFactureProvider.HT ? "T_HT" : "T_TTC";

                result.append(rowFact.getString("NUMERO"));

                result.append(" (");

                if (this.withDate) {

                    result.append(format.format(rowFact.getDate("DATE").getTime()) + " ");

                }

                result.append(GestionDevise.currencyToString(rowFact.getLong(fieldTotal)) + "€), ");

                if (this.withDate) {

                    result.append("\n");

                }

            }

        }

        return result.toString();

    }

}