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;
}