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);
        wNotRegle = wNotRegle.and(new Where(elementEchT.getTable().getField("ID_SEPA_MANDATE"), "=", (Object) null));

        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;
    }
}