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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.preferences.DefaultPreferencePanel;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.sql.SQLException;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.SwingUtilities;

public class CompteCloturePreferencePanel extends DefaultPreferencePanel {

    private ISQLCompteSelector selCompteOuverture, selCompteFermeture, selCompteResultat, selCompteResultatPerte;

    private SQLRequestComboBox selJournal;

    private JCheckBox boxCompteSolde;

    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 CompteCloturePreferencePanel() {

        final SQLRow rowPrefCompte = tablePrefCompte.getRow(2);

        this.rowPrefCompteVals.loadAbsolutelyAll(rowPrefCompte);

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        // Compte ouverture

        this.add(new JLabel("Compte bilan d'ouverture"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteOuverture = new ISQLCompteSelector();

        this.selCompteOuverture.init();

        this.add(this.selCompteOuverture, c);

        // Compte fermeture

        c.gridy++;

        c.weightx = 0;

        c.gridx = 0;

        this.add(new JLabel("Compte bilan de clôture"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteFermeture = new ISQLCompteSelector();

        this.selCompteFermeture.init();

        this.add(this.selCompteFermeture, c);

        // Compte résultat

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel("Compte de résultat (bénéfice)"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteResultat = new ISQLCompteSelector();

        this.selCompteResultat.init();

        this.add(this.selCompteResultat, c);

        // Compte résultat

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel("Compte de résultat (perte)"), c);

        c.weightx = 1;

        c.gridx++;

        this.selCompteResultatPerte = new ISQLCompteSelector();

        this.selCompteResultatPerte.init();

        this.add(this.selCompteResultatPerte, c);

        // Compte résultat

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel("Journal des à nouveaux"), c);

        c.weightx = 1;

        c.gridx++;

        this.selJournal = new SQLRequestComboBox(false);

        this.selJournal.uiInit(Configuration.getInstance().getDirectory().getElement("JOURNAL").createComboRequest());

        this.add(this.selJournal, c);

        // Compte résultat

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        this.add(new JLabel("Générer des écritures de fermetures et d'à nouveaux pour les comptes soldés"), c);

        c.weightx = 1;

        c.gridx++;

        this.boxCompteSolde = new JCheckBox();

        this.boxCompteSolde.setSelected(true);

        this.add(this.boxCompteSolde, c);

        // Spacer

        JPanel p = new JPanel();

        p.setOpaque(false);

        c.gridy++;

        c.weighty = 1;

        this.add(p, c);

        setValues();

    }

    public void storeValues() {

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_BILAN_O", this.selCompteOuverture.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_BILAN_F", this.selCompteFermeture.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_RESULTAT", this.selCompteResultat.getValue());

        this.rowPrefCompteVals.put("ID_COMPTE_PCE_RESULTAT_PERTE", this.selCompteResultatPerte.getValue());

        this.rowPrefCompteVals.put("ID_JOURNAL_AN", this.selJournal.getValue());

        this.rowPrefCompteVals.put("CREATE_NUL_SOLDE_ECR", this.boxCompteSolde.isSelected());

        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 {

            // Ouverture

            String compte;

            compte = ComptePCESQLElement.getComptePceDefault("BilanOuverture");

            int value = ComptePCESQLElement.getId(compte);

            this.selCompteOuverture.setValue(value);

            // Fermeture

            compte = ComptePCESQLElement.getComptePceDefault("BilanFermeture");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteFermeture.setValue(value);

            // Resultat

            compte = ComptePCESQLElement.getComptePceDefault("Resultat");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteResultat.setValue(value);

            // Resultat

            compte = ComptePCESQLElement.getComptePceDefault("ResultatPerte");

            value = ComptePCESQLElement.getId(compte);

            this.selCompteResultatPerte.setValue(value);

            // AN

            this.selJournal.setValue(JournalSQLElement.OD);

            this.boxCompteSolde.setSelected(true);

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

    public String getTitleName() {

        return "Clôture";

    }

    private void setValues() {

        try {

            // Ouverture

            SQLRowAccessor rowBilanO = this.rowPrefCompteVals.getForeign("ID_COMPTE_PCE_BILAN_O");

            int value = 1;

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

                String compte = ComptePCESQLElement.getComptePceDefault("BilanOuverture");

                value = ComptePCESQLElement.getId(compte);

            } else {

                value = rowBilanO.getID();

            }

            this.selCompteOuverture.setValue(value);

            // Fermeture

            SQLRowAccessor rowBilanF = this.rowPrefCompteVals.getForeign("ID_COMPTE_PCE_BILAN_F");

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

                String compte = ComptePCESQLElement.getComptePceDefault("BilanFermeture");

                value = ComptePCESQLElement.getId(compte);

            } else {

                value = rowBilanF.getID();

            }

            this.selCompteFermeture.setValue(value);

            // Resultat

            SQLRowAccessor rowResultat = this.rowPrefCompteVals.getForeign("ID_COMPTE_PCE_RESULTAT");

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

                String compte = ComptePCESQLElement.getComptePceDefault("Resultat");

                value = ComptePCESQLElement.getId(compte);

            } else {

                value = rowResultat.getID();

            }

            this.selCompteResultat.setValue(value);

            // Resultat Perte

            SQLRowAccessor rowResultatP = this.rowPrefCompteVals.getForeign("ID_COMPTE_PCE_RESULTAT_PERTE");

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

                String compte = ComptePCESQLElement.getComptePceDefault("ResultatPerte");

                value = ComptePCESQLElement.getId(compte);

            } else {

                value = rowResultatP.getID();

            }

            this.selCompteResultatPerte.setValue(value);

            // Journal

            SQLRowAccessor rowJ = this.rowPrefCompteVals.getForeign("ID_JOURNAL_AN");

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

                value = JournalSQLElement.OD;

            } else {

                value = rowJ.getID();

            }

            this.selJournal.setValue(value);

            // Journal

            boolean b = true;

            if (this.rowPrefCompteVals.getObject("CREATE_NUL_SOLDE_ECR") != null) {

                b = this.rowPrefCompteVals.getBoolean("CREATE_NUL_SOLDE_ECR");

            }

            this.boxCompteSolde.setSelected(b);

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

}