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.model.PlanComptableEModel;
import org.openconcerto.erp.element.objet.Compte;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.SQLTableEvent;
import org.openconcerto.sql.model.SQLTableListener;
import org.openconcerto.sql.model.SQLTableModifiedListener;
import org.openconcerto.sql.view.EditFrame;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.utils.ExceptionHandler;

import java.awt.Container;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.AbstractAction;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JTable;

public class GestionPlanComptableEFrame extends JFrame {

    private JButton boutonAjout = new JButton("Créer un nouveau compte");
    private JButton boutonSuppr = new JButton("Supprimer");
    private JButton boutonAjoutPCG = new JButton("Ajouter un compte depuis le PCG");
    private EditFrame edit = null;
    private AjouterComptePCGtoPCEFrame ajoutCptFrame = null;

    private SQLTable compteTable = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getTable("COMPTE_PCE");
    private PlanComptableEPanel panelPCE;

    public GestionPlanComptableEFrame() {
        super("Gérer le plan comptable entreprise");
        Container container = this.getContentPane();

        // instanciation du panel et du menu click droit associé
        Vector<AbstractAction> actionClickDroitTable = new Vector<AbstractAction>();

        actionClickDroitTable.add(new AbstractAction("Ajouter un compte") {

            public void actionPerformed(ActionEvent e) {
                if (GestionPlanComptableEFrame.this.edit == null) {
                    GestionPlanComptableEFrame.this.edit = new EditFrame(Configuration.getInstance().getDirectory().getElement("COMPTE_PCE"));
                    GestionPlanComptableEFrame.this.edit.pack();
                }
                GestionPlanComptableEFrame.this.edit.setVisible(true);
            }
        });

        this.panelPCE = new PlanComptableEPanel(actionClickDroitTable);

        container.setLayout(new GridBagLayout());
        final GridBagConstraints c = new DefaultGridBagConstraints();
        c.fill = GridBagConstraints.NONE;
        container.add(this.boutonAjout, c);

        this.boutonAjout.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {
                if (GestionPlanComptableEFrame.this.edit == null) {
                    GestionPlanComptableEFrame.this.edit = new EditFrame(Configuration.getInstance().getDirectory().getElement("COMPTE_PCE"));
                    GestionPlanComptableEFrame.this.edit.pack();
                }
                GestionPlanComptableEFrame.this.edit.setVisible(true);
            }
        });

        c.gridx++;
        container.add(this.boutonSuppr, c);
        this.boutonSuppr.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                supprimerCompte();
            }
        });

        c.gridx++;
        container.add(this.boutonAjoutPCG, c);
        this.boutonAjoutPCG.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {
                if (GestionPlanComptableEFrame.this.ajoutCptFrame == null) {
                    GestionPlanComptableEFrame.this.ajoutCptFrame = new AjouterComptePCGtoPCEFrame();
                    GestionPlanComptableEFrame.this.ajoutCptFrame.pack();
                }
                GestionPlanComptableEFrame.this.ajoutCptFrame.setVisible(true);
            }
        });

        c.gridy++;
        c.gridx = 0;
        c.gridwidth = GridBagConstraints.REMAINDER;
        c.fill = GridBagConstraints.BOTH;
        c.weightx = 1;
        c.weighty = 1;

        container.add(this.panelPCE, c);

        this.compteTable.addTableModifiedListener(new SQLTableModifiedListener() {

            @Override
            public void tableModified(SQLTableEvent evt) {
                final SQLRow row = evt.getRow();
                GestionPlanComptableEFrame.this.panelPCE.fireModificationCompte(new Compte(evt.getId(), row.getString("NUMERO"), row.getString("NOM")));
            }
        });
    }

    private void supprimerCompte() {

        JTable tableTmp = (JTable) (this.panelPCE.getTables().get(this.panelPCE.getSelectedIndex()));

        PlanComptableEModel model = (PlanComptableEModel) tableTmp.getModel();

        int[] selectedRows = tableTmp.getSelectedRows();

        if (selectedRows.length == 0) {
            return;
        }

        SQLElement eltComptePCE = Configuration.getInstance().getDirectory().getElement("COMPTE_PCE");

        for (int i = 0; i < selectedRows.length; i++) {

            // Numéro du compte à supprimer
            // String numero = tableTmp.getValueAt(selectedRows[i], 0).toString();
            // int id = ComptePCESQLElement.getId(numero);
            int id = model.getId(selectedRows[i]);
            try {
                eltComptePCE.archive(id);
            } catch (SQLException e) {
                e.printStackTrace();
                ExceptionHandler.handle("Erreur lors de la suppression du compte.", e);
            }
            System.out.println("Compte Supprimé");
        }
    }

    public PlanComptableEPanel getPanelPCE() {
        return this.panelPCE;
    }
}