Collaboration diagram for PHPExcel_Calculation_Database:

Static Public Member Functions
static	DAVERAGE ($database, $field, $criteria)

static	DCOUNT ($database, $field, $criteria)

static	DCOUNTA ($database, $field, $criteria)

static	DGET ($database, $field, $criteria)

static	DMAX ($database, $field, $criteria)

static	DMIN ($database, $field, $criteria)

static	DPRODUCT ($database, $field, $criteria)

static	DSTDEV ($database, $field, $criteria)

static	DSTDEVP ($database, $field, $criteria)

static	DSUM ($database, $field, $criteria)

static	DVAR ($database, $field, $criteria)

static	DVARP ($database, $field, $criteria)

Static Private Member Functions
static	__fieldExtract ($database, $field)
	__fieldExtract More...

static	__filter ($database, $criteria)
	__filter More...

Detailed Description

Definition at line 46 of file Database.php.

Member Function Documentation

◆ __fieldExtract()

static PHPExcel_Calculation_Database::__fieldExtract	(	$database,
		$field
	)

staticprivate

__fieldExtract

Extracts the column ID to use for the data field.

@access private

Parameters

mixed[]	$database	The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
mixed	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

Returns: string|NULL

Definition at line 67 of file Database.php.

                                                                 {
                $field = strtoupper(PHPExcel_Calculation_Functions::flattenSingleValue($field));
                $fieldNames = array_map('strtoupper',array_shift($database));
 
                if (is_numeric($field)) {
                        $keys = array_keys($fieldNames);
                        return $keys[$field-1];
                }
                $key = array_search($field,$fieldNames);
                return ($key) ? $key : NULL;
        }

References $key, $keys, and PHPExcel_Calculation_Functions\flattenSingleValue().

Referenced by DAVERAGE(), DCOUNT(), DCOUNTA(), DGET(), DMAX(), DMIN(), DPRODUCT(), DSTDEV(), DSTDEVP(), DSUM(), DVAR(), and DVARP().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __filter()

static PHPExcel_Calculation_Database::__filter	(	$database,
		$criteria
	)

staticprivate

__filter

Parses the selection criteria, extracts the database rows that match those criteria, and returns that subset of rows.

@access private

Parameters

mixed[]	$database	The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
mixed[]	$criteria	The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: array of mixed

Definition at line 98 of file Database.php.

                                                              {
                $fieldNames = array_shift($database);
                $criteriaNames = array_shift($criteria);
 
                //      Convert the criteria into a set of AND/OR conditions with [:placeholders]
                $testConditions = $testValues = array();
                $testConditionsCount = 0;
                foreach($criteriaNames as $key => $criteriaName) {
                        $testCondition = array();
                        $testConditionCount = 0;
                        foreach($criteria as $row => $criterion) {
                                if ($criterion[$key] > '') {
                                        $testCondition[] = '[:'.$criteriaName.']'.PHPExcel_Calculation_Functions::_ifCondition($criterion[$key]);
                                        $testConditionCount++;
                                }
                        }
                        if ($testConditionCount > 1) {
                                $testConditions[] = 'OR('.implode(',',$testCondition).')';
                                $testConditionsCount++;
                        } elseif($testConditionCount == 1) {
                                $testConditions[] = $testCondition[0];
                                $testConditionsCount++;
                        }
                }
 
                if ($testConditionsCount > 1) {
                        $testConditionSet = 'AND('.implode(',',$testConditions).')';
                } elseif($testConditionsCount == 1) {
                        $testConditionSet = $testConditions[0];
                }
 
                //      Loop through each row of the database
                foreach($database as $dataRow => $dataValues) {
                        //      Substitute actual values from the database row for our [:placeholders]
                        $testConditionList = $testConditionSet;
                        foreach($criteriaNames as $key => $criteriaName) {
                                $k = array_search($criteriaName,$fieldNames);
                                if (isset($dataValues[$k])) {
                                        $dataValue = $dataValues[$k];
                                        $dataValue = (is_string($dataValue)) ? PHPExcel_Calculation::_wrapResult(strtoupper($dataValue)) : $dataValue;
                                        $testConditionList = str_replace('[:'.$criteriaName.']',$dataValue,$testConditionList);
                                }
                        }
                        //      evaluate the criteria against the row data
                        $result = PHPExcel_Calculation::getInstance()->_calculateFormulaValue('='.$testConditionList);
                        //      If the row failed to meet the criteria, remove it from the database
                        if (!$result) {
                                unset($database[$dataRow]);
                        }
                }
 
                return $database;
        }

References $key, $result, $row, PHPExcel_Calculation_Functions\_ifCondition(), PHPExcel_Calculation\_wrapResult(), and PHPExcel_Calculation\getInstance().

Referenced by DAVERAGE(), DCOUNT(), DCOUNTA(), DGET(), DMAX(), DMIN(), DPRODUCT(), DSTDEV(), DSTDEVP(), DSUM(), DVAR(), and DVARP().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ DAVERAGE()

static PHPExcel_Calculation_Database::DAVERAGE	(	$database,
		$field,
		$criteria
	)

static

Definition at line 180 of file Database.php.

                                                                    {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::AVERAGE($colData);
        }       //      function DAVERAGE()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\AVERAGE().

Here is the call graph for this function:

◆ DCOUNT()

static PHPExcel_Calculation_Database::DCOUNT	(	$database,
		$field,
		$criteria
	)

static

Definition at line 232 of file Database.php.

                                                                  {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::COUNT($colData);
        }       //      function DCOUNT()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\COUNT().

Here is the call graph for this function:

◆ DCOUNTA()

static PHPExcel_Calculation_Database::DCOUNTA	(	$database,
		$field,
		$criteria
	)

static

Definition at line 281 of file Database.php.

                                                                   {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::COUNTA($colData);
        }       //      function DCOUNTA()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\COUNTA().

Here is the call graph for this function:

◆ DGET()

static PHPExcel_Calculation_Database::DGET	(	$database,
		$field,
		$criteria
	)

static

Definition at line 328 of file Database.php.

                                                                {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                if (count($colData) > 1) {
                        return PHPExcel_Calculation_Functions::NaN();
                }
 
                return $colData[0];
        }       //      function DGET()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Functions\NaN().

Here is the call graph for this function:

◆ DMAX()

static PHPExcel_Calculation_Database::DMAX	(	$database,
		$field,
		$criteria
	)

static

Definition at line 379 of file Database.php.

                                                                {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::MAX($colData);
        }       //      function DMAX()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\MAX().

Here is the call graph for this function:

◆ DMIN()

static PHPExcel_Calculation_Database::DMIN	(	$database,
		$field,
		$criteria
	)

static

Definition at line 426 of file Database.php.

                                                                {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::MIN($colData);
        }       //      function DMIN()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\MIN().

Here is the call graph for this function:

◆ DPRODUCT()

static PHPExcel_Calculation_Database::DPRODUCT	(	$database,
		$field,
		$criteria
	)

static

Definition at line 472 of file Database.php.

                                                                    {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_MathTrig::PRODUCT($colData);
        }       //      function DPRODUCT()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_MathTrig\PRODUCT().

Here is the call graph for this function:

◆ DSTDEV()

static PHPExcel_Calculation_Database::DSTDEV	(	$database,
		$field,
		$criteria
	)

static

Definition at line 519 of file Database.php.

                                                                  {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::STDEV($colData);
        }       //      function DSTDEV()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\STDEV().

Here is the call graph for this function:

◆ DSTDEVP()

static PHPExcel_Calculation_Database::DSTDEVP	(	$database,
		$field,
		$criteria
	)

static

Definition at line 566 of file Database.php.

                                                                   {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::STDEVP($colData);
        }       //      function DSTDEVP()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\STDEVP().

Here is the call graph for this function:

◆ DSUM()

static PHPExcel_Calculation_Database::DSUM	(	$database,
		$field,
		$criteria
	)

static

Definition at line 612 of file Database.php.

                                                                {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_MathTrig::SUM($colData);
        }       //      function DSUM()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_MathTrig\SUM().

Here is the call graph for this function:

◆ DVAR()

static PHPExcel_Calculation_Database::DVAR	(	$database,
		$field,
		$criteria
	)

static

Definition at line 659 of file Database.php.

                                                                {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::VARFunc($colData);
        }       //      function DVAR()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\VARFunc().

Here is the call graph for this function:

◆ DVARP()

static PHPExcel_Calculation_Database::DVARP	(	$database,
		$field,
		$criteria
	)

static

Definition at line 706 of file Database.php.

                                                                 {
                $field = self::__fieldExtract($database,$field);
                if (is_null($field)) {
                        return NULL;
                }
 
                //      reduce the database to a set of rows that match all the criteria
                $database = self::__filter($database,$criteria);
                //      extract an array of values for the requested column
                $colData = array();
                foreach($database as $row) {
                        $colData[] = $row[$field];
                }
 
                // Return
                return PHPExcel_Calculation_Statistical::VARP($colData);
        }       //      function DVARP()

References $row, __fieldExtract(), __filter(), and PHPExcel_Calculation_Statistical\VARP().

Here is the call graph for this function:

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php

Static Public Member Functions

Static Private Member Functions

Detailed Description

Member Function Documentation

◆ __fieldExtract()

◆ __filter()

◆ DAVERAGE()

◆ DCOUNT()

◆ DCOUNTA()

◆ DGET()

◆ DMAX()

◆ DMIN()

◆ DPRODUCT()

◆ DSTDEV()

◆ DSTDEVP()

◆ DSUM()

◆ DVAR()

◆ DVARP()