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.erp.core.common.element.StyleSQLElement;
import org.openconcerto.openoffice.spreadsheet.Sheet;
import org.openconcerto.openoffice.spreadsheet.SpreadSheet;

import java.awt.Point;
import java.io.File;
import java.io.IOException;
import java.util.Map;

// TODO mettre les style dans des notes --> ex : @style : normal col1, Col2
// TODO popup si cell repeated > 50 ---> java heap space
// TODO popup si fichier introuvable
public class SpreadSheetGeneratorCompta extends SpreadSheetGenerator {

    public SpreadSheetGeneratorCompta(SheetInterface sheet, String destFileName, boolean impr, boolean visu) {
        this(sheet, destFileName, impr, visu, true);
    }

    public SpreadSheetGeneratorCompta(SheetInterface sheet, String destFileName, boolean impr, boolean visu, boolean exportPDF) {
        super(sheet, destFileName, impr, visu, exportPDF);
        new Thread(this).start();
    }

    protected File generateWithStyle() throws IOException {

        final SpreadSheet ssheet = loadTemplate();
        if (ssheet == null) {
            return null;
        }

        final Map<String, Map<Integer, String>> mapStyleDef = StyleSQLElement.getMapAllStyle();

        final Sheet sheet = ssheet.getSheet(0);

        // on parcourt chaque ligne de la feuille pour recuperer les styles
        String s = (sheet.getPrintRanges() == null) ? "" : sheet.getPrintRanges().toString();
        String[] range = s.split(":");

        for (int i = 0; i < range.length; i++) {
            String string = range[i];
            range[i] = string.subSequence(string.indexOf('.') + 1, string.length()).toString();
        }

        // int colDeb = -1;
        int colEnd = -1;
        int rowEnd = -1;
        if (range.length > 1) {
            // colDeb = sheet.resolveHint(range[0]).x;
            final Point resolveHint = sheet.resolveHint(range[1]);
            colEnd = resolveHint.x;
            rowEnd = resolveHint.y;
        }
        searchStyle(sheet, mapStyleDef, colEnd, rowEnd);

        if (colEnd > 0) {
            System.err.println("Set Column Count to :: " + (colEnd + 1));
            sheet.setColumnCount(colEnd + 1);
        }
        if (this.nbPage < 1) {
            throw new IllegalArgumentException("invalid page count : " + this.nbPage);
        }
        sheet.duplicateFirstRows(this.nbRowsPerPage, this.nbPage - 1);

        Object printRangeObj = sheet.getPrintRanges();
        if (printRangeObj != null) {
            String[] range2 = printRangeObj.toString().split(":");

            for (int i = 0; i < range2.length; i++) {
                String string = range2[i];
                range2[i] = string.subSequence(string.indexOf('.') + 1, string.length()).toString();
            }

            if (range2.length > 1) {
                int end = sheet.resolveHint(range2[1]).y + 1;
                int rowEndNew = end * this.nbPage;
                String sNew = s.replaceAll(String.valueOf(end), String.valueOf(rowEndNew));
                sheet.setPrintRanges(sNew);
                System.err.println("SpreadSheetGenerator ******  Replace print ranges; Old:" + end + "--" + s + " New:" + rowEndNew + "--" + sNew);
            }
        } else {
            sheet.removePrintRanges();
        }

        // on place les valeurs
        fill(sheet, mapStyleDef);

        return save(ssheet);
    }
}