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.finance.payment.element;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.model.FieldPath;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.graph.Path;

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

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

import org.openconcerto.utils.CollectionUtils;

import java.util.ArrayList;

import java.util.Collection;

import java.util.List;

import java.util.Set;

public class ReglerMontantSQLElement extends ComptaSQLConfElement {

    public ReglerMontantSQLElement() {

        super("REGLER_MONTANT", "un règlement à un fournisseur", "règlements aux fournisseurs");

    }

    protected List<String> getListFields() {

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

        l.add("DATE");

        l.add("ID_FOURNISSEUR");

        l.add("ID_MODE_REGLEMENT");

        l.add("MONTANT");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("DATE");

        l.add("MONTANT");

        return l;

    }

    @Override

    protected void _initTableSource(SQLTableModelSource res) {

        super._initTableSource(res);

        final BaseSQLTableModelColumn racColFact = new BaseSQLTableModelColumn("Factures associées", String.class) {

            @Override

            protected Object show_(SQLRowAccessor r) {

                Collection<? extends SQLRowAccessor> l = r.getReferentRows(r.getTable().getTable("REGLER_MONTANT_ELEMENT"));

                String s = "";

                for (SQLRowAccessor sqlRowAccessor : l) {

                    if (!sqlRowAccessor.isForeignEmpty("ID_MOUVEMENT_ECHEANCE")) {

                        SQLRowAccessor rMvt = sqlRowAccessor.getForeign("ID_MOUVEMENT_ECHEANCE");

                        if (!rMvt.isForeignEmpty("ID_PIECE")) {

                            SQLRowAccessor rP = rMvt.getForeign("ID_PIECE");

                            s += (s.trim().length() > 0 ? ", " : "") + rP.getString("NOM");

                        }

                    }

                }

                return s;

            }

            @Override

            public Set<FieldPath> getPaths() {

                Path p = new Path(getTable());

                Path p2 = p.add(p.getLast().getTable("REGLER_MONTANT_ELEMENT"));

                Path p3 = p2.add(p2.getLast().getField("ID_MOUVEMENT_ECHEANCE"));

                Path p4 = p3.add(p3.getLast().getField("ID_PIECE"));

                return CollectionUtils.createSet(new FieldPath(p4, "NOM"));

            }

        };

        res.getColumns().add(racColFact);

        final BaseSQLTableModelColumn racCol = new BaseSQLTableModelColumn("Report échéance", Boolean.class) {

            @Override

            protected Object show_(SQLRowAccessor r) {

                return !r.getForeign("ID_MODE_REGLEMENT").getBoolean("COMPTANT");

            }

            @Override

            public Set<FieldPath> getPaths() {

                Path p = new Path(getTable());

                Path p2 = p.add(p.getLast().getField("ID_MODE_REGLEMENT"));

                return CollectionUtils.createSet(new FieldPath(p2, "COMPTANT"));

            }

        };

        res.getColumns().add(racCol);

    }

    public SQLComponent createComponent() {

        return new ReglerMontantSQLComponent(this);

    };

    @Override

    protected String createCode() {

        return createCodeOfPackage() + ".regulation";

    }

}