woogc/network_orders/get_orders/mysql_query/WHERE
Name: woogc/network_orders/get_orders/mysql_query/WHERE
Type: Filter
Arguments: $mysql_query, $blog_id
The filter can be used to modify the MySQL query used by the Network Orders interface to output the orders from all shops.
The following code example shows only the orders for shop_manager roles, from shops where the user have access :
add_filter ( 'woogc/network_orders/get_orders/mysql_query/WHERE', '_custom_network_orders_mysql_query_WHERE_2', 10, 2 );
function _custom_network_orders_mysql_query_WHERE_2 ( $mysql_query, $blog_id )
{
global $wpdb;
switch_to_blog( $blog_id );
$user = wp_get_current_user();
if ( in_array( 'administrator', (array) $user->roles ) )
return $mysql_query;
if ( in_array( 'shop_manager', (array) $user->roles ) )
return $mysql_query;
$mysql_query .= " AND 1 = 2";
restore_current_blog();
return $mysql_query;
}
The code should be placed inside a php file on wp-content/mu-plugins folder.