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.

 */

 package org.openconcerto.sql.users;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.TM;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.DBRoot;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLRowValuesListFetcher;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.request.ComboSQLRequest;

import org.openconcerto.sql.sqlobject.itemview.SimpleRowItemView;

import org.openconcerto.sql.ui.IColorChooser;

import org.openconcerto.sql.ui.Login;

import org.openconcerto.sql.view.QuickAssignPanel;

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

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

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

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

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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.ISpinner;

import org.openconcerto.ui.ISpinnerIntegerModel;

import org.openconcerto.ui.JLabelBold;

import org.openconcerto.ui.component.InteractionMode;

import org.openconcerto.ui.valuewrapper.TextValueWrapper;

import org.openconcerto.ui.warning.JLabelWarning;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.ListMap;

import org.openconcerto.utils.cc.ITransformer;

import org.openconcerto.utils.checks.ValidState;

import org.openconcerto.utils.text.SimpleDocumentListener;

import java.awt.Component;

import java.awt.Font;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import javax.swing.BorderFactory;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import javax.swing.event.DocumentEvent;

import javax.swing.table.DefaultTableCellRenderer;

// FIXME Login user unique ?

public class UserCommonSQLElement extends SQLElement {

    /**

     * Set this system property to "true" if this should generate old style passwords.

     */

    public static final String LEGACY_PASSWORDS = "org.openconcerto.sql.legacyPasswords";

    private final boolean familyNameFirst;

    public UserCommonSQLElement(final DBRoot root) {

        this(root, false);

    }

    public UserCommonSQLElement(final DBRoot root, final boolean familyNameFirst) {

        // allow subclass to keep same code

        super(root.findTable("USER_COMMON"), null, "sql.user");

        this.familyNameFirst = familyNameFirst;

    }

    @Override

    protected List<String> getListFields() {

        final List<String> l = new ArrayList<>(5);

        if (this.familyNameFirst) {

            l.add("NOM");

            l.add("PRENOM");

        } else {

            l.add("PRENOM");

            l.add("NOM");

        }

        l.add("LOGIN");

        if (getTable().contains("DISABLED")) {

            l.add("DISABLED");

        }

        if (getTable().contains("OUT")) {

            l.add("OUT");

        }

        return l;

    }

    @Override

    protected synchronized void _initTableSource(final SQLTableModelSource res) {

        super._initTableSource(res);

        // current user in bold

        for (final SQLTableModelColumn col : res.getColumns()) {

            if (col.getValueClass().equals(String.class)) {

                col.setRenderer(new DefaultTableCellRenderer() {

                    @Override

                    public Component getTableCellRendererComponent(final JTable table, final Object value, final boolean isSelected, final boolean hasFocus, final int row, final int column) {

                        final JLabel res = (JLabel) super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);

                        final boolean isCurrentUser = ITableModel.getLine(table.getModel(), row).getRowAccessor().getID() == UserManager.getUserID();

                        final int targetStyle = isCurrentUser ? Font.BOLD : Font.PLAIN;

                        if ((res.getFont().getStyle() & targetStyle) == 0) {

                            res.setFont(res.getFont().deriveFont(targetStyle));

                        }

                        return res;

                    }

                });

            }

        }

    }

    @Override

    protected List<String> getComboFields() {

        final List<String> l = new ArrayList<>(2);

        if (this.familyNameFirst) {

            l.add("NOM");

            l.add("PRENOM");

        } else {

            l.add("PRENOM");

            l.add("NOM");

        }

        return l;

    }

    @Override

    protected void _initComboRequest(final ComboSQLRequest req) {

        super._initComboRequest(req);

        req.setFieldSeparator(" ");

    }

    @Override

    public ListMap<String, String> getShowAs() {

        return ListMap.singleton(null, "PRENOM", "NOM");

    }

    /*

     * (non-Javadoc)

     *

     * @see org.openconcerto.devis.SQLElement#getComponent()

     */

    @Override

    public SQLComponent createComponent() {

        return new UserSQLComponent(this);

    }

    protected static class UserSQLComponent extends BaseSQLComponent {

        private JPasswordField passField;

        private JPasswordField passFieldConfirm;

        private JPanel panelWarning;

        private final SQLElement accessSocieteElem;

        private QuickAssignPanel table;

        // TODO transform into real SQLRowItemView

        private final JTextField encryptedPass = new JTextField();

        private JCheckBox noCompanyLimitCheckBox;

        {

            final SQLTable t = getTable().getDBSystemRoot().getGraph().findReferentTable(getTable(), "ACCES_SOCIETE");

            this.accessSocieteElem = t == null ? null : getDirectory().getElement(t);

        }

        protected UserSQLComponent(final SQLElement element) {

            super(element);

        }

        protected final JPasswordField getPassField() {

            return this.passField;

        }

        protected final JPasswordField getPassFieldConfirm() {

            return this.passFieldConfirm;

        }

        @Override

        public void addViews() {

            final GridBagConstraints c = new GridBagConstraints();

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

            c.gridx = 0;

            c.gridy = 0;

            c.weightx = 0;

            c.weighty = 0;

            c.fill = GridBagConstraints.HORIZONTAL;

            c.anchor = GridBagConstraints.WEST;

            this.panelWarning = new JPanel(new GridBagLayout());

            this.panelWarning.setBorder(BorderFactory.createEmptyBorder());

            final JLabelWarning labelWarning = new JLabelWarning();

            this.panelWarning.add(labelWarning, c);

            final JLabel labelTextWarning = new JLabel(TM.tr("user.passwordsDontMatch.short"));

            c.gridx++;

            this.panelWarning.add(labelTextWarning, c);

            final GridBagLayout layout = new GridBagLayout();

            this.setLayout(layout);

            // Login

            c.gridx = 0;

            c.insets = new Insets(2, 2, 1, 2);

            final JLabel labelLogin = new JLabel(getLabelFor("LOGIN"), SwingConstants.RIGHT);

            this.add(labelLogin, c);

            final JTextField textLogin = new JTextField();

            c.gridx++;

            DefaultGridBagConstraints.lockMinimumSize(textLogin);

            c.weightx = 1;

            this.add(textLogin, c);

            // Warning

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.gridx++;

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

            this.add(this.panelWarning, c);

            this.panelWarning.setVisible(false);

            // Pass

            c.gridy++;

            c.gridwidth = 1;

            c.gridx = 0;

            c.weightx = 0;

            c.insets = new Insets(2, 2, 1, 2);

            final JLabel labelPass = new JLabel(getLabelFor("PASSWORD"), SwingConstants.RIGHT);

            this.add(labelPass, c);

            this.passField = new JPasswordField(15);

            c.gridx++;

            c.weightx = 1;

            DefaultGridBagConstraints.lockMinimumSize(this.getPassField());

            this.add(this.getPassField(), c);

            // Confirmation password

            c.gridx++;

            c.weightx = 0;

            final JLabel labelConfirmationPass = new JLabel(getLabelFor("PASSWORD_CONFIRM"), SwingConstants.RIGHT);

            this.add(labelConfirmationPass, c);

            this.passFieldConfirm = new JPasswordField(15);

            c.gridx++;

            c.weightx = 1;

            DefaultGridBagConstraints.lockMinimumSize(this.getPassFieldConfirm());

            this.add(this.getPassFieldConfirm(), c);

            // Nom

            c.gridx = 0;

            c.gridy++;

            c.weightx = 0;

            final JLabel labelNom = new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT);

            this.add(labelNom, c);

            final JTextField textNom = new JTextField();

            c.gridx++;

            c.weightx = 1;

            this.add(textNom, c);

            // Prenom

            c.gridx++;

            c.weightx = 0;

            final JLabel labelPrenom = new JLabel(getLabelFor("PRENOM"), SwingConstants.RIGHT);

            this.add(labelPrenom, c);

            final JTextField textPrenom = new JTextField();

            c.gridx++;

            c.weightx = 1;

            this.add(textPrenom, c);

            // Surnom

            c.gridx = 0;

            c.gridy++;

            c.weightx = 0;

            final JLabel labelSurnom = new JLabel(getLabelFor("SURNOM"), SwingConstants.RIGHT);

            this.add(labelSurnom, c);

            final JTextField textSurnom = new JTextField();

            c.gridx++;

            c.weightx = 1;

            this.add(textSurnom, c);

            if (this.getTable().contains("ADMIN")) {

                final JCheckBox checkAdmin = new JCheckBox(getLabelFor("ADMIN"));

                c.gridx++;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 0;

                this.add(checkAdmin, c);

                this.addView(checkAdmin, "ADMIN");

            }

            c.gridy++;

            c.gridwidth = 1;

            c.gridx = 0;

            c.weightx = 0;

            if (getTable().contains("MAIL")) {

                final JLabel labelMail = new JLabel(getLabelFor("MAIL"), SwingConstants.RIGHT);

                c.anchor = GridBagConstraints.NORTHWEST;

                this.add(labelMail, c);

                c.gridx++;

                final JTextField textMail = new JTextField();

                c.gridwidth = 1;

                c.weightx = 1;

                this.add(textMail, c);

                this.addView(textMail, "MAIL");

            }

            if (getTable().contains("OUT")) {

                c.gridx++;

                final JCheckBox boxOut = new JCheckBox(getLabelFor("OUT"));

                c.gridwidth = 1;

                c.weightx = 1;

                c.gridwidth = GridBagConstraints.REMAINDER;

                this.add(boxOut, c);

                this.addView(boxOut, "OUT");

            } else {

                if (getTable().contains("DISABLED")) {

                    c.gridx++;

                    final JCheckBox boxDisabled = new JCheckBox(getLabelFor("DISABLED"));

                    c.gridwidth = 1;

                    c.weightx = 1;

                    c.gridwidth = GridBagConstraints.REMAINDER;

                    this.add(boxDisabled, c);

                    this.addView(boxDisabled, "DISABLED");

                }

            }

            c.gridy++;

            if (getTable().contains("COMPTE_NUMERO")) {

                final JLabel labelMail = new JLabel(getLabelFor("COMPTE_NUMERO"));

                labelMail.setHorizontalAlignment(SwingConstants.RIGHT);

                c.anchor = GridBagConstraints.NORTHWEST;

                this.add(labelMail, c);

                c.gridx++;

                final JTextField textMail = new JTextField();

                c.gridwidth = 1;

                c.weightx = 1;

                c.gridy++;

                this.add(textMail, c);

                this.addView(textMail, "COMPTE_NUMERO");

            }

            if (getTable().contains("TEL")) {

                c.gridx = 0;

                final JLabel labelTel = new JLabel(getLabelFor("TEL"), SwingConstants.RIGHT);

                c.gridwidth = 1;

                c.weightx = 0;

                this.add(labelTel, c);

                final JTextField fieldTel = new JTextField(20);

                c.gridx++;

                c.weightx = 1;

                this.add(fieldTel, c);

                this.addView(fieldTel, "TEL");

            }

            if (getTable().contains("CALENDAR_USER")) {

                c.gridx = 2;

                final JCheckBox boxCalUser = new JCheckBox(getLabelFor("CALENDAR_USER"));

                c.weightx = 1;

                c.gridwidth = GridBagConstraints.REMAINDER;

                this.add(boxCalUser, c);

                this.addView(boxCalUser, "CALENDAR_USER");

            }

            if (getTable().contains("COLOR")) {

                c.gridy++;

                c.gridx = 0;

                final JLabel labelTel = new JLabel(getLabelFor("COLOR"), SwingConstants.RIGHT);

                c.gridwidth = 1;

                c.weightx = 0;

                this.add(labelTel, c);

                final IColorChooser colorChooser = new IColorChooser(getLabelFor("COLOR"));

                c.gridx++;

                c.weightx = 1;

                c.fill = GridBagConstraints.HORIZONTAL;

                this.add(colorChooser, c);

                this.addView(colorChooser, "COLOR");

            }

            final boolean gestionHoraire = false;

            if (Configuration.getInstance().getAppName().startsWith("OpenConcerto") && gestionHoraire) {

                c.gridwidth = 1;

                final JPanel panelHoraires = new JPanel(new GridBagLayout());

                final GridBagConstraints cH = new DefaultGridBagConstraints();

                createHalfDay(panelHoraires, cH, "Matin :", "MATIN", 8, 12);

                createHalfDay(panelHoraires, cH, "Après midi :", "MIDI", 13, 17);

                c.gridy++;

                c.gridx = 0;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 1;

                c.weighty = 0;

                panelHoraires.setBorder(BorderFactory.createTitledBorder("Horaires"));

                this.add(panelHoraires, c);

            }

            if (this.accessSocieteElem != null) {

                c.gridy++;

                c.gridx = 0;

                c.gridwidth = 4;

                this.add(new JLabelBold("Accés aux sociétés"), c);

                c.gridy++;

                this.noCompanyLimitCheckBox = new JCheckBox("ne pas limiter l'accès à certaines sociétés");

                this.add(this.noCompanyLimitCheckBox, c);

                c.gridy++;

                c.weighty = 1;

                c.fill = GridBagConstraints.BOTH;

                final SQLElement companyElement = this.accessSocieteElem.getForeignElement("ID_SOCIETE_COMMON");

                final List<SQLTableElement> tableElements = new ArrayList<>();

                tableElements.add(new SQLTableElement(companyElement.getTable().getField("NOM")));

                final RowValuesTableModel model = new RowValuesTableModel(companyElement, tableElements, companyElement.getTable().getKey(), false);

                this.table = new QuickAssignPanel(companyElement, "ID", model);

                this.add(this.table, c);

                this.noCompanyLimitCheckBox.addItemListener(new ItemListener() {

                    @Override

                    public void itemStateChanged(final ItemEvent e) {

                        UserSQLComponent.this.table.setEnabled(e.getStateChange() == ItemEvent.DESELECTED);

                    }

                });

                getView("ADMIN").addValueListener(new PropertyChangeListener() {

                    @Override

                    public void propertyChange(final PropertyChangeEvent evt) {

                        final boolean selected = evt.getNewValue() == Boolean.TRUE;

                        UserSQLComponent.this.noCompanyLimitCheckBox.setEnabled(!selected);

                        if (selected)

                            UserSQLComponent.this.noCompanyLimitCheckBox.setSelected(true);

                    }

                });

                this.noCompanyLimitCheckBox.setSelected(true);

            }

            this.addRequiredSQLObject(textLogin, "LOGIN");

            this.addView(new SimpleRowItemView<String>(new TextValueWrapper(this.encryptedPass)) {

                @Override

                public void setEditable(final InteractionMode mode) {

                    mode.applyTo(getPassField());

                    mode.applyTo(getPassFieldConfirm());

                }

            }, "PASSWORD", REQ);

            this.addSQLObject(textNom, "NOM");

            this.addSQLObject(textPrenom, "PRENOM");

            this.addSQLObject(textSurnom, "SURNOM");

            this.getPassField().getDocument().addDocumentListener(new SimpleDocumentListener() {

                @Override

                public void update(final DocumentEvent e) {

                    updateEncrypted();

                    fireValidChange();

                }

            });

            this.getPassFieldConfirm().getDocument().addDocumentListener(new SimpleDocumentListener() {

                @Override

                public void update(final DocumentEvent e) {

                    fireValidChange();

                }

            });

            this.addViews(c);

        }

        protected void addViews(final GridBagConstraints c) {

        }

        // après midi arrivée 13:30

        // __________ départ 17:53

        private void createHalfDay(final JPanel panelHoraires, final GridBagConstraints cH, final String label, final String field, final int startHour, final int endHour) {

            panelHoraires.add(new JLabel(label), cH);

            cH.gridx++;

            createTime(panelHoraires, cH, "arrivée", field + "_A", startHour);

            cH.gridy++;

            cH.gridx = 1;

            createTime(panelHoraires, cH, "départ", field + "_D", endHour);

            cH.gridy++;

            cH.gridx = 0;

        }

        // départ 17:53

        private void createTime(final JPanel panelHoraires, final GridBagConstraints cH, final String label, final String field, final int hour) {

            panelHoraires.add(new JLabel(label), cH);

            cH.gridx++;

            final ISpinner spinHourMA = createSpinner(panelHoraires, cH, true, hour);

            final ISpinner spinMinMA = createSpinner(panelHoraires, cH, false, 0);

            this.addView(new SimpleRowItemView<Integer>(spinHourMA), "HEURE_" + field, null);

            this.addView(new SimpleRowItemView<Integer>(spinMinMA), "MINUTE_" + field, null);

        }

        // 17 h or 53 min

        private ISpinner createSpinner(final JPanel panelHoraires, final GridBagConstraints cH, final boolean hour, final int value) {

            final ISpinnerIntegerModel modelHourMA = new ISpinnerIntegerModel(0, hour ? 23 : 59, value);

            final ISpinner spinHourMA = new ISpinner(modelHourMA);

            panelHoraires.add(spinHourMA.getComp(), cH);

            cH.gridx++;

            panelHoraires.add(new JLabel(hour ? "h" : "min"), cH);

            cH.gridx++;

            return spinHourMA;

        }

        private void updateEncrypted() {

            final String pass = String.valueOf(this.getPassField().getPassword());

            final String dbPass = Boolean.getBoolean(LEGACY_PASSWORDS) ? '"' + pass + '"' : pass;

            this.encryptedPass.setText(Login.encodePassword(dbPass));

            System.err.println("UserCommonSQLElement.UserSQLComponent.updateEncrypted() encode:"+dbPass+":"+this.encryptedPass.getText());

        }

        private boolean checkValidityPassword() {

            final boolean b = String.valueOf(this.getPassField().getPassword()).equalsIgnoreCase(String.valueOf(this.getPassFieldConfirm().getPassword()));

            this.panelWarning.setVisible(!b);

            return b;

        }

        @Override

        public synchronized ValidState getValidState() {

            return super.getValidState().and(ValidState.createCached(checkValidityPassword(), TM.tr("user.passwordsDontMatch")));

        }

        @Override

        public void select(final SQLRowAccessor row) {

            // show something in the user-visible text fields, but do it before the real select

            // so that this.encryptedPass (which will be updated by updateEncrypted() and thus

            // have a bogus value) will be changed to its database value and thus the user can

            // update any field without changing the password.

            if (this.table != null) {

                this.table.getModel().clearRows();

            }

            if (row != null) {

                final String bogusPass = "bogusPass!";

                this.getPassField().setText(bogusPass);

                this.getPassFieldConfirm().setText(bogusPass);

                // Allowed companies

                if (this.accessSocieteElem != null) {

                    final SQLTable tableCompanyAccess = this.accessSocieteElem.getTable();

                    final SQLRowValues graph = new SQLRowValues(tableCompanyAccess);

                    graph.put("ID", null);

                    graph.putRowValues("ID_SOCIETE_COMMON").put("NOM", null);

                    final SQLRowValuesListFetcher f = new SQLRowValuesListFetcher(graph);

                    f.setSelTransf(new ITransformer<SQLSelect, SQLSelect>() {

                        @Override

                        public SQLSelect transformChecked(final SQLSelect input) {

                            input.setWhere(new Where(tableCompanyAccess.getField("ID_USER_COMMON"), "=", row.getID()));

                            return input;

                        }

                    });

                    final List<SQLRowValues> companies = f.fetch();

                    for (final SQLRowValues r : companies) {

                        this.table.getModel().addRow(r.getForeign("ID_SOCIETE_COMMON").asRowValues());

                    }

                    this.noCompanyLimitCheckBox.setSelected(companies.isEmpty());

                }

            }

            super.select(row);

        }

        @Override

        public int insert(SQLRow order) {

            int id = super.insert(order);

            if (this.table != null && !noCompanyLimitCheckBox.isSelected()) {

                insertCompanyAccessForUser(id);

            }

            return id;

        }

        private void insertCompanyAccessForUser(final int id) {

            final SQLTable tableCompanyAccess = this.getDirectory().getElement("ACCES_SOCIETE").getTable();

            final int stop = this.table.getModel().getRowCount();

            for (int i = 0; i < stop; i++) {

                final SQLRowValues rCompany = this.table.getModel().getRowValuesAt(i);

                final SQLRowValues rAccess = new SQLRowValues(tableCompanyAccess);

                rAccess.put("ID_USER_COMMON", id);

                rAccess.put("ID_SOCIETE_COMMON", rCompany.getID());

                try {

                    rAccess.commit();

                } catch (final SQLException e) {

                    ExceptionHandler.handle("Unable to store company access", e);

                }

            }

        }

        @Override

        public void update() {

            super.update();

            if (this.table != null) {

                final SQLTable tableCompanyAccess = this.getDirectory().getElement("ACCES_SOCIETE").getTable();

                String query = "DELETE FROM " + tableCompanyAccess.getSQL() + " WHERE \"ID_USER_COMMON\" = " + getSelectedID();

                tableCompanyAccess.getDBSystemRoot().getDataSource().execute(query);

                if (!noCompanyLimitCheckBox.isSelected()) {

                    insertCompanyAccessForUser(getSelectedID());

                }

            }

        }

    }

}