org.sevenorcas.style.mod.cust.CustListSS.java Source code

Introduction

Here is the source code for org.sevenorcas.style.mod.cust.CustListSS.java

Source

package org.sevenorcas.style.mod.cust;

import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.sevenorcas.style.app.anno.Export;
import org.sevenorcas.style.app.mod.login.UserParam;
import org.sevenorcas.style.app.mod.ss.BaseListSpreadSheet;
import org.sevenorcas.style.app.mod.ss.SpreadSheet;
import org.sevenorcas.style.app.mod.ss.SpreadsheetCell;
import org.sevenorcas.style.app.mod.ss.SpreadsheetCellCallBackI;

/**
 * Customer List spreadsheet generation class.<p>
 *  
 * [License]
 * @author John Stewart
 */
@Export
public class CustListSS extends BaseListSpreadSheet implements CustListI {

    private CustListHtml list;

    /**
     * Constructor
     * @param User parameters
     * @param List Wrapper
     */
    public CustListSS(UserParam params, CustListHtml list) {
        super(params, list.getWrap());
        this.list = list;
    }

    /**
     * Output spreadsheet.
     * 
     * @throws Exception 
     */
    public List<SpreadSheet> getSpreadSheetList() throws Exception {

        SpreadSheet sheet = new SpreadSheet(lang.getLabel("CustS"));

        SpreadsheetCell cell = sheet.addCell(lang.getLabel("CustS"), STYLE_TITLE_CELL);

        cell.setCallback(new SpreadsheetCellCallBackI() {
            public HSSFRichTextString getCellValue(HSSFWorkbook wb, SpreadSheet sheet, HSSFCell cell,
                    String value) {
                HSSFFont font = wb.createFont();
                font.setFontHeightInPoints((short) 16);
                HSSFCellStyle style = wb.createCellStyle();
                style.setFont(font);
                cell.setCellStyle(style);
                return new HSSFRichTextString(value);
            }
        });

        int cols = 5 + (config.isMultiCountry() ? 1 : 0);

        mergeColumns(sheet, cell, cols);
        sheet.incrementRow();
        sheet.incrementRow();
        sheet.setCol(0);

        cell = addCellHeader(sheet, FIELD_NR);
        cell.setBackgroundColorRGB(COLOL_GREY25);
        addCellHeader(sheet, FIELD_CODE);
        addCellHeader(sheet, FIELD_LOC);
        addCellHeader(sheet, FIELD_CTRY);
        addCellHeader(sheet, "Adr");
        addCellHeader(sheet, "AdrC");

        //        for (ExportObject e: list.getExportObject()){
        //            sheet.incrementRow();
        //            sheet.setCol(0);
        //            sheet.addCell (e.number,  STYLE_DATA_CELL);
        //            sheet.addCell (e.code,    STYLE_DATA_CELL);
        //            sheet.addCell (e.loc,     STYLE_DATA_CELL);
        //            if (config.isMultiCountry()){
        //                sheet.addCell (e.country, STYLE_DATA_CELL);
        //            }
        //            sheet.addCell (e.address, STYLE_DATA_CELL);
        //            sheet.addCell (e.contact, STYLE_DATA_CELL);
        //        }

        List<SpreadSheet> sheets = new ArrayList<SpreadSheet>();
        sheets.add(sheet);
        return sheets;
    }

}