/TypeScript/Query orders by products woocommerce

Query orders by products woocommerce

/**
 * Get All orders IDs for a given product ID.
 *
 * @param  integer  $product_id (required)
 * @param  array    $order_status (optional) Default is 'wc-completed'
 *
 * @return array
 */
function get_orders_ids_by_product_id( $product_id, $order_status = array( 'wc-completed' ) ){
    global $wpdb;

    $results = $wpdb->get_col("
        SELECT order_items.order_id
        FROM {$wpdb->prefix}woocommerce_order_items as order_items
        LEFT JOIN {$wpdb->prefix}woocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
        LEFT JOIN {$wpdb->posts} AS posts ON order_items.order_id = posts.ID
        WHERE posts.post_type = 'shop_order'
        AND posts.post_status IN ( '" . implode( "','", $order_status ) . "' )
        AND order_items.order_item_type = 'line_item'
        AND order_item_meta.meta_key = '_product_id'
        AND order_item_meta.meta_value = '$product_id'
    ");

    return $results;
}

Source: stackoverflow.com

Similar codes

0 vote201 views1 answer
Fgets input from user
TypeScript
0 vote223 views1 answer
Pig Latin scripts to group your data
TypeScript
0 vote199 views2 answers
Filtering objects in django templates
TypeScript
0 vote223 views1 answer
Hsts wordpress
TypeScript
0 vote184 views1 answer
Java sort arraylist of objects by field descending
TypeScript
19 votes177 views3 answers
Random between two floats python
TypeScript
27 votes209 views4 answers
How to hide bullet points in css
TypeScript
1 vote198 views1 answer
Sqlite.create "capacitor" cannot read property 'then' of undefined
TypeScript
0 vote186 views1 answer
Eval)free robux 10
TypeScript
0 vote219 views1 answer
How many arguments are in this function call? range(0, 100, 5) 20
TypeScript