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

/*

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

 *

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

 *

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

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

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

 * language governing permissions and limitations under the License.

 *

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

 */

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

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

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

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

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.utils.ListMap;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.sql.SQLException;

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 CaisseCotisationSQLElement extends ComptaSQLConfElement {

    public CaisseCotisationSQLElement(final DBRoot root) {

        super(root.getTable("CAISSE_COTISATION"), "une caisse", "caisses");

    }

    protected List<String> getListFields() {

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

        l.add("NOM");

        l.add("ID_ADRESSE_COMMON");

        l.add("NUMERO_COMPTE_PCE");

        l.add("NUMERO_COMPTE_PCE_CHARGES");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("NOM");

        return l;

    }

    @Override

    public ListMap<String, String> getShowAs() {

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

    }

    private final static SQLTable tableCaisse = Configuration.getInstance().getBase().getTable("CAISSE_COTISATION");

    private static List<SQLRow> liste;

    public static List<SQLRow> getCaisseCotisation() {

        if (liste == null) {

            SQLSelect selCaisse = new SQLSelect(Configuration.getInstance().getBase());

            selCaisse.addSelect(tableCaisse.getField("ID"));

            selCaisse.addSelect(tableCaisse.getField("NOM"));

            String req = selCaisse.asString();

            liste = (List<SQLRow>) Configuration.getInstance().getBase().getDataSource().execute(req, SQLRowListRSH.createFromSelect(selCaisse));

        }

        return liste;

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            CaisseCotisationRenseignementTable table;

            public void addViews() {

                this.setLayout(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

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

                 * Renseignements

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

                JPanel panelInfos = new JPanel();

                panelInfos.setBorder(BorderFactory.createTitledBorder("Renseignements"));

                panelInfos.setLayout(new GridBagLayout());

                // Nom

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

                JTextField textNom = new JTextField();

                panelInfos.add(labelNom, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textNom, c);

                c.weightx = 0;

                // Nom

                JCheckBox boxOrgProt = new JCheckBox(getLabelFor("ORG_PROTECTION_SOCIALE"));

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 1;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(boxOrgProt, c);

                this.addSQLObject(boxOrgProt, "ORG_PROTECTION_SOCIALE");

                c.gridwidth = 1;

                // Nom

                JCheckBox boxUrssaf = new JCheckBox(getLabelFor("URSSAF"));

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.weightx = 1;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(boxUrssaf, c);

                this.addSQLObject(boxUrssaf, "URSSAF");

                c.gridwidth = 1;

                // Adresse

                TitledSeparator sep = new TitledSeparator("Adresse");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(sep, c);

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

                ElementSQLObject eltAdr = (ElementSQLObject) this.getView("ID_ADRESSE_COMMON");

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(eltAdr, c);

                TitledSeparator sepContact = new TitledSeparator("Contact");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(sepContact, c);

                // Telephone

                JLabel labelTel = new JLabel(getLabelFor("TEL"));

                JTextField textTel = new JTextField();

                c.gridy++;

                c.gridwidth = 1;

                c.gridx = 0;

                panelInfos.add(labelTel, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textTel, c);

                c.weightx = 0;

                // Telephone portable

                JLabel labelTelP = new JLabel(getLabelFor("TEL_PORTABLE"));

                JTextField textTelP = new JTextField();

                c.gridx++;

                panelInfos.add(labelTelP, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textTelP, c);

                c.weightx = 0;

                // Mail

                JLabel labelMail = new JLabel(getLabelFor("MAIL"));

                JTextField textMail = new JTextField();

                c.gridy++;

                c.gridx = 0;

                panelInfos.add(labelMail, c);

                c.gridx++;

                c.weightx = 1;

                panelInfos.add(textMail, c);

                this.addSQLObject(textMail, "MAIL");

                c.weightx = 0;

                c.gridx = 0;

                c.gridy = 0;

                c.fill = GridBagConstraints.BOTH;

                c.weightx = 1;

                c.weighty = 1;

                this.add(panelInfos, c);

                c.weightx = 0;

                c.weighty = 0;

                c.fill = GridBagConstraints.HORIZONTAL;

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

                 * Comptabilité

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

                JPanel panelCompta = new JPanel();

                panelCompta.setBorder(BorderFactory.createTitledBorder("Comptabilité"));

                panelCompta.setLayout(new GridBagLayout());

                // Compte tiers

                JLabel labelTiers = new JLabel(getLabelFor("NUMERO_COMPTE_PCE"));

                // JFormattedTextField fieldCompte = new JFormattedTextField();

                // fieldCompte.set

                //

                // MaskFormatter mask;

                // try {

                // mask = new MaskFormatter("AAAAAAAAAAAAAA");

                // mask.setValidCharacters("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789");

                // mask.s

                // mask.install(this);

                // } catch (ParseException exn) {

                // exn.printStackTrace();

                // }

                JTextField fieldCompte = new JTextField();

                this.addView(fieldCompte, "NUMERO_COMPTE_PCE");

                panelCompta.add(labelTiers, c);

                c.gridx++;

                c.weightx = 1;

                panelCompta.add(fieldCompte, c);

                c.weightx = 0;

                // Compte charge

                JLabel labelCharge = new JLabel(getLabelFor("NUMERO_COMPTE_PCE_CHARGES"));

                c.gridy++;

                c.gridx = 0;

                panelCompta.add(labelCharge, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldCompteCharge = new JTextField();

                panelCompta.add(fieldCompteCharge, c);

                this.addView(fieldCompteCharge, "NUMERO_COMPTE_PCE_CHARGES");

                c.weightx = 0;

                c.gridx = 0;

                c.gridy = 1;

                c.fill = GridBagConstraints.BOTH;

                c.weightx = 1;

                c.weighty = 1;

                this.add(panelCompta, c);

                c.weightx = 0;

                c.weighty = 0;

                this.addSQLObject(textNom, "NOM");

                this.addSQLObject(textTel, "TEL");

                this.addSQLObject(textTelP, "TEL_PORTABLE");

                // this.addSQLObject(selCompteTiers, "ID_COMPTE_PCE_TIERS");

                // this.addSQLObject(selCompteCharge, "ID_COMPTE_PCE_CHARGE");

                // selCompteTiers.init();

                // selCompteCharge.init();

                TitledSeparator sepRenseignement = new TitledSeparator("Renseignement Organisme de protection social (S21.G00.20)");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridy++;

                c.gridx = 0;

                c.weightx = 1;

                this.add(sepRenseignement, c);

                this.table = new CaisseCotisationRenseignementTable();

                this.table.setEnabled(true);

                c.gridy++;

                c.weighty = 1;

                this.add(this.table, c);

            }

            @Override

            public void select(SQLRowAccessor r) {

                super.select(r);

                if (r != null) {

                    this.table.getModel().insertFrom(r);

                } else {

                    this.table.getModel().clearRows();

                }

            }

            @Override

            public void update() {

                super.update();

                this.table.getModel().updateField("ID_CAISSE_COTISATION", getSelectedID());

            }

            @Override

            public int insert(SQLRow order) {

                final int insertID = super.insert(order);

                this.table.getModel().updateField("ID_CAISSE_COTISATION", insertID);

                return insertID;

            }

        };

    }

}