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

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.

 *

 * The contents of this file are subject to the terms of the GNU General Public License Version 3

 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a

 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific

 * language governing permissions and limitations under the License.

 *

 * When distributing the software, include this License Header Notice in each file.

 */

 package org.openconcerto.erp.core.humanresources.payroll.element;

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

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

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

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.utils.ListMap;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.util.ArrayList;

import java.util.List;

import javax.swing.BorderFactory;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

public class ContratPrevoyanceSQLElement extends ComptaSQLConfElement {

    public ContratPrevoyanceSQLElement() {

        super("CONTRAT_PREVOYANCE", "un contrat de prévoyance, mutuelle, formation", "contrats de prévoyance, mutuelle, formation");

    }

    protected List<String> getListFields() {

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

        // l.add("CODE_UNIQUE");

        l.add("NOM");

        l.add("REFERENCE");

        l.add("CODE_ORGANISME");

        l.add("CODE_DELEGATAIRE");

        l.add("COTISATION_ETABLISSEMENT");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("NOM");

        l.add("REFERENCE");

        return l;

    }

    @Override

    public ListMap<String, String> getShowAs() {

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

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            ContratPrevSalarieTable tableSalarie = new ContratPrevSalarieTable();

            ContratPrevRubriqueTable tableRub = new ContratPrevRubriqueTable(false);

            ContratPrevRubriqueTable tableRubNet = new ContratPrevRubriqueTable(true);

            public void addViews() {

                this.setLayout(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

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

                 * Renseignements

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

                JPanel panelInfos = new JPanel();

                panelInfos.setBorder(BorderFactory.createTitledBorder("Renseignements (S21.G00.15)"));

                panelInfos.setLayout(new GridBagLayout());

                // // Code

                // JLabel labelCode = new JLabel(getLabelFor("CODE_UNIQUE"));

                // JTextField textCode = new JTextField();

                // panelInfos.add(labelCode, c);

                // c.gridx++;

                // c.weightx = 1;

                // panelInfos.add(textCode, c);

                // this.addSQLObject(textCode, "CODE_UNIQUE");

                // c.weightx = 0;

                // Nom

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

                JTextField textNom = new JTextField();

                // c.gridx++;

                c.weightx = 0;

                panelInfos.add(labelNom, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textNom, c);

                c.weightx = 0;

                // Ref

                JLabel labelRef = new JLabel(getLabelFor("REFERENCE"));

                JTextField textRef = new JTextField();

                c.gridx++;

                panelInfos.add(labelRef, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textRef, c);

                c.weightx = 0;

                // Nom

                JLabel labelCO = new JLabel(getLabelFor("CODE_ORGANISME"));

                JTextField textCO = new JTextField();

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                panelInfos.add(labelCO, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textCO, c);

                c.weightx = 0;

                // Ref

                JLabel labelCD = new JLabel(getLabelFor("CODE_DELEGATAIRE"));

                JTextField textCD = new JTextField();

                c.gridx++;

                panelInfos.add(labelCD, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textCD, c);

                // Formation

                JCheckBox checkFO = new JCheckBox(getLabelFor("COTISATION_ETABLISSEMENT"));

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                c.gridwidth = 2;

                panelInfos.add(checkFO, c);

                // Deb

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

                JDate dateDeb = new JDate();

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                panelInfos.add(labelDateDeb, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(dateDeb, c);

                this.addSQLObject(dateDeb, "DATE_DEBUT");

                c.weightx = 0;

                // Fin

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

                JDate dateFin = new JDate();

                c.gridx++;

                panelInfos.add(labelDateFin, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(dateFin, c);

                this.addSQLObject(dateFin, "DATE_FIN");

                c.weightx = 0;

                TitledSeparator sepRenseignement = new TitledSeparator("Renseignement par contrat salarié (S21.G00.70)");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(sepRenseignement, c);

                c.gridx = 0;

                c.gridy++;

                c.fill = GridBagConstraints.BOTH;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weighty = 0.5;

                panelInfos.add(tableSalarie, c);

                TitledSeparator sepRub = new TitledSeparator("Rubriques de cotisation rattachées");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(sepRub, c);

                c.gridx = 0;

                c.gridy++;

                c.fill = GridBagConstraints.BOTH;

                c.weighty = 0.5;

                panelInfos.add(tableRub, c);

                TitledSeparator sepRubN = new TitledSeparator("Rubriques de net rattachées");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(sepRubN, c);

                c.gridx = 0;

                c.gridy++;

                c.fill = GridBagConstraints.BOTH;

                c.weighty = 0.5;

                panelInfos.add(tableRubNet, c);

                c.gridx = 0;

                c.gridy++;

                c.fill = GridBagConstraints.BOTH;

                c.weightx = 1;

                c.weighty = 1;

                this.add(panelInfos, c);

                this.addSQLObject(textNom, "NOM");

                this.addSQLObject(textCD, "CODE_DELEGATAIRE");

                this.addSQLObject(textCO, "CODE_ORGANISME");

                this.addSQLObject(textRef, "REFERENCE");

                this.addSQLObject(checkFO, "COTISATION_ETABLISSEMENT");

            }

            @Override

            public int insert(SQLRow order) {

                int id = super.insert(order);

                tableRub.updateField("ID_CONTRAT_PREVOYANCE", id);

                tableRubNet.updateField("ID_CONTRAT_PREVOYANCE", id);

                tableSalarie.updateField("ID_CONTRAT_PREVOYANCE", id);

                return id;

            }

            @Override

            public void update() {

                int id = getSelectedID();

                super.update();

                tableRub.updateField("ID_CONTRAT_PREVOYANCE", id);

                tableRubNet.updateField("ID_CONTRAT_PREVOYANCE", id);

                tableSalarie.updateField("ID_CONTRAT_PREVOYANCE", id);

            }

            @Override

            public void select(SQLRowAccessor r) {

                super.select(r);

                if (r != null) {

                    tableRub.insertFrom("ID_CONTRAT_PREVOYANCE", r.getID());

                    tableRubNet.insertFrom("ID_CONTRAT_PREVOYANCE", r.getID());

                    tableSalarie.insertFrom("ID_CONTRAT_PREVOYANCE", r.getID());

                }

            }

        };

    }

}