GanttCalendarPlugin: use iso8601 format for holiday.date column
| @@ -5,6 +5,16 @@ | ||
| 5 | 5 | from trac.admin import IAdminPanelProvider |
| 6 | 6 | from trac.core import Component, implements, TracError |
| 7 | 7 | from trac.env import IEnvironmentSetupParticipant |
| 8 | +from trac.util.datefmt import format_date, parse_date | |
| 9 | +try: | |
| 10 | + from trac.util.datefmt import user_time | |
| 11 | +except ImportError: | |
| 12 | + def user_time(req, func, *args, **kwargs): | |
| 13 | + if 'tzinfo' not in kwargs: | |
| 14 | + kwargs['tzinfo'] = getattr(req, 'tz', None) | |
| 15 | + if 'locale' not in kwargs: | |
| 16 | + kwargs['locale'] = getattr(req, 'locale', None) | |
| 17 | + return func(*args, **kwargs) | |
| 8 | 18 | |
| 9 | 19 | from ganttcalendar.translation import _, add_domain |
| 10 | 20 |
| @@ -45,7 +55,10 @@ | ||
| 45 | 55 | |
| 46 | 56 | if req.method == 'POST': |
| 47 | 57 | if req.args.get('add'): |
| 48 | - keydate = req.args.get('date') | |
| 58 | + keydate = req.args.getfirst('date') | |
| 59 | + keydate = user_time(req, parse_date, keydate) | |
| 60 | + keydate = user_time(req, format_date, keydate, | |
| 61 | + format='iso8601') | |
| 49 | 62 | cursor.execute("SELECT COUNT(*) FROM holiday WHERE date=%s", |
| 50 | 63 | (keydate,)) |
| 51 | 64 | for cnt, in cursor: |
jun66j5
plugins/ganttcalendarplugin/trunk/ganttcalendar/admin.py