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.

 */

 /*

 * Créé le 20 janv. 2012

 */

package org.openconcerto.erp.core.supplychain.supplier.component;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

import org.openconcerto.erp.core.customerrelationship.customer.element.ContactItemTable;

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

import org.openconcerto.erp.model.ISQLCompteSelector;

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.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.UndefinedRowValuesCache;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.SQLTextCombo;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FormLayouter;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.ui.component.ITextArea;

import org.openconcerto.ui.component.InteractionMode;

import java.awt.Dimension;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.event.ActionListener;

import java.sql.SQLException;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTabbedPane;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

public class FournisseurSQLComponent extends BaseSQLComponent {

    public FournisseurSQLComponent(SQLElement elt) {

        super(elt);

    }

    JCheckBox checkEnlevement;

    ElementSQLObject comp2;

    TitledSeparator sep2;

    private ContactItemTable table;

    private SQLTable contactTable = Configuration.getInstance().getDirectory().getElement("CONTACT_FOURNISSEUR").getTable();

    private SQLRowValues defaultContactRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(this.contactTable));

    public void addViews() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        // Code

        JLabel labelCode = new JLabel("Code", SwingConstants.RIGHT);

        JTextField textCode = new JTextField();

        c.gridx = 0;

        c.gridy++;

        c.weightx = 0;

        c.weighty = 0;

        this.add(labelCode, c);

        c.gridx++;

        c.weightx = 0.5;

        this.add(textCode, c);

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        // Raison sociale

        JLabel labelRS = new JLabel("Forme juridique", SwingConstants.RIGHT);

        SQLTextCombo textType = new SQLTextCombo();

        JTextField textNom = new JTextField();

        this.add(labelRS, c);

        c.gridx++;

        c.weightx = 0.5;

        this.add(textType, c);

        // Tel

        JLabel labelTel = new JLabel(getLabelFor("TEL"), SwingConstants.RIGHT);

        JTextField textTel = new JTextField(15);

        c.gridx++;

        c.weightx = 0;

        c.weighty = 0;

        this.add(labelTel, c);

        c.gridx++;

        c.weightx = 0.5;

        this.add(textTel, c);

        // Nom

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        String fieldNom = "NOM";

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

            fieldNom = "NOM_SOCIETE";

        }

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

        c.gridx++;

        c.weightx = 0.5;

        this.add(textNom, c);

        this.addRequiredSQLObject(textNom, fieldNom);

        // Fax

        c.gridx++;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 0.5;

        JTextField textFax = new JTextField();

        this.add(textFax, c);

        // Mail

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        c.gridwidth = 1;

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

        c.gridx++;

        c.weightx = 0.5;

        JTextField textMail = new JTextField();

        this.add(textMail, c);

        this.addView(textMail, "MAIL");

        // Tel P

        c.gridx++;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 0.5;

        JTextField textTelP = new JTextField();

        this.add(textTelP, c);

        this.addView(textTelP, "TEL_P");

        // Langue

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 0.5;

        ElementComboBox langue = new ElementComboBox(true, 35);

        this.add(langue, c);

        this.addView(langue, "ID_LANGUE");

        // Resp

        c.gridx++;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 0.5;

        JTextField textResp = new JTextField();

        this.add(textResp, c);

        this.addView(textResp, "RESPONSABLE");

        // Siret

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 0.5;

        JTextField textSiret = new JTextField();

        ;

        this.add(textSiret, c);

        this.addView(textSiret, "SIRET");

        // tva

        c.gridx++;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 0.5;

        JTextField textNumeroTVA = new JTextField();

        this.add(textNumeroTVA, c);

        this.addView(textNumeroTVA, "NUMERO_TVA");

        c.gridx = 1;

        c.gridy++;

        JCheckBox boxUE = new JCheckBox(getLabelFor("UE"));

        this.add(boxUE, c);

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

            c.gridx++;

            c.weightx = 0;

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

            c.gridx++;

            c.weightx = 0.5;

            ElementComboBox devise = new ElementComboBox(true, 35);

            this.add(devise, c);

            this.addView(devise, "ID_DEVISE");

        }

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

            c.gridy++;

            c.gridx = 0;

            c.weightx = 0;

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

            c.gridx++;

            c.weightx = 1;

            JTextField fieldRegistre = new JTextField(20);

            this.add(fieldRegistre, c);

            this.addView(fieldRegistre, "ALG_REGISTRE");

            c.gridx++;

            c.weightx = 0;

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

            c.gridx++;

            c.weightx = 1;

            JTextField fieldMatricule = new JTextField(20);

            this.add(fieldMatricule, c);

            this.addView(fieldMatricule, "ALG_MATRICULE");

            c.gridy++;

            c.gridx = 0;

            c.weightx = 0;

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

            c.gridx++;

            c.weightx = 1;

            JTextField fieldArticle = new JTextField(20);

            this.add(fieldArticle, c);

            this.addView(fieldArticle, "ALG_ARTICLE");

        }

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

        // Tabbed

        JTabbedPane tabbedPane = new JTabbedPane();

        JPanel panelAdresse = new JPanel(new GridBagLayout());

        panelAdresse.setOpaque(false);

        GridBagConstraints cAdr = new DefaultGridBagConstraints();

        // Adresse

        TitledSeparator sep = new TitledSeparator("Adresse");

        sep.setOpaque(false);

        panelAdresse.add(sep, cAdr);

        this.sep2 = new TitledSeparator("Adresse d'enlévement");

        this.sep2.setOpaque(false);

        cAdr.gridx = GridBagConstraints.RELATIVE;

        panelAdresse.add(this.sep2, cAdr);

        //

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

        cAdr.gridy++;

        cAdr.fill = GridBagConstraints.HORIZONTAL;

        cAdr.weightx = 1;

        final ElementSQLObject view = (ElementSQLObject) this.getView("ID_ADRESSE");

        view.setOpaque(false);

        panelAdresse.add(view, cAdr);

        // Selection de 2eme adresse

        this.addView("ID_ADRESSE_E", DEC);

        cAdr.gridx = GridBagConstraints.RELATIVE;

        this.comp2 = (ElementSQLObject) this.getView("ID_ADRESSE_E");

        this.comp2.setCreated(true);

        this.comp2.setOpaque(false);

        panelAdresse.add(this.comp2, cAdr);

        this.checkEnlevement = new JCheckBox("Adresse d'enlèvement identique");

        this.checkEnlevement.setOpaque(false);

        cAdr.gridx = 0;

        cAdr.gridy++;

        cAdr.gridwidth = GridBagConstraints.REMAINDER;

        panelAdresse.add(this.checkEnlevement, cAdr);

        tabbedPane.add("Adresses", panelAdresse);

        this.checkEnlevement.setSelected(true);

        this.sep2.setVisible(false);

        this.checkEnlevement.addActionListener(new ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent e) {

                System.out.println("Click");

                if (checkEnlevement.isSelected()) {

                    System.out.println("Mode 1");

                    comp2.setEditable(InteractionMode.DISABLED);

                    comp2.setCreated(false);

                    sep2.setVisible(false);

                } else {

                    System.out.println("Mode 2");

                    comp2.setEditable(InteractionMode.READ_WRITE);

                    comp2.setCreated(true);

                    sep2.setVisible(true);

                }

            };

        });

        // Contact

        JPanel panelContact = new JPanel(new GridBagLayout());

        panelContact.setOpaque(false);

        this.table = new ContactItemTable(this.defaultContactRowVals);

        this.table.setOpaque(false);

        this.table.setPreferredSize(new Dimension(this.table.getSize().width, 150));

        GridBagConstraints cContact = new DefaultGridBagConstraints();

        cContact.fill = GridBagConstraints.BOTH;

        cContact.weightx = 1;

        cContact.weighty = 1;

        panelContact.add(this.table, cContact);

        tabbedPane.add("Contacts", panelContact);

        c.gridx = 0;

        c.gridy++;

        c.anchor = GridBagConstraints.NORTHWEST;

        c.fill = GridBagConstraints.BOTH;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(tabbedPane, c);

        // Mode de réglement

        TitledSeparator reglSep = new TitledSeparator(getLabelFor("ID_MODE_REGLEMENT"));

        c.gridwidth = 2;

        c.gridy++;

        c.gridx = 0;

        this.add(reglSep, c);

        c.gridy++;

        c.gridx = 0;

        c.fill = GridBagConstraints.NONE;

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

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

        this.add(eltModeRegl, c);

        //

        {

            c.gridx = 2;

            c.gridy--;

            c.gridwidth = 2;

            c.fill = GridBagConstraints.BOTH;

            TitledSeparator ribSep = new TitledSeparator("Coordonnées bancaires");

            this.add(ribSep, c);

            final JPanel pCoordonneesBancaires = new JPanel();

            pCoordonneesBancaires.setLayout(new GridBagLayout());

            GridBagConstraints c2 = new DefaultGridBagConstraints();

            c2.gridy++;

            // IBAN

            JLabel labelIBAN = new JLabel("IBAN", SwingConstants.RIGHT);

            JTextField textIBAN = new JTextField(40);

            c2.weightx = 0;

            pCoordonneesBancaires.add(labelIBAN, c2);

            c2.gridx++;

            c2.weightx = 1;

            pCoordonneesBancaires.add(textIBAN, c2);

            // BIC

            JLabel labelBIC = new JLabel("BIC", SwingConstants.RIGHT);

            JTextField textBIC = new JTextField(20);

            c2.gridx = 0;

            c2.gridy++;

            c2.weightx = 0;

            pCoordonneesBancaires.add(labelBIC, c2);

            c2.gridx++;

            c2.weightx = 1;

            c2.fill = GridBagConstraints.NONE;

            pCoordonneesBancaires.add(textBIC, c2);

            c.gridy++;

            c.fill = GridBagConstraints.HORIZONTAL;

            this.add(pCoordonneesBancaires, c);

            this.addView(textIBAN, "IBAN");

            this.addView(textBIC, "BIC");

        }

        // Compte associé

        c.gridx = 0;

        c.gridy++;

        c.weightx = 1;

        c.weighty = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridwidth = GridBagConstraints.REMAINDER;

        TitledSeparator sepCompteCharge = new TitledSeparator("Comptes associés");

        this.add(sepCompteCharge, c);

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

        final GridBagConstraints c2 = new DefaultGridBagConstraints();

        panel.add(new JLabel("Compte fournisseur associé", SwingConstants.RIGHT), c2);

        ISQLCompteSelector compteSel = new ISQLCompteSelector(true);

        c2.gridx++;

        c2.weightx = 1;

        panel.add(compteSel, c2);

        c2.gridx = 0;

        c2.gridy++;

        c2.weightx = 0;

        panel.add(new JLabel(getLabelFor("ID_COMPTE_PCE_CHARGE"), SwingConstants.RIGHT), c2);

        ISQLCompteSelector compteSelCharge = new ISQLCompteSelector(true);

        c2.gridx++;

        c2.weightx = 1;

        panel.add(compteSelCharge, c2);

        addView(compteSelCharge, "ID_COMPTE_PCE_CHARGE");

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridy++;

        c.gridx = 0;

        c.weightx = 1;

        c.anchor = GridBagConstraints.NORTHWEST;

        this.add(panel, c);

        c.gridwidth = 1;

        c.gridy++;

        c.gridx = 0;

        c.weightx = 1;

        c.anchor = GridBagConstraints.NORTHWEST;

        // INfos

        c.gridx = 0;

        c.gridy++;

        c.gridheight = 1;

        c.weightx = 1;

        c.anchor = GridBagConstraints.WEST;

        c.gridwidth = GridBagConstraints.REMAINDER;

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

        c.gridy++;

        c.weightx = 1;

        c.weighty = 1;

        c.fill = GridBagConstraints.BOTH;

        ITextArea infos = new ITextArea();

        final JScrollPane scrollPane = new JScrollPane(infos);

        scrollPane.setBorder(null);

        this.add(scrollPane, c);

        this.addView(infos, "INFOS");

        this.addSQLObject(textType, "TYPE");

        this.addSQLObject(textCode, "CODE");

        this.addSQLObject(textTel, "TEL");

        this.addSQLObject(textFax, "FAX");

        this.addSQLObject(boxUE, "UE");

        this.addRequiredSQLObject(compteSel, "ID_COMPTE_PCE");

        // this.addRequiredPrivateForeignField(adresse,"ID_ADRESSE");

        // this.addSQLObject(adresse, "VILLE");

        /***********************************************************************************

         * this.addSQLObject(new JTextField(), "NUMERO_CANTON"); this.addSQLObject(new JTextField(),

         * "NUMERO_COMMUNE");

         */

        // Select Compte fournisseur par defaut

        final SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();

        final SQLTable tablePrefCompte = base.getTable("PREFS_COMPTE");

        final SQLRow rowPrefsCompte = tablePrefCompte.getRow(2);

        int idCompteFourn = rowPrefsCompte.getInt("ID_COMPTE_PCE_FOURNISSEUR");

        if (idCompteFourn <= 1) {

            try {

                idCompteFourn = ComptePCESQLElement.getIdComptePceDefault("Fournisseurs");

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        compteSel.setValue(idCompteFourn);

    }

    @Override

    public void select(SQLRowAccessor r) {

        if (r != null && r.isForeignEmpty("ID_ADRESSE_E")) {

            this.checkEnlevement.setSelected(true);

            this.comp2.setEditable(InteractionMode.DISABLED);

            this.comp2.setCreated(false);

            this.sep2.setVisible(false);

        } else {

            this.checkEnlevement.setSelected(false);

            this.comp2.setEditable(InteractionMode.READ_WRITE);

            this.comp2.setCreated(true);

            this.sep2.setVisible(true);

        }

        if (r != null) {

            this.table.insertFrom("ID_" + this.getTable().getName(), r.asRowValues());

            this.defaultContactRowVals.put("TEL_DIRECT", r.getString("TEL"));

            this.defaultContactRowVals.put("FAX", r.getString("FAX"));

        }

        super.select(r);

    }

    @Override

    public void update() {

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

        super.update();

        this.table.updateField("ID_" + this.getTable().getName(), getSelectedID());

    }

    @Override

    public int insert(SQLRow order) {

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

        int id = super.insert(order);

        this.table.updateField("ID_" + this.getTable().getName(), id);

        return id;

    }

    @Override

    protected SQLRowValues createDefaults() {

        SQLRowValues vals = new SQLRowValues(this.getTable());

        SQLRowAccessor r;

        this.checkEnlevement.setSelected(true);

        this.sep2.setVisible(false);

        try {

            r = ModeReglementDefautPrefPanel.getDefaultRow(false);

            SQLElement eltModeReglement = Configuration.getInstance().getDirectory().getElement("MODE_REGLEMENT");

            if (r.getID() > 1) {

                SQLRowValues rowVals = eltModeReglement.createCopy(r.getID());

                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 charge par defaut

        final SQLTable tablePrefCompte = getTable().getTable("PREFS_COMPTE");

        final SQLRow rowPrefsCompte = SQLBackgroundTableCache.getInstance().getCacheForTable(tablePrefCompte).getRowFromId(2);

        // compte Achat

        int idCompteAchat = rowPrefsCompte.getInt("ID_COMPTE_PCE_ACHAT");

        if (idCompteAchat <= 1) {

            try {

                idCompteAchat = ComptePCESQLElement.getIdComptePceDefault("Achats");

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        vals.put("ID_COMPTE_PCE_CHARGE", idCompteAchat);

        return vals;

    }

}