← All changes | classes/Visualizer/Gutenberg/Block.php +217 -313 4.0.4 → 3.3.0 View file →

		@@ -59,145 +59,50 @@
59	59	$this->version = Visualizer_Plugin::VERSION;
60	60	add_action( 'enqueue_block_editor_assets', array( $this, 'enqueue_gutenberg_scripts' ) );
61	61	add_action( 'init', array( $this, 'register_block_type' ) );
62	62	add_action( 'rest_api_init', array( $this, 'register_rest_endpoints' ) );
63		- add_filter( 'rest_visualizer_query', array( $this, 'add_rest_query_vars' ), 9, 2 );
64	63	}
65	64
66	65	/**
67		- * Enqueue Gutenberg block assets.
	66	+ * Enqueue front end and editor JavaScript and CSS
68	67	*/
69	68	public function enqueue_gutenberg_scripts() {
70		- global $pagenow;
	69	+ $blockPath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/block.js';
	70	+ $handsontableJS = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/handsontable.js';
	71	+ $stylePath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/block.css';
	72	+ $handsontableCSS = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/handsontable.css';
71	73
72		- $blockPath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/index.js';
73		- $stylePath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/style-index.css';
74		- $asset_path = VISUALIZER_ABSPATH . '/classes/Visualizer/Gutenberg/build/index.asset.php';
75		- if ( file_exists( $asset_path ) ) {
76		- // @phpstan-ignore-next-line
77		- $asset = require $asset_path;
	74	+ if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) {
	75	+ $version = filemtime( VISUALIZER_ABSPATH . 'classes/Visualizer/Gutenberg/build/block.js' );
78	76	} else {
79		- $asset = array(
80		- 'dependencies' => array(),
81		- 'version' => $this->version,
82		- );
	77	+ $version = $this->version;
83	78	}
84	79
85		- if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) {
86		- $asset['version'] = filemtime( VISUALIZER_ABSPATH . '/classes/Visualizer/Gutenberg/build/index.js' );
87		- }
	80	+ // Enqueue the bundled block JS file
	81	+ wp_enqueue_script( 'handsontable', $handsontableJS );
	82	+ wp_enqueue_script( 'visualizer-gutenberg-block', $blockPath, array( 'wp-api', 'handsontable', 'visualizer-datatables', 'moment' ), $version, true );
88	83
89		- if ( ! wp_script_is( 'visualizer-datatables', 'registered' ) ) {
90		- wp_register_script( 'visualizer-datatables', VISUALIZER_ABSURL . 'js/lib/datatables.min.js', array( 'jquery-ui-core' ), Visualizer_Plugin::VERSION );
91		- }
	84	+ $type = 'community';
92	85
93		- if ( ! wp_style_is( 'visualizer-datatables', 'registered' ) ) {
94		- wp_register_style( 'visualizer-datatables', VISUALIZER_ABSURL . 'css/lib/datatables.min.css', array(), Visualizer_Plugin::VERSION );
	86	+ if ( Visualizer_Module::is_pro() ) {
	87	+ $type = 'pro';
	88	+ if ( apply_filters( 'visualizer_is_business', false ) ) {
	89	+ $type = 'developer';
	90	+ }
95	91	}
96	92
97		- // Enqueue the bundled block JS file
98		- $script_deps = array(
99		- 'wp-api',
100		- 'wp-blocks',
101		- 'wp-block-editor',
102		- 'wp-components',
103		- 'wp-editor',
104		- 'wp-element',
105		- 'wp-i18n',
106		- 'lodash',
107		- 'moment',
108		- 'react',
109		- 'visualizer-datatables',
110		- );
111		- if ( isset( $asset['dependencies'] ) && is_array( $asset['dependencies'] ) ) {
112		- $script_deps = array_merge( $script_deps, $asset['dependencies'] );
113		- }
114		- $script_deps = array_values( array_unique( $script_deps ) );
115		- wp_enqueue_script( 'visualizer-gutenberg-block', $blockPath, $script_deps, $asset['version'], true );
116		-
117	93	$translation_array = array(
	94	+ 'isPro' => $type,
	95	+ 'proTeaser' => Visualizer_Plugin::PRO_TEASER_URL,
	96	+ 'absurl' => VISUALIZER_ABSURL,
	97	+ 'charts' => Visualizer_Module_Admin::_getChartTypesLocalized(),
118	98	'adminPage' => menu_page_url( 'visualizer', false ),
119		- 'createChart' => add_query_arg( array( 'action' => 'visualizer-create-chart', 'library' => 'yes', 'type' => '', 'chart-library' => '', 'tab' => 'visualizer' ), admin_url( 'admin-ajax.php' ) ),
120		- 'chartsPerPage' => defined( 'TI_E2E_TESTING' ) ? 20 : 6,
121		- 'isFullSiteEditor' => 'site-editor.php' === $pagenow,
122		- /* translators: %1$s: opening tag, %2$s: closing tag */
123		- 'chartEditUrl' => admin_url( 'admin-ajax.php' ),
124	99	);
125	100	wp_localize_script( 'visualizer-gutenberg-block', 'visualizerLocalize', $translation_array );
126	101
127		- $d3_renderer_asset = VISUALIZER_ABSPATH . '/classes/Visualizer/D3Renderer/build/index.asset.php';
128		- if ( file_exists( $d3_renderer_asset ) && ! wp_script_is( 'visualizer-d3-renderer', 'registered' ) ) {
129		- // @phpstan-ignore-next-line
130		- $d3_asset = include $d3_renderer_asset;
131		- wp_register_script(
132		- 'visualizer-d3-renderer',
133		- VISUALIZER_ABSURL . 'classes/Visualizer/D3Renderer/build/index.js',
134		- array_merge( $d3_asset['dependencies'], array( 'jquery' ) ),
135		- $d3_asset['version'],
136		- true
137		- );
138		- }
139		- if ( wp_script_is( 'visualizer-d3-renderer', 'registered' ) ) {
140		- wp_enqueue_script( 'visualizer-d3-renderer' );
141		- wp_localize_script(
142		- 'visualizer-d3-renderer',
143		- 'vizD3Renderer',
144		- array(
145		- 'iframeJsUrl' => VISUALIZER_ABSURL . 'classes/Visualizer/D3Renderer/build/iframe.js',
146		- )
147		- );
148		- }
149		-
150	102	// Enqueue frontend and editor block styles
151		- wp_enqueue_style( 'visualizer-gutenberg-block', $stylePath, array( 'visualizer-datatables' ), $asset['version'] );
152		-
153		- // Enqueue ChartBuilder (AI Builder) so the D3 edit modal is available in the block editor.
154		- $chart_builder_asset = VISUALIZER_ABSPATH . '/classes/Visualizer/ChartBuilder/build/index.asset.php';
155		- if ( file_exists( $chart_builder_asset ) && ! wp_script_is( 'visualizer-chart-builder', 'enqueued' ) ) {
156		- /**
157		- * Ignore missing build asset in source checkout.
158		- *
159		- * @phpstan-ignore-next-line
160		- */
161		- $cb_asset = include $chart_builder_asset;
162		- wp_enqueue_script(
163		- 'visualizer-chart-builder',
164		- VISUALIZER_ABSURL . 'classes/Visualizer/ChartBuilder/build/index.js',
165		- $cb_asset['dependencies'],
166		- $cb_asset['version'],
167		- true
168		- );
169		- wp_enqueue_style(
170		- 'visualizer-chart-builder',
171		- VISUALIZER_ABSURL . 'classes/Visualizer/ChartBuilder/build/style-index.css',
172		- array(),
173		- $cb_asset['version']
174		- );
175		- $chart_builder_css = VISUALIZER_ABSPATH . '/classes/Visualizer/ChartBuilder/build/index.css';
176		- if ( file_exists( $chart_builder_css ) ) {
177		- wp_enqueue_style(
178		- 'visualizer-chart-builder-runtime',
179		- VISUALIZER_ABSURL . 'classes/Visualizer/ChartBuilder/build/index.css',
180		- array( 'visualizer-chart-builder' ),
181		- $cb_asset['version']
182		- );
183		- }
184		- wp_localize_script(
185		- 'visualizer-chart-builder',
186		- 'vizAIBuilder',
187		- array(
188		- 'ajaxUrl' => admin_url( 'admin-ajax.php' ),
189		- 'nonce' => wp_create_nonce( 'visualizer-ai-builder' ),
190		- 'isPro' => Visualizer_Module::is_pro(),
191		- )
192		- );
193		- // Inject the mount point the ChartBuilder React app needs.
194		- wp_add_inline_script(
195		- 'visualizer-chart-builder',
196		- 'document.body.insertAdjacentHTML("beforeend","<div id=\"viz-chart-builder-root\"></div>");',
197		- 'before'
198		- );
199		- }
	103	+ wp_enqueue_style( 'handsontable', $handsontableCSS );
	104	+ wp_enqueue_style( 'visualizer-gutenberg-block', $stylePath, array( 'visualizer-datatables' ), $version );
200	105	}
201	106	/**
202	107	* Hook server side rendering into render callback
203	108	*/
		@@ -208,11 +113,8 @@
208	113	'attributes' => array(
209	114	'id' => array(
210	115	'type' => 'number',
211	116	),
212		- 'lazy' => array(
213		- 'type' => 'string',
214		- ),
215	117	),
216	118	)
217	119	);
218	120	}
		@@ -219,45 +121,16 @@
219	121
220	122	/**
221	123	* Gutenberg Block Callback Function
222	124	*/
223		- public function gutenberg_block_callback( $atts ) {
224		- // no id, no fun.
225		- if ( ! isset( $atts['id'] ) ) {
226		- return '';
	125	+ public function gutenberg_block_callback( $attr ) {
	126	+ if ( isset( $attr['id'] ) ) {
	127	+ $id = $attr['id'];
	128	+ if ( empty( $id ) || $id === 'none' ) {
	129	+ return ''; // no id = no fun
	130	+ }
	131	+ return '[visualizer id="' . $id . '"]';
227	132	}
228		-
229		- $atts = shortcode_atts(
230		- array(
231		- 'id' => false,
232		- 'lazy' => apply_filters( 'visualizer_lazy_by_default', false, $atts['id'] ),
233		- // we are deliberating excluding the class attribute from here
234		- // as this will be handled by the custom class in Gutenberg
235		- ),
236		- $atts
237		- );
238		-
239		- // no id, no fun.
240		- if ( ! $atts['id'] ) {
241		- return '';
242		- }
243		-
244		- if ( $atts['lazy'] === '-1' || $atts['lazy'] === false ) {
245		- $atts['lazy'] = 'no';
246		- }
247		-
248		- // we don't want the chart in the editor lazy-loading.
249		- if ( is_admin() ) {
250		- unset( $atts['lazy'] );
251		- }
252		-
253		- $shortcode = '[visualizer';
254		- foreach ( $atts as $name => $value ) {
255		- $shortcode .= sprintf( ' %s="%s"', $name, $value );
256		- }
257		- $shortcode .= ']';
258		-
259		- return $shortcode;
260	133	}
261	134
262	135	/**
263	136	* Hook server side rendering into render callback
		@@ -269,8 +142,50 @@
269	142	array(
270	143	'get_callback' => array( $this, 'get_visualizer_data' ),
271	144	)
272	145	);
	146	+
	147	+ register_rest_route(
	148	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	149	+ '/update-chart',
	150	+ array(
	151	+ 'methods' => 'POST',
	152	+ 'callback' => array( $this, 'update_chart_data' ),
	153	+ 'args' => array(
	154	+ 'id' => array(
	155	+ 'sanitize_callback' => 'absint',
	156	+ ),
	157	+ ),
	158	+ )
	159	+ );
	160	+
	161	+ register_rest_route(
	162	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	163	+ '/upload-data',
	164	+ array(
	165	+ 'methods' => 'POST',
	166	+ 'callback' => array( $this, 'upload_csv_data' ),
	167	+ 'args' => array(
	168	+ 'url' => array(
	169	+ 'sanitize_callback' => 'esc_url_raw',
	170	+ ),
	171	+ ),
	172	+ )
	173	+ );
	174	+
	175	+ register_rest_route(
	176	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	177	+ '/get-permission-data',
	178	+ array(
	179	+ 'methods' => 'GET',
	180	+ 'callback' => array( $this, 'get_permission_data' ),
	181	+ 'args' => array(
	182	+ 'type' => array(
	183	+ 'sanitize_callback' => 'sanitize_text_field',
	184	+ ),
	185	+ ),
	186	+ )
	187	+ );
273	188	}
274	189
275	190	/**
276	191	* Get Post Meta Fields
		@@ -275,22 +190,14 @@
275	190	/**
276	191	* Get Post Meta Fields
277	192	*/
278	193	public function get_visualizer_data( $post ) {
279		- if ( ! current_user_can( 'edit_posts' ) ) {
280		- return false;
281		- }
282		-
283	194	$data = array();
284	195	$post_id = $post['id'];
285	196
286	197	$data['visualizer-chart-type'] = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_TYPE, true );
287	198
288		- $library = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_LIBRARY, true );
289		- $data['visualizer-chart-library'] = $library;
290		- if ( 'd3' === $library ) {
291		- $data['visualizer-d3-code'] = get_post_meta( $post_id, Visualizer_Module_AIBuilder::CF_D3_CODE, true );
292		- }
	199	+ $data['visualizer-chart-library'] = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_LIBRARY, true );
293	200
294	201	$data['visualizer-source'] = get_post_meta( $post_id, Visualizer_Plugin::CF_SOURCE, true );
295	202
296	203	$data['visualizer-default-data'] = get_post_meta( $post_id, Visualizer_Plugin::CF_DEFAULT_DATA, true );
		@@ -296,11 +203,9 @@
296	203	$data['visualizer-default-data'] = get_post_meta( $post_id, Visualizer_Plugin::CF_DEFAULT_DATA, true );
297	204
298	205	// faetch and update settings
299	206	$data['visualizer-settings'] = get_post_meta( $post_id, Visualizer_Plugin::CF_SETTINGS, true );
300		- if ( empty( $data['visualizer-settings']['pagination'] ) ) {
301		- $data['visualizer-settings']['pageSize'] = '';
302		- }
	207	+
303	208	// handle series filter hooks
304	209	$data['visualizer-series'] = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_SERIES, get_post_meta( $post_id, Visualizer_Plugin::CF_SERIES, true ), $post_id, $data['visualizer-chart-type'] );
305	210
306	211	// handle settings filter hooks
		@@ -308,134 +213,87 @@
308	213
309	214	// handle data filter hooks
310	215	$data['visualizer-data'] = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, unserialize( html_entity_decode( get_the_content( $post_id ) ) ), $post_id, $data['visualizer-chart-type'] );
311	216
312		- // we are going to format only for tabular charts, because we are not sure of the effect on others.
313		- // this is to solve the case where boolean data shows up as all-ticks on gutenberg.
314		- if ( in_array( $data['visualizer-chart-type'], array( 'tabular' ), true ) ) {
315		- $data['visualizer-data'] = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
316		- }
	217	+ $import = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_URL, true );
317	218
318		- if ( ! isset( $data['visualizer-settings']['hAxis']['format'] ) ) {
319		- $data['visualizer-settings']['hAxis']['format'] = '';
	219	+ $schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_SCHEDULE, true );
	220	+
	221	+ if ( ! empty( $import ) && ! empty( $schedule ) ) {
	222	+ $data['visualizer-chart-url'] = $import;
	223	+ $data['visualizer-chart-schedule'] = $schedule;
320	224	}
321	225
322		- $data['visualizer-data-exploded'] = '';
323		- // handle annotations for google charts
324		- if ( 'GoogleCharts' === $library ) {
325		- // this will contain the data of both axis.
326		- $settings = $data['visualizer-settings'];
327		- // this will contain data only of Y axis.
328		- $series = $data['visualizer-series'];
329		- $annotations = array();
330		- if ( isset( $settings['series'] ) ) {
331		- foreach ( $settings['series'] as $index => $serie ) {
332		- // skip X axis data.
333		- if ( $index === 0 ) {
334		- continue;
335		- }
336		- if ( ! empty( $serie['role'] ) ) {
337		- // this series is some kind of annotation, so let's collect its index.
338		- // the index will be +1 because the X axis value is index 0, which is being ignored.
339		- $annotations[ 'role' . ( intval( $index ) + 1 ) ] = $serie['role'];
	226	+ if ( Visualizer_Module::is_pro() ) {
	227	+ $permissions = get_post_meta( $post_id, Visualizer_PRO::CF_PERMISSIONS, true );
340	228
341		- if ( isset( $data['visualizer-series'][ intval( $index ) + 1 ] ) ) {
342		- $data['visualizer-series'][ intval( $index ) + 1 ]['role'] = $serie['role'];
343		- }
344		- }
345		- }
	229	+ if ( ! empty( $permissions ) ) {
	230	+ $data['visualizer-permissions'] = $permissions;
346	231	}
347		- if ( ! empty( $annotations ) ) {
348		- $exploded_data = array();
349		- $series_names = array();
350		- foreach ( $series as $index => $serie ) {
351		- // skip X axis data.
352		- if ( $index === 0 ) {
353		- continue;
354		- }
355		- if ( array_key_exists( 'role' . $index, $annotations ) ) {
356		- $series_names[] = (object) array( 'role' => $annotations[ 'role' . $index ], 'type' => $serie['type'] );
357		- } else {
358		- $series_names[] = $serie['label'];
359		- }
360		- }
361		- $exploded_data[] = $series_names;
362		-
363		- foreach ( $data['visualizer-data'] as $datum ) {
364		- // skip X axis data.
365		- unset( $datum[0] );
366		- $exploded_data[] = $datum;
367		- }
368		- $data['visualizer-data-exploded'] = array( $exploded_data );
369		- }
370	232	}
371	233
372		- $import = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_URL, true );
	234	+ return $data;
	235	+ }
373	236
374		- $schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_SCHEDULE, true );
	237	+ /**
	238	+ * Rest Callback Method
	239	+ */
	240	+ public function update_chart_data( $data ) {
	241	+ if ( $data['id'] && ! is_wp_error( $data['id'] ) ) {
375	242
376		- $db_schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_DB_SCHEDULE, true );
	243	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_TYPE, $data['visualizer-chart-type'] );
	244	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_SOURCE, $data['visualizer-source'] );
	245	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_DEFAULT_DATA, $data['visualizer-default-data'] );
	246	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_SERIES, $data['visualizer-series'] );
	247	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_SETTINGS, $data['visualizer-settings'] );
377	248
378		- $db_query = get_post_meta( $post_id, Visualizer_Plugin::CF_DB_QUERY, true );
	249	+ if ( $data['visualizer-chart-url'] && $data['visualizer-chart-schedule'] ) {
	250	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_URL, $data['visualizer-chart-url'] );
	251	+ apply_filters( 'visualizer_pro_chart_schedule', $data['id'], $data['visualizer-chart-url'], $data['visualizer-chart-schedule'] );
	252	+ } else {
	253	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_URL );
	254	+ apply_filters( 'visualizer_pro_remove_schedule', $data['id'] );
	255	+ }
379	256
380		- $json_url = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_URL, true );
	257	+ if ( Visualizer_Module::is_pro() ) {
	258	+ update_post_meta( $data['id'], Visualizer_PRO::CF_PERMISSIONS, $data['visualizer-permissions'] );
	259	+ }
381	260
382		- $json_headers = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_HEADERS, true );
	261	+ if ( $data['visualizer-chart-url'] ) {
	262	+ $content['source'] = $data['visualizer-chart-url'];
	263	+ $content['data'] = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
	264	+ } else {
	265	+ $content = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
	266	+ }
383	267
384		- $json_schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_SCHEDULE, true );
	268	+ $chart = array(
	269	+ 'ID' => $data['id'],
	270	+ 'post_content' => serialize( $content ),
	271	+ );
385	272
386		- $json_root = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_ROOT, true );
	273	+ wp_update_post( $chart );
387	274
388		- $json_paging = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_PAGING, true );
	275	+ $revisions = wp_get_post_revisions( $data['id'], array( 'order' => 'ASC' ) );
389	276
390		- if ( ! empty( $import ) && $schedule >= 0 ) {
391		- $data['visualizer-chart-url'] = $import;
392		- $data['visualizer-chart-schedule'] = $schedule;
393		- }
	277	+ if ( count( $revisions ) > 1 ) {
	278	+ $revision_ids = array_keys( $revisions );
394	279
395		- if ( ! empty( $db_schedule ) && ! empty( $db_query ) ) {
396		- $data['visualizer-db-schedule'] = $db_schedule;
397		- $data['visualizer-db-query'] = $db_query;
398		- }
399		-
400		- if ( ! empty( $json_url ) ) {
401		- $data['visualizer-json-schedule'] = $json_schedule;
402		- $data['visualizer-json-url'] = $json_url;
403		- $data['visualizer-json-headers'] = $json_headers;
404		- $data['visualizer-json-root'] = $json_root;
405		-
406		- if ( Visualizer_Module::is_pro() && ! empty( $json_paging ) ) {
407		- $data['visualizer-json-paging'] = $json_paging;
	280	+ // delete all revisions.
	281	+ foreach ( $revision_ids as $id ) {
	282	+ wp_delete_post_revision( $id );
	283	+ }
408	284	}
409		- }
410	285
411		- if ( Visualizer_Module::is_pro() ) {
412		- $permissions = get_post_meta( $post_id, Visualizer_Pro::CF_PERMISSIONS, true );
413		-
414		- if ( empty( $permissions ) ) {
415		- $permissions = array(
416		- 'permissions' => array(
417		- 'read' => 'all',
418		- 'edit' => 'roles',
419		- 'edit-specific' => array( 'administrator' ),
420		- ),
421		- );
422		- }
423		-
424		- $data['visualizer-permissions'] = $permissions;
	286	+ return new \WP_REST_Response( array( 'success' => sprintf( 'Chart updated' ) ) );
425	287	}
426		-
427		- return $data;
428	288	}
429	289
430	290	/**
431	291	* Format chart data.
432		- *
433		- * Note: No matter how tempted, don't use the similar method from Visualizer_Source. That works on a different structure.
434	292	*/
435	293	public function format_chart_data( $data, $series ) {
436	294	foreach ( $series as $i => $row ) {
437		- // if no value exists for the series, then add null
	295	+ // if no value exists for the seires, then add null
438	296	if ( ! isset( $series[ $i ] ) ) {
439	297	$series[ $i ] = null;
440	298	}
441	299
		@@ -442,38 +300,39 @@
442	300	if ( is_null( $series[ $i ] ) ) {
443	301	continue;
444	302	}
445	303
446		- switch ( $row['type'] ) {
447		- case 'number':
448		- foreach ( $data as $o => $col ) {
449		- $data[ $o ][ $i ] = ( is_numeric( $col[ $i ] ) ) ? floatval( $col[ $i ] ) : ( is_numeric( str_replace( ',', '', $col[ $i ] ) ) ? floatval( str_replace( ',', '', $col[ $i ] ) ) : null );
	304	+ if ( $row['type'] === 'number' ) {
	305	+ foreach ( $data as $o => $col ) {
	306	+ $data[ $o ][ $i ] = ( is_numeric( $col[ $i ] ) ) ? floatval( $col[ $i ] ) : ( is_numeric( str_replace( ',', '', $col[ $i ] ) ) ? floatval( str_replace( ',', '', $col[ $i ] ) ) : null );
	307	+ }
	308	+ }
	309	+
	310	+ if ( $row['type'] === 'boolean' ) {
	311	+ foreach ( $data as $o => $col ) {
	312	+ $data[ $o ][ $i ] = ! empty( $col[ $i ] ) ? filter_validate( $col[ $i ], FILTER_VALIDATE_BOOLEAN ) : null;
	313	+ }
	314	+ }
	315	+
	316	+ if ( $row['type'] === 'timeofday' ) {
	317	+ foreach ( $data as $o => $col ) {
	318	+ $date = new DateTime( '1984-03-16T' . $col[ $i ] );
	319	+ if ( $date ) {
	320	+ $data[ $o ][ $i ] = array(
	321	+ intval( $date->format( 'H' ) ),
	322	+ intval( $date->format( 'i' ) ),
	323	+ intval( $date->format( 's' ) ),
	324	+ 0,
	325	+ );
450	326	}
451		- break;
452		- case 'boolean':
453		- foreach ( $data as $o => $col ) {
454		- $data[ $o ][ $i ] = ! empty( $col[ $i ] ) ? filter_var( $col[ $i ], FILTER_VALIDATE_BOOLEAN ) : false;
455		- }
456		- break;
457		- case 'timeofday':
458		- foreach ( $data as $o => $col ) {
459		- $date = new DateTime( '1984-03-16T' . $col[ $i ] );
460		- if ( $date ) {
461		- $data[ $o ][ $i ] = array(
462		- intval( $date->format( 'H' ) ),
463		- intval( $date->format( 'i' ) ),
464		- intval( $date->format( 's' ) ),
465		- 0,
466		- );
467		- }
468		- }
469		- break;
470		- case 'string':
471		- foreach ( $data as $o => $col ) {
472		- $data[ $o ][ $i ] = $this->toUTF8( $col[ $i ] );
473		- }
474		- break;
	327	+ }
475	328	}
	329	+
	330	+ if ( $row['type'] === 'string' ) {
	331	+ foreach ( $data as $o => $col ) {
	332	+ $data[ $o ][ $i ] = $this->toUTF8( $col[ $i ] );
	333	+ }
	334	+ }
476	335	}
477	336
478	337	return $data;
479	338	}
		@@ -488,25 +347,70 @@
488	347	return $datum;
489	348	}
490	349
491	350	/**
492		- * Filter Rest Query
	351	+ * Handle remote CSV data
493	352	*/
494		- public function add_rest_query_vars( $args, \WP_REST_Request $request ) {
495		- if ( isset( $request['meta_key'] ) && isset( $request['meta_value'] ) ) {
496		- $args['meta_query'] = array(
497		- 'relation' => 'OR',
498		- array(
499		- 'key' => $request->get_param( 'meta_key' ),
500		- 'value' => $request->get_param( 'meta_value' ),
501		- 'compare' => '!=',
502		- ),
503		- array(
504		- 'key' => $request->get_param( 'meta_key' ),
505		- 'value' => $request->get_param( 'meta_value' ),
506		- 'compare' => 'NOT EXISTS',
507		- ),
508		- );
	353	+ public function upload_csv_data( $data ) {
	354	+ if ( $data['url'] && ! is_wp_error( $data['url'] ) && filter_var( $data['url'], FILTER_VALIDATE_URL ) ) {
	355	+ $source = new Visualizer_Source_Csv_Remote( $data['url'] );
	356	+ if ( $source->fetch() ) {
	357	+ $temp = $source->getData();
	358	+ if ( is_string( $temp ) && is_array( unserialize( $temp ) ) ) {
	359	+ $content['series'] = $source->getSeries();
	360	+ $content['data'] = $source->getRawData();
	361	+ return $content;
	362	+ } else {
	363	+ return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
	364	+ }
	365	+ } else {
	366	+ return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
	367	+ }
	368	+ } else {
	369	+ return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
509	370	}
510		- return $args;
511	371	}
	372	+
	373	+ /**
	374	+ * Get permission data
	375	+ */
	376	+ public function get_permission_data( $data ) {
	377	+ $options = array();
	378	+ switch ( $data['type'] ) {
	379	+ case 'users':
	380	+ $query = new WP_User_Query(
	381	+ array(
	382	+ 'number' => 1000,
	383	+ 'orderby' => 'display_name',
	384	+ 'fields' => array( 'ID', 'display_name' ),
	385	+ 'count_total' => false,
	386	+ )
	387	+ );
	388	+ $users = $query->get_results();
	389	+ if ( ! empty( $users ) ) {
	390	+ $i = 0;
	391	+ foreach ( $users as $user ) {
	392	+ $options[ $i ]['value'] = $user->ID;
	393	+ $options[ $i ]['label'] = $user->display_name;
	394	+ $i++;
	395	+ }
	396	+ }
	397	+ break;
	398	+ case 'roles':
	399	+ if ( ! function_exists( 'get_editable_roles' ) ) {
	400	+ require_once ABSPATH . 'wp-admin/includes/user.php';
	401	+ }
	402	+ $roles = get_editable_roles();
	403	+ if ( ! empty( $roles ) ) {
	404	+ $i = 0;
	405	+ foreach ( get_editable_roles() as $name => $info ) {
	406	+ $options[ $i ]['value'] = $name;
	407	+ $options[ $i ]['label'] = $name;
	408	+ $i++;
	409	+ }
	410	+ }
	411	+ break;
	412	+ }
	413	+ return $options;
	414	+ }
	415	+
512	416	}