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

0 vote167 views1 answer
Change php version linux nginx
PHP
0 vote161 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
1 vote140 views1 answer
Php add array values with same keys
PHP
0 vote165 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
0 vote169 views1 answer
Final class constants - PHP 8.1
PHP
0 vote157 views2 answers
Check if number is multiple of 3 in php
PHP
3 votes165 views3 answers
Laravel passport create access token
PHP Laravel
0 vote145 views1 answer
Nl2br is not working for database in php
PHP
-4 votes210 views1 answer
Apache/2.4.52 (win64) openssl/1.1.1m php/8.1.2 server at localhost port 80
PHP
-1 vote122 views1 answer
Validate rule if row exist laravel
PHP Laravel