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!

Dependency Graph View Issue ] Relation Graph ] Horizontal ]
related to child of duplicate of

Viewing Issue Simple Details
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  
Assigned To alex
Priority normal Resolution fixed  
Status closed      
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.



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

Powered by Mantis Bugtracker