← All changes | classes/Visualizer/Source.php +235 -8 3.1.1 → 3.6.1 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
		@@ -132,9 +140,12 @@
132	140	*
133	141	* @access public
134	142	* @return string The serialized array of data.
135	143	*/
136		- public function getData() {
	144	+ public function getData( $fetch_from_editable_table = false ) {
	145	+ if ( $fetch_from_editable_table ) {
	146	+ $this->_fetchDataFromEditableTable();
	147	+ }
137	148	return serialize( $this->_data );
138	149	}
139	150
140	151	/**
		@@ -144,9 +155,12 @@
144	155	*
145	156	* @access public
146	157	* @return array
147	158	*/
148		- public function getRawData() {
	159	+ public function getRawData( $fetch_from_editable_table = false ) {
	160	+ if ( $fetch_from_editable_table ) {
	161	+ $this->_fetchDataFromEditableTable();
	162	+ }
149	163	return $this->_data;
150	164	}
151	165
152	166	/**
		@@ -193,9 +207,8 @@
193	207	* @return array Normalized row of data.
194	208	*/
195	209	protected function _normalizeData( $data ) {
196	210	// normalize values
197		- // error_log(print_r($data,true));
198	211	foreach ( $this->_series as $i => $series ) {
199	212	// if no value exists for the seires, then add null
200	213	if ( ! isset( $data[ $i ] ) ) {
201	214	$data[ $i ] = null;
		@@ -207,9 +220,10 @@
207	220	case 'number':
208	221	$data[ $i ] = ( is_numeric( $data[ $i ] ) ) ? floatval( $data[ $i ] ) : ( is_numeric( str_replace( ',', '', $data[ $i ] ) ) ? floatval( str_replace( ',', '', $data[ $i ] ) ) : null );
209	222	break;
210	223	case 'boolean':
211		- $data[ $i ] = ! empty( $data[ $i ] ) ? filter_var( $data[ $i ], FILTER_VALIDATE_BOOLEAN ) : null;
	224	+ $datum = trim( strval( $data[ $i ] ) );
	225	+ $data[ $i ] = in_array( $datum, array( 'true', 'yes', '1' ), true ) ? 'true' : 'false';
212	226	break;
213	227	case 'timeofday':
214	228	$date = new DateTime( '1984-03-16T' . $data[ $i ] );
215	229	if ( $date ) {
		@@ -220,16 +234,23 @@
220	234	0,
221	235	);
222	236	}
223	237	break;
	238	+ case 'datetime':
	239	+ // let's check if the date is a Unix epoch
	240	+ $value = DateTime::createFromFormat( 'U', $data[ $i ] );
	241	+ if ( $value !== false && ! is_wp_error( $value ) ) {
	242	+ $data[ $i ] = $value->format( 'Y-m-d H:i:s' );
	243	+ }
	244	+ break;
224	245	case 'string':
225		- $data[ $i ] = $this->toUTF8( $data[ $i ] );
	246	+ // if a ' is provided, strip the backslash
	247	+ $data[ $i ] = stripslashes( $this->toUTF8( $data[ $i ] ) );
226	248	break;
227	249	}
228	250	}
229	251
230		- // error_log(print_r($data,true));
231		- return $data;
	252	+ return apply_filters( 'visualizer_format_data', $data, $this->_series );
232	253	}
233	254
234	255
235	256	/**
		@@ -246,6 +267,212 @@
246	267	$datum = \ForceUTF8\Encoding::toUTF8( $datum );
247	268	}
248	269	return $datum;
249	270	}
	271	+
	272	+ /**
	273	+ * Determines the formats of date/time columns.
	274	+ *
	275	+ * @access public
	276	+ *
	277	+ * @param array $series The actual array of series.
	278	+ * @param array $data The actual array of data.
	279	+ *
	280	+ * @return array
	281	+ */
	282	+ public static final function get_date_formats_if_exists( $series, $data ) {
	283	+ $date_formats = array();
	284	+ $types = array();
	285	+ $index = 0;
	286	+ foreach ( $series as $column ) {
	287	+ if ( in_array( $column['type'], array( 'date', 'datetime', 'timeofday' ), true ) ) {
	288	+ $types[] = array( 'index' => $index, 'type' => $column['type'] );
	289	+ }
	290	+ $index++;
	291	+ }
	292	+
	293	+ if ( ! $types ) {
	294	+ return $date_formats;
	295	+ }
	296	+
	297	+ $random = $data;
	298	+ // let's randomly pick 5 data points instead of cycling through the entire data set.
	299	+ if ( count( $data ) > 5 ) {
	300	+ $random = array();
	301	+ for ( $x = 0; $x < 5; $x++ ) {
	302	+ $random[] = $data[ rand( 0, count( $data ) - 1 ) ];
	303	+ }
	304	+ }
	305	+
	306	+ foreach ( $types as $type ) {
	307	+ $formats = array();
	308	+ foreach ( $random as $datum ) {
	309	+ $f = self::determine_date_format( $datum[ $type['index'] ], $type['type'] );
	310	+ if ( $f ) {
	311	+ $formats[] = $f;
	312	+ }
	313	+ }
	314	+ // if there are multiple formats, use the most frequent format.
	315	+ $formats = array_filter( $formats );
	316	+ if ( $formats ) {
	317	+ $formats = array_count_values( $formats );
	318	+ arsort( $formats );
	319	+ $formats = array_keys( $formats );
	320	+ $final_format = reset( $formats );
	321	+ // we have determined the PHP format; now we have to change this into the JS format where m = MM, d = DD etc.
	322	+ $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 ) );
	323	+ }
	324	+ }
	325	+ return $date_formats;
	326	+ }
	327	+
	328	+ /**
	329	+ * Determines the date/time format of the given string.
	330	+ *
	331	+ * @access private
	332	+ *
	333	+ * @param string $value The string.
	334	+ * @param string $type 'date', 'timeofday' or 'datetime'.
	335	+ *
	336	+ * @return string|null
	337	+ */
	338	+ private static function determine_date_format( $value, $type ) {
	339	+ if ( version_compare( phpversion(), '5.3.0', '<' ) ) {
	340	+ do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'PHP version %s not supported', phpversion() ), 'error', __FILE__, __LINE__ );
	341	+ return null;
	342	+ }
	343	+
	344	+ $formats = array(
	345	+ 'Y/m/d',
	346	+ 'Y-m-d',
	347	+ 'm/d/Y',
	348	+ 'm-d-Y',
	349	+ 'd-m-Y',
	350	+ 'd/m/Y',
	351	+ );
	352	+
	353	+ switch ( $type ) {
	354	+ case 'datetime':
	355	+ $formats = array_merge(
	356	+ $formats, array(
	357	+ 'U',
	358	+ 'Y/m/d H:i:s',
	359	+ 'Y-m-d H:i:s',
	360	+ 'm/d/Y H:i:s',
	361	+ 'm-d-Y H:i:s',
	362	+ )
	363	+ );
	364	+ break;
	365	+ case 'timeofday':
	366	+ $formats = array_merge(
	367	+ $formats, array(
	368	+ 'H:i:s',
	369	+ 'H:i',
	370	+ )
	371	+ );
	372	+ break;
	373	+ }
	374	+
	375	+ $formats = apply_filters( 'visualizer_date_formats', $formats, $type );
	376	+
	377	+ foreach ( $formats as $format ) {
	378	+ $return = DateTime::createFromFormat( $format, $value );
	379	+ if ( $return !== false && ! is_wp_error( $return ) ) {
	380	+ return $format;
	381	+ }
	382	+ }
	383	+ // invalid format
	384	+ return null;
	385	+ }
	386	+
	387	+ /**
	388	+ * Returns the error, if any.
	389	+ *
	390	+ * @access public
	391	+ * @return string
	392	+ */
	393	+ public function get_error() {
	394	+ return $this->_error;
	395	+ }
	396	+
	397	+ /**
	398	+ * Fetches information from the editable table and parses it to build series and data arrays.
	399	+ *
	400	+ * @since ?
	401	+ *
	402	+ * @access public
	403	+ * @return boolean TRUE on success, otherwise FALSE.
	404	+ */
	405	+ public function fetchFromEditableTable() {
	406	+ if ( empty( $this->_args ) ) {
	407	+ return false;
	408	+ }
	409	+
	410	+ $this->_fetchSeriesFromEditableTable();
	411	+ $this->_fetchDataFromEditableTable();
	412	+ return true;
	413	+ }
	414	+
	415	+ /**
	416	+ * Fetches series information from the editable table. This is fetched only through the UI and not while refreshing the chart data.
	417	+ *
	418	+ * @since 1.0.0
	419	+ *
	420	+ * @access private
	421	+ */
	422	+ private function _fetchSeriesFromEditableTable() {
	423	+ $params = $this->_args;
	424	+ $headers = array_filter( $params['header'] );
	425	+ $types = array_filter( $params['type'] );
	426	+ $header_row = $type_row = array();
	427	+ if ( $headers ) {
	428	+ foreach ( $headers as $header ) {
	429	+ if ( ! empty( $types[ $header ] ) ) {
	430	+ $this->_series[] = array(
	431	+ 'label' => $header,
	432	+ 'type' => $types[ $header ],
	433	+ );
	434	+ }
	435	+ }
	436	+ }
	437	+
	438	+ 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__ );
	439	+
	440	+ return true;
	441	+ }
	442	+
	443	+
	444	+ /**
	445	+ * Fetches data information from the editable table.
	446	+ *
	447	+ * @since 1.0.0
	448	+ *
	449	+ * @access private
	450	+ */
	451	+ private function _fetchDataFromEditableTable() {
	452	+ $headers = wp_list_pluck( $this->_series, 'label' );
	453	+ $this->fetch();
	454	+
	455	+ $data = $this->_data;
	456	+ $this->_data = array();
	457	+
	458	+ foreach ( $data as $line ) {
	459	+ $data_row = array();
	460	+ // we have to make sure we are fetching the data in the right order
	461	+ // in case the columns have been reordered
	462	+ foreach ( $headers as $header ) {
	463	+ $value = $line[ $header ];
	464	+ // phpcs:ignore WordPress.PHP.StrictInArray.MissingTrueStrict
	465	+ if ( in_array( $header, $headers ) ) {
	466	+ $data_row[] = $value;
	467	+ }
	468	+ }
	469	+ $this->_data[] = $this->_normalizeData( $data_row );
	470	+ }
	471	+
	472	+ 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__ );
	473	+
	474	+ return true;
	475	+ }
	476	+
250	477
251	478	}