Automattic\WooCommerce\Admin\API
ProductsLowInStock::get_base_query()
Return a query string for low in stock products. The query string includes the following replacement strings:
- :selects
- :postmeta_join
- :postmeta_wheres
- :orderAndLimit
Method of the class: ProductsLowInStock{}
No Hooks.
Return
String
.
Usage
// private - for code of main (parent) class only $result = $this->get_base_query( $replacements );
- $replacements(array)
- of replacement strings.
Default: array()
ProductsLowInStock::get_base_query() ProductsLowInStock::get base query code WC 9.6.0
private function get_base_query( $replacements = array() ) { global $wpdb; $query = " SELECT :selects FROM {$wpdb->wc_product_meta_lookup} wc_product_meta_lookup LEFT JOIN {$wpdb->posts} wp_posts ON wp_posts.ID = wc_product_meta_lookup.product_id :postmeta_join WHERE wp_posts.post_type IN ('product', 'product_variation') AND wp_posts.post_status = %s AND wc_product_meta_lookup.stock_quantity IS NOT NULL AND wc_product_meta_lookup.stock_status IN('instock', 'outofstock') :postmeta_wheres :orderAndLimit "; return strtr( $query, $replacements ); }