function uc_coupon_purchase_has_coupon in Ubercart Discount Coupons 6

Same name and namespace in other branches

1. 7.3 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 111

Code

function uc_coupon_purchase_has_coupon($account, $coupon = NULL) {
  $sql = 'SELECT COUNT(*) FROM {uc_coupon_purchase_users} WHERE uid = %d';

  // Make sure coupon is valid before looking for it.
  if (!empty($coupon) && !empty($coupon->cid)) {
    $sql .= ' AND cid = %d';
    $coupon = $coupon->cid;
  }
  return db_result(db_query($sql, $account->uid, $coupon));
}