Fax server TimeZoe

Status
Not open for further replies.

MTR

Member
Oct 25, 2017
181
9
18
45
Good afternoon

in the Datebase when i look on the "v_fax_files table the time for each record is on UTC time, now when a uses logs into the portal to see his faxes the time will also display UTC

what is the nest approach to change this to EST time zone
 

paradym

New Member
May 26, 2017
11
1
3
39
Open up the PHP editor and look up fax_files.php

replace these lines
PHP:
//get the list
    $sql = "select * from v_fax_files ";

with these lines
PHP:
//get the domain time zone
    $time_zone= array_values($_SESSION['time_zone'])[0];
    if ($time_zone == "") $time_zone = 'UTC';

//get the list
    //$sql = "select * from v_fax_files ";
    $sql = "select *, fax_date AT TIME ZONE 'UTC' AT TIME ZONE '".$time_zone."' as fax_time ";
    $sql .= "from v_fax_files ";

Then search for instances of fax_date and replace them with fax_time (but leave the label alone). There are 3 instances.

You'll also need to have your time_zone variable set in default settings, or in the domain settings.
 
Last edited:
Status
Not open for further replies.