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

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

import org.openconcerto.erp.core.sales.pos.io.BarcodeReader;

import org.openconcerto.erp.core.sales.pos.ui.BarcodeListener;

import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;

import org.openconcerto.erp.core.sales.product.element.UniteVenteArticleSQLElement;

import org.openconcerto.erp.core.sales.product.ui.CurrencyWithSymbolRenderer;

import org.openconcerto.erp.core.sales.product.ui.DeliveredQtyRowValuesRenderer;

import org.openconcerto.erp.core.sales.product.ui.QteUnitRowValuesRenderer;

import org.openconcerto.erp.preferences.DefaultNXProps;

import org.openconcerto.erp.preferences.GestionArticleGlobalPreferencePanel;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.FieldPath;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.UndefinedRowValuesCache;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.model.graph.Path;

import org.openconcerto.sql.preferences.SQLPreferences;

import org.openconcerto.sql.sqlobject.ITextArticleWithCompletionCellEditor;

import org.openconcerto.sql.sqlobject.ITextWithCompletion;

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

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

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

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

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

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

import org.openconcerto.utils.DecimalUtils;

import org.openconcerto.utils.Tuple3;

import org.openconcerto.utils.i18n.TranslationManager;

import java.awt.Component;

import java.awt.event.ActionEvent;

import java.awt.event.HierarchyEvent;

import java.awt.event.HierarchyListener;

import java.awt.event.KeyEvent;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.math.BigDecimal;

import java.math.RoundingMode;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Calendar;

import java.util.HashMap;

import java.util.HashSet;

import java.util.List;

import java.util.Map;

import java.util.Set;

import java.util.Vector;

import javax.swing.AbstractAction;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPopupMenu;

import javax.swing.JTable;

import javax.swing.SwingUtilities;

import javax.swing.ToolTipManager;

import javax.swing.event.TableModelEvent;

import javax.swing.event.TableModelListener;

import javax.swing.table.DefaultTableCellRenderer;

import javax.swing.table.TableCellRenderer;

public abstract class AbstractAchatArticleItemTable extends AbstractArticleItemTable {

    private AutoCompletionManager m;

    private AutoCompletionManager m2, m3;

    private AutoCompletionManager m4;

    private final SQLTable tableArticle = getSQLElement().getTable().getTable("ARTICLE");

    private SQLRowAccessor rowDevise;

    private boolean supplierCode;

    public AbstractAchatArticleItemTable() {

        super();

    }

    @Override

    protected void setModel(RowValuesTableModel model) {

        super.setModel(model);

        model.addTableModelListener(new TableModelListener() {

            @Override

            public void tableChanged(TableModelEvent e) {

                calculTarifNomenclature();

            }

        });

    }

    protected void init() {

        final SQLElement e = getSQLElement();

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

        final boolean selectArticle = prefs.getBoolean(GestionArticleGlobalPreferencePanel.USE_CREATED_ARTICLE, false);

        final boolean createAuto = prefs.getBoolean(GestionArticleGlobalPreferencePanel.CREATE_ARTICLE_AUTO, true);

        final boolean showEco = prefs.getBoolean(AbstractVenteArticleItemTable.SHOW_ECO_CONTRIBUTION_COLUMNS, false);

        final boolean showDmdAchat = prefs.getBoolean(GestionArticleGlobalPreferencePanel.ACTIVE_DEMANDE_ACHAT, false);

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

        this.supplierCode = prefs.getBoolean(GestionArticleGlobalPreferencePanel.SUPPLIER_PRODUCT_CODE, false);

        final List<SQLTableElement> list = new Vector<SQLTableElement>();

        final SQLTableElement eNiveau = new SQLTableElement(e.getTable().getField("NIVEAU")) {

            @Override

            public void setValueFrom(SQLRowValues row, Object value) {

                super.setValueFrom(row, value);

            }

        };

        eNiveau.setRenderer(new NiveauTableCellRender());

        eNiveau.setEditor(new NiveauTableCellEditor());

        list.add(eNiveau);

        list.add(new SQLTableElement(e.getTable().getField("ID_STYLE")));

        SQLTableElement dmdElt = null;

        if (showDmdAchat && e.getTable().contains("ID_DEMANDE_ACHAT_ELEMENT")) {

            dmdElt = new SQLTableElement(e.getTable().getField("ID_DEMANDE_ACHAT_ELEMENT"));

            list.add(dmdElt);

        }

        if (e.getTable().contains("ID_AFFAIRE")) {

            list.add(new SQLTableElement(e.getTable().getField("ID_AFFAIRE")));

        }

        SQLTableElement tableElementCodeFournisseur = null;

        if (e.getTable().contains("ID_CODE_FOURNISSEUR") && supplierCode) {

            tableElementCodeFournisseur = new SQLTableElement(e.getTable().getField("ID_CODE_FOURNISSEUR"), true, true, true);

            list.add(tableElementCodeFournisseur);

        }

        if (e.getTable().contains("ID_COMPTE_PCE")) {

            list.add(new SQLTableElement(e.getTable().getField("ID_COMPTE_PCE")));

        }

        SQLTableElement tableElementArticle = new SQLTableElement(e.getTable().getField("ID_ARTICLE"), true, true, true) {

            @Override

            public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {

                boolean b = super.isCellEditable(vals, rowIndex, columnIndex);

                if (vals.getTable().contains("ID_COMMANDE_ELEMENT")) {

                    boolean noCmdElt = vals.getObject("ID_COMMANDE_ELEMENT") == null || vals.isForeignEmpty("ID_COMMANDE_ELEMENT");

                    return b && noCmdElt;

                } else {

                    return b;

                }

            }

        };

        list.add(tableElementArticle);

        // Article

        SQLTableElement tableElementDepot = new SQLTableElement(e.getTable().getField("ID_DEPOT_STOCK"), true, true, true);

        list.add(tableElementDepot);

        if (e.getTable().getFieldsName().contains("ID_FAMILLE_ARTICLE")) {

            final SQLTableElement tableFamille = new SQLTableElement(e.getTable().getField("ID_FAMILLE_ARTICLE"));

            list.add(tableFamille);

        }

        if (e.getTable().getFieldsName().contains("ID_ECO_CONTRIBUTION")) {

            this.tableElementEcoID = new SQLTableElement(e.getTable().getField("ID_ECO_CONTRIBUTION"));

            list.add(this.tableElementEcoID);

        }

        if (e.getTable().getFieldsName().contains("INCOTERM")) {

            final SQLTableElement tableElementInco = new SQLTableElement(e.getTable().getField("INCOTERM"));

            tableElementInco.setEditable(false);

            list.add(tableElementInco);

        }

        if (e.getTable().getFieldsName().contains("PREBILAN")) {

            final SQLTableElement tableElementPre = new SQLTableElement(e.getTable().getField("PREBILAN"), BigDecimal.class);

            tableElementPre.setRenderer(new DeviseTableCellRenderer());

            list.add(tableElementPre);

        }

        // Code article

        final SQLTableElement tableElementCode = new SQLTableElement(e.getTable().getField("CODE"), String.class,

                new ITextArticleWithCompletionCellEditor(e.getTable().getTable("ARTICLE"), e.getTable().getTable("ARTICLE_FOURNISSEUR"))) {

            @Override

            public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {

                boolean b = super.isCellEditable(vals, rowIndex, columnIndex);

                if (vals.getTable().contains("ID_COMMANDE_ELEMENT")) {

                    boolean noCmdElt = vals.getObject("ID_COMMANDE_ELEMENT") == null || vals.isForeignEmpty("ID_COMMANDE_ELEMENT");

                    return b && noCmdElt;

                } else {

                    return b;

                }

            }

        };

        list.add(tableElementCode);

        // Désignation de l'article

        final SQLTableElement tableElementNom = new SQLTableElement(e.getTable().getField("NOM")) {

            @Override

            public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {

                boolean b = super.isCellEditable(vals, rowIndex, columnIndex);

                if (vals.getTable().contains("ID_COMMANDE_ELEMENT")) {

                    boolean noCmdElt = vals.getObject("ID_COMMANDE_ELEMENT") == null || vals.isForeignEmpty("ID_COMMANDE_ELEMENT");

                    return b && noCmdElt;

                } else {

                    return b;

                }

            }

        };

        list.add(tableElementNom);

        if (e.getTable().getFieldsName().contains("DESCRIPTIF")) {

            final SQLTableElement tableElementDesc = new SQLTableElement(e.getTable().getField("DESCRIPTIF"));

            list.add(tableElementDesc);

        }

        if (e.getTable().getFieldsName().contains("COLORIS")) {

            final SQLTableElement tableElementColoris = new SQLTableElement(e.getTable().getField("COLORIS"));

            list.add(tableElementColoris);

        }

        // Valeur des métriques

        final SQLTableElement tableElement_ValeurMetrique2 = new SQLTableElement(e.getTable().getField("VALEUR_METRIQUE_2"), Float.class);

        list.add(tableElement_ValeurMetrique2);

        final SQLTableElement tableElement_ValeurMetrique3 = new SQLTableElement(e.getTable().getField("VALEUR_METRIQUE_3"), Float.class);

        list.add(tableElement_ValeurMetrique3);

        final SQLTableElement tableElement_ValeurMetrique1 = new SQLTableElement(e.getTable().getField("VALEUR_METRIQUE_1"), Float.class);

        list.add(tableElement_ValeurMetrique1);

        // Prix d'achat HT de la métrique 1

        final DeviseNumericHTConvertorCellEditor editorPAHT = new DeviseNumericHTConvertorCellEditor(e.getTable().getField("PRIX_METRIQUE_HA_1"));

        final SQLTableElement tableElement_PrixMetrique1_AchatHT = new SQLTableElement(e.getTable().getField("PRIX_METRIQUE_HA_1"), BigDecimal.class, editorPAHT);

        tableElement_PrixMetrique1_AchatHT.setRenderer(new CurrencyWithSymbolRenderer());

        list.add(tableElement_PrixMetrique1_AchatHT);

        if (e.getTable().getFieldsName().contains("ECO_CONTRIBUTION")) {

            this.tableElementEco = new SQLTableElement(e.getTable().getField("ECO_CONTRIBUTION"));

            list.add(this.tableElementEco);

        }

        final SQLTableElement tableElement_Devise = new SQLTableElement(e.getTable().getField("ID_DEVISE"));

        tableElement_Devise.setEditable(false);

        final SQLTableElement tableElement_PA_Devise = new SQLTableElement(e.getTable().getField("PA_DEVISE"), BigDecimal.class);

        Path p = new Path(getSQLElement().getTable()).addForeignField("ID_DEVISE");

        tableElement_PA_Devise.setRenderer(new CurrencyWithSymbolRenderer(new FieldPath(p, "CODE")));

        if (showDevise) {

            // Devise

            list.add(tableElement_Devise);

            // Prix d'achat HT devise

            list.add(tableElement_PA_Devise);

        }

        // Mode de vente

        final SQLTableElement tableElement_ModeVente = new SQLTableElement(e.getTable().getField("ID_MODE_VENTE_ARTICLE"));

        list.add(tableElement_ModeVente);

        // Prix d'achat unitaire HT

        this.ha = new SQLTableElement(e.getTable().getField("PA_HT"), BigDecimal.class);

        this.ha.setRenderer(new CurrencyWithSymbolRenderer());

        list.add(this.ha);

        SQLTableElement qteU = new SQLTableElement(e.getTable().getField("QTE_UNITAIRE"), BigDecimal.class) {

            @Override

            public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {

                SQLRowAccessor row = vals.getForeign("ID_UNITE_VENTE");

                if (row != null && !row.isUndefined() && row.getBoolean("A_LA_PIECE")) {

                    return false;

                } else {

                    return super.isCellEditable(vals, rowIndex, columnIndex);

                }

            }

            @Override

            public TableCellRenderer getTableCellRenderer() {

                return new QteUnitRowValuesRenderer();

            }

            protected Object getDefaultNullValue() {

                return BigDecimal.ZERO;

            }

        };

        list.add(qteU);

        SQLTableElement uniteVente = new SQLTableElement(e.getTable().getField("ID_UNITE_VENTE"));

        list.add(uniteVente);

        SQLTableElement tableCmdElt = null;

        if (e.getTable().contains("ID_COMMANDE_ELEMENT")) {

            tableCmdElt = new SQLTableElement(e.getTable().getField("ID_COMMANDE_ELEMENT"));

            tableCmdElt.setRenderer(new DefaultTableCellRenderer() {

                @Override

                public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) {

                    SQLRowValues rowVals = getRowValuesTable().getRowValuesTableModel().getRowValuesAt(row);

                    JLabel tableCellRendererComponent = (JLabel) super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);

                    tableCellRendererComponent.setText("");

                    if (rowVals.getObject("ID_COMMANDE_ELEMENT") != null && !rowVals.isForeignEmpty("ID_COMMANDE_ELEMENT")) {

                        SQLRowAccessor rowCmdItem = rowVals.getForeign("ID_COMMANDE_ELEMENT");

                        int qte = rowCmdItem.getInt("QTE");

                        BigDecimal qteU = rowCmdItem.getBigDecimal("QTE_UNITAIRE");

                        BigDecimal qteR = rowCmdItem.getBigDecimal("QTE_RECUE");

                        qteU = qteU.multiply(new BigDecimal(qte));

                        if (qteR != null) {

                            tableCellRendererComponent.setText(qteU.subtract(qteR).setScale(2, RoundingMode.HALF_UP).toString());

                        } else {

                            tableCellRendererComponent.setText(qteU.setScale(2, RoundingMode.HALF_UP).toString());

                        }

                    }

                    return tableCellRendererComponent;

                }

            });

            tableCmdElt.setEditable(false);

            list.add(tableCmdElt);

        }

        if (e.getTable().getFieldsName().contains("QTE_ORIGINE")) {

            final SQLTableElement tableQteO = new SQLTableElement(e.getTable().getField("QTE_ORIGINE"));

            tableQteO.setEditable(false);

            list.add(tableQteO);

        }

        // Quantité

        final SQLTableElement qteElement = new SQLTableElement(e.getTable().getField("QTE"), Integer.class) {

            protected Object getDefaultNullValue() {

                return Integer.valueOf(0);

            }

        };

        if (e.getTable().getFieldsName().contains("QTE_ORIGINE")) {

            qteElement.setRenderer(new DeliveredQtyRowValuesRenderer(false));

        }

        list.add(qteElement);

        // TVA

        this.tableElementTVA = new SQLTableElement(e.getTable().getField("ID_TAXE"));

        list.add(this.tableElementTVA);

        // Poids piece

        SQLTableElement tableElementPoids = new SQLTableElement(e.getTable().getField("POIDS"), Float.class);

        list.add(tableElementPoids);

        // Poids total

        this.tableElementPoidsTotal = new SQLTableElement(e.getTable().getField("T_POIDS"), Float.class);

        list.add(this.tableElementPoidsTotal);

        // Service

        String val = DefaultNXProps.getInstance().getStringProperty("ArticleService");

        Boolean b = Boolean.valueOf(val);

        if (b != null && b.booleanValue()) {

            this.service = new SQLTableElement(e.getTable().getField("SERVICE"), Boolean.class);

            list.add(this.service);

        }

        if (showDevise) {

            // Prix d'achat HT devise

            this.tableElementTotalDevise = new SQLTableElement(e.getTable().getField("PA_DEVISE_T"), BigDecimal.class);

            CurrencyWithSymbolRenderer deviseTotalRenderer = new CurrencyWithSymbolRenderer(new FieldPath(p, "CODE"));

            deviseTotalRenderer.setHideZeroValue(true);

            this.tableElementTotalDevise.setRenderer(deviseTotalRenderer);

            list.add(tableElementTotalDevise);

        }

        SQLTableElement tableElementRemise = null;

        if (e.getTable().contains("POURCENT_REMISE")) {

            tableElementRemise = new SQLTableElement(e.getTable().getField("POURCENT_REMISE"));

            list.add(tableElementRemise);

        }

        if (e.getTable().getFieldsName().contains("T_ECO_CONTRIBUTION")) {

            this.tableElementEcoTotal = new SQLTableElement(e.getTable().getField("T_ECO_CONTRIBUTION"));

            list.add(this.tableElementEcoTotal);

        }

        // Total HT

        this.totalHT = new SQLTableElement(e.getTable().getField("T_PA_HT"), BigDecimal.class);

        DeviseTableCellRenderer totalRenderer = new DeviseTableCellRenderer();

        totalRenderer.setHideZeroValue(true);

        this.totalHT.setRenderer(totalRenderer);

        this.totalHT.setEditable(false);

        if (e.getTable().contains("POURCENT_REMISE") && tableElementRemise != null) {

            tableElementRemise.addModificationListener(this.totalHT);

        }

        list.add(this.totalHT);

        this.totalHA = this.totalHT;

        // Total TTC

        this.tableElementTotalTTC = new SQLTableElement(e.getTable().getField("T_PA_TTC"), BigDecimal.class);

        this.tableElementTotalTTC.setRenderer(totalRenderer);

        list.add(this.tableElementTotalTTC);

        this.defaultRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(e.getTable()));

        this.defaultRowVals.put("ID_TAXE", TaxeCache.getCache().getFirstTaxe().getID());

        this.defaultRowVals.put("CODE", "");

        this.defaultRowVals.put("NOM", "");

        this.defaultRowVals.put("QTE", 1);

        this.defaultRowVals.put("QTE_UNITAIRE", BigDecimal.ONE);

        this.defaultRowVals.put("ID_UNITE_VENTE", UniteVenteArticleSQLElement.A_LA_PIECE);

        this.defaultRowVals.put("ID_MODE_VENTE_ARTICLE", ReferenceArticleSQLElement.A_LA_PIECE);

        final RowValuesTableModel model = new RowValuesTableModel(e, list, e.getTable().getField("NOM"), false, this.defaultRowVals);

        setModel(model);

        this.table = new RowValuesTable(model, getConfigurationFile());

        ToolTipManager.sharedInstance().unregisterComponent(this.table);

        ToolTipManager.sharedInstance().unregisterComponent(this.table.getTableHeader());

        table.addMouseListener(new MouseAdapter() {

            @Override

            public void mouseReleased(MouseEvent e) {

                handlePopup(e);

            }

            @Override

            public void mousePressed(MouseEvent e) {

                handlePopup(e);

            }

            public void handlePopup(MouseEvent e) {

                final int rowindex = table.getSelectedRow();

                if (rowindex < 0)

                    return;

                if (e.isPopupTrigger() && e.getComponent() instanceof JTable) {

                    JPopupMenu popup = new JPopupMenu();

                    if (prefs.getBoolean(GestionArticleGlobalPreferencePanel.CAN_EXPAND_NOMENCLATURE_HA, true)) {

                        popup.add(new AbstractAction(TranslationManager.getInstance().getTranslationForItem("product.bom.expand")) {

                            @Override

                            public void actionPerformed(ActionEvent arg0) {

                                expandNomenclature(rowindex, m, EXPAND_TYPE.EXPAND);

                            }

                        });

                        popup.add(new AbstractAction(TranslationManager.getInstance().getTranslationForItem("product.bom.expose")) {

                            @Override

                            public void actionPerformed(ActionEvent arg0) {

                                expandNomenclature(rowindex, m, EXPAND_TYPE.VIEW_ONLY);

                            }

                        });

                        popup.add(new AbstractAction(TranslationManager.getInstance().getTranslationForItem("product.bom.flat")) {

                            @Override

                            public void actionPerformed(ActionEvent arg0) {

                                expandNomenclature(rowindex, m, EXPAND_TYPE.FLAT);

                            }

                        });

                    }

                    for (AbstractAction action : getAdditionnalMouseAction(rowindex)) {

                        popup.add(action);

                    }

                    popup.show(e.getComponent(), e.getX(), e.getY());

                }

            }

        });

        // Autocompletion

        if (dmdElt != null) {

            AutoCompletionManager dmd = new AutoCompletionManager(dmdElt, ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getField("DEMANDE_ACHAT_ELEMENT.ID"), this.table,

                    this.table.getRowValuesTableModel(), ITextWithCompletion.MODE_CONTAINS, true, true, new ValidStateChecker());

            dmd.fill("ID_FAMILLE_ARTICLE", "ID_FAMILLE_ARTICLE");

        }

        List<String> completionFields = new ArrayList<String>();

        if (e.getTable().getFieldsName().contains("INCOTERM")) {

            completionFields.add("INCOTERM");

        }

        if (e.getTable().getFieldsName().contains("ID_ECO_CONTRIBUTION")) {

            completionFields.add("ID_ECO_CONTRIBUTION");

        }

        completionFields.add("ID_UNITE_VENTE");

        completionFields.add("QTE_UNITAIRE");

        completionFields.add("PA_HT");

        completionFields.add("PV_HT");

        completionFields.add("POIDS");

        completionFields.add("ID_TAXE");

        completionFields.add("PRIX_METRIQUE_HA_1");

        completionFields.add("PRIX_METRIQUE_HA_2");

        completionFields.add("PRIX_METRIQUE_HA_3");

        completionFields.add("VALEUR_METRIQUE_1");

        completionFields.add("VALEUR_METRIQUE_2");

        completionFields.add("VALEUR_METRIQUE_3");

        completionFields.add("ID_MODE_VENTE_ARTICLE");

        completionFields.add("PRIX_METRIQUE_VT_1");

        completionFields.add("PRIX_METRIQUE_VT_2");

        completionFields.add("PRIX_METRIQUE_VT_3");

        completionFields.add("SERVICE");

        completionFields.add("ID_DEVISE");

        completionFields.add("PA_DEVISE");

        if (e.getTable().getFieldsName().contains("COLORIS")) {

            completionFields.add("COLORIS");

        }

        if (e.getTable().getFieldsName().contains("DESCRIPTIF")) {

            completionFields.add("DESCRIPTIF");

        }

        if (e.getTable().getFieldsName().contains("ID_FAMILLE_ARTICLE")) {

            completionFields.add("ID_FAMILLE_ARTICLE");

        }

        this.m = new AutoCompletionManager(tableElementCode, ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getField("ARTICLE.CODE"), this.table,

                this.table.getRowValuesTableModel()) {

            @Override

            protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {

                Object res = tarifCompletion(row, field);

                if (res == null) {

                    return super.getValueFrom(row, field, rowDest);

                } else {

                    return res;

                }

            }

        };

        m.fill("NOM", "NOM");

        m.fill("ID", "ID_ARTICLE");

        for (String string : completionFields) {

            m.fill(string, string);

        }

        final SQLTable sqlTableArticle = ((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("ARTICLE");

        final Where w = new Where(sqlTableArticle.getField("OBSOLETE"), "=", Boolean.FALSE);

        m.setWhere(w);

        this.m2 = new AutoCompletionManager(tableElementNom, ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getField("ARTICLE.NOM"), this.table,

                this.table.getRowValuesTableModel()) {

            @Override

            protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {

                Object res = tarifCompletion(row, field);

                if (res == null) {

                    return super.getValueFrom(row, field, rowDest);

                } else {

                    return res;

                }

            }

        };

        m2.fill("CODE", "CODE");

        m2.fill("ID", "ID_ARTICLE");

        for (String string : completionFields) {

            m2.fill(string, string);

        }

        m2.setWhere(w);

        this.m3 = new AutoCompletionManager(tableElementArticle, ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getField("ARTICLE.NOM"), this.table,

                this.table.getRowValuesTableModel(), ITextWithCompletion.MODE_CONTAINS, true, true, new ValidStateChecker()) {

            @Override

            protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {

                Object res = tarifCompletion(row, field);

                if (res == null) {

                    return super.getValueFrom(row, field, rowDest);

                } else {

                    return res;

                }

            }

        };

        m3.fill("CODE", "CODE");

        m3.fill("NOM", "NOM");

        for (String string : completionFields) {

            m3.fill(string, string);

        }

        m3.setWhere(w);

        if (e.getTable().contains("ID_CODE_FOURNISSEUR") && supplierCode) {

            this.m4 = new AutoCompletionManager(tableElementCodeFournisseur, ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getField("ARTICLE.NOM"), this.table,

                    this.table.getRowValuesTableModel(), ITextWithCompletion.MODE_CONTAINS, true, true, new ValidStateChecker()) {

                @Override

                protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {

                    Object res = tarifCompletion(row, field);

                    if (res == null) {

                        return super.getValueFrom(row, field, rowDest);

                    } else {

                        return res;

                    }

                }

            };

            m4.fill("CODE", "CODE");

            m4.fill("NOM", "NOM");

            for (String string : completionFields) {

                m4.fill(string, string);

            }

        }

        tableElementCode.addModificationListener(tableElementArticle);

        tableElementArticle.setModifier(new CellDynamicModifier() {

            @Override

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                try {

                    SQLRowAccessor foreign = row.getForeign("ID_ARTICLE");

                    if (foreign != null && !foreign.isUndefined() && foreign.getObject("CODE") != null && foreign.getString("CODE").equals(row.getString("CODE"))) {

                        return foreign.getID();

                    } else {

                        return tableArticle.getUndefinedID();

                    }

                } catch (Exception e) {

                    return tableArticle.getUndefinedID();

                }

            }

        });

        // ECO Contribution

        if (this.tableElementEco != null && this.tableElementEcoTotal != null && this.tableElementEcoID != null) {

            qteElement.addModificationListener(this.tableElementEcoTotal);

            this.tableElementEco.addModificationListener(this.tableElementEcoTotal);

            this.tableElementEcoTotal.setModifier(new CellDynamicModifier() {

                public Object computeValueFrom(final SQLRowValues row, SQLTableElement source) {

                    int qte = Integer.parseInt(row.getObject("QTE").toString());

                    BigDecimal f = (row.getObject("ECO_CONTRIBUTION") == null) ? BigDecimal.ZERO : (BigDecimal) row.getObject("ECO_CONTRIBUTION");

                    return f.multiply(new BigDecimal(qte));

                }

            });

            this.tableElementEcoID.addModificationListener(this.tableElementEco);

            this.tableElementEco.setModifier(new CellDynamicModifier() {

                public Object computeValueFrom(final SQLRowValues row, SQLTableElement source) {

                    if (source.equals(tableElementEcoID)) {

                        return row.getForeign("ID_ECO_CONTRIBUTION").getBigDecimal("TAUX");

                    } else {

                        return row.getObject("ECO_CONTRIBUTION");

                    }

                }

            });

        }

        // Calcul automatique du total HT

        qteElement.addModificationListener(this.totalHT);

        qteU.addModificationListener(this.totalHT);

        this.ha.addModificationListener(this.totalHT);

        this.totalHT.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(final SQLRowValues row, SQLTableElement source) {

                int qte = Integer.parseInt(row.getObject("QTE").toString());

                BigDecimal f = (row.getObject("PA_HT") == null) ? BigDecimal.ZERO : (BigDecimal) row.getObject("PA_HT");

                BigDecimal b = (row.getObject("QTE_UNITAIRE") == null) ? BigDecimal.ONE : (BigDecimal) row.getObject("QTE_UNITAIRE");

                BigDecimal r = b.multiply(f.multiply(BigDecimal.valueOf(qte)), DecimalUtils.HIGH_PRECISION).setScale(totalHT.getDecimalDigits(), BigDecimal.ROUND_HALF_UP);

                if (row.getTable().contains("POURCENT_REMISE")) {

                    final Object o2 = row.getObject("POURCENT_REMISE");

                    BigDecimal lremise = (o2 == null) ? BigDecimal.ZERO : ((BigDecimal) o2);

                    if (lremise.compareTo(BigDecimal.ZERO) >= 0 && lremise.compareTo(BigDecimal.valueOf(100)) < 0) {

                        r = r.multiply(new BigDecimal(100).subtract(lremise).movePointLeft(2)).setScale(totalHT.getDecimalDigits(), BigDecimal.ROUND_HALF_UP);

                    }

                }

                return r;

            }

        });

        if (showDevise) {

            if (tableElement_PA_Devise != null) {

                tableElement_PA_Devise.addModificationListener(tableElement_PrixMetrique1_AchatHT);

            }

            if (tableElement_PA_Devise != null) {

                tableElement_PrixMetrique1_AchatHT.addModificationListener(tableElement_PA_Devise);

                tableElement_PA_Devise.setModifier(new CellDynamicModifier() {

                    public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                        if (source != null && source.getField().getName().equals("PA_DEVISE")) {

                            return row.getObject("PA_DEVISE");

                        } else {

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

                                String devCode = row.getForeign("ID_DEVISE").getString("CODE");

                                BigDecimal bigDecimal = (BigDecimal) row.getObject("PRIX_METRIQUE_HA_1");

                                CurrencyConverter c = new CurrencyConverter();

                                BigDecimal result = convert(bigDecimal, devCode, true);

                                if (result == null) {

                                    JOptionPane.showMessageDialog(AbstractAchatArticleItemTable.this, "Unable to convert " + bigDecimal + " from " + c.getCompanyCurrencyCode() + " to " + devCode);

                                    return BigDecimal.ZERO;

                                }

                                return result;

                            } else if (source != null && source.getField().getName().equalsIgnoreCase("PRIX_METRIQUE_HA_1")) {

                                return row.getObject("PRIX_METRIQUE_HA_1");

                            }

                            return row.getObject("PA_DEVISE");

                        }

                    }

                });

            }

            qteElement.addModificationListener(this.tableElementTotalDevise);

            qteU.addModificationListener(this.tableElementTotalDevise);

            tableElement_PA_Devise.addModificationListener(this.tableElementTotalDevise);

            if (e.getTable().contains("POURCENT_REMISE") && tableElementRemise != null) {

                tableElementRemise.addModificationListener(this.tableElementTotalDevise);

            }

            this.tableElementTotalDevise.setModifier(new CellDynamicModifier() {

                public Object computeValueFrom(final SQLRowValues row, SQLTableElement source) {

                    int qte = Integer.parseInt(row.getObject("QTE").toString());

                    BigDecimal f = (BigDecimal) row.getObject("PA_DEVISE");

                    BigDecimal b = (row.getObject("QTE_UNITAIRE") == null) ? BigDecimal.ONE : (BigDecimal) row.getObject("QTE_UNITAIRE");

                    BigDecimal r = b.multiply(f.multiply(BigDecimal.valueOf(qte)), DecimalUtils.HIGH_PRECISION).setScale(tableElementTotalDevise.getDecimalDigits(), BigDecimal.ROUND_HALF_UP);

                    if (row.getTable().contains("POURCENT_REMISE")) {

                        final Object o2 = row.getObject("POURCENT_REMISE");

                        BigDecimal lremise = (o2 == null) ? BigDecimal.ZERO : ((BigDecimal) o2);

                        if (lremise.compareTo(BigDecimal.ZERO) >= 0 && lremise.compareTo(BigDecimal.valueOf(100)) < 0) {

                            r = r.multiply(new BigDecimal(100).subtract(lremise).movePointLeft(2)).setScale(tableElementTotalDevise.getDecimalDigits(), BigDecimal.ROUND_HALF_UP);

                        }

                    }

                    return r;

                }

            });

        }

        // Calcul automatique du total TTC

        qteElement.addModificationListener(this.tableElementTotalTTC);

        qteU.addModificationListener(this.tableElementTotalTTC);

        this.ha.addModificationListener(this.tableElementTotalTTC);

        this.tableElementTVA.addModificationListener(this.tableElementTotalTTC);

        this.tableElementTotalTTC.setModifier(new CellDynamicModifier() {

            @Override

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                int qte = Integer.parseInt(row.getObject("QTE").toString());

                BigDecimal f = (BigDecimal) row.getObject("PA_HT");

                int idTaux = Integer.parseInt(row.getObject("ID_TAXE").toString());

                if (idTaux < 0) {

                    System.out.println(row);

                }

                Float resultTaux = TaxeCache.getCache().getTauxFromId(idTaux);

                editorPAHT.setTaxe(resultTaux);

                BigDecimal b = (row.getObject("QTE_UNITAIRE") == null) ? BigDecimal.ONE : (BigDecimal) row.getObject("QTE_UNITAIRE");

                BigDecimal r = b.multiply(f.multiply(BigDecimal.valueOf(qte), DecimalUtils.HIGH_PRECISION), DecimalUtils.HIGH_PRECISION).setScale(tableElementTotalTTC.getDecimalDigits(),

                        BigDecimal.ROUND_HALF_UP);

                float taux = (resultTaux == null) ? 0.0F : resultTaux.floatValue();

                BigDecimal total = r.multiply(BigDecimal.ONE.add(new BigDecimal(taux / 100f))).setScale(tableElementTotalTTC.getDecimalDigits(), RoundingMode.HALF_UP);

                return total;

            }

        });

        this.table.readState();

        // Mode Gestion article avancé

        String valModeAvanceVt = DefaultNXProps.getInstance().getStringProperty("ArticleModeVenteAvance");

        Boolean bModeAvance = Boolean.valueOf(valModeAvanceVt);

        boolean view = !(bModeAvance != null && !bModeAvance.booleanValue());

        setColumnVisible(model.getColumnForField("VALEUR_METRIQUE_1"), view);

        setColumnVisible(model.getColumnForField("VALEUR_METRIQUE_2"), view);

        setColumnVisible(model.getColumnForField("VALEUR_METRIQUE_3"), view);

        setColumnVisible(model.getColumnForField("PRIX_METRIQUE_VT_1"), view);

        setColumnVisible(model.getColumnForField("ID_MODE_VENTE_ARTICLE"), view);

        setColumnVisible(model.getColumnForField("PA_HT"), view);

        if (e.getTable().contains("ID_COMMANDE_ELEMENT")) {

            setColumnVisible(model.getColumnForField("ID_COMMANDE_ELEMENT"), false);

        }

        // Gestion des unités de vente

        final boolean gestionUV = prefs.getBoolean(GestionArticleGlobalPreferencePanel.UNITE_VENTE, true);

        setColumnVisible(model.getColumnForField("QTE_UNITAIRE"), gestionUV);

        setColumnVisible(model.getColumnForField("ID_UNITE_VENTE"), gestionUV);

        setColumnVisible(model.getColumnForField("ID_STYLE"), DefaultNXProps.getInstance().getBooleanValue("ArticleShowStyle", true));

        if (this.tableElementEco != null && this.tableElementEcoTotal != null && this.tableElementEcoID != null) {

            setColumnVisible(model.getColumnForField("ID_ECO_CONTRIBUTION"), showEco);

            setColumnVisible(model.getColumnForField("ECO_CONTRIBUTION"), showEco);

            setColumnVisible(model.getColumnForField("T_ECO_CONTRIBUTION"), showEco);

        }

        setColumnVisible(model.getColumnForField("ID_ARTICLE"), selectArticle);

        setColumnVisible(model.getColumnForField("CODE"), !selectArticle || (selectArticle && createAuto));

        setColumnVisible(model.getColumnForField("NOM"), !selectArticle || (selectArticle && createAuto));

        setColumnVisible(model.getColumnForField("ID_DEPOT_STOCK"), prefs.getBoolean(GestionArticleGlobalPreferencePanel.STOCK_MULTI_DEPOT, false));

        // Calcul automatique du poids unitaire

        tableElement_ValeurMetrique1.addModificationListener(tableElementPoids);

        tableElement_ValeurMetrique2.addModificationListener(tableElementPoids);

        tableElement_ValeurMetrique3.addModificationListener(tableElementPoids);

        tableElementPoids.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                return new Float(ReferenceArticleSQLElement.getPoidsFromDetails(row));

            }

        });

        // Calcul automatique du poids total

        tableElementPoids.addModificationListener(this.tableElementPoidsTotal);

        qteElement.addModificationListener(this.tableElementPoidsTotal);

        qteU.addModificationListener(this.tableElementPoidsTotal);

        this.tableElementPoidsTotal.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                Number f = (row.getObject("POIDS") == null) ? 0 : (Number) row.getObject("POIDS");

                int qte = Integer.parseInt(row.getObject("QTE").toString());

                BigDecimal b = (row.getObject("QTE_UNITAIRE") == null) ? BigDecimal.ONE : (BigDecimal) row.getObject("QTE_UNITAIRE");

                // FIXME convertir en float autrement pour éviter une valeur non transposable

                // avec floatValue ou passer POIDS en bigDecimal

                return b.multiply(new BigDecimal(f.floatValue() * qte)).floatValue();

            }

        });

        tableElement_PrixMetrique1_AchatHT.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                if (source != null && source.getField().getName().equals("PRIX_METRIQUE_HA_1")) {

                    return row.getObject("PRIX_METRIQUE_HA_1");

                } else {

                    if (source != null && source.getField().getName().equals("PA_DEVISE")) {

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

                            String devCode = row.getForeign("ID_DEVISE").getString("CODE");

                            BigDecimal bigDecimal = (BigDecimal) row.getObject("PA_DEVISE");

                            return convert(bigDecimal, devCode, false);

                        } else {

                            return row.getObject("PRIX_METRIQUE_HA_1");

                        }

                    }

                    return row.getObject("PRIX_METRIQUE_HA_1");

                }

            }

        });

        // Calcul automatique du prix d'achat unitaire HT

        tableElement_ValeurMetrique1.addModificationListener(this.ha);

        tableElement_ValeurMetrique2.addModificationListener(this.ha);

        tableElement_ValeurMetrique3.addModificationListener(this.ha);

        tableElement_PrixMetrique1_AchatHT.addModificationListener(this.ha);

        this.ha.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                if (row.isForeignEmpty("ID_MODE_VENTE_ARTICLE") || row.getInt("ID_MODE_VENTE_ARTICLE") == ReferenceArticleSQLElement.A_LA_PIECE) {

                    return row.getObject("PRIX_METRIQUE_HA_1");

                } else {

                    final BigDecimal prixHAFromDetails = ReferenceArticleSQLElement.getPrixHAFromDetails(row);

                    return prixHAFromDetails.setScale(ha.getDecimalDigits(), RoundingMode.HALF_UP);

                }

            }

        });

        uniteVente.addModificationListener(qteU);

        qteU.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                SQLRowAccessor rowUnite = row.getForeign("ID_UNITE_VENTE");

                if (rowUnite != null && !rowUnite.isUndefined() && rowUnite.getBoolean("A_LA_PIECE")) {

                    return BigDecimal.ONE;

                } else {

                    return row.getObject("QTE_UNITAIRE");

                }

            }

        });

        // La devise est renseignée globalement dans la commande et est reportée automatiquement sur

        // les lignes

        setColumnVisible(model.getColumnIndexForElement(tableElement_Devise), false);

        for (String string : visibilityMap.keySet()) {

            setColumnVisible(model.getColumnForField(string), visibilityMap.get(string));

        }

        // Barcode reader

        final BarcodeReader barcodeReader = ComptaPropsConfiguration.getInstanceCompta().getBarcodeReader();

        if (barcodeReader != null) {

            final BarcodeListener l = new BarcodeListener() {

                @Override

                public void keyReceived(KeyEvent ee) {

                    // TODO Auto-generated method stub

                }

                @Override

                public void barcodeRead(String code) {

                    if (((JFrame) SwingUtilities.getRoot(getRowValuesTable())).isActive()) {

                        final SQLSelect selArticle = new SQLSelect();

                        final SQLTable tableArticle = getSQLElement().getForeignElement("ID_ARTICLE").getTable();

                        selArticle.addSelectStar(tableArticle);

                        Where w = new Where(tableArticle.getField("OBSOLETE"), "=", Boolean.FALSE);

                        w = w.and(new Where(tableArticle.getField("CODE_BARRE"), "=", code));

                        selArticle.setWhere(w);

                        List<SQLRow> l2 = SQLRowListRSH.execute(selArticle);

                        if (l2.size() > 0) {

                            System.err.println("ARTICLE " + l2.get(0).getString("NOM"));

                            Tuple3<Double, String, String> art = Tuple3.create(1.0D, l2.get(0).getString("CODE"), l2.get(0).getString("NOM"));

                            List<Tuple3<Double, String, String>> l = new ArrayList<Tuple3<Double, String, String>>();

                            l.add(art);

                            insertFromDrop(l, m);

                        } else {

                            System.err.println("ARTICLE NOT FOUND !");

                        }

                    }

                }

            };

            getRowValuesTable().addHierarchyListener(new HierarchyListener() {

                public void hierarchyChanged(HierarchyEvent e) {

                    if ((e.getChangeFlags() & HierarchyEvent.DISPLAYABILITY_CHANGED) != 0)

                        if (getRowValuesTable().isDisplayable()) {

                            barcodeReader.addBarcodeListener(l);

                        } else {

                            barcodeReader.removeBarcodeListener(l);

                        }

                }

            });

        }

        // On réécrit la configuration au cas ou les preferences aurait changé

        this.table.writeState();

    }

    private static Map<String, Boolean> visibilityMap = new HashMap<String, Boolean>();

    public static Map<String, Boolean> getVisibilityMap() {

        return visibilityMap;

    }

    private String incoterm = "";

    public void setIncoterms(String incoterm) {

        if (incoterm == null) {

            incoterm = "";

        }

        this.incoterm = incoterm;

    }

    private SQLRow rowFournisseur = null;

    public void setFournisseur(SQLRow rowFournisseur) {

        this.rowFournisseur = rowFournisseur;

        if (getSQLElement().getTable().contains("ID_CODE_FOURNISSEUR") && this.supplierCode) {

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

                Where w = new Where(getSQLElement().getTable().getTable("CODE_FOURNISSEUR").getField("ID_FOURNISSEUR"), "=", rowFournisseur.getID());

                this.m4.setWhere(w);

            } else {

                this.m4.setWhere(null);

            }

        }

    }

    private BigDecimal getPrice(final SQLRowAccessor r, List<String> list) {

        BigDecimal result = r.getBigDecimal(list.get(0));

        for (int i = 1; i < list.size(); i++) {

            BigDecimal m0 = r.getBigDecimal(list.get(i));

            if (m0 != null && m0.floatValue() > 0) {

                result = result.divide(m0, 2, RoundingMode.HALF_UP);

            }

        }

        return result;

    }

    public Object tarifCompletion(SQLRow row, String field) {

        final SQLTable tTarifFournisseur = this.getSQLElement().getTable().getDBRoot().getTable("ARTICLE_TARIF_FOURNISSEUR");

        if (row != null && !row.isUndefined() && (field.equalsIgnoreCase("PRIX_METRIQUE_HA_1") || field.equalsIgnoreCase("PA_HT")) && tTarifFournisseur != null) {