PHP _icl_tax_has_objects_recursive函数代码示例

function _icl_tax_has_objects_recursive($id, $term_id = -1, $rec = 0)
{
    // based on the case where two categories were one the parent of another
    // eliminating the chance of infinite loops by letting this function calling itself too many times
    // 100 is the default limit in most of teh php configuration
    //
    // this limit this function to work only with categories nested up to 60 levels
    // should enough for most cases
    if ($rec > 60) {
        return false;
    }
    global $wpdb;
    if ($term_id === -1) {
        $term_id = $wpdb->get_var($wpdb->prepare("SELECT term_id FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id=%d", $id));
    }
    $children = $wpdb->get_results($wpdb->prepare("\n        SELECT term_taxonomy_id, term_id, count FROM {$wpdb->term_taxonomy} WHERE parent = %d\n    ", $term_id));
    $count = 0;
    foreach ($children as $ch) {
        $count += $ch->count;
    }
    if ($count) {
        return true;
    } else {
        foreach ($children as $ch) {
            if (_icl_tax_has_objects_recursive($ch->term_taxonomy_id, $ch->term_id, $rec + 1)) {
                return true;
            }
        }
    }
    return false;
}

 /**
  * @param int    $trid
  * @param string $el_type Use comment, post, page, {custom post time name}, nav_menu, nav_menu_item, category, post_tag, etc. (prefixed with 'post_', 'tax_', or nothing for 'comment')
  * @param bool   $skip_empty
  * @param bool   $all_statuses
  * @param bool   $skip_cache
  *
  * @return array|bool|mixed
  */
 function get_element_translations($trid, $el_type = 'post_post', $skip_empty = false, $all_statuses = false, $skip_cache = false)
 {
     $cache_key_args = array_filter(array($trid, $el_type, $skip_empty, $all_statuses));
     $cache_key = md5(json_encode($cache_key_args));
     $cache_group = 'element_translations';
     $temp_elements = $skip_cache ? false : wp_cache_get($cache_key, $cache_group);
     if ($temp_elements) {
         return $temp_elements;
     }
     global $wpdb;
     $translations = array();
     $sel_add = '';
     $where_add = '';
     if ($trid) {
         if (0 === strpos($el_type, 'post_')) {
             $sel_add = ', p.post_title, p.post_status';
             $join_add = " LEFT JOIN {$wpdb->posts} p ON t.element_id=p.ID";
             $groupby_add = "";
             if (!is_admin() && empty($all_statuses) && $el_type != 'post_attachment') {
                 // the current user may not be the admin but may have read private post/page caps!
                 if (current_user_can('read_private_pages') || current_user_can('read_private_posts')) {
                     $where_add .= " AND (p.post_status = 'publish' OR p.post_status = 'private' OR p.post_status = 'pending')";
                 } else {
                     $where_add .= " AND (";
                     $where_add .= "p.post_status = 'publish' OR p.post_status = 'pending' ";
                     if ($uid = $this->get_current_user()->ID) {
                         $where_add .= " OR (post_status in ('draft', 'private', 'pending') AND  post_author = {$uid})";
                     }
                     $where_add .= ") ";
                 }
             }
         } elseif (preg_match('#^tax_(.+)$#', $el_type)) {
             $sel_add = ', tm.name, tm.term_id, COUNT(tr.object_id) AS instances';
             $join_add = " LEFT JOIN {$wpdb->term_taxonomy} tt ON t.element_id=tt.term_taxonomy_id\r\n\t\t\t\t\t\t\t  LEFT JOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id\r\n\t\t\t\t\t\t\t  LEFT JOIN {$wpdb->term_relationships} tr ON tr.term_taxonomy_id=tt.term_taxonomy_id\r\n\t\t\t\t\t\t\t  ";
             $groupby_add = "GROUP BY tm.term_id";
         }
         $where_add .= " AND t.trid='{$trid}'";
         if (!isset($join_add)) {
             $join_add = "";
         }
         if (!isset($groupby_add)) {
             $groupby_add = "";
         }
         $query = "\r\n\t\t\t\tSELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, NULLIF(t.source_language_code, '') IS NULL AS original {$sel_add}\r\n\t\t\t\tFROM {$wpdb->prefix}icl_translations t\r\n\t\t\t\t\t {$join_add}\r\n\t\t\t\tWHERE 1 {$where_add}\r\n\t\t\t\t{$groupby_add}\r\n\t\t\t";
         $ret = $wpdb->get_results($query);
         foreach ($ret as $t) {
             if (preg_match('#^tax_(.+)$#', $el_type) && $t->instances == 0 && !_icl_tax_has_objects_recursive($t->element_id) && $skip_empty) {
                 continue;
             }
             $cached_object_key = $t->element_id . '#' . $el_type . '#0#' . $t->language_code;
             wp_cache_set($cached_object_key, $cached_object_key, 'icl_object_id');
             $translations[$t->language_code] = $t;
         }
     }
     if ($translations) {
         wp_cache_set($cache_key, $translations, $cache_group);
     }
     return $translations;
 }

 function get_element_translations($trid, $el_type = 'post_post', $skip_empty = false)
 {
     global $wpdb;
     $translations = array();
     $sel_add = '';
     $where_add = '';
     if ($trid) {
         if (0 === strpos($el_type, 'post_')) {
             $sel_add = ', p.post_title, p.post_status';
             $join_add = " LEFT JOIN {$wpdb->posts} p ON t.element_id=p.ID";
             $groupby_add = "";
             if (!is_admin()) {
                 $where_add .= " AND (";
                 $where_add .= "p.post_status = 'publish'";
                 if ($uid = get_current_user_id()) {
                     $where_add .= " OR (post_status in ('draft', 'private') AND  post_author = {$uid})";
                 }
                 $where_add .= ") ";
             }
         } elseif (preg_match('#^tax_(.+)$#', $el_type)) {
             $sel_add = ', tm.name, tm.term_id, COUNT(tr.object_id) AS instances';
             $join_add = " LEFT JOIN {$wpdb->term_taxonomy} tt ON t.element_id=tt.term_taxonomy_id\n                              LEFT JOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id\n                              LEFT JOIN {$wpdb->term_relationships} tr ON tr.term_taxonomy_id=tt.term_taxonomy_id\n                              ";
             $groupby_add = "GROUP BY tm.term_id";
         }
         $where_add .= " AND t.trid='{$trid}'";
         $query = "\n                SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code IS NULL AS original {$sel_add}\n                FROM {$wpdb->prefix}icl_translations t\n                     {$join_add}\n                WHERE 1 {$where_add}\n                {$groupby_add} \n            ";
         $ret = $wpdb->get_results($query);
         foreach ($ret as $t) {
             if (preg_match('#^tax_(.+)$#', $el_type) && $t->instances == 0 && !_icl_tax_has_objects_recursive($t->element_id) && $skip_empty) {
                 continue;
             }
             $translations[$t->language_code] = $t;
         }
     }
     return $translations;
 }

 /**
  * @param stdClass $translation
  *
  * @return bool
  */
 private function must_ignore_translation($translation)
 {
     return $this->wpml_element_type_is_taxonomy($translation->element_type) && $this->skip_empty && $translation->instances === 0 && (!$this->skip_recursions && !_icl_tax_has_objects_recursive($translation->element_id));
 }