WebSVN - OpenConcerto - Diff - Rev 177 and 180 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/humanresources/payroll/element/ContratSalarieSQLElement.java


/*
 * 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.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);
                    }
                }
 
                // 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");
 
                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";
    }
}

Rev 177	Rev 180
1	`/*`	1	`/*`
2	`* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.`	2	`* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.`
3	`*`	3	`*`
4	`* Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.`	4	`* Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.`
5	`*`	5	`*`
6	`* The contents of this file are subject to the terms of the GNU General Public License Version 3`	6	`* The contents of this file are subject to the terms of the GNU General Public License Version 3`
7	`* only ("GPL"). You may not use this file except in compliance with the License. You can obtain a`	7	`* only ("GPL"). You may not use this file except in compliance with the License. You can obtain a`
8	`* copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific`	8	`* copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific`
9	`* language governing permissions and limitations under the License.`	9	`* language governing permissions and limitations under the License.`
10	`*`	10	`*`
11	`* When distributing the software, include this License Header Notice in each file.`	11	`* When distributing the software, include this License Header Notice in each file.`
12	`*/`	12	`*/`
13		13
14	`package org.openconcerto.erp.core.humanresources.payroll.element;`	14	`package org.openconcerto.erp.core.humanresources.payroll.element;`
15		15
16	`import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;`	16	`import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;`
17	`import org.openconcerto.sql.element.BaseSQLComponent;`	17	`import org.openconcerto.sql.element.BaseSQLComponent;`
18	`import org.openconcerto.sql.element.SQLComponent;`	18	`import org.openconcerto.sql.element.SQLComponent;`
19	`import org.openconcerto.sql.sqlobject.ElementComboBox;`	19	`import org.openconcerto.sql.sqlobject.ElementComboBox;`
20	`import org.openconcerto.ui.DefaultGridBagConstraints;`	20	`import org.openconcerto.ui.DefaultGridBagConstraints;`
21	`import org.openconcerto.ui.JDate;`	21	`import org.openconcerto.ui.JDate;`
22		22
23	`import java.awt.GridBagConstraints;`	23	`import java.awt.GridBagConstraints;`
24	`import java.awt.GridBagLayout;`	24	`import java.awt.GridBagLayout;`
25	`import java.beans.PropertyChangeEvent;`	25	`import java.beans.PropertyChangeEvent;`
26	`import java.beans.PropertyChangeListener;`	26	`import java.beans.PropertyChangeListener;`
27	`import java.util.ArrayList;`	27	`import java.util.ArrayList;`
28	`import java.util.Arrays;`	28	`import java.util.Arrays;`
29	`import java.util.HashSet;`	29	`import java.util.HashSet;`
30	`import java.util.List;`	30	`import java.util.List;`
31	`import java.util.Set;`	31	`import java.util.Set;`
32		32
33	`import javax.swing.JLabel;`	33	`import javax.swing.JLabel;`
34	`import javax.swing.JTextField;`	34	`import javax.swing.JTextField;`
35	`import javax.swing.SwingConstants;`	35	`import javax.swing.SwingConstants;`
36		36
37	`public class ContratSalarieSQLElement extends ComptaSQLConfElement {`	37	`public class ContratSalarieSQLElement extends ComptaSQLConfElement {`
38		38
39	`public ContratSalarieSQLElement() {`	39	`public ContratSalarieSQLElement() {`
40	`super("CONTRAT_SALARIE", "un contrat salarié", "contrats salariés");`	40	`super("CONTRAT_SALARIE", "un contrat salarié", "contrats salariés");`
41	`}`	41	`}`
42		42
43	`protected List<String> getListFields() {`	43	`protected List<String> getListFields() {`
44	`final List<String> l = new ArrayList<String>();`	44	`final List<String> l = new ArrayList<String>();`
45	`l.add("NATURE");`	45	`l.add("NATURE");`
46	`return l;`	46	`return l;`
47	`}`	47	`}`
48		48
49	`@Override`	49	`@Override`
50	`public Set<String> getInsertOnlyFields() {`	50	`public Set<String> getInsertOnlyFields() {`
51	`Set<String> s = new HashSet<String>();`	51	`Set<String> s = new HashSet<String>();`
52	`s.add("DATE_MODIFICATION");`	52	`s.add("DATE_MODIFICATION");`
53	`return s;`	53	`return s;`
54	`}`	54	`}`
55		55
56	`protected List<String> getComboFields() {`	56	`protected List<String> getComboFields() {`
57	`final List<String> l = new ArrayList<String>();`	57	`final List<String> l = new ArrayList<String>();`
58	`l.add("NUMERO");`	58	`l.add("NUMERO");`
59	`l.add("DATE_DEBUT");`	59	`l.add("DATE_DEBUT");`
60	`return l;`	60	`return l;`
61	`}`	61	`}`
62		62
63	`@Override`	63	`@Override`
64	`public boolean isPrivate() {`	64	`public boolean isPrivate() {`
65	`return true;`	65	`return true;`
66	`}`	66	`}`
67		67
68	`/*`	68	`/*`
69	`* (non-Javadoc)`	69	`* (non-Javadoc)`
70	`*`	70	`*`
71	`* @see org.openconcerto.devis.SQLElement#getComponent()`	71	`* @see org.openconcerto.devis.SQLElement#getComponent()`
72	`*/`	72	`*/`
73	`public SQLComponent createComponent() {`	73	`public SQLComponent createComponent() {`
74	`return new BaseSQLComponent(this) {`	74	`return new BaseSQLComponent(this) {`
75		75
76	`public void addViews() {`	76	`public void addViews() {`
77		77
78	`this.setLayout(new GridBagLayout());`	78	`this.setLayout(new GridBagLayout());`
79		79
80	`GridBagConstraints c = new DefaultGridBagConstraints();`	80	`GridBagConstraints c = new DefaultGridBagConstraints();`
81		81
82	`// Numero`	82	`// Numero`
83	`JLabel labelNumero = new JLabel(getLabelFor("NUMERO"));`	83	`JLabel labelNumero = new JLabel(getLabelFor("NUMERO"));`
84	`labelNumero.setHorizontalAlignment(SwingConstants.RIGHT);`	84	`labelNumero.setHorizontalAlignment(SwingConstants.RIGHT);`
85	`JTextField textNumero = new JTextField();`	85	`JTextField textNumero = new JTextField();`
86		86
87	`this.add(labelNumero, c);`	87	`this.add(labelNumero, c);`
88	`c.gridx++;`	88	`c.gridx++;`
89	`c.weightx = 1;`	89	`c.weightx = 1;`
90	`this.add(textNumero, c);`	90	`this.add(textNumero, c);`
91	`this.addRequiredSQLObject(textNumero, "NUMERO");`	91	`this.addRequiredSQLObject(textNumero, "NUMERO");`
92		92
93	`c.gridy++;`	93	`c.gridy++;`
94	`c.gridx = 0;`	94	`c.gridx = 0;`
95	`// Nature`	95	`// Nature`
96	`JLabel labelNature = new JLabel(getLabelFor("NATURE"));`	96	`JLabel labelNature = new JLabel(getLabelFor("NATURE"));`
97	`labelNature.setHorizontalAlignment(SwingConstants.RIGHT);`	97	`labelNature.setHorizontalAlignment(SwingConstants.RIGHT);`
98	`JTextField textNature = new JTextField();`	98	`JTextField textNature = new JTextField();`
99		99
100	`this.add(labelNature, c);`	100	`this.add(labelNature, c);`
101	`c.gridx++;`	101	`c.gridx++;`
102	`c.weightx = 1;`	102	`c.weightx = 1;`
103	`c.gridwidth = 3;`	103	`c.gridwidth = 3;`
104	`this.add(textNature, c);`	104	`this.add(textNature, c);`
105		105
106	`c.gridwidth = 1;`	106	`c.gridwidth = 1;`
107	`// Catégorie socioprofessionnelle`	107	`// Catégorie socioprofessionnelle`
108	`JLabel labelCatSocio = new JLabel(getLabelFor("ID_CODE_EMPLOI"));`	108	`JLabel labelCatSocio = new JLabel(getLabelFor("ID_CODE_EMPLOI"));`
109	`labelCatSocio.setHorizontalAlignment(SwingConstants.RIGHT);`	109	`labelCatSocio.setHorizontalAlignment(SwingConstants.RIGHT);`
110	`ElementComboBox selCodeCatSocio = new ElementComboBox();`	110	`ElementComboBox selCodeCatSocio = new ElementComboBox();`
111	`selCodeCatSocio.setInfoIconVisible(false);`	111	`selCodeCatSocio.setInfoIconVisible(false);`
112	`c.gridy++;`	112	`c.gridy++;`
113	`c.gridx = 0;`	113	`c.gridx = 0;`
114	`c.weightx = 0;`	114	`c.weightx = 0;`
115	`this.add(labelCatSocio, c);`	115	`this.add(labelCatSocio, c);`
116	`c.gridx++;`	116	`c.gridx++;`
117	`c.weightx = 1;`	117	`c.weightx = 1;`
118	`this.add(selCodeCatSocio, c);`	118	`this.add(selCodeCatSocio, c);`
119		119
120	`JLabel complPCSLabel = new JLabel(getLabelFor("COMPLEMENT_PCS"));`	120	`JLabel complPCSLabel = new JLabel(getLabelFor("COMPLEMENT_PCS"));`
121	`complPCSLabel.setHorizontalAlignment(SwingConstants.RIGHT);`	121	`complPCSLabel.setHorizontalAlignment(SwingConstants.RIGHT);`
122	`JTextField complPCS = new JTextField();`	122	`JTextField complPCS = new JTextField();`
123	`c.gridx++;`	123	`c.gridx++;`
124	`c.weightx = 0;`	124	`c.weightx = 0;`
125	`this.add(complPCSLabel, c);`	125	`this.add(complPCSLabel, c);`
126	`c.gridx++;`	126	`c.gridx++;`
127	`c.weightx = 1;`	127	`c.weightx = 1;`
128	`this.add(complPCS, c);`	128	`this.add(complPCS, c);`
129	`addView(complPCS, "COMPLEMENT_PCS");`	129	`addView(complPCS, "COMPLEMENT_PCS");`
130		130
131	`JLabel objetSpecLabel = new JLabel(getLabelFor("SPECTACLE_OBJET"));`	131	`JLabel objetSpecLabel = new JLabel(getLabelFor("SPECTACLE_OBJET"));`
132	`objetSpecLabel.setHorizontalAlignment(SwingConstants.RIGHT);`	132	`objetSpecLabel.setHorizontalAlignment(SwingConstants.RIGHT);`
133	`JTextField objetSpec = new JTextField();`	133	`JTextField objetSpec = new JTextField();`
134	`c.gridy++;`	134	`c.gridy++;`
135	`c.gridx = 0;`	135	`c.gridx = 0;`
136	`c.weightx = 0;`	136	`c.weightx = 0;`
137	`this.add(objetSpecLabel, c);`	137	`this.add(objetSpecLabel, c);`
138	`c.gridx++;`	138	`c.gridx++;`
139	`c.weightx = 1;`	139	`c.weightx = 1;`
140	`this.add(objetSpec, c);`	140	`this.add(objetSpec, c);`
141	`addView(objetSpec, "SPECTACLE_OBJET");`	141	`addView(objetSpec, "SPECTACLE_OBJET");`
142	`objetSpec.setEditable(false);`	142	`objetSpec.setEditable(false);`
143		143
144	`JLabel jourContratLabel = new JLabel(getLabelFor("SPECTACLE_JOUR_CONTRAT"));`	144	`JLabel jourContratLabel = new JLabel(getLabelFor("SPECTACLE_JOUR_CONTRAT"));`
145	`jourContratLabel.setHorizontalAlignment(SwingConstants.RIGHT);`	145	`jourContratLabel.setHorizontalAlignment(SwingConstants.RIGHT);`
146	`JTextField jourContrat = new JTextField();`	146	`JTextField jourContrat = new JTextField();`
147	`c.gridx++;`	147	`c.gridx++;`
148	`c.weightx = 0;`	148	`c.weightx = 0;`
149	`this.add(jourContratLabel, c);`	149	`this.add(jourContratLabel, c);`
150	`c.gridx++;`	150	`c.gridx++;`
151	`c.weightx = 1;`	151	`c.weightx = 1;`
152	`this.add(jourContrat, c);`	152	`this.add(jourContrat, c);`
153	`addView(jourContrat, "SPECTACLE_JOUR_CONTRAT");`	153	`addView(jourContrat, "SPECTACLE_JOUR_CONTRAT");`
154	`jourContrat.setEditable(false);`	154	`jourContrat.setEditable(false);`
155		155
156	`final ElementComboBox selCaractActivite = new ElementComboBox();`	156	`final ElementComboBox selCaractActivite = new ElementComboBox();`
157	`selCaractActivite.setInfoIconVisible(false);`	157	`selCaractActivite.setInfoIconVisible(false);`
158	`this.addRequiredSQLObject(selCaractActivite, "ID_CODE_CARACT_ACTIVITE");`	158	`this.addRequiredSQLObject(selCaractActivite, "ID_CODE_CARACT_ACTIVITE");`
159	`selCaractActivite.addModelListener("wantedID", new PropertyChangeListener() {`	159	`selCaractActivite.addModelListener("wantedID", new PropertyChangeListener() {`
160		160
161	`@Override`	161	`@Override`
162	`public void propertyChange(PropertyChangeEvent evt) {`	162	`public void propertyChange(PropertyChangeEvent evt) {`
163	`final boolean b = selCaractActivite.getSelectedRow() != null && selCaractActivite.getSelectedRow().getString("CODE").equals("04");`	163	`final boolean b = selCaractActivite.getSelectedRow() != null && selCaractActivite.getSelectedRow().getString("CODE").equals("04");`
164	`objetSpec.setEditable(b);`	164	`objetSpec.setEditable(b);`
165	`jourContrat.setEditable(b);`	165	`jourContrat.setEditable(b);`
166	`if (!b) {`	166	`if (!b) {`
167	`objetSpec.setText("");`	167	`objetSpec.setText("");`
168	`;`	168	`;`
169	`jourContrat.setText("");`	169	`jourContrat.setText("");`
170	`}`	170	`}`
171	`}`	171	`}`
172	`});`	172	`});`
173		173
174	`// Contrat de travail`	174	`// Contrat de travail`
175	`JLabel labelContratTravail = new JLabel(getLabelFor("ID_CODE_CONTRAT_TRAVAIL"));`	175	`JLabel labelContratTravail = new JLabel(getLabelFor("ID_CODE_CONTRAT_TRAVAIL"));`
176	`labelContratTravail.setHorizontalAlignment(SwingConstants.RIGHT);`	176	`labelContratTravail.setHorizontalAlignment(SwingConstants.RIGHT);`
177	`ElementComboBox selContratTravail = new ElementComboBox();`	177	`ElementComboBox selContratTravail = new ElementComboBox();`
178	`selContratTravail.setInfoIconVisible(false);`	178	`selContratTravail.setInfoIconVisible(false);`
179	`c.gridy++;`	179	`c.gridy++;`
180	`c.gridx = 0;`	180	`c.gridx = 0;`
181	`c.weightx = 0;`	181	`c.weightx = 0;`
182	`this.add(labelContratTravail, c);`	182	`this.add(labelContratTravail, c);`
183	`c.gridx++;`	183	`c.gridx++;`
184	`c.weightx = 1;`	184	`c.weightx = 1;`
185	`this.add(selContratTravail, c);`	185	`this.add(selContratTravail, c);`
186		186
187	`// Droit Contrat de travail`	187	`// Droit Contrat de travail`
188	`JLabel labelDroitContrat = new JLabel(getLabelFor("ID_CODE_DROIT_CONTRAT"));`	188	`JLabel labelDroitContrat = new JLabel(getLabelFor("ID_CODE_DROIT_CONTRAT"));`
189	`labelDroitContrat.setHorizontalAlignment(SwingConstants.RIGHT);`	189	`labelDroitContrat.setHorizontalAlignment(SwingConstants.RIGHT);`
190	`ElementComboBox selDroitContrat = new ElementComboBox();`	190	`ElementComboBox selDroitContrat = new ElementComboBox();`
191	`selDroitContrat.setInfoIconVisible(false);`	191	`selDroitContrat.setInfoIconVisible(false);`
192	`c.gridx++;`	192	`c.gridx++;`
193	`c.weightx = 0;`	193	`c.weightx = 0;`
194	`this.add(labelDroitContrat, c);`	194	`this.add(labelDroitContrat, c);`
195	`c.gridx++;`	195	`c.gridx++;`
196	`c.weightx = 1;`	196	`c.weightx = 1;`
197	`this.add(selDroitContrat, c);`	197	`this.add(selDroitContrat, c);`
198		198
199	`// caracteristiques activité`	199	`// caracteristiques activité`
200	`JLabel labelCaractActivite = new JLabel(getLabelFor("ID_CODE_CARACT_ACTIVITE"));`	200	`JLabel labelCaractActivite = new JLabel(getLabelFor("ID_CODE_CARACT_ACTIVITE"));`
201	`labelCaractActivite.setHorizontalAlignment(SwingConstants.RIGHT);`	201	`labelCaractActivite.setHorizontalAlignment(SwingConstants.RIGHT);`
202		202
203	`c.gridy++;`	203	`c.gridy++;`
204	`c.gridx = 0;`	204	`c.gridx = 0;`
205	`c.weightx = 0;`	205	`c.weightx = 0;`
206	`this.add(labelCaractActivite, c);`	206	`this.add(labelCaractActivite, c);`
207	`c.gridx++;`	207	`c.gridx++;`
208	`c.weightx = 1;`	208	`c.weightx = 1;`
209	`this.add(selCaractActivite, c);`	209	`this.add(selCaractActivite, c);`
210		210
211	`// Statut profesionnel`	211	`// Statut profesionnel`
212	`JLabel labelStatutProf = new JLabel(getLabelFor("ID_CODE_STATUT_PROF"));`	212	`JLabel labelStatutProf = new JLabel(getLabelFor("ID_CODE_STATUT_PROF"));`
213	`labelStatutProf.setHorizontalAlignment(SwingConstants.RIGHT);`	213	`labelStatutProf.setHorizontalAlignment(SwingConstants.RIGHT);`
214	`ElementComboBox selStatutProf = new ElementComboBox();`	214	`ElementComboBox selStatutProf = new ElementComboBox();`
215	`selStatutProf.setInfoIconVisible(false);`	215	`selStatutProf.setInfoIconVisible(false);`
216	`c.gridx++;`	216	`c.gridx++;`
217	`c.weightx = 0;`	217	`c.weightx = 0;`
218	`this.add(labelStatutProf, c);`	218	`this.add(labelStatutProf, c);`
219	`c.gridx++;`	219	`c.gridx++;`
220	`c.weightx = 1;`	220	`c.weightx = 1;`
221	`this.add(selStatutProf, c);`	221	`this.add(selStatutProf, c);`
222		222
223	`// Statut categoriel`	223	`// Statut categoriel`
224	`JLabel labelStatutCat = new JLabel(getLabelFor("ID_CODE_STATUT_CATEGORIEL"));`	224	`JLabel labelStatutCat = new JLabel(getLabelFor("ID_CODE_STATUT_CATEGORIEL"));`
225	`labelStatutCat.setHorizontalAlignment(SwingConstants.RIGHT);`	225	`labelStatutCat.setHorizontalAlignment(SwingConstants.RIGHT);`
226	`ElementComboBox selStatutCat = new ElementComboBox();`	226	`ElementComboBox selStatutCat = new ElementComboBox();`
227	`selStatutCat.setInfoIconVisible(false);`	227	`selStatutCat.setInfoIconVisible(false);`
228	`c.gridy++;`	228	`c.gridy++;`
229	`c.gridx = 0;`	229	`c.gridx = 0;`
230	`c.weightx = 0;`	230	`c.weightx = 0;`
231	`this.add(labelStatutCat, c);`	231	`this.add(labelStatutCat, c);`
232	`c.gridx++;`	232	`c.gridx++;`
233	`c.weightx = 1;`	233	`c.weightx = 1;`
234	`this.add(selStatutCat, c);`	234	`this.add(selStatutCat, c);`
235		235
236	`// Statut categoriel`	236	`// Statut categoriel`
237	`JLabel labelStatutCatConv = new JLabel(getLabelFor("ID_CODE_STATUT_CAT_CONV"));`	237	`JLabel labelStatutCatConv = new JLabel(getLabelFor("ID_CODE_STATUT_CAT_CONV"));`
238	`labelStatutCatConv.setHorizontalAlignment(SwingConstants.RIGHT);`	238	`labelStatutCatConv.setHorizontalAlignment(SwingConstants.RIGHT);`
239	`ElementComboBox selStatutCatConv = new ElementComboBox();`	239	`ElementComboBox selStatutCatConv = new ElementComboBox();`
240	`selStatutCatConv.setInfoIconVisible(false);`	240	`selStatutCatConv.setInfoIconVisible(false);`
241	`c.gridx++;`	241	`c.gridx++;`
242	`c.weightx = 0;`	242	`c.weightx = 0;`
243	`this.add(labelStatutCatConv, c);`	243	`this.add(labelStatutCatConv, c);`
244	`c.gridx++;`	244	`c.gridx++;`
245	`c.weightx = 1;`	245	`c.weightx = 1;`
246	`this.add(selStatutCatConv, c);`	246	`this.add(selStatutCatConv, c);`
247		247
248	`List<String> dsnFF = Arrays.asList("ID_CONTRAT_MODALITE_TEMPS", "ID_CONTRAT_REGIME_MALADIE", "ID_CONTRAT_REGIME_VIEILLESSE", "ID_CONTRAT_DETACHE_EXPATRIE",`	248	`List<String> dsnFF = Arrays.asList("ID_CONTRAT_MODALITE_TEMPS", "ID_CONTRAT_REGIME_MALADIE", "ID_CONTRAT_REGIME_VIEILLESSE", "ID_CONTRAT_DETACHE_EXPATRIE",`
249	`"ID_CONTRAT_DISPOSITIF_POLITIQUE", "ID_CONTRAT_MOTIF_RECOURS");`	249	`"ID_CONTRAT_DISPOSITIF_POLITIQUE", "ID_CONTRAT_MOTIF_RECOURS", "ID_DIPLOME_PREPARE");`
250	`int p = 0;`	250	`int p = 0;`
251	`for (String ffName : dsnFF) {`	251	`for (String ffName : dsnFF) {`
252	`JLabel labelFF = new JLabel(getLabelFor(ffName));`	252	`JLabel labelFF = new JLabel(getLabelFor(ffName));`
253	`labelFF.setHorizontalAlignment(SwingConstants.RIGHT);`	253	`labelFF.setHorizontalAlignment(SwingConstants.RIGHT);`
254	`ElementComboBox selFF = new ElementComboBox();`	254	`ElementComboBox selFF = new ElementComboBox();`
255	`selFF.setInfoIconVisible(false);`	255	`selFF.setInfoIconVisible(false);`
256	`if (p % 2 == 0) {`	256	`if (p % 2 == 0) {`
257	`c.gridy++;`	257	`c.gridy++;`
258	`c.gridx = 0;`	258	`c.gridx = 0;`
259	`} else {`	259	`} else {`
260	`c.gridx++;`	260	`c.gridx++;`
261	`}`	261	`}`
262	`p++;`	262	`p++;`
263	`c.weightx = 0;`	263	`c.weightx = 0;`
264	`this.add(labelFF, c);`	264	`this.add(labelFF, c);`
265	`c.gridx++;`	265	`c.gridx++;`
266	`c.weighty = 1;`	266	`c.weighty = 1;`
267	`c.weightx = 1;`	267	`c.weightx = 1;`
268	`this.add(selFF, c);`	268	`this.add(selFF, c);`
269	`if (ffName.equals("ID_CONTRAT_MOTIF_RECOURS")) {`	269	`if (ffName.equals("ID_CONTRAT_MOTIF_RECOURS") \|\| ffName.equals("ID_DIPLOME_PREPARE")) {`
270	`this.addSQLObject(selFF, ffName);`	270	`this.addSQLObject(selFF, ffName);`
271	`} else {`	271	`} else {`
272	`this.addRequiredSQLObject(selFF, ffName);`	272	`this.addRequiredSQLObject(selFF, ffName);`
273	`}`	273	`}`
274	`}`	274	`}`
275		275
276	`// Code Arrco, agirc retirés du contrat et ajoutés dans les caisses de cotisations`	276	`// Code Arrco, agirc retirés du contrat et ajoutés dans les caisses de cotisations`
277		277
278	`// Code UGRR`	278	`// Code UGRR`
279		279
280	`// JLabel labelCodeUGRR = new JLabel(getLabelFor("CODE_IRC_UGRR"));`	280	`// JLabel labelCodeUGRR = new JLabel(getLabelFor("CODE_IRC_UGRR"));`
281	`// labelCodeUGRR.setHorizontalAlignment(SwingConstants.RIGHT);`	281	`// labelCodeUGRR.setHorizontalAlignment(SwingConstants.RIGHT);`
282	`// JTextField textCodeUGRR = new JTextField();`	282	`// JTextField textCodeUGRR = new JTextField();`
283	`// c.gridy++;`	283	`// c.gridy++;`
284	`// c.gridx = 0;`	284	`// c.gridx = 0;`
285	`// c.weightx = 0;`	285	`// c.weightx = 0;`
286	`// this.add(labelCodeUGRR, c);`	286	`// this.add(labelCodeUGRR, c);`
287	`// c.gridx++;`	287	`// c.gridx++;`
288	`// c.weighty = 1;`	288	`// c.weighty = 1;`
289	`// c.weightx = 1;`	289	`// c.weightx = 1;`
290	`// this.add(textCodeUGRR, c);`	290	`// this.add(textCodeUGRR, c);`
291	`// addView(textCodeUGRR, "CODE_IRC_UGRR");`	291	`// addView(textCodeUGRR, "CODE_IRC_UGRR");`
292	`//`	292	`//`
293	`// JLabel labelNumUGRR = new JLabel(getLabelFor("NUMERO_RATTACHEMENT_UGRR"));`	293	`// JLabel labelNumUGRR = new JLabel(getLabelFor("NUMERO_RATTACHEMENT_UGRR"));`
294	`// labelNumUGRR.setHorizontalAlignment(SwingConstants.RIGHT);`	294	`// labelNumUGRR.setHorizontalAlignment(SwingConstants.RIGHT);`
295	`// JTextField textNumUGRR = new JTextField();`	295	`// JTextField textNumUGRR = new JTextField();`
296	`// c.gridy++;`	296	`// c.gridy++;`
297	`// c.gridx = 0;`	297	`// c.gridx = 0;`
298	`// c.weightx = 0;`	298	`// c.weightx = 0;`
299	`// this.add(labelNumUGRR, c);`	299	`// this.add(labelNumUGRR, c);`
300	`// c.gridx++;`	300	`// c.gridx++;`
301	`// c.weighty = 1;`	301	`// c.weighty = 1;`
302	`// c.weightx = 1;`	302	`// c.weightx = 1;`
303	`// this.add(textNumUGRR, c);`	303	`// this.add(textNumUGRR, c);`
304	`// addView(textNumUGRR, "NUMERO_RATTACHEMENT_UGRR");`	304	`// addView(textNumUGRR, "NUMERO_RATTACHEMENT_UGRR");`
305	`//`	305	`//`
306	`// // Code UGRC`	306	`// // Code UGRC`
307	`// JLabel labelCodeUGRC = new JLabel(getLabelFor("CODE_IRC_UGRC"));`	307	`// JLabel labelCodeUGRC = new JLabel(getLabelFor("CODE_IRC_UGRC"));`
308	`// labelCodeUGRC.setHorizontalAlignment(SwingConstants.RIGHT);`	308	`// labelCodeUGRC.setHorizontalAlignment(SwingConstants.RIGHT);`
309	`// JTextField textCodeUGRC = new JTextField();`	309	`// JTextField textCodeUGRC = new JTextField();`
310	`// c.gridy++;`	310	`// c.gridy++;`
311	`// c.gridx = 0;`	311	`// c.gridx = 0;`
312	`// c.weightx = 0;`	312	`// c.weightx = 0;`
313	`// this.add(labelCodeUGRC, c);`	313	`// this.add(labelCodeUGRC, c);`
314	`// c.gridx++;`	314	`// c.gridx++;`
315	`// c.weighty = 1;`	315	`// c.weighty = 1;`
316	`// c.weightx = 1;`	316	`// c.weightx = 1;`
317	`// this.add(textCodeUGRC, c);`	317	`// this.add(textCodeUGRC, c);`
318	`// addView(textCodeUGRC, "CODE_IRC_UGRC");`	318	`// addView(textCodeUGRC, "CODE_IRC_UGRC");`
319	`//`	319	`//`
320	`// JLabel labelNumUGRC = new JLabel(getLabelFor("NUMERO_RATTACHEMENT_UGRC"));`	320	`// JLabel labelNumUGRC = new JLabel(getLabelFor("NUMERO_RATTACHEMENT_UGRC"));`
321	`// labelNumUGRC.setHorizontalAlignment(SwingConstants.RIGHT);`	321	`// labelNumUGRC.setHorizontalAlignment(SwingConstants.RIGHT);`
322	`// JTextField textNumUGRC = new JTextField();`	322	`// JTextField textNumUGRC = new JTextField();`
323	`// c.gridy++;`	323	`// c.gridy++;`
324	`// c.gridx = 0;`	324	`// c.gridx = 0;`
325	`// c.weightx = 0;`	325	`// c.weightx = 0;`
326	`// this.add(labelNumUGRC, c);`	326	`// this.add(labelNumUGRC, c);`
327	`// c.gridx++;`	327	`// c.gridx++;`
328	`// c.weighty = 1;`	328	`// c.weighty = 1;`
329	`// c.weightx = 1;`	329	`// c.weightx = 1;`
330	`// this.add(textNumUGRC, c);`	330	`// this.add(textNumUGRC, c);`
331	`// addView(textNumUGRC, "NUMERO_RATTACHEMENT_UGRC");`	331	`// addView(textNumUGRC, "NUMERO_RATTACHEMENT_UGRC");`
332	`//`	332	`//`
333	`// // Retraite`	333	`// // Retraite`
334	`// JLabel labelCodeRetraite = new JLabel(getLabelFor("CODE_IRC_RETRAITE"));`	334	`// JLabel labelCodeRetraite = new JLabel(getLabelFor("CODE_IRC_RETRAITE"));`
335	`// labelCodeRetraite.setHorizontalAlignment(SwingConstants.RIGHT);`	335	`// labelCodeRetraite.setHorizontalAlignment(SwingConstants.RIGHT);`
336	`// JTextField textCodeRetraite = new JTextField();`	336	`// JTextField textCodeRetraite = new JTextField();`
337	`// c.gridy++;`	337	`// c.gridy++;`
338	`// c.gridx = 0;`	338	`// c.gridx = 0;`
339	`// c.weightx = 0;`	339	`// c.weightx = 0;`
340	`// this.add(labelCodeRetraite, c);`	340	`// this.add(labelCodeRetraite, c);`
341	`// c.gridx++;`	341	`// c.gridx++;`
342	`// c.weighty = 1;`	342	`// c.weighty = 1;`
343	`// c.weightx = 1;`	343	`// c.weightx = 1;`
344	`// this.add(textCodeRetraite, c);`	344	`// this.add(textCodeRetraite, c);`
345	`// addView(textCodeRetraite, "CODE_IRC_RETRAITE");`	345	`// addView(textCodeRetraite, "CODE_IRC_RETRAITE");`
346	`//`	346	`//`
347	`// JLabel labelNumRetraite = new`	347	`// JLabel labelNumRetraite = new`
348	`// JLabel(getLabelFor("NUMERO_RATTACHEMENT_RETRAITE"));`	348	`// JLabel(getLabelFor("NUMERO_RATTACHEMENT_RETRAITE"));`
349	`// labelNumRetraite.setHorizontalAlignment(SwingConstants.RIGHT);`	349	`// labelNumRetraite.setHorizontalAlignment(SwingConstants.RIGHT);`
350	`// JTextField textNumRetraite = new JTextField();`	350	`// JTextField textNumRetraite = new JTextField();`
351	`// c.gridy++;`	351	`// c.gridy++;`
352	`// c.gridx = 0;`	352	`// c.gridx = 0;`
353	`// c.weightx = 0;`	353	`// c.weightx = 0;`
354	`// this.add(labelNumRetraite, c);`	354	`// this.add(labelNumRetraite, c);`
355	`// c.gridx++;`	355	`// c.gridx++;`
356	`// c.weighty = 1;`	356	`// c.weighty = 1;`
357	`// c.weightx = 1;`	357	`// c.weightx = 1;`
358	`// this.add(textNumRetraite, c);`	358	`// this.add(textNumRetraite, c);`
359	`// addView(textNumRetraite, "NUMERO_RATTACHEMENT_RETRAITE");`	359	`// addView(textNumRetraite, "NUMERO_RATTACHEMENT_RETRAITE");`
360		360
361	`// JLabel labelCodeRegimeRetraite = new`	361	`// JLabel labelCodeRegimeRetraite = new`
362	`// JLabel(getLabelFor("CODE_REGIME_RETRAITE_DSN"));`	362	`// JLabel(getLabelFor("CODE_REGIME_RETRAITE_DSN"));`
363	`// labelCodeRegimeRetraite.setHorizontalAlignment(SwingConstants.RIGHT);`	363	`// labelCodeRegimeRetraite.setHorizontalAlignment(SwingConstants.RIGHT);`
364	`// JTextField textCodeRegimeRetraite = new JTextField();`	364	`// JTextField textCodeRegimeRetraite = new JTextField();`
365	`// c.gridy++;`	365	`// c.gridy++;`
366	`// c.gridx = 0;`	366	`// c.gridx = 0;`
367	`// c.weightx = 0;`	367	`// c.weightx = 0;`
368	`// this.add(labelCodeRegimeRetraite, c);`	368	`// this.add(labelCodeRegimeRetraite, c);`
369	`// c.gridx++;`	369	`// c.gridx++;`
370	`// c.weighty = 1;`	370	`// c.weighty = 1;`
371	`// c.weightx = 1;`	371	`// c.weightx = 1;`
372	`// this.add(textCodeRegimeRetraite, c);`	372	`// this.add(textCodeRegimeRetraite, c);`
373	`// addRequiredSQLObject(textCodeRegimeRetraite, "CODE_REGIME_RETRAITE_DSN");`	373	`// addRequiredSQLObject(textCodeRegimeRetraite, "CODE_REGIME_RETRAITE_DSN");`
374		374
375	`// JLabel labelDateModif = new JLabel(getLabelFor("DATE_MODIFICATION"));`	375	`// JLabel labelDateModif = new JLabel(getLabelFor("DATE_MODIFICATION"));`
376	`// labelDateModif.setHorizontalAlignment(SwingConstants.RIGHT);`	376	`// labelDateModif.setHorizontalAlignment(SwingConstants.RIGHT);`
377	`// JDate textDateModif = new JDate();`	377	`// JDate textDateModif = new JDate();`
378	`// c.gridy++;`	378	`// c.gridy++;`
379	`// c.gridx = 0;`	379	`// c.gridx = 0;`
380	`// c.weightx = 0;`	380	`// c.weightx = 0;`
381	`// this.add(textDateModif, c);`	381	`// this.add(textDateModif, c);`
382	`// c.gridx++;`	382	`// c.gridx++;`
383	`// c.weighty = 1;`	383	`// c.weighty = 1;`
384	`// c.weightx = 1;`	384	`// c.weightx = 1;`
385	`// this.add(textDateModif, c);`	385	`// this.add(textDateModif, c);`
386	`// addSQLObject(textDateModif, "DATE_MODIFICATION");`	386	`// addSQLObject(textDateModif, "DATE_MODIFICATION");`
387		387
388	`// JLabel labelCM = new JLabel(getLabelFor("ID_INFOS_SALARIE_PAYE_MODIFIE"));`	388	`// JLabel labelCM = new JLabel(getLabelFor("ID_INFOS_SALARIE_PAYE_MODIFIE"));`
389	`// labelCM.setHorizontalAlignment(SwingConstants.RIGHT);`	389	`// labelCM.setHorizontalAlignment(SwingConstants.RIGHT);`
390	`// ElementComboBox selCM = new ElementComboBox();`	390	`// ElementComboBox selCM = new ElementComboBox();`
391	`// final SQLElement elementInfosPaye =`	391	`// final SQLElement elementInfosPaye =`
392	`// getDirectory().getElement("INFOS_SALARIE_PAYE");`	392	`// getDirectory().getElement("INFOS_SALARIE_PAYE");`
393	`// selCM.init(elementInfosPaye, elementInfosPaye.createComboRequest());`	393	`// selCM.init(elementInfosPaye, elementInfosPaye.createComboRequest());`
394	`// selCM.setInfoIconVisible(false);`	394	`// selCM.setInfoIconVisible(false);`
395	`// c.gridy++;`	395	`// c.gridy++;`
396	`// c.gridx = 0;`	396	`// c.gridx = 0;`
397	`// c.weightx = 0;`	397	`// c.weightx = 0;`
398	`// this.add(labelCM, c);`	398	`// this.add(labelCM, c);`
399	`// c.gridx++;`	399	`// c.gridx++;`
400	`// c.weighty = 1;`	400	`// c.weighty = 1;`
401	`// c.weightx = 1;`	401	`// c.weightx = 1;`
402	`// this.add(selCM, c);`	402	`// this.add(selCM, c);`
403	`// this.addSQLObject(selCM, "ID_INFOS_SALARIE_PAYE_MODIFIE");`	403	`// this.addSQLObject(selCM, "ID_INFOS_SALARIE_PAYE_MODIFIE");`
404		404
405	`JLabel labelDateDebut = new JLabel(getLabelFor("DATE_DEBUT"));`	405	`JLabel labelDateDebut = new JLabel(getLabelFor("DATE_DEBUT"));`
406	`labelDateDebut.setHorizontalAlignment(SwingConstants.RIGHT);`	406	`labelDateDebut.setHorizontalAlignment(SwingConstants.RIGHT);`
407	`JDate textDateDebut = new JDate();`	407	`JDate textDateDebut = new JDate();`
408	`c.gridy++;`	408	`c.gridy++;`
409	`c.gridx = 0;`	409	`c.gridx = 0;`
410	`c.weightx = 0;`	410	`c.weightx = 0;`
411	`this.add(labelDateDebut, c);`	411	`this.add(labelDateDebut, c);`
412	`c.gridx++;`	412	`c.gridx++;`
413	`c.weightx = 1;`	413	`c.weightx = 1;`
414	`this.add(textDateDebut, c);`	414	`this.add(textDateDebut, c);`
415	`addSQLObject(textDateDebut, "DATE_DEBUT", REQ);`	415	`addSQLObject(textDateDebut, "DATE_DEBUT", REQ);`
416		416
417	`JLabel labelDateFin = new JLabel(getLabelFor("DATE_PREV_FIN"));`	417	`JLabel labelDateFin = new JLabel(getLabelFor("DATE_PREV_FIN"));`
418	`labelDateFin.setHorizontalAlignment(SwingConstants.RIGHT);`	418	`labelDateFin.setHorizontalAlignment(SwingConstants.RIGHT);`
419	`JDate textDateFin = new JDate();`	419	`JDate textDateFin = new JDate();`
420	`c.gridx++;`	420	`c.gridx++;`
421	`c.weightx = 0;`	421	`c.weightx = 0;`
422	`this.add(labelDateFin, c);`	422	`this.add(labelDateFin, c);`
423	`c.gridx++;`	423	`c.gridx++;`
424	`c.weightx = 1;`	424	`c.weightx = 1;`
425	`this.add(textDateFin, c);`	425	`this.add(textDateFin, c);`
426	`addSQLObject(textDateFin, "DATE_PREV_FIN");`	426	`addSQLObject(textDateFin, "DATE_PREV_FIN");`
427		427
428	`JLabel labelAmen = new JLabel(getLabelFor("ID_CODE_AMENAGEMENT_PARTIEL"));`	428	`JLabel labelAmen = new JLabel(getLabelFor("ID_CODE_AMENAGEMENT_PARTIEL"));`
429	`labelAmen.setHorizontalAlignment(SwingConstants.RIGHT);`	429	`labelAmen.setHorizontalAlignment(SwingConstants.RIGHT);`
430	`ElementComboBox selAmen = new ElementComboBox();`	430	`ElementComboBox selAmen = new ElementComboBox();`
431	`selAmen.setInfoIconVisible(false);`	431	`selAmen.setInfoIconVisible(false);`
432	`c.gridy++;`	432	`c.gridy++;`
433	`c.gridx = 0;`	433	`c.gridx = 0;`
434	`c.weightx = 0;`	434	`c.weightx = 0;`
435	`this.add(labelAmen, c);`	435	`this.add(labelAmen, c);`
436	`c.gridx++;`	436	`c.gridx++;`
437	`c.weightx = 1;`	437	`c.weightx = 1;`
438	`this.add(selAmen, c);`	438	`this.add(selAmen, c);`
439	`this.addSQLObject(selAmen, "ID_CODE_AMENAGEMENT_PARTIEL");`	439	`this.addSQLObject(selAmen, "ID_CODE_AMENAGEMENT_PARTIEL");`
440		440
441	`JLabel labelSupsension = new JLabel(getLabelFor("ID_CODE_SUSPENSION"));`	441	`JLabel labelSupsension = new JLabel(getLabelFor("ID_CODE_SUSPENSION"));`
442	`labelSupsension.setHorizontalAlignment(SwingConstants.RIGHT);`	442	`labelSupsension.setHorizontalAlignment(SwingConstants.RIGHT);`
443	`ElementComboBox selSupsension = new ElementComboBox();`	443	`ElementComboBox selSupsension = new ElementComboBox();`
444	`selSupsension.setInfoIconVisible(false);`	444	`selSupsension.setInfoIconVisible(false);`
445	`c.gridx++;`	445	`c.gridx++;`
446	`c.weightx = 0;`	446	`c.weightx = 0;`
447	`this.add(labelSupsension, c);`	447	`this.add(labelSupsension, c);`
448	`c.gridx++;`	448	`c.gridx++;`
449	`c.weightx = 1;`	449	`c.weightx = 1;`
450	`this.add(selSupsension, c);`	450	`this.add(selSupsension, c);`
451	`this.addSQLObject(selSupsension, "ID_CODE_SUSPENSION");`	451	`this.addSQLObject(selSupsension, "ID_CODE_SUSPENSION");`
452		452
453	`JLabel labelDateDebutSusp = new JLabel(getLabelFor("DATE_DEBUT_SUSPENSION"));`	453	`JLabel labelDateDebutSusp = new JLabel(getLabelFor("DATE_DEBUT_SUSPENSION"));`
454	`labelDateDebutSusp.setHorizontalAlignment(SwingConstants.RIGHT);`	454	`labelDateDebutSusp.setHorizontalAlignment(SwingConstants.RIGHT);`
455	`JDate textDateDebutSups = new JDate();`	455	`JDate textDateDebutSups = new JDate();`
456	`c.gridy++;`	456	`c.gridy++;`
457	`c.gridx = 0;`	457	`c.gridx = 0;`
458	`c.weightx = 0;`	458	`c.weightx = 0;`
459	`this.add(labelDateDebutSusp, c);`	459	`this.add(labelDateDebutSusp, c);`
460	`c.gridx++;`	460	`c.gridx++;`
461	`c.weightx = 1;`	461	`c.weightx = 1;`
462	`this.add(textDateDebutSups, c);`	462	`this.add(textDateDebutSups, c);`
463	`this.addSQLObject(textDateDebutSups, "DATE_DEBUT_SUSPENSION");`	463	`this.addSQLObject(textDateDebutSups, "DATE_DEBUT_SUSPENSION");`
464		464
465	`JLabel labelDateFinSups = new JLabel(getLabelFor("DATE_FIN_SUSPENSION"));`	465	`JLabel labelDateFinSups = new JLabel(getLabelFor("DATE_FIN_SUSPENSION"));`
466	`labelDateFinSups.setHorizontalAlignment(SwingConstants.RIGHT);`	466	`labelDateFinSups.setHorizontalAlignment(SwingConstants.RIGHT);`
467	`JDate textDateFinSuspension = new JDate();`	467	`JDate textDateFinSuspension = new JDate();`
468	`c.gridx++;`	468	`c.gridx++;`
469	`c.weightx = 0;`	469	`c.weightx = 0;`
470	`this.add(labelDateFinSups, c);`	470	`this.add(labelDateFinSups, c);`
471	`c.gridx++;`	471	`c.gridx++;`
472	`c.weightx = 1;`	472	`c.weightx = 1;`
473	`this.add(textDateFinSuspension, c);`	473	`this.add(textDateFinSuspension, c);`
474	`this.addSQLObject(textDateFinSuspension, "DATE_FIN_SUSPENSION");`	474	`this.addSQLObject(textDateFinSuspension, "DATE_FIN_SUSPENSION");`
475		475
476	`this.addRequiredSQLObject(selCodeCatSocio, "ID_CODE_EMPLOI");`	476	`this.addRequiredSQLObject(selCodeCatSocio, "ID_CODE_EMPLOI");`
477	`this.addRequiredSQLObject(selContratTravail, "ID_CODE_CONTRAT_TRAVAIL");`	477	`this.addRequiredSQLObject(selContratTravail, "ID_CODE_CONTRAT_TRAVAIL");`
478	`this.addRequiredSQLObject(selDroitContrat, "ID_CODE_DROIT_CONTRAT");`	478	`this.addRequiredSQLObject(selDroitContrat, "ID_CODE_DROIT_CONTRAT");`
479	`this.addRequiredSQLObject(selStatutProf, "ID_CODE_STATUT_PROF");`	479	`this.addRequiredSQLObject(selStatutProf, "ID_CODE_STATUT_PROF");`
480	`this.addRequiredSQLObject(selStatutCat, "ID_CODE_STATUT_CATEGORIEL");`	480	`this.addRequiredSQLObject(selStatutCat, "ID_CODE_STATUT_CATEGORIEL");`
481	`this.addRequiredSQLObject(selStatutCatConv, "ID_CODE_STATUT_CAT_CONV");`	481	`this.addRequiredSQLObject(selStatutCatConv, "ID_CODE_STATUT_CAT_CONV");`
482	`this.addRequiredSQLObject(textNature, "NATURE");`	482	`this.addRequiredSQLObject(textNature, "NATURE");`
483	`}`	483	`}`
484	`};`	484	`};`
485	`}`	485	`}`
486		486
487	`@Override`	487	`@Override`
488	`protected String createCode() {`	488	`protected String createCode() {`
489	`return createCodeOfPackage() + ".contract.employe";`	489	`return createCodeOfPackage() + ".contract.employe";`
490	`}`	490	`}`
491	`}`	491	`}`

Dépôt officiel du code source de l'ERP OpenConcerto

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/humanresources/payroll/element/ContratSalarieSQLElement.java - Rev 177 → 180