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

import org.openconcerto.erp.core.common.ui.DeviseNumericHTConvertorCellEditor;

import org.openconcerto.erp.core.finance.tax.model.TaxeCache;

import org.openconcerto.erp.core.sales.product.component.ReferenceArticleSQLComponent;

import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.view.list.CellDynamicModifier;

import org.openconcerto.sql.view.list.RowValuesTable;

import org.openconcerto.sql.view.list.RowValuesTableModel;

import org.openconcerto.sql.view.list.RowValuesTablePanel;

import org.openconcerto.sql.view.list.SQLTableElement;

import org.openconcerto.ui.table.NumberCellRenderer;

import org.openconcerto.utils.DecimalUtils;

import java.math.BigDecimal;

import java.util.List;

import java.util.Vector;

public class ArticleTarifTable extends RowValuesTablePanel {

    private SQLTableElement tarif;

    private SQLTable article = Configuration.getInstance().getBase().getTable("ARTICLE");

    private SQLRowValues rowValuesArticleCompile = new SQLRowValues(article);

    SQLTableElement tableElement_PrixMetrique1_VenteHT;

    ReferenceArticleSQLComponent comp;

    public ArticleTarifTable(ReferenceArticleSQLComponent comp) {

        init();

        uiInit();

        this.comp = comp;

    }

    public void setArticleValues(SQLRowAccessor articleAccessor) {

        rowValuesArticleCompile.put("VALEUR_METRIQUE_1", articleAccessor.getObject("VALEUR_METRIQUE_1"));

        rowValuesArticleCompile.put("VALEUR_METRIQUE_2", articleAccessor.getObject("VALEUR_METRIQUE_2"));

        rowValuesArticleCompile.put("VALEUR_METRIQUE_3", articleAccessor.getObject("VALEUR_METRIQUE_2"));

        rowValuesArticleCompile.put("PRIX_METRIQUE_VT_1", articleAccessor.getObject("PRIX_METRIQUE_VT_1"));

        rowValuesArticleCompile.put("PRIX_METRIQUE_VT_2", articleAccessor.getObject("PRIX_METRIQUE_VT_2"));

        rowValuesArticleCompile.put("PRIX_METRIQUE_VT_3", articleAccessor.getObject("PRIX_METRIQUE_VT_3"));

        rowValuesArticleCompile.put("ID_MODE_VENTE_ARTICLE", articleAccessor.getObject("ID_MODE_VENTE_ARTICLE"));

        rowValuesArticleCompile.put("ID_TAXE", articleAccessor.getObject("ID_TAXE"));

    }

    public void fireModification() {

        rowValuesArticleCompile.putAll(comp.getDetailsRowValues().getAbsolutelyAll());

        rowValuesArticleCompile.put("ID_TAXE", comp.getSelectedTaxe());

        int rows = getRowValuesTable().getRowCount();

        for (int i = 0; i < rows; i++) {

            SQLRowValues rowVals = getRowValuesTable().getRowValuesTableModel().getRowValuesAt(i);

            rowValuesArticleCompile.put("PRIX_METRIQUE_VT_1", rowVals.getObject("PRIX_METRIQUE_VT_1"));

            this.tableElement_PrixMetrique1_VenteHT.fireModification(rowVals);

        }

    }

    /**

     *

     */

    protected void init() {

        final SQLElement e = getSQLElement();

        final List<SQLTableElement> list = new Vector<SQLTableElement>();

        this.tarif = new SQLTableElement(e.getTable().getField("ID_TARIF"));

        this.tarif.setEditable(false);

        list.add(this.tarif);

        list.add(new SQLTableElement(e.getTable().getField("QTE")));

        // Prix de vente HT de la métrique 1

        final SQLField field = e.getTable().getField("PRIX_METRIQUE_VT_1");

        final DeviseNumericHTConvertorCellEditor editorPVHT = new DeviseNumericHTConvertorCellEditor(field);

        this.tableElement_PrixMetrique1_VenteHT = new SQLTableElement(field, BigDecimal.class);

        list.add(tableElement_PrixMetrique1_VenteHT);

        // Devise

        final SQLTableElement tableElement_Devise = new SQLTableElement(e.getTable().getField("ID_DEVISE"));

        tableElement_Devise.setEditable(false);

        list.add(tableElement_Devise);

        // TVA

        final SQLTableElement tableElement_TVA = new SQLTableElement(e.getTable().getField("ID_TAXE"));

        list.add(tableElement_TVA);

        // Prix de vente unitaire HT

        final SQLTableElement tableElement_PrixVente_HT = new SQLTableElement(e.getTable().getField("PV_HT"), BigDecimal.class);

        tableElement_PrixVente_HT.setEditable(false);

        list.add(tableElement_PrixVente_HT);

        // Prix de vente unitaire TTC

        final SQLTableElement tableElement_PrixVente_TTC = new SQLTableElement(e.getTable().getField("PV_TTC"), BigDecimal.class);

        tableElement_PrixVente_TTC.setEditable(false);

        list.add(tableElement_PrixVente_TTC);

        this.defaultRowVals = new SQLRowValues(getSQLElement().getTable());

        this.defaultRowVals.put("PRIX_METRIQUE_VT_1", BigDecimal.ZERO);

        this.defaultRowVals.put("PV_HT", BigDecimal.ZERO);

        this.defaultRowVals.put("PV_TTC", BigDecimal.ZERO);

        if (e.getTable().contains("POURCENT_REMISE")) {

            final SQLTableElement tableElementDiscount = new SQLTableElement(e.getTable().getField("POURCENT_REMISE"), BigDecimal.class) {

                @Override

                protected Object getDefaultNullValue() {

                    return BigDecimal.ZERO;

                }

            };

            tableElementDiscount.setRenderer(new NumberCellRenderer());

            list.add(tableElementDiscount);

        }

        this.model = new RowValuesTableModel(e, list, e.getTable().getField("ID_TARIF"), false, this.defaultRowVals);

        this.table = new RowValuesTable(this.model, null);

        // Calcul automatique du prix de vente unitaire HT

        tableElement_PrixMetrique1_VenteHT.addModificationListener(tableElement_PrixVente_HT);

        tableElement_PrixVente_HT.setModifier(new CellDynamicModifier() {

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                rowValuesArticleCompile.putAll(comp.getDetailsRowValues().getAbsolutelyAll());

                rowValuesArticleCompile.put("PRIX_METRIQUE_VT_1", row.getObject("PRIX_METRIQUE_VT_1"));

                Number n = (Number) rowValuesArticleCompile.getObject("ID_MODE_VENTE_ARTICLE");

                if (n.intValue() == ReferenceArticleSQLElement.A_LA_PIECE || n.intValue() <= 1) {

                    return row.getObject("PRIX_METRIQUE_VT_1");

                } else {

                    final BigDecimal prixVTFromDetails = ReferenceArticleSQLElement.getPrixVTFromDetails(rowValuesArticleCompile);

                    return prixVTFromDetails;

                }

            }

        });

        // Calcul automatique du prix de vente unitaire TTC

        tableElement_PrixVente_HT.addModificationListener(tableElement_PrixVente_TTC);

        tableElement_PrixVente_TTC.setModifier(new CellDynamicModifier() {

            @Override

            public Object computeValueFrom(SQLRowValues row, SQLTableElement source) {

                rowValuesArticleCompile.putAll(comp.getDetailsRowValues().getAbsolutelyAll());

                rowValuesArticleCompile.put("PRIX_METRIQUE_VT_1", row.getObject("PRIX_METRIQUE_VT_1"));

                BigDecimal pHT = (BigDecimal) row.getObject("PV_HT");

                Object object = row.getObject("ID_TAXE");

                int idTaux = 1;

                if (object != null) {

                    idTaux = Integer.parseInt(object.toString());

                }

                Float resultTaux = TaxeCache.getCache().getTauxFromId(idTaux);

                if (resultTaux == null) {

                    final SQLRow i = TaxeCache.getCache().getFirstTaxe();

                    rowValuesArticleCompile.put("ID_TAXE", i.getID());

                    resultTaux = i.getFloat("TAUX");

                }

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

                editorPVHT.setTaxe(taux);

                BigDecimal r = pHT.multiply(BigDecimal.valueOf(taux).divide(BigDecimal.valueOf(100)).add(BigDecimal.ONE), DecimalUtils.HIGH_PRECISION);

                return r.setScale(tableElement_PrixVente_TTC.getDecimalDigits(), BigDecimal.ROUND_HALF_UP);

            }

        });

    }

    public SQLElement getSQLElement() {

        return Configuration.getInstance().getDirectory().getElement("ARTICLE_TARIF");

    }

}