Dépôt officiel du code source de l'ERP OpenConcerto

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.
 * 
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
 * language governing permissions and limitations under the License.
 * 
 * When distributing the software, include this License Header Notice in each file.
 */
 
 package org.openconcerto.erp.core.customerrelationship.customer.element;

import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.core.common.component.AdresseSQLComponent;
import org.openconcerto.erp.core.common.element.BanqueSQLElement;
import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;
import org.openconcerto.erp.core.common.ui.DeviseField;
import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseClientItemTable;
import org.openconcerto.erp.core.finance.accounting.element.ComptePCESQLElement;
import org.openconcerto.erp.core.finance.payment.component.ModeDeReglementSQLComponent;
import org.openconcerto.erp.model.ISQLCompteSelector;
import org.openconcerto.erp.preferences.DefaultNXProps;
import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;
import org.openconcerto.erp.preferences.ModeReglementDefautPrefPanel;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.ElementSQLObject;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.SQLBackgroundTableCache;
import org.openconcerto.sql.model.SQLBase;
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.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.UndefinedRowValuesCache;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.preferences.SQLPreferences;
import org.openconcerto.sql.request.SQLRowItemView;
import org.openconcerto.sql.sqlobject.ElementComboBox;
import org.openconcerto.sql.sqlobject.JUniqueTextField;
import org.openconcerto.sql.sqlobject.SQLSearchableTextCombo;
import org.openconcerto.sql.sqlobject.SQLTextCombo;
import org.openconcerto.sql.sqlobject.itemview.VWRowItemView;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.FormLayouter;
import org.openconcerto.ui.JLabelBold;
import org.openconcerto.ui.TitledSeparator;
import org.openconcerto.ui.component.ComboLockedMode;
import org.openconcerto.ui.component.ITextArea;
import org.openconcerto.ui.component.InteractionMode;

import java.awt.Component;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

import javax.swing.ButtonGroup;
import javax.swing.Icon;
import javax.swing.JCheckBox;
import javax.swing.JComponent;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTabbedPane;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.event.DocumentEvent;
import javax.swing.event.DocumentListener;

// Client without CTech link (i.e. there's one and only table in the DB)
public class ClientNormalSQLComponent extends BaseSQLComponent {

    private int idDefaultCompteClient = 1;
    private JCheckBox checkAdrFacturation;

    private final SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");
    private ElementComboBox boxPays = null;
    private final ElementComboBox boxTarif = new ElementComboBox();

    protected boolean showMdr = true;

    private ElementSQLObject componentPrincipale, componentFacturation;
    private AdresseClientItemTable adresseTable = new AdresseClientItemTable();
    private JCheckBox boxGestionAutoCompte;
    private Map<SQLField, JCheckBox> mapCheckLivraison = new HashMap<SQLField, JCheckBox>();

    private JCheckBox boxAffacturage, boxComptant;
    private DeviseField fieldMontantFactMax;
    private ISQLCompteSelector compteSel;
    private SQLRowItemView textNom;
    // ITextWithCompletion textNom;
    private final ElementComboBox comboPole = new ElementComboBox();
    private final DecimalFormat format = new DecimalFormat("000");

    private final SQLTable contactTable = Configuration.getInstance().getDirectory().getElement("CONTACT").getTable();
    private ContactItemTable table;
    private final SQLRowValues defaultContactRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(this.contactTable));
    private SQLRowItemView eltModeRegl;
    private JUniqueTextField textCode;
    private JLabel labelCpt;
    private ModeDeReglementSQLComponent modeReglComp;

    public ClientNormalSQLComponent(SQLElement elt) {
        super(elt);
    }

    public void addViews() {
        this.setLayout(new GridBagLayout());
        final GridBagConstraints c = new DefaultGridBagConstraints();

        // Raison sociale
        JLabel labelRS = new JLabel(getLabelFor("FORME_JURIDIQUE"));
        labelRS.setHorizontalAlignment(SwingConstants.RIGHT);
        SQLTextCombo textType = new SQLTextCombo();

        this.add(labelRS, c);
        c.gridx++;
        c.weightx = 0.5;
        c.fill = GridBagConstraints.BOTH;
        DefaultGridBagConstraints.lockMinimumSize(textType);
        this.add(textType, c);

        // Code
        JLabel labelCode = new JLabel(getLabelFor("CODE"));
        labelCode.setHorizontalAlignment(SwingConstants.RIGHT);
        this.textCode = new JUniqueTextField() {
            @Override
            public String getAutoRefreshNumber() {
                if (getMode() == Mode.INSERTION) {
                    return NumerotationAutoSQLElement.getNextNumero(getElement().getClass());
                } else {
                    return null;
                }
            }
        };
        c.gridx++;
        c.weightx = 0;
        c.weighty = 0;
        c.gridwidth = 1;
        c.fill = GridBagConstraints.HORIZONTAL;
        this.add(labelCode, c);
        c.gridx++;
        c.weightx = 0.5;
        c.gridwidth = 1;
        DefaultGridBagConstraints.lockMinimumSize(textCode);
        this.add(this.textCode, c);
        // Nom
        JLabel labelNom = new JLabel("Nom");
        labelNom.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridy++;
        c.gridx = 0;
        c.weightx = 0;
        this.add(labelNom, c);
        c.gridx++;
        c.gridwidth = 1;
        c.weightx = 0.5;

        final JComponent nomComp;
            nomComp = new JTextField();
        DefaultGridBagConstraints.lockMinimumSize(nomComp);
        this.add(nomComp, c);

        if (getTable().getFieldsName().contains("ID_PAYS")) {
            c.gridx++;
            c.weightx = 0;
            this.add(new JLabel(getLabelFor("ID_PAYS"), SwingConstants.RIGHT), c);
            boxPays = new ElementComboBox(true, 25);
            c.gridx++;
            c.weightx = 0.5;
            this.add(boxPays, c);
            this.addView(boxPays, "ID_PAYS");
            DefaultGridBagConstraints.lockMinimumSize(boxPays);
        }
        if (getTable().getFieldsName().contains("LOCALISATION")) {
            c.gridy++;
            c.gridx = 0;
            c.weightx = 0;
            JLabel comp2 = new JLabel(getLabelFor("LOCALISATION"));
            comp2.setHorizontalAlignment(SwingConstants.RIGHT);
            this.add(comp2, c);
            JTextField loc = new JTextField();
            c.gridx++;
            c.weightx = 1;
            // DefaultGridBagConstraints.lockMinimumSize(boxPays);
            this.add(loc, c);
            this.addView(loc, "LOCALISATION");
        }
        // Numero intracomm
        JLabel labelIntraComm = new JLabel("N° TVA");
        labelIntraComm.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridy++;
        c.gridx = 0;
        c.gridwidth = 1;
        c.weightx = 0;
        this.add(labelIntraComm, c);

        final JTextField textNumIntracomm = new JTextField(20);
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textNumIntracomm);
        this.add(textNumIntracomm, c);
        JLabel labelSIREN = new JLabel(getLabelFor("SIRET"));
        labelSIREN.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridx++;
        c.gridwidth = 1;
        c.weightx = 0;
        this.add(labelSIREN, c);

        JComponent textSiren;
            textSiren = new JTextField(20);
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textSiren);
        this.add(textSiren, c);

        // Responsable
        final JLabel responsable = new JLabel(this.getLabelFor("RESPONSABLE"));
        responsable.setHorizontalAlignment(SwingConstants.RIGHT);
        final JTextField textResp = new JTextField();
        c.gridx = 0;
        c.gridy++;
        c.weightx = 0;
        c.weighty = 0;
        c.gridwidth = 1;
        this.add(responsable, c);
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textResp);
        this.add(textResp, c);

        final JLabel labelRIB = new JLabel(getLabelFor("RIB"));
        labelRIB.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridx++;
        c.gridwidth = 1;
        c.weightx = 0;
        this.add(labelRIB, c);

        final JTextField textRib = new JTextField();
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textRib);
        this.add(textRib, c);


        // tel
        JLabel labelTel = new JLabel(this.getLabelFor("TEL"));
        labelTel.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridx = 0;
        c.gridy++;
        c.weightx = 0;
        this.add(labelTel, c);

        final JTextField textTel = new JTextField();
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textTel);
        this.add(textTel, c);
        textTel.getDocument().addDocumentListener(new DocumentListener() {

            public void changedUpdate(DocumentEvent e) {
                defaultContactRowVals.put("TEL_DIRECT", textTel.getText());
            }

            public void insertUpdate(DocumentEvent e) {
                defaultContactRowVals.put("TEL_DIRECT", textTel.getText());
            }

            public void removeUpdate(DocumentEvent e) {
                defaultContactRowVals.put("TEL_DIRECT", textTel.getText());
            }

        });

        // email
        JLabel labelMail = new JLabel("E-mail");
        labelMail.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridx++;
        c.weightx = 0;
        this.add(labelMail, c);

        final JTextField textMail = new JTextField();
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textMail);
        this.add(textMail, c);

        // Portable
        JLabel labelPortable = new JLabel("N° de portable");
        labelPortable.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridx = 0;
        c.gridy++;
        c.weightx = 0;
        this.add(labelPortable, c);

        final JTextField textPortable = new JTextField();
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textPortable);
        this.add(textPortable, c);

        // Fax
        JLabel labelFax = new JLabel("N° de fax");
        labelFax.setHorizontalAlignment(SwingConstants.RIGHT);
        c.gridx++;
        c.weightx = 0;
        this.add(labelFax, c);

        final JTextField textFax = new JTextField();
        c.gridx++;
        c.weightx = 0.5;
        DefaultGridBagConstraints.lockMinimumSize(textFax);
        this.add(textFax, c);

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

            public void changedUpdate(DocumentEvent e) {
                defaultContactRowVals.put("FAX", textFax.getText());
            }

            public void insertUpdate(DocumentEvent e) {
                defaultContactRowVals.put("FAX", textFax.getText());
            }

            public void removeUpdate(DocumentEvent e) {
                defaultContactRowVals.put("FAX", textFax.getText());
            }

        });


        // 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;

        final JTabbedPane tabs = new JTabbedPane();
        tabs.addTab("Adresses", createAdressesComponent());
        tabs.addTab("Contacts", createContactComponent());
        JPanel pReglement = createReglementComponent();
        if (showMdr) {
            tabs.addTab("Mode de règlement", pReglement);
        }

        tabs.addTab("Comptabilité", createComptabiliteComponent());

        tabs.setMinimumSize(new Dimension(tabs.getPreferredSize().width, tabs.getPreferredSize().height));

        c.gridx = 0;
        c.gridy++;
        c.weightx = 1;
        c.weighty = 0;
        c.gridwidth = GridBagConstraints.REMAINDER;
        c.anchor = GridBagConstraints.WEST;
        c.fill = GridBagConstraints.HORIZONTAL;
        this.add(tabs, c);

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


        // Mode de régelement

        if (getTable().getFieldsName().contains("ID_TARIF")) {

            // Tarif
            JLabel tarifSep = new JLabel("Tarif spécial à appliquer");
            c.gridwidth = GridBagConstraints.REMAINDER;
            c.gridy++;
            c.gridx = 0;
            this.add(tarifSep, c);

            c.gridy++;
            c.gridx = 0;
            c.gridwidth = 1;
            c.weightx = 0;
            this.add(new JLabel(getLabelFor("ID_TARIF"), SwingConstants.RIGHT), c);
            c.gridx++;
            c.weightx = 1;
            c.gridwidth = GridBagConstraints.REMAINDER;

            this.add(boxTarif, c);
            this.addView(boxTarif, "ID_TARIF");
        }
        if (getTable().getFieldsName().contains("ID_LANGUE")) {
            // Tarif
            JLabel langueSep = new JLabel("Langue à appliquer sur les documents");
            c.gridwidth = GridBagConstraints.REMAINDER;
            c.gridy++;
            c.gridx = 0;
            this.add(langueSep, c);

            c.gridy++;
            c.gridx = 0;
            c.gridwidth = 1;
            c.weightx = 0;
            this.add(new JLabel(getLabelFor("ID_LANGUE"), SwingConstants.RIGHT), c);
            c.gridx++;
            c.weightx = 1;
            c.gridwidth = GridBagConstraints.REMAINDER;
            final ElementComboBox boxLangue = new ElementComboBox();
            this.add(boxLangue, c);
            this.addView(boxLangue, "ID_LANGUE");

            boxPays.addValueListener(new PropertyChangeListener() {

                @Override
                public void propertyChange(PropertyChangeEvent evt) {
                    SQLRow row = boxPays.getSelectedRow();
                    if (row != null) {
                        boxTarif.setValue(row.getInt("ID_TARIF"));
                        boxLangue.setValue(row.getInt("ID_LANGUE"));
                    }
                }
            });
        }
        // Add on
        final JPanel addOnPanel = getAddOnPanel(this);
        if (addOnPanel != null) {
            c.gridy++;
            this.add(addOnPanel, c);
        }

        // Infos
        JLabel infosSep = new JLabel(getLabelFor("INFOS"));
        c.gridwidth = GridBagConstraints.REMAINDER;
        c.gridy++;
        c.gridx = 0;
        this.add(infosSep, c);
        ITextArea textInfos = new ITextArea();
        c.gridy++;
        c.weighty = 0.3;
        c.fill = GridBagConstraints.BOTH;
        this.add(textInfos, c);

        this.checkAdrFacturation.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                boolean b = checkAdrFacturation.isSelected();
                componentFacturation.setEditable((!b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);
                componentFacturation.setCreated(!b);
            }
        });

        this.addSQLObject(textType, "FORME_JURIDIQUE");
        this.addView(nomComp, "NOM", REQ);
        this.textNom = this.getView(nomComp);
        this.addSQLObject(this.textCode, "CODE");
        this.addSQLObject(textFax, "FAX");
        this.addSQLObject(textSiren, "SIRET");
        this.addSQLObject(textMail, "MAIL");
        this.addSQLObject(textTel, "TEL");
        this.addSQLObject(textPortable, "TEL_P");
        this.addSQLObject(textNumIntracomm, "NUMERO_TVA");
        this.addSQLObject(textResp, "RESPONSABLE");
        this.addSQLObject(textInfos, "INFOS");
        this.addSQLObject(this.compteSel, "ID_COMPTE_PCE");

    }

    private Component createAdressesComponent() {
        final JTabbedPane tabbedAdresse = new JTabbedPane() {
            public void insertTab(String title, Icon icon, Component component, String tip, int index) {
                if (component instanceof JComponent) {
                    ((JComponent) component).setOpaque(false);
                }
                super.insertTab(title, icon, component, tip, index);
            }

        };
        final GridBagConstraints c = new DefaultGridBagConstraints();
        // Adr principale
        this.addView("ID_ADRESSE", REQ + ";" + DEC + ";" + SEP);
        this.componentPrincipale = (ElementSQLObject) this.getView("ID_ADRESSE");
        this.componentPrincipale.setOpaque(false);
        tabbedAdresse.add(getLabelFor("ID_ADRESSE"), this.componentPrincipale);
        tabbedAdresse.setOpaque(false);

        // Adr facturation
        JPanel panelFacturation = new JPanel(new GridBagLayout());
        panelFacturation.setOpaque(false);
        GridBagConstraints cPanelF = new GridBagConstraints(0, 0, 1, 1, 1, 0, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(2, 1, 2, 1), 0, 0);

        this.addView("ID_ADRESSE_F", DEC + ";" + SEP);

        this.componentFacturation = (ElementSQLObject) this.getView("ID_ADRESSE_F");
        this.componentFacturation.setOpaque(false);
        ((AdresseSQLComponent) componentFacturation.getSQLChild()).setDestinataireVisible(true);

        panelFacturation.add(this.componentFacturation, cPanelF);

        this.checkAdrFacturation = new JCheckBox("Adresse de facturation identique à la principale");
        this.checkAdrFacturation.setOpaque(false);
        cPanelF.gridy++;
        panelFacturation.add(this.checkAdrFacturation, cPanelF);
        tabbedAdresse.add(getLabelFor("ID_ADRESSE_F"), panelFacturation);

        this.checkAdrFacturation.addActionListener(new ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent e) {
                boolean b = checkAdrFacturation.isSelected();

                componentFacturation.setEditable(!b ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);
                componentFacturation.setCreated(!b);
            }
        });
        checkAdrFacturation.setSelected(true);

            Set<SQLField> fieldsAdr = getTable().getForeignKeys("ADRESSE");
            List<SQLField> fieldsAdrOrder = new ArrayList<SQLField>(fieldsAdr);
            Collections.sort(fieldsAdrOrder, new Comparator<SQLField>() {
                @Override
                public int compare(SQLField o1, SQLField o2) {

                    return o1.getName().compareTo(o2.getName());
                }
            });
            int val = 1;
            for (SQLField sqlField : fieldsAdrOrder) {

                final String fieldName = sqlField.getName();
                if (fieldName.startsWith("ID_ADRESSE_L")) {
                    // Adr livraison
                    JPanel panelLivraison = new JPanel(new GridBagLayout());
                    panelLivraison.setOpaque(false);
                    GridBagConstraints cPanelL = new GridBagConstraints(0, 0, 1, 1, 1, 0, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(2, 1, 2, 1), 0, 0);

                    this.addView(fieldName, DEC + ";" + SEP);

                    final ElementSQLObject componentLivraison = (ElementSQLObject) this.getView(fieldName);
                    componentLivraison.setOpaque(false);
                    ((AdresseSQLComponent) componentLivraison.getSQLChild()).setDestinataireVisible(true);
                    panelLivraison.add(componentLivraison, cPanelL);

                    final JCheckBox checkAdrLivraison = new JCheckBox("Adresse de livraison identique à l'adresse principale");
                    checkAdrLivraison.setOpaque(false);
                    cPanelL.gridy++;
                    panelLivraison.add(checkAdrLivraison, cPanelL);
                    tabbedAdresse.add(getLabelFor(fieldName) + (val == 1 ? "" : " " + val), panelLivraison);
                    val++;

                    checkAdrLivraison.addActionListener(new ActionListener() {

                        public void actionPerformed(java.awt.event.ActionEvent e) {
                            boolean b = checkAdrLivraison.isSelected();

                            componentLivraison.setEditable((!b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);
                            componentLivraison.setCreated(!b);
                        }
                    });
                    checkAdrLivraison.setSelected(true);
                    this.mapCheckLivraison.put(sqlField, checkAdrLivraison);
                }
            }

        String labelAdrSuppl = "Adresses supplémentaires";
        tabbedAdresse.add(labelAdrSuppl, this.adresseTable);

        c.gridx = 0;
        c.gridy++;
        c.gridwidth = GridBagConstraints.REMAINDER;

        return tabbedAdresse;
    }

    private JPanel createContactComponent() {

        this.table = new ContactItemTable(this.defaultContactRowVals);
        this.table.setPreferredSize(new Dimension(this.table.getSize().width, 150));
        this.table.setOpaque(false);
        return table;
    }

    private JPanel createReglementComponent() {

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

        final JPanel p = new JPanel();
        p.setOpaque(false);
        p.setLayout(new GridBagLayout());
        final GridBagConstraints c = new DefaultGridBagConstraints();
        final ElementSQLObject comp = (ElementSQLObject) this.eltModeRegl.getComp();
        this.modeReglComp = (ModeDeReglementSQLComponent) comp.getSQLChild();

        final JLabelBold label = new JLabelBold(getLabelFor("ID_MODE_REGLEMENT"));
        c.gridwidth = GridBagConstraints.REMAINDER;
        c.weightx = 1;
        c.fill = GridBagConstraints.NONE;
        c.gridy++;
        c.gridx = 0;
        p.add(label, c);
        c.gridy++;
        c.gridx = 0;
        // FIXME: comp?
        comp.setOpaque(false);
        p.add(comp, c);
        return p;
    }

    private Component createComptabiliteComponent() {
        final JPanel p = new JPanel();
        p.setOpaque(false);
        p.setLayout(new GridBagLayout());
        final GridBagConstraints c = new DefaultGridBagConstraints();
        // Compte associé
        this.compteSel = new ISQLCompteSelector(true);
        this.boxGestionAutoCompte = new JCheckBox("Gestion Automatique des comptes");
        JLabelBold sepCompte = new JLabelBold("Compte associé");
        this.labelCpt = new JLabel(getLabelFor("ID_COMPTE_PCE"));

        if (!Boolean.valueOf(DefaultNXProps.getInstance().getProperty("HideCompteClient"))) {

            c.gridx = 0;
            c.gridy++;
            c.weightx = 1;
            c.weighty = 0;
            c.gridwidth = GridBagConstraints.REMAINDER;

            p.add(sepCompte, c);

            c.gridwidth = 1;
            c.gridy++;
            c.gridx = 0;
            c.weightx = 0;
            p.add(this.labelCpt, c);

            c.gridwidth = GridBagConstraints.REMAINDER;
            c.gridx++;
            c.weightx = 1;

            p.add(this.compteSel, c);

            this.boxGestionAutoCompte.addActionListener(new ActionListener() {
                @Override
                public void actionPerformed(ActionEvent e) {

                    setCompteVisible(!(boxGestionAutoCompte.isSelected() && getSelectedID() <= 1));
                }
            });

            c.gridwidth = 1;
            c.gridy++;
            c.gridx = 0;
            c.weightx = 0;
            p.add(new JLabel(getLabelFor("ID_COMPTE_PCE_SERVICE")), c);

            c.gridwidth = GridBagConstraints.REMAINDER;
            c.gridx++;
            c.weightx = 1;
            ISQLCompteSelector compteSelService = new ISQLCompteSelector();
            p.add(compteSelService, c);
            this.addView(compteSelService, "ID_COMPTE_PCE_SERVICE");
        }

        return p;
    }

    private void setCompteVisible(boolean b) {

        this.labelCpt.setVisible(b);
        this.compteSel.setVisible(b);
    }

    @Override
    public void update() {
        super.update();
        final int selectedID = getSelectedID();
        this.table.updateField("ID_CLIENT", selectedID);
        this.adresseTable.updateField("ID_CLIENT", selectedID);
        if (this.boxGestionAutoCompte.isSelected()) {

            SQLRow row = getTable().getRow(selectedID);
            if (row.getInt("ID_COMPTE_PCE") <= 1) {
                createCompteClientAuto(selectedID);
            } else {
                SQLRow rowCpt = row.getForeignRow("ID_COMPTE_PCE");
                String num = rowCpt.getString("NUMERO");
                String initialClient = "";
                final String text = getNameValue();
                if (text != null && text.trim().length() > 1) {
                    initialClient += text.trim().toUpperCase().charAt(0);
                }

                String compte = "411" + initialClient;
                if (!num.startsWith(compte)) {
                    int answer = JOptionPane.showConfirmDialog(null, "Voulez vous changer le compte associé au client, le nom a changé?", "Modification compte client", JOptionPane.YES_NO_OPTION);

                    if (answer == JOptionPane.YES_OPTION) {
                        createCompteClientAuto(selectedID);
                    }
                }
            }

        }
    }

    private String getNameValue() {
        return (String) ((VWRowItemView<?>) this.textNom).getWrapper().getValue();
    }

    @Override
    public void select(SQLRowAccessor r) {

        super.select(r);

        for (SQLField f : this.mapCheckLivraison.keySet()) {
            this.mapCheckLivraison.get(f).setSelected(r == null || !r.getFields().contains(f.getName()) || r.isForeignEmpty(f.getName()));
        }
        this.checkAdrFacturation.setSelected(r == null || !r.getFields().contains("ID_ADRESSE_F") || r.isForeignEmpty("ID_ADRESSE_F"));

        if (r != null) {
            this.table.insertFrom("ID_CLIENT", r.asRowValues());
            this.adresseTable.insertFrom("ID_CLIENT", r.getID());
            this.defaultContactRowVals.put("TEL_DIRECT", r.getString("TEL"));
            this.defaultContactRowVals.put("FAX", r.getString("FAX"));
        }
    }

    private void createCompteClientFromCodeAuto(int idClient) {
        final SQLRow rowClient = getTable().getRow(idClient);
        if (rowClient.isForeignEmpty("ID_COMPTE_PCE")) {
            createCompteClientAuto(idClient);
        }
    }

    private void createCompteClientAuto(int idClient) {
        SQLRowValues rowVals = getTable().getRow(idClient).createEmptyUpdateRow();
        String initialClient = "";
        final String text = getNameValue();
        if (text != null && text.trim().length() > 1) {
            initialClient += text.trim().toUpperCase().charAt(0);
        }

        String compte = "411" + initialClient;

        SQLTable table = Configuration.getInstance().getDirectory().getElement("COMPTE_PCE").getTable();
        SQLSelect selCompte = new SQLSelect();
        selCompte.addSelectFunctionStar("COUNT");
        selCompte.setArchivedPolicy(SQLSelect.BOTH);
        selCompte.setWhere(new Where(table.getField("NUMERO"), "LIKE", compte + "%"));
        System.err.println(selCompte.asString());
        Object o = Configuration.getInstance().getBase().getDataSource().executeScalar(selCompte.asString());

        int nb = 0;
        if (o != null) {
            Long i = (Long) o;
            nb = i.intValue();
        }

        int idCpt = ComptePCESQLElement.getId(compte + this.format.format(nb), text);
        rowVals.put("ID_COMPTE_PCE", idCpt);
        try {
            rowVals.update();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Override
    public int insert(SQLRow order) {

        // incrémentation du numéro auto
        if (NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), new Date()).equalsIgnoreCase(this.textCode.getText().trim())) {
            SQLRowValues rowVals = new SQLRowValues(this.tableNum);

            final SQLRow rowNumAuto = this.tableNum.getRow(2);
            if (rowNumAuto.getObject("CLIENT_START") != null) {
                int val = rowNumAuto.getInt("CLIENT_START");
                val++;
                rowVals.put("CLIENT_START", new Integer(val));

                try {
                    rowVals.update(2);
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }

        int id = super.insert(order);

        this.table.updateField("ID_CLIENT", id);
        this.adresseTable.updateField("ID_CLIENT", id);
        if (this.boxGestionAutoCompte.isSelected()) {
            createCompteClientAuto(id);
        }
        SQLPreferences prefs = new SQLPreferences(getTable().getDBRoot());
        if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.COMPTE_CLIENT_AUTO, Boolean.FALSE)) {
            createCompteClientFromCodeAuto(id);
        }
        return id;
    }

    @Override
    protected SQLRowValues createDefaults() {
        SQLRowValues vals = new SQLRowValues(this.getTable());
        SQLRow r;

        vals.put("MARCHE_PUBLIC", Boolean.TRUE);
        vals.put("CODE", NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), new Date()));

        // Mode de règlement par defaut
        try {
            r = ModeReglementDefautPrefPanel.getDefaultRow(true);
            SQLElement eltModeReglement = Configuration.getInstance().getDirectory().getElement("MODE_REGLEMENT");
            if (r.getID() > 1) {
                SQLRowValues rowVals = eltModeReglement.createCopy(r, null);
                System.err.println(rowVals.getInt("ID_TYPE_REGLEMENT"));
                vals.put("ID_MODE_REGLEMENT", rowVals);
            }
        } catch (SQLException e) {
            System.err.println("Impossible de sélectionner le mode de règlement par défaut du client.");
            e.printStackTrace();
        }

        // Select Compte client par defaut
        final SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();
        final SQLTable tablePrefCompte = base.getTable("PREFS_COMPTE");
        final SQLRow rowPrefsCompte = SQLBackgroundTableCache.getInstance().getCacheForTable(tablePrefCompte).getRowFromId(2);

        this.idDefaultCompteClient = rowPrefsCompte.getInt("ID_COMPTE_PCE_CLIENT");
        if (this.idDefaultCompteClient <= 1) {
            try {
                this.idDefaultCompteClient = ComptePCESQLElement.getIdComptePceDefault("Clients");
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        vals.put("ID_COMPTE_PCE", this.idDefaultCompteClient);

        return vals;
    }

    public ContactItemTable getContactTable() {
        return this.table;
    }

    protected JPanel getAddOnPanel(BaseSQLComponent c) {
        return null;
    }
}