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.model.SelectJournauxModel;

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

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

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

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

import org.openconcerto.erp.generationDoc.SpreadSheetGeneratorCompta;

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.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.TitledSeparator;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.text.SimpleDocumentListener;

import java.awt.Dimension;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

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.io.File;

import java.util.Calendar;

import java.util.Date;

import javax.swing.AbstractAction;

import javax.swing.BorderFactory;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JProgressBar;

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.event.DocumentEvent;

public class ImpressionJournauxPanel extends JPanel implements SpreadSheetGeneratorListener {

    private final JDate dateDeb, dateEnd;

    private JTable tableJrnl;

    private JButton valid;

    private JButton annul;

    private JCheckBox checkCentralMois;

    private JCheckBox checkAncienModele;

    private JTextField compteDeb;

    private JTextField compteEnd;

    private int mode = GrandLivrePDF.MODEALL;

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

    public ImpressionJournauxPanel() {

        this.setLayout(new GridBagLayout());

        final GridBagConstraints c = new DefaultGridBagConstraints();

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

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

        this.dateDeb = new JDate();

        this.dateEnd = new JDate();

        this.tableJrnl = new JTable(new SelectJournauxModel());

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

        c.gridx++;

        c.weightx = 1;

        this.add(this.dateDeb, c);

        // Chargement des valeurs par défaut

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

        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.weightx = 1;

        this.add(this.dateEnd, c);

        // Chargement des valeurs par défaut

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

        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();

        this.compteEnd = new JTextField();

        c.gridy++;

        c.gridx = 0;

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

        c.gridx++;

        c.weightx = 1;

        this.add(this.compteDeb, c);

        this.compteDeb.setText("1");

        this.compteEnd.setText("9");

        c.gridx++;

        c.weightx = 0;

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

        c.gridx++;

        c.weightx = 1;

        this.add(this.compteEnd, c);

        c.gridy++;

        c.gridx = 0;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(new TitledSeparator("Sélection des journaux"), c);

        c.gridy++;

        c.fill = GridBagConstraints.BOTH;

        c.weightx = 0;

        c.weighty = 1;

        JScrollPane scroll = new JScrollPane(this.tableJrnl);

        Dimension d;

        if (this.tableJrnl.getPreferredSize().height > 200) {

            d = new Dimension(scroll.getPreferredSize().width, 200);

        } else {

            d = new Dimension(scroll.getPreferredSize().width, this.tableJrnl.getPreferredSize().height + 30);

        }

        scroll.setPreferredSize(d);

        this.add(scroll, c);

        this.valid = new JButton("Valider");

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

        // Radio mode

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

            public void actionPerformed(ActionEvent e) {

                ImpressionJournauxPanel.this.mode = GrandLivrePDF.MODEALL;

            }

        });

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

            public void actionPerformed(ActionEvent e) {

                ImpressionJournauxPanel.this.mode = GrandLivrePDF.MODELETTREE;

            }

        });

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

            public void actionPerformed(ActionEvent e) {

                ImpressionJournauxPanel.this.mode = GrandLivrePDF.MODENONLETTREE_PERIODE;

            }

        });

        JPanel panelMode = new JPanel();

        panelMode.add(radioAll);

        panelMode.add(radioLettree);

        panelMode.add(radioNonLettree);

        c.gridy++;

        c.gridx = 0;

        c.weightx = 1;

        c.gridwidth = 2;

        c.weighty = 0;

        c.fill = GridBagConstraints.NONE;

        ButtonGroup group = new ButtonGroup();

        group.add(radioAll);

        group.add(radioLettree);

        group.add(radioNonLettree);

        radioAll.setSelected(true);

        panelMode.setBorder(BorderFactory.createTitledBorder("Ecritures"));

        this.add(panelMode, c);

        // Centralisation par mois

        this.checkCentralMois = new JCheckBox("Centralisation par mois");

        c.gridx += 2;

        c.gridwidth = GridBagConstraints.REMAINDER;

        this.add(this.checkCentralMois, c);

        // Ancien modele

        this.checkAncienModele = new JCheckBox("Ancien modèle");

        // Progress bar

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridy++;

        c.gridx = 0;

        c.weightx = 1;

        c.weighty = 0;

        c.fill = GridBagConstraints.HORIZONTAL;

        this.bar.setStringPainted(true);

        this.add(this.bar, c);

        c.gridy++;

        c.gridx = 3;

        c.fill = GridBagConstraints.NONE;

        c.anchor = GridBagConstraints.EAST;

        c.gridwidth = 1;

        final JPanel actionPanel = new JPanel();

        actionPanel.add(this.valid);

        actionPanel.add(this.annul);

        this.add(actionPanel, c);

        checkValidity();

        this.valid.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                bar.setString(null);

                bar.setValue(1);

                valid.setEnabled(false);

                new Thread(new Runnable() {

                    public void run() {

                        int[] idS = ((SelectJournauxModel) tableJrnl.getModel()).getSelectedIds(tableJrnl.getSelectedRows());

                        if (checkAncienModele.isSelected()) {

                            JournauxSheet bSheet;

                            bSheet = new JournauxSheet(idS, dateDeb.getDate(), dateEnd.getDate(), mode, compteDeb.getText().trim(), compteEnd.getText().trim());

                            final SpreadSheetGeneratorCompta generator = new SpreadSheetGeneratorCompta(bSheet, "Journal_" + Calendar.getInstance().getTimeInMillis(), false, true);

                            SwingUtilities.invokeLater(new Runnable() {

                                public void run() {

                                    bar.setValue(2);

                                    generator.addGenerateListener(ImpressionJournauxPanel.this);

                                }

                            });

                        } else if (checkCentralMois.isSelected()) {

                            JournauxSheet bSheet;

                            bSheet = new JournauxMoisSheet(idS, dateDeb.getDate(), dateEnd.getDate(), mode);

                            final SpreadSheetGeneratorCompta generator = new SpreadSheetGeneratorCompta(bSheet, "Journal_" + Calendar.getInstance().getTimeInMillis(), false, true);

                            SwingUtilities.invokeLater(new Runnable() {

                                public void run() {

                                    bar.setValue(2);

                                    generator.addGenerateListener(ImpressionJournauxPanel.this);

                                }

                            });

                        } else {

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

                                final JournauxSheetXML xmlSheet = new JournauxSheetXML(idS[i], dateDeb.getDate(), dateEnd.getDate(), mode, compteDeb.getText().trim(), compteEnd.getText().trim());

                                SwingUtilities.invokeLater(new Runnable() {

                                    public void run() {

                                        bar.setValue(2);

                                    }

                                });

                                try {

                                    xmlSheet.createDocument();

                                    xmlSheet.getOrCreatePDFDocumentFile(false, true);

                                    final File generatedPDFFile = xmlSheet.getGeneratedPDFFile();

                                    if (generatedPDFFile != null)

                                        Gestion.openPDF(generatedPDFFile);

                                } catch (Exception exn) {

                                    ExceptionHandler.handle("Erreur lors de la création du journal !", exn);

                                }

                            }

                            SwingUtilities.invokeLater(new Runnable() {

                                public void run() {

                                    bar.setValue(3);

                                    bar.setString("Terminée");

                                    valid.setEnabled(true);

                                }

                            });

                        }

                    }

                }).start();

            }

        });

        this.annul.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                ((JFrame) SwingUtilities.getRoot(ImpressionJournauxPanel.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();

            }

        });

        this.tableJrnl.addMouseListener(new MouseAdapter() {

            public void mouseReleased(MouseEvent e) {

                checkValidity();

            }

        });

        this.tableJrnl.addKeyListener(new KeyAdapter() {

            public void keyReleased(KeyEvent e) {

                checkValidity();

            }

        });

        SimpleDocumentListener doc = new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                checkValidity();

            }

        };

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

        // Chargement des valeurs par défaut

        this.compteDeb.setText("1");

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

        // Chargement des valeurs par défaut

        this.compteEnd.setText("8");

    }

    private void checkValidity() {

        Date beginDate = this.dateDeb.getDate();

        Date endDate = this.dateEnd.getDate();

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

            this.valid.setEnabled(false);

        } else {

            if (beginDate.after(endDate)) {

                this.valid.setEnabled(false);

            } else {

                if (this.tableJrnl.getSelectedRows().length == 0) {

                    this.valid.setEnabled(false);

                } else {

                    this.valid.setEnabled(true);

                }

            }

        }

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

            this.valid.setEnabled(false);

        } else {

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

                this.valid.setEnabled(false);

            } else {

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

                    this.valid.setEnabled(false);

                }

            }

        }

    }

    private void storeValue() {

        // Set date debut

        Date d = this.dateDeb.getDate();

        if (d != null) {

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

        }

        // Set date Fin

        Date dFin = this.dateEnd.getDate();

        if (dFin != null) {

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

        }

        DefaultNXProps.getInstance().store();

    }

    public void taskEnd() {

        bar.setValue(3);

        bar.setString("Terminée");

        valid.setEnabled(true);

    }

}