WC_API_Customers::modify_user_query() │ public │ WC 2.1

Modify the WP_User_Query to support filtering on the date the customer was created

Method of the class: WC_API_Customers{}

No Hooks.

Return

null. Nothing.

Usage

$WC_API_Customers = new WC_API_Customers();
$WC_API_Customers->modify_user_query( $query );

$query(WP_User_Query) (required)

-

Changelog

WC_API_Customers::modify_user_query() WC API Customers::modify user query code ^{WC 7.7.0}

public function modify_user_query( $query ) {

	if ( $this->created_at_min ) {
		$query->query_where .= sprintf( " AND user_registered >= STR_TO_DATE( '%s', '%%Y-%%m-%%d %%h:%%i:%%s' )", esc_sql( $this->created_at_min ) );
	}

	if ( $this->created_at_max ) {
		$query->query_where .= sprintf( " AND user_registered <= STR_TO_DATE( '%s', '%%Y-%%m-%%d %%h:%%i:%%s' )", esc_sql( $this->created_at_max ) );
	}
}