← All changes | classes/Visualizer/Module/Chart.php +144 -151 3.0.7 → 2.1.1 View file →

		@@ -72,23 +72,16 @@
72	72	public function getCharts() {
73	73	$query_args = array(
74	74	'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
75	75	'posts_per_page' => 9,
76		- 'paged' => filter_input(
77		- INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
78		- 'options' => array(
79		- 'min_range' => 1,
80		- 'default' => 1,
81		- ),
82		- )
83		- ),
	76	+ 'paged' => filter_input( INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
	77	+ 'options' => array(
	78	+ 'min_range' => 1,
	79	+ 'default' => 1,
	80	+ ),
	81	+ ) ),
84	82	);
85	83	$filter = filter_input( INPUT_GET, 's', FILTER_SANITIZE_STRING );
86		- if ( empty( $filter ) ) {
87		- // 'filter' is from the modal from the add media button.
88		- $filter = filter_input( INPUT_GET, 'filter', FILTER_SANITIZE_STRING );
89		- }
90		-
91	84	if ( $filter && in_array( $filter, Visualizer_Plugin::getChartTypes() ) ) {
92	85	$query_args['meta_query'] = array(
93	86	array(
94	87	'key' => Visualizer_Plugin::CF_CHART_TYPE,
		@@ -104,15 +97,13 @@
104	97	$chart_data = $this->_getChartArray( $chart );
105	98	$chart_data['id'] = $chart->ID;
106	99	$charts[] = $chart_data;
107	100	}
108		- self::_sendResponse(
109		- array(
110		- 'success' => true,
111		- 'data' => $charts,
112		- 'total' => $query->max_num_pages,
113		- )
114		- );
	101	+ self::_sendResponse( array(
	102	+ 'success' => true,
	103	+ 'data' => $charts,
	104	+ 'total' => $query->max_num_pages,
	105	+ ) );
115	106	}
116	107
117	108	/**
118	109	* Returns chart data required for rendering.
		@@ -171,15 +162,13 @@
171	162	$chart_id = $success = false;
172	163	$nonce = wp_verify_nonce( filter_input( $input_method, 'nonce' ) );
173	164	$capable = current_user_can( 'delete_posts' );
174	165	if ( $nonce && $capable ) {
175		- $chart_id = filter_input(
176		- $input_method, 'chart', FILTER_VALIDATE_INT, array(
177		- 'options' => array(
178		- 'min_range' => 1,
179		- ),
180		- )
181		- );
	166	+ $chart_id = filter_input( $input_method, 'chart', FILTER_VALIDATE_INT, array(
	167	+ 'options' => array(
	168	+ 'min_range' => 1,
	169	+ ),
	170	+ ) );
182	171	if ( $chart_id ) {
183	172	$chart = get_post( $chart_id );
184	173	$success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
185	174	}
		@@ -187,13 +176,11 @@
187	176	if ( $success ) {
188	177	wp_delete_post( $chart_id, true );
189	178	}
190	179	if ( $is_post ) {
191		- self::_sendResponse(
192		- array(
193		- 'success' => $success,
194		- )
195		- );
	180	+ self::_sendResponse( array(
	181	+ 'success' => $success,
	182	+ ) );
196	183	}
197	184	wp_redirect( wp_get_referer() );
198	185	exit;
199	186	}
		@@ -213,53 +200,41 @@
213	200	if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type != Visualizer_Plugin::CPT_VISUALIZER ) {
214	201	$default_type = 'line';
215	202	$source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $default_type . '.csv' );
216	203	$source->fetch();
217		- $chart_id = wp_insert_post(
218		- array(
219		- 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
220		- 'post_title' => 'Visualization',
221		- 'post_author' => get_current_user_id(),
222		- 'post_status' => 'auto-draft',
223		- 'post_content' => $source->getData(),
224		- )
225		- );
	204	+ $chart_id = wp_insert_post( array(
	205	+ 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
	206	+ 'post_title' => 'Visualization',
	207	+ 'post_author' => get_current_user_id(),
	208	+ 'post_status' => 'auto-draft',
	209	+ 'post_content' => $source->getData(),
	210	+ ) );
226	211	if ( $chart_id && ! is_wp_error( $chart_id ) ) {
227	212	add_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, $default_type );
228	213	add_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, 1 );
229	214	add_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, $source->getSourceName() );
230	215	add_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
231		- add_post_meta(
232		- $chart_id, Visualizer_Plugin::CF_SETTINGS, array(
233		- 'focusTarget' => 'datum',
234		- )
235		- );
236		- do_action( 'visualizer_pro_new_chart_defaults', $chart_id );
	216	+ add_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, array(
	217	+ 'focusTarget' => 'datum',
	218	+ ) );
237	219	}
238	220	wp_redirect( add_query_arg( 'chart', (int) $chart_id ) );
239	221	defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
240	222	}
241	223	// enqueue and register scripts and styles
242		- wp_register_script( 'visualizer-chosen', VISUALIZER_ABSURL . 'js/lib/chosen.jquery.min.js', array( 'jquery' ), Visualizer_Plugin::VERSION );
243		- wp_register_style( 'visualizer-chosen', VISUALIZER_ABSURL . 'css/lib/chosen.min.css', array(), Visualizer_Plugin::VERSION );
244		-
245		- wp_register_style( 'visualizer-frame', VISUALIZER_ABSURL . 'css/frame.css', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION );
246		- wp_register_script( 'visualizer-frame', VISUALIZER_ABSURL . 'js/frame.js', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION, true );
	224	+ wp_register_style( 'visualizer-frame', VISUALIZER_ABSURL . 'css/frame.css', array(), Visualizer_Plugin::VERSION );
	225	+ wp_register_script( 'visualizer-frame', VISUALIZER_ABSURL . 'js/frame.js', array( 'jquery' ), Visualizer_Plugin::VERSION, true );
247	226	wp_register_script( 'google-jsapi-new', '//www.gstatic.com/charts/loader.js', array(), null, true );
248	227	wp_register_script( 'google-jsapi-old', '//www.google.com/jsapi', array( 'google-jsapi-new' ), null, true );
249		- wp_register_script(
250		- 'visualizer-render', VISUALIZER_ABSURL . 'js/render.js', array(
251		- 'google-jsapi-old',
252		- 'google-jsapi-new',
253		- 'visualizer-frame',
254		- ), Visualizer_Plugin::VERSION, true
255		- );
256		- wp_register_script(
257		- 'visualizer-preview', VISUALIZER_ABSURL . 'js/preview.js', array(
258		- 'wp-color-picker',
259		- 'visualizer-render',
260		- ), Visualizer_Plugin::VERSION, true
261		- );
	228	+ wp_register_script( 'visualizer-render', VISUALIZER_ABSURL . 'js/render.js', array(
	229	+ 'google-jsapi-old',
	230	+ 'google-jsapi-new',
	231	+ 'visualizer-frame',
	232	+ ), Visualizer_Plugin::VERSION, true );
	233	+ wp_register_script( 'visualizer-preview', VISUALIZER_ABSURL . 'js/preview.js', array(
	234	+ 'wp-color-picker',
	235	+ 'visualizer-render',
	236	+ ), Visualizer_Plugin::VERSION, true );
262	237	// added by Ash/Upwork
263	238	if ( VISUALIZER_PRO ) {
264	239	global $Visualizer_Pro;
265	240	$Visualizer_Pro->_addScriptsAndStyles();
		@@ -265,26 +240,17 @@
265	240	$Visualizer_Pro->_addScriptsAndStyles();
266	241	}
267	242	// dispatch pages
268	243	$this->_chart = get_post( $chart_id );
269		- $tab = isset( $_GET['tab'] ) && ! empty( $_GET['tab'] ) ? $_GET['tab'] : 'visualizer';
270		-
271		- // skip chart type pages only for existing charts.
272		- if ( VISUALIZER_SKIP_CHART_TYPE_PAGE && 'auto-draft' !== $this->_chart->post_status ) {
273		- $tab = 'settings';
274		- }
275		-
276		- switch ( $tab ) {
	244	+ switch ( isset( $_GET['tab'] ) ? $_GET['tab'] : '' ) {
277	245	case 'settings':
	246	+ // changed by Ash/Upwork
278	247	$this->_handleDataAndSettingsPage();
279	248	break;
280		- case 'type': // fall through.
281		- case 'visualizer': // fall through.
	249	+ case 'type':
	250	+ default:
282	251	$this->_handleTypesPage();
283	252	break;
284		- default:
285		- do_action( 'visualizer_pro_handle_tab', $tab, $this->_chart );
286		- break;
287	253	}
288	254	defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
289	255	}
290	256
		@@ -326,30 +292,17 @@
326	292	wp_enqueue_style( 'wp-color-picker' );
327	293	wp_enqueue_style( 'visualizer-frame' );
328	294	wp_enqueue_script( 'visualizer-preview' );
329	295	wp_enqueue_script( 'visualizer-render' );
330		- wp_localize_script(
331		- 'visualizer-render', 'visualizer', array(
332		- 'l10n' => array(
333		- 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
334		- 'loading' => esc_html__( 'Loading...', 'visualizer' ),
335		- ),
336		- 'charts' => array(
337		- 'canvas' => $data,
338		- ),
339		- 'language' => $this->get_language(),
340		- 'map_api_key' => get_option( 'visualizer-map-api-key' ),
341		- 'ajax' => array(
342		- 'url' => admin_url( 'admin-ajax.php' ),
343		- 'nonces' => array(
344		- 'permissions' => wp_create_nonce( Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA ),
345		- ),
346		- 'actions' => array(
347		- 'permissions' => Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA,
348		- ),
349		- ),
350		- )
351		- );
	296	+ wp_localize_script( 'visualizer-render', 'visualizer', array(
	297	+ 'l10n' => array(
	298	+ 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
	299	+ ),
	300	+ 'charts' => array(
	301	+ 'canvas' => $data,
	302	+ ),
	303	+ 'map_api_key' => get_option( 'visualizer-map-api-key' ),
	304	+ ) );
352	305	$render = new Visualizer_Render_Page_Data();
353	306	$render->chart = $this->_chart;
354	307	$render->type = $data['type'];
355	308	$render->sidebar = $sidebar;
		@@ -425,8 +378,9 @@
425	378	*
426	379	* @access public
427	380	*/
428	381	public function uploadData() {
	382	+ error_log( 'in uploadData ' . print_r( $_GET,true ) . print_r( $_POST,true ) );
429	383	// validate nonce
430	384	// do not use filter_input as it does not work for phpunit test cases, use filter_var instead
431	385	if ( ! isset( $_GET['nonce'] ) || ! wp_verify_nonce( $_GET['nonce'] ) ) {
432	386	status_header( 403 );
		@@ -440,14 +394,8 @@
440	394	}
441	395	if ( ! isset( $_POST['vz-import-time'] ) ) {
442	396	apply_filters( 'visualizer_pro_remove_schedule', $chart_id );
443	397	}
444		-
445		- if ( ! isset( $_POST['chart_data_src'] ) || Visualizer_Plugin::CF_SOURCE_FILTER !== $_POST['chart_data_src'] ) {
446		- // delete the filters in case this chart is being uploaded from other data sources
447		- delete_post_meta( $chart_id, 'visualizer-filter-config' );
448		- }
449		-
450	398	$source = null;
451	399	$render = new Visualizer_Render_Page_Update();
452	400	if ( isset( $_POST['remote_data'] ) && filter_var( $_POST['remote_data'], FILTER_VALIDATE_URL ) ) {
453	401	$source = new Visualizer_Source_Csv_Remote( $_POST['remote_data'] );
		@@ -493,15 +441,13 @@
493	441	$chart_id = $success = false;
494	442	$nonce = wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ), Visualizer_Plugin::ACTION_CLONE_CHART );
495	443	$capable = current_user_can( 'edit_posts' );
496	444	if ( $nonce && $capable ) {
497		- $chart_id = filter_input(
498		- INPUT_GET, 'chart', FILTER_VALIDATE_INT, array(
499		- 'options' => array(
500		- 'min_range' => 1,
501		- ),
502		- )
503		- );
	445	+ $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT, array(
	446	+ 'options' => array(
	447	+ 'min_range' => 1,
	448	+ ),
	449	+ ) );
504	450	if ( $chart_id ) {
505	451	$chart = get_post( $chart_id );
506	452	$success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
507	453	}
		@@ -507,17 +453,15 @@
507	453	}
508	454	}
509	455	$redirect = wp_get_referer();
510	456	if ( $success ) {
511		- $new_chart_id = wp_insert_post(
512		- array(
513		- 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
514		- 'post_title' => 'Visualization',
515		- 'post_author' => get_current_user_id(),
516		- 'post_status' => $chart->post_status,
517		- 'post_content' => $chart->post_content,
518		- )
519		- );
	457	+ $new_chart_id = wp_insert_post( array(
	458	+ 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
	459	+ 'post_title' => 'Visualization',
	460	+ 'post_author' => get_current_user_id(),
	461	+ 'post_status' => $chart->post_status,
	462	+ 'post_content' => $chart->post_content,
	463	+ ) );
520	464	if ( $new_chart_id && ! is_wp_error( $new_chart_id ) ) {
521	465	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_CHART_TYPE, get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true ) );
522	466	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
523	467	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
		@@ -522,14 +466,12 @@
522	466	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
523	467	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
524	468	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SERIES, get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true ) );
525	469	add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SETTINGS, get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true ) );
526		- $redirect = add_query_arg(
527		- array(
528		- 'page' => 'visualizer',
529		- 'type' => filter_input( INPUT_GET, 'type' ),
530		- ), admin_url( 'upload.php' )
531		- );
	470	+ $redirect = add_query_arg( array(
	471	+ 'page' => 'visualizer',
	472	+ 'type' => filter_input( INPUT_GET, 'type' ),
	473	+ ), admin_url( 'upload.php' ) );
532	474	}
533	475	}
534	476	wp_redirect( $redirect );
535	477	exit;
		@@ -543,25 +485,79 @@
543	485	* @access public
544	486	*/
545	487	public function exportData() {
546	488	check_ajax_referer( Visualizer_Plugin::ACTION_EXPORT_DATA . Visualizer_Plugin::VERSION, 'security' );
	489	+ $chart_id = $success = false;
547	490	$capable = current_user_can( 'edit_posts' );
548	491	if ( $capable ) {
549		- $chart_id = isset( $_GET['chart'] ) ? filter_var(
550		- $_GET['chart'], FILTER_VALIDATE_INT, array(
551		- 'options' => array(
552		- 'min_range' => 1,
553		- ),
554		- )
555		- ) : '';
	492	+ $chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT, array(
	493	+ 'options' => array(
	494	+ 'min_range' => 1,
	495	+ ),
	496	+ ) ) : '';
556	497	if ( $chart_id ) {
557		- $data = $this->_getDataAs( $chart_id, 'csv' );
558		- if ( $data ) {
559		- echo wp_send_json_success( $data );
	498	+ $chart = get_post( $chart_id );
	499	+ $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
	500	+ }
	501	+ }
	502	+ if ( $success ) {
	503	+ $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true );
	504	+ $filename = isset( $settings['title'] ) ? $settings['title'] : '';
	505	+ if ( empty( $filename ) ) {
	506	+ $filename = 'export.csv';
	507	+ } else {
	508	+ $filename .= '.csv';
	509	+ }
	510	+ $rows = array();
	511	+ $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true );
	512	+ $data = unserialize( $chart->post_content );
	513	+ if ( ! empty( $series ) ) {
	514	+ $row = array();
	515	+ foreach ( $series as $array ) {
	516	+ $row[] = $array['label'];
560	517	}
	518	+ $rows[] = $row;
	519	+ $row = array();
	520	+ foreach ( $series as $array ) {
	521	+ $row[] = $array['type'];
	522	+ }
	523	+ $rows[] = $row;
561	524	}
562		- }
563		-
	525	+ if ( ! empty( $data ) ) {
	526	+ foreach ( $data as $array ) {
	527	+ // ignore strings
	528	+ if ( ! is_array( $array ) ) {
	529	+ continue;
	530	+ }
	531	+ // if this is an array of arrays...
	532	+ if ( is_array( $array[0] ) ) {
	533	+ foreach ( $array as $arr ) {
	534	+ $rows[] = $arr;
	535	+ }
	536	+ } else {
	537	+ // just an array
	538	+ $rows[] = $array;
	539	+ }
	540	+ }
	541	+ }
	542	+ $fp = tmpfile();
	543	+ foreach ( $rows as $row ) {
	544	+ fputcsv( $fp, $row );
	545	+ }
	546	+ rewind( $fp );
	547	+ $csv = '';
	548	+ while ( ( $array = fgetcsv( $fp ) ) !== false ) {
	549	+ if ( strlen( $csv ) > 0 ) {
	550	+ $csv .= PHP_EOL;
	551	+ }
	552	+ $csv .= implode( ',', $array );
	553	+ }
	554	+ fclose( $fp );
	555	+ echo wp_send_json_success( array(
	556	+ 'csv' => $csv,
	557	+ 'name' => $filename,
	558	+ ) );
	559	+ }// End if().
564	560	defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
565	561	}
566	562
567	563	/**
		@@ -578,19 +574,16 @@
578	574	$render->type = $data['type'];
579	575	unset( $data['settings']['width'], $data['settings']['height'] );
580	576	wp_enqueue_style( 'visualizer-frame' );
581	577	wp_enqueue_script( 'visualizer-render' );
582		- wp_localize_script(
583		- 'visualizer-render', 'visualizer', array(
584		- 'l10n' => array(
585		- 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
586		- 'loading' => esc_html__( 'Loading...', 'visualizer' ),
587		- ),
588		- 'charts' => array(
589		- 'canvas' => $data,
590		- ),
591		- )
592		- );
	578	+ wp_localize_script( 'visualizer-render', 'visualizer', array(
	579	+ 'l10n' => array(
	580	+ 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
	581	+ ),
	582	+ 'charts' => array(
	583	+ 'canvas' => $data,
	584	+ ),
	585	+ ) );
593	586	// Added by Ash/Upwork
594	587	if ( VISUALIZER_PRO ) {
595	588	global $Visualizer_Pro;
596	589	$Visualizer_Pro->_enqueueScriptsAndStyles( $data );