From 301275c432501d9709168e69bb685c073fb621de Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Tue, 10 Mar 2020 22:51:04 +0300 Subject: Mail unsubscribe API --- src/main/java/com/juick/service/EmailServiceImpl.java | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'src/main/java/com/juick/service/EmailServiceImpl.java') diff --git a/src/main/java/com/juick/service/EmailServiceImpl.java b/src/main/java/com/juick/service/EmailServiceImpl.java index 6f0cf995..8d053f50 100644 --- a/src/main/java/com/juick/service/EmailServiceImpl.java +++ b/src/main/java/com/juick/service/EmailServiceImpl.java @@ -17,6 +17,7 @@ package com.juick.service; +import com.juick.model.User; import org.apache.commons.lang3.StringUtils; import org.springframework.dao.EmptyResultDataAccessException; import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; @@ -66,6 +67,12 @@ public class EmailServiceImpl extends BaseJdbcService implements EmailService { .addValue("email", account)) > 0; } + @Override + public boolean disableEmail(User user, String account) { + return getJdbcTemplate().update("UPDATE emails SET subscr_hour=NULL " + + "WHERE user_id=? AND email=?", user.getUid(), account) > 0; + } + @Transactional(readOnly = true) @Override public String getNotificationsEmail(Integer userId) { -- cgit v1.2.3