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.supplier.component;

import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.SQLRequestComboBox;

import org.openconcerto.sql.sqlobject.SQLTextCombo;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JDate;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.sql.SQLException;

import java.util.Arrays;

import java.util.HashSet;

import java.util.Set;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

public class MouvementStockSQLComponent extends BaseSQLComponent {

    public MouvementStockSQLComponent(SQLElement element) {

        super(element);

    }

    @Override

    public Set<String> getPartialResetNames() {

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

        s.add("QTE");

        s.add("ID_ARTICLE");

        return s;

    }

    public void addViews() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        // Libellé

        final JLabel labelLib = new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT);

        this.add(labelLib, c);

        c.gridx++;

        c.weightx = 1;

        final SQLTextCombo textLib = new SQLTextCombo();

        this.add(textLib, c);

        // Date

        c.gridx++;

        c.weightx = 0;

        JLabel labelDate = new JLabel(getLabelFor("DATE"), SwingConstants.RIGHT);

        this.add(labelDate, c);

        c.gridx++;

        final JDate date = new JDate(true);

        this.add(date, c);

        // Article

        final ElementComboBox articleSelect = new ElementComboBox();

        c.gridx = 0;

        c.gridy++;

        final JLabel labelArticle = new JLabel(getLabelFor("ID_ARTICLE"), SwingConstants.RIGHT);

        this.add(labelArticle, c);

        c.gridx++;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.weightx = 1;

        this.add(articleSelect, c);

        // Article

        final SQLRequestComboBox articleStock = new SQLRequestComboBox();

        c.gridwidth = 1;

        c.weightx = 0;

        c.gridx = 0;

        c.gridy++;

        final JLabel labelStock = new JLabel(getLabelFor("ID_STOCK"), SwingConstants.RIGHT);

        this.add(labelStock, c);

        c.gridx++;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.weightx = 1;

        this.add(articleStock, c);

        // QTE

        c.gridwidth = 1;

        c.weightx = 0;

        c.gridy++;

        c.gridx = 0;

        c.anchor = GridBagConstraints.EAST;

        final JLabel labelQte = new JLabel(getLabelFor("QTE"), SwingConstants.RIGHT);

        this.add(labelQte, c);

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        final JTextField textQte = new JTextField(6);

        c.weighty = 0;

        c.anchor = GridBagConstraints.NORTHWEST;

        this.add(textQte, c);

        c.gridx++;

        final JCheckBox boxReel = new JCheckBox(getLabelFor("REEL"));

        this.add(boxReel, c);

        addView(boxReel, "REEL");

        c.gridy++;

        c.weighty = 1;

        final JPanel comp = new JPanel();

        comp.setOpaque(false);

        this.add(comp, c);

        DefaultGridBagConstraints.lockMinimumSize(textQte);

        DefaultGridBagConstraints.lockMaximumSize(textQte);

        this.addRequiredSQLObject(textQte, "QTE");

        this.addSQLObject(textLib, "NOM");

        this.addRequiredSQLObject(articleSelect, "ID_ARTICLE");

        this.addRequiredSQLObject(articleStock, "ID_STOCK");

        this.addRequiredSQLObject(date, "DATE");

        articleStock.getRequest().setWhere(Where.FALSE);

        articleSelect.addModelListener("wantedID", new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                articleStock.getRequest().setWhere(new Where(articleStock.getRequest().getPrimaryTable().getField("ID_ARTICLE"), "=", articleSelect.getWantedID()));

            }

        });

    }

    @Override

    protected SQLRowValues createDefaults() {

        SQLRowValues rowVals = new SQLRowValues(getTable());

        rowVals.put("REEL", Boolean.TRUE);

        return rowVals;

    }

    @Override

    public int insert(SQLRow order) {

        int id = super.insert(order);

        try {

            ((MouvementStockSQLElement) getElement()).updateStock(Arrays.asList(getTable().getRow(id)), false);

        } catch (SQLException e) {

            throw new IllegalStateException("Impossible de metter à jour les stocks pour l'id " + id, e);

        }

        return id;

    }

    @Override

    public void update() {

        int id = getSelectedID();

        try {

            ((MouvementStockSQLElement) getElement()).updateStock(Arrays.asList(getTable().getRow(id)), true);

            super.update();

            ((MouvementStockSQLElement) getElement()).updateStock(Arrays.asList(getTable().getRow(id)), false);

        } catch (SQLException e) {

            throw new IllegalStateException("Impossible de metter à jour les stocks pour l'id " + id, e);

        }

    }

}