← All changes | classes/Visualizer/Source.php +223 -5 3.0.8 → 3.4.2 View file →

		@@ -57,8 +57,16 @@
57	57	*/
58	58	protected $_series = array();
59	59
60	60	/**
	61	+ * The error message.
	62	+ *
	63	+ * @access protected
	64	+ * @var string
	65	+ */
	66	+ protected $_error;
	67	+
	68	+ /**
61	69	* Return allowed types
62	70	*
63	71	* @since 1.0.1
64	72	*
		@@ -83,9 +91,9 @@
83	91	* @return boolean TRUE if sereis types are valid, otherwise FALSE.
84	92	*/
85	93	protected static function _validateTypes( $types ) {
86	94	foreach ( $types as $type ) {
87		- if ( ! in_array( $type, self::$allowed_types ) ) {
	95	+ if ( ! in_array( $type, self::$allowed_types, true ) ) {
88	96	return false;
89	97	}
90	98	}
91	99
		@@ -193,9 +201,8 @@
193	201	* @return array Normalized row of data.
194	202	*/
195	203	protected function _normalizeData( $data ) {
196	204	// normalize values
197		- // error_log(print_r($data,true));
198	205	foreach ( $this->_series as $i => $series ) {
199	206	// if no value exists for the seires, then add null
200	207	if ( ! isset( $data[ $i ] ) ) {
201	208	$data[ $i ] = null;
		@@ -207,9 +214,10 @@
207	214	case 'number':
208	215	$data[ $i ] = ( is_numeric( $data[ $i ] ) ) ? floatval( $data[ $i ] ) : ( is_numeric( str_replace( ',', '', $data[ $i ] ) ) ? floatval( str_replace( ',', '', $data[ $i ] ) ) : null );
209	216	break;
210	217	case 'boolean':
211		- $data[ $i ] = ! empty( $data[ $i ] ) ? filter_validate( $data[ $i ], FILTER_VALIDATE_BOOLEAN ) : null;
	218	+ $datum = trim( strval( $data[ $i ] ) );
	219	+ $data[ $i ] = in_array( $datum, array( 'true', 'yes', '1' ), true ) ? 'true' : 'false';
212	220	break;
213	221	case 'timeofday':
214	222	$date = new DateTime( '1984-03-16T' . $data[ $i ] );
215	223	if ( $date ) {
		@@ -220,8 +228,15 @@
220	228	0,
221	229	);
222	230	}
223	231	break;
	232	+ case 'datetime':
	233	+ // let's check if the date is a Unix epoch
	234	+ $value = DateTime::createFromFormat( 'U', $data[ $i ] );
	235	+ if ( $value !== false && ! is_wp_error( $value ) ) {
	236	+ $data[ $i ] = $value->format( 'Y-m-d H:i:s' );
	237	+ }
	238	+ break;
224	239	case 'string':
225	240	$data[ $i ] = $this->toUTF8( $data[ $i ] );
226	241	break;
227	242	}
		@@ -226,10 +241,9 @@
226	241	break;
227	242	}
228	243	}
229	244
230		- // error_log(print_r($data,true));
231		- return $data;
	245	+ return apply_filters( 'visualizer_format_data', $data, $this->_series );
232	246	}
233	247
234	248
235	249	/**
		@@ -246,6 +260,210 @@
246	260	$datum = \ForceUTF8\Encoding::toUTF8( $datum );
247	261	}
248	262	return $datum;
249	263	}
	264	+
	265	+ /**
	266	+ * Determines the formats of date/time columns.
	267	+ *
	268	+ * @access public
	269	+ *
	270	+ * @param array $series The actual array of series.
	271	+ * @param array $data The actual array of data.
	272	+ *
	273	+ * @return array
	274	+ */
	275	+ public static final function get_date_formats_if_exists( $series, $data ) {
	276	+ $date_formats = array();
	277	+ $types = array();
	278	+ $index = 0;
	279	+ foreach ( $series as $column ) {
	280	+ if ( in_array( $column['type'], array( 'date', 'datetime', 'timeofday' ), true ) ) {
	281	+ $types[] = array( 'index' => $index, 'type' => $column['type'] );
	282	+ }
	283	+ $index++;
	284	+ }
	285	+
	286	+ if ( ! $types ) {
	287	+ return $date_formats;
	288	+ }
	289	+
	290	+ $random = $data;
	291	+ // let's randomly pick 5 data points instead of cycling through the entire data set.
	292	+ if ( count( $data ) > 5 ) {
	293	+ $random = array();
	294	+ for ( $x = 0; $x < 5; $x++ ) {
	295	+ $random[] = $data[ rand( 0, count( $data ) - 1 ) ];
	296	+ }
	297	+ }
	298	+
	299	+ foreach ( $types as $type ) {
	300	+ $formats = array();
	301	+ foreach ( $random as $datum ) {
	302	+ $f = self::determine_date_format( $datum[ $type['index'] ], $type['type'] );
	303	+ if ( $f ) {
	304	+ $formats[] = $f;
	305	+ }
	306	+ }
	307	+ // if there are multiple formats, use the most frequent format.
	308	+ $formats = array_filter( $formats );
	309	+ if ( $formats ) {
	310	+ $formats = array_count_values( $formats );
	311	+ arsort( $formats );
	312	+ $formats = array_keys( $formats );
	313	+ $final_format = reset( $formats );
	314	+ // we have determined the PHP format; now we have to change this into the JS format where m = MM, d = DD etc.
	315	+ $date_formats[] = array( 'index' => $type['index'], 'format' => str_replace( array( 'Y', 'm', 'd', 'H', 'i', 's' ), array( 'YYYY', 'MM', 'DD', 'HH', 'mm', 'ss' ), $final_format ) );
	316	+ }
	317	+ }
	318	+ return $date_formats;
	319	+ }
	320	+
	321	+ /**
	322	+ * Determines the date/time format of the given string.
	323	+ *
	324	+ * @access private
	325	+ *
	326	+ * @param string $value The string.
	327	+ * @param string $type 'date', 'timeofday' or 'datetime'.
	328	+ *
	329	+ * @return string|null
	330	+ */
	331	+ private static final function determine_date_format( $value, $type ) {
	332	+ if ( version_compare( phpversion(), '5.3.0', '<' ) ) {
	333	+ do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'PHP version %s not supported', phpversion() ), 'error', __FILE__, __LINE__ );
	334	+ return null;
	335	+ }
	336	+
	337	+ $formats = array(
	338	+ 'Y/m/d',
	339	+ 'Y-m-d',
	340	+ 'm/d/Y',
	341	+ 'm-d-Y',
	342	+ 'd-m-Y',
	343	+ 'd/m/Y',
	344	+ );
	345	+
	346	+ switch ( $type ) {
	347	+ case 'datetime':
	348	+ $formats = array_merge(
	349	+ $formats, array(
	350	+ 'U',
	351	+ 'Y/m/d H:i:s',
	352	+ 'Y-m-d H:i:s',
	353	+ 'm/d/Y H:i:s',
	354	+ 'm-d-Y H:i:s',
	355	+ )
	356	+ );
	357	+ break;
	358	+ case 'timeofday':
	359	+ $formats = array_merge(
	360	+ $formats, array(
	361	+ 'H:i:s',
	362	+ 'H:i',
	363	+ )
	364	+ );
	365	+ break;
	366	+ }
	367	+
	368	+ $formats = apply_filters( 'visualizer_date_formats', $formats, $type );
	369	+
	370	+ foreach ( $formats as $format ) {
	371	+ $return = DateTime::createFromFormat( $format, $value );
	372	+ if ( $return !== false && ! is_wp_error( $return ) ) {
	373	+ return $format;
	374	+ }
	375	+ }
	376	+ // invalid format
	377	+ return null;
	378	+ }
	379	+
	380	+ /**
	381	+ * Returns the error, if any.
	382	+ *
	383	+ * @access public
	384	+ * @return string
	385	+ */
	386	+ public function get_error() {
	387	+ return $this->_error;
	388	+ }
	389	+
	390	+ /**
	391	+ * Fetches information from the editable table and parses it to build series and data arrays.
	392	+ *
	393	+ * @since ?
	394	+ *
	395	+ * @access public
	396	+ * @return boolean TRUE on success, otherwise FALSE.
	397	+ */
	398	+ public function fetchFromEditableTable() {
	399	+ if ( empty( $this->_args ) ) {
	400	+ return false;
	401	+ }
	402	+
	403	+ $this->_fetchSeriesFromEditableTable();
	404	+ $this->_fetchDataFromEditableTable();
	405	+ return true;
	406	+ }
	407	+
	408	+ /**
	409	+ * Fetches series information from the editable table. This is fetched only through the UI and not while refreshing the chart data.
	410	+ *
	411	+ * @since 1.0.0
	412	+ *
	413	+ * @access private
	414	+ */
	415	+ private function _fetchSeriesFromEditableTable() {
	416	+ $params = $this->_args;
	417	+ $headers = array_filter( $params['header'] );
	418	+ $types = array_filter( $params['type'] );
	419	+ $header_row = $type_row = array();
	420	+ if ( $headers ) {
	421	+ foreach ( $headers as $header ) {
	422	+ if ( ! empty( $types[ $header ] ) ) {
	423	+ $this->_series[] = array(
	424	+ 'label' => $header,
	425	+ 'type' => $types[ $header ],
	426	+ );
	427	+ }
	428	+ }
	429	+ }
	430	+
	431	+ do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Series found for %s = %s', print_r( $this->_args, true ), print_r( $this->_series, true ) ), 'debug', __FILE__, __LINE__ );
	432	+
	433	+ return true;
	434	+ }
	435	+
	436	+
	437	+ /**
	438	+ * Fetches data information from the editable table.
	439	+ *
	440	+ * @since 1.0.0
	441	+ *
	442	+ * @access private
	443	+ */
	444	+ private function _fetchDataFromEditableTable() {
	445	+ $params = $this->_args;
	446	+ $headers = wp_list_pluck( $this->_series, 'label' );
	447	+ $this->fetch();
	448	+
	449	+ $data = $this->_data;
	450	+ $this->_data = array();
	451	+
	452	+ foreach ( $data as $line ) {
	453	+ $data_row = array();
	454	+ foreach ( $line as $header => $value ) {
	455	+ // phpcs:ignore WordPress.PHP.StrictInArray.MissingTrueStrict
	456	+ if ( in_array( $header, $headers ) ) {
	457	+ $data_row[] = $value;
	458	+ }
	459	+ }
	460	+ $this->_data[] = $this->_normalizeData( $data_row );
	461	+ }
	462	+
	463	+ do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Data found for %s = %s', print_r( $this->_args, true ), print_r( $this->_data, true ) ), 'debug', __FILE__, __LINE__ );
	464	+
	465	+ return true;
	466	+ }
	467	+
250	468
251	469	}