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.Configuration;
import org.openconcerto.sql.PropsConfiguration;
import org.openconcerto.sql.TM;
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.JComponent;
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 {
                    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());
        final List<Locale> langs = 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"));
        if (this.connexionPanel == null) {
            final Locale locale = UserProps.getInstance().getLocale();
            // for next launch
            UserProps.getInstance().setLocale(locale);
            // for current run
            ((PropsConfiguration) Configuration.getInstance()).setLocale(locale);
            // for code that will never need more than one Locale concurrently
            // (e.g. used by TM singletons in various packages)
            Locale.setDefault(locale);
            // as explained in Locale.setDefault() javadoc : "be prepared to reinitialize
            // locale-sensitive code"
            JComponent.setDefaultLocale(locale);
            // throw RuntimeException like ResourceBundle.getBundle() at the beginning of this
            // method
            TranslationManager.createDefaultInstance();
            TM.getInstance();
            return null;
        }

        this.connexionPanel.initLocalization(getClass().getName(), langs);

        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
                ClasseCompte.loadClasseCompte(comptaConf);
                try {
                    Thread.sleep(1000);
                } catch (InterruptedException e) {
                    e.printStackTrace();
                }
                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);
            }
        });
    }
}