examples.conditional.ConditionalReportView Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of poi.builder.examples Show documentation
Usage examples for POI builder library
There is a newer version: 1.0.4
package examples.conditional;

import org.subtlelib.poi.api.sheet.SheetContext;
import org.subtlelib.poi.api.workbook.WorkbookContext;
import org.subtlelib.poi.impl.workbook.WorkbookContextFactory;

/**
 * This example shows how to use subtlelib to render a report with grouped data.
 * Additional features covered:
 * 
 *     conditional cell (see 'Related E-book' below): it is rendered
 *         depending on the report model
 *     optional data (see 'ISBN'): when the field is optional, nothing is written in the cell.
 *         If you have nullable fields instead, use .text(Optional.fromNullable(myData.getSomeField()))
 * 
 *
 * Created on 16/05/13
 * @author d.serdiuk
 */
public class ConditionalReportView {
    public WorkbookContext render(ConditionalReportModel model) {
        WorkbookContext workbookCtx = WorkbookContextFactory.createWorkbook();
        SheetContext sheetCtx = workbookCtx.createSheet("Books");

        // report heading
        sheetCtx
            .nextRow()
                .mergeCells(2).text("Authors report #")
                .number(model.getReportNumber())
            .nextRow().cellAt(5)
                .text("Date:").setColumnWidth(11)
                .date(model.getReportCreationDate().toDate()).setColumnWidth(11)
            .nextRow().cellAt(5)
                .text("Place:")
                .text(model.getReportCreationPlace());

        // columns heading
        sheetCtx
            .nextRow()
                .header("Name")
                .header("Surname").setColumnWidth(25)
                .header("ContactNumber").setColumnWidth(15)
                .header("Last Activity").setColumnWidth(16)
                .header("Rating");

        // data
        for (Author author: model.getBooksByAuthor().keySet()) {
            sheetCtx
                .nextRow()
                    .text(author.getName())
                    .text(author.getSurname())
                    .text(author.getContactNumber()) // contact number is Optional. If value is Absent, cell will be skipped
                    .date(author.getLastUpdate().toDate())
                    .text(author.getRating())
                .nextRow().skipCell()
                    .header("Title")
                    .header("# pages")
                    .conditionalCell(model.isEbooksIncluded()).header("Related E-book")
                    .header("Rating")
                    .header("Left in stock")
                    .header("Publisher")
                    .header("ISBN");

            for (Book book : model.getBooksByAuthor().get(author)) {
                sheetCtx
                    .nextRow().skipCell()
                        .text(book.getTitle())
                        .number(book.getPages())
                        .conditionalCell(model.isEbooksIncluded()).text(book.getEbookNumber())
                        .number(book.getRating())
                        .number(book.getLeftInWarehouse())
                        .text(book.getPublisher())
                        .text(book.getIsbn()); // ISBN is Optional. If value is Absent - cell will be skipped
            }
            sheetCtx
                .skipRow();
        }
        return workbookCtx;
    }
}