In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details Jump to Notes ] Wiki ]  Related Changesets ] View Advanced ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000058 [In-Portal CMS] Data Management feature request N/A 2009-06-08 11:26 2012-07-25 05:32
Reporter alex View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.2.0-B1
Status closed Product Version 5.1.0 Target Version 5.2.0
Time EstimateNo estimate
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.

2. During installation set both timezones (2 configuration settings in Advanced configuration section) to current server timezone. - done in 0000743 issue

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.
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.
Tags No tags attached.
Reference
Change Log Message
Estimate Points 1
Attached Files patch file icon user_timezone_core_58.patch [^] (22,853 bytes) 2012-01-04 09:02 [Show Content]
patch file icon user_timezone_theme_58.patch [^] (15,036 bytes) 2012-01-04 09:02 [Show Content]
patch file icon user_timezone_core_v2.patch [^] (23,145 bytes) 2012-01-05 05:16 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to 0000743closed (5.1.0)alex Incorrect daylight time saving, when server timezone differs from site timezone 
related to 0001201closed (5.2.0)alex Fatal error during Installation on States import with MySQL in Strict Mode 

-  Notes
User avatar (0000039)
Dmitry (manager)
2009-06-08 11:44

Sounds like a good, useful feature!
User avatar (0002769)
Dmitry (manager)
2010-09-05 20:57

Isn't it "2. During installation set both timezones (2 configuration settings in Advanced configuration section) to current server timezone." already completed?
User avatar (0004387)
erik (manager)
2012-01-04 09:03

Patches attached - needs testing.
User avatar (0004388)
alex (manager)
2012-01-05 05:13

We even can use http://jeoftp.blogspot.com/2009/03/determine-java-timezone-of-your-web.html to auto detect user timezone upon registration (like vBulletin does). But we need to convert GMT+ into Americas/Chicago format somehow.
User avatar (0004389)
alex (manager)
2012-01-05 05:17

Fix committed to 5.2.x branch. Commit Message:

Fixes 0000058: Add Timezone Field to User record
Commit on behalf of Erik
User avatar (0005000)
alex (manager)
2012-07-25 05:32

Since 5.2.0 version was released.

- Related Changesets
In-Portal CMS: 5.2.x r14994
Timestamp: 2012-01-05 05:17:53
Author: alex
Details ] Diff ]
Fixes 0000058: Add Timezone Field to User record
Commit on behalf of Erik
mod - /in-portal/branches/5.2.x/admin/system_presets/simple/users_u.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/admin_templates/config/custom_variables.tpl Diff ] File ]
mod - /in-portal/branches/5.2.x/core/admin_templates/incs/form_blocks.tpl Diff ] File ]
mod - /in-portal/branches/5.2.x/core/admin_templates/users/admins_edit.tpl Diff ] File ]
mod - /in-portal/branches/5.2.x/core/admin_templates/users/users_edit.tpl Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/english.lang Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_data.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_schema.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/upgrades.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/application.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/user_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/users/users_config.php Diff ] File ]
Themes :: Advanced: 1.2.x r14993
Timestamp: 2012-01-05 05:17:08
Author: alex
Details ] Diff ]
Bug 0000058: Add Timezone Field to User record
Commit on behalf of Erik
mod - /themes/advanced/branches/1.2.x/platform/elements/forms.elm.tpl Diff ] File ]
mod - /themes/advanced/branches/1.2.x/platform/inc/script.js Diff ] File ]
mod - /themes/advanced/branches/1.2.x/platform/login/register.tpl Diff ] File ]
mod - /themes/advanced/branches/1.2.x/platform/my_account/my_profile.tpl Diff ] File ]

- 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 View Revisions
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 View Revisions
2010-09-06 05:35 alex Description Updated View Revisions
2010-09-06 05:33 alex Status needs feedback => needs work
2010-09-06 05:33 alex Description Updated View Revisions
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 View Revisions
2009-06-08 11:26 alex New Issue



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker