|Version 10 (modified by matobaa, 4 years ago) (diff)|
Epoch (unix time) field, timezone sensitive
this plugin has two functionality:
- Timezone sensitive date&time field
- date&time presentation in report
If you have any issues, create a new ticket.
Download the zipped source from [download:epochfieldplugin here].
specify format=epoch for the custom-field in trac.ini as follows(or use CustomFieldAdminPlugin):
[ticket-custom] due = text due.format = epoch
this plugin uses jquery.datetimeentry.js. Ctrl-Home to current datetime.
in trac.ini, specify field-names you want to translate from epoch to datetime-string in regular-expressions, as follows:
[epochfield] date_columns = .*_date, .*日付? datetime_columns = .*_datetime, .*日時 time_columns = .*_time, .*時刻
and, for example, 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")
- 15659 by matobaa on 2016-07-11 16:21:25
EpochFieldPlugin: follows changeset:15474
- 15101 by matobaa on 2015-12-07 04:04:46
epochfieldPlugin: add "Epoch" Macro;
- 15088 by matobaa on 2015-12-01 16:00:54
EpochFieldPlugin: fix a bug that epoch format is not hold in custom field admin panel by CustomFieldAdminPlugin