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.tax.element;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.model.ISQLCompteSelector;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.model.SQLDataSource;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.request.UpdateBuilder;
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.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.swing.AbstractAction;
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) {

            @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);

                // Spacer
                c.gridy++;
                c.weighty = 1;
                c.anchor = GridBagConstraints.NORTHWEST;
                this.add(new JPanel(), 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
    protected String createCode() {
        return "finance.tax";
    }
}