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.finance.accounting.ui;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

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

import org.openconcerto.erp.core.finance.accounting.element.ComptePCESQLElement;

import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;

import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;

import org.openconcerto.erp.core.finance.accounting.model.PointageModel;

import org.openconcerto.erp.model.ISQLCompteSelector;

import org.openconcerto.erp.rights.ComptaUserRight;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.element.SQLElementDirectory;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLSystem;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.request.ComboSQLRequest;

import org.openconcerto.sql.users.rights.UserRightsManager;

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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.FontUtils;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.JLabelBold;

import org.openconcerto.ui.warning.JLabelWarning;

import org.openconcerto.utils.text.SimpleDocumentListener;

import java.awt.Color;

import java.awt.Component;

import java.awt.Dimension;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.Window;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.KeyAdapter;

import java.awt.event.KeyEvent;

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

import java.util.concurrent.ExecutionException;

import javax.swing.AbstractAction;

import javax.swing.BorderFactory;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JPopupMenu;

import javax.swing.JRadioButton;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import javax.swing.SwingUtilities;

import javax.swing.SwingWorker;

import javax.swing.event.DocumentEvent;

import javax.swing.event.TableModelEvent;

import javax.swing.event.TableModelListener;

public class PointagePanel extends JPanel {

    private ListPanelEcritures ecriturePanel;

    private JTextField codePointage;

    private ISQLCompteSelector selCompte;

    private final JDate datePointee;

    private JCheckBox boxValidEcriture;

    private JPanel warningPanel;

    private final DeviseField fieldSoldeD = new DeviseField(15);

    private final DeviseField fieldSoldeA = new DeviseField(15);

    private final DeviseField fieldEcart = new DeviseField(15);

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

    private final SQLTable tableEcr = this.base.getTable("ECRITURE");

    private final static int allEcriture = 0;

    private final static int ecriturePointee = 1;

    private final static int ecritureNotPointee = 2;

    private int modeSelect;

    private PointageModel model;

    private JButton buttonPointer;

    private JDate dateFin, dateDeb;

    public PointagePanel() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        final SQLElementDirectory directory = Configuration.getInstance().getDirectory();

        this.modeSelect = allEcriture;

        // Selection du compte à pointer

        // TODO Ajouter selection d'un Journal

        JLabel labelPointageCompte = new JLabel("Pointage du compte");

        labelPointageCompte.setHorizontalAlignment(SwingConstants.RIGHT);

        this.add(labelPointageCompte, c);

        this.selCompte = new ISQLCompteSelector();

        SQLElement eltCpt = directory.getElement("COMPTE_PCE");

        final ComboSQLRequest createComboRequest = eltCpt.createComboRequest();

        String function = "REGEXP";

        if (Configuration.getInstance().getBase().getServer().getSQLSystem() == SQLSystem.POSTGRESQL) {

            function = "~";

        }

        createComboRequest.setWhere(new Where(eltCpt.getTable().getField("NUMERO"), function, "^5.*$"));

        this.selCompte.init(eltCpt, createComboRequest);

        new SwingWorker<Integer, Object>() {

            @Override

            protected Integer doInBackground() throws Exception {

                return ComptePCESQLElement.getId("5");

            }

            @Override

            protected void done() {

                try {

                    PointagePanel.this.selCompte.setValue(get());

                } catch (InterruptedException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                } catch (ExecutionException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

            }

        }.execute();

        c.weightx = 1;

        c.gridx++;

        c.gridwidth = 2;

        c.fill = GridBagConstraints.NONE;

        this.add(this.selCompte, c);

        // Gestion du pointage

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

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = 1;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        // Numero de releve

        final JLabel labelReleve = new JLabel("N° de relevé");

        labelReleve.setHorizontalAlignment(SwingConstants.RIGHT);

        this.add(labelReleve, c);

        this.codePointage = new JTextField(10);

        c.gridx++;

        c.weightx = 0;

        c.fill = GridBagConstraints.NONE;

        this.add(this.codePointage, c);

        // Warning si aucun code rentré

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        c.gridwidth = 1;

        c.weightx = 0;

        createPanelWarning();

        this.add(this.warningPanel, c);

        // Date de pointage

        // MAYBE si date invalide grisée le bouton pointer

        JLabel labelDate = new JLabel("Date de pointage");

        labelDate.setHorizontalAlignment(SwingConstants.RIGHT);

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = 1;

        c.weightx = 0;

        this.add(labelDate, c);

        this.datePointee = new JDate(true);

        c.fill = GridBagConstraints.NONE;

        c.weightx = 1;

        c.gridx++;

        c.gridwidth = 1;

        this.add(this.datePointee, c);

        JPanel panelCheckValue = new JPanel(new GridBagLayout());

        GridBagConstraints cCheck = new DefaultGridBagConstraints();

        JLabel labelSoldeD = new JLabel("Solde de départ");

        labelSoldeD.setHorizontalAlignment(SwingConstants.RIGHT);

        cCheck.gridwidth = 1;

        cCheck.weightx = 0;

        panelCheckValue.add(labelSoldeD, cCheck);

        cCheck.fill = GridBagConstraints.NONE;

        cCheck.weightx = 1;

        cCheck.gridx++;

        cCheck.gridwidth = 1;

        panelCheckValue.add(this.fieldSoldeD, cCheck);

        JLabel labelSoldeA = new JLabel("Solde d'arrivée");

        labelSoldeA.setHorizontalAlignment(SwingConstants.RIGHT);

        cCheck.gridx++;

        cCheck.gridwidth = 1;

        cCheck.weightx = 0;

        panelCheckValue.add(labelSoldeA, cCheck);

        cCheck.fill = GridBagConstraints.NONE;

        cCheck.weightx = 1;

        cCheck.gridx++;

        cCheck.gridwidth = 1;

        panelCheckValue.add(this.fieldSoldeA, cCheck);

        JLabel labelEcart = new JLabel("Ecart pointage");

        labelEcart.setHorizontalAlignment(SwingConstants.RIGHT);

        cCheck.gridx++;

        cCheck.gridwidth = 1;

        cCheck.weightx = 0;

        panelCheckValue.add(labelEcart, cCheck);

        cCheck.fill = GridBagConstraints.NONE;

        cCheck.weightx = 1;

        cCheck.gridx++;

        cCheck.gridwidth = 1;

        this.fieldEcart.setEditable(false);

        panelCheckValue.add(this.fieldEcart, cCheck);

        c.gridx++;

        c.gridwidth = 1;

        c.weightx = 1;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(panelCheckValue, c);

        this.fieldSoldeA.getDocument().addDocumentListener(new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                PointagePanel.this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

            }

        });

        this.fieldSoldeD.getDocument().addDocumentListener(new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                PointagePanel.this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

            }

        });

        JLabelBold sepPeriode = new JLabelBold("Liste des écritures");

        c.gridy++;

        c.gridx = 0;

        c.anchor = GridBagConstraints.WEST;

        c.gridwidth = 3;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(sepPeriode, c);

        JPanel panelSelectEcritures = createPanelSelectionEcritures();

        c.gridy++;

        c.weightx = 0;

        c.gridwidth = 1;

        c.gridx = 0;

        final JLabel labelEcr = new JLabel("Etats");

        labelEcr.setHorizontalAlignment(SwingConstants.RIGHT);

        this.add(labelEcr, c);

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        c.gridwidth = 2;

        c.weightx = 1;

        this.add(panelSelectEcritures, c);

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        JPanel panelPeriode = new JPanel();

        // Date de début

        this.dateDeb = new JDate();

        final JLabel periodLabel = new JLabel("Période du ");

        periodLabel.setHorizontalAlignment(SwingConstants.RIGHT);

        c.gridwidth = 1;

        this.add(periodLabel, c);

        c.gridx++;

        panelPeriode.add(this.dateDeb);

        this.dateDeb.addValueListener(new PropertyChangeListener() {

            public void propertyChange(PropertyChangeEvent evt) {

                changeListRequest();

                PointagePanel.this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

            }

        });

        // Date de fin

        this.dateFin = new JDate(true);

        panelPeriode.add(new JLabel("au"));

        this.dateFin.addValueListener(new PropertyChangeListener() {

            public void propertyChange(PropertyChangeEvent evt) {

                changeListRequest();

                PointagePanel.this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

            }

        });

        panelPeriode.add(this.dateFin);

        c.weightx = 1;

        c.fill = GridBagConstraints.NONE;

        c.gridwidth = 2;

        this.add(panelPeriode, c);

        // Liste des ecritures

        final EcritureSQLElement ecritureElem = directory.getElement(EcritureSQLElement.class);

        this.ecriturePanel = new ListPanelEcritures(ecritureElem, new IListe(ecritureElem.createPointageTableSource()));

        this.ecriturePanel.setShowReadOnlyFrameOnDoubleClick(false);

        c.gridx = 0;

        c.gridy++;

        c.weighty = 1;

        c.weightx = 1;

        c.fill = GridBagConstraints.BOTH;

        c.gridwidth = 3;

        this.ecriturePanel.getListe().setPreferredSize(new Dimension(this.ecriturePanel.getListe().getPreferredSize().width, 200));

        this.add(this.ecriturePanel, c);

        c.gridy++;

        c.weighty = 0;

        this.add(createBottomPanel(), c);

        // Changement de compte

        this.selCompte.addModelListener("wantedID", new PropertyChangeListener() {

            public void propertyChange(PropertyChangeEvent evt) {

                changeListRequest();

            };

        });

        // Action Souris sur la IListe

        this.ecriturePanel.getListe().getJTable().addMouseListener(new MouseAdapter() {

            @Override

            public void mouseReleased(MouseEvent e) {

                // ATTN never modify an IListe on mousePressed otherwise the selection is incoherent

                // (see IListe.iterateSelectedRows())

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

                    int rowIndex = PointagePanel.this.ecriturePanel.getListe().getJTable().rowAtPoint(e.getPoint());

                    int id = PointagePanel.this.ecriturePanel.getListe().idFromIndex(rowIndex);

                    SQLRow row = PointagePanel.this.tableEcr.getRow(id);

                    if (row.getString("POINTEE").trim().length() == 0) {

                        actionPointage(rowIndex);

                    } else {

                        actionDepointage(rowIndex);

                    }

                }

                if (e.getButton() == MouseEvent.BUTTON3) {

                    actionMenuDroit(e);

                }

                int[] selectedRows = PointagePanel.this.ecriturePanel.getListe().getJTable().getSelectedRows();

                int[] idRows = new int[selectedRows.length];

                for (int i = 0; i < idRows.length; i++) {

                    idRows[i] = PointagePanel.this.ecriturePanel.getListe().idFromIndex(selectedRows[i]);

                }

                PointagePanel.this.model.updateSelection(idRows);

            }

        });

        // action sur la IListe

        this.ecriturePanel.getListe().getJTable().addKeyListener(new KeyAdapter() {

            @Override

            public void keyReleased(KeyEvent e) {

                int[] selectedRows = PointagePanel.this.ecriturePanel.getListe().getJTable().getSelectedRows();

                int[] idRows = new int[selectedRows.length];

                for (int i = 0; i < idRows.length; i++) {

                    idRows[i] = PointagePanel.this.ecriturePanel.getListe().idFromIndex(selectedRows[i]);

                }

                PointagePanel.this.model.updateSelection(idRows);

            }

        });

        this.ecriturePanel.getListe().addListener(new TableModelListener() {

            @Override

            public void tableChanged(TableModelEvent e) {

                PointagePanel.this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

            }

        });

        // Gestion du code de releve

        this.codePointage.getDocument().addDocumentListener(new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                PointagePanel.this.warningPanel.setVisible((PointagePanel.this.codePointage.getText().trim().length() == 0));

                PointagePanel.this.buttonPointer.setEnabled((PointagePanel.this.codePointage.getText().trim().length() != 0));

                PointagePanel.this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

            }

        });

        changeListRequest();

        this.warningPanel.setVisible((this.codePointage.getText().trim().length() == 0));

        this.buttonPointer.setEnabled((this.codePointage.getText().trim().length() != 0));

    }

    private Component createBottomPanel() {

        JPanel p = new JPanel();

        GridBagConstraints c = new DefaultGridBagConstraints();

        p.setLayout(new GridBagLayout());

        // JTable Totaux

        c.weighty = 1;

        c.weightx = 1;

        c.gridheight = 3;

        c.fill = GridBagConstraints.BOTH;

        this.model = new PointageModel(this.selCompte.getSelectedId(), this);

        JTable table = new JTable(this.model);

        table.setRowHeight(FontUtils.getPreferredRowHeight(table));

        final DeviseNiceTableCellRenderer cellRenderer = new DeviseNiceTableCellRenderer();

        for (int i = 0; i < table.getColumnCount(); i++) {

            table.getColumnModel().getColumn(i).setCellRenderer(cellRenderer);

        }

        JScrollPane sPane = new JScrollPane(table);

        // TODO Gerer la taille des colonnes

        Dimension d = new Dimension(table.getPreferredSize().width, table.getPreferredSize().height + table.getTableHeader().getPreferredSize().height + 4);

        sPane.setPreferredSize(d);

        p.add(sPane, c);

        // Legende

        c.gridx++;

        c.anchor = GridBagConstraints.WEST;

        c.fill = GridBagConstraints.NONE;

        c.weightx = 0;

        p.add(createPanelLegende(), c);

        // Validation des ecritures pointées

        this.boxValidEcriture = new JCheckBox("Valider les écritures pointées");

        c.gridx++;

        c.gridheight = 1;

        c.gridwidth = 2;

        p.add(this.boxValidEcriture, c);

        // Bouton Pointer

        c.anchor = GridBagConstraints.SOUTHEAST;

        this.buttonPointer = new JButton("Pointer");

        c.gridwidth = 1;

        c.gridy++;

        c.fill = GridBagConstraints.NONE;

        p.add(this.buttonPointer, c);

        // Bouton Depointer

        JButton buttonDepointer = new JButton("Dépointer");

        c.gridx++;

        p.add(buttonDepointer, c);

        c.gridy++;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.EAST;

        JButton buttonClose = new JButton("Fermer");

        buttonClose.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                ((Window) SwingUtilities.getRoot(PointagePanel.this)).dispose();

            }

        });

        p.add(buttonClose, c);

        this.buttonPointer.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                int[] rowIndex = PointagePanel.this.ecriturePanel.getListe().getJTable().getSelectedRows();

                for (int i = 0; i < rowIndex.length; i++) {

                    actionPointage(rowIndex[i]);

                }

            }

        });

        buttonDepointer.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                int[] rowIndex = PointagePanel.this.ecriturePanel.getListe().getJTable().getSelectedRows();

                for (int i = 0; i < rowIndex.length; i++) {

                    actionDepointage(rowIndex[i]);

                }

            }

        });

        return p;

    }

    /* Menu clic Droit */

    private void actionMenuDroit(final MouseEvent mE) {

        JPopupMenu menu = new JPopupMenu();

        menu.add(new AbstractAction("Voir la source") {

            public void actionPerformed(ActionEvent e) {

                int rowIndex = PointagePanel.this.ecriturePanel.getListe().getJTable().rowAtPoint(mE.getPoint());

                int id = PointagePanel.this.ecriturePanel.getListe().idFromIndex(rowIndex);

                SQLTable ecriture = PointagePanel.this.base.getTable("ECRITURE");

                SQLRow rowEcr = ecriture.getRow(id);

                MouvementSQLElement.showSource(rowEcr.getInt("ID_MOUVEMENT"));

            }

        });

        if (this.codePointage.getText().trim().length() != 0) {

            menu.add(new AbstractAction("Pointer") {

                public void actionPerformed(ActionEvent e) {

                    int rowIndex = PointagePanel.this.ecriturePanel.getListe().getJTable().rowAtPoint(mE.getPoint());

                    actionPointage(rowIndex);

                }

            });

        }

        menu.add(new AbstractAction("Dépointer") {

            public void actionPerformed(ActionEvent e) {

                int rowIndex = PointagePanel.this.ecriturePanel.getListe().getJTable().rowAtPoint(mE.getPoint());

                actionDepointage(rowIndex);

            }

        });

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

    }

    public Date getDateDeb() {

        return this.dateDeb.getValue();

    }

    public Date getDateFin() {

        return this.dateFin.getDate();

    }

    public String getCodePointage() {

        return this.codePointage.getText();

    }

    /* Panel Warning no numero releve */

    private void createPanelWarning() {

        this.warningPanel = new JPanel();

        this.warningPanel.setLayout(new GridBagLayout());

        // this.warningPanel.setBorder(BorderFactory.createTitledBorder("Warning"));

        GridBagConstraints c = new GridBagConstraints();

        c.anchor = GridBagConstraints.WEST;

        c.fill = GridBagConstraints.NONE;

        c.gridheight = 1;

        c.gridwidth = 1;

        c.gridx = 0;

        c.gridy = 0;

        c.weightx = 0;

        c.weighty = 0;

        final JLabel warningNoCodeImg = new JLabelWarning();

        // warningNoCodeImg.setHorizontalAlignment(SwingConstants.RIGHT);

        this.warningPanel.add(warningNoCodeImg, c);

        final JLabel warningNoCodeText = new JLabel("Impossible de pointer tant que le numéro de relevé n'est pas saisi!");

        c.gridx++;

        this.warningPanel.add(warningNoCodeText, c);

    }

    // Pointe la ligne passée en parametre

    private void actionPointage(int rowIndex) {

        String codePoint = this.codePointage.getText().trim();

        int id = this.ecriturePanel.getListe().idFromIndex(rowIndex);

        SQLRow row = this.tableEcr.getRow(id);

        SQLRowValues rowVals = new SQLRowValues(this.tableEcr);

        // Pointage

        // On pointe ou repointe la ligne avec la date et le numero de releve saisis

        if ((!this.datePointee.isEmpty()) && (codePoint.length() > 0)) {

            // Si la ligne est en brouillard on valide le mouvement associé

            if (this.boxValidEcriture.isSelected() && (!row.getBoolean("VALIDE"))) {

                EcritureSQLElement.validationEcritures(row.getInt("ID_MOUVEMENT"));

            }

            rowVals.put("POINTEE", codePoint);

            rowVals.put("DATE_POINTEE", new java.sql.Date(this.datePointee.getDate().getTime()));

            try {

                rowVals.update(id);

            } catch (SQLException e1) {

                e1.printStackTrace();

            }

        }

        this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

    }

    public ListPanelEcritures getEcriturePanel() {

        return this.ecriturePanel;

    }

    // Pointe la ligne passée en parametre

    private void actionDepointage(int rowIndex) {

        int id = this.ecriturePanel.getListe().idFromIndex(rowIndex);

        SQLRow row = this.tableEcr.getRow(id);

        SQLRowValues rowVals = new SQLRowValues(this.tableEcr);

        // Dépointage

        if (row.getString("POINTEE").trim().length() != 0) {

            rowVals.put("POINTEE", "");

            rowVals.put("DATE_POINTEE", null);

            try {

                rowVals.update(id);

            } catch (SQLException e1) {

                e1.printStackTrace();

            }

        }

        this.model.updateTotauxCompte(PointagePanel.this.fieldSoldeD, PointagePanel.this.fieldSoldeA, PointagePanel.this.fieldEcart);

    }

    /*

     * MaJ de la requete pour remplir la IListe en fonction du compte sélectionner et du mode de

     * sélection

     */

    private void changeListRequest() {

        Object idCpt = this.selCompte.getWantedID();

        // filtre de selection

        Where w = new Where(this.tableEcr.getField("ID_COMPTE_PCE"), "=", idCpt);

        if (!UserRightsManager.getCurrentUserRights().haveRight(ComptaUserRight.ACCES_NOT_RESCTRICTED_TO_411)) {

            // TODO Show Restricted acces in UI

            w = w.and(new Where(this.tableEcr.getField("COMPTE_NUMERO"), "LIKE", "411%"));

        }

        Date d1 = this.dateDeb.getValue();

        Date d2 = this.dateFin.getValue();

        if (d1 == null && d2 != null) {

            w = w.and(new Where(this.tableEcr.getField("DATE"), "<=", d2));

        } else {

            if (d1 != null && d2 == null) {

                w = w.and(new Where(this.tableEcr.getField("DATE"), ">=", d1));

            } else {

                if (d1 != null && d2 != null) {

                    w = w.and(new Where(this.tableEcr.getField("DATE"), d1, d2));

                }

            }

        }

        if (this.modeSelect == ecriturePointee) {

            w = w.and(new Where(this.tableEcr.getField("POINTEE"), "!=", ""));

        } else {

            if (this.modeSelect == ecritureNotPointee) {

                w = w.and(new Where(this.tableEcr.getField("POINTEE"), "=", ""));

            }

        }

        this.ecriturePanel.getListe().getRequest().setWhere(w);

        this.ecriturePanel.getListe().setModificationAllowed(false);

        this.model.setIdCompte(Integer.parseInt(idCpt.toString()));

    }

    /*

     * Panel de sélection du mode d'affichage des ecritures

     */

    private JPanel createPanelSelectionEcritures() {

        JPanel panelSelectEcritures = new JPanel();

        GridBagConstraints cPanel = new GridBagConstraints();

        cPanel.anchor = GridBagConstraints.NORTHWEST;

        cPanel.fill = GridBagConstraints.HORIZONTAL;

        cPanel.gridheight = 1;

        cPanel.gridwidth = 1;

        cPanel.gridx = 0;

        cPanel.gridy = 0;

        cPanel.weightx = 0;

        cPanel.weighty = 0;

        panelSelectEcritures.setLayout(new GridBagLayout());

        final JRadioButton buttonBoth = new JRadioButton("Toutes");

        panelSelectEcritures.add(buttonBoth, cPanel);

        cPanel.gridx++;

        final JRadioButton buttonNotPointe = new JRadioButton("Non pointées");

        panelSelectEcritures.add(buttonNotPointe, cPanel);

        cPanel.gridx++;

        final JRadioButton buttonPointe = new JRadioButton("Pointées");

        panelSelectEcritures.add(buttonPointe, cPanel);

        ButtonGroup group = new ButtonGroup();

        group.add(buttonBoth);

        group.add(buttonNotPointe);

        group.add(buttonPointe);

        buttonBoth.setSelected(true);

        buttonPointe.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                if (buttonPointe.isSelected()) {

                    PointagePanel.this.modeSelect = ecriturePointee;

                    changeListRequest();

                }

            }

        });

        buttonNotPointe.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                if (buttonNotPointe.isSelected()) {

                    PointagePanel.this.modeSelect = ecritureNotPointee;

                    changeListRequest();

                }

            }

        });

        buttonBoth.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                if (buttonBoth.isSelected()) {

                    PointagePanel.this.modeSelect = allEcriture;

                    changeListRequest();

                }

            }

        });

        return panelSelectEcritures;

    }

    /*

     * Creation du panel de la legende

     */

    private JPanel createPanelLegende() {

        JPanel panelLegende = new JPanel();

        GridBagConstraints c = new GridBagConstraints();

        c.anchor = GridBagConstraints.NORTHWEST;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.gridheight = 1;

        c.gridwidth = 1;

        c.gridx = 0;

        c.gridy = GridBagConstraints.RELATIVE;

        c.weightx = 0;

        c.weighty = 0;

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

        GridBagConstraints cPanel = new GridBagConstraints();

        cPanel.anchor = GridBagConstraints.NORTHWEST;

        cPanel.fill = GridBagConstraints.HORIZONTAL;

        cPanel.gridheight = 1;

        cPanel.gridwidth = 1;

        cPanel.gridx = 0;

        cPanel.gridy = GridBagConstraints.RELATIVE;

        cPanel.weightx = 0;

        cPanel.weighty = 0;

        cPanel.insets = new Insets(0, 0, 0, 0);

        panelLegende.setLayout(new GridBagLayout());

        panelLegende.setBorder(BorderFactory.createTitledBorder("Légendes"));

        JPanel ecritureValidPanel = new JPanel();

        ecritureValidPanel.setLayout(new GridBagLayout());

        ecritureValidPanel.setBackground(Color.WHITE);

        ecritureValidPanel.add(new JLabel("Ecritures validées"), cPanel);

        panelLegende.add(ecritureValidPanel, c);

        JPanel ecritureNonValidPanel = new JPanel();

        ecritureNonValidPanel.setLayout(new GridBagLayout());

        ecritureNonValidPanel.setBackground(PointageRenderer.getCouleurEcritureNonValide());

        ecritureNonValidPanel.add(new JLabel("Ecritures non validées"), cPanel);

        panelLegende.add(ecritureNonValidPanel, c);

        JPanel ecritureNonValidTodayPanel = new JPanel();

        ecritureNonValidTodayPanel.setLayout(new GridBagLayout());

        ecritureNonValidTodayPanel.setBackground(PointageRenderer.getCouleurEcritureToDay());

        ecritureNonValidTodayPanel.add(new JLabel("Ecritures non validées du jour"), cPanel);

        panelLegende.add(ecritureNonValidTodayPanel, c);

        JPanel ecriturePointePanel = new JPanel();

        ecriturePointePanel.setLayout(new GridBagLayout());

        ecriturePointePanel.setBackground(PointageRenderer.getCouleurEcriturePointee());

        ecriturePointePanel.add(new JLabel("Ecritures pointées"), cPanel);

        panelLegende.add(ecriturePointePanel, c);

        return panelLegende;

    }

}