-= Team Anon Force =-
Uname:
Perm: -rw-r--r--
/
home
/
ogbpffv
/
www
/
atpr
/
wp-includes
/
Nama File / Folder
Size
Action
ID3
--
NONE
IXR
--
NONE
PHPMailer
--
NONE
Requests
--
NONE
SimplePie
--
NONE
Text
--
NONE
abilities-api
--
NONE
ai-client
--
NONE
assets
--
NONE
block-bindings
--
NONE
block-patterns
--
NONE
block-supports
--
NONE
blocks
--
NONE
build
--
NONE
certificates
--
NONE
collaboration
--
NONE
css
--
NONE
customize
--
NONE
fonts
--
NONE
html-api
--
NONE
images
--
NONE
interactivity-api
--
NONE
js
--
NONE
l10n
--
NONE
php-ai-client
--
NONE
php-compat
--
NONE
pomo
--
NONE
rest-api
--
NONE
sitemaps
--
NONE
sodium_compat
--
NONE
style-engine
--
NONE
theme-compat
--
NONE
widgets
--
NONE
abilities-api.php
23.798KB
Delete
Edit
abilities.php
7.821KB
Delete
Edit
admin-bar.php
38.394KB
Delete
Edit
ai-client.php
2.489KB
Delete
Edit
atomlib.php
11.896KB
Delete
Edit
author-template.php
19.379KB
Delete
Edit
block-bindings.php
7.35KB
Delete
Edit
block-editor.php
28.051KB
Delete
Edit
block-i18n.json
0.309KB
Delete
Edit
block-template-utils.php
61.332KB
Delete
Edit
block-template.php
17.833KB
Delete
Edit
blocks.php
116.643KB
Delete
Edit
bookmark-template.php
12.469KB
Delete
Edit
bookmark.php
15.065KB
Delete
Edit
cache-compat.php
10.763KB
Delete
Edit
cache.php
13.17KB
Delete
Edit
canonical.php
33.833KB
Delete
Edit
capabilities.php
42.61KB
Delete
Edit
category-template.php
55.649KB
Delete
Edit
category.php
12.533KB
Delete
Edit
class-avif-info.php
29.305KB
Delete
Edit
class-feed.php
0.526KB
Delete
Edit
class-http.php
0.358KB
Delete
Edit
class-phpass.php
6.612KB
Delete
Edit
class-phpmailer.php
0.648KB
Delete
Edit
class-pop3.php
20.626KB
Delete
Edit
class-requests.php
2.185KB
Delete
Edit
class-simplepie.php
0.442KB
Delete
Edit
class-smtp.php
0.446KB
Delete
Edit
class-snoopy.php
36.831KB
Delete
Edit
class-walker-category-dropdown.php
2.411KB
Delete
Edit
class-walker-category.php
8.278KB
Delete
Edit
class-walker-nav-menu.php
11.762KB
Delete
Edit
class-walker-page-dropdown.php
2.646KB
Delete
Edit
class-walker-page.php
7.434KB
Delete
Edit
class-wp-admin-bar.php
17.582KB
Delete
Edit
class-wp-ajax-response.php
5.143KB
Delete
Edit
class-wp-application-passwords.php
16.698KB
Delete
Edit
class-wp-block-bindings-registry.php
8.069KB
Delete
Edit
class-wp-block-bindings-source.php
2.922KB
Delete
Edit
class-wp-block-editor-context.php
1.318KB
Delete
Edit
class-wp-block-list.php
4.603KB
Delete
Edit
class-wp-block-metadata-registry.php
11.568KB
Delete
Edit
class-wp-block-parser-block.php
2.495KB
Delete
Edit
class-wp-block-parser-frame.php
1.947KB
Delete
Edit
class-wp-block-parser.php
11.25KB
Delete
Edit
class-wp-block-pattern-categories-registry.php
4.28KB
Delete
Edit
class-wp-block-patterns-registry.php
10.07KB
Delete
Edit
class-wp-block-processor.php
68.319KB
Delete
Edit
class-wp-block-styles-registry.php
6.269KB
Delete
Edit
class-wp-block-supports.php
6.397KB
Delete
Edit
class-wp-block-template.php
1.985KB
Delete
Edit
class-wp-block-templates-registry.php
6.914KB
Delete
Edit
class-wp-block-type-registry.php
4.912KB
Delete
Edit
class-wp-block-type.php
16.829KB
Delete
Edit
class-wp-block.php
24.141KB
Delete
Edit
class-wp-classic-to-block-menu-converter.php
3.932KB
Delete
Edit
class-wp-connector-registry.php
14.071KB
Delete
Edit
class-wp-customize-manager.php
198.126KB
Delete
Edit
class-wp-customize-nav-menus.php
56.609KB
Delete
Edit
class-wp-customize-panel.php
10.459KB
Delete
Edit
class-wp-customize-section.php
10.946KB
Delete
Edit
class-wp-customize-setting.php
29.261KB
Delete
Edit
class-wp-date-query.php
35.127KB
Delete
Edit
class-wp-dependencies.php
16.688KB
Delete
Edit
class-wp-dependency.php
2.591KB
Delete
Edit
class-wp-duotone.php
39.951KB
Delete
Edit
class-wp-editor.php
70.535KB
Delete
Edit
class-wp-embed.php
15.535KB
Delete
Edit
class-wp-error.php
7.326KB
Delete
Edit
class-wp-fatal-error-handler.php
7.959KB
Delete
Edit
class-wp-feed-cache-transient.php
3.227KB
Delete
Edit
class-wp-feed-cache.php
0.946KB
Delete
Edit
class-wp-hook.php
16.246KB
Delete
Edit
class-wp-http-cookie.php
7.099KB
Delete
Edit
class-wp-http-curl.php
12.95KB
Delete
Edit
class-wp-http-encoding.php
6.532KB
Delete
Edit
class-wp-http-ixr-client.php
3.434KB
Delete
Edit
class-wp-http-proxy.php
5.84KB
Delete
Edit
class-wp-http-requests-hooks.php
1.975KB
Delete
Edit
class-wp-http-requests-response.php
4.144KB
Delete
Edit
class-wp-http-response.php
2.907KB
Delete
Edit
class-wp-http-streams.php
16.371KB
Delete
Edit
class-wp-http.php
40.672KB
Delete
Edit
class-wp-icons-registry.php
7.673KB
Delete
Edit
class-wp-image-editor-gd.php
20.22KB
Delete
Edit
class-wp-image-editor-imagick.php
36.11KB
Delete
Edit
class-wp-image-editor.php
17.01KB
Delete
Edit
class-wp-list-util.php
7.269KB
Delete
Edit
class-wp-locale-switcher.php
6.617KB
Delete
Edit
class-wp-locale.php
16.453KB
Delete
Edit
class-wp-matchesmapregex.php
1.785KB
Delete
Edit
class-wp-meta-query.php
29.792KB
Delete
Edit
class-wp-metadata-lazyloader.php
6.673KB
Delete
Edit
class-wp-navigation-fallback.php
8.978KB
Delete
Edit
class-wp-object-cache.php
17.113KB
Delete
Edit
class-wp-oembed-controller.php
6.743KB
Delete
Edit
class-wp-oembed.php
30.862KB
Delete
Edit
class-wp-paused-extensions-storage.php
4.948KB
Delete
Edit
class-wp-plugin-dependencies.php
24.592KB
Delete
Edit
class-wp-post.php
6.331KB
Delete
Edit
class-wp-query.php
159.503KB
Delete
Edit
class-wp-recovery-mode-cookie-service.php
6.716KB
Delete
Edit
class-wp-recovery-mode-email-service.php
10.904KB
Delete
Edit
class-wp-recovery-mode-key-service.php
4.799KB
Delete
Edit
class-wp-recovery-mode-link-service.php
3.44KB
Delete
Edit
class-wp-recovery-mode.php
11.185KB
Delete
Edit
class-wp-rewrite.php
62.2KB
Delete
Edit
class-wp-role.php
2.464KB
Delete
Edit
class-wp-roles.php
9.103KB
Delete
Edit
class-wp-script-modules.php
39.647KB
Delete
Edit
class-wp-scripts.php
35.927KB
Delete
Edit
class-wp-session-tokens.php
7.147KB
Delete
Edit
class-wp-simplepie-file.php
3.469KB
Delete
Edit
class-wp-simplepie-sanitize-kses.php
1.865KB
Delete
Edit
class-wp-site-query.php
30.744KB
Delete
Edit
class-wp-site.php
7.284KB
Delete
Edit
class-wp-speculation-rules.php
7.377KB
Delete
Edit
class-wp-styles.php
13.043KB
Delete
Edit
class-wp-tax-query.php
19.118KB
Delete
Edit
class-wp-taxonomy.php
18.124KB
Delete
Edit
class-wp-term-query.php
39.796KB
Delete
Edit
class-wp-term.php
5.14KB
Delete
Edit
class-wp-text-diff-renderer-inline.php
0.956KB
Delete
Edit
class-wp-text-diff-renderer-table.php
18.488KB
Delete
Edit
class-wp-textdomain-registry.php
10.235KB
Delete
Edit
class-wp-theme-json-data.php
1.767KB
Delete
Edit
class-wp-theme-json-resolver.php
34.855KB
Delete
Edit
class-wp-theme-json-schema.php
7.194KB
Delete
Edit
class-wp-theme-json.php
169.569KB
Delete
Edit
class-wp-theme.php
64.22KB
Delete
Edit
class-wp-token-map.php
27.947KB
Delete
Edit
class-wp-url-pattern-prefixer.php
4.689KB
Delete
Edit
class-wp-user-meta-session-tokens.php
2.885KB
Delete
Edit
class-wp-user-query.php
43.068KB
Delete
Edit
class-wp-user-request.php
2.251KB
Delete
Edit
class-wp-user.php
22.477KB
Delete
Edit
class-wp-walker.php
13.01KB
Delete
Edit
class-wp-widget-factory.php
3.269KB
Delete
Edit
class-wp-xmlrpc-server.php
209.98KB
Delete
Edit
class-wp.php
25.753KB
Delete
Edit
class.wp-dependencies.php
0.364KB
Delete
Edit
class.wp-scripts.php
0.335KB
Delete
Edit
class.wp-styles.php
0.33KB
Delete
Edit
collaboration.php
2.107KB
Delete
Edit
comment-template.php
100.792KB
Delete
Edit
compat-utf8.php
19.096KB
Delete
Edit
compat.php
15.687KB
Delete
Edit
connectors.php
23.516KB
Delete
Edit
cron.php
43.941KB
Delete
Edit
date.php
0.391KB
Delete
Edit
default-constants.php
11.099KB
Delete
Edit
default-filters.php
36.54KB
Delete
Edit
default-widgets.php
2.241KB
Delete
Edit
deprecated.php
189.431KB
Delete
Edit
embed.php
37.994KB
Delete
Edit
feed-atom-comments.php
5.375KB
Delete
Edit
feed-atom.php
3.048KB
Delete
Edit
feed-rdf.php
2.605KB
Delete
Edit
feed-rss.php
1.161KB
Delete
Edit
feed-rss2-comments.php
4.039KB
Delete
Edit
feed-rss2.php
3.71KB
Delete
Edit
feed.php
24.599KB
Delete
Edit
fonts.php
9.561KB
Delete
Edit
formatting.php
346.377KB
Delete
Edit
functions.php
283.521KB
Delete
Edit
functions.wp-scripts.php
20.012KB
Delete
Edit
functions.wp-styles.php
8.451KB
Delete
Edit
general-template.php
170.834KB
Delete
Edit
global-styles-and-settings.php
20.293KB
Delete
Edit
http.php
26.616KB
Delete
Edit
https-detection.php
5.72KB
Delete
Edit
https-migration.php
4.63KB
Delete
Edit
kses.php
80.645KB
Delete
Edit
l10n.php
69.741KB
Delete
Edit
link-template.php
156.394KB
Delete
Edit
load.php
55.151KB
Delete
Edit
locale.php
0.158KB
Delete
Edit
media-template.php
61.792KB
Delete
Edit
media.php
218.549KB
Delete
Edit
meta.php
65.175KB
Delete
Edit
ms-blogs.php
25.714KB
Delete
Edit
ms-default-constants.php
4.806KB
Delete
Edit
ms-default-filters.php
6.48KB
Delete
Edit
ms-deprecated.php
21.24KB
Delete
Edit
ms-files.php
2.79KB
Delete
Edit
ms-functions.php
89.689KB
Delete
Edit
ms-load.php
19.568KB
Delete
Edit
ms-network.php
3.693KB
Delete
Edit
ms-settings.php
4.105KB
Delete
Edit
ms-site.php
40.751KB
Delete
Edit
nav-menu-template.php
25.381KB
Delete
Edit
nav-menu.php
43.231KB
Delete
Edit
option.php
102.616KB
Delete
Edit
pluggable-deprecated.php
6.176KB
Delete
Edit
pluggable.php
124.568KB
Delete
Edit
plugin.php
35.646KB
Delete
Edit
post-formats.php
6.904KB
Delete
Edit
post-template.php
67.007KB
Delete
Edit
post-thumbnail-template.php
10.624KB
Delete
Edit
query.php
36.226KB
Delete
Edit
registration-functions.php
0.195KB
Delete
Edit
registration.php
0.195KB
Delete
Edit
revision.php
29.992KB
Delete
Edit
rewrite.php
19.005KB
Delete
Edit
robots-template.php
5.063KB
Delete
Edit
rss-functions.php
0.249KB
Delete
Edit
rss.php
22.659KB
Delete
Edit
script-loader.php
159.303KB
Delete
Edit
script-modules.php
11.663KB
Delete
Edit
sitemaps.php
3.162KB
Delete
Edit
speculative-loading.php
8.398KB
Delete
Edit
spl-autoload-compat.php
0.431KB
Delete
Edit
style-engine.php
7.386KB
Delete
Edit
taxonomy.php
172.992KB
Delete
Edit
template-canvas.php
0.531KB
Delete
Edit
template-loader.php
4.167KB
Delete
Edit
template.php
35.961KB
Delete
Edit
theme-i18n.json
1.848KB
Delete
Edit
theme-templates.php
3.965KB
Delete
Edit
theme.json
8.825KB
Delete
Edit
theme.php
131.476KB
Delete
Edit
update.php
37.379KB
Delete
Edit
user.php
174.633KB
Delete
Edit
utf8.php
7.09KB
Delete
Edit
vars.php
6.452KB
Delete
Edit
version.php
1.104KB
Delete
Edit
view-transitions.php
0.588KB
Delete
Edit
wp-db.php
0.435KB
Delete
Edit
wp-diff.php
0.78KB
Delete
Edit
<=Back
<?php /** * Taxonomy API: WP_Tax_Query class * * @package WordPress * @subpackage Taxonomy * @since 4.4.0 */ /** * Core class used to implement taxonomy queries for the Taxonomy API. * * Used for generating SQL clauses that filter a primary query according to object * taxonomy terms. * * WP_Tax_Query is a helper that allows primary query classes, such as WP_Query, to filter * their results by object metadata, by generating `JOIN` and `WHERE` subclauses to be * attached to the primary SQL query string. * * @since 3.1.0 */ #[AllowDynamicProperties] class WP_Tax_Query { /** * Array of taxonomy queries. * * See WP_Tax_Query::__construct() for information on tax query arguments. * * @since 3.1.0 * @var array */ public $queries = array(); /** * The relation between the queries. Can be one of 'AND' or 'OR'. * * @since 3.1.0 * @var string */ public $relation; /** * Standard response when the query should not return any rows. * * @since 3.2.0 * @var array<string, array<string>> */ private static $no_results = array( 'join' => array( '' ), 'where' => array( '0 = 1' ), ); /** * A flat list of table aliases used in the JOIN clauses. * * @since 4.1.0 * @var array */ protected $table_aliases = array(); /** * Terms and taxonomies fetched by this query. * * We store this data in a flat array because they are referenced in a * number of places by WP_Query. * * @since 4.1.0 * @var array */ public $queried_terms = array(); /** * Database table that where the metadata's objects are stored (eg $wpdb->users). * * @since 4.1.0 * @var string */ public $primary_table; /** * Column in 'primary_table' that represents the ID of the object. * * @since 4.1.0 * @var string */ public $primary_id_column; /** * Constructor. * * @since 3.1.0 * @since 4.1.0 Added support for `$operator` 'NOT EXISTS' and 'EXISTS' values. * * @param array $tax_query { * Array of taxonomy query clauses. * * @type string $relation Optional. The MySQL keyword used to join * the clauses of the query. Accepts 'AND', or 'OR'. Default 'AND'. * @type array ...$0 { * An array of first-order clause parameters, or another fully-formed tax query. * * @type string $taxonomy Taxonomy being queried. Optional when field=term_taxonomy_id. * @type string|int|array $terms Term or terms to filter by. * @type string $field Field to match $terms against. Accepts 'term_id', 'slug', * 'name', or 'term_taxonomy_id'. Default: 'term_id'. * @type string $operator MySQL operator to be used with $terms in the WHERE clause. * Accepts 'AND', 'IN', 'NOT IN', 'EXISTS', 'NOT EXISTS'. * Default: 'IN'. * @type bool $include_children Optional. Whether to include child terms. * Requires a $taxonomy. Default: true. * } * } */ public function __construct( $tax_query ) { if ( isset( $tax_query['relation'] ) ) { $this->relation = $this->sanitize_relation( $tax_query['relation'] ); } else { $this->relation = 'AND'; } $this->queries = $this->sanitize_query( $tax_query ); } /** * Ensures the 'tax_query' argument passed to the class constructor is well-formed. * * Ensures that each query-level clause has a 'relation' key, and that * each first-order clause contains all the necessary keys from `$defaults`. * * @since 4.1.0 * * @param array $queries Array of queries clauses. * @return array Sanitized array of query clauses. */ public function sanitize_query( $queries ) { $cleaned_query = array(); $defaults = array( 'taxonomy' => '', 'terms' => array(), 'field' => 'term_id', 'operator' => 'IN', 'include_children' => true, ); foreach ( $queries as $key => $query ) { if ( 'relation' === $key ) { $cleaned_query['relation'] = $this->sanitize_relation( $query ); // First-order clause. } elseif ( self::is_first_order_clause( $query ) ) { $cleaned_clause = array_merge( $defaults, $query ); $cleaned_clause['terms'] = (array) $cleaned_clause['terms']; $cleaned_query[] = $cleaned_clause; /* * Keep a copy of the clause in the flate * $queried_terms array, for use in WP_Query. */ if ( ! empty( $cleaned_clause['taxonomy'] ) && 'NOT IN' !== $cleaned_clause['operator'] ) { $taxonomy = $cleaned_clause['taxonomy']; if ( ! isset( $this->queried_terms[ $taxonomy ] ) ) { $this->queried_terms[ $taxonomy ] = array(); } /* * Backward compatibility: Only store the first * 'terms' and 'field' found for a given taxonomy. */ if ( ! empty( $cleaned_clause['terms'] ) && ! isset( $this->queried_terms[ $taxonomy ]['terms'] ) ) { $this->queried_terms[ $taxonomy ]['terms'] = $cleaned_clause['terms']; } if ( ! empty( $cleaned_clause['field'] ) && ! isset( $this->queried_terms[ $taxonomy ]['field'] ) ) { $this->queried_terms[ $taxonomy ]['field'] = $cleaned_clause['field']; } } // Otherwise, it's a nested query, so we recurse. } elseif ( is_array( $query ) ) { $cleaned_subquery = $this->sanitize_query( $query ); if ( ! empty( $cleaned_subquery ) ) { // All queries with children must have a relation. if ( ! isset( $cleaned_subquery['relation'] ) ) { $cleaned_subquery['relation'] = 'AND'; } $cleaned_query[] = $cleaned_subquery; } } } return $cleaned_query; } /** * Sanitizes a 'relation' operator. * * @since 4.1.0 * * @param string $relation Raw relation key from the query argument. * @return string Sanitized relation. Either 'AND' or 'OR'. */ public function sanitize_relation( $relation ) { if ( 'OR' === strtoupper( $relation ) ) { return 'OR'; } else { return 'AND'; } } /** * Determines whether a clause is first-order. * * A "first-order" clause is one that contains any of the first-order * clause keys ('terms', 'taxonomy', 'include_children', 'field', * 'operator'). An empty clause also counts as a first-order clause, * for backward compatibility. Any clause that doesn't meet this is * determined, by process of elimination, to be a higher-order query. * * @since 4.1.0 * * @param array $query Tax query arguments. * @return bool Whether the query clause is a first-order clause. */ protected static function is_first_order_clause( $query ) { return is_array( $query ) && ( empty( $query ) || array_key_exists( 'terms', $query ) || array_key_exists( 'taxonomy', $query ) || array_key_exists( 'include_children', $query ) || array_key_exists( 'field', $query ) || array_key_exists( 'operator', $query ) ); } /** * Generates SQL clauses to be appended to a main query. * * @since 3.1.0 * * @param string $primary_table Database table where the object being filtered is stored (eg wp_users). * @param string $primary_id_column ID column for the filtered object in $primary_table. * @return string[] { * Array containing JOIN and WHERE SQL clauses to append to the main query. * * @type string $join SQL fragment to append to the main JOIN clause. * @type string $where SQL fragment to append to the main WHERE clause. * } */ public function get_sql( $primary_table, $primary_id_column ) { $this->primary_table = $primary_table; $this->primary_id_column = $primary_id_column; return $this->get_sql_clauses(); } /** * Generates SQL clauses to be appended to a main query. * * Called by the public WP_Tax_Query::get_sql(), this method * is abstracted out to maintain parity with the other Query classes. * * @since 4.1.0 * * @return string[] { * Array containing JOIN and WHERE SQL clauses to append to the main query. * * @type string $join SQL fragment to append to the main JOIN clause. * @type string $where SQL fragment to append to the main WHERE clause. * } */ protected function get_sql_clauses() { /* * $queries are passed by reference to get_sql_for_query() for recursion. * To keep $this->queries unaltered, pass a copy. */ $queries = $this->queries; $sql = $this->get_sql_for_query( $queries ); if ( ! empty( $sql['where'] ) ) { $sql['where'] = ' AND ' . $sql['where']; } return $sql; } /** * Generates SQL clauses for a single query array. * * If nested subqueries are found, this method recurses the tree to * produce the properly nested SQL. * * @since 4.1.0 * * @param array $query Query to parse (passed by reference). * @param int $depth Optional. Number of tree levels deep we currently are. * Used to calculate indentation. Default 0. * @return string[] { * Array containing JOIN and WHERE SQL clauses to append to a single query array. * * @type string $join SQL fragment to append to the main JOIN clause. * @type string $where SQL fragment to append to the main WHERE clause. * } */ protected function get_sql_for_query( &$query, $depth = 0 ) { $sql_chunks = array( 'join' => array(), 'where' => array(), ); $sql = array( 'join' => '', 'where' => '', ); $indent = ''; for ( $i = 0; $i < $depth; $i++ ) { $indent .= ' '; } foreach ( $query as $key => &$clause ) { if ( 'relation' === $key ) { $relation = $query['relation']; } elseif ( is_array( $clause ) ) { // This is a first-order clause. if ( $this->is_first_order_clause( $clause ) ) { $clause_sql = $this->get_sql_for_clause( $clause, $query ); $where_count = count( $clause_sql['where'] ); if ( ! $where_count ) { $sql_chunks['where'][] = ''; } elseif ( 1 === $where_count ) { $sql_chunks['where'][] = $clause_sql['where'][0]; } else { $sql_chunks['where'][] = '( ' . implode( ' AND ', $clause_sql['where'] ) . ' )'; } $sql_chunks['join'] = array_merge( $sql_chunks['join'], $clause_sql['join'] ); // This is a subquery, so we recurse. } else { $clause_sql = $this->get_sql_for_query( $clause, $depth + 1 ); $sql_chunks['where'][] = $clause_sql['where']; $sql_chunks['join'][] = $clause_sql['join']; } } } // Filter to remove empties. $sql_chunks['join'] = array_filter( $sql_chunks['join'] ); $sql_chunks['where'] = array_filter( $sql_chunks['where'] ); if ( empty( $relation ) ) { $relation = 'AND'; } // Filter duplicate JOIN clauses and combine into a single string. if ( ! empty( $sql_chunks['join'] ) ) { $sql['join'] = implode( ' ', array_unique( $sql_chunks['join'] ) ); } // Generate a single WHERE clause with proper brackets and indentation. if ( ! empty( $sql_chunks['where'] ) ) { $sql['where'] = '( ' . "\n " . $indent . implode( ' ' . "\n " . $indent . $relation . ' ' . "\n " . $indent, $sql_chunks['where'] ) . "\n" . $indent . ')'; } return $sql; } /** * Generates SQL JOIN and WHERE clauses for a "first-order" query clause. * * @since 4.1.0 * * @global wpdb $wpdb The WordPress database abstraction object. * * @param array $clause Query clause (passed by reference). * @param array $parent_query Parent query array. * @return array { * Array containing JOIN and WHERE SQL clauses to append to a first-order query. * * @type string[] $join Array of SQL fragments to append to the main JOIN clause. * @type string[] $where Array of SQL fragments to append to the main WHERE clause. * } */ public function get_sql_for_clause( &$clause, $parent_query ) { global $wpdb; $sql = array( 'where' => array(), 'join' => array(), ); $join = ''; $where = ''; $this->clean_query( $clause ); if ( is_wp_error( $clause ) ) { return self::$no_results; } $terms = $clause['terms']; $operator = strtoupper( $clause['operator'] ); if ( 'IN' === $operator ) { if ( empty( $terms ) ) { return self::$no_results; } $terms = implode( ',', $terms ); /* * Before creating another table join, see if this clause has a * sibling with an existing join that can be shared. */ $alias = $this->find_compatible_table_alias( $clause, $parent_query ); if ( false === $alias ) { $i = count( $this->table_aliases ); $alias = $i ? 'tt' . $i : $wpdb->term_relationships; // Store the alias as part of a flat array to build future iterators. $this->table_aliases[] = $alias; // Store the alias with this clause, so later siblings can use it. $clause['alias'] = $alias; $join .= " LEFT JOIN $wpdb->term_relationships"; $join .= $i ? " AS $alias" : ''; $join .= " ON ($this->primary_table.$this->primary_id_column = $alias.object_id)"; } $where = "$alias.term_taxonomy_id $operator ($terms)"; } elseif ( 'NOT IN' === $operator ) { if ( empty( $terms ) ) { return $sql; } $terms = implode( ',', $terms ); $where = "$this->primary_table.$this->primary_id_column NOT IN ( SELECT object_id FROM $wpdb->term_relationships WHERE term_taxonomy_id IN ($terms) )"; } elseif ( 'AND' === $operator ) { if ( empty( $terms ) ) { return $sql; } $num_terms = count( $terms ); $terms = implode( ',', $terms ); $where = "( SELECT COUNT(1) FROM $wpdb->term_relationships WHERE term_taxonomy_id IN ($terms) AND object_id = $this->primary_table.$this->primary_id_column ) = $num_terms"; } elseif ( 'NOT EXISTS' === $operator || 'EXISTS' === $operator ) { $where = $wpdb->prepare( "$operator ( SELECT 1 FROM $wpdb->term_relationships INNER JOIN $wpdb->term_taxonomy ON $wpdb->term_taxonomy.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id WHERE $wpdb->term_taxonomy.taxonomy = %s AND $wpdb->term_relationships.object_id = $this->primary_table.$this->primary_id_column )", $clause['taxonomy'] ); } $sql['join'][] = $join; $sql['where'][] = $where; return $sql; } /** * Identifies an existing table alias that is compatible with the current query clause. * * We avoid unnecessary table joins by allowing each clause to look for * an existing table alias that is compatible with the query that it * needs to perform. * * An existing alias is compatible if (a) it is a sibling of `$clause` * (ie, it's under the scope of the same relation), and (b) the combination * of operator and relation between the clauses allows for a shared table * join. In the case of WP_Tax_Query, this only applies to 'IN' * clauses that are connected by the relation 'OR'. * * @since 4.1.0 * * @param array $clause Query clause. * @param array $parent_query Parent query of $clause. * @return string|false Table alias if found, otherwise false. */ protected function find_compatible_table_alias( $clause, $parent_query ) { $alias = false; // Confidence check. Only IN queries use the JOIN syntax. if ( ! isset( $clause['operator'] ) || 'IN' !== $clause['operator'] ) { return $alias; } // Since we're only checking IN queries, we're only concerned with OR relations. if ( ! isset( $parent_query['relation'] ) || 'OR' !== $parent_query['relation'] ) { return $alias; } $compatible_operators = array( 'IN' ); foreach ( $parent_query as $sibling ) { if ( ! is_array( $sibling ) || ! $this->is_first_order_clause( $sibling ) ) { continue; } if ( empty( $sibling['alias'] ) || empty( $sibling['operator'] ) ) { continue; } // The sibling must both have compatible operator to share its alias. if ( in_array( strtoupper( $sibling['operator'] ), $compatible_operators, true ) ) { $alias = preg_replace( '/\W/', '_', $sibling['alias'] ); break; } } return $alias; } /** * Validates a single query. * * @since 3.2.0 * * @param array $query The single query. Passed by reference. */ private function clean_query( &$query ) { if ( empty( $query['taxonomy'] ) ) { if ( 'term_taxonomy_id' !== $query['field'] ) { $query = new WP_Error( 'invalid_taxonomy', __( 'Invalid taxonomy.' ) ); return; } // So long as there are shared terms, 'include_children' requires that a taxonomy is set. $query['include_children'] = false; } elseif ( ! taxonomy_exists( $query['taxonomy'] ) ) { $query = new WP_Error( 'invalid_taxonomy', __( 'Invalid taxonomy.' ) ); return; } if ( 'slug' === $query['field'] || 'name' === $query['field'] ) { $query['terms'] = array_unique( (array) $query['terms'] ); } else { $query['terms'] = wp_parse_id_list( $query['terms'] ); } if ( is_taxonomy_hierarchical( $query['taxonomy'] ) && $query['include_children'] ) { $this->transform_query( $query, 'term_id' ); if ( is_wp_error( $query ) ) { return; } $children = array(); foreach ( $query['terms'] as $term ) { $children = array_merge( $children, get_term_children( $term, $query['taxonomy'] ) ); $children[] = $term; } $query['terms'] = $children; } $this->transform_query( $query, 'term_taxonomy_id' ); } /** * Transforms a single query, from one field to another. * * Operates on the `$query` object by reference. In the case of error, * `$query` is converted to a WP_Error object. * * @since 3.2.0 * * @param array $query The single query. Passed by reference. * @param string $resulting_field The resulting field. Accepts 'slug', 'name', 'term_taxonomy_id', * or 'term_id'. Default 'term_id'. */ public function transform_query( &$query, $resulting_field ) { if ( empty( $query['terms'] ) ) { return; } if ( $query['field'] === $resulting_field ) { return; } $resulting_field = sanitize_key( $resulting_field ); // Empty 'terms' always results in a null transformation. $terms = array_filter( $query['terms'] ); if ( empty( $terms ) ) { $query['terms'] = array(); $query['field'] = $resulting_field; return; } $args = array( 'get' => 'all', 'number' => 0, 'taxonomy' => $query['taxonomy'], 'update_term_meta_cache' => false, 'orderby' => 'none', ); // Term query parameter name depends on the 'field' being searched on. switch ( $query['field'] ) { case 'slug': $args['slug'] = $terms; break; case 'name': $args['name'] = $terms; break; case 'term_taxonomy_id': $args['term_taxonomy_id'] = $terms; break; default: $args['include'] = wp_parse_id_list( $terms ); break; } if ( ! is_taxonomy_hierarchical( $query['taxonomy'] ) ) { $args['number'] = count( $terms ); } $term_query = new WP_Term_Query(); $term_list = $term_query->query( $args ); if ( is_wp_error( $term_list ) ) { $query = $term_list; return; } if ( 'AND' === $query['operator'] && count( $term_list ) < count( $query['terms'] ) ) { $query = new WP_Error( 'inexistent_terms', __( 'Inexistent terms.' ) ); return; } $query['terms'] = wp_list_pluck( $term_list, $resulting_field ); $query['field'] = $resulting_field; } }
Liking