DGet.php

Go to the documentation of this file.

<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\Database;

use PhpOffice\PhpSpreadsheet\Calculation\Functions;

class DGet extends DatabaseAbstract
{
    public static function evaluate($database, $field, $criteria)
    {
        $field = self::fieldExtract($database, $field);
        if ($field === null) {
            return null;
        }

        $columnData = self::getFilteredColumn($database, $field, $criteria);
        if (count($columnData) > 1) {
            return Functions::NAN();
        }

        $row = array_pop($columnData);

        return array_pop($row);
    }
}