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.product.element;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.sales.invoice.ui.FactureAffacturerTable;
import org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.view.EditFrame;
import org.openconcerto.sql.view.EditPanel.EditMode;
import org.openconcerto.sql.view.EditPanelListener;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
import org.openconcerto.ui.DefaultGridBagConstraints;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.swing.AbstractAction;
import javax.swing.JLabel;

public class ReliquatSQLElement extends ComptaSQLConfElement {

    private final String tableBonName;

    static public class ReliquatBRSQLElement extends ReliquatSQLElement {
        public ReliquatBRSQLElement() {
            super("RELIQUAT_BR", "un reliquat de BR", "reliquats de BR", "BON_RECEPTION");
        }

        @Override
        protected String createCode() {
            return createCodeOfPackage() + ".reliquatbr";
        }
    }

    public ReliquatSQLElement(final String tableName, final String singularName, final String pluralName, final String tableBonName) {
        super(tableName, singularName, pluralName);
        this.tableBonName = tableBonName;

        PredicateRowAction actionTR = new PredicateRowAction(new AbstractAction("Transfert vers Bon") {

            @Override
            public void actionPerformed(ActionEvent e) {
                final List<SQLRowValues> rows = IListe.get(e).getSelectedRows();
                EditFrame frame = new EditFrame(getForeignElement("ID_" + tableBonName), EditMode.CREATION);
                frame.addEditPanelListener(new EditPanelListener() {

                    @Override
                    public void modified() {
                    }

                    @Override
                    public void inserted(int id) {
                        for (SQLRowValues rowVals : rows) {
                            try {
                                SQLRowValues upRowVals = rowVals.createEmptyUpdateRow();
                                upRowVals.put("ID_" + tableBonName, id);
                                upRowVals.update();
                            } catch (SQLException exn) {
                                exn.printStackTrace();
                            }
                        }

                    }

                    @Override
                    public void deleted() {
                    }

                    @Override
                    public void cancelled() {
                    }
                });

                SQLComponent comp = (SQLComponent) frame.getSQLComponent();
                if (comp instanceof BonReceptionSQLComponent) {
                    ((BonReceptionSQLComponent) comp).loadFromReliquat(rows);
                } else {
                    // ((BonDeLivraisonSQLComponent) comp).loadFromReliquat(rows);

                }
                frame.setVisible(true);

            }
        }, true);
        actionTR.setPredicate(IListeEvent.getNonEmptySelectionPredicate());
        getRowActions().add(actionTR);
    }

    public ReliquatSQLElement() {
        this("RELIQUAT_BL", "un reliquat de BL", "reliquats de BL", "BON_DE_LIVRAISON");
    }

    @Override
    protected String getParentFFName() {
        return "ID_" + this.tableBonName;
    }

    protected List<String> getListFields() {
        final List<String> l = new ArrayList<String>();
        // l.add("DATE");
        l.add("ID_" + this.tableBonName + "_ORIGINE");
        l.add("ID_ARTICLE");
        l.add("QTE_UNITAIRE");
        l.add("ID_UNITE_VENTE");
        l.add("QTE");
        l.add("ID_" + this.tableBonName);
        return l;
    }

    protected List<String> getComboFields() {
        final List<String> l = new ArrayList<String>();
        l.add("DATE");
        l.add("QTE");
        return l;
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.SQLElement#getComponent()
     */
    public SQLComponent createComponent() {
        return new BaseSQLComponent(this) {
            FactureAffacturerTable table = new FactureAffacturerTable(null);

            public void addViews() {

                // FIXME CREATION DE L'UI
                this.setLayout(new GridBagLayout());

                GridBagConstraints c = new DefaultGridBagConstraints();

                this.add(new JLabel(getLabelFor("NB_FACT")), c);
                // c.gridx++;
                // c.weightx = 1;
                // JTextField fieldNbFact = new JTextField();
                // this.add(fieldNbFact, c);
                //
                // c.gridx++;
                // c.weightx = 0;
                // this.add(new JLabel(getLabelFor("MONTANT_FACT")), c);
                // c.gridx++;
                // c.weightx = 1;
                // DeviseField fieldMontantFact = new DeviseField();
                // this.add(fieldMontantFact, c);
                //
                // c.gridx++;
                // c.weightx = 0;
                // this.add(new JLabel(getLabelFor("DATE")), c);
                // c.gridx++;
                //
                // JDate date = new JDate();
                // this.add(date, c);
                //
                // c.gridwidth = GridBagConstraints.REMAINDER;
                // c.gridx = 0;
                // c.gridy++;
                // this.add(this.table, c);
                //
                // this.addView(fieldNbFact, "NB_FACT");
                // this.addSQLObject(fieldMontantFact, "MONTANT_FACT");
                // this.addView(date, "DATE");
            }

        };
    }

    @Override
    protected String createCode() {
        return createCodeOfPackage() + ".reliquatbl";
    }
}