ZoneSearch
class ZoneSearch extends BaseSearch (View source)
Properties
| protected object | $db | from BaseSearch | |
| protected string | $db_type | from BaseSearch | |
| protected ConfigurationInterface | $config | from BaseSearch | |
| protected IPAddressValidator | $ipValidator | from BaseSearch | |
| protected UserContextService | $userContext | from BaseSearch |
Methods
No description
Builds the search string for the given parameters.
The needle for free-text columns. Record content and comments hold whatever the user typed, so the punycoded form of the query cannot match them.
Punycode names whose decoded form contains the query.
Extend a name predicate so partial IDN queries match. Returns the SQL to append, binding one placeholder per matching name into $params.
Restores the original SQL mode for the MySQL database connection if needed.
Search for zones based on specified parameters.
Prepares the list of found zones by aggregating owner details and converting domain names to UTF-8.
Fetch zones based on specified search criteria and pagination.
Get the total number of zones based on the specified search criteria.
Get the number of found zones based on the search criteria.
Details
__construct($db, $config, string $db_type, IPAddressValidator|null $ipValidator = null, UserContextService|null $userContext = null)
No description
protected array
buildSearchString(array $parameters)
Builds the search string for the given parameters.
protected string
buildRawSearchString(array $parameters)
The needle for free-text columns. Record content and comments hold whatever the user typed, so the punycoded form of the query cannot match them.
protected array
idnNamesMatching(string $table, string $column, string $query)
Punycode names whose decoded form contains the query.
The punycode of a substring is not a substring of the punycode, so a partial query like "munch" can never match "xn--mnchen-3ya" through LIKE. Decoding the IDN names and comparing in PHP is bounded to the rows that are actually punycode.
protected string
idnNameCondition(string $table, string $column, string $query, string $prefix, array $params)
Extend a name predicate so partial IDN queries match. Returns the SQL to append, binding one placeholder per matching name into $params.
protected string
handleSqlMode()
No description
protected void
restoreSqlMode(string $originalSqlMode)
Restores the original SQL mode for the MySQL database connection if needed.
array
searchZones(array $parameters, string $permission_view, string $sort_zones_by, string $zone_sort_direction, int $iface_rowamount, bool $iface_zone_comments, int $page)
Search for zones based on specified parameters.
array
prepareFoundZones(array $zones)
Prepares the list of found zones by aggregating owner details and converting domain names to UTF-8.
array
fetchZones(array $parameters, mixed $search_string, bool $reverse, mixed $reverse_search_string, string $permission_view, string $sort_zones_by, string $zone_sort_direction, int $iface_rowamount, bool $iface_zone_comments, int $page)
Fetch zones based on specified search criteria and pagination.
int
getTotalZones(array $parameters, string $permission_view)
Get the total number of zones based on the specified search criteria.
int
getFoundZones(array $parameters, mixed $search_string, bool $reverse, mixed $reverse_search_string, string $permission_view)
Get the number of found zones based on the search criteria.