← All changes | classes/Visualizer/Module/Chart.php +445 -43 3.1.2 → 3.3.0 View file →

		@@ -60,11 +60,159 @@
60	60	$this->_addAjaxAction( Visualizer_Plugin::ACTION_EXPORT_DATA, 'exportData' );
61	61
62	62	$this->_addAjaxAction( Visualizer_Plugin::ACTION_FETCH_DB_DATA, 'getQueryData' );
63	63	$this->_addAjaxAction( Visualizer_Plugin::ACTION_SAVE_DB_QUERY, 'saveQuery' );
	64	+
	65	+ $this->_addAjaxAction( Visualizer_Plugin::ACTION_JSON_GET_ROOTS, 'getJsonRoots' );
	66	+ $this->_addAjaxAction( Visualizer_Plugin::ACTION_JSON_GET_DATA, 'getJsonData' );
	67	+ $this->_addAjaxAction( Visualizer_Plugin::ACTION_JSON_SET_DATA, 'setJsonData' );
	68	+ $this->_addAjaxAction( Visualizer_Plugin::ACTION_JSON_SET_SCHEDULE, 'setJsonSchedule' );
	69	+
	70	+ $this->_addAjaxAction( Visualizer_Plugin::ACTION_SAVE_FILTER_QUERY, 'saveFilter' );
	71	+
64	72	}
65	73
66	74	/**
	75	+ * Sets the schedule for how JSON-endpoint charts should be updated.
	76	+ *
	77	+ * @since ?
	78	+ *
	79	+ * @access public
	80	+ */
	81	+ public function setJsonSchedule() {
	82	+ check_ajax_referer( Visualizer_Plugin::ACTION_JSON_SET_SCHEDULE . Visualizer_Plugin::VERSION, 'security' );
	83	+
	84	+ $chart_id = filter_input(
	85	+ INPUT_POST,
	86	+ 'chart',
	87	+ FILTER_VALIDATE_INT,
	88	+ array(
	89	+ 'options' => array(
	90	+ 'min_range' => 1,
	91	+ ),
	92	+ )
	93	+ );
	94	+
	95	+ if ( ! $chart_id ) {
	96	+ wp_send_json_error();
	97	+ }
	98	+
	99	+ $time = filter_input(
	100	+ INPUT_POST,
	101	+ 'time',
	102	+ FILTER_VALIDATE_INT,
	103	+ array(
	104	+ 'options' => array(
	105	+ 'min_range' => -1,
	106	+ ),
	107	+ )
	108	+ );
	109	+
	110	+ delete_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_SCHEDULE );
	111	+
	112	+ if ( -1 < $time ) {
	113	+ add_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_SCHEDULE, $time );
	114	+ }
	115	+ wp_send_json_success();
	116	+ }
	117	+
	118	+ /**
	119	+ * Get the root elements for JSON-endpoint.
	120	+ *
	121	+ * @since ?
	122	+ *
	123	+ * @access public
	124	+ */
	125	+ public function getJsonRoots() {
	126	+ check_ajax_referer( Visualizer_Plugin::ACTION_JSON_GET_ROOTS . Visualizer_Plugin::VERSION, 'security' );
	127	+
	128	+ $params = wp_parse_args( $_POST['params'] );
	129	+
	130	+ $source = new Visualizer_Source_Json( $params );
	131	+
	132	+ $roots = $source->fetchRoots();
	133	+ if ( empty( $roots ) ) {
	134	+ wp_send_json_error( array( 'msg' => $source->get_error() ) );
	135	+ }
	136	+
	137	+ wp_send_json_success( array( 'url' => $params['url'], 'roots' => $roots ) );
	138	+ }
	139	+
	140	+ /**
	141	+ * Get the data for the JSON-endpoint corresponding to the chosen root.
	142	+ *
	143	+ * @since ?
	144	+ *
	145	+ * @access public
	146	+ */
	147	+ public function getJsonData() {
	148	+ check_ajax_referer( Visualizer_Plugin::ACTION_JSON_GET_DATA . Visualizer_Plugin::VERSION, 'security' );
	149	+
	150	+ $params = wp_parse_args( $_POST['params'] );
	151	+
	152	+ $chart_id = $params['chart'];
	153	+
	154	+ if ( empty( $chart_id ) ) {
	155	+ wp_die();
	156	+ }
	157	+
	158	+ $source = new Visualizer_Source_Json( $params );
	159	+
	160	+ $data = $source->parse();
	161	+ if ( empty( $data ) ) {
	162	+ wp_send_json_error( array( 'msg' => esc_html__( 'Unable to fetch data from the endpoint. Please try again.', 'visualizer' ) ) );
	163	+ }
	164	+
	165	+ $data = Visualizer_Render_Layout::show( 'editor-table', $data, $chart_id, 'viz-json-table', false, false );
	166	+ wp_send_json_success( array( 'table' => $data, 'root' => $params['root'], 'url' => $params['url'], 'paging' => $source->getPaginationElements() ) );
	167	+ }
	168	+
	169	+ /**
	170	+ * Updates the database with the correct post parameters for JSON-endpoint charts.
	171	+ *
	172	+ * @since ?
	173	+ *
	174	+ * @access public
	175	+ */
	176	+ public function setJsonData() {
	177	+ check_ajax_referer( Visualizer_Plugin::ACTION_JSON_SET_DATA . Visualizer_Plugin::VERSION, 'security' );
	178	+
	179	+ $params = $_POST;
	180	+ $chart_id = $_GET['chart'];
	181	+
	182	+ if ( empty( $chart_id ) ) {
	183	+ wp_die();
	184	+ }
	185	+
	186	+ $chart = get_post( $chart_id );
	187	+
	188	+ $source = new Visualizer_Source_Json( $params );
	189	+ $source->fetch();
	190	+
	191	+ $content = $source->getData();
	192	+ $chart->post_content = $content;
	193	+ wp_update_post( $chart->to_array() );
	194	+ update_post_meta( $chart->ID, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
	195	+ update_post_meta( $chart->ID, Visualizer_Plugin::CF_SOURCE, $source->getSourceName() );
	196	+ update_post_meta( $chart->ID, Visualizer_Plugin::CF_DEFAULT_DATA, 0 );
	197	+ update_post_meta( $chart->ID, Visualizer_Plugin::CF_JSON_URL, $params['url'] );
	198	+ update_post_meta( $chart->ID, Visualizer_Plugin::CF_JSON_ROOT, $params['root'] );
	199	+ delete_post_meta( $chart->ID, Visualizer_Plugin::CF_JSON_PAGING );
	200	+ if ( ! empty( $params['paging'] ) ) {
	201	+ add_post_meta( $chart->ID, Visualizer_Plugin::CF_JSON_PAGING, $params['paging'] );
	202	+ }
	203	+
	204	+ $render = new Visualizer_Render_Page_Update();
	205	+ $render->id = $chart->ID;
	206	+ $render->data = json_encode( $source->getRawData() );
	207	+ $render->series = json_encode( $source->getSeries() );
	208	+ $render->render();
	209	+
	210	+ defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
	211	+ }
	212	+
	213	+
	214	+ /**
67	215	* Fetches charts from database.
68	216	*
69	217	* This method is also called from the media pop-up (classic editor: create a post and add chart from insert content).
70	218	*
		@@ -93,9 +241,9 @@
93	241	// 'filter' is from the modal from the add media button.
94	242	$filter = filter_input( INPUT_GET, 'filter', FILTER_SANITIZE_STRING );
95	243	}
96	244
97		- if ( $filter && in_array( $filter, Visualizer_Plugin::getChartTypes() ) ) {
	245	+ if ( $filter && in_array( $filter, Visualizer_Plugin::getChartTypes(), true ) ) {
98	246	$query_args['meta_query'] = array(
99	247	array(
100	248	'key' => Visualizer_Plugin::CF_CHART_TYPE,
101	249	'value' => $filter,
		@@ -162,8 +310,10 @@
162	310	$css = $arguments[0];
163	311	$settings = $arguments[1];
164	312	}
165	313
	314	+ $date_formats = Visualizer_Source::get_date_formats_if_exists( $series, $data );
	315	+
166	316	return array(
167	317	'type' => $type,
168	318	'series' => $series,
169	319	'settings' => $settings,
		@@ -169,8 +319,9 @@
169	319	'settings' => $settings,
170	320	'data' => $data,
171	321	'library' => $library,
172	322	'css' => $css,
	323	+ 'date_formats' => $date_formats,
173	324	);
174	325	}
175	326
176	327	/**
		@@ -197,9 +348,9 @@
197	348	*
198	349	* @access public
199	350	*/
200	351	public function deleteChart() {
201		- $is_post = $_SERVER['REQUEST_METHOD'] == 'POST';
	352	+ $is_post = $_SERVER['REQUEST_METHOD'] === 'POST';
202	353	$input_method = $is_post ? INPUT_POST : INPUT_GET;
203	354	$chart_id = $success = false;
204	355	$nonce = wp_verify_nonce( filter_input( $input_method, 'nonce' ) );
205	356	$capable = current_user_can( 'delete_posts' );
		@@ -215,9 +366,9 @@
215	366	)
216	367	);
217	368	if ( $chart_id ) {
218	369	$chart = get_post( $chart_id );
219		- $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
	370	+ $success = $chart && $chart->post_type === Visualizer_Plugin::CPT_VISUALIZER;
220	371	}
221	372	}
222	373	if ( $success ) {
223	374	wp_delete_post( $chart_id, true );
		@@ -228,13 +379,41 @@
228	379	'success' => $success,
229	380	)
230	381	);
231	382	}
232		- wp_redirect( wp_get_referer() );
	383	+ wp_redirect( remove_query_arg( 'vaction', wp_get_referer() ) );
233	384	exit;
234	385	}
235	386
236	387	/**
	388	+ * Delete charts that are still in auto-draft mode.
	389	+ */
	390	+ private function deleteOldCharts() {
	391	+ $query = new WP_Query(
	392	+ array(
	393	+ 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
	394	+ 'post_status' => 'auto-draft',
	395	+ 'fields' => 'ids',
	396	+ 'update_post_meta_cache' => false,
	397	+ 'update_post_term_cache' => false,
	398	+ 'posts_per_page' => 50,
	399	+ 'date_query' => array(
	400	+ array(
	401	+ 'before' => 'today',
	402	+ ),
	403	+ ),
	404	+ )
	405	+ );
	406	+
	407	+ if ( $query->have_posts() ) {
	408	+ $ids = array();
	409	+ while ( $query->have_posts() ) {
	410	+ wp_delete_post( $query->next_post(), true );
	411	+ }
	412	+ }
	413	+ }
	414	+
	415	+ /**
237	416	* Renders appropriate page for chart builder. Creates new auto draft chart
238	417	* if no chart has been specified.
239	418	*
240	419	* @since 1.0.0
		@@ -244,9 +423,10 @@
244	423	public function renderChartPages() {
245	424	defined( 'IFRAME_REQUEST' ) || define( 'IFRAME_REQUEST', 1 );
246	425	// check chart, if chart not exists, will create new one and redirects to the same page with proper chart id
247	426	$chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT ) : '';
248		- if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type != Visualizer_Plugin::CPT_VISUALIZER ) {
	427	+ if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type !== Visualizer_Plugin::CPT_VISUALIZER ) {
	428	+ $this->deleteOldCharts();
249	429	$default_type = isset( $_GET['type'] ) && ! empty( $_GET['type'] ) ? $_GET['type'] : 'line';
250	430	$source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $default_type . '.csv' );
251	431	$source->fetch();
252	432	$chart_id = wp_insert_post(
		@@ -275,16 +455,23 @@
275	455	wp_redirect( add_query_arg( 'chart', (int) $chart_id ) );
276	456	defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
277	457	}
278	458
279		- $this->load_chart_type( $chart_id );
	459	+ $lib = $this->load_chart_type( $chart_id );
280	460
	461	+ // the alpha color picker (RGBA) is not supported by google.
	462	+ $color_picker_dep = 'wp-color-picker';
	463	+ if ( in_array( $lib, array( 'chartjs', 'datatables' ), true ) && ! wp_script_is( 'wp-color-picker-alpha', 'registered' ) ) {
	464	+ wp_register_script( 'wp-color-picker-alpha', VISUALIZER_ABSURL . 'js/lib/wp-color-picker-alpha.min.js', array( 'wp-color-picker' ), Visualizer_Plugin::VERSION );
	465	+ $color_picker_dep = 'wp-color-picker-alpha';
	466	+ }
	467	+
281	468	// enqueue and register scripts and styles
282	469	wp_register_script( 'visualizer-chosen', VISUALIZER_ABSURL . 'js/lib/chosen.jquery.min.js', array( 'jquery' ), Visualizer_Plugin::VERSION );
283	470	wp_register_style( 'visualizer-chosen', VISUALIZER_ABSURL . 'css/lib/chosen.min.css', array(), Visualizer_Plugin::VERSION );
284	471
285	472	wp_register_style( 'visualizer-frame', VISUALIZER_ABSURL . 'css/frame.css', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION );
286		- wp_register_script( 'visualizer-frame', VISUALIZER_ABSURL . 'js/frame.js', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION, true );
	473	+ wp_register_script( 'visualizer-frame', VISUALIZER_ABSURL . 'js/frame.js', array( 'visualizer-chosen', 'jquery-ui-accordion' ), Visualizer_Plugin::VERSION, true );
287	474	wp_register_script( 'visualizer-customization', $this->get_user_customization_js(), array(), null, true );
288	475	wp_register_script(
289	476	'visualizer-render',
290	477	VISUALIZER_ABSURL . 'js/render-facade.js',
		@@ -295,19 +482,23 @@
295	482	wp_register_script(
296	483	'visualizer-preview',
297	484	VISUALIZER_ABSURL . 'js/preview.js',
298	485	array(
299		- 'wp-color-picker',
	486	+ $color_picker_dep,
300	487	'visualizer-render',
301	488	),
302	489	Visualizer_Plugin::VERSION,
303	490	true
304	491	);
305		- // added by Ash/Upwork
306		- if ( VISUALIZER_PRO ) {
	492	+ wp_register_script( 'visualizer-editor-simple', VISUALIZER_ABSURL . 'js/simple-editor.js', array( 'jquery' ), Visualizer_Plugin::VERSION, true );
	493	+
	494	+ do_action( 'visualizer_add_scripts' );
	495	+
	496	+ if ( Visualizer_Module::is_pro() && Visualizer_Module::is_pro_older_than( '1.9.0' ) ) {
307	497	global $Visualizer_Pro;
308	498	$Visualizer_Pro->_addScriptsAndStyles();
309	499	}
	500	+
310	501	// dispatch pages
311	502	$this->_chart = get_post( $chart_id );
312	503	$tab = isset( $_GET['tab'] ) && ! empty( $_GET['tab'] ) ? $_GET['tab'] : 'visualizer';
313	504
		@@ -347,22 +538,23 @@
347	538	*/
348	539	private function loadCodeEditorAssets() {
349	540	global $wp_version;
350	541
351		- if ( ! VISUALIZER_PRO ) {
	542	+ $wp_scripts = wp_scripts();
	543	+
	544	+ // data tables assets.
	545	+ wp_register_script( 'visualizer-datatables', VISUALIZER_ABSURL . 'js/lib/datatables.min.js', array( 'jquery-ui-core' ), Visualizer_Plugin::VERSION );
	546	+ wp_register_style( 'visualizer-datatables', VISUALIZER_ABSURL . 'css/lib/datatables.min.css', array(), Visualizer_Plugin::VERSION );
	547	+ wp_register_style( 'visualizer-jquery-ui', sprintf( '//ajax.googleapis.com/ajax/libs/jqueryui/%s/themes/smoothness/jquery-ui.css', $wp_scripts->registered['jquery-ui-core']->ver ), array( 'visualizer-datatables' ), Visualizer_Plugin::VERSION );
	548	+ wp_enqueue_script( 'visualizer-datatables' );
	549	+ wp_enqueue_style( 'visualizer-jquery-ui' );
	550	+
	551	+ if ( ! Visualizer_Module::is_pro() ) {
352	552	return;
353	553	}
354	554
355	555	$table_col_mapping = Visualizer_Source_Query_Params::get_all_db_tables_column_mapping();
356	556
357		- // data tables assets.
358		- wp_register_script( 'visualizer-datatables', '//cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js', array( 'jquery-ui-core' ), Visualizer_Plugin::VERSION );
359		- wp_register_style( 'visualizer-datatables', '//cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css', array(), Visualizer_Plugin::VERSION );
360		- wp_register_style( 'visualizer-datatables-ui', '//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css', array( 'visualizer-datatables' ), Visualizer_Plugin::VERSION );
361		-
362		- wp_enqueue_script( 'visualizer-datatables' );
363		- wp_enqueue_style( 'visualizer-datatables-ui' );
364		-
365	557	if ( version_compare( $wp_version, '4.9.0', '<' ) ) {
366	558	// code mirror assets.
367	559	wp_register_script( 'visualizer-codemirror-core', '//codemirror.net/lib/codemirror.js', array( 'jquery' ), Visualizer_Plugin::VERSION );
368	560	wp_register_script( 'visualizer-codemirror-placeholder', '//codemirror.net/addon/display/placeholder.js', array( 'visualizer-codemirror-core' ), Visualizer_Plugin::VERSION );
		@@ -402,10 +594,10 @@
402	594	private function _handleDataAndSettingsPage() {
403	595	if ( isset( $_POST['map_api_key'] ) ) {
404	596	update_option( 'visualizer-map-api-key', $_POST['map_api_key'] );
405	597	}
406		- if ( $_SERVER['REQUEST_METHOD'] == 'POST' && isset( $_GET['nonce'] ) && wp_verify_nonce( $_GET['nonce'] ) ) {
407		- if ( $this->_chart->post_status == 'auto-draft' ) {
	598	+ if ( $_SERVER['REQUEST_METHOD'] === 'POST' && isset( $_GET['nonce'] ) && wp_verify_nonce( $_GET['nonce'] ) ) {
	599	+ if ( $this->_chart->post_status === 'auto-draft' ) {
408	600	$this->_chart->post_status = 'publish';
409	601
410	602	// ensure that a revision is not created. If a revision is created it will have the proper data and the parent of the revision will have default data.
411	603	// we do not want any difference in data so disable revisions temporarily.
		@@ -414,8 +606,24 @@
414	606	}
415	607	// save meta data only when it is NOT being canceled.
416	608	if ( ! ( isset( $_POST['cancel'] ) && 1 === intval( $_POST['cancel'] ) ) ) {
417	609	update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SETTINGS, $_POST );
	610	+
	611	+ // we will keep a parameter called 'internal_title' that will be set to the given title or, if empty, the chart ID
	612	+ // this will help in searching with the chart id.
	613	+ $settings = get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SETTINGS, true );
	614	+ $title = null;
	615	+ if ( isset( $settings['title'] ) && ! empty( $settings['title'] ) ) {
	616	+ $title = $settings['title'];
	617	+ if ( is_array( $title ) ) {
	618	+ $title = $settings['title']['text'];
	619	+ }
	620	+ }
	621	+ if ( empty( $title ) ) {
	622	+ $title = $this->_chart->ID;
	623	+ }
	624	+ $settings['internal_title'] = $title;
	625	+ update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SETTINGS, $settings );
418	626	}
419	627	$render = new Visualizer_Render_Page_Send();
420	628	$render->text = sprintf( '[visualizer id="%d"]', $this->_chart->ID );
421	629	wp_iframe( array( $render, 'render' ) );
		@@ -423,9 +631,9 @@
423	631	return;
424	632	}
425	633	$data = $this->_getChartArray();
426	634	$sidebar = '';
427		- $sidebar_class = 'Visualizer_Render_Sidebar_Type_' . ucfirst( $data['type'] );
	635	+ $sidebar_class = $this->load_chart_class_name( $this->_chart->ID );
428	636	if ( class_exists( $sidebar_class, true ) ) {
429	637	$sidebar = new $sidebar_class( $data['settings'] );
430	638	$sidebar->__series = $data['series'];
431	639	$sidebar->__data = $data['data'];
		@@ -430,14 +638,14 @@
430	638	$sidebar->__series = $data['series'];
431	639	$sidebar->__data = $data['data'];
432	640	} else {
433	641	$sidebar = apply_filters( 'visualizer_pro_chart_type_sidebar', '', $data );
434		- if ( $sidebar != '' ) {
	642	+ if ( $sidebar !== '' ) {
435	643	$sidebar->__series = $data['series'];
436	644	$sidebar->__data = $data['data'];
437	645	}
438	646	}
439		- unset( $data['settings']['width'], $data['settings']['height'] );
	647	+ unset( $data['settings']['width'], $data['settings']['height'], $data['settings']['chartArea'] );
440	648	wp_enqueue_style( 'wp-color-picker' );
441	649	wp_enqueue_style( 'visualizer-frame' );
442	650	wp_enqueue_script( 'visualizer-preview' );
443	651	wp_enqueue_script( 'visualizer-chosen' );
		@@ -442,8 +650,25 @@
442	650	wp_enqueue_script( 'visualizer-preview' );
443	651	wp_enqueue_script( 'visualizer-chosen' );
444	652	wp_enqueue_script( 'visualizer-render' );
445	653
	654	+ if ( ! Visualizer_Module::is_pro() ) {
	655	+ wp_enqueue_script( 'visualizer-editor-simple' );
	656	+ wp_localize_script(
	657	+ 'visualizer-editor-simple',
	658	+ 'visualizer1',
	659	+ array(
	660	+ 'ajax' => array(
	661	+ 'url' => admin_url( 'admin-ajax.php' ),
	662	+ 'nonces' => array(
	663	+ ),
	664	+ 'actions' => array(
	665	+ ),
	666	+ ),
	667	+ )
	668	+ );
	669	+ }
	670	+
446	671	$table_col_mapping = $this->loadCodeEditorAssets();
447	672
448	673	wp_localize_script(
449	674	'visualizer-render',
		@@ -451,8 +676,9 @@
451	676	array(
452	677	'l10n' => array(
453	678	'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
454	679	'loading' => esc_html__( 'Loading...', 'visualizer' ),
	680	+ 'json_error' => esc_html__( 'An error occured in fetching data.', 'visualizer' ),
455	681	),
456	682	'charts' => array(
457	683	'canvas' => $data,
458	684	'id' => $this->_chart->ID,
		@@ -463,19 +689,28 @@
463	689	'url' => admin_url( 'admin-ajax.php' ),
464	690	'nonces' => array(
465	691	'permissions' => wp_create_nonce( Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA ),
466	692	'db_get_data' => wp_create_nonce( Visualizer_Plugin::ACTION_FETCH_DB_DATA . Visualizer_Plugin::VERSION ),
	693	+ 'json_get_roots' => wp_create_nonce( Visualizer_Plugin::ACTION_JSON_GET_ROOTS . Visualizer_Plugin::VERSION ),
	694	+ 'json_get_data' => wp_create_nonce( Visualizer_Plugin::ACTION_JSON_GET_DATA . Visualizer_Plugin::VERSION ),
	695	+ 'json_set_schedule' => wp_create_nonce( Visualizer_Plugin::ACTION_JSON_SET_SCHEDULE . Visualizer_Plugin::VERSION ),
467	696	),
468	697	'actions' => array(
469	698	'permissions' => Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA,
470	699	'db_get_data' => Visualizer_Plugin::ACTION_FETCH_DB_DATA,
	700	+ 'json_get_roots' => Visualizer_Plugin::ACTION_JSON_GET_ROOTS,
	701	+ 'json_get_data' => Visualizer_Plugin::ACTION_JSON_GET_DATA,
	702	+ 'json_set_schedule' => Visualizer_Plugin::ACTION_JSON_SET_SCHEDULE,
471	703	),
472	704	),
473	705	'db_query' => array(
474	706	'tables' => $table_col_mapping,
475	707	),
476		- 'is_pro' => VISUALIZER_PRO,
	708	+ 'is_pro' => Visualizer_Module::is_pro(),
477	709	'page_type' => 'chart',
	710	+ 'json_tag_separator' => Visualizer_Source_Json::TAG_SEPARATOR,
	711	+ 'json_tag_separator_view' => Visualizer_Source_Json::TAG_SEPARATOR_VIEW,
	712	+ 'is_front' => false,
478	713	)
479	714	);
480	715
481	716	$render = new Visualizer_Render_Page_Data();
		@@ -483,21 +718,25 @@
483	718	$render->type = $data['type'];
484	719	$render->custom_css = $data['css'];
485	720	$render->sidebar = $sidebar;
486	721	if ( filter_input( INPUT_GET, 'library', FILTER_VALIDATE_BOOLEAN ) ) {
487		- $render->button = filter_input( INPUT_GET, 'action' ) == Visualizer_Plugin::ACTION_EDIT_CHART
	722	+ $render->button = filter_input( INPUT_GET, 'action' ) === Visualizer_Plugin::ACTION_EDIT_CHART
488	723	? esc_html__( 'Save Chart', 'visualizer' )
489	724	: esc_html__( 'Create Chart', 'visualizer' );
490		- if ( filter_input( INPUT_GET, 'action' ) == Visualizer_Plugin::ACTION_EDIT_CHART ) {
	725	+ if ( filter_input( INPUT_GET, 'action' ) === Visualizer_Plugin::ACTION_EDIT_CHART ) {
491	726	$render->cancel_button = esc_html__( 'Cancel', 'visualizer' );
492	727	}
493	728	} else {
494	729	$render->button = esc_attr__( 'Insert Chart', 'visualizer' );
495	730	}
496		- if ( VISUALIZER_PRO ) {
	731	+
	732	+ do_action( 'visualizer_enqueue_scripts_and_styles', $data );
	733	+
	734	+ if ( Visualizer_Module::is_pro() && Visualizer_Module::is_pro_older_than( '1.9.0' ) ) {
497	735	global $Visualizer_Pro;
498	736	$Visualizer_Pro->_enqueueScriptsAndStyles( $data );
499	737	}
	738	+
500	739	$this->_addAction( 'admin_head', 'renderFlattrScript' );
501	740	wp_iframe( array( $render, 'render' ) );
502	741	}
503	742
		@@ -509,13 +748,21 @@
509	748	* @access private
510	749	*/
511	750	private function _handleTypesPage() {
512	751	// process post request
513		- if ( $_SERVER['REQUEST_METHOD'] == 'POST' && wp_verify_nonce( filter_input( INPUT_POST, 'nonce' ) ) ) {
	752	+ if ( $_SERVER['REQUEST_METHOD'] === 'POST' && wp_verify_nonce( filter_input( INPUT_POST, 'nonce' ) ) ) {
514	753	$type = filter_input( INPUT_POST, 'type' );
515		- if ( in_array( $type, Visualizer_Plugin::getChartTypes() ) ) {
	754	+ $library = filter_input( INPUT_POST, 'chart-library' );
	755	+ if ( in_array( $type, Visualizer_Plugin::getChartTypes(), true ) ) {
	756	+ if ( empty( $library ) ) {
	757	+ // library cannot be empty.
	758	+ do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, 'Chart library empty while creating the chart! Aborting...', 'error', __FILE__, __LINE__ );
	759	+ return;
	760	+ }
	761	+
516	762	// save new chart type
517	763	update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_TYPE, $type );
	764	+ update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_LIBRARY, $library );
518	765	// if the chart has default data, update it with appropriate default data for new type
519	766	if ( filter_var( get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_DEFAULT_DATA, true ), FILTER_VALIDATE_BOOLEAN ) ) {
520	767	$source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $type . '.csv' );
521	768	$source->fetch();
		@@ -522,8 +769,11 @@
522	769	$this->_chart->post_content = $source->getData();
523	770	wp_update_post( $this->_chart->to_array() );
524	771	update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
525	772	}
	773	+
	774	+ Visualizer_Module_Utility::set_defaults( $this->_chart );
	775	+
526	776	// redirect to next tab
527	777	// changed by Ash/Upwork
528	778	wp_redirect( add_query_arg( 'tab', 'settings' ) );
529	779
		@@ -531,9 +781,9 @@
531	781	}
532	782	}
533	783	$render = new Visualizer_Render_Page_Types();
534	784	$render->type = get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_TYPE, true );
535		- $render->types = Visualizer_Module_Admin::_getChartTypesLocalized();
	785	+ $render->types = Visualizer_Module_Admin::_getChartTypesLocalized( false, false, false, 'types' );
536	786	$render->chart = $this->_chart;
537	787	wp_enqueue_style( 'visualizer-frame' );
538	788	wp_enqueue_script( 'visualizer-frame' );
539	789	wp_iframe( array( $render, 'render' ) );
		@@ -549,10 +799,110 @@
549	799	*/
550	800	public function renderFlattrScript() {
551	801	echo '';
552	802	}
553		- // changed by Ash/Upwork
	803	+
554	804	/**
	805	+ * Processes the CSV that is sent in the request as a string.
	806	+ *
	807	+ * @since 3.2.0
	808	+ */
	809	+ private function handleCSVasString( $data ) {
	810	+ $source = null;
	811	+
	812	+ // @issue https://github.com/Codeinwp/visualizer/issues/412
	813	+ if ( has_filter( 'visualizer_pro_handle_chart_data' ) ) {
	814	+ $source = apply_filters( 'visualizer_pro_handle_chart_data', $data, '' );
	815	+ } else {
	816	+ // data coming in from the text editor.
	817	+ $tmpfile = tempnam( get_temp_dir(), Visualizer_Plugin::NAME );
	818	+ $handle = fopen( $tmpfile, 'w' );
	819	+ $values = preg_split( '/[\n\r]+/', stripslashes( trim( $data ) ) );
	820	+ if ( $values ) {
	821	+ foreach ( $values as $row ) {
	822	+ if ( empty( $row ) ) {
	823	+ continue;
	824	+ }
	825	+ $columns = explode( ',', $row );
	826	+ fputcsv( $handle, $columns );
	827	+ }
	828	+ }
	829	+ $source = new Visualizer_Source_Csv( $tmpfile );
	830	+ fclose( $handle );
	831	+ }
	832	+ return $source;
	833	+ }
	834	+
	835	+ /**
	836	+ * Parses the data uploaded as an HTML table.
	837	+ *
	838	+ * @since 3.2.0
	839	+ *
	840	+ * @access private
	841	+ */
	842	+ private function handleTabularData() {
	843	+ $csv = array();
	844	+ // the datatable mentions the headers twice, so lets remove the duplicates.
	845	+ $headers = array_unique( array_filter( $_POST['header'] ) );
	846	+ $types = $_POST['type'];
	847	+
	848	+ // capture all the indexes that correspond to excluded columns.
	849	+ $exclude = array();
	850	+ $index = 0;
	851	+ foreach ( $types as $type ) {
	852	+ if ( empty( $type ) ) {
	853	+ $exclude[] = $index;
	854	+ }
	855	+ $index++;
	856	+ }
	857	+
	858	+ // when N headers are being renamed, the number of headers increases by N
	859	+ // because of the way datatable duplicates header information
	860	+ // so unset the headers that have been renamed.
	861	+ if ( count( $headers ) !== count( $types ) ) {
	862	+ $to = count( $headers );
	863	+ for ( $i = count( $types ); $i < $to; $i++ ) {
	864	+ unset( $headers[ $i + 1 ] );
	865	+ }
	866	+ }
	867	+
	868	+ $columns = array();
	869	+ for ( $i = 0; $i < count( $headers ); $i++ ) {
	870	+ if ( ! isset( $_POST[ 'data' . $i ] ) ) {
	871	+ continue;
	872	+ }
	873	+ $columns[ $i ] = $_POST[ 'data' . $i ];
	874	+ }
	875	+
	876	+ $csv[] = $headers;
	877	+ $csv[] = $types;
	878	+ for ( $j = 0; $j < count( $columns[0] ); $j++ ) {
	879	+ $row = array();
	880	+ for ( $i = 0; $i < count( $headers ); $i++ ) {
	881	+ $row[] = $columns[ $i ][ $j ];
	882	+ }
	883	+ $csv[] = $row;
	884	+ }
	885	+
	886	+ $tmpfile = tempnam( get_temp_dir(), Visualizer_Plugin::NAME );
	887	+ $handle = fopen( $tmpfile, 'w' );
	888	+
	889	+ if ( $csv ) {
	890	+ $index = 0;
	891	+ foreach ( $csv as $row ) {
	892	+ // remove all the cells corresponding to the excluded headers.
	893	+ foreach ( $exclude as $j ) {
	894	+ unset( $row[ $j ] );
	895	+ }
	896	+ fputcsv( $handle, $row );
	897	+ }
	898	+ }
	899	+ $source = new Visualizer_Source_Csv( $tmpfile );
	900	+ fclose( $handle );
	901	+ return $source;
	902	+ }
	903	+
	904	+ /**
555	905	* Parses uploaded CSV file and saves new data for the chart.
556	906	*
557	907	* @since 1.0.0
558	908	*
		@@ -574,9 +924,9 @@
574	924
575	925	// check chart, if chart exists
576	926	// do not use filter_input as it does not work for phpunit test cases, use filter_var instead
577	927	$chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT ) : '';
578		- if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type != Visualizer_Plugin::CPT_VISUALIZER ) {
	928	+ if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type !== Visualizer_Plugin::CPT_VISUALIZER ) {
579	929	if ( ! $can_die ) {
580	930	return;
581	931	}
582	932	status_header( 400 );
		@@ -588,9 +938,11 @@
588	938	}
589	939
590	940	if ( ! isset( $_POST['chart_data_src'] ) || Visualizer_Plugin::CF_SOURCE_FILTER !== $_POST['chart_data_src'] ) {
591	941	// delete the filters in case this chart is being uploaded from other data sources
592		- delete_post_meta( $chart_id, 'visualizer-filter-config' );
	942	+ delete_post_meta( $chart_id, Visualizer_Plugin::CF_FILTER_CONFIG );
	943	+ delete_post_meta( $chart_id, '__transient-' . Visualizer_Plugin::CF_FILTER_CONFIG );
	944	+ delete_post_meta( $chart_id, '__transient-' . Visualizer_Plugin::CF_DB_QUERY );
593	945
594	946	// delete "import from db" specific parameters.
595	947	delete_post_meta( $chart_id, Visualizer_Plugin::CF_DB_QUERY );
596	948	delete_post_meta( $chart_id, Visualizer_Plugin::CF_DB_SCHEDULE );
		@@ -595,8 +947,13 @@
595	947	delete_post_meta( $chart_id, Visualizer_Plugin::CF_DB_QUERY );
596	948	delete_post_meta( $chart_id, Visualizer_Plugin::CF_DB_SCHEDULE );
597	949	}
598	950
	951	+ // delete json related data.
	952	+ delete_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_URL );
	953	+ delete_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_ROOT );
	954	+ delete_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_PAGING );
	955	+
599	956	$source = null;
600	957	$render = new Visualizer_Render_Page_Update();
601	958	if ( isset( $_POST['remote_data'] ) && filter_var( $_POST['remote_data'], FILTER_VALIDATE_URL ) ) {
602	959	$source = new Visualizer_Source_Csv_Remote( $_POST['remote_data'] );
		@@ -602,14 +959,17 @@
602	959	$source = new Visualizer_Source_Csv_Remote( $_POST['remote_data'] );
603	960	if ( isset( $_POST['vz-import-time'] ) ) {
604	961	apply_filters( 'visualizer_pro_chart_schedule', $chart_id, $_POST['remote_data'], $_POST['vz-import-time'] );
605	962	}
	963	+ // phpcs:ignore WordPress.PHP.StrictComparisons.LooseComparison
606	964	} elseif ( isset( $_FILES['local_data'] ) && $_FILES['local_data']['error'] == 0 ) {
607	965	$source = new Visualizer_Source_Csv( $_FILES['local_data']['tmp_name'] );
608	966	} elseif ( isset( $_POST['chart_data'] ) && strlen( $_POST['chart_data'] ) > 0 ) {
609		- $source = apply_filters( 'visualizer_pro_handle_chart_data', $_POST['chart_data'], '' );
	967	+ $source = $this->handleCSVasString( $_POST['chart_data'] );
	968	+ } elseif ( isset( $_POST['table_data'] ) && 'yes' === $_POST['table_data'] ) {
	969	+ $source = $this->handleTabularData();
610	970	} else {
611		- $render->message = esc_html__( 'CSV file with chart data was not uploaded. Please, try again.', 'visualizer' );
	971	+ $render->message = esc_html__( 'CSV file with chart data was not uploaded. Please try again.', 'visualizer' );
612	972	}
613	973	if ( $source ) {
614	974	if ( $source->fetch() ) {
615	975	$content = $source->getData();
		@@ -629,13 +989,22 @@
629	989	wp_update_post( $chart->to_array() );
630	990	update_post_meta( $chart->ID, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
631	991	update_post_meta( $chart->ID, Visualizer_Plugin::CF_SOURCE, $source->getSourceName() );
632	992	update_post_meta( $chart->ID, Visualizer_Plugin::CF_DEFAULT_DATA, 0 );
	993	+
	994	+ Visualizer_Module_Utility::set_defaults( $chart, null );
	995	+
	996	+ $settings = get_post_meta( $chart->ID, Visualizer_Plugin::CF_SETTINGS, true );
	997	+
633	998	$render->id = $chart->ID;
634	999	$render->data = json_encode( $source->getRawData() );
635	1000	$render->series = json_encode( $source->getSeries() );
	1001	+ $render->settings = json_encode( $settings );
636	1002	} else {
637		- $render->message = esc_html__( 'CSV file is broken or invalid. Please, try again.', 'visualizer' );
	1003	+ $render->message = $source->get_error();
	1004	+ if ( empty( $render->message ) ) {
	1005	+ $render->message = esc_html__( 'CSV file is broken or invalid. Please try again.', 'visualizer' );
	1006	+ }
638	1007	}
639	1008	}
640	1009	$render->render();
641	1010	if ( ! $can_die ) {
		@@ -667,12 +1036,12 @@
667	1036	)
668	1037	);
669	1038	if ( $chart_id ) {
670	1039	$chart = get_post( $chart_id );
671		- $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
	1040	+ $success = $chart && $chart->post_type === Visualizer_Plugin::CPT_VISUALIZER;
672	1041	}
673	1042	}
674		- $redirect = wp_get_referer();
	1043	+ $redirect = remove_query_arg( 'vaction', wp_get_referer() );
675	1044	if ( $success ) {
676	1045	$new_chart_id = wp_insert_post(
677	1046	array(
678	1047	'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
		@@ -691,10 +1060,11 @@
691	1060	$redirect = add_query_arg(
692	1061	array(
693	1062	'page' => 'visualizer',
694	1063	'type' => filter_input( INPUT_GET, 'type' ),
	1064	+ 'vaction' => false,
695	1065	),
696		- admin_url( 'upload.php' )
	1066	+ admin_url( 'admin.php' )
697	1067	);
698	1068	}
699	1069	}
700	1070	wp_redirect( $redirect );
		@@ -743,9 +1113,9 @@
743	1113	$data = $this->_getChartArray();
744	1114	$render = new Visualizer_Render_Page_Data();
745	1115	$render->chart = $this->_chart;
746	1116	$render->type = $data['type'];
747		- unset( $data['settings']['width'], $data['settings']['height'] );
	1117	+ unset( $data['settings']['width'], $data['settings']['height'], $data['settings']['chartArea'] );
748	1118	wp_enqueue_style( 'visualizer-frame' );
749	1119	wp_enqueue_script( 'visualizer-render' );
750	1120	wp_localize_script(
751	1121	'visualizer-render',
		@@ -759,13 +1129,16 @@
759	1129	'canvas' => $data,
760	1130	),
761	1131	)
762	1132	);
763		- // Added by Ash/Upwork
764		- if ( VISUALIZER_PRO ) {
	1133	+
	1134	+ do_action( 'visualizer_enqueue_scripts_and_styles', $data );
	1135	+
	1136	+ if ( Visualizer_Module::is_pro() && Visualizer_Module::is_pro_older_than( '1.9.0' ) ) {
765	1137	global $Visualizer_Pro;
766	1138	$Visualizer_Pro->_enqueueScriptsAndStyles( $data );
767	1139	}
	1140	+
768	1141	// Added by Ash/Upwork
769	1142	$this->_addAction( 'admin_head', 'renderFlattrScript' );
770	1143	wp_iframe( array( $render, 'render' ) );
771	1144	}
		@@ -838,8 +1211,37 @@
838	1211	$render->message = $error;
839	1212	}
840	1213	}
841	1214	$render->render();
	1215	+ if ( ! ( defined( 'VISUALIZER_DO_NOT_DIE' ) && VISUALIZER_DO_NOT_DIE ) ) {
	1216	+ defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
	1217	+ }
	1218	+ }
	1219	+
	1220	+
	1221	+ /**
	1222	+ * Saves the filter query and the schedule.
	1223	+ *
	1224	+ * @access public
	1225	+ */
	1226	+ public function saveFilter() {
	1227	+ check_ajax_referer( Visualizer_Plugin::ACTION_SAVE_FILTER_QUERY . Visualizer_Plugin::VERSION, 'security' );
	1228	+
	1229	+ $chart_id = filter_input(
	1230	+ INPUT_GET,
	1231	+ 'chart',
	1232	+ FILTER_VALIDATE_INT,
	1233	+ array(
	1234	+ 'options' => array(
	1235	+ 'min_range' => 1,
	1236	+ ),
	1237	+ )
	1238	+ );
	1239	+
	1240	+ $hours = $_POST['refresh'];
	1241	+
	1242	+ do_action( 'visualizer_save_filter', $chart_id, $hours );
	1243	+
842	1244	if ( ! ( defined( 'VISUALIZER_DO_NOT_DIE' ) && VISUALIZER_DO_NOT_DIE ) ) {
843	1245	defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
844	1246	}
845	1247	}