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

package org.openconcerto.modules.common.batchprocessing;

import java.awt.Component;
import java.awt.FlowLayout;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.swing.DefaultListCellRenderer;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.SwingUtilities;
import javax.swing.SwingWorker;

import org.openconcerto.sql.element.SQLElementDirectory;
import org.openconcerto.sql.model.SQLField;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowListRSH;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.request.SQLFieldTranslator;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.JLabelBold;
import org.openconcerto.ui.ReloadPanel;
import org.openconcerto.utils.ExceptionHandler;

public class BatchEditorPanel extends JPanel {

    public BatchEditorPanel(final SQLElementDirectory dir, final List<SQLRowAccessor> rows, FieldFilter filter) {
        SQLFieldTranslator translator = dir.getTranslator();
        Set<SQLField> fields = rows.get(0).getTable().getFields();
        List<BatchField> f = new ArrayList<BatchField>();
        for (SQLField sqlField : fields) {
            if (ForbiddenFieldName.isAllowed(sqlField.getName()) && translator.getLabelFor(sqlField) != null) {
                if (filter == null || !filter.isFiltered(sqlField)) {
                    f.add(new BatchField(dir, sqlField, null));
                }
            }
        }

        // Tarif
        SQLTable tableTarif = rows.get(0).getTable().getTable("TARIF");
        SQLTable tableArticleTarif = rows.get(0).getTable().getTable("ARTICLE_TARIF");
        SQLSelect sel = new SQLSelect();
        sel.addSelectStar(tableTarif);
        List<SQLRow> rowTarif = SQLRowListRSH.execute(sel);
        for (SQLRow sqlRow : rowTarif) {
            f.add(new BatchField(dir, tableArticleTarif.getField("PV_HT"), sqlRow));
            if (tableArticleTarif.contains("POURCENT_REMISE")) {
                f.add(new BatchField(dir, tableArticleTarif.getField("POURCENT_REMISE"), sqlRow));
            }
        }

        // Tarif Promo
        SQLTable tableTarifPromo = rows.get(0).getTable().getTable("TARIF_PROMOTION");
        SQLTable tableArticleTarifPromo = rows.get(0).getTable().getTable("ARTICLE_TARIF_PROMOTION");
        SQLSelect selT = new SQLSelect();
        selT.addSelectStar(tableTarifPromo);
        List<SQLRow> rowTarifP = SQLRowListRSH.execute(selT);
        for (SQLRow sqlRow : rowTarifP) {
            f.add(new BatchField(dir, tableArticleTarifPromo.getField("PV_HT"), sqlRow));
        }

        // Tarif quantite
        SQLTable tableTarifQte = rows.get(0).getTable().getTable("TARIF_QUANTITE");
        SQLSelect selQ = new SQLSelect();
        selQ.addSelectStar(tableTarifQte);
        Where w = Where.inValues(tableTarifQte.getField("ID_" + rows.get(0).getTable().getName()), SQLRow.getIDs(rows));
        selQ.setWhere(w);
        List<SQLRow> rowTarifQ = SQLRowListRSH.execute(selQ);
        Set<BigDecimal> qtes = new HashSet<>();
        for (SQLRow sqlRow : rowTarifQ) {
            final BigDecimal qte = sqlRow.getBigDecimal("QUANTITE");
            if (!qtes.contains(qte)) {
                qtes.add(qte);
                final BatchField batchFieldQte = new BatchField(dir, sqlRow.getTable().getField("PRIX_METRIQUE_VT_1"), null);
                batchFieldQte.setDefaultMatchingValue(sqlRow.getTable().getField("QUANTITE"), qte);
                f.add(batchFieldQte);
                final BatchField batchFieldRemise = new BatchField(dir, sqlRow.getTable().getField("POURCENT_REMISE"), null);
                batchFieldRemise.setDefaultMatchingValue(sqlRow.getTable().getField("QUANTITE"), qte);
                f.add(batchFieldRemise);
            }
        }

        // Stock
        SQLTable tableDepotStock = rows.get(0).getTable().getTable("DEPOT_STOCK");
        SQLTable tableStock = tableDepotStock.getTable("STOCK");
        SQLSelect selDepot = new SQLSelect();
        selDepot.addSelectStar(tableDepotStock);
        List<SQLRow> rowDepot = SQLRowListRSH.execute(selDepot);
        for (SQLRow sqlRow : rowDepot) {
            f.add(new BatchField(dir, tableStock.getField("QTE_MIN"), sqlRow));
        }

        Collections.sort(f, new Comparator<BatchField>() {

            @Override
            public int compare(BatchField o1, BatchField o2) {
                return o1.getComboName().compareToIgnoreCase(o2.getComboName());
            }
        });
        this.setLayout(new GridBagLayout());
        GridBagConstraints c = new DefaultGridBagConstraints();
        this.add(new JLabel("Champ"), c);

        final JComboBox<BatchField> combo = new JComboBox<BatchField>(f.toArray(new BatchField[1]));
        combo.setRenderer(new DefaultListCellRenderer() {
            @Override
            public Component getListCellRendererComponent(JList list, Object value, int index, boolean isSelected, boolean cellHasFocus) {
                String label = ((BatchField) value).getComboName();
                return super.getListCellRendererComponent(list, label, index, isSelected, cellHasFocus);
            }
        });

        combo.setSelectedIndex(0);

        c.gridx++;
        c.weightx = 1;
        c.fill = GridBagConstraints.NONE;
        this.add(combo, c);
        c.gridx = 0;
        c.gridy++;
        c.gridwidth = 2;
        c.fill = GridBagConstraints.HORIZONTAL;
        this.add(new JLabelBold("Action à appliquer"), c);
        c.weightx = 1;
        c.weighty = 1;
        c.fill = GridBagConstraints.HORIZONTAL;
        c.gridy++;
        c.anchor = GridBagConstraints.NORTHWEST;
        final BatchDetailPanel comp = new BatchDetailPanel();
        comp.setField((BatchField) combo.getSelectedItem());
        this.add(comp, c);

        JPanel actions = new JPanel();
        actions.setLayout(new FlowLayout(FlowLayout.RIGHT));
        final JButton buttonProcess = new JButton("Lancer le traitement");

        final JButton buttonCancel = new JButton("Annuler");
        final ReloadPanel reload = new ReloadPanel();
        actions.add(reload);
        actions.add(buttonProcess);

        actions.add(buttonCancel);

        c.gridy++;
        c.weighty = 0;
        this.add(actions, c);

        combo.addItemListener(new ItemListener() {

            @Override
            public void itemStateChanged(ItemEvent e) {
                comp.setField((BatchField) combo.getSelectedItem());

            }
        });
        buttonProcess.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                if (!comp.getProcessor().checkParameters()) {
                    JOptionPane.showMessageDialog(BatchEditorPanel.this, "Paramètres non valides");
                    return;
                }

                buttonProcess.setEnabled(false);
                buttonCancel.setEnabled(false);
                comp.setEnabled(false);

                combo.setEnabled(false);
                reload.setMode(ReloadPanel.MODE_ROTATE);
                SwingWorker<Object, Object> w = new SwingWorker<Object, Object>() {

                    @Override
                    protected Object doInBackground() throws Exception {
                        try {
                            final BatchProcessor processor = comp.getProcessor();
                            processor.process(rows);
                        } catch (Exception e) {
                            ExceptionHandler.handle("Echec du traitement", e);
                        }
                        return null;
                    }

                    @Override
                    protected void done() {
                        reload.setMode(ReloadPanel.MODE_EMPTY);
                        JOptionPane.showMessageDialog(BatchEditorPanel.this, "Traitement terminé");
                        SwingUtilities.getWindowAncestor(BatchEditorPanel.this).dispose();
                    }

                };
                w.execute();
            }
        });
        buttonCancel.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                SwingUtilities.getWindowAncestor(BatchEditorPanel.this).dispose();
            }
        });
    }
}