3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.5 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2014 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2014
39 class CRM_Utils_Date
{
42 * format a date by padding it with leading '0'.
44 * @param array $date ('Y', 'M', 'd')
45 * @param string $separator the seperator to use when formatting the date
46 * @param int|string $invalidDate what to return if the date is invalid
48 * @return string - formatted string for date
52 static function format($date, $separator = '', $invalidDate = 0) {
53 if (is_numeric($date) &&
54 ((strlen($date) == 8) ||
(strlen($date) == 14))
59 if (!is_array($date) ||
60 CRM_Utils_System
::isNull($date) ||
66 $date['Y'] = (int ) $date['Y'];
67 if ($date['Y'] < 1000 ||
$date['Y'] > 2999) {
71 if (array_key_exists('m', $date)) {
72 $date['M'] = $date['m'];
74 elseif (array_key_exists('F', $date)) {
75 $date['M'] = $date['F'];
78 if (!empty($date['M'])) {
79 $date['M'] = (int ) $date['M'];
80 if ($date['M'] < 1 ||
$date['M'] > 12) {
88 if (!empty($date['d'])) {
89 $date['d'] = (int ) $date['d'];
95 if (!checkdate($date['M'], $date['d'], $date['Y'])) {
99 $date['M'] = sprintf('%02d', $date['M']);
100 $date['d'] = sprintf('%02d', $date['d']);
103 if (CRM_Utils_Array
::value('H', $date) != NULL ||
104 CRM_Utils_Array
::value('h', $date) != NULL ||
105 CRM_Utils_Array
::value('i', $date) != NULL ||
106 CRM_Utils_Array
::value('s', $date) != NULL
108 // we have time too..
109 if (!empty($date['h'])) {
110 if (CRM_Utils_Array
::value('A', $date) == 'PM' or CRM_Utils_Array
::value('a', $date) == 'pm') {
111 if ($date['h'] != 12) {
112 $date['h'] = $date['h'] +
12;
115 if ((CRM_Utils_Array
::value('A', $date) == 'AM' or CRM_Utils_Array
::value('a', $date) == 'am') &&
116 CRM_Utils_Array
::value('h', $date) == 12
121 $date['h'] = (int ) $date['h'];
127 // in 24-hour format the hour is under the 'H' key
128 if (!empty($date['H'])) {
129 $date['H'] = (int) $date['H'];
135 if (!empty($date['i'])) {
136 $date['i'] = (int ) $date['i'];
142 if ($date['h'] == 0 && $date['H'] != 0) {
143 $date['h'] = $date['H'];
146 if (!empty($date['s'])) {
147 $date['s'] = (int ) $date['s'];
153 $date['h'] = sprintf('%02d', $date['h']);
154 $date['i'] = sprintf('%02d', $date['i']);
155 $date['s'] = sprintf('%02d', $date['s']);
160 $time .= $date['h'] . $separator . $date['i'] . $separator . $date['s'];
163 return $date['Y'] . $separator . $date['M'] . $separator . $date['d'] . $time;
167 * return abbreviated weekday names according to the locale
169 * @return array 0-based array with abbreviated weekday names
173 static function &getAbbrWeekdayNames() {
174 static $abbrWeekdayNames;
175 if (!isset($abbrWeekdayNames)) {
177 // set LC_TIME and build the arrays from locale-provided names
178 // June 1st, 1970 was a Monday
179 CRM_Core_I18n
::setLcTime();
180 for ($i = 0; $i < 7; $i++
) {
181 $abbrWeekdayNames[$i] = strftime('%a', mktime(0, 0, 0, 6, $i, 1970));
184 return $abbrWeekdayNames;
188 * return full weekday names according to the locale
190 * @return array 0-based array with full weekday names
194 static function &getFullWeekdayNames() {
195 static $fullWeekdayNames;
196 if (!isset($fullWeekdayNames)) {
198 // set LC_TIME and build the arrays from locale-provided names
199 // June 1st, 1970 was a Monday
200 CRM_Core_I18n
::setLcTime();
201 for ($i = 0; $i < 7; $i++
) {
202 $fullWeekdayNames[$i] = strftime('%A', mktime(0, 0, 0, 6, $i, 1970));
205 return $fullWeekdayNames;
209 * return abbreviated month names according to the locale
213 * @return array 1-based array with abbreviated month names
217 static function &getAbbrMonthNames($month = FALSE) {
218 static $abbrMonthNames;
219 if (!isset($abbrMonthNames)) {
221 // set LC_TIME and build the arrays from locale-provided names
222 CRM_Core_I18n
::setLcTime();
223 for ($i = 1; $i <= 12; $i++
) {
224 $abbrMonthNames[$i] = strftime('%b', mktime(0, 0, 0, $i, 10, 1970));
228 return $abbrMonthNames[$month];
230 return $abbrMonthNames;
234 * return full month names according to the locale
236 * @return array 1-based array with full month names
240 static function &getFullMonthNames() {
241 static $fullMonthNames;
242 if (!isset($fullMonthNames)) {
244 // set LC_TIME and build the arrays from locale-provided names
245 CRM_Core_I18n
::setLcTime();
246 for ($i = 1; $i <= 12; $i++
) {
247 $fullMonthNames[$i] = strftime('%B', mktime(0, 0, 0, $i, 10, 1970));
250 return $fullMonthNames;
258 static function unixTime($string) {
259 if (empty($string)) {
262 $parsedDate = date_parse($string);
263 return mktime(CRM_Utils_Array
::value('hour', $parsedDate),
264 CRM_Utils_Array
::value('minute', $parsedDate),
266 CRM_Utils_Array
::value('month', $parsedDate),
267 CRM_Utils_Array
::value('day', $parsedDate),
268 CRM_Utils_Array
::value('year', $parsedDate)
273 * create a date and time string in a provided format
275 * %b - abbreviated month name ('Jan'..'Dec')
276 * %B - full month name ('January'..'December')
277 * %d - day of the month as a decimal number, 0-padded ('01'..'31')
278 * %e - day of the month as a decimal number, blank-padded (' 1'..'31')
279 * %E - day of the month as a decimal number ('1'..'31')
280 * %f - English ordinal suffix for the day of the month ('st', 'nd', 'rd', 'th')
281 * %H - hour in 24-hour format, 0-padded ('00'..'23')
282 * %I - hour in 12-hour format, 0-padded ('01'..'12')
283 * %k - hour in 24-hour format, blank-padded (' 0'..'23')
284 * %l - hour in 12-hour format, blank-padded (' 1'..'12')
285 * %m - month as a decimal number, 0-padded ('01'..'12')
286 * %M - minute, 0-padded ('00'..'60')
287 * %p - lowercase ante/post meridiem ('am', 'pm')
288 * %P - uppercase ante/post meridiem ('AM', 'PM')
289 * %Y - year as a decimal number including the century ('2005')
291 * @param string $dateString
292 * @param string $format the output format
293 * @param array $dateParts an array with the desired date parts
295 * @internal param string $date date and time in 'YYYY-MM-DD hh:mm:ss' format
296 * @return string the $format-formatted $date
300 static function customFormat($dateString, $format = NULL, $dateParts = NULL) {
301 // 1-based (January) month names arrays
302 $abbrMonths = self
::getAbbrMonthNames();
303 $fullMonths = self
::getFullMonthNames();
306 $config = CRM_Core_Config
::singleton();
309 if (array_intersect(array('h', 'H'), $dateParts)) {
310 $format = $config->dateformatDatetime
;
312 elseif (array_intersect(array('d', 'j'), $dateParts)) {
313 $format = $config->dateformatFull
;
315 elseif (array_intersect(array('m', 'M'), $dateParts)) {
316 $format = $config->dateformatPartial
;
319 $format = $config->dateformatYear
;
323 if (strpos($dateString, '-')) {
324 $month = (int) substr($dateString, 5, 2);
325 $day = (int) substr($dateString, 8, 2);
328 $month = (int) substr($dateString, 4, 2);
329 $day = (int) substr($dateString, 6, 2);
332 if (strlen($dateString) > 10) {
333 $format = $config->dateformatDatetime
;
336 $format = $config->dateformatFull
;
338 elseif ($month > 0) {
339 $format = $config->dateformatPartial
;
342 $format = $config->dateformatYear
;
348 if (strpos($dateString, '-')) {
349 $year = (int) substr($dateString, 0, 4);
350 $month = (int) substr($dateString, 5, 2);
351 $day = (int) substr($dateString, 8, 2);
353 $hour24 = (int) substr($dateString, 11, 2);
354 $minute = (int) substr($dateString, 14, 2);
357 $year = (int) substr($dateString, 0, 4);
358 $month = (int) substr($dateString, 4, 2);
359 $day = (int) substr($dateString, 6, 2);
361 $hour24 = (int) substr($dateString, 8, 2);
362 $minute = (int) substr($dateString, 10, 2);
365 if ($day %
10 == 1 and $day != 11) {
368 elseif ($day %
10 == 2 and $day != 12) {
371 elseif ($day %
10 == 3 and $day != 13) {
392 $hour12 = $hour24 - 12;
398 '%b' => CRM_Utils_Array
::value($month, $abbrMonths),
399 '%B' => CRM_Utils_Array
::value($month, $fullMonths),
400 '%d' => $day > 9 ?
$day : '0' . $day,
401 '%e' => $day > 9 ?
$day : ' ' . $day,
404 '%H' => $hour24 > 9 ?
$hour24 : '0' . $hour24,
405 '%h' => $hour12 > 9 ?
$hour12 : '0' . $hour12,
406 '%I' => $hour12 > 9 ?
$hour12 : '0' . $hour12,
407 '%k' => $hour24 > 9 ?
$hour24 : ' ' . $hour24,
408 '%l' => $hour12 > 9 ?
$hour12 : ' ' . $hour12,
409 '%m' => $month > 9 ?
$month : '0' . $month,
410 '%M' => $minute > 9 ?
$minute : '0' . $minute,
411 '%i' => $minute > 9 ?
$minute : '0' . $minute,
412 '%p' => strtolower($type),
418 return strtr($format, $date);
426 * converts the date/datetime from MySQL format to ISO format
428 * @param string $mysql date/datetime in MySQL format
430 * @return string date/datetime in ISO format
433 static function mysqlToIso($mysql) {
434 $year = substr($mysql, 0, 4);
435 $month = substr($mysql, 4, 2);
436 $day = substr($mysql, 6, 2);
437 $hour = substr($mysql, 8, 2);
438 $minute = substr($mysql, 10, 2);
439 $second = substr($mysql, 12, 2);
465 * converts the date/datetime from ISO format to MySQL format
466 * Note that until CRM-14986/ 4.4.7 this was required whenever the pattern $dao->find(TRUE): $dao->save(); was
467 * used to update an object with a date field was used. The DAO now checks for a '-' in date field strings
468 * & runs this function if the - appears - meaning it is likely redundant in the form & BAO layers
470 * @param string $iso date/datetime in ISO format
472 * @return string date/datetime in MySQL format
475 static function isoToMysql($iso) {
476 $dropArray = array('-' => '', ':' => '', ' ' => '');
477 return strtr($iso, $dropArray);
481 * converts the any given date to default date format.
483 * @param array $params has given date-format
484 * @param int $dateType type of date
485 * @param string $dateParam index of params
490 static function convertToDefaultDate(&$params, $dateType, $dateParam) {
492 $cen = substr($now['year'], 0, 2);
496 if (!empty($params[$dateParam])) {
497 // suppress hh:mm or hh:mm:ss if it exists CRM-7957
498 $value = preg_replace("/(\s(([01]\d)|[2][0-3])(:([0-5]\d)){1,2})$/", "", $params[$dateParam]);
503 if (!preg_match('/^\d\d\d\d-?(\d|\d\d)-?(\d|\d\d)$/', $value)) {
509 if (!preg_match('/^(\d|\d\d)[-\/](\d|\d\d)[-\/]\d\d$/', $value)) {
515 if (!preg_match('/^(\d|\d\d)[-\/](\d|\d\d)[-\/]\d\d\d\d$/', $value)) {
521 if (!preg_match('/^[A-Za-z]*.[ \t]?\d\d\,[ \t]?\d\d\d\d$/', $value)) {
527 if (!preg_match('/^\d\d-[A-Za-z]{3}.*-\d\d$/', $value) && !preg_match('/^\d\d[-\/]\d\d[-\/]\d\d$/', $value)) {
533 if (!preg_match('/^(\d|\d\d)[-\/](\d|\d\d)[-\/]\d\d\d\d/', $value)) {
539 if ($dateType == 1) {
540 $formattedDate = explode("-", $value);
541 if (count($formattedDate) == 3) {
542 $year = (int) $formattedDate[0];
543 $month = (int) $formattedDate[1];
544 $day = (int) $formattedDate[2];
546 elseif (count($formattedDate) == 1 && (strlen($value) == 8)) {
555 if ($dateType == 2 ||
$dateType == 4) {
556 $formattedDate = explode("/", $value);
557 if (count($formattedDate) != 3) {
558 $formattedDate = explode("-", $value);
560 if (count($formattedDate) == 3) {
561 $year = (int) $formattedDate[2];
562 $month = (int) $formattedDate[0];
563 $day = (int) $formattedDate[1];
569 if ($dateType == 8) {
570 $dateArray = explode(' ', $value);
572 $dateArray[1] = (int) substr($dateArray[1], 0, 2);
575 $fullMonths = self
::getFullMonthNames();
576 foreach ($fullMonths as $key => $val) {
577 if (strtolower($dateArray[0]) == strtolower($val)) {
583 $abbrMonths = self
::getAbbrMonthNames();
584 foreach ($abbrMonths as $key => $val) {
585 if (strtolower(trim($dateArray[0], ".")) == strtolower($val)) {
591 $year = (int) $dateArray[2];
592 $day = (int) $dateArray[1];
593 $month = (int) $monthInt;
595 if ($dateType == 16) {
596 $dateArray = explode('-', $value);
597 if (count($dateArray) != 3) {
598 $dateArray = explode('/', $value);
601 if (count($dateArray) == 3) {
603 $fullMonths = self
::getFullMonthNames();
604 foreach ($fullMonths as $key => $val) {
605 if (strtolower($dateArray[1]) == strtolower($val)) {
611 $abbrMonths = self
::getAbbrMonthNames();
612 foreach ($abbrMonths as $key => $val) {
613 if (strtolower(trim($dateArray[1], ".")) == strtolower($val)) {
620 $monthInt = $dateArray[1];
623 $year = (int) $dateArray[2];
624 $day = (int) $dateArray[0];
625 $month = (int) $monthInt;
631 if ($dateType == 32) {
632 $formattedDate = explode("/", $value);
633 if (count($formattedDate) == 3) {
634 $year = (int) $formattedDate[2];
635 $month = (int) $formattedDate[1];
636 $day = (int) $formattedDate[0];
643 $month = ($month < 10) ?
"0" . "$month" : $month;
644 $day = ($day < 10) ?
"0" . "$day" : $day;
646 $year = (int ) $year;
647 // simple heuristic to determine what century to use
648 // 00 - 20 is always 2000 - 2020
649 // 21 - 99 is always 1921 - 1999
651 $year = (strlen($year) == 1) ?
$cen . '0' . $year : $cen . $year;
653 elseif ($year < 100) {
654 $year = $prevCen . $year;
657 if ($params[$dateParam]) {
658 $params[$dateParam] = "$year$month$day";
660 //if month is invalid return as error
661 if ($month !== '00' && $month <= 12) {
672 static function isDate(&$date) {
673 if (CRM_Utils_System
::isNull($date)) {
680 * @param null $timeStamp
682 * @return bool|string
684 static function currentDBDate($timeStamp = NULL) {
685 return $timeStamp ?
date('YmdHis', $timeStamp) : date('YmdHis');
694 static function overdue($date, $now = NULL) {
695 $mysqlDate = self
::isoToMysql($date);
697 $now = self
::currentDBDate();
700 $now = self
::isoToMysql($now);
703 return ($mysqlDate >= $now) ?
FALSE : TRUE;
707 * Function to get customized today
709 * This function is used for getting customized today. To get
710 * actuall today pass 'dayParams' as null. or else pass the day,
711 * month, year values as array values
712 * Example: $dayParams = array(
713 'day' => '25', 'month' => '10',
714 * 'year' => '2007' );
716 * @param Array $dayParams Array of the day, month, year
718 * @param string $format expected date format( default
719 * format is 2007-12-21 )
721 * @return string Return the customized todays date (Y-m-d)
724 static function getToday($dayParams = NULL, $format = "Y-m-d") {
725 if (is_null($dayParams) ||
empty($dayParams)) {
726 $today = date($format);
729 $today = date($format, mktime(0, 0, 0,
740 * Function to find whether today's date lies in
743 * @param date $startDate start date for the range
744 * @param date $endDate end date for the range
746 * @return true todays date is in the given date range
749 static function getRange($startDate, $endDate) {
750 $today = date("Y-m-d");
751 $mysqlStartDate = self
::isoToMysql($startDate);
752 $mysqlEndDate = self
::isoToMysql($endDate);
753 $mysqlToday = self
::isoToMysql($today);
755 if ((isset($mysqlStartDate) && isset($mysqlEndDate)) && (($mysqlToday >= $mysqlStartDate) && ($mysqlToday <= $mysqlEndDate))) {
758 elseif ((isset($mysqlStartDate) && !isset($mysqlEndDate)) && (($mysqlToday >= $mysqlStartDate))) {
761 elseif ((!isset($mysqlStartDate) && isset($mysqlEndDate)) && (($mysqlToday <= $mysqlEndDate))) {
768 * Function to get start date and end from
769 * the given relative term and unit
771 * @param date $relative eg: term.unit
776 * @return array start date, end date
779 static function getFromTo($relative, $from, $to) {
781 list($term, $unit) = explode('.', $relative);
782 $dateRange = self
::relativeToAbsolute($term, $unit);
783 $from = $dateRange['from'];
784 //Take only Date Part, Sometime Time part is also present in 'to'
785 $to = substr($dateRange['to'], 0, 8);
788 $from = self
::processDate($from);
789 $to = self
::processDate($to, '235959');
791 return array($from, $to);
795 * Function to calculate Age in Years if greater than one year else in months
797 * @param date $birthDate Birth Date
799 * @return int array $results contains years or months
803 static public function calculateAge($birthDate) {
805 $formatedBirthDate = CRM_Utils_Date
::customFormat($birthDate, '%Y-%m-%d');
807 $bDate = explode('-', $formatedBirthDate);
808 $birthYear = $bDate[0];
809 $birthMonth = $bDate[1];
810 $birthDay = $bDate[2];
811 $year_diff = date("Y") - $birthYear;
813 // don't calculate age CRM-3143
814 if ($birthYear == '1902') {
818 switch ($year_diff) {
820 $month = (12 - $birthMonth) +
date("m");
822 if (date("d") < $birthDay) {
825 $results['months'] = $month;
827 elseif ($month == 12 && (date("d") < $birthDay)) {
828 $results['months'] = $month - 1;
831 $results['years'] = $year_diff;
836 $month = date("m") - $birthMonth;
837 $results['months'] = $month;
841 $results['years'] = $year_diff;
842 if ((date("m") < $birthMonth) ||
(date("m") == $birthMonth) && (date("d") < $birthDay)) {
851 * Function to calculate next payment date according to provided unit & interval
853 * @param string $unit frequency unit like year,month, week etc..
855 * @param int $interval frequency interval.
857 * @param array $date start date of pledge.
859 * @param bool $dontCareTime
861 * @return array $result contains new date with added interval
864 static function intervalAdd($unit, $interval, $date, $dontCareTime = FALSE) {
865 if (is_array($date)) {
866 $hour = CRM_Utils_Array
::value('H', $date);
867 $minute = CRM_Utils_Array
::value('i', $date);
868 $second = CRM_Utils_Array
::value('s', $date);
869 $month = CRM_Utils_Array
::value('M', $date);
870 $day = CRM_Utils_Array
::value('d', $date);
871 $year = CRM_Utils_Array
::value('Y', $date);
874 extract(date_parse($date));
876 $date = mktime($hour, $minute, $second, $month, $day, $year);
879 $date = mktime($hour, $minute, $second, $month, $day, $year +
$interval);
883 $date = mktime($hour, $minute, $second, $month +
$interval, $day, $year);
887 $interval = $interval * 7;
888 $date = mktime($hour, $minute, $second, $month, $day +
$interval, $year);
892 $date = mktime($hour, $minute, $second, $month, $day +
$interval, $year);
896 $date = mktime($hour, $minute, $second +
$interval, $month, $day, $year);
900 $scheduleDate = explode("-", date("n-j-Y-H-i-s", $date));
903 $date['M'] = $scheduleDate[0];
904 $date['d'] = $scheduleDate[1];
905 $date['Y'] = $scheduleDate[2];
906 if ($dontCareTime == FALSE) {
907 $date['H'] = $scheduleDate[3];
908 $date['i'] = $scheduleDate[4];
909 $date['s'] = $scheduleDate[5];
915 * function to check given format is valid for bith date.
916 * and retrun supportable birth date format w/ qf mapping.
918 * @param $format given format ( eg 'M Y', 'Y M' )
919 * return array of qfMapping and date parts for date format.
921 * @return array|null|string
923 static function &checkBirthDateFormat($format = NULL) {
924 $birthDateFormat = NULL;
926 $birthDateFormat = self
::getDateFormat('birth');
929 $supportableFormats = array(
930 'mm/dd' => '%B %E%f',
931 'dd-mm' => '%E%f %B',
935 'dd/mm/yy' => '%E%f %B %Y',
938 if (array_key_exists($birthDateFormat, $supportableFormats)) {
939 $birthDateFormat = array('qfMapping' => $supportableFormats[$birthDateFormat]);
942 return $birthDateFormat;
946 * resolves the given relative time interval into finite time limits
948 * @param array $relativeTerm relative time frame like this, previous, etc
949 * @param int $unit frequency unit like year, month, week etc..
951 * @return array $dateRange start date and end date for the relative time frame
954 static function relativeToAbsolute($relativeTerm, $unit) {
956 $from = $to = $dateRange = array();
957 $from['H'] = $from['i'] = $from['s'] = 0;
961 switch ($relativeTerm) {
963 $from['d'] = $from['M'] = 1;
966 $to['Y'] = $from['Y'] = $now['year'];
970 $from['M'] = $from['d'] = 1;
973 $to['Y'] = $from['Y'] = $now['year'] - 1;
976 case 'previous_before':
977 $from['M'] = $from['d'] = 1;
980 $to['Y'] = $from['Y'] = $now['year'] - 2;
984 $from['M'] = $from['d'] = 1;
987 $from['Y'] = $now['year'] - 2;
988 $to['Y'] = $now['year'] - 1;
994 $to['Y'] = $now['year'] - 1;
999 $from['M'] = $from['d'] = 1;
1000 $from['Y'] = $now['year'];
1004 case 'greater_previous':
1007 $from['Y'] = $now['year'] - 1;
1012 $to['d'] = $now['mday'];
1013 $to['M'] = $now['mon'];
1014 $to['Y'] = $now['year'];
1016 $to['i'] = $to['s'] = 59;
1017 $from = self
::intervalAdd('year', -1, $to);
1018 $from = self
::intervalAdd('second', 1, $from);
1022 $from['M'] = $from['d'] = 1;
1023 $from['Y'] = $now['year'];
1025 $to['i'] = $to['s'] = 59;
1026 $to['d'] = $now['mday'];
1027 $to['M'] = $now['mon'];
1028 $to['Y'] = $now['year'];
1032 $to['d'] = $now['mday'];
1033 $to['M'] = $now['mon'];
1034 $to['Y'] = $now['year'];
1036 $to['i'] = $to['s'] = 59;
1037 $from = self
::intervalAdd('year', -2, $to);
1038 $from = self
::intervalAdd('second', 1, $from);
1042 $to['d'] = $now['mday'];
1043 $to['M'] = $now['mon'];
1044 $to['Y'] = $now['year'];
1046 $to['i'] = $to['s'] = 59;
1047 $from = self
::intervalAdd('year', -3, $to);
1048 $from = self
::intervalAdd('second', 1, $from);
1054 $config = CRM_Core_Config
::singleton();
1055 $from['d'] = $config->fiscalYearStart
['d'];
1056 $from['M'] = $config->fiscalYearStart
['M'];
1057 $fYear = self
::calculateFiscalYear($from['d'], $from['M']);
1058 switch ($relativeTerm) {
1060 $from['Y'] = $fYear;
1061 $fiscalYear = mktime(0, 0, 0, $from['M'], $form['d'], $from['Y'] +
1);
1062 $fiscalEnd = explode('-', date("Y-m-d", $fiscalYear));
1064 $to['d'] = $fiscalEnd['2'];
1065 $to['M'] = $fiscalEnd['1'];
1066 $to['Y'] = $fiscalEnd['0'];
1070 $from['Y'] = $fYear - 1;
1071 $fiscalYear = mktime(0, 0, 0, $from['M'], $form['d'], $from['Y'] +
1);
1072 $fiscalEnd = explode('-', date("Y-m-d", $fiscalYear));
1074 $to['d'] = $fiscalEnd['2'];
1075 $to['M'] = $fiscalEnd['1'];
1076 $to['Y'] = $fiscalEnd['0'];
1082 switch ($relativeTerm) {
1085 $quarter = ceil($now['mon'] / 3);
1087 $from['M'] = (3 * $quarter) - 2;
1088 $to['M'] = 3 * $quarter;
1089 $to['Y'] = $from['Y'] = $now['year'];
1090 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $now['year']));
1095 $quarter = ceil($now['mon'] / 3);
1096 $quarter = $quarter - $difference;
1098 if ($quarter <= 0) {
1103 $from['M'] = (3 * $quarter) - 2;
1104 $to['M'] = 3 * $quarter;
1105 $to['Y'] = $from['Y'] = $now['year'] - $subtractYear;
1106 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1109 case 'previous_before':
1111 $quarter = ceil($now['mon'] / 3);
1112 $quarter = $quarter - $difference;
1114 if ($quarter <= 0) {
1119 $from['M'] = (3 * $quarter) - 2;
1120 $to['M'] = 3 * $quarter;
1121 $to['Y'] = $from['Y'] = $now['year'] - $subtractYear;
1122 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1127 $quarter = ceil($now['mon'] / 3);
1128 $current_quarter = $quarter;
1129 $quarter = $quarter - $difference;
1131 if ($quarter <= 0) {
1136 $from['M'] = (3 * $quarter) - 2;
1137 switch ($current_quarter) {
1139 $to['M'] = (4 * $quarter);
1143 $to['M'] = (4 * $quarter) +
3;
1147 $to['M'] = (4 * $quarter) +
2;
1151 $to['M'] = (4 * $quarter) +
1;
1154 $to['Y'] = $from['Y'] = $now['year'] - $subtractYear;
1155 if ($to['M'] > 12) {
1156 $to['M'] = 3 * ($quarter - 3);
1157 $to['Y'] = $now['year'];
1159 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1163 $quarter = ceil($now['mon'] / 3) - 1;
1165 if ($quarter <= 0) {
1169 $to['M'] = 3 * $quarter;
1170 $to['Y'] = $from['Y'] = $now['year'] - $subtractYear;
1171 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1176 $quarter = ceil($now['mon'] / 3);
1178 $from['M'] = (3 * $quarter) - 2;
1179 $from['Y'] = $now['year'];
1183 case 'greater_previous':
1184 $quarter = ceil($now['mon'] / 3) - 1;
1186 if ($quarter <= 0) {
1190 $from['M'] = 3 * $quarter;
1191 $from['Y'] = $from['Y'] = $now['year'] - $subtractYear;
1192 $from['d'] = date('t', mktime(0, 0, 0, $from['M'], 1, $from['Y']));
1197 $to['d'] = $now['mday'];
1198 $to['M'] = $now['mon'];
1199 $to['Y'] = $now['year'];
1201 $to['i'] = $to['s'] = 59;
1202 $from = self
::intervalAdd('month', -3, $to);
1203 $from = self
::intervalAdd('second', 1, $from);
1207 $quarter = ceil($now['mon'] / 3);
1209 $from['M'] = (3 * $quarter) - 2;
1210 $from['Y'] = $now['year'];
1211 $to['d'] = $now['mday'];
1212 $to['M'] = $now['mon'];
1213 $to['Y'] = $now['year'];
1215 $to['i'] = $to['s'] = 59;
1221 switch ($relativeTerm) {
1224 $to['d'] = date('t', mktime(0, 0, 0, $now['mon'], 1, $now['year']));
1225 $from['M'] = $to['M'] = $now['mon'];
1226 $from['Y'] = $to['Y'] = $now['year'];
1231 if ($now['mon'] == 1) {
1232 $from['M'] = $to['M'] = 12;
1233 $from['Y'] = $to['Y'] = $now['year'] - 1;
1236 $from['M'] = $to['M'] = $now['mon'] - 1;
1237 $from['Y'] = $to['Y'] = $now['year'];
1239 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1242 case 'previous_before':
1244 if ($now['mon'] < 3) {
1245 $from['M'] = $to['M'] = 10 +
$now['mon'];
1246 $from['Y'] = $to['Y'] = $now['year'] - 1;
1249 $from['M'] = $to['M'] = $now['mon'] - 2;
1250 $from['Y'] = $to['Y'] = $now['year'];
1252 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1257 if ($now['mon'] < 3) {
1258 $from['M'] = 10 +
$now['mon'];
1259 $from['Y'] = $now['year'] - 1;
1262 $from['M'] = $now['mon'] - 2;
1263 $from['Y'] = $now['year'];
1266 if ($now['mon'] == 1) {
1268 $to['Y'] = $now['year'] - 1;
1271 $to['M'] = $now['mon'] - 1;
1272 $to['Y'] = $now['year'];
1275 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1279 //before end of past month
1280 if ($now['mon'] == 1) {
1282 $to['Y'] = $now['year'] - 1;
1285 $to['M'] = $now['mon'] - 1;
1286 $to['Y'] = $now['year'];
1289 $to['d'] = date('t', mktime(0, 0, 0, $to['M'], 1, $to['Y']));
1295 $from['M'] = $now['mon'];;
1296 $from['Y'] = $now['year'];
1300 case 'greater_previous':
1301 //from end of past month
1302 if ($now['mon'] == 1) {
1304 $from['Y'] = $now['year'] - 1;
1307 $from['M'] = $now['mon'] - 1;
1308 $from['Y'] = $now['year'];
1311 $from['d'] = date('t', mktime(0, 0, 0, $from['M'], 1, $from['Y']));
1316 $to['d'] = $now['mday'];
1317 $to['M'] = $now['mon'];
1318 $to['Y'] = $now['year'];
1320 $to['i'] = $to['s'] = 59;
1321 $from = self
::intervalAdd('month', -1, $to);
1322 $from = self
::intervalAdd('second', 1, $from);
1327 $from['M'] = $now['mon'];;
1328 $from['Y'] = $now['year'];
1329 $to['d'] = $now['mday'];
1330 $to['M'] = $now['mon'];
1331 $to['Y'] = $now['year'];
1333 $to['i'] = $to['s'] = 59;
1339 switch ($relativeTerm) {
1341 $from['d'] = $now['mday'];
1342 $from['M'] = $now['mon'];
1343 $from['Y'] = $now['year'];
1344 $from = self
::intervalAdd('day', -1 * ($now['wday']), $from);
1345 $to = self
::intervalAdd('day', 6, $from);
1349 $from['d'] = $now['mday'];
1350 $from['M'] = $now['mon'];
1351 $from['Y'] = $now['year'];
1352 $from = self
::intervalAdd('day', -1 * ($now['wday']) - 7, $from);
1353 $to = self
::intervalAdd('day', 6, $from);
1356 case 'previous_before':
1357 $from['d'] = $now['mday'];
1358 $from['M'] = $now['mon'];
1359 $from['Y'] = $now['year'];
1360 $from = self
::intervalAdd('day', -1 * ($now['wday']) - 14, $from);
1361 $to = self
::intervalAdd('day', 6, $from);
1365 $from['d'] = $now['mday'];
1366 $from['M'] = $now['mon'];
1367 $from['Y'] = $now['year'];
1368 $from = self
::intervalAdd('day', -1 * ($now['wday']) - 14, $from);
1369 $to = self
::intervalAdd('day', 13, $from);
1373 $to['d'] = $now['mday'];
1374 $to['M'] = $now['mon'];
1375 $to['Y'] = $now['year'];
1376 $to = self
::intervalAdd('day', -1 * ($now['wday']) - 1, $to);
1381 $from['d'] = $now['mday'];
1382 $from['M'] = $now['mon'];
1383 $from['Y'] = $now['year'];
1384 $from = self
::intervalAdd('day', -1 * ($now['wday']), $from);
1388 case 'greater_previous':
1389 $from['d'] = $now['mday'];
1390 $from['M'] = $now['mon'];
1391 $from['Y'] = $now['year'];
1392 $from = self
::intervalAdd('day', -1 * ($now['wday']) - 1, $from);
1397 $to['d'] = $now['mday'];
1398 $to['M'] = $now['mon'];
1399 $to['Y'] = $now['year'];
1401 $to['i'] = $to['s'] = 59;
1402 $from = self
::intervalAdd('day', -7, $to);
1403 $from = self
::intervalAdd('second', 1, $from);
1407 $from['d'] = $now['mday'];
1408 $from['M'] = $now['mon'];
1409 $from['Y'] = $now['year'];
1410 $from = self
::intervalAdd('day', -1 * ($now['wday']), $from);
1411 $to['d'] = $now['mday'];
1412 $to['M'] = $now['mon'];
1413 $to['Y'] = $now['year'];
1415 $to['i'] = $to['s'] = 59;
1421 switch ($relativeTerm) {
1423 $from['d'] = $to['d'] = $now['mday'];
1424 $from['M'] = $to['M'] = $now['mon'];
1425 $from['Y'] = $to['Y'] = $now['year'];
1429 $from['d'] = $now['mday'];
1430 $from['M'] = $now['mon'];
1431 $from['Y'] = $now['year'];
1432 $from = self
::intervalAdd('day', -1, $from);
1433 $to['d'] = $from['d'];
1434 $to['M'] = $from['M'];
1435 $to['Y'] = $from['Y'];
1438 case 'previous_before':
1439 $from['d'] = $now['mday'];
1440 $from['M'] = $now['mon'];
1441 $from['Y'] = $now['year'];
1442 $from = self
::intervalAdd('day', -2, $from);
1443 $to['d'] = $from['d'];
1444 $to['M'] = $from['M'];
1445 $to['Y'] = $from['Y'];
1449 $from['d'] = $to['d'] = $now['mday'];
1450 $from['M'] = $to['M'] = $now['mon'];
1451 $from['Y'] = $to['Y'] = $now['year'];
1452 $from = self
::intervalAdd('day', -2, $from);
1453 $to = self
::intervalAdd('day', -1, $to);
1457 $to['d'] = $now['mday'];
1458 $to['M'] = $now['mon'];
1459 $to['Y'] = $now['year'];
1464 $from['d'] = $now['mday'];
1465 $from['M'] = $now['mon'];;
1466 $from['Y'] = $now['year'];
1474 'from', 'to') as $item) {
1475 if (!empty($
$item)) {
1476 $dateRange[$item] = self
::format($
$item);
1479 $dateRange[$item] = NULL;
1486 * Function to calculate current fiscal year based on the fiscal month and day
1488 * @param int $fyDate Fiscal start date
1490 * @param int $fyMonth Fiscal Start Month
1492 * @return int $fy Current Fiscl Year
1496 static function calculateFiscalYear($fyDate, $fyMonth) {
1497 $date = date("Y-m-d");
1498 $currentYear = date("Y");
1500 //recalculate the date because month 4::04 make the difference
1501 $fiscalYear = explode('-', date("Y-m-d", mktime(0, 0, 0, $fyMonth, $fyDate, $currentYear)));
1502 $fyDate = $fiscalYear[2];
1503 $fyMonth = $fiscalYear[1];
1504 $fyStartDate = date("Y-m-d", mktime(0, 0, 0, $fyMonth, $fyDate, $currentYear));
1506 if ($fyStartDate > $date) {
1507 $fy = intval(intval($currentYear) - 1);
1510 $fy = intval($currentYear);
1516 * Function to process date, convert to mysql format
1518 * @param string $date date string
1519 * @param string $time time string
1520 * @param bool|string $returnNullString 'null' needs to be returned
1521 * so that db oject will set null in db
1522 * @param string $format expected return date format.( default is mysql )
1524 * @return string $mysqlDate date format that is excepted by mysql
1526 static function processDate($date, $time = NULL, $returnNullString = FALSE, $format = 'YmdHis') {
1529 if ($returnNullString) {
1530 $mysqlDate = 'null';
1534 $mysqlDate = date($format, strtotime($date . ' ' . $time));
1541 * Function to convert mysql to date plugin format
1543 * @param string $mysqlDate date string
1545 * @param null $formatType
1546 * @param null $format
1547 * @param null $timeFormat
1549 * @return array $date and time
1551 static function setDateDefaults($mysqlDate = NULL, $formatType = NULL, $format = NULL, $timeFormat = NULL) {
1552 // if date is not passed assume it as today
1554 $mysqlDate = date('Y-m-d G:i:s');
1557 $config = CRM_Core_Config
::singleton();
1559 // get actual format
1560 $params = array('name' => $formatType);
1562 CRM_Core_DAO
::commonRetrieve('CRM_Core_DAO_PreferencesDate', $params, $values);
1564 if ($values['date_format']) {
1565 $format = $values['date_format'];
1568 if (isset($values['time_format'])) {
1569 $timeFormat = $values['time_format'];
1573 // now we set display date using js, hence we should always setdefault
1574 // 'm/d/Y' format. So that submitted value is alwats mm/dd/YY format
1575 // note that for date display we dynamically create text field
1578 $format = $config->dateInputFormat;
1581 // get actual format
1582 $actualPHPFormats = CRM_Core_SelectValues::datePluginToPHPFormats( );
1583 $dateFormat = CRM_Utils_Array::value( $format, $actualPHPFormats );
1587 $dateFormat = 'm/d/Y';
1588 $date = date($dateFormat, strtotime($mysqlDate));
1591 $timeFormat = $config->timeInputFormat
;
1594 $actualTimeFormat = "g:iA";
1595 $appendZeroLength = 7;
1596 if ($timeFormat > 1) {
1597 $actualTimeFormat = "G:i";
1598 $appendZeroLength = 5;
1601 $time = date($actualTimeFormat, strtotime($mysqlDate));
1603 // need to append zero for hours < 10
1604 if (strlen($time) < $appendZeroLength) {
1605 $time = '0' . $time;
1608 return array($date, $time);
1612 * Function get date format
1614 * @param string $formatType Date name e.g. birth
1616 * @return string $format
1618 static function getDateFormat($formatType = NULL) {
1621 $format = CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_PreferencesDate',
1622 $formatType, 'date_format', 'name'
1627 $config = CRM_Core_Config
::singleton();
1628 $format = $config->dateInputFormat
;
1634 * Get the time in UTC for the current time. You can optionally send an offset from the current time if needed
1636 * @param $offset int the offset from the current time in seconds
1638 * @return the time in UTC
1642 static function getUTCTime($offset = 0) {
1643 $originalTimezone = date_default_timezone_get();
1644 date_default_timezone_set('UTC');
1645 $time = time() +
$offset;
1646 $now = date('YmdHis', $time);
1647 date_default_timezone_set($originalTimezone);
1656 * @return null|string
1658 static function formatDate($date, $dateType) {
1659 $formattedDate = NULL;
1661 return $formattedDate;
1664 //1. first convert date to default format.
1665 //2. append time to default formatted date (might be removed during format)
1666 //3. validate date / date time.
1667 //4. If date and time then convert to default date time format.
1670 $dateParams = array($dateKey => $date);
1672 if (CRM_Utils_Date
::convertToDefaultDate($dateParams, $dateType, $dateKey)) {
1673 $dateVal = $dateParams[$dateKey];
1675 if ($dateType == 1) {
1677 if (preg_match("/(\s(([01]\d)|[2][0-3]):([0-5]\d))$/", $date, $matches)) {
1678 $ruleName = 'dateTime';
1679 if (strpos($date, '-') !== FALSE) {
1680 $dateVal .= array_shift($matches);
1686 $valid = CRM_Utils_Rule
::$ruleName($dateVal);
1689 //format date and time to default.
1690 if ($ruleName == 'dateTime') {
1691 $dateVal = CRM_Utils_Date
::customFormat(preg_replace("/(:|\s)?/", "", $dateVal), '%Y%m%d%H%i');
1692 //hack to add seconds
1695 $formattedDate = $dateVal;
1699 return $formattedDate;