= Epoch (unix time) field, timezone sensitive =

== Description ==

[[PageOutline]]
this plugin has two functionality:
 1. Timezone sensitive date&time field
 2. date&time presentation in report

== Bugs/Feature Requests == 

Existing bugs and feature requests for EpochFieldPlugin are 
[report:9?COMPONENT=EpochFieldPlugin here].

If you have any issues, create a 
[http://trac-hacks.org/newticket?component=EpochFieldPlugin&owner=matobaa new ticket].

== Download ==

Download the zipped source from [download: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.

== Example ==
=== epoch field === #field
trac.ini (or CustomFieldAdminPlugin):
{{{
[ticket-custom]
due = text
due.format = epoch
}}}
this plugin uses [http://keith-wood.name/datetimeEntry.html jquery.datetimeentry.js]. Ctrl-Home to current datetime.

[[Image(ticket.png)]]

=== epoch report === #report
in trac.ini:
{{{
[epochfield]
date_columns = .*_date, .*日付?
datetime_columns = .*_datetime, .*日時
time_columns = .*_time, .*時刻
}}}
report query as:
{{{
select id, summary, ticket.time,
    a.time as accepted_datetime,
    c.time as closed_datetime,
    c.author as Closer
from ticket
left join (
    SELECT ticket, author, newvalue AS status, max(time) AS time
        FROM ticket_change WHERE field = 'status' and status = 'accepted'
        GROUP BY ticket, newvalue
) AS a on (a.ticket = ticket.id and a.status = "accepted")
left join (
    SELECT ticket, author, newvalue AS status, max(time) AS time
        FROM ticket_change WHERE field = 'status' and status = 'closed'
        GROUP BY ticket, newvalue
) AS c on (c.ticket = ticket.id and c.status = "closed")
}}}
[[Image(report.png)]]

== Recent Changes ==

[[ChangeLog(epochfieldplugin, 3)]]

== Author/Contributors ==

'''Author:''' [wiki:matobaa] [[BR]]
'''Maintainer:''' [wiki:matobaa] [[BR]]
'''Contributors:'''