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

import org.openconcerto.sql.model.FieldPath;

import org.openconcerto.sql.model.graph.Path;

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

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

import org.openconcerto.sql.view.list.IListeAction.IListeEvent;

import org.openconcerto.ui.table.PercentTableCellRenderer;

import org.openconcerto.utils.CollectionUtils;

import org.openconcerto.utils.DecimalUtils;

import java.math.BigDecimal;

import java.math.RoundingMode;

import java.util.Collection;

        l.add("DATE_REGLEMENT");

    @Override

    protected void _initTableSource(SQLTableModelSource res) {

        super._initTableSource(res);

        final BaseSQLTableModelColumn colAvancement = new BaseSQLTableModelColumn("Avancement réglement", BigDecimal.class) {

            @Override

            protected Object show_(SQLRowAccessor r) {

                return getAvancement(r);

            }

            @Override

            public Set<FieldPath> getPaths() {

                Path p = new Path(getTable());

                p = p.add(getTable().getTable("ECHEANCE_FOURNISSEUR"));

                Path p2 = new Path(getTable());

                p2 = p2.add(getTable().getField("ID_AVOIR_FOURNISSEUR"));

                return CollectionUtils.createSet(new FieldPath(p, "MONTANT"), new FieldPath(p, "REG_COMPTA"), new FieldPath(p, "REGLE"), new FieldPath(p2, "MONTANT_TTC"));

            }

        };

        res.getColumns().add(colAvancement);

        colAvancement.setRenderer(new PercentTableCellRenderer());

    }

    private BigDecimal getAvancement(SQLRowAccessor r) {

        Collection<? extends SQLRowAccessor> rows = r.getReferentRows(r.getTable().getTable("ECHEANCE_FOURNISSEUR"));

        long totalEch = 0;

        for (SQLRowAccessor row : rows) {

            if (!row.getBoolean("REGLE") && !row.getBoolean("REG_COMPTA")) {

                totalEch += row.getLong("MONTANT");

            }

        }

        SQLRowAccessor avoir = r.getForeign("ID_AVOIR_FOURNISSEUR");

        BigDecimal avoirTTC = BigDecimal.ZERO;

        if (avoir != null && !avoir.isUndefined()) {

            avoirTTC = new BigDecimal(avoir.getLong("MONTANT_TTC"));

        }

        final BigDecimal totalAregler = new BigDecimal(r.getLong("T_TTC")).subtract(avoirTTC);

        if (totalAregler.signum() > 0 && totalEch > 0) {

            return totalAregler.subtract(new BigDecimal(totalEch)).divide(totalAregler, DecimalUtils.HIGH_PRECISION).movePointRight(2).setScale(2, RoundingMode.HALF_UP);

        } else {

            return BigDecimal.ONE.movePointRight(2);

        }

    }