Changes between Version 10 and Version 11 of EpochFieldPlugin


Ignore:
Timestamp:
Apr 8, 2012, 5:24:03 AM (3 years ago)
Author:
matobaa
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • EpochFieldPlugin

    v10 v11  
    44
    55[[PageOutline]]
    6 this plugin has two functionality:
    7  1. Timezone sensitive date&time field
    8  2. date&time presentation in report
     6this plugin has two functionality: / 以下の二機能があります:
     7 1. [#field Timezone sensitive date&time field] / 時差を考慮した時刻フィールド
     8 2. [#report date&time presentation in report] / 時差を考慮したレポート表示
    99
    1010== Bugs/Feature Requests ==
    1111
    1212Existing bugs and feature requests for EpochFieldPlugin are
    13 [report:9?COMPONENT=EpochFieldPlugin here].
     13[report:9?COMPONENT=EpochFieldPlugin here].[[BR]]
     14If you have any issues, create a
     15[http://trac-hacks.org/newticket?component=EpochFieldPlugin&owner=matobaa new ticket]. / 不具合報告は[http://trac-hacks.org/newticket?component=EpochFieldPlugin&owner=matobaa こちら]へ。
    1416
    15 If you have any issues, create a
    16 [http://trac-hacks.org/newticket?component=EpochFieldPlugin&owner=matobaa new ticket].
     17== Get A Plugin or Source ==
    1718
    18 == Download ==
     19Download the zipped source from [download:epochfieldplugin here].[[BR]]
     20You can check out EpochFieldPlugin from [http://trac-hacks.org/svn/epochfieldplugin here] using Subversion, or [source:epochfieldplugin browse the source] with Trac.[[BR]]
     21入手は[download:epochfieldplugin zip], [http://trac-hacks.org/svn/epochfieldplugin Subversion], [source:epochfieldplugin Trac]でどうぞ。
    1922
    20 Download the zipped source from [download:epochfieldplugin here].
    21 
    22 == Source ==
    23 
    24 You can check out EpochFieldPlugin from [http://trac-hacks.org/svn/epochfieldplugin here] using Subversion, or [source:epochfieldplugin browse the source] with Trac.
    25 
    26 == Example ==
     23== Example / 例 ==
    2724=== epoch field === #field
    28 specify '''format=epoch''' for the custom-field in trac.ini as follows(or use CustomFieldAdminPlugin):
     25specify '''format=epoch''' for the custom-field in trac.ini as follows(or use CustomFieldAdminPlugin): / trac.ini または CustomFieldAdminPlugin で、カスタムフィールドの format を epoch と指定します:
    2926{{{
    3027[ticket-custom]
     
    3229due.format = epoch
    3330}}}
    34 this plugin uses [http://keith-wood.name/datetimeEntry.html jquery.datetimeentry.js]. Ctrl-Home to current datetime.
     31this plugin uses [http://keith-wood.name/datetimeEntry.html jquery.datetimeentry.js]. Ctrl-Home to current datetime. / Ctrl-Home で現在日時を入力できます。
    3532
    3633[[Image(ticket.png)]]
    3734
    3835=== epoch report === #report
    39 in trac.ini, specify field-names you want to translate from epoch to datetime-string in regular-expressions, as follows:
     36in trac.ini, specify field-names you want to translate from epoch to datetime-string in regular-expressions, as follows: / trac.ini で 日時表記したいカラム名を正規表現で指定して:
    4037{{{
    4138[epochfield]
     
    4542}}}
    4643
    47 and, for example, report query as:
     44and, for example, report query as: / たとえば以下のようにSQLを書くと、
    4845{{{
    4946select id, summary, ticket.time,
     
    6360) AS c on (c.ticket = ticket.id and c.status = "closed")
    6461}}}
    65 then the epoch field (status change time in above example) shows as datetime string.
     62then the epoch field (status change time in above example) shows as datetime string. / 更新日時といった列を unixtime ではなく日付文字列で表示します。
     63
    6664[[Image(report.png)]]
    6765