function uc_discounts_get_skus_for_discount_id in Ubercart Discounts (Alternative) 7.2

Get all product SKUs to which a discount ID applies.

Parameters

int $discount_id:

const $grouping:

bool $exclude_all_skus:

Return value

array Array of product SKUs (model_id)

3 calls to uc_discounts_get_skus_for_discount_id()

uc_discounts_admin_discount_copy_form in uc_discounts/uc_discounts.admin.inc

Generates admin form to create a copy of existing discount.

uc_discounts_get_product_ids_for_discount in uc_discounts/uc_discounts.module

Returns product IDs to which a discount applies.

_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 1071

Code

function uc_discounts_get_skus_for_discount_id($discount_id, $grouping, $exclude_all_skus = FALSE) {
  $query = "SELECT sku\n            FROM {uc_discounts_skus}\n            WHERE discount_id = :discount_id\n            AND grouping = :grouping";
  $args = array(
    ':discount_id' => $discount_id,
    ':grouping' => $grouping,
  );
  if ($exclude_all_skus) {
    $query .= ' AND sku <> :sku';
    $args[':sku'] = UC_DISCOUNTS_OPTION_ALL_SKUS;
  }
  $result = db_query($query, $args);
  $ids = array();
  foreach ($result as $row) {
    $ids[] = $row->sku;
  }
  return $ids;
}