enum_types.php

<?php declare(strict_types=1);

/** Use <select><option> for enum edit instead of regular input text on enum type in PostgreSQL
 *
 * @see     https://www.adminer.org/plugins/#use
 *
 * @author  Adam Kuśmierz, http://kusmierz.be/
 * @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
 * @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
 */
class AdminerEnumTypes
{
    public $_types = null;

    /**
     * @param $table
     * @param $field
     * @param $attrs
     * @param $value
     *
     * @return string|void
     */
    public function editInput($table, $field, $attrs, $value)
    {
        // PostgreSQL only
        if (!in_array(strtolower(connection()->extension), [
            'pgsql',
            'pdo_pgsql',
        ])) {
            return;
        }

        // read types and "cache" it
        if (is_null($this->_types)) {
            $types = types();
            $this->_types = [];

            foreach ($types as $type) {
                $values = get_vals("SELECT unnest(enum_range(NULL::$type))::text AS value");
                if (!empty($values) && is_array($values)) {
                    $this->_types[$type] = $values;
                }
            }
        }

        if (array_key_exists($field['type'], $this->_types)) {
            $options = $this->_types[$field['type']];
            $options = array_combine($options, $options);
            $selected = $value;

            if ($field['null']) {
                $options = ['' => ['' => 'NULL']] + $options;
                if ($value === null && !isset($_GET['select'])) {
                    $selected = '';
                }
            }
            if (isset($_GET['select'])) {
                $options = ['' => [-1 => lang('original')]] + $options;
            }

            return "<select$attrs>" . optionlist($options, (string) $selected, 1) . '</select>';
        }
    }
}