|
|
Placeholder page |
|
|
\ No newline at end of file |
|
|
## Original changes
|
|
|
|
|
|
The Event time zone change set from included:
|
|
|
|
|
|
1. Conversion of the start_date, end_date, registration_start_date, and registration_end_date DATETIME columns to TIMESTAMP
|
|
|
2. Addition of an event_tz VARCHAR column to record the timezone of the event
|
|
|
3. Utility functions to convert the times into the correct timezone on display
|
|
|
4. Changes to the admin pages to set / display timezone information with the event times
|
|
|
5. Changes to the information pages to display timezone information with the event times
|
|
|
6. An additional token to show the event timezone
|
|
|
7. Changes to various system workflow message to display timezone information with event messages
|
|
|
8. Additional fields to the API to show the event timezone
|
|
|
|
|
|
The TIMESTAMP conversion was done so that the front-end interface would require no changes in order to continue working with unknown systems that were not aware of the timezone change (i.e. the event time would appear in the system timezone, but be stored as UTC). This can not be automatically added to the DAO, so systems bypassing the API and BAO work under the assumption that they're in the CRM timezone or the timezone doesn't matter.
|
|
|
|
|
|
## Proposed solution
|
|
|
|
|
|
totten suggests leaving the existing start and end dates as is, and adding additional columns with the offset information in a decided timezone. This will work best for the consideration of "systems bypassing the API and BAO work under the assumption that they're in the CRM timezone or the timezone doesn't matter."
|
|
|
|
|
|
Changes required to support timezones:
|
|
|
|
|
|
1. Addition of DATETIME columns to hold the GMT date & time for indexed sorting:
|
|
|
1. start_date_gmt
|
|
|
2. end_date_gmt
|
|
|
3. registration_start_date_gmt
|
|
|
4. registration_end_date_gmt
|
|
|
2. Addition of an event_tz VARCHAR column to record the timezone of the event †
|
|
|
3. Utility functions to convert the times into the correct timezone on display †
|
|
|
4. Changes to the admin pages to set / display timezone information with the event times ††
|
|
|
1. These need to be adjusted to save the adjusted timezone information to GMT
|
|
|
2. The information entered on these pages is assumed to be in the target time zone of the event and should be saved as such
|
|
|
3. Converted directly to the "your local timezone" version on the summary page
|
|
|
5. Changes to the information pages to display timezone information with the event times ††
|
|
|
1. Reads directly from the pre-existing columns (no change)
|
|
|
2. GMT version is loaded into values in the <time datetime="">tags for possible local time zone conversion scripts</time>
|
|
|
6. An additional token to show the event timezone †
|
|
|
7. Changes to various system workflow message to display timezone information with event messages †
|
|
|
8. Additional fields to the API to show the event timezone †
|
|
|
|
|
|
† Already implemented in original PR
|
|
|
|
|
|
†† Implementation in original PR exists, but will need adjustment |
|
|
\ No newline at end of file |