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.sales.invoice.ui;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

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

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

import org.openconcerto.erp.core.finance.accounting.ui.ListeGestCommEltPanel;

import org.openconcerto.erp.core.finance.payment.element.SDDMessageSQLElement;

import org.openconcerto.erp.core.finance.payment.element.SDDMessageSQLElement.GenerationResult;

import org.openconcerto.erp.core.finance.payment.element.SDDMessageSQLElement.IgnoreReason;

import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureSQLElement;

import org.openconcerto.erp.core.sales.pos.POSConfiguration;

import org.openconcerto.erp.core.sales.pos.ui.TextAreaTicketPanel;

import org.openconcerto.erp.utils.TM;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.FieldPath;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.Where;

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

import org.openconcerto.sql.request.UpdateBuilder;

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

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

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

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

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

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

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

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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JLabelBold;

import org.openconcerto.ui.PanelFrame;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.TableSorter;

import org.openconcerto.utils.cc.IClosure;

import org.openconcerto.utils.i18n.Grammar_fr;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.event.ActionEvent;

import java.math.BigInteger;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Collections;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.swing.AbstractAction;

import javax.swing.JButton;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTabbedPane;

import javax.swing.JTable;

import javax.swing.SwingWorker;

import javax.swing.table.TableColumn;

public class ListeDesVentesPanel extends JPanel {

    private ListeGestCommEltPanel listeFact;

    // private JButton buttonEnvoye, buttonRegle, buttonDupliquer;

    private JLabelBold textField = new JLabelBold("0");

    private JLabelBold textField2 = new JLabelBold("0");

    public ListeDesVentesPanel() {

        this.setLayout(new GridBagLayout());

        GridBagConstraints c = new GridBagConstraints();

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

        c.fill = GridBagConstraints.BOTH;

        c.anchor = GridBagConstraints.NORTHWEST;

        c.gridx = 0;

        c.gridy = 0;

        c.gridwidth = 1;

        c.gridheight = 1;

        c.weightx = 1;

        c.weighty = 1;

        JTabbedPane tabbedPane = new JTabbedPane();

        final SQLElement elementVF = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE");

        // tab Vente facture

        final SQLElement eltFacture = elementVF;

        final SQLTableModelSourceOnline src = eltFacture.getTableSource(true);

        // Filter

        Where wPrev = new Where(eltFacture.getTable().getField("PREVISIONNELLE"), "=", Boolean.FALSE);

        if (src.getReq().getWhere() != null) {

            wPrev = wPrev.and(src.getReq().getWhere());

        }

        src.getReq().setWhere(wPrev);

        final ListeFactureRenderer rend = new ListeFactureRenderer();

        for (SQLTableModelColumn column : src.getColumns()) {

            if (column.getClass().isAssignableFrom(SQLTableModelColumnPath.class)) {

                ((SQLTableModelColumnPath) column).setEditable(false);

            }

            // FIXME Voir pour appliquer le renderer correctement

            if (!column.getName().startsWith("Avancement")) {

                column.setRenderer(rend);

            }

        }

        final SQLTableModelColumn dateEnvoiCol = src.getColumn(eltFacture.getTable().getField("DATE_ENVOI"));

            ((SQLTableModelColumnPath) dateEnvoiCol).setEditable(true);

        final SQLTableModelColumn dateReglCol = src.getColumn(eltFacture.getTable().getField("DATE_REGLEMENT"));

        if (dateReglCol != null)

            ((SQLTableModelColumnPath) dateReglCol).setEditable(true);

            // Edition des dates d'envois

            dateEnvoiCol.setColumnInstaller(new IClosure<TableColumn>() {

                @Override

                public void executeChecked(TableColumn columnDateEnvoi) {

                    final org.openconcerto.ui.table.TimestampTableCellEditor cellEditor = new org.openconcerto.ui.table.TimestampTableCellEditor();

                    cellEditor.setAllowNull(true);

                    columnDateEnvoi.setCellEditor(cellEditor);

                    columnDateEnvoi.setCellRenderer(new DateEnvoiRenderer());

                }

            });

        // Edition des dates de reglement

        if (dateReglCol != null) {

            dateReglCol.setColumnInstaller(new IClosure<TableColumn>() {

                @Override

                public void executeChecked(TableColumn columnDateReglement) {

                    final org.openconcerto.ui.table.TimestampTableCellEditor cellEditor = new org.openconcerto.ui.table.TimestampTableCellEditor();

                    cellEditor.setAllowNull(true);

                    columnDateReglement.setCellEditor(cellEditor);

                    columnDateReglement.setCellRenderer(new DateEnvoiRenderer());

                }

            });

        }

        src.getColumns().add(new SQLTableModelColumnPath(new FieldPath(new Path(eltFacture.getTable()).addForeignField(SaisieVenteFactureSQLElement.MESSAGE_FIELD_NAME), "MessageIdentification")));

        this.listeFact = new ListeGestCommEltPanel(eltFacture, new IListe(src), true);

        final SDDMessageSQLElement sepaMsgElem = eltFacture.getDirectory().getElement(SDDMessageSQLElement.class);

        final String aMessageLabel = sepaMsgElem.getName().getVariant(Grammar_fr.INDEFINITE_ARTICLE_SINGULAR);

        this.listeFact.getListe().addIListeAction(new RowAction.PredicateRowAction(new AbstractAction("Générer " + aMessageLabel, null) {

            @Override

            public void actionPerformed(ActionEvent e) {

                final IListe l = IListe.get(e);

                final List<Integer> selectedIDs = l.getSelection().getSelectedIDs();

                // TODO dialog with label informing of the successful creation of message for n

                // invoices/n2 messages too far in the future/n3 messages with collection date

                // changed and having a button to open the file chooser

                new SwingWorker<GenerationResult, Void>() {

                    @Override

                    protected GenerationResult doInBackground() throws Exception {

                        return sepaMsgElem.generateXML(selectedIDs);

                    }

                    @Override

                    protected void done() {

                        final GenerationResult genRes;

                        try {

                            genRes = this.get();

                        } catch (Exception e) {

                            ExceptionHandler.handle(l, "Impossible de générer " + aMessageLabel, e);

                            return;

                        }

                        final int includedInvoicesCount = genRes.getIncludedInvoicesCount();

                        final Map<String, Object> tmMap = new HashMap<>();

                        tmMap.put("msgElem", sepaMsgElem.getName());

                        tmMap.put("invoiceElem", elementVF.getName());

                        tmMap.put("invoiceElemCount", includedInvoicesCount);

                        if (genRes.getDDInvoicesWithoutMessage().isEmpty()) {

                            JOptionPane.showMessageDialog(l, TM.getTM().trM("sddMessage.generation.noneNeeded", tmMap));

                        } else if (genRes.getIgnoredInvoices().isEmpty()) {

                            JOptionPane.showMessageDialog(l, TM.getTM().trM("sddMessage.generation.noneIgnored", tmMap));

                        } else {

                            final int futureCount = genRes.getIgnoredInvoices().getNonNull(IgnoreReason.TOO_FAR_IN_FUTURE).size();

                            final int duplicateCount = genRes.getIgnoredInvoices().getNonNull(IgnoreReason.DUPLICATE_MANDATE).size();

                            final int missingInfoCount = genRes.getIgnoredInvoices().getNonNull(IgnoreReason.MISSING_INFO).size();

                            tmMap.put("futureCount", futureCount);

                            tmMap.put("duplicateCount", duplicateCount);

                            tmMap.put("missingInfoCount", missingInfoCount);

                            final StringBuilder msg = new StringBuilder(256);

                            msg.append(TM.getTM().trM("sddMessage.generation.someIgnored", tmMap));

                            if (futureCount > 0) {

                                msg.append("\n- ");

                                msg.append(TM.getTM().trM("sddMessage.generation.someIgnored.future", tmMap));

                            }

                            if (duplicateCount > 0) {

                                msg.append("\n- ");

                                msg.append(TM.getTM().trM("sddMessage.generation.someIgnored.duplicateMandate", tmMap));

                            }

                            if (missingInfoCount > 0) {

                                msg.append("\n- ");

                                msg.append(TM.getTM().trM("sddMessage.generation.someIgnored.missingInfo", tmMap));

                            }

                            final int messageType = duplicateCount == 0 ? JOptionPane.WARNING_MESSAGE : JOptionPane.ERROR_MESSAGE;

                            JOptionPane.showMessageDialog(l, msg.toString(), null, messageType);

                        }

                        if (genRes.getInsertedMessage() != null) {

                            sepaMsgElem.exportXML(l, Collections.singletonList(genRes.getInsertedMessage()));

                        }

                    }

                }.execute();

            }

        }, false, true).setPredicate(IListeEvent.getNonEmptySelectionPredicate()));

        // TODO remove once we have a join with {SENT, OK, DEFINITIVE_ERROR, TRANSIENT_ERROR}

        this.listeFact.getListe().addIListeAction(new RowAction.PredicateRowAction(new AbstractAction("Prélever à nouveau", null) {

            @Override

            public void actionPerformed(ActionEvent e) {

                final IListe l = IListe.get(e);

                if (JOptionPane.showConfirmDialog(l, "Voulez-vous vraiment prélever à nouveau les factures sélectionnées ? Cette action est définitive.", "Prélever à nouveau",

                        JOptionPane.OK_CANCEL_OPTION, JOptionPane.WARNING_MESSAGE) != JOptionPane.OK_OPTION)

                    return;

                final List<Integer> selectedIDs = l.getSelection().getSelectedIDs();

                final UpdateBuilder upd = new UpdateBuilder(l.getSource().getPrimaryTable());

                upd.setObject(SaisieVenteFactureSQLElement.MESSAGE_FIELD_NAME, upd.getTable().getForeignTable(SaisieVenteFactureSQLElement.MESSAGE_FIELD_NAME).getUndefinedIDNumber());

                upd.setObject(SaisieVenteFactureSQLElement.END2END_FIELD_NAME, "");

                // don't allow to debit already payed invoices

                upd.setWhere(new Where(upd.getTable().getKey(), selectedIDs).and(Where.isNull(upd.getTable().getField("DATE_REGLEMENT"))));

                upd.getTable().getDBSystemRoot().getDataSource().execute(upd.asString());

                for (final Integer id : selectedIDs)

                    upd.getTable().fireTableModified(id, upd.getFieldsNames());

            }

        }, false, true).setPredicate(IListeEvent.getNonEmptySelectionPredicate()));

        this.listeFact.setOpaque(false);

        this.listeFact.getListe().setModificationAllowed(true);

        final JTable tableFact = this.listeFact.getListe().getJTable();

        final SQLTableModelColumn numeroCol = src.getColumn(eltFacture.getTable().getField("NUMERO"));

        ((TableSorter) tableFact.getModel()).setSortingStatus(src.getColumns().indexOf(numeroCol), TableSorter.ASCENDING);

        JPanel panelFacture = new JPanel(new GridBagLayout());

        GridBagConstraints cFacture = new DefaultGridBagConstraints();

        cFacture.gridy++;

        cFacture.gridx = 0;

        cFacture.weighty = 1;

        cFacture.weightx = 1;

        cFacture.gridwidth = GridBagConstraints.REMAINDER;

        cFacture.fill = GridBagConstraints.BOTH;

        panelFacture.add(this.listeFact, cFacture);

        List<SQLField> l = new ArrayList<SQLField>();

        if (this.listeFact.getListe().getSource().getColumn(eltFacture.getTable().getField("T_HA")) != null) {

            l.add(eltFacture.getTable().getField("T_HA"));

        }

        l.add(eltFacture.getTable().getField("T_HT"));

        l.add(eltFacture.getTable().getField("T_TTC"));

        final IListTotalPanel total = new IListTotalPanel(this.listeFact.getListe(), l);

        cFacture.weighty = 0;

        cFacture.fill = GridBagConstraints.NONE;

        cFacture.gridy++;

        cFacture.anchor = GridBagConstraints.EAST;

        total.setOpaque(false);

        panelFacture.add(total, cFacture);

        IListFilterDatePanel filterDate = new IListFilterDatePanel(this.listeFact.getListe(), eltFacture.getTable().getField("DATE"), IListFilterDatePanel.getDefaultMap());

        cFacture.weighty = 0;

        cFacture.fill = GridBagConstraints.HORIZONTAL;

        cFacture.gridy++;

        filterDate.setOpaque(false);

        panelFacture.add(filterDate, cFacture);

        tabbedPane.add("Ventes avec facture", panelFacture);

        PredicateRowAction actionRegle = new PredicateRowAction(new AbstractAction("Facture réglée") {

            @Override

            public void actionPerformed(ActionEvent e) {

                final List<SQLRowValues> selectedRows = IListe.get(e).getSelectedRows();

                for (SQLRowAccessor sqlRowAccessor : selectedRows) {

                    final SQLRowValues rowVals = sqlRowAccessor.asRow().createEmptyUpdateRow();

                    rowVals.put("DATE_REGLEMENT", new Date());

                    try {

                        rowVals.update();

                    } catch (SQLException e1) {

                        ExceptionHandler.handle("Modification impossible", e1);

                    }

                }

            }

        }, true);

        actionRegle.setPredicate(IListeEvent.getNonEmptySelectionPredicate());

        this.listeFact.getListe().addIListeAction(actionRegle);

        PredicateRowAction actionEnvoye = new PredicateRowAction(new AbstractAction("Facture envoyée") {

            @Override

            public void actionPerformed(ActionEvent e) {

                final List<SQLRowValues> selectedRows = IListe.get(e).getSelectedRows();

                for (SQLRowAccessor sqlRowAccessor : selectedRows) {

                    final SQLRowValues rowVals = sqlRowAccessor.asRow().createEmptyUpdateRow();

                    rowVals.put("DATE_ENVOI", new Date());

                    try {

                        rowVals.update();

                    } catch (SQLException e1) {

                        ExceptionHandler.handle("Modification impossible", e1);

                    }

                }

            }

        }, true);

        actionEnvoye.setPredicate(IListeEvent.getNonEmptySelectionPredicate());

        this.listeFact.getListe().addIListeAction(actionEnvoye);

            {

                // Tab Vente caisse

                ListeViewPanel panelTicket = new ListeViewPanel(Configuration.getInstance().getDirectory().getElement("TICKET_CAISSE")) {

                    @Override

                    protected void handleAction(JButton source, ActionEvent evt) {

                        if (source == this.buttonModifier) {

                            POSConfiguration posConf = POSConfiguration.getInstance();

                            try {

                                if (posConf == null)

                                    posConf = POSConfiguration.setInstance();

                            } catch (Exception e) {

                                ExceptionHandler.handle(source, "Impossible d'initialiser la configuration de la caisse", e);

                                return;

                            }

                            new PanelFrame(new TextAreaTicketPanel(posConf, this.getListe().fetchSelectedRow()), "Ticket").setVisible(true);

                        } else {

                            super.handleAction(source, evt);

                        }

                    }

                };

                JPanel panel = new JPanel(new GridBagLayout());

                GridBagConstraints cc = new DefaultGridBagConstraints();

                cc.weightx = 1;

                cc.weighty = 1;

                cc.fill = GridBagConstraints.BOTH;

                panel.add(panelTicket, cc);

                final List<SQLField> l2 = new ArrayList<SQLField>();

                l2.add(panelTicket.getElement().getTable().getField("TOTAL_HT"));

                l2.add(panelTicket.getElement().getTable().getField("TOTAL_TTC"));

                final IListTotalPanel total2 = new IListTotalPanel(panelTicket.getListe(), l2);

                cc.weighty = 0;

                cc.fill = GridBagConstraints.NONE;

                cc.gridy++;

                cc.anchor = GridBagConstraints.EAST;

                total2.setOpaque(false);

                panel.add(total2, cc);

                IListFilterDatePanel filterDate2 = new IListFilterDatePanel(panelTicket.getListe(), panelTicket.getElement().getTable().getField("DATE"), IListFilterDatePanel.getDefaultMap());

                cc.weighty = 0;

                cc.fill = GridBagConstraints.HORIZONTAL;

                cc.gridy++;

                filterDate2.setOpaque(false);

                panel.add(filterDate2, cc);

                tabbedPane.add("Ventes caisse", panel);

            }

            // Tab Vente comptoir

            {

                final ListeGestCommEltPanel listeVC = new ListeGestCommEltPanel(Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_COMPTOIR"), true);

                listeVC.getListe().setModificationAllowed(false);

                listeVC.setOpaque(false);

                final JTable table = listeVC.getListe().getJTable();

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

                    if (table.getColumnClass(i) == Long.class || table.getColumnClass(i) == BigInteger.class) {

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

                    }

                }

                JPanel panelComptoir = new JPanel(new GridBagLayout());

                GridBagConstraints cc = new DefaultGridBagConstraints();

                cc.weightx = 1;

                cc.weighty = 1;

                cc.fill = GridBagConstraints.BOTH;

                panelComptoir.add(listeVC, cc);

                final List<SQLField> l2 = new ArrayList<SQLField>();

                l2.add(listeVC.getElement().getTable().getField("MONTANT_HT"));

                l2.add(listeVC.getElement().getTable().getField("MONTANT_TTC"));

                final IListTotalPanel total2 = new IListTotalPanel(listeVC.getListe(), l2);

                cc.weighty = 0;

                cc.fill = GridBagConstraints.NONE;

                cc.gridy++;

                cc.anchor = GridBagConstraints.EAST;

                total2.setOpaque(false);

                panelComptoir.add(total2, cc);

                IListFilterDatePanel filterDate2 = new IListFilterDatePanel(listeVC.getListe(), listeVC.getElement().getTable().getField("DATE"), IListFilterDatePanel.getDefaultMap());

                cc.weighty = 0;

                cc.fill = GridBagConstraints.HORIZONTAL;

                cc.gridy++;

                filterDate2.setOpaque(false);

                panelComptoir.add(filterDate2, cc);

                tabbedPane.add("Ventes comptoir", panelComptoir);

            }

        this.add(tabbedPane, c);

    }

}