Question

我有以下几张幻灯片,检查某一物品是否库存,如果是,将物品的地位从公布后改写。我怎样才能在这个问询中排除一个类别? 谢谢!

add_action( admin_init ,  woo_moveoutofstocktodraft );

function woo_moveoutofstocktodraft() {
    $current_user = wp_get_current_user();
    //if loggedin user does not have admin previlage
    if (!user_can($current_user,  administrator )) {
        return;
    }
    $params = [
         posts_per_page  => -1,
         post_type  =>  product ,
         post_status  =>  publish 
    ];
    $wc_query = new WP_Query($params);
    if ($wc_query->have_posts()) :
        while ($wc_query->have_posts()) :
            $wc_query->the_post();
            $product_id = get_the_ID();
            $product = wc_get_product($product_id);
            //if product is Out of Stock move to draft              
  if (!$product->is_in_stock()) {
            $post = array(  ID  => $product_id,  post_status  =>  draft  );
            wp_update_post($post);
            }
        endwhile;
        wp_reset_postdata();
    endif;
}

Answer 1

使用tax_query/a> 页: 1

e.i.

$params = [
     posts_per_page  => -1,
     post_type  =>  product ,
     post_status  =>  publish 
     tax_query  => [
        [
             taxonomy  =>  product_cat ,
             terms      => [1,2,3,4], //IDs of categories
             operator   =>  NOT IN 
        ]
    ],
];

但是,我这样说,占用的资源太大,只是为了做一件简单的事而做大量无用的间接费用。

您的法典如下:

Perform database query to read records on post table
Loop through each record
Another database query (read) for checking stock for each record on meta table (N+1 problem)
Then Another database query (write) for each record meeting specific condition to update a single posts table field.

您最好在一份与元和与经济相关的表格合并的单项原始月度说明中,使用的资源可能比现行做法少99%。

友情链接