limit = $limit; } public function getFieldInput($table, array $field, $attrs, $value, $function) { if (!$table) { return null; } if (!isset($this->foreignTables[$table])) { $this->foreignTables[$table] = column_foreign_keys($table); } $foreignKeys = $this->foreignTables[$table]; if (!isset($foreignKeys[$field["field"]])) { return null; } foreach ($foreignKeys[$field["field"]] as $foreignKey) { if (count($foreignKey["source"]) != 1) { continue; } $ns = $foreignKey["ns"]; $target = $foreignKey["table"]; $key = "$ns.$target"; $id = $foreignKey["target"][0]; if (!isset($this->foreignOptions[$key][$id])) { $column = idf_escape($id); if (preg_match('~binary~', $field["type"])) { $column = "HEX($column)"; } $values = get_vals("SELECT $column FROM " . ($ns ? idf_escape($ns) . "." : "") . table($target) . " ORDER BY 1 LIMIT " . ($this->limit + 1)); if (Connection::get()->getError() || count($values) > $this->limit) { $this->foreignOptions[$key][$id] = false; } else { $this->foreignOptions[$key][$id] = ["" => ""] + $values; } } if ($options = $this->foreignOptions[$key][$id]) { return "" . optionlist($options, $value) . ""; } else { return null; } } return null; } }