| @@ -62,12 +62,8 @@ | ||
| 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 | - | |
| 70 | 66 | } |
| 71 | 67 | |
| 72 | 68 | /** |
| 73 | 69 | * Registers an action hook. |
| @@ -144,403 +140,7 @@ | ||
| 144 | 140 | */ |
| 145 | 141 | protected function _addShortcode( $tag, $method ) { |
| 146 | 142 | add_shortcode( $tag, array( $this, $method ) ); |
| 147 | 143 | return $this; |
| 148 | - } | |
| 149 | - | |
| 150 | - /** | |
| 151 | - * Extracts the data for a chart and prepares it for the given type. | |
| 152 | - * | |
| 153 | - * @access public | |
| 154 | - * @param int $chart_id The chart id. | |
| 155 | - * @param string $type The exported type. | |
| 156 | - */ | |
| 157 | - public function _getDataAs( $chart_id, $type ) { | |
| 158 | - $final = null; | |
| 159 | - $success = false; | |
| 160 | - if ( $chart_id ) { | |
| 161 | - $chart = get_post( $chart_id ); | |
| 162 | - $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER; | |
| 163 | - } | |
| 164 | - if ( $success ) { | |
| 165 | - $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true ); | |
| 166 | - $rows = array(); | |
| 167 | - $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true ); | |
| 168 | - $data = unserialize( $chart->post_content ); | |
| 169 | - if ( ! empty( $series ) ) { | |
| 170 | - $row = array(); | |
| 171 | - foreach ( $series as $array ) { | |
| 172 | - $row[] = $array['label']; | |
| 173 | - } | |
| 174 | - $rows[] = $row; | |
| 175 | - $row = array(); | |
| 176 | - foreach ( $series as $array ) { | |
| 177 | - $row[] = $array['type']; | |
| 178 | - } | |
| 179 | - $rows[] = $row; | |
| 180 | - } | |
| 181 | - if ( ! empty( $data ) ) { | |
| 182 | - foreach ( $data as $array ) { | |
| 183 | - // ignore strings | |
| 184 | - if ( ! is_array( $array ) ) { | |
| 185 | - continue; | |
| 186 | - } | |
| 187 | - // if this is an array of arrays... | |
| 188 | - if ( is_array( $array[0] ) ) { | |
| 189 | - foreach ( $array as $arr ) { | |
| 190 | - $rows[] = $arr; | |
| 191 | - } | |
| 192 | - } else { | |
| 193 | - // just an array | |
| 194 | - $rows[] = $array; | |
| 195 | - } | |
| 196 | - } | |
| 197 | - } | |
| 198 | - | |
| 199 | - $filename = isset( $settings['title'] ) && ! empty( $settings['title'] ) ? $settings['title'] : 'visualizer#' . $chart_id; | |
| 200 | - | |
| 201 | - switch ( $type ) { | |
| 202 | - case 'csv': | |
| 203 | - $final = $this->_getCSV( $rows, $filename ); | |
| 204 | - break; | |
| 205 | - case 'xls': | |
| 206 | - $final = $this->_getExcel( $rows, $filename ); | |
| 207 | - break; | |
| 208 | - case 'print': | |
| 209 | - $final = $this->_getHTML( $rows ); | |
| 210 | - break; | |
| 211 | - } | |
| 212 | - } | |
| 213 | - return $final; | |
| 214 | - } | |
| 215 | - | |
| 216 | - /** | |
| 217 | - * Prepares a CSV. | |
| 218 | - * | |
| 219 | - * @access private | |
| 220 | - * @param array $rows The array of data. | |
| 221 | - * @param string $filename The name of the file to use. | |
| 222 | - */ | |
| 223 | - private function _getCSV( $rows, $filename ) { | |
| 224 | - $filename .= '.csv'; | |
| 225 | - | |
| 226 | - $fp = tmpfile(); | |
| 227 | - // support for MS Excel | |
| 228 | - fprintf( $fp, $bom = ( chr( 0xEF ) . chr( 0xBB ) . chr( 0xBF ) ) ); | |
| 229 | - foreach ( $rows as $row ) { | |
| 230 | - fputcsv( $fp, $row ); | |
| 231 | - } | |
| 232 | - rewind( $fp ); | |
| 233 | - $csv = ''; | |
| 234 | - while ( ( $array = fgetcsv( $fp ) ) !== false ) { | |
| 235 | - if ( strlen( $csv ) > 0 ) { | |
| 236 | - $csv .= PHP_EOL; | |
| 237 | - } | |
| 238 | - $csv .= implode( ',', $array ); | |
| 239 | - } | |
| 240 | - fclose( $fp ); | |
| 241 | - | |
| 242 | - return array( | |
| 243 | - 'csv' => $csv, | |
| 244 | - 'name' => $filename, | |
| 245 | - ); | |
| 246 | - } | |
| 247 | - | |
| 248 | - /** | |
| 249 | - * Prepares an Excel file. | |
| 250 | - * | |
| 251 | - * @access private | |
| 252 | - * @param array $rows The array of data. | |
| 253 | - * @param string $filename The name of the file to use. | |
| 254 | - */ | |
| 255 | - private function _getExcel( $rows, $filename ) { | |
| 256 | - // PHPExcel does not like sheet names longer than 31 characters. | |
| 257 | - $chart = substr( $filename, 0, 30 ); | |
| 258 | - $filename .= '.xlsx'; | |
| 259 | - | |
| 260 | - $xlsData = ''; | |
| 261 | - if ( class_exists( 'PHPExcel' ) ) { | |
| 262 | - $doc = new PHPExcel(); | |
| 263 | - $doc->getActiveSheet()->fromArray( $rows, null, 'A1' ); | |
| 264 | - $doc->getActiveSheet()->setTitle( sanitize_title( $chart ) ); | |
| 265 | - $doc = apply_filters( 'visualizer_excel_doc', $doc ); | |
| 266 | - $writer = PHPExcel_IOFactory::createWriter( $doc, 'Excel2007' ); | |
| 267 | - ob_start(); | |
| 268 | - $writer->save( 'php://output' ); | |
| 269 | - $xlsData = ob_get_contents(); | |
| 270 | - ob_end_clean(); | |
| 271 | - } else { | |
| 272 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, 'Class PHPExcel does not exist!', 'error', __FILE__, __LINE__ ); | |
| 273 | - error_log( 'Class PHPExcel does not exist!' ); | |
| 274 | - } | |
| 275 | - return array( | |
| 276 | - 'csv' => 'data:application/vnd.ms-excel;base64,' . base64_encode( $xlsData ), | |
| 277 | - 'name' => $filename, | |
| 278 | - ); | |
| 279 | - } | |
| 280 | - | |
| 281 | - /** | |
| 282 | - * Prepares an HTML table. | |
| 283 | - * | |
| 284 | - * @access private | |
| 285 | - * @param array $rows The array of data. | |
| 286 | - */ | |
| 287 | - private function _getHTML( $rows ) { | |
| 288 | - $css = ' | |
| 289 | - table.visualizer-print { | |
| 290 | - border-collapse: collapse; | |
| 291 | - } | |
| 292 | - table.visualizer-print, table.visualizer-print th, table.visualizer-print td { | |
| 293 | - border: 1px solid #000; | |
| 294 | - } | |
| 295 | - '; | |
| 296 | - $html = ''; | |
| 297 | - $html .= ' | |
| 298 | - <html> | |
| 299 | - <head> | |
| 300 | - <style> | |
| 301 | - ' . apply_filters( 'visualizer_print_css', $css ) . ' | |
| 302 | - </style> | |
| 303 | - </head> | |
| 304 | - <body>'; | |
| 305 | - | |
| 306 | - $table = '<table class="visualizer-print">'; | |
| 307 | - $index = 0; | |
| 308 | - foreach ( $rows as $row ) { | |
| 309 | - $table .= '<tr>'; | |
| 310 | - foreach ( $row as $col ) { | |
| 311 | - if ( $index === 0 ) { | |
| 312 | - $table .= '<th>' . $col . '</th>'; | |
| 313 | - } else { | |
| 314 | - $table .= '<td>' . $col . '</td>'; | |
| 315 | - } | |
| 316 | - } | |
| 317 | - $table .= '</tr>'; | |
| 318 | - $index++; | |
| 319 | - } | |
| 320 | - $table .= '</table>'; | |
| 321 | - | |
| 322 | - $html .= apply_filters( 'visualizer_print_table', $table ) . ' | |
| 323 | - </body> | |
| 324 | - </html>'; | |
| 325 | - return array( | |
| 326 | - 'csv' => $html, | |
| 327 | - ); | |
| 328 | - } | |
| 329 | - | |
| 330 | - /** | |
| 331 | - * Undo revisions for the chart, and if necessary, restore the earliest version. | |
| 332 | - * | |
| 333 | - * @return bool If any revisions were found. | |
| 334 | - */ | |
| 335 | - public final function undoRevisions( $chart_id, $restore = false ) { | |
| 336 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'undoRevisions for %d with%s restore', $chart_id, ( $restore ? '' : 'out' ) ), 'debug', __FILE__, __LINE__ ); | |
| 337 | - | |
| 338 | - $revisions = wp_get_post_revisions( $chart_id, array( 'order' => 'ASC' ) ); | |
| 339 | - if ( count( $revisions ) > 1 ) { | |
| 340 | - $revision_ids = array_keys( $revisions ); | |
| 341 | - | |
| 342 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'found %d revisions = %s', count( $revisions ), print_r( $revision_ids, true ) ), 'debug', __FILE__, __LINE__ ); | |
| 343 | - | |
| 344 | - // when we restore, a new revision is likely to be created. so, let's disable revisions for the time being. | |
| 345 | - add_filter( 'wp_revisions_to_keep', '__return_false' ); | |
| 346 | - | |
| 347 | - if ( $restore ) { | |
| 348 | - // restore to the oldest one i.e. the first one. | |
| 349 | - wp_restore_post_revision( array_shift( $revision_ids ) ); | |
| 350 | - } | |
| 351 | - | |
| 352 | - // delete all revisions. | |
| 353 | - foreach ( $revision_ids as $id ) { | |
| 354 | - wp_delete_post_revision( $id ); | |
| 355 | - } | |
| 356 | - | |
| 357 | - return true; | |
| 358 | - } | |
| 359 | - return false; | |
| 360 | - } | |
| 361 | - | |
| 362 | - /** | |
| 363 | - * If existing revisions exist for the chart, restore the earliest version and then create a new revision to initiate editing. | |
| 364 | - */ | |
| 365 | - public final function handleExistingRevisions( $chart_id, $chart ) { | |
| 366 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'handleExistingRevisions for %d', $chart_id ), 'debug', __FILE__, __LINE__ ); | |
| 367 | - | |
| 368 | - // undo revisions. | |
| 369 | - $revisions_found = $this->undoRevisions( $chart_id, true ); | |
| 370 | - | |
| 371 | - // create revision for the edit action. | |
| 372 | - wp_save_post_revision( $chart_id ); | |
| 373 | - | |
| 374 | - if ( $revisions_found ) { | |
| 375 | - // fetch chart data again in case it was updated by an earlier revision. | |
| 376 | - $chart = get_post( $chart_id ); | |
| 377 | - } | |
| 378 | - return $chart; | |
| 379 | - } | |
| 380 | - | |
| 381 | - /** | |
| 382 | - * Returns the language of the locale. | |
| 383 | - * | |
| 384 | - * @access protected | |
| 385 | - */ | |
| 386 | - protected function get_language() { | |
| 387 | - $locale = get_locale(); | |
| 388 | - if ( empty( $locale ) ) { | |
| 389 | - return ''; | |
| 390 | - } | |
| 391 | - $array = explode( '_', $locale ); | |
| 392 | - if ( count( $array ) < 2 ) { | |
| 393 | - return ''; | |
| 394 | - } | |
| 395 | - return reset( $array ); | |
| 396 | - } | |
| 397 | - | |
| 398 | - /** | |
| 399 | - * Gets/creates the JS where user-specific customizations can be/have been added. | |
| 400 | - */ | |
| 401 | - protected function get_user_customization_js() { | |
| 402 | - // use this as the JS file in case we are not able to create the file in uploads. | |
| 403 | - $default = VISUALIZER_ABSURL . 'js/customization.js'; | |
| 404 | - | |
| 405 | - $uploads = wp_get_upload_dir(); | |
| 406 | - $specific = $uploads['baseurl'] . '/visualizer/customization.js'; | |
| 407 | - | |
| 408 | - // for testing on user sites (before we send them the correctly customized file). | |
| 409 | - if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) { | |
| 410 | - return $default; | |
| 411 | - } | |
| 412 | - | |
| 413 | - require_once( ABSPATH . 'wp-admin/includes/file.php' ); | |
| 414 | - WP_Filesystem(); | |
| 415 | - global $wp_filesystem; | |
| 416 | - | |
| 417 | - $dir = $wp_filesystem->wp_content_dir() . 'uploads/visualizer'; | |
| 418 | - $file = $wp_filesystem->wp_content_dir() . 'uploads/visualizer/customization.js'; | |
| 419 | - | |
| 420 | - if ( $wp_filesystem->is_readable( $file ) ) { | |
| 421 | - return $specific; | |
| 422 | - } | |
| 423 | - | |
| 424 | - if ( $wp_filesystem->exists( $file ) && ! $wp_filesystem->is_readable( $file ) ) { | |
| 425 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Unable to read file %s', $file ), 'error', __FILE__, __LINE__ ); | |
| 426 | - return $default; | |
| 427 | - } | |
| 428 | - | |
| 429 | - if ( ! $wp_filesystem->exists( $dir ) ) { | |
| 430 | - if ( ( $done = $wp_filesystem->mkdir( $dir ) ) === false ) { | |
| 431 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Unable to create directory %s', $dir ), 'error', __FILE__, __LINE__ ); | |
| 432 | - return $default; | |
| 433 | - } | |
| 434 | - } | |
| 435 | - | |
| 436 | - // if file does not exist, copy. | |
| 437 | - if ( ! $wp_filesystem->exists( $file ) ) { | |
| 438 | - $src = str_replace( ABSPATH, $wp_filesystem->abspath(), VISUALIZER_ABSPATH . '/js/customization.js' ); | |
| 439 | - if ( ( $done = $wp_filesystem->copy( $src, $file ) ) === false ) { | |
| 440 | - do_action( 'themeisle_log_event', Visualizer_Plugin::NAME, sprintf( 'Unable to copy file %s to %s', $src, $file ), 'error', __FILE__, __LINE__ ); | |
| 441 | - return $default; | |
| 442 | - } | |
| 443 | - } | |
| 444 | - | |
| 445 | - return $specific; | |
| 446 | - } | |
| 447 | - | |
| 448 | - /** | |
| 449 | - * Load the class for the given chart's chart type so that its assets can be loaded. | |
| 450 | - */ | |
| 451 | - protected function load_chart_type( $chart_id ) { | |
| 452 | - $type = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true ); | |
| 453 | - $name = 'Visualizer_Render_Sidebar_Type_' . ucwords( $type ); | |
| 454 | - $class = null; | |
| 455 | - if ( class_exists( $name ) || true === apply_filters( 'visualizer_load_chart', false, $name ) ) { | |
| 456 | - $class = new $name; | |
| 457 | - } | |
| 458 | - | |
| 459 | - if ( is_null( $class ) && VISUALIZER_PRO ) { | |
| 460 | - // lets see if this type exists in pro. New Lite(3.1.0+) & old Pro(1.8.0-). | |
| 461 | - $class = apply_filters( 'visualizer_pro_chart_type_sidebar', null, array( 'type' => $type, 'settings' => get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true ) ) ); | |
| 462 | - } | |
| 463 | - | |
| 464 | - return is_null( $class ) ? null : $class->getLibrary(); | |
| 465 | - } | |
| 466 | - | |
| 467 | - /** | |
| 468 | - * Generates the inline CSS to apply to the chart and adds these classes to the settings. | |
| 469 | - * | |
| 470 | - * @access public | |
| 471 | - * @param int $id The id of the chart. | |
| 472 | - * @param array $settings The settings of the chart. | |
| 473 | - */ | |
| 474 | - protected function get_inline_custom_css( $id, $settings ) { | |
| 475 | - $css = ''; | |
| 476 | - | |
| 477 | - $arguments = array( '', $settings ); | |
| 478 | - if ( ! isset( $settings['customcss'] ) ) { | |
| 479 | - return $arguments; | |
| 480 | - } | |
| 481 | - | |
| 482 | - $classes = array(); | |
| 483 | - $css = '<style type="text/css" name="visualizer-custom-css" id="customcss-' . $id . '">'; | |
| 484 | - foreach ( $settings['customcss'] as $name => $element ) { | |
| 485 | - $attributes = array(); | |
| 486 | - foreach ( $element as $property => $value ) { | |
| 487 | - $attributes[] = $this->handle_css_property( $property, $value ); | |
| 488 | - } | |
| 489 | - $class_name = $id . $name; | |
| 490 | - $properties = implode( '; ', array_filter( $attributes ) ); | |
| 491 | - if ( ! empty( $properties ) ) { | |
| 492 | - $css .= '.' . $class_name . ' {' . $properties . ' !important;}'; | |
| 493 | - $classes[ $name ] = $class_name; | |
| 494 | - } | |
| 495 | - } | |
| 496 | - $css .= '</style>'; | |
| 497 | - | |
| 498 | - $settings['cssClassNames'] = $classes; | |
| 499 | - | |
| 500 | - $arguments = array( $css, $settings ); | |
| 501 | - apply_filters_ref_array( 'visualizer_inline_css', array( &$arguments ) ); | |
| 502 | - | |
| 503 | - return $arguments; | |
| 504 | - } | |
| 505 | - | |
| 506 | - /** | |
| 507 | - * Handles CSS properties that might need special syntax. | |
| 508 | - * | |
| 509 | - * @access private | |
| 510 | - * @param string $property The name of the css property. | |
| 511 | - * @param string $value The value of the css property. | |
| 512 | - */ | |
| 513 | - private function handle_css_property( $property, $value ) { | |
| 514 | - if ( empty( $property ) || empty( $value ) ) { | |
| 515 | - return ''; | |
| 516 | - } | |
| 517 | - | |
| 518 | - switch ( $property ) { | |
| 519 | - case 'transform': | |
| 520 | - $value = 'rotate(' . $value . 'deg)'; | |
| 521 | - break; | |
| 522 | - } | |
| 523 | - return $property . ': ' . $value; | |
| 524 | - } | |
| 525 | - | |
| 526 | - /** | |
| 527 | - * Determines if charts have been created of the particular chart type. | |
| 528 | - */ | |
| 529 | - protected static function hasChartType( $type ) { | |
| 530 | - $args = array( | |
| 531 | - 'post_type' => Visualizer_Plugin::CPT_VISUALIZER, | |
| 532 | - 'fields' => 'ids', | |
| 533 | - 'post_status' => 'publish', | |
| 534 | - 'meta_query' => array( | |
| 535 | - array( | |
| 536 | - 'key' => Visualizer_Plugin::CF_CHART_TYPE, | |
| 537 | - 'value' => $type, | |
| 538 | - ), | |
| 539 | - ), | |
| 540 | - ); | |
| 541 | - | |
| 542 | - $q = new WP_Query( $args ); | |
| 543 | - return $q->found_posts > 0; | |
| 544 | 144 | } |
| 545 | 145 | |
| 546 | 146 | } |
