ODSExporter.java

/**
 * Copyright (C) 2010-2017 Structr GmbH
 *
 * This file is part of Structr <http://structr.org>.
 *
 * Structr is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * Structr 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with Structr.  If not, see <http://www.gnu.org/licenses/>.
 */
package org.structr.odf.entity;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.StringJoiner;
import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument;
import org.odftoolkit.odfdom.doc.table.OdfTable;
import org.odftoolkit.odfdom.doc.table.OdfTableCell;
import org.structr.common.error.FrameworkException;
import org.structr.core.Export;
import org.structr.core.GraphObject;
import org.structr.core.GraphObjectMap;
import org.structr.core.Result;
import org.structr.core.app.App;
import org.structr.core.app.StructrApp;
import org.structr.core.entity.AbstractNode;
import org.structr.core.property.StringProperty;
import static org.structr.odf.entity.ODFExporter.logger;
import static org.structr.odf.entity.ODFExporter.resultDocument;
import org.structr.schema.SchemaService;
import org.structr.transform.VirtualType;
import org.structr.web.entity.FileBase;

/**
 *
 */
public class ODSExporter extends ODFExporter {

	static {
		SchemaService.registerBuiltinTypeOverride("ODSExporter", ODSExporter.class.getName());
	}

	private void writeCollectionToCells(OdfTable sheet, OdfTableCell startCell, Collection col) {

		int rowIndex, colIndex;

		colIndex = startCell.getColumnIndex();
		rowIndex = startCell.getRowIndex();

		Iterator<Collection> colIt = col.iterator();

		while (colIt.hasNext()) {
			Object obj = colIt.next();
			if (obj instanceof String[]) {

				String[] arr = (String[]) obj;
				List<String> list = new ArrayList<>(Arrays.asList(arr));
				StringJoiner sj = new StringJoiner(",");
				list.forEach(
					s -> sj.add(s)
				);
				writeObjectToCell(sheet.getCellByPosition(colIndex, rowIndex), sj.toString());

			} else if (obj instanceof Collection) {

				Collection nestedCol = (Collection) obj;
				StringJoiner sj = new StringJoiner(",");
				nestedCol.forEach(
					s -> sj.add(s.toString())
				);
				writeObjectToCell(sheet.getCellByPosition(colIndex, rowIndex), sj.toString());

			} else {

				writeObjectToCell(sheet.getCellByPosition(colIndex, rowIndex), obj);

			}

			rowIndex++;
		}

	}

	private void writeObjectToCell(OdfTableCell cell, Object val) {
		if (val instanceof String) {

			cell.setStringValue((String) val);

		} else if (val instanceof Integer) {

			Integer i = (Integer) val;
			cell.setDoubleValue(i.doubleValue());

		} else if (val instanceof Double) {

			cell.setDoubleValue((Double) val);

		} else if (val instanceof Boolean) {

			cell.setBooleanValue((Boolean) val);

		} else if (val instanceof AbstractNode) {

			AbstractNode node = (AbstractNode) val;
			cell.setStringValue(
				node.getProperty(new StringProperty("id"))
			);

		} else if (val != null) {

			cell.setStringValue(val.toString());

		}
	}

	@Export
	public void exportAttributes(String uuid) throws FrameworkException {

		FileBase output = getProperty(resultDocument);
		VirtualType transformation = getProperty(transformationProvider);

		try {

			final App app = StructrApp.getInstance();
			final Result result = app.nodeQuery(AbstractNode.class).and(GraphObject.id, uuid).getResult();
			final Result transformedResult = transformation.transformOutput(securityContext, AbstractNode.class, result);

			Map<String, Object> nodeProperties = new HashMap<>();
			GraphObjectMap node = (GraphObjectMap) transformedResult.get(0);
			node.getPropertyKeys(null).forEach(
				p -> nodeProperties.put(p.dbName(), node.getProperty(p))
			);

			OdfSpreadsheetDocument spreadsheet = OdfSpreadsheetDocument.loadDocument(output.getFileOnDisk().getAbsolutePath());
			OdfTable sheet = spreadsheet.getTableList().get(0);

			Iterator<Entry<String, Object>> it = nodeProperties.entrySet().iterator();

			while (it.hasNext()) {

				Entry<String, Object> currentEntry = it.next();
				String address = currentEntry.getKey();
				Object val = currentEntry.getValue();

				if (val instanceof Collection) {

					Collection col = (Collection) val;
					writeCollectionToCells(sheet, sheet.getCellByPosition(address), col);

				} else if (val instanceof String[]) {

					String[] arr = (String[]) val;
					List<String> list = new ArrayList<>(Arrays.asList(arr));
					writeCollectionToCells(sheet, sheet.getCellByPosition(address), list);

				} else {
					writeObjectToCell(sheet.getCellByPosition(address), val);
				}

			}

			spreadsheet.save(output.getFileOnDisk().getAbsolutePath());
			spreadsheet.close();

		} catch (Exception e) {
			logger.error("Error while exporting to ODS", e);
		}
	}

}