function wplister_woocommerce_admin_order_filter_query($query)
{
global $typenow, $wp_query, $wpdb;
if ($typenow == 'shop_order') {
// filter by ebay status
if (!empty($_GET['is_from_ebay'])) {
if ($_GET['is_from_ebay'] == 'yes') {
$account_id = isset($_REQUEST['wple_account_id']) ? $_REQUEST['wple_account_id'] : false;
if ($account_id) {
// find post_ids for all orders for this account
$post_ids = array();
$orders = EbayOrdersModel::getWhere('account_id', $account_id);
foreach ($orders as $order) {
if (!$order->post_id) {
continue;
}
$post_ids[] = $order->post_id;
}
if (empty($post_ids)) {
$post_ids = array('0');
}
$query->query_vars['post__in'] = $post_ids;
} else {
$query->query_vars['meta_query'][] = array('key' => '_ebay_order_id', 'compare' => 'EXISTS');
}
} elseif ($_GET['is_from_ebay'] == 'no') {
$query->query_vars['meta_query'][] = array('key' => '_ebay_order_id', 'compare' => 'NOT EXISTS');
}
}
}
}
