protected function _get_term($_term)
{
if (!$_term) {
return false;
}
if ($_term->parent === $this->_parent_term_id) {
return $_term;
}
global $wpdb;
$query = "SELECT t.*, tt.*\n\t\t\t\tFROM {$wpdb->terms} AS t\n\t\t\t\tINNER JOIN {$wpdb->term_taxonomy} AS tt ON t.term_id = tt.term_id\n\t\t\t\tWHERE t.slug = %s\n\t\t\t\tAND tt.taxonomy = %s\n\t\t\t\tAND tt.parent = %d\n\t\t\t\tLIMIT 1";
$query = $wpdb->prepare($query, $this->_args['slug'], $this->_taxonomy, $this->_parent_term_id);
$terms = $wpdb->get_results($query);
if (!$terms) {
$query = "SELECT t.*, tt.*\n\t\t\t\t\tFROM {$wpdb->terms} AS t\n\t\t\t\t\tINNER JOIN {$wpdb->term_taxonomy} AS tt ON t.term_id = tt.term_id\n\t\t\t\t\tWHERE tt.term_id = %d\n\t\t\t\t\tAND tt.taxonomy = %s\n\t\t\t\t\tLIMIT 1";
$query = $wpdb->prepare($query, $this->_term_id, $this->_taxonomy);
$terms = $wpdb->get_results($query);
}
$term = $terms[0];
$term_obj = new WP_Term($term);
$term_obj->filter($term_obj->filter);
return $term_obj;
}
/**
* Retrieve WP_Term instance.
*
* @since 4.4.0
* @access public
* @static
*
* @global wpdb $wpdb WordPress database abstraction object.
*
* @param int $term_id Term ID.
* @param string $taxonomy Optional. Limit matched terms to those matching `$taxonomy`. Only used for
* disambiguating potentially shared terms.
* @return WP_Term|WP_Error|false Term object, if found. WP_Error if `$term_id` is shared between taxonomies and
* there's insufficient data to distinguish which term is intended.
* False for other failures.
*/
public static function get_instance($term_id, $taxonomy = null)
{
global $wpdb;
$term_id = (int) $term_id;
if (!$term_id) {
return false;
}
$_term = wp_cache_get($term_id, 'terms');
// If there isn't a cached version, hit the database.
if (!$_term || $taxonomy && $taxonomy !== $_term->taxonomy) {
// Grab all matching terms, in case any are shared between taxonomies.
$terms = $wpdb->get_results($wpdb->prepare("SELECT t.*, tt.* FROM {$wpdb->terms} AS t INNER JOIN {$wpdb->term_taxonomy} AS tt ON t.term_id = tt.term_id WHERE t.term_id = %d", $term_id));
if (!$terms) {
return false;
}
// If a taxonomy was specified, find a match.
if ($taxonomy) {
foreach ($terms as $match) {
if ($taxonomy === $match->taxonomy) {
$_term = $match;
break;
}
}
// If only one match was found, it's the one we want.
} elseif (1 === count($terms)) {
$_term = reset($terms);
// Otherwise, the term must be shared between taxonomies.
} else {
// If the term is shared only with invalid taxonomies, return the one valid term.
foreach ($terms as $t) {
if (!taxonomy_exists($t->taxonomy)) {
continue;
}
// Only hit if we've already identified a term in a valid taxonomy.
if ($_term) {
return new WP_Error('ambiguous_term_id', __('Term ID is shared between multiple taxonomies'), $term_id);
}
$_term = $t;
}
}
if (!$_term) {
return false;
}
// Don't return terms from invalid taxonomies.
if (!taxonomy_exists($_term->taxonomy)) {
return new WP_Error('invalid_taxonomy', __('Invalid taxonomy'));
}
$_term = sanitize_term($_term, $_term->taxonomy, 'raw');
// Don't cache terms that are shared between taxonomies.
if (1 === count($terms)) {
wp_cache_add($term_id, $_term, 'terms');
}
}
$term_obj = new WP_Term($_term);
$term_obj->filter($term_obj->filter);
return $term_obj;
}
/**
* Retrieve WP_Term instance.
*
* @since 4.4.0
* @access public
* @static
*
* @global wpdb $wpdb WordPress database abstraction object.
*
* @param int $term_id Term ID.
* @return WP_Term|false Term object, false otherwise.
*/
public static function get_instance($term_id)
{
global $wpdb;
$term_id = (int) $term_id;
if (!$term_id) {
return false;
}
$_term = wp_cache_get($term_id, 'terms');
// If there isn't a cached version, hit the database.
if (!$_term) {
$_term = $wpdb->get_row($wpdb->prepare("SELECT t.*, tt.* FROM {$wpdb->terms} AS t INNER JOIN {$wpdb->term_taxonomy} AS tt ON t.term_id = tt.term_id WHERE t.term_id = %d LIMIT 1", $term_id));
if (!$_term) {
return false;
}
$_term = sanitize_term($_term, $_term->taxonomy, 'raw');
wp_cache_add($term_id, $_term, 'terms');
}
$term_obj = new WP_Term($_term);
$term_obj->filter($term_obj->filter);
return $term_obj;
}
