woocommerce_report_most_stocked_query_from
Использование
add_filter( 'woocommerce_report_most_stocked_query_from', 'wp_kama_woocommerce_report_most_stocked_query_from_filter' );
/**
* Function for `woocommerce_report_most_stocked_query_from` filter-hook.
*
* @param $prepare
*
* @return
*/
function wp_kama_woocommerce_report_most_stocked_query_from_filter( $prepare ){
// filter...
return $prepare;
}
- $prepare
- -
Где вызывается хук
woocommerce_report_most_stocked_query_from
woocommerce/includes/admin/reports/class-wc-report-most-stocked.php 33-46
$query_from = apply_filters(
'woocommerce_report_most_stocked_query_from',
$wpdb->prepare(
"
FROM {$wpdb->posts} as posts
INNER JOIN {$wpdb->wc_product_meta_lookup} AS lookup ON posts.ID = lookup.product_id
WHERE 1=1
AND posts.post_type IN ( 'product', 'product_variation' )
AND posts.post_status = 'publish'
AND lookup.stock_quantity > %d
",
$stock
)
);