<?php
/**
 * @package		SectionEx
 * @copyright	Copyright (C) 2008 Robert Kuster. All rights reserved.
 * @license		GNU/GPL, see LICENSE.php
 * @link        http://www.stackideas.com  
 *
 * SectionEx is free software. This version may have been modified pursuant
 * to the GNU General Public License, and as distributed it includes or
 * is derivative of works licensed under the GNU General Public License or
 * other free or open source software licenses.
 * See COPYRIGHT.php for copyright notices and details.
 */ 
 
// no direct access
defined('_JEXEC') or die('Restricted access');

class SExDateHelper 
{		
	function sec_to_DB_time($seconds) {
		$negative = 0;
		if ($seconds < 0){
			$seconds = abs($seconds);
			$negative = 1;
		}
	    $hours = floor($seconds / 3600);
	    $minutes = floor($seconds % 3600 / 60);
	    $seconds = $seconds % 60;
	    
	    if($negative == 1){
	    	$hours = 0 - $hours;
	    }
	    return sprintf("%d:%02d:%02d", $hours, $minutes, $seconds);
	}
	function get_user_DB_tz_offset_relative_to_joomla_tz_offset() 
	{		
		$user =& JFactory::getUser();
		if ($user->id != 0)
		{	// -> logged-in user
			global $mainframe;
			$joomlaTimeZone  = $mainframe->getCfg('offset');				// joomla (global) time-zone set in the back-end
			$userTimeZone = $user->getParam('timezone', $joomlaTimeZone);	// user time-zone

			return SExDateHelper::sec_to_DB_time(($userTimeZone - $joomlaTimeZone) * 60 * 60);
		}
		
		// guests always use the global joomla time zone (no ofset)
		return SExDateHelper::sec_to_DB_time(0);
	}
}