Automattic\WooCommerce\Admin\API
ProductsLowInStock::get_count_query()
Generate a count query.
Method of the class: ProductsLowInStock{}
No Hooks.
Return
String
.
Usage
// protected - for code of main (parent) or child class $result = $this->get_count_query( $sitewide_only );
- $sitewide_only(true|false)
- generates a query for sitewide low stock threshold only query.
Default: false
ProductsLowInStock::get_count_query() ProductsLowInStock::get count query code WC 9.6.0
protected function get_count_query( $sitewide_only = false ) { $query = $this->get_base_query( array( ':selects' => 'count(*) as total', ':orderAndLimit' => '', ) ); 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', ) ); }