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

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.element.SQLElementLink.LinkType;
import org.openconcerto.sql.element.SQLElementLinksSetup;
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.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;
import java.util.Set;

import javax.swing.JTextField;

public class AssociationAnalytiqueSQLElement extends ComptaSQLConfElement {

    public AssociationAnalytiqueSQLElement() {
        super("ASSOCIATION_ANALYTIQUE", "une association analytique", "associations analytiques");

    }

    @Override
    protected void ffInited() {
        super.ffInited();
        this.setAction("ID_ECRITURE", ReferenceAction.CASCADE);
        this.setAction("ID_SAISIE_KM_ELEMENT", ReferenceAction.CASCADE);
    }

    @Override
    protected void setupLinks(SQLElementLinksSetup links) {
        super.setupLinks(links);
        if (getTable().contains("ID_ECRITURE")) {
            links.get("ID_ECRITURE").setType(LinkType.ASSOCIATION);
        }
    }

    protected List<String> getListFields() {
        final List<String> list = new ArrayList<String>(2);
        list.add("ID_ECRITURE");
        list.add("ID_POSTE_ANALYTIQUE");
        // list.add("MONTANT");
        return list;
    }

    protected List<String> getComboFields() {
        final List<String> list = new ArrayList<String>(2);
        list.add("ID_ECRITURE");
        list.add("ID_POSTE_ANALYTIQUE");
        return list;
    }

    public SQLComponent createComponent() {
        return new BaseSQLComponent(this) {
            public void addViews() {
                this.addRequiredSQLObject(new JTextField(), "ID_ECRITURE");
                this.addRequiredSQLObject(new JTextField(), "ID_POSTE_ANALYTIQUE");
            }
        };
    }

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

    @Override
    protected synchronized void _initTableSource(final SQLTableModelSource table) {
        super._initTableSource(table);
        BaseSQLTableModelColumn debit = new BaseSQLTableModelColumn("Débit", BigDecimal.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                long montant = r.getLong("MONTANT");
                if (montant > 0) {
                    return new BigDecimal(montant).movePointLeft(2);
                } else {
                    return BigDecimal.ZERO;
                }
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(getTable());
                return CollectionUtils.createSet(new FieldPath(p, "MONTANT"));
            }
        };

        table.getColumns().add(debit);

        BaseSQLTableModelColumn credit = new BaseSQLTableModelColumn("Crédit", BigDecimal.class) {

            @Override
            protected Object show_(SQLRowAccessor r) {

                long montant = r.getLong("MONTANT");
                if (montant < 0) {
                    return new BigDecimal(-montant).movePointLeft(2);
                } else {
                    return BigDecimal.ZERO;
                }
            }

            @Override
            public Set<FieldPath> getPaths() {
                Path p = new Path(getTable());
                return CollectionUtils.createSet(new FieldPath(p, "MONTANT"));
            }
        };

        table.getColumns().add(credit);
    }
}