Automattic\WooCommerce\Admin\API
ProductsLowInStock::get_count_query
Generate a count query.
Method of the class: ProductsLowInStock{}
No Hooks.
Returns
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 10.4.3
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',
)
);
}