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.
 */
 
 /*
 * Créé le 19 nov. 2012
 */
package org.openconcerto.erp.generationDoc.gestcomm;

import org.openconcerto.erp.generationDoc.AbstractListeSheetXml;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLRowValuesListFetcher;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.Where;
import org.openconcerto.utils.cc.ITransformer;

import java.math.BigDecimal;
import java.math.RoundingMode;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class ReportingTaxeComplementaireSheetXML extends AbstractListeSheetXml {

    public static final String TEMPLATE_ID = "ReportingTaxeComplementaire";
    public static final String TEMPLATE_PROPERTY_NAME = DEFAULT_PROPERTY_NAME;
    private Date date;

    private Date dateD, dateF;

    public ReportingTaxeComplementaireSheetXML(Date debut, Date fin) {
        super();

        this.dateD = debut;
        this.dateF = fin;

    }

    @Override
    public String getStoragePathP() {
        return "Autres";
    }

    @Override
    public String getDefaultTemplateId() {
        return TEMPLATE_ID;
    }

    @Override
    public String getName() {
        if (this.date == null) {
            this.date = new Date();
        }
        return "ReportingTaxeCompl" + this.date.getTime();
    }

    @Override
    protected void createListeValues() {

        this.mapAllSheetValues = new HashMap<Integer, Map<String, Object>>();
        this.listAllSheetValues = new HashMap<Integer, List<Map<String, Object>>>();
        this.styleAllSheetValues = new HashMap<Integer, Map<Integer, String>>();

        fillSynthese();

    }

    private static SQLTable tableVF = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE").getTable();

    class TaxeComplRecap {
        private final String code, nom, numeroCptProduit, numeroCpt;
        private BigDecimal percentTaxe, totalBase, qte;

        public TaxeComplRecap(SQLRowAccessor foreignTaxeCompl) {
            this.code = foreignTaxeCompl.getString("CODE");
            this.nom = foreignTaxeCompl.getString("NOM");
            this.qte = BigDecimal.ZERO;
            this.percentTaxe = foreignTaxeCompl.getBigDecimal("POURCENT");
            this.totalBase = BigDecimal.ZERO;
            if (foreignTaxeCompl.getObject("ID_COMPTE_PCE") != null && !foreignTaxeCompl.isForeignEmpty("ID_COMPTE_PCE")) {
                this.numeroCpt = foreignTaxeCompl.getForeign("ID_COMPTE_PCE").getString("NUMERO");
            } else {
                this.numeroCpt = "";
            }
            if (foreignTaxeCompl.getObject("ID_COMPTE_PCE_PRODUITS") != null && !foreignTaxeCompl.isForeignEmpty("ID_COMPTE_PCE_PRODUITS")) {
                this.numeroCptProduit = foreignTaxeCompl.getForeign("ID_COMPTE_PCE_PRODUITS").getString("NUMERO");
            } else {
                this.numeroCptProduit = "";
            }
        }

        public void cumul(BigDecimal qte, BigDecimal total) {
            this.qte = qte.add(this.qte);
            this.totalBase = total.add(this.totalBase);
        }

        public String getCode() {
            return code;
        }

        public String getNom() {
            return nom;
        }

        public String getNumeroCpt() {
            return numeroCpt;
        }

        public String getNumeroCptProduit() {
            return numeroCptProduit;
        }

        public BigDecimal getQte() {
            return qte;
        }

        public BigDecimal getPercentTaxe() {
            return percentTaxe;

        }

        public BigDecimal getTotalBase() {
            return totalBase;
        }

        public BigDecimal getTotalTaxe() {
            return this.totalBase.multiply(this.percentTaxe.movePointLeft(2)).setScale(2, RoundingMode.HALF_UP);
        }

        public BigDecimal getTotalBaseHT() {
            return this.totalBase.subtract(getTotalTaxe());
        }
    }

    private void fillSynthese() {
        final SQLTable tableVF = Configuration.getInstance().getRoot().findTable("SAISIE_VENTE_FACTURE");
        final SQLTable tableVFElt = Configuration.getInstance().getRoot().findTable("SAISIE_VENTE_FACTURE_ELEMENT");

        SQLRowValues rowvalsVF = new SQLRowValues(tableVF);
        rowvalsVF.put("NUMERO", null);
        rowvalsVF.put("DATE", null);

        SQLRowValues rowvalsVFElt = new SQLRowValues(tableVFElt);
        rowvalsVFElt.put("ID_SAISIE_VENTE_FACTURE", rowvalsVF);
        rowvalsVFElt.put("T_PV_HT", null);
        rowvalsVFElt.put("QTE", null);
        rowvalsVFElt.put("QTE_UNITAIRE", null);
        final SQLRowValues rowValsTaxeCompl = rowvalsVFElt.putRowValues("ID_ARTICLE").putRowValues("ID_TAXE_COMPLEMENTAIRE");
        rowValsTaxeCompl.putNulls("CODE", "NOM", "POURCENT");
        rowValsTaxeCompl.putRowValues("ID_COMPTE_PCE_PRODUITS").putNulls("NUMERO", "NOM");
        rowValsTaxeCompl.putRowValues("ID_COMPTE_PCE").putNulls("NUMERO", "NOM");
        SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(rowvalsVFElt);
        fetcher.setSelTransf(new ITransformer<SQLSelect, SQLSelect>() {

            @Override
            public SQLSelect transformChecked(SQLSelect input) {
                Where w = new Where(input.getAlias(tableVF).getField("DATE"), dateD, dateF);
                input.setWhere(w);
                return input;
            }
        });

        Map<Integer, TaxeComplRecap> recap = new HashMap<Integer, ReportingTaxeComplementaireSheetXML.TaxeComplRecap>();
        List<SQLRowValues> results = fetcher.fetch();
        for (SQLRowValues sqlRowValues : results) {
            TaxeComplRecap r;
            if (sqlRowValues.getForeign("ID_ARTICLE") != null && !sqlRowValues.isForeignEmpty("ID_ARTICLE")) {
                final SQLRowAccessor foreignArt = sqlRowValues.getForeign("ID_ARTICLE");
                if (foreignArt.getForeign("ID_TAXE_COMPLEMENTAIRE") != null && !foreignArt.isForeignEmpty("ID_TAXE_COMPLEMENTAIRE")) {
                    final SQLRowAccessor foreignTaxeCompl = foreignArt.getForeign("ID_TAXE_COMPLEMENTAIRE");
                    if (recap.containsKey(foreignTaxeCompl.getID())) {
                        r = recap.get(foreignTaxeCompl.getID());
                    } else {
                        r = new TaxeComplRecap(foreignTaxeCompl);
                        recap.put(foreignTaxeCompl.getID(), r);
                    }
                    r.cumul(sqlRowValues.getBigDecimal("QTE_UNITAIRE").multiply(new BigDecimal(sqlRowValues.getInt("QTE"))), sqlRowValues.getBigDecimal("T_PV_HT"));
                }
            }
        }

        List<Map<String, Object>> values = new ArrayList<Map<String, Object>>();
        this.listAllSheetValues.put(0, values);
        Map<Integer, String> style = new HashMap<Integer, String>();
        this.styleAllSheetValues.put(0, style);

        BigDecimal totalBaseHT = BigDecimal.ZERO;
        BigDecimal totalTaxe = BigDecimal.ZERO;
        BigDecimal qteTotal = BigDecimal.ZERO;

        for (TaxeComplRecap item : recap.values()) {
            Map<String, Object> vals = new HashMap<String, Object>();

            vals.put("COMPTE_NUMERO", item.getNumeroCpt());
            vals.put("COMPTE_PRODUIT_NUMERO", item.getNumeroCptProduit());

            vals.put("CODE", item.getCode());
            vals.put("NOM", item.getNom());
            vals.put("QTE", item.getQte());
            vals.put("POURCENT", item.getPercentTaxe());
            vals.put("TOTAL_BASE", item.getTotalBaseHT());
            vals.put("TOTAL_TAXE", item.getTotalTaxe());
            style.put(values.size(), "Normal");
            totalBaseHT = totalBaseHT.add(item.getTotalBaseHT());
            totalTaxe = totalTaxe.add(item.getTotalTaxe());
            qteTotal = qteTotal.add(item.getQte());
            values.add(vals);
        }

        SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy");
        Map<String, Object> vals = new HashMap<String, Object>();
        vals.put("DATE_DEB", this.dateD);
        vals.put("DATE_FIN", this.dateF);
        vals.put("PERIODE", "Période du " + format.format(this.dateD) + " au " + format.format(this.dateF));
        vals.put("TOTAL_TAXE", totalTaxe);
        vals.put("TOTAL_BASE", totalBaseHT);
        vals.put("TOTAL_QTE", qteTotal);
        this.mapAllSheetValues.put(0, vals);
        // style.put(values.size(), "Titre 1");
    }
}