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.config.ComptaPropsConfiguration;

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

import org.openconcerto.erp.core.humanresources.payroll.ui.ContratPenibiliteTable;

import org.openconcerto.erp.model.PrixHT;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.ElementSQLObject;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JDate;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.util.ArrayList;

import java.util.List;

import javax.swing.BorderFactory;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import javax.swing.event.DocumentEvent;

import javax.swing.event.DocumentListener;

public class InfosSalariePayeSQLElement extends ComptaSQLConfElement {

    public InfosSalariePayeSQLElement() {

        super("INFOS_SALARIE_PAYE", "une fiche d'informations salarié-paye", "fiches d'informations salariés-payes");

    }

    @Override

    public boolean isPrivate() {

        return true;

    }

    protected List<String> getListFields() {

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

        l.add("ID_IDCC");

        l.add("ID_SALARIE");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("ID_SALARIE");

        l.add("ID_CONTRAT_SALARIE");

        return l;

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            private JTextField dureeMois;

            private JTextField dureeHebdo;

            private DocumentListener listenerMois = new DocumentListener() {

                public void insertUpdate(DocumentEvent e) {

                    updateHebdo();

                }

                public void removeUpdate(DocumentEvent e) {

                    updateHebdo();

                }

                public void changedUpdate(DocumentEvent e) {

                    updateHebdo();

                }

            };

            private DocumentListener listenerHebdo = new DocumentListener() {

                public void insertUpdate(DocumentEvent e) {

                    updateMois();

                }

                public void removeUpdate(DocumentEvent e) {

                    updateMois();

                }

                public void changedUpdate(DocumentEvent e) {

                    updateMois();

                }

            };

            ContratPenibiliteTable tablePeni = new ContratPenibiliteTable();

            @Override

            public int insert(SQLRow order) {

                // TODO Auto-generated method stub

                int id = super.insert(order);

                tablePeni.updateField("ID_INFOS_SALARIE_PAYE", id);

                return id;

            }

            @Override

            public void update() {

                // TODO Auto-generated method stub

                int id = getSelectedID();

                super.update();

                tablePeni.updateField("ID_INFOS_SALARIE_PAYE", id);

            }

            public void addViews() {

                this.setLayout(new GridBagLayout());

                GridBagConstraints c = new DefaultGridBagConstraints();

                // Convention collective

                JLabel labelConvention = new JLabel(getLabelFor("ID_IDCC"));

                labelConvention.setHorizontalAlignment(SwingConstants.RIGHT);

                final ElementComboBox comboConvention = new ElementComboBox();

                this.add(labelConvention, c);

                c.gridx++;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 1;

                this.add(comboConvention, c);

                c.gridwidth = 1;

                // Contrat

                c.fill = GridBagConstraints.BOTH;

                JPanel panelContrat = new JPanel();

                panelContrat.setOpaque(false);

                panelContrat.setBorder(BorderFactory.createTitledBorder("Contrat de travail"));

                panelContrat.setLayout(new GridBagLayout());

                GridBagConstraints c2 = new DefaultGridBagConstraints();

                c2.fill = GridBagConstraints.HORIZONTAL;

                c2.weighty = 1;

                c2.weightx = 1;

                c2.anchor = GridBagConstraints.NORTH;

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

                ElementSQLObject eltContrat = (ElementSQLObject) this.getView("ID_CONTRAT_SALARIE");

                panelContrat.add(eltContrat, c2);

                c.gridx = 0;

                c.gridy++;

                c.gridheight = 1;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 1;

                this.add(panelContrat, c);

                c.gridwidth = 1;

                c.gridheight = 1;

                // Classement conventionnel

                c.fill = GridBagConstraints.BOTH;

                JPanel panelClassement = new JPanel();

                panelClassement.setOpaque(false);

                panelClassement.setBorder(BorderFactory.createTitledBorder("Classement conventionnel"));

                panelClassement.setLayout(new GridBagLayout());

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

                ElementSQLObject eltClassement = (ElementSQLObject) this.getView("ID_CLASSEMENT_CONVENTIONNEL");

                c.gridx = 0;

                c.gridy = 0;

                c.weightx = 1;

                panelClassement.add(eltClassement, c);

                c.gridy = 2;

                c.gridx = 0;

                c.gridwidth = 2;

                c.weightx = 1;

                this.add(panelClassement, c);

                // Classement conventionnel

                final SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();

                if (base.getTable("COEFF_PRIME") != null) {

                    c.fill = GridBagConstraints.BOTH;

                    JPanel panelCoeff = new JPanel();

                    panelCoeff.setOpaque(false);

                    panelCoeff.setBorder(BorderFactory.createTitledBorder("Coefficient prime"));

                    panelCoeff.setLayout(new GridBagLayout());

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

                    ElementSQLObject eltCoeff = (ElementSQLObject) this.getView("ID_COEFF_PRIME");

                    c.gridx = 0;

                    c.gridy = 0;

                    c.weightx = 1;

                    panelCoeff.add(eltCoeff, c);

                    c.gridy = 3;

                    c.gridx = 0;

                    c.gridwidth = 2;

                    c.weightx = 0;

                    this.add(panelCoeff, c);

                    c.gridwidth = 1;

                }

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

                 * DATE ENTREE / SORTIE

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

                JPanel panelEntreeSortie = new JPanel();

                panelEntreeSortie.setOpaque(false);

                panelEntreeSortie.setBorder(BorderFactory.createTitledBorder("Entrée/Sortie"));

                panelEntreeSortie.setLayout(new GridBagLayout());

                // Date d'arrivée dans la société

                JLabel labelDateArrive = new JLabel(getLabelFor("DATE_ARRIVE"));

                labelDateArrive.setHorizontalAlignment(SwingConstants.RIGHT);

                JDate dateArrive = new JDate(true);

                c.gridy = 0;

                c.gridx = 0;

                c.weightx = 0;

                c.fill = GridBagConstraints.HORIZONTAL;

                panelEntreeSortie.add(labelDateArrive, c);

                c.gridx++;

                panelEntreeSortie.add(dateArrive, c);

                // Date de sortie

                JLabel labelDateSortie = new JLabel(getLabelFor("DATE_SORTIE"));

                labelDateSortie.setHorizontalAlignment(SwingConstants.RIGHT);

                JDate dateSortie = new JDate();

                c.gridy++;

                c.gridx = 0;

                c.fill = GridBagConstraints.HORIZONTAL;

                panelEntreeSortie.add(labelDateSortie, c);

                c.gridx++;

                panelEntreeSortie.add(dateSortie, c);

                /*

                 * // Ancienneté JLabel labelAnc = new

                 * JLabel(Configuration.getInstance().getTranslator

                 * ().getLabelFor(InfosSalariePayeSQLElement

                 * .this.getTable().getField("DATE_SORTIE")));

                 * labelDateSortie.setHorizontalAlignment(SwingConstants.RIGHT); JTextField textAnc

                 * = new JTextField(5, false);

                 *

                 * c.gridy++; c.gridx = 0; c.fill = GridBagConstraints.HORIZONTAL;

                 * panelEntreeSortie.add(labelAnc, c); c.gridx++; panelEntreeSortie.add(textAnc, c);

                 */

                c.gridx = 2;

                c.gridy = 2;

                c.gridwidth = 2;

                this.add(panelEntreeSortie, c);

                c.gridwidth = 1;

                JPanel panelPeni = new JPanel();

                panelPeni.setOpaque(false);

                panelPeni.setBorder(BorderFactory.createTitledBorder("Pénibilité (S21.G00.34)"));

                panelPeni.setLayout(new GridBagLayout());

                GridBagConstraints cPeni = new DefaultGridBagConstraints();

                cPeni.weightx = 1;

                cPeni.weighty = 1;

                cPeni.fill = GridBagConstraints.BOTH;

                panelPeni.add(tablePeni, cPeni);

                c.gridy++;

                c.weighty = 1;

                c.fill = GridBagConstraints.BOTH;

                this.add(panelPeni, c);

                c.fill = GridBagConstraints.HORIZONTAL;

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

                 * Valeurs de bases

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

                JPanel panelBase = new JPanel();

                panelBase.setOpaque(false);

                panelBase.setBorder(BorderFactory.createTitledBorder("Valeurs de base"));

                panelBase.setLayout(new GridBagLayout());

                // Durée mensuelle

                JLabel labelDureeMois = new JLabel(getLabelFor("DUREE_MOIS"));

                labelDureeMois.setHorizontalAlignment(SwingConstants.RIGHT);

                this.dureeMois = new JTextField();

                c.gridy = 0;

                c.gridx = 0;

                c.gridheight = 1;

                c.fill = GridBagConstraints.HORIZONTAL;

                panelBase.add(labelDureeMois, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(this.dureeMois, c);

                // Durée hebdomadaire

                JLabel labelDureeHebdo = new JLabel(getLabelFor("DUREE_HEBDO"));

                labelDureeHebdo.setHorizontalAlignment(SwingConstants.RIGHT);

                this.dureeHebdo = new JTextField();

                c.gridx++;

                c.weightx = 0;

                panelBase.add(labelDureeHebdo, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(this.dureeHebdo, c);

                // Salaire de base

                JLabel labelSalaireBase = new JLabel(getLabelFor("SALAIRE_MOIS"));

                labelSalaireBase.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField salaireBase = new JTextField();

                c.gridx++;

                c.weightx = 0;

                panelBase.add(labelSalaireBase, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(salaireBase, c);

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

                    // PRIME_TRANSPORT

                    JLabel labelTransport = new JLabel(getLabelFor("PRIME_TRANSPORT"));

                    labelTransport.setHorizontalAlignment(SwingConstants.RIGHT);

                    c.gridy++;

                    c.gridx = 0;

                    c.gridheight = 1;

                    c.fill = GridBagConstraints.HORIZONTAL;

                    panelBase.add(labelTransport, c);

                    c.gridx++;

                    c.weightx = 1;

                    JTextField fieldTransp = new JTextField();

                    panelBase.add(fieldTransp, c);

                    addView(fieldTransp, "PRIME_TRANSPORT");

                    // Durée hebdomadaire

                    JLabel labelPanier = new JLabel(getLabelFor("PRIME_PANIER"));

                    labelPanier.setHorizontalAlignment(SwingConstants.RIGHT);

                    JTextField fieldPanier = new JTextField();

                    c.gridx++;

                    c.weightx = 0;

                    panelBase.add(labelPanier, c);

                    c.gridx++;

                    c.weightx = 1;

                    panelBase.add(fieldPanier, c);

                    addView(fieldPanier, "PRIME_PANIER");

                    // Salaire de base

                    JLabel labelLogement = new JLabel(getLabelFor("PRIME_LOGEMENT"));

                    labelLogement.setHorizontalAlignment(SwingConstants.RIGHT);

                    JTextField fieldLogement = new JTextField();

                    c.gridx++;

                    c.weightx = 0;

                    panelBase.add(labelLogement, c);

                    c.gridx++;

                    c.weightx = 1;

                    panelBase.add(fieldLogement, c);

                    addView(fieldLogement, "PRIME_LOGEMENT");

                    // PRIME_TRANSPORT

                    JLabel labelCnam = new JLabel(getLabelFor("NUMERO_CNAM"));

                    labelCnam.setHorizontalAlignment(SwingConstants.RIGHT);

                    c.gridy++;

                    c.gridx = 0;

                    c.gridheight = 1;

                    c.fill = GridBagConstraints.HORIZONTAL;

                    panelBase.add(labelCnam, c);

                    c.gridx++;

                    c.weightx = 1;

                    JTextField fieldCnam = new JTextField();

                    panelBase.add(fieldCnam, c);

                    addView(fieldCnam, "NUMERO_CNAM");

                    // Durée hebdomadaire

                    JLabel labelCNSS = new JLabel(getLabelFor("NUMERO_CNSS"));

                    labelCNSS.setHorizontalAlignment(SwingConstants.RIGHT);

                    JTextField fieldCnss = new JTextField();

                    c.gridx++;

                    c.weightx = 0;

                    panelBase.add(labelCNSS, c);

                    c.gridx++;

                    c.weightx = 1;

                    panelBase.add(fieldCnss, c);

                    addView(fieldCnss, "NUMERO_CNSS");

                }

                // Taux AT

                JLabel labelTauxAT = new JLabel(getLabelFor("TAUX_AT"));

                labelTauxAT.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField tauxAT = new JTextField();

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                panelBase.add(labelTauxAT, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(tauxAT, c);

                // Congés payés

                JLabel labelConges = new JLabel(getLabelFor("CONGES_PAYES"));

                labelConges.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField conges = new JTextField();

                c.gridx++;

                c.weightx = 0;

                panelBase.add(labelConges, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(conges, c);

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

                    JLabel labelFillon = new JLabel(getLabelFor("BASE_FILLON_ANNUELLE"));

                    labelFillon.setHorizontalAlignment(SwingConstants.RIGHT);

                    JTextField fillon = new JTextField();

                    c.gridx++;

                    c.weightx = 0;

                    panelBase.add(labelFillon, c);

                    c.gridx++;

                    c.weightx = 1;

                    panelBase.add(fillon, c);

                    addView(fillon, "BASE_FILLON_ANNUELLE");

                }

                // Code AT

                JLabel labelCodeAT = new JLabel(getLabelFor("CODE_AT"));

                labelCodeAT.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField CodeAT = new JTextField();

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                panelBase.add(labelCodeAT, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(CodeAT, c);

                addView(CodeAT, "CODE_AT", REQ);

                // Code section AT

                JLabel labelSectionAT = new JLabel(getLabelFor("CODE_SECTION_AT"));

                labelSectionAT.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField sectionAT = new JTextField();

                c.gridx++;

                c.weightx = 0;

                panelBase.add(labelSectionAT, c);

                c.gridx++;

                c.weightx = 1;

                panelBase.add(sectionAT, c);

                addView(sectionAT, "CODE_SECTION_AT");

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

                    JLabel labelForfait = new JLabel(getLabelFor("DUREE_FORFAIT"));

                    labelForfait.setHorizontalAlignment(SwingConstants.RIGHT);

                    JTextField forfait = new JTextField();

                    c.gridx++;

                    c.weightx = 0;

                    panelBase.add(labelForfait, c);

                    c.gridx++;

                    c.weightx = 1;

                    panelBase.add(forfait, c);

                    addView(forfait, "DUREE_FORFAIT");

                }

                c.gridy = 5;

                c.gridx = 0;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weighty = 1;

                c.weightx = 1;

                c.anchor = GridBagConstraints.NORTHWEST;

                this.add(panelBase, c);

                this.addRequiredSQLObject(comboConvention, "ID_IDCC");

                this.addRequiredSQLObject(dateArrive, "DATE_ARRIVE");

                this.addSQLObject(dateSortie, "DATE_SORTIE");

                this.addRequiredSQLObject(this.dureeHebdo, "DUREE_HEBDO");

                this.addRequiredSQLObject(this.dureeMois, "DUREE_MOIS");

                this.addRequiredSQLObject(tauxAT, "TAUX_AT");

                this.addRequiredSQLObject(conges, "CONGES_PAYES");

                this.addRequiredSQLObject(salaireBase, "SALAIRE_MOIS");

                // this.addRequiredSQLObject(textAnc, "ANCIENNETE");

                // Listener

                this.dureeMois.getDocument().addDocumentListener(this.listenerMois);

                this.dureeHebdo.getDocument().addDocumentListener(this.listenerHebdo);

            }

            private void updateHebdo() {

                if (this.dureeMois.getText().trim().length() == 0) {

                    return;

                } else {

                    this.dureeHebdo.getDocument().removeDocumentListener(this.listenerHebdo);

                    this.dureeHebdo.setText(String.valueOf(new PrixHT(Float.parseFloat(this.dureeMois.getText()) / (52.0 / 12.0)).getValue()));

                    this.dureeHebdo.getDocument().addDocumentListener(this.listenerHebdo);

                }

            }

            private void updateMois() {

                if (this.dureeHebdo.getText().trim().length() == 0) {

                    return;

                } else {

                    this.dureeMois.getDocument().removeDocumentListener(this.listenerMois);

                    this.dureeMois.setText(String.valueOf(new PrixHT(Float.parseFloat(this.dureeHebdo.getText()) * (52.0 / 12.0)).getValue()));

                    this.dureeMois.getDocument().addDocumentListener(this.listenerMois);

                }

            }

            @Override

            public void select(SQLRowAccessor r) {

                this.dureeMois.getDocument().removeDocumentListener(this.listenerMois);

                this.dureeHebdo.getDocument().removeDocumentListener(this.listenerHebdo);

                super.select(r);

                if (r != null) {

                    tablePeni.insertFrom("ID_INFOS_SALARIE_PAYE", r.getID());

                }

                this.dureeMois.getDocument().addDocumentListener(this.listenerMois);

                this.dureeHebdo.getDocument().addDocumentListener(this.listenerHebdo);

            }

        };

    }

    @Override

    protected String createCode() {

        return createCodeOfPackage() + ".info";

    }

}