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 +381 -164 2.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_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 /].
@@ -819,9 +989,13 @@
819 989 $output = $table['last_modified'];
820 990 break;
821 991 case 'human':
822 992 $modified_timestamp = date_create( $table['last_modified'], wp_timezone() );
823 - $modified_timestamp = $modified_timestamp->getTimestamp(); // @phpstan-ignore-line
993 + if ( false === $modified_timestamp ) {
994 + $modified_timestamp = $table['last_modified'];
995 + } else {
996 + $modified_timestamp = $modified_timestamp->getTimestamp();
997 + }
824 998 $current_timestamp = time();
825 999 $time_diff = $current_timestamp - $modified_timestamp;
826 1000 // Time difference is only shown up to one week.
827 1001 if ( $time_diff >= 0 && $time_diff < WEEK_IN_SECONDS ) {
@@ -849,14 +1023,10 @@
849 1023 break;
850 1024 case 'number_rows':
851 1025 $output = count( $table['data'] );
852 1026 if ( 'raw' !== $format ) {
853 - if ( $table['options']['table_head'] ) {
854 - --$output;
855 - }
856 - if ( $table['options']['table_foot'] ) {
857 - --$output;
858 - }
1027 + $output -= $table['options']['table_head'];
1028 + $output -= $table['options']['table_foot'];
859 1029 }
860 1030 break;
861 1031 case 'number_columns':
862 1032 $output = count( $table['data'][0] );
@@ -889,9 +1059,9 @@
889 1059 return $output;
890 1060 }
891 1061
892 1062 /**
893 - * 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.
894 1064 *
895 1065 * This is done by looping through all search terms and TablePress tables and searching there for the search term,
896 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
897 1067 * Shortcode for one of these tables in their content.
@@ -908,9 +1078,9 @@
908 1078
909 1079 global $wpdb;
910 1080
911 1081 // Protect against cases where `null` is somehow passed to the filter hook callback.
912 - 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.)
913 1083 return '';
914 1084 }
915 1085
916 1086 if ( ! is_search() || ! is_main_query() ) {
@@ -927,20 +1097,27 @@
927 1097 $table_ids = TablePress::$model_table->load_all( true, false );
928 1098 // Array of all search words that were found, and the table IDs where they were found.
929 1099 $query_result = array();
930 1100
1101 + $fn_stripos = function_exists( 'mb_stripos' ) ? 'mb_stripos' : 'stripos';
1102 +
931 1103 foreach ( $table_ids as $table_id ) {
932 1104 // Load table, with table data, options, and visibility settings.
933 1105 $table = TablePress::$model_table->load( $table_id, true, true );
934 1106
1107 + // Skip tables that could not be loaded.
1108 + if ( is_wp_error( $table ) ) {
1109 + continue;
1110 + }
1111 +
1112 + // Do not search in corrupted tables.
935 1113 if ( isset( $table['is_corrupted'] ) && $table['is_corrupted'] ) {
936 - // Do not search in corrupted tables.
937 1114 continue;
938 1115 }
939 1116
940 1117 foreach ( $search_terms as $search_term ) {
941 - if ( ( $table['options']['print_name'] && false !== stripos( $table['name'], $search_term ) ) // @phpstan-ignore-line
942 - || ( $table['options']['print_description'] && false !== stripos( $table['description'], $search_term ) ) ) { // @phpstan-ignore-line
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 ) ) ) {
943 1120 // Found the search term in the name or description (and they are shown).
944 1121 $query_result[ $search_term ][] = $table_id; // Add table ID to result list.
945 1122 // No need to continue searching this search term in this table.
946 1123 continue;
@@ -946,9 +1123,9 @@
946 1123 continue;
947 1124 }
948 1125
949 1126 // Search search term in visible table cells (without taking Shortcode parameters into account!).
950 - foreach ( $table['data'] as $row_idx => $table_row ) { // @phpstan-ignore-line
1127 + foreach ( $table['data'] as $row_idx => $table_row ) {
951 1128 if ( 0 === $table['visibility']['rows'][ $row_idx ] ) {
952 1129 // Row is hidden, so don't search in it.
953 1130 continue;
954 1131 }
@@ -957,9 +1134,9 @@
957 1134 // Column is hidden, so don't search in it.
958 1135 continue;
959 1136 }
960 1137 // @todo Cells are not evaluated here, so math formulas are searched.
961 - if ( false !== stripos( $table_cell, $search_term ) ) {
1138 + if ( false !== $fn_stripos( $table_cell, (string) $search_term ) ) {
962 1139 // Found the search term in the cell content.
963 1140 $query_result[ $search_term ][] = $table_id; // Add table ID to result list
964 1141 // No need to continue searching this search term in this table.
965 1142 continue 3;
@@ -976,9 +1153,9 @@
976 1153 $n = ( empty( $exact ) ) ? '%' : '';
977 1154 $search_sql = $wpdb->remove_placeholder_escape( $search_sql );
978 1155 foreach ( $query_result as $search_term => $table_ids ) {
979 1156 $search_term = esc_sql( $wpdb->esc_like( $search_term ) );
980 - $old_or = "OR ({$wpdb->posts}.post_content LIKE '{$n}{$search_term}{$n}')"; // @phpstan-ignore-line
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.)
981 1158 $table_ids = implode( '|', $table_ids );
982 1159 $regexp = '\\\\[' . TablePress::$shortcode . ' id=(["\\\']?)(' . $table_ids . ')([\]"\\\' /])'; // ' needs to be single escaped, [ double escaped (with \\) in mySQL
983 1160 $new_or = $old_or . " OR ({$wpdb->posts}.post_content REGEXP '{$regexp}')";
984 1161 $search_sql = str_replace( $old_or, $new_or, $search_sql );
@@ -1006,10 +1183,50 @@
1006 1183 $render_attributes = shortcode_parse_atts( $block_attributes['parameters'] );
1007 1184 } else {
1008 1185 $render_attributes = array();
1009 1186 }
1010 - $render_attributes['id'] = $block_attributes['id']; // @phpstan-ignore-line
1187 + $render_attributes['id'] = $block_attributes['id'];
1011 1188
1012 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' );
1013 1230 }
1014 1231
1015 1232 } // class TablePress_Frontend_Controller