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.core.finance.accounting.report;

import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.config.Gestion;
import org.openconcerto.erp.core.finance.accounting.element.ComptePCESQLElement;
import org.openconcerto.erp.core.finance.accounting.model.SommeCompte;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.model.SQLBase;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.utils.GestionDevise;

import java.io.File;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.swing.JProgressBar;
import javax.swing.SwingUtilities;

public class Map3310 extends Thread {

    private Map<String, String> m;
    private JProgressBar bar;
    private Date dateDebut;
    private Date dateFin;
    private static final SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();
    private static final SQLTable tablePrefCompte = base.getTable("PREFS_COMPTE");
    private static final SQLTable tableCompte = Configuration.getInstance().getRoot().findTable("COMPTE_PCE");
    private SQLRowValues rowPrefCompteVals = new SQLRowValues(tablePrefCompte);
    SommeCompte sommeCompte;

    // TODO if value = 0.0 ne pas mettre -0.0

    public void run() {

        SQLRow rowPrefCompte = tablePrefCompte.getRow(2);
        this.rowPrefCompteVals.loadAbsolutelyAll(rowPrefCompte);
        // TVA Coll
        int idCompteTVACol = this.rowPrefCompteVals.getInt("ID_COMPTE_PCE_TVA_VENTE");
        if (idCompteTVACol <= 1) {
            String compte;
            try {
                compte = ComptePCESQLElement.getComptePceDefault("TVACollectee");
                idCompteTVACol = ComptePCESQLElement.getId(compte);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        SQLRow rowCompteTVACol = tableCompte.getRow(idCompteTVACol);

        // TVA Ded
        int idCompteTVADed = this.rowPrefCompteVals.getInt("ID_COMPTE_PCE_TVA_ACHAT");
        if (idCompteTVADed <= 1) {
            try {
                String compte = ComptePCESQLElement.getComptePceDefault("TVADeductible");
                idCompteTVADed = ComptePCESQLElement.getId(compte);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        SQLRow rowCompteTVADed = tableCompte.getRow(idCompteTVADed);

        // TVA intracomm
        int idCompteTVAIntra = this.rowPrefCompteVals.getInt("ID_COMPTE_PCE_TVA_INTRA");
        if (idCompteTVAIntra <= 1) {
            try {
                String compte = ComptePCESQLElement.getComptePceDefault("TVAIntraComm");
                idCompteTVAIntra = ComptePCESQLElement.getId(compte);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        SQLRow rowCompteTVAIntra = tableCompte.getRow(idCompteTVAIntra);

        // Achats intracomm
        int idCompteAchatsIntra = this.rowPrefCompteVals.getInt("ID_COMPTE_PCE_ACHAT_INTRA");
        if (idCompteAchatsIntra <= 1) {
            try {
                String compte = ComptePCESQLElement.getComptePceDefault("AchatsIntra");
                idCompteAchatsIntra = ComptePCESQLElement.getId(compte);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        SQLRow rowCompteAchatIntra = tableCompte.getRow(idCompteAchatsIntra);

        // TVA immo
        int idCompteTVAImmo = this.rowPrefCompteVals.getInt("ID_COMPTE_PCE_TVA_IMMO");
        if (idCompteTVAImmo <= 1) {
            try {
                String compte = ComptePCESQLElement.getComptePceDefault("TVAImmo");
                idCompteTVAImmo = ComptePCESQLElement.getId(compte);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        SQLRow rowCompteTVAImmo = tableCompte.getRow(idCompteTVAImmo);

        PdfGenerator_3310 p = new PdfGenerator_3310();
        this.m = new HashMap<String, String>();

        long v010 = -this.sommeCompte.soldeCompte(70, 70, true, this.dateDebut, this.dateFin);
        this.m.put("A01", GestionDevise.round(v010));

        this.m.put("A02", "");
        long tvaIntra = -this.sommeCompte.sommeCompteFils(rowCompteTVAIntra.getString("NUMERO"), this.dateDebut, this.dateFin);
        long achatsIntra = this.sommeCompte.sommeCompteFils(rowCompteAchatIntra.getString("NUMERO"), this.dateDebut, this.dateFin);
        this.m.put("A03", GestionDevise.round(achatsIntra));
        this.m.put("A04", "");
        this.m.put("A05", "");
        this.m.put("A06", "");
        this.m.put("A07", "");

        long tvaCol = -this.sommeCompte.sommeCompteFils(rowCompteTVACol.getString("NUMERO"), this.dateDebut, this.dateFin) + tvaIntra;
        this.m.put("B08", GestionDevise.round(tvaCol));
        this.m.put("B08HT", GestionDevise.round(Math.round(tvaCol / 0.196)));
        this.m.put("B09", "");
        this.m.put("B09HT", "");
        this.m.put("B09B", "");
        this.m.put("B09BHT", "");

        this.m.put("B10", "");
        this.m.put("B10HT", "");
        this.m.put("B11", "");
        this.m.put("B11HT", "");
        this.m.put("B12", "");
        this.m.put("B12HT", "");
        this.m.put("B13", "");
        this.m.put("B13HT", "");
        this.m.put("B14", "");
        this.m.put("B14HT", "");

        this.m.put("B15", "");
        this.m.put("B16", GestionDevise.round(tvaCol));
        this.m.put("B17", GestionDevise.round(tvaIntra));
        this.m.put("B18", "");
        final String numeroCptTVAImmo = rowCompteTVAImmo.getString("NUMERO");
        long tvaImmo = this.sommeCompte.sommeCompteFils(numeroCptTVAImmo, this.dateDebut, this.dateFin);
        this.m.put("B19", GestionDevise.round(tvaImmo));

        final String numeroCptTVADed = rowCompteTVADed.getString("NUMERO");
        long tvaAutre = this.sommeCompte.sommeCompteFils(numeroCptTVADed, this.dateDebut, this.dateFin);

        // Déduction de la tva sur immo si elle fait partie des sous comptes
        if (numeroCptTVAImmo.startsWith(numeroCptTVADed)) {
            tvaAutre -= tvaImmo;
        }

        this.m.put("B20", GestionDevise.round(tvaAutre));
        this.m.put("B21", "");
        this.m.put("B22", "");
        this.m.put("B23", "");
        long tvaDed = tvaAutre + tvaImmo;
        this.m.put("B24", GestionDevise.round(tvaDed));

        this.m.put("C25", "");
        this.m.put("C26", "");
        this.m.put("C27", "");
        this.m.put("C28", GestionDevise.round(tvaCol - tvaDed));
        this.m.put("C29", "");
        this.m.put("C30", "");
        this.m.put("C31", "");
        this.m.put("C32", GestionDevise.round(tvaCol - tvaDed));

        p.generateFrom(this.m);

        SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                Map3310.this.bar.setValue(95);
            }
        });

        SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                final File generatedFile = p.getGeneratedFile();
                if (generatedFile != null) {
                    Gestion.openPDF(generatedFile);
                } else {
                    Map3310.this.bar.setValue(100);
                }
            }
        });

    }

    public Map3310(JProgressBar bar, Date dateDeb, Date dateFin) {
        this.bar = bar;
        if (dateDeb == null && dateFin == null) {
            SQLRow rowSociete = ((ComptaPropsConfiguration) Configuration.getInstance()).getRowSociete();
            SQLRow rowExercice = Configuration.getInstance().getBase().getTable("EXERCICE_COMMON").getRow(rowSociete.getInt("ID_EXERCICE_COMMON"));
            dateFin = (Date) rowExercice.getObject("DATE_FIN");
            dateDeb = (Date) rowExercice.getObject("DATE_DEB");
        }
        this.dateDebut = dateDeb;
        this.dateFin = dateFin;
        this.sommeCompte = new SommeCompte();
    }

    public Map3310(JProgressBar bar) {
        this(bar, null, null);
    }

    public void generateMap2033A() {
        this.start();
    }
}