+--------------------------------------------------------------------+
| CiviCRM version 5 |
+--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2018 |
+ | Copyright CiviCRM LLC (c) 2004-2019 |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
/**
*
* @package CRM
- * @copyright CiviCRM LLC (c) 2004-2018
+ * @copyright CiviCRM LLC (c) 2004-2019
*/
/**
}
}
+ /**
+ * Wrapper for customFormat that takes a timestamp
+ *
+ * @param int $timestamp
+ * Date and time in timestamp format.
+ * @param string $format
+ * The output format.
+ * @param array $dateParts
+ * An array with the desired date parts.
+ *
+ * @return string
+ * the $format-formatted $date
+ */
+ public static function customFormatTs($timestamp, $format = NULL, $dateParts = NULL) {
+ return CRM_Utils_Date::customFormat(date("Y-m-d H:i:s", $timestamp), $format, $dateParts);
+ }
+
/**
* Converts the date/datetime from MySQL format to ISO format
*
$now = self::isoToMysql($now);
}
- return ($mysqlDate >= $now) ? FALSE : TRUE;
+ return (strtotime($mysqlDate) >= strtotime($now)) ? FALSE : TRUE;
}
/**
$to['M'] = $now['mon'];
$to['Y'] = $now['year'] + 1;
break;
+
+ default:
+ if ($relativeTermPrefix === 'ending') {
+ $to['d'] = $now['mday'];
+ $to['M'] = $now['mon'];
+ $to['Y'] = $now['year'];
+ $to['H'] = 23;
+ $to['i'] = $to['s'] = 59;
+ $from = self::intervalAdd('year', -$relativeTermSuffix, $to);
+ $from = self::intervalAdd('second', 1, $from);
+ }
}
break;
$to = self::intervalAdd('day', 90, $from);
$to = self::intervalAdd('second', -1, $to);
break;
+
+ default:
+ if ($relativeTermPrefix === 'ending') {
+ $to['d'] = $now['mday'];
+ $to['M'] = $now['mon'];
+ $to['Y'] = $now['year'];
+ $to['H'] = 23;
+ $to['i'] = $to['s'] = 59;
+ $from = self::intervalAdd('month', -($relativeTermSuffix * 3), $to);
+ $from = self::intervalAdd('second', 1, $from);
+ }
}
break;
$to = self::intervalAdd('day', 60, $from);
$to = self::intervalAdd('second', -1, $to);
break;
+
+ default:
+ if ($relativeTermPrefix === 'ending') {
+ $to['d'] = $now['mday'];
+ $to['M'] = $now['mon'];
+ $to['Y'] = $now['year'];
+ $to['H'] = 23;
+ $to['i'] = $to['s'] = 59;
+ $from = self::intervalAdd($unit, -$relativeTermSuffix, $to);
+ $from = self::intervalAdd('second', 1, $from);
+ }
}
break;
$to = self::intervalAdd('day', 7, $from);
$to = self::intervalAdd('second', -1, $to);
break;
+
+ default:
+ if ($relativeTermPrefix === 'ending') {
+ $to['d'] = $now['mday'];
+ $to['M'] = $now['mon'];
+ $to['Y'] = $now['year'];
+ $to['H'] = 23;
+ $to['i'] = $to['s'] = 59;
+ $from = self::intervalAdd($unit, -$relativeTermSuffix, $to);
+ $from = self::intervalAdd('second', 1, $from);
+ }
}
break;
$from['Y'] = $to['Y'];
break;
+ default:
+ if ($relativeTermPrefix === 'ending') {
+ $to['d'] = $now['mday'];
+ $to['M'] = $now['mon'];
+ $to['Y'] = $now['year'];
+ $to['H'] = 23;
+ $to['i'] = $to['s'] = 59;
+ $from = self::intervalAdd($unit, -$relativeTermSuffix, $to);
+ $from = self::intervalAdd('second', 1, $from);
+ }
}
break;
}
return $month;
}
+
+ /**
+ * Convert a relative date format to an api field.
+ *
+ * @param array $params
+ * @param string $dateField
+ * @param bool $isDatePicker
+ * Non datepicker fields are deprecated. Exterminate Exterminate.
+ * (but for now handle them).
+ */
+ public static function convertFormDateToApiFormat(&$params, $dateField, $isDatePicker = TRUE) {
+ if (!empty($params[$dateField . '_relative'])) {
+ $dates = CRM_Utils_Date::getFromTo($params[$dateField . '_relative'], NULL, NULL);
+ unset($params[$dateField . '_relative']);
+ }
+ if (!empty($params[$dateField . '_low'])) {
+ $dates[0] = $isDatePicker ? $params[$dateField . '_low'] : date('Y-m-d H:i:s', strtotime($params[$dateField . '_low']));
+ unset($params[$dateField . '_low']);
+ }
+ if (!empty($params[$dateField . '_high'])) {
+ $dates[1] = $isDatePicker ? $params[$dateField . '_high'] : date('Y-m-d 23:59:59', strtotime($params[$dateField . '_high']));
+ unset($params[$dateField . '_high']);
+ }
+ if (empty($dates)) {
+ return;
+ }
+ if (empty($dates[0])) {
+ $params[$dateField] = ['<=' => $dates[1]];
+ }
+ elseif (empty($dates[1])) {
+ $params[$dateField] = ['>=' => $dates[0]];
+ }
+ else {
+ $params[$dateField] = ['BETWEEN' => $dates];
+ }
+ }
+
}