PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 3.5.0
Visualizer – Tables & Charts Manager with Built-in AI Generator v3.5.0
4.0.8 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 All 149 releases
← All changes | classes/Visualizer/Module.php +432 -13 3.0.73.5.0 View file →
@@ -62,11 +62,31 @@
62 62 global $wpdb;
63 63
64 64 $this->_wpdb = $wpdb;
65 65 $this->_plugin = $plugin;
66 +
67 + $this->_addFilter( Visualizer_Plugin::FILTER_UNDO_REVISIONS, 'undoRevisions', 10, 2 );
68 + $this->_addFilter( Visualizer_Plugin::FILTER_HANDLE_REVISIONS, 'handleExistingRevisions', 10, 2 );
69 + $this->_addFilter( Visualizer_Plugin::FILTER_GET_CHART_DATA_AS, 'getDataAs', 10, 3 );
70 + register_shutdown_function( array($this, 'onShutdown') );
71 +
66 72 }
67 73
68 74 /**
75 + * Register a shutdown hook to catch fatal errors.
76 + *
77 + * @since ?
78 + *
79 + * @access public
80 + */
81 + public function onShutdown() {
82 + $error = error_get_last();
83 + if ( $error && $error['type'] === E_ERROR && false !== strpos( $error['file'], 'Visualizer/' ) ) {
84 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Critical error %s', print_r( $error, true ) ), 'error', __FILE__, __LINE__ );
85 + }
86 + }
87 +
88 + /**
69 89 * Registers an action hook.
70 90 *
71 91 * @since 1.0.0
72 92 * @uses add_action() To register action hook.
@@ -143,8 +163,17 @@
143 163 return $this;
144 164 }
145 165
146 166 /**
167 + * A wrapper around the actual function _getDataAs. This function is invoked as a filter.
168 + *
169 + * @since 3.2.0
170 + */
171 + public function getDataAs( $final, $chart_id, $type ) {
172 + return $this->_getDataAs( $chart_id, $type );
173 + }
174 +
175 + /**
147 176 * Extracts the data for a chart and prepares it for the given type.
148 177 *
149 178 * @access public
150 179 * @param int $chart_id The chart id.
@@ -154,15 +183,15 @@
154 183 $final = null;
155 184 $success = false;
156 185 if ( $chart_id ) {
157 186 $chart = get_post( $chart_id );
158 - $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
187 + $success = $chart && $chart->post_type === Visualizer_Plugin::CPT_VISUALIZER;
159 188 }
160 189 if ( $success ) {
161 190 $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true );
162 191 $rows = array();
163 192 $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true );
164 - $data = unserialize( $chart->post_content );
193 + $data = self::get_chart_data( $chart, $type, false );
165 194 if ( ! empty( $series ) ) {
166 195 $row = array();
167 196 foreach ( $series as $array ) {
168 197 $row[] = $array['label'];
@@ -191,14 +220,29 @@
191 220 }
192 221 }
193 222 }
194 223
195 - $filename = isset( $settings['title'] ) && ! empty( $settings['title'] ) ? $settings['title'] : 'visualizer#' . $chart_id;
224 + $title = 'visualizer#' . $chart_id;
225 + if ( ! empty( $settings['title'] ) ) {
226 + $title = $settings['title'];
227 + }
228 + // for ChartJS, title is an array.
229 + if ( is_array( $title ) && isset( $title['text'] ) ) {
230 + $title = $title['text'];
231 + }
232 + if ( empty( $title ) ) {
233 + $title = 'visualizer#' . $chart_id;
234 + }
196 235
236 + $filename = $title;
237 +
197 238 switch ( $type ) {
198 239 case 'csv':
199 - $final = $this->_getCSV( $rows, $filename );
240 + $final = $this->_getCSV( $rows, $filename, false );
200 241 break;
242 + case 'csv-display':
243 + $final = $this->_getCSV( $rows, $filename, true );
244 + break;
201 245 case 'xls':
202 246 $final = $this->_getExcel( $rows, $filename );
203 247 break;
204 248 case 'print':
@@ -214,24 +258,43 @@
214 258 *
215 259 * @access private
216 260 * @param array $rows The array of data.
217 261 * @param string $filename The name of the file to use.
262 + * @param bool $enclose Enclose strings that have commas in them in double quotes.
218 263 */
219 - private function _getCSV( $rows, $filename ) {
264 + private function _getCSV( $rows, $filename, $enclose ) {
220 265 $filename .= '.csv';
221 266
267 + $bom = chr( 0xEF ) . chr( 0xBB ) . chr( 0xBF );
222 268 $fp = tmpfile();
269 + if ( ! apply_filters( 'vizualizer_export_include_series_type', true ) ) {
270 + unset( $rows[1] );
271 + $rows = array_values( $rows );
272 + }
223 273 // support for MS Excel
224 - fprintf( $fp, $bom = ( chr( 0xEF ) . chr( 0xBB ) . chr( 0xBF ) ) );
274 + fprintf( $fp, $bom );
225 275 foreach ( $rows as $row ) {
226 276 fputcsv( $fp, $row );
227 277 }
228 278 rewind( $fp );
229 279 $csv = '';
280 + // phpcs:ignore WordPress.CodeAnalysis.AssignmentInCondition.FoundInWhileCondition
230 281 while ( ( $array = fgetcsv( $fp ) ) !== false ) {
231 282 if ( strlen( $csv ) > 0 ) {
232 283 $csv .= PHP_EOL;
233 284 }
285 + // if enclosure is required, check every item of this line
286 + // if a comma exists in the item, add enclosure.
287 + if ( $enclose ) {
288 + $temp_array = array();
289 + foreach ( $array as $item ) {
290 + if ( strpos( $item, ',' ) !== false ) {
291 + $item = VISUALIZER_CSV_ENCLOSURE . $item . VISUALIZER_CSV_ENCLOSURE;
292 + }
293 + $temp_array[] = $item;
294 + }
295 + $array = $temp_array;
296 + }
234 297 $csv .= implode( ',', $array );
235 298 }
236 299 fclose( $fp );
237 300
@@ -237,8 +300,9 @@
237 300
238 301 return array(
239 302 'csv' => $csv,
240 303 'name' => $filename,
304 + 'string' => str_replace( $bom, '', $csv ),
241 305 );
242 306 }
243 307
244 308 /**
@@ -248,30 +312,44 @@
248 312 * @param array $rows The array of data.
249 313 * @param string $filename The name of the file to use.
250 314 */
251 315 private function _getExcel( $rows, $filename ) {
252 - // PHPExcel does not like sheet names longer than 31 characters.
316 + // PHPExcel did not like sheet names longer than 31 characters and we will assume the same with PhpSpreadsheet
253 317 $chart = substr( $filename, 0, 30 );
254 318 $filename .= '.xlsx';
255 -
319 + if ( ! apply_filters( 'vizualizer_export_include_series_type', true ) ) {
320 + unset( $rows[1] );
321 + $rows = array_values( $rows );
322 + $rows = array_map(
323 + function( $r ) {
324 + return array_map( 'strval', $r );
325 + },
326 + $rows
327 + );
328 + }
329 + $vendor_file = VISUALIZER_ABSPATH . '/vendor/autoload.php';
330 + if ( is_readable( $vendor_file ) ) {
331 + include_once( $vendor_file );
332 + }
256 333 $xlsData = '';
257 - if ( class_exists( 'PHPExcel' ) ) {
258 - $doc = new PHPExcel();
334 + if ( class_exists( 'PhpOffice\PhpSpreadsheet\Spreadsheet' ) ) {
335 + $doc = new PhpOffice\PhpSpreadsheet\Spreadsheet();
259 336 $doc->getActiveSheet()->fromArray( $rows, null, 'A1' );
260 337 $doc->getActiveSheet()->setTitle( sanitize_title( $chart ) );
261 338 $doc = apply_filters( 'visualizer_excel_doc', $doc );
262 - $writer = PHPExcel_IOFactory::createWriter( $doc, 'Excel2007' );
339 + $writer = PhpOffice\PhpSpreadsheet\IOFactory::createWriter( $doc, 'Xlsx' );
263 340 ob_start();
264 341 $writer->save( 'php://output' );
265 342 $xlsData = ob_get_contents();
266 343 ob_end_clean();
267 344 } else {
268 - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, 'Class PHPExcel does not exist!', 'error', __FILE__, __LINE__ );
269 - error_log( 'Class PHPExcel does not exist!' );
345 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, 'Class PhpOffice\PhpSpreadsheet\Spreadsheet does not exist!', 'error', __FILE__, __LINE__ );
346 + error_log( 'Class PhpOffice\PhpSpreadsheet\Spreadsheet does not exist!' );
270 347 }
271 348 return array(
272 349 'csv' => 'data:application/vnd.ms-excel;base64,' . base64_encode( $xlsData ),
273 350 'name' => $filename,
351 + 'raw' => base64_encode( $xlsData ),
274 352 );
275 353 }
276 354
277 355 /**
@@ -301,8 +379,14 @@
301 379
302 380 $table = '<table class="visualizer-print">';
303 381 $index = 0;
304 382 foreach ( $rows as $row ) {
383 + // skip the data type row.
384 + if ( 1 === $index ) {
385 + $index++;
386 + continue;
387 + }
388 +
305 389 $table .= '<tr>';
306 390 foreach ( $row as $col ) {
307 391 if ( $index === 0 ) {
308 392 $table .= '<th>' . $col . '</th>';
@@ -323,8 +407,78 @@
323 407 );
324 408 }
325 409
326 410 /**
411 + * Disable revisions temporarily for visualizer post type.
412 + */
413 + protected final function disableRevisionsTemporarily() {
414 + add_filter(
415 + 'wp_revisions_to_keep', function( $num, $post ) {
416 + if ( $post->post_type === Visualizer_Plugin::CPT_VISUALIZER ) {
417 + return 0;
418 + }
419 + return $num;
420 + }, 10, 2
421 + );
422 + }
423 +
424 + /**
425 + * Undo revisions for the chart, and if necessary, restore the earliest version.
426 + *
427 + * @return bool If any revisions were found.
428 + */
429 + public final function undoRevisions( $chart_id, $restore = false ) {
430 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'undoRevisions for %d with%s restore', $chart_id, ( $restore ? '' : 'out' ) ), 'debug', __FILE__, __LINE__ );
431 + if ( get_post_type( $chart_id ) !== Visualizer_Plugin::CPT_VISUALIZER ) {
432 + return false;
433 + }
434 + $revisions = wp_get_post_revisions( $chart_id, array( 'order' => 'ASC' ) );
435 + if ( count( $revisions ) > 1 ) {
436 + $revision_ids = array_keys( $revisions );
437 +
438 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'found %d revisions = %s', count( $revisions ), print_r( $revision_ids, true ) ), 'debug', __FILE__, __LINE__ );
439 +
440 + // when we restore, a new revision is likely to be created. so, let's disable revisions for the time being.
441 + $this->disableRevisionsTemporarily();
442 +
443 + if ( $restore ) {
444 + // restore to the oldest one i.e. the first one.
445 + wp_restore_post_revision( array_shift( $revision_ids ) );
446 + }
447 +
448 + // delete all revisions.
449 + foreach ( $revision_ids as $id ) {
450 + wp_delete_post_revision( $id );
451 + }
452 +
453 + return true;
454 + }
455 + return false;
456 + }
457 +
458 + /**
459 + * If existing revisions exist for the chart, restore the earliest version and then create a new revision to initiate editing.
460 + */
461 + public final function handleExistingRevisions( $chart_id, $chart ) {
462 +
463 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'handleExistingRevisions for %d', $chart_id ), 'debug', __FILE__, __LINE__ );
464 + if ( get_post_type( $chart_id ) !== Visualizer_Plugin::CPT_VISUALIZER ) {
465 + return $chart_id;
466 + }
467 + // undo revisions.
468 + $revisions_found = $this->undoRevisions( $chart_id, true );
469 +
470 + // create revision for the edit action.
471 + wp_save_post_revision( $chart_id );
472 +
473 + if ( $revisions_found ) {
474 + // fetch chart data again in case it was updated by an earlier revision.
475 + $chart = get_post( $chart_id );
476 + }
477 + return $chart;
478 + }
479 +
480 + /**
327 481 * Returns the language of the locale.
328 482 *
329 483 * @access protected
330 484 */
@@ -337,6 +491,271 @@
337 491 if ( count( $array ) < 2 ) {
338 492 return '';
339 493 }
340 494 return reset( $array );
495 + }
496 +
497 + /**
498 + * Gets/creates the JS where user-specific customizations can be/have been added.
499 + */
500 + protected function get_user_customization_js() {
501 + // use this as the JS file in case we are not able to create the file in uploads.
502 + $default = VISUALIZER_ABSURL . 'js/customization.js';
503 +
504 + $uploads = wp_get_upload_dir();
505 + $specific = $uploads['baseurl'] . '/visualizer/customization.js';
506 +
507 + // for testing on user sites (before we send them the correctly customized file).
508 + if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) {
509 + return $default;
510 + }
511 +
512 + require_once( ABSPATH . 'wp-admin/includes/file.php' );
513 + WP_Filesystem();
514 + global $wp_filesystem;
515 +
516 + $multisite_arg = '/';
517 + if ( is_multisite() && ! is_main_site() ) {
518 + $multisite_arg = '/sites/' . get_current_blog_id() . '/';
519 + }
520 +
521 + $dir = $wp_filesystem->wp_content_dir() . 'uploads' . $multisite_arg . 'visualizer';
522 + $file = $wp_filesystem->wp_content_dir() . 'uploads' . $multisite_arg . 'visualizer/customization.js';
523 +
524 + if ( $wp_filesystem->is_readable( $file ) ) {
525 + return $specific;
526 + }
527 +
528 + if ( $wp_filesystem->exists( $file ) && ! $wp_filesystem->is_readable( $file ) ) {
529 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Unable to read file %s', $file ), 'error', __FILE__, __LINE__ );
530 + return $default;
531 + }
532 +
533 + if ( ! $wp_filesystem->exists( $dir ) ) {
534 + // phpcs:ignore WordPress.CodeAnalysis.AssignmentInCondition.Found
535 + if ( ( $done = $wp_filesystem->mkdir( $dir ) ) === false ) {
536 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Unable to create directory %s', $dir ), 'error', __FILE__, __LINE__ );
537 + return $default;
538 + }
539 + }
540 +
541 + // if file does not exist, copy.
542 + if ( ! $wp_filesystem->exists( $file ) ) {
543 + $src = str_replace( ABSPATH, $wp_filesystem->abspath(), VISUALIZER_ABSPATH . '/js/customization.js' );
544 + // phpcs:ignore WordPress.CodeAnalysis.AssignmentInCondition.Found
545 + if ( ( $done = $wp_filesystem->copy( $src, $file ) ) === false ) {
546 + do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Unable to copy file %s to %s', $src, $file ), 'error', __FILE__, __LINE__ );
547 + return $default;
548 + }
549 + }
550 +
551 + return $specific;
552 + }
553 +
554 + /**
555 + * Load the class for the given chart's chart type so that its assets can be loaded.
556 + */
557 + protected function load_chart_type( $chart_id ) {
558 + $name = $this->load_chart_class_name( $chart_id );
559 + $class = null;
560 + if ( class_exists( $name ) || true === apply_filters( 'visualizer_load_chart', false, $name ) ) {
561 + if ( 'Visualizer_Render_Sidebar_Type_DataTable_DataTable' === $name ) {
562 + $name = 'Visualizer_Render_Sidebar_Type_DataTable_Tabular';
563 + }
564 + $class = new $name;
565 + }
566 +
567 + if ( is_null( $class ) && Visualizer_Module::is_pro() ) {
568 + // lets see if this type exists in pro. New Lite(3.1.0+) & old Pro(1.8.0-).
569 + $type = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true );
570 + $class = apply_filters( 'visualizer_pro_chart_type_sidebar', null, array( 'id' => $chart_id, 'type' => $type, 'settings' => get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true ) ) );
571 + }
572 +
573 + return is_null( $class ) ? null : $class->getLibrary();
574 + }
575 +
576 + /**
577 + * Returns the class name for the given chart's chart type.
578 + */
579 + protected function load_chart_class_name( $chart_id ) {
580 + $type = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true );
581 + $lib = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_LIBRARY, true );
582 +
583 + // backward compatibility.
584 + if ( empty( $lib ) ) {
585 + $lib = 'GoogleCharts';
586 + if ( 'dataTable' === $type ) {
587 + $lib = 'DataTable';
588 + }
589 + }
590 + $name = 'Visualizer_Render_Sidebar_Type_' . $lib . '_' . ucwords( $type );
591 + return $name;
592 + }
593 +
594 + /**
595 + * Generates the inline CSS to apply to the chart and adds these classes to the settings.
596 + *
597 + * @access public
598 + * @param int $id The id of the chart.
599 + * @param array $settings The settings of the chart.
600 + */
601 + protected function get_inline_custom_css( $id, $settings ) {
602 + $css = '';
603 +
604 + $arguments = array( '', $settings );
605 + if ( ! isset( $settings['customcss'] ) ) {
606 + return $arguments;
607 + }
608 +
609 + $classes = array();
610 + $css = '<style type="text/css" name="visualizer-custom-css" id="customcss-' . $id . '">';
611 + foreach ( $settings['customcss'] as $name => $element ) {
612 + $attributes = array();
613 + foreach ( $element as $property => $value ) {
614 + $attributes[] = $this->handle_css_property( $property, $value );
615 + }
616 + $class_name = $id . $name;
617 + $properties = implode( ' !important; ', array_filter( $attributes ) );
618 + if ( ! empty( $properties ) ) {
619 + $css .= '.' . $class_name . ' {' . $properties . ' !important;}';
620 + $classes[ $name ] = $class_name;
621 + }
622 + }
623 + $css .= '</style>';
624 +
625 + $settings['cssClassNames'] = $classes;
626 +
627 + $arguments = array( $css, $settings );
628 + apply_filters_ref_array( 'visualizer_inline_css', array( &$arguments ) );
629 +
630 + return $arguments;
631 + }
632 +
633 + /**
634 + * Handles CSS properties that might need special syntax.
635 + *
636 + * @access private
637 + * @param string $property The name of the css property.
638 + * @param string $value The value of the css property.
639 + */
640 + private function handle_css_property( $property, $value ) {
641 + if ( empty( $property ) || empty( $value ) ) {
642 + return '';
643 + }
644 +
645 + switch ( $property ) {
646 + case 'transform':
647 + $value = 'rotate(' . $value . 'deg)';
648 + break;
649 + }
650 + return $property . ': ' . $value;
651 + }
652 +
653 + /**
654 + * Determines if charts have been created of the particular chart type.
655 + */
656 + protected static function hasChartType( $type ) {
657 + $args = array(
658 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
659 + 'fields' => 'ids',
660 + 'post_status' => 'publish',
661 + 'meta_query' => array(
662 + array(
663 + 'key' => Visualizer_Plugin::CF_CHART_TYPE,
664 + 'value' => $type,
665 + ),
666 + ),
667 + );
668 +
669 + $q = new WP_Query( $args );
670 + return $q->found_posts > 0;
671 + }
672 +
673 + /**
674 + * Determines how many charts have been created.
675 + */
676 + protected static function numberOfCharts() {
677 + $args = array(
678 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
679 + 'fields' => 'ids',
680 + 'post_status' => 'publish',
681 + 'posts_per_page' => 300,
682 + );
683 +
684 + $q = new WP_Query( $args );
685 + return $q->found_posts;
686 + }
687 +
688 + /**
689 + * Checks if the PRO version is active.
690 + *
691 + * @since 3.3.0
692 + */
693 + public static function is_pro() {
694 + // versions of pro before 1.9.0 will use the constant VISUALIZER_PRO
695 + // versions of pro 1.9.0 onwards will use the filter
696 + return apply_filters( 'visualizer_is_pro', VISUALIZER_PRO );
697 + }
698 +
699 + /**
700 + * Checks if the PRO version is older than a particular version.
701 + *
702 + * @since 3.3.0
703 + */
704 + public static function is_pro_older_than( $version ) {
705 + return version_compare( VISUALIZER_PRO_VERSION, $version, '<' );
706 + }
707 +
708 + /**
709 + * Should we show some specific feature on the basis of the version?
710 + *
711 + * @since 3.4.0
712 + */
713 + public static function can_show_feature( $feature ) {
714 + switch ( $feature ) {
715 + case 'simple-editor':
716 + // if user has pro but an older version, then don't load the simple editor functionality
717 + // as the select box will not behave as expected because the pro editor's functionality will supercede.
718 + return ! Visualizer_Module::is_pro() || ! Visualizer_Module::is_pro_older_than( '1.9.2' );
719 + }
720 + return false;
721 + }
722 +
723 + /**
724 + * Gets the features for the provided license type.
725 + */
726 + public static final function get_features_for_license( $plan ) {
727 + switch ( $plan ) {
728 + case 1:
729 + return array( 'import-wp', 'db-query' );
730 + case 2:
731 + return array( 'schedule-chart', 'chart-permissions' );
732 + }
733 + }
734 +
735 + /**
736 + * Gets the chart content after common manipulations.
737 + */
738 + public static function get_chart_data( $chart, $type, $run_filter = true ) {
739 + // change HTML entities
740 + $data = unserialize( html_entity_decode( $chart->post_content ) );
741 + $altered = array();
742 + foreach ( $data as $index => $array ) {
743 + if ( ! is_array( $index ) && is_array( $array ) ) {
744 + foreach ( $array as &$datum ) {
745 + if ( is_string( $datum ) ) {
746 + $datum = stripslashes( $datum );
747 + }
748 + }
749 + $altered[ $index ] = $array;
750 + }
751 + }
752 + // if something goes wrong and the end result is empty, be safe and use the original data
753 + if ( empty( $altered ) ) {
754 + $altered = $data;
755 + }
756 + if ( $run_filter ) {
757 + return apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, $altered, $chart->ID, $type );
758 + }
759 + return $altered;
341 760 }
342 761 }