WebSVN - OpenConcerto - Rev 185 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/order/action/ListeDesElementsACommanderClientAction.java

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

import org.openconcerto.erp.action.CreateIListFrameAbstractAction;
import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.core.common.ui.IListFilterDatePanel;
import org.openconcerto.erp.core.common.ui.ListeViewPanel;
import org.openconcerto.erp.core.common.ui.NumberCellRenderer;
import org.openconcerto.erp.core.sales.order.element.CommandeClientElementSQLElement;
import org.openconcerto.erp.core.sales.product.ui.QteAcommanderRenderer;
import org.openconcerto.erp.core.supplychain.stock.action.ListeDesStocksAction;
import org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement;
import org.openconcerto.erp.preferences.GestionArticleGlobalPreferencePanel;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.FieldPath;
import org.openconcerto.sql.model.FieldRef;
import org.openconcerto.sql.model.SQLName;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLSelectJoin;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.model.graph.Path;
import org.openconcerto.sql.preferences.SQLPreferences;
import org.openconcerto.sql.view.IListFrame;
import org.openconcerto.sql.view.IListPanel;
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
import org.openconcerto.sql.view.list.SQLTableModelSource;
import org.openconcerto.sql.view.list.SQLTableModelSourceOnline;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.FrameUtil;
import org.openconcerto.utils.CollectionUtils;
import org.openconcerto.utils.DecimalUtils;
import org.openconcerto.utils.cc.ITransformer;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.Collection;
import java.util.List;
import java.util.Set;

import javax.swing.AbstractAction;
import javax.swing.JPanel;

public class ListeDesElementsACommanderClientAction extends CreateIListFrameAbstractAction<CommandeClientElementSQLElement> {

    public ListeDesElementsACommanderClientAction(final ComptaPropsConfiguration conf) {
        super(conf, CommandeClientElementSQLElement.class);
    }

    @Override
    protected String getPanelVariant() {
        return this.getClass().getSimpleName();
    }

    @Override
    protected SQLTableModelSource createTableSource() {
        final SQLTableModelSource tableSource = super.createTableSource();
        final CommandeClientElementSQLElement eltCmd = getElem();
        tableSource.getReq().setSelectTransf(new ITransformer<SQLSelect, SQLSelect>() {

            @Override
            public SQLSelect transformChecked(SQLSelect input) {
                // new SQLName(eltCmd.getTable().getDBRoot().getName(),
                // tableBLElement.getName()).quote()
                final String quoteQteL = new SQLName(input.getAlias(eltCmd.getTable()).getAlias(), "QTE_LIVREE").quote();
                final String quoteQte = new SQLName(input.getAlias(eltCmd.getTable()).getAlias(), "QTE").quote();
                final String quoteQteU = new SQLName(input.getAlias(eltCmd.getTable()).getAlias(), "QTE_UNITAIRE").quote();
                Where w = Where.createRaw(quoteQteL + " < (" + quoteQte + "*" + quoteQteU + ")", eltCmd.getTable().getField("QTE_LIVREE"), eltCmd.getTable().getField("QTE"),
                        eltCmd.getTable().getField("QTE_UNITAIRE")).or(Where.isNull(input.getAlias(eltCmd.getTable()).getField("QTE_LIVREE")));
                w = w.and(new Where(eltCmd.getTable().getField("LIVRE_FORCED"), "=", Boolean.FALSE));
                input.setWhere(w);
                return input;
            }
        });

        SQLPreferences prefs = SQLPreferences.getMemCached(eltCmd.getTable().getDBRoot());
        if (prefs.getBoolean(GestionArticleGlobalPreferencePanel.STOCK_MULTI_DEPOT, false)) {
            BaseSQLTableModelColumn colStockD = new BaseSQLTableModelColumn("Dépôt", String.class) {

                @Override
                protected Object show_(SQLRowAccessor r) {

                    final SQLRowAccessor foreign = r.getForeign("ID_ARTICLE");
                    if (foreign != null && !foreign.isUndefined()) {
                        SQLRowAccessor foreign2 = StockSQLElement.getStockFetched(r);
                        if (foreign2 != null && !foreign2.isUndefined()) {
                            return foreign2.getForeign("ID_DEPOT_STOCK").getString("NOM");
                        }
                    }
                    return "";
                }

                @Override
                public Set<FieldPath> getPaths() {
                    Path p = new Path(eltCmd.getTable());
                    p = p.add(p.getLast().getField("ID_ARTICLE"));
                    Path p2 = p.add(p.getLast().getTable("STOCK").getField("ID_ARTICLE"));
                    Path p3 = p2.add(p2.getLast().getField("ID_DEPOT_STOCK"));
                    Path p4 = p.add(p.getLast().getField("ID_DEPOT_STOCK"));
                    return CollectionUtils.createSet(new FieldPath(p3, "NOM"), new FieldPath(p4, "NOM"));
                }
            };
            tableSource.getColumns().add(colStockD);
        }
        BaseSQLTableModelColumn colStockR = new BaseSQLTableModelColumn("Stock Reel", Float.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                final SQLRowAccessor foreign = r.getForeign("ID_ARTICLE");

                if (foreign != null && !foreign.isUndefined()) {
                    if (foreign.getBoolean("GESTION_STOCK")) {
                        SQLRowAccessor foreign2 = StockSQLElement.getStockFetched(r);
                        if (foreign2 != null && !foreign2.isUndefined()) {
                            return foreign2.getFloat("QTE_REEL");
                        }
                    }
                }
                return null;
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(eltCmd.getTable());
                p = p.add(p.getLast().getField("ID_ARTICLE"));
                Path p2 = p.add(p.getLast().getTable("STOCK").getField("ID_ARTICLE"));
                return CollectionUtils.createSet(new FieldPath(p, "ID_DEPOT_STOCK"), new FieldPath(p2, "QTE_REEL"), new FieldPath(p2, "ID_DEPOT_STOCK"));
            }
        };
        tableSource.getColumns().add(colStockR);

        BaseSQLTableModelColumn colLiv2 = new BaseSQLTableModelColumn("Stock TH", Float.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                final SQLRowAccessor foreign = r.getForeign("ID_ARTICLE");
                if (foreign != null && !foreign.isUndefined()) {
                    if (foreign.getBoolean("GESTION_STOCK")) {

                        SQLRowAccessor foreign2 = StockSQLElement.getStockFetched(r);
                        if (foreign2 != null && !foreign2.isUndefined()) {
                            return foreign2.getFloat("QTE_TH");
                        }
                    }
                }
                return null;
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(eltCmd.getTable());
                p = p.add(p.getLast().getField("ID_ARTICLE"));
                Path p2 = p.add(p.getLast().getTable("STOCK").getField("ID_ARTICLE"));
                return CollectionUtils.createSet(new FieldPath(p, "ID_DEPOT_STOCK"), new FieldPath(p2, "QTE_TH"), new FieldPath(p2, "ID_DEPOT_STOCK"));
            }
        };
        tableSource.getColumns().add(colLiv2);

        BaseSQLTableModelColumn colStockMin = new BaseSQLTableModelColumn("Stock Min", Float.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                final SQLRowAccessor foreign = r.getForeign("ID_ARTICLE");
                if (foreign != null && !foreign.isUndefined()) {
                    if (foreign.getBoolean("GESTION_STOCK")) {

                        SQLRowAccessor foreign2 = StockSQLElement.getStockFetched(r);
                        if (foreign2 != null && !foreign2.isUndefined()) {
                            return foreign2.getFloat("QTE_MIN");
                        }
                    }
                }
                return null;
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(eltCmd.getTable());
                p = p.add(p.getLast().getField("ID_ARTICLE"));
                Path p2 = p.add(p.getLast().getTable("STOCK").getField("ID_ARTICLE"));
                return CollectionUtils.createSet(new FieldPath(p, "ID_DEPOT_STOCK"), new FieldPath(p2, "QTE_MIN"), new FieldPath(p2, "ID_DEPOT_STOCK"));
            }
        };
        tableSource.getColumns().add(colStockMin);

        BaseSQLTableModelColumn colSug = new BaseSQLTableModelColumn("Qtè à commander", Float.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                final SQLRowAccessor foreign = r.getForeign("ID_ARTICLE");
                if (foreign != null && !foreign.isUndefined()) {
                    if (foreign.getBoolean("GESTION_STOCK")) {

                        SQLRowAccessor foreign2 = StockSQLElement.getStockFetched(r);
                        if (foreign2 != null && !foreign2.isUndefined()) {
                            float qteMin = foreign2.getFloat("QTE_MIN");
                            float manque = foreign2.getFloat("QTE_TH") - qteMin;
                            if (manque < 0) {
                                return -manque;
                            } else {
                                return 0f;
                            }
                        }
                    }
                }
                return r.getBigDecimal("QTE_UNITAIRE").multiply(new BigDecimal(r.getInt("QTE"))).floatValue();

            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(eltCmd.getTable());
                p = p.add(p.getLast().getField("ID_ARTICLE"));
                Path p2 = p.add(p.getLast().getTable("STOCK").getField("ID_ARTICLE"));
                return CollectionUtils.createSet(new FieldPath(p, "ID_DEPOT_STOCK"), new FieldPath(p2, "QTE_TH"), new FieldPath(p2, "QTE_MIN"), new FieldPath(p2, "ID_DEPOT_STOCK"));
            }
        };
        tableSource.getColumns().add(colSug);
        colSug.setRenderer(new QteAcommanderRenderer());

        return tableSource;
    }

    private BigDecimal getAvancementLFromBL(SQLRowAccessor r) {
        Collection<? extends SQLRowAccessor> rows = r.getReferentRows(r.getTable().getTable("COMMANDE_CLIENT_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")));
            totalQte = totalQte.add(qte);
            if (row.getBoolean("LIVRE_FORCED") || row.getBoolean("LIVRE")) {
                totalQteL = totalQteL.add(qte);
            } else {
                totalQteL = totalQteL.add(row.getBigDecimal("QTE_LIVREE"));
            }
        }
        if (totalQte.signum() != 0) {
            return totalQteL.divide(totalQte, DecimalUtils.HIGH_PRECISION).movePointRight(2).setScale(2, RoundingMode.HALF_UP);
        } else {
            return BigDecimal.ONE.movePointRight(2);
        }
    }

    @Override
    protected IListPanel instantiateListPanel(SQLTableModelSource tableSource, String panelVariant) {
        final IListPanel panel = super.instantiateListPanel(tableSource, panelVariant);
        final CommandeClientElementSQLElement eltCmd = getElem();
        // final List<Tuple2<? extends SQLTableModelColumn, IListTotalPanel.Type>> fields = new
        // ArrayList<Tuple2<? extends SQLTableModelColumn, IListTotalPanel.Type>>(2);
        // fields.add(Tuple2.create(panel.getListe().getSource().getColumn(eltCmd.getTable().getField("T_HT")),
        // IListTotalPanel.Type.SOMME));
        // fields.add(Tuple2.create(this.colAvancement, IListTotalPanel.Type.AVANCEMENT_TTC));
        // final IListTotalPanel totalPanel = new IListTotalPanel(panel.getListe(), fields, null,
        // "Total des commandes de la liste");

        final GridBagConstraints c = new DefaultGridBagConstraints();
        c.gridwidth = GridBagConstraints.REMAINDER;
        c.fill = GridBagConstraints.BOTH;
        c.anchor = GridBagConstraints.EAST;
        c.weightx = 1;
        c.gridy = 4;

        // Date panel
        final IListFilterDatePanel datePanel = new IListFilterDatePanel(panel.getListe(), eltCmd.getTable().getForeignTable("ID_COMMANDE_CLIENT").getField("DATE"),
                IListFilterDatePanel.getDefaultMap());

        datePanel.setFilterOnDefault();

        final JPanel bottomPanel = new JPanel();
        bottomPanel.setLayout(new GridBagLayout());
        bottomPanel.setOpaque(false);
        final GridBagConstraints c2 = new DefaultGridBagConstraints();
        c2.fill = GridBagConstraints.NONE;
        c2.weightx = 1;
        bottomPanel.add(datePanel, c2);

        // c2.gridx++;
        // c2.weightx = 0;
        // c2.anchor = GridBagConstraints.EAST;
        // bottomPanel.add(totalPanel, c2);

        panel.add(bottomPanel, c);

        PredicateRowAction action = new PredicateRowAction(new AbstractAction("Calcul des besoins") {

            @Override
            public void actionPerformed(ActionEvent e) {

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

                if (prefs.getBoolean(GestionArticleGlobalPreferencePanel.STOCK_MULTI_DEPOT, false)) {
                    ListeDesStocksAction action = new ListeDesStocksAction(true);
                    FrameUtil.show(action.createFrame());
                } else {

                    final SQLElement artElt = eltCmd.getForeignElement("ID_ARTICLE");
                    final SQLTableModelSourceOnline createTableSource = artElt.createTableSource();
                    createTableSource.getReq().setSelectTransf(new ITransformer<SQLSelect, SQLSelect>() {
                        @Override
                        public SQLSelect transformChecked(SQLSelect input) {
                            FieldRef refStock = input.getAlias(artElt.getTable().getForeignTable("ID_STOCK").getField("QTE_TH"));
                            FieldRef refStockMin = input.getAlias(artElt.getTable().getForeignTable("ID_STOCK").getField("QTE_MIN"));

                            SQLSelectJoin j = input.getJoinFromField(artElt.getTable().getTable("ARTICLE_ELEMENT").getField("ID_ARTICLE_PARENT"));
                            if (j == null) {
                                j = input.addBackwardJoin("LEFT", artElt.getTable().getTable("ARTICLE_ELEMENT").getField("ID_ARTICLE_PARENT"), null);
                            }

                            Where w = new Where(refStock, "<", refStockMin);
                            w = w.and(new Where(j.getJoinedTable().getKey(), "=", (Object) null));
                            input.setWhere(w);
                            // input.setHaving(Where.createRaw("COUNT(\"" +
                            // j.getJoinedTable().getKey()
                            // + "\")" + " = 0", Arrays.asList(j.getJoinedTable().getKey())));
                            return input;
                        }
                    });

                    IListe listeArt = new IListe(createTableSource);
                    final PredicateRowAction predicateACtion = new PredicateRowAction(new AbstractAction("Passer une commande fournisseur") {

                        @Override
                        public void actionPerformed(ActionEvent e) {
                            List<SQLRowAccessor> selectedRows = IListe.get(e).getSelectedRowAccessors();
                            eltCmd.transfertCommande(selectedRows);
                        }
                    }, true);
                    predicateACtion.setPredicate(IListeEvent.getNonEmptySelectionPredicate());
                    listeArt.addIListeAction(predicateACtion);
                    ListeViewPanel p = new ListeViewPanel(artElt, listeArt);
                    IListFrame f = new IListFrame(p);
                    FrameUtil.show(f);
                }
            }

        }, true);
        action.setPredicate(IListeEvent.createTotalRowCountPredicate(0, Integer.MAX_VALUE));
        panel.getListe().addIListeAction(action);

        return panel;
    }

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

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/order/action/ListeDesElementsACommanderClientAction.java @ 156 - Rev 185
