lagdo / jaxon-dbadmin

src/Page/Dml/DataRowReader.php

<?php

namespace Lagdo\DbAdmin\Db\Page\Dml;

use Lagdo\DbAdmin\Db\Page\AppPage;
use Lagdo\DbAdmin\Driver\DriverInterface;
use Lagdo\DbAdmin\Driver\Entity\TableFieldEntity;
use Lagdo\DbAdmin\Driver\Entity\UserTypeEntity;
use Lagdo\DbAdmin\Driver\Utils\Utils;

use function count;
use function implode;
use function is_array;
use function is_string;
use function json_decode;
use function preg_match;
use function substr;

/**
 * Reads data from the user inputs for data row insert and update.
 */
class DataRowReader
{
    /**
     * @var array<UserTypeEntity>
     */
    private array $userTypes;

    /**
     * The constructor
     *
     * @param AppPage $page
     * @param DriverInterface $driver
     * @param Utils $utils
     */
    public function __construct(private AppPage $page,
        private DriverInterface $driver, private Utils $utils)
    {
        $this->userTypes = $this->driver->userTypes(true);
    }

    /**
     * Get the user input values for data save on insert and update
     * Function process_input() in html.inc.php.
     *
     * @param TableFieldEntity $field
     * @param array $values
     *
     * @return mixed
     */
    private function getInputValue(TableFieldEntity $field, array $values): mixed
    {
        if ($field->isDisabled()) {
            return false;
        }

        $fieldId = $this->driver->bracketEscape($field->name);
        $value = $values['fields'][$fieldId];

        $userType = $this->userTypes[$field->type] ?? null;
        $enumValues = $userType?->enums ?? [];
        if ($field->type === "enum" || count($enumValues) > 0) {
            $value = $value[0];
            if ($value === "orig") {
                return false;
            }
            if ($value === "null") {
                return "NULL";
            }

            $value = substr($value, 4); // 4 - strlen("val-")
        }

        if ($field->autoIncrement && $value === '') {
            return null;
        }

        // The function is not provided for auto-incremented fields or enums.
        $function = $values['function'][$fieldId] ?? '';
        if ($function === 'orig') {
            return preg_match('~^CURRENT_TIMESTAMP~i', $field->onUpdate) ?
                $this->driver->escapeId($field->name) : false;
        }

        if ($function === 'NULL') {
            return 'NULL';
        }

        if ($field->type === 'set') {
            $value = implode(',', (array)$value);
        }

        if ($function === 'json') {
            $function = '';

The assignment to $function is dead and can be removed.

            $value = json_decode($value, true);
            //! report errors
            return is_array($value) ? $value : false;
        }

        if ($this->utils->isBlob($field) && $this->utils->iniBool('file_uploads')) {
            $file = $this->page->getFileContents("fields-$fieldId");
            //! report errors
            return is_string($file) ? $this->driver->quoteBinary($file) : false;
        }

        return $this->page->getUnconvertedFieldValue($field, $value, $function);
    }

    /**
     * @param array<TableFieldEntity> $fields The table fields
     * @param array $inputs The user form inputs
     *
     * @return array
     */
    public function getInputValues(array $fields, array $inputs): array
    {
        // From edit.inc.php
        $values = [];
        foreach ($fields as $name => $field) {
            $value = $this->getInputValue($field, $inputs);
            if ($value !== false && $value !== null) {
                $values[$this->driver->escapeId($name)] = $value;
            }
        }

        return $values;
    }
}