org.activityinfo.server.report.renderer.excel.BaseExcelRenderer.java Source code

Introduction

Here is the source code for org.activityinfo.server.report.renderer.excel.BaseExcelRenderer.java

Source

package org.activityinfo.server.report.renderer.excel;

/*
 * #%L
 * ActivityInfo Server
 * %%
 * Copyright (C) 2009 - 2013 UNICEF
 * %%
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as
 * published by the Free Software Foundation, either version 3 of the 
 * License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public 
 * License along with this program.  If not, see
 * <http://www.gnu.org/licenses/gpl-3.0.html>.
 * #L%
 */

import org.activityinfo.legacy.shared.reports.content.FilterDescription;
import org.activityinfo.legacy.shared.reports.model.ReportElement;
import org.apache.poi.ss.usermodel.*;

import java.util.List;
import java.util.logging.Logger;

public abstract class BaseExcelRenderer<ElementT extends ReportElement> {

    private static final int MAX_CELL_CONTENT_LENGTH = 32700;
    protected final ElementT element;
    protected final Workbook book;
    protected final Sheet sheet;
    protected final CreationHelper factory;

    private static final Logger LOGGER = Logger.getLogger(BaseExcelRenderer.class.getName());

    protected int rowIndex;

    public BaseExcelRenderer(Workbook book, ElementT element) {

        this.element = element;
        this.book = book;
        this.factory = book.getCreationHelper();
        this.sheet = book.createSheet(composeSheetName());

        /* Create title line */

        Row titleRow = sheet.createRow(0);
        Cell titleCell = titleRow.createCell(0);
        titleCell.setCellValue(factory.createRichTextString(element.getTitle()));

        /* Create filter descriptors */

        List<FilterDescription> descs = generateFilterDescriptions();

        rowIndex = 2;

        for (FilterDescription desc : descs) {

            Row filterRow = sheet.createRow(rowIndex++);
            Cell filterCell = filterRow.createCell(0);

            String label = desc.joinLabels(", ");
            if (label.length() > MAX_CELL_CONTENT_LENGTH) {
                LOGGER.severe("Huge filter label string: " + label);
                label = label.substring(0, MAX_CELL_CONTENT_LENGTH) + "...";
            }
            filterCell.setCellValue(factory.createRichTextString(label));
        }

        rowIndex++;

        generate();
    }

    public abstract List<FilterDescription> generateFilterDescriptions();

    public String composeSheetName() {
        if (element.getSheetTitle() != null) {
            return element.getSheetTitle();
        } else if (element.getTitle() != null) {
            return element.getTitle();
        } else {
            return "Sheet" + (book.getNumberOfSheets() + 1);
        }
    }

    public void generate() {

    }

    protected Font createBaseFont() {
        Font font = book.createFont();

        return font;
    }

}