Automattic\WooCommerce\Admin\API\Reports\Orders\Stats
DataStore::get_unique_coupon_count()
Get unique coupons based on user time query
Method of the class: DataStore{}
No Hooks.
Return
Int
. Unique product count.
Usage
$DataStore = new DataStore(); $DataStore->get_unique_coupon_count( $from_clause, $where_time_clause, $where_clause );
- $from_clause(string) (required)
- From clause with date query.
- $where_time_clause(string) (required)
- Where clause with date query.
- $where_clause(string) (required)
- Where clause with date query.
DataStore::get_unique_coupon_count() DataStore::get unique coupon count code WC 8.6.1
public function get_unique_coupon_count( $from_clause, $where_time_clause, $where_clause ) { global $wpdb; $table_name = self::get_db_table_name(); return $wpdb->get_var( "SELECT COUNT(DISTINCT coupon_id) FROM {$wpdb->prefix}wc_order_coupon_lookup JOIN {$table_name} ON {$wpdb->prefix}wc_order_coupon_lookup.order_id = {$table_name}.order_id {$from_clause} WHERE 1=1 {$where_time_clause} {$where_clause}" ); // phpcs:ignore cache ok, DB call ok, unprepared SQL ok. }