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

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011-2019 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.tax.element;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.sales.product.element.TaxeCatComptableSQLElement;
import org.openconcerto.erp.core.sales.product.ui.TaxeCategorieComptableTable;
import org.openconcerto.erp.model.ISQLCompteSelector;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.model.SQLDataSource;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.request.UpdateBuilder;
import org.openconcerto.sql.sqlobject.ElementComboBox;
import org.openconcerto.sql.utils.SQLUtils;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.utils.ProductInfo;

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.ArrayList;
import java.util.List;

import javax.swing.AbstractAction;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.SwingConstants;

public class TaxeSQLElement extends ComptaSQLConfElement {

    public TaxeSQLElement() {
        super("TAXE", "une taxe", "taxes");

        PredicateRowAction action = new PredicateRowAction(new AbstractAction("Définir par défaut") {

            @Override
            public void actionPerformed(ActionEvent e) {

                final SQLRowAccessor row = IListe.get(e).getSelectedRow();
                final SQLDataSource ds = row.getTable().getDBSystemRoot().getDataSource();

                try {
                    SQLUtils.executeAtomic(ds, new SQLUtils.SQLFactory<Object>() {
                        @Override
                        public Object create() throws SQLException {
                            // Transaction
                            UpdateBuilder upRemoveDefault = new UpdateBuilder(row.getTable());
                            upRemoveDefault.set("DEFAULT", "FALSE");

                            ds.execute(upRemoveDefault.asString());

                            UpdateBuilder upSetDefault = new UpdateBuilder(row.getTable());
                            upSetDefault.set("DEFAULT", "TRUE");
                            upSetDefault.setWhere(new Where(row.getTable().getKey(), "=", row.getID()));

                            ds.execute(upSetDefault.asString());

                            JOptionPane.showMessageDialog(null, "Rédémarrez " + ProductInfo.getInstance().getName() + " pour valider le changement de TVA par défaut.");

                            return null;
                        }
                    });
                } catch (Exception ex) {
                    throw new IllegalStateException("Erreur lors d'affectation de la nouvelle TVA par défaut", ex);
                }

            }
        }, true);
        action.setPredicate(IListeEvent.getSingleSelectionPredicate());

        this.getRowActions().add(action);

    }

    protected List<String> getListFields() {
        final List<String> l = new ArrayList<String>();
        l.add("NOM");
        l.add("TAUX");
        l.add("DEFAULT");
        return l;
    }

    protected List<String> getComboFields() {
        final List<String> l = new ArrayList<String>();
        l.add("NOM");
        return l;
    }

    public SQLComponent createComponent() {
        return new BaseSQLComponent(this) {

            TaxeCategorieComptableTable tableCatComptable = new TaxeCategorieComptableTable(getElement().getDirectory().getElement(TaxeCatComptableSQLElement.class));

            @Override
            protected void addViews() {

                this.setLayout(new GridBagLayout());
                GridBagConstraints c = new DefaultGridBagConstraints();
                JLabel labelNom = new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT);

                this.add(labelNom, c);
                c.gridx++;
                c.weightx = 1;
                c.fill = GridBagConstraints.NONE;
                JTextField fieldNom = new JTextField(40);
                DefaultGridBagConstraints.lockMinimumSize(fieldNom);
                this.add(fieldNom, c);
                c.gridx = 0;
                c.gridy++;
                c.weightx = 0;
                c.fill = GridBagConstraints.HORIZONTAL;
                JLabel labelTaux = new JLabel(getLabelFor("TAUX"), SwingConstants.RIGHT);
                this.add(labelTaux, c);
                c.gridx++;
                c.fill = GridBagConstraints.NONE;
                JTextField fieldTaux = new JTextField(6);
                DefaultGridBagConstraints.lockMinimumSize(fieldTaux);
                this.add(fieldTaux, c);

                JLabel labelCompteCol = new JLabel(getLabelFor("ID_COMPTE_PCE_COLLECTE"), SwingConstants.RIGHT);
                c.fill = GridBagConstraints.HORIZONTAL;
                c.gridx = 0;
                c.gridy++;
                this.add(labelCompteCol, c);
                c.gridx++;
                c.weightx = 1;
                c.gridwidth = GridBagConstraints.REMAINDER;
                ISQLCompteSelector compteCol = new ISQLCompteSelector();
                this.add(compteCol, c);

                JLabel labelCompteDed = new JLabel(getLabelFor("ID_COMPTE_PCE_DED"), SwingConstants.RIGHT);
                c.gridx = 0;
                c.gridy++;
                c.weightx = 0;
                c.gridwidth = 1;
                c.fill = GridBagConstraints.HORIZONTAL;
                this.add(labelCompteDed, c);
                c.gridx++;
                c.weightx = 1;

                c.gridwidth = GridBagConstraints.REMAINDER;
                ISQLCompteSelector compteDed = new ISQLCompteSelector();
                this.add(compteDed, c);

                JLabel labelCompteVente = new JLabel(getLabelFor("ID_COMPTE_PCE_VENTE"), SwingConstants.RIGHT);
                c.fill = GridBagConstraints.HORIZONTAL;
                c.gridwidth = 1;
                c.gridx = 0;
                c.gridy++;
                this.add(labelCompteVente, c);
                c.gridx++;
                c.weightx = 1;
                c.gridwidth = GridBagConstraints.REMAINDER;
                ISQLCompteSelector compteVente = new ISQLCompteSelector();
                this.add(compteVente, c);

                JLabel labelCompteVenteS = new JLabel(getLabelFor("ID_COMPTE_PCE_VENTE_SERVICE"), SwingConstants.RIGHT);
                c.gridx = 0;
                c.gridy++;
                c.weightx = 0;
                c.gridwidth = 1;
                c.fill = GridBagConstraints.HORIZONTAL;
                this.add(labelCompteVenteS, c);
                c.gridx++;
                c.weightx = 1;

                c.gridwidth = GridBagConstraints.REMAINDER;
                ISQLCompteSelector compteVenteS = new ISQLCompteSelector();
                this.add(compteVenteS, c);

                JLabel labelCompteColIntra = new JLabel(getLabelFor("ID_COMPTE_PCE_COLLECTE_INTRA"), SwingConstants.RIGHT);
                c.fill = GridBagConstraints.HORIZONTAL;
                c.gridx = 0;
                c.gridy++;
                c.gridwidth = 1;
                c.weightx = 0;
                this.add(labelCompteColIntra, c);
                c.gridx++;
                c.weightx = 1;
                c.gridwidth = GridBagConstraints.REMAINDER;
                ISQLCompteSelector compteColIntra = new ISQLCompteSelector();
                this.add(compteColIntra, c);

                JLabel labelCompteDedIntra = new JLabel(getLabelFor("ID_COMPTE_PCE_DED_INTRA"), SwingConstants.RIGHT);
                c.gridx = 0;
                c.gridy++;
                c.weightx = 0;
                c.gridwidth = 1;
                c.fill = GridBagConstraints.HORIZONTAL;
                this.add(labelCompteDedIntra, c);
                c.gridx++;
                c.weightx = 1;

                c.gridwidth = GridBagConstraints.REMAINDER;
                ISQLCompteSelector compteDedIntra = new ISQLCompteSelector();
                this.add(compteDedIntra, c);

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

                this.add(createCategorieComptablePanel(), c);

                this.addSQLObject(compteCol, "ID_COMPTE_PCE_COLLECTE");
                this.addSQLObject(compteDed, "ID_COMPTE_PCE_DED");
                this.addSQLObject(compteVente, "ID_COMPTE_PCE_VENTE");
                this.addSQLObject(compteVenteS, "ID_COMPTE_PCE_VENTE_SERVICE");
                this.addSQLObject(compteColIntra, "ID_COMPTE_PCE_COLLECTE_INTRA");
                this.addSQLObject(compteDedIntra, "ID_COMPTE_PCE_DED_INTRA");

                this.addRequiredSQLObject(fieldNom, "NOM");
                this.addRequiredSQLObject(fieldTaux, "TAUX");
            }

            @Override
            public void select(SQLRowAccessor r) {
                super.select(r);
                if (r != null) {
                    this.tableCatComptable.getRowValuesTable().insertFrom(r);
                }
            }

            @Override
            public int insert(SQLRow order) {
                int id = super.insert(order);
                this.tableCatComptable.updateField("ID_TAXE", id);
                return id;
            }

            @Override
            public void update() {
                super.update();
                this.tableCatComptable.updateField("ID_TAXE", getSelectedID());
            }

            protected JPanel createCategorieComptablePanel() {
                JPanel panel = new JPanel(new GridBagLayout());
                panel.setOpaque(false);
                GridBagConstraints c = new DefaultGridBagConstraints();

                // Ajout catégorie
                c.gridwidth = 1;
                c.weightx = 0;
                c.gridy++;
                c.gridx = 0;
                panel.add(new JLabel("Ajouter la catégorie "), c);

                final ElementComboBox boxCat = new ElementComboBox();
                boxCat.init(getDirectory().getElement("CATEGORIE_COMPTABLE"));

                c.gridx++;
                panel.add(boxCat, c);

                c.fill = GridBagConstraints.NONE;
                c.gridx++;
                JButton buttonAjouter = new JButton("Ajouter");
                buttonAjouter.setOpaque(false);
                panel.add(buttonAjouter, c);
                c.gridx++;
                JButton buttonSupprimer = new JButton("Supprimer");
                buttonSupprimer.setOpaque(false);
                panel.add(buttonSupprimer, c);

                c.gridwidth = GridBagConstraints.REMAINDER;
                c.fill = GridBagConstraints.BOTH;
                c.weightx = 1;
                c.weighty = 1;
                c.gridy++;
                c.gridx = 0;
                c.fill = GridBagConstraints.BOTH;
                this.tableCatComptable.setOpaque(false);
                panel.add(this.tableCatComptable, c);

                // Listeners
                buttonAjouter.addActionListener(new ActionListener() {

                    @Override
                    public void actionPerformed(ActionEvent e) {

                        SQLRow rowCat = boxCat.getSelectedRow();
                        if (rowCat == null || rowCat.isUndefined()) {
                            return;
                        }
                        int nbRows = tableCatComptable.getModel().getRowCount();

                        for (int i = 0; i < nbRows; i++) {
                            SQLRowValues rowVals = tableCatComptable.getModel().getRowValuesAt(i);
                            int idTarif = Integer.parseInt(rowVals.getObject("ID_CATEGORIE_COMPTABLE").toString());
                            if (idTarif == rowCat.getID()) {
                                JOptionPane.showMessageDialog(null, "Impossible d'ajouter.\nLa catégorie est déjà présente dans la liste!");
                                return;
                            }
                        }

                        SQLRowValues rowVals = new SQLRowValues(Configuration.getInstance().getBase().getTable("TAXE_CATEGORIE_COMPTABLE"));
                        if (getSelectedID() > 1) {
                            rowVals.put("ID_TAXE", getSelectedID());
                        }
                        rowVals.put("ID_CATEGORIE_COMPTABLE", rowCat.getID());
                        tableCatComptable.getModel().addRow(rowVals);
                    }
                });
                buttonSupprimer.addActionListener(new ActionListener() {

                    @Override
                    public void actionPerformed(ActionEvent e) {
                        tableCatComptable.removeSelectedRow();
                    }
                });
                return panel;
            }
        };
    }

    @Override
    protected String createCode() {
        return "finance.tax";
    }
}