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.stock.element;

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

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

import org.openconcerto.erp.core.sales.product.action.InventairePanel;

import org.openconcerto.erp.generationDoc.gestcomm.FicheArticleXmlSheet;

import org.openconcerto.erp.model.MouseSheetXmlListeListener;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLRowValuesListFetcher;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.sqlobject.ElementComboBox;

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.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FrameUtil;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.ListMap;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.event.ActionEvent;

import java.sql.SQLException;

import java.util.Arrays;

import java.util.Collection;

import java.util.HashSet;

import java.util.List;

import java.util.Set;

import javax.swing.AbstractAction;

import javax.swing.JLabel;

import javax.swing.JTextField;

public class StockSQLElement extends ComptaSQLConfElement {

    public StockSQLElement() {

        super("STOCK", "un stock", "stocks");

        getRowActions().addAll(new MouseSheetXmlListeListener(FicheArticleXmlSheet.class).getRowActions());

        PredicateRowAction stock = new PredicateRowAction(new AbstractAction("Mettre à jour les stocks") {

            @Override

            public void actionPerformed(ActionEvent e) {

                PanelFrame p = new PanelFrame(new InventairePanel(IListe.get(e), IListe.get(e).getSelectedRows()), "Mise à jour des stocks");

                FrameUtil.show(p);

            }

        }, true, false);

        stock.setPredicate(IListeEvent.getNonEmptySelectionPredicate());

        getRowActions().add(stock);

    }

    protected List<String> getListFields() {

        return Arrays.asList("ID_ARTICLE", "QTE_MIN", "QTE_TH", "QTE_REEL", "QTE_LIV_ATTENTE", "QTE_RECEPT_ATTENTE", "ID_DEPOT_STOCK");

    }

    @Override

    public Set<String> getReadOnlyFields() {

        Set<String> s = new HashSet<>();

        if (getTable().contains("ID_ARTICLE")) {

            s.add("ID_ARTICLE");

        }

        s.add("QTE_TH");

        s.add("QTE_REEL");

        s.add("QTE_LIV_ATTENTE");

        s.add("QTE_RECEPT_ATTENTE");

        if (getTable().contains("ID_DEPOT_STOCK")) {

            s.add("ID_DEPOT_STOCK");

        }

        return s;

    }

    @Override

    protected List<String> getComboFields() {

        return Arrays.asList("ID_DEPOT_STOCK", "QTE_REEL");

    }

    @Override

    protected String getParentFFName() {

        return "ID_ARTICLE";

    }

    @Override

    public ListMap<String, String> getShowAs() {

        if (getTable().contains("ID_DEPOT_STOCK")) {

            return ListMap.singleton(null, "QTE_TH", "QTE_REEL", "QTE_LIV_ATTENTE", "QTE_RECEPT_ATTENTE", "ID_DEPOT_STOCK");

        } else {

            return ListMap.singleton(null, "QTE_TH", "QTE_REEL", "QTE_LIV_ATTENTE", "QTE_RECEPT_ATTENTE");

        }

    }

    public static SQLRowAccessor getStockFetched(SQLRowAccessor rowValsSource) {

        SQLRowAccessor rowStock = null;

        final int idDepot;

        if (rowValsSource.getForeign("ID_DEPOT_STOCK") != null && !rowValsSource.isForeignEmpty("ID_DEPOT_STOCK")) {

            idDepot = rowValsSource.getForeignID("ID_DEPOT_STOCK");

        } else {

            idDepot = rowValsSource.getForeign("ID_ARTICLE").getForeignID("ID_DEPOT_STOCK");

        }

        SQLTable stockTable = rowValsSource.getTable().getTable("STOCK");

        Collection<? extends SQLRowAccessor> rows = rowValsSource.getForeign("ID_ARTICLE").getReferentRows(stockTable);

        for (SQLRowAccessor sqlRowAccessor : rows) {

            if (sqlRowAccessor.getForeignID("ID_DEPOT_STOCK") == idDepot) {

                rowStock = sqlRowAccessor;

                break;

            }

        }

        return rowStock;

    }

    public static SQLRowAccessor getStock(SQLRowAccessor rowValsSource) {

        SQLRowAccessor rowStock = null;

        final int idDepot;

        if (rowValsSource.getForeign("ID_DEPOT_STOCK") != null && !rowValsSource.isForeignEmpty("ID_DEPOT_STOCK")) {

            idDepot = rowValsSource.getForeignID("ID_DEPOT_STOCK");

        } else {

            idDepot = rowValsSource.getForeign("ID_ARTICLE").getForeignID("ID_DEPOT_STOCK");

        }

        SQLTable stockTable = rowValsSource.getTable().getTable("STOCK");

        SQLRowValues putRowValuesStock = new SQLRowValues(stockTable);

        putRowValuesStock.putNulls(stockTable.getTable().getFieldsName());

        SQLRowValuesListFetcher fetch = SQLRowValuesListFetcher.create(putRowValuesStock);

        Where w = new Where(putRowValuesStock.getTable().getField("ID_DEPOT_STOCK"), "=", idDepot);

        Where w2 = new Where(putRowValuesStock.getTable().getField("ID_ARTICLE"), "=", rowValsSource.getForeignID("ID_ARTICLE"));

        Collection<SQLRowValues> rowValsResult = fetch.fetch(w.and(w2));

        if (rowValsResult.isEmpty()) {

            SQLRowValues rowValsStock = new SQLRowValues(stockTable);

            rowValsStock.put("ID_ARTICLE", rowValsSource.getForeignID("ID_ARTICLE"));

            rowValsStock.put("ID_DEPOT_STOCK", idDepot);

            rowValsStock.put("QTE_TH", 0F);

            rowValsStock.put("QTE_REEL", 0F);

            rowValsStock.put("QTE_RECEPT_ATTENTE", 0F);

            rowValsStock.put("QTE_LIV_ATTENTE", 0F);

            try {

                rowStock = rowValsStock.insert();

                if (idDepot == DepotStockSQLElement.DEFAULT_ID) {

                    rowValsSource.getForeign("ID_ARTICLE").createEmptyUpdateRow().put("ID_STOCK", rowStock.getID()).commit();

                }

            } catch (SQLException e) {

                ExceptionHandler.handle("Erreur lors la création du stock!", e);

            }

        } else if (rowValsResult.size() == 1) {

            rowStock = rowValsResult.iterator().next();

        } else if (rowValsResult.size() > 1) {

            throw new IllegalStateException("2 lignes de stocks pour le même dépôt! Article " + rowValsSource.getForeign("ID_ARTICLE").getID() + " Depot " + idDepot);

        }

        return rowStock;

    }

    /*

     * (non-Javadoc)

     *

     * @see org.openconcerto.devis.SQLElement#getComponent()

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            public void addViews() {

                this.setLayout(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

                // Article

                JLabel labelA = new JLabel(getLabelFor("ID_ARTICLE"));

                c.weightx = 0;

                this.add(labelA, c);

                c.gridx++;

                ElementComboBox boxA = new ElementComboBox();

                this.add(boxA, c);

                // Depot

                JLabel labelD = new JLabel(getLabelFor("ID_DEPOT_STOCK"));

                c.gridx++;

                c.weightx = 0;

                this.add(labelD, c);

                c.gridx++;

                ElementComboBox boxD = new ElementComboBox();

                this.add(boxD, c);

                // Qté Réelle

                JLabel labelQteR = new JLabel(getLabelFor("QTE_REEL"));

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                this.add(labelQteR, c);

                c.gridx++;

                JTextField textQteReel = new JTextField(6);

                this.add(textQteReel, c);

                // Qté Réelle

                JLabel labelQteT = new JLabel(getLabelFor("QTE_TH"));

                c.gridx++;

                c.weightx = 0;

                this.add(labelQteT, c);

                c.gridx++;

                JTextField textQteT = new JTextField(6);

                this.add(textQteT, c);

                // Qté Réelle

                JLabel labelQteRe = new JLabel(getLabelFor("QTE_RECEPT_ATTENTE"));

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                this.add(labelQteRe, c);

                c.gridx++;

                JTextField textQteRe = new JTextField(6);

                this.add(textQteRe, c);

                JLabel labelQteL = new JLabel(getLabelFor("QTE_LIV_ATTENTE"));

                c.gridx++;

                c.weightx = 0;

                this.add(labelQteL, c);

                c.gridx++;

                JTextField textQteL = new JTextField(6);

                this.add(textQteL, c);

                // Qté Min

                JLabel labelQteTMin = new JLabel(getLabelFor("QTE_MIN"));

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                this.add(labelQteTMin, c);

                c.gridx++;

                JTextField textQteMin = new JTextField(6);

                this.add(textQteMin, c);

                this.addSQLObject(textQteReel, "QTE_REEL");

                this.addSQLObject(textQteT, "QTE_TH");

                this.addSQLObject(textQteMin, "QTE_MIN");

                this.addSQLObject(textQteL, "QTE_LIV_ATTENTE");

                this.addSQLObject(textQteRe, "QTE_RECEPT_ATTENTE");

                this.addSQLObject(boxA, "ID_ARTICLE");

                this.addSQLObject(boxD, "ID_DEPOT_STOCK");

            }

        };

    }

    @Override

    protected String createCode() {

        return "supplychain.stock";

    }

}