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.
 */
 
 /*
 * Créé le 23 avr. 2012
 */
package org.openconcerto.erp.core.supplychain.stock.element;

import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.ConnectionHandlerNoSetup;
import org.openconcerto.sql.model.SQLDataSource;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
import org.openconcerto.sql.utils.SQLUtils;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.SwingThreadUtils;
import org.openconcerto.utils.ExceptionHandler;

import java.awt.Component;
import java.awt.FileDialog;
import java.awt.Frame;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Window;
import java.awt.event.ActionEvent;
import java.io.File;
import java.io.IOException;
import java.sql.SQLException;

import javax.swing.AbstractAction;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.SwingUtilities;

public class ImportInventairePanel extends JPanel {

    public ImportInventairePanel(final SQLElement depotElt) {
        super(new GridBagLayout());

        final SQLRequestComboBox boxDepot = new SQLRequestComboBox(false);
        boxDepot.uiInit(depotElt.createComboRequest());

        GridBagConstraints c = new DefaultGridBagConstraints();
        JLabel labelCom = new JLabel("Dépôt ");
        this.add(labelCom, c);
        c.gridx++;
        this.add(boxDepot, c);

        // final JDate dateDeb = new JDate();
        // this.add(dateDeb, c);
        // c.gridx++;
        // JLabel labelD = new JLabel("Début au");
        // final JDate dateDebut = new JDate();

        final JButton buttonValid = new JButton(new AbstractAction("Valider") {

            @Override
            public void actionPerformed(ActionEvent e) {
                SQLRowAccessor row = boxDepot.getSelectedRow();
                final SQLRowAccessor rowDepot;
                if (row != null && !row.isUndefined()) {
                    rowDepot = boxDepot.getSelectedRow();
                } else {
                    rowDepot = depotElt.getTable().getRow(DepotStockSQLElement.DEFAULT_ID);

                }

                ((Window) SwingUtilities.getRoot(ImportInventairePanel.this)).dispose();
                final Frame frame = SwingThreadUtils.getAncestorOrSelf(Frame.class, (Component) e.getSource());
                final FileDialog fd = new FileDialog(frame, "Import Inventaire", FileDialog.LOAD);
                fd.setVisible(true);
                if (fd.getFile() != null) {
                    final File f = new File(fd.getDirectory(), fd.getFile());
                    if (!f.exists()) {
                        JOptionPane.showMessageDialog(null, "Le ficher selectionné n'existe pas", "Erreur", JOptionPane.ERROR_MESSAGE);
                    } else if (f.isDirectory()) {
                        JOptionPane.showMessageDialog(null, "Le fichier selectionné n'est pas valide", "Erreur", JOptionPane.ERROR_MESSAGE);
                    } else {
                        new Thread(new Runnable() {

                            @Override
                            public void run() {
                                // FIXME ajouter une barre de progression
                                final InventaireFromEtatStockImporter impoter = new InventaireFromEtatStockImporter(depotElt.getDirectory().getElement("ARTICLE"), rowDepot);
                                try {
                                    SQLUtils.executeAtomic(depotElt.getTable().getDBSystemRoot().getDataSource(), new ConnectionHandlerNoSetup<Object, IOException>() {
                                        @Override
                                        public Object handle(final SQLDataSource ds) throws SQLException, IOException {

                                            impoter.importArticles(f, depotElt.getTable().getDBRoot());
                                            return null;
                                        }
                                    });
                                } catch (Exception e1) {
                                    ExceptionHandler.handle("Erreur lors de l'importation", e1);
                                }

                            }
                        }).start();
                    }
                }
            }

        });
        c.gridx++;
        // buttonValid.setEnabled(false);
        this.add(buttonValid, c);

    }

}