Name: woogc/network_orders/get_orders/mysql_query/SELECT
Type: Filter
Arguments: $mysql_query, $blog_id
The filter can be used to modify the MySQL query used by the Network Orders interface, that outputs 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/SELECT', '_custom_network_orders_mysql_query_SELECT', 10, 2 );
function _custom_network_orders_mysql_query_SELECT ( $mysql_query, $blog_id )
{
...
View More
Name: woogc/network_orders/get_orders/mysql_query/JOIN
Type: Filter
Arguments: $mysql_query, $blog_id
The filter can be used to modify the MySQL query used by the Network Orders interface, which outputs 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/JOIN', '_custom_network_orders_mysql_query_JOIN', 10, 2 );
function _custom_network_orders_mysql_query_JOIN ( $mysql_query, $blog_id )
{
...
View More
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 )
{
...
View More
Name: woogc/network_orders/get_orders/mysql_query/GROUP_BY
Type: Filter
Arguments: $mysql_query, $blog_id
The filter can be used to modify the MySQL query used by the Network Orders interface, which outputs 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/GROUP_BY', '_custom_network_orders_mysql_query_GROUP_BY', 10, 2 );
function _custom_network_orders_mysql_query_GROUP_BY ( $mysql_query, $blog_id )
{
...
View More