PHP _update_post_term_count函数代码示例

/**
 * Function for recounting product terms, ignoring hidden products.
 *
 * @param  array $terms
 * @param  string $taxonomy
 * @param  bool $callback
 * @param  bool $terms_are_term_taxonomy_ids
 */
function _wc_term_recount($terms, $taxonomy, $callback = true, $terms_are_term_taxonomy_ids = true)
{
    global $wpdb;
    // Standard callback
    if ($callback) {
        _update_post_term_count($terms, $taxonomy);
    }
    // Stock query
    if (get_option('woocommerce_hide_out_of_stock_items') == 'yes') {
        $stock_join = "LEFT JOIN {$wpdb->postmeta} AS meta_stock ON posts.ID = meta_stock.post_id";
        $stock_query = "\n\t\tAND meta_stock.meta_key = '_stock_status'\n\t\tAND meta_stock.meta_value = 'instock'\n\t\t";
    } else {
        $stock_query = $stock_join = '';
    }
    // Main query
    $count_query = "\n\t\tSELECT COUNT( DISTINCT posts.ID ) FROM {$wpdb->posts} as posts\n\t\tLEFT JOIN {$wpdb->postmeta} AS meta_visibility ON posts.ID = meta_visibility.post_id\n\t\tLEFT JOIN {$wpdb->term_relationships} AS rel ON posts.ID=rel.object_ID\n\t\tLEFT JOIN {$wpdb->term_taxonomy} AS tax USING( term_taxonomy_id )\n\t\tLEFT JOIN {$wpdb->terms} AS term USING( term_id )\n\t\tLEFT JOIN {$wpdb->postmeta} AS postmeta ON posts.ID = postmeta.post_id\n\t\t{$stock_join}\n\t\tWHERE \tpost_status = 'publish'\n\t\tAND \tpost_type \t= 'product'\n\t\tAND \tmeta_visibility.meta_key = '_visibility'\n\t\tAND \tmeta_visibility.meta_value IN ( 'visible', 'catalog' )\n\t\t{$stock_query}\n\t";
    // Pre-process term taxonomy ids
    if (!$terms_are_term_taxonomy_ids) {
        // We passed in an array of TERMS in format id=>parent
        $terms = array_filter((array) array_keys($terms));
    } else {
        // If we have term taxonomy IDs we need to get the term ID
        $term_taxonomy_ids = $terms;
        $terms = array();
        foreach ($term_taxonomy_ids as $term_taxonomy_id) {
            $term = get_term_by('term_taxonomy_id', $term_taxonomy_id, $taxonomy->name);
            $terms[] = $term->term_id;
        }
    }
    // Exit if we have no terms to count
    if (empty($terms)) {
        return;
    }
    // Ancestors need counting
    if (is_taxonomy_hierarchical($taxonomy->name)) {
        foreach ($terms as $term_id) {
            $terms = array_merge($terms, get_ancestors($term_id, $taxonomy->name));
        }
    }
    // Unique terms only
    $terms = array_unique($terms);
    // Count the terms
    foreach ($terms as $term_id) {
        $terms_to_count = array(absint($term_id));
        if (is_taxonomy_hierarchical($taxonomy->name)) {
            // We need to get the $term's hierarchy so we can count its children too
            if (($children = get_term_children($term_id, $taxonomy->name)) && !is_wp_error($children)) {
                $terms_to_count = array_unique(array_map('absint', array_merge($terms_to_count, $children)));
            }
        }
        // Generate term query
        $term_query = 'AND term_id IN ( ' . implode(',', $terms_to_count) . ' )';
        // Get the count
        $count = $wpdb->get_var($count_query . $term_query);
        // Update the count
        update_woocommerce_term_meta($term_id, 'product_count_' . $taxonomy->name, absint($count));
    }
    delete_transient('wc_term_counts');
}

/**
 * Perform term count update immediately.
 *
 * @since 2.5.0
 *
 * @param array  $terms    The term_taxonomy_id of terms to update.
 * @param string $taxonomy The context of the term.
 * @return true Always true when complete.
 */
function wp_update_term_count_now($terms, $taxonomy)
{
    $terms = array_map('intval', $terms);
    $taxonomy = get_taxonomy($taxonomy);
    if (!empty($taxonomy->update_count_callback)) {
        call_user_func($taxonomy->update_count_callback, $terms, $taxonomy);
    } else {
        $object_types = (array) $taxonomy->object_type;
        foreach ($object_types as &$object_type) {
            if (0 === strpos($object_type, 'attachment:')) {
                list($object_type) = explode(':', $object_type);
            }
        }
        if ($object_types == array_filter($object_types, 'post_type_exists')) {
            // Only post types are attached to this taxonomy
            _update_post_term_count($terms, $taxonomy);
        } else {
            // Default count updater
            _update_generic_term_count($terms, $taxonomy);
        }
    }
    clean_term_cache($terms, '', false);
    return true;
}

/**
 * Function for recounting product terms, ignoring hidden products.
 *
 * @access public
 * @param mixed $term
 * @param mixed $taxonomy
 * @return void
 */
function _woocommerce_term_recount($terms, $taxonomy, $callback = true, $terms_are_term_taxonomy_ids = true)
{
    global $wpdb;
    // Standard callback
    if ($callback) {
        _update_post_term_count($terms, $taxonomy);
    }
    // Stock query
    if (get_option('woocommerce_hide_out_of_stock_items') == 'yes') {
        $stock_join = "LEFT JOIN {$wpdb->postmeta} AS meta_stock ON posts.ID = meta_stock.post_id";
        $stock_query = "\n\t\tAND (\n\t\t\tmeta_stock.meta_key = '_stock_status'\n\t\t\tAND\n\t\t\tmeta_stock.meta_value = 'instock'\n\t\t)";
    } else {
        $stock_query = $stock_join = '';
    }
    // Main query
    $count_query = $wpdb->prepare("\n\t\tSELECT COUNT( DISTINCT posts.ID ) FROM {$wpdb->posts} as posts\n\n\t\tLEFT JOIN {$wpdb->postmeta} AS meta_visibility ON posts.ID = meta_visibility.post_id\n\t\tLEFT JOIN {$wpdb->term_relationships} AS rel ON posts.ID = rel.object_ID\n\t\tLEFT JOIN {$wpdb->term_taxonomy} AS tax USING( term_taxonomy_id )\n\t\tLEFT JOIN {$wpdb->terms} AS term USING( term_id )\n\t\t{$stock_join}\n\n\t\tWHERE \tposts.post_status \t= 'publish'\n\t\tAND \tposts.post_type \t= 'product'\n\t\tAND \t(\n\t\t\tmeta_visibility.meta_key = '_visibility'\n\t\t\tAND\n\t\t\tmeta_visibility.meta_value IN ( 'visible', 'catalog' )\n\t\t)\n\t\tAND \ttax.taxonomy\t= %s\n\t\t{$stock_query}\n\t", $taxonomy->name);
    // Store terms + counts here
    $term_counts = array();
    $counted_terms = array();
    $maybe_count_parents = array();
    // Pre-process term taxonomy ids
    if ($terms_are_term_taxonomy_ids) {
        $term_ids = array();
        foreach ((array) $terms as $term) {
            $the_term = $wpdb->get_row("SELECT term_id, parent FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id = {$term} AND taxonomy = '{$taxonomy->name}'");
            $term_ids[$the_term->term_id] = $the_term->parent;
        }
        $terms = $term_ids;
    }
    // Count those terms!
    foreach ((array) $terms as $term_id => $parent_id) {
        $term_ids = array();
        if (is_taxonomy_hierarchical($taxonomy->name)) {
            // Grab the parents to count later
            $parent = $parent_id;
            while (!empty($parent) && $parent > 0) {
                $maybe_count_parents[] = $parent;
                $parent_term = get_term_by('id', $parent, $taxonomy->name);
                if ($parent_term) {
                    $parent = $parent_term->parent;
                } else {
                    $parent = 0;
                }
            }
            // We need to get the $term's hierarchy so we can count its children too
            $term_ids = get_term_children($term_id, $taxonomy->name);
        }
        $term_ids[] = absint($term_id);
        // Generate term query
        $term_query = 'AND term.term_id IN ( ' . implode(',', $term_ids) . ' )';
        // Get the count
        $count = $wpdb->get_var($count_query . $term_query);
        update_woocommerce_term_meta($term_id, 'product_count_' . $taxonomy->name, absint($count));
        $counted_terms[] = $term_id;
    }
    // Re-count parents
    if (is_taxonomy_hierarchical($taxonomy->name)) {
        $terms = array_diff($maybe_count_parents, $counted_terms);
        foreach ((array) $terms as $term) {
            $term_ids = get_term_children($term, $taxonomy->name);
            $term_ids[] = $term;
            // Generate term query
            $term_query = 'AND term.term_id IN ( ' . implode(',', $term_ids) . ' )';
            // Get the count
            $count = $wpdb->get_var($count_query . $term_query);
            update_woocommerce_term_meta($term, 'product_count_' . $taxonomy->name, absint($count));
        }
    }
}

 public static function status_tools()
 {
     global $wpdb;
     $tools = self::get_tools();
     if (!empty($_GET['action']) && !empty($_REQUEST['_wpnonce']) && wp_verify_nonce($_REQUEST['_wpnonce'], 'debug_action')) {
         switch ($_GET['action']) {
             case 'clear_transients':
                 delete_transient('jigoshop_addons_data');
                 delete_transient('jigoshop_report_coupon_usage');
                 delete_transient('jigoshop_report_customer_list');
                 delete_transient('jigoshop_report_customers');
                 delete_transient('jigoshop_report_low_in_stock');
                 delete_transient('jigoshop_report_most_stocked');
                 delete_transient('jigoshop_report_out_of_stock');
                 delete_transient('jigoshop_report_sales_by_category');
                 delete_transient('jigoshop_report_sales_by_date');
                 delete_transient('jigoshop_report_sales_by_product');
                 delete_transient('jigoshop_widget_cache');
                 $query = new WP_User_Query(array('fields' => 'ids'));
                 $users = $query->get_results();
                 foreach ($users as $user) {
                     delete_transient('jigo_usercart_' . $user);
                 }
                 echo '<div class="updated"><p>' . __('Jigoshop transients cleared', 'jigoshop') . '</p></div>';
                 break;
             case 'clear_expired_transients':
                 // http://w-shadow.com/blog/2012/04/17/delete-stale-transients/
                 $rows = $wpdb->query("\n\t\t\t\t\t\tDELETE\n\t\t\t\t\t\t\ta, b\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t{$wpdb->options} a, {$wpdb->options} b\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\ta.option_name LIKE '_transient_%' AND\n\t\t\t\t\t\t\ta.option_name NOT LIKE '_transient_timeout_%' AND\n\t\t\t\t\t\t\tb.option_name = CONCAT(\n\t\t\t\t\t\t\t\t'_transient_timeout_',\n\t\t\t\t\t\t\t\tSUBSTRING(\n\t\t\t\t\t\t\t\t\ta.option_name,\n\t\t\t\t\t\t\t\t\tCHAR_LENGTH('_transient_') + 1\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tAND b.option_value < UNIX_TIMESTAMP()\n\t\t\t\t\t");
                 $rows2 = $wpdb->query("\n\t\t\t\t\t\tDELETE\n\t\t\t\t\t\t\ta, b\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t{$wpdb->options} a, {$wpdb->options} b\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\ta.option_name LIKE '_site_transient_%' AND\n\t\t\t\t\t\t\ta.option_name NOT LIKE '_site_transient_timeout_%' AND\n\t\t\t\t\t\t\tb.option_name = CONCAT(\n\t\t\t\t\t\t\t\t'_site_transient_timeout_',\n\t\t\t\t\t\t\t\tSUBSTRING(\n\t\t\t\t\t\t\t\t\ta.option_name,\n\t\t\t\t\t\t\t\t\tCHAR_LENGTH('_site_transient_') + 1\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tAND b.option_value < UNIX_TIMESTAMP()\n\t\t\t\t\t");
                 echo '<div class="updated"><p>' . sprintf(__('%d transients rows cleared', 'jigoshop'), $rows + $rows2) . '</p></div>';
                 break;
             case 'reset_roles':
                 // Remove then re-add caps and roles
                 /** @var $wp_roles WP_Roles */
                 global $wp_roles;
                 $capabilities = jigoshop_get_core_capabilities();
                 foreach ($capabilities as $cap_group) {
                     foreach ($cap_group as $cap) {
                         $wp_roles->remove_cap('administrator', $cap);
                         $wp_roles->remove_cap('shop_manager', $cap);
                     }
                 }
                 remove_role('customer');
                 remove_role('shop_manager');
                 // Add roles back
                 jigoshop_roles_init();
                 echo '<div class="updated"><p>' . __('Roles successfully reset', 'jigoshop') . '</p></div>';
                 break;
             case 'recount_terms':
                 $product_cats = get_terms('product_cat', array('hide_empty' => false, 'fields' => 'id=>parent'));
                 _update_post_term_count($product_cats, get_taxonomy('product_cat'));
                 $product_tags = get_terms('product_tag', array('hide_empty' => false, 'fields' => 'id=>parent'));
                 _update_post_term_count($product_tags, get_taxonomy('product_tag'));
                 echo '<div class="updated"><p>' . __('Terms successfully recounted', 'jigoshop') . '</p></div>';
                 break;
             case 'delete_taxes':
                 $options = Jigoshop_Base::get_options();
                 $options->set('jigoshop_tax_rates', '');
                 $options->update_options();
                 echo '<div class="updated"><p>' . __('Tax rates successfully deleted', 'jigoshop') . '</p></div>';
                 break;
             default:
                 $action = esc_attr($_GET['action']);
                 if (isset($tools[$action]['callback'])) {
                     $callback = $tools[$action]['callback'];
                     $return = call_user_func($callback);
                     if ($return === false) {
                         if (is_array($callback)) {
                             echo '<div class="error"><p>' . sprintf(__('There was an error calling %s::%s', 'jigoshop'), get_class($callback[0]), $callback[1]) . '</p></div>';
                         } else {
                             echo '<div class="error"><p>' . sprintf(__('There was an error calling %s', 'jigoshop'), $callback) . '</p></div>';
                         }
                     }
                 }
                 break;
         }
     }
     // Display message if settings settings have been saved
     if (isset($_REQUEST['settings-updated'])) {
         echo '<div class="updated"><p>' . __('Your changes have been saved.', 'jigoshop') . '</p></div>';
     }
     $template = jigoshop_locate_template('admin/status/tools');
     /** @noinspection PhpIncludeInspection */
     include $template;
 }

/**
 * Function for recounting product terms, ignoring hidden products.
 * @param  array $terms
 * @param  string $taxonomy
 * @param  bool $callback
 * @param  bool $terms_are_term_taxonomy_ids
 */
function _wc_term_recount($terms, $taxonomy, $callback = true, $terms_are_term_taxonomy_ids = true)
{
    global $wpdb, $wc_allow_term_recount;
    // Don't recount unless CRUD is calling this.
    if (empty($wc_allow_term_recount)) {
        return;
    }
    // Standard callback
    if ($callback) {
        _update_post_term_count($terms, $taxonomy);
    }
    // Main query
    $count_query = "\n\t\tSELECT COUNT( DISTINCT posts.ID ) FROM {$wpdb->posts} as posts\n\t\tLEFT JOIN {$wpdb->term_relationships} AS rel ON posts.ID=rel.object_ID\n\t\tLEFT JOIN {$wpdb->term_taxonomy} AS tax USING( term_taxonomy_id )\n\t\tWHERE \tpost_status = 'publish'\n\t\tAND \tpost_type \t= 'product'\n\t";
    $product_visibility_term_ids = wc_get_product_visibility_term_ids();
    if ($product_visibility_term_ids['exclude-from-catalog']) {
        $count_query .= " AND term_taxonomy_id !=" . $product_visibility_term_ids['exclude-from-catalog'];
    }
    if ('yes' === get_option('woocommerce_hide_out_of_stock_items') && $product_visibility_term_ids['outofstock']) {
        $count_query .= " AND term_taxonomy_id !=" . $product_visibility_term_ids['outofstock'];
    }
    // Pre-process term taxonomy ids
    if (!$terms_are_term_taxonomy_ids) {
        // We passed in an array of TERMS in format id=>parent
        $terms = array_filter((array) array_keys($terms));
    } else {
        // If we have term taxonomy IDs we need to get the term ID
        $term_taxonomy_ids = $terms;
        $terms = array();
        foreach ($term_taxonomy_ids as $term_taxonomy_id) {
            $term = get_term_by('term_taxonomy_id', $term_taxonomy_id, $taxonomy->name);
            $terms[] = $term->term_id;
        }
    }
    // Exit if we have no terms to count
    if (empty($terms)) {
        return;
    }
    // Ancestors need counting
    if (is_taxonomy_hierarchical($taxonomy->name)) {
        foreach ($terms as $term_id) {
            $terms = array_merge($terms, get_ancestors($term_id, $taxonomy->name));
        }
    }
    // Unique terms only
    $terms = array_unique($terms);
    // Count the terms
    foreach ($terms as $term_id) {
        $terms_to_count = array(absint($term_id));
        if (is_taxonomy_hierarchical($taxonomy->name)) {
            // We need to get the $term's hierarchy so we can count its children too
            if (($children = get_term_children($term_id, $taxonomy->name)) && !is_wp_error($children)) {
                $terms_to_count = array_unique(array_map('absint', array_merge($terms_to_count, $children)));
            }
        }
        // Generate term query
        $term_query = ' AND term_id IN ( ' . implode(',', $terms_to_count) . ' )';
        // Get the count
        $count = $wpdb->get_var($count_query . $term_query);
        // Update the count
        update_woocommerce_term_meta($term_id, 'product_count_' . $taxonomy->name, absint($count));
    }
    delete_transient('wc_term_counts');
}

 /**
  * Term Count Callback that applies custom filter
  * Allows Workflow State counts to include non-published posts
  * @since 1.2.1
  * @param unknown $terms
  * @param unknown $taxonomy
  */
 function term_count_cb($terms, $taxonomy)
 {
     add_filter('query', array(&$this, 'term_count_query_filter'));
     _update_post_term_count($terms, $taxonomy);
     remove_filter('query', array(&$this, 'term_count_query_filter'));
 }