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.reports.history.ui;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

import org.openconcerto.erp.preferences.DefaultNXProps;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

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

import java.awt.event.WindowAdapter;

import java.awt.event.WindowEvent;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.swing.JFrame;

import javax.swing.event.TableModelEvent;

import javax.swing.event.TableModelListener;

public class HistoriqueClientFrame {

    private PanelFrame panelFrame;

    private ListeHistoriquePanel listPanel;

    public HistoriqueClientFrame() {

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

        SQLBase b = comptaPropsConfiguration.getSQLBaseSociete();

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

        Map<String, List<String>> mapList = new HashMap<String, List<String>>();

        final Boolean bModeVenteComptoir = DefaultNXProps.getInstance().getBooleanValue("ArticleVenteComptoir", true);

        if (bModeVenteComptoir) {

            mapList.put("Ventes comptoir", Arrays.asList("SAISIE_VENTE_COMPTOIR"));

        }

        mapList.put("Ventes facture", Arrays.asList("SAISIE_VENTE_FACTURE"));

        mapList.put("Chèques à encaisser", Arrays.asList("CHEQUE_A_ENCAISSER"));

        mapList.put("Echéances", Arrays.asList("ECHEANCE_CLIENT"));

        mapList.put("Relances", Arrays.asList("RELANCE"));

        mapList.put("Devis", Arrays.asList("DEVIS"));

        mapList.put("Commandes", Arrays.asList("COMMANDE_CLIENT"));

        mapList.put("Avoirs", Arrays.asList("AVOIR_CLIENT"));

                mapList.put("Articles facturés", Arrays.asList("SAISIE_VENTE_FACTURE_ELEMENT"));

                mapList.put("Articles proposés", Arrays.asList("DEVIS_ELEMENT"));

                mapList.put("Encaissements", Arrays.asList("ENCAISSER_MONTANT"));

        Map<SQLTable, SQLField> map = new HashMap<SQLTable, SQLField>();

        map.put(b.getTable("SAISIE_VENTE_FACTURE_ELEMENT"), b.getTable("SAISIE_VENTE_FACTURE_ELEMENT").getField("ID_SAISIE_VENTE_FACTURE"));

        map.put(b.getTable("DEVIS_ELEMENT"), b.getTable("DEVIS_ELEMENT").getField("ID_DEVIS"));

        final HistoriqueClientBilanPanel bilanPanel = new HistoriqueClientBilanPanel();

        SQLTable tableEch = Configuration.getInstance().getRoot().findTable("ECHEANCE_CLIENT");

        Where wNotRegle = new Where(tableEch.getField("REGLE"), "=", Boolean.FALSE);

        wNotRegle = wNotRegle.and(new Where(tableEch.getField("REG_COMPTA"), "=", Boolean.FALSE));

        this.listPanel = new ListeHistoriquePanel("Clients", JListSQLTablePanel.createComboRequest(Configuration.getInstance().getDirectory().getElement(b.getTable("CLIENT")), false), mapList,

                bilanPanel, map, null, wNotRegle);

        this.listPanel.addListenerTable(new TableModelListener() {

            public void tableChanged(TableModelEvent arg0) {

                bilanPanel.updateRelance(HistoriqueClientFrame.this.listPanel.getListId("RELANCE"));

            }

        }, "RELANCE");

        this.listPanel.addListenerTable(new TableModelListener() {

            public void tableChanged(TableModelEvent arg0) {

                bilanPanel.updateEcheance(HistoriqueClientFrame.this.listPanel.getListId("ECHEANCE_CLIENT"));

            }

        }, "ECHEANCE_CLIENT");

        this.listPanel.addListenerTable(new TableModelListener() {

            public void tableChanged(TableModelEvent arg0) {

                bilanPanel.updateChequeData(HistoriqueClientFrame.this.listPanel.getListId("CHEQUE_A_ENCAISSER"));

            }

        }, "CHEQUE_A_ENCAISSER");

        this.listPanel.addListenerTable(new TableModelListener() {

            public void tableChanged(TableModelEvent arg0) {

                bilanPanel.updateVCData(HistoriqueClientFrame.this.listPanel.getListId("SAISIE_VENTE_COMPTOIR"));

            }

        }, "SAISIE_VENTE_COMPTOIR");

        this.listPanel.addListenerTable(new TableModelListener() {

            public void tableChanged(TableModelEvent arg0) {

                SQLRowAccessor rowSel = HistoriqueClientFrame.this.listPanel.getSelectedRow();

                int id = (rowSel == null) ? -1 : rowSel.getID();

                bilanPanel.updateVFData(HistoriqueClientFrame.this.listPanel.getListId("SAISIE_VENTE_FACTURE"), id);

            }

        }, "SAISIE_VENTE_FACTURE");

        this.listPanel.addListenerTable(new TableModelListener() {

            public void tableChanged(TableModelEvent arg0) {

                SQLRowAccessor rowSel = HistoriqueClientFrame.this.listPanel.getSelectedRow();

                int id = (rowSel == null) ? -1 : rowSel.getID();

                bilanPanel.updateVFArticleData(HistoriqueClientFrame.this.listPanel.getListId("SAISIE_VENTE_FACTURE_ELEMENT"), id);

            }

        }, "SAISIE_VENTE_FACTURE_ELEMENT");

        this.panelFrame = new PanelFrame(this.listPanel, "Historique client");

        this.panelFrame.addWindowListener(new WindowAdapter() {

            public void windowClosing(WindowEvent e) {

                listPanel.removeAllTableListener();

            };

        });

        this.panelFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

        // // Daet filter

        // Map<IListe, SQLField> listeFilter = new HashMap<IListe, SQLField>();

        // IListe listeRel = this.listPanel.getIListeFromTableName("RELANCE");

        // listeFilter.put(listeRel, listeRel.getModel().getTable().getField("DATE"));

        // IListe listeVtC = this.listPanel.getIListeFromTableName("SAISIE_VENTE_COMPTOIR");

        // listeFilter.put(listeVtC, listeVtC.getModel().getTable().getField("DATE"));

        // IListe listeDevis = this.listPanel.getIListeFromTableName("DEVIS");

        // listeFilter.put(listeDevis, listeDevis.getModel().getTable().getField("DATE"));

        //

        // IListe listeChq = this.listPanel.getIListeFromTableName("CHEQUE_A_ENCAISSER");

        // listeFilter.put(listeChq, listeChq.getModel().getTable().getField("DATE"));

        //

        // IListe listeEch = this.listPanel.getIListeFromTableName("ECHEANCE_CLIENT");

        // listeFilter.put(listeEch, listeEch.getModel().getTable().getField("DATE"));

        // IListe listedevisElt = this.listPanel.getIListeFromTableName("DEVIS_ELEMENT");

        // listeFilter.put(listedevisElt,

        // listedevisElt.getModel().getTable().getForeignTable("ID_DEVIS").getField("DATE"));

        //

        // IListe listeAvoir = this.listPanel.getIListeFromTableName("AVOIR_CLIENT");

        // listeFilter.put(listeAvoir, listeAvoir.getModel().getTable().getField("DATE"));

        //

        // IListe listefactElt =

        // this.listPanel.getIListeFromTableName("SAISIE_VENTE_FACTURE_ELEMENT");

        // listeFilter.put(listefactElt,

        // listefactElt.getModel().getTable().getForeignTable("ID_SAISIE_VENTE_FACTURE").getField("DATE"));

        //

        // IListe listeFact = this.listPanel.getIListeFromTableName("SAISIE_VENTE_FACTURE");

        // listeFilter.put(listeFact, listeFact.getModel().getTable().getField("DATE"));

        //

        // final IListFilterDatePanel panel = new IListFilterDatePanel(listeFilter,

        // IListFilterDatePanel.getDefaultMap());

        // GridBagConstraints c = new DefaultGridBagConstraints();

        // c.gridy = 4;

        // c.gridwidth = GridBagConstraints.REMAINDER;

        // c.weightx = 1;

        // c.gridx=0;

        // this.listPanel.add(panel);

    }

    public PanelFrame getFrame() {

        return this.panelFrame;

    }

    public void selectId(int id) {

        this.listPanel.selectIDinJList(id);

    }

    public void setVisible(boolean b) {

        this.panelFrame.setVisible(b);

    }

}