提交: 11 - Stats2Excel (svn)

OmegaT の翻訳状況（Statistics）を Excel で表示します。

Commit MetaInfo

• 修订版: 11 (tree)
• 时间: 2014-05-04 14:48:39
• 作者: yu-tang

Log Message

OmegaT 3.1 対応 (#50224)
Excel テンプレートに集計列を追加
テンプレートのバージョンを ini ファイルで管理

更改概述

• added: src-stubs/org/omegat/util/StringUtil.java
• added: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/Settings.java
• modified: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/ExcelModel.java
• modified: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/StandardTemplate.xlt
• modified: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/Bundle.properties
• modified: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/L10n.java
• modified: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/StandardTemplate.xltx
• modified: src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/Bundle_ja.properties

差异

--- src-stubs/org/omegat/util/StringUtil.java	(nonexistent)
+++ src-stubs/org/omegat/util/StringUtil.java	(revision 11)
@@ -0,0 +1,26 @@
+/**************************************************************************
+  This code is only a stub.
+ **************************************************************************/
+
+package org.omegat.util;
+
+/**
+ * Utilities for string processing.
+ * 
+ * @author Maxym Mykhalchuk
+ * @author Didier Briel
+ * @author Tiago Saboga
+ * @author Zoltan Bartko
+ * @author Andrzej Sawula
+ * @author Alex Buloichik ([e-mail])
+ */
+public class StringUtil {
+
+    /**
+     * Check if string is empty, i.e. null or length==0
+     */
+    public static boolean isEmpty(final String str) {
+        throw new UnsupportedOperationException("This method is only a stub.");
+    }
+
+}

--- src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/Settings.java	(nonexistent)
+++ src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/Settings.java	(revision 11)
@@ -0,0 +1,92 @@
+/**************************************************************************
+ Stats2Excel - open Statistics with Excel from standard Tools menu.
+ 
+ Copyright (C) 2014 Yu Tang
+               Home page: http://sourceforge.jp/users/yu-tang/
+               Support center: http://sourceforge.jp/users/yu-tang/
+
+ This file is part of plugin for OmegaT.
+ http://www.omegat.org/
+
+ License: GNU GPL version 3 or (at your option) any later version.
+
+ 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 jp.sourceforge.users.yutang.omegat.plugin.stats2excel;
+
+import java.io.BufferedReader;
+import java.io.BufferedWriter;
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.FileWriter;
+import java.io.IOException;
+import java.io.InputStreamReader;
+import java.io.Writer;
+import java.util.Properties;
+import org.omegat.util.OConsts;
+
+/**
+ *
+ * @author Yu-Tang
+ */
+public class Settings {
+    
+    private final File file;
+    private final Properties properties;
+
+    // Key
+    private final String TEMPLATE_VERSION = "TemplateVersion";
+
+    public Settings(File file) throws IOException {
+        this.file = file;
+        properties = new Properties(getDefaultProperties());
+
+        if (file.isFile()) {
+            BufferedReader reader = null;
+            try {
+                FileInputStream in = new FileInputStream(file);
+                reader  = new BufferedReader(new InputStreamReader(in, OConsts.UTF8));
+                properties.load(reader);
+            } finally {
+                try {
+                    if (reader != null) {
+                        reader.close();
+                    }
+                } catch(IOException ex) { /* ignore */ }
+            }
+        }
+    }
+
+    public String getTemplateVersion() {
+        return properties.getProperty(TEMPLATE_VERSION);
+    }
+
+    public void setTemplateVersion(String versionString) {
+        properties.setProperty(TEMPLATE_VERSION, versionString);
+    }
+
+    public void save() throws IOException {
+        Writer writer = null;
+        try {
+            writer = new BufferedWriter(new FileWriter(file));
+            properties.store(writer, null);
+        } finally {
+            try {
+                if (writer != null) {
+                    writer.close();
+                }
+            } catch(IOException ex) { /* ignore */ }
+        }
+    }
+
+    private Properties getDefaultProperties() {
+        Properties p = new Properties();
+
+        // set default property here
+        p.setProperty(TEMPLATE_VERSION, "V1");
+
+        return p;
+    }
+}

--- src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/ExcelModel.java	(revision 10)
+++ src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/ExcelModel.java	(revision 11)
@@ -19,15 +19,19 @@
 import java.io.ByteArrayInputStream;
 import java.io.ByteArrayOutputStream;
 import java.io.File;
+import java.io.FileNotFoundException;
 import java.io.IOException;
 import java.io.InputStream;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.List;
+import javax.swing.JOptionPane;
+import org.omegat.core.Core;
 import org.omegat.util.LFileCopy;
 import org.omegat.util.Log;
 import org.omegat.util.OConsts;
 import org.omegat.util.StaticUtils;
+import org.omegat.util.StringUtil;
 
 /**
  *
@@ -39,11 +43,16 @@
     private static final String LEGACY_STANDARD_TEMPLATE_NAME = "StandardTemplate.xlt";
     private static final String STANDARD_TEMPLATE_NAME = "StandardTemplate.xltx";
     private static final String TXT_NAME = "Stats2Excel.txt";
+    private static final String SETTINGS_FILE_NAME = "Stats2Excel.ini";
     private static final File _wsf;
     private static final File _txt;
     private static String windowTitle;
     private static int installedExcelVersion;
 
+    private static enum TemplateVersion {
+        NA, CUSTOMIZED, V1, V2
+    }
+
     public static final int INSTALLED_VERSION_NOT_FOUND = -1;
 
     static {
@@ -145,10 +154,45 @@
                 LEGACY_STANDARD_TEMPLATE_NAME; // Excel 2003 or earlier
         File template = new File(parent, templateName);
 
-        if (! template.exists()) {
+        // check if we should replace the template file with the latest one.
+        final Settings settings = new Settings(new File(parent, SETTINGS_FILE_NAME));
+        TemplateVersion ver = getTemplateVersion(settings, template);
+        switch (ver) {
+            case NA:
+                // File not found, version not available.
+                break;
+            case V1:
+                // Probably older version is found. Ask user for upgrade.
+                String msg = L10n.getUpdateTemplateDialogMessage();
+                String title = L10n.getUpdateTemplateDialogTitle();
+                int ret = Core.getMainWindow().showConfirmDialog(msg, title,
+                        JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
+                if (ret == JOptionPane.YES_OPTION) {
+                    template.delete();
+                } else {
+                    // set template version setting to CUSTOMIZED
+                    settings.setTemplateVersion(TemplateVersion.CUSTOMIZED.name());
+                    settings.save();
+                }
+                break;
+            case V2:
+                // OK, we have the latest version. Go on.
+                break;
+            case CUSTOMIZED:
+                // Maybe user uses the customized template file. Don't touch it.
+                break;
+            default:
+                // We shouldn't have come here. Something is wrong.
+                throw new IOException("Unknown Template Version Error: " + ver.toString());
+        }
+
+        if (!template.exists()) {
             InputStream in = ExcelModel.class.getResourceAsStream(templateName);
             try {
                 LFileCopy.copy(in, template);
+
+                settings.setTemplateVersion(TemplateVersion.V2.name());
+                settings.save();
             } finally {
                 in.close();
             }
@@ -156,6 +200,23 @@
         return template;
     }
 
+    private static TemplateVersion getTemplateVersion(Settings settings, File template) throws IOException {
+        if (!template.isFile()) {
+            return TemplateVersion.NA;
+        }
+
+        String ver = settings.getTemplateVersion();
+        if (StringUtil.isEmpty(ver)) {
+            return TemplateVersion.V1;
+        } else {
+            try {
+                return TemplateVersion.valueOf(ver);
+            } catch (IllegalArgumentException ex) {
+                return TemplateVersion.V1;
+            }
+        }
+    }
+
     private static File getWSF() throws IOException {
         if (! _wsf.exists()) {
             InputStream in = ExcelModel.class.getResourceAsStream(WSF_NAME);

--- src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/L10n.java	(revision 10)
+++ src/jp/sourceforge/users/yutang/omegat/plugin/stats2excel/L10n.java	(revision 11)
@@ -42,6 +42,16 @@
         return bundle.getString("S2E_EXCEL_WINDOW_TITLE");
     }
 
+    // Update template dialog
+
+    public static String getUpdateTemplateDialogTitle() {
+        return bundle.getString("S2E_UPDATE_TEMPLATE_DIALOG_TITLE");
+    }
+
+    public static String getUpdateTemplateDialogMessage() {
+        return bundle.getString("S2E_UPDATE_TEMPLATE_DIALOG_MESSAGE");
+    }
+
     // Error
 
     public static String getLoadingErrorFormat() {