Changes between Version 19 and Version 20 of EpochFieldPlugin

Timestamp:

Nov 11, 2015, 10:18:12 AM (8 years ago)

Author:

figaro

Comment:

Cosmetic changes

EpochFieldPlugin

@@ -5 +5 @@
 == Description
 
-'''Note''': in this page, after slashes, descriptions in japanese-KANJI are added.
+'''Note''': on this page descriptions in japanese-Kanji are added after slashes (/).
 
 '''This plugin will conflict in Trac 1.1.1. see trac:wiki:/TracDev/Proposals/TracTicketsCustomTimeFields and trac:ticket:1942. '''
@@ -16 +16 @@
 
 Existing bugs and feature requests for EpochFieldPlugin are 
-[report:9?COMPONENT=EpochFieldPlugin here].[[BR]]
+[report:9?COMPONENT=EpochFieldPlugin here].
 
 If you have any issues, create a 
-[http://trac-hacks.org/newticket?component=EpochFieldPlugin&owner=matobaa new ticket]. / 不具合報告は[http://trac-hacks.org/newticket?component=EpochFieldPlugin&owner=matobaa こちら]へ。
+[/newticket?component=EpochFieldPlugin new ticket]. / 不具合報告は[/newticket?component=EpochFieldPlugin こちら]へ。
 
 [[TicketQuery(component=EpochFieldPlugin,group=type,format=progress)]]
@@ -25 +25 @@
 == Download
 
-Download the zipped source from [download:epochfieldplugin here].[[BR]]
+Download the zipped source from [export:epochfieldplugin here].
 
 == Source
 
-You can check out EpochFieldPlugin from [http://trac-hacks.org/svn/epochfieldplugin here] using Subversion, or [source:epochfieldplugin browse the source] with Trac.[[BR]]
-入手は[download:epochfieldplugin zip], [http://trac-hacks.org/svn/epochfieldplugin Subversion], [source:epochfieldplugin Trac]でどうぞ。
+You can check out EpochFieldPlugin from [/svn/epochfieldplugin here] using Subversion, or [source:epochfieldplugin browse the source] with Trac.
+
+入手は[export:epochfieldplugin zip], [/svn/epochfieldplugin Subversion], [source:epochfieldplugin Trac]でどうぞ。
 
 == Example / 例
@@ -36 +37 @@
 === Epoch field === #field
 
-Specify '''format=epoch''' for the custom-field in trac.ini as follows or use CustomFieldAdminPlugin: / trac.ini または CustomFieldAdminPlugin で、カスタムフィールドの format を epoch と指定します:
-{{{
-#!ini
+Specify '''format=epoch''' for the custom-field in `trac.ini` as follows or use CustomFieldAdminPlugin: / `trac.ini` または CustomFieldAdminPlugin で、カスタムフィールドの format を epoch と指定します:
+{{{#!ini
 [ticket-custom]
 due = text
@@ -51 +51 @@
 
 In the `trac.ini` file specify the field-names you want to translate from epoch to datetime-string in regular-expressions as follows: / trac.ini で 日時表記したいカラム名を正規表現で指定して:
-{{{
-#!ini
+{{{#!ini
 [epochfield]
 date_columns = .*_date, .*日付?
@@ -60 +59 @@
 
 And, for example, create a report query as follows: / たとえば以下のようにSQLを書くと、
-{{{
-#!sql
+{{{#!sql
 SELECT id, summary, ticket.time,
-    a.time as accepted_datetime,
-    c.time as closed_datetime,
-    c.author as Closer
+    a.time AS accepted_datetime,
+    c.time AS closed_datetime,
+    c.author AS Closer
 FROM ticket
 LEFT JOIN (
@@ -73 +71 @@
         GROUP BY ticket, newvalue, author
 ) AS a ON (a.ticket = ticket.id AND a.status = 'accepted')
-left join (
+LEFT JOIN (
     SELECT ticket, author, newvalue AS status, MAX(time) AS time
         FROM ticket_change