In-Portal Issue Tracker - In-Portal CMS
|
|||||||||||||||
Viewing Issue Advanced Details | |||||||||||||||
|
|||||||||||||||
ID: | Category: | Type: | Reproducibility: | Date Submitted: | Last Update: | ||||||||||
58 | [In-Portal CMS] Data Management | feature request | N/A | 2009-06-08 11:26 | 2012-07-25 05:32 | ||||||||||
|
|||||||||||||||
Reporter: | alex | Platform: | |||||||||||||
Assigned To: | alex | OS: | |||||||||||||
Priority: | normal | OS Version: | |||||||||||||
Status: | closed | Product Version: | 5.1.0 | ||||||||||||
Product Build: | Resolution: | fixed | |||||||||||||
ETA: | none | Fixed in Version: | 5.2.0-B1 | ||||||||||||
Reference: | |||||||||||||||
Change Log Message: | |||||||||||||||
Estimate Points: | 1 | ||||||||||||||
|
|||||||||||||||
Summary: | 0000058: Add Timezone Field to User record | ||||||||||||||
Description: |
1. Add Timezone field to user record (dropdown), default to empty value which means user is in same timezone with webserver. 3. When user authenticates on site (performs login) store it's timezone (if any) to session for easy access in future. In case if user haven't selected timezone, then user server timezone (as now) for calculations. |
||||||||||||||
Steps To Reproduce: | |||||||||||||||
Additional Information: |
Plan: 1. remove "tz" column from PortalUser table 2. add TimeZone column (varchar(255)) into PortalUser table 3. use same control as for website timezone entering (2 dropdowns in a row) 4. display new TimeZone field on both user/admin editing screens in admin and on user registration/my profile forms on front-end 5. hide new TimeZone field from user/admin editing form by default via simple interface preset 6. in kApplication::ValidateLogin method do putenv('TZ=<time_zone_string_here>') (http://www.php.net/manual/ru/function.putenv.php#11811) only when user has selected his timezone. 7. all timestamps in db are always in UTC, so no additional timestamp processing except putenv is needed 8. create 2 users with different timezones (different from each other and from server) and verify that each of them properly sees dates (e.g. link submission date) from other user actions. 9. create user without a timezone set and verify that he still works as before this task implementation. |
||||||||||||||
Relationships |
| ||||||||||||||
Attached Files: |
user_timezone_core_58.patch (22,853) 2012-01-04 09:02 http://tracker.in-portal.org/file_download.php?file_id=1463&type=bug user_timezone_theme_58.patch (15,036) 2012-01-04 09:02 http://tracker.in-portal.org/file_download.php?file_id=1464&type=bug user_timezone_core_v2.patch (23,145) 2012-01-05 05:16 http://tracker.in-portal.org/file_download.php?file_id=1465&type=bug |
||||||||||||||
|
|||||||||||||||
Issue History | |||||||||||||||
Date Modified | Username | Field | Change | ||||||||||||
2012-07-25 05:32 | alex | Note Added: 0005000 | |||||||||||||
2012-07-25 05:32 | alex | Status | resolved => closed | ||||||||||||
2012-02-06 04:05 | alex | Relationship added | related to 0001201 | ||||||||||||
2012-01-05 05:17 | alex | Changeset attached | 5.2.x r14994 | ||||||||||||
2012-01-05 05:17 | alex | Note Added: 0004389 | |||||||||||||
2012-01-05 05:17 | alex | Status | reviewed and tested => resolved | ||||||||||||
2012-01-05 05:17 | alex | Fixed in Version | => 5.2.0-B1 | ||||||||||||
2012-01-05 05:17 | alex | Resolution | open => fixed | ||||||||||||
2012-01-05 05:17 | alex | Assigned To | !COMMUNITY => alex | ||||||||||||
2012-01-05 05:17 | alex | Changeset attached | 1.2.x r14993 | ||||||||||||
2012-01-05 05:16 | alex | File Added: user_timezone_core_v2.patch | |||||||||||||
2012-01-05 05:13 | alex | Assigned To | alex => !COMMUNITY | ||||||||||||
2012-01-05 05:13 | alex | Status | needs testing => reviewed and tested | ||||||||||||
2012-01-05 05:13 | alex | Note Added: 0004388 | |||||||||||||
2012-01-04 11:20 | Dmitry | Target Version | Icebox => 5.2.0 | ||||||||||||
2012-01-04 09:03 | erik | Note Added: 0004387 | |||||||||||||
2012-01-04 09:03 | erik | Assigned To | erik => alex | ||||||||||||
2012-01-04 09:03 | erik | Developer | => erik | ||||||||||||
2012-01-04 09:03 | erik | Status | needs work => needs testing | ||||||||||||
2012-01-04 09:02 | erik | File Added: user_timezone_theme_58.patch | |||||||||||||
2012-01-04 09:02 | erik | File Added: user_timezone_core_58.patch | |||||||||||||
2012-01-04 02:23 | alex | Estimate Points | 0 => 1 | ||||||||||||
2012-01-04 02:23 | alex | Additional Information Updated | bug_revision_view_page.php?rev_id=957#r957 | ||||||||||||
2012-01-03 17:33 | Dmitry | Estimate Points | => 0 | ||||||||||||
2012-01-03 17:33 | Dmitry | Assigned To | alex => erik | ||||||||||||
2010-09-06 05:35 | alex | Relationship added | related to 0000743 | ||||||||||||
2010-09-06 05:35 | alex | Description Updated | bug_revision_view_page.php?rev_id=561#r561 | ||||||||||||
2010-09-06 05:35 | alex | Description Updated | bug_revision_view_page.php?rev_id=560#r560 | ||||||||||||
2010-09-06 05:33 | alex | Status | needs feedback => needs work | ||||||||||||
2010-09-06 05:33 | alex | Description Updated | bug_revision_view_page.php?rev_id=559#r559 | ||||||||||||
2010-09-05 20:57 | Dmitry | Note Added: 0002769 | |||||||||||||
2010-09-05 20:57 | Dmitry | Assigned To | => alex | ||||||||||||
2010-09-05 20:57 | Dmitry | Status | active => needs feedback | ||||||||||||
2010-08-31 14:28 | alex | version | => 5.1.0 | ||||||||||||
2009-06-08 11:44 | Dmitry | Note Added: 0000039 | |||||||||||||
2009-06-08 11:44 | Dmitry | Target Version | => Icebox | ||||||||||||
2009-06-08 11:44 | Dmitry | Summary | Add Timezone field to user record. => Add Timezone Field to User record | ||||||||||||
2009-06-08 11:44 | Dmitry | Description Updated | bug_revision_view_page.php?rev_id=34#r34 | ||||||||||||
2009-06-08 11:26 | alex | New Issue |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|