← All changes | classes/Visualizer/Gutenberg/Block.php +442 -129 4.0.3 → 3.5.1 View file →

		@@ -63,140 +63,70 @@
63	63	add_filter( 'rest_visualizer_query', array( $this, 'add_rest_query_vars' ), 9, 2 );
64	64	}
65	65
66	66	/**
67		- * Enqueue Gutenberg block assets.
	67	+ * Enqueue front end and editor JavaScript and CSS
68	68	*/
69	69	public function enqueue_gutenberg_scripts() {
70		- global $pagenow;
	70	+ global $wp_version;
71	71
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;
	72	+ $blockPath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/block.js';
	73	+ $handsontableJS = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/handsontable.js';
	74	+ $stylePath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/block.css';
	75	+ $handsontableCSS = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/handsontable.css';
	76	+
	77	+ if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) {
	78	+ $version = filemtime( VISUALIZER_ABSPATH . '/classes/Visualizer/Gutenberg/build/block.js' );
78	79	} else {
79		- $asset = array(
80		- 'dependencies' => array(),
81		- 'version' => $this->version,
82		- );
	80	+ $version = $this->version;
83	81	}
84	82
85		- if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) {
86		- $asset['version'] = filemtime( VISUALIZER_ABSPATH . '/classes/Visualizer/Gutenberg/build/index.js' );
87		- }
	83	+ // Enqueue the bundled block JS file
	84	+ wp_enqueue_script( 'handsontable', $handsontableJS );
	85	+ wp_enqueue_script( 'visualizer-gutenberg-block', $blockPath, array( 'wp-api', 'handsontable', 'visualizer-datatables', 'moment' ), $version, true );
88	86
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		- }
	87	+ $type = 'community';
92	88
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 );
	89	+ if ( Visualizer_Module::is_pro() ) {
	90	+ $type = 'pro';
	91	+ if ( apply_filters( 'visualizer_is_business', false ) ) {
	92	+ $type = 'business';
	93	+ }
95	94	}
96	95
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 );
	96	+ $table_col_mapping = Visualizer_Source_Query_Params::get_all_db_tables_column_mapping( null, false );
116	97
117	98	$translation_array = array(
	99	+ 'isPro' => $type,
	100	+ 'proTeaser' => Visualizer_Plugin::PRO_TEASER_URL,
	101	+ 'absurl' => VISUALIZER_ABSURL,
	102	+ 'charts' => Visualizer_Module_Admin::_getChartTypesLocalized(),
118	103	'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' ),
	104	+ 'sqlTable' => $table_col_mapping,
	105	+ 'chartsPerPage' => defined( 'TI_CYPRESS_TESTING' ) ? 20 : 6,
124	106	);
125	107	wp_localize_script( 'visualizer-gutenberg-block', 'visualizerLocalize', $translation_array );
126	108
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		- }
	109	+ // Enqueue frontend and editor block styles
	110	+ wp_enqueue_style( 'handsontable', $handsontableCSS );
	111	+ wp_enqueue_style( 'visualizer-gutenberg-block', $stylePath, array( 'visualizer-datatables' ), $version );
149	112
150		- // Enqueue frontend and editor block styles
151		- wp_enqueue_style( 'visualizer-gutenberg-block', $stylePath, array( 'visualizer-datatables' ), $asset['version'] );
	113	+ if ( version_compare( $wp_version, '4.9.0', '>' ) ) {
152	114
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',
	115	+ wp_enqueue_code_editor(
187	116	array(
188		- 'ajaxUrl' => admin_url( 'admin-ajax.php' ),
189		- 'nonce' => wp_create_nonce( 'visualizer-ai-builder' ),
190		- 'isPro' => Visualizer_Module::is_pro(),
	117	+ 'type' => 'sql',
	118	+ 'codemirror' => array(
	119	+ 'autofocus' => true,
	120	+ 'lineWrapping' => true,
	121	+ 'dragDrop' => false,
	122	+ 'matchBrackets' => true,
	123	+ 'autoCloseBrackets' => true,
	124	+ 'extraKeys' => array( 'Ctrl-Space' => 'autocomplete' ),
	125	+ 'hintOptions' => array( 'tables' => $table_col_mapping ),
	126	+ ),
191	127	)
192	128	);
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	129	}
200	130	}
201	131	/**
202	132	* Hook server side rendering into render callback
		@@ -240,9 +170,10 @@
240	170	if ( ! $atts['id'] ) {
241	171	return '';
242	172	}
243	173
244		- if ( $atts['lazy'] === '-1' || $atts['lazy'] === false ) {
	174	+ // phpcs:ignore WordPress.PHP.StrictComparisons.LooseComparison
	175	+ if ( $atts['lazy'] == -1 || $atts['lazy'] == false ) {
245	176	$atts['lazy'] = 'no';
246	177	}
247	178
248	179	// we don't want the chart in the editor lazy-loading.
		@@ -269,8 +200,125 @@
269	200	array(
270	201	'get_callback' => array( $this, 'get_visualizer_data' ),
271	202	)
272	203	);
	204	+
	205	+ register_rest_route(
	206	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	207	+ '/get-query-data',
	208	+ array(
	209	+ 'methods' => 'GET',
	210	+ 'callback' => array( $this, 'get_query_data' ),
	211	+ 'permission_callback' => function () {
	212	+ return current_user_can( 'edit_posts' );
	213	+ },
	214	+ )
	215	+ );
	216	+
	217	+ register_rest_route(
	218	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	219	+ '/get-json-root',
	220	+ array(
	221	+ 'methods' => 'GET',
	222	+ 'callback' => array( $this, 'get_json_root_data' ),
	223	+ 'args' => array(
	224	+ 'url' => array(
	225	+ 'sanitize_callback' => 'esc_url_raw',
	226	+ ),
	227	+ ),
	228	+ 'permission_callback' => function () {
	229	+ return current_user_can( 'edit_posts' );
	230	+ },
	231	+ )
	232	+ );
	233	+
	234	+ register_rest_route(
	235	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	236	+ '/get-json-data',
	237	+ array(
	238	+ 'methods' => 'GET',
	239	+ 'callback' => array( $this, 'get_json_data' ),
	240	+ 'args' => array(
	241	+ 'url' => array(
	242	+ 'sanitize_callback' => 'esc_url_raw',
	243	+ ),
	244	+ 'chart' => array(
	245	+ 'sanitize_callback' => 'absint',
	246	+ ),
	247	+ ),
	248	+ 'permission_callback' => function () {
	249	+ return current_user_can( 'edit_posts' );
	250	+ },
	251	+ )
	252	+ );
	253	+
	254	+ register_rest_route(
	255	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	256	+ '/set-json-data',
	257	+ array(
	258	+ 'methods' => 'GET',
	259	+ 'callback' => array( $this, 'set_json_data' ),
	260	+ 'args' => array(
	261	+ 'url' => array(
	262	+ 'sanitize_callback' => 'esc_url_raw',
	263	+ ),
	264	+ ),
	265	+ 'permission_callback' => function () {
	266	+ return current_user_can( 'edit_posts' );
	267	+ },
	268	+ )
	269	+ );
	270	+
	271	+ register_rest_route(
	272	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	273	+ '/update-chart',
	274	+ array(
	275	+ 'methods' => 'POST',
	276	+ 'callback' => array( $this, 'update_chart_data' ),
	277	+ 'args' => array(
	278	+ 'id' => array(
	279	+ 'sanitize_callback' => 'absint',
	280	+ ),
	281	+ ),
	282	+ 'permission_callback' => function () {
	283	+ return current_user_can( 'edit_posts' );
	284	+ },
	285	+ )
	286	+ );
	287	+
	288	+ register_rest_route(
	289	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	290	+ '/upload-data',
	291	+ array(
	292	+ 'methods' => 'POST',
	293	+ 'callback' => array( $this, 'upload_csv_data' ),
	294	+ 'args' => array(
	295	+ 'url' => array(
	296	+ 'sanitize_callback' => 'esc_url_raw',
	297	+ ),
	298	+ ),
	299	+ 'permission_callback' => function () {
	300	+ return current_user_can( 'edit_posts' );
	301	+ },
	302	+ )
	303	+ );
	304	+
	305	+ register_rest_route(
	306	+ 'visualizer/v' . VISUALIZER_REST_VERSION,
	307	+ '/get-permission-data',
	308	+ array(
	309	+ 'methods' => 'GET',
	310	+ 'callback' => array( $this, 'get_permission_data' ),
	311	+ 'args' => array(
	312	+ 'type' => array(
	313	+ 'sanitize_callback' => 'sanitize_text_field',
	314	+ ),
	315	+ ),
	316	+ 'permission_callback' => function () {
	317	+ return current_user_can( 'edit_posts' );
	318	+ },
	319	+ )
	320	+ );
273	321	}
274	322
275	323	/**
276	324	* Get Post Meta Fields
		@@ -286,11 +334,8 @@
286	334	$data['visualizer-chart-type'] = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_TYPE, true );
287	335
288	336	$library = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_LIBRARY, true );
289	337	$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		- }
293	338
294	339	$data['visualizer-source'] = get_post_meta( $post_id, Visualizer_Plugin::CF_SOURCE, true );
295	340
296	341	$data['visualizer-default-data'] = get_post_meta( $post_id, Visualizer_Plugin::CF_DEFAULT_DATA, true );
		@@ -296,11 +341,9 @@
296	341	$data['visualizer-default-data'] = get_post_meta( $post_id, Visualizer_Plugin::CF_DEFAULT_DATA, true );
297	342
298	343	// faetch and update settings
299	344	$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		- }
	345	+
303	346	// handle series filter hooks
304	347	$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	348
306	349	// handle settings filter hooks
		@@ -314,12 +357,8 @@
314	357	if ( in_array( $data['visualizer-chart-type'], array( 'tabular' ), true ) ) {
315	358	$data['visualizer-data'] = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
316	359	}
317	360
318		- if ( ! isset( $data['visualizer-settings']['hAxis']['format'] ) ) {
319		- $data['visualizer-settings']['hAxis']['format'] = '';
320		- }
321		-
322	361	$data['visualizer-data-exploded'] = '';
323	362	// handle annotations for google charts
324	363	if ( 'GoogleCharts' === $library ) {
325	364	// this will contain the data of both axis.
		@@ -386,10 +425,10 @@
386	425	$json_root = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_ROOT, true );
387	426
388	427	$json_paging = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_PAGING, true );
389	428
390		- if ( ! empty( $import ) && $schedule >= 0 ) {
391		- $data['visualizer-chart-url'] = $import;
	429	+ if ( ! empty( $import ) && ! empty( $schedule ) ) {
	430	+ $data['visualizer-chart-url'] = $import;
392	431	$data['visualizer-chart-schedule'] = $schedule;
393	432	}
394	433
395	434	if ( ! empty( $db_schedule ) && ! empty( $db_query ) ) {
		@@ -408,17 +447,16 @@
408	447	}
409	448	}
410	449
411	450	if ( Visualizer_Module::is_pro() ) {
412		- $permissions = get_post_meta( $post_id, Visualizer_Pro::CF_PERMISSIONS, true );
	451	+ $permissions = get_post_meta( $post_id, Visualizer_PRO::CF_PERMISSIONS, true );
413	452
414	453	if ( empty( $permissions ) ) {
415		- $permissions = array(
416		- 'permissions' => array(
	454	+ $permissions = array( 'permissions' => array(
417	455	'read' => 'all',
418	456	'edit' => 'roles',
419	457	'edit-specific' => array( 'administrator' ),
420		- ),
	458	+ ),
421	459	);
422	460	}
423	461
424	462	$data['visualizer-permissions'] = $permissions;
		@@ -427,8 +465,209 @@
427	465	return $data;
428	466	}
429	467
430	468	/**
	469	+ * Returns the data for the query.
	470	+ *
	471	+ * @access public
	472	+ */
	473	+ public function get_query_data( $data ) {
	474	+ if ( ! current_user_can( 'edit_posts' ) ) {
	475	+ return false;
	476	+ }
	477	+
	478	+ $source = new Visualizer_Source_Query( stripslashes( $data['query'] ) );
	479	+ $html = $source->fetch( true );
	480	+ $source->fetch( false );
	481	+ $name = $source->getSourceName();
	482	+ $series = $source->getSeries();
	483	+ $data = $source->getRawData();
	484	+ $error = '';
	485	+ if ( empty( $html ) ) {
	486	+ $error = $source->get_error();
	487	+ wp_send_json_error( array( 'msg' => $error ) );
	488	+ }
	489	+ wp_send_json_success( array( 'table' => $html, 'name' => $name, 'series' => $series, 'data' => $data ) );
	490	+ }
	491	+
	492	+ /**
	493	+ * Returns the JSON root.
	494	+ *
	495	+ * @access public
	496	+ */
	497	+ public function get_json_root_data( $data ) {
	498	+ if ( ! current_user_can( 'edit_posts' ) ) {
	499	+ return false;
	500	+ }
	501	+
	502	+ $source = new Visualizer_Source_Json( $data );
	503	+
	504	+ $roots = $source->fetchRoots();
	505	+ if ( empty( $roots ) ) {
	506	+ wp_send_json_error( array( 'msg' => $source->get_error() ) );
	507	+ }
	508	+
	509	+ wp_send_json_success( array( 'url' => $data['url'], 'roots' => $roots ) );
	510	+ }
	511	+
	512	+ /**
	513	+ * Returns the JSON data.
	514	+ *
	515	+ * @access public
	516	+ */
	517	+ public function get_json_data( $data ) {
	518	+ if ( ! current_user_can( 'edit_posts' ) ) {
	519	+ return false;
	520	+ }
	521	+
	522	+ $chart_id = $data['chart'];
	523	+
	524	+ if ( empty( $chart_id ) ) {
	525	+ wp_die();
	526	+ }
	527	+
	528	+ $source = new Visualizer_Source_Json( $data );
	529	+ $source->fetch();
	530	+ $table = $source->getRawData();
	531	+
	532	+ if ( empty( $table ) ) {
	533	+ wp_send_json_error( array( 'msg' => esc_html__( 'Unable to fetch data from the endpoint. Please try again.', 'visualizer' ) ) );
	534	+ }
	535	+
	536	+ $table = Visualizer_Render_Layout::show( 'editor-table', $table, $chart_id, 'viz-json-table', false, false );
	537	+ wp_send_json_success( array( 'table' => $table, 'root' => $data['root'], 'url' => $data['url'], 'paging' => $source->getPaginationElements() ) );
	538	+ }
	539	+
	540	+ /**
	541	+ * Set the JSON data.
	542	+ *
	543	+ * @access public
	544	+ */
	545	+ public function set_json_data( $data ) {
	546	+ if ( ! current_user_can( 'edit_posts' ) ) {
	547	+ return false;
	548	+ }
	549	+
	550	+ $source = new Visualizer_Source_Json( $data );
	551	+
	552	+ $table = $source->fetch();
	553	+ if ( empty( $table ) ) {
	554	+ wp_send_json_error( array( 'msg' => esc_html__( 'Unable to fetch data from the endpoint. Please try again.', 'visualizer' ) ) );
	555	+ }
	556	+
	557	+ $source->fetchFromEditableTable();
	558	+ $name = $source->getSourceName();
	559	+ $series = json_encode( $source->getSeries() );
	560	+ $data = json_encode( $source->getRawData() );
	561	+ wp_send_json_success( array( 'name' => $name, 'series' => $series, 'data' => $data ) );
	562	+ }
	563	+
	564	+ /**
	565	+ * Rest Callback Method
	566	+ */
	567	+ public function update_chart_data( $data ) {
	568	+ if ( ! current_user_can( 'edit_posts' ) ) {
	569	+ return false;
	570	+ }
	571	+
	572	+ if ( $data['id'] && ! is_wp_error( $data['id'] ) ) {
	573	+ if ( get_post_type( $data['id'] ) !== Visualizer_Plugin::CPT_VISUALIZER ) {
	574	+ return new WP_Error( 'invalid_post_type', 'Invalid post type.' );
	575	+ }
	576	+ $chart_type = sanitize_text_field( $data['visualizer-chart-type'] );
	577	+ $source_type = sanitize_text_field( $data['visualizer-source'] );
	578	+
	579	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_TYPE, $chart_type );
	580	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_SOURCE, $source_type );
	581	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_DEFAULT_DATA, $data['visualizer-default-data'] );
	582	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_SERIES, $data['visualizer-series'] );
	583	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_SETTINGS, $data['visualizer-settings'] );
	584	+
	585	+ if ( $data['visualizer-chart-url'] && $data['visualizer-chart-schedule'] ) {
	586	+ $chart_url = esc_url_raw( $data['visualizer-chart-url'] );
	587	+ $chart_schedule = intval( $data['visualizer-chart-schedule'] );
	588	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_URL, $chart_url );
	589	+ apply_filters( 'visualizer_pro_chart_schedule', $data['id'], $chart_url, $chart_schedule );
	590	+ } else {
	591	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_URL );
	592	+ apply_filters( 'visualizer_pro_remove_schedule', $data['id'] );
	593	+ }
	594	+
	595	+ // let's check if this is not an external db chart
	596	+ // as there is no support for that in the block editor interface
	597	+ $external_params = get_post_meta( $data['id'], Visualizer_Plugin::CF_REMOTE_DB_PARAMS, true );
	598	+ if ( empty( $external_params ) ) {
	599	+ if ( $source_type === 'Visualizer_Source_Query' ) {
	600	+ $db_schedule = intval( $data['visualizer-db-schedule'] );
	601	+ $db_query = $data['visualizer-db-query'];
	602	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_DB_SCHEDULE, $db_schedule );
	603	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_DB_QUERY, stripslashes( $db_query ) );
	604	+ } else {
	605	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_DB_SCHEDULE );
	606	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_DB_QUERY );
	607	+ }
	608	+ }
	609	+
	610	+ if ( $source_type === 'Visualizer_Source_Json' ) {
	611	+ $json_schedule = intval( $data['visualizer-json-schedule'] );
	612	+ $json_url = esc_url_raw( $data['visualizer-json-url'] );
	613	+ $json_headers = esc_url_raw( $data['visualizer-json-headers'] );
	614	+ $json_root = $data['visualizer-json-root'];
	615	+ $json_paging = $data['visualizer-json-paging'];
	616	+
	617	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_SCHEDULE, $json_schedule );
	618	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_URL, $json_url );
	619	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_HEADERS, $json_headers );
	620	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_ROOT, $json_root );
	621	+
	622	+ if ( ! empty( $json_paging ) ) {
	623	+ update_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_PAGING, $json_paging );
	624	+ } else {
	625	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_PAGING );
	626	+ }
	627	+ } else {
	628	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_SCHEDULE );
	629	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_URL );
	630	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_HEADERS );
	631	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_ROOT );
	632	+ delete_post_meta( $data['id'], Visualizer_Plugin::CF_JSON_PAGING );
	633	+ }
	634	+
	635	+ if ( Visualizer_Module::is_pro() ) {
	636	+ update_post_meta( $data['id'], Visualizer_PRO::CF_PERMISSIONS, $data['visualizer-permissions'] );
	637	+ }
	638	+
	639	+ if ( $data['visualizer-chart-url'] ) {
	640	+ $chart_url = esc_url_raw( $data['visualizer-chart-url'] );
	641	+ $content['source'] = $chart_url;
	642	+ $content['data'] = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
	643	+ } else {
	644	+ $content = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
	645	+ }
	646	+
	647	+ $chart = array(
	648	+ 'ID' => $data['id'],
	649	+ 'post_content' => serialize( $content ),
	650	+ );
	651	+
	652	+ wp_update_post( $chart );
	653	+
	654	+ $revisions = wp_get_post_revisions( $data['id'], array( 'order' => 'ASC' ) );
	655	+
	656	+ if ( count( $revisions ) > 1 ) {
	657	+ $revision_ids = array_keys( $revisions );
	658	+
	659	+ // delete all revisions.
	660	+ foreach ( $revision_ids as $id ) {
	661	+ wp_delete_post_revision( $id );
	662	+ }
	663	+ }
	664	+
	665	+ return new \WP_REST_Response( array( 'success' => sprintf( 'Chart updated' ) ) );
	666	+ }
	667	+ }
	668	+
	669	+ /**
431	670	* Format chart data.
432	671	*
433	672	* Note: No matter how tempted, don't use the similar method from Visualizer_Source. That works on a different structure.
434	673	*/
		@@ -433,9 +672,9 @@
433	672	* Note: No matter how tempted, don't use the similar method from Visualizer_Source. That works on a different structure.
434	673	*/
435	674	public function format_chart_data( $data, $series ) {
436	675	foreach ( $series as $i => $row ) {
437		- // if no value exists for the series, then add null
	676	+ // if no value exists for the seires, then add null
438	677	if ( ! isset( $series[ $i ] ) ) {
439	678	$series[ $i ] = null;
440	679	}
441	680
		@@ -485,8 +724,82 @@
485	724	if ( ! function_exists( 'mb_detect_encoding' ) || mb_detect_encoding( $datum ) !== 'ASCII' ) {
486	725	$datum = \ForceUTF8\Encoding::toUTF8( $datum );
487	726	}
488	727	return $datum;
	728	+ }
	729	+
	730	+ /**
	731	+ * Handle remote CSV data
	732	+ */
	733	+ public function upload_csv_data( $data ) {
	734	+ if ( ! current_user_can( 'edit_posts' ) ) {
	735	+ return false;
	736	+ }
	737	+
	738	+ if ( $data['url'] && ! is_wp_error( $data['url'] ) && filter_var( $data['url'], FILTER_VALIDATE_URL ) ) {
	739	+ $source = new Visualizer_Source_Csv_Remote( $data['url'] );
	740	+ if ( $source->fetch() ) {
	741	+ $temp = $source->getData();
	742	+ if ( is_string( $temp ) && is_array( unserialize( $temp ) ) ) {
	743	+ $content['series'] = $source->getSeries();
	744	+ $content['data'] = $source->getRawData();
	745	+ return $content;
	746	+ } else {
	747	+ return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
	748	+ }
	749	+ } else {
	750	+ return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
	751	+ }
	752	+ } else {
	753	+ return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
	754	+ }
	755	+ }
	756	+
	757	+ /**
	758	+ * Get permission data
	759	+ */
	760	+ public function get_permission_data( $data ) {
	761	+ if ( ! current_user_can( 'edit_posts' ) ) {
	762	+ return false;
	763	+ }
	764	+
	765	+ $options = array();
	766	+ switch ( $data['type'] ) {
	767	+ case 'users':
	768	+ $query = new WP_User_Query(
	769	+ array(
	770	+ 'number' => 1000,
	771	+ 'orderby' => 'display_name',
	772	+ 'fields' => array( 'ID', 'display_name' ),
	773	+ 'count_total' => false,
	774	+ )
	775	+ );
	776	+ $users = $query->get_results();
	777	+ if ( ! empty( $users ) ) {
	778	+ $i = 0;
	779	+ foreach ( $users as $user ) {
	780	+ $options[ $i ]['value'] = $user->ID;
	781	+ $options[ $i ]['label'] = $user->display_name;
	782	+ $i++;
	783	+ }
	784	+ }
	785	+ break;
	786	+ case 'roles':
	787	+ if ( ! function_exists( 'get_editable_roles' ) ) {
	788	+ require_once ABSPATH . 'wp-admin/includes/user.php';
	789	+ }
	790	+ $roles = get_editable_roles();
	791	+ if ( ! empty( $roles ) ) {
	792	+ $i = 0;
	793	+ foreach ( get_editable_roles() as $name => $info ) {
	794	+ $options[ $i ]['value'] = $name;
	795	+ $options[ $i ]['label'] = $name;
	796	+ $i++;
	797	+ }
	798	+ }
	799	+ break;
	800	+ }
	801	+ return $options;
489	802	}
490	803
491	804	/**
492	805	* Filter Rest Query