enmi-conf.org: wp/wp-includes/class-wp-term-query.php@3d72ae0968f4 (annotated)

7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1	<?php
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	2
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	3	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	4	* Taxonomy API: WP_Term_Query class.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	5	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	6	* @package WordPress
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	7	* @subpackage Taxonomy
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	8	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	9	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	10
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	11	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	12	* Class used for querying terms.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	13	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	14	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	15	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	16	* @see WP_Term_Query::__construct() for accepted arguments.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	17	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	18	class WP_Term_Query {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	19
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	20	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	21	* SQL string used to perform database query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	22	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	23	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	24	* @var string
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	25	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	26	public $request;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	27
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	28	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	29	* Metadata query container.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	30	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	31	* @since 4.6.0
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	32	* @var WP_Meta_Query A meta query instance.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	33	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	34	public $meta_query = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	35
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	36	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	37	* Metadata query clauses.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	38	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	39	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	40	* @var array
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	41	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	42	protected $meta_query_clauses;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	43
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	44	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	45	* SQL query clauses.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	46	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	47	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	48	* @var array
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	49	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	50	protected $sql_clauses = array(
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	51	'select' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	52	'from' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	53	'where' => array(),
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	54	'orderby' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	55	'limits' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	56	);
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	57
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	58	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	59	* Query vars set by the user.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	60	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	61	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	62	* @var array
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	63	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	64	public $query_vars;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	65
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	66	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	67	* Default values for query vars.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	68	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	69	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	70	* @var array
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	71	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	72	public $query_var_defaults;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	73
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	74	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	75	* List of terms located by the query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	76	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	77	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	78	* @var array
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	79	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	80	public $terms;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	81
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	82	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	83	* Constructor.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	84	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	85	* Sets up the term query, based on the query vars passed.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	86	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	87	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	88	* @since 4.6.0 Introduced 'term_taxonomy_id' parameter.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	89	* @since 4.7.0 Introduced 'object_ids' parameter.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	90	* @since 4.9.0 Added 'slug__in' support for 'orderby'.
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	91	* @since 5.1.0 Introduced the 'meta_compare_key' parameter.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	92	* @since 5.3.0 Introduced the 'meta_type_key' parameter.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	93	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	94	* @param string\|array $query {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	95	* Optional. Array or query string of term query parameters. Default empty.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	96	*
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	97	* @type string\|string[] $taxonomy Taxonomy name, or array of taxonomy names, to which results
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	98	* should be limited.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	99	* @type int\|int[] $object_ids Object ID, or array of object IDs. Results will be
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	100	* limited to terms associated with these objects.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	101	* @type string $orderby Field(s) to order terms by. Accepts:
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	102	* - Term fields ('name', 'slug', 'term_group', 'term_id', 'id',
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	103	* 'description', 'parent', 'term_order'). Unless `$object_ids`
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	104	* is not empty, 'term_order' is treated the same as 'term_id'.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	105	* - 'count' to use the number of objects associated with the term.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	106	* - 'include' to match the 'order' of the `$include` param.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	107	* - 'slug__in' to match the 'order' of the `$slug` param.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	108	* - 'meta_value'
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	109	* - 'meta_value_num'.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	110	* - The value of `$meta_key`.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	111	* - The array keys of `$meta_query`.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	112	* - 'none' to omit the ORDER BY clause.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	113	* Default 'name'.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	114	* @type string $order Whether to order terms in ascending or descending order.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	115	* Accepts 'ASC' (ascending) or 'DESC' (descending).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	116	* Default 'ASC'.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	117	* @type bool\|int $hide_empty Whether to hide terms not assigned to any posts. Accepts
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	118	* 1\|true or 0\|false. Default 1\|true.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	119	* @type int[]\|string $include Array or comma/space-separated string of term IDs to include.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	120	* Default empty array.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	121	* @type int[]\|string $exclude Array or comma/space-separated string of term IDs to exclude.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	122	* If `$include` is non-empty, `$exclude` is ignored.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	123	* Default empty array.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	124	* @type int[]\|string $exclude_tree Array or comma/space-separated string of term IDs to exclude
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	125	* along with all of their descendant terms. If `$include` is
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	126	* non-empty, `$exclude_tree` is ignored. Default empty array.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	127	* @type int\|string $number Maximum number of terms to return. Accepts ''\|0 (all) or any
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	128	* positive number. Default ''\|0 (all). Note that `$number` may
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	129	* not return accurate results when coupled with `$object_ids`.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	130	* See #41796 for details.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	131	* @type int $offset The number by which to offset the terms query. Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	132	* @type string $fields Term fields to query for. Accepts:
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	133	* - 'all' Returns an array of complete term objects (`WP_Term[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	134	* - 'all_with_object_id' Returns an array of term objects
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	135	* with the 'object_id' param (`WP_Term[]`). Works only
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	136	* when the `$object_ids` parameter is populated.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	137	* - 'ids' Returns an array of term IDs (`int[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	138	* - 'tt_ids' Returns an array of term taxonomy IDs (`int[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	139	* - 'names' Returns an array of term names (`string[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	140	* - 'slugs' Returns an array of term slugs (`string[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	141	* - 'count' Returns the number of matching terms (`int`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	142	* - 'id=>parent' Returns an associative array of parent term IDs,
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	143	* keyed by term ID (`int[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	144	* - 'id=>name' Returns an associative array of term names,
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	145	* keyed by term ID (`string[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	146	* - 'id=>slug' Returns an associative array of term slugs,
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	147	* keyed by term ID (`string[]`).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	148	* Default 'all'.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	149	* @type bool $count Whether to return a term count. If true, will take precedence
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	150	* over `$fields`. Default false.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	151	* @type string\|string[] $name Name or array of names to return term(s) for.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	152	* Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	153	* @type string\|string[] $slug Slug or array of slugs to return term(s) for.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	154	* Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	155	* @type int\|int[] $term_taxonomy_id Term taxonomy ID, or array of term taxonomy IDs,
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	156	* to match when querying terms.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	157	* @type bool $hierarchical Whether to include terms that have non-empty descendants
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	158	* (even if `$hide_empty` is set to true). Default true.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	159	* @type string $search Search criteria to match terms. Will be SQL-formatted with
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	160	* wildcards before and after. Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	161	* @type string $name__like Retrieve terms with criteria by which a term is LIKE
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	162	* `$name__like`. Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	163	* @type string $description__like Retrieve terms where the description is LIKE
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	164	* `$description__like`. Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	165	* @type bool $pad_counts Whether to pad the quantity of a term's children in the
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	166	* quantity of each term's "count" object variable.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	167	* Default false.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	168	* @type string $get Whether to return terms regardless of ancestry or whether the
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	169	* terms are empty. Accepts 'all' or '' (disabled).
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	170	* Default ''.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	171	* @type int $child_of Term ID to retrieve child terms of. If multiple taxonomies
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	172	* are passed, `$child_of` is ignored. Default 0.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	173	* @type int $parent Parent term ID to retrieve direct-child terms of.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	174	* Default empty.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	175	* @type bool $childless True to limit results to terms that have no children.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	176	* This parameter has no effect on non-hierarchical taxonomies.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	177	* Default false.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	178	* @type string $cache_domain Unique cache key to be produced when this query is stored in
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	179	* an object cache. Default 'core'.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	180	* @type bool $update_term_meta_cache Whether to prime meta caches for matched terms. Default true.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	181	* @type string\|string[] $meta_key Meta key or keys to filter by.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	182	* @type string\|string[] $meta_value Meta value or values to filter by.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	183	* @type string $meta_compare MySQL operator used for comparing the meta value.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	184	* See WP_Meta_Query::__construct for accepted values and default value.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	185	* @type string $meta_compare_key MySQL operator used for comparing the meta key.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	186	* See WP_Meta_Query::__construct for accepted values and default value.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	187	* @type string $meta_type MySQL data type that the meta_value column will be CAST to for comparisons.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	188	* See WP_Meta_Query::__construct for accepted values and default value.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	189	* @type string $meta_type_key MySQL data type that the meta_key column will be CAST to for comparisons.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	190	* See WP_Meta_Query::__construct for accepted values and default value.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	191	* @type array $meta_query An associative array of WP_Meta_Query arguments.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	192	* See WP_Meta_Query::__construct for accepted values.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	193	* }
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	194	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	195	public function __construct( $query = '' ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	196	$this->query_var_defaults = array(
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	197	'taxonomy' => null,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	198	'object_ids' => null,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	199	'orderby' => 'name',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	200	'order' => 'ASC',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	201	'hide_empty' => true,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	202	'include' => array(),
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	203	'exclude' => array(),
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	204	'exclude_tree' => array(),
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	205	'number' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	206	'offset' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	207	'fields' => 'all',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	208	'count' => false,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	209	'name' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	210	'slug' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	211	'term_taxonomy_id' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	212	'hierarchical' => true,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	213	'search' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	214	'name__like' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	215	'description__like' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	216	'pad_counts' => false,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	217	'get' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	218	'child_of' => 0,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	219	'parent' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	220	'childless' => false,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	221	'cache_domain' => 'core',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	222	'update_term_meta_cache' => true,
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	223	'meta_query' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	224	'meta_key' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	225	'meta_value' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	226	'meta_type' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	227	'meta_compare' => '',
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	228	);
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	229
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	230	if ( ! empty( $query ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	231	$this->query( $query );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	232	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	233	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	234
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	235	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	236	* Parse arguments passed to the term query with default query parameters.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	237	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	238	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	239	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	240	* @param string\|array $query WP_Term_Query arguments. See WP_Term_Query::__construct()
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	241	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	242	public function parse_query( $query = '' ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	243	if ( empty( $query ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	244	$query = $this->query_vars;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	245	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	246
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	247	$taxonomies = isset( $query['taxonomy'] ) ? (array) $query['taxonomy'] : null;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	248
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	249	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	250	* Filters the terms query default arguments.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	251	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	252	* Use {@see 'get_terms_args'} to filter the passed arguments.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	253	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	254	* @since 4.4.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	255	*
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	256	* @param array $defaults An array of default get_terms() arguments.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	257	* @param string[] $taxonomies An array of taxonomy names.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	258	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	259	$this->query_var_defaults = apply_filters( 'get_terms_defaults', $this->query_var_defaults, $taxonomies );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	260
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	261	$query = wp_parse_args( $query, $this->query_var_defaults );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	262
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	263	$query['number'] = absint( $query['number'] );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	264	$query['offset'] = absint( $query['offset'] );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	265
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	266	// 'parent' overrides 'child_of'.
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	267	if ( 0 < (int) $query['parent'] ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	268	$query['child_of'] = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	269	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	270
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	271	if ( 'all' === $query['get'] ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	272	$query['childless'] = false;
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	273	$query['child_of'] = 0;
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	274	$query['hide_empty'] = 0;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	275	$query['hierarchical'] = false;
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	276	$query['pad_counts'] = false;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	277	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	278
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	279	$query['taxonomy'] = $taxonomies;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	280
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	281	$this->query_vars = $query;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	282
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	283	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	284	* Fires after term query vars have been parsed.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	285	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	286	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	287	*
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	288	* @param WP_Term_Query $query Current instance of WP_Term_Query.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	289	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	290	do_action( 'parse_term_query', $this );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	291	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	292
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	293	/**
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	294	* Sets up the query and retrieves the results.
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	295	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	296	* The return type varies depending on the value passed to `$args['fields']`. See
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	297	* WP_Term_Query::get_terms() for details.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	298	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	299	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	300	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	301	* @param string\|array $query Array or URL query string of parameters.
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	302	* @return WP_Term[]\|int[]\|string[]\|string Array of terms, or number of terms as numeric string
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	303	* when 'count' is passed as a query var.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	304	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	305	public function query( $query ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	306	$this->query_vars = wp_parse_args( $query );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	307	return $this->get_terms();
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	308	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	309
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	310	/**
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	311	* Retrieves the query results.
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	312	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	313	* The return type varies depending on the value passed to `$args['fields']`.
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	314	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	315	* The following will result in an array of `WP_Term` objects being returned:
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	316	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	317	* - 'all'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	318	* - 'all_with_object_id'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	319	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	320	* The following will result in a numeric string being returned:
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	321	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	322	* - 'count'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	323	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	324	* The following will result in an array of text strings being returned:
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	325	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	326	* - 'id=>name'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	327	* - 'id=>slug'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	328	* - 'names'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	329	* - 'slugs'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	330	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	331	* The following will result in an array of numeric strings being returned:
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	332	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	333	* - 'id=>parent'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	334	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	335	* The following will result in an array of integers being returned:
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	336	*
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	337	* - 'ids'
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	338	* - 'tt_ids'
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	339	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	340	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	341	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	342	* @global wpdb $wpdb WordPress database abstraction object.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	343	*
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	344	* @return WP_Term[]\|int[]\|string[]\|string Array of terms, or number of terms as numeric string
be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	345	* when 'count' is passed as a query var.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	346	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	347	public function get_terms() {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	348	global $wpdb;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	349
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	350	$this->parse_query( $this->query_vars );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	351	$args = &$this->query_vars;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	352
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	353	// Set up meta_query so it's available to 'pre_get_terms'.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	354	$this->meta_query = new WP_Meta_Query();
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	355	$this->meta_query->parse_query_vars( $args );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	356
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	357	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	358	* Fires before terms are retrieved.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	359	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	360	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	361	*
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	362	* @param WP_Term_Query $query Current instance of WP_Term_Query (passed by reference).
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	363	*/
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	364	do_action_ref_array( 'pre_get_terms', array( &$this ) );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	365
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	366	$taxonomies = (array) $args['taxonomy'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	367
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	368	// Save queries by not crawling the tree in the case of multiple taxes or a flat tax.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	369	$has_hierarchical_tax = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	370	if ( $taxonomies ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	371	foreach ( $taxonomies as $_tax ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	372	if ( is_taxonomy_hierarchical( $_tax ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	373	$has_hierarchical_tax = true;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	374	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	375	}
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	376	} else {
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	377	// When no taxonomies are provided, assume we have to descend the tree.
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	378	$has_hierarchical_tax = true;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	379	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	380
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	381	if ( ! $has_hierarchical_tax ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	382	$args['hierarchical'] = false;
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	383	$args['pad_counts'] = false;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	384	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	385
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	386	// 'parent' overrides 'child_of'.
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	387	if ( 0 < (int) $args['parent'] ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	388	$args['child_of'] = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	389	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	390
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	391	if ( 'all' === $args['get'] ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	392	$args['childless'] = false;
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	393	$args['child_of'] = 0;
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	394	$args['hide_empty'] = 0;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	395	$args['hierarchical'] = false;
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	396	$args['pad_counts'] = false;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	397	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	398
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	399	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	400	* Filters the terms query arguments.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	401	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	402	* @since 3.1.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	403	*
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	404	* @param array $args An array of get_terms() arguments.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	405	* @param string[] $taxonomies An array of taxonomy names.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	406	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	407	$args = apply_filters( 'get_terms_args', $args, $taxonomies );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	408
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	409	// Avoid the query if the queried parent/child_of term has no descendants.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	410	$child_of = $args['child_of'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	411	$parent = $args['parent'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	412
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	413	if ( $child_of ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	414	$_parent = $child_of;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	415	} elseif ( $parent ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	416	$_parent = $parent;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	417	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	418	$_parent = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	419	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	420
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	421	if ( $_parent ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	422	$in_hierarchy = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	423	foreach ( $taxonomies as $_tax ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	424	$hierarchy = _get_term_hierarchy( $_tax );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	425
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	426	if ( isset( $hierarchy[ $_parent ] ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	427	$in_hierarchy = true;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	428	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	429	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	430
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	431	if ( ! $in_hierarchy ) {
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	432	if ( 'count' === $args['fields'] ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	433	return 0;
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	434	} else {
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	435	$this->terms = array();
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	436	return $this->terms;
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	437	}
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	438	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	439	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	440
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	441	// 'term_order' is a legal sort order only when joining the relationship table.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	442	$_orderby = $this->query_vars['orderby'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	443	if ( 'term_order' === $_orderby && empty( $this->query_vars['object_ids'] ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	444	$_orderby = 'term_id';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	445	}
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	446
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	447	$orderby = $this->parse_orderby( $_orderby );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	448
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	449	if ( $orderby ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	450	$orderby = "ORDER BY $orderby";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	451	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	452
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	453	$order = $this->parse_order( $this->query_vars['order'] );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	454
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	455	if ( $taxonomies ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	456	$this->sql_clauses['where']['taxonomy'] =
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	457	"tt.taxonomy IN ('" . implode( "', '", array_map( 'esc_sql', $taxonomies ) ) . "')";
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	458	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	459
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	460	if ( empty( $args['exclude'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	461	$args['exclude'] = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	462	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	463
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	464	if ( empty( $args['include'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	465	$args['include'] = array();
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	466	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	467
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	468	$exclude = $args['exclude'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	469	$exclude_tree = $args['exclude_tree'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	470	$include = $args['include'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	471
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	472	$inclusions = '';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	473	if ( ! empty( $include ) ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	474	$exclude = '';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	475	$exclude_tree = '';
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	476	$inclusions = implode( ',', wp_parse_id_list( $include ) );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	477	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	478
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	479	if ( ! empty( $inclusions ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	480	$this->sql_clauses['where']['inclusions'] = 't.term_id IN ( ' . $inclusions . ' )';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	481	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	482
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	483	$exclusions = array();
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	484	if ( ! empty( $exclude_tree ) ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	485	$exclude_tree = wp_parse_id_list( $exclude_tree );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	486	$excluded_children = $exclude_tree;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	487	foreach ( $exclude_tree as $extrunk ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	488	$excluded_children = array_merge(
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	489	$excluded_children,
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	490	(array) get_terms(
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	491	array(
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	492	'taxonomy' => reset( $taxonomies ),
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	493	'child_of' => (int) $extrunk,
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	494	'fields' => 'ids',
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	495	'hide_empty' => 0,
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	496	)
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	497	)
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	498	);
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	499	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	500	$exclusions = array_merge( $excluded_children, $exclusions );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	501	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	502
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	503	if ( ! empty( $exclude ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	504	$exclusions = array_merge( wp_parse_id_list( $exclude ), $exclusions );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	505	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	506
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	507	// 'childless' terms are those without an entry in the flattened term hierarchy.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	508	$childless = (bool) $args['childless'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	509	if ( $childless ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	510	foreach ( $taxonomies as $_tax ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	511	$term_hierarchy = _get_term_hierarchy( $_tax );
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	512	$exclusions = array_merge( array_keys( $term_hierarchy ), $exclusions );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	513	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	514	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	515
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	516	if ( ! empty( $exclusions ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	517	$exclusions = 't.term_id NOT IN (' . implode( ',', array_map( 'intval', $exclusions ) ) . ')';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	518	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	519	$exclusions = '';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	520	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	521
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	522	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	523	* Filters the terms to exclude from the terms query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	524	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	525	* @since 2.3.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	526	*
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	527	* @param string $exclusions `NOT IN` clause of the terms query.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	528	* @param array $args An array of terms query arguments.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	529	* @param string[] $taxonomies An array of taxonomy names.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	530	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	531	$exclusions = apply_filters( 'list_terms_exclusions', $exclusions, $args, $taxonomies );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	532
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	533	if ( ! empty( $exclusions ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	534	// Must do string manipulation here for backward compatibility with filter.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	535	$this->sql_clauses['where']['exclusions'] = preg_replace( '/^\sAND\s/', '', $exclusions );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	536	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	537
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	538	if ( '' === $args['name'] ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	539	$args['name'] = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	540	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	541	$args['name'] = (array) $args['name'];
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	542	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	543
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	544	if ( ! empty( $args['name'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	545	$names = $args['name'];
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	546	foreach ( $names as &$_name ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	547	// `sanitize_term_field()` returns slashed data.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	548	$_name = stripslashes( sanitize_term_field( 'name', $_name, 0, reset( $taxonomies ), 'db' ) );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	549	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	550
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	551	$this->sql_clauses['where']['name'] = "t.name IN ('" . implode( "', '", array_map( 'esc_sql', $names ) ) . "')";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	552	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	553
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	554	if ( '' === $args['slug'] ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	555	$args['slug'] = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	556	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	557	$args['slug'] = array_map( 'sanitize_title', (array) $args['slug'] );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	558	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	559
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	560	if ( ! empty( $args['slug'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	561	$slug = implode( "', '", $args['slug'] );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	562
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	563	$this->sql_clauses['where']['slug'] = "t.slug IN ('" . $slug . "')";
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	564	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	565
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	566	if ( '' === $args['term_taxonomy_id'] ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	567	$args['term_taxonomy_id'] = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	568	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	569	$args['term_taxonomy_id'] = array_map( 'intval', (array) $args['term_taxonomy_id'] );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	570	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	571
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	572	if ( ! empty( $args['term_taxonomy_id'] ) ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	573	$tt_ids = implode( ',', $args['term_taxonomy_id'] );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	574
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	575	$this->sql_clauses['where']['term_taxonomy_id'] = "tt.term_taxonomy_id IN ({$tt_ids})";
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	576	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	577
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	578	if ( ! empty( $args['name__like'] ) ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	579	$this->sql_clauses['where']['name__like'] = $wpdb->prepare(
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	580	't.name LIKE %s',
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	581	'%' . $wpdb->esc_like( $args['name__like'] ) . '%'
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	582	);
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	583	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	584
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	585	if ( ! empty( $args['description__like'] ) ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	586	$this->sql_clauses['where']['description__like'] = $wpdb->prepare(
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	587	'tt.description LIKE %s',
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	588	'%' . $wpdb->esc_like( $args['description__like'] ) . '%'
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	589	);
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	590	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	591
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	592	if ( '' === $args['object_ids'] ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	593	$args['object_ids'] = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	594	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	595	$args['object_ids'] = array_map( 'intval', (array) $args['object_ids'] );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	596	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	597
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	598	if ( ! empty( $args['object_ids'] ) ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	599	$object_ids = implode( ', ', $args['object_ids'] );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	600
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	601	$this->sql_clauses['where']['object_ids'] = "tr.object_id IN ($object_ids)";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	602	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	603
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	604	/*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	605	* When querying for object relationships, the 'count > 0' check
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	606	* added by 'hide_empty' is superfluous.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	607	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	608	if ( ! empty( $args['object_ids'] ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	609	$args['hide_empty'] = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	610	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	611
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	612	if ( '' !== $parent ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	613	$parent = (int) $parent;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	614	$this->sql_clauses['where']['parent'] = "tt.parent = '$parent'";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	615	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	616
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	617	$hierarchical = $args['hierarchical'];
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	618	if ( 'count' === $args['fields'] ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	619	$hierarchical = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	620	}
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	621	if ( $args['hide_empty'] && ! $hierarchical ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	622	$this->sql_clauses['where']['count'] = 'tt.count > 0';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	623	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	624
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	625	$number = $args['number'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	626	$offset = $args['offset'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	627
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	628	// Don't limit the query results when we have to descend the family tree.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	629	if ( $number && ! $hierarchical && ! $child_of && '' === $parent ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	630	if ( $offset ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	631	$limits = 'LIMIT ' . $offset . ',' . $number;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	632	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	633	$limits = 'LIMIT ' . $number;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	634	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	635	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	636	$limits = '';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	637	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	638
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	639	if ( ! empty( $args['search'] ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	640	$this->sql_clauses['where']['search'] = $this->get_search_sql( $args['search'] );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	641	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	642
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	643	// Meta query support.
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	644	$join = '';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	645	$distinct = '';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	646
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	647	// Reparse meta_query query_vars, in case they were modified in a 'pre_get_terms' callback.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	648	$this->meta_query->parse_query_vars( $this->query_vars );
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	649	$mq_sql = $this->meta_query->get_sql( 'term', 't', 'term_id' );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	650	$meta_clauses = $this->meta_query->get_clauses();
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	651
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	652	if ( ! empty( $meta_clauses ) ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	653	$join .= $mq_sql['join'];
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	654	$this->sql_clauses['where']['meta_query'] = preg_replace( '/^\sAND\s/', '', $mq_sql['where'] );
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	655	$distinct .= 'DISTINCT';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	656
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	657	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	658
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	659	$selects = array();
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	660	switch ( $args['fields'] ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	661	case 'count':
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	662	$orderby = '';
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	663	$order = '';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	664	$selects = array( 'COUNT(*)' );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	665	break;
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	666	default:
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	667	$selects = array( 't.term_id' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	668	if ( 'all_with_object_id' === $args['fields'] && ! empty( $args['object_ids'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	669	$selects[] = 'tr.object_id';
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	670	}
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	671	break;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	672	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	673
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	674	$_fields = $args['fields'];
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	675
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	676	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	677	* Filters the fields to select in the terms query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	678	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	679	* Field lists modified using this filter will only modify the term fields returned
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	680	* by the function when the `$fields` parameter set to 'count' or 'all'. In all other
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	681	* cases, the term fields in the results array will be determined by the `$fields`
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	682	* parameter alone.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	683	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	684	* Use of this filter can result in unpredictable behavior, and is not recommended.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	685	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	686	* @since 2.8.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	687	*
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	688	* @param string[] $selects An array of fields to select for the terms query.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	689	* @param array $args An array of term query arguments.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	690	* @param string[] $taxonomies An array of taxonomy names.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	691	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	692	$fields = implode( ', ', apply_filters( 'get_terms_fields', $selects, $args, $taxonomies ) );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	693
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	694	$join .= " INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	695
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	696	if ( ! empty( $this->query_vars['object_ids'] ) ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	697	$join .= " INNER JOIN {$wpdb->term_relationships} AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id";
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	698	$distinct = 'DISTINCT';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	699	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	700
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	701	$where = implode( ' AND ', $this->sql_clauses['where'] );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	702
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	703	$clauses = array( 'fields', 'join', 'where', 'distinct', 'orderby', 'order', 'limits' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	704
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	705	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	706	* Filters the terms query SQL clauses.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	707	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	708	* @since 3.1.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	709	*
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	710	* @param string[] $clauses {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	711	* Associative array of the clauses for the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	712	*
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	713	* @type string $fields The SELECT clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	714	* @type string $join The JOIN clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	715	* @type string $where The WHERE clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	716	* @type string $distinct The DISTINCT clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	717	* @type string $orderby The ORDER BY clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	718	* @type string $order The ORDER clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	719	* @type string $limits The LIMIT clause of the query.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	720	* }
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	721	* @param string[] $taxonomies An array of taxonomy names.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	722	* @param array $args An array of term query arguments.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	723	*/
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	724	$clauses = apply_filters( 'terms_clauses', compact( $clauses ), $taxonomies, $args );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	725
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	726	$fields = isset( $clauses['fields'] ) ? $clauses['fields'] : '';
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	727	$join = isset( $clauses['join'] ) ? $clauses['join'] : '';
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	728	$where = isset( $clauses['where'] ) ? $clauses['where'] : '';
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	729	$distinct = isset( $clauses['distinct'] ) ? $clauses['distinct'] : '';
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	730	$orderby = isset( $clauses['orderby'] ) ? $clauses['orderby'] : '';
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	731	$order = isset( $clauses['order'] ) ? $clauses['order'] : '';
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	732	$limits = isset( $clauses['limits'] ) ? $clauses['limits'] : '';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	733
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	734	if ( $where ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	735	$where = "WHERE $where";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	736	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	737
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	738	$this->sql_clauses['select'] = "SELECT $distinct $fields";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	739	$this->sql_clauses['from'] = "FROM $wpdb->terms AS t $join";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	740	$this->sql_clauses['orderby'] = $orderby ? "$orderby $order" : '';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	741	$this->sql_clauses['limits'] = $limits;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	742
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	743	$this->request = "
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	744	{$this->sql_clauses['select']}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	745	{$this->sql_clauses['from']}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	746	{$where}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	747	{$this->sql_clauses['orderby']}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	748	{$this->sql_clauses['limits']}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	749	";
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	750
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	751	$this->terms = null;
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	752
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	753	/**
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	754	* Filters the terms array before the query takes place.
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	755	*
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	756	* Return a non-null value to bypass WordPress' default term queries.
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	757	*
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	758	* @since 5.3.0
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	759	*
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	760	* @param array\|null $terms Return an array of term data to short-circuit WP's term query,
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	761	* or null to allow WP queries to run normally.
18 be944660c56a Site enmi version 09/2022 ymh <ymh.work@gmail.com> parents: 16 diff changeset	762	* @param WP_Term_Query $query The WP_Term_Query instance, passed by reference.
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	763	*/
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	764	$this->terms = apply_filters_ref_array( 'terms_pre_query', array( $this->terms, &$this ) );
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	765
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	766	if ( null !== $this->terms ) {
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	767	return $this->terms;
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	768	}
a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	769
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	770	// $args can be anything. Only use the args defined in defaults to compute the key.
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	771	$cache_args = wp_array_slice_assoc( $args, array_keys( $this->query_var_defaults ) );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	772
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	773	unset( $cache_args['update_term_meta_cache'] );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	774
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	775	if ( 'count' !== $_fields && 'all_with_object_id' !== $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	776	$cache_args['fields'] = 'all';
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	777	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	778
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	779	$key = md5( serialize( $cache_args ) . serialize( $taxonomies ) . $this->request );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	780	$last_changed = wp_cache_get_last_changed( 'terms' );
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	781	$cache_key = "get_terms:$key:$last_changed";
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	782	$cache = wp_cache_get( $cache_key, 'terms' );
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	783
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	784	if ( false !== $cache ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	785	if ( 'ids' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	786	$cache = array_map( 'intval', $cache );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	787	} elseif ( 'count' !== $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	788	if ( ( 'all_with_object_id' === $_fields && ! empty( $args['object_ids'] ) ) \|\| ( 'all' === $_fields && $args['pad_counts'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	789	$term_ids = wp_list_pluck( $cache, 'term_id' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	790	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	791	$term_ids = array_map( 'intval', $cache );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	792	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	793	_prime_term_caches( $term_ids, $args['update_term_meta_cache'] );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	794	$term_objects = $this->populate_terms( $cache );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	795	$cache = $this->format_terms( $term_objects, $_fields );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	796	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	797
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	798	$this->terms = $cache;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	799	return $this->terms;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	800	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	801
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	802	if ( 'count' === $_fields ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	803	$count = $wpdb->get_var( $this->request ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	804	wp_cache_set( $cache_key, $count, 'terms' );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	805	return $count;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	806	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	807
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	808	$terms = $wpdb->get_results( $this->request ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	809
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	810	if ( empty( $terms ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	811	wp_cache_add( $cache_key, array(), 'terms' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	812	return array();
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	813	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	814
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	815	$term_ids = wp_list_pluck( $terms, 'term_id' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	816	_prime_term_caches( $term_ids, false );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	817	$term_objects = $this->populate_terms( $terms );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	818
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	819	if ( $child_of ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	820	foreach ( $taxonomies as $_tax ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	821	$children = _get_term_hierarchy( $_tax );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	822	if ( ! empty( $children ) ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	823	$term_objects = _get_term_children( $child_of, $term_objects, $_tax );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	824	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	825	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	826	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	827
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	828	// Update term counts to include children.
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	829	if ( $args['pad_counts'] && 'all' === $_fields ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	830	foreach ( $taxonomies as $_tax ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	831	_pad_term_counts( $term_objects, $_tax );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	832	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	833	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	834
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	835	// Make sure we show empty categories that have children.
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	836	if ( $hierarchical && $args['hide_empty'] && is_array( $term_objects ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	837	foreach ( $term_objects as $k => $term ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	838	if ( ! $term->count ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	839	$children = get_term_children( $term->term_id, $term->taxonomy );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	840	if ( is_array( $children ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	841	foreach ( $children as $child_id ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	842	$child = get_term( $child_id, $term->taxonomy );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	843	if ( $child->count ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	844	continue 2;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	845	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	846	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	847	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	848
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	849	// It really is empty.
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	850	unset( $term_objects[ $k ] );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	851	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	852	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	853	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	854
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	855	// Hierarchical queries are not limited, so 'offset' and 'number' must be handled now.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	856	if ( $hierarchical && $number && is_array( $term_objects ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	857	if ( $offset >= count( $term_objects ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	858	$term_objects = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	859	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	860	$term_objects = array_slice( $term_objects, $offset, $number, true );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	861	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	862	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	863
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	864	// Prime termmeta cache.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	865	if ( $args['update_term_meta_cache'] ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	866	$term_ids = wp_list_pluck( $term_objects, 'term_id' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	867	update_termmeta_cache( $term_ids );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	868	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	869
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	870	if ( 'all_with_object_id' === $_fields && ! empty( $args['object_ids'] ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	871	$term_cache = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	872	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	873	$object = new stdClass();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	874	$object->term_id = $term->term_id;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	875	$object->object_id = $term->object_id;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	876	$term_cache[] = $object;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	877	}
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	878	} elseif ( 'all' === $_fields && $args['pad_counts'] ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	879	$term_cache = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	880	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	881	$object = new stdClass();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	882	$object->term_id = $term->term_id;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	883	$object->count = $term->count;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	884	$term_cache[] = $object;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	885	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	886	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	887	$term_cache = wp_list_pluck( $term_objects, 'term_id' );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	888	}
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	889	wp_cache_add( $cache_key, $term_cache, 'terms' );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	890	$this->terms = $this->format_terms( $term_objects, $_fields );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	891
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	892	return $this->terms;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	893	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	894
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	895	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	896	* Parse and sanitize 'orderby' keys passed to the term query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	897	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	898	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	899	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	900	* @global wpdb $wpdb WordPress database abstraction object.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	901	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	902	* @param string $orderby_raw Alias for the field to order by.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	903	* @return string\|false Value to used in the ORDER clause. False otherwise.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	904	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	905	protected function parse_orderby( $orderby_raw ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	906	$_orderby = strtolower( $orderby_raw );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	907	$maybe_orderby_meta = false;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	908
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	909	if ( in_array( $_orderby, array( 'term_id', 'name', 'slug', 'term_group' ), true ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	910	$orderby = "t.$_orderby";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	911	} elseif ( in_array( $_orderby, array( 'count', 'parent', 'taxonomy', 'term_taxonomy_id', 'description' ), true ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	912	$orderby = "tt.$_orderby";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	913	} elseif ( 'term_order' === $_orderby ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	914	$orderby = 'tr.term_order';
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	915	} elseif ( 'include' === $_orderby && ! empty( $this->query_vars['include'] ) ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	916	$include = implode( ',', wp_parse_id_list( $this->query_vars['include'] ) );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	917	$orderby = "FIELD( t.term_id, $include )";
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	918	} elseif ( 'slug__in' === $_orderby && ! empty( $this->query_vars['slug'] ) && is_array( $this->query_vars['slug'] ) ) {
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	919	$slugs = implode( "', '", array_map( 'sanitize_title_for_query', $this->query_vars['slug'] ) );
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	920	$orderby = "FIELD( t.slug, '" . $slugs . "')";
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	921	} elseif ( 'none' === $_orderby ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	922	$orderby = '';
16 a86126ab1dd4 update enmi-conf ymh <ymh.work@gmail.com> parents: 9 diff changeset	923	} elseif ( empty( $_orderby ) \|\| 'id' === $_orderby \|\| 'term_id' === $_orderby ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	924	$orderby = 't.term_id';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	925	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	926	$orderby = 't.name';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	927
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	928	// This may be a value of orderby related to meta.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	929	$maybe_orderby_meta = true;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	930	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	931
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	932	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	933	* Filters the ORDERBY clause of the terms query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	934	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	935	* @since 2.8.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	936	*
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	937	* @param string $orderby `ORDERBY` clause of the terms query.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	938	* @param array $args An array of term query arguments.
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	939	* @param string[] $taxonomies An array of taxonomy names.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	940	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	941	$orderby = apply_filters( 'get_terms_orderby', $orderby, $this->query_vars, $this->query_vars['taxonomy'] );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	942
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	943	// Run after the 'get_terms_orderby' filter for backward compatibility.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	944	if ( $maybe_orderby_meta ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	945	$maybe_orderby_meta = $this->parse_orderby_meta( $_orderby );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	946	if ( $maybe_orderby_meta ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	947	$orderby = $maybe_orderby_meta;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	948	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	949	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	950
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	951	return $orderby;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	952	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	953
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	954	/**
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	955	* Format response depending on field requested.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	956	*
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	957	* @since 6.0.0
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	958	*
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	959	* @param WP_Term[] $term_objects Array of term objects.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	960	* @param string $_fields Field to format.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	961	*
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	962	* @return WP_Term[]\|int[]\|string[] Array of terms / strings / ints depending on field requested.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	963	*/
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	964	protected function format_terms( $term_objects, $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	965	$_terms = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	966	if ( 'id=>parent' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	967	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	968	$_terms[ $term->term_id ] = $term->parent;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	969	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	970	} elseif ( 'ids' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	971	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	972	$_terms[] = (int) $term->term_id;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	973	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	974	} elseif ( 'tt_ids' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	975	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	976	$_terms[] = (int) $term->term_taxonomy_id;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	977	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	978	} elseif ( 'names' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	979	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	980	$_terms[] = $term->name;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	981	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	982	} elseif ( 'slugs' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	983	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	984	$_terms[] = $term->slug;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	985	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	986	} elseif ( 'id=>name' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	987	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	988	$_terms[ $term->term_id ] = $term->name;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	989	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	990	} elseif ( 'id=>slug' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	991	foreach ( $term_objects as $term ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	992	$_terms[ $term->term_id ] = $term->slug;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	993	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	994	} elseif ( 'all' === $_fields \|\| 'all_with_object_id' === $_fields ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	995	$_terms = $term_objects;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	996	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	997
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	998	return $_terms;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	999	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1000
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1001	/**
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1002	* Generate the ORDER BY clause for an 'orderby' param that is potentially related to a meta query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1003	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1004	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1005	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1006	* @param string $orderby_raw Raw 'orderby' value passed to WP_Term_Query.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1007	* @return string ORDER BY clause.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1008	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1009	protected function parse_orderby_meta( $orderby_raw ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1010	$orderby = '';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1011
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1012	// Tell the meta query to generate its SQL, so we have access to table aliases.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1013	$this->meta_query->get_sql( 'term', 't', 'term_id' );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1014	$meta_clauses = $this->meta_query->get_clauses();
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1015	if ( ! $meta_clauses \|\| ! $orderby_raw ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1016	return $orderby;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1017	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1018
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	1019	$allowed_keys = array();
177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	1020	$primary_meta_key = null;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1021	$primary_meta_query = reset( $meta_clauses );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1022	if ( ! empty( $primary_meta_query['key'] ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1023	$primary_meta_key = $primary_meta_query['key'];
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	1024	$allowed_keys[] = $primary_meta_key;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1025	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1026	$allowed_keys[] = 'meta_value';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1027	$allowed_keys[] = 'meta_value_num';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1028	$allowed_keys = array_merge( $allowed_keys, array_keys( $meta_clauses ) );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1029
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1030	if ( ! in_array( $orderby_raw, $allowed_keys, true ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1031	return $orderby;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1032	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1033
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	1034	switch ( $orderby_raw ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1035	case $primary_meta_key:
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1036	case 'meta_value':
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1037	if ( ! empty( $primary_meta_query['type'] ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1038	$orderby = "CAST({$primary_meta_query['alias']}.meta_value AS {$primary_meta_query['cast']})";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1039	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1040	$orderby = "{$primary_meta_query['alias']}.meta_value";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1041	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1042	break;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1043
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1044	case 'meta_value_num':
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1045	$orderby = "{$primary_meta_query['alias']}.meta_value+0";
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1046	break;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1047
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1048	default:
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1049	if ( array_key_exists( $orderby_raw, $meta_clauses ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1050	// $orderby corresponds to a meta_query clause.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1051	$meta_clause = $meta_clauses[ $orderby_raw ];
9 177826044cd9 upgrade wordpress to 5.2.3 ymh <ymh.work@gmail.com> parents: 7 diff changeset	1052	$orderby = "CAST({$meta_clause['alias']}.meta_value AS {$meta_clause['cast']})";
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1053	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1054	break;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1055	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1056
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1057	return $orderby;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1058	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1059
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1060	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1061	* Parse an 'order' query variable and cast it to ASC or DESC as necessary.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1062	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1063	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1064	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1065	* @param string $order The 'order' query variable.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1066	* @return string The sanitized 'order' query variable.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1067	*/
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1068	protected function parse_order( $order ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1069	if ( ! is_string( $order ) \|\| empty( $order ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1070	return 'DESC';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1071	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1072
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1073	if ( 'ASC' === strtoupper( $order ) ) {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1074	return 'ASC';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1075	} else {
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1076	return 'DESC';
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1077	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1078	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1079
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1080	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1081	* Used internally to generate a SQL string related to the 'search' parameter.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1082	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1083	* @since 4.6.0
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1084	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1085	* @global wpdb $wpdb WordPress database abstraction object.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1086	*
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1087	* @param string $search Search string.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1088	* @return string Search SQL.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1089	*/
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1090	protected function get_search_sql( $search ) {
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1091	global $wpdb;
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1092
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1093	$like = '%' . $wpdb->esc_like( $search ) . '%';
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1094
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1095	return $wpdb->prepare( '((t.name LIKE %s) OR (t.slug LIKE %s))', $like, $like );
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1096	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1097
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1098	/**
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1099	* Creates an array of term objects from an array of term IDs.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1100	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1101	* Also discards invalid term objects.
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1102	*
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1103	* @since 4.9.8
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1104	*
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1105	* @param Object[]\|int[] $terms List of objects or term ids.
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1106	* @return WP_Term[] Array of `WP_Term` objects.
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1107	*/
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1108	protected function populate_terms( $terms ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1109	$term_objects = array();
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1110	if ( ! is_array( $terms ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1111	return $term_objects;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1112	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1113
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1114	foreach ( $terms as $key => $term_data ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1115	if ( is_object( $term_data ) && property_exists( $term_data, 'term_id' ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1116	$term = get_term( $term_data->term_id );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1117	if ( property_exists( $term_data, 'object_id' ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1118	$term->object_id = (int) $term_data->object_id;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1119	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1120	if ( property_exists( $term_data, 'count' ) ) {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1121	$term->count = (int) $term_data->count;
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1122	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1123	} else {
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1124	$term = get_term( $term_data );
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1125	}
3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1126
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1127	if ( $term instanceof WP_Term ) {
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1128	$term_objects[ $key ] = $term;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1129	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1130	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1131
19 3d72ae0968f4 upgrade wordpress to 6.0.2 ymh <ymh.work@gmail.com> parents: 18 diff changeset	1132	return $term_objects;
7 cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1133	}
cf61fcea0001 resynchronize code repo with production ymh <ymh.work@gmail.com> parents: diff changeset	1134	}

author	ymh <ymh.work@gmail.com>
	Tue, 27 Sep 2022 16:37:53 +0200
changeset 19	3d72ae0968f4
parent 18	be944660c56a
child 21	48c4eec2b7e6
permissions	-rw-r--r--