PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 2.0.3
Visualizer – Tables & Charts Manager with Built-in AI Generator v2.0.3
4.0.7 4.0.6 4.0.5 4.0.4 4.0.3 3.0.5 3.0.6 3.0.7 3.0.8 3.0.9 3.1.0 3.1.1 3.1.2 3.1.3 3.10.0 3.10.1 3.10.10 3.10.11 3.10.12 3.10.13 3.10.14 3.10.15 3.10.2 3.10.3 3.10.4 All 148 releases
← All changes | classes/Visualizer/Module/Chart.php +142 -145 3.0.52.0.3 View file →
@@ -72,16 +72,14 @@
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 84 if ( $filter && in_array( $filter, Visualizer_Plugin::getChartTypes() ) ) {
87 85 $query_args['meta_query'] = array(
@@ -99,15 +97,13 @@
99 97 $chart_data = $this->_getChartArray( $chart );
100 98 $chart_data['id'] = $chart->ID;
101 99 $charts[] = $chart_data;
102 100 }
103 - self::_sendResponse(
104 - array(
105 - 'success' => true,
106 - 'data' => $charts,
107 - 'total' => $query->max_num_pages,
108 - )
109 - );
101 + self::_sendResponse( array(
102 + 'success' => true,
103 + 'data' => $charts,
104 + 'total' => $query->max_num_pages,
105 + ) );
110 106 }
111 107
112 108 /**
113 109 * Returns chart data required for rendering.
@@ -166,15 +162,13 @@
166 162 $chart_id = $success = false;
167 163 $nonce = wp_verify_nonce( filter_input( $input_method, 'nonce' ) );
168 164 $capable = current_user_can( 'delete_posts' );
169 165 if ( $nonce && $capable ) {
170 - $chart_id = filter_input(
171 - $input_method, 'chart', FILTER_VALIDATE_INT, array(
172 - 'options' => array(
173 - 'min_range' => 1,
174 - ),
175 - )
176 - );
166 + $chart_id = filter_input( $input_method, 'chart', FILTER_VALIDATE_INT, array(
167 + 'options' => array(
168 + 'min_range' => 1,
169 + ),
170 + ) );
177 171 if ( $chart_id ) {
178 172 $chart = get_post( $chart_id );
179 173 $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
180 174 }
@@ -182,13 +176,11 @@
182 176 if ( $success ) {
183 177 wp_delete_post( $chart_id, true );
184 178 }
185 179 if ( $is_post ) {
186 - self::_sendResponse(
187 - array(
188 - 'success' => $success,
189 - )
190 - );
180 + self::_sendResponse( array(
181 + 'success' => $success,
182 + ) );
191 183 }
192 184 wp_redirect( wp_get_referer() );
193 185 exit;
194 186 }
@@ -208,53 +200,41 @@
208 200 if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type != Visualizer_Plugin::CPT_VISUALIZER ) {
209 201 $default_type = 'line';
210 202 $source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $default_type . '.csv' );
211 203 $source->fetch();
212 - $chart_id = wp_insert_post(
213 - array(
214 - 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
215 - 'post_title' => 'Visualization',
216 - 'post_author' => get_current_user_id(),
217 - 'post_status' => 'auto-draft',
218 - 'post_content' => $source->getData(),
219 - )
220 - );
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 + ) );
221 211 if ( $chart_id && ! is_wp_error( $chart_id ) ) {
222 212 add_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, $default_type );
223 213 add_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, 1 );
224 214 add_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, $source->getSourceName() );
225 215 add_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
226 - add_post_meta(
227 - $chart_id, Visualizer_Plugin::CF_SETTINGS, array(
228 - 'focusTarget' => 'datum',
229 - )
230 - );
231 - do_action( 'visualizer_pro_new_chart_defaults', $chart_id );
216 + add_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, array(
217 + 'focusTarget' => 'datum',
218 + ) );
232 219 }
233 220 wp_redirect( add_query_arg( 'chart', (int) $chart_id ) );
234 221 defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
235 222 }
236 223 // enqueue and register scripts and styles
237 - wp_register_script( 'visualizer-chosen', VISUALIZER_ABSURL . 'js/lib/chosen.jquery.min.js', array( 'jquery' ), Visualizer_Plugin::VERSION );
238 - wp_register_style( 'visualizer-chosen', VISUALIZER_ABSURL . 'css/lib/chosen.min.css', array(), Visualizer_Plugin::VERSION );
239 -
240 - wp_register_style( 'visualizer-frame', VISUALIZER_ABSURL . 'css/frame.css', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION );
241 - 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 );
242 226 wp_register_script( 'google-jsapi-new', '//www.gstatic.com/charts/loader.js', array(), null, true );
243 227 wp_register_script( 'google-jsapi-old', '//www.google.com/jsapi', array( 'google-jsapi-new' ), null, true );
244 - wp_register_script(
245 - 'visualizer-render', VISUALIZER_ABSURL . 'js/render.js', array(
246 - 'google-jsapi-old',
247 - 'google-jsapi-new',
248 - 'visualizer-frame',
249 - ), Visualizer_Plugin::VERSION, true
250 - );
251 - wp_register_script(
252 - 'visualizer-preview', VISUALIZER_ABSURL . 'js/preview.js', array(
253 - 'wp-color-picker',
254 - 'visualizer-render',
255 - ), Visualizer_Plugin::VERSION, true
256 - );
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 );
257 237 // added by Ash/Upwork
258 238 if ( VISUALIZER_PRO ) {
259 239 global $Visualizer_Pro;
260 240 $Visualizer_Pro->_addScriptsAndStyles();
@@ -260,21 +240,17 @@
260 240 $Visualizer_Pro->_addScriptsAndStyles();
261 241 }
262 242 // dispatch pages
263 243 $this->_chart = get_post( $chart_id );
264 - $tab = isset( $_GET['tab'] ) && ! empty( $_GET['tab'] ) ? $_GET['tab'] : 'visualizer';
265 - switch ( $tab ) {
244 + switch ( isset( $_GET['tab'] ) ? $_GET['tab'] : '' ) {
266 245 case 'settings':
267 246 // changed by Ash/Upwork
268 247 $this->_handleDataAndSettingsPage();
269 248 break;
270 - case 'type': // fall through.
271 - case 'visualizer': // fall through.
249 + case 'type':
250 + default:
272 251 $this->_handleTypesPage();
273 252 break;
274 - default:
275 - do_action( 'visualizer_pro_handle_tab', $tab, $this->_chart );
276 - break;
277 253 }
278 254 defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
279 255 }
280 256
@@ -281,11 +257,8 @@
281 257 /**
282 258 * Handle data and settings page
283 259 */
284 260 private function _handleDataAndSettingsPage() {
285 - if ( isset( $_POST['map_api_key'] ) ) {
286 - update_option( 'visualizer-map-api-key', $_POST['map_api_key'] );
287 - }
288 261 if ( $_SERVER['REQUEST_METHOD'] == 'POST' && isset( $_GET['nonce'] ) && wp_verify_nonce( $_GET['nonce'] ) ) {
289 262 if ( $this->_chart->post_status == 'auto-draft' ) {
290 263 $this->_chart->post_status = 'publish';
291 264 wp_update_post( $this->_chart->to_array() );
@@ -316,29 +289,16 @@
316 289 wp_enqueue_style( 'wp-color-picker' );
317 290 wp_enqueue_style( 'visualizer-frame' );
318 291 wp_enqueue_script( 'visualizer-preview' );
319 292 wp_enqueue_script( 'visualizer-render' );
320 - wp_localize_script(
321 - 'visualizer-render', 'visualizer', array(
322 - 'l10n' => array(
323 - 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
324 - 'loading' => esc_html__( 'Loading...', 'visualizer' ),
325 - ),
326 - 'charts' => array(
327 - 'canvas' => $data,
328 - ),
329 - 'map_api_key' => get_option( 'visualizer-map-api-key' ),
330 - 'ajax' => array(
331 - 'url' => admin_url( 'admin-ajax.php' ),
332 - 'nonces' => array(
333 - 'permissions' => wp_create_nonce( Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA ),
334 - ),
335 - 'actions' => array(
336 - 'permissions' => Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA,
337 - ),
338 - ),
339 - )
340 - );
293 + wp_localize_script( 'visualizer-render', 'visualizer', array(
294 + 'l10n' => array(
295 + 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
296 + ),
297 + 'charts' => array(
298 + 'canvas' => $data,
299 + ),
300 + ) );
341 301 $render = new Visualizer_Render_Page_Data();
342 302 $render->chart = $this->_chart;
343 303 $render->type = $data['type'];
344 304 $render->sidebar = $sidebar;
@@ -429,14 +389,8 @@
429 389 }
430 390 if ( ! isset( $_POST['vz-import-time'] ) ) {
431 391 apply_filters( 'visualizer_pro_remove_schedule', $chart_id );
432 392 }
433 -
434 - if ( ! isset( $_POST['chart_data_src'] ) || Visualizer_Plugin::CF_SOURCE_FILTER !== $_POST['chart_data_src'] ) {
435 - // delete the filters in case this chart is being uploaded from other data sources
436 - delete_post_meta( $chart_id, 'visualizer-filter-config' );
437 - }
438 -
439 393 $source = null;
440 394 $render = new Visualizer_Render_Page_Update();
441 395 if ( isset( $_POST['remote_data'] ) && filter_var( $_POST['remote_data'], FILTER_VALIDATE_URL ) ) {
442 396 $source = new Visualizer_Source_Csv_Remote( $_POST['remote_data'] );
@@ -465,11 +419,9 @@
465 419 $render->message = esc_html__( 'CSV file is broken or invalid. Please, try again.', 'visualizer' );
466 420 }
467 421 }
468 422 $render->render();
469 - if ( ! ( defined( 'VISUALIZER_DO_NOT_DIE' ) && VISUALIZER_DO_NOT_DIE ) ) {
470 - defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
471 - }
423 + defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
472 424 }
473 425
474 426 /**
475 427 * Clones the chart.
@@ -482,15 +434,13 @@
482 434 $chart_id = $success = false;
483 435 $nonce = wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ), Visualizer_Plugin::ACTION_CLONE_CHART );
484 436 $capable = current_user_can( 'edit_posts' );
485 437 if ( $nonce && $capable ) {
486 - $chart_id = filter_input(
487 - INPUT_GET, 'chart', FILTER_VALIDATE_INT, array(
488 - 'options' => array(
489 - 'min_range' => 1,
490 - ),
491 - )
492 - );
438 + $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT, array(
439 + 'options' => array(
440 + 'min_range' => 1,
441 + ),
442 + ) );
493 443 if ( $chart_id ) {
494 444 $chart = get_post( $chart_id );
495 445 $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
496 446 }
@@ -496,17 +446,15 @@
496 446 }
497 447 }
498 448 $redirect = wp_get_referer();
499 449 if ( $success ) {
500 - $new_chart_id = wp_insert_post(
501 - array(
502 - 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
503 - 'post_title' => 'Visualization',
504 - 'post_author' => get_current_user_id(),
505 - 'post_status' => $chart->post_status,
506 - 'post_content' => $chart->post_content,
507 - )
508 - );
450 + $new_chart_id = wp_insert_post( array(
451 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
452 + 'post_title' => 'Visualization',
453 + 'post_author' => get_current_user_id(),
454 + 'post_status' => $chart->post_status,
455 + 'post_content' => $chart->post_content,
456 + ) );
509 457 if ( $new_chart_id && ! is_wp_error( $new_chart_id ) ) {
510 458 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_CHART_TYPE, get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true ) );
511 459 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
512 460 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
@@ -511,14 +459,12 @@
511 459 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
512 460 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
513 461 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SERIES, get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true ) );
514 462 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SETTINGS, get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true ) );
515 - $redirect = add_query_arg(
516 - array(
517 - 'page' => 'visualizer',
518 - 'type' => filter_input( INPUT_GET, 'type' ),
519 - ), admin_url( 'upload.php' )
520 - );
463 + $redirect = add_query_arg( array(
464 + 'page' => 'visualizer',
465 + 'type' => filter_input( INPUT_GET, 'type' ),
466 + ), admin_url( 'upload.php' ) );
521 467 }
522 468 }
523 469 wp_redirect( $redirect );
524 470 exit;
@@ -532,25 +478,79 @@
532 478 * @access public
533 479 */
534 480 public function exportData() {
535 481 check_ajax_referer( Visualizer_Plugin::ACTION_EXPORT_DATA . Visualizer_Plugin::VERSION, 'security' );
482 + $chart_id = $success = false;
536 483 $capable = current_user_can( 'edit_posts' );
537 484 if ( $capable ) {
538 - $chart_id = isset( $_GET['chart'] ) ? filter_var(
539 - $_GET['chart'], FILTER_VALIDATE_INT, array(
540 - 'options' => array(
541 - 'min_range' => 1,
542 - ),
543 - )
544 - ) : '';
485 + $chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT, array(
486 + 'options' => array(
487 + 'min_range' => 1,
488 + ),
489 + ) ) : '';
545 490 if ( $chart_id ) {
546 - $data = $this->_getDataAs( $chart_id, 'csv' );
547 - if ( $data ) {
548 - echo wp_send_json_success( $data );
491 + $chart = get_post( $chart_id );
492 + $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
493 + }
494 + }
495 + if ( $success ) {
496 + $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true );
497 + $filename = isset( $settings['title'] ) ? $settings['title'] : '';
498 + if ( empty( $filename ) ) {
499 + $filename = 'export.csv';
500 + } else {
501 + $filename .= '.csv';
502 + }
503 + $rows = array();
504 + $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true );
505 + $data = unserialize( $chart->post_content );
506 + if ( ! empty( $series ) ) {
507 + $row = array();
508 + foreach ( $series as $array ) {
509 + $row[] = $array['label'];
549 510 }
511 + $rows[] = $row;
512 + $row = array();
513 + foreach ( $series as $array ) {
514 + $row[] = $array['type'];
515 + }
516 + $rows[] = $row;
550 517 }
551 - }
552 -
518 + if ( ! empty( $data ) ) {
519 + foreach ( $data as $array ) {
520 + // ignore strings
521 + if ( ! is_array( $array ) ) {
522 + continue;
523 + }
524 + // if this is an array of arrays...
525 + if ( is_array( $array[0] ) ) {
526 + foreach ( $array as $arr ) {
527 + $rows[] = $arr;
528 + }
529 + } else {
530 + // just an array
531 + $rows[] = $array;
532 + }
533 + }
534 + }
535 + $fp = tmpfile();
536 + foreach ( $rows as $row ) {
537 + fputcsv( $fp, $row );
538 + }
539 + rewind( $fp );
540 + $csv = '';
541 + while ( ( $array = fgetcsv( $fp ) ) !== false ) {
542 + if ( strlen( $csv ) > 0 ) {
543 + $csv .= PHP_EOL;
544 + }
545 + $csv .= implode( ',', $array );
546 + }
547 + fclose( $fp );
548 + echo wp_send_json_success( array(
549 + 'csv' => $csv,
550 + 'name' => $filename,
551 + ) );
552 + }// End if().
553 553 defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
554 554 }
555 555
556 556 /**
@@ -567,19 +567,16 @@
567 567 $render->type = $data['type'];
568 568 unset( $data['settings']['width'], $data['settings']['height'] );
569 569 wp_enqueue_style( 'visualizer-frame' );
570 570 wp_enqueue_script( 'visualizer-render' );
571 - wp_localize_script(
572 - 'visualizer-render', 'visualizer', array(
573 - 'l10n' => array(
574 - 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
575 - 'loading' => esc_html__( 'Loading...', 'visualizer' ),
576 - ),
577 - 'charts' => array(
578 - 'canvas' => $data,
579 - ),
580 - )
581 - );
571 + wp_localize_script( 'visualizer-render', 'visualizer', array(
572 + 'l10n' => array(
573 + 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
574 + ),
575 + 'charts' => array(
576 + 'canvas' => $data,
577 + ),
578 + ) );
582 579 // Added by Ash/Upwork
583 580 if ( VISUALIZER_PRO ) {
584 581 global $Visualizer_Pro;
585 582 $Visualizer_Pro->_enqueueScriptsAndStyles( $data );