SiT! Bugs - SiT!
View Issue Details
0001913SiT!holidayspublic2014-01-24 12:512014-01-24 13:41
Frans 
 
normalminoralways
newopen 
WindowsWindows Server2000+Later
3.67 LTS 
 
0001913: Days to approve : shows the previous day.
holidays.php.
Show the days to approve.
The list shows all the days previous to the requested days
Example: Requested 12/02/2014. Shows 11/02/2014.
The time zone conversion causes this.
The database table has the value 12/02/2014.

Time zone south america.
A user requests holidays.
Show the days to approve.
The list shows all the requested days minus one.
The time zone conversion causes this.


Solution
I added 8 hours to the unixtime in line 114 of holidays.php.

   $dates->date = mysql2date($dates->date, TRUE);
   $dates->date += 8*3600; // Add 8 hours for timezone conversion. Frans


No tags attached.
? holidays.php (11,201) 2014-01-24 12:51
http://bugs.sitracker.org/file_download.php?file_id=236&type=bug
Issue History
2014-01-24 12:51FransNew Issue
2014-01-24 12:51FransFile Added: holidays.php
2014-01-24 13:00FransNote Added: 0004894
2014-01-24 13:20FransNote Added: 0004895
2014-01-24 13:25FransNote Added: 0004896
2014-01-24 13:41FransNote Added: 0004897

Notes
(0004894)
Frans   
2014-01-24 13:00   
The same happens in holiday_request.php: line 63.
(0004895)
Frans   
2014-01-24 13:20   
The same happens in holiday_request.php: line 248 (or 250).
(0004896)
Frans   
2014-01-24 13:25   
The same happens in holiday.php: line 193.
(0004897)
Frans   
2014-01-24 13:41   
holidays.php line 198
change date to ldate
echo ldate('jS F Y', $dates->date);
To show in the right language !