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.core.humanresources.payroll.element;

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

import org.openconcerto.erp.core.humanresources.payroll.component.FormuleTreeNode;

import org.openconcerto.erp.core.humanresources.payroll.component.VariableTree;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.ConfSQLElement;

import org.openconcerto.sql.element.ElementSQLObject;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.warning.JLabelWarning;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.util.ArrayList;

import java.util.List;

import java.util.Map;

import javax.swing.BorderFactory;

import javax.swing.ButtonGroup;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JScrollPane;

import javax.swing.JSeparator;

import javax.swing.JSplitPane;

import javax.swing.JTabbedPane;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import javax.swing.event.DocumentEvent;

import javax.swing.event.DocumentListener;

import javax.swing.tree.TreePath;

import org.apache.commons.dbutils.handlers.ArrayListHandler;

public class RubriqueBrutSQLElement extends ConfSQLElement {

    public RubriqueBrutSQLElement() {

        super("RUBRIQUE_BRUT", "une rubrique de brut", "rubriques de brut");

    }

    protected List<String> getListFields() {

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

        l.add("CODE");

        l.add("NOM");

        l.add("BASE");

        l.add("TAUX");

        l.add("MONTANT");

        l.add("PART_BRUT");

        l.add("PART_CP");

        l.add("IMPOSABLE");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("CODE");

        l.add("NOM");

        return l;

    }

    protected List<String> getPrivateFields() {

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

        l.add("ID_PERIODE_VALIDITE");

        return l;

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            private JTextField textCode = new JTextField();

            private JTextField textLibelle = new JTextField();

            private SQLJavaEditor formuleBase, formuleTaux, formuleMontant;

            private JLabel labelWarningBadName, labelBadName;

            private boolean validCode;

            public void addViews() {

                this.labelWarningBadName = new JLabelWarning();

                this.labelBadName = new JLabel("Code déjà attribué.");

                this.validCode = true;

                this.setLayout(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

                // Code

                JLabel labelCode = new JLabel(getLabelFor("CODE"));

                labelCode.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelCode, c);

                c.gridx++;

                c.weightx = 1;

                this.add(this.textCode, c);

                c.weightx = 0;

                this.textCode.getDocument().addDocumentListener(new DocumentListener() {

                    public void insertUpdate(DocumentEvent e) {

                        isValidCodeName();

                    }

                    public void removeUpdate(DocumentEvent e) {

                        isValidCodeName();

                    }

                    public void changedUpdate(DocumentEvent e) {

                        isValidCodeName();

                    }

                });

                c.gridx++;

                this.add(this.labelWarningBadName);

                this.labelWarningBadName.setVisible(false);

                c.gridx++;

                this.add(this.labelBadName);

                this.labelBadName.setVisible(false);

                // Libelle

                c.gridy++;

                c.gridx = 0;

                JLabel labelNom = new JLabel(getLabelFor("NOM"));

                labelNom.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelNom, c);

                c.gridx++;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 1;

                this.add(this.textLibelle, c);

                c.weightx = 0;

                c.gridwidth = 1;

                /***********************************************************************************

                 * PANEL CALCUL

                 **********************************************************************************/

                JPanel panelCalcul = new JPanel();

                panelCalcul.setLayout(new GridBagLayout());

                final GridBagConstraints cPanel = new DefaultGridBagConstraints();

                final VariableTree tree = new VariableTree();

                JScrollPane paneTree = new JScrollPane(tree);

                cPanel.gridheight = GridBagConstraints.REMAINDER;

                cPanel.weighty = 1;

                cPanel.weightx = 1;

                cPanel.fill = GridBagConstraints.BOTH;

                // panelCalcul.add(paneTree, cPanel);

                cPanel.fill = GridBagConstraints.HORIZONTAL;

                cPanel.weighty = 0;

                cPanel.weightx = 0;

                cPanel.gridheight = 1;

                // Formule base

                cPanel.gridx++;

                final Map<String, List<?>> mapTree = VariablePayeSQLElement.getMapTree();

                this.formuleBase = new SQLJavaEditor(mapTree);

                this.formuleBase.setVarAssign("BASE");

                final JRadioButton radioBase = new JRadioButton(getLabelFor("BASE"));

                panelCalcul.add(radioBase, cPanel);

                cPanel.gridx++;

                panelCalcul.add(this.formuleBase, cPanel);

                JSeparator sep1 = new JSeparator();

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                cPanel.gridy++;

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                panelCalcul.add(sep1, cPanel);

                cPanel.gridwidth = 1;

                cPanel.weightx = 0;

                // Formule Taux

                cPanel.gridy++;

                cPanel.gridx = 1;

                this.formuleTaux = new SQLJavaEditor(mapTree);

                this.formuleTaux.setVarAssign("TAUX");

                final JRadioButton radioTaux = new JRadioButton(getLabelFor("TAUX"));

                panelCalcul.add(radioTaux, cPanel);

                cPanel.gridx++;

                panelCalcul.add(this.formuleTaux, cPanel);

                JSeparator sep2 = new JSeparator();

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                cPanel.gridy++;

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                panelCalcul.add(sep2, cPanel);

                cPanel.gridwidth = 1;

                cPanel.weightx = 0;

                // Formule Montant

                cPanel.gridy++;

                cPanel.gridx = 1;

                this.formuleMontant = new SQLJavaEditor(mapTree);

                this.formuleMontant.setVarAssign("MONTANT");

                final JRadioButton radioMontant = new JRadioButton(getLabelFor("MONTANT"));

                panelCalcul.add(radioMontant, cPanel);

                cPanel.gridx++;

                panelCalcul.add(this.formuleMontant, cPanel);

                JSeparator sep3 = new JSeparator();

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                cPanel.gridy++;

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                panelCalcul.add(sep3, cPanel);

                cPanel.gridwidth = 1;

                cPanel.weightx = 0;

                // Salarie

                cPanel.gridy++;

                cPanel.gridx = 1;

                JLabel labelSelSal = new JLabel("Salarié");

                labelSelSal.setHorizontalAlignment(SwingConstants.RIGHT);

                panelCalcul.add(labelSelSal, cPanel);

                SQLElement eltSal = new SalarieSQLElement();

                final ElementComboBox selSalarie = new ElementComboBox(false);

                cPanel.gridx++;

                selSalarie.init(eltSal);

                panelCalcul.add(selSalarie, cPanel);

                ButtonGroup groupRadio = new ButtonGroup();

                groupRadio.add(radioBase);

                groupRadio.add(radioMontant);

                groupRadio.add(radioTaux);

                radioBase.setSelected(true);

                tree.addMouseListener(new MouseAdapter() {

                    public void mousePressed(MouseEvent e) {

                        if (e.getClickCount() == 2 && e.getButton() == MouseEvent.BUTTON1) {

                            TreePath path = tree.getClosestPathForLocation(e.getPoint().x, e.getPoint().y);

                            final Object obj = path.getLastPathComponent();

                            if (obj == null) {

                                return;

                            } else {

                                if (obj instanceof FormuleTreeNode) {

                                    FormuleTreeNode n = (FormuleTreeNode) obj;

                                    if (radioBase.isSelected()) {

                                        int start = formuleBase.getSelectionStart();

                                        String tmp = formuleBase.getText();

                                        formuleBase.setText(tmp.substring(0, start) + n.getTextValue() + tmp.substring(start, tmp.length()));

                                    } else {

                                        if (radioMontant.isSelected()) {

                                            int start = formuleMontant.getSelectionStart();

                                            String tmp = formuleMontant.getText();

                                            formuleMontant.setText(tmp.substring(0, start) + n.getTextValue() + tmp.substring(start, tmp.length()));

                                        } else {

                                            int start = formuleTaux.getSelectionStart();

                                            String tmp = formuleTaux.getText();

                                            formuleTaux.setText(tmp.substring(0, start) + n.getTextValue() + tmp.substring(start, tmp.length()));

                                        }

                                    }

                                }

                            }

                        }

                    }

                });

                /***********************************************************************************

                 * PANEL PROPRIETE

                 **********************************************************************************/

                JPanel panelProp = new JPanel();

                panelProp.setLayout(new GridBagLayout());

                cPanel.gridx = 0;

                cPanel.gridy = 0;

                cPanel.weightx = 0;

                cPanel.weighty = 0;

                cPanel.gridwidth = 1;

                cPanel.gridheight = 1;

                cPanel.fill = GridBagConstraints.HORIZONTAL;

                cPanel.anchor = GridBagConstraints.NORTHWEST;

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

                // Periode d'application

                this.addView("ID_PERIODE_VALIDITE", REQ + ";" + DEC + ";" + SEP);

                ElementSQLObject eltInfosPaye = (ElementSQLObject) this.getView("ID_PERIODE_VALIDITE");

                cPanel.gridy = 0;

                cPanel.gridx = 0;

                cPanel.gridheight = GridBagConstraints.REMAINDER;

                cPanel.weighty = 1;

                cPanel.fill = GridBagConstraints.NONE;

                JPanel panelPeriodeVal = new JPanel();

                panelPeriodeVal.setBorder(BorderFactory.createTitledBorder("Période de validité"));

                panelPeriodeVal.add(eltInfosPaye);

                panelProp.add(panelPeriodeVal, cPanel);

                cPanel.weightx = 0;

                cPanel.weighty = 0;

                cPanel.gridheight = 1;

                cPanel.fill = GridBagConstraints.HORIZONTAL;

                // Type

                JLabel labelSelTypeRubrique = new JLabel("Type");

                labelSelTypeRubrique.setHorizontalAlignment(SwingConstants.RIGHT);

                cPanel.gridx++;

                cPanel.gridheight = 1;

                cPanel.weightx = 0;

                cPanel.anchor = GridBagConstraints.WEST;

                panelProp.add(labelSelTypeRubrique, cPanel);

                // SQLElement eltType =

                // Configuration.getInstance().getDirectory().getElement("TYPE_RUBRIQUE_BRUT");

                ElementComboBox comboSelTypeRubrique = new ElementComboBox(false);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelProp.add(comboSelTypeRubrique, cPanel);

                // Impression

                JLabel labelSelTypeRubriqueImpression = new JLabel("Impression");

                cPanel.gridy++;

                cPanel.gridx = 1;

                cPanel.weightx = 0;

                panelProp.add(labelSelTypeRubriqueImpression, cPanel);

                ElementComboBox comboSelTypeImpression = new ElementComboBox(false);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelProp.add(comboSelTypeImpression, cPanel);

                // Imposable

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkImpo = new JCheckBox(getLabelFor("IMPOSABLE"));

                panelProp.add(checkImpo, cPanel);

                // Participation à la base brute

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkBrut = new JCheckBox(getLabelFor("PART_BRUT"));

                panelProp.add(checkBrut, cPanel);

                // Participation aux congés payés

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkCP = new JCheckBox(getLabelFor("PART_CP"));

                panelProp.add(checkCP, cPanel);

                // Tabbed Pane

                JTabbedPane tab = new JTabbedPane();

                tab.add("Calcul", new JSplitPane(JSplitPane.HORIZONTAL_SPLIT, paneTree, panelCalcul));

                tab.add("Propriétés", panelProp);

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                c.fill = GridBagConstraints.BOTH;

                c.weightx = 1;

                c.weighty = 1;

                this.add(tab, c);

                this.addRequiredSQLObject(this.textCode, "CODE");

                this.addSQLObject(this.textLibelle, "NOM");

                this.addSQLObject(this.formuleBase, "BASE");

                this.addSQLObject(this.formuleTaux, "TAUX");

                this.addSQLObject(this.formuleMontant, "MONTANT");

                this.addRequiredSQLObject(comboSelTypeRubrique, "ID_TYPE_RUBRIQUE_BRUT");

                this.addRequiredSQLObject(comboSelTypeImpression, "ID_IMPRESSION_RUBRIQUE");

                this.addSQLObject(checkBrut, "PART_BRUT");

                this.addSQLObject(checkCP, "PART_CP");

                this.addSQLObject(checkImpo, "IMPOSABLE");

                selSalarie.addValueListener(new PropertyChangeListener() {

                    public void propertyChange(PropertyChangeEvent evt) {

                        formuleBase.setSalarieID(selSalarie.getSelectedId());

                        formuleTaux.setSalarieID(selSalarie.getSelectedId());

                        formuleMontant.setSalarieID(selSalarie.getSelectedId());

                    }

                });

            }

            private void isValidCodeName() {

                System.err.println("Changed valid");

                // on vérifie que la variable n'existe pas déja

                SQLSelect selAllCodeName = new SQLSelect(getTable().getBase());

                selAllCodeName.addSelect(getTable().getField("ID"));

                selAllCodeName.setWhere("RUBRIQUE_BRUT.CODE", "=", this.textCode.getText().trim());

                int idSelected = this.getSelectedID();

                if (idSelected > 1) {

                    selAllCodeName.andWhere(new Where(getTable().getField("ID"), "!=", idSelected));

                }

                String reqAllCodeName = selAllCodeName.asString();

                Object[] objCodeID = ((List) getTable().getBase().getDataSource().execute(reqAllCodeName, new ArrayListHandler())).toArray();

                SQLSelect selAllVarName = new SQLSelect(getTable().getBase());

                SQLTable tableVar = getTable().getBase().getTable("VARIABLE_PAYE");

                selAllVarName.addSelect(tableVar.getField("ID"));

                selAllVarName.setWhere("VARIABLE_PAYE.NOM", "=", this.textCode.getText().trim());

                String reqAllVarName = selAllVarName.asString();

                Object[] objVarID = ((List) getTable().getBase().getDataSource().execute(reqAllVarName, new ArrayListHandler())).toArray();

                // System.err.println("nb var same " + objVarID.length + " --- nb code same " +

                // objCodeID.length);

                if ((objCodeID.length > 0) || (objVarID.length > 0)) {

                    this.labelWarningBadName.setVisible(true);

                    this.labelBadName.setVisible(true);

                    this.validCode = false;

                } else {

                    List l = VariablePayeSQLElement.getForbiddenVarName();

                    for (int i = 0; i < l.size(); i++) {

                        if (l.get(i).toString().trim().equals(this.textCode.getText().trim())) {

                            this.labelWarningBadName.setVisible(true);

                            this.labelBadName.setVisible(true);

                            this.validCode = false;

                            return;

                        }

                    }

                    this.labelWarningBadName.setVisible(false);

                    this.labelBadName.setVisible(false);

                    this.validCode = true;

                }

            }

            public synchronized boolean isValidated() {

                return super.isValidated() && this.validCode;

            }

            @Override

            public void select(SQLRowAccessor r) {

                super.select(r);

                isValidCodeName();

            }

        };

    }

}