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.gestcomm;

import org.openconcerto.erp.generationDoc.SheetInterface;

import org.openconcerto.erp.generationDoc.SheetXml;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.utils.GestionDevise;

import org.openconcerto.utils.Tuple2;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

public class ReleveChequeEmisSheet extends SheetInterface {

    private static final SQLTable tableCheque = base.getTable("CHEQUE_FOURNISSEUR");

    private static final SQLTable tableFourn = base.getTable("FOURNISSEUR");

    private List<Integer> listeCheques;

    public ReleveChequeEmisSheet(List<Integer> idCheques) {

        this.mapReplace = new HashMap();

        this.mapStyleRow = new HashMap();

        this.mCell = new HashMap();

        this.row = tableCheque.getRow(idCheques.get(0));

        // super(idCheques.get(0), tableCheque);

        this.listeCheques = idCheques;

        init();

        createMap();

    }

    public static final String TEMPLATE_ID = "ReleveChequeEmis";

    public static final String TEMPLATE_PROPERTY_NAME = "LocationReleveCheque";

    private void init() {

        this.modele = "ReleveChequeEmis.ods";

    }

    @Override

    public String getTemplateId() {

        return TEMPLATE_ID;

    }

    @Override

    protected String getYear() {

        return "";

    }

    protected void createMap() {

        long montantTotal = 0;

        // Element Cheques

        int pos = 5;

        for (Integer i : this.listeCheques) {

            SQLRow rowTmp = tableCheque.getRow(i.intValue());

            SQLRow rowFournTmp = tableFourn.getRow(rowTmp.getInt("ID_FOURNISSEUR"));

            Object nomTmp = rowFournTmp.getObject("NOM");

            this.mCell.put("B" + pos, nomTmp);

            Long montant = (Long) rowTmp.getObject("MONTANT");

            montantTotal += montant;

            this.mCell.put("L" + pos, new Double(GestionDevise.currencyToString(montant.longValue(), false)));

            pos++;

        }

        // Date

        this.mCell.put("C45", (Date) this.row.getObject("DATE_DECAISSE"));

        // Total

        this.mCell.put("L45", new Double(GestionDevise.currencyToString(montantTotal, false)));

        this.nbPage = 1;

    }

}