You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
82 lines
2.5 KiB
82 lines
2.5 KiB
9 months ago
|
<?php
|
||
|
|
/**
|
||
|
|
* TablePress Formula Evaluation Class
|
||
|
|
*
|
||
|
|
* @package TablePress
|
||
|
|
* @subpackage Formulas
|
||
|
|
* @author Tobias Bäthge
|
||
|
|
* @since 1.5.0
|
||
|
|
*/
|
||
|
|
|
||
|
|
// Prohibit direct script loading.
|
||
|
|
defined( 'ABSPATH' ) || die( 'No direct script access allowed!' );
|
||
|
|
|
||
|
|
/**
|
||
|
|
* TablePress Formula Evaluation Class
|
||
|
|
*
|
||
|
|
* Before TablePress 1.5, this was part of the TablePress_Render class.
|
||
|
|
*
|
||
|
|
* @package TablePress
|
||
|
|
* @subpackage Formulas
|
||
|
|
* @author Tobias Bäthge
|
||
|
|
* @since 1.5.0
|
||
|
|
*/
|
||
|
|
class TablePress_Evaluate {
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Checks whether the requirements for the PHPSpreadsheet evaluate class are fulfilled or if the legacy evaluate class should be used.
|
||
|
|
*
|
||
|
|
* @since 2.0.0
|
||
|
|
*
|
||
|
|
* @return bool Whether the legacy evaluate class should be used.
|
||
|
|
*/
|
||
|
|
protected function _should_use_legacy_evaluate_class(): bool {
|
||
|
|
/**
|
||
|
|
* Filters whether the Legacy Table Evaluate class shall be used.
|
||
|
|
*
|
||
|
|
* @since 2.0.0
|
||
|
|
*
|
||
|
|
* @param bool $use_legacy_class Whether to use the legacy table evaluate class. Default false.
|
||
|
|
*/
|
||
|
|
if ( apply_filters( 'tablepress_use_legacy_table_evaluate_class', false ) ) {
|
||
|
|
return true;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Use the legacy evaluate class, if the requirements for PHPSpreadsheet Calculations are not fulfilled.
|
||
|
|
$phpspreadsheet_requirements_fulfilled = extension_loaded( 'mbstring' );
|
||
|
|
if ( ! $phpspreadsheet_requirements_fulfilled ) {
|
||
|
|
return true;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Use the legacy evaluate class, if the PHPSpreadsheet files do not exist (e.g. because `composer install` was not run).
|
||
|
|
if ( ! file_exists( TABLEPRESS_ABSPATH . 'libraries/autoload.php' ) ) {
|
||
|
|
return true;
|
||
|
|
}
|
||
|
|
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Evaluate formulas in the passed table.
|
||
|
|
*
|
||
|
|
* @since 1.0.0
|
||
|
|
*
|
||
|
|
* @param array<int, array<int, string>> $table_data Table data in which formulas shall be evaluated.
|
||
|
|
* @param string $table_id ID of the passed table.
|
||
|
|
* @return array<int, array<int, string>> Table data with evaluated formulas.
|
||
|
|
*/
|
||
|
|
public function evaluate_table_data( array $table_data, string $table_id ): array {
|
||
|
|
$use_legacy_evaluate_class = $this->_should_use_legacy_evaluate_class();
|
||
|
|
|
||
|
|
// Choose the Table Evaluate library based on the PHP version and the filter hook value.
|
||
|
|
if ( $use_legacy_evaluate_class ) {
|
||
|
|
$evaluate_class = TablePress::load_class( 'TablePress_Evaluate_Legacy', 'class-evaluate-legacy.php', 'classes' );
|
||
|
|
} else {
|
||
|
|
$evaluate_class = TablePress::load_class( 'TablePress_Evaluate_PHPSpreadsheet', 'class-evaluate-phpspreadsheet.php', 'classes' );
|
||
|
|
}
|
||
|
|
|
||
|
|
return $evaluate_class->evaluate_table_data( $table_data, $table_id );
|
||
|
|
}
|
||
|
|
|
||
|
|
} // class TablePress_Evaluate
|