--- /dev/null
+/*******************************************************************************\r
+ * Copyright (c) 2007, 2010 Association for Decentralized Information Management\r
+ * in Industry THTH ry.\r
+ * All rights reserved. This program and the accompanying materials\r
+ * are made available under the terms of the Eclipse Public License v1.0\r
+ * which accompanies this distribution, and is available at\r
+ * http://www.eclipse.org/legal/epl-v10.html\r
+ *\r
+ * Contributors:\r
+ * VTT Technical Research Centre of Finland - initial API and implementation\r
+ *******************************************************************************/\r
+package org.simantics.spreadsheet.ui.editor;\r
+\r
+import java.io.File;\r
+import java.io.IOException;\r
+\r
+import org.simantics.Simantics;\r
+import org.simantics.databoard.Bindings;\r
+import org.simantics.databoard.binding.mutable.Variant;\r
+import org.simantics.db.ReadGraph;\r
+import org.simantics.db.Resource;\r
+import org.simantics.db.Session;\r
+import org.simantics.db.WriteGraph;\r
+import org.simantics.db.common.request.ResourceRead;\r
+import org.simantics.db.common.request.WriteRequest;\r
+import org.simantics.db.common.utils.Logger;\r
+import org.simantics.db.exception.DatabaseException;\r
+import org.simantics.db.layer0.util.Layer0Utils;\r
+import org.simantics.excel.Excel;\r
+import org.simantics.excel.ExcelException;\r
+import org.simantics.layer0.Layer0;\r
+import org.simantics.spreadsheet.ClientModel;\r
+import org.simantics.spreadsheet.Range;\r
+import org.simantics.spreadsheet.common.client.ClientModelListenerAdapter;\r
+import org.simantics.spreadsheet.common.exception.CellParseException;\r
+import org.simantics.spreadsheet.resource.SpreadsheetResource;\r
+import org.simantics.spreadsheet.util.SpreadsheetUtils;\r
+import org.simantics.utils.FileUtils;\r
+import org.simantics.utils.datastructures.Pair;\r
+import org.simantics.utils.ui.dialogs.ShowMessage;\r
+\r
+public class ExcelLink extends ClientModelListenerAdapter {\r
+\r
+ final private Session session;\r
+ final private Resource container;\r
+ final private ClientModel model;\r
+ final private Resource book;\r
+ final private String bookName;\r
+ final private String sheetName;\r
+ final private String prefix;\r
+ final private Excel excel;\r
+ private int handle;\r
+ \r
+ public ExcelLink(Session session, Resource container, ClientModel model, final Resource book, String bookName, String sheetName, String prefix) {\r
+ \r
+ this.session = session;\r
+ this.container = container;\r
+ this.handle = 0;\r
+ this.model = model;\r
+ this.bookName = bookName + ".xlsx";\r
+ this.sheetName = sheetName;\r
+ this.prefix = prefix;\r
+ this.book = book;\r
+ \r
+ this.excel = tryGetExcel(book, bookName);\r
+\r
+ model.addListener(this);\r
+ \r
+ }\r
+ \r
+ public static Excel tryGetExcel(final Resource book, final String bookName) {\r
+\r
+ try {\r
+\r
+ Excel excel = Excel.getInstance(System.out);\r
+ String file = excel.getFile(bookName);\r
+ final File tester = new File(file);\r
+\r
+ if(!tester.exists()) {\r
+ // Restore file from graph\r
+ try {\r
+ byte[] saved = Simantics.getSession().syncRequest(new ResourceRead<byte[]>(book) {\r
+\r
+ @Override\r
+ public byte[] perform(ReadGraph graph) throws DatabaseException {\r
+ SpreadsheetResource SR = SpreadsheetResource.getInstance(graph);\r
+ return graph.getPossibleRelatedValue(book, SR.HasMicrosoftExcelDocumentData, Bindings.BYTE_ARRAY);\r
+ }\r
+\r
+ });\r
+ if(saved != null) FileUtils.writeFile(tester, saved);\r
+ } catch (DatabaseException e) {\r
+ Logger.defaultLogError(e);\r
+ } catch (IOException e) {\r
+ Logger.defaultLogError(e);\r
+ }\r
+ }\r
+\r
+ return excel;\r
+\r
+ } catch (ExcelException e1) {\r
+\r
+ Logger.defaultLogError(e1);\r
+\r
+ } \r
+\r
+ return null;\r
+\r
+ }\r
+\r
+ public void dispose() {\r
+ \r
+ model.removeListener(this);\r
+\r
+ try {\r
+ \r
+ if(excel != null) {\r
+ if(handle != 0) excel.close_(handle);\r
+ String file = excel.getFile(bookName);\r
+ File tester = new File(file);\r
+ if(tester.exists()) {\r
+ final byte[] saved = FileUtils.readFile(tester);\r
+ if(saved != null) {\r
+ Simantics.getSession().syncRequest(new WriteRequest() {\r
+ \r
+ @Override\r
+ public void perform(WriteGraph graph) throws DatabaseException {\r
+ SpreadsheetResource SR = SpreadsheetResource.getInstance(graph);\r
+ graph.claimLiteral(book, SR.HasMicrosoftExcelDocumentData, saved, Bindings.BYTE_ARRAY);\r
+ }\r
+ \r
+ });\r
+ }\r
+ }\r
+ }\r
+ \r
+ } catch (DatabaseException e) {\r
+ Logger.defaultLogError(e);\r
+ } catch (IOException e) {\r
+ Logger.defaultLogError(e);\r
+ }\r
+ \r
+ }\r
+\r
+ @Override\r
+ public void propertyChange(String location, String property, Object value) {\r
+ \r
+ if(ClientModel.CONTENT.equals(property) && value != null && value instanceof Variant) {\r
+ \r
+ if(handle == 0) return;\r
+ Range range = SpreadsheetUtils.decodeCellAbsolute(location);\r
+ excel.setString_(handle, range.startRow, range.startColumn, ((Variant)value).getValue().toString());\r
+ final String modis = excel.getModifications_(handle);\r
+\r
+ session.asyncRequest(new WriteRequest() {\r
+\r
+ @Override\r
+ public void perform(WriteGraph graph) throws DatabaseException {\r
+\r
+ String[] parts = (modis+"0").split("#");\r
+ \r
+ Range range = SpreadsheetUtils.decodeRange(parts[0]);\r
+ \r
+ Layer0 L0 = Layer0.getInstance(graph);\r
+ SpreadsheetResource SHEET = SpreadsheetResource.getInstance(graph);\r
+ \r
+ int index = 1;\r
+ for(int i=0;i<range.height();i++) {\r
+ for(int j=0;j<range.width();j++) {\r
+ \r
+ String addr = SpreadsheetUtils.cellName(range.startRow + i, range.startColumn + j);\r
+ String content = parts[index++];\r
+ \r
+ Resource cell = Layer0Utils.getPossibleChild(graph, container, addr);\r
+ if(cell != null) {\r
+ Variant newValue = Variant.ofInstance(content);\r
+ Variant existing = graph.getRelatedValue(cell, SHEET.Cell_content, Bindings.VARIANT);\r
+ if(!newValue.equals(existing)) {\r
+ graph.claimLiteral(cell, SHEET.Cell_content, SHEET.Cell_content_Inverse, L0.Variant, newValue, Bindings.VARIANT);\r
+ }\r
+ } else {\r
+ cell = graph.newResource();\r
+ graph.claim(cell, L0.InstanceOf, null, SHEET.TextCell);\r
+ graph.addLiteral(cell, L0.HasName, L0.NameOf, L0.String, addr, Bindings.STRING);\r
+ graph.addLiteral(cell, SHEET.Cell_content, SHEET.Cell_content_Inverse, L0.Variant, Variant.ofInstance(content), Bindings.VARIANT);\r
+ graph.claim(cell, L0.PartOf, container);\r
+ }\r
+ \r
+ }\r
+ }\r
+ \r
+ for(int i=1;i<parts.length;i++) {\r
+// String addr = parts[i];\r
+// String content = parts[i+1];\r
+// \r
+// Layer0 L0 = Layer0.getInstance(graph);\r
+// SpreadsheetResource SHEET = SpreadsheetResource.getInstance(graph);\r
+// \r
+// Resource cell = Layer0Utils.getPossibleChild(graph, container, addr);\r
+// if(cell != null) {\r
+// Variant newValue = Variant.ofInstance(content);\r
+// Variant existing = graph.getRelatedValue(cell, SHEET.Cell_content, Bindings.VARIANT);\r
+// if(!newValue.equals(existing))\r
+// graph.claimLiteral(cell, SHEET.Cell_content, SHEET.Cell_content_Inverse, L0.Variant, newValue, Bindings.VARIANT);\r
+// } else {\r
+// cell = graph.newResource();\r
+// graph.claim(cell, L0.InstanceOf, null, SHEET.TextCell);\r
+// graph.addLiteral(cell, L0.HasName, L0.NameOf, L0.String, addr, Bindings.STRING);\r
+// graph.addLiteral(cell, SHEET.Cell_content, SHEET.Cell_content_Inverse, L0.Variant, Variant.ofInstance(content), Bindings.VARIANT);\r
+// graph.claim(cell, L0.PartOf, container);\r
+// }\r
+ \r
+\r
+ }\r
+ \r
+ \r
+ }\r
+ \r
+ });\r
+ \r
+// System.err.println("excel.setString " + value);\r
+ \r
+ } else if("Excel".equals(location) && "Visible".equals(property) && value instanceof Boolean) {\r
+\r
+ Boolean visible = (Boolean)value;\r
+ if(visible) {\r
+ \r
+ try {\r
+ if(handle == 0) {\r
+ \r
+ Excel excel = Excel.getInstance(System.out);\r
+ String file = excel.getFile(bookName);\r
+ FileUtils.ensureParentDirectoryExists(file);\r
+ \r
+ //String sheetName2 = sheetName;//(sheetName + UUID.randomUUID().toString()).substring(0,30);\r
+ String sheetName2 = (bookName + "_" + sheetName).substring(0,30).replace(".", "_");\r
+ \r
+ String handleString = excel.open_(file, sheetName2);\r
+ try {\r
+ handle = Integer.valueOf(handleString);\r
+ } catch (NumberFormatException e) {\r
+ ShowMessage.showError("Problems with Excel", handleString);\r
+ Logger.defaultLogError(new RuntimeException(handleString));\r
+ return;\r
+ }\r
+// System.err.println("excel.open " + (name + ".xlsx"));\r
+ \r
+ for(Pair<String, Object> label : model.listAll(ClientModel.LABEL)) {\r
+ try {\r
+ Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);\r
+ excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);\r
+// System.err.println("excel.setString " + label.second);\r
+ } catch (CellParseException e) {\r
+ }\r
+ }\r
+ for(Pair<String, Object> label : model.listAll(ClientModel.CONTENT)) {\r
+ try {\r
+ Range range = SpreadsheetUtils.decodeCellAbsolute(label.first);\r
+ //excel.setString_(handle, range.startRow, range.startColumn, (String)label.second);\r
+ \r
+ String uri = (String)label.second;\r
+ if(uri.startsWith(prefix)) {\r
+ String rvi = uri.substring(prefix.length()+1).replace("#", "_").replace("(", "_").replace(")", "_").replace("+", "p").replace("-", "m");\r
+ excel.setName_(handle, range.startRow, range.startColumn, rvi);\r
+// System.err.println("excel.setCellName '" + rvi + "'");\r
+ }\r
+ \r
+ } catch (CellParseException e) {\r
+ }\r
+ }\r
+ \r
+ }\r
+ } catch (Throwable t) {\r
+ Logger.defaultLogError(t);\r
+ }\r
+ \r
+ } else {\r
+\r
+ try {\r
+// doClose();\r
+ if(handle != 0) {\r
+ Excel excel = Excel.getInstance(System.out); \r
+ handle = excel.close_(handle);\r
+ handle = 0;\r
+ }\r
+ } catch (Throwable t) {\r
+ Logger.defaultLogError(t);\r
+ }\r
+ \r
+ }\r
+// excel.setVisible_(handle, (Boolean)value);\r
+// System.err.println("excel.setVisible " + value);\r
+ }\r
+ }\r
+ \r
+// @Override\r
+// public void changed(int row, int column, Cell cell) {\r
+//\r
+// String value = cell != null ? cell.toString() : "";\r
+// if(value == null) value = "...";\r
+// excel.setString_(handle, row, column, value);\r
+// \r
+// }\r
+\r
+}\r