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.account;

import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;

import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable.TypeCalcul;

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

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

import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureSQLElement;

import org.openconcerto.erp.core.sales.invoice.ui.FactureSituationItemTable;

import org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater;

import org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater.TypeStockUpdate;

import org.openconcerto.erp.core.supplychain.stock.element.StockLabel;

import org.openconcerto.erp.preferences.GestionArticleGlobalPreferencePanel;

import org.openconcerto.sql.element.GlobalMapper;

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.preferences.SQLPreferences;

import org.openconcerto.ui.group.Group;

import org.openconcerto.utils.DecimalUtils;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.Tuple2;

import java.math.BigDecimal;

import java.math.RoundingMode;

import java.sql.SQLException;

import java.util.Collection;

import java.util.Date;

import java.util.HashSet;

import java.util.List;

import java.util.Set;

import javax.swing.JCheckBox;

public class VenteFactureSoldeSQLComponent extends VenteFactureSituationSQLComponent {

    public static final String ID = "sales.invoice.partial.balance";

    public VenteFactureSoldeSQLComponent(SQLElement element) {

        super(element, (Group) GlobalMapper.getInstance().get(ID));

    }

    @Override

    protected void addViews() {

        super.addViews();

        getEditor("sales.invoice.partial.amount").setEnabled(false);

        JCheckBox box = new JCheckBox("Solde");

        box.setSelected(true);

        this.addView(box, "SOLDE");

    }

    @Override

    protected SQLRowValues createDefaults() {

        SQLRowValues rowVals = new SQLRowValues(getTable());

        rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(SaisieVenteFactureSQLElement.class, new Date()));

        rowVals.put("SOLDE", Boolean.TRUE);

        return rowVals;

    }

    @Override

    public int insert(SQLRow order) {

        int id = super.insert(order);

        try {

            updateStock(id);

        } catch (SQLException e) {

            ExceptionHandler.handle("Erreur lors de la mise à jour du stock.", e);

            e.printStackTrace();

        }

        return id;

    }

    @Override

    public void update() {

        super.update();

        try {

            updateStock(getSelectedID());

        } catch (SQLException e) {

            ExceptionHandler.handle("Erreur lors de la mise à jour du stock.", e);

            e.printStackTrace();

        }

    }

    @Override

    public void importFrom(List<SQLRowValues> rows) {

        super.importFrom(rows);

        AcompteField field = (AcompteField) getEditor("sales.invoice.partial.amount");

        Tuple2<Long, Long> t = getTotalFacture(rows);

        // final Acompte a = new Acompte(null, new BigDecimal(t.get0() -

        // t.get1()).movePointLeft(2));

        // field.setValue(a);

        final BigDecimal percent = BigDecimal.ONE.subtract(new BigDecimal(t.get1()).divide(new BigDecimal(t.get0()), DecimalUtils.HIGH_PRECISION).setScale(6, RoundingMode.HALF_UP));

        final Acompte a = new Acompte(percent.movePointRight(2), null);

        field.setValue(a);

        final FactureSituationItemTable table = ((FactureSituationItemTable) getEditor("sales.invoice.partial.items.list"));

        table.calculPourcentage(a, TypeCalcul.CALCUL_FACTURABLE);

    }

    public Tuple2<Long, Long> getTotalFacture(List<SQLRowValues> context) {

        long totalFacture = 0;

        long totalCommande = 0;

        Set<SQLRowAccessor> facture = new HashSet<SQLRowAccessor>();

        for (SQLRowAccessor sqlRowAccessor : context) {

            totalFacture += getFacture(sqlRowAccessor, facture);

            totalCommande += sqlRowAccessor.getLong("T_HT");

        }

        return Tuple2.create(totalCommande, totalFacture);

    }

    public long getFacture(SQLRowAccessor sqlRowAccessor, Set<SQLRowAccessor> alreadyAdded) {

        Collection<? extends SQLRowAccessor> rows = sqlRowAccessor.getReferentRows(sqlRowAccessor.getTable().getTable("TR_COMMANDE_CLIENT"));

        long l = 0;

        for (SQLRowAccessor sqlRowAccessor2 : rows) {

            if (!sqlRowAccessor2.isForeignEmpty("ID_SAISIE_VENTE_FACTURE")) {

                SQLRowAccessor rowFacture = sqlRowAccessor2.getForeign("ID_SAISIE_VENTE_FACTURE");

                if (!alreadyAdded.contains(rowFacture)) {

                    alreadyAdded.add(rowFacture);

                    l += rowFacture.getLong("T_HT");

                }

            }

        }

        return l;

    }

    protected String getLibelleStock(SQLRowAccessor row, SQLRowAccessor rowElt) {

        return "Saisie vente facture N°" + row.getString("NUMERO");

    }

    /**

     * Mise à jour des stocks pour chaque article composant la facture

     *

     * @throws SQLException

     */

    private void updateStock(int id) throws SQLException {

        SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());

        if (prefs.getBoolean(GestionArticleGlobalPreferencePanel.STOCK_FACT, true)) {

            SQLRow row = getTable().getRow(id);

            StockItemsUpdater stockUpdater = new StockItemsUpdater(new StockLabel() {

                @Override

                public String getLabel(SQLRowAccessor rowOrigin, SQLRowAccessor rowElt) {

                    return getLibelleStock(rowOrigin, rowElt);

                }

            }, row, row.getReferentRows(getTable().getTable("SAISIE_VENTE_FACTURE_ELEMENT")),

                    getTable().contains("CREATE_VIRTUAL_STOCK") && row.getBoolean("CREATE_VIRTUAL_STOCK") ? TypeStockUpdate.REAL_VIRTUAL_DELIVER : TypeStockUpdate.REAL_DELIVER);

            stockUpdater.update();

        }

    }

    // @Override

    // public Component addView(MutableRowItemView rowItemView, String fields, Object specObj) {

    //

    // if (fields.contains("ID_POLE_PRODUIT") && countPole == 0) {

    // countPole++;

    // return null;

    // } else {

    // return super.addView(rowItemView, fields, specObj);

    // }

    // }

}