function get_product_ids_for_discount in Ubercart Discounts (Alternative) 6.2

Returns product_ids for discount. Note: this function does not check filter_type so a discount with filter_type other than FILTER_TYPE_PRODUCTS will return no values.

Parameters

$discount_id:

$grouping:

$exclude_all_products:

Return value

array of product ids (nids)

3 calls to get_product_ids_for_discount()

get_product_ids_for_discount_object in uc_discounts/uc_discounts.module

Returns product_ids for discount object. Note: this function correctly returns all products for term-based discounts.

uc_discounts_copy in uc_discounts/uc_discounts.admin.inc

Copy a discount.

_uc_discounts_product_filter_form in uc_discounts/uc_discounts.admin.inc

Helper function that creates a series of dropdowns for selecting a product via product_id, sku, class, term, or author

File

uc_discounts/uc_discounts.module, line 986

Code

function get_product_ids_for_discount($discount_id, $grouping, $exclude_all_products = FALSE) {
  $query = "SELECT product_id FROM {uc_discounts_products} WHERE discount_id = %d AND grouping = %d";
  $args = array(
    $discount_id,
    $grouping,
  );
  if ($exclude_all_products) {
    $query .= ' AND product_id <> %d';
    $args[] = ALL_PRODUCTS;
  }
  $result = db_query($query, $args);
  $ids = array();
  while ($row = db_fetch_array($result)) {
    $ids[] = $row["product_id"];
  }
  return $ids;
}