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

import static org.openconcerto.task.config.ComptaBasePropsConfiguration.getStreamStatic;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.config.DefaultMenuConfiguration;

import org.openconcerto.erp.config.Gestion;

import org.openconcerto.erp.config.Log;

import org.openconcerto.erp.config.MainFrame;

import org.openconcerto.erp.config.MenuManager;

import org.openconcerto.erp.config.MinimalMenuConfiguration;

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

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

import org.openconcerto.erp.core.finance.tax.model.TaxeCache;

import org.openconcerto.erp.core.humanresources.payroll.element.CaisseCotisationSQLElement;

import org.openconcerto.erp.element.objet.ClasseCompte;

import org.openconcerto.erp.modules.ModuleFrame;

import org.openconcerto.erp.modules.ModuleManager;

import org.openconcerto.erp.panel.ComptaTipsFrame;

import org.openconcerto.erp.preferences.GestionClientPreferencePanel;

import org.openconcerto.erp.rights.GroupUIComboRightEditor;

import org.openconcerto.erp.rights.MenuComboRightEditor;

import org.openconcerto.erp.utils.NXDatabaseAccessor;

import org.openconcerto.map.model.Ville;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLBackgroundTableCache;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.UndefinedRowValuesCache;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.preferences.SQLPreferences;

import org.openconcerto.sql.preferences.UserProps;

import org.openconcerto.sql.sqlobject.IComboSelectionItem;

import org.openconcerto.sql.ui.ConnexionPanel;

import org.openconcerto.sql.users.User;

import org.openconcerto.sql.users.UserManager;

import org.openconcerto.sql.users.rights.SQLTableRightEditor;

import org.openconcerto.sql.users.rights.TableAllRights;

import org.openconcerto.sql.users.rights.UserRights;

import org.openconcerto.sql.users.rights.UserRightsManager;

import org.openconcerto.sql.users.rights.UserRightsManager.RightTuple;

import org.openconcerto.sql.utils.BackupPanel;

import org.openconcerto.task.config.ComptaBasePropsConfiguration;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FrameUtil;

import org.openconcerto.ui.component.MutableListComboPopupListener;

import org.openconcerto.ui.preferences.EmailProps;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.JImage;

import org.openconcerto.utils.cc.IClosure;

import org.openconcerto.utils.i18n.TranslationManager;

import java.awt.Color;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Image;

import java.awt.Insets;

import java.io.File;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

import java.util.Locale;

import java.util.concurrent.CountDownLatch;

import java.util.concurrent.FutureTask;

import java.util.logging.Level;

import javax.swing.Action;

import javax.swing.JFrame;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextArea;

import javax.swing.SwingUtilities;

import javax.swing.SwingWorker;

import javax.swing.UIManager;

public class NouvelleConnexionAction extends CreateFrameAbstractAction {

    private final ComptaPropsConfiguration conf;

    private ConnexionPanel connexionPanel;

    public NouvelleConnexionAction(ComptaPropsConfiguration conf) {

        super();

        this.conf = conf;

        this.putValue(Action.NAME, "Changer d'utilisateur");

    }

    public JFrame createFrame() {

        // needed as done() must come after us

        assert SwingUtilities.isEventDispatchThread();

        final ComptaPropsConfiguration comptaPropsConfiguration = this.conf;

        Runnable r = new Runnable() {

            public void run() {

                try {

                    TranslationManager.getInstance().addTranslationStreamFromClass(MainFrame.class);

                    TranslationManager.getInstance().setLocale(UserProps.getInstance().getLocale());

                    final Boolean booleanValue = UserProps.getInstance().getBooleanValue("HideTips");

                    if (!booleanValue) {

                        SwingUtilities.invokeLater(new Runnable() {

                            @Override

                            public void run() {

                                ComptaTipsFrame.getFrame(true).setVisible(true);

                            }

                        });

                    }

                    int selectedSociete;

                    if (NouvelleConnexionAction.this.connexionPanel != null && !Gestion.isMinimalMode()) {

                        selectedSociete = NouvelleConnexionAction.this.connexionPanel.getSelectedSociete();

                    } else {

                        selectedSociete = UserProps.getInstance().getLastSocieteID();

                        if (selectedSociete < SQLRow.MIN_VALID_ID) {

                            final SQLElement elem = comptaPropsConfiguration.getDirectory().getElement(comptaPropsConfiguration.getRoot().getTable("SOCIETE_COMMON"));

                            final List<IComboSelectionItem> comboItems = elem.getComboRequest().getComboItems();

                            if (comboItems.size() > 0)

                                selectedSociete = comboItems.get(0).getId();

                            else

                                throw new IllegalStateException("No " + elem + " found");

                        }

                    }

                    comptaPropsConfiguration.setUpSocieteDataBaseConnexion(selectedSociete);

                    comptaPropsConfiguration.setupBarCodeIfNeeded();

                    File fMail2 = new File(comptaPropsConfiguration.getConfDir(), "Email" + selectedSociete + ".properties");

                    EmailProps.getInstance().setPropsFileName(fMail2.toString());

                    // needed by openEmergencyModuleManager()

                    UserRightsManager.getInstance().addRightForAdmins(new RightTuple(ModuleManager.MODULE_DB_RIGHT, true));

                    UserRightsManager.getInstance().addRightForAdmins(new RightTuple(BackupPanel.RIGHT_CODE, true));

                    // finish filling the configuration before going any further, otherwise the

                    // SQLElementDirectory is not coherent

                    final ModuleManager moduleMngr = comptaPropsConfiguration.getModuleManager();

                    try {

                        moduleMngr.init();

                    } catch (Throwable e) {

                        // not OK to continue without required elements

                        openEmergencyModuleManager(moduleMngr, "Impossible de configurer les modules requis", e);

                        return;

                    }

                    MenuManager.setInstance(

                            (Gestion.isMinimalMode() ? new MinimalMenuConfiguration(comptaPropsConfiguration) : new DefaultMenuConfiguration(comptaPropsConfiguration)).createMenuAndActions());

                    final User user = UserManager.getInstance().getCurrentUser();

                    final UserRights rights = UserRightsManager.getCurrentUserRights();

                    // Si l'utilisateur n'est pas superUser ou si il n'a pas de droit d'accéder

                    // à toutes les société

                    final int userId = user.getId();

                    if (!rights.haveRight("ACCES_ALL_SOCIETE")) {

                        final SQLTable tableAcces = comptaPropsConfiguration.getRoot().findTable("ACCES_SOCIETE");

                        SQLSelect sel = new SQLSelect();

                        sel.addSelectStar(tableAcces);

                        sel.setWhere(new Where(tableAcces.getField("ID_USER_COMMON"), "=", userId));

                        final List<SQLRow> accessRows = SQLRowListRSH.execute(sel);

                        final boolean accessGranted;

                        if (accessRows.size() == 0) {

                            accessGranted = true;

                        } else {

                            boolean tmp = false;

                            for (final SQLRow r : accessRows) {

                                if (r.getInt("ID_SOCIETE_COMMON") == selectedSociete) {

                                    tmp = true;

                                    break;

                                }

                            }

                            accessGranted = tmp;

                        }

                        if (!accessGranted) {

                            JOptionPane.showMessageDialog(null, "Vous n'avez pas les droits suffisants, pour accéder à cette société!");

                            return;

                        }

                    }

                    SwingUtilities.invokeLater(new Runnable() {

                        @Override

                        public void run() {

                            MenuComboRightEditor.register();

                            GroupUIComboRightEditor.register();

                            SQLTableRightEditor.register();

                            // even for quick login, check the license before displaying the main

                            // frame

                            MutableListComboPopupListener.setLockOverridable(rights.isSuperUser());

                            StatusPanel.getInstance().fireStatusChanged();

                            final MainFrame f = new MainFrame(comptaPropsConfiguration);

                            String version = comptaPropsConfiguration.getVersion();

                            final String socTitle = comptaPropsConfiguration.getRowSociete() == null ? "" : ", [Société " + comptaPropsConfiguration.getRowSociete().getString("NOM") + "]";

                            f.setTitle(comptaPropsConfiguration.getAppName() + " " + version + socTitle);

                            f.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);

                        }

                    });

                    final FutureTask<?> showMainFrame = new FutureTask<Object>(new Runnable() {

                        @Override

                        public void run() {

                            // make sure the application is started with all required and mandatory

                            // modules

                            if (moduleMngr.isInited()) {

                                final MainFrame mainFrame = MainFrame.getInstance();

                                mainFrame.initMenuBar();

                                FrameUtil.show(mainFrame);

                            }

                        }

                    }, null);

                    moduleMngr.invoke(new IClosure<ModuleManager>() {

                        @Override

                        public void executeChecked(ModuleManager input) {

                            // start modules before displaying the frame (e.g. avoid modifying a

                            // visible menu bar)

                            try {

                                input.startRequiredModules();

                                try {

                                    input.startPreviouslyRunningModules();

                                } catch (Exception exn) {

                                    // OK to start the application without all modules started

                                    // but don't continue right away otherwise connexion panel will

                                    // be closed and the popup with it

                                    try {

                                        ExceptionHandler.handle(NouvelleConnexionAction.this.connexionPanel, "Impossible de démarrer les modules", exn).get();

                                    } catch (Exception e) {

                                        e.printStackTrace();

                                    }

                                }

                                SwingUtilities.invokeLater(showMainFrame);

                            } catch (Exception exn) {

                                openEmergencyModuleManager(input, "Impossible de démarrer les modules requis", exn);

                            }

                        }

                    });

                    initCache(comptaPropsConfiguration);

                    // don't close ConnexionPanel until the main frame is shown

                    showMainFrame.get();

                } catch (Throwable e) {

                    if (e.getMessage() != null && ((e.getMessage().contains("table") && e.getMessage().contains("not found")) || e.getMessage().contains("unknown field")

                            || e.getMessage().contains("Couldn't add showAs") || e.getMessage().contains("Base de données non à jour"))) {

                        e.printStackTrace();

                        JOptionPane.showMessageDialog(new JFrame(),

                                "Votre base de données n'est pas à jour.\nUtilisez l'outil de configuration et pensez à l'achat du manuel !\n(" + e.getMessage() + ")");

                        return;

                    }

                    ExceptionHandler.handle("Erreur de connexion", e);

                }

            }

        };

        final JImage image = new JImage(ComptaBasePropsConfiguration.class.getResource("logo.png"));

        Image customImage = ComptaPropsConfiguration.getInstanceCompta().getCustomLogo();

        if (customImage != null) {

            image.setImage(customImage);

        }

        image.setBackground(Color.WHITE);

        JPanel p = new JPanel();

        p.setLayout(new GridBagLayout());

        GridBagConstraints c = new DefaultGridBagConstraints();

        c.weightx = 1;

        c.weighty = 1;

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

        c.fill = GridBagConstraints.BOTH;

        this.connexionPanel = ConnexionPanel.create(r, image, !Gestion.isMinimalMode());

        if (this.connexionPanel == null)

            return null;

        this.connexionPanel.initLocalization(getClass().getName(), Arrays.asList(Locale.FRANCE, Locale.CANADA_FRENCH, new Locale("fr", "CH"), new Locale("fr", "BE"), Locale.UK, Locale.CANADA,

                Locale.US, Locale.GERMANY, new Locale("de", "CH"), new Locale("es", "ES"), new Locale("pl", "PL")));

        p.add(this.connexionPanel, c);

        final PanelFrame panelFrame = new PanelFrame(p, "Connexion");

        panelFrame.setLocationRelativeTo(null);

        panelFrame.pack();

        panelFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

        return panelFrame;

    }

    static public void initCache(final ComptaPropsConfiguration comptaConf) {

        initCache(comptaConf, 600);

    }

    static public void initCache(final ComptaPropsConfiguration comptaConf, final int timeout) {

        final SQLBase baseSociete = comptaConf.getSQLBaseSociete();

        Thread t = new Thread() {

            @Override

            public void run() {

                // laisse le temps au logiciel de demarrer

                try {

                    Thread.sleep(10000);

                } catch (InterruptedException e) {

                    e.printStackTrace();

                }

                ClasseCompte.loadClasseCompte();

                CaisseCotisationSQLElement.getCaisseCotisation();

                SQLPreferences prefs = SQLPreferences.getMemCached(comptaConf.getRootSociete());

                Ville.init(new NXDatabaseAccessor(comptaConf), prefs.getBoolean(GestionClientPreferencePanel.LOAD_CITIES, true));

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("TAXE"), timeout);

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("ETAT_DEVIS"), timeout);

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("PREFS_COMPTE"), timeout);

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("COMPTE_PCE"), timeout);

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("JOURNAL"), timeout);

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("COMMERCIAL"), timeout);

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("PERIODE_VALIDITE"), timeout);

                if (comptaConf.getRootSociete().contains("DEPOT_STOCK")) {

                    SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("DEPOT_STOCK"), timeout);

                }

                SQLBackgroundTableCache.getInstance().add(baseSociete.getTable("TYPE_REGLEMENT"), timeout);

                SQLBackgroundTableCache.getInstance().startCacheWatcher();

                TaxeCache.getCache();

                final UndefinedRowValuesCache undefCache = UndefinedRowValuesCache.getInstance();

                final List<SQLTable> tablesToCache = new ArrayList<SQLTable>();

                tablesToCache.add(baseSociete.getTable("DEVIS"));

                tablesToCache.add(baseSociete.getTable("ETAT_DEVIS"));

                tablesToCache.add(baseSociete.getTable("FAMILLE_ARTICLE"));

                tablesToCache.add(baseSociete.getTable("ADRESSE"));

                tablesToCache.add(baseSociete.getTable("DEVIS_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("CONTACT"));

                tablesToCache.add(baseSociete.getTable("SAISIE_VENTE_FACTURE_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("SAISIE_KM_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("BON_DE_LIVRAISON_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("COMMANDE_CLIENT_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("AVOIR_CLIENT_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("BON_RECEPTION_ELEMENT"));

                tablesToCache.add(baseSociete.getTable("ASSOCIATION_ANALYTIQUE"));

                undefCache.preload(tablesToCache);

            }

        };

        t.setName("Cache preload");

        t.setDaemon(true);

        t.setPriority(Thread.MIN_PRIORITY);

        t.start();

    }

    private String checkLicense(final SwingWorker<String, Object> w) {

        try {

            return w.get();

        } catch (Exception e) {

            throw ExceptionHandler.die("Impossible de charger la licence.", e);

        }

    }

    private void openEmergencyModuleManager(ModuleManager mngr, final String str, final Throwable e) {

        Log.get().log(Level.SEVERE, "Normal startup impossible, opening the module manager in order to resolve the issue.", e);

        SwingUtilities.invokeLater(new Runnable() {

            @Override

            public void run() {

                ExceptionHandler.handle(str, e);

                // can't start since there's no main frame (and obviously no modules can be stopped

                // since none are running)

                final ModuleFrame fMod = new ModuleFrame(mngr, true);

                fMod.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

                fMod.setTitle(str);

                FrameUtil.show(fMod);

            }

        });

    }

}