Dépôt officiel du code source de l'ERP OpenConcerto

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * Copyright 2011-2019 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.generationDoc;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLTable;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

import org.jdom2.Element;

public class OOXMLTableElement {

    private List<SQLRow> row;

    private int firstLine, endPageLine, endLine, filterId;

    private List<String> listBlankLineStyle;

    private boolean typeStyleWhere;

    private SQLElement elt;

    private String foreignTableWhere, typeWhere, fieldWhere;

    private Element tableau;

    private OOXMLCache cache;

    public OOXMLTableElement(Element tableau, SQLRow row, OOXMLCache cache) {

        this.tableau = tableau;

        this.cache = cache;

        this.foreignTableWhere = tableau.getAttributeValue("tableForeignWhere");

        this.fieldWhere = tableau.getAttributeValue("fieldWhere");

        if (this.fieldWhere != null && row.getTable().contains(fieldWhere)) {

            this.filterId = row.getInt(this.fieldWhere);

        }

        String fieldAttribute = tableau.getAttributeValue("field");

        if (fieldAttribute != null && fieldAttribute.trim().length() > 0) {

            if (fieldAttribute.contains(",")) {

                List<String> l = SQLRow.toList(fieldAttribute);

                this.row = new ArrayList<SQLRow>();

                for (String string : l) {

                    this.row.add(row.getForeignRow(string));

                }

            } else {

                this.row = Arrays.asList(row.getForeignRow(fieldAttribute));

            }

        } else {

            this.row = Arrays.asList(row);

        }

        this.firstLine = Integer.valueOf(tableau.getAttributeValue("firstLine"));

        this.endPageLine = Integer.valueOf(tableau.getAttributeValue("endPageLine"));

        this.endLine = Integer.valueOf(tableau.getAttributeValue("endLine"));

        this.elt = Configuration.getInstance().getDirectory().getElement(tableau.getAttributeValue("table"));

        this.typeWhere = tableau.getAttributeValue("typeWhere");

        String blankLineBeforeStyle = tableau.getAttributeValue("blankLineBeforeStyle");

        this.listBlankLineStyle = new ArrayList<String>();

        if (blankLineBeforeStyle != null) {

            this.listBlankLineStyle = SQLRow.toList(blankLineBeforeStyle.trim());

        }

        this.typeStyleWhere = (this.typeWhere == null) ? false : this.typeWhere.equalsIgnoreCase("Style");

    }

    public List<? extends SQLRowAccessor> getRows() {

        String foreignTableName = this.tableau.getAttributeValue("table");

        SQLTable tableElt = null;

        if (!this.row.isEmpty()) {

            SQLTable tableRow = this.row.get(0).getTable();

            if (tableRow.getDBRoot().contains(foreignTableName)) {

                tableElt = tableRow.getDBRoot().getTable(foreignTableName);

            } else {

                tableElt = Configuration.getInstance().getRoot().findTable(foreignTableName);

            }

        }

        if (tableElt != null) {

            return cache.getReferentRows(this.row, tableElt, this.tableau.getAttributeValue("groupBy"), this.tableau.getAttributeValue("orderBy"),

                    Boolean.valueOf(this.tableau.getAttributeValue("expandNomenclature")), this.tableau.getAttributeValue("foreignField"),

                    Boolean.valueOf(this.tableau.getAttributeValue("excludeZeroQty")));

        } else {

            System.err.println("OOXMLTableElement.getRows() Table " + tableElt + " is null!");

            return new ArrayList<SQLRow>();

        }

    }

    public int getFirstLine() {

        return this.firstLine;

    }

    public int getFilterId() {

        return this.filterId;

    }

    public int getEndPageLine() {

        return this.endPageLine;

    }

    public int getEndLine() {

        return this.endLine;

    }

    public List<String> getListBlankLineStyle() {

        return this.listBlankLineStyle;

    }

    public SQLElement getSQLElement() {

        return this.elt;

    }

    public String getForeignTableWhere() {

        return this.foreignTableWhere;

    }

    public List<SQLRow> getRow() {

        return this.row;

    }

    public Element getTableau() {

        return this.tableau;

    }

    public String getTypeWhere() {

        return this.typeWhere;

    }

    public boolean getTypeStyleWhere() {

        return this.typeStyleWhere;

    }

    public String getFieldWhere() {

        return this.fieldWhere;

    }

}