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

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.

 *

 * The contents of this file are subject to the terms of the GNU General Public License Version 3

 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a

 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific

 * language governing permissions and limitations under the License.

 *

 * When distributing the software, include this License Header Notice in each file.

 */

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

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.util.Date;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

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

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

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

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

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

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

import org.openconcerto.erp.generationEcritures.GenerationMvtAvoirFournisseur;

import org.openconcerto.erp.model.ISQLCompteSelector;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.ElementSQLObject;

import org.openconcerto.sql.element.SQLElement;

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.sqlobject.ElementComboBox;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FormLayouter;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.ui.component.ITextArea;

import org.openconcerto.ui.component.InteractionMode;

import org.openconcerto.utils.ExceptionHandler;

public class AvoirFournisseurSQLComponent extends TransfertBaseSQLComponent implements ActionListener {

    private JTextField textNom;

    private JDate date;

    private ElementComboBox selectFournisseur;

    private MontantPanel montantPanel;

    private JTextField textNumero = new JTextField(16);

    private JCheckBox boxAdeduire = new JCheckBox(getLabelFor("A_DEDUIRE"));

    private JCheckBox boxImmo = new JCheckBox(getLabelFor("IMMO"));

    private ElementSQLObject eltModeRegl;

    private PropertyChangeListener listenerModeReglDefaut = new PropertyChangeListener() {

        public void propertyChange(PropertyChangeEvent evt) {

            SQLRow rowSelected = AvoirFournisseurSQLComponent.this.selectFournisseur.getSelectedRow();

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

                rowSelected = rowSelected.asRow();

                AvoirFournisseurSQLComponent.this.montantPanel.setUE(rowSelected.getBoolean("UE"));

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

                if (idModeRegl > 1 && AvoirFournisseurSQLComponent.this.eltModeRegl != null) {

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

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

                    SQLRowValues rowVals = rowModeRegl.createUpdateRow();

                    rowVals.clearPrimaryKeys();

                    AvoirFournisseurSQLComponent.this.eltModeRegl.setValue(rowVals);

                }

            } else {

                AvoirFournisseurSQLComponent.this.montantPanel.setUE(false);

            }

        }

    };

    @Override

    protected SQLRowValues createDefaults() {

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

        vals.put("A_DEDUIRE", Boolean.TRUE);

        // Select Compte charge par defaut

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

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

        final SQLRow rowPrefsCompte = tablePrefCompte.getRow(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", idCompteAchat);

        vals.put("ID_TAXE", TaxeCache.getCache().getFirstTaxeAchat().getID());

        vals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), new Date()));

        return vals;

    }

    public AvoirFournisseurSQLComponent() {

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

    }

    public void addViews() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

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

        this.textNom = new JTextField();

        this.selectFournisseur = new ElementComboBox();

        this.montantPanel = new MontantPanel();

        // Numero

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

        c.gridx++;

        c.weightx = 1;

        c.fill = GridBagConstraints.NONE;

        DefaultGridBagConstraints.lockMinimumSize(this.textNumero);

        this.add(this.textNumero, c);

        // Date

        c.gridx++;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

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

        c.gridx++;

        c.weightx = 0;

        c.fill = GridBagConstraints.NONE;

        this.date = new JDate(true);

        this.add(this.date, c);

        // Libellé

        c.gridwidth = 1;

        c.weightx = 0;

        c.gridy++;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridx = 0;

        final JLabel labelLib = new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT);

        this.add(labelLib, c);

        c.gridx++;

        c.weightx = 1;

        c.gridwidth = 3;

        this.add(this.textNom, c);

        // Fournisseur

        c.gridx = 0;

        c.gridy++;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.anchor = GridBagConstraints.WEST;

        c.weightx = 0;

        c.gridwidth = 1;

        final JLabel labelFourn = new JLabel(getLabelFor("ID_FOURNISSEUR"), SwingConstants.RIGHT);

        this.add(labelFourn, c);

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.weightx = 0;

        this.add(this.selectFournisseur, c);

        c.gridx = 0;

        c.gridy++;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridwidth = 1;

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

        c.weighty = 0;

        c.anchor = GridBagConstraints.WEST;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridx++;

        this.montantPanel = new MontantPanel();

        this.add(this.montantPanel, c);

        // /

        TitledSeparator title = new TitledSeparator("Comptabilité");

        c.gridx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridy++;

        c.gridwidth = 4;

        this.add(title, c);

        // Ligne 5 Compte de charges

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        c.fill = GridBagConstraints.NONE;

        c.gridwidth = 1;

        final ISQLCompteSelector compteSel = new ISQLCompteSelector();

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

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridx++;

        c.weightx = 1;

        this.add(compteSel, c);

        // Immo

        c.gridwidth = 1;

        c.anchor = GridBagConstraints.WEST;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridx = 1;

        c.gridy++;

        c.weighty = 0;

        this.add(this.boxImmo, c);

        // Mode de règlement

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

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

        //

        // JPanel panelBottom = new JPanel();

        // panelBottom.add(eltModeRegl);

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

         * * CALCUL DES TOTAUX

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

        // c.anchor = GridBagConstraints.WEST;

        // c.gridwidth = GridBagConstraints.REMAINDER;

        // c.gridx = 0;

        // c.gridy++;

        // c.weighty = 0;

        // this.add(this.boxAdeduire, c);

        //

        // c.anchor = GridBagConstraints.WEST;

        // c.gridwidth = GridBagConstraints.REMAINDER;

        // c.gridx = 0;

        // c.gridy++;

        // c.weighty = 0;

        // this.add(panelBottom, c);

        // Filler

        c.gridheight = 1;

        c.gridx = 0;

        c.gridy++;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridwidth = GridBagConstraints.REMAINDER;

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

        c.gridy++;

        c.fill = GridBagConstraints.BOTH;

        c.weighty = 1;

        c.gridwidth = GridBagConstraints.REMAINDER;

        ITextArea infos = new ITextArea(4, 4);

        infos.setBorder(null);

        JScrollPane scrollPane = new JScrollPane(infos);

        DefaultGridBagConstraints.lockMinimumSize(scrollPane);

        this.add(scrollPane, c);

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

            this.addSQLObject(infos, "INFOS");

        }

        JPanel p = new JPanel();

        p.setOpaque(false);

        c.gridy++;

        c.weighty = 1;

        this.add(p, c);

        this.addSQLObject(this.textNom, "NOM");

        // this.addSQLObject(this.boxAdeduire, "A_DEDUIRE");

        this.addRequiredSQLObject(this.textNumero, "NUMERO");

        this.addRequiredSQLObject(this.date, "DATE");

        this.addRequiredSQLObject(this.selectFournisseur, "ID_FOURNISSEUR");

        this.addRequiredSQLObject(this.montantPanel.getMontantHT(), "MONTANT_HT");

        this.addRequiredSQLObject(this.montantPanel.getMontantTVA(), "MONTANT_TVA");

        this.addRequiredSQLObject(this.montantPanel.getMontantTTC(), "MONTANT_TTC");

        this.addRequiredSQLObject(this.montantPanel.getChoixTaxe(), "ID_TAXE");

        this.addSQLObject(compteSel, "ID_COMPTE_PCE");

        this.addSQLObject(this.boxImmo, "IMMO");

        this.selectFournisseur.addValueListener(this.listenerModeReglDefaut);

        // this.boxAdeduire.addActionListener(this);

        this.montantPanel.setChoixTaxe(TaxeCache.getCache().getFirstTaxe().getID());

    }

    @Override

    public int insert(SQLRow order) {

        int id = getSelectedID();

        id = super.insert(order);

        try {

            final SQLTable tableNum = this.getTable().getBase().getTable("NUMEROTATION_AUTO");

            final SQLRow row = getTable().getRow(id);

            // incrémentation du numéro auto

            if (NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), row.getDate("DATE").getTime()).equalsIgnoreCase(this.textNumero.getText().trim())) {

                SQLRowValues rowVals = new SQLRowValues(tableNum);

                int val = tableNum.getRow(2).getInt("AVOIR_F_START");

                val++;

                rowVals.put("AVOIR_F_START", Integer.valueOf(val));

                rowVals.update(2);

            }

            GenerationMvtAvoirFournisseur gen = new GenerationMvtAvoirFournisseur(row);

            gen.genereMouvement();

        } catch (Exception e) {

            ExceptionHandler.handle("Erreur d'insertion", e);

        }

        return id;

    }

    @Override

    public void select(SQLRowAccessor r) {

        this.selectFournisseur.rmValueListener(this.listenerModeReglDefaut);

        super.select(r);

        if (r != null && r.getID() > 1) {

            int i = r.getInt("ID_FOURNISSEUR");

            if (i > 1) {

                SQLRowAccessor rowFourn = r.getForeign("ID_FOURNISSEUR");

                if (rowFourn != null && rowFourn.getID() > 1) {

                    AvoirFournisseurSQLComponent.this.montantPanel.setUE(rowFourn.getBoolean("UE"));

                }

            }

        }

        this.selectFournisseur.addValueListener(this.listenerModeReglDefaut);

    }

    @Override

    public void update() {

        super.update();

        try {

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

            int idMvt = row.getInt("ID_MOUVEMENT");

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

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

            eltEcr.archiveMouvementProfondeur(idMvt, false);

            GenerationMvtAvoirFournisseur gen = new GenerationMvtAvoirFournisseur(row, idMvt);

            gen.genereMouvement();

        } catch (Exception e) {

            ExceptionHandler.handle("Erreur Archivage des fils", e);

        }

    }

    public void actionPerformed(ActionEvent e) {

        if (e.getSource() == this.boxAdeduire) {

            if (this.eltModeRegl != null) {

                final boolean b = this.boxAdeduire.isSelected();

                InteractionMode mode = null;

                this.eltModeRegl.setEditable((!b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);

                this.eltModeRegl.setCreated(!b);

            }

        }

    }

    @Override

    protected void refreshAfterSelect(SQLRowAccessor rSource) {

        // TODO Auto-generated method stub

    }

}