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.supplychain.order.component;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.core.common.component.TransfertBaseSQLComponent;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;

import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;

import org.openconcerto.erp.core.common.ui.DeviseField;

import org.openconcerto.erp.core.common.ui.TotalPanel;

import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;

import org.openconcerto.erp.core.finance.accounting.model.CurrencyConverter;

import org.openconcerto.erp.core.finance.tax.model.TaxeCache;

import org.openconcerto.erp.core.supplychain.order.ui.FactureFournisseurItemTable;

import org.openconcerto.erp.generationDoc.gestcomm.FactureFournisseurXmlSheet;

import org.openconcerto.erp.generationEcritures.GenerationMvtFactureFournisseur;

import org.openconcerto.erp.panel.PanelOOSQLComponent;

import org.openconcerto.erp.preferences.DefaultNXProps;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.DefaultElementSQLObject;

import org.openconcerto.sql.element.ElementSQLObject;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLBackgroundTableCache;

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.model.Where;

import org.openconcerto.sql.preferences.SQLPreferences;

import org.openconcerto.sql.request.ComboSQLRequest;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.users.UserManager;

import org.openconcerto.sql.view.list.RowValuesTable;

import org.openconcerto.ui.AutoHideListener;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FormLayouter;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.ui.component.ITextArea;

import org.openconcerto.ui.preferences.DefaultProps;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.text.SimpleDocumentListener;

import java.awt.Color;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.math.BigDecimal;

import java.sql.SQLException;

import java.util.HashSet;

import java.util.List;

import java.util.Set;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import javax.swing.SwingUtilities;

import javax.swing.event.DocumentEvent;

import javax.swing.event.DocumentListener;

import javax.swing.event.TableModelEvent;

import javax.swing.event.TableModelListener;

public class FactureFournisseurSQLComponent extends TransfertBaseSQLComponent {

    private FactureFournisseurItemTable table = new FactureFournisseurItemTable();

    private final ITextArea infos = new ITextArea(3, 3);

    private ElementComboBox fourn = new ElementComboBox();

    private ElementComboBox comptePCE = new ElementComboBox();

    private ElementComboBox avoirFourn = new ElementComboBox();

    private DefaultElementSQLObject compAdr;

    private PanelOOSQLComponent panelOO;

    final JPanel panelAdrSpec = new JPanel(new GridBagLayout());

    private JDate dateCommande = new JDate();

    private final JTextField fieldTaux = new JTextField(15);

    private final DeviseField textNetAPayer = new DeviseField(15);

    private final JLabel labelTaux = new JLabel();

    private ElementSQLObject eltModeRegl;

    DeviseField fieldTTC = new DeviseField();

    DeviseField avoirTTC = new DeviseField();

    private PropertyChangeListener listenerModeReglDefaut = new PropertyChangeListener() {

        public void propertyChange(PropertyChangeEvent evt) {

            SQLRow rowFourn = fourn.getRequest().getPrimaryTable().getRow(fourn.getWantedID());

            if (!isFilling() && rowFourn != null && !rowFourn.isUndefined()) {

                // SQLRow rowCharge = rowFourn.getForeign("ID_COMPTE_PCE_CHARGE");

                // if (rowCharge != null && !rowCharge.isUndefined()) {

                // compteSel.setValue(rowCharge);

                // }

                int idModeRegl = rowFourn.getInt("ID_MODE_REGLEMENT");

                if (idModeRegl > 1 && FactureFournisseurSQLComponent.this.eltModeRegl != null && getMode() == Mode.INSERTION) {

                    SQLElement sqlEltModeRegl = getElement().getDirectory().getElement("MODE_REGLEMENT");

                    SQLRow rowModeRegl = sqlEltModeRegl.getTable().getRow(idModeRegl);

                    SQLRowValues rowVals = rowModeRegl.createUpdateRow();

                    rowVals.clearPrimaryKeys();

                    FactureFournisseurSQLComponent.this.eltModeRegl.setValue(rowVals);

                    System.err.println("Select Mode regl " + idModeRegl);

                }

                // }

            }

        }

    };

    public FactureFournisseurSQLComponent() {

        super(Configuration.getInstance().getDirectory().getElement("FACTURE_FOURNISSEUR"));

    }

    public ElementComboBox getBoxFournisseur() {

        return this.fourn;

    }

    @Override

    protected Set<String> createRequiredNames() {

        final Set<String> s = new HashSet<>(1);

        if (getTable().contains("ID_TYPE_CMD")) {

            s.add("ID_TYPE_CMD");

        }

        return s;

    }

    public void addViews() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        // Numero du commande

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel(getLabelFor("NUMERO"), SwingConstants.RIGHT), c);

        JTextField numero = new JTextField(25);

        c.gridx++;

        c.weightx = 1;

        c.fill = GridBagConstraints.NONE;

        DefaultGridBagConstraints.lockMinimumSize(numero);

        this.add(numero, c);

        // Date

        JLabel labelDate = new JLabel(getLabelFor("DATE"));

        labelDate.setHorizontalAlignment(SwingConstants.RIGHT);

        c.gridx = 2;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(labelDate, c);

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        this.add(dateCommande, c);

        this.dateCommande.addValueListener(new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                if (!isFilling() && dateCommande.getValue() != null) {

                    table.setDateDevise(dateCommande.getValue());

                    updateLabelTauxConversion();

                }

            }

        });

        // Fournisseur

        c.gridx = 0;

        c.gridy++;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(new JLabel(getLabelFor("ID_FOURNISSEUR"), SwingConstants.RIGHT), c);

        c.gridx = GridBagConstraints.RELATIVE;

        c.gridwidth = 1;

        c.weightx = 1;

        c.weighty = 0;

        c.fill = GridBagConstraints.NONE;

        this.add(this.fourn, c);

        addRequiredSQLObject(this.fourn, "ID_FOURNISSEUR");

        fourn.addModelListener("wantedID", new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                int wantedID = fourn.getWantedID();

                if (wantedID != SQLRow.NONEXISTANT_ID && wantedID >= SQLRow.MIN_VALID_ID) {

                    final SQLRow rowF = getTable().getForeignTable("ID_FOURNISSEUR").getRow(wantedID);

                    if (rowF.getObject("ID_CATEGORIE_COMPTABLE") != null && !rowF.isForeignEmpty("ID_CATEGORIE_COMPTABLE")) {

                        table.setRowCatComptable(rowF.getForeign("ID_CATEGORIE_COMPTABLE"));

                    } else {

                        table.setRowCatComptable(null);

                    }

                } else {

                    table.setRowCatComptable(null);

                }

            }

        });

        this.fourn.addModelListener("wantedID", this.listenerModeReglDefaut);

        // Champ Module

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = GridBagConstraints.REMAINDER;

        final JPanel addP = ComptaSQLConfElement.createAdditionalPanel();

        this.setAdditionalFieldsPanel(new FormLayouter(addP, 2));

        this.add(addP, c);

        c.gridy++;

        c.gridwidth = 1;

        SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());

        final boolean showDevise = prefs.getBoolean(AbstractVenteArticleItemTable.ARTICLE_SHOW_DEVISE, false);

        final ElementComboBox boxDevise = new ElementComboBox();

        if (showDevise) {

            // Devise

            c.gridx = 0;

            c.gridy++;

            c.weightx = 0;

            c.fill = GridBagConstraints.HORIZONTAL;

            this.add(new JLabel(getLabelFor("ID_DEVISE"), SwingConstants.RIGHT), c);

            c.gridx++;

            c.gridwidth = 1;

            c.weightx = 1;

            c.weighty = 0;

            c.fill = GridBagConstraints.NONE;

            this.add(boxDevise, c);

            this.addView(boxDevise, "ID_DEVISE");

            this.fourn.addModelListener("wantedID", new PropertyChangeListener() {

                @Override

                public void propertyChange(PropertyChangeEvent evt) {

                    table.setFournisseur(fourn.getSelectedRow());

                    SQLRow row = fourn.getSelectedRow();

                    if (!isFilling()) {

                        if (row != null && !row.isUndefined() && !row.isForeignEmpty("ID_DEVISE")) {

                            boxDevise.setValue(row.getForeignID("ID_DEVISE"));

                        }

                    }

                    if (row != null && !row.isUndefined()) {

                        avoirFourn.getRequest().setWhere(new Where(avoirFourn.getRequest().getPrimaryTable().getField("ID_FOURNISSEUR"), "=", row.getID()));

                    } else {

                        avoirFourn.getRequest().setWhere(null);

                    }

                }

            });

            if (getTable().contains("TAUX_APPLIQUE")) {

                // Devise

                c.gridx++;

                c.weightx = 0;

                c.fill = GridBagConstraints.HORIZONTAL;

                this.add(new JLabel(getLabelFor("TAUX_APPLIQUE"), SwingConstants.RIGHT), c);

                c.gridx++;

                c.gridwidth = 1;

                c.weightx = 1;

                c.weighty = 0;

                c.fill = GridBagConstraints.NONE;

                DefaultGridBagConstraints.lockMinimumSize(this.fieldTaux);

                JPanel panelTaux = new JPanel();

                panelTaux.add(this.fieldTaux);

                panelTaux.add(this.labelTaux);

                this.add(panelTaux, c);

                this.addView(this.fieldTaux, "TAUX_APPLIQUE");

            }

        }

        // Compte pce

        c.gridx = 0;

        c.gridy++;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(new JLabel(getLabelFor("ID_COMPTE_PCE"), SwingConstants.RIGHT), c);

        c.gridx = GridBagConstraints.RELATIVE;

        c.gridwidth = 1;

        c.weightx = 1;

        c.weighty = 0;

        c.fill = GridBagConstraints.NONE;

        this.add(this.comptePCE, c);

        final SQLElement foreignElement = getElement().getForeignElement("ID_COMPTE_PCE");

        final ComboSQLRequest comboRequest = foreignElement.getComboRequest(true);

        comboRequest.setWhere(new Where(foreignElement.getTable().getField("NUMERO"), "LIKE", "6%"));

        this.comptePCE.init(foreignElement, comboRequest);

        this.addView(this.comptePCE, "ID_COMPTE_PCE");

        // Reference

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = 1;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.anchor = GridBagConstraints.EAST;

        this.add(new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT), c);

        final JTextField textNom = new JTextField();

        c.gridx++;

        c.weightx = 1;

        this.add(textNom, c);

        String field;

            field = "ID_COMMERCIAL";

        // Commercial

        c.weightx = 0;

        c.gridx++;

        this.add(new JLabel(getLabelFor(field), SwingConstants.RIGHT), c);

        ElementComboBox commSel = new ElementComboBox(false, 25);

        c.gridx = GridBagConstraints.RELATIVE;

        c.gridwidth = 1;

        c.weightx = 1;

        c.weighty = 0;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.WEST;

        this.add(commSel, c);

        addRequiredSQLObject(commSel, field);

        // Table d'élément

        c.fill = GridBagConstraints.BOTH;

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        c.weighty = 1;

        c.gridwidth = 4;

        this.add(this.table, c);

        if (showDevise) {

            boxDevise.addValueListener(new PropertyChangeListener() {

                @Override

                public void propertyChange(PropertyChangeEvent evt) {

                    table.setDevise(boxDevise.getSelectedRow());

                    updateLabelTauxConversion();

                }

            });

            fieldTaux.getDocument().addDocumentListener(new SimpleDocumentListener() {

                @Override

                public void update(DocumentEvent e) {

                    BigDecimal tauxConversion = null;

                    if (fieldTaux.getText().trim().length() > 0) {

                        tauxConversion = new BigDecimal(fieldTaux.getText());

                    }

                    table.setTauxConversion(tauxConversion);

                    updateLabelTauxConversion();

                }

            });

        }

        this.fourn.addModelListener("wantedID", new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                table.setFournisseur(fourn.getSelectedRow());

                if (!isFilling()) {

                    SQLRow row = fourn.getSelectedRow();

                    if (row != null && !row.isUndefined()) {

                        row.fetchValues();

                        if (!row.isForeignEmpty("ID_COMPTE_PCE_CHARGE")) {

                            comptePCE.setValue(row.getForeign("ID_COMPTE_PCE_CHARGE"));

                        }

                    }

                }

            }

        });

        // Bottom

        c.gridy++;

        c.weighty = 0;

        this.add(getBottomPanel(), c);

        c.gridx = 0;

        c.gridy++;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.anchor = GridBagConstraints.WEST;

        c.gridx = 0;

        c.gridy++;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.SOUTHEAST;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.panelOO = new PanelOOSQLComponent(this);

        this.add(this.panelOO, c);

        addSQLObject(textNom, "NOM");

        addRequiredSQLObject(dateCommande, "DATE");

        addRequiredSQLObject(numero, "NUMERO");

        addSQLObject(this.infos, "INFOS");

        DefaultGridBagConstraints.lockMinimumSize(this.fourn);

        DefaultGridBagConstraints.lockMinimumSize(commSel);

    }

    private void updateLabelTauxConversion() {

        String result = "";

        if (this.fieldTaux.getText().trim().length() == 0 && this.table.getDevise() != null && !this.table.getDevise().isUndefined()) {

            CurrencyConverter converter = new CurrencyConverter();

            BigDecimal taux = converter.convert(BigDecimal.ONE, converter.getCompanyCurrencyCode(), this.table.getDevise().getString("CODE"), this.table.getDateDevise(), false);

            result = "(" + taux + ")";

        } else {

            result = "(" + this.fieldTaux.getText() + ")";

        }

        this.labelTaux.setText(result);

    }

    private JPanel getBottomPanel() {

        final JPanel panel = new JPanel(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        // Colonne 1 : Infos

        c.gridx = 0;

        c.weightx = 1;

        c.anchor = GridBagConstraints.WEST;

        c.fill = GridBagConstraints.HORIZONTAL;

        panel.add(new TitledSeparator(getLabelFor("INFOS")), c);

        c.gridy++;

        c.weighty = 0;

        c.weightx = 1;

        c.fill = GridBagConstraints.BOTH;

        final JScrollPane scrollPane = new JScrollPane(this.infos);

        scrollPane.setBorder(null);

        panel.add(scrollPane, c);

        this.addView("ID_MODE_REGLEMENT", REQ + ";" + DEC + ";" + SEP);

        this.eltModeRegl = (ElementSQLObject) this.getView("ID_MODE_REGLEMENT");

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        c.weighty = 1;

        eltModeRegl.setOpaque(false);

        panel.add(eltModeRegl, c);

        // Colonne 2 : Poids & autres

        DefaultProps props = DefaultNXProps.getInstance();

        Boolean b = props.getBooleanValue("ArticleShowPoids");

        final JTextField textPoidsTotal = new JTextField(8);

        JTextField poids = new JTextField();

        if (b) {

            final JPanel panelPoids = new JPanel();

            panelPoids.add(new JLabel(getLabelFor("T_POIDS")), c);

            textPoidsTotal.setEnabled(false);

            textPoidsTotal.setHorizontalAlignment(JTextField.RIGHT);

            textPoidsTotal.setDisabledTextColor(Color.BLACK);

            panelPoids.add(textPoidsTotal, c);

            c.gridx++;

            c.gridy = 0;

            c.weightx = 0;

            c.weighty = 0;

            c.gridwidth = 1;

            c.gridheight = 2;

            c.fill = GridBagConstraints.NONE;

            c.anchor = GridBagConstraints.NORTHEAST;

            panel.add(panelPoids, c);

            DefaultGridBagConstraints.lockMinimumSize(panelPoids);

            addSQLObject(textPoidsTotal, "T_POIDS");

        } else {

            addSQLObject(poids, "T_POIDS");

        }

        DeviseField textPortHT = new DeviseField();

        ElementComboBox comboTaxePort = new ElementComboBox();

        DeviseField textRemiseHT = new DeviseField();

        final JPanel panelPoids = new JPanel(new GridBagLayout());

        GridBagConstraints cPort = new DefaultGridBagConstraints();

        if (getTable().contains("PORT_HT")) {

            addSQLObject(textPortHT, "PORT_HT");

            cPort.gridx = 0;

            cPort.weightx = 0;

            panelPoids.add(new JLabel(getLabelFor("PORT_HT")), cPort);

            textPortHT.setHorizontalAlignment(JTextField.RIGHT);

            cPort.gridx++;

            cPort.weightx = 1;

            panelPoids.add(textPortHT, cPort);

            cPort.gridy++;

            cPort.gridx = 0;

            cPort.weightx = 0;

            addRequiredSQLObject(comboTaxePort, "ID_TAXE_PORT");

            panelPoids.add(new JLabel(getLabelFor("ID_TAXE_PORT")), cPort);

            cPort.gridx++;

            cPort.weightx = 0;

            panelPoids.add(comboTaxePort, cPort);

            c.gridx++;

            c.gridy = 0;

            c.weightx = 0;

            c.weighty = 0;

            c.gridwidth = 1;

            c.gridheight = 2;

            c.fill = GridBagConstraints.NONE;

            c.anchor = GridBagConstraints.NORTHEAST;

            panel.add(panelPoids, c);

            DefaultGridBagConstraints.lockMinimumSize(panelPoids);

            addSQLObject(textRemiseHT, "REMISE_HT");

            cPort.gridy++;

            cPort.gridx = 0;

            cPort.fill = GridBagConstraints.NONE;

            cPort.weightx = 0;

            panelPoids.add(new JLabel(getLabelFor("REMISE_HT")), cPort);

            textRemiseHT.setHorizontalAlignment(JTextField.RIGHT);

            cPort.gridx++;

            cPort.weightx = 1;

            panelPoids.add(textRemiseHT, cPort);

        }

        // Total

        DeviseField fieldHT = new DeviseField();

        DeviseField fieldEco = new DeviseField();

        DeviseField fieldTVA = new DeviseField();

        DeviseField fieldDevise = new DeviseField();

        DeviseField fieldService = new DeviseField();

        fieldHT.setOpaque(false);

        fieldTVA.setOpaque(false);

        fieldTTC.setOpaque(false);

        fieldService.setOpaque(false);

        addRequiredSQLObject(fieldDevise, "T_DEVISE");

        addRequiredSQLObject(fieldEco, "T_ECO_CONTRIBUTION");

        addRequiredSQLObject(fieldHT, "T_HT");

        addRequiredSQLObject(fieldTVA, "T_TVA");

        addRequiredSQLObject(fieldTTC, "T_TTC");

        addRequiredSQLObject(fieldService, "T_SERVICE");

        fieldTTC.getDocument().addDocumentListener(new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                refreshText();

            }

        });

        // Disable

        this.allowEditable("T_ECO_CONTRIBUTION", false);

        this.allowEditable("T_HT", false);

        this.allowEditable("T_TVA", false);

        this.allowEditable("T_TTC", false);

        this.allowEditable("T_SERVICE", false);

        this.allowEditable("T_POIDS", false);

        final TotalPanel totalTTC = new TotalPanel(this.table, fieldEco, fieldHT, fieldTVA, fieldTTC, textPortHT, textRemiseHT, fieldService, null, fieldDevise, null, null,

                (getTable().contains("ID_TAXE_PORT") ? comboTaxePort : null), null);

        if (getTable().contains("TVA_ADJUSTMENT")) {

            final JTextField textTvaAdujs = new JTextField(15);

            JLabel labelTvaAdujst = new JLabel(getLabelFor("TVA_ADJUSTMENT"));

            labelTvaAdujst.setHorizontalAlignment(SwingConstants.RIGHT);

            cPort.gridx = 0;

            cPort.gridy++;

            panelPoids.add(labelTvaAdujst, cPort);

            cPort.gridx++;

            panelPoids.add(textTvaAdujs, cPort);

            addView(textTvaAdujs, "TVA_ADJUSTMENT");

            totalTTC.setTextFixTVA(textTvaAdujs);

            textTvaAdujs.getDocument().addDocumentListener(new SimpleDocumentListener() {

                @Override

                public void update(final DocumentEvent e) {

                    final String text = textTvaAdujs.getText();

                    if (text != null && text.trim().length() > 0) {

                        if (!text.trim().equals("-")) {

                            BigDecimal tvaFix = new BigDecimal(text);

                            if (tvaFix.abs().compareTo(new BigDecimal(0.05)) > 0) {

                                final String limitedFix;

                                if (tvaFix.signum() > 0) {

                                    limitedFix = tvaFix.min(new BigDecimal(0.05)).toString();

                                } else {

                                    limitedFix = tvaFix.max(new BigDecimal(-0.05)).toString();

                                }

                                SwingUtilities.invokeLater(new Runnable() {

                                    @Override

                                    public void run() {

                                        textTvaAdujs.setText(limitedFix);

                                    }

                                });

                            }

                        }

                    }

                    totalTTC.updateTotal();

                }

            });

            DefaultGridBagConstraints.lockMinimumSize(textTvaAdujs);

        }

        c.gridx++;

        c.gridy--;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridheight = 2;

        c.anchor = GridBagConstraints.NORTHEAST;

        c.fill = GridBagConstraints.BOTH;

        c.weighty = 0;

        DefaultGridBagConstraints.lockMinimumSize(totalTTC);

        panel.add(totalTTC, c);

        c.gridy += 3;

        c.gridheight = 1;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.EAST;

        panel.add(createPanelAvoir(), c);

        c.gridy += 4;

        c.gridheight = 2;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.EAST;

        panel.add(getModuleTotalPanel(), c);

        table.getModel().addTableModelListener(new TableModelListener() {

            public void tableChanged(TableModelEvent e) {

                textPoidsTotal.setText(String.valueOf(table.getPoidsTotal()));

            }

        });

        this.fourn.addModelListener("wantedID", new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                final SQLRow selectedRow2 = fourn.getSelectedRow();

                if (selectedRow2 != null && !selectedRow2.isUndefined()) {

                    totalTTC.setIntraComm(selectedRow2.getBoolean("UE"));

                } else {

                    totalTTC.setIntraComm(false);

                }

            }

        });

        textPortHT.getDocument().addDocumentListener(new DocumentListener() {

            public void changedUpdate(DocumentEvent e) {

                totalTTC.updateTotal();

            }

            public void removeUpdate(DocumentEvent e) {

                totalTTC.updateTotal();

            }

            public void insertUpdate(DocumentEvent e) {

                totalTTC.updateTotal();

            }

        });

        comboTaxePort.addValueListener(new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                // TODO Raccord de méthode auto-généré

                totalTTC.updateTotal();

            }

        });

        textRemiseHT.getDocument().addDocumentListener(new DocumentListener() {

            public void changedUpdate(DocumentEvent e) {

                totalTTC.updateTotal();

            }

            public void removeUpdate(DocumentEvent e) {

                totalTTC.updateTotal();

            }

            public void insertUpdate(DocumentEvent e) {

                totalTTC.updateTotal();

            }

        });

        return panel;

    }

    protected JPanel getModuleTotalPanel() {

        return AutoHideListener.listen(new JPanel());

    }

    public int insert(SQLRow order) {

        int idFacture = getSelectedID();

        idFacture = super.insert(order);

        this.table.updateField("ID_FACTURE_FOURNISSEUR", idFacture);

        // Création des articles

        this.table.createArticle(idFacture, this.getElement());

        final SQLRow rowA = getTable().getRow(idFacture);

        new GenerationMvtFactureFournisseur(rowA);

        final FactureFournisseurXmlSheet sheet = new FactureFournisseurXmlSheet(rowA);

        sheet.createDocumentAsynchronous();

        sheet.showPrintAndExportAsynchronous(this.panelOO.isVisualisationSelected(), this.panelOO.isImpressionSelected(), true);

        commitAvoir(null, rowA);

        return idFacture;

    }

    @Override

    public void update() {

        SQLRow rowFactureOld = getTable().getRow(getSelectedID());

        super.update();

        SQLRow row = getTable().getRow(getSelectedID());

        this.table.updateField("ID_FACTURE_FOURNISSEUR", row.getID());

        this.table.createArticle(getSelectedID(), this.getElement());

        int idMvt = (row.getObject("ID_MOUVEMENT") == null ? 1 : row.getInt("ID_MOUVEMENT"));

        System.err.println("__________***************** UPDATE" + idMvt);

        // on supprime tout ce qui est lié à la facture

        EcritureSQLElement eltEcr = (EcritureSQLElement) Configuration.getInstance().getDirectory().getElement("ECRITURE");

        eltEcr.archiveMouvementProfondeur(idMvt, false);

        if (idMvt > 1) {

            new GenerationMvtFactureFournisseur(row, idMvt);

        } else {

            new GenerationMvtFactureFournisseur(row);

        }

        final FactureFournisseurXmlSheet sheet = new FactureFournisseurXmlSheet(row);

        sheet.createDocumentAsynchronous();

        sheet.showPrintAndExportAsynchronous(this.panelOO.isVisualisationSelected(), this.panelOO.isImpressionSelected(), true);

        commitAvoir(rowFactureOld, row);

    }

    public void commitAvoir(SQLRow rowFactureOld, SQLRow rowFacture) {

        try {

            if (rowFactureOld != null && rowFactureOld.getObject("ID_AVOIR_FOURNISSEUR") != null && !rowFactureOld.isForeignEmpty("ID_AVOIR_FOURNISSEUR")

                    && (rowFacture.getObject("ID_AVOIR_FOURNISSEUR") == null || rowFacture.isForeignEmpty("ID_AVOIR_FOURNISSEUR"))) {

                SQLRow rowAvoir = rowFactureOld.getForeignRow("ID_AVOIR_FOURNISSEUR");

                SQLRowValues rowVals = rowAvoir.createEmptyUpdateRow();

                // Soldé

                rowVals.put("SOLDE", Boolean.FALSE);

                rowVals.update();

            }

            // on solde l'avoir

            if (rowFacture.getObject("ID_AVOIR_FOURNISSEUR") != null && !rowFacture.isForeignEmpty("ID_AVOIR_FOURNISSEUR")) {

                SQLRow rowAvoir = rowFacture.getForeignRow("ID_AVOIR_FOURNISSEUR");

                SQLRowValues rowVals = rowAvoir.createEmptyUpdateRow();

                rowVals.put("SOLDE", Boolean.TRUE);

                rowVals.update();

            }

        } catch (SQLException e) {

            ExceptionHandler.handle("Erreur lors la mise à jour de l'avoir associée!", e);

        }

    }

    public void setDefaults() {

        this.resetValue();

        this.table.getModel().clearRows();

    }

    @Override

    protected SQLRowValues createDefaults() {

        SQLRowValues rowVals = new SQLRowValues(getTable());

        rowVals.put("T_POIDS", 0.0F);

        // User

        // SQLSelect sel = new SQLSelect(Configuration.getInstance().getBase());

        SQLElement eltComm = Configuration.getInstance().getDirectory().getElement("COMMERCIAL");

        int idUser = UserManager.getInstance().getCurrentUser().getId();

        // sel.addSelect(eltComm.getTable().getKey());

        // sel.setWhere(new Where(eltComm.getTable().getField("ID_USER_COMMON"), "=", idUser));

        // List<SQLRow> rowsComm = (List<SQLRow>)

        // Configuration.getInstance().getBase().getDataSource().execute(sel.asString(), new

        // SQLRowListRSH(eltComm.getTable()));

        SQLRow rowsComm = SQLBackgroundTableCache.getInstance().getCacheForTable(eltComm.getTable()).getFirstRowContains(idUser, eltComm.getTable().getField("ID_USER_COMMON"));

        if (rowsComm != null) {

            rowVals.put("ID_COMMERCIAL", rowsComm.getID());

        }

        rowVals.put("T_HT", Long.valueOf(0));

        rowVals.put("T_SERVICE", Long.valueOf(0));

        rowVals.put("T_DEVISE", Long.valueOf(0));

        rowVals.put("T_TVA", Long.valueOf(0));

        rowVals.put("T_TTC", Long.valueOf(0));

        // rowVals.put("NUMERO",

        // NumerotationAutoSQLElement.getNextNumero(CommandeSQLElement.class));

        if (getTable().contains("ID_TAXE_PORT")) {

            rowVals.put("ID_TAXE_PORT", TaxeCache.getCache().getFirstTaxe().getID());

        }

        return rowVals;

    }

    @Override

    public RowValuesTable getRowValuesTable() {

        return this.table.getRowValuesTable();

    }

    private JPanel createPanelAvoir() {

        JPanel panelAvoir = new JPanel(new GridBagLayout());

        panelAvoir.setOpaque(false);

        GridBagConstraints cA = new DefaultGridBagConstraints();

        JLabel labelAvoir = new JLabel(getLabelFor("ID_AVOIR_FOURNISSEUR"));

        labelAvoir.setHorizontalAlignment(SwingConstants.RIGHT);

        cA.weightx = 1;

        labelAvoir.setHorizontalAlignment(SwingConstants.RIGHT);

        panelAvoir.add(labelAvoir, cA);

        cA.weightx = 0;

        cA.gridx++;

        this.avoirFourn = new ElementComboBox();

        this.avoirFourn.setAddIconVisible(false);

        panelAvoir.add(this.avoirFourn, cA);

        final JLabel labelTotalAvoir = new JLabel("Total à régler");

        this.textNetAPayer.setEditable(false);

        cA.gridx++;

        cA.weightx = 0;

        panelAvoir.add(labelTotalAvoir, cA);

        cA.gridx++;

        cA.weightx = 0;

        panelAvoir.add(this.textNetAPayer, cA);

        addView(textNetAPayer, "NET_A_PAYER");

        this.textNetAPayer.setHorizontalAlignment(SwingConstants.RIGHT);

        addView(this.avoirFourn, "ID_AVOIR_FOURNISSEUR");

        addView(avoirTTC, "AVOIR_TTC");

        this.avoirFourn.addValueListener(new PropertyChangeListener() {

            public void propertyChange(PropertyChangeEvent evt) {

                refreshText();

            }

        });

        return panelAvoir;

    }

    private void refreshText() {

        Number n = this.fieldTTC.getValue();

        long totalAvoirTTC = 0;

        long netAPayer = 0;

        long ttc = 0;

        if (n != null) {

            netAPayer = n.longValue();

            ttc = n.longValue();

        }

        if (this.avoirFourn.getSelectedId() > 1) {

            SQLTable tableAvoir = getTable().getForeignTable("ID_AVOIR_FOURNISSEUR");

            if (n != null) {

                SQLRow rowAvoir = tableAvoir.getRow(this.avoirFourn.getSelectedId());

                long totalAvoir = ((Number) rowAvoir.getObject("MONTANT_TTC")).longValue();

                if (getSelectedID() > 1) {

                    SQLRow row = getTable().getRow(getSelectedID());

                    int idAvoirOld = row.getInt("ID_AVOIR_FOURNISSEUR");

                    if (idAvoirOld == rowAvoir.getID()) {

                        totalAvoir += Long.valueOf(row.getObject("AVOIR_TTC").toString());

                    }

                }

                long l = ttc - totalAvoir;

                if (l < 0) {

                    l = 0;

                    totalAvoirTTC = ttc;

                } else {

                    totalAvoirTTC = totalAvoir;

                }

                netAPayer = l;

            }

        }

        this.textNetAPayer.setValue(netAPayer);

        this.avoirTTC.setValue(totalAvoirTTC);

    }

    @Override

    protected void refreshAfterSelect(SQLRowAccessor rSource) {

        if (this.dateCommande.getValue() != null) {

            this.table.setDateDevise(this.dateCommande.getValue());

            updateLabelTauxConversion();

        }

    }

    public void loadFactureExistante(int idFacture) {

        SQLElement fact = getElement();

        SQLElement factElt = getElement().getDirectory().getElement("FACTURE_FOURNISSEUR_ELEMENT");

        // On duplique la facture

        if (idFacture > 1) {

            SQLRow row = fact.getTable().getRow(idFacture);

            SQLRowValues rowVals = new SQLRowValues(fact.getTable());

            rowVals.put("ID_FOURNISSEUR", row.getInt("ID_FOURNISSEUR"));

            // if (getTable().contains("ID_NUMEROTATION_AUTO")) {

            // rowVals.put("NUMERO",

            // NumerotationAutoSQLElement.getNextNumero(SaisieVenteFactureSQLElement.class, new

            // Date(), row.getForeign("ID_NUMEROTATION_AUTO")));

            // } else {

            // rowVals.put("NUMERO",

            // NumerotationAutoSQLElement.getNextNumero(SaisieVenteFactureSQLElement.class, new

            // Date()));

            // }

            rowVals.put("NOM", row.getObject("NOM"));

            this.select(rowVals);

        }

        // On duplique les elements de facture

        List<SQLRow> myListItem = fact.getTable().getRow(idFacture).getReferentRows(factElt.getTable());

        if (myListItem.size() != 0) {

            this.table.getModel().clearRows();

            for (SQLRow rowElt : myListItem) {

                SQLRowValues rowVals = rowElt.createUpdateRow();

                rowVals.clearPrimaryKeys();

                this.table.getModel().addRow(rowVals);

                int rowIndex = this.table.getModel().getRowCount() - 1;

                this.table.getModel().fireTableModelModified(rowIndex);

            }

        } else {

            this.table.getModel().clearRows();

        }

        this.table.getModel().fireTableDataChanged();

        this.table.repaint();

    }

}