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.config.ComptaPropsConfiguration;

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

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

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

import org.openconcerto.erp.core.humanresources.payroll.component.VariableRowTreeNode;

import org.openconcerto.erp.core.humanresources.payroll.report.FichePayeSheetXML;

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

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

import org.openconcerto.erp.model.FichePayeModel;

import org.openconcerto.erp.model.MouseSheetXmlListeListener;

import org.openconcerto.erp.model.RubriquePayeTree;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElementDirectory;

import org.openconcerto.sql.element.SQLElementLink.LinkType;

import org.openconcerto.sql.element.SQLElementLinksSetup;

import org.openconcerto.sql.element.TreesOfSQLRows;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLSystem;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.view.EditFrame;

import org.openconcerto.sql.view.IListFrame;

import org.openconcerto.sql.view.list.IListe;

import org.openconcerto.sql.view.list.IListeAction.IListeEvent;

import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.component.InteractionMode;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.ListMap;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Calendar;

import java.util.Date;

import java.util.List;

import javax.swing.AbstractAction;

import javax.swing.BorderFactory;

import javax.swing.JButton;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JPopupMenu;

import javax.swing.JScrollPane;

import javax.swing.JSplitPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.SwingUtilities;

import javax.swing.tree.TreePath;

public class FichePayeSQLElement extends ComptaSQLConfElement {

    public FichePayeSQLElement() {

        super("FICHE_PAYE", "une fiche de paye", "fiches de paye");

        MouseSheetXmlListeListener l = new MouseSheetXmlListeListener(FichePayeSheetXML.class);

        getRowActions().addAll(l.getRowActions());

        PredicateRowAction actionCumuls = new PredicateRowAction(new AbstractAction("Détails cumuls et variables") {

            @Override

            public void actionPerformed(ActionEvent e) {

                final PanelCumulsPaye pCumuls = new PanelCumulsPaye();

                final PanelFrame p = new PanelFrame(pCumuls, "Détails cumuls et variables");

                pCumuls.selectFiche(IListe.get(e).getSelectedRow().asRow());

                p.setVisible(true);

            }

        }, true);

        actionCumuls.setPredicate(IListeEvent.getSingleSelectionPredicate());

        getRowActions().add(actionCumuls);

        PredicateRowAction genererNonSimplifie = new PredicateRowAction(new AbstractAction("Créer le bulletin détaillé") {

            @Override

            public void actionPerformed(ActionEvent e) {

                SQLRow row = IListe.get(e).getSelectedRow().asRow();

                FichePayeSheetXML sheet = new FichePayeSheetXML(row, false);

                try {

                    sheet.createDocument();

                    sheet.showPrintAndExport(true, false, true);

                } catch (Exception e1) {

                    ExceptionHandler.handle("Erreur lors de la création du document.", e1);

                }

            }

        }, false);

        genererNonSimplifie.setPredicate(IListeEvent.getSingleSelectionPredicate());

        getRowActions().add(genererNonSimplifie);

    }

    @Override

    public ListMap<String, String> getShowAs() {

        final ListMap<String, String> map = new ListMap<>();

        map.put("ID_SALARIE", Arrays.asList("CODE", "NOM", "PRENOM", "ID_REGLEMENT_PAYE"));

        return map;

    }

    protected List<String> getListFields() {

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

        l.add("ID_SALARIE");

        l.add("ID_MOIS");

        l.add("ANNEE");

        l.add("NET_A_PAYER");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("ID_SALARIE");

        l.add("ID_MOIS");

        l.add("ANNEE");

        return l;

    }

    @Override

    public boolean isPrivate() {

        return true;

    }

    @Override

    protected void setupLinks(SQLElementLinksSetup links) {

        super.setupLinks(links);

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

            links.get("ID_INFOS_SALARIE_PAYE").setType(LinkType.ASSOCIATION);

        }

    }

    /*

     * (non-Javadoc)

     *

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

     */

    // FIXME Place des rubriques importantes --> [Brut -- cotisations -- cotisations with CSG --

    // Net]

    // FIXME Date periode must be correct

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            private FichePayeModel model;

            private ElementComboBox comboSelProfil, selSalCombo;

            private EditFrame edit = null;

            private ElementComboBox selMois;

            private int dernMois, dernAnnee;

            private JTextField textAnnee;

            JDate dateDu, dateAu;

            private JScrollPane paneTreeLeft;

            private JPanel pDate;

            public void addViews() {

                this.dernMois = 0;

                this.dernAnnee = 0;

                this.setLayout(new GridBagLayout());

                final RubriquePayeTree tree = new RubriquePayeTree();

                tree.expandRow(0);

                JPanel panelLeft = new JPanel(new GridBagLayout());

                GridBagConstraints cLeft = new DefaultGridBagConstraints();

                cLeft.fill = GridBagConstraints.BOTH;

                cLeft.weightx = 1;

                cLeft.weighty = 1;

                cLeft.gridheight = GridBagConstraints.REMAINDER;

                panelLeft.add(tree, cLeft);

                this.paneTreeLeft = new JScrollPane(tree);

                // this.add(this.paneTreeLeft, c);

                // Panel Fiche paye on the right

                // Salarie

                JPanel panelRight = new JPanel(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

                // Tree elt Fiche de Paye On the left

                c.fill = GridBagConstraints.HORIZONTAL;

                c.weightx = 1;

                c.weighty = 0;

                c.gridheight = 1;

                c.gridwidth = 2;

                this.selSalCombo = new ElementComboBox();

                panelRight.add(this.selSalCombo, c);

                // Mois

                JLabel labelMois = new JLabel("Fiche de paye du mois de");

                this.selMois = new ElementComboBox(true, 20);

                JLabel labelDu = new JLabel("Du");

                JLabel labelAu = new JLabel("Au");

                this.dateDu = new JDate();

                this.dateAu = new JDate();

                JLabel labelAnnee = new JLabel("Année");

                this.textAnnee = new JTextField();

                {

                    this.pDate = new JPanel(new GridBagLayout());

                    GridBagConstraints cDate = new DefaultGridBagConstraints();

                    cDate.weightx = 0;

                    cDate.gridx = GridBagConstraints.RELATIVE;

                    this.pDate.setOpaque(false);

                    this.pDate.add(labelMois, cDate);

                    cDate.weightx = 1;

                    this.pDate.add(this.selMois, cDate);

                    cDate.weightx = 0;

                    this.pDate.add(labelAnnee, cDate);

                    cDate.weightx = 1;

                    this.pDate.add(this.textAnnee, cDate);

                    cDate.weightx = 0;

                    this.pDate.add(labelDu, cDate);

                    cDate.weightx = 0;

                    this.pDate.add(this.dateDu, cDate);

                    cDate.weightx = 0;

                    this.pDate.add(labelAu, cDate);

                    cDate.weightx = 0;

                    this.pDate.add(this.dateAu, cDate);

                    c.gridy++;

                    c.fill = GridBagConstraints.HORIZONTAL;

                    c.weightx = 1;

                    c.weighty = 0;

                    c.gridheight = 1;

                    c.gridwidth = 2;

                    panelRight.add(this.pDate, c);

                }

                // Action Button

                JPanel pButtons = new JPanel(new GridBagLayout());

                pButtons.setOpaque(false);

                JButton buttonUp = new JNiceButton(IListFrame.class.getResource("fleche_haut.png"));

                JButton buttonDown = new JNiceButton(IListFrame.class.getResource("fleche_bas.png"));

                JButton buttonRemove = new JNiceButton(SQLComponent.class.getResource("delete.png"));

                {

                    GridBagConstraints cButtons = new DefaultGridBagConstraints();

                    cButtons.weightx = 0;

                    cButtons.fill = GridBagConstraints.NONE;

                    cButtons.gridx = GridBagConstraints.RELATIVE;

                    pButtons.add(buttonUp, cButtons);

                    pButtons.add(buttonDown, cButtons);

                    pButtons.add(buttonRemove, cButtons);

                }

                c.gridx += 2;

                c.fill = GridBagConstraints.NONE;

                c.weightx = 0;

                c.weighty = 0;

                c.gridwidth = 1;

                panelRight.add(pButtons, c);

                // Table

                c.fill = GridBagConstraints.BOTH;

                c.weightx = 1;

                c.weighty = 1;

                c.gridx = 0;

                c.gridy++;

                c.gridwidth = GridBagConstraints.REMAINDER;

                this.model = new FichePayeModel(1);

                final JTable table = new JTable(this.model);

                panelRight.add(new JScrollPane(table), c);

                FichePayeRenderer rend = new FichePayeRenderer();

                table.setDefaultRenderer(String.class, rend);

                table.setDefaultRenderer(Float.class, rend);

                // Import profil

                c.gridx = 0;

                c.gridy++;

                c.weightx = 0;

                c.weighty = 0;

                c.gridwidth = 1;

                c.fill = GridBagConstraints.HORIZONTAL;

                JLabel labelProfil = new JLabel("Lié à un profil prédéfini");

                panelRight.add(labelProfil, c);

                c.gridwidth = 1;

                this.comboSelProfil = new ElementComboBox();

                // this.comboSelProfil = new ElementComboBox();

                this.comboSelProfil.setListIconVisible(false);

                c.gridx++;

                c.gridwidth = 1;

                c.weightx = 1;

                // this.comboSelProfil.init(eltProfil.getTable().getField("NOM"), null);

                panelRight.add(this.comboSelProfil, c);

                JButton buttonImportProfil = new JButton("Importer");

                c.gridx++;

                c.weightx = 0;

                panelRight.add(buttonImportProfil, c);

                // Total Periode

                JPanel panelTotal = new JPanel(new GridBagLayout());

                panelTotal.setBorder(BorderFactory.createTitledBorder("Totaux sur la période"));

                GridBagConstraints cPanel = new DefaultGridBagConstraints();

                JLabel labelInfosConges = new JLabel(getLabelFor("DETAILS_CONGES"));

                panelTotal.add(labelInfosConges, cPanel);

                JTextField textConges = new JTextField();

                cPanel.gridx++;

                cPanel.weightx = 1;

                cPanel.gridwidth = 5;

                panelTotal.add(textConges, cPanel);

                addView(textConges, "DETAILS_CONGES");

                // Salaire brut

                cPanel.weightx = 0;

                cPanel.gridwidth = 1;

                cPanel.gridy++;

                cPanel.gridx = 0;

                JLabel labelBrut = new JLabel(getLabelFor("SAL_BRUT"));

                panelTotal.add(labelBrut, cPanel);

                JTextField textSalBrut = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textSalBrut, cPanel);

                textSalBrut.setEditable(false);

                textSalBrut.setEnabled(false);

                // acompte

                cPanel.gridx++;

                cPanel.weightx = 0;

                JLabel labelAcompte = new JLabel(getLabelFor("ACOMPTE"));

                panelTotal.add(labelAcompte, cPanel);

                JTextField textAcompte = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textAcompte, cPanel);

                // textAcompte.setEditable(false);

                // textAcompte.setEnabled(false);

                // Conges Acquis

                cPanel.gridx++;

                cPanel.weightx = 0;

                JLabel labelCongesAcquis = new JLabel(getLabelFor("CONGES_ACQUIS"));

                panelTotal.add(labelCongesAcquis, cPanel);

                JTextField textCongesAcquis = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textCongesAcquis, cPanel);

                // cotisation salariale

                cPanel.gridx = 0;

                cPanel.gridy++;

                cPanel.weightx = 0;

                JLabel labelCotSal = new JLabel(getLabelFor("COT_SAL"));

                panelTotal.add(labelCotSal, cPanel);

                JTextField textCotSal = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textCotSal, cPanel);

                textCotSal.setEditable(false);

                textCotSal.setEnabled(false);

                // cotisation patronale

                cPanel.gridx++;

                cPanel.weightx = 0;

                JLabel labelCotPat = new JLabel(getLabelFor("COT_PAT"));

                panelTotal.add(labelCotPat, cPanel);

                JTextField textCotPat = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textCotPat, cPanel);

                textCotPat.setEditable(false);

                textCotPat.setEnabled(false);

                JLabel labelCSG = new JLabel(getLabelFor("CSG"));

                cPanel.gridx++;

                cPanel.weightx = 0;

                panelTotal.add(labelCSG, cPanel);

                JTextField textCSG = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textCSG, cPanel);

                textCSG.setEditable(false);

                textCSG.setEnabled(false);

                // net imposable

                cPanel.gridx = 0;

                cPanel.gridy++;

                cPanel.weightx = 0;

                JLabel labelNetImp = new JLabel(getLabelFor("NET_IMP"));

                panelTotal.add(labelNetImp, cPanel);

                JTextField textNetImp = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textNetImp, cPanel);

                textNetImp.setEditable(false);

                textNetImp.setEnabled(false);

                cPanel.gridx++;

                cPanel.weightx = 0;

                JLabel labelNetAPayer = new JLabel(getLabelFor("NET_A_PAYER"));

                panelTotal.add(labelNetAPayer, cPanel);

                JTextField textNetAPayer = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textNetAPayer, cPanel);

                textNetAPayer.setEditable(false);

                textNetAPayer.setEnabled(false);

                cPanel.gridx++;

                cPanel.weightx = 0;

                JLabel labelCice = new JLabel(getLabelFor("CICE"));

                panelTotal.add(labelCice, cPanel);

                JTextField textCice = new JTextField(10);

                cPanel.gridx++;

                cPanel.weightx = 1;

                panelTotal.add(textCice, cPanel);

                textCice.setEditable(false);

                textCice.setEnabled(false);

                this.addSQLObject(textCice, "CICE");

                c.gridx = 0;

                c.gridy++;

                c.fill = GridBagConstraints.HORIZONTAL;

                c.weightx = 1;

                c.weighty = 0;

                c.gridwidth = GridBagConstraints.REMAINDER;

                panelRight.add(panelTotal, c);

                // Cumuls

                GridBagConstraints cGlobal = new DefaultGridBagConstraints();

                cGlobal.gridx = 0;

                cGlobal.gridy = 0;

                cGlobal.gridwidth = 1;

                cGlobal.gridheight = 1;

                cGlobal.fill = GridBagConstraints.BOTH;

                cGlobal.weightx = 1;

                cGlobal.weighty = 1;

                this.add(new JSplitPane(JSplitPane.HORIZONTAL_SPLIT, this.paneTreeLeft, panelRight), cGlobal);

                buttonUp.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        int newRowSelected = model.upRow(table.getSelectedRow());

                        if (newRowSelected >= 0) {

                            table.setRowSelectionInterval(newRowSelected, newRowSelected);

                        }

                    }

                });

                buttonDown.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        int newRowSelected = model.downRow(table.getSelectedRow());

                        if (newRowSelected >= 0) {

                            table.setRowSelectionInterval(newRowSelected, newRowSelected);

                        }

                    }

                });

                buttonRemove.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        model.removeRow(table.getSelectedRow());

                    }

                });

                tree.addMouseListener(new MouseAdapter() {

                    public void mousePressed(MouseEvent mE) {

                        TreePath path = tree.getClosestPathForLocation(mE.getPoint().x, mE.getPoint().y);

                        final Object obj = path.getLastPathComponent();

                        if (obj == null) {

                            return;

                        }

                        if (mE.getClickCount() == 2 && mE.getButton() == MouseEvent.BUTTON1) {

                            if (obj instanceof VariableRowTreeNode) {

                                model.addRowAt(((VariableRowTreeNode) obj).getRow(), table.getSelectedRow());

                            }

                        } else {

                            if (mE.getButton() == 3) {

                                if (obj instanceof VariableRowTreeNode) {

                                    final SQLRow row = ((VariableRowTreeNode) obj).getRow();

                                    JPopupMenu menuDroit = new JPopupMenu();

                                    menuDroit.add(new AbstractAction("Editer") {

                                        public void actionPerformed(ActionEvent e) {

                                            if (edit != null) {

                                                edit.dispose();

                                            }

                                            edit = new EditFrame(Configuration.getInstance().getDirectory().getElement(row.getTable()), EditFrame.MODIFICATION);

                                            edit.selectionId(row.getID(), 0);

                                            edit.pack();

                                            edit.setVisible(true);

                                        }

                                    });

                                    menuDroit.add(new AbstractAction("Nouvelle rubrique") {

                                        public void actionPerformed(ActionEvent e) {

                                            if (edit != null) {

                                                edit.dispose();

                                            }

                                            edit = new EditFrame(Configuration.getInstance().getDirectory().getElement(row.getTable()));

                                            edit.pack();

                                            edit.setVisible(true);

                                        }

                                    });

                                    menuDroit.show(mE.getComponent(), mE.getPoint().x, mE.getPoint().y);

                                }

                            }

                        }

                    }

                });

                this.dateDu.addValueListener(new PropertyChangeListener() {

                    public void propertyChange(PropertyChangeEvent evt) {

                        if (!dateDu.isEmpty()) {

                            Date d = dateDu.getValue();

                            if (d != null) {

                                Calendar cal = Calendar.getInstance();

                                cal.setTime(d);

                                if (selMois.getSelectedId() > 1 && cal.get(Calendar.MONTH) + 2 != selMois.getSelectedId()) {

                                    cal.set(Calendar.DAY_OF_MONTH, 1);

                                    cal.set(Calendar.MONTH, selMois.getSelectedId() - 2);

                                    dateDu.setValue(cal.getTime());

                                }

                                fireValidChange();

                            }

                        }

                    }

                });

                this.dateAu.addValueListener(new PropertyChangeListener() {

                    public void propertyChange(PropertyChangeEvent evt) {

                        if (!dateAu.isEmpty()) {

                            Date d = dateAu.getValue();

                            if (d != null) {

                                Calendar cal = Calendar.getInstance();

                                cal.setTime(d);

                                if (selMois.getSelectedId() > 1 && cal.get(Calendar.MONTH) + 2 != selMois.getSelectedId()) {

                                    // TODO checker l'annee

                                    // TODO ajouter dans le isValidated du au compris dans le mois

                                    // selectionne

                                    // Calendar.getInstance().set(Calendar.DAY_OF_MONTH, maxDay);

                                    cal.set(Calendar.DAY_OF_MONTH, 1);

                                    cal.set(Calendar.MONTH, selMois.getSelectedId() - 2);

                                    cal.set(Calendar.DAY_OF_MONTH, cal.getActualMaximum(Calendar.DAY_OF_MONTH));

                                    dateAu.setValue(cal.getTime());

                                }

                                fireValidChange();

                            }

                        }

                    }

                });

                this.addRequiredSQLObject(this.textAnnee, "ANNEE");

                this.addRequiredSQLObject(this.selMois, "ID_MOIS");

                this.addSQLObject(this.comboSelProfil, "ID_PROFIL_PAYE");

                this.addSQLObject(textCongesAcquis, "CONGES_ACQUIS");

                this.addSQLObject(textCotPat, "COT_PAT");

                this.addSQLObject(textCotSal, "COT_SAL");

                this.addSQLObject(textCSG, "CSG");

                this.addSQLObject(textNetAPayer, "NET_A_PAYER");

                this.addSQLObject(textNetImp, "NET_IMP");

                this.addSQLObject(textSalBrut, "SAL_BRUT");

                this.addSQLObject(textAcompte, "ACOMPTE");

                this.addSQLObject(this.selSalCombo, "ID_SALARIE");

                this.addRequiredSQLObject(this.dateDu, "DU");

                this.addRequiredSQLObject(this.dateAu, "AU");

                this.selSalCombo.setInteractionMode(InteractionMode.DISABLED);

                this.selSalCombo.setEnabled(false);

                this.selSalCombo.setButtonsVisible(false);

                // this.selSalCombo.setVisible(false);

                buttonImportProfil.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        model.loadFromProfil(comboSelProfil.getSelectedId());

                    }

                });

            }

            // private boolean isDateValid() {

            //

            // String yearS = this.textAnnee.getText().trim();

            // int annee = (yearS.length() == 0) ? 0 : Integer.parseInt(yearS);

            //

            // int mois = this.selMois.getSelectedId();

            // // System.err.println("année " + annee + " dernAnnee " + this.dernAnnee + " mois " +

            // // mois + " dernMois " + this.dernMois);

            //

            // return ((this.dernAnnee == 0) ? true : annee > this.dernAnnee) || ((this.dernMois ==

            // 0 || this.dernMois == 13) ? true : mois > this.dernMois);

            // }

            //

            // @Override

            // public synchronized ValidState getValidState() {

            // // FIXME add fireValidChange()

            // return super.getValidState().and(ValidState.createCached(isDateValid(), "Date

            // invalide"));

            // }

            public int insert(SQLRow order) {

                int id = super.insert(order);

                this.model.updateFields(id);

                return id;

            }

            @Override

            public void update() {

                super.update();

                this.model.updateFields(this.getSelectedID());

            }

            @Override

            public void select(SQLRowAccessor r) {

                // System.err.println("SELECT FICHE ID -> " + r.getID());

                super.select(r);

                if (r != null && r.getID() > 1) {

                    this.model.setFicheID(r.getID());

                    SQLTable tableSal = getTable().getBase().getTable("SALARIE");

                    SQLRow rowSal = tableSal.getRow(r.getInt("ID_SALARIE"));

                    this.dernMois = rowSal.getInt("DERNIER_MOIS");

                    this.dernAnnee = rowSal.getInt("DERNIERE_ANNEE");

                    this.selSalCombo.setVisible(((Boolean) r.getObject("VALIDE")).booleanValue());

                    this.paneTreeLeft.setVisible(!((Boolean) r.getObject("VALIDE")).booleanValue());

                    setpDateEnabled(!((Boolean) r.getObject("VALIDE")).booleanValue());

                }

                this.selSalCombo.setInteractionMode(InteractionMode.DISABLED);

                this.selSalCombo.setEnabled(false);

                this.selMois.setButtonsVisible(false);

                this.selSalCombo.setButtonsVisible(false);

            }

            private void setpDateEnabled(boolean b) {

                this.selMois.setInteractionMode((b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);

                this.textAnnee.setEditable(b);

                this.textAnnee.setEnabled(b);

                this.dateDu.setInteractionMode((b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);

                this.dateAu.setInteractionMode((b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);

            }

            protected SQLRowValues createDefaults() {

                final SQLRowValues rowVals = new SQLRowValues(getTable());

                final Calendar cal = Calendar.getInstance();

                rowVals.put("ID_MOIS", cal.get(Calendar.MONTH) + 2);

                rowVals.put("ANNEE", cal.get(Calendar.YEAR));

                cal.set(Calendar.DAY_OF_MONTH, 1);

                rowVals.put("DU", new java.sql.Date(cal.getTime().getTime()));

                cal.set(Calendar.DAY_OF_MONTH, cal.getActualMaximum(Calendar.DAY_OF_MONTH));

                rowVals.put("AU", new java.sql.Date(cal.getTime().getTime()));

                return rowVals;

            }

        };

    }

    private static List<String> cumulFields = Arrays.asList("SAL_BRUT", "CSG", "COT_SAL", "COT_PAT", "NET_IMP", "HEURE_TRAV", "CICE", "AVANTAGE_NATURE", "ALLEGEMENT_COTISATION", "SAL_BASE_BRUT",

            "TAXE_CM_SAL", "TAXE_CM_PAT", "SAL_BRUT_COTISABLE", "SAL_BRUT_TAXABLE");

    @Override

    protected void archive(TreesOfSQLRows trees, boolean cutLinks) throws SQLException {

        super.archive(trees, cutLinks);

        for (SQLRow row : trees.getRows()) {

            if (row != null && row.getID() > 1) {

                if (JOptionPane.showConfirmDialog(null, "Soustraire les cumuls de cette fiche à celle en cours?", "Suppression d'une fiche de paye",

                        JOptionPane.YES_NO_OPTION) == JOptionPane.YES_OPTION) {

                    // on effectue le cumul

                    SQLRow rowSal = row.getForeignRow("ID_SALARIE");

                    SQLRow rowCumuls = rowSal.getForeignRow("ID_CUMULS_PAYE");

                    SQLRowValues rowValsCumul = rowCumuls.createEmptyUpdateRow();

                    for (String string : cumulFields) {

                        float cumul = rowCumuls.getFloat(string + "_C") - row.getFloat(string);

                        rowValsCumul.put(string + "_C", new Float(cumul));

                    }

                    // TODO stocker les heures travaillées du mois pour faire déduction

                    // float heure = rowCumuls.getFloat("HEURE_TRAV_C") -

                    // row.getFloat("HEURE_TRAV");

                    float netAPayer = rowCumuls.getFloat("NET_A_PAYER_C") - row.getFloat("NET_A_PAYER") - row.getFloat("ACOMPTE");

                    rowValsCumul.put("NET_A_PAYER_C", new Float(netAPayer));

                    // rowValsCumul.put("HEURE_TRAV_C", new Float(heure));

                    try {

                        rowValsCumul.update();

                    } catch (SQLException e) {

                        e.printStackTrace();

                    }

                    // Calcul des congés

                    SQLRow rowCumulConge = rowSal.getForeignRow("ID_CUMULS_CONGES");

                    SQLRow rowVarSalFiche = row.getForeignRow("ID_VARIABLE_SALARIE");

                    SQLRow rowVarSal = rowSal.getForeignRow("ID_VARIABLE_SALARIE");

                    float congeCumule = rowCumulConge.getFloat("ACQUIS");

                    float congeRestant = rowCumulConge.getFloat("RESTANT");

                    float prisPeriode = rowVarSalFiche.getFloat("CONGES_PRIS");

                    congeRestant += prisPeriode;

                    congeCumule -= row.getFloat("CONGES_ACQUIS");

                    SQLRowValues rowValsCumulsConges = new SQLRowValues(rowCumulConge.getTable());

                    rowValsCumulsConges.put("ACQUIS", new Float(congeCumule));

                    rowValsCumulsConges.put("RESTANT", new Float(congeRestant));

                    try {

                        rowValsCumulsConges.update(rowCumulConge.getID());

                    } catch (SQLException e) {

                        e.printStackTrace();

                    }

                    // Annulation du cumul des variables

                    final SQLRowValues rowVals = rowVarSal.asRowValues();

                    for (final SQLField field : rowVarSalFiche.getTable().getContentFields()) {

                        if (!field.getName().endsWith("_DEFAULT_VAL") && !field.getName().endsWith("_CUMUL_VAL")) {

                            if (rowVarSalFiche.getTable().contains(field.getName() + "_CUMUL_VAL")) {

                                final float valPeriode = rowVarSalFiche.getObject(field.getName()) == null ? 0.0F : rowVarSalFiche.getFloat(field.getName());

                                final float valCumul = rowVarSal.getObject(field.getName() + "_CUMUL_VAL") == null ? 0.0F : rowVarSal.getFloat(field.getName() + "_CUMUL_VAL");

                                rowVals.put(field.getName() + "_CUMUL_VAL", valCumul - valPeriode);

                            }

                        }

                    }

                    try {

                        rowVals.update();

                    } catch (SQLException e) {

                        e.printStackTrace();

                    }

                }

            }

        }

    }

    /**

     * Validation de la fiche de paye en cours pour un salarié

     *

     * @param id id de la fiche à valider

     * @throws SQLException

     */

    public static synchronized void validationFiche(int id) throws SQLException {

        final int oldID = id;

        SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();

        SQLTable tableSal = base.getTable("SALARIE");

        SQLTable tableCumulConge = base.getTable("CUMULS_CONGES");

        SQLTable tableVariableSal = base.getTable("VARIABLE_SALARIE");

        SQLTable tableFiche = base.getTable("FICHE_PAYE");

        SQLTable tableFicheElt = base.getTable("FICHE_PAYE_ELEMENT");

        SQLTable tableCumuls = base.getTable("CUMULS_PAYE");

        final SQLRowValues rowValsSal = new SQLRowValues(tableSal);

        final SQLRow rowFiche = tableFiche.getRow(oldID);

        final SQLRow rowSal = tableSal.getRow(rowFiche.getInt("ID_SALARIE"));

        // On teste que la fiche est entrée dans une période non cloturée

        if (!checkDateValid(id)) {

            String msg = "Impossible de créer la fiche de paye de " + rowSal.getString("NOM") + " " + rowSal.getString("PRENOM") + ".\n La période est cloturée.";

            JOptionPane.showMessageDialog(null, msg, "Création paye impossible", JOptionPane.INFORMATION_MESSAGE);

            return;

        }

        // valider les elements de la fiche

        validElements(id);

        // Sauvegarde des valeurs de la fiche (cumuls, conges, ...)

        stockValidValues(oldID);

        // creer et associer une nouvelle fiche au salarie

        final SQLRowValues rowValsNewFiche = new SQLRowValues(tableFiche);

        SQLRow r = rowValsNewFiche.insert();

        rowValsNewFiche.put("ID", r.getID());

        // mis a jour de la periode

        int mois = rowFiche.getInt("ID_MOIS");

        int annee = rowFiche.getInt("ANNEE");

        rowValsNewFiche.put("ID_MOIS", mois);

        rowValsNewFiche.put("ANNEE", annee);

        final Calendar calDu = rowFiche.getDate("DU");

        calDu.add(Calendar.MONTH, 1);

        calDu.set(Calendar.DAY_OF_MONTH, 1);

        rowValsNewFiche.put("DU", calDu.getTime());

        calDu.set(Calendar.DAY_OF_MONTH, calDu.getActualMaximum(Calendar.DAY_OF_MONTH));

        rowValsNewFiche.put("AU", calDu.getTime());

        rowValsNewFiche.put("ID_PROFIL_PAYE", rowFiche.getInt("ID_PROFIL_PAYE"));

        rowValsNewFiche.put("ID_SALARIE", rowSal.getID());

        rowValsSal.put("ID_FICHE_PAYE", rowValsNewFiche.getID());

        SwingUtilities.invokeLater(new Runnable() {

            public void run() {

                try {

                    // FIXME: Ouch: sql in swing!

                    rowValsSal.update(rowSal.getID());

                    rowValsNewFiche.update();

                } catch (SQLException e1) {

                    e1.printStackTrace();

                }

            }

        });

        // On recupere la liste des elements de la fiche de paye

        SQLSelect selAllElt = new SQLSelect();

        selAllElt.addSelect(tableFicheElt.getKey());

        selAllElt.addSelect(tableFicheElt.getField("POSITION"));

        selAllElt.addSelect(tableFicheElt.getField("SOURCE"));

        selAllElt.addSelect(tableFicheElt.getField("IDSOURCE"));

        selAllElt.setWhere(tableFicheElt.getField("ID_FICHE_PAYE"), "=", oldID);

        selAllElt.setDistinct(true);

        selAllElt.addFieldOrder(tableFicheElt.getField("POSITION"));

        for (final SQLRow rowTmpElt : SQLRowListRSH.execute(selAllElt)) {

            String source = rowTmpElt.getString("SOURCE");

            int idSource = rowTmpElt.getInt("IDSOURCE");

            int pos = rowTmpElt.getInt("POSITION");

            SQLRowValues rowValsTmp = new SQLRowValues(tableFicheElt);

            rowValsTmp.put("SOURCE", source);

            rowValsTmp.put("IDSOURCE", idSource);

            rowValsTmp.put("POSITION", pos);

            rowValsTmp.put("ID_FICHE_PAYE", rowValsNewFiche.getID());

            rowValsTmp.commit();

        }

        // on effectue le cumul

        final SQLRow rowVarSal = tableVariableSal.getRow(rowSal.getInt("ID_VARIABLE_SALARIE"));

        int idCumuls = rowSal.getInt("ID_CUMULS_PAYE");

        SQLRow rowCumuls = tableCumuls.getRow(idCumuls);

        SQLRowValues rowValsCumul = new SQLRowValues(tableCumuls);

        for (String string : cumulFields) {

            float cumul = rowCumuls.getFloat(string + "_C") + rowFiche.getFloat(string);

            rowValsCumul.put(string + "_C", new Float(cumul));

        }

        float netAPayer = rowCumuls.getFloat("NET_A_PAYER_C") + rowFiche.getFloat("NET_A_PAYER") + rowFiche.getFloat("ACOMPTE");

        rowValsCumul.put("NET_A_PAYER_C", new Float(netAPayer));

        SQLRow row = rowValsCumul.insert();

        rowValsCumul.put("ID", row.getID());

        rowValsSal.put("ID_CUMULS_PAYE", rowValsCumul.getID());

        SwingUtilities.invokeLater(new Runnable() {

            public void run() {

                // FIXME: Ouch: sql in swing!

                try {

                    rowValsSal.update(rowFiche.getInt("ID_SALARIE"));

                } catch (SQLException e1) {

                    e1.printStackTrace();

                }

            }

        });

        // Calcul des congés

        final SQLRow rowCumulConge = tableCumulConge.getRow(rowSal.getInt("ID_CUMULS_CONGES"));

        float congeCumule = rowCumulConge.getFloat("ACQUIS");

        float congeRestant = rowCumulConge.getFloat("RESTANT");

        float prisPeriode = rowVarSal.getFloat("CONGES_PRIS");

        congeRestant -= prisPeriode;

        SQLTable tableInfosSalPaye = base.getTable("INFOS_SALARIE_PAYE");

        final SQLRow rowSalInfosPaye = tableInfosSalPaye.getRow(rowSal.getInt("ID_INFOS_SALARIE_PAYE"));

        congeCumule += rowFiche.getFloat("CONGES_ACQUIS");

        final SQLRowValues rowValsCumulsConges = new SQLRowValues(tableCumulConge);

        // Si on passe le 1 juin

        // FIXME est ce que les conges nonpris sont à indemniser

        /*

         * if (mois == 7) { congeRestant = congeCumule; congeCumule = 0; }

         */

        rowValsCumulsConges.put("ACQUIS", new Float(congeCumule));

        rowValsCumulsConges.put("RESTANT", new Float(congeRestant));

        SwingUtilities.invokeLater(new Runnable() {

            public void run() { // FIXME: Ouch: sql in swing!

                try {

                    rowValsCumulsConges.update(rowCumulConge.getID());

                    rowValsNewFiche.put("CONGES_ACQUIS", new Float(rowSalInfosPaye.getFloat("CONGES_PAYES")));

                    rowValsNewFiche.update();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

        });

        final SQLRowValues rowValsOldFiche = new SQLRowValues(tableFiche);

        rowValsOldFiche.put("VALIDE", Boolean.TRUE);

        SwingUtilities.invokeLater(new Runnable() {

            public void run() { // FIXME: Ouch: sql in swing!

                try {

                    rowValsOldFiche.update(rowFiche.getID());

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

        });

        // Remise à 0 des variables sal

        final SQLRowValues rowVals = new SQLRowValues(tableVariableSal);

        for (final SQLField field : tableVariableSal.getContentFields()) {

            if (!field.getName().endsWith("_DEFAULT_VAL") && !field.getName().endsWith("_CUMUL_VAL")) {

                if (tableVariableSal.contains(field.getName() + "_CUMUL_VAL")) {

                    final float valPeriode = rowVarSal.getObject(field.getName()) == null ? 0.0F : rowVarSal.getFloat(field.getName());

                    final float valCumul = rowVarSal.getObject(field.getName() + "_CUMUL_VAL") == null ? 0.0F : rowVarSal.getFloat(field.getName() + "_CUMUL_VAL");

                    rowVals.put(field.getName() + "_CUMUL_VAL", valCumul + valPeriode);

                }

                if (tableVariableSal.contains(field.getName() + "_DEFAULT_VAL")) {

                    rowVals.put(field.getName(), rowVarSal.getObject(field.getName() + "_DEFAULT_VAL"));

                } else {

                    if (field.getType().getJavaType() == Integer.class) {

                        rowVals.put(field.getName(), 0);

                    } else {

                        rowVals.put(field.getName(), Float.valueOf(0));

                    }

                }

            }

        }

        rowVals.put("HEURE_TRAV", rowSalInfosPaye.getObject("DUREE_MOIS"));

        if (tableVariableSal.contains("NB_JOUR_MOIS")) {

            rowVals.put("NB_JOUR_MOIS", Float.valueOf(31));

            rowVals.put("NB_JOUR_TRAV", Float.valueOf(31));

        }

        SwingUtilities.invokeLater(new Runnable() {

            public void run() { // FIXME: Ouch: sql in swing!

                try {

                    rowVals.update(rowVarSal.getID());

                } catch (SQLException e) {