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.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLComponent;

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.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashSet;

import java.util.List;

import java.util.Set;

import javax.swing.JLabel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

public class ContratSalarieSQLElement extends ComptaSQLConfElement {

    public ContratSalarieSQLElement() {

        super("CONTRAT_SALARIE", "un contrat salarié", "contrats salariés");

    }

    protected List<String> getListFields() {

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

        l.add("NATURE");

        return l;

    }

    @Override

    public Set<String> getInsertOnlyFields() {

        Set<String> s = new HashSet<String>();

        s.add("DATE_MODIFICATION");

        return s;

    }

    protected List<String> getComboFields() {

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

        l.add("NUMERO");

        l.add("DATE_DEBUT");

        return l;

    }

    @Override

    public boolean isPrivate() {

        return true;

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            public void addViews() {

                this.setLayout(new GridBagLayout());

                GridBagConstraints c = new DefaultGridBagConstraints();

                // Numero

                JLabel labelNumero = new JLabel(getLabelFor("NUMERO"));

                labelNumero.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField textNumero = new JTextField();

                this.add(labelNumero, c);

                c.gridx++;

                c.weightx = 1;

                this.add(textNumero, c);

                this.addRequiredSQLObject(textNumero, "NUMERO");

                c.gridy++;

                c.gridx = 0;

                // Nature

                JLabel labelNature = new JLabel(getLabelFor("NATURE"));

                labelNature.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField textNature = new JTextField();

                this.add(labelNature, c);

                c.gridx++;

                c.weightx = 1;

                c.gridwidth = 3;

                this.add(textNature, c);

                c.gridwidth = 1;

                // Catégorie socioprofessionnelle

                JLabel labelCatSocio = new JLabel(getLabelFor("ID_CODE_EMPLOI"));

                labelCatSocio.setHorizontalAlignment(SwingConstants.RIGHT);

                ElementComboBox selCodeCatSocio = new ElementComboBox();

                selCodeCatSocio.setInfoIconVisible(false);

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(labelCatSocio, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selCodeCatSocio, c);

                JLabel complPCSLabel = new JLabel(getLabelFor("COMPLEMENT_PCS"));

                complPCSLabel.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField complPCS = new JTextField();

                c.gridx++;

                c.weightx = 0;

                this.add(complPCSLabel, c);

                c.gridx++;

                c.weightx = 1;

                this.add(complPCS, c);

                addView(complPCS, "COMPLEMENT_PCS");

                JLabel objetSpecLabel = new JLabel(getLabelFor("SPECTACLE_OBJET"));

                objetSpecLabel.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField objetSpec = new JTextField();

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(objetSpecLabel, c);

                c.gridx++;

                c.weightx = 1;

                this.add(objetSpec, c);

                addView(objetSpec, "SPECTACLE_OBJET");

                objetSpec.setEditable(false);

                JLabel jourContratLabel = new JLabel(getLabelFor("SPECTACLE_JOUR_CONTRAT"));

                jourContratLabel.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField jourContrat = new JTextField();

                c.gridx++;

                c.weightx = 0;

                this.add(jourContratLabel, c);

                c.gridx++;

                c.weightx = 1;

                this.add(jourContrat, c);

                addView(jourContrat, "SPECTACLE_JOUR_CONTRAT");

                jourContrat.setEditable(false);

                final ElementComboBox selCaractActivite = new ElementComboBox();

                selCaractActivite.setInfoIconVisible(false);

                this.addRequiredSQLObject(selCaractActivite, "ID_CODE_CARACT_ACTIVITE");

                selCaractActivite.addModelListener("wantedID", new PropertyChangeListener() {

                    @Override

                    public void propertyChange(PropertyChangeEvent evt) {

                        final boolean b = selCaractActivite.getSelectedRow() != null && selCaractActivite.getSelectedRow().getString("CODE").equals("04");

                        objetSpec.setEditable(b);

                        jourContrat.setEditable(b);

                        if (!b) {

                            objetSpec.setText("");

                            ;

                            jourContrat.setText("");

                        }

                    }

                });

                // Contrat de travail

                JLabel labelContratTravail = new JLabel(getLabelFor("ID_CODE_CONTRAT_TRAVAIL"));

                labelContratTravail.setHorizontalAlignment(SwingConstants.RIGHT);

                ElementComboBox selContratTravail = new ElementComboBox();

                selContratTravail.setInfoIconVisible(false);

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(labelContratTravail, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selContratTravail, c);

                // Droit Contrat de travail

                JLabel labelDroitContrat = new JLabel(getLabelFor("ID_CODE_DROIT_CONTRAT"));

                labelDroitContrat.setHorizontalAlignment(SwingConstants.RIGHT);

                ElementComboBox selDroitContrat = new ElementComboBox();

                selDroitContrat.setInfoIconVisible(false);

                c.gridx++;

                c.weightx = 0;

                this.add(labelDroitContrat, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selDroitContrat, c);

                // caracteristiques activité

                JLabel labelCaractActivite = new JLabel(getLabelFor("ID_CODE_CARACT_ACTIVITE"));

                labelCaractActivite.setHorizontalAlignment(SwingConstants.RIGHT);

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(labelCaractActivite, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selCaractActivite, c);

                // Statut profesionnel

                JLabel labelStatutProf = new JLabel(getLabelFor("ID_CODE_STATUT_PROF"));

                labelStatutProf.setHorizontalAlignment(SwingConstants.RIGHT);

                ElementComboBox selStatutProf = new ElementComboBox();

                selStatutProf.setInfoIconVisible(false);

                c.gridx++;

                c.weightx = 0;

                this.add(labelStatutProf, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selStatutProf, c);

                // Statut categoriel

                JLabel labelStatutCat = new JLabel(getLabelFor("ID_CODE_STATUT_CATEGORIEL"));

                labelStatutCat.setHorizontalAlignment(SwingConstants.RIGHT);

                ElementComboBox selStatutCat = new ElementComboBox();

                selStatutCat.setInfoIconVisible(false);

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(labelStatutCat, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selStatutCat, c);

                // Statut categoriel

                JLabel labelStatutCatConv = new JLabel(getLabelFor("ID_CODE_STATUT_CAT_CONV"));

                labelStatutCatConv.setHorizontalAlignment(SwingConstants.RIGHT);

                ElementComboBox selStatutCatConv = new ElementComboBox();

                selStatutCatConv.setInfoIconVisible(false);

                c.gridx++;

                c.weightx = 0;

                this.add(labelStatutCatConv, c);

                c.gridx++;

                c.weightx = 1;

                this.add(selStatutCatConv, c);

                List<String> dsnFF = Arrays.asList("ID_CONTRAT_MODALITE_TEMPS", "ID_CONTRAT_REGIME_MALADIE", "ID_CONTRAT_REGIME_VIEILLESSE", "ID_CONTRAT_DETACHE_EXPATRIE",

                        "ID_CONTRAT_DISPOSITIF_POLITIQUE", "ID_CONTRAT_MOTIF_RECOURS", "ID_DIPLOME_PREPARE");

                int p = 0;

                for (String ffName : dsnFF) {

                    JLabel labelFF = new JLabel(getLabelFor(ffName));

                    labelFF.setHorizontalAlignment(SwingConstants.RIGHT);

                    ElementComboBox selFF = new ElementComboBox();

                    selFF.setInfoIconVisible(false);

                    if (p % 2 == 0) {

                        c.gridy++;

                        c.gridx = 0;

                    } else {

                        c.gridx++;

                    }

                    p++;

                    c.weightx = 0;

                    this.add(labelFF, c);

                    c.gridx++;

                    c.weighty = 1;

                    c.weightx = 1;

                    this.add(selFF, c);

                    if (ffName.equals("ID_CONTRAT_MOTIF_RECOURS") || ffName.equals("ID_DIPLOME_PREPARE")) {

                        this.addSQLObject(selFF, ffName);

                    } else {

                        this.addRequiredSQLObject(selFF, ffName);

                    }

                }

                // ccode congés payés

                JLabel labelCodeConges = new JLabel(getLabelFor("ID_CODE_CAISSE_CONGES_PAYES"));

                labelCodeConges.setHorizontalAlignment(SwingConstants.RIGHT);

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(labelCodeConges, c);

                c.gridx++;

                c.weightx = 1;

                ElementComboBox boxConges = new ElementComboBox(true);

                this.add(boxConges, c);

                this.addView(boxConges, "ID_CODE_CAISSE_CONGES_PAYES");

                // Statut profesionnel

                JLabel labelTauxProf = new JLabel(getLabelFor("TAUX_FRAIS_PROFESSIONNELS"));

                labelTauxProf.setHorizontalAlignment(SwingConstants.RIGHT);

                JTextField tauxProf = new JTextField();

                c.gridx++;

                c.weightx = 0;

                this.add(labelTauxProf, c);

                c.gridx++;

                c.weightx = 1;

                this.add(tauxProf, c);

                this.addView(tauxProf, "TAUX_FRAIS_PROFESSIONNELS");

                // Code Arrco, agirc retirés du contrat et ajoutés dans les caisses de cotisations

                // Code UGRR

                // JLabel labelCodeUGRR = new JLabel(getLabelFor("CODE_IRC_UGRR"));

                // labelCodeUGRR.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textCodeUGRR = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelCodeUGRR, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textCodeUGRR, c);

                // addView(textCodeUGRR, "CODE_IRC_UGRR");

                //

                // JLabel labelNumUGRR = new JLabel(getLabelFor("NUMERO_RATTACHEMENT_UGRR"));

                // labelNumUGRR.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textNumUGRR = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelNumUGRR, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textNumUGRR, c);

                // addView(textNumUGRR, "NUMERO_RATTACHEMENT_UGRR");

                //

                // // Code UGRC

                // JLabel labelCodeUGRC = new JLabel(getLabelFor("CODE_IRC_UGRC"));

                // labelCodeUGRC.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textCodeUGRC = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelCodeUGRC, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textCodeUGRC, c);

                // addView(textCodeUGRC, "CODE_IRC_UGRC");

                //

                // JLabel labelNumUGRC = new JLabel(getLabelFor("NUMERO_RATTACHEMENT_UGRC"));

                // labelNumUGRC.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textNumUGRC = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelNumUGRC, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textNumUGRC, c);

                // addView(textNumUGRC, "NUMERO_RATTACHEMENT_UGRC");

                //

                // // Retraite

                // JLabel labelCodeRetraite = new JLabel(getLabelFor("CODE_IRC_RETRAITE"));

                // labelCodeRetraite.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textCodeRetraite = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelCodeRetraite, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textCodeRetraite, c);

                // addView(textCodeRetraite, "CODE_IRC_RETRAITE");

                //

                // JLabel labelNumRetraite = new

                // JLabel(getLabelFor("NUMERO_RATTACHEMENT_RETRAITE"));

                // labelNumRetraite.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textNumRetraite = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelNumRetraite, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textNumRetraite, c);

                // addView(textNumRetraite, "NUMERO_RATTACHEMENT_RETRAITE");

                // JLabel labelCodeRegimeRetraite = new

                // JLabel(getLabelFor("CODE_REGIME_RETRAITE_DSN"));

                // labelCodeRegimeRetraite.setHorizontalAlignment(SwingConstants.RIGHT);

                // JTextField textCodeRegimeRetraite = new JTextField();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelCodeRegimeRetraite, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textCodeRegimeRetraite, c);

                // addRequiredSQLObject(textCodeRegimeRetraite, "CODE_REGIME_RETRAITE_DSN");

                // JLabel labelDateModif = new JLabel(getLabelFor("DATE_MODIFICATION"));

                // labelDateModif.setHorizontalAlignment(SwingConstants.RIGHT);

                // JDate textDateModif = new JDate();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(textDateModif, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(textDateModif, c);

                // addSQLObject(textDateModif, "DATE_MODIFICATION");

                // JLabel labelCM = new JLabel(getLabelFor("ID_INFOS_SALARIE_PAYE_MODIFIE"));

                // labelCM.setHorizontalAlignment(SwingConstants.RIGHT);

                // ElementComboBox selCM = new ElementComboBox();

                // final SQLElement elementInfosPaye =

                // getDirectory().getElement("INFOS_SALARIE_PAYE");

                // selCM.init(elementInfosPaye, elementInfosPaye.createComboRequest());

                // selCM.setInfoIconVisible(false);

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelCM, c);

                // c.gridx++;

                // c.weighty = 1;

                // c.weightx = 1;

                // this.add(selCM, c);

                // this.addSQLObject(selCM, "ID_INFOS_SALARIE_PAYE_MODIFIE");

                JLabel labelDateDebut = new JLabel(getLabelFor("DATE_DEBUT"));

                labelDateDebut.setHorizontalAlignment(SwingConstants.RIGHT);

                JDate textDateDebut = new JDate();

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                this.add(labelDateDebut, c);

                c.gridx++;

                c.weightx = 1;

                this.add(textDateDebut, c);

                addSQLObject(textDateDebut, "DATE_DEBUT", REQ);

                JLabel labelDateFin = new JLabel(getLabelFor("DATE_PREV_FIN"));

                labelDateFin.setHorizontalAlignment(SwingConstants.RIGHT);

                JDate textDateFin = new JDate();

                c.gridx++;

                c.weightx = 0;

                this.add(labelDateFin, c);

                c.gridx++;

                c.weightx = 1;

                this.add(textDateFin, c);

                addSQLObject(textDateFin, "DATE_PREV_FIN");

                // Déplacer dans les arrets chomage intempérie

                // JLabel labelAmen = new JLabel(getLabelFor("ID_CODE_AMENAGEMENT_PARTIEL"));

                // labelAmen.setHorizontalAlignment(SwingConstants.RIGHT);

                // ElementComboBox selAmen = new ElementComboBox();

                // selAmen.setInfoIconVisible(false);

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelAmen, c);

                // c.gridx++;

                // c.weightx = 1;

                // this.add(selAmen, c);

                // this.addSQLObject(selAmen, "ID_CODE_AMENAGEMENT_PARTIEL");

                //

                // JLabel labelSupsension = new JLabel(getLabelFor("ID_CODE_SUSPENSION"));

                // labelSupsension.setHorizontalAlignment(SwingConstants.RIGHT);

                // ElementComboBox selSupsension = new ElementComboBox();

                // selSupsension.setInfoIconVisible(false);

                // c.gridx++;

                // c.weightx = 0;

                // this.add(labelSupsension, c);

                // c.gridx++;

                // c.weightx = 1;

                // this.add(selSupsension, c);

                // this.addSQLObject(selSupsension, "ID_CODE_SUSPENSION");

                //

                // JLabel labelDateDebutSusp = new JLabel(getLabelFor("DATE_DEBUT_SUSPENSION"));

                // labelDateDebutSusp.setHorizontalAlignment(SwingConstants.RIGHT);

                // JDate textDateDebutSups = new JDate();

                // c.gridy++;

                // c.gridx = 0;

                // c.weightx = 0;

                // this.add(labelDateDebutSusp, c);

                // c.gridx++;

                // c.weightx = 1;

                // this.add(textDateDebutSups, c);

                // this.addSQLObject(textDateDebutSups, "DATE_DEBUT_SUSPENSION");

                //

                // JLabel labelDateFinSups = new JLabel(getLabelFor("DATE_FIN_SUSPENSION"));

                // labelDateFinSups.setHorizontalAlignment(SwingConstants.RIGHT);

                // JDate textDateFinSuspension = new JDate();

                // c.gridx++;

                // c.weightx = 0;

                // this.add(labelDateFinSups, c);

                // c.gridx++;

                // c.weightx = 1;

                // this.add(textDateFinSuspension, c);

                // this.addSQLObject(textDateFinSuspension, "DATE_FIN_SUSPENSION");

                this.addRequiredSQLObject(selCodeCatSocio, "ID_CODE_EMPLOI");

                this.addRequiredSQLObject(selContratTravail, "ID_CODE_CONTRAT_TRAVAIL");

                this.addRequiredSQLObject(selDroitContrat, "ID_CODE_DROIT_CONTRAT");

                this.addRequiredSQLObject(selStatutProf, "ID_CODE_STATUT_PROF");

                this.addRequiredSQLObject(selStatutCat, "ID_CODE_STATUT_CATEGORIEL");

                this.addRequiredSQLObject(selStatutCatConv, "ID_CODE_STATUT_CAT_CONV");

                this.addRequiredSQLObject(textNature, "NATURE");

            }

        };

    }

    @Override

    protected String createCode() {

        return createCodeOfPackage() + ".contract.employe";

    }

}