If order has product id in array

function get_order_ids_from_bought_items( $product_ids = 0, $customer_id = 0 ) {
    global $wpdb;

    $customer_id = $customer_id == 0 || $customer_id == '' ? get_current_user_id() : $customer_id;
    $statuses    = array_map( 'esc_sql', wc_get_is_paid_statuses() );

    if ( is_array( $product_ids ) )
        $product_ids = implode(',', $product_ids);

    if ( $product_ids !=  ( 0 || '' ) )
        $meta_query_line = "AND woim.meta_value IN ($product_ids)";
    else
        $meta_query_line = "AND woim.meta_value != 0";

    // Get Orders IDs
    $results = $wpdb->get_col( "
        SELECT DISTINCT p.ID FROM {$wpdb->prefix}posts AS p
        INNER JOIN {$wpdb->prefix}postmeta AS pm ON p.ID = pm.post_id
        INNER JOIN {$wpdb->prefix}woocommerce_order_items AS woi ON p.ID = woi.order_id
        INNER JOIN {$wpdb->prefix}woocommerce_order_itemmeta AS woim ON woi.order_item_id = woim.order_item_id
        WHERE p.post_status IN ( 'wc-" . implode( "','wc-", $statuses ) . "' )
        AND pm.meta_key = '_customer_user'
        AND pm.meta_value = $customer_id
        AND woim.meta_key IN ( '_product_id', '_variation_id' )
        $meta_query_line
    " );

    // Return an array of Order IDs or an empty array
    return sizeof($results) > 0 ? $results : array();
}

Source: stackoverflow.com

Similar codes

2 votes167 views2 answers
Get relationship data from soft delete laravel
PHP
22 votes172 views5 answers
Update or insert in laravel
PHP Laravel
57 votes525 views6 answers
How to create migration in laravel
PHP Laravel
0 vote167 views1 answer
How to declare an integer in PHP
PHP
0 vote202 views1 answer
Php script to calculate next 50 days from current date
PHP
5 votes167 views3 answers
PHP Fatal error: Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes)
PHP
6 votes171 views3 answers
Php calculate hours and minutes between two times
PHP
1 vote189 views1 answer
Laravel not finding asset files in public directory
PHP Laravel
0 vote166 views1 answer
Prevent re submit form
PHP
15 votes206 views4 answers
Find in php string or
PHP