OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 144 | Rev 180 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/*
 * 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(12);
            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;
    }

}