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.finance.accounting.ui;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

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

import org.openconcerto.erp.generationEcritures.GenerationMvtSaisieVenteFacture;

import org.openconcerto.erp.model.ISQLCompteSelector;

import org.openconcerto.sql.Configuration;

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.request.SQLFieldTranslator;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.ui.preferences.DefaultPreferencePanel;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.sql.SQLException;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.SwingUtilities;

public class CompteGestCommPreferencePanel extends DefaultPreferencePanel {

    private ISQLCompteSelector selCompteCBAttente, selCompteTVAIntraComm, selCompteFourn, selCompteAchat, selCompteValeurEncaissement, selCompteAvanceClient, selCompteClient, selCompteVenteProduits,

            selCompteVenteService, selCompteTVACol, selCompteTVADed, selCompteTVAImmo, selCompteAchatIntra, selCompteFactor, selComptePortSoumis, selComptePortNonSoumis;

    private ElementComboBox selJrnlFactor, selJrnlValEnc, selJrnlCB;

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

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

    private SQLRowValues rowPrefCompteVals = new SQLRowValues(tablePrefCompte);

    public CompteGestCommPreferencePanel() {

        super();

        final SQLRow rowPrefCompte = tablePrefCompte.getRow(2);

        this.rowPrefCompteVals.loadAbsolutelyAll(rowPrefCompte);

        final Insets separatorInsets = new Insets(10, 2, 1, 2);

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        final Insets normalInsets = c.insets;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.anchor = GridBagConstraints.WEST;

        c.gridx = 0;

        c.gridy = 0;

        c.gridwidth = 1;

        c.gridheight = 1;

        c.weightx = 1;

        c.weighty = 0;

        c.gridwidth = GridBagConstraints.REMAINDER;

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

         * SAISIE DES ACHATS

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

        TitledSeparator sep = new TitledSeparator("Saisie des Achats");

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(sep, c);

        c.gridwidth = 1;

        // Compte Fournisseur

        c.gridy++;

        c.weightx = 0;

        this.add(new JLabel("Compte Fournisseur"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteFourn = new ISQLCompteSelector();

        this.selCompteFourn.init();

        this.add(this.selCompteFourn, c);

        // Compte Achat

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte Achat"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteAchat = new ISQLCompteSelector();

        this.selCompteAchat.init();

        this.add(this.selCompteAchat, c);

        // Compte Achat intra

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte Achat Intracommunautaire"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteAchatIntra = new ISQLCompteSelector();

        this.selCompteAchatIntra.init();

        this.add(this.selCompteAchatIntra, c);

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

         * SAISIE DES VENTES

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

        c.gridy++;

        c.gridx = 0;

        TitledSeparator sepVenteC = new TitledSeparator("Saisie des ventes");

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.insets = separatorInsets;

        this.add(sepVenteC, c);

        c.insets = normalInsets;

        c.gridwidth = 1;

        // Compte client

        c.gridy++;

        c.weightx = 0;

        this.add(new JLabel("Compte Client"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteClient = new ISQLCompteSelector();

        this.selCompteClient.init();

        this.add(this.selCompteClient, c);

        // Avance Compte client

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel("Compte Avance Client"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteAvanceClient = new ISQLCompteSelector();

        this.selCompteAvanceClient.init();

        this.add(this.selCompteAvanceClient, c);

        // Valeur à l'encaissement

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel("Compte dépôt chèque"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteValeurEncaissement = new ISQLCompteSelector();

        this.selCompteValeurEncaissement.init();

        this.add(this.selCompteValeurEncaissement, c);

        // Journal

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Journal dépôt chèque"), c);

        c.weightx = 1;

        c.gridx++;

        this.selJrnlValEnc = new ElementComboBox();

        this.selJrnlValEnc.init(Configuration.getInstance().getDirectory().getElement("JOURNAL"));

        this.add(this.selJrnlValEnc, c);

        // Journal

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Journal CB Attente"), c);

        c.weightx = 1;

        c.gridx++;

        this.selJrnlCB = new ElementComboBox();

        this.selJrnlCB.init(Configuration.getInstance().getDirectory().getElement("JOURNAL"));

        this.add(this.selJrnlCB, c);

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte CB Attente"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteCBAttente = new ISQLCompteSelector();

        this.selCompteCBAttente.init();

        this.add(this.selCompteCBAttente, c);

        // Compte vente produits

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte Vente de produits"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteVenteProduits = new ISQLCompteSelector();

        this.selCompteVenteProduits.init();

        this.add(this.selCompteVenteProduits, c);

        // Compte vente service

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte Vente de service"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteVenteService = new ISQLCompteSelector();

        this.selCompteVenteService.init();

        this.add(this.selCompteVenteService, c);

        // Factor NATEXIS

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte affacturage"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteFactor = new ISQLCompteSelector();

        this.selCompteFactor.init();

        this.add(this.selCompteFactor, c);

        // Journal Factor NATEXIS

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Journal affacturage"), c);

        c.weightx = 1;

        c.gridx++;

        this.selJrnlFactor = new ElementComboBox();

        this.selJrnlFactor.init(Configuration.getInstance().getDirectory().getElement("JOURNAL"));

        this.add(this.selJrnlFactor, c);

        /**

         * Frais de port sur vente

         */

        c.gridy++;

        c.gridx = 0;

        TitledSeparator sepPort = new TitledSeparator("Ports sur vente");

        c.insets = separatorInsets;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(sepPort, c);

        c.insets = normalInsets;

        c.gridwidth = 1;

        // Compte TVA Collectee

        c.gridy++;

        c.weightx = 0;

        this.add(new JLabel("Compte Port soumis à TVA"), c);

        c.weightx = 1;

        c.gridx++;

        this.selComptePortSoumis = new ISQLCompteSelector();

        this.selComptePortSoumis.init();

        this.add(this.selComptePortSoumis, c);

        // Compte TVA Deductible

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte Port non soumis à TVA)"), c);

        c.weightx = 1;

        c.gridx++;

        this.selComptePortNonSoumis = new ISQLCompteSelector();

        this.selComptePortNonSoumis.init();

        this.add(this.selComptePortNonSoumis, c);

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

         * TVA

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

        c.gridy++;

        c.gridx = 0;

        TitledSeparator sepTVA = new TitledSeparator("TVA");

        c.insets = separatorInsets;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(sepTVA, c);

        c.insets = normalInsets;

        c.gridwidth = 1;

        // Compte TVA Collectee

        c.gridy++;

        c.weightx = 0;

        this.add(new JLabel("Compte TVA Collectée (Ventes)"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteTVACol = new ISQLCompteSelector();

        this.selCompteTVACol.init();

        this.add(this.selCompteTVACol, c);

        // Compte TVA Deductible

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte TVA déductible (Achats)"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteTVADed = new ISQLCompteSelector();

        this.selCompteTVADed.init();

        this.add(this.selCompteTVADed, c);

        // Compte TVA intracommunautaire

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte TVA due intracommunautaire"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteTVAIntraComm = new ISQLCompteSelector();

        this.selCompteTVAIntraComm.init();

        this.add(this.selCompteTVAIntraComm, c);

        // Compte TVA intracommunautaire

        c.gridy++;

        c.weighty = 0;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte TVA sur immobilisations"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteTVAImmo = new ISQLCompteSelector();

        this.selCompteTVAImmo.init();

        this.add(this.selCompteTVAImmo, c);

        // Spacer

        c.weighty = 1;

        c.gridy++;

        this.add(new JPanel(), c);

        setValues();

    }

    public void storeValues() {

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_ACHAT", this.selCompteAchat.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_ACHAT_INTRA", this.selCompteAchatIntra.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_VENTE_PRODUIT", this.selCompteVenteProduits.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_VENTE_SERVICE", this.selCompteVenteService.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_FACTOR", this.selCompteFactor.getValue());

        final int selectedId = this.selJrnlFactor.getSelectedId();

        this.rowPrefCompteVals.put("ID_JOURNAL_FACTOR", (selectedId > 1) ? selectedId : 1);

        final int selectedIdEnc = this.selJrnlValEnc.getSelectedId();

        this.rowPrefCompteVals.put("ID_JOURNAL_VALEUR_ENCAISSEMENT", (selectedIdEnc > 1) ? selectedIdEnc : 1);

        final int selectedIdCB = this.selJrnlCB.getSelectedId();

        this.rowPrefCompteVals.put("ID_JOURNAL_CB_ATTENTE", (selectedIdCB > 1) ? selectedIdCB : 1);

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_CB_ATTENTE", this.selCompteCBAttente.getSelectedId() > 1 ? this.selCompteCBAttente.getSelectedId() : 1);

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_FOURNISSEUR", this.selCompteFourn.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_CLIENT", this.selCompteClient.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_AVANCE_CLIENT", this.selCompteAvanceClient.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_VALEUR_ENCAISSEMENT", this.selCompteValeurEncaissement.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_TVA_ACHAT", this.selCompteTVADed.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_TVA_VENTE", this.selCompteTVACol.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_TVA_INTRA", this.selCompteTVAIntraComm.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_TVA_IMMO", this.selCompteTVAImmo.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_PORT_SOUMIS", this.selComptePortSoumis.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_PORT_NON_SOUMIS", this.selComptePortNonSoumis.getValue());

        try {

            final Object[] pb = this.rowPrefCompteVals.getInvalid();

            if (pb != null) {

                final SQLFieldTranslator trans = Configuration.getInstance().getTranslator();

                JOptionPane.showMessageDialog(SwingUtilities.getRoot(this), "Impossible de valider les modifications! Le champ <"

                        + trans.getLabelFor(this.rowPrefCompteVals.getTable().getField(pb[0].toString())) + "> pointe sur un compte invalide!(" + pb[1] + ")");

            } else {

                this.rowPrefCompteVals.update();

            }

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }

    public void restoreToDefaults() {

        try {

            // Achats

            String compte;

            compte = ComptePCESQLElement.getComptePceDefault("Achats");

            int value = ComptePCESQLElement.getId(compte);

            this.selCompteAchat.setValue(value);

            // Achats Intra

            compte = ComptePCESQLElement.getComptePceDefault("AchatsIntra");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteAchatIntra.setValue(value);

            // Ventes Produits

            compte = ComptePCESQLElement.getComptePceDefault("VentesProduits");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteVenteProduits.setValue(value);

            // Ventes Services

            compte = ComptePCESQLElement.getComptePceDefault("VentesServices");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteVenteService.setValue(value);

            // Ventes factor

            compte = ComptePCESQLElement.getComptePceDefault("Factor");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteFactor.setValue(value);

            this.selJrnlFactor.setValue(GenerationMvtSaisieVenteFacture.journal);

            this.selJrnlValEnc.setValue(JournalSQLElement.BANQUES);

            // Fournisseurs

            compte = ComptePCESQLElement.getComptePceDefault("Fournisseurs");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteFourn.setValue(value);

            // Client

            compte = ComptePCESQLElement.getComptePceDefault("Clients");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteClient.setValue(value);

            // AvanceClient

            compte = ComptePCESQLElement.getComptePceDefault("AvanceClients");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteAvanceClient.setValue(value);

            compte = ComptePCESQLElement.getComptePceDefault("ValeurEncaissement");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteValeurEncaissement.setValue(value);

            // Port

            compte = ComptePCESQLElement.getComptePceDefault("PortVenteSoumisTVA");

            value = ComptePCESQLElement.getId(compte);

            this.selComptePortSoumis.setValue(value);

            // Port non soumis

            compte = ComptePCESQLElement.getComptePceDefault("PortVenteNonSoumisTVA");

            value = ComptePCESQLElement.getId(compte);

            this.selComptePortNonSoumis.setValue(value);

            // TVA Coll

            compte = ComptePCESQLElement.getComptePceDefault("TVACollectee");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteTVACol.setValue(value);

            // TVA Ded

            compte = ComptePCESQLElement.getComptePceDefault("TVADeductible");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteTVADed.setValue(value);

            // TVA IntraComm

            compte = ComptePCESQLElement.getComptePceDefault("TVAIntraComm");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteTVAIntraComm.setValue(value);

            // TVA Immo

            compte = ComptePCESQLElement.getComptePceDefault("TVAImmo");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteTVAImmo.setValue(value);

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

    public String getTitleName() {

        return "Gestion commerciale";

    }

    private void setValues() {

        try {

            setComboValues(selCompteAchat, "ID_COMPTE_PCE_ACHAT", "Achats");

            setComboValues(selCompteAchatIntra, "ID_COMPTE_PCE_ACHAT_INTRA", "AchatsIntra");

            setComboValues(selCompteVenteProduits, "ID_COMPTE_PCE_VENTE_PRODUIT", "VentesProduits");

            setComboValues(selCompteVenteService, "ID_COMPTE_PCE_VENTE_SERVICE", "VentesServices");

            setComboValues(selCompteFactor, "ID_COMPTE_PCE_FACTOR", "Factor");

            {

                // Journal Factor

                int value = (this.rowPrefCompteVals.getObject("ID_JOURNAL_FACTOR") == null ? 1 : this.rowPrefCompteVals.getInt("ID_JOURNAL_FACTOR"));

                if (value <= 1) {

                    value = GenerationMvtSaisieVenteFacture.journal;

                }

                this.selJrnlFactor.setValue(value);

            }

            {

                // Journal CB

                int value = (this.rowPrefCompteVals.getObject("ID_JOURNAL_CB_ATTENTE") == null ? 1 : this.rowPrefCompteVals.getInt("ID_JOURNAL_CB_ATTENTE"));

                if (value > 1) {

                    this.selJrnlCB.setValue(value);

                }

                int valueCpt = (this.rowPrefCompteVals.getObject("ID_COMPTE_PCE_CB_ATTENTE") == null ? 1 : this.rowPrefCompteVals.getInt("ID_COMPTE_PCE_CB_ATTENTE"));

                if (valueCpt > 1) {

                    this.selCompteCBAttente.setValue(valueCpt);

                }

            }

            {

                // Journal Val enc

                int value = (this.rowPrefCompteVals.getObject("ID_JOURNAL_VALEUR_ENCAISSEMENT") == null ? 1 : this.rowPrefCompteVals.getInt("ID_JOURNAL_VALEUR_ENCAISSEMENT"));

                if (value <= 1) {

                    value = JournalSQLElement.BANQUES;

                }

                this.selJrnlValEnc.setValue(value);

            }

            setComboValues(this.selCompteFourn, "ID_COMPTE_PCE_FOURNISSEUR", "Fournisseurs");

            setComboValues(this.selCompteClient, "ID_COMPTE_PCE_CLIENT", "Clients");

            setComboValues(this.selCompteAvanceClient, "ID_COMPTE_PCE_AVANCE_CLIENT", "AvanceClients");

            setComboValues(this.selCompteValeurEncaissement, "ID_COMPTE_PCE_VALEUR_ENCAISSEMENT", "ValeurEncaissement");

            setComboValues(this.selComptePortSoumis, "ID_COMPTE_PCE_PORT_SOUMIS", "PortVenteSoumisTVA");

            setComboValues(this.selComptePortNonSoumis, "ID_COMPTE_PCE_PORT_NON_SOUMIS", "PortVenteNonSoumisTVA");

            setComboValues(this.selCompteTVACol, "ID_COMPTE_PCE_TVA_VENTE", "TVACollectee");

            setComboValues(this.selCompteTVADed, "ID_COMPTE_PCE_TVA_ACHAT", "TVADeductible");

            setComboValues(this.selCompteTVAIntraComm, "ID_COMPTE_PCE_TVA_INTRA", "TVAIntraComm");

            setComboValues(this.selCompteTVAImmo, "ID_COMPTE_PCE_TVA_IMMO", "TVAImmo");

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

    private void setComboValues(ISQLCompteSelector combo, String field, String defaultName) {

        int value = 1;

        SQLRowAccessor row = this.rowPrefCompteVals.getForeign(field);

        if (row == null || row.isUndefined()) {

            String compte = ComptePCESQLElement.getComptePceDefault(defaultName);

            value = ComptePCESQLElement.getId(compte);

        } else {

            value = row.getID();

        }

        combo.setValue(value);

    }

}