PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 2.1.4
Visualizer – Tables & Charts Manager with Built-in AI Generator v2.1.4
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 +143 -151 3.0.72.1.4 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;
@@ -440,14 +393,8 @@
440 393 }
441 394 if ( ! isset( $_POST['vz-import-time'] ) ) {
442 395 apply_filters( 'visualizer_pro_remove_schedule', $chart_id );
443 396 }
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 397 $source = null;
451 398 $render = new Visualizer_Render_Page_Update();
452 399 if ( isset( $_POST['remote_data'] ) && filter_var( $_POST['remote_data'], FILTER_VALIDATE_URL ) ) {
453 400 $source = new Visualizer_Source_Csv_Remote( $_POST['remote_data'] );
@@ -493,15 +440,13 @@
493 440 $chart_id = $success = false;
494 441 $nonce = wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ), Visualizer_Plugin::ACTION_CLONE_CHART );
495 442 $capable = current_user_can( 'edit_posts' );
496 443 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 - );
444 + $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT, array(
445 + 'options' => array(
446 + 'min_range' => 1,
447 + ),
448 + ) );
504 449 if ( $chart_id ) {
505 450 $chart = get_post( $chart_id );
506 451 $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
507 452 }
@@ -507,17 +452,15 @@
507 452 }
508 453 }
509 454 $redirect = wp_get_referer();
510 455 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 - );
456 + $new_chart_id = wp_insert_post( array(
457 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
458 + 'post_title' => 'Visualization',
459 + 'post_author' => get_current_user_id(),
460 + 'post_status' => $chart->post_status,
461 + 'post_content' => $chart->post_content,
462 + ) );
520 463 if ( $new_chart_id && ! is_wp_error( $new_chart_id ) ) {
521 464 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_CHART_TYPE, get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true ) );
522 465 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
523 466 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
@@ -522,14 +465,12 @@
522 465 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
523 466 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
524 467 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SERIES, get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true ) );
525 468 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 - );
469 + $redirect = add_query_arg( array(
470 + 'page' => 'visualizer',
471 + 'type' => filter_input( INPUT_GET, 'type' ),
472 + ), admin_url( 'upload.php' ) );
532 473 }
533 474 }
534 475 wp_redirect( $redirect );
535 476 exit;
@@ -543,25 +484,79 @@
543 484 * @access public
544 485 */
545 486 public function exportData() {
546 487 check_ajax_referer( Visualizer_Plugin::ACTION_EXPORT_DATA . Visualizer_Plugin::VERSION, 'security' );
488 + $chart_id = $success = false;
547 489 $capable = current_user_can( 'edit_posts' );
548 490 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 - ) : '';
491 + $chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT, array(
492 + 'options' => array(
493 + 'min_range' => 1,
494 + ),
495 + ) ) : '';
556 496 if ( $chart_id ) {
557 - $data = $this->_getDataAs( $chart_id, 'csv' );
558 - if ( $data ) {
559 - echo wp_send_json_success( $data );
497 + $chart = get_post( $chart_id );
498 + $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
499 + }
500 + }
501 + if ( $success ) {
502 + $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true );
503 + $filename = isset( $settings['title'] ) ? $settings['title'] : '';
504 + if ( empty( $filename ) ) {
505 + $filename = 'export.csv';
506 + } else {
507 + $filename .= '.csv';
508 + }
509 + $rows = array();
510 + $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true );
511 + $data = unserialize( $chart->post_content );
512 + if ( ! empty( $series ) ) {
513 + $row = array();
514 + foreach ( $series as $array ) {
515 + $row[] = $array['label'];
560 516 }
517 + $rows[] = $row;
518 + $row = array();
519 + foreach ( $series as $array ) {
520 + $row[] = $array['type'];
521 + }
522 + $rows[] = $row;
561 523 }
562 - }
563 -
524 + if ( ! empty( $data ) ) {
525 + foreach ( $data as $array ) {
526 + // ignore strings
527 + if ( ! is_array( $array ) ) {
528 + continue;
529 + }
530 + // if this is an array of arrays...
531 + if ( is_array( $array[0] ) ) {
532 + foreach ( $array as $arr ) {
533 + $rows[] = $arr;
534 + }
535 + } else {
536 + // just an array
537 + $rows[] = $array;
538 + }
539 + }
540 + }
541 + $fp = tmpfile();
542 + foreach ( $rows as $row ) {
543 + fputcsv( $fp, $row );
544 + }
545 + rewind( $fp );
546 + $csv = '';
547 + while ( ( $array = fgetcsv( $fp ) ) !== false ) {
548 + if ( strlen( $csv ) > 0 ) {
549 + $csv .= PHP_EOL;
550 + }
551 + $csv .= implode( ',', $array );
552 + }
553 + fclose( $fp );
554 + echo wp_send_json_success( array(
555 + 'csv' => $csv,
556 + 'name' => $filename,
557 + ) );
558 + }// End if().
564 559 defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
565 560 }
566 561
567 562 /**
@@ -578,19 +573,16 @@
578 573 $render->type = $data['type'];
579 574 unset( $data['settings']['width'], $data['settings']['height'] );
580 575 wp_enqueue_style( 'visualizer-frame' );
581 576 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 - );
577 + wp_localize_script( 'visualizer-render', 'visualizer', array(
578 + 'l10n' => array(
579 + 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
580 + ),
581 + 'charts' => array(
582 + 'canvas' => $data,
583 + ),
584 + ) );
593 585 // Added by Ash/Upwork
594 586 if ( VISUALIZER_PRO ) {
595 587 global $Visualizer_Pro;
596 588 $Visualizer_Pro->_enqueueScriptsAndStyles( $data );