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.supplychain.order.action;

import org.openconcerto.erp.action.CreateFrameAbstractAction;
import org.openconcerto.erp.core.common.ui.IListFilterDatePanel;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.FieldPath;
import org.openconcerto.sql.model.SQLField;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.graph.Path;
import org.openconcerto.sql.model.graph.PathBuilder;
import org.openconcerto.sql.view.IListFrame;
import org.openconcerto.sql.view.ListeAddPanel;
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.SQLTableModelSourceOnline;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.table.PercentTableCellRenderer;
import org.openconcerto.utils.CollectionUtils;
import org.openconcerto.utils.DecimalUtils;

import java.awt.GridBagConstraints;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.Collection;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;

import javax.swing.Action;
import javax.swing.JFrame;

public class ListeDesCommandesAction extends CreateFrameAbstractAction {
    public ListeDesCommandesAction() {
        super();
        this.putValue(Action.NAME, "Liste des commandes fournisseurs");
    }

    public JFrame createFrame() {

        final SQLElement elementCmd = Configuration.getInstance().getDirectory().getElement("COMMANDE");
        final SQLTableModelSourceOnline tableSource = elementCmd.getTableSource(true);
        BaseSQLTableModelColumn colAvancementR = new BaseSQLTableModelColumn("Avancement réception", BigDecimal.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                return getAvancementLFromBR(r);
            }

            @Override
            public Set<FieldPath> getPaths() {
                final Path p = new PathBuilder(elementCmd.getTable()).addTable("COMMANDE_ELEMENT").build();
                return CollectionUtils.createSet(new FieldPath(p, "RECU_FORCED"), new FieldPath(p, "RECU"), new FieldPath(p, "QTE_RECUE"), new FieldPath(p, "PA_HT"), new FieldPath(p, "ID_ARTICLE"),
                        new FieldPath(p, "QTE"), new FieldPath(p, "QTE_UNITAIRE"));
            }
        };
        tableSource.getColumns().add(colAvancementR);
        colAvancementR.setRenderer(new PercentTableCellRenderer());

        BaseSQLTableModelColumn colAvancement = new BaseSQLTableModelColumn("Avancement facturation", BigDecimal.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                return getAvancementFact(r);
            }

            @Override
            public Set<FieldPath> getPaths() {
                final Path p = new PathBuilder(elementCmd.getTable()).addTable("TR_COMMANDE").addTable("SAISIE_ACHAT").build();
                final Path p2 = new PathBuilder(elementCmd.getTable()).addTable("TR_COMMANDE").addTable("FACTURE_FOURNISSEUR").build();

                final Path pBr = new PathBuilder(elementCmd.getTable()).addTable("TR_COMMANDE").addTable("BON_RECEPTION").build();
                final Path trBr = pBr.add(elementCmd.getTable().getTable("TR_BON_RECEPTION"));
                final Path pFact2 = trBr.addTable("FACTURE_FOURNISSEUR");
                final Path pAchat2 = trBr.addTable("SAISIE_ACHAT");
                return CollectionUtils.createSet(new FieldPath(p, "MONTANT_HT"), new FieldPath(p2, "T_HT"), new FieldPath(pAchat2, "MONTANT_HT"), new FieldPath(pFact2, "T_HT"));
            }
        };
        tableSource.getColumns().add(colAvancement);
        colAvancement.setRenderer(new PercentTableCellRenderer());

        final ListeAddPanel panel = new ListeAddPanel(elementCmd, new IListe(tableSource));
        // Date panel
        Map<IListe, SQLField> map = new HashMap<IListe, SQLField>();
        map.put(panel.getListe(), elementCmd.getTable().getField("DATE"));

        IListFilterDatePanel datePanel = new IListFilterDatePanel(map, IListFilterDatePanel.getDefaultMap());
        GridBagConstraints c = new DefaultGridBagConstraints();
        c.weightx = 0;
        c.fill = GridBagConstraints.NONE;
        c.gridy = 4;
        c.anchor = GridBagConstraints.CENTER;
        c.weighty = 0;
        datePanel.setFilterOnDefault();
        panel.add(datePanel, c);
        final IListFrame frame = new IListFrame(panel);

        return frame;
    }

    private BigDecimal getAvancementLFromBR(SQLRowAccessor r) {
        Collection<? extends SQLRowAccessor> rows = r.getReferentRows(r.getTable().getTable("COMMANDE_ELEMENT"));
        BigDecimal totalQte = BigDecimal.ZERO;
        BigDecimal totalQteL = BigDecimal.ZERO;
        for (SQLRowAccessor row : rows) {
            BigDecimal qte = row.getBigDecimal("QTE_UNITAIRE").multiply(new BigDecimal(row.getInt("QTE")));
            // On ne prend en compte que les articles ou les lignes différentes de 0
            if (!row.isForeignEmpty("ID_ARTICLE") || row.getBigDecimal("PA_HT").signum() != 0) {
                totalQte = totalQte.add(qte);
                if (row.getBoolean("RECU_FORCED") || row.getBoolean("RECU")) {
                    totalQteL = totalQteL.add(qte);
                } else if (row.getBigDecimal("QTE_RECUE") != null) {
                    final BigDecimal qteLivree = row.getBigDecimal("QTE_RECUE");
                    if (qteLivree != null) {
                        totalQteL = totalQteL.add(qteLivree);
                    }
                }
            }
        }
        if (totalQte.signum() != 0) {
            return totalQteL.divide(totalQte, DecimalUtils.HIGH_PRECISION).movePointRight(2).setScale(2, RoundingMode.HALF_UP);
        } else {
            return BigDecimal.ONE.movePointRight(2);
        }
    }

    BigDecimal bigDecimal100 = new BigDecimal(100.0);

    private BigDecimal getAvancementFact(SQLRowAccessor r) {
        Collection<? extends SQLRowAccessor> rows = r.getReferentRows(r.getTable().getTable("TR_COMMANDE"));
        long totalFact = 0;
        long total = r.getLong("T_HT");
        for (SQLRowAccessor row : rows) {
            if (!row.isForeignEmpty("ID_FACTURE_FOURNISSEUR")) {
                SQLRowAccessor rowFact = row.getForeign("ID_FACTURE_FOURNISSEUR");
                Long l = rowFact.getLong("T_HT");
                totalFact += l;
            }
            if (!row.isForeignEmpty("ID_SAISIE_ACHAT")) {
                SQLRowAccessor rowFact = row.getForeign("ID_SAISIE_ACHAT");
                Long l = rowFact.getLong("MONTANT_HT");
                totalFact += l;
            }

            if (!row.isForeignEmpty("ID_BON_RECEPTION")) {
                Collection<? extends SQLRowAccessor> rowsBr = row.getForeign("ID_BON_RECEPTION").getReferentRows(r.getTable().getTable("TR_BON_RECEPTION"));
                for (SQLRowAccessor rowTrBr : rowsBr) {
                    if (!rowTrBr.isForeignEmpty("ID_FACTURE_FOURNISSEUR")) {
                        SQLRowAccessor rowFact = rowTrBr.getForeign("ID_FACTURE_FOURNISSEUR");
                        Long l = rowFact.getLong("T_HT");
                        totalFact += l;
                    }
                    if (!rowTrBr.isForeignEmpty("ID_SAISIE_ACHAT")) {
                        SQLRowAccessor rowFact = rowTrBr.getForeign("ID_SAISIE_ACHAT");
                        Long l = rowFact.getLong("MONTANT_HT");
                        totalFact += l;
                    }

                }
            }
        }

        if (total > 0) {
            return this.bigDecimal100.min(new BigDecimal(totalFact).divide(new BigDecimal(total), DecimalUtils.HIGH_PRECISION).movePointRight(2).setScale(2, RoundingMode.HALF_UP));
        } else {
            return BigDecimal.ONE.movePointRight(2);
        }
    }

    private BigDecimal getAvancement(SQLRowAccessor r) {
        Collection<? extends SQLRowAccessor> rows = r.getReferentRows(r.getTable().getTable("TR_COMMANDE"));
        long totalFact = 0;
        long total = r.getLong("T_HT");
        for (SQLRowAccessor row : rows) {
            if (!row.isForeignEmpty("ID_BON_RECEPTION")) {
                SQLRowAccessor rowFact = row.getForeign("ID_BON_RECEPTION");
                Long l = rowFact.getLong("TOTAL_HT");
                totalFact += l;
            }
        }
        if (total > 0) {
            return new BigDecimal(totalFact).divide(new BigDecimal(total), DecimalUtils.HIGH_PRECISION).movePointRight(2).setScale(2, RoundingMode.HALF_UP);
        } else {
            return BigDecimal.ONE.movePointRight(2);
        }
    }

}