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

import org.openconcerto.erp.core.finance.accounting.report.GrandLivrePDF;

import org.openconcerto.erp.core.finance.accounting.report.GrandLivreSheetXML;

import org.openconcerto.erp.generationDoc.SpreadSheetGeneratorListener;

import org.openconcerto.erp.preferences.DefaultNXProps;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.JLabelBold;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.FileUtils;

import java.awt.FlowLayout;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.io.File;

import java.io.IOException;

import java.text.SimpleDateFormat;

import java.util.Date;

import javax.swing.AbstractAction;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JFileChooser;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JProgressBar;

import javax.swing.JRadioButton;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import javax.swing.SwingUtilities;

import javax.swing.event.DocumentEvent;

import javax.swing.event.DocumentListener;

public class ImpressionGrandLivrePanel extends JPanel implements SpreadSheetGeneratorListener {

    private final JDate dateDeb;

    private final JDate dateEnd;

    private JButton validPDF;

    private JButton validODS;

    private JButton annul;

    private JCheckBox checkImpr;

    private JCheckBox checkVisu;

    private JTextField compteDeb, compteEnd;

    private int mode = GrandLivrePDF.MODEALL;

    private JProgressBar bar = new JProgressBar(0, 3);

    public ImpressionGrandLivrePanel() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

        final ComptaPropsConfiguration comptaPropsConfiguration = (ComptaPropsConfiguration) Configuration.getInstance();

        SQLRow rowSociete = comptaPropsConfiguration.getRowSociete();

        SQLRow rowExercice = comptaPropsConfiguration.getBase().getTable("EXERCICE_COMMON").getRow(rowSociete.getInt("ID_EXERCICE_COMMON"));

        this.dateDeb = new JDate();

        this.dateEnd = new JDate();

        // Période

        c.weightx = 0;

        this.add(new JLabel("Période du", SwingConstants.RIGHT), c);

        c.gridx++;

        c.weightx = 0;

        this.add(this.dateDeb, c);

        // Chargement des valeurs par défaut

        String valueDateDeb = DefaultNXProps.getInstance().getStringProperty("GrandLivreDateDeb");

        if (valueDateDeb.trim().length() > 0) {

            Long l = new Long(valueDateDeb);

            this.dateDeb.setValue(new Date(l.longValue()));

        } else {

            this.dateDeb.setValue((Date) rowExercice.getObject("DATE_DEB"));

        }

        c.gridx++;

        c.weightx = 0;

        this.add(new JLabel("au"), c);

        c.gridx++;

        c.fill = GridBagConstraints.NONE;

        this.add(this.dateEnd, c);

        // Chargement des valeurs par défaut

        String valueDateEnd = DefaultNXProps.getInstance().getStringProperty("GrandLivreDateEnd");

        if (valueDateEnd.trim().length() > 0) {

            Long l = new Long(valueDateEnd);

            this.dateEnd.setValue(new Date(l.longValue()));

        } else {

            this.dateEnd.setValue((Date) rowExercice.getObject("DATE_FIN"));

        }

        // Compte

        this.compteDeb = new JTextField(8);

        this.compteEnd = new JTextField(8);

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(new JLabel("Du compte", SwingConstants.RIGHT), c);

        c.gridx++;

        c.gridwidth = 3;

        c.fill = GridBagConstraints.NONE;

        JPanel pCompte = new JPanel(new FlowLayout(FlowLayout.LEADING, 0, 0));

        pCompte.add(this.compteDeb);

        pCompte.add(new JLabel(" au compte "));

        pCompte.add(this.compteEnd);

        this.add(pCompte, c);

        c.gridx = 0;

        c.gridwidth = 4;

        c.gridy++;

        this.add(new JLabelBold("Options"), c);

        final JCheckBox boxCumulsAnts = new JCheckBox("Cumuls antérieurs");

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = 2;

        this.add(boxCumulsAnts, c);

        boxCumulsAnts.setSelected(true);

        final JCheckBox boxCentralClient = new JCheckBox("Centralisation comptes clients");

        c.gridx += 2;

        c.gridwidth = 2;

        this.add(boxCentralClient, c);

        final JCheckBox boxCompteSolde = new JCheckBox("Inclure les comptes soldés");

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = 2;

        this.add(boxCompteSolde, c);

        boxCompteSolde.setSelected(true);

        final JCheckBox boxCentralFourn = new JCheckBox("Centralisation comptes fournisseurs");

        c.gridx += 2;

        c.gridwidth = 2;

        this.add(boxCentralFourn, c);

        // Journal à exclure

        c.gridy++;

        c.gridx = 0;

        c.gridwidth = 1;

        this.add(new JLabel("Exclure le journal", SwingConstants.RIGHT), c);

        c.gridx++;

        c.gridwidth = 3;

        final ElementComboBox comboJrnl = new ElementComboBox(true);

        comboJrnl.init(Configuration.getInstance().getDirectory().getElement("JOURNAL"));

        this.add(comboJrnl, c);

        // Radio mode

        JRadioButton radioAll = new JRadioButton(new AbstractAction("Toutes") {

            public void actionPerformed(ActionEvent e) {

                mode = GrandLivrePDF.MODEALL;

            }

        });

        JRadioButton radioLettree = new JRadioButton(new AbstractAction("Lettrées") {

            public void actionPerformed(ActionEvent e) {

                mode = GrandLivrePDF.MODELETTREE;

            }

        });

        JRadioButton radioNonLettree = new JRadioButton(new AbstractAction("Non lettrées") {

            public void actionPerformed(ActionEvent e) {

                mode = GrandLivrePDF.MODENONLETTREE_ALL;

            }

        });

        JRadioButton radioNonLettreePeridod = new JRadioButton(new AbstractAction("Non lettrées sur la période") {

            public void actionPerformed(ActionEvent e) {

                mode = GrandLivrePDF.MODENONLETTREE_PERIODE;

            }

        });

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(new JLabelBold("Ecritures à inclure"), c);

        JPanel panelMode = new JPanel();

        panelMode.add(radioAll);

        panelMode.add(radioLettree);

        panelMode.add(radioNonLettree);

        panelMode.add(radioNonLettreePeridod);

        c.gridy++;

        c.gridx = 0;

        c.weightx = 0;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.weighty = 0;

        c.fill = GridBagConstraints.NONE;

        ButtonGroup group = new ButtonGroup();

        group.add(radioAll);

        group.add(radioLettree);

        group.add(radioNonLettree);

        group.add(radioNonLettreePeridod);

        radioAll.setSelected(true);

        this.add(panelMode, c);

        // Progress bar

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridy++;

        c.gridx = 0;

        c.weighty = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.add(new JLabelBold("Progression de la creation du grand livre"), c);

        c.gridy++;

        this.bar.setStringPainted(true);

        this.add(this.bar, c);

        this.validPDF = new JButton("PDF");

        this.validODS = new JButton("Tableur");

        this.annul = new JButton("Fermer");

        // OK, Cancel

        c.gridx = 0;

        c.gridy++;

        c.gridwidth = 4;

        c.weightx = 1;

        c.weighty = 1;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.SOUTHEAST;

        JPanel panelOkCancel = new JPanel();

        panelOkCancel.add(this.validODS);

        panelOkCancel.add(this.validPDF);

        panelOkCancel.add(this.annul);

        this.add(panelOkCancel, c);

        this.checkValidity();

        this.validPDF.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                JFileChooser chooser = new JFileChooser();

                SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy");

                chooser.setSelectedFile(new File("Grand livre " + df.format(new Date()) + ".pdf"));

                int r = chooser.showSaveDialog(ImpressionGrandLivrePanel.this);

                if (r == JFileChooser.APPROVE_OPTION) {

                    validPDF.setEnabled(false);

                    validODS.setEnabled(false);

                    bar.setString(null);

                    bar.setValue(0);

                    // un fichier a été choisi (sortie par OK)

                    // nom du fichier choisi

                    final File file = chooser.getSelectedFile();

                    new Thread(new Runnable() {

                        public void run() {

                            try {

                                final GrandLivrePDF bSheet = new GrandLivrePDF(comptaPropsConfiguration, dateDeb.getDate(), dateEnd.getDate(), compteDeb.getText().trim(), compteEnd.getText().trim(),

                                        mode, boxCumulsAnts.isSelected(), !boxCompteSolde.isSelected(), boxCentralClient.isSelected(), boxCentralFourn.isSelected(), comboJrnl.getSelectedId());

                                bar.setValue(1);

                                bSheet.getGeneratedPDFFile(file);

                                bar.setValue(2);

                                SwingUtilities.invokeLater(new Runnable() {

                                    @Override

                                    public void run() {

                                        Gestion.openPDF(file);

                                    }

                                });

                            } catch (Exception exn) {

                                ExceptionHandler.handle("Erreur de génération du grand livre", exn);

                                exn.printStackTrace();

                            } finally {

                                taskEnd();

                            }

                        }

                    }).start();

                }

            }

        });

        this.validODS.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                validPDF.setEnabled(false);

                validODS.setEnabled(false);

                bar.setString(null);

                bar.setValue(0);

                // un fichier a été choisi (sortie par OK)

                // nom du fichier choisi

                new Thread(new Runnable() {

                    public void run() {

                        try {

                            final GrandLivreSheetXML bSheet = new GrandLivreSheetXML(dateDeb.getDate(), dateEnd.getDate(), compteDeb.getText().trim(), compteEnd.getText().trim(), mode,

                                    boxCumulsAnts.isSelected(), !boxCompteSolde.isSelected(), boxCentralClient.isSelected(), boxCentralFourn.isSelected(), comboJrnl.getSelectedId());

                            bar.setValue(1);

                            final File file = bSheet.getOrCreateDocumentFile();

                            bar.setValue(2);

                            SwingUtilities.invokeLater(new Runnable() {

                                @Override

                                public void run() {

                                    try {

                                        FileUtils.openFile(file);

                                    } catch (IOException e) {

                                        ExceptionHandler.handle("Erreur lors de l'ouverture du grand livre.", e);

                                    }

                                }

                            });

                        } catch (Exception exn) {

                            ExceptionHandler.handle("Erreur de génération du grand livre", exn);

                            exn.printStackTrace();

                        } finally {

                            taskEnd();

                        }

                    }

                }).start();

            }

        });

        this.annul.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                ((JFrame) SwingUtilities.getRoot(ImpressionGrandLivrePanel.this)).dispose();

            }

        });

        this.dateDeb.addValueListener(new PropertyChangeListener() {

            public void propertyChange(PropertyChangeEvent evt) {

                checkValidity();

                storeValue();

            }

        });

        this.dateEnd.addValueListener(new PropertyChangeListener() {

            public void propertyChange(PropertyChangeEvent evt) {

                checkValidity();

                storeValue();

            }

        });

        DocumentListener d = new DocumentListener() {

            public void insertUpdate(DocumentEvent e) {

                checkValidity();

            }

            public void removeUpdate(DocumentEvent e) {

                checkValidity();

            }

            public void changedUpdate(DocumentEvent e) {

                checkValidity();

            }

        };

        this.compteDeb.getDocument().addDocumentListener(d);

        // Chargement des valeurs par défaut

        String valueCompteDeb = DefaultNXProps.getInstance().getStringProperty("GrandLivreCompteDeb");

        if (valueCompteDeb.trim().length() > 0) {

            this.compteDeb.setText(valueCompteDeb);

        } else {

            this.compteDeb.setText("1");

        }

        this.compteEnd.getDocument().addDocumentListener(d);

        // Chargement des valeurs par défaut

        String valueCompteEnd = DefaultNXProps.getInstance().getStringProperty("GrandLivreCompteEnd");

        if (valueCompteEnd.trim().length() > 0) {

            this.compteEnd.setText(valueCompteEnd);

        } else {

            this.compteEnd.setText("8");

        }

    }

    private void checkValidity() {

        Date beginDate = this.dateDeb.getDate();

        Date endDate = this.dateEnd.getDate();

        this.validODS.setEnabled(true);

        this.validPDF.setEnabled(true);

        if (beginDate == null || endDate == null) {

            this.validODS.setEnabled(false);

            this.validPDF.setEnabled(false);

        } else {

            if (this.compteDeb.getText().trim().length() == 0 || this.compteEnd.getText().trim().length() == 0) {

                this.validODS.setEnabled(false);

                this.validPDF.setEnabled(false);

            } else {

                if (this.compteDeb.getText().trim().compareToIgnoreCase(this.compteEnd.getText().trim()) > 0) {

                    this.validODS.setEnabled(false);

                    this.validPDF.setEnabled(false);

                } else {

                    if (beginDate.after(endDate)) {

                        this.validODS.setEnabled(false);

                        this.validPDF.setEnabled(false);

                    }

                }

            }

        }

    }

    private void storeValue() {

        // Set date debut

        Date d = this.dateDeb.getDate();

        if (d != null) {

            DefaultNXProps.getInstance().setProperty("GrandLivreDateDeb", String.valueOf(d.getTime()));

        }

        // Set date Fin

        Date dFin = this.dateEnd.getDate();

        if (dFin != null) {

            DefaultNXProps.getInstance().setProperty("GrandLivreDateEnd", String.valueOf(dFin.getTime()));

        }

        DefaultNXProps.getInstance().setProperty("GrandLivreCompteDeb", this.compteDeb.getText());

        DefaultNXProps.getInstance().setProperty("GrandLivreCompteEnd", this.compteEnd.getText());

        DefaultNXProps.getInstance().store();

    }

    public void taskEnd() {

        bar.setValue(3);

        bar.setString("Terminée");

        validPDF.setEnabled(true);

        validODS.setEnabled(true);

    }

}