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.core.finance.accounting.element.EcritureSQLElement;

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

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.view.EditFrame;

import org.openconcerto.sql.view.ListeAddPanel;

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

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

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

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

import java.awt.event.ActionEvent;

import java.util.Calendar;

import java.util.Date;

import javax.swing.JButton;

import javax.swing.JTable;

import javax.swing.table.TableColumn;

public class ListPanelEcheancesClients extends ListeAddPanel {

    // TODO Ajouter une légende dans liste echeance panel pour les couleurs du renderer

    private EditFrame editFrame;

    private boolean showRegCompta = false;

    private boolean onlyOld = false;

    public ListPanelEcheancesClients() {

        this(false);

    }

    public ListPanelEcheancesClients(boolean onlyOld) {

        this(Configuration.getInstance().getDirectory().getElement("ECHEANCE_CLIENT"), onlyOld);

    }

    private ListPanelEcheancesClients(final SQLElement elem, boolean onlyOld) {

        super(elem, new IListe(elem.getTableSource(true)));

        this.onlyOld = onlyOld;

        setListe();

    }

    public JTable getJTable() {

        return this.getListe().getJTable();

    }

    public void setShowRegCompta(boolean b) {

        this.showRegCompta = b;

        setListe();

    }

    protected void handleAction(JButton source, ActionEvent e) {

        if (source == this.buttonModifier) {

            if (this.editFrame == null) {

                this.editFrame = new EditFrame(this.element, EditFrame.MODIFICATION);

            }

            this.editFrame.selectionId(this.getListe().getSelectedId());

            this.editFrame.pack();

            this.editFrame.setVisible(true);

            SQLRow ecritureRow = Configuration.getInstance().getDirectory().getElement(EcritureSQLElement.class).getTable().getRow(this.getListe().getSelectedId());

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

        } else {

            super.handleAction(source, e);

        }

    }

    private void setListe() {

        // FIXME : remove queries from AWT

        final SQLTable elementEchT = getListe().getSource().getPrimaryTable();

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

        if (!showRegCompta) {

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

        }

        if (onlyOld) {

            Calendar c = Calendar.getInstance();

            c.add(Calendar.DAY_OF_MONTH, -7);

            Date date = c.getTime();

            wNotRegle = wNotRegle.and(new Where(elementEchT.getField("DATE"), "<", date));

        }

        getListe().getRequest().setWhere(wNotRegle);

        final ListEcheanceClientRenderer rend = new ListEcheanceClientRenderer(false);

        final ListEcheanceClientRenderer rendDate = new ListEcheanceClientRenderer(true);

        //

        SQLTableModelColumn colDate = ListPanelEcheancesClients.this.getListe().getSource().getColumn(elementEchT.getField("DATE"));

        int indexColDate = ListPanelEcheancesClients.this.getListe().getSource().getColumns().indexOf(colDate);

        for (int i = 0; i < ListPanelEcheancesClients.this.getListe().getJTable().getColumnCount(); i++) {

            if (ListPanelEcheancesClients.this.getListe().getJTable().getColumnClass(i) != Boolean.class) {

                TableColumn col = ListPanelEcheancesClients.this.getListe().getJTable().getColumnModel().getColumn(i);

                if (col.getModelIndex() == indexColDate) {

                    col.setCellRenderer(rendDate);

                } else {

                    col.setCellRenderer(rend);

                }

            }

        }

        getListe().getSource().getColumn(elementEchT.getField("DATE")).setRenderer(rendDate);

        ListPanelEcheancesClients.this.buttonAjouter.setVisible(false);

        ListPanelEcheancesClients.this.buttonEffacer.setVisible(false);

        ListPanelEcheancesClients.this.buttonModifier.setVisible(false);

        final SQLTableModelSource src = ListPanelEcheancesClients.this.getListe().getSource();

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

        SQLField fieldDateEch = elementEchT.getField("DATE");

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

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

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

            }

            if (column.getFields().contains(fieldDateEch)) {

                column.setRenderer(rendDate);

            } else {

                column.setRenderer(rend);

            }

        }

        ((SQLTableModelColumnPath) src.getColumns(getElement().getTable().getField("INFOS")).iterator().next()).setEditable(true);

    }

    @Override

    public SQLComponent getModifComp() {

        return null;

    }

}