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

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.common.ui.DeviseTableCellRenderer;
import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;
import org.openconcerto.erp.core.sales.order.ui.TypeFactureCommandeCellRenderer;
import org.openconcerto.erp.core.sales.order.ui.TypeFactureCommandeClient;
import org.openconcerto.erp.core.sales.order.ui.TypeFactureCommandeClientComboBox;
import org.openconcerto.erp.core.sales.order.ui.TypeFactureCommandeRowItemView;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.element.UISQLComponent;
import org.openconcerto.sql.model.FieldPath;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.graph.Path;
import org.openconcerto.sql.view.EditFrame;
import org.openconcerto.sql.view.EditPanelListener;
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.RowAction;
import org.openconcerto.sql.view.list.SQLTableModelSource;
import org.openconcerto.utils.CollectionUtils;
import org.openconcerto.utils.DecimalUtils;
import org.openconcerto.utils.ExceptionHandler;

import java.awt.event.ActionEvent;
import java.math.BigDecimal;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.swing.AbstractAction;

public class FacturationCommandeClientSQLElement extends ComptaSQLConfElement {

    public static final String TABLENAME = "FACTURATION_COMMANDE_CLIENT";

    public FacturationCommandeClientSQLElement() {
        super(TABLENAME, "un terme de facturation de commande client", "termes de facturation commandes clients");
        {
            RowAction action = new RowAction(new AbstractAction("Facturer") {

                @Override
                public void actionPerformed(ActionEvent e) {
                    final SQLRow sel = IListe.get(e).getSelectedRow().asRow();
                    sel.fetchValues();
                    CommandeClientSQLElement eltCmd = (CommandeClientSQLElement) getForeignElement("ID_COMMANDE_CLIENT");
                    int typeFacture = sel.getInt("TYPE_FACTURE");
                    final SQLRow asRow = sel.getForeign("ID_COMMANDE_CLIENT").asRow();
                    asRow.fetchValues();
                    List<SQLRowValues> l = Arrays.asList(asRow.asRowValues());
                    final EditFrame f;
                    if (typeFacture == TypeFactureCommandeClient.SITUATION.getId()) {
                        f = eltCmd.transfertAcompteClient(l);
                        SQLRowValues rowValues = new SQLRowValues(getForeignElement("ID_SAISIE_VENTE_FACTURE").getTable());
                        rowValues.put("POURCENT_FACTURABLE", sel.getObject("POURCENT"));
                        rowValues.put("MONTANT_FACTURABLE", null);
                        ((BaseSQLComponent) f.getSQLComponent()).getView("MONTANT_FACTURABLE,POURCENT_FACTURABLE").show(rowValues);
                        ;

                    } else if (typeFacture == TypeFactureCommandeClient.SOLDE.getId()) {
                        f = eltCmd.transfertSoldeClient(l);

                    } else {
                        f = eltCmd.transfertFactureClient(l);
                    }

                    SQLRowValues rowValues = new SQLRowValues(eltCmd.getTable().getTable("MODE_REGLEMENT").getTable());
                    rowValues.put("ID_TYPE_REGLEMENT", sel.getForeignID("ID_TYPE_REGLEMENT"));
                    rowValues.put("FIN_MOIS", Boolean.FALSE);
                    if (sel.getBoolean("COMPTANT")) {
                        rowValues.put("AJOURS", 0);
                        rowValues.put("LENJOUR", 0);
                        rowValues.put("DATE_FACTURE", Boolean.TRUE);
                        rowValues.put("COMPTANT", Boolean.TRUE);
                    } else {
                        rowValues.put("AJOURS", sel.getObject("AJOURS"));
                        int lenjour = sel.getInt("LENJOUR");
                        if (sel.getBoolean("FIN_MOIS")) {
                            lenjour = 31;
                        }
                        rowValues.put("LENJOUR", lenjour);
                        rowValues.put("COMPTANT", Boolean.FALSE);
                        rowValues.put("FIN_MOIS", lenjour == 31);
                        rowValues.put("DATE_FACTURE", lenjour == 0);
                    }

                    ((BaseSQLComponent) f.getSQLComponent()).getView("ID_MODE_REGLEMENT").show(rowValues);
                    ;

                    f.addEditPanelListener(new EditPanelListener() {

                        @Override
                        public void modified() {

                        }

                        @Override
                        public void inserted(int id) {
                            try {
                                sel.createEmptyUpdateRow().put("ID_SAISIE_VENTE_FACTURE", id).commit();
                                SQLTable tableFacture = getForeignElement("ID_SAISIE_VENTE_FACTURE").getTable();
                                SQLRowValues rowValsFact = new SQLRowValues(tableFacture);
                                rowValsFact.put(tableFacture.getKey().getName(), id);
                                rowValsFact.put("ID_FACTURATION_COMMANDE_CLIENT", sel.getID());
                                rowValsFact.commit();
                            } catch (SQLException e) {
                                ExceptionHandler.handle("Erreur lors de l'affectation de la facture", e);
                            }
                        }

                        @Override
                        public void deleted() {
                        }

                        @Override
                        public void cancelled() {

                        }
                    });
                }
            }, true) {
                @Override
                public boolean enabledFor(List<SQLRowValues> selection) {

                    if (selection != null && selection.size() == 1) {
                        SQLRowAccessor sel = selection.get(0);
                        return sel.isForeignEmpty("ID_SAISIE_VENTE_FACTURE");
                    }
                    return false;
                }
            };

            getRowActions().add(action);
        }

        {
            RowAction action = new RowAction(new AbstractAction("Voir la facture") {

                @Override
                public void actionPerformed(ActionEvent e) {
                    final SQLRowAccessor sel = IListe.get(e).getSelectedRow();
                    SQLRowAccessor fact = sel.getForeign("ID_SAISIE_VENTE_FACTURE");
                    VenteFactureXmlSheet sheet = new VenteFactureXmlSheet(fact.asRow());
                    try {
                        sheet.showPreviewDocument();
                    } catch (Exception e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }
                }
            }, true) {
                @Override
                public boolean enabledFor(List<SQLRowValues> selection) {

                    if (selection != null && selection.size() == 1) {
                        SQLRowAccessor sel = selection.get(0);
                        return !sel.isForeignEmpty("ID_SAISIE_VENTE_FACTURE");
                    }
                    return false;
                }
            };

            getRowActions().add(action);
        }
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.BaseSQLElement#getComboFields()
     */
    protected List<String> getComboFields() {
        final List<String> l = new ArrayList<>(1);
        l.add("NOM");
        return l;
    }

    @Override
    public Set<String> getReadOnlyFields() {
        Set<String> s = new HashSet<>(1);
        s.add("CHOICE");
        return s;
    }

    @Override
    protected String getParentFFName() {
        return "ID_COMMANDE_CLIENT";
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.BaseSQLElement#getListFields()
     */
    protected List<String> getListFields() {
        final List<String> l = new ArrayList<>(7);
        l.add("NOM");
        l.add("TYPE_FACTURE");
        l.add("ID_TYPE_REGLEMENT");
        l.add("POURCENT");
        l.add("DATE_PREVISIONNELLE");
        l.add("ID_COMMANDE_CLIENT");
        l.add("ID_SAISIE_VENTE_FACTURE");
        return l;
    }

    @Override
    protected void _initTableSource(SQLTableModelSource res) {
        res.init();
        res.getColumn(getTable().getField("POURCENT")).setRenderer(new DeviseTableCellRenderer());
        res.getColumn(getTable().getField("TYPE_FACTURE")).setRenderer(new TypeFactureCommandeCellRenderer());
        final BaseSQLTableModelColumn pourcentFact = new BaseSQLTableModelColumn("Montant à facturer", BigDecimal.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {
                long ht = r.getForeign("ID_COMMANDE_CLIENT").getLong("T_TTC");
                BigDecimal percent = r.getBigDecimal("POURCENT");
                return percent.movePointLeft(2).multiply(new BigDecimal(ht).movePointLeft(2), DecimalUtils.HIGH_PRECISION);
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(getTable());
                Path p2 = p.add(p.getFirst().getField("ID_COMMANDE_CLIENT"));
                return CollectionUtils.createSet(new FieldPath(p, "POURCENT"), new FieldPath(p2, "T_TTC"));
            }
        };
        pourcentFact.setRenderer(new DeviseTableCellRenderer());
        res.getColumns().add(pourcentFact);

        final BaseSQLTableModelColumn montantFact = new BaseSQLTableModelColumn("Montant facturé", BigDecimal.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {
                Collection<? extends SQLRowAccessor> rows = r.getReferentRows(getForeignElement("ID_SAISIE_VENTE_FACTURE").getTable());
                long ht = 0;
                for (SQLRowAccessor sqlRowAccessor : rows) {
                    ht += sqlRowAccessor.getLong("T_TTC");
                }

                return new BigDecimal(ht).movePointLeft(2);
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(getTable());
                Path p2 = p.add(p.getFirst().getField("ID_COMMANDE_CLIENT"));
                Path p3 = new Path(getTable());
                p3 = p3.add(getTable().getForeignTable("ID_SAISIE_VENTE_FACTURE").getField("ID_FACTURATION_COMMANDE_CLIENT"));
                return CollectionUtils.createSet(new FieldPath(p, "POURCENT"), new FieldPath(p2, "T_TTC"), new FieldPath(p3, "T_TTC"), new FieldPath(p2, "T_HT"), new FieldPath(p3, "T_HT"));
            }
        };
        montantFact.setRenderer(new DeviseTableCellRenderer());
        res.getColumns().add(montantFact);
        super._initTableSource(res);
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.SQLElement#getComponent()
     */
    public SQLComponent createComponent() {
        return new UISQLComponent(this) {
            public void addViews() {
                this.addView("NOM");
                this.addView("POURCENT");
                this.addView("ID_TYPE_REGLEMENT");
                this.addView("AJOURS");
                this.addView("COMPTANT");
                this.addView("CHOICE");

                TypeFactureCommandeClientComboBox box = new TypeFactureCommandeClientComboBox();

                this.addView(new TypeFactureCommandeRowItemView(box), "TYPE_FACTURE", REQ);
                this.addView("ID_MODELE");
            }

            @Override
            protected SQLRowValues createDefaults() {
                SQLRowValues rowVals = new SQLRowValues(getTable());
                rowVals.put("CHOICE", Boolean.TRUE);
                return rowVals;
            }
        };
    }

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

}