PluginProbe
TablePress – Tables in WordPress made easy / 3.2
TablePress – Tables in WordPress made easy v3.2
3.3.4 3.3.3 3.3.2 3.3.1 trunk 1.12 1.14 1.9.2 2.0.4 2.1.7 2.1.8 2.2 2.2.1 2.2.2 2.2.3 2.2.4 2.2.5 2.3 2.3.1 2.3.2 2.4 2.4.1 2.4.2 2.4.3 2.4.4 All 44 releases
← All changes | controllers/controller-frontend.php +368 -160 2.4.33.2 View file →
@@ -21,18 +21,47 @@
21 21 */
22 22 class TablePress_Frontend_Controller extends TablePress_Controller {
23 23
24 24 /**
25 + * Whether to use the legacy CSS loading method of enqueuing all CSS files on all pages.
26 + *
27 + * @since 3.0.1
28 + */
29 + public bool $use_legacy_css_loading = false;
30 +
31 + /**
32 + * File name of the admin screens' parent page in the admin menu.
33 + *
34 + * @since 1.0.0
35 + */
36 + public string $parent_page = 'middle';
37 +
38 + /**
39 + * Whether TablePress admin screens are a top-level menu item in the admin menu.
40 + *
41 + * @since 1.0.0
42 + */
43 + public bool $is_top_level_page = false;
44 +
45 + /**
25 46 * List of tables that are shown for the current request.
26 47 *
27 48 * @since 1.0.0
28 49 * @var array<string, array{count: int, instances: array<string, array<string, mixed>>}>
29 50 */
30 - protected $shown_tables = array();
51 + protected array $shown_tables = array();
31 52
32 53 /**
33 - * Initiate Frontend functionality.
54 + * List of registered DataTables datetime formats.
34 55 *
56 + * @since 3.0.0
57 + * @var string[]
58 + */
59 + protected array $datatables_datetime_formats = array();
60 +
61 + /**
62 + * Initiates Frontend functionality.
63 + *
35 64 * @since 1.0.0
36 65 */
37 66 public function __construct() {
38 67 parent::__construct();
@@ -37,20 +66,33 @@
37 66 public function __construct() {
38 67 parent::__construct();
39 68
40 69 /**
41 - * Filters whether the TablePress Default CSS code shall be loaded.
70 + * Filters the admin menu parent page, which is needed for the construction of plugin URLs.
42 71 *
43 72 * @since 1.0.0
44 73 *
45 - * @param bool $use Whether the Default CSS shall be loaded. Default true.
74 + * @param string $parent_page Current admin menu parent page.
46 75 */
47 - if ( apply_filters( 'tablepress_use_default_css', true ) || TablePress::$model_options->get( 'use_custom_css' ) ) {
76 + $this->parent_page = apply_filters( 'tablepress_admin_menu_parent_page', TablePress::$model_options->get( 'admin_menu_parent_page' ) );
77 + $this->is_top_level_page = in_array( $this->parent_page, array( 'top', 'middle', 'bottom' ), true );
78 +
79 + /**
80 + * Filters whether TablePress should load its frontend CSS files on all pages.
81 + * For block themes, the default behavior is to only load the CSS files when a table is encountered on the page.
82 + * If Elementor is active, the CSS is also loaded on the editor page.
83 + *
84 + * @since 3.0.1
85 + *
86 + * @param bool $use_legacy_css_loading Whether TablePress should load its frontend CSS files on all pages.
87 + */
88 + $this->use_legacy_css_loading = apply_filters( 'tablepress_frontend_legacy_css_loading', ! wp_is_block_theme() || ( isset( $_GET['elementor-preview'] ) && is_plugin_active( 'elementor/elementor.php' ) ) );
89 +
90 + if ( $this->use_legacy_css_loading ) {
48 91 add_action( 'wp_enqueue_scripts', array( $this, 'enqueue_css' ) );
49 92 }
50 93
51 - // Add DataTables invocation calls.
52 - add_action( 'wp_print_footer_scripts', array( $this, 'add_datatables_calls' ), 11 ); // After inclusion of files.
94 + add_action( 'wp_print_footer_scripts', array( $this, 'add_datatables_calls' ), 9 ); // Priority 9 so that this runs before `_wp_footer_scripts()`.
53 95
54 96 // Register TablePress Shortcodes. Priority 20 is kept for backwards-compatibility purposes.
55 97 add_action( 'init', array( $this, 'init_shortcodes' ), 20 );
56 98
@@ -73,18 +115,31 @@
73 115
74 116 /**
75 117 * Register the tablepress/table block and its dependencies.
76 118 */
77 - register_block_type(
78 - TABLEPRESS_ABSPATH . 'blocks/table/',
119 + if ( function_exists( 'wp_register_block_metadata_collection' ) ) {
120 + // wp_register_block_metadata_collection() is only available since WP 6.7.
121 + wp_register_block_metadata_collection(
122 + TABLEPRESS_ABSPATH . 'blocks',
123 + TABLEPRESS_ABSPATH . 'blocks/blocks-manifest.php',
124 + );
125 + }
126 + register_block_type_from_metadata(
127 + TABLEPRESS_ABSPATH . 'blocks/table/block.json',
79 128 array(
80 129 'render_callback' => array( $this, 'table_block_render_callback' ),
81 - )
130 + ),
82 131 );
132 +
133 + /**
134 + * Register the TablePress Elementor widgets.
135 + */
136 + add_action( 'elementor/widgets/register', array( $this, 'register_elementor_widgets' ) );
137 + add_action( 'elementor/editor/after_enqueue_styles', array( $this, 'enqueue_elementor_editor_styles' ), 10, 0 );
83 138 }
84 139
85 140 /**
86 - * Register TablePress Shortcodes.
141 + * Registers TablePress Shortcodes.
87 142 *
88 143 * @since 1.0.0
89 144 */
90 145 public function init_shortcodes(): void {
@@ -92,18 +147,67 @@
92 147 add_shortcode( TablePress::$shortcode_info, array( $this, 'shortcode_table_info' ) );
93 148 }
94 149
95 150 /**
96 - * Enqueue CSS files for default CSS and "Custom CSS" (if desired).
151 + * Checks if the CSS files for TablePress default CSS and "Custom CSS" should be loaded.
97 152 *
153 + * This function is only called when a [table /] Shortcode or "TablePress Table" block is evaluated, so that CSS files are only loaded when needed.
154 + *
155 + * @since 3.0.0
156 + */
157 + public function maybe_enqueue_css(): void {
158 + // Bail early if the legacy CSS loading mechanism is used, as the files will then have been enqueued already.
159 + if ( $this->use_legacy_css_loading && ! doing_action( 'enqueue_block_assets' ) ) {
160 + return;
161 + }
162 +
163 + /*
164 + * Bail early if the function is called from some action hook outside of the normal rendering process.
165 + * These are often used by e.g. SEO plugins that render the content in additional contexts, e.g. to get an excerpt via an output buffer.
166 + * In these cases, we don't want to enqueue the CSS, as it would likely not be printed on the page.
167 + */
168 + if ( doing_action( 'wp_head' ) || doing_action( 'wp_footer' ) ) {
169 + return;
170 + }
171 +
172 + // Prevent repeated execution via a static variable.
173 + static $css_enqueued = false;
174 + if ( $css_enqueued && ! doing_action( 'enqueue_block_assets' ) ) {
175 + return;
176 + }
177 + $css_enqueued = true;
178 +
179 + $this->enqueue_css();
180 + }
181 +
182 + /**
183 + * Enqueues CSS files for TablePress default CSS and "Custom CSS" (if desired).
184 + *
185 + * If styles have not been printed to the page (in the `<head>`), the TablePress CSS files will be enqueued.
186 + * If styles have already been printed to the page, the TablePress CSS files will be printed right away (likely in the `<body`>).
187 + *
98 188 * @since 1.0.0
99 189 */
100 190 public function enqueue_css(): void {
101 - /** This filter is documented in controllers/controller-frontend.php */
191 + /**
192 + * Filters whether the TablePress Default CSS code shall be loaded.
193 + *
194 + * @since 1.0.0
195 + *
196 + * @param bool $use Whether the Default CSS shall be loaded. Default true.
197 + */
102 198 $use_default_css = apply_filters( 'tablepress_use_default_css', true );
199 + $use_custom_css = TablePress::$model_options->get( 'use_custom_css' );
200 +
201 + if ( ! $use_default_css && ! $use_custom_css ) {
202 + // Register a placeholder dependency, so that the handle is known for other styles.
203 + wp_register_style( 'tablepress-default', false ); // phpcs:ignore WordPress.WP.EnqueuedResourceParameters.MissingVersion
204 + return;
205 + }
206 +
103 207 $custom_css = TablePress::$model_options->get( 'custom_css' );
104 - $use_custom_css = ( TablePress::$model_options->get( 'use_custom_css' ) && '' !== $custom_css );
105 - $use_custom_css_file = ( $use_custom_css && TablePress::$model_options->get( 'use_custom_css_file' ) );
208 + $use_custom_css = $use_custom_css && '' !== $custom_css;
209 + $use_custom_css_file = $use_custom_css && TablePress::$model_options->get( 'use_custom_css_file' );
106 210 /**
107 211 * Filters the "Custom CSS" version number that is appended to the enqueued CSS files
108 212 *
109 213 * @since 1.0.0
@@ -131,81 +235,71 @@
131 235 if ( $use_custom_css_combined_file ) {
132 236 $custom_css_combined_url = $tablepress_css->get_custom_css_location( 'combined', 'url' );
133 237 // Need to use 'tablepress-default' instead of 'tablepress-combined' to not break existing TablePress Extensions.
134 238 wp_enqueue_style( 'tablepress-default', $custom_css_combined_url, array(), $custom_css_version );
239 + if ( did_action( 'wp_print_styles' ) ) {
240 + wp_print_styles( 'tablepress-default' );
241 + }
242 + return;
243 + }
244 +
245 + if ( $use_default_css ) {
246 + wp_enqueue_style( 'tablepress-default', $default_css_url, array(), TablePress::version );
135 247 } else {
136 - $custom_css_dependencies = array();
137 - if ( $use_default_css ) {
138 - wp_enqueue_style( 'tablepress-default', $default_css_url, array(), TablePress::version );
139 - // Add dependency to make sure that Custom CSS is printed after Default CSS.
140 - $custom_css_dependencies[] = 'tablepress-default';
248 + // Register a placeholder dependency, so that the handle is known for other styles.
249 + wp_register_style( 'tablepress-default', false ); // phpcs:ignore WordPress.WP.EnqueuedResourceParameters.MissingVersion
250 + }
251 +
252 + $use_custom_css_minified_file = ( $use_custom_css_file && ! SCRIPT_DEBUG && $tablepress_css->load_custom_css_from_file( 'minified' ) );
253 + if ( $use_custom_css_minified_file ) {
254 + $custom_css_minified_url = $tablepress_css->get_custom_css_location( 'minified', 'url' );
255 + wp_enqueue_style( 'tablepress-custom', $custom_css_minified_url, array( 'tablepress-default' ), $custom_css_version );
256 + if ( did_action( 'wp_print_styles' ) ) {
257 + wp_print_styles( 'tablepress-custom' );
141 258 }
259 + return;
260 + }
142 261
143 - $use_custom_css_minified_file = ( $use_custom_css_file && ! SCRIPT_DEBUG && $tablepress_css->load_custom_css_from_file( 'minified' ) );
144 - if ( $use_custom_css_minified_file ) {
145 - $custom_css_minified_url = $tablepress_css->get_custom_css_location( 'minified', 'url' );
146 - wp_enqueue_style( 'tablepress-custom', $custom_css_minified_url, $custom_css_dependencies, $custom_css_version );
147 - return;
262 + $use_custom_css_normal_file = ( $use_custom_css_file && $tablepress_css->load_custom_css_from_file( 'normal' ) );
263 + if ( $use_custom_css_normal_file ) {
264 + $custom_css_normal_url = $tablepress_css->get_custom_css_location( 'normal', 'url' );
265 + wp_enqueue_style( 'tablepress-custom', $custom_css_normal_url, array( 'tablepress-default' ), $custom_css_version );
266 + if ( did_action( 'wp_print_styles' ) ) {
267 + wp_print_styles( 'tablepress-custom' );
148 268 }
269 + return;
270 + }
149 271
150 - $use_custom_css_normal_file = ( $use_custom_css_file && $tablepress_css->load_custom_css_from_file( 'normal' ) );
151 - if ( $use_custom_css_normal_file ) {
152 - $custom_css_normal_url = $tablepress_css->get_custom_css_location( 'normal', 'url' );
153 - wp_enqueue_style( 'tablepress-custom', $custom_css_normal_url, $custom_css_dependencies, $custom_css_version );
154 - return;
272 + if ( $use_custom_css ) {
273 + // Get "Custom CSS" from options, try minified Custom CSS first.
274 + $custom_css_minified = TablePress::$model_options->get( 'custom_css_minified' );
275 + if ( ! empty( $custom_css_minified ) ) {
276 + $custom_css = $custom_css_minified;
155 277 }
156 -
157 - if ( $use_custom_css ) {
158 - // Get "Custom CSS" from options, try minified Custom CSS first.
159 - $custom_css_minified = TablePress::$model_options->get( 'custom_css_minified' );
160 - if ( ! empty( $custom_css_minified ) ) {
161 - $custom_css = $custom_css_minified;
278 + /**
279 + * Filters the "Custom CSS" code that is to be loaded as inline CSS.
280 + *
281 + * @since 1.0.0
282 + *
283 + * @param string $custom_css The "Custom CSS" code.
284 + */
285 + $custom_css = apply_filters( 'tablepress_custom_css', $custom_css );
286 + if ( ! empty( $custom_css ) ) {
287 + wp_add_inline_style( 'tablepress-default', $custom_css );
288 + if ( did_action( 'wp_print_styles' ) ) {
289 + wp_print_styles( 'tablepress-default' );
162 290 }
163 - /**
164 - * Filters the "Custom CSS" code that is to be loaded as inline CSS.
165 - *
166 - * @since 1.0.0
167 - *
168 - * @param string $custom_css The "Custom CSS" code.
169 - */
170 - $custom_css = apply_filters( 'tablepress_custom_css', $custom_css );
171 - if ( ! empty( $custom_css ) ) {
172 - // wp_add_inline_style() requires a loaded CSS file, so we have to work around that if "Default CSS" is disabled.
173 - if ( $use_default_css ) {
174 - // Handle of the file to which the <style> shall be appended.
175 - wp_add_inline_style( 'tablepress-default', $custom_css );
176 - } else {
177 - add_action( 'wp_head', array( $this, '_print_custom_css' ), 8 ); // Priority 8 to hook in right after WP_Styles has been processed.
178 - }
179 - }
291 + return;
180 292 }
181 293 }
182 294 }
183 295
184 296 /**
185 - * Print "Custom CSS" to "wp_head" inline.
297 + * Enqueues the DataTables JavaScript library and its dependencies.
186 298 *
187 - * This is necessary if "Default CSS" is off, and saving "Custom CSS" to a file is not possible.
188 - *
189 - * @since 1.0.0
299 + * @since 3.0.0
190 300 */
191 - public function _print_custom_css(): void {
192 - // Get "Custom CSS" from options, try minified Custom CSS first.
193 - $custom_css = TablePress::$model_options->get( 'custom_css_minified' );
194 - if ( empty( $custom_css ) ) {
195 - $custom_css = TablePress::$model_options->get( 'custom_css' );
196 - }
197 - /** This filter is documented in controllers/controller-frontend.php */
198 - $custom_css = apply_filters( 'tablepress_custom_css', $custom_css );
199 - echo "<style>\n{$custom_css}\n</style>\n";
200 - }
201 -
202 - /**
203 - * Enqueue the DataTables JavaScript library and its dependencies.
204 - *
205 - * @since 1.0.0
206 - */
207 - protected function _enqueue_datatables(): void {
301 + protected function enqueue_datatables_files(): void {
208 302 $js_file = 'js/jquery.datatables.min.js';
209 303 $js_url = plugins_url( $js_file, TABLEPRESS__FILE__ );
210 304 /**
211 305 * Filters the URL from which the DataTables JavaScript library file is loaded.
@@ -215,13 +309,27 @@
215 309 * @param string $js_url URL of the DataTables JS library file.
216 310 * @param string $js_file Path and file name of the DataTables JS library file.
217 311 */
218 312 $js_url = apply_filters( 'tablepress_datatables_js_url', $js_url, $js_file );
219 - wp_enqueue_script( 'tablepress-datatables', $js_url, array( 'jquery-core' ), TablePress::version, true );
313 +
314 + $dependencies = array( 'jquery-core' );
315 + if ( ! empty( $this->datatables_datetime_formats ) ) {
316 + $dependencies[] = 'moment';
317 + }
318 + /**
319 + * Filters the dependencies for the DataTables JavaScript library.
320 + *
321 + * @since 3.0.0
322 + *
323 + * @param string[] $dependencies The dependencies for the DataTables JS library.
324 + */
325 + $dependencies = apply_filters( 'tablepress_datatables_js_dependencies', $dependencies );
326 +
327 + wp_enqueue_script( 'tablepress-datatables', $js_url, $dependencies, TablePress::version, true );
220 328 }
221 329
222 330 /**
223 - * Add JS code for invocation of DataTables JS library.
331 + * Adds the JavaScript code for the invocation of the DataTables JS library.
224 332 *
225 333 * @since 1.0.0
226 334 */
227 335 public function add_datatables_calls(): void {
@@ -230,16 +338,16 @@
230 338 if ( $datatables_calls_printed ) {
231 339 return;
232 340 }
233 341
342 + // Bail early if there are no TablePress tables on the page.
234 343 if ( empty( $this->shown_tables ) ) {
235 - // There are no tables with activated DataTables on the page that is currently rendered.
236 344 return;
237 345 }
238 346
239 347 /*
240 - * Don't add the DataTables function calls in the scope of the block editor.
241 - * Otherwise, this causes a script error in the block editor iframe.
348 + * Don't add the DataTables function calls in the scope of the block editor iframe.
349 + * This is necessary for non-block themes, for others, the repeated execution check above is sufficient.
242 350 */
243 351 if ( function_exists( 'get_current_screen' ) ) {
244 352 $current_screen = get_current_screen();
245 353 if ( ( $current_screen instanceof WP_Screen ) && $current_screen->is_block_editor() ) {
@@ -246,20 +354,31 @@
246 354 return;
247 355 }
248 356 }
249 357
358 + // Filter out all tables that use DataTables.
359 + $shown_tables_with_datatables = array();
360 + foreach ( $this->shown_tables as $table_id => $table_store ) {
361 + if ( ! empty( $table_store['instances'] ) ) {
362 + $shown_tables_with_datatables[ (string) $table_id ] = $table_store;
363 + }
364 + }
365 +
366 + // Bail early if there are no tables with activated DataTables on the page.
367 + if ( empty( $shown_tables_with_datatables ) ) {
368 + return;
369 + }
370 +
371 + $this->enqueue_datatables_files();
372 +
250 373 // Storage for the DataTables language strings.
251 374 $datatables_language = array();
252 375 // Generate the specific JS commands, depending on chosen features on the "Edit" screen and the Shortcode parameters.
253 376 $commands = array();
254 377
255 - foreach ( $this->shown_tables as $table_id => $table_store ) {
378 + foreach ( $shown_tables_with_datatables as $table_id => $table_store ) {
256 379 $table_id = (string) $table_id; // Ensure that the table ID is a string, as it comes from an array key where numeric strings are converted to integers.
257 380
258 - if ( empty( $table_store['instances'] ) ) {
259 - continue;
260 - }
261 -
262 381 foreach ( $table_store['instances'] as $html_id => $js_options ) {
263 382 $parameters = array();
264 383
265 384 // Settle dependencies/conflicts between certain features.
@@ -314,9 +433,9 @@
314 433 $datatables_strings = array();
315 434 }
316 435 } elseif ( str_ends_with( $language_file, '.json' ) ) {
317 436 $datatables_strings = file_get_contents( $language_file );
318 - $datatables_strings = json_decode( $datatables_strings, true ); // @phpstan-ignore-line
437 + $datatables_strings = json_decode( $datatables_strings, true ); // @phpstan-ignore argument.type
319 438 // Check if JSON could be decoded.
320 439 if ( is_null( $datatables_strings ) ) {
321 440 $datatables_strings = array();
322 441 }
@@ -340,58 +459,56 @@
340 459 * @param string $datatables_locale Current locale/language for the DataTables JS library.
341 460 */
342 461 $datatables_language[ $datatables_locale ] = apply_filters( 'tablepress_datatables_language_strings', $datatables_strings, $datatables_locale );
343 462 }
344 - $parameters['language'] = '"language":DT_language["' . $datatables_locale . '"]';
463 + $parameters['language'] = "language:DT_language['{$datatables_locale}']";
345 464
346 465 // These parameters need to be added for performance gain or to overwrite unwanted default behavior.
347 466 if ( $js_options['datatables_sort'] ) {
348 467 // No initial sort.
349 - $parameters['order'] = '"order":[]';
468 + $parameters['order'] = 'order:[]';
350 469 // Don't add additional classes, to speed up sorting.
351 - $parameters['orderClasses'] = '"orderClasses":false';
470 + $parameters['orderClasses'] = 'orderClasses:false';
352 471 }
353 472
354 - // Alternating row colors is default, so remove them if not wanted with [].
355 - $parameters['stripeClasses'] = '"stripeClasses":' . ( ( $js_options['alternating_row_colors'] ) ? '["even","odd"]' : '[]' );
356 -
357 473 // The following options are activated by default, so we only need to "false" them if we don't want them, but don't need to "true" them if we do.
358 474 if ( ! $js_options['datatables_sort'] ) {
359 - $parameters['ordering'] = '"ordering":false';
475 + $parameters['ordering'] = 'ordering:false';
360 476 }
361 477 if ( $js_options['datatables_paginate'] ) {
362 - $parameters['pagingType'] = '"pagingType":"simple"';
478 + $parameters['pagingType'] = "pagingType:'simple_numbers'";
363 479 if ( $js_options['datatables_lengthchange'] ) {
364 480 $length_menu = array( 10, 25, 50, 100 );
365 481 if ( ! in_array( $js_options['datatables_paginate_entries'], $length_menu, true ) ) {
366 482 $length_menu[] = $js_options['datatables_paginate_entries'];
367 483 sort( $length_menu, SORT_NUMERIC );
368 - $parameters['lengthMenu'] = '"lengthMenu":[' . implode( ',', $length_menu ) . ']';
484 + $parameters['lengthMenu'] = 'lengthMenu:[' . implode( ',', $length_menu ) . ']';
369 485 }
370 486 } else {
371 - $parameters['lengthChange'] = '"lengthChange":false';
487 + $parameters['lengthChange'] = 'lengthChange:false';
372 488 }
373 489 if ( 10 !== $js_options['datatables_paginate_entries'] ) {
374 - $parameters['pageLength'] = '"pageLength":' . $js_options['datatables_paginate_entries'];
490 + $parameters['pageLength'] = "pageLength:{$js_options['datatables_paginate_entries']}";
375 491 }
376 492 } else {
377 - $parameters['paging'] = '"paging":false';
493 + $parameters['paging'] = 'paging:false';
378 494 }
379 495 if ( ! $js_options['datatables_filter'] ) {
380 - $parameters['searching'] = '"searching":false';
496 + $parameters['searching'] = 'searching:false';
381 497 }
382 498 if ( ! $js_options['datatables_info'] ) {
383 - $parameters['info'] = '"info":false';
499 + $parameters['info'] = 'info:false';
384 500 }
385 501 if ( $js_options['datatables_scrollx'] ) {
386 - $parameters['scrollX'] = '"scrollX":true';
502 + $parameters['scrollX'] = 'scrollX:true';
387 503 }
388 504 if ( false !== $js_options['datatables_scrolly'] ) {
389 - $parameters['scrollY'] = '"scrollY":"' . preg_replace( '#[^0-9a-z.%]#', '', $js_options['datatables_scrolly'] ) . '"';
390 - $parameters['scrollCollapse'] = '"scrollCollapse":true';
505 + $parameters['scrollY'] = 'scrollY:"' . preg_replace( '#[^0-9a-z.%]#', '', $js_options['datatables_scrolly'] ) . '"';
506 + $parameters['scrollCollapse'] = 'scrollCollapse:true';
391 507 }
392 - if ( ! empty( $js_options['datatables_custom_commands'] ) ) {
393 - $parameters['custom_commands'] = $js_options['datatables_custom_commands'];
508 + if ( '' !== $js_options['datatables_custom_commands'] ) {
509 + $parameters['custom_commands'] = trim( $js_options['datatables_custom_commands'] ); // Remove leading and trailing whitespace.
510 + $parameters['custom_commands'] = trim( $parameters['custom_commands'], ',' ); // Remove potentially leading and trailing commas to prevent JS script errors.
394 511 }
395 512
396 513 /**
397 514 * Filters the parameters that are passed to the DataTables JavaScript library.
@@ -404,21 +521,22 @@
404 521 * @param array<string, mixed> $js_options The options for the JS library.
405 522 */
406 523 $parameters = apply_filters( 'tablepress_datatables_parameters', $parameters, $table_id, $html_id, $js_options );
407 524
408 - // If an existing parameter (in the from `"parameter":`) is set in the "Custom Commands", remove its default value.
409 - if ( isset( $parameters['custom_commands'] ) ) {
410 - foreach ( array_keys( $parameters ) as $maybe_overwritten_parameter ) {
411 - if ( str_contains( $parameters['custom_commands'], "\"{$maybe_overwritten_parameter}\":" ) ) {
412 - unset( $parameters[ $maybe_overwritten_parameter ] );
413 - }
525 + // If an existing parameter is set as an object key in the "Custom Commands", remove its separate value, to allow for full overrides.
526 + if ( isset( $parameters['custom_commands'] ) && '' !== $parameters['custom_commands'] ) {
527 + $parameters_in_custom_commands = TablePress::extract_keys_from_js_object_string( '{' . $parameters['custom_commands'] . '}' );
528 + foreach ( $parameters_in_custom_commands as $parameter_in_custom_commands ) {
529 + unset( $parameters[ $parameter_in_custom_commands ] );
414 530 }
415 531 }
416 532
533 + $name = substr( $html_id, 11 ); // Remove "tablepress-" from the HTML ID.
534 + $name = "DT_TP['" . str_replace( '-', '_', $name ) . "']";
417 535 $parameters = implode( ',', $parameters );
418 536 $parameters = ( ! empty( $parameters ) ) ? '{' . $parameters . '}' : '';
419 537
420 - $command = "$('#{$html_id}').DataTable({$parameters});";
538 + $command = "{$name} = new DataTable('#{$html_id}',{$parameters});";
421 539 /**
422 540 * Filters the JavaScript command that invokes the DataTables JavaScript library on one table.
423 541 *
424 542 * @since 1.0.0
@@ -427,10 +545,11 @@
427 545 * @param string $html_id The ID of the table HTML element.
428 546 * @param string $parameters The parameters for the DataTables JS library.
429 547 * @param string $table_id The current table ID.
430 548 * @param array<string, mixed> $js_options The options for the JS library.
549 + * @param string $name The name of the DataTable instance.
431 550 */
432 - $command = apply_filters( 'tablepress_datatables_command', $command, $html_id, $parameters, $table_id, $js_options );
551 + $command = apply_filters( 'tablepress_datatables_command', $command, $html_id, $parameters, $table_id, $js_options, $name );
433 552 if ( ! empty( $command ) ) {
434 553 $commands[] = $command;
435 554 }
436 555 } // foreach table instance
@@ -437,14 +556,40 @@
437 556 } // foreach table ID
438 557
439 558 // DataTables language/translation handling.
440 559 if ( ! empty( $datatables_language ) ) {
441 - $datatables_language = wp_json_encode( $datatables_language, JSON_HEX_TAG | JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE | JSON_FORCE_OBJECT );
442 - $datatables_language = "var DT_language={$datatables_language};\n";
560 + $datatables_language_command = wp_json_encode( $datatables_language, JSON_HEX_TAG | JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE | JSON_FORCE_OBJECT );
561 + $datatables_language_command = "var DT_language={$datatables_language_command};\n";
443 562 } else {
444 - $datatables_language = '';
563 + $datatables_language_command = '';
445 564 }
446 565
566 + // DataTables datetime format string handling.
567 + if ( ! empty( $this->datatables_datetime_formats ) ) {
568 + // Create a command like `DataTable.datetime('MM/DD/YYYY');DataTable.datetime('DD.MM.YYYY');`.
569 + $datatables_datetime_command = implode(
570 + '',
571 + array_map(
572 + static fn( string $datetime_format ): string => "DataTable.datetime('{$datetime_format}');",
573 + $this->datatables_datetime_formats,
574 + )
575 + ) . "\n";
576 + } else {
577 + $datatables_datetime_command = '';
578 + }
579 +
580 + /**
581 + * Filters the JavaScript code for the DataTables JavaScript library that initializes the automatically detected date/time formats via moment.js.
582 + *
583 + * @since 3.0.0
584 + *
585 + * @param string $datatables_datetime_command The JS code for the DataTables JS library that initializes the date/time formats.
586 + * @param string[] $datatables_datetime_formats The date/time formats for moment.js.
587 + */
588 + $datatables_datetime_command = apply_filters( 'tablepress_datatables_datetime_command', $datatables_datetime_command, $this->datatables_datetime_formats );
589 +
590 + $datatables_pre_commands = $datatables_language_command . $datatables_datetime_command;
591 +
447 592 $commands = implode( "\n", $commands );
448 593 /**
449 594 * Filters the JavaScript commands that invoke the DataTables JavaScript library on all tables on the page.
450 595 *
@@ -456,33 +601,32 @@
456 601 if ( '' === $commands ) {
457 602 return;
458 603 }
459 604
460 - $script_type_attr = current_theme_supports( 'html5', 'script' ) ? '' : ' type="text/javascript"';
461 -
462 - $js_wrapper = <<<'JS'
463 -<script%3$s>
464 -jQuery(function($){
465 -%1$s%2$s
466 -});
467 -</script>
468 -JS;
605 + $script_template = <<<'JS'
606 + var DT_TP = {};
607 + jQuery(($)=>{
608 + %1$s%2$s
609 + });
610 + JS;
469 611 /**
470 612 * Filters the script/jQuery wrapper code for the DataTables commands calls.
471 613 *
472 614 * @since 1.14.0
473 615 *
474 - * @param string $js_wrapper Default script/jQuery wrapper code for the DataTables commands calls.
616 + * @param string $script_template Default script/jQuery wrapper code for the DataTables commands calls.
475 617 */
476 - $js_wrapper = apply_filters( 'tablepress_all_datatables_commands_wrapper', $js_wrapper );
477 - printf( $js_wrapper, $datatables_language, $commands, $script_type_attr );
618 + $script_template = apply_filters( 'tablepress_all_datatables_commands_wrapper', $script_template );
478 619
620 + $script = sprintf( $script_template, $datatables_pre_commands, $commands );
621 + wp_add_inline_script( 'tablepress-datatables', $script );
622 +
479 623 // Prevent repeated execution (which would lead to DataTables error messages) via a static variable.
480 624 $datatables_calls_printed = true;
481 625 }
482 626
483 627 /**
484 - * Handle Shortcode [table id=<ID> /].
628 + * Handles the Shortcode [table id=<ID> /].
485 629 *
486 630 * @since 1.0.0
487 631 *
488 632 * @param array<string, mixed>|string $shortcode_atts List of attributes that where included in the Shortcode. An empty string for empty Shortcodes like [table] or [table /].
@@ -490,8 +634,10 @@
490 634 */
491 635 public function shortcode_table( /* array|string */ $shortcode_atts ): string {
492 636 $shortcode_atts = (array) $shortcode_atts;
493 637
638 + $this->maybe_enqueue_css();
639 +
494 640 $_render = TablePress::load_class( 'TablePress_Render', 'class-render.php', 'classes' );
495 641
496 642 $default_shortcode_atts = $_render->get_default_render_options();
497 643 /**
@@ -559,19 +705,26 @@
559 705 $message = apply_filters( 'tablepress_table_corrupted_message', $message, $table_id, $table['json_error'] );
560 706 return $message;
561 707 }
562 708
563 - /**
564 - * Filters whether the "datatables_custom_commands" Shortcode parameter is disabled.
565 - *
566 - * By default, the "datatables_custom_commands" Shortcode parameter is disabled for security reasons.
567 - *
568 - * @since 1.0.0
569 - *
570 - * @param bool $disable Whether to disable the "datatables_custom_commands" Shortcode parameter. Default true.
571 - */
572 - if ( ! is_null( $shortcode_atts['datatables_custom_commands'] ) && apply_filters( 'tablepress_disable_custom_commands_shortcode_parameter', true ) ) {
573 - $shortcode_atts['datatables_custom_commands'] = null;
709 + if ( ! is_null( $shortcode_atts['datatables_custom_commands'] ) ) {
710 + /**
711 + * Filters whether the "datatables_custom_commands" Shortcode parameter is disabled.
712 + *
713 + * By default, the "datatables_custom_commands" Shortcode parameter is disabled for security reasons.
714 + *
715 + * @since 1.0.0
716 + *
717 + * @param bool $disable Whether to disable the "datatables_custom_commands" Shortcode parameter. Default true.
718 + */
719 + if ( apply_filters( 'tablepress_disable_custom_commands_shortcode_parameter', true ) ) {
720 + $shortcode_atts['datatables_custom_commands'] = null;
721 + } else {
722 + // Convert the HTML entity `&amp;` back to `&` manually, as entities in Shortcodes in normal text paragraphs are sometimes double-encoded.
723 + $shortcode_atts['datatables_custom_commands'] = str_replace( '&amp;', '&', $shortcode_atts['datatables_custom_commands'] );
724 + // Convert HTML entities like `&lt;`, `&lsqb;`, `&#91;`, and `&amp;` back to their respective characters.
725 + $shortcode_atts['datatables_custom_commands'] = html_entity_decode( $shortcode_atts['datatables_custom_commands'], ENT_QUOTES | ENT_HTML5, get_option( 'blog_charset' ) );
726 + }
574 727 }
575 728
576 729 // Determine options to use (if set in Shortcode, use those, otherwise use stored options, from the "Edit" screen).
577 730 $render_options = array();
@@ -594,8 +747,12 @@
594 747 $render_options[ $key ] = $value;
595 748 }
596 749 }
597 750
751 + // Backward compatibility: Convert boolean or numeric string "table_head" and "table_foot" options to integer.
752 + $render_options['table_head'] = absint( $render_options['table_head'] );
753 + $render_options['table_foot'] = absint( $render_options['table_foot'] );
754 +
598 755 // Generate unique HTML ID, depending on how often this table has already been shown on this page.
599 756 if ( ! isset( $this->shown_tables[ $table_id ] ) ) {
600 757 $this->shown_tables[ $table_id ] = array(
601 758 'count' => 0,
@@ -630,9 +787,9 @@
630 787 *
631 788 * @param bool $show Whether to show the "Edit" link below the table. Default true.
632 789 * @param string $table_id The current table ID.
633 790 */
634 - if ( is_user_logged_in() && apply_filters( 'tablepress_edit_link_below_table', true, $table['id'] ) && current_user_can( 'tablepress_edit_table', $table['id'] ) ) {
791 + if ( is_user_logged_in() && ! $render_options['block_preview'] && apply_filters( 'tablepress_edit_link_below_table', true, $table['id'] ) && current_user_can( 'tablepress_edit_table', $table['id'] ) ) {
635 792 $render_options['edit_table_url'] = TablePress::url( array( 'action' => 'edit', 'table_id' => $table['id'] ) );
636 793 }
637 794
638 795 /**
@@ -646,12 +803,16 @@
646 803 * @param array<string, mixed> $table The current table.
647 804 */
648 805 $render_options = apply_filters( 'tablepress_table_render_options', $render_options, $table );
649 806
807 + // Backward compatibility: Convert boolean "table_head" and "table_foot" options to integer, in case they were overwritten via the filter hook.
808 + $render_options['table_head'] = absint( $render_options['table_head'] );
809 + $render_options['table_foot'] = absint( $render_options['table_foot'] );
810 +
650 811 // Check if table output shall and can be loaded from the transient cache, otherwise generate the output.
651 812 if ( $render_options['cache_table_output'] && ! is_user_logged_in() ) {
652 813 // Hash the Render Options array to get a unique cache identifier.
653 - $table_hash = md5( wp_json_encode( $render_options, TABLEPRESS_JSON_OPTIONS ) ); // @phpstan-ignore-line
814 + $table_hash = md5( wp_json_encode( $render_options, TABLEPRESS_JSON_OPTIONS ) ); // @phpstan-ignore argument.type
654 815 $transient_name = 'tablepress_' . $table_hash; // Attention: This string must not be longer than 45 characters!
655 816 $output = get_transient( $transient_name );
656 817 if ( false === $output || '' === $output ) {
657 818 // Render/generate the table HTML, as it was not found in the cache.
@@ -688,13 +849,11 @@
688 849 }
689 850
690 851 // If DataTables is to be and can be used with this instance of a table, process its parameters and register the call for inclusion in the footer.
691 852 if ( $render_options['use_datatables']
692 - && $render_options['table_head']
693 - && str_contains( $output, '<thead' ) // A `<thead>` tag is required.
694 - && ! str_contains( $output, ' colspan="' ) // `colspan` attributes are forbidden.
695 - && ! str_contains( $output, ' rowspan="' ) // `rowspan` attributes are forbidden.
696 - ) {
853 + && 0 < $render_options['table_head']
854 + && ! str_contains( $output, 'tbody-has-connected-cells' ) // The Render class adds this CSS class to the `<table>` element if the table has connected cells in the `<tbody>`.
855 + ) {
697 856 // Get options for the DataTables JavaScript library from the table's render options.
698 857 $js_options = array();
699 858 foreach ( array(
700 859 'alternating_row_colors',
@@ -724,10 +883,21 @@
724 883 * @param string $table_id The current table ID.
725 884 * @param array<string, mixed> $render_options The render options for the table.
726 885 */
727 886 $js_options = apply_filters( 'tablepress_table_js_options', $js_options, $table_id, $render_options );
887 +
728 888 $this->shown_tables[ $table_id ]['instances'][ (string) $render_options['html_id'] ] = $js_options;
729 - $this->_enqueue_datatables();
889 +
890 + // DataTables datetime format string handling.
891 + if ( '' !== $render_options['datatables_datetime'] ) {
892 + $render_options['datatables_datetime'] = explode( '|', $render_options['datatables_datetime'] );
893 + foreach ( $render_options['datatables_datetime'] as $datetime_format ) {
894 + $datetime_format = trim( $datetime_format );
895 + if ( '' !== $datetime_format && ! in_array( $datetime_format, $this->datatables_datetime_formats, true ) ) {
896 + $this->datatables_datetime_formats[] = $datetime_format;
897 + }
898 + }
899 + }
730 900 }
731 901
732 902 // Maybe print a list of used render options.
733 903 if ( $render_options['shortcode_debug'] && is_user_logged_in() ) {
@@ -737,9 +907,9 @@
737 907 return $output;
738 908 }
739 909
740 910 /**
741 - * Handle Shortcode [table-info id=<ID> field=<name> /].
911 + * Handles the Shortcode [table-info id=<ID> field=<name> /].
742 912 *
743 913 * @since 1.0.0
744 914 *
745 915 * @param array<string, mixed>|string $shortcode_atts List of attributes that where included in the Shortcode. An empty string for empty Shortcodes like [table] or [table /].
@@ -853,14 +1023,10 @@
853 1023 break;
854 1024 case 'number_rows':
855 1025 $output = count( $table['data'] );
856 1026 if ( 'raw' !== $format ) {
857 - if ( $table['options']['table_head'] ) {
858 - --$output;
859 - }
860 - if ( $table['options']['table_foot'] ) {
861 - --$output;
862 - }
1027 + $output -= $table['options']['table_head'];
1028 + $output -= $table['options']['table_foot'];
863 1029 }
864 1030 break;
865 1031 case 'number_columns':
866 1032 $output = count( $table['data'][0] );
@@ -893,9 +1059,9 @@
893 1059 return $output;
894 1060 }
895 1061
896 1062 /**
897 - * Expand WP Search to also find posts and pages that have a search term in a table that is shown in them.
1063 + * Expands the WP Search to also find posts and pages that have a search term in a table that is shown in them.
898 1064 *
899 1065 * This is done by looping through all search terms and TablePress tables and searching there for the search term,
900 1066 * saving all tables's IDs that have a search term and then expanding the WP query to search for posts or pages that have the
901 1067 * Shortcode for one of these tables in their content.
@@ -912,9 +1078,9 @@
912 1078
913 1079 global $wpdb;
914 1080
915 1081 // Protect against cases where `null` is somehow passed to the filter hook callback.
916 - if ( ! is_string( $search_sql ) ) {
1082 + if ( ! is_string( $search_sql ) ) { // @phpstan-ignore function.alreadyNarrowedType (The `is_string()` check is needed as the input is coming from a filter hook.)
917 1083 return '';
918 1084 }
919 1085
920 1086 if ( ! is_search() || ! is_main_query() ) {
@@ -931,8 +1097,10 @@
931 1097 $table_ids = TablePress::$model_table->load_all( true, false );
932 1098 // Array of all search words that were found, and the table IDs where they were found.
933 1099 $query_result = array();
934 1100
1101 + $fn_stripos = function_exists( 'mb_stripos' ) ? 'mb_stripos' : 'stripos';
1102 +
935 1103 foreach ( $table_ids as $table_id ) {
936 1104 // Load table, with table data, options, and visibility settings.
937 1105 $table = TablePress::$model_table->load( $table_id, true, true );
938 1106
@@ -946,10 +1114,10 @@
946 1114 continue;
947 1115 }
948 1116
949 1117 foreach ( $search_terms as $search_term ) {
950 - if ( ( $table['options']['print_name'] && false !== stripos( $table['name'], $search_term ) )
951 - || ( $table['options']['print_description'] && false !== stripos( $table['description'], $search_term ) ) ) {
1118 + if ( ( $table['options']['print_name'] && false !== $fn_stripos( $table['name'], (string) $search_term ) )
1119 + || ( $table['options']['print_description'] && false !== $fn_stripos( $table['description'], (string) $search_term ) ) ) {
952 1120 // Found the search term in the name or description (and they are shown).
953 1121 $query_result[ $search_term ][] = $table_id; // Add table ID to result list.
954 1122 // No need to continue searching this search term in this table.
955 1123 continue;
@@ -966,9 +1134,9 @@
966 1134 // Column is hidden, so don't search in it.
967 1135 continue;
968 1136 }
969 1137 // @todo Cells are not evaluated here, so math formulas are searched.
970 - if ( false !== stripos( $table_cell, $search_term ) ) {
1138 + if ( false !== $fn_stripos( $table_cell, (string) $search_term ) ) {
971 1139 // Found the search term in the cell content.
972 1140 $query_result[ $search_term ][] = $table_id; // Add table ID to result list
973 1141 // No need to continue searching this search term in this table.
974 1142 continue 3;
@@ -985,9 +1153,9 @@
985 1153 $n = ( empty( $exact ) ) ? '%' : '';
986 1154 $search_sql = $wpdb->remove_placeholder_escape( $search_sql );
987 1155 foreach ( $query_result as $search_term => $table_ids ) {
988 1156 $search_term = esc_sql( $wpdb->esc_like( $search_term ) );
989 - $old_or = "OR ({$wpdb->posts}.post_content LIKE '{$n}{$search_term}{$n}')"; // @phpstan-ignore-line (The esc_sql() call above returns a string, as a string is passed.)
1157 + $old_or = "OR ({$wpdb->posts}.post_content LIKE '{$n}{$search_term}{$n}')"; // @phpstan-ignore encapsedStringPart.nonString (The esc_sql() call above returns a string, as a string is passed.)
990 1158 $table_ids = implode( '|', $table_ids );
991 1159 $regexp = '\\\\[' . TablePress::$shortcode . ' id=(["\\\']?)(' . $table_ids . ')([\]"\\\' /])'; // ' needs to be single escaped, [ double escaped (with \\) in mySQL
992 1160 $new_or = $old_or . " OR ({$wpdb->posts}.post_content REGEXP '{$regexp}')";
993 1161 $search_sql = str_replace( $old_or, $new_or, $search_sql );
@@ -1018,7 +1186,47 @@
1018 1186 }
1019 1187 $render_attributes['id'] = $block_attributes['id'];
1020 1188
1021 1189 return $this->shortcode_table( $render_attributes );
1190 + }
1191 +
1192 + /**
1193 + * Registers the TablePress Elementor widgets.
1194 + *
1195 + * @since 3.1.0
1196 + *
1197 + * @param \Elementor\Widgets_Manager $widgets_manager Elementor widgets manager.
1198 + */
1199 + public function register_elementor_widgets( \Elementor\Widgets_Manager $widgets_manager ): void {
1200 + TablePress::load_file( 'class-elementor-widget-table.php', 'classes' );
1201 + $widgets_manager->register( new TablePress\Elementor\TablePressTableWidget() ); // @phpstan-ignore method.notFound (Elementor methods are not in the stubs.)
1202 + }
1203 +
1204 + /**
1205 + * Enqueues the TablePress Elementor Editor CSS styles.
1206 + *
1207 + * @since 3.1.0
1208 + */
1209 + public function enqueue_elementor_editor_styles(): void {
1210 + $svg_url = plugins_url( 'admin/img/tablepress-editor-button.svg', TABLEPRESS__FILE__ );
1211 + wp_register_style( 'tablepress-elementor', false ); // phpcs:ignore WordPress.WP.EnqueuedResourceParameters.MissingVersion
1212 + wp_add_inline_style(
1213 + 'tablepress-elementor',
1214 + <<<CSS
1215 + .elementor-panel .elementor-element .icon:has(> .tablepress-elementor-icon) {
1216 + height: 43.5px;
1217 + }
1218 + .tablepress-elementor-icon {
1219 + display: inline-block;
1220 + height: 28px;
1221 + width: 28px;
1222 + background-image: url({$svg_url});
1223 + background-repeat: no-repeat;
1224 + background-position: center;
1225 + background-size: 28px auto;
1226 + }
1227 + CSS
1228 + );
1229 + wp_enqueue_style( 'tablepress-elementor' );
1022 1230 }
1023 1231
1024 1232 } // class TablePress_Frontend_Controller