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.core.common.ui;

import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.core.finance.accounting.element.ComptePCESQLElement;
import org.openconcerto.erp.preferences.DefaultNXProps;
import org.openconcerto.erp.utils.TM;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.model.SQLField;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.preferences.SQLPreferences;
import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
import org.openconcerto.sql.users.rights.UserRights;
import org.openconcerto.sql.users.rights.UserRightsManager;
import org.openconcerto.sql.view.list.RowValuesTable;
import org.openconcerto.sql.view.list.SQLTableElement;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.JLabelBold;
import org.openconcerto.utils.DecimalUtils;
import org.openconcerto.utils.ExceptionHandler;
import org.openconcerto.utils.GestionDevise;

import java.awt.Color;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.beans.PropertyChangeListener;
import java.beans.PropertyChangeSupport;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.ArrayList;
import java.util.List;

import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JSeparator;
import javax.swing.JTextField;
import javax.swing.SwingWorker;
import javax.swing.UIManager;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;

public class TotalPanel extends JPanel implements TableModelListener {
    public static String MARGE_MARQUE = "MargeMarque";
    private RowValuesTable table;
    private DeviseField textTotalHT, textTotalHTSel;
    private DeviseField textTotalTVA, textTotalTVASel;
    private DeviseField textTotalTTC, textTotalTTCSel;
    private DeviseField textPortHT;
    private DeviseField textRemiseHT, textTotalEco, textTotalEcoSel;
    private JTextField textTVAFix;
    private JTextField textPoids;
    private DeviseField textTotalDevise, textTotalDeviseSel;
    private DeviseField textService, textServiceSel;
    private DeviseField textHA, textHASel;
    private JTextField marge, margeSel;
    private DeviseField textFraisDoc, textFraisDocSel;
    private boolean gestionHA = false;
    private PropertyChangeSupport supp;
    private int columnIndexEchHT = -1;
    private int columnIndexEchTTC = -1;
    private SQLTableElement ha;
    private SQLRequestComboBox selPortTVA;
    private SQLRequestComboBox selFraisDocTVA = null;
    private AcompteField facturable;
    private boolean intraComm = false;

    AbstractArticleItemTable articleTable;

    public TotalPanel(AbstractArticleItemTable articleItemTable, DeviseField textTotalEco, DeviseField textTotalHT, DeviseField textTotalTVA, DeviseField textTotalTTC, DeviseField textPortHT,
            DeviseField textRemiseHT, DeviseField textService, DeviseField textTotalHA, DeviseField textTotalDevise, JTextField textTotalPoids, JPanel tableEchantillon) {
        this(articleItemTable, textTotalEco, textTotalHT, textTotalTVA, textTotalTTC, textPortHT, textRemiseHT, textService, textTotalHA, textTotalDevise, textTotalPoids, tableEchantillon, null,
                null);
    }

    public TotalPanel(AbstractArticleItemTable articleItemTable, DeviseField textTotalEco, DeviseField textTotalHT, DeviseField textTotalTVA, DeviseField textTotalTTC, DeviseField textPortHT,
            DeviseField textRemiseHT, DeviseField textService, DeviseField textTotalHA, DeviseField textTotalDevise, JTextField textTotalPoids, JPanel tableEchantillon, SQLRequestComboBox selPortTva,
            AcompteField facturable) {

        super();
        this.setOpaque(false);
        this.selPortTVA = selPortTva;
        this.facturable = facturable;
        this.articleTable = articleItemTable;
        this.supp = new PropertyChangeSupport(this);
        this.table = articleItemTable.getRowValuesTable();

        this.ha = (articleItemTable.getPrebilanElement() == null) ? articleItemTable.getHaElement() : articleItemTable.getPrebilanElement();
        this.gestionHA = ha != null && articleItemTable.getQteElement() != null;

        this.textPoids = (textTotalPoids == null ? new JTextField() : textTotalPoids);
        this.textTotalHT = textTotalHT;
        this.textTotalHT.setBold();
        this.textTotalEco = textTotalEco;
        this.textTotalTVA = textTotalTVA;
        this.textTotalTTC = textTotalTTC;
        this.textPortHT = textPortHT;
        this.textRemiseHT = textRemiseHT;
        this.textService = textService;
        this.textFraisDoc = new DeviseField();
        this.textTVAFix = new DeviseField();
        this.textFraisDocSel = new DeviseField();
        this.textTotalHTSel = new DeviseField(true);
        this.textServiceSel = new DeviseField();
        this.textTotalEcoSel = new DeviseField();
        this.textTotalTTCSel = new DeviseField();
        this.textTotalTVASel = new DeviseField();
        this.textHA = (textTotalHA == null) ? new DeviseField() : textTotalHA;
        this.textHASel = new DeviseField();
        this.marge = new JTextField();
        this.margeSel = new JTextField();
        final UserRights rights = UserRightsManager.getCurrentUserRights();

        final boolean showHA = rights.haveRight(AbstractVenteArticleItemTable.SHOW_PRIX_ACHAT_CODE);
        this.textHA.setVisible(showHA);
        this.textHASel.setVisible(showHA);
        this.marge.setVisible(showHA);
        this.margeSel.setVisible(showHA);

        if (articleItemTable.getTableElementTotalDevise() != null) {
            this.textTotalDevise = textTotalDevise;
            this.textTotalDeviseSel = new DeviseField();
            reconfigure(this.textTotalDevise);
            reconfigure(this.textTotalDeviseSel);
        }
        reconfigure(this.textTotalHT);
        reconfigure(this.textTotalEco);
        reconfigure(this.textTotalTVA);
        reconfigure(this.textTotalTTC);
        reconfigure(this.textService);
        reconfigure(this.textHA);
        reconfigure(this.marge);
        reconfigure(this.textTotalHTSel);
        reconfigure(this.textFraisDoc);
        reconfigure(this.textTVAFix);
        reconfigure(this.textFraisDocSel);
        reconfigure(this.textTotalEcoSel);
        reconfigure(this.textTotalTVASel);
        reconfigure(this.textTotalTTCSel);
        reconfigure(this.textServiceSel);
        reconfigure(this.textHASel);
        reconfigure(this.margeSel);

        // String val = DefaultNXProps.getInstance().getStringProperty("ArticleService");
        // Boolean b = Boolean.valueOf(val);

        // if (this.columnIndexHT < 0 || this.columnIndexTVA < 0 || (b != null && b.booleanValue()
        // && this.columnIndexService < 0)) {
        // throw new IllegalArgumentException("Impossible de trouver la colonne de " +
        // articleItemTable.getPrixTotalHTElement() + " / " + articleItemTable.getTVAElement() +
        // " / "
        // + articleItemTable.getPrixServiceElement());
        // }
        this.setLayout(new GridBagLayout());
        GridBagConstraints c = new DefaultGridBagConstraints();

        c.gridheight = 1;
        c.weighty = 0;
        c.fill = GridBagConstraints.HORIZONTAL;

        // Collone 1 : Selection
        c.gridx++;
        this.add(new JLabelBold(TM.tr("TotalPanel.selection")), c); //$NON-NLS-1$
        c.gridy++;
        c.gridx = 1;
        c.gridwidth = 2;
        c.weightx = 1;
        c.fill = GridBagConstraints.BOTH;
        this.add(createSeparator(), c);

        c.gridwidth = 1;
        c.weightx = 0;
        c.fill = GridBagConstraints.HORIZONTAL;
        if (this.gestionHA) {
            final JLabel labelMarge = new JLabel(TM.tr("TotalPanel.margin")); //$NON-NLS-1$
            final JLabel labelHA = new JLabel((this.ha == articleItemTable.getPrebilanElement()) ? TM.tr("TotalPanel.estimatedBudget") : TM.tr("TotalPanel.purchaseTotal.taxExcluded")); //$NON-NLS-1$//$NON-NLS-2$

            // Total HA HT
            c.gridy++;
            this.add(labelHA, c);
            labelHA.setVisible(showHA);

            c.gridx++;
            c.weightx = 1;
            this.add(this.textHASel, c);

            // Marge
            c.gridy++;
            c.gridx = 1;
            c.weightx = 0;
            this.add(labelMarge, c);
            labelMarge.setVisible(showHA);

            c.gridx++;
            c.weightx = 1;
            this.add(this.margeSel, c);

            c.gridy++;
            c.gridx = 1;
            c.gridwidth = 2;
            c.weightx = 1;

            c.fill = GridBagConstraints.BOTH;
            this.add(createSeparator(), c);

            c.gridwidth = 1;
            c.weightx = 0;
        }

        // Total HT
        c.gridy++;
        c.gridx = 1;
        c.weightx = 0;
        c.fill = GridBagConstraints.HORIZONTAL;
        this.add(getLabelBoldFor(textTotalHT.getField(), TM.tr("TotalPanel.total.taxExcluded")), c); //$NON-NLS-1$

        c.gridx++;
        c.weightx = 1;
        this.add(this.textTotalHTSel, c);

        // Service
        if (DefaultNXProps.getInstance().getBooleanValue(AbstractVenteArticleItemTable.ARTICLE_SERVICE, false)) {
            c.gridx = 1;
            c.gridy++;
            c.weightx = 0;
            this.add(new JLabel(TM.tr("TotalPanel.service.taxExcluded")), c); //$NON-NLS-1$
            c.gridx++;
            c.weightx = 1;
            this.add(this.textServiceSel, c);
        }

        // TVA
        c.gridx = 1;
        c.gridy++;
        c.weightx = 0;
        this.add(getLabelFor(textTotalTVA.getField(), TM.tr("TotalPanel.total.VAT")), c); //$NON-NLS-1$
        c.gridx++;
        c.weightx = 1;
        this.add(this.textTotalTVASel, c);

        c.gridx = 1;
        c.gridy++;
        c.gridwidth = 2;
        c.fill = GridBagConstraints.BOTH;
        this.add(createSeparator(), c);

        if (articleItemTable.getTableElementTotalDevise() != null) {
            // Devise
            c.gridwidth = 1;
            c.gridx = 1;
            c.gridy++;
            c.weightx = 0;
            c.fill = GridBagConstraints.HORIZONTAL;
            this.add(getLabelFor(textTotalDevise.getField(), TM.tr("TotalPanel.currencyTotal")), c); //$NON-NLS-1$
            c.gridx++;
            c.weightx = 1;
            this.add(this.textTotalDeviseSel, c);
        }

        // Eco-contribution
        final SQLPreferences prefs = SQLPreferences.getMemCached(this.table.getRowValuesTableModel().getSQLElement().getTable().getDBRoot());
        final boolean showEco = prefs.getBoolean(AbstractVenteArticleItemTable.SHOW_TOTAL_ECO_CONTRIBUTION, false);
        if (showEco) {
            c.gridx = 1;
            c.gridy++;
            c.weightx = 0;
            this.add(new JLabel(TM.tr("TotalPanel.ecoTax")), c); //$NON-NLS-1$
            c.gridx++;
            c.weightx = 1;
            this.add(this.textTotalEcoSel, c);
        }

        // TTC
        c.gridwidth = 1;
        c.gridx = 1;
        c.gridy++;
        c.weightx = 0;
        c.fill = GridBagConstraints.HORIZONTAL;
        this.add(getLabelFor(textTotalTTC.getField(), TM.tr("TotalPanel.total.taxIncluded")), c); //$NON-NLS-1$
        c.gridx++;
        c.weightx = 1;
        this.add(this.textTotalTTCSel, c);

        // Global
        c.gridx = 3;
        c.gridy = 0;
        c.gridheight = GridBagConstraints.REMAINDER;
        c.weighty = 1;
        c.fill = GridBagConstraints.VERTICAL;
        c.weightx = 0;
        this.add(createSeparator(), c);

        c.gridheight = 1;
        c.fill = GridBagConstraints.HORIZONTAL;
        c.weighty = 0;
        c.gridx++;
        this.add(new JLabelBold(TM.tr("TotalPanel.global")), c); //$NON-NLS-1$
        c.gridy++;
        c.gridx = 4;
        c.gridwidth = 2;
        c.weightx = 1;
        this.add(createSeparator(), c);

        c.gridwidth = 1;
        c.weightx = 0;
        if (this.gestionHA) {
            final JLabel labelMarge = new JLabel(TM.tr("TotalPanel.margin")); //$NON-NLS-1$
            final JLabel labelHA = new JLabel((this.ha == articleItemTable.getPrebilanElement()) ? TM.tr("TotalPanel.estimatedBudget") : TM.tr("TotalPanel.purchaseTotal.taxExcluded")); //$NON-NLS-1$//$NON-NLS-2$

            // Total HA HT
            c.gridy++;
            this.add(labelHA, c);
            labelHA.setVisible(showHA);

            c.gridx++;
            c.weightx = 1;
            this.add(this.textHA, c);

            // Marge
            c.gridy++;
            c.gridx = 4;
            c.weightx = 0;
            this.add(labelMarge, c);
            labelMarge.setVisible(showHA);

            c.gridx++;
            c.weightx = 1;
            this.add(this.marge, c);

            c.gridy++;
            c.gridx = 4;
            c.gridwidth = 2;
            c.weightx = 1;
            this.add(createSeparator(), c);

            c.gridwidth = 1;
            c.weightx = 0;
        }

        // Total HT
        c.gridy++;
        c.gridx = 4;
        c.weightx = 0;
        this.add(getLabelBoldFor(textTotalHT.getField(), TM.tr("TotalPanel.total.taxExcluded")), c); //$NON-NLS-1$

        c.gridx++;
        c.weightx = 1;
        this.add(textTotalHT, c);

        if (DefaultNXProps.getInstance().getBooleanValue(AbstractVenteArticleItemTable.ARTICLE_SERVICE, false)) {
            // Service
            c.gridx = 4;
            c.gridy++;
            c.weightx = 0;
            this.add(new JLabelBold(TM.tr("TotalPanel.service.taxExcluded")), c); //$NON-NLS-1$
            c.gridx++;
            c.weightx = 1;
            this.add(this.textService, c);
        }
        // TVA
        c.gridx = 4;
        c.gridy++;
        c.weightx = 0;
        this.add(getLabelBoldFor(textTotalTVA.getField(), TM.tr("TotalPanel.total.VAT")), c); //$NON-NLS-1$
        c.gridx++;
        c.weightx = 1;
        this.add(textTotalTVA, c);

        // Sep
        c.gridwidth = 2;
        c.gridx = 4;
        c.gridy++;
        c.weightx = 1;
        c.fill = GridBagConstraints.BOTH;
        this.add(createSeparator(), c);

        if (articleItemTable.getTableElementTotalDevise() != null) {
            // devise
            c.gridwidth = 1;
            c.gridx = 4;
            c.gridy++;
            c.weightx = 0;
            c.fill = GridBagConstraints.HORIZONTAL;
            this.add(getLabelBoldFor(textTotalDevise.getField(), TM.tr("TotalPanel.currencyTotal")), c); //$NON-NLS-1$
            c.gridx++;
            c.weightx = 1;
            textTotalDevise.setFont(textTotalHT.getFont());
            this.add(textTotalDevise, c);
        }

        // Eco-contribution
        if (showEco) {
            c.gridx = 4;
            c.gridy++;
            c.weightx = 0;
            this.add(new JLabel(TM.tr("TotalPanel.ecoTax")), c); //$NON-NLS-1$
            c.gridx++;
            c.weightx = 1;
            this.add(this.textTotalEco, c);
        }

        // TTC
        c.gridwidth = 1;
        c.gridx = 4;
        c.gridy++;
        c.weightx = 0;
        c.fill = GridBagConstraints.HORIZONTAL;
        this.add(getLabelBoldFor(textTotalTTC.getField(), TM.tr("TotalPanel.total.taxIncluded")), c); //$NON-NLS-1$
        c.gridx++;
        c.weightx = 1;
        textTotalTTC.setFont(textTotalHT.getFont());
        this.add(textTotalTTC, c);

        updateTotal();
        this.table.getRowValuesTableModel().addTableModelListener(this);
        this.table.getSelectionModel().addListSelectionListener(new ListSelectionListener() {
            public void valueChanged(ListSelectionEvent e) {
                updateTotal();
            }
        });
    }

    public void setTextFraisDoc(DeviseField textFraisDoc, SQLRequestComboBox boxTVA) {
        this.textFraisDoc = textFraisDoc;
        this.selFraisDocTVA = boxTVA;
    }

    public void setTextFixTVA(JTextField textTVAFix) {
        this.textTVAFix = textTVAFix;
    }

    public void setIntraComm(boolean intraComm) {
        this.intraComm = intraComm;
        updateTotal();
    }

    private boolean achat = false;

    public void setAchat(boolean b) {
        this.achat = b;
    }

    private void reconfigure(JTextField field) {
        field.setEditable(false);
        field.setHorizontalAlignment(JTextField.RIGHT);
        field.setBorder(null);
        field.setColumns(11);
        field.setOpaque(false);
        field.setMinimumSize(new Dimension(150, 20));
        field.setPreferredSize(new Dimension(150, 20));
        field.setBackground(UIManager.getColor("control"));
        field.setEditable(false);
        field.setEnabled(false);
        field.setDisabledTextColor(Color.BLACK);
    }

    public void tableChanged(TableModelEvent e) {
        updateTotal();
    }

    private static String CLEAR = "";
    private SwingWorker<TotalCalculator, Object> worker;

    private void clearTextField() {

        if (textTotalDevise != null) {
            textTotalDevise.setText(CLEAR);
            textTotalDeviseSel.setText(CLEAR);
        }

        textPoids.setText(CLEAR);
        textTotalHT.setText(CLEAR);
        textService.setText(CLEAR);
        textTotalTVA.setText(CLEAR);
        textTotalTTC.setText(CLEAR);
        textTotalHTSel.setText(CLEAR);
        textServiceSel.setText(CLEAR);
        textTotalTVASel.setText(CLEAR);
        textTotalTTCSel.setText(CLEAR);
        if (gestionHA) {
            textHA.setText(CLEAR);
            marge.setText(CLEAR);
            textHASel.setText(CLEAR);
            margeSel.setText(CLEAR);
        }
    }

    private SQLRowAccessor defaultRowCompteProduit = null;

    public void setDefaultCompteProduit(SQLRowAccessor row) {
        this.defaultRowCompteProduit = row;
    }

    private SQLRowAccessor rowCatComptable = null;

    public void setCategorieComptable(SQLRowAccessor row) {
        this.rowCatComptable = row;
    }

    /**
     * 
     */
    public void updateTotal() {

        final long valRemiseHT;
        final BigDecimal valPortHT, fraisDoc, tvaFix;

        clearTextField();
        // Clone rows to be thread safe
        final List<SQLRowValues> vals = articleTable.getRowValuesAtLevel(1);
        final List<SQLRowValues> list = new ArrayList<SQLRowValues>(vals.size());
        for (SQLRowValues sqlRowValues : vals) {
            list.add(sqlRowValues.asRowValues());
        }


        final TotalCalculatorParameters params = new TotalCalculatorParameters(list);

        // Total Service
        String val = DefaultNXProps.getInstance().getStringProperty("ArticleService");
        Boolean bServiceActive = Boolean.valueOf(val);

        final int[] selectedRows = this.table.getSelectedRows();

        // Remise à inclure

        // FIXME Remise à appliquer en plus sur les frais de ports??
        if (this.textRemiseHT.getText().trim().length() > 0) {
            if (!this.textRemiseHT.getText().trim().equals("-")) {
                valRemiseHT = GestionDevise.parseLongCurrency(this.textRemiseHT.getText().trim());
            } else {
                valRemiseHT = 0;
            }
        } else {
            valRemiseHT = 0;
        }
        params.setRemiseHT(valRemiseHT);

        // Frais de port à inclure
        if (textPortHT.getText().trim().length() > 0) {
            if (!textPortHT.getText().trim().equals("-")) {
                long p = GestionDevise.parseLongCurrency(textPortHT.getText().trim());
                valPortHT = new BigDecimal(p).movePointLeft(2);
            } else {
                valPortHT = BigDecimal.ZERO;
            }
        } else {
            valPortHT = BigDecimal.ZERO;
        }
        params.setPortHT(valPortHT);

        final SQLRow tvaPort = selPortTVA == null ? null : selPortTVA.getSelectedRow();
        final SQLRowValues rowValsPort;
        // TVA Port inclus
        if (tvaPort != null && valPortHT.signum() != 0 && !tvaPort.isUndefined()) {
            rowValsPort = new SQLRowValues(articleTable.getSQLElement().getTable());
            rowValsPort.put(articleTable.getPrixTotalHTElement().getField().getName(), valPortHT);
            rowValsPort.put("QTE", 1);
            rowValsPort.put("ID_TAXE", tvaPort.getIDNumber());

            final SQLTable tablePrefCompte = Configuration.getInstance().getRoot().findTable("PREFS_COMPTE");
            final SQLRow rowPrefsCompte = tablePrefCompte.getRow(2);
            SQLRow rowDefaultCptPort;
            if (tvaPort.getFloat("TAUX") > 0) {
                rowDefaultCptPort = rowPrefsCompte.getForeign("ID_COMPTE_PCE_PORT_SOUMIS");
                if (rowDefaultCptPort == null || rowDefaultCptPort.isUndefined()) {
                    try {
                        rowDefaultCptPort = ComptePCESQLElement.getRowComptePceDefault("PortVenteSoumisTVA");
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            } else {
                rowDefaultCptPort = rowPrefsCompte.getForeign("ID_COMPTE_PCE_PORT_NON_SOUMIS");
                if (rowDefaultCptPort == null || rowDefaultCptPort.isUndefined()) {
                    try {
                        rowDefaultCptPort = ComptePCESQLElement.getRowComptePceDefault("PortVenteNonSoumisTVA");
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            }
            final SQLRowValues putRowValues = rowValsPort.putRowValues("ID_ARTICLE");
            putRowValues.put("ID_COMPTE_PCE", rowDefaultCptPort.getID());
            putRowValues.put("ID_COMPTE_PCE_ACHAT", rowDefaultCptPort.getID());
        } else {
            rowValsPort = null;
        }
        // Frais documents
        if (textFraisDoc.getText().trim().length() > 0) {
            if (!textFraisDoc.getText().trim().equals("-")) {
                long p = GestionDevise.parseLongCurrency(textFraisDoc.getText().trim());
                fraisDoc = new BigDecimal(p).movePointLeft(2);
            } else {
                fraisDoc = BigDecimal.ZERO;
            }
        } else {
            fraisDoc = BigDecimal.ZERO;
        }
        final SQLRow tvafraisDoc = selFraisDocTVA == null ? null : selFraisDocTVA.getSelectedRow();
        final SQLRowValues rowValsFraisDoc;
        if (tvafraisDoc != null && fraisDoc.signum() != 0 && !tvafraisDoc.isUndefined()) {
            rowValsFraisDoc = new SQLRowValues(articleTable.getSQLElement().getTable());
            rowValsFraisDoc.put(articleTable.getPrixTotalHTElement().getField().getName(), fraisDoc);
            rowValsFraisDoc.put("QTE", 1);
            rowValsFraisDoc.put("ID_TAXE", tvafraisDoc.getIDNumber());
            rowValsFraisDoc.put("SERVICE", Boolean.TRUE);
        } else {
            rowValsFraisDoc = null;
        }

        // Fix TVA si écart avec facture fournisseur
        if (textTVAFix.getText().trim().length() > 0) {
            if (!textTVAFix.getText().trim().equals("-")) {
                long p = GestionDevise.parseLongCurrency(textTVAFix.getText().trim());
                tvaFix = new BigDecimal(p).movePointLeft(2);
            } else {
                tvaFix = BigDecimal.ZERO;
            }
        } else {
            tvaFix = BigDecimal.ZERO;
        }

        final Boolean isServiceActive = bServiceActive;
        if (worker != null) {
            worker.cancel(true);
        }
        worker = new SwingWorker<TotalCalculator, Object>() {

            @Override
            protected TotalCalculator doInBackground() throws Exception {
                Thread.sleep(100);
                params.fetchArticle();

                SQLTableElement tableElementTotalDevise = articleTable.getTableElementTotalDevise();
                String fieldDevise = (tableElementTotalDevise == null ? null : tableElementTotalDevise.getField().getName());

                SQLTableElement tableElementTotalHA = (articleTable.getPrebilanElement() == null) ? articleTable.getTotalHaElement() : articleTable.getPrebilanElement();
                String fieldHA = (tableElementTotalHA == null ? null : tableElementTotalHA.getField().getName());
                SQLTableElement tableElementTotalHT = articleTable.getPrixTotalHTElement();
                String fieldHT = (tableElementTotalHT == null ? null : tableElementTotalHT.getField().getName());

                final TotalCalculator calc = new TotalCalculator(fieldHA, fieldHT, fieldDevise, achat, null, rowCatComptable);
                calc.setIntraComm(intraComm);
                if (defaultRowCompteProduit != null) {
                    calc.setRowDefaultCptProduit(defaultRowCompteProduit);
                }
                calc.setSelectedRows(selectedRows);

                // Calcul avant remise
                final BigDecimal totalHTAvtremise;

                final int size = list.size();
                calc.setServiceActive(isServiceActive);
                if (valRemiseHT != 0) {

                    for (int i = 0; i < size; i++) {
                        SQLRowValues rowVals = list.get(i);
                        calc.addLine(rowVals, params.getMapArticle().get(rowVals.getInt("ID_ARTICLE")), i, false);
                    }

                    // TVA Port inclus
                    // if (this.selPortTVA != null && !valPortHT.equals(BigDecimal.ZERO)) {
                    //
                    // SQLRow tvaPort = this.selPortTVA.getSelectedRow();
                    // if (tvaPort != null) {
                    // calc.addLine(-1, valPortHT, null, null, 1, 0, false, tvaPort, false);
                    // }
                    // }
                    totalHTAvtremise = calc.getTotalHT();
                } else {
                    totalHTAvtremise = BigDecimal.ZERO;
                }

                calc.initValues();
                calc.setSelectedRows(selectedRows);
                long valRemiseHTReel = valRemiseHT;
                if (facturable != null && facturable.getValue() != null) {
                    if (facturable.getValue().getMontant() != null && facturable.getValue().getMontant().signum() > 0) {
                        valRemiseHTReel = 0;
                    } else if (facturable.getValue().getPercent() != null && facturable.getValue().getPercent().signum() > 0) {
                        valRemiseHTReel = facturable.getValue().getPercent().movePointLeft(2).multiply(new BigDecimal(valRemiseHT)).setScale(0, RoundingMode.HALF_UP).longValue();
                    }

                }
                calc.setRemise(valRemiseHTReel, totalHTAvtremise);

                if (Thread.currentThread().isInterrupted()) {
                    throw new InterruptedException();
                }


                // Total des elements
                int rowCount = size;
                for (int i = 0; i < rowCount; i++) {
                    SQLRowValues values = list.get(i);

                    Object id = values.getObject("ID_ARTICLE");
                    calc.addLine(values, (id == null) ? null : params.getMapArticle().get(id), i, i == (rowCount - 1));
                }

                // TVA Port inclus
                if (rowValsPort != null) {
                    calc.addLine(rowValsPort, rowValsPort.getForeign("ID_ARTICLE"), 0, false);
                }

                if (rowValsFraisDoc != null) {
                    calc.addLine(rowValsFraisDoc, null, 0, false);
                }

                calc.addTVAAdjust(tvaFix);

                // Verification du resultat ht +tva = ttc
                calc.checkResult();
                if (Thread.currentThread().isInterrupted()) {
                    throw new InterruptedException();
                }
                return calc;
            }

            @Override
            protected void done() {
                // if cancel() is called after doInBackground() nothing happens
                // but updating is set to a new instance
                if (this.isCancelled() || TotalPanel.this.worker != this) {
                    // une autre maj arrive
                    return;
                }
                TotalCalculator calc;
                try {
                    calc = get();

                    BigDecimal totalHT = calc.getTotalHT();

                    if (textTotalDevise != null) {
                        textTotalDevise.setText(GestionDevise.currencyToString(calc.getTotalDevise().setScale(2, RoundingMode.HALF_UP)));
                        textTotalDeviseSel.setText(GestionDevise.currencyToString(calc.getTotalDeviseSel().setScale(2, RoundingMode.HALF_UP)));
                    }

                    textPoids.setText(String.valueOf(calc.getTotalPoids()));

                    textTotalEco.setText(GestionDevise.currencyToString(calc.getTotalEco()));
                    textTotalEcoSel.setText(GestionDevise.currencyToString(calc.getTotalEcoSel()));
                    textTotalHT.setText(GestionDevise.currencyToString(totalHT));
                    textService.setText(GestionDevise.currencyToString(calc.getTotalService().setScale(2, RoundingMode.HALF_UP)));
                    textTotalTVA.setText(GestionDevise.currencyToString(calc.getTotalTVA().setScale(2, RoundingMode.HALF_UP)));
                    textTotalTTC.setText(GestionDevise.currencyToString(calc.getTotalTTC().setScale(2, RoundingMode.HALF_UP)));
                    BigDecimal totalHTSel = calc.getTotalHTSel();
                    textTotalHTSel.setText(GestionDevise.currencyToString(totalHTSel.setScale(2, RoundingMode.HALF_UP)));
                    textServiceSel.setText(GestionDevise.currencyToString(calc.getTotalServiceSel().setScale(2, RoundingMode.HALF_UP)));

                    textTotalTVASel.setText(GestionDevise.currencyToString(calc.getTotalTVASel().setScale(2, RoundingMode.HALF_UP)));
                    textTotalTTCSel.setText(GestionDevise.currencyToString(calc.getTotalTTCSel().setScale(2, RoundingMode.HALF_UP)));
                    if (gestionHA) {
                        BigDecimal totalHA = calc.getTotalHA();
                        textHA.setText(GestionDevise.currencyToString(totalHA.setScale(2, RoundingMode.HALF_UP)));

                        BigDecimal m = BigDecimal.ZERO;
                        BigDecimal d = BigDecimal.ZERO;

                        d = totalHT.subtract(totalHA);
                        if (DefaultNXProps.getInstance().getBooleanValue(MARGE_MARQUE, false) && totalHT.signum() != 0) {
                            m = d.divide(totalHT, DecimalUtils.HIGH_PRECISION).movePointRight(2);
                        } else if (totalHA.signum() != 0) {
                            m = d.divide(totalHA, DecimalUtils.HIGH_PRECISION).movePointRight(2);
                        }

                        if (d.compareTo(BigDecimal.ZERO) <= 0) {
                            marge.setForeground(Color.red);
                            marge.setDisabledTextColor(Color.RED);
                        } else {
                            marge.setForeground(textTotalTTC.getForeground());
                            marge.setDisabledTextColor(textTotalTTC.getForeground());
                        }
                        marge.setText("(" + m.setScale(2, RoundingMode.HALF_UP) + "%) " + GestionDevise.currencyToString(d.setScale(2, RoundingMode.HALF_UP)));

                        BigDecimal totalHASel = calc.getTotalHASel();
                        textHASel.setText(GestionDevise.currencyToString(totalHASel.setScale(2, RoundingMode.HALF_UP)));

                        BigDecimal m2 = BigDecimal.ZERO;
                        BigDecimal e = BigDecimal.ZERO;

                        e = totalHTSel.subtract(totalHASel);
                        if (DefaultNXProps.getInstance().getBooleanValue(MARGE_MARQUE, false) && totalHTSel.signum() != 0) {
                            m2 = e.divide(totalHTSel, DecimalUtils.HIGH_PRECISION).movePointRight(2);
                        } else if (totalHASel.signum() != 0) {
                            m2 = e.divide(totalHASel, DecimalUtils.HIGH_PRECISION).movePointRight(2);
                        }

                        margeSel.setText("(" + m2.setScale(2, RoundingMode.HALF_UP) + "%) " + GestionDevise.currencyToString(e.setScale(2, RoundingMode.HALF_UP)));
                        if (e.compareTo(BigDecimal.ZERO) <= 0) {
                            margeSel.setForeground(Color.red);
                            margeSel.setDisabledTextColor(Color.RED);
                        } else {
                            margeSel.setForeground(textTotalTTC.getForeground());
                            margeSel.setDisabledTextColor(textTotalTTC.getForeground());
                        }

                    }
                    supp.firePropertyChange("value", null, null);
                } catch (Exception e1) {
                    ExceptionHandler.handle("", e1);
                }
            }

        };
        worker.execute();
    }

    public long getTotalHT() {
        return GestionDevise.parseLongCurrency(this.textTotalHT.getText());
    }

    private static final JLabel getLabelFor(SQLField field, String defaultLabel) {
        if (field == null) {
            return new JLabel(defaultLabel);
        }
        return new JLabel(Configuration.getInstance().getTranslator().getLabelFor(field));

    }

    private static final JLabel getLabelBoldFor(SQLField field, String defaultLabel) {
        if (field == null) {
            return new JLabelBold(defaultLabel);
        }
        return new JLabelBold(Configuration.getInstance().getTranslator().getLabelFor(field));

    }

    public void addValueListener(PropertyChangeListener listener) {
        this.supp.addPropertyChangeListener(listener);
    }

    public void removeValueListener(PropertyChangeListener listener) {
        this.supp.removePropertyChangeListener(listener);
    }

    private final JSeparator createSeparator() {
        final JSeparator sep = new JSeparator(JSeparator.HORIZONTAL);
        DefaultGridBagConstraints.lockMinimumSize(sep);
        return sep;
    }
}