Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-48

Add Timezone Field to User record

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1.0
    • Fix Version/s: 5.2.0-B1
    • Component/s: Data Management
    • Labels:
      None
    • Additional information:
      Hide

      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>') ([url]http://www.php.net/manual/ru/function.putenv.php#11811[/url]) 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.

      Show
      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>') ( [url] http://www.php.net/manual/ru/function.putenv.php#11811[/url]) 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.
    • Story Points:
      1
    • External issue ID:
      58
    • Copy Issue Key:
    • Patch Instructions:

      Patches must be submitted through Phabricator.

      Description

      1. Add Timezone field to user record (dropdown), default to empty value which means user is in same timezone with webserver.

      [DEL]2. During installation set both timezones (2 configuration settings in Advanced configuration section) to current server timezone.[/DEL] - [B]done in #0000743 issue[/B]

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Erik Snarski [Intechnic]
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: