WC_Report_Out_Of_Stock::get_items() public WC 1.0
Get Products matching stock criteria.
{} Это метод класса: WC_Report_Out_Of_Stock{}
Хуки из метода
Возвращает
Null. Ничего.
Использование
$WC_Report_Out_Of_Stock = new WC_Report_Out_Of_Stock(); $WC_Report_Out_Of_Stock->get_items( $current_page, $per_page );
- $current_page(число) (обязательный)
- Current page number.
- $per_page(число) (обязательный)
- How many results to show per page.
Код WC_Report_Out_Of_Stock::get_items() WC Report Out Of Stock::get items WC 4.9.1
public function get_items( $current_page, $per_page ) {
global $wpdb;
$this->max_items = 0;
$this->items = array();
$stock = absint( max( get_option( 'woocommerce_notify_no_stock_amount' ), 0 ) );
$query_from = apply_filters(
'woocommerce_report_out_of_stock_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
)
);
$this->items = $wpdb->get_results( $wpdb->prepare( "SELECT SQL_CALC_FOUND_ROWS posts.ID as id, posts.post_parent as parent {$query_from} ORDER BY posts.post_title DESC LIMIT %d, %d;", ( $current_page - 1 ) * $per_page, $per_page ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
$this->max_items = $wpdb->get_var( 'SELECT FOUND_ROWS();' ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
}