DateTimeUtil.php

<?php
    /*********************************************************************************
     * Zurmo is a customer relationship management program developed by
     * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
     *
     * Zurmo is free software; you can redistribute it and/or modify it under
     * the terms of the GNU Affero General Public License version 3 as published by the
     * Free Software Foundation with the addition of the following permission added
     * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
     * IN WHICH THE COPYRIGHT IS OWNED BY ZURMO, ZURMO DISCLAIMS THE WARRANTY
     * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
     *
     * Zurmo is distributed in the hope that it will be useful, but WITHOUT
     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
     * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
     * details.
     *
     * You should have received a copy of the GNU Affero General Public License along with
     * this program; if not, see http://www.gnu.org/licenses or write to the Free
     * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
     * 02110-1301 USA.
     *
     * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive
     * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
     *
     * The interactive user interfaces in original and modified versions
     * of this program must display Appropriate Legal Notices, as required under
     * Section 5 of the GNU Affero General Public License version 3.
     *
     * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
     * these Appropriate Legal Notices must retain the display of the Zurmo
     * logo and Zurmo copyright notice. If the display of the logo is not reasonably
     * feasible for technical reasons, the Appropriate Legal Notices must display the words
     * "Copyright Zurmo Inc. 2017. All rights reserved".
     ********************************************************************************/

    class DateTimeUtil
    {
        const DATETIME_FORMAT_DATE_WIDTH                     = 'short';

        const DATETIME_FORMAT_TIME_WIDTH                     = 'short';

        const DISPLAY_FORMAT_FOR_INPUT                       = 'Display Format For Input';

        const DISPLAY_FORMAT_ABBREVIATED_MONTH_ONLY_WIDTH    = 'Display Format Abbreviated Month';

        const DISPLAY_FORMAT_ABBREVIATED_MONTH_AND_DAY_WIDTH = 'Display Format Abbreviated Month And Day';

        public static function getTimeSinceDisplayContent($dateTime, $durationDisplayFormat = false)
        {
            assert('DateTimeUtil::isValidDbFormattedDateTime($dateTime)');
            $nowTimeStamp           = time();
            $dateTimeStamp          = DateTimeUtil::convertDbFormatDateTimeToTimeStamp($dateTime);
            $timeSinceLatestUpdate  = $nowTimeStamp - $dateTimeStamp;
            $timeForString = array(
                'days'  => floor($timeSinceLatestUpdate / 86400),
                'hours' => floor($timeSinceLatestUpdate / 3600),
                'minutes' => floor($timeSinceLatestUpdate / (60)),
                'seconds' => floor($timeSinceLatestUpdate)
            );

            if ($timeForString['days'] >= 1)
            {
                if ($durationDisplayFormat === true)
                {
                    return Zurmo::t('Core', '{n} day|{n} days', $timeForString['days']);
                }
                else
                {
                    return Zurmo::t('Core', '{n} day ago|{n} days ago', $timeForString['days']);
                }
            }
            else
            {
                if ($timeForString['hours'] >= 1)
                {
                    if ($durationDisplayFormat === true)
                    {
                        return Zurmo::t('Core', '{n} hour|{n} hours', $timeForString['hours']);
                    }
                    else
                    {
                        return Zurmo::t('Core', '{n} hour ago|{n} hours ago', $timeForString['hours']);
                    }
                }
                else
                {
                    if ($timeForString['minutes'] >= 1)
                    {
                        if ($durationDisplayFormat === true)
                        {
                            return Zurmo::t('Core', '{n} minute|{n} minutes', $timeForString['minutes']);
                        }
                        else
                        {
                            return Zurmo::t('Core', '{n} minute ago|{n} minutes ago', $timeForString['minutes']);
                        }
                    }
                    else
                    {
                        if ($durationDisplayFormat === true)
                        {
                            return Zurmo::t('Core', '{n} second|{n} seconds', $timeForString['seconds']);
                        }
                        else
                        {
                            return Zurmo::t('Core', '{n} second ago|{n} seconds ago', $timeForString['seconds']);
                        }
                    }
                }
            }
        }

        public static function getTimeSinceInDays($dateTime)
        {
            assert('DateTimeUtil::isValidDbFormattedDateTime($dateTime)');
            $nowTimeStamp   = time();
            $dateTimeStamp  = DateTimeUtil::convertDbFormatDateTimeToTimeStamp($dateTime);
            $timeSince      = $nowTimeStamp - $dateTimeStamp;
            return floor($timeSince / 86400);
        }

        public static function getMonthName($month)
        {
            if ($month != null)
            {
                return Yii::app()->locale->getMonthName((int)$month);
            }
            return $month;
        }

        public static function getLocaleDateTimeFormat()
        {
            $dateTimePattern = Yii::app()->locale->getDateTimeFormat();
            $timeFormat      = Yii::app()->locale->getTimeFormat(self::DATETIME_FORMAT_TIME_WIDTH);
            $dateFormat      = Yii::app()->locale->getDateFormat(self::DATETIME_FORMAT_DATE_WIDTH);
            return strtr($dateTimePattern, array('{0}' => $timeFormat, '{1}' => $dateFormat));
        }

        public static function getLocaleDateTimeFormatForInput()
        {
            $dateTimePattern = Yii::app()->locale->getDateTimeFormat();
            $timeFormat      = Yii::app()->locale->getTimeFormat(self::DATETIME_FORMAT_TIME_WIDTH);
            $dateFormat      = Yii::app()->locale->getDateFormatForInput(self::DATETIME_FORMAT_DATE_WIDTH);
            return strtr($dateTimePattern, array('{0}' => $timeFormat, '{1}' => $dateFormat));
        }

        public static function getLocaleDateFormat($dateWidth = self::DATETIME_FORMAT_DATE_WIDTH)
        {
            return Yii::app()->locale->getDateFormat($dateWidth);
        }

        public static function getLocaleDateFormatForInput($dateWidth = self::DATETIME_FORMAT_DATE_WIDTH)
        {
            return Yii::app()->locale->getDateFormatForInput($dateWidth);
        }

        public static function getLocaleTimeFormat($timeWidth = self::DATETIME_FORMAT_TIME_WIDTH)
        {
            return Yii::app()->locale->getTimeFormat($timeWidth);
        }

        public static function isLocaleTimeDisplayedAs12Hours()
        {
            $timeFormat = DateTimeUtil::getLocaleTimeFormat();
            if (strpos($timeFormat, 'H') === false)
            {
                return true;
            }
            return false;
        }

        public static function resolveTimeStampForDateTimeLocaleFormattedDisplay($value,
                                    $dateWidth = self::DATETIME_FORMAT_DATE_WIDTH,
                                    $timeWidth = self::DATETIME_FORMAT_TIME_WIDTH,
                                    $forInput = false)
        {
            if ($value == null)
            {
                return null;
            }
            if ($forInput)
            {
                $pattern = static::getLocaleDateTimeFormatForInput();
                return Yii::app()->dateFormatter->format($pattern, $value);
            }
            return Yii::app()->dateFormatter->formatDateTime($value, $dateWidth, $timeWidth);
        }

        public static function resolveValueForDateLocaleFormattedDisplay(
                                    $date, $displayFormat = null)
        {
            if ($date == null)
            {
                return null;
            }
            $parsedTimeStamp = CDateTimeParser::parse($date, DatabaseCompatibilityUtil::getDateFormat());
            if ($parsedTimeStamp === false)
            {
                return null;
            }
            if ($displayFormat == self::DISPLAY_FORMAT_ABBREVIATED_MONTH_ONLY_WIDTH)
            {
                $month = Yii::app()->dateFormatter->format('M', $parsedTimeStamp);
                return Yii::app()->locale->getMonthName($month, 'abbreviated', true);
            }
            elseif ($displayFormat == self::DISPLAY_FORMAT_ABBREVIATED_MONTH_AND_DAY_WIDTH)
            {
                $month    = Yii::app()->dateFormatter->format('M', $parsedTimeStamp);
                $content  = Yii::app()->locale->getMonthName($month, 'abbreviated', true);
                $content .= ' ' . Yii::app()->dateFormatter->format('d', $parsedTimeStamp);
                return $content;
            }
            elseif ($displayFormat == static::DISPLAY_FORMAT_FOR_INPUT)
            {
                return Yii::app()->dateFormatter->format(static::getLocaleDateFormatForInput(self::DATETIME_FORMAT_DATE_WIDTH), $parsedTimeStamp);
            }
            return Yii::app()->dateFormatter->format(static::getLocaleDateFormat(self::DATETIME_FORMAT_DATE_WIDTH), $parsedTimeStamp);
        }

        public static function resolveValueForDateDBFormatted($value)
        {
            if ($value == null)
            {
                return null;
            }
            $localeDateFormat = DateTimeUtil::getLocaleDateFormatForInput();
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                                CDateTimeParser::parse($value, $localeDateFormat));
        }

        public static function convertFromUtcUnixStampByTimeZone($utcTimeStamp, $timeZone)
        {
            assert('is_string($timeZone)');
            $timeZoneObject = new DateTimeZone($timeZone);
            $offset = $timeZoneObject->getOffset(new DateTime());
            return $utcTimeStamp + $offset;
        }

        public static function convertFromLocalUnixStampByTimeZoneToUtcUnixStamp($utcTimeStamp, $timeZone)
        {
            assert('is_string($timeZone)');
            $timeZoneObject = new DateTimeZone($timeZone);
            $offset = $timeZoneObject->getOffset(new DateTime());
            return $utcTimeStamp - $offset;
        }

        public static function convertTimestampToDbFormatDate($timestamp)
        {
            assert('is_int($timestamp)');
            $timeZone = date_default_timezone_get();
            date_default_timezone_set('GMT');
            $result   = Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                                                     $timestamp);
            date_default_timezone_set($timeZone);
            return $result;
        }

        public static function convertTimestampToDbFormatDateTime($timestamp)
        {
            assert('is_int($timestamp)');
            $timeZone = date_default_timezone_get();
            date_default_timezone_set('GMT');
            $result = Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateTimeFormat(),
                                                     $timestamp);
            date_default_timezone_set($timeZone);
            return $result;
        }

        public static function convertDbFormatDateTimeToTimestamp($dbFormatDateTime)
        {
            assert('is_string($dbFormatDateTime)');
            $timeZone = date_default_timezone_get();
            date_default_timezone_set('GMT');
            $result = strtotime($dbFormatDateTime);
            date_default_timezone_set($timeZone);
            return $result;
        }

        public static function convertTimestampToDisplayFormat($timestamp,
                                    $dateWidth = self::DATETIME_FORMAT_DATE_WIDTH,
                                    $timeWidth = self::DATETIME_FORMAT_TIME_WIDTH,
                                    $forInput = false)
        {
            assert('is_int($timestamp)');
            return self::resolveTimeStampForDateTimeLocaleFormattedDisplay($timestamp, $dateWidth, $timeWidth, $forInput);
        }

        public static function isValidDbFormattedDate($date) // Basic version, feel free to enhance.
        {
            if ($date == '0000-00-00')
            {
                return true;
            }
            return preg_match('/^[1-2][0-9][0-9][0-9]-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|[3][0-1])$/',
                        $date) == 1;
        }

        public static function isValidDbFormattedDateTime($datetime) // Basic version, feel free to enhance.
        {
            if ($datetime == '0000-00-00 00:00:00')
            {
                return true;
            }
            return preg_match(  '/^[1-2][0-9][0-9][0-9]-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|[3][0-1]) ' .
                                '(0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]$/',
                                $datetime) == 1;
        }

        public static function convertDbFormattedDateTimeToLocaleFormattedDisplay($dbFormatDateTime,
                                    $dateWidth = self::DATETIME_FORMAT_DATE_WIDTH,
                                    $timeWidth = self::DATETIME_FORMAT_TIME_WIDTH,
                                    $forInput = false)
        {
            assert('is_string($dbFormatDateTime) || $dbFormatDateTime == null');
            if ($dbFormatDateTime == null || $dbFormatDateTime == '0000-00-00 00:00:00')
            {
                return null;
            }
            $timestamp = self::convertDbFormatDateTimeToTimestamp($dbFormatDateTime);
            return self::convertTimestampToDisplayFormat((int)$timestamp, $dateWidth, $timeWidth, $forInput);
        }

        public static function convertDateTimeLocaleFormattedDisplayToDbFormattedDateTimeWithSecondsAsZero($localeFormattedDateTime)
        {
            assert('is_string($localeFormattedDateTime) || $localeFormattedDateTime == null');
            if ($localeFormattedDateTime == null)
            {
                return null;
            }
            $timestamp = CDateTimeParser::parse($localeFormattedDateTime, self::getLocaleDateTimeFormatForInput());
            if ($timestamp == null)
            {
                return null;
            }
            $dbFormattedDateTime =  self::convertTimestampToDbFormatDateTime($timestamp);
            //todo deal with potential diffferent db format
            return substr_replace($dbFormattedDateTime, '00', -2, 2);
        }

        public static function convertDateIntoTimeZoneAdjustedDateTimeBeginningOfDay($dateValue)
        {
            assert('is_string($dateValue) && DateTimeUtil::isValidDbFormattedDate($dateValue)');
            $greaterThanValue = $dateValue . ' 00:00:00';
            return static::convertDbFormattedDateTimeToTimeZoneAdjustedDateTime($greaterThanValue);
        }

        public static function convertDateIntoTimeZoneAdjustedDateTimeEndOfDay($dateValue)
        {
            assert('is_string($dateValue) && DateTimeUtil::isValidDbFormattedDate($dateValue)');
            $lessThanValue = $dateValue . ' 23:59:59';
            return static::convertDbFormattedDateTimeToTimeZoneAdjustedDateTime($lessThanValue);
        }

        public static function convertDbFormattedDateTimeToTimeZoneAdjustedDateTime($dateTime)
        {
            assert('is_string($dateTime) && DateTimeUtil::isValidDbFormattedDateTime($dateTime)');
            $userTimeZone = new DateTimeZone(Yii::app()->timeZoneHelper->getForCurrentUser());
            $adjustedDate = new DateTime($dateTime, $userTimeZone);
            $adjustedDate->setTimezone(new DateTimeZone('GMT'));
            $adjustedTimeStamp = $adjustedDate->getTimestamp();
            return static::convertTimestampToDbFormatDateTime($adjustedTimeStamp);
        }

        public static function getFirstDayOfAMonthDate($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('first day of this month');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getLastDayOfAMonthDate($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('last day of this month');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getFirstDayOfLastMonthDate($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('first day of last month');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getLastDayOfLastMonthDate($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('last day of last month');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getFirstDayOfNextMonthDate($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('first day of next month');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getLastDayOfNextMonthDate($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('last day of next month');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function isDateValueNull(RedBeanModel $model, $attributeName)
        {
            assert('is_string($attributeName) || $attributeName == null');
            return self::isDateStringNull($model->$attributeName);
        }

        public static function isDateStringNull($date)
        {
            assert('is_string($date) || $date == null');
            if ($date != null && $date != '0000-00-00')
            {
                return false;
            }
            return true;
        }

        public static function isDateTimeValueNull(RedBeanModel $model, $attributeName)
        {
            assert('is_string($attributeName) || $attributeName == null');
            return self::isDateTimeStringNull($model->$attributeName);
        }

        public static function isDateTimeStringNull($dateTime)
        {
            assert('is_string($dateTime) || $dateTime == null');
            if ($dateTime != null && $dateTime != '0000-00-00 00:00:00')
            {
                return false;
            }
            return true;
        }

        public static function resolveDateAsDateTime($date)
        {
            assert('is_string($date)');
            return $date . ' 00:00:00';
        }

        public static function resolveDateTimeAsDate($dateTime)
        {
            assert('is_string($dateTime)');
            if ($dateTime == '0000-00-00 00:00:00')
            {
                return '0000-00-00';
            }
            elseif ($dateTime == null)
            {
                return null;
            }
            return substr($dateTime, 0, 10);
        }

        public static function getDatesBetweenTwoDatesInARange($beginDate, $endDate)
        {
            assert('is_string($beginDate)');
            assert('is_string($endDate)');
            $beginTimeStamp = strtotime($beginDate);
            $endTimeStamp   = strtotime($endDate);
            $quantityOfDays = round(($endTimeStamp - $beginTimeStamp) / 86400) + 1;
            $daysData       = array();
            for ($i = 0; $i < $quantityOfDays; $i++)
            {
                $daysData[] = date('Y-m-d', ($beginTimeStamp + ($i * 86400)));
            }
            return $daysData;
        }

        public static function getWeekStartAndEndDatesBetweenTwoDatesInARange($beginDate, $endDate)
        {
            assert('is_string($beginDate)');
            assert('is_string($endDate)');
            $weekTimeStamp      = strtotime($beginDate);
            $endTimeStamp       = strtotime($endDate);
            $weeksData          = array();
            while ($weekTimeStamp <= $endTimeStamp)
            {
                $date = new DateTime(date('Y-m-d', $weekTimeStamp));
                if (('Sunday' == $date->format('l')) && !static::doesWeekStrictlyStartOnMonday())
                {
                    $date->modify('Monday last week');
                }
                else
                {
                    $date->modify('Monday this week');
                }
                $beginDateOfWeek = $date->format('Y-m-d');
                $date->modify('this week next sunday');
                $endDateOfWeek = $date->format('Y-m-d');
                $weeksData[$beginDateOfWeek] = $endDateOfWeek;
                $weekTimeStamp = strtotime("+1 week", $weekTimeStamp); // Not Coding Standard
            }
            //Capture dates in last week if needed
            $date = new DateTime(date('Y-m-d', $weekTimeStamp));
            if (('Sunday' == $date->format('l')) && !static::doesWeekStrictlyStartOnMonday())
            {
                $date->modify('Monday last week');
            }
            else
            {
                $date->modify('Monday this week');
            }
            $beginDateOfWeek = $date->format('Y-m-d');
            if ($beginDateOfWeek < $endDate)
            {
                $date->modify('this week next sunday');
                $endDateOfWeek = $date->format('Y-m-d');
                $weeksData[$beginDateOfWeek] = $endDateOfWeek;
                $weekTimeStamp               = strtotime("+1 week", $weekTimeStamp); // Not Coding Standard
            }
            if ($endDateOfWeek < $endDate)
            {
                $date = new DateTime(date('Y-m-d', $weekTimeStamp));
                if (('Sunday' == $date->format('l')) && !static::doesWeekStrictlyStartOnMonday())
                {
                    $date->modify('Monday last week');
                }
                else
                {
                    $date->modify('Monday this week');
                }
                $beginDateOfWeek = $date->format('Y-m-d');
                $date->modify('this week next sunday');
                $endDateOfWeek = $date->format('Y-m-d');
                $weeksData[$beginDateOfWeek] = $endDateOfWeek;
            }
            return $weeksData;
        }

        public static function getMonthStartAndEndDatesBetweenTwoDatesInARange($beginDate, $endDate)
        {
            assert('is_string($beginDate)');
            assert('is_string($endDate)');
            $monthTimeStamp      = strtotime($beginDate);
            $endTimeStamp        = strtotime($endDate);
            $monthsData          = array();
            while ($monthTimeStamp <= $endTimeStamp)
            {
                $date = new DateTime(date('Y-m-d', $monthTimeStamp));
                $date->modify('first day of this month');
                $beginDateOfMonth = $date->format('Y-m-d');
                $date->modify('last day of this month');
                $endDateOfMonth = $date->format('Y-m-d');
                $monthsData[$beginDateOfMonth] = $endDateOfMonth;
                $monthTimeStamp = strtotime("+1 month", $monthTimeStamp); // Not Coding Standard
            }
            //Capture dates in last month if needed
            $date = new DateTime(date('Y-m-d', $monthTimeStamp));
            $date->modify('first day of this month');
            $beginDateOfMonth = $date->format('Y-m-d');
            if ($beginDateOfMonth < $endDate)
            {
                $date->modify('last day of this month');
                $endDateOfMonth = $date->format('Y-m-d');
                $monthsData[$beginDateOfMonth] = $endDateOfMonth;
                $monthTimeStamp = strtotime("+1 month", $monthTimeStamp); // Not Coding Standard
            }
            if ($endDateOfMonth < $endDate)
            {
                $date = new DateTime(date('Y-m-d', $monthTimeStamp));
                $date->modify('first day of this month');
                $beginDateOfMonth = $date->format('Y-m-d');
                $date->modify('last day of this month');
                $endDateOfMonth = $date->format('Y-m-d');
                $monthsData[$beginDateOfMonth] = $endDateOfMonth;
            }
            return $monthsData;
        }

        public static function getFirstDayOfAWeek($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dayOfTheWeek = date('w', strtotime($stringTime));
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('this week');
            if ($dayOfTheWeek == 0 && !static::doesWeekStrictlyStartOnMonday())
            {
                $dateTime->modify('-7 days');
            }
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getLastDayOfAWeek($stringTime = null)
        {
            assert('is_string($stringTime) || $stringTime == null');
            $dayOfTheWeek = date('w', strtotime($stringTime));
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('this week +6 days');
            if ($dayOfTheWeek == 0 && !static::doesWeekStrictlyStartOnMonday())
            {
                $dateTime->modify('-7 days');
            }
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getTodaysDate()
        {
            $dateTime = new DateTime();
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getFirstDayOfNextWeek()
        {
            $dateTime = new DateTime();
            $dateTime->modify('next monday');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function getTomorrowsDate()
        {
            $dateTime = new DateTime();
            $dateTime->modify('tomorrow');
            return Yii::app()->dateFormatter->format(DatabaseCompatibilityUtil::getDateFormat(),
                        $dateTime->getTimestamp());
        }

        public static function convertDateToDateTimeByTimeZoneOffset($date)
        {
            $offset          = ZurmoTimeZoneHelper::getTimeZoneOffset();
            $absOffset       = abs($offset);
            $hours           = floor($absOffset / (60 * 60));
            $absOffset       -= $hours * (60 * 60);

            $minutes         = floor($absOffset / 60);
            $absOffset       -= $minutes * 60;

            $seconds         = floor($absOffset);
            $absOffset       -= $seconds;
            $hours           = ($hours < 10)? '0' . $hours : $hours;
            $minutes         = ($minutes < 10)? '0' . $minutes : $minutes;
            $seconds         = ($seconds < 10)? '0' . $seconds : $seconds;
            return $date . ' ' . $hours . ':' . $minutes . ':' . $seconds;
        }

        public static function doesWeekStrictlyStartOnMonday()
        {
            // 2014-04-27 was a sunday, so if we consider strictly that a week starts on monday,
            // then the first day of the week is 2014-04-21
            $stringTime = '2014-04-27 23:59:59';
            $dateTime = new DateTime($stringTime);
            $dateTime->modify('this week');
            if ($dateTime->format('Y-m-d') == '2014-04-21')
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
?>