Changes between Version 10 and Version 11 of EpochFieldPlugin
- Timestamp:
- Apr 8, 2012, 3:24:03 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EpochFieldPlugin
v10 v11 4 4 5 5 [[PageOutline]] 6 this plugin has two functionality: 7 1. Timezone sensitive date&time field8 2. date&time presentation in report6 this plugin has two functionality: / 以下の二機能があります: 7 1. [#field Timezone sensitive date&time field] / 時差を考慮した時刻フィールド 8 2. [#report date&time presentation in report] / 時差を考慮したレポート表示 9 9 10 10 == Bugs/Feature Requests == 11 11 12 12 Existing bugs and feature requests for EpochFieldPlugin are 13 [report:9?COMPONENT=EpochFieldPlugin here]. 13 [report:9?COMPONENT=EpochFieldPlugin here].[[BR]] 14 If 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 こちら]へ。 14 16 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 == 17 18 18 == Download == 19 Download the zipped source from [download:epochfieldplugin here].[[BR]] 20 You 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]でどうぞ。 19 22 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 / 例 == 27 24 === epoch field === #field 28 specify '''format=epoch''' for the custom-field in trac.ini as follows(or use CustomFieldAdminPlugin): 25 specify '''format=epoch''' for the custom-field in trac.ini as follows(or use CustomFieldAdminPlugin): / trac.ini または CustomFieldAdminPlugin で、カスタムフィールドの format を epoch と指定します: 29 26 {{{ 30 27 [ticket-custom] … … 32 29 due.format = epoch 33 30 }}} 34 this plugin uses [http://keith-wood.name/datetimeEntry.html jquery.datetimeentry.js]. Ctrl-Home to current datetime. 31 this plugin uses [http://keith-wood.name/datetimeEntry.html jquery.datetimeentry.js]. Ctrl-Home to current datetime. / Ctrl-Home で現在日時を入力できます。 35 32 36 33 [[Image(ticket.png)]] 37 34 38 35 === epoch report === #report 39 in trac.ini, specify field-names you want to translate from epoch to datetime-string in regular-expressions, as follows: 36 in trac.ini, specify field-names you want to translate from epoch to datetime-string in regular-expressions, as follows: / trac.ini で 日時表記したいカラム名を正規表現で指定して: 40 37 {{{ 41 38 [epochfield] … … 45 42 }}} 46 43 47 and, for example, report query as: 44 and, for example, report query as: / たとえば以下のようにSQLを書くと、 48 45 {{{ 49 46 select id, summary, ticket.time, … … 63 60 ) AS c on (c.ticket = ticket.id and c.status = "closed") 64 61 }}} 65 then the epoch field (status change time in above example) shows as datetime string. 62 then the epoch field (status change time in above example) shows as datetime string. / 更新日時といった列を unixtime ではなく日付文字列で表示します。 63 66 64 [[Image(report.png)]] 67 65