Automattic\WooCommerce\Admin\API
ProductsLowInStock::get_query()
Generate a query.
Method of the class: ProductsLowInStock{}
No Hooks.
Return
String
.
Usage
// protected - for code of main (parent) or child class $result = $this->get_query( $sitewide_only );
- $sitewide_only(true|false)
- generates a query for sitewide low stock threshold only query.
Default: false
ProductsLowInStock::get_query() ProductsLowInStock::get query code WC 9.6.1
protected function get_query( $sitewide_only = false ) { $query = $this->get_base_query( array( ':selects' => 'wp_posts.*, :postmeta_select wc_product_meta_lookup.stock_quantity', ':orderAndLimit' => 'order by wc_product_meta_lookup.product_id DESC limit %d, %d', ) ); if ( ! $sitewide_only ) { return $this->add_sitewide_stock_query_str( $query ); } return strtr( $query, array( ':postmeta_select' => '', ':postmeta_join' => '', ':postmeta_wheres' => 'AND wc_product_meta_lookup.stock_quantity <= %d', ) ); }