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.payment.component;

import org.openconcerto.erp.core.common.element.BanqueSQLElement;
import org.openconcerto.erp.core.common.ui.DeviseField;
import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;
import org.openconcerto.erp.core.finance.payment.ui.DepotChequeTable;
import org.openconcerto.erp.generationEcritures.GenerationMvtDepotChequeClient;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.sqlobject.ElementComboBox;
import org.openconcerto.sql.view.list.RowValuesTableModel;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.JDate;
import org.openconcerto.ui.JLabelBold;
import org.openconcerto.utils.ExceptionHandler;
import org.openconcerto.utils.GestionDevise;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;

import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;

public class DepotChequeSQLComponent extends BaseSQLComponent {

    private DepotChequeTable table = new DepotChequeTable();

    private JTextField nom = new JTextField();
    private DeviseField montant = new DeviseField(10);
    private JDate date;
    private ElementComboBox boxBanque = new ElementComboBox(true);

    public DepotChequeSQLComponent(SQLElement elt) {
        super(elt);
    }

    @Override
    public void addViews() {
        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        c.gridwidth = GridBagConstraints.REMAINDER;
        c.weightx = 1;
        this.add(new JLabelBold("Chèques"), c);
        c.gridy++;
        c.weighty = 1;
        c.fill = GridBagConstraints.BOTH;
        this.add(this.table, c);
        this.table.getRowValuesTable().setEnabled(false);
        c.fill = GridBagConstraints.HORIZONTAL;
        c.gridwidth = 1;
        c.gridy++;
        c.weighty = 0;

        // Client
        c.gridx = 0;
        c.gridy++;
        c.weightx = 0;
        final String itemName = "ID_" + getDirectory().getElement(BanqueSQLElement.class).getTable().getName();
        this.add(new JLabel(getLabelFor(itemName), SwingConstants.RIGHT), c);

        c.gridx++;
        c.weightx = 1;
        c.gridwidth = 1;
        this.add(this.boxBanque, c);
        c.gridwidth = 1;

        // Date
        this.date = new JDate(true);
        c.gridx = GridBagConstraints.RELATIVE;
        c.weightx = 0;
        c.gridwidth = 1;
        this.add(new JLabel("Date"), c);
        // c.gridx++;
        c.weightx = 0;
        this.add(this.date, c);

        this.addSQLObject(this.boxBanque, itemName);

        // Nom
        c.gridy++;
        c.gridx = 0;
        final JLabel label = new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT);
        c.weightx = 0;
        this.add(label, c);
        c.gridx++;
        c.weightx = 1;
        c.gridwidth = 2;
        this.add(this.nom, c);

        // Montant
        c.gridwidth = 1;
        c.gridy++;
        c.gridx = 0;
        c.weightx = 0;
        this.add(new JLabel("Montant encaissé", SwingConstants.RIGHT), c);

        c.gridx++;
        c.gridwidth = 3;
        c.fill = GridBagConstraints.NONE;
        this.add(this.montant, c);

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

        this.addSQLObject(this.nom, "NOM");
        DefaultGridBagConstraints.lockMinimumSize(this.montant);

        final TableModelListener tableListener = new TableModelListener() {

            @Override
            public void tableChanged(TableModelEvent e) {
                final RowValuesTableModel model = table.getRowValuesTable().getRowValuesTableModel();
                if (e.getColumn() == TableModelEvent.ALL_COLUMNS || e.getColumn() == model.getColumnIndexForElement(table.getMontantElement())) {

                    final int rowCount = model.getRowCount();
                    long total = 0;
                    for (int i = 0; i < rowCount; i++) {
                        Number nHT = (Number) model.getValueAt(i, model.getColumnIndexForElement(table.getMontantElement()));
                        if (nHT != null) {
                            total += nHT.longValue();
                        }
                    }

                    montant.setText(GestionDevise.currencyToString(total));

                }
            }
        };

        this.table.getRowValuesTable().getRowValuesTableModel().addTableModelListener(tableListener);

    }

    @Override
    public void select(SQLRowAccessor r) {
        super.select(r);
        if (r != null && r.getID() > 1) {
            this.table.insertFrom("ID_DEPOT_CHEQUE", r.getID());
        } else if (r != null && r instanceof SQLRowValues) {
            this.table.insertFrom((SQLRowValues) r);

        }
    }

    @Override
    public int insert(SQLRow order) {

        int id = super.insert(order);
        try {
            this.table.updateField("ID_DEPOT_CHEQUE", id);

            System.err.println("Génération des ecritures du reglement");
            GenerationMvtDepotChequeClient depotGen = new GenerationMvtDepotChequeClient(getTable().getRow(id));
            depotGen.genere();

        } catch (Exception e) {
            ExceptionHandler.handle("Erreur lors de la génération des ecritures du reglement", e);
        }
        return id;
    }

    @Override
    public void update() {
        final int id = this.getSelectedID();
        super.update();
        this.table.updateField("ID_DEPOT_CHEQUE", id);
        SQLRow row = getTable().getRow(id);
        int idMvt = row.getInt("ID_MOUVEMENT");

        // on supprime tout ce qui est lié à la facture
        try {
            EcritureSQLElement eltEcr = (EcritureSQLElement) Configuration.getInstance().getDirectory().getElement("ECRITURE");
            eltEcr.archiveMouvementProfondeur(idMvt, false);

            GenerationMvtDepotChequeClient depotGen = new GenerationMvtDepotChequeClient(row);
            depotGen.genere();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    @Override
    protected SQLRowValues createDefaults() {
        this.table.getModel().clearRows();

        return new SQLRowValues(getTable());
    }

}