function DBTimeStamp($ts)
{
if (is_string($ts)) {
$d = ADORecordSet::UnixTimeStamp($ts);
}
return 'TO_DATE(' . adodb_date($this->fmtTimeStamp, $ts) . ",'RRRR-MM-DD, HH:MI:SS AM')";
}
function DBTimeStamp($ts)
{
if (is_string($ts)) $ts = ADORecordSet::UnixTimeStamp($ts);
if (is_object($ts)) $ds = $ts->format($this->fmtDate);
else $ds = adodb_date($this->fmtTimeStamp,$ts);
return 'TO_DATE('.$ds.",'RRRR-MM-DD, HH:MI:SS AM')";
}
public function metaform()
{
$timestamp = $this->getValue();
if (!is_numeric($timestamp)) {
$timestamp = self::strtotime($timestamp);
}
if (!empty($timestamp)) {
$datepicker = adodb_date(self::getDateFormat(), $timestamp);
$hour = adodb_date('H', $timestamp);
$minute = adodb_date('i', $timestamp);
} else {
$datepicker = $hour = $minute = null;
}
$data = $this->getData();
$form = array();
$form[] = array('#type' => 'textfield', '#title' => $this->getTitle(), '#attributes' => array('class' => 'js-wpt-date', 'style' => 'width:150px;'), '#name' => $this->getName() . '[datepicker]', '#value' => $datepicker, '#validate' => $this->getValidationData());
if (!empty($data['add_time'])) {
// Hour
$hours = 24;
$options = array();
for ($index = 0; $index < $hours; $index++) {
$prefix = $index < 10 ? '0' : '';
$options[$index] = array('#title' => $prefix . strval($index), '#value' => $index);
}
$form[] = array('#type' => 'select', '#title' => __('Hour'), '#options' => $options, '#default_value' => $hour, '#name' => $this->getName() . '[hour]', '#inline' => true);
// Minutes
$minutes = 60;
$options = array();
for ($index = 0; $index < $minutes; $index++) {
$prefix = $index < 10 ? '0' : '';
$options[$index] = array('#title' => $prefix . strval($index), '#value' => $index);
}
$form[] = array('#type' => 'select', '#title' => __('Minute'), '#options' => $options, '#default_value' => $minute, '#name' => $this->getName() . '[minute]', '#inline' => true);
}
return $form;
}
function adodb_date2($fmt, $d = false, $is_gmt = false)
{
if ($d !== false) {
if (!preg_match("|^([0-9]{4})[-/\\.]?([0-9]{1,2})[-/\\.]?([0-9]{1,2})[ -]?(([0-9]{1,2}):?([0-9]{1,2}):?([0-9\\.]{1,4}))?|", $d, $rr)) {
return adodb_date($fmt, false, $is_gmt);
}
if ($rr[1] <= 100 && $rr[2] <= 1) {
return adodb_date($fmt, false, $is_gmt);
}
// h-m-s-MM-DD-YY
if (!isset($rr[5])) {
$d = adodb_mktime(0, 0, 0, $rr[2], $rr[3], $rr[1]);
} else {
$d = @adodb_mktime($rr[5], $rr[6], $rr[7], $rr[2], $rr[3], $rr[1]);
}
}
return adodb_date($fmt, $d, $is_gmt);
}
/**
* Fix due to a bug saving date as array.
*
* BUGS
* 'timestamp' is saved without Hour and Minute appended.
*
* @param type $value
* @param type $field
*/
function __wpcf_fields_date_check_leftover($value, $field, $use_cache = true)
{
if (empty($value)) {
return $value;
}
if (!is_object($field)) {
$post_id = wpcf_get_post_id();
$field_id = isset($field['id']) ? $field['id'] : false;
$meta_id = isset($field['__meta_id']) ? $field['__meta_id'] : false;
} else {
$post_id = isset($field->meta_object->post_id) ? $field->meta_object->post_id : false;
$field_id = isset($field->cf['id']) ? $field->cf['id'] : false;
$meta_id = isset($field->meta_object->meta_id) ? $field->meta_object->meta_id : false;
}
if (empty($post_id) || empty($meta_id) || empty($field_id)) {
return $value;
}
$field_slug = wpcf_types_get_meta_prefix() . $field_id;
// Check if cached
static $cache = array();
$cache_key = $meta_id;
if (isset($cache[$cache_key]) && $use_cache) {
return $cache[$cache_key];
}
$_meta = wpcf_get_post_meta($post_id, '_wpcf_' . $field_id . '_hour_and_minute', true);
/*
* If meta exists - it's outdated value
* and Hour and Minute should be appended and removed.
*/
if (!empty($_meta) && is_array($_meta) && isset($_meta[$meta_id])) {
$meta = $_meta[$meta_id];
// Return empty date if can not be calculated
if (!empty($meta['timestamp']) || !empty($meta['datepicker'])) {
$meta['timestamp'] = wpcf_fields_date_value_get_filter($meta, $field, 'timestamp', 'check_leftover');
// Check if calculation needed
if (isset($meta['hour']) && $meta['hour'] != adodb_date('H', $meta['timestamp']) || isset($meta['minute']) && $meta['minute'] != adodb_date('i', $meta['timestamp'])) {
$value = wpcf_fields_date_calculate_time($meta);
}
}
}
// Cache it
if ($use_cache) {
$cache[$cache_key] = $value;
}
return $value;
}
function _fetch()
{
$rs = $this->_queryID;
if (!$rs or $rs->EOF) {
$this->fields = false;
return false;
}
$this->fields = array();
if (!$this->_tarr) {
$tarr = array();
$flds = array();
for ($i = 0, $max = $this->_numOfFields; $i < $max; $i++) {
$f = $rs->Fields($i);
$flds[] = $f;
$tarr[] = $f->Type;
}
// bind types and flds only once
$this->_tarr = $tarr;
$this->_flds = $flds;
}
$t = reset($this->_tarr);
$f = reset($this->_flds);
if ($this->hideErrors) {
$olde = error_reporting(E_ERROR | E_CORE_ERROR);
}
// sometimes $f->value be null
for ($i = 0, $max = $this->_numOfFields; $i < $max; $i++) {
//echo "<p>",$t,' ';var_dump($f->value); echo '</p>';
switch ($t) {
case 135:
// timestamp
if (!strlen((string) $f->value)) {
$this->fields[] = false;
} else {
if (!is_numeric($f->value)) {
$val = variant_date_to_timestamp($f->value);
} else {
$val = $f->value;
}
$this->fields[] = adodb_date('Y-m-d H:i:s', $val);
}
break;
case 133:
// A date value (yyyymmdd)
if ($val = $f->value) {
$this->fields[] = substr($val, 0, 4) . '-' . substr($val, 4, 2) . '-' . substr($val, 6, 2);
} else {
$this->fields[] = false;
}
break;
case 7:
// adDate
if (!strlen((string) $f->value)) {
$this->fields[] = false;
} else {
if (!is_numeric($f->value)) {
$val = variant_date_to_timestamp($f->value);
} else {
$val = $f->value;
}
if ($val % 86400 == 0) {
$this->fields[] = adodb_date('Y-m-d', $val);
} else {
$this->fields[] = adodb_date('Y-m-d H:i:s', $val);
}
}
break;
case 1:
// null
$this->fields[] = false;
break;
case 6:
// currency is not supported properly;
ADOConnection::outp('<b>' . $f->Name . ': currency type not supported by PHP</b>');
$this->fields[] = (double) $f->value;
break;
default:
$this->fields[] = $f->value;
break;
}
//print " $f->value $t, ";
$f = next($this->_flds);
$t = next($this->_tarr);
}
// for
if ($this->hideErrors) {
error_reporting($olde);
}
@$rs->MoveNext();
// @ needed for some versions of PHP!
if ($this->fetchMode & ADODB_FETCH_ASSOC) {
$this->fields =& $this->GetRowAssoc(ADODB_ASSOC_CASE);
}
return true;
}
function DBTimeStamp($ts, $isfld = false)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
if (is_string($ts)) {
$ts = ADORecordSet::UnixTimeStamp($ts);
}
return 'TO_DATE(' . adodb_date($this->fmtTimeStamp, $ts) . ",'YYYY-MM-DD HH24:MI:SS')";
}
function FormatDate($format, $date)
{
if ($this->UseAdodbTime) {
return adodb_date($format, $date);
} else {
return date($format, $date);
}
}
function _fetch()
{
$rs = $this->_queryID;
if (!$rs or $rs->EOF) {
$this->fields = false;
return false;
}
$this->fields = array();
if (!$this->_tarr) {
$tarr = array();
$flds = array();
$i = 0;
for ($max = $this->_numOfFields; $i < $max; ++$i) {
$f = $rs->Fields($i);
$flds[] = $f;
$tarr[] = $f->Type;
}
$this->_tarr = $tarr;
$this->_flds = $flds;
}
$t = reset($this->_tarr);
$f = reset($this->_flds);
if ($this->hideErrors) {
$olde = error_reporting(E_ERROR | E_CORE_ERROR);
}
$i = 0;
for ($max = $this->_numOfFields; $i < $max; ++$i) {
switch ($t) {
case 135:
if (!strlen((string) $f->value)) {
$this->fields[] = false;
break;
} else {
if (!is_numeric($f->value)) {
$val = variant_date_to_timestamp($f->value);
} else {
$val = $f->value;
}
$this->fields[] = adodb_date('Y-m-d H:i:s', $val);
break;
}
break;
case 133:
if ($val = $f->value) {
$this->fields[] = substr($val, 0, 4) . '-' . substr($val, 4, 2) . '-' . substr($val, 6, 2);
break;
} else {
$this->fields[] = false;
break;
}
break;
case 7:
if (!strlen((string) $f->value)) {
$this->fields[] = false;
break;
} else {
if (!is_numeric($f->value)) {
$val = variant_date_to_timestamp($f->value);
} else {
$val = $f->value;
}
if ($val % 86400 == 0) {
$this->fields[] = adodb_date('Y-m-d', $val);
break;
} else {
$this->fields[] = adodb_date('Y-m-d H:i:s', $val);
break;
}
break;
}
break;
case 1:
$this->fields[] = false;
break;
case 6:
adoconnection::outp('<b>' . $f->Name . ': currency type not supported by PHP</b>');
$this->fields[] = (double) $f->value;
break;
default:
$this->fields[] = $f->value;
break;
}
$f = next($this->_flds);
$t = next($this->_tarr);
}
if ($this->hideErrors) {
error_reporting($olde);
}
@$rs->MoveNext();
if ($this->fetchMode & ADODB_FETCH_ASSOC) {
$this->fields =& $this->GetRowAssoc(ADODB_ASSOC_CASE);
}
return true;
}
public function wpt_localize_extended_date()
{
if (!isset($_POST['date'])) {
die;
}
$date = $_POST['date'];
$date_format = '';
if (isset($_POST['date-format'])) {
$date_format = $_POST['date-format'];
}
if ($date_format == '') {
$date_format = get_option('date_format');
}
$date = adodb_mktime(0, 0, 0, substr($date, 2, 2), substr($date, 0, 2), substr($date, 4, 4));
$date_format = str_replace('\\\\', '\\', $date_format);
echo json_encode(array('display' => adodb_date($date_format, $date), 'timestamp' => $date));
die;
}
function DBTimeStamp($ts)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
if (is_string($ts)) {
$ts = ADORecordSet::UnixTimeStamp($ts);
}
return 'TO_DATE(' . adodb_date($this->fmtTimeStamp, $ts) . ",'RRRR-MM-DD, HH:MI:SS AM')";
}
function DBTimeStamp($ts)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
if (is_string($ts)) {
$ts = ADORecordSet::UnixTimeStamp($ts);
}
// See #8387 for more details
// original: return 'TO_DATE('.adodb_date($this->fmtTimeStamp,$ts).",'YYYY-MM-DD HH24:MI:SS')";
return adodb_date($this->fmtTimeStamp, $ts);
}
/**
* View function.
*
* @param type $params
*/
function wpcf_fields_date_view($params)
{
global $wp_locale;
$defaults = array('format' => get_option('date_format'), 'style' => '');
$params = wp_parse_args($params, $defaults);
$output = '';
// Make sure value is right
$__timestamp = wpcf_fields_date_value_get_filter($params['field_value'], $params['field'], 'timestamp');
if (is_null($__timestamp)) {
return '';
} else {
$params['field_value'] = $__timestamp;
}
switch ($params['style']) {
case 'calendar':
$output .= wpcf_fields_date_get_calendar($params, true, false);
break;
default:
$field_name = '';
// Extract the Full month and Short month from the format.
// We'll replace with the translated months if possible.
$format = $params['format'];
//$format = str_replace( 'F', '#111111#', $format );
//$format = str_replace( 'M', '#222222#', $format );
// Same for the Days
//$format = str_replace( 'D', '#333333#', $format );
//$format = str_replace( 'l', '#444444#', $format );
$date_out = adodb_date($format, $params['field_value']);
//$month = adodb_date( 'm', $params['field_value'] );
//$month_full = $wp_locale->get_month( $month );
//$date_out = str_replace( '#111111#', $month_full, $date_out );
//$month_short = $wp_locale->get_month_abbrev( $month_full );
//$date_out = str_replace( '#222222#', $month_short, $date_out );
//$day = adodb_date( 'w', $params['field_value'] );
//$day_full = $wp_locale->get_weekday( $day );
//$date_out = str_replace( '#444444#', $day_full, $date_out );
//$day_short = $wp_locale->get_weekday_abbrev( $day_full );
//$date_out = str_replace( '#333333#', $day_short, $date_out );
$output .= $date_out;
break;
}
return $output;
}
/**
* cred-post-expiration-shortcode: cred-post-expiration
*
* Description: Display the expiration date/time of the current post
*
* Parameters:
* id => post ID, defaults to global $post->ID
* format => Format string for the date. Defaults to Wordpress settings option (date_format)
*
* Example usage:
* Expiration on [cred-post-expiration format="F jS, Y"]
*
* Link:
* Format parameter is the same as here: http://codex.wordpress.org/Formatting_Date_and_Time
*
* Note:
*
*/
function cred_pe_shortcode_cred_post_expiration($atts)
{
extract(shortcode_atts(array('id' => '', 'format' => get_option('date_format')), $atts));
$out = '';
$post_id = $id;
global $post;
if (empty($post_id) && isset($post->ID)) {
$post_id = $post->ID;
}
if (!empty($post_id)) {
$post_expiration_time = get_post_meta($post_id, $this->_post_expiration_time_field, true);
if (self::_isTimestampInRange($post_expiration_time)) {
$out = apply_filters('the_time', adodb_date($format, $post_expiration_time));
}
}
return $out;
}
/**
* Format date according to a format string, uses ATK's language files to translate
* months, weekdays etc.
*
* @param $date mixed timestamp or date array (gotten with getdate())
* @param $format string format string, compatible with PHP's date format functions
* @param $weekday bool always include day-of-week or not
*
* @return string formatted date
*/
public static function atkFormatDate($date, $format, $weekday = false)
{
static $langcache = [];
if (!is_array($date)) {
$date = getdate($date);
}
/* format month */
$format = str_replace('M', '%-%', $format);
$format = str_replace('F', '%=%', $format);
/* format day */
$format = str_replace('D', '%&%', $format);
$format = str_replace('l', '%*%', $format);
if ($weekday && strpos($format, '%&%') === false && strpos($format, '%*%') === false) {
$format = str_replace('d', '%*% d', $format);
$format = str_replace('j', '%*% j', $format);
}
/* get date string */
$str_date = adodb_date($format, $date[0]);
$month = $date['month'];
$shortmonth = substr(strtolower($date['month']), 0, 3);
/* store the self::text calls */
if (!isset($langcache[$month])) {
$langcache[$month] = self::atktext(strtolower($month), 'atk');
}
if (!isset($langcache[$shortmonth])) {
$langcache[$shortmonth] = self::atktext($shortmonth);
}
/* replace month/week name */
$str_date = str_replace('%-%', $langcache[$shortmonth], $str_date);
$str_date = str_replace('%=%', $langcache[$month], $str_date);
$str_date = str_replace('%*%', self::atktext(strtolower($date['weekday']), 'atk'), $str_date);
$str_date = str_replace('%&%', self::atktext(substr(strtolower($date['weekday']), 0, 3), 'atk'), $str_date);
/* return string */
return $str_date;
}
function cal_to_include($args)
{
//echo "<p>cal_to_include("; print_r($args); echo ")</p>\n";
$user = intval($args['owner']);
if ($user <= 0 && !checkdate($args['month'], $args['day'], $args['year'])) {
return False;
}
if (!is_object($GLOBALS['phpgw']->html)) {
$GLOBALS['phpgw']->html = CreateObject('phpgwapi.html');
}
$GLOBALS['phpgw']->translation->add_app('infolog');
$do_events = $args['location'] == 'calendar_include_events';
$to_include = array();
$date_wanted = sprintf('%04d/%02d/%02d', $args['year'], $args['month'], $args['day']);
$query = array('order' => 'info_startdate', 'sort' => $do_events ? 'ASC' : 'DESC', 'filter' => "user{$user}" . ($do_events ? 'date' : 'opentoday') . $date_wanted, 'start' => 0);
while ($infos = $this->search($query)) {
foreach ($infos as $info) {
$time = (int) adodb_date('Hi', $info['info_startdate']);
$date = adodb_date('Y/m/d', $info['info_startdate']);
if ($do_events && !$time || !$do_events && $time && $date == $date_wanted) {
continue;
}
$title = ($do_events ? $GLOBALS['phpgw']->common->formattime(adodb_date('H', $info['info_startdate']), adodb_date('i', $info['info_startdate'])) . ' ' : '') . $info['info_subject'];
$view = $this->link->view('infolog', $info['info_id']);
$content = array();
foreach ($icons = array($info['info_type'] => 'infolog', $info['info_status'] => 'infolog') as $name => $app) {
$content[] = $GLOBALS['phpgw']->html->image($app, $name, lang($name), 'border="0" width="15" height="15"') . ' ';
}
$content[] = $GLOBALS['phpgw']->html->a_href($title, $view);
$content = $GLOBALS['phpgw']->html->table(array(1 => $content));
$to_include[] = array('starttime' => $info['info_startdate'], 'endtime' => $info['info_enddate'] ? $info['info_enddate'] : $info['info_startdate'], 'title' => $title, 'view' => $view, 'icons' => $icons, 'content' => $content);
}
if ($query['total'] <= ($query['start'] += count($infos))) {
break;
// no more availible
}
}
//echo "boinfolog::cal_to_include("; print_r($args); echo ")<pre>"; print_r($to_include); echo "</pre>\n";
return $to_include;
}
function mkActiveDate($param, $acttime = false)
{
if (!$acttime) {
$acttime = $this->timetoday;
}
if (function_exists("adodb_date")) {
return adodb_date($param, $acttime);
} else {
return date($param, $acttime);
}
}
/**
* Single condition form elements.
*
* @param type $data
* @param type $condition
* @param type $key
* @return string
*/
function wpcf_cd_admin_form_single_filter($data, $condition, $key = null, $group = false, $force_multi = false)
{
global $wpcf;
if ($group) {
$name = 'wpcf[group][conditional_display]';
} else {
$name = 'wpcf[fields][' . $data['id'] . '][conditional_display]';
}
$group_id = isset($_GET['group_id']) ? intval($_GET['group_id']) : false;
/*
*
*
* TODO Review this allowing fields from same group as conditional (self loop)
* I do not remember allowing fields from same group as conditional (self loop)
* on Group Fields edit screen.
*/
// if ( $group_id && !$group ) {// Allow group to use other fields
// $fields = wpcf_admin_fields_get_fields_by_group( $group_id );
// } else {
$fields = wpcf_admin_fields_get_fields(true, false, true);
ksort($fields, SORT_STRING);
// }
if ($group) {
$_distinct = wpcf_admin_fields_get_fields_by_group($group_id);
foreach ($_distinct as $_field_id => $_field) {
if (isset($fields[$_field_id])) {
unset($fields[$_field_id]);
}
}
}
$options = array();
$ignore_field_type_array = array('audio', 'checkboxes', 'embed', 'file', 'image', 'video', 'wysiwyg');
$flag_repetitive = false;
foreach ($fields as $field_id => $field) {
if (!$group && $data['id'] == $field_id) {
continue;
}
// WE DO NOT ALLOW repetitive fields to be compared.
if (wpcf_admin_is_repetitive($field)) {
$flag_repetitive = true;
continue;
}
/**
* Skip some files
*/
if (in_array($field['type'], $ignore_field_type_array)) {
continue;
}
/**
* build options
*/
$options[$field_id] = array('#value' => $field_id, '#title' => stripslashes($field['name']), '#attributes' => array('class' => 'wpcf-conditional-select-' . $field['type']));
}
/*
* Special case
* https://icanlocalize.basecamphq.com/projects/7393061-wp-views/todo_items/153565054/comments
*
* When field is new and only one diff field in list - that
* means one field is saved but other not yet.
*/
$is_new = isset($data['id']) && isset($fields[$data['id']]) ? false : true;
$special_stop = false;
if ($is_new) {
if (count($options) == 1) {
$special_stop = true;
}
}
/*
*
* This means all fields are repetitive and no one left to compare with.
* WE DO NOT ALLOW repetitive fields to be compared.
*/
if (!$group && empty($options) && $flag_repetitive) {
return array('cd' => array('#type' => 'markup', '#markup' => '<p class="wpcf-error">' . __('Conditional display is only working based on non-repeating fields. All fields in this group are repeating, so you cannot set their display based on other fields.', 'wpcf') . '</p>' . wpcf_conditional_disable_add_js($data['id'])));
} else {
if (!$group && (empty($options) || $special_stop)) {
return array('cd' => array('#type' => 'markup', '#markup' => '<p>' . __('You will be able to set conditional field display when you save more fields.', 'wpcf') . '</p>'));
}
}
$id = !is_null($key) ? $key : strval('condition_' . wpcf_unique_id(serialize($data) . serialize($condition) . $key . $group));
$form = array();
$before = '<div class="wpcf-cd-entry"><br />';
$form['cd']['field_' . $id] = array('#type' => 'select', '#name' => $name . '[conditions][' . $id . '][field]', '#options' => $options, '#inline' => true, '#before' => $before, '#default_value' => isset($condition['field']) ? $condition['field'] : null, '#attributes' => array('class' => 'wpcf-cd-field'));
$form['cd']['operation_' . $id] = array('#type' => 'select', '#name' => $name . '[conditions][' . $id . '][operation]', '#options' => array_flip(wpcf_cd_admin_operations()), '#inline' => true, '#default_value' => isset($condition['operation']) ? $condition['operation'] : null, '#attributes' => array('class' => 'wpcf-cd-operation'));
$form['cd']['value_' . $id] = array('#type' => 'textfield', '#name' => $name . '[conditions][' . $id . '][value]', '#inline' => true, '#value' => isset($condition['value']) ? $condition['value'] : '', '#attributes' => array('class' => 'wpcf-cd-value'));
/*
*
* Adjust for date
*/
if (!empty($condition['value'])) {
WPCF_Loader::loadInclude('fields/date/functions.php');
$timestamp = wpcf_fields_date_convert_datepicker_to_timestamp($condition['value']);
if ($timestamp !== false) {
$date_value = adodb_date('d', $timestamp) . ',' . adodb_date('m', $timestamp) . ',' . adodb_date('Y', $timestamp);
$date_function = 'date';
} else {
if (wpcf_fields_date_timestamp_is_valid($condition['value'])) {
$date_value = adodb_date('d', $condition['value']) . ',' . adodb_date('m', $condition['value']) . ',' . adodb_date('Y', $condition['value']);
$date_function = 'date';
}
}
}
if (empty($date_value)) {
$date_value = '';
$date_function = false;
}
$form['cd']['value_date_' . $id] = array('#type' => 'markup', '#markup' => '<br />' . wpcf_conditional_add_date_controls($date_function, $date_value, $name . '[conditions][' . $id . ']'), '#attributes' => array('class' => 'wpcf-cd-value-date'));
$form['cd']['remove_' . $id] = array('#type' => 'button', '#name' => 'remove', '#value' => __('Remove condition', 'wpcf'), '#attributes' => array('onclick' => 'wpcfCdRemoveCondition(jQuery(this));', 'class' => 'wpcf-add-condition'), '#after' => '</div><br />');
return $form['cd'];
}
/**
* wpv_render_datepicker
*
* Renders the datepicker for date based frontend filters
*
* @param $url_param (string) the URL parameter used on the frontend filter
* @param $date_format (string) the date format to use when displaying the selected date besides the datepicker
* @param $default_date (string) the default date to be used when there is no value passed by the URL parameter - special case NONE
*
* @return (string) containing the needed inputs
*
* @since unknown
*
* @note $default_date default value was changed in 1.7 from NOW() to NONE; empty will mean NONE too
*
* @todo add an attribute for themes http://rtsinani.github.io/jquery-datepicker-skins/
* OR better an option in the Views settings, because we can not have two different styles for two datepickers
*/
function wpv_render_datepicker( $url_param, $date_format, $default_date = '' ) {
static $support_loaded = false;
$display_date = $datepicker_date = '';
// TODO we need to enqueue this style in the right way. We are loading it twice! And it can not be unregistered...
if ( !$support_loaded && 1 === 0 ) {
?>
<script type="text/javascript">
jQuery(document).ready(function () {
jQuery('head').append('<link rel="stylesheet" href="<?php echo WPV_URL_EMBEDDED . '/common/toolset-forms/css/wpt-jquery-ui/datepicker.css';?>" type="text/css" />');
});
</script>
<?php
$support_loaded = true;
}
if ( $date_format == '' ) {
$date_format = get_option( 'date_format' );
}
$clear_button_style = '';
$date = '';
if( isset( $_GET[$url_param] ) ) {
if ( $_GET[$url_param] == '' || $_GET[$url_param] == '0' ) {
$date = '';
} else {
$date = $_GET[$url_param];
}
} else {
if (
$default_date == ''
|| $default_date == 'NONE'
) {
$date = '';
} else {
$date = wpv_filter_parse_date( $default_date );
}
}
if ( is_numeric( $date ) ) {
if (
$date < -12219292800
|| $date > 32535215940
) {
$date = '';
}
} else {
$date = '';
}
if ( $date != '' ) {
$display_date = adodb_date( $date_format, $date );
} else {
$clear_button_style = ' style="display:none"';
}
$out = '';
$out .= '<span class="wpv_date_input js-wpv-date-param-' . $url_param . ' js-wpv-date-display" data-param="' . $url_param . '">' . $display_date . '</span> ';
$out .= '<input type="hidden" class="js-wpv-date-param-' . $url_param . '-value js-wpv-filter-trigger" name="' . $url_param . '" value="' . $date . '" />';
$out .= '<input type="hidden" class="js-wpv-date-param-' . $url_param . '-format" name="' . $url_param . '-format" value="' . $date_format . '" />';
if ( $date != '' ) {
$datepicker_date = adodb_date( 'dmY', $date );
}
$out .= '<input type="hidden" data-param="' . $url_param . '" class="wpv-date-front-end js-wpv-frontend-datepicker js-wpv-date-front-end-' . $url_param . '" value="' . $datepicker_date . '"/>';
$delete_date_image = WPV_URL_EMBEDDED_FRONTEND . '/res/img/delete.png';
$delete_date_image = apply_filters( 'wpv_filter_wpv_delete_date_image', $delete_date_image );
$delete_date_image = apply_filters( 'wptoolset_filter_wptoolset_delete_date_image', $delete_date_image );
$out .= '<img src="' . $delete_date_image . '" title="' . esc_attr( __( 'Clear date', 'wpv-views' ) ) . '" alt="' . esc_attr( __( 'Clear date', 'wpv-views' ) ) . '" class="wpv-date-front-end-clear js-wpv-date-front-end-clear js-wpv-date-front-end-clear-' . $url_param . '" data-param="' . $url_param . '"' . $clear_button_style . ' />';
return $out;
}
function DBTimeStamp($ts, $isfld = false)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
if ($isfld) {
return 'TO_DATE(substr(' . $ts . ",1,19),'RRRR-MM-DD, HH24:MI:SS')";
}
if (is_string($ts)) {
$ts = ADORecordSet::UnixTimeStamp($ts);
}
return 'TO_DATE(' . adodb_date("'Y-m-d H:i:s'", $ts) . ",'RRRR-MM-DD, HH24:MI:SS')";
}
<?php
include_once '../adodb-time.inc.php';
//adodb_date_test();
//require("adodb-time.inc.php");
echo adodb_date('d/m/Y', adodb_mktime(0, 0, 0, 12, 1, 2056));
$datestring = "1963-12-04";
// string normally from mySQL
$stringArray = explode("-", $datestring);
$date = adodb_mktime(0, 0, 0, $stringArray[1], $stringArray[2], $stringArray[0]);
$convertedDate = date("d-M-Y", $date);
// converted string to UK style date
echo "Birthday: {$convertedDate}";
//why is string returned as one day (3 not 4) less for this example??
function DBTimeStamp($ts)
{
if (empty($ts) && $ts !== 0) return 'null';
if (is_string($ts)) $ts = ADORecordSet::UnixTimeStamp($ts);
return 'TO_DATE('.adodb_date("'Y-m-d H:i:s'",$ts).",'RRRR-MM-DD, HH24:MI:SS')";
}
public static function timetodate($timestamp, $format = null)
{
if (is_null($format)) {
$format = self::getDateFormat();
}
return self::_isTimestampInRange($timestamp) ? @adodb_date($format, $timestamp) : false;
}
function wpv_format_date()
{
$date_format = $_POST['date-format'];
if ($date_format == '') {
$date_format = get_option('date_format');
}
// this is needed to escape characters in the date_i18n function
$date_format = str_replace('\\\\', '\\', $date_format);
$date = $_POST['date'];
// We can not be sure that the adodb_xxx functions are available, so we do different things whether they exist or not
if (defined('ADODB_DATE_VERSION')) {
$date = adodb_mktime(0, 0, 0, substr($date, 2, 2), substr($date, 0, 2), substr($date, 4, 4));
echo json_encode(array('display' => adodb_date($date_format, $date), 'timestamp' => $date));
} else {
$date = mktime(0, 0, 0, substr($date, 2, 2), substr($date, 0, 2), substr($date, 4, 4));
echo json_encode(array('display' => date_i18n($date_format, intval($date)), 'timestamp' => $date));
}
die;
}
function _fetch()
{
$rs = $this->_queryID;
if (!$rs or $rs->EOF) {
$this->fields = false;
return false;
}
$this->fields = array();
if (!$this->_tarr) {
$tarr = array();
$flds = array();
for ($i=0,$max = $this->_numOfFields; $i < $max; $i++) {
$f = $rs->Fields($i);
$flds[] = $f;
$tarr[] = $f->Type;
}
// bind types and flds only once
$this->_tarr = $tarr;
$this->_flds = $flds;
}
$t = reset($this->_tarr);
$f = reset($this->_flds);
if ($this->hideErrors) $olde = error_reporting(E_ERROR|E_CORE_ERROR);// sometimes $f->value be null
for ($i=0,$max = $this->_numOfFields; $i < $max; $i++) {
//echo "<p>",$t,' ';var_dump($f->value); echo '</p>';
switch($t) {
case 135: // timestamp
if (!strlen((string)$f->value)) $this->fields[] = false;
else {
if (!is_numeric($f->value)) # $val = variant_date_to_timestamp($f->value);
// VT_DATE stores dates as (float) fractional days since 1899/12/30 00:00:00
$val= (float) variant_cast($f->value,VT_R8)*3600*24-2209161600;
else
$val = $f->value;
$this->fields[] = adodb_date('Y-m-d H:i:s',$val);
}
break;
case 133:// A date value (yyyymmdd)
if ($val = $f->value) {
$this->fields[] = substr($val,0,4).'-'.substr($val,4,2).'-'.substr($val,6,2);
} else
$this->fields[] = false;
break;
case 7: // adDate
if (!strlen((string)$f->value)) $this->fields[] = false;
else {
if (!is_numeric($f->value)) $val = variant_date_to_timestamp($f->value);
else $val = $f->value;
if (($val % 86400) == 0) $this->fields[] = adodb_date('Y-m-d',$val);
else $this->fields[] = adodb_date('Y-m-d H:i:s',$val);
}
break;
case 1: // null
$this->fields[] = false;
break;
case 20:
case 21: // bigint (64 bit)
$this->fields[] = (float) $f->value; // if 64 bit PHP, could use (int)
break;
case 6: // currency is not supported properly;
ADOConnection::outp( '<b>'.$f->Name.': currency type not supported by PHP</b>');
$this->fields[] = (float) $f->value;
break;
case 11: //BIT;
$val = "";
if(is_bool($f->value)) {
if($f->value==true) $val = 1;
else $val = 0;
}
if(is_null($f->value)) $val = null;
$this->fields[] = $val;
break;
default:
$this->fields[] = $f->value;
break;
}
//print " $f->value $t, ";
$f = next($this->_flds);
$t = next($this->_tarr);
} // for
if ($this->hideErrors) error_reporting($olde);
@$rs->MoveNext(); // @ needed for some versions of PHP!
if ($this->fetchMode & ADODB_FETCH_ASSOC) {
$this->fields = $this->GetRowAssoc(ADODB_ASSOC_CASE);
}
return true;
}
function BindTimeStamp($ts)
{
if (empty($ts) && $ts !== 0) {
return 'null';
}
if (is_string($ts)) {
$ts = ADORecordSet::UnixTimeStamp($ts);
}
if (is_object($ts)) {
$tss = $ts->format("'Y-m-d H:i:s'");
} else {
$tss = adodb_date("'Y-m-d H:i:s'", $ts);
}
return $tss;
}
function adodb_strftime($fmt, $ts = false, $is_gmt = false)
{
global $ADODB_DATE_LOCALE;
if (!defined('ADODB_TEST_DATES')) {
if (abs($ts) <= 0x7fffffff) {
// check if number in 32-bit signed range
if (!defined('ADODB_NO_NEGATIVE_TS') || $ts >= 0) {
// if windows, must be +ve integer
return $is_gmt ? @gmstrftime($fmt, $ts) : @strftime($fmt, $ts);
}
}
}
if (empty($ADODB_DATE_LOCALE)) {
/*
$tstr = strtoupper(gmstrftime('%c',31366800)); // 30 Dec 1970, 1 am
$sep = substr($tstr,2,1);
$hasAM = strrpos($tstr,'M') !== false;
*/
# see http://phplens.com/lens/lensforum/msgs.php?id=14865 for reasoning, and changelog for version 0.24
$dstr = gmstrftime('%x', 31366800);
// 30 Dec 1970, 1 am
$sep = substr($dstr, 2, 1);
$tstr = strtoupper(gmstrftime('%X', 31366800));
// 30 Dec 1970, 1 am
$hasAM = strrpos($tstr, 'M') !== false;
$ADODB_DATE_LOCALE = array();
$ADODB_DATE_LOCALE[] = strncmp($tstr, '30', 2) == 0 ? 'd' . $sep . 'm' . $sep . 'y' : 'm' . $sep . 'd' . $sep . 'y';
$ADODB_DATE_LOCALE[] = $hasAM ? 'h:i:s a' : 'H:i:s';
}
$inpct = false;
$fmtdate = '';
for ($i = 0, $max = strlen($fmt); $i < $max; $i++) {
$ch = $fmt[$i];
if ($ch == '%') {
if ($inpct) {
$fmtdate .= '%';
$inpct = false;
} else {
$inpct = true;
}
} else {
if ($inpct) {
$inpct = false;
switch ($ch) {
case '0':
case '1':
case '2':
case '3':
case '4':
case '5':
case '6':
case '7':
case '8':
case '9':
case 'E':
case 'O':
/* ignore format modifiers */
$inpct = true;
break;
case 'a':
$fmtdate .= 'D';
break;
case 'A':
$fmtdate .= 'l';
break;
case 'h':
case 'b':
$fmtdate .= 'M';
break;
case 'B':
$fmtdate .= 'F';
break;
case 'c':
$fmtdate .= $ADODB_DATE_LOCALE[0] . $ADODB_DATE_LOCALE[1];
break;
case 'C':
$fmtdate .= '\\C?';
break;
// century
// century
case 'd':
$fmtdate .= 'd';
break;
case 'D':
$fmtdate .= 'm/d/y';
break;
case 'e':
$fmtdate .= 'j';
break;
case 'g':
$fmtdate .= '\\g?';
break;
//?
//?
case 'G':
$fmtdate .= '\\G?';
break;
//?
//?
case 'H':
$fmtdate .= 'H';
break;
case 'I':
$fmtdate .= 'h';
break;
case 'j':
$fmtdate .= '?z';
$parsej = true;
break;
// wrong as j=1-based, z=0-basd
// wrong as j=1-based, z=0-basd
case 'm':
$fmtdate .= 'm';
break;
case 'M':
$fmtdate .= 'i';
break;
case 'n':
$fmtdate .= "\n";
break;
case 'p':
$fmtdate .= 'a';
break;
case 'r':
$fmtdate .= 'h:i:s a';
break;
case 'R':
$fmtdate .= 'H:i:s';
break;
case 'S':
$fmtdate .= 's';
break;
case 't':
$fmtdate .= "\t";
break;
case 'T':
$fmtdate .= 'H:i:s';
break;
case 'u':
$fmtdate .= '?u';
$parseu = true;
break;
// wrong strftime=1-based, date=0-based
// wrong strftime=1-based, date=0-based
case 'U':
$fmtdate .= '?U';
$parseU = true;
break;
// wrong strftime=1-based, date=0-based
// wrong strftime=1-based, date=0-based
case 'x':
$fmtdate .= $ADODB_DATE_LOCALE[0];
break;
case 'X':
$fmtdate .= $ADODB_DATE_LOCALE[1];
break;
case 'w':
$fmtdate .= '?w';
$parseu = true;
break;
// wrong strftime=1-based, date=0-based
// wrong strftime=1-based, date=0-based
case 'W':
$fmtdate .= '?W';
$parseU = true;
break;
// wrong strftime=1-based, date=0-based
// wrong strftime=1-based, date=0-based
case 'y':
$fmtdate .= 'y';
break;
case 'Y':
$fmtdate .= 'Y';
break;
case 'Z':
$fmtdate .= 'T';
break;
}
} else {
if ('A' <= $ch && $ch <= 'Z' || 'a' <= $ch && $ch <= 'z') {
$fmtdate .= "\\" . $ch;
} else {
$fmtdate .= $ch;
}
}
}
}
//echo "fmt=",$fmtdate,"<br>";
if ($ts === false) {
$ts = time();
}
$ret = adodb_date($fmtdate, $ts, $is_gmt);
return $ret;
}
$states->draw($img);
$iards->draw($img);
$bar640t->draw($img);
$rs = pg_prepare($coopdb, "SELECT", "SELECT station, \n\tsum(precip) as s_prec, sum(gdd50(high,low)) as s_gdd50,\n\tsum(sdd86(high,low)) as s_sdd86, min(low) as s_mintemp,\n\tmax(high) as s_maxtemp from alldata \n\tWHERE day >= \$1 and day <= \$2 GROUP by station \n\tORDER by station ASC");
$rs = pg_execute($coopdb, "SELECT", array(adodb_date("Y-m-d", $sts), adodb_date("Y-m-d", $ets)));
for ($i = 0; $row = @pg_fetch_array($rs, $i); $i++) {
$ukey = $row["station"];
if (!isset($cities[$ukey])) {
continue;
}
// Red Dot...
$pt = ms_newPointObj();
$pt->setXY($cities[$ukey]['lon'], $cities[$ukey]['lat'], 0);
$pt->draw($map, $ponly, $img, 0, '');
// City Name
$pt = ms_newPointObj();
$pt->setXY($cities[$ukey]['lon'], $cities[$ukey]['lat'], 0);
$pt->draw($map, $snet, $img, 3, $cities[$ukey]['name']);
// Value UL
$pt = ms_newPointObj();
$pt->setXY($cities[$ukey]['lon'], $cities[$ukey]['lat'], 0);
$pt->draw($map, $snet, $img, 0, round($row["s_" . $var], $rnd[$var]));
}
if ($i == 0) {
plotNoData($map, $img);
}
$title = sprintf("%s (%s through %s)", $varDef[$var], adodb_date("Y-m-d", $sts), adodb_date("Y-m-d", $ets));
mktitlelocal($map, $img, $title);
$map->drawLabelCache($img);
header("Content-type: image/png");
$img->saveImage('');
/**
* @param v is the character date in YYYY-MM-DD format, returned by database
* @param fmt is the format to apply to it, using date()
*
* @return a date formated as user desires
*/
function UserDate($v, $fmt = 'Y-m-d')
{
$tt = $this->UnixDate($v);
// $tt == -1 if pre TIMESTAMP_FIRST_YEAR
if (($tt === false || $tt == -1) && $v != false) {
return $v;
} else {
if ($tt == 0) {
return $this->emptyDate;
} else {
if ($tt == -1) {
// pre-TIMESTAMP_FIRST_YEAR
}
}
}
return adodb_date($fmt, $tt);
}
/**
* Return formatted date.
*
* You can supply a format as defined at http://php.net/date
*
* Default date is in ISO format
*/
function getDate($timestamp = null, $format = null)
{
$timestamp = !isset($timestamp) ? Ak::time() : $timestamp;
$use_adodb = $timestamp <= -3600 || $timestamp >= 2147468400;
if ($use_adodb) {
require_once AK_CONTRIB_DIR . DS . 'adodb' . DS . 'adodb-time.inc.php';
}
if (!isset($format)) {
return $use_adodb ? adodb_date('Y-m-d H:i:s', $timestamp) : date('Y-m-d H:i:s', $timestamp);
} elseif (!empty($format)) {
return $use_adodb ? adodb_date($format, $timestamp) : date($format, $timestamp);
}
trigger_error(Ak::t('You must supply a valid UNIX timetamp. You can get the timestamp by calling Ak::getTimestamp("2006-09-27 20:45:57")'));
return false;
}
