Back to PhocacartCoupon class

Method storeCouponCountUser

public static
storeCouponCountUser
(mixed $couponId, mixed $userId)

Method storeCouponCountUser - Source code

public static function storeCouponCountUser($couponId, $userId)
{
    $idExists = 0;
    if ((int) $couponId > 0 && (int) $userId > 0) {
        $db = Factory::getDBO();
        $query = ' SELECT coupon_id, user_id FROM #__phocacart_coupon_count_user WHERE coupon_id = ' . (int) $couponId . ' AND user_id = ' . (int) $userId . ' ORDER BY coupon_id LIMIT 1';
        $db->setQuery($query);
        $idExists = $db->loadAssoc();
        if (isset($idExists['coupon_id']) && isset($idExists['user_id']) && (int) $idExists['coupon_id'] > 0 && (int) $idExists['user_id'] > 0) {
            $query = 'UPDATE #__phocacart_coupon_count_user SET count = count + 1 WHERE coupon_id = ' . (int) $idExists['coupon_id'] . ' AND user_id = ' . (int) $idExists['user_id'];
            $db->setQuery($query);
            $db->execute();
        } else {
            $valuesString = '(' . (int) $couponId . ', ' . (int) $userId . ', 1)';
            $query = ' INSERT INTO #__phocacart_coupon_count_user (coupon_id, user_id, count) VALUES ' . (string) $valuesString;
            $db->setQuery($query);
            $db->execute();
        }
        return true;
    }
    return false;
}