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

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;

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

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

import org.openconcerto.sql.element.ElementSQLObject;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.DBRoot;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.SQLRequestComboBox;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.utils.ListMap;

import org.openconcerto.utils.NoneSelectedButtonGroup;

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

import javax.swing.tree.TreePath;

public class RubriqueBrutSQLElement extends ComptaSQLConfElement {

    public RubriqueBrutSQLElement(final DBRoot root) {

        super(root.getTable("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("COTISABLE");

        l.add("PART_CP");

        l.add("TAXABLE_CM");

        l.add("CSG_NORMAL");

        l.add("CSG_REDUIT");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("CODE");

        l.add("NOM");

        return l;

    }

    @Override

    public ListMap<String, String> getShowAs() {

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

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new RubriqueSQLComponent(this) {

            private SQLJavaEditor formuleBase, formuleTaux, formuleMontant;

            @Override

            protected void addViews(GridBagConstraints 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 = getDirectory().getElement(SalarieSQLElement.class);

                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");

                SQLRequestComboBox comboSelTypeRubrique = new SQLRequestComboBox(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);

                SQLRequestComboBox comboSelTypeImpression = new SQLRequestComboBox(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("TAXABLE_CM"));

                panelProp.add(checkImpo, cPanel);

                // Participation à la base cotisable

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkCotis = new JCheckBox(getLabelFor("COTISABLE"));

                panelProp.add(checkCotis, 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);

                // CSG Normal

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkCSGN = new JCheckBox(getLabelFor("CSG_NORMAL"));

                panelProp.add(checkCSGN, cPanel);

                // CSG Réduite

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkCSGR = new JCheckBox(getLabelFor("CSG_REDUIT"));

                panelProp.add(checkCSGR, cPanel);

                cPanel.gridx = 1;

                cPanel.weightx = 1;

                cPanel.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                cPanel.gridwidth = GridBagConstraints.REMAINDER;

                JCheckBox checkCSGSansAbattement = new JCheckBox(getLabelFor("PART_CSG_SANS_ABATTEMENT"));

                panelProp.add(checkCSGSansAbattement, cPanel);

                NoneSelectedButtonGroup groupCSG = new NoneSelectedButtonGroup();

                groupCSG.add(checkCSGN);

                groupCSG.add(checkCSGR);

                groupCSG.add(checkCSGSansAbattement);

                // Type

                JLabel labelSelCodeRubrique = new JLabel("Code DSN (S21.G00.51.011)");

                labelSelCodeRubrique.setHorizontalAlignment(SwingConstants.RIGHT);

                cPanel.gridy++;

                cPanel.gridx = 1;

                cPanel.gridheight = 1;

                cPanel.gridwidth = 1;

                cPanel.weightx = 0;

                cPanel.anchor = GridBagConstraints.WEST;

                panelProp.add(labelSelCodeRubrique, cPanel);

                ElementComboBox comboSelCodeRubrique = new ElementComboBox(false);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelProp.add(comboSelCodeRubrique, cPanel);

                this.addView(comboSelCodeRubrique, "ID_CODE_TYPE_RUBRIQUE_BRUT");

                // 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.gridx = 0;

                c.fill = GridBagConstraints.BOTH;

                c.weightx = 1;

                c.weighty = 1;

                this.add(tab, c);

                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(checkCotis, "COTISABLE");

                this.addSQLObject(checkCP, "PART_CP");

                this.addSQLObject(checkImpo, "TAXABLE_CM");

                this.addSQLObject(checkCSGN, "CSG_NORMAL");

                this.addSQLObject(checkCSGR, "CSG_REDUIT");

                this.addSQLObject(checkCSGSansAbattement, "PART_CSG_SANS_ABATTEMENT");

                selSalarie.addValueListener(new PropertyChangeListener() {

                    public void propertyChange(PropertyChangeEvent evt) {

                        formuleBase.setSalarieID(selSalarie.getSelectedId());

                        formuleTaux.setSalarieID(selSalarie.getSelectedId());

                        formuleMontant.setSalarieID(selSalarie.getSelectedId());

                    }

                });

            }

            @Override

            protected SQLRowValues createDefaults() {

                SQLRowValues rowVals = new SQLRowValues(getTable());

                rowVals.put("TAXABLE_CM", Boolean.TRUE);

                rowVals.put("COTISABLE", Boolean.TRUE);

                rowVals.put("PART_BRUT", Boolean.TRUE);

                rowVals.put("CSG_NORMAL", Boolean.TRUE);

                return rowVals;

            }

        };

    }

    @Override

    protected String createCode() {

        return "humanresources.payroll.category.raw";

    }

}