function uc_coupon_purchase_has_coupon in Ubercart Discount Coupons 7.3

Same name and namespace in other branches

1. 6 uc_coupon_purchase/uc_coupon_purchase.module \uc_coupon_purchase_has_coupon()
2. 7.2 uc_coupon_purchase/uc_coupon_purchase.module \uc_coupon_purchase_has_coupon()

Check whether a given user has purchased any coupon, or the specific supplied coupon.

1 call to uc_coupon_purchase_has_coupon()

uc_coupon_purchase_can_view in uc_coupon_purchase/uc_coupon_purchase.module

Access callback for user/%/coupons.

File

uc_coupon_purchase/uc_coupon_purchase.module, line 117

Code

function uc_coupon_purchase_has_coupon($account, $coupon = NULL) {
  $query = db_select('uc_coupon_purchase_users', 'u')
    ->condition('u.uid', $account->uid);
  $query
    ->addExpression('COUNT(*)');

  // Make sure coupon is valid before looking for it.
  if (!empty($coupon) && !empty($coupon->cid)) {
    $query
      ->condition('u.cid', $coupon->cid, 'AND');
  }
  return $query
    ->execute()
    ->fetchField();
}