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

/*

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

import org.openconcerto.erp.action.CreateFrameAbstractAction;

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

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

import org.openconcerto.erp.rights.DepotStockViewRightEditor;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.FieldPath;

import org.openconcerto.sql.model.SQLBackgroundTableCache;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

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

import org.openconcerto.sql.users.rights.UserRightsManager;

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

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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.PanelFrame;

import org.openconcerto.utils.CollectionUtils;

import org.openconcerto.utils.DecimalUtils;

import org.openconcerto.utils.Tuple2;

import org.openconcerto.utils.cc.ITransformer;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.math.BigDecimal;

import java.util.ArrayList;

import java.util.List;

import java.util.Set;

import javax.swing.Action;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.JTabbedPane;

public class ListeDesStocksAction extends CreateFrameAbstractAction {

    private final boolean besoin;

    public ListeDesStocksAction() {

        this(false);

    }

    public ListeDesStocksAction(boolean b) {

        super();

        this.besoin = b;

        this.putValue(Action.NAME, "Liste des stocks");

    }

    public JFrame createFrame() {

        SQLElement eltStock = Configuration.getInstance().getDirectory().getElement("STOCK");

        final SQLTable stockTable = eltStock.getTable();

        final SQLTable depotTable = stockTable.getForeignTable("ID_DEPOT_STOCK");

        List<SQLRow> rowsEtat = SQLBackgroundTableCache.getInstance().getCacheForTable(depotTable).getRows();

        JTabbedPane tabs = new JTabbedPane();

        boolean canViewAll = true;

        for (final SQLRow sqlRow : rowsEtat) {

            boolean canView = UserRightsManager.getCurrentUserRights().haveRight(DepotStockViewRightEditor.ID_RIGHT, String.valueOf(sqlRow.getID()));

            canViewAll &= canView;

            if (canView) {

                ListeAddPanel panel = createPanel(eltStock, stockTable, sqlRow);

                tabs.add(sqlRow.getString("NOM"), panel);

            }

        }

        if (canViewAll && this.besoin) {

            tabs.insertTab("Global", null, createPanel(eltStock, stockTable, null), null, 0);

        }

        JPanel panel = new JPanel(new GridBagLayout());

        GridBagConstraints c = new DefaultGridBagConstraints();

        c.fill = GridBagConstraints.BOTH;

        c.weightx = 1;

        c.weighty = 1;

        panel.add(tabs, c);

        return new PanelFrame(panel, "Liste des stocks");

    }

    private ListeAddPanel createPanel(SQLElement eltStock, final SQLTable stockTable, final SQLRow sqlRow) {

        final SQLTableModelSourceOnline tableSource = eltStock.getTableSource(true);

        SQLTableModelColumn colStock;

        if (stockTable.getDBRoot().contains("ARTICLE_PRIX_REVIENT")) {

            colStock = tableSource.getColumn(tableSource.getColumns().size() - 2);

        } else {

            colStock = new BaseSQLTableModelColumn("Valeur HT du stock", BigDecimal.class) {

                @Override

                protected Object show_(SQLRowAccessor stock) {

                    if (stock == null || stock.isUndefined()) {

                        return BigDecimal.ZERO;

                    } else {

                        float qte = stock.getFloat("QTE_REEL");

                        BigDecimal ha = stock.getForeign("ID_ARTICLE").getBigDecimal("PA_HT");

                        BigDecimal total = ha.multiply(new BigDecimal(qte), DecimalUtils.HIGH_PRECISION);

                        if (total.signum() == 1) {

                            return total;

                        } else {

                            return BigDecimal.ZERO;

                        }

                    }

                }

                @Override

                public Set<FieldPath> getPaths() {

                    final SQLTable table = stockTable;

                    Path p2 = new Path(table).addForeignField("ID_ARTICLE");

                    return CollectionUtils.createSet(new FieldPath(p2, "PA_HT"));

                }

            };

            colStock.setRenderer(ComptaSQLConfElement.CURRENCY_RENDERER);

            tableSource.getColumns().add(colStock);

        }

        tableSource.getReq().setSelectTransf(new ITransformer<SQLSelect, SQLSelect>() {

            @Override

            public SQLSelect transformChecked(SQLSelect input) {

                Where w = sqlRow == null ? null : new Where(input.getTable("STOCK").getField("ID_DEPOT_STOCK"), "=", sqlRow.getID());

                if (besoin) {

                    w = Where.and(w, new Where(input.getTable("STOCK").getField("QTE_TH"), "<", input.getTable("STOCK").getField("QTE_MIN")));

                }

                input.setWhere(w);

                return input;

            }

        });

        final IListe liste = new IListe(tableSource);

        ListeAddPanel panel = new ListeAddPanel(eltStock, liste);

        panel.setAddVisible(false);

        panel.setDeleteVisible(false);

        List<Tuple2<? extends SQLTableModelColumn, IListTotalPanel.Type>> fields = new ArrayList<Tuple2<? extends SQLTableModelColumn, IListTotalPanel.Type>>(1);

        fields.add(Tuple2.create(colStock, IListTotalPanel.Type.SOMME));

        IListTotalPanel total = new IListTotalPanel(liste, fields, null, "Total");

        GridBagConstraints c2 = new DefaultGridBagConstraints();

        c2.gridy = 4;

        c2.anchor = GridBagConstraints.EAST;

        c2.weightx = 0;

        c2.fill = GridBagConstraints.NONE;

        panel.add(total, c2);

        return panel;

    }

}