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.tax.model;

import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.model.DBRoot;
import org.openconcerto.sql.model.SQLRow;
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.utils.ExceptionHandler;

import java.util.Arrays;
import java.util.Collections;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

public final class TaxeCache {

    private static final SQLRowValuesListFetcher getSel() {
        final DBRoot root = ((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete();
        final SQLTable table = root.getTable("TAXE");
        SQLRowValues rowVals = new SQLRowValues(table);
        rowVals.putNulls("TAUX", "CODE", "NOM", "ID_TAXE", "DEFAULT", "DEFAULT_ACHAT");
        List<String> compteFields = Arrays.asList("ID_COMPTE_PCE_COLLECTE", "ID_COMPTE_PCE_DED", "ID_COMPTE_PCE", "ID_COMPTE_PCE_VENTE", "ID_COMPTE_PCE_VENTE_SERVICE", "ID_COMPTE_PCE_COLLECTE_INTRA",
                "ID_COMPTE_PCE_DED_INTRA");
        for (String foreignFieldName : compteFields) {
            rowVals.putRowValues(foreignFieldName).putNulls("NUMERO", "NOM");
        }
        return SQLRowValuesListFetcher.create(rowVals);
    }

    private final Map<Integer, Float> mapTaux = new HashMap<>();
    private final Map<SQLRowAccessor, Float> mapRowTaux = new LinkedHashMap<>();
    private static TaxeCache instance;
    private SQLRow firstIdTaxe = null;
    private SQLRow firstIdTaxeAchat = null;

    private TaxeCache() {
        loadCache();
    }

    private void loadCache() {

        this.mapRowTaux.clear();
        this.mapTaux.clear();
        this.firstIdTaxe = null;
        this.firstIdTaxeAchat = null;

        final SQLRowValuesListFetcher sel = getSel();

        final List<SQLRowValues> l = sel.fetch();
        for (SQLRowValues sqlRow : l) {
            this.mapRowTaux.put(sqlRow, sqlRow.getFloat("TAUX"));
            this.mapTaux.put(sqlRow.getID(), sqlRow.getFloat("TAUX"));
            if (sqlRow.getBoolean("DEFAULT")) {
                this.firstIdTaxe = sqlRow.asRow();
            }
            if (sqlRow.getBoolean("DEFAULT_ACHAT")) {
                this.firstIdTaxeAchat = sqlRow.asRow();
            }
        }
    }

    public static synchronized TaxeCache getCache() {
        if (instance == null) {
            instance = new TaxeCache();
        }
        return instance;
    }

    public synchronized Float getTauxFromId(final int idTaux) {
        Float f = this.mapTaux.get(Integer.valueOf(idTaux));
        if (f == null) {
            loadCache();
            f = this.mapTaux.get(Integer.valueOf(idTaux));
        }
        return f;
    }

    public synchronized SQLRowAccessor getRowFromId(final int idTaux) {
        Set<SQLRowAccessor> s = mapRowTaux.keySet();
        for (SQLRowAccessor r : s) {
            if (r.getID() == idTaux) {
                return r;
            }
        }
        loadCache();
        for (SQLRowAccessor r : s) {
            if (r.getID() == idTaux) {
                return r;
            }
        }
        return null;

    }

    public synchronized SQLRow getFirstTaxe() {
        if (this.firstIdTaxe == null) {
            final SQLRowValuesListFetcher sel = getSel();
            final List<SQLRowValues> rows = sel.fetch(new Where(sel.getReq().getTable("TAXE").getField("DEFAULT"), "=", Boolean.TRUE));
            if (rows != null && !rows.isEmpty()) {

                this.firstIdTaxe = rows.get(0).asRow();
            } else {
                ExceptionHandler.handle("Aucune TVA par défaut définie!", new IllegalArgumentException("Aucune TVA par défaut définie!"));
                return mapRowTaux.keySet().iterator().next().asRow();
            }

        }
        return this.firstIdTaxe;
    }

    public synchronized SQLRow getFirstTaxeAchat() {
        if (this.firstIdTaxeAchat == null) {
            final SQLRowValuesListFetcher sel = getSel();
            final List<SQLRowValues> rows = sel.fetch(new Where(sel.getReq().getTable("TAXE").getField("DEFAULT_ACHAT"), "=", Boolean.TRUE));
            if (rows != null && !rows.isEmpty()) {
                this.firstIdTaxeAchat = rows.get(0).asRow();
            } else {
                this.firstIdTaxeAchat = getFirstTaxe();
            }

        }
        return this.firstIdTaxeAchat;
    }

    public synchronized Integer getIdFromTaux(Float tax) {
        Set<Integer> s = mapTaux.keySet();
        for (Integer integer : s) {
            if (this.mapTaux.get(integer).equals(tax)) {
                return integer;
            }
        }
        loadCache();
        for (Integer integer : s) {
            if (this.mapTaux.get(integer).equals(tax)) {
                return integer;
            }
        }
        return null;
    }

    public synchronized Set<SQLRowAccessor> getAllTaxe() {
        return Collections.unmodifiableSet(this.mapRowTaux.keySet());
    }

}