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.core.supplychain.stock.element;

import org.openconcerto.erp.core.sales.product.element.LotSQLElement;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.FieldPath;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLRowValuesListFetcher;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.model.graph.Path;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class StockRootNode {
    private final List<StockNode> children = new ArrayList<>();
    private final List<SQLRowValues> listRowValsStock = new ArrayList<>();
    private final List<FieldPath> cols = new ArrayList<>();
    private final SQLElement eltStock;
    private boolean hasBatch = false;

    public StockRootNode(SQLElement e) {
        this.eltStock = e;
        final SQLTable tableStock = this.eltStock.getTable();
        final Path pStock = new Path(tableStock);
        final Path pDepotStock = pStock.add(tableStock.getField("ID_DEPOT_STOCK"));
        this.cols.add(new FieldPath(pDepotStock, "NOM"));
        this.cols.add(new FieldPath(pStock, "QTE_TH"));
        this.cols.add(new FieldPath(pStock, "QTE_RECEPT_ATTENTE"));
        this.cols.add(new FieldPath(pStock, "QTE_LIV_ATTENTE"));
        this.cols.add(new FieldPath(pStock, "QTE_REEL"));

    }

    public void load(SQLRowAccessor article) {

        this.children.clear();
        final SQLTable tableStock = this.eltStock.getTable();
        final SQLRowValues rowValsStock = new SQLRowValues(tableStock);
        rowValsStock.putNulls("QTE_TH", "QTE_RECEPT_ATTENTE", "QTE_LIV_ATTENTE", "QTE_REEL");
        rowValsStock.putRowValues("ID_DEPOT_STOCK").putNulls("NOM");

        final SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(rowValsStock);
        final List<SQLRowValues> fetch = fetcher.fetch(
                new Where(tableStock.getField("ID_ARTICLE"), "=", article.getID()).and(new Where(tableStock.getField("QTE_REEL"), "!=", 0).or(new Where(tableStock.getField("QTE_TH"), "!=", 0))));
        this.listRowValsStock.clear();
        this.listRowValsStock.addAll(fetch);
        final List<Integer> idsStock = new ArrayList<>();
        for (SQLRowValues r : this.listRowValsStock) {
            idsStock.add(r.getID());
        }

        final SQLTable tableLot = this.eltStock.getDirectory().getElement(LotSQLElement.class).getTable();
        SQLRowValues rLot = new SQLRowValues(tableLot);
        rLot.putNulls("ID_STOCK", "QUANTITE", "NUMERO_LOT", "NUMERO_SERIE", "DLC", "DLUO");
        final List<SQLRowValues> fetchLots = SQLRowValuesListFetcher.create(rLot).fetch(Where.inValues(tableLot.getField("ID_STOCK"), idsStock));
        this.hasBatch = !fetchLots.isEmpty();

        final Map<Integer, List<BatchNode>> stockLots = new HashMap<>();
        for (SQLRowValues lot : fetchLots) {
            int idStock = lot.getInt("ID_STOCK");
            List<BatchNode> lots = stockLots.get(idStock);
            if (lots == null) {
                lots = new ArrayList<>();
                stockLots.put(idStock, lots);
            }
            lots.add(new BatchNode(lot));
        }
        for (SQLRowValues r : this.listRowValsStock) {
            this.children.add(new StockNode(r, stockLots.get(r.getID())));
        }
    }

    public boolean hasBatch() {
        return this.hasBatch;
    }

    public StockNode getChild(int i) {
        return this.children.get(i);
    }

    public int getSize() {
        return this.children.size();
    }

    public String getLabelFor(int column) {
        return this.eltStock.getDirectory().getTranslator().getLabelFor(this.cols.get(column).getField()).replace("Quantité", "Quantité\n");
    }

    public FieldPath getFieldPath(int columnIndex) {
        final FieldPath fieldPath = this.cols.get(columnIndex);
        return fieldPath;
    }

}