KontenplanExcelImporter.java

/////////////////////////////////////////////////////////////////////////////
//
// Project ProjectForge Community Edition
//         www.projectforge.org
//
// Copyright (C) 2001-2014 Kai Reinhard (k.reinhard@micromata.de)
//
// ProjectForge is dual-licensed.
//
// This community edition 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; version 3 of the License.
//
// This community edition 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/.
//
/////////////////////////////////////////////////////////////////////////////

package org.projectforge.fibu.datev;

import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;

import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.projectforge.common.ImportStorage;
import org.projectforge.common.ImportedElement;
import org.projectforge.common.ImportedSheet;
import org.projectforge.core.ActionLog;
import org.projectforge.excel.ExcelImport;
import org.projectforge.fibu.KontoDO;

public class KontenplanExcelImporter
{
  public static final String NAME_OF_EXCEL_SHEET = "Kontenplan";

  private static final Logger log = Logger.getLogger(KontenplanExcelImporter.class);

  /** In dieser Zeile stehen die Überschriften der Spalten für die Konten. */
  public static final int ROW_COLUMNNAMES = 1;

  public void doImport(final ImportStorage<KontoDO> storage, final InputStream is, final ActionLog actionLog) throws Exception
  {
    final ExcelImport<KontenplanExcelRow> imp = new ExcelImport<KontenplanExcelRow>(is);
    for (short idx = 0; idx < imp.getWorkbook().getNumberOfSheets(); idx++) {
      imp.setActiveSheet(idx);
      final String name = imp.getWorkbook().getSheetName(idx);
      if (NAME_OF_EXCEL_SHEET.equals(name)) {
        imp.setActiveSheet(idx);
        final HSSFSheet sheet = imp.getWorkbook().getSheetAt(idx);
        importKontenplan(storage, imp, sheet, actionLog);
        return;
      }
    }
    log.error("Oups, no sheet named 'Kontenplan' found.");
  }

  private void importKontenplan(final ImportStorage<KontoDO> storage, final ExcelImport<KontenplanExcelRow> imp, final HSSFSheet sheet,
      final ActionLog actionLog) throws Exception
      {
    final ImportedSheet<KontoDO> importedSheet = new ImportedSheet<KontoDO>();
    storage.addSheet(importedSheet);
    importedSheet.setName(NAME_OF_EXCEL_SHEET);
    imp.setNameRowIndex(ROW_COLUMNNAMES);
    imp.setStartingRowIndex(ROW_COLUMNNAMES + 1);
    imp.setRowClass(KontenplanExcelRow.class);

    final Map<String, String> map = new HashMap<String, String>();
    map.put("Konto", "konto");
    map.put("Bezeichnung", "bezeichnung");
    map.put("Beschriftung", "bezeichnung");
    imp.setColumnMapping(map);

    KontenplanExcelRow[] rows = new KontenplanExcelRow[0];
    rows = imp.convertToRows(KontenplanExcelRow.class);
    for (int i = 0; i < rows.length; i++) {
      actionLog.incrementCounterSuccess();
      final KontoDO konto = convertKonto(rows[i]);
      final ImportedElement<KontoDO> element = new ImportedElement<KontoDO>(storage.nextVal(), KontoDO.class,
          DatevImportDao.KONTO_DIFF_PROPERTIES);
      element.setValue(konto);
      importedSheet.addElement(element);
      log.debug(konto);
    }
      }

  private KontoDO convertKonto(final KontenplanExcelRow row) throws Exception
  {
    final KontoDO konto = new KontoDO();
    konto.setNummer(row.konto);
    konto.setBezeichnung(row.bezeichnung);
    return konto;
  }
}