<?php
use Twig\Environment;
use Twig\Error\LoaderError;
use Twig\Error\RuntimeError;
use Twig\Extension\CoreExtension;
use Twig\Extension\SandboxExtension;
use Twig\Markup;
use Twig\Sandbox\SecurityError;
use Twig\Sandbox\SecurityNotAllowedTagError;
use Twig\Sandbox\SecurityNotAllowedFilterError;
use Twig\Sandbox\SecurityNotAllowedFunctionError;
use Twig\Source;
use Twig\Template;
use Twig\TemplateWrapper;
/* table/search/index.twig */
class __TwigTemplate_7c80e4f6ffa84d8c1284fbdced15ebb9 extends Template
{
private Source $source;
/**
* @var array<string, Template>
*/
private array $macros = [];
public function __construct(Environment $env)
{
parent::__construct($env);
$this->source = $this->getSourceContext();
$this->parent = false;
$this->blocks = [
];
}
protected function doDisplay(array $context, array $blocks = []): iterable
{
$macros = $this->macros;
// line 1
yield "<ul class=\"nav nav-pills m-2\">
<li class=\"nav-item\">
<a class=\"nav-link active disableAjax\" href=\"";
// line 3
yield PhpMyAdmin\Url::getFromRoute("/table/search", ["db" => ($context["db"] ?? null), "table" => ($context["table"] ?? null), "pos" => 0]);
yield "\">
";
// line 4
yield PhpMyAdmin\Html\Generator::getIcon("b_search", _gettext("Table search"), false, false, "TabsMode");
yield "
</a>
</li>
<li class=\"nav-item\">
<a class=\"nav-link disableAjax\" href=\"";
// line 9
yield PhpMyAdmin\Url::getFromRoute("/table/zoom-search", ["db" => ($context["db"] ?? null), "table" => ($context["table"] ?? null)]);
yield "\">
";
// line 10
yield PhpMyAdmin\Html\Generator::getIcon("b_select", _gettext("Zoom search"), false, false, "TabsMode");
yield "
</a>
</li>
<li class=\"nav-item\">
<a class=\"nav-link disableAjax\" href=\"";
// line 15
yield PhpMyAdmin\Url::getFromRoute("/table/find-replace", ["db" => ($context["db"] ?? null), "table" => ($context["table"] ?? null)]);
yield "\">
";
// line 16
yield PhpMyAdmin\Html\Generator::getIcon("b_find_replace", _gettext("Find and replace"), false, false, "TabsMode");
yield "
</a>
</li>
</ul>
<form method=\"post\" action=\"";
// line 21
yield PhpMyAdmin\Url::getFromRoute("/table/search");
yield "\" name=\"insertForm\" id=\"tbl_search_form\" class=\"ajax lock-page\">
";
// line 22
yield PhpMyAdmin\Url::getHiddenInputs(($context["db"] ?? null), ($context["table"] ?? null));
yield "
<input type=\"hidden\" name=\"goto\" value=\"";
// line 23
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape(($context["goto"] ?? null), "html", null, true);
yield "\">
<input type=\"hidden\" name=\"back\" value=\"";
// line 24
yield PhpMyAdmin\Url::getFromRoute("/table/search");
yield "\">
<div class=\"card\">
<div class=\"card-header\">";
yield _gettext("Do a \"query by example\" (wildcard: \"%\")");
// line 27
yield "</div>
<div class=\"card-body\">
<div id=\"fieldset_table_qbe\">
<div class=\"table-responsive-md jsresponsive\">
<table class=\"table table-striped table-hover table-sm w-auto\">
<thead>
<tr>
";
// line 35
if (($context["geom_column_flag"] ?? null)) {
// line 36
yield " <th>";
yield _gettext("Function");
yield "</th>
";
}
// line 38
yield " <th>";
yield _gettext("Column");
yield "</th>
<th>";
yield _gettext("Type");
// line 39
yield "</th>
<th>";
yield _gettext("Collation");
// line 40
yield "</th>
<th>";
yield _gettext("Operator");
// line 41
yield "</th>
<th>";
yield _gettext("Value");
// line 42
yield "</th>
</tr>
</thead>
<tbody>
";
// line 46
$context['_parent'] = $context;
$context['_seq'] = CoreExtension::ensureTraversable(range(0, (Twig\Extension\CoreExtension::length($this->env->getCharset(), ($context["column_names"] ?? null)) - 1)));
foreach ($context['_seq'] as $context["_key"] => $context["column_index"]) {
// line 47
yield " <tr class=\"noclick\">
";
// line 49
yield " ";
if (($context["geom_column_flag"] ?? null)) {
// line 50
yield " ";
// line 51
yield " <td>
";
// line 52
$context["geom_types"] = PhpMyAdmin\Utils\Gis::getDataTypes();
// line 53
yield " ";
if (CoreExtension::inFilter((($_v0 = ($context["column_types"] ?? null)) && is_array($_v0) || $_v0 instanceof ArrayAccess ? ($_v0[$context["column_index"]] ?? null) : null), ($context["geom_types"] ?? null))) {
// line 54
yield " <select class=\"geom_func\" name=\"geom_func[";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["column_index"], "html", null, true);
yield "]\">
";
// line 56
yield " ";
$context["funcs"] = PhpMyAdmin\Utils\Gis::getFunctions((($_v1 = ($context["column_types"] ?? null)) && is_array($_v1) || $_v1 instanceof ArrayAccess ? ($_v1[$context["column_index"]] ?? null) : null), true, true);
// line 57
yield " ";
$context['_parent'] = $context;
$context['_seq'] = CoreExtension::ensureTraversable(($context["funcs"] ?? null));
foreach ($context['_seq'] as $context["func_name"] => $context["func"]) {
// line 58
yield " ";
$context["name"] = ((CoreExtension::getAttribute($this->env, $this->source, $context["func"], "display", [], "array", true, true, false, 58)) ? ((($_v2 = $context["func"]) && is_array($_v2) || $_v2 instanceof ArrayAccess ? ($_v2["display"] ?? null) : null)) : ($context["func_name"]));
// line 59
yield " <option value=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape(($context["name"] ?? null), "html", null, true);
yield "\">
";
// line 60
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape(($context["name"] ?? null), "html", null, true);
yield "
</option>
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['func_name'], $context['func'], $context['_parent']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 63
yield " </select>
";
}
// line 65
yield " </td>
";
}
// line 67
yield " ";
// line 68
yield " <th>";
// line 70
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v3 = ($context["column_names"] ?? null)) && is_array($_v3) || $_v3 instanceof ArrayAccess ? ($_v3[$context["column_index"]] ?? null) : null), "html", null, true);
// line 71
yield "</th>
";
// line 72
$context["properties"] = CoreExtension::getAttribute($this->env, $this->source, ($context["self"] ?? null), "getColumnProperties", [$context["column_index"], $context["column_index"]], "method", false, false, false, 72);
// line 73
yield " <td dir=\"ltr\">
";
// line 74
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v4 = ($context["properties"] ?? null)) && is_array($_v4) || $_v4 instanceof ArrayAccess ? ($_v4["type"] ?? null) : null), "html", null, true);
yield "
</td>
<td>
";
// line 77
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v5 = ($context["properties"] ?? null)) && is_array($_v5) || $_v5 instanceof ArrayAccess ? ($_v5["collation"] ?? null) : null), "html", null, true);
yield "
</td>
<td>
";
// line 80
yield (($_v6 = ($context["properties"] ?? null)) && is_array($_v6) || $_v6 instanceof ArrayAccess ? ($_v6["func"] ?? null) : null);
yield "
</td>
";
// line 83
yield " <td data-type=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v7 = ($context["properties"] ?? null)) && is_array($_v7) || $_v7 instanceof ArrayAccess ? ($_v7["type"] ?? null) : null), "html", null, true);
yield "\">
";
// line 84
yield (($_v8 = ($context["properties"] ?? null)) && is_array($_v8) || $_v8 instanceof ArrayAccess ? ($_v8["value"] ?? null) : null);
yield "
";
// line 86
yield " <input type=\"hidden\" name=\"criteriaColumnNames[";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["column_index"], "html", null, true);
yield "]\" value=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v9 = ($context["column_names"] ?? null)) && is_array($_v9) || $_v9 instanceof ArrayAccess ? ($_v9[$context["column_index"]] ?? null) : null), "html", null, true);
yield "\">
<input type=\"hidden\" name=\"criteriaColumnTypes[";
// line 87
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["column_index"], "html", null, true);
yield "]\" value=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v10 = ($context["column_types"] ?? null)) && is_array($_v10) || $_v10 instanceof ArrayAccess ? ($_v10[$context["column_index"]] ?? null) : null), "html", null, true);
yield "\">
<input type=\"hidden\" name=\"criteriaColumnCollations[";
// line 88
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["column_index"], "html", null, true);
yield "]\" value=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape((($_v11 = ($context["column_collations"] ?? null)) && is_array($_v11) || $_v11 instanceof ArrayAccess ? ($_v11[$context["column_index"]] ?? null) : null), "html", null, true);
yield "\">
</td>
</tr>
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['_key'], $context['column_index'], $context['_parent']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 92
yield " </tbody>
</table>
</div>
<div id=\"gis_editor\"></div>
<div id=\"popup_background\"></div>
</div>
";
// line 99
if ((($context["default_sliders_state"] ?? null) != "disabled")) {
// line 100
yield " <div>
<button class=\"btn btn-sm btn-secondary\" type=\"button\" data-bs-toggle=\"collapse\" data-bs-target=\"#searchExtraOptions\" aria-expanded=\"";
// line 101
yield (((($context["default_sliders_state"] ?? null) == "open")) ? ("true") : ("false"));
yield "\" aria-controls=\"searchExtraOptions\">
";
yield _gettext("Extra options");
// line 103
yield " </button>
</div>
<div class=\"collapse mt-3";
// line 105
yield (((($context["default_sliders_state"] ?? null) == "open")) ? (" show") : (""));
yield "\" id=\"searchExtraOptions\">
";
}
// line 107
yield "
";
// line 109
yield " <fieldset>
<div class=\"mb-3\">
<label class=\"form-label\" for=\"columnsToDisplaySelect\">";
yield _gettext("Select columns (at least one):");
// line 111
yield "</label>
<select class=\"form-select resize-vertical\" id=\"columnsToDisplaySelect\" name=\"columnsToDisplay[]\" size=\"";
// line 112
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape(min(Twig\Extension\CoreExtension::length($this->env->getCharset(), ($context["column_names"] ?? null)), 10), "html", null, true);
yield "\" multiple>
";
// line 113
$context['_parent'] = $context;
$context['_seq'] = CoreExtension::ensureTraversable(($context["column_names"] ?? null));
foreach ($context['_seq'] as $context["_key"] => $context["each_field"]) {
// line 114
yield " <option value=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["each_field"], "html", null, true);
yield "\" selected>
";
// line 115
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["each_field"], "html", null, true);
yield "
</option>
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['_key'], $context['each_field'], $context['_parent']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 118
yield " </select>
</div>
<div class=\"form-check mb-3\">
<input class=\"form-check-input\" type=\"checkbox\" name=\"distinct\" value=\"DISTINCT\" id=\"oDistinct\">
<label class=\"form-check-label\" for=\"oDistinct\" dir=\"ltr\" lang=\"en\">DISTINCT</label>
</div>
</fieldset>
";
// line 127
yield " <div class=\"mb-3\">
<label class=\"form-label\" for=\"customWhereClauseInput\">
<em>";
yield _gettext("Or");
// line 129
yield "</em>
";
yield _gettext("Add search conditions (body of the \"where\" clause):");
// line 131
yield " ";
yield PhpMyAdmin\Html\MySQLDocumentation::show("Functions");
yield "
</label>
<input class=\"form-control\" id=\"customWhereClauseInput\" type=\"text\" name=\"customWhereClause\" size=\"64\">
</div>
";
// line 137
yield " <div class=\"mb-3\">
<label class=\"form-label\" for=\"maxRowsInput\">";
yield _gettext("Number of rows per page");
// line 138
yield "</label>
<input class=\"form-control\" id=\"maxRowsInput\" type=\"number\" name=\"session_max_rows\" min=\"1\" value=\"";
// line 139
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape(($context["max_rows"] ?? null), "html", null, true);
yield "\" required>
</div>
";
// line 143
yield " <fieldset>
<legend class=\"visually-hidden\">";
yield _gettext("Display order:");
// line 144
yield "</legend>
<div class=\"mb-3\">
<label class=\"form-label\" for=\"orderByColumnSelect\">";
yield _gettext("Order by:");
// line 146
yield "</label>
<select class=\"form-select\" id=\"orderByColumnSelect\" name=\"orderByColumn\">
<option value=\"--nil--\" selected></option>
";
// line 149
$context['_parent'] = $context;
$context['_seq'] = CoreExtension::ensureTraversable(($context["column_names"] ?? null));
foreach ($context['_seq'] as $context["_key"] => $context["each_field"]) {
// line 150
yield " <option value=\"";
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["each_field"], "html", null, true);
yield "\">
";
// line 151
yield $this->env->getRuntime('Twig\Runtime\EscaperRuntime')->escape($context["each_field"], "html", null, true);
yield "
</option>
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['_key'], $context['each_field'], $context['_parent']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 154
yield " </select>
</div>
<div class=\"form-check\">
<input class=\"form-check-input\" type=\"radio\" name=\"order\" id=\"orderByAscRadio\" value=\"ASC\" checked>
<label class=\"form-check-label\" for=\"orderByAscRadio\">";
yield _gettext("Ascending");
// line 159
yield "</label>
</div>
<div class=\"form-check\">
<input class=\"form-check-input\" type=\"radio\" name=\"order\" id=\"orderByDescRadio\" value=\"DESC\">
<label class=\"form-check-label\" for=\"orderByDescRadio\">";
yield _gettext("Descending");
// line 163
yield "</label>
</div>
</fieldset>
";
// line 166
if ((($context["default_sliders_state"] ?? null) != "disabled")) {
// line 167
yield " </div>
";
}
// line 169
yield " </div>
<div class=\"card-footer\">
<input class=\"btn btn-primary\" type=\"submit\" name=\"submit\" value=\"";
yield _gettext("Go");
// line 172
yield "\">
</div>
</div>
</form>
<div class=\"modal fade\" id=\"rangeSearchModal\" tabindex=\"-1\" aria-labelledby=\"rangeSearchModalLabel\" aria-hidden=\"false\">
<div class=\"modal-dialog\">
<div class=\"modal-content\">
<div class=\"modal-header\">
<h5 class=\"modal-title\" id=\"rangeSearchModalLabel\">";
yield _gettext("Range search");
// line 181
yield "</h5>
<button type=\"button\" class=\"btn-close\" data-bs-dismiss=\"modal\" aria-label=\"";
yield _gettext("Close");
// line 182
yield "\"></button>
</div>
<div class=\"modal-body\">
<fieldset class=\"pma-fieldset\">
<legend id=\"rangeSearchLegend\"></legend>
<label for=\"min_value\">";
yield _gettext("Minimum value:");
// line 187
yield "</label>
<input type=\"text\" id=\"min_value\"><br>
<span class=\"small_font\" id=\"rangeSearchMin\"></span><br>
<label for=\"max_value\">";
yield _gettext("Maximum value:");
// line 190
yield "</label>
<input type=\"text\" id=\"max_value\"><br>
<span class=\"small_font\" id=\"rangeSearchMax\"></span>
</fieldset>
</div>
<div class=\"modal-footer\">
<button type=\"button\" class=\"btn btn-secondary\" id=\"rangeSearchModalGo\">";
yield _gettext("Go");
// line 196
yield "</button>
<button type=\"button\" class=\"btn btn-secondary\" data-bs-dismiss=\"modal\">";
yield _gettext("Cancel");
// line 197
yield "</button>
</div>
</div>
</div>
</div>
<div id=\"sqlqueryresultsouter\"></div>
";
yield from [];
}
/**
* @codeCoverageIgnore
*/
public function getTemplateName(): string
{
return "table/search/index.twig";
}
/**
* @codeCoverageIgnore
*/
public function isTraitable(): bool
{
return false;
}
/**
* @codeCoverageIgnore
*/
public function getDebugInfo(): array
{
return array ( 475 => 197, 471 => 196, 462 => 190, 456 => 187, 448 => 182, 444 => 181, 432 => 172, 426 => 169, 422 => 167, 420 => 166, 415 => 163, 408 => 159, 400 => 154, 391 => 151, 386 => 150, 382 => 149, 377 => 146, 372 => 144, 368 => 143, 362 => 139, 359 => 138, 355 => 137, 346 => 131, 342 => 129, 337 => 127, 327 => 118, 318 => 115, 313 => 114, 309 => 113, 305 => 112, 302 => 111, 297 => 109, 294 => 107, 289 => 105, 285 => 103, 280 => 101, 277 => 100, 275 => 99, 266 => 92, 254 => 88, 248 => 87, 241 => 86, 237 => 84, 232 => 83, 227 => 80, 221 => 77, 215 => 74, 212 => 73, 210 => 72, 207 => 71, 205 => 70, 203 => 68, 201 => 67, 197 => 65, 193 => 63, 184 => 60, 179 => 59, 176 => 58, 171 => 57, 168 => 56, 163 => 54, 160 => 53, 158 => 52, 155 => 51, 153 => 50, 150 => 49, 147 => 47, 143 => 46, 137 => 42, 133 => 41, 129 => 40, 125 => 39, 119 => 38, 113 => 36, 111 => 35, 101 => 27, 94 => 24, 90 => 23, 86 => 22, 82 => 21, 74 => 16, 70 => 15, 62 => 10, 58 => 9, 50 => 4, 46 => 3, 42 => 1,);
}
public function getSourceContext(): Source
{
return new Source("", "table/search/index.twig", "/usr/share/phpmyadmin/templates/table/search/index.twig");
}
}