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.common.element;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.core.common.ui.PanelFrame;

import org.openconcerto.erp.panel.ChargementCreationSocietePanel;

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

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.graph.TablesMap;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.SQLRequestComboBox;

import org.openconcerto.sql.sqlobject.SQLTextCombo;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FormLayouter;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.ui.component.InteractionMode;

import org.openconcerto.utils.ListMap;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Collections;

import java.util.Date;

import java.util.List;

import javax.swing.BorderFactory;

import javax.swing.JCheckBox;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

/**

 * Sociétés existantes avec le nom de la base associée

 */

public class SocieteCommonSQLElement extends ComptaSQLConfElement {

    private static final String TABLE_NAME = "SOCIETE_COMMON";

    static public final DBRoot getRoot(final SQLRow company) {

        try {

            return getRoot(company, false);

        } catch (SQLException e) {

            // shouldn't happen since we don't allow refresh

            throw new IllegalStateException(e);

        }

    }

    static public final DBRoot getRoot(final SQLRow company, final boolean allowRefresh) throws SQLException {

        final String rootName = company.getString("DATABASE_NAME");

        final DBSystemRoot sysRoot = company.getTable().getDBSystemRoot();

        if (allowRefresh && !sysRoot.contains(rootName)) {

            sysRoot.addRootToMap(rootName);

            sysRoot.refresh(TablesMap.createFromTables(rootName, Collections.singleton(TABLE_NAME)), true);

        }

        return sysRoot.getRoot(rootName);

    }

    public SocieteCommonSQLElement(DBRoot root) {

        super(root.getTable(TABLE_NAME), "une société", "sociétés");

    }

    @Override

    public ListMap<String, String> getShowAs() {

        return ListMap.singleton(null, getListFields());

    }

    protected List<String> getListFields() {

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

        l.add("NOM");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("NOM");

        return l;

    }

    public final static Date getDateDebutExercice() {

        SQLTable tableExercice = Configuration.getInstance().getBase().getTable("EXERCICE_COMMON");

        SQLRow societeRow = ((ComptaPropsConfiguration) Configuration.getInstance()).getRowSociete();

        return (Date) tableExercice.getRow(societeRow.getInt("ID_EXERCICE_COMMON")).getObject("DATE_DEB");

    }

    /*

     * (non-Javadoc)

     *

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

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            private JTextField textNom, textNumSiret, textNumNII, textNumAPE;

            private JTextField textNumTel, textNumFax, textEmail, textNumUrssaff;

            // private ITextArea textAdresse;

            private JComboBox combo;

            private JLabel labelPlan;

            private ElementSQLObject eltExercice;

            private TitledSeparator sep, sepPlan;

            private SQLTextCombo textType;

            public void addViews() {

                this.setLayout(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

                this.textNom = new JTextField();

                this.textNumAPE = new JTextField();

                this.textNumNII = new JTextField();

                this.textNumSiret = new JTextField();

                this.textNumTel = new JTextField();

                this.textNumFax = new JTextField();

                this.textEmail = new JTextField();

                this.textType = new SQLTextCombo();

                this.textNumUrssaff = new JTextField();

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

                 * Informations générales

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

                TitledSeparator sepInfos = new TitledSeparator("Informations générales");

                c.gridwidth = 4;

                c.gridx = 0;

                c.gridy++;

                this.add(sepInfos, c);

                // Type

                c.gridy++;

                c.gridwidth = 1;

                c.weightx = 0;

                JLabel labelType = new JLabel(getLabelFor("TYPE"));

                labelType.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelType, c);

                c.gridx++;

                c.gridwidth = 1;

                c.weightx = 1;

                this.add(this.textType, c);

                // Nom

                c.gridx++;

                c.gridwidth = 1;

                c.weightx = 0;

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

                labelNom.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelNom, c);

                c.gridx++;

                c.gridwidth = 1;

                c.weightx = 1;

                this.add(this.textNom, c);

                // Numero Siret

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                JLabel labelNumSiret = new JLabel(getLabelFor("NUM_SIRET"));

                labelNumSiret.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelNumSiret, c);

                c.gridx++;

                c.weightx = 1;

                this.add(this.textNumSiret, c);

                // Numero NII

                c.gridx++;

                c.weightx = 0;

                JLabel labelNumNII = new JLabel(getLabelFor("NUM_NII"));

                labelNumNII.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelNumNII, c);

                c.gridx++;

                c.weightx = 1;

                this.add(this.textNumNII, c);

                // Numero URSSAF

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                JLabel labelNumUrs = new JLabel(getLabelFor("NUMERO_URSSAF"));

                labelNumUrs.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelNumUrs, c);

                c.gridx++;

                c.weightx = 1;

                this.add(this.textNumUrssaff, c);

                // Numero APE

                c.gridx++;

                c.weightx = 0;

                JLabel labelNumAPE = new JLabel(getLabelFor("NUM_APE"));

                labelNumAPE.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelNumAPE, c);

                c.gridx++;

                c.weightx = 1;

                this.add(this.textNumAPE, c);

                // Org social

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                JLabel labelIDSoc = new JLabel(getLabelFor("ORG_PROTECTION_SOCIAL_ID"));

                labelIDSoc.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelIDSoc, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldIDSoc = new JTextField();

                this.add(fieldIDSoc, c);

                this.addView(fieldIDSoc, "ORG_PROTECTION_SOCIAL_ID");

                c.gridx++;

                c.weightx = 0;

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

                labelIDCC.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelIDCC, c);

                c.gridx++;

                c.weightx = 1;

                final SQLRequestComboBox comboIDCC = new SQLRequestComboBox();

                this.add(comboIDCC, c);

                this.addView(comboIDCC, "ID_IDCC");

                // RCS

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                JLabel labelRCS = new JLabel(getLabelFor("RCS"));

                labelRCS.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelRCS, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldRCS = new JTextField();

                this.add(fieldRCS, c);

                this.addView(fieldRCS, "RCS");

                // Capital

                c.gridx++;

                c.weightx = 0;

                JLabel labelCapital = new JLabel(getLabelFor("CAPITAL"));

                labelCapital.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelCapital, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldCapital = new JTextField();

                this.add(fieldCapital, c);

                this.addView(fieldCapital, "CAPITAL");

                // IBAN

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                JLabel labelIban = new JLabel(getLabelFor("IBAN"));

                labelIban.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelIban, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldIban = new JTextField();

                this.add(fieldIban, c);

                this.addView(fieldIban, "IBAN");

                // BIC

                c.gridx++;

                c.weightx = 0;

                JLabel labelBIC = new JLabel(getLabelFor("BIC"));

                labelBIC.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelBIC, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldBIC = new JTextField();

                this.add(fieldBIC, c);

                this.addView(fieldBIC, "BIC");

                // SEPA creditor

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                JLabel labelICS = new JLabel(getLabelFor("SEPA_CREDITOR_ID"));

                labelICS.setHorizontalAlignment(SwingConstants.RIGHT);

                this.add(labelICS, c);

                c.gridx++;

                c.weightx = 1;

                JTextField fieldICS = new JTextField();

                this.add(fieldICS, c);

                this.addView(fieldICS, "SEPA_CREDITOR_ID");

                // Assurance

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

                    c.gridy++;

                    c.gridx = 0;

                    c.weightx = 0;

                    JLabel labelPolice = new JLabel(getLabelFor("NUMERO_POLICE"));

                    labelPolice.setHorizontalAlignment(SwingConstants.RIGHT);

                    this.add(labelPolice, c);

                    c.gridx++;

                    c.weightx = 1;

                    JTextField fieldPolice = new JTextField();

                    this.add(fieldPolice, c);

                    this.addView(fieldPolice, "NUMERO_POLICE");

                }

                // ccode congés payés

                JPanel panelAssuj = new JPanel();

                JCheckBox boxAssujCFP = new JCheckBox(getLabelFor("ASSUJETTISSEMENT_CFP"));

                panelAssuj.add(boxAssujCFP);

                this.addView(boxAssujCFP, "ASSUJETTISSEMENT_CFP");

                JCheckBox boxAssujCFPCDD = new JCheckBox(getLabelFor("ASSUJETTISSEMENT_CFP_CDD"));

                panelAssuj.add(boxAssujCFPCDD);

                this.addView(boxAssujCFPCDD, "ASSUJETTISSEMENT_CFP_CDD");

                JCheckBox boxAssujTA = new JCheckBox(getLabelFor("ASSUJETTISSEMENT_TA"));

                panelAssuj.add(boxAssujTA, c);

                this.addView(boxAssujTA, "ASSUJETTISSEMENT_TA");

                c.gridy++;

                c.gridx = 0;

                c.weightx = 0;

                c.gridwidth = 2;

                this.add(panelAssuj, c);

                JLabel labelMotifTA = new JLabel(getLabelFor("ID_MOTIF_NON_ASSUJETIS_TA"));

                labelMotifTA.setHorizontalAlignment(SwingConstants.RIGHT);

                c.gridx += 2;

                c.gridwidth = 1;

                c.weightx = 0;

                this.add(labelMotifTA, c);

                c.gridx++;

                c.weightx = 1;

                ElementComboBox boxMotifTA = new ElementComboBox(true);

                this.add(boxMotifTA, c);

                this.addView(boxMotifTA, "ID_MOTIF_NON_ASSUJETIS_TA");

                // Adresse

                final TitledSeparator sepAdresse = new TitledSeparator(getLabelFor("ID_ADRESSE_COMMON"));

                c.gridx = 0;

                c.gridy++;

                c.gridwidth = 4;

                c.gridheight = 1;

                c.weightx = 1;

                c.weighty = 0;

                c.fill = GridBagConstraints.BOTH;

                this.add(sepAdresse, c);

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

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

                c.gridy++;

                this.add(eltAdr, c);

                // Contact

                JPanel panelContact = new JPanel();

                panelContact.setLayout(new GridBagLayout());

                panelContact.setBorder(BorderFactory.createTitledBorder("Contacts"));

                final GridBagConstraints cc = new DefaultGridBagConstraints();

                // Numero de telephone

                JLabel labelNumTel = new JLabel(getLabelFor("NUM_TEL"));

                labelNumTel.setHorizontalAlignment(SwingConstants.RIGHT);

                cc.weightx = 0;

                panelContact.add(labelNumTel, cc);

                cc.gridx++;

                cc.weightx = 1;

                panelContact.add(this.textNumTel, cc);

                // Numero de fax

                cc.gridy++;

                cc.gridx = 0;

                cc.weightx = 0;

                JLabel labelNumFax = new JLabel(getLabelFor("NUM_FAX"));

                labelNumFax.setHorizontalAlignment(SwingConstants.RIGHT);

                panelContact.add(labelNumFax, cc);

                cc.gridx++;

                cc.weightx = 1;

                panelContact.add(this.textNumFax, cc);

                // EMail

                cc.gridx = 0;

                cc.gridy++;

                cc.weightx = 0;

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

                labelEMail.setHorizontalAlignment(SwingConstants.RIGHT);

                panelContact.add(labelEMail, cc);

                cc.gridx++;

                cc.weightx = 1;

                panelContact.add(this.textEmail, cc);

                c.gridy++;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.fill = GridBagConstraints.BOTH;

                this.add(panelContact, c);

                c.fill = GridBagConstraints.HORIZONTAL;

                c.gridwidth = 1;

                // Devise

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

                    c.gridy++;

                    c.gridx = 0;

                    c.weightx = 0;

                    c.gridwidth = 1;

                    JLabel labelDevise = new JLabel(getLabelFor("ID_DEVISE"));

                    labelDevise.setHorizontalAlignment(SwingConstants.RIGHT);

                    this.add(labelDevise, c);

                    c.gridx++;

                    c.gridwidth = 3;

                    c.fill = GridBagConstraints.NONE;

                    ElementComboBox boxDevise = new ElementComboBox();

                    this.add(boxDevise, c);

                    this.addView(boxDevise, "ID_DEVISE");

                }

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

                 * DATE D'EXERCICE

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

                this.sep = new TitledSeparator("Date de l'exercice");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridx = 0;

                c.gridy++;

                c.insets = new Insets(10, 2, 1, 2);

                c.fill = GridBagConstraints.HORIZONTAL;

                this.add(this.sep, c);

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                c.weighty = 1;

                c.anchor = GridBagConstraints.NORTHWEST;

                c.insets = new Insets(2, 2, 1, 2);

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

                this.eltExercice = (ElementSQLObject) this.getView("ID_EXERCICE_COMMON");

                c.gridwidth = GridBagConstraints.REMAINDER;

                this.add(this.eltExercice, c);

                // Regime fiscale

                /*

                 * c.gridx = 0; c.gridy++; c.gridwidth = 1; c.weightx = 0; JLabel labelRegime = new

                 * JLabel("Régime fiscale ");

                 * labelRegime.setHorizontalAlignment(SwingConstants.RIGHT); this.add(labelRegime,

                 * c);

                 */

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

                 * Choix du plan comptable

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

                this.sepPlan = new TitledSeparator("Plan comptable de l'entreprise");

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.gridx = 0;

                c.gridy++;

                c.insets = new Insets(10, 2, 1, 2);

                this.add(this.sepPlan, c);

                JPanel panelPlan = new JPanel();

                this.labelPlan = new JLabel("Choix du plan comptable", SwingConstants.RIGHT);

                this.combo = new JComboBox();

                this.combo.addItem("Base");

                this.combo.addItem("Abrégé");

                this.combo.addItem("Développé");

                panelPlan.add(this.labelPlan);

                panelPlan.add(this.combo);

                c.gridx = 0;

                c.gridy++;

                c.gridwidth = GridBagConstraints.REMAINDER;

                c.insets = new Insets(2, 2, 1, 2);

                c.fill = GridBagConstraints.NONE;

                this.add(panelPlan, c);

                c.gridy++;

                final JPanel additionalPanel = new JPanel();

                this.add(additionalPanel, c);

                this.setAdditionalFieldsPanel(new FormLayouter(additionalPanel, 2, 1));

                this.addRequiredSQLObject(this.textNom, "NOM");

                // this.addSQLObject(this.textAdresse, "ADRESSE");

                this.addRequiredSQLObject(this.textNumAPE, "NUM_APE");

                this.addRequiredSQLObject(this.textNumNII, "NUM_NII");

                this.addRequiredSQLObject(this.textNumSiret, "NUM_SIRET");

                this.addSQLObject(this.textEmail, "MAIL");

                this.addSQLObject(this.textNumTel, "NUM_TEL");

                this.addSQLObject(this.textNumFax, "NUM_FAX");

                this.addSQLObject(this.textNumUrssaff, "NUMERO_URSSAF");

                this.addSQLObject(this.textType, "TYPE");

            }

            public int insert(SQLRow order) {

                int id = super.insert(order);

                SQLRow row = getTable().getRow(id);

                SQLRowValues rowVals = row.getForeignRow("ID_EXERCICE_COMMON").createEmptyUpdateRow();

                rowVals.put("ID_SOCIETE_COMMON", id);

                try {

                    rowVals.update();

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                creationBase(id, this.combo.getSelectedIndex());

                return id;

            }

            /*

             * public int insert() {

             *

             * int id = super.insert(); creationBase(id); return id; }

             */

            private void creationBase(int id, int typePCG) {

                System.err.println("display chargement societe panel");

                PanelFrame frameChargement = new PanelFrame(new ChargementCreationSocietePanel(id, typePCG), "Création d'une société");

                frameChargement.setVisible(true);

                /*

                 * System.err.println("Création de la base");

                 * ActionDB.dupliqueMySQLDB("Default", "OpenConcerto" + id); SQLRowValues

                 * rowVals = new SQLRowValues(getTable()); rowVals.put("DATABASE_NAME", "OpenConcerto"

                 * + id); try { rowVals.update(id); } catch (SQLException e) {

                 *

                 * e.printStackTrace(); }

                 */

                /*

                 * SQLTable comptePCETable = ((ComptaPropsConfiguration)

                 * Configuration.getInstance()).getSQLBaseSociete().getTable("COMPTE_PCE"); SQLTable

                 * comptePCGTable = ((ComptaPropsConfiguration)

                 * Configuration.getInstance()).getSQLBaseSociete().getTable("COMPTE_PCG"); // MAYBE

                 * Vérifier qu'aucun n'est deja créé???? // On crée le PCE à partir du PCG

                 * selectionné; SQLSelect selCompte = new SQLSelect(getTable().getBase());

                 * selCompte.addSelect(comptePCGTable.getField("NUMERO"));

                 * selCompte.addSelect(comptePCGTable.getField("NOM"));

                 * selCompte.addSelect(comptePCGTable.getField("INFOS"));

                 *

                 * if (this.combo.getSelectedIndex() == 0) {

                 * selCompte.setWhere("ID_TYPE_COMPTE_PCG_BASE", "!=", 1); } else { if

                 * (this.combo.getSelectedIndex() == 1) {

                 * selCompte.setWhere("ID_TYPE_COMPTE_PCG_AB", "!=", 1); } }

                 *

                 * String reqCompte = selCompte.asString(); Object obRep =

                 * getTable().getBase().getDataSource().execute(reqCompte, new ArrayListHandler());

                 *

                 * List tmpCpt = (List) obRep;

                 *

                 * for (int i = 0; i < tmpCpt.size(); i++) { Object[] tmp = (Object[])

                 * tmpCpt.get(i);

                 *

                 * SQLRowValues vals = new SQLRowValues(comptePCETable); vals.put("NUMERO", tmp[0]);

                 * vals.put("NOM", tmp[1]); vals.put("INFOS", tmp[2]);

                 *

                 * try { vals.insert(); } catch (SQLException e) { e.printStackTrace(); } }

                 */

            }

            @Override

            public void select(SQLRowAccessor r) {

                super.select(r);

                if (r != null) {

                    disableEdition();

                }

            }

            @Override

            public void update() {

                // TODO Auto-generated method stub

                super.update();

                ComptaPropsConfiguration.getInstanceCompta().getRowSociete().fetchValues();

            }

            public void disableEdition() {

                this.combo.setVisible(false);

                this.labelPlan.setVisible(false);

                this.eltExercice.setEditable(InteractionMode.DISABLED);

                this.sepPlan.setVisible(false);

            }

        };

    }

}