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.sales.product.action;

import org.openconcerto.erp.action.CreateFrameAbstractAction;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

import org.openconcerto.erp.core.sales.product.ui.FamilleArticlePanel;

import org.openconcerto.erp.panel.ITreeSelection;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.request.ListSQLRequest;

import org.openconcerto.sql.view.ListeAddPanel;

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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.PanelFrame;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.math.BigInteger;

import javax.swing.Action;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.JSplitPane;

import javax.swing.JTable;

import javax.swing.event.TableModelEvent;

import javax.swing.event.TableModelListener;

public class ListeDesArticlesAction extends CreateFrameAbstractAction {

    private PanelFrame panelFrame;

    String title = "Liste des articles";

    private final SQLTable sqlTableArticle = ((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("ARTICLE");

    private final SQLTable sqlTableFamilleArticle = ((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("FAMILLE_ARTICLE");

    public ListeDesArticlesAction() {

        super();

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

    }

    public JFrame createFrame() {

        final FamilleArticlePanel panelFam = new FamilleArticlePanel();

        // Renderer pour les devises

        // frame.getPanel().getListe().getJTable().setDefaultRenderer(Long.class, new

        // DeviseNiceTableCellRenderer());

        SQLElement elt = Configuration.getInstance().getDirectory().getElement(this.sqlTableArticle);

        IListe liste = new IListe(ListSQLRequest.copy(elt.getListRequest(), getWhere(panelFam)));

        final ListeAddPanel panel = new ListeAddPanel(elt, liste);

        JSplitPane pane = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT, panelFam, panel);

        JPanel panelAll = new JPanel(new GridBagLayout());

        GridBagConstraints c = new DefaultGridBagConstraints();

        c.fill = GridBagConstraints.BOTH;

        c.weightx = 1;

        c.weighty = 1;

        c.insets = new Insets(0, 0, 0, 0);

        panelAll.add(pane, c);

        DeviseNiceTableCellRenderer rend = new DeviseNiceTableCellRenderer();

        JTable table = panel.getListe().getJTable();

        for (int i = 0; i < table.getColumnCount(); i++) {

            if (table.getColumnClass(i) == Long.class || table.getColumnClass(i) == BigInteger.class) {

                table.getColumnModel().getColumn(i).setCellRenderer(rend);

            }

        }

        final ITreeSelection tree = panelFam.getFamilleTree();

        tree.addValueListener(new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                panel.getListe().getRequest().setWhere(getWhere(panelFam));

            }

        });

        // rafraichir le titre à chaque changement de la liste

        panel.getListe().addListener(new TableModelListener() {

            public void tableChanged(TableModelEvent e) {

                setTitle(panel);

            }

        });

        panel.getListe().addListenerOnModel(new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                if (evt.getPropertyName() == null || evt.getPropertyName().equals("loading") || evt.getPropertyName().equals("searching"))

                    setTitle(panel);

            }

        });

        panelFam.getCheckObsolete().addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                panel.getListe().getRequest().setWhere(getWhere(panelFam));

            }

        });

        this.panelFrame = new PanelFrame(panelAll, "Liste des articles");

        return this.panelFrame;

    }

    protected void setTitle(ListeAddPanel panel) {

        String title = this.title;

        if (panel.getListe().getModel().isLoading())

            title += ", chargement en cours";

        if (panel.getListe().getModel().isSearching())

            title += ", recherche en cours";

        this.panelFrame.setTitle(title);

    }

    /**

     * Filtre par rapport à la famille sélectionnée

     *

     * @param panel

     * @return le where approprié

     */

    public Where getWhere(FamilleArticlePanel panel) {

        int id = panel.getFamilleTree().getSelectedID();

        Where w = null;

        if (panel.getCheckObsolete().isSelected()) {

            w = new Where(this.sqlTableArticle.getField("OBSOLETE"), "=", Boolean.FALSE);

        }

        if (id > 1) {

            SQLRow row = this.sqlTableFamilleArticle.getRow(id);

            String code = row.getString("CODE") + "%";

            Where w2 = new Where(this.sqlTableArticle.getField("ID_FAMILLE_ARTICLE"), "=", this.sqlTableFamilleArticle.getKey());

            if (w != null) {

                w = w.and(w2);

            } else {

                w = w2;

            }

            w = w.and(new Where(this.sqlTableFamilleArticle.getField("CODE"), "LIKE", code));

        }

        return w;

    }

}