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.sales.product.element;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.finance.tax.model.TaxeCache;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.utils.DecimalUtils;
import org.openconcerto.utils.StringUtils;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.event.DocumentEvent;

public class ArticleTarifSQLElement extends ComptaSQLConfElement {

    public ArticleTarifSQLElement() {
        super("ARTICLE_TARIF", "un tarif d'article", "tarifs d'article");
    }

    protected List<String> getListFields() {
        final List<String> l = new ArrayList<String>();
        l.add("ID_TARIF");
        l.add("ID_ARTICLE");
        l.add("QTE");
        l.add("PV_HT");
        l.add("PV_TTC");
        return l;
    }

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

    @Override
    protected String getParentFFName() {
        return "ID_ARTICLE";
    }

    @Override
    public Set<String> getInsertOnlyFields() {
        Set<String> req = new HashSet<>();
        req.add("ID_TARIF");
        req.add("ID_ARTICLE");
        return req;
    }

    @Override
    public Set<String> getReadOnlyFields() {
        Set<String> ro = new HashSet<>();
        ro.add("PV_HT");
        ro.add("PV_TTC");
        return ro;
    }

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

            public void addViews() {
                this.setLayout(new GridBagLayout());
                final GridBagConstraints c = new DefaultGridBagConstraints();

                c.gridx = 0;
                c.weightx = 0;
                // Nom
                this.add(new JLabel(getLabelFor("ID_TARIF")), c);
                c.gridx++;
                c.weightx = 1;
                final SQLRequestComboBox tarifCombo = new SQLRequestComboBox();
                this.add(tarifCombo, c);
                this.addRequiredSQLObject(tarifCombo, "ID_TARIF");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                this.add(new JLabel(getLabelFor("ID_ARTICLE")), c);
                c.gridx++;
                c.weightx = 1;
                final SQLRequestComboBox artCombo = new SQLRequestComboBox();
                this.add(artCombo, c);
                this.addRequiredSQLObject(artCombo, "ID_ARTICLE");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                JLabel labelQTE = new JLabel(getLabelFor("QTE"));
                JTextField textQTE = new JTextField();
                this.add(labelQTE, c);
                c.gridx++;
                c.weightx = 1;
                this.add(textQTE, c);
                this.addRequiredSQLObject(textQTE, "QTE");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                JLabel labelRemise = new JLabel(getLabelFor("POURCENT_REMISE"));
                JTextField textRemise = new JTextField();
                this.add(labelRemise, c);
                c.gridx++;
                c.weightx = 1;
                this.add(textRemise, c);
                this.addSQLObject(textRemise, "POURCENT_REMISE");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                // Nom
                JLabel labelPVM = new JLabel(getLabelFor("PRIX_METRIQUE_VT_1"));
                JTextField textPVM = new JTextField();
                this.add(labelPVM, c);
                c.gridx++;
                c.weightx = 1;
                this.add(textPVM, c);
                this.addSQLObject(textPVM, "PRIX_METRIQUE_VT_1");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                JLabel labelPV = new JLabel(getLabelFor("PV_HT"));
                final JTextField textPV = new JTextField();
                this.add(labelPV, c);
                c.gridx++;
                c.weightx = 1;
                this.add(textPV, c);
                this.addSQLObject(textPV, "PV_HT");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                this.add(new JLabel(getLabelFor("ID_TAXE")), c);
                c.gridx++;
                c.weightx = 1;
                final SQLRequestComboBox taxeCombo = new SQLRequestComboBox();
                this.add(taxeCombo, c);
                this.addSQLObject(taxeCombo, "ID_TAXE");

                c.gridy++;
                c.gridx = 0;
                c.weightx = 0;
                // Nom
                JLabel labelPVTTC = new JLabel(getLabelFor("PV_TTC"));
                final JTextField textTTC = new JTextField();
                this.add(labelPVTTC, c);
                c.gridx++;
                c.weightx = 1;
                this.add(textTTC, c);
                this.addSQLObject(textTTC, "PV_TTC");

                textPVM.getDocument().addDocumentListener(new org.openconcerto.utils.text.SimpleDocumentListener() {
                    @Override
                    public void update(DocumentEvent e) {

                        final BigDecimal ht = StringUtils.getBigDecimalFromUserText(textPVM.getText());

                        if (ht != null) {

                            SQLRowAccessor rTaxe = taxeCombo.getSelectedRowAccessor();
                            if (rTaxe == null || rTaxe.isUndefined()) {
                                SQLRowAccessor a = artCombo.getSelectedRowAccessor();
                                if (a != null && !a.isUndefined()) {
                                    rTaxe = a.asRow().fetchNewRow().getForeignRow("ID_TAXE");
                                }
                                if (rTaxe == null || rTaxe.isUndefined()) {
                                    rTaxe = TaxeCache.getCache().getFirstTaxe();
                                }
                            }

                            Float resultTaux = TaxeCache.getCache().getTauxFromId(rTaxe.getID());

                            if (resultTaux == null) {
                                final SQLRow i = TaxeCache.getCache().getFirstTaxe();
                                resultTaux = i.getFloat("TAUX");
                            }

                            float taux = (resultTaux == null) ? 0.0F : resultTaux.floatValue();

                            BigDecimal r = ht.multiply(BigDecimal.valueOf(taux).divide(BigDecimal.valueOf(100)).add(BigDecimal.ONE), DecimalUtils.HIGH_PRECISION);
                            textPV.setText(textPVM.getText());
                            textTTC.setText(r.setScale(2, RoundingMode.HALF_UP).toString());
                        } else {
                            textPV.setText("");
                            textTTC.setText("");
                        }
                    }
                });

            }
        };
    }

    @Override
    public SQLRowValues createDefaultRowValues(String token) {

        SQLRowValues rowVals = super.createDefaultRowValues(token);
        rowVals.put("QTE", 1);
        return rowVals;
    }

    @Override
    protected String createCode() {
        return createCodeOfPackage() + ".price";
    }
}